<?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_ &eacute;l&eacute;ments",
                        "sZeroRecords": "Aucun &eacute;l&eacute;ment &agrave; afficher",
                        "sInfo": "Affichage : _START_ &agrave; _END_ sur _TOTAL_ &eacute;l&eacute;ments",
                        "sInfoEmpty": "Affichage de l'&eacute;lement 0 &agrave; 0 sur 0 &eacute;l&eacute;ments",
                        "sInfoFiltered": "(filtr&eacute; de _MAX_ &eacute;l&eacute;ments au total)",
                        "sInfoPostFix": "",
                        "sSearch": "Rechercher&nbsp;/&nbsp;Filtrer&nbsp;:",
                        "sLoadingRecords": "T&#233;l&#233;chargement...",
                        "sUrl": "",
                        "oPaginate": {
                            "sFirst": "Premier",
                            "sPrevious": "Pr&eacute;c&eacute;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> &nbsp; | &nbsp; <a href="close.php" class="link" title="Fermer et clore votre session">D&#233;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&#233;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&#233;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&#233;</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>