*/
include("session.php");
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}
if(isset($_POST['valid']))
{
$_SESSION["popup_suite"] = true;
?>
wash($_GET['what_users'], "no", "", "no"));
$where .= " and (u.LASTNAME like '%".strtolower($what_users)."%'
OR u.LASTNAME like '%".strtoupper($what_users)."%'
OR u.FIRSTNAME like '%".strtolower($what_users)."%'
OR u.FIRSTNAME like '%".strtoupper($what_users)."%'
OR u.USER_ID like '%".strtolower($what_users)."%'
OR u.USER_ID like '%".strtoupper($what_users)."%')";
$orderby = " ORDER BY u.USER_ID asc, u.LASTNAME asc, u.FIRSTNAME asc,s.SERVICE asc";
}
if(isset($_GET['what_services']) && !empty($_GET['what_services']) )
{
$what_services = addslashes($func->wash($_GET['what_services'], "no", "", "no"));
$where .= " and (s.SERVICE like '%".strtolower($what_services)."%' or s.SERVICE like '%".strtoupper($what_services)."%')";
$orderby = " ORDER BY s.SERVICE asc, u.USER_ID asc, u.LASTNAME asc, u.FIRSTNAME asc";
}
if($_SESSION['config']['show_only_elu_in_mailing_list'] == 'true')
$where .= "AND u.ELU = 'Y' ";
if( !isset($_GET['what_users']) && !isset($_GET['what_services']) )
$where = " AND 1=0 ";
$db = new dbquery();
$db->connect();
$db->query("select u.USER_ID, u.FIRSTNAME, u.LASTNAME, u.DEPARTMENT, u.MAIL, s.SERVICE
FROM ".$_SESSION['tablename']['users']." u, ".$_SESSION['tablename']['services']." s
WHERE u.DEPARTMENT = s.ID and STATUS <> 'DEL' AND u.ENABLED = 'Y'".$where.$orderby);
$i=0;
while($line = $db->fetch_object())
{
array_push($users, array("ID" => $line->USER_ID, "PRENOM" => stripslashes($line->FIRSTNAME), "NOM" => stripslashes($line->LASTNAME), "DEP_ID" => $line->DEPARTMENT, "MAIL" => $line->MAIL, "DEP" =>stripslashes($line->SERVICE)));
}
$id = "";
$desc ="";
if(isset($_GET['action']) && $_GET['action'] == "add" )
{
if(isset($_GET['id']) && !empty($_GET['id']))
{
$id = $_GET['id'];
$find = false;
for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']); $i++)
{
if($id == $_SESSION['m_admin']['services']['listmodel'][$i]['USER_ID'])
{
$find = true;
break;
}
}
if( $find == false)
{
$conn = new dbquery();
$conn->connect();
$conn->query("SELECT u.FIRSTNAME, u.LASTNAME, u.DEPARTMENT, u.MAIL, s.SERVICE FROM ".$_SESSION['tablename']['users']." u, ".$_SESSION['tablename']['services']." s WHERE s.ID = u.DEPARTMENT and USER_ID='".$id."'");
$line = $conn->fetch_object();
array_push($_SESSION['m_admin']['services']['listmodel'], array( 'USER_ID' => $id,
'FIRSTNAME' =>stripslashes($line->FIRSTNAME),
'LASTNAME' =>stripslashes($line->LASTNAME),
'DEPARTMENT_ID' =>$line->DEPARTMENT,
'DEPARTMENT' =>stripslashes($line->SERVICE),
'MAIL' =>$line->MAIL,
'SEQUENCE' =>$i+1 ,
));
}
}
}
else if(isset($_GET['action']) && $_GET['action'] == "remove" )
{
$rang = $_GET['rang'];
unset( $_SESSION['m_admin']['services']['listmodel'][$rang] );
$_SESSION['m_admin']['services']['listmodel'] = array_values($_SESSION['m_admin']['services']['listmodel']);
for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']); $i++)
{
$_SESSION['m_admin']['services']['listmodel'][$i]['SEQUENCE'] = $i+1;
}
}
else if(isset($_GET['action']) && $_GET['action'] == "up" )
{
$rang = $_GET['rang'];
$temp = $_SESSION['m_admin']['services']['listmodel'][$rang-1];
$_SESSION['m_admin']['services']['listmodel'][$rang-1] = $_SESSION['m_admin']['services']['listmodel'][$rang];
$_SESSION['m_admin']['services']['listmodel'][$rang] = $temp;
for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']); $i++)
{
$_SESSION['m_admin']['services']['listmodel'][$i]['SEQUENCE'] = $i+1;
}
}
else if(isset($_GET['action']) && $_GET['action'] == "down" )
{
$rang = $_GET['rang'];
$temp = $_SESSION['m_admin']['services']['listmodel'][$rang+1];
$_SESSION['m_admin']['services']['listmodel'][$rang+1] = $_SESSION['m_admin']['services']['listmodel'][$rang];
$_SESSION['m_admin']['services']['listmodel'][$rang] = $temp;
for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']); $i++)
{
$_SESSION['m_admin']['services']['listmodel'][$i]['SEQUENCE'] = $i+1;
}
}
$time = $func->get_session_time_expire();
?>
<?php echo _MANAGE_MODEL_LIST_TITLE;?>
0)
{ ?>
.
.
.