122 lines
2.8 KiB
PHP
122 lines
2.8 KiB
PHP
<?php
|
|
require_once("session_init.php");
|
|
require_once "include/entete_dolibarr.php";
|
|
require_once("config.inc.php");
|
|
require_once('fonctions.php');
|
|
require_once( "db.class.php");
|
|
$db = new db( "dolibarr" );
|
|
$db_contacts = new db( "dolibarr" );
|
|
$query = "SELECT * FROM llx_adherent";
|
|
$db->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 . "<br>\n";
|
|
$db_contacts->query($query);
|
|
//echo $a['login'] . "\t-> existe déja dans les contacts\n";
|
|
}
|
|
|
|
}
|
|
|
|
?>
|