- // find the next adrid not used
- while ($adrids[$i_adrid] == $new_adrid) {
- $i_adrid++;
- $new_adrid++;
- }
-
- if ($adr['city']) {
-
- $res = $globals->xdb->query(
- "SELECT a2 FROM geoloc_pays
- WHERE pays LIKE {?} OR country LIKE {?}",
- $adr['country'], $adr['country']);
-
- $a2 = $res->fetchOneCell();
- }
- if (!$a2) { $a2 = '00'; }
-
- $globals->xdb->execute(
- "INSERT INTO adresses
- SET uid = {?}, adrid = {?},
- adr1 = {?}, adr2 = {?}, adr3 = {?},
- postcode = {?}, city = {?},
- country = {?},
- datemaj = NOW(),
- pub = 'ax'",
- $userax['uid'], $new_adrid,
- $adr['adr1'], $adr['adr2'], $adr['adr3'],
- $adr['postcode'], $adr['city'],
- $a2);
- // import tels
- if ($adr['tel'])
- $globals->xdb->execute(
- "INSERT INTO adresses
- SET uid = {?}, adrid = {?}, tel = {?},
- telid = 0, tel_type = 'Tel.', tel_pub = 'ax'",
- $userax["uid"], $new_adrid, $adr['tel']);
- if ($adr['fax'])
- $globals->xdb->execute(
- "INSERT INTO adresses
- SET uid = {?}, adrid = {?}, tel = {?},
- telid = 1, tel_type = 'Fax', tel_pub = 'ax'",
- $userax["uid"], $new_adrid, $adr['fax']);
- }
- }
-
- if (is_array($add_pro)) {
-
- $res = $globals->xdb->query(
- "SELECT entrid FROM entreprises
- WHERE uid = {?} AND entrid >= 1 ORDER BY entrid",
- $userax['uid']);
- $entrids = $res->fetchColumn();
- $i_entrid = 0;
- $new_entrid = 1;
-
- $nb_entr = count($entrids);
-
- foreach($add_pro as $entrid) if ($nb_entr < 2) {
-
- $nb_entr++;
-
- $pro = $userax['adr_pro'][$entrid];
-
- // find the next adrid not used
- while ($entrids[$i_entrid] == $new_entrid) {
- $i_entrid++;
- $new_entrid++;
- }
-
- if ($pro['country']) {
- $res = $globals->xdb->query(
- "SELECT a2 FROM geoloc_pays
- WHERE pays LIKE {?} OR country LIKE {?}",
- $pro['country'], $pro['country']);
- $a2 = $res->fetchOneCell();
- }
- if (!$a2) { $a2 = '00'; }
-
- $globals->xdb->execute(
- "INSERT INTO entreprises
- SET uid = {?}, entrid = {?},
- entreprise = {?}, poste = {?},
- adr1 = {?}, adr2 = {?}, adr3 = {?},
- postcode = {?}, city = {?},
- country = {?},
- tel = {?}, fax = {?},
- pub = 'ax', adr_pub = 'ax', tel_pub = 'ax'",
- $userax['uid'], $new_entrid,
- $pro['entreprise'], $pro['fonction'],
- $pro['adr1'], $pro['adr2'], $pro['adr3'],
- $pro['postcode'], $pro['city'],
- $a2,
- $pro['tel'], $pro['fax']);
- }
- }