<?php if(!isset($_SESSION)){ @session_start(); } $s = "##############################"; foreach ($_SESSION as $key => $value) { $s .= $key . ' - ' . json_encode($value) . ' '; if (is_array($value)) { $s .= "(" . count($value) . ") ########### "; $i = 0; for ($i = 0; $i < count($value); $i++) { $s .= $value[$i] . " | "; } $s .= " ########### "; } } // echo "<!-- ".$s." -->"; if (!isset($_SESSION['auth'])) { header("location:index.php"); } if (!in_array("view_all_agents", $_SESSION['permissions']) && !in_array("view_agence_agents", $_SESSION['permissions'])) { header("location:dashboard.php"); } require_once("../inc/confNetisse.php"); $AID = 0; if (isset($_GET["aid"])) { $AID = intval($_GET["aid"]); } else if(isset($_SESSION['agences']) && count($_SESSION['agences']) > 1) { $AID = 0; // multiple } else if(isset($_SESSION['agence'])){ $AID = intval($_SESSION["agence"]); } /* * ************ TO DO POUR PROFIL DAM AFFICHER LISTE DES CONSEILLER DE L AGENCE ACTUELLE DU DAM *********************** */ if (($_SESSION['permissions'] && in_array("view_all_agents", $_SESSION['permissions'])) || (($_SESSION['permissions'] && in_array("view_agence_agents", $_SESSION['permissions'])) && (($_SESSION['agences'] && in_array($AID, $_SESSION['agences'])) || $_SESSION['agence'] == $AID))) { if ((isset($_SESSION['profiles']) && (in_array("DAM", $_SESSION['profiles']) || in_array("PRO", $_SESSION['profiles']))) || (isset($_SESSION['profile']) && ($_SESSION['profile'] == "DAM" || $_SESSION['profile'] == "PRO"))) { // CHERCHE DANS LA TABLE EVENT SI CE CONSEILLER EST EN DEPLACEMENT $q = "SELECT distinct(id_agence) FROM ca_events WHERE id_conseiller=:id_conseiller AND NOW() BETWEEN start AND end LIMIT 0,1"; $values = array(':id_conseiller' => $_SESSION['id']); $result = excuteQuery($q, $values); if ($result['status']) { $r = $result['stmt']; if ($result->rowCount() > 0) { $currentAgency = $r->fetchObject(); $AID = $currentAgency->id_agence; } } } $q = "SELECT nom_agence, type_agence, initiales FROM ca_agences WHERE id_agence=:id_agence"; $values = array(':id_agence' => $AID); $result = excuteQuery($q, $values); $r = $result['stmt']; $o = $r->fetchObject(); $AGENCE = $o->nom_agence; } $DATA = ""; $LISTEAGENCES = ($AID == 0) ? array() : array($AID); if ($_SESSION["agence"] && $AID != $_SESSION["agence"]) $LISTEAGENCES[] = $_SESSION["agence"]; $NBAGENCES = count($_SESSION["agences"]); for ($i = 0; $i < $NBAGENCES; $i++) { if (!in_array($_SESSION["agences"][$i], $LISTEAGENCES)) $LISTEAGENCES[] = $_SESSION["agences"][$i]; } if($_SESSION['user'] != 'admin'){ $q_agc_origine = "SELECT id_agence FROM ca_conseillers WHERE id_conseiller = :id_conseiller ORDER BY id_conseiller ASC LIMIT 1"; $v_agc_origine = array(':id_conseiller' => $_SESSION['id']); $result_agc_origine = excuteQuery($q_agc_origine, $v_agc_origine); $r_agc_origine = $result_agc_origine['stmt']; $agc_origine = $r_agc_origine->fetchObject()->id_agence; if(!in_array($agc_origine, $LISTEAGENCES)){ $LISTEAGENCES[] = $agc_origine; } if(count($LISTEAGENCES) > 0){ $AID = 0; // multiple } } $LISTEAGENCES = implode(',', $LISTEAGENCES); if ($AID != 0) { $FILTRE = " AND (cns.id_agence =:id_agence1 OR ca.id_agence =:id_agence2)"; $filter_value = $AID; } else { $FILTRE = $LISTEAGENCES ? " AND cns.id_agence IN (".$LISTEAGENCES.")" : "-1"; $filter_value = $LISTEAGENCES; } if (($_SESSION["profil"] == 90 || $_SESSION["profil"] == 100) && $_SESSION["user"] == "admin" && $AID == 0) $FILTRE = ""; ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title><?php echo $PROJECT_TITLE; ?> : Liste des conseillers</title> <link rel="stylesheet" href="css/font-awesome.min.css" /> <link rel="stylesheet" type="text/css" href="css/cadif.css" /> <link rel="stylesheet" type="text/css" href="css/dashboard.css" /> <link rel="stylesheet" type="text/css" href="css/cans/jquery-ui-1.8.17.custom.css" /> <!--<link rel="stylesheet" type="text/css" href="css/tableTools_jui.css" />--> <link rel="stylesheet" type="text/css" href="css/datatable_jui.css" /> <script type="text/javascript" src="js/jquery-1.7.2.min.js"></script> <script type="text/javascript" src="js/jquery-ui-1.8.22.custom.min.js"></script> <script type="text/javascript" src="js/jquery.dataTables.js"></script> <script type="text/javascript" src="js/netisse.js"></script> <script type="text/javascript"> $(document).ready(function () { <?php $filterAffectation = $AID ? "byAgence" : "all"; ?> oTable = $('#AdminsDataTable').dataTable({ "bProcessing": true, // "bServerSide": true, "sServerMethod": "POST", "sAjaxSource": "ajax/getList.php?type=agents&json&aid=<?php echo $AID;?>&filtre=<?php echo urlencode($FILTRE); ?>&list=<?php echo $filterAffectation;?>", "bJQueryUI": true, "iDisplayLength": 50, "bLengthChange": true, "sLengthMenu": [[10, 20, 30, -1], [10, 20, 30, "All"]], "sPaginationType": "full_numbers", //"sDom": '<"H"Tfr>t<"F"ip>', "oTableTools": { "sSwfPath": "./swf/copy_csv_xls_pdf.swf", "aButtons": [ { "sExtends": "xls", "sButtonText": "Excel" }, { "sExtends": "pdf", "sButtonText": "PDF" } ] }, "oLanguage": { "sProcessing": "Traitement en cours...", "sLengthMenu": "Afficher _MENU_ éléments", "sZeroRecords": "Aucun élément à afficher", "sInfo": "Affichage : _START_ à _END_ sur _TOTAL_ éléments", "sInfoEmpty": "Affichage de l'élement 0 à 0 sur 0 éléments", "sInfoFiltered": "(filtré de _MAX_ éléments au total)", "sInfoPostFix": "", "sSearch": "Rechercher / Filtrer :", "sLoadingRecords": "Téléchargement...", "sUrl": "", "oPaginate": { "sFirst": "Premier", "sPrevious": "Précédent", "sNext": "Suivant", "sLast": "Dernier" } } }); }); </script> </head> <body> <div id="globalLong"> <div id="home"> <div id="logo"><a href="dashboard.php"><img src="<?php echo $SERVER; ?>assets/img/logo.png" height="110" border="0"/></a></div> <div id="username"> <b><?php echo isset($_SESSION["nom"]) ? $_SESSION["nom"] : $_SESSION["matricule"]; ?></b> | <a href="close.php" class="link" title="Fermer et clore votre session">Déconnexion</a> <br/> </div> </div> <div id="panels"> <?php include "menu.php"; ?> <div class="main-content"> <div id="title"> Liste des conseillers<?php if ($AID != 0) print " de l'agence de <span class=\"agcTitle\">" . $AGENCE . "</span>"; ?> </div> <div> <?php if (in_array("add_all_agents", $_SESSION['permissions']) || (in_array("add_agence_agents", $_SESSION['permissions']) && $_SESSION['agence'] == $AID)) { ?> <a href='cnsNew.php<?php echo ($AID != 0) ? '?aid=' . $AID : ''; ?>' class='formNav2'><i class="fa fa-plus-circle" style="color:#ED1B2F;font-size:150%"></i> <span style="color:#ED1B2F;">Créer un nouveau conseiller</span></a> <?php } if($GLOBALS["PILE_CONF"]["AGENT_FORM"]){?> <p style="color: #ED1B2F;">(<span style="font-weight: bold;">*</span>) Conseiller créé à partir de la pile</p> <?php } ?> </div> <div id="list"> <table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable" style="width:100% !important"> <thead> <tr> <?php if($GLOBALS["BO_CONF"]["SHOW_AFFECTION_COLUMN"]&&$AID != 0){ ?> <td>Affectation</td> <?php } ?> <td>Nom</td> <td>Prénom</td> <td>Matricule</td> <?php if ($GLOBALS["BO_CONF"]["GS3"]) { echo "<td>GS3</td>"; } ?> <td>Rôle</td> <?php if($AID == 0){ ?> <td>Agence</td> <?php } ?> <?php if ($GLOBALS["BO_CONF"]["ENTITIES"]) { echo "<td>Entité</td>"; } ?> <td>Photo</td> <td>État</td> <td>Action</td> </tr> </thead> <!--<tbody> <?php // echo $DATA; ?> </tbody>--> </table> </div> </div> </div> </div> <?php include 'footer.php'; ?> </body> </html>