"; for ($i=0; $i< min(count($res), 5) ;$i++) { echo "
• ".$req->show_string($res[$i][0]['value'])." ".$req->show_string($res[$i][1]['value'])."
"; } if($i == 0){ $noResultUsers = true; } //CONTACTS $arrayPDO = array(); if ((isset($_REQUEST['contact_type']) && $_REQUEST['contact_type'] <> '') && $_SESSION['is_multi_contact'] =! 'OK') { $contactTypeRequest = " AND contact_type = ?"; $arrayPDOtype = array($_REQUEST['contact_type']); } $Input = $_REQUEST['Input']; $boldInput = strtoupper($Input); $ucwordsInput = ucwords($Input); $Input = $Input . ' ' . $boldInput . ' ' . $ucwordsInput; $args = explode(' ', $Input); $args[] = $Input; $args_bold = array(); foreach ($args as $key => $value) { $args_bold[$key] = ''. $value . ''; } $num_args = count($args); if ($num_args == 0) return "
"; //STEP 1 : search with lastname (physical contact) $query = "SELECT contact_id,ca_id,contact_firstname, contact_lastname, society,address_num,address_street,is_private,CASE WHEN LOWER(translate(contact_lastname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) like LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) THEN contact_lastname END as trust_result FROM view_contacts WHERE is_corporate_person = 'N' AND contact_enabled = 'Y' AND enabled = 'Y' AND (LOWER(translate(contact_lastname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY contact_lastname,contact_firstname ASC"; $arrayPDO = array('%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step1 = $stmt->rowCount(); $m = 30; if ($nb_step1 >= $m) $l = $m; else $l = $nb_step1; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if($res->trust_result){ $count_trust = strlen($res->trust_result); $count_input = strlen($_REQUEST['Input']); $confidence_index = round(($count_input*100)/$count_trust); }else{ $confidence_index = '??'; } if(!empty($res->society)){ $arr_contact_info = array($res->contact_firstname,$res->contact_lastname,'('.$res->society.')'); }else{ $arr_contact_info = array($res->contact_firstname,$res->contact_lastname); } $contact_info = implode(' ', $arr_contact_info); $address = ''; if(!empty($res->address_street) && $res->is_private != 'Y'){ $arr_address = array($res->address_num,$res->address_street,$res->address_postal_code,$res->address_town); $address = implode(' ', $arr_address); }else if($res->is_private == 'Y'){ $address = 'adresse confidentielle'; }else{ $address = 'aucune information sur l\'adresse'; } if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . '' . str_replace($args, $args_bold, $contact_info) . '' . '
  - ' .str_replace($args, $args_bold, $address).'
  ' ."
"; } //STEP 2 : search with lastname(corporate contact) $query = "SELECT contact_id,ca_id,firstname, lastname, society, address_num,address_street,address_postal_code,address_town,is_private,CASE WHEN LOWER(translate(lastname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) like LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) THEN lastname END as trust_result FROM view_contacts WHERE is_corporate_person = 'Y' AND contact_enabled = 'Y' AND enabled = 'Y' AND (LOWER(translate(lastname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY lastname,firstname ASC"; $arrayPDO = array('%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step2 = $stmt->rowCount(); $m = 30; if ($nb_step2 >= $m) $l = $m; else $l = $nb_step2; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); $count_trust = strlen($res->trust_result); $count_input = strlen($_REQUEST['Input']); $confidence_index = round(($count_input*100)/$count_trust); $address = ''; $arr_address = array($res->address_num,$res->address_street,$res->address_postal_code,$res->address_town); $tmp_address = implode(' ', $arr_address); if(!empty($res->firstname) || !empty($res->lastname) ){ $arr_address = array($res->firstname.' '.$res->lastname,$tmp_address); $address = implode(', ', $arr_address); }else{ $address = $tmp_address; } if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . ''. str_replace($args, $args_bold, $res->society) .'' . '
  - ' .str_replace($args, $args_bold, $address).'
  ' ."
"; } //STEP 3 : search with society(physical contact) $query = "SELECT contact_id,ca_id,contact_firstname, contact_lastname, society, address_num,address_street,is_private, CASE WHEN LOWER(translate(society,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) like LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) THEN society END as trust_result FROM view_contacts WHERE is_corporate_person = 'N' AND contact_enabled = 'Y' AND enabled = 'Y' AND (LOWER(translate(society,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) OR LOWER(translate(society_short,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY society,contact_lastname,contact_firstname ASC"; $arrayPDO = array('%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step3 = $stmt->rowCount(); $m = 30; if ($nb_step3 >= $m) $l = $m; else $l = $nb_step3; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if($res->trust_result){ $count_trust = strlen($res->trust_result); $count_input = strlen($_REQUEST['Input']); $confidence_index = round(($count_input*100)/$count_trust); }else{ $confidence_index = '??'; } if(!empty($res->society)){ $arr_contact_info = array($res->contact_firstname,$res->contact_lastname,'('.$res->society.')'); }else{ $arr_contact_info = array($res->contact_firstname,$res->contact_lastname); } $contact_info = implode(' ', $arr_contact_info); $address = ''; if(!empty($res->address_street) && $res->is_private != 'Y'){ $arr_address = array($res->address_num,$res->address_street,$res->address_postal_code,$res->address_town); $address = implode(' ', $arr_address); }else if($res->is_private == 'Y'){ $address = 'adresse confidentielle'; }else{ $address = 'aucune information sur l\'adresse'; } if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . '' . str_replace($args, $args_bold, $contact_info) . '' . '
  - ' .str_replace($args, $args_bold, $address).'
  ' ."
"; } /////////////////////// //STEP 4 : search with society(corporate contact) $query = "SELECT contact_id,ca_id,firstname, lastname, society, address_num,address_street,address_postal_code,address_town,is_private, CASE WHEN LOWER(translate(society,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) like LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) THEN society END as trust_result FROM view_contacts WHERE is_corporate_person = 'Y' AND contact_enabled = 'Y' AND enabled = 'Y' AND (LOWER(translate(society,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) OR LOWER(translate(society_short,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) ORDER BY society,lastname,firstname ASC"; $arrayPDO = array('%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step4 = $stmt->rowCount(); $m = 30; if ($nb_step4 >= $m) $l = $m; else $l = $nb_step4; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if($res->trust_result){ $count_trust = strlen($res->trust_result); $count_input = strlen($_REQUEST['Input']); $confidence_index = round(($count_input*100)/$count_trust); }else{ $confidence_index = '??'; } $address = ''; $arr_address = array($res->address_num,$res->address_street,$res->address_postal_code,$res->address_town); $tmp_address = implode(' ', $arr_address); if(!empty($res->firstname) || !empty($res->lastname) ){ $arr_address = array($res->firstname.' '.$res->lastname,$tmp_address); $address = implode(', ', $arr_address); }else{ $address = $tmp_address; } if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . ''. str_replace($args, $args_bold, $res->society) .'' . '
  - ' .str_replace($args, $args_bold, $address).'
  ' ."
"; } /////////////////////// //STEP 5 : search with other informations (physical contact) $query = "SELECT contact_id,ca_id,contact_firstname, contact_lastname, society, address_num,address_street,address_postal_code,address_town,is_private FROM view_contacts WHERE is_corporate_person = 'N' AND contact_enabled = 'Y' AND enabled = 'Y'" ." AND ((LOWER(translate(contact_firstname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) OR (LOWER(translate(departement,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))))"; $arrayPDO = array('%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step5 = $stmt->rowCount(); $m = 30; if ($nb_step5 >= $m) $l = $m; else $l = $nb_step5; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); if(!empty($res->society)){ $arr_contact_info = array($res->contact_firstname,$res->contact_lastname,'('.$res->society.')'); }else{ $arr_contact_info = array($res->contact_firstname,$res->contact_lastname); } $contact_info = implode(' ', $arr_contact_info); $address = ''; if(!empty($res->address_street) && $res->is_private != 'Y'){ $arr_address = array($res->address_num,$res->address_street,$res->address_postal_code,$res->address_town); $address = implode(' ', $arr_address); }else if($res->is_private == 'Y'){ $address = 'adresse confidentielle'; }else{ $address = 'aucune information sur l\'adresse'; } if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . '' . str_replace($args, $args_bold, $contact_info) . '' . '
  - ' .str_replace($args, $args_bold, $address).'
  ' ."
"; } /////////////////////// //STEP 6 : search with other informations (corporate contact) $query = "SELECT contact_id,ca_id,firstname, lastname, society, address_num,address_street,address_postal_code,address_town,is_private FROM view_contacts WHERE is_corporate_person = 'Y' AND contact_enabled = 'Y' AND enabled = 'Y'" . " AND ((LOWER(translate(firstname,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))) OR (LOWER(translate(departement,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) LIKE LOWER(translate(?,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr'))))"; $arrayPDO = array('%'.$_REQUEST['Input'].'%','%'.$_REQUEST['Input'].'%'); $stmt = $db->query($query, $arrayPDO); $nb_step6 = $stmt->rowCount(); $m = 30; if ($nb_step6 >= $m) $l = $m; else $l = $nb_step6; $found = false; for ($i=0; $i<$l; $i++) { $res = $stmt->fetchObject(); $address = ''; $arr_address = array($res->address_num,$res->address_street,$res->address_postal_code,$res->address_town); $tmp_address = implode(' ', $arr_address); if(!empty($res->firstname) || !empty($res->lastname) ){ $arr_address = array($res->firstname.' '.$res->lastname,$tmp_address); $address = implode(', ', $arr_address); }else{ $address = $tmp_address; } if ($i%2==1) $color = 'LightYellow'; else $color = 'white'; echo "
• " . ''. str_replace($args, $args_bold, $res->society) .'' . '
  - ' .str_replace($args, $args_bold, $address).'
  ' ."
"; } if($nb_step1 == 0 && $nb_step2 == 0 && $nb_step3 == 0 && $nb_step4 == 0 && $nb_step5 == 0 && $nb_step6 == 0) echo "
"; echo "

...".$nb_total." résulats au total

Aucun résultat trouvé.