load_lang();
$db = new dbquery();
$db->connect();
$query = "SELECT "
. "is_corporate_person, society, lastname, firstname, phone, email, user_id, contact_id "
. "FROM "
.$_SESSION['tablename']['contacts']
." WHERE "
. "(lower(lastname) like lower('".$db->protect_string_db($_REQUEST['searchValue'])."%') or lower(firstname) like lower('".$db->protect_string_db($_REQUEST['searchValue'])."%') or lower(society) like lower('".$db->protect_string_db($_REQUEST['searchValue'])."%')) AND enabled = 'Y' AND user_id = '" .$_SESSION['user']['UserId']
. "' ORDER BY "
."lastname, society";
$returnId = $db->query($query);
// $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 = $db->fetch_object()) {
if($line->is_corporate_person == "N") {
$return['rechercheContact'] .=
'
';
} else {
$return['rechercheContact'] .=
'
';
}
}
echo json_encode($return);