*/ include("session.php"); 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...
"; } $funct= new functions(); $res_id =$_SESSION['courrier']['res_id']; $func = new functions(); $_SESSION["rediriger"]=false; if($_GET['cancel']) { //$_SESSION["popup_suite"] = true; $_SESSION['diff_copy'] = $_SESSION['liste_originale']; ?> connect(); $conn2 = new dbquery(); $conn2->connect(); $_SESSION['is_diff'] = false; $conn2->query("delete from ".$_SESSION['tablename']['listinstance']." where res_id = ".$res_id." and sequence > 1"); //echo "delete from ".$_SESSION['tablename']['listinstance']." where res_id = ".$res_id." and sequence > 1

"; for($i=0;$iquery("select count(*) as cpt_user from ".$_SESSION['tablename']['listinstance']." where res_id = ".$res_id." and user_id = '".$_SESSION['diff_copy'][$i]['UserID']."'"); $line_user = $conn2->fetch_object(); if($line_user->cpt_user > 0) { //user already exists in the listinstance } else { $conn->query("insert into ".$_SESSION['tablename']['listinstance']." (res_table, res_id, sequence, user_id) values('res_x', '".$res_id."',".$cpt.", '".$_SESSION['diff_copy'][$i]['UserID']."')"); } } ?> 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 ".$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 =""; //print_r($users); if(isset($_GET['action']) && $_GET['action'] == "add" ) { if(isset($_GET['id']) && !empty($_GET['id'])) { $id = $_GET['id']; $find = false; for($i=0;$iconnect(); $conn->query("SELECT u.firstname, u.lastname, u.department, u.mail, s.id 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_copy'], array("UserID" => $id, "FirstName" =>$line->firstname, "LastName"=>$line->lastname, "Service"=>$line->id, "Mail"=>$line->mail )); } } } else if(isset($_GET['action']) && $_GET['action'] == "remove" ) { $rang = $_GET['rang']; unset( $_SESSION['diff_copy'][$rang] ); $_SESSION['diff_copy'] = array_values($_SESSION['diff_copy']); } $func = new functions(); ?> <?php echo $_SESSION['config']['applicationname']; ?> <? echo _CC_LIST;?>
:
  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) { ?> >
 



>