query($query); while($a = $db->result->fetch_array()) { switch( $a['civility'] ) { case "Monsieur": $civility = "Mr"; break; case "Madame": $civility = "Mme"; break; case "Mademoiselle": $civility = "Mlle"; break; case "Maître": $civility = "Me"; break; case "Docteur": $civility = "Dr"; break; default: $civility =""; break; } $query = "SELECT EXISTS(SELECT 1 FROM llx_socpeople WHERE ref_ext='" . $a['rowid'] . "')"; $db_contacts->query($query); $r= $db_contacts->result->fetch_array(); if( $r[0] == 0) { $query = 'INSERT INTO llx_socpeople(datec, entity, civility, lastname, firstname, address, zip, town,fk_departement, fk_pays, phone, phone_perso, phone_mobile, email, fk_user_creat, fk_user_modif, statut, ref_ext) VALUES ("' . $a['datec'] . '", "' . $a['entity'] . '", "' . $civility . '", "' . $a['lastname'] . '", "' . $a['firstname'] . '", "' . $a['address'] . '", "' . $a['zip'] . '", "' . $a['town'] . '", '; if (empty($a['state_id'])) { $query .= 'NULL,'; }else { $query .= '"' . $a['state_id'] . '", '; } if (empty($a['country'])) { $query .= 'NULL, '; }else { $query .= '"' . $a['country'] . '", "'; } $query .= $a['phone'] . '", "' . $a['phone_perso'] . '", "' . $a['phone_mobile'] . '", "' . $a['email'] . '", "' . $a['fk_user_author'] . '", "' . $a['fk_user_mod'] . '", "1", "' . $a['rowid'] . '")'; echo $query . "\n"; $db_contacts->query($query); echo $a['login'] . "\t-> ajouté aux contacts\n"; }else { $query = 'UPDATE llx_socpeople SET datec="' . $a['datec'] . '", entity="' . $a['entity'] . '", civility="' . $civility . '", lastname="' . $a['lastname'] . '", firstname="' . $a['firstname'] . '", address="' . $a['address'] . '", zip="' . $a['zip'] . '", town="' . $a['town'] . '", fk_departement='; if (empty($a['state_id'])) { $query .= 'NULL,'; }else { $query .= '"' . $a['state_id'] . '", '; } $query .= 'fk_pays='; if (empty($a['country'])) { $query .= 'NULL, "'; }else { $query .= '"' . $a['country'] . '", '; } $query .= ' phone="' . $a['phone'] . '", phone_perso="' . $a['phone_perso'] . '", phone_mobile="' . $a['phone_mobile'] . '", email="' . $a['email'] . '", fk_user_creat="' . $a['fk_user_author'] . '", fk_user_modif="' . $a['fk_user_mod'] . '", statut="1" WHERE ref_ext="' . $a['rowid'] . '"'; echo $query . "
\n"; $db_contacts->query($query); //echo $a['login'] . "\t-> existe déja dans les contacts\n"; } } ?>