. */ /** * @brief List of users for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); $db = new dbquery(); $db->connect(); $listArray = array(); $db->query("select lastname, firstname, user_id from ".$_SESSION['tablename']['users'] ." where lower(lastname) like lower('%".$db->protect_string_db($_REQUEST['what'])."%') and enabled = 'Y' order by lastname, firstname"); while($line = $db->fetch_object()) { array_push($listArray, $db->show_string($line->lastname)." ".$db->show_string($line->firstname)." (user:".$line->user_id.")"); //array_push($listArray, "user : [".$db->show_string($line->lastname)." ".$db->show_string($line->firstname))."]"; } $db->query("select is_corporate_person, society, lastname, firstname, contact_id from ".$_SESSION['tablename']['contacts'] ." where (lower(lastname) like lower('%".$db->protect_string_db($_REQUEST['what'])."%') " //." or lower(firstname) like lower('".$db->protect_string_db($_REQUEST['what'])."%') " ." or lower(society) like lower('%".$db->protect_string_db($_REQUEST['what'])."%')) and enabled = 'Y' order by society, lastname, firstname"); //$db->show(); while($line = $db->fetch_object()) { if($line->is_corporate_person == "Y") { array_push($listArray, $db->show_string($line->society).", ".$db->show_string($line->lastname)." ".$db->show_string($line->firstname)." (contact:".$line->contact_id.")"); } else { array_push($listArray, $db->show_string($line->society).", ".$db->show_string($line->lastname)." ".$db->show_string($line->firstname)." (contact:".$line->contact_id.")"); } } echo "

\n"; $authViewList = 0; foreach($listArray as $what) { if($authViewList >= 30) { $flagAuthView = true; } echo "
• ".$what."
\n"; if(isset($flagAuthView) && $flagAuthView) { echo "
• ...
\n"; break; } $authViewList++; } echo "

";