1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
// Load original field value
if (! empty($id) )
{
$return=array();
$langs->load('companies');
$out='';
$sql = "SELECT st.rowid, st.phone as TiersTel, st.email as TiersMail, stex.s_tel2 as TiersSupTel, stex.s_email2 as TiersSupMail, p.code as country_code ";
$sql.= " FROM llx_societe as st";
$sql.= " LEFT JOIN llx_societe_extrafields as stex on fk_object = st.rowid ";
$sql .= ' LEFT JOIN llx_c_pays as p ON st.fk_pays = p.rowid';
$sql.= " WHERE st.rowid ='".$id."'";
$w= new FormCglSuivi($db);
$resql=$db->query($sql);
if ($resql)
{
$num = $db->num_rows($resql);
$i = 0;
if ($num) {
$objc = $db->fetch_object($resql);
$return['telmail'] = $w->ChercheTelMailTiersContact($objc->TiersTel, $objc->TiersSupTel, $objc->TiersMail, $objc->TiersSupMail, $objc->rowid, $objc->country_code);
}
}
else
{
//dol_print_error($db);
$error = $db->error;
$num = -1;
}
$return['tel'] = $objc->TiersTel;
$return['telfmt'] = $objc->TiersTel;
$return['mail'] = $objc->TiersMail;
$return['suptel'] = $objc->TiersSupTel;
$return['suptelfmt'] = $objc->TiersSupTel;
$return['supmail'] = $objc->TiersSupMail;
$return['num'] = $num;
$return['error'] = $error;
echo json_encode($return);
dol_syslog("ajaxclient retour=".join(',',$return));
} // if
echo json_encode(""); |