load_lang(); $db = new Database(); $query = "SELECT contacts_v2.is_corporate_person, contacts_v2.society, contacts_v2.lastname, contacts_v2.firstname, contact_addresses.phone, contact_addresses.email, contacts_v2.user_id, contacts_v2.contact_id FROM ".APPS_CONTACTS_V2." INNER JOIN ".APPS_CONTACTS_ADDRESSES." ON contacts_v2.contact_id = contact_addresses.contact_id WHERE (lower(contacts_v2.lastname) like lower(?) or lower(contacts_v2.firstname) like lower(?) or lower(contacts_v2.society) like lower(?)) AND contacts_v2.enabled = 'Y' AND contacts_v2.user_id = ? ORDER BY contacts_v2.lastname, contacts_v2.society"; $returnId = $db->query($query,array($_REQUEST['searchValue'].'%',$_REQUEST['searchValue'].'%',$_REQUEST['searchValue'].'%',$_SESSION['user']['UserId'])); // $db->show(); //$returnId = $db->query($query); if (!$returnId) { $return['status'] = 0; $return['msg'] = 'fail'; echo json_encode($return); exit; } $return['status'] = 1; $return['msg'] = 'Recherche effectué'; $return['query'] = $query; $return['searchValue'] = $_REQUEST['searchValue']; while ($line = $returnId->fetchObject()) { if($line->is_corporate_person == "N") { $return['rechercheContact'] .= '
' .functions::xssafe($line->email). ' ' .functions::xssafe($line->phone). '
'; } else { $return['rechercheContact'] .= '
' .functions::xssafe($line->email). ' ' .functions::xssafe($line->phone). '
'; } } echo json_encode($return);