* @author Loic Vinet */ session_name('LetterBox2'); session_start(); require_once("class_functions.php"); require_once("class_db.php"); if(file_exists($_SESSION['config']['lang'].'.php')) { include($_SESSION['config']['lang'].'.php'); } else { $_SESSION['error'] = "Language file missing...
"; } $func = new functions(); $_SESSION["rediriger"]=false; if($_GET['cancel']) { //$_SESSION["popup_suite"] = true; $_SESSION['diff'] = $_SESSION['liste_originale']; ?> 0) { $user_access = "AND DEPARTMENT IN ("; for($t=0; $twash($_GET['what'], "no", "", "no")); if($_GET['service'] == "true") { if($what <> 'all') { $where = " and (u.DEPARTMENT like '".strtolower($what)."%' or u.DEPARTMENT like '".strtoupper($what)."%') ".$user_access." ORDER BY u.DEPARTMENT asc, u.LASTNAME asc "; } else { $where = ' '.$user_access.' ORDER BY u.DEPARTMENT asc, u.LASTNAME asc'; } } else { if($what <> 'all') { $where = " and (u.LASTNAME like '".strtolower($what)."%' or u.LASTNAME like '".strtoupper($what)."%') ".$user_access." ORDER BY u.LASTNAME asc"; } else { $where = ' '.$user_access.' ORDER BY u.LASTNAME asc'; } } } else { $where = " and( u.LASTNAME like '".strtolower($what)."%' or u.LASTNAME like '".strtoupper($what)."%') ORDER BY u.LASTNAME asc"; } $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' ".$where); //$db->show(); $i=0; while($line = $db->fetch_object()) { array_push($users, array("ID" => $line->USER_ID, "PRENOM" => $line->FIRSTNAME, "NOM" => $line->LASTNAME, "DEP_ID" => $line->DEPARTMENT, "MAIL" => $line->MAIL, "DEP" =>$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['diff']); $i++) { if($id == $_SESSION['diff'][$i]['UserID']) { $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['diff'], array( "UserID" => $id, "FirstName" =>$line->FIRSTNAME, "LastName"=>$line->LASTNAME, "Service_id"=>$line->DEPARTMENT, "Service"=>$line->SERVICE, "Mail"=>$line->MAIL )); } } } else if(isset($_GET['action']) && $_GET['action'] == "remove" ) { $rang = $_GET['rang']; unset( $_SESSION['diff'][$rang] ); $_SESSION['diff'] = array_values($_SESSION['diff']); } else if(isset($_GET['action']) && $_GET['action'] == "up" ) { $rang = $_GET['rang']; $temp = $_SESSION['diff'][$rang]; $_SESSION['diff'][$rang] = $_SESSION['diff'][$rang-1]; $_SESSION['diff'][$rang-1] = $temp; } else if(isset($_GET['action']) && $_GET['action'] == "down" ) { $rang = $_GET['rang']; $temp = $_SESSION['diff'][$rang]; $_SESSION['diff'][$rang] = $_SESSION['diff'][$rang+1]; $_SESSION['diff'][$rang+1] = $temp; } $func = new functions(); $time = $func->get_session_time_expire(); ?> <? echo _UPDATE_DIFFUSION_LIST;?> "._CHOOSE_DEPARTMENT_FIRST.". " . "

"; } else { $link = "popup_diff_view.php"; //print_r($_SESSION['diff']); ?>
:
  exist_user_letter($link, "A", "user"); ?> exist_user_letter($link, "B", "user"); ?> exist_user_letter($link, "C", "user"); ?> exist_user_letter($link, "D", "user"); ?> exist_user_letter($link, "E", "user"); ?> exist_user_letter($link, "F", "user"); ?> exist_user_letter($link, "G", "user"); ?> exist_user_letter($link, "H", "user"); ?> exist_user_letter($link, "I", "user"); ?> exist_user_letter($link, "J", "user"); ?> exist_user_letter($link, "K", "user"); ?> exist_user_letter($link, "L", "user"); ?> exist_user_letter($link, "M", "user"); ?> exist_user_letter($link, "N", "user"); ?> exist_user_letter($link, "O", "user"); ?> exist_user_letter($link, "P", "user"); ?> exist_user_letter($link, "Q", "user"); ?> exist_user_letter($link, "R", "user"); ?> exist_user_letter($link, "S", "user"); ?> exist_user_letter($link, "T", "user"); ?> exist_user_letter($link, "U", "user"); ?> exist_user_letter($link, "V", "user"); ?> exist_user_letter($link, "W", "user"); ?> exist_user_letter($link, "X", "user"); ?> exist_user_letter($link, "Y", "user"); ?> exist_user_letter($link, "Z", "user"); ?> -
:
  exist_user_letter($link, "A", "service"); ?> exist_user_letter($link, "B", "service"); ?> exist_user_letter($link, "C", "service"); ?> exist_user_letter($link, "D", "service"); ?> exist_user_letter($link, "E", "service"); ?> exist_user_letter($link, "F", "service"); ?> exist_user_letter($link, "G", "service"); ?> exist_user_letter($link, "H", "service"); ?> exist_user_letter($link, "I", "service"); ?> exist_user_letter($link, "J", "service"); ?> exist_user_letter($link, "K", "service"); ?> exist_user_letter($link, "L", "service"); ?> exist_user_letter($link, "M", "service"); ?> exist_user_letter($link, "N", "service"); ?> exist_user_letter($link, "O", "service"); ?> exist_user_letter($link, "P", "service"); ?> exist_user_letter($link, "Q", "service"); ?> exist_user_letter($link, "R", "service"); ?> exist_user_letter($link, "S", "service"); ?> exist_user_letter($link, "T", "service"); ?> exist_user_letter($link, "U", "service"); ?> exist_user_letter($link, "V", "service"); ?> exist_user_letter($link, "W", "service"); ?> exist_user_letter($link, "X", "service"); ?> exist_user_letter($link, "Y", "service"); ?> exist_user_letter($link, "Z", "service"); ?> -


0) { ?>

0) { ?>

 
1){?>   

1) { ?>

>
 




>
 









.
.

.

.

.