*/
include("session.php");
require_once("class_functions.php");
require_once("class_db.php");
$db = new dbquery();
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing... ";
}
//On efface tout ce qui concerne les emetteurs
unset($_SESSION['new_emet']);
unset($_SESSION['emet_id']);
unset($_SESSION['last_emet_search']);
unset($_SESSION['last_emet_result']);
function search_exp($search)
{
global $db;
if( strlen(trim($search)) < 1 )
return array();
$db->connect();
$db->query("SELECT ID, LASTNAME, FIRSTNAME, SOCIETY FROM ".$_SESSION['tablename']['senders']."
WHERE TOCONTACT = 'EXT'
AND ( LASTNAME LIKE '%".strtolower($search)."%'
OR LASTNAME LIKE '%".strtoupper($search)."%'
OR FIRSTNAME LIKE '%".strtolower($search)."%'
OR FIRSTNAME LIKE '%".strtoupper($search)."%'
OR SOCIETY LIKE '%".strtoupper($search)."%'
OR SOCIETY LIKE '%".strtoupper($search)."%' )
ORDER BY LASTNAME, FIRSTNAME, SOCIETY, ID
LIMIT 0,5");
$return=array();
while($res = $db->fetch_object())
$return[$res->ID] = array("LASTNAME"=>$res->LASTNAME,"FIRSTNAME"=>$res->FIRSTNAME,"SOCIETY"=>$res->SOCIETY);
$db->query("SELECT USER_ID, LASTNAME, FIRSTNAME FROM ".$_SESSION['tablename']['users']."
WHERE ( LASTNAME LIKE '%".strtolower($search)."%'
OR LASTNAME LIKE '%".strtoupper($search)."%'
OR FIRSTNAME LIKE '%".strtolower($search)."%'
OR FIRSTNAME LIKE '%".strtoupper($search)."%' )
ORDER BY LASTNAME, FIRSTNAME, USER_ID
LIMIT 0,5");
while($res = $db->fetch_object())
$return[$res->USER_ID] = array("LASTNAME"=>$res->LASTNAME,"FIRSTNAME"=>$res->FIRSTNAME);
$db->deco();
return $return;
}
//Recherche Ajax
if( isset($_GET['ajax']) )
{
if( isset($_GET['exp_search']) && !empty($_GET['exp_search']) )
{
//On efface l'expediteur
unset($_SESSION['exp_id']);
unset($_SESSION['new_exp']);
//Requete Ajax de recherche
echo "