<?php
require_once("../inc/confNetisse.php");
session_start();
if(!isset($_SESSION['auth'])) {
header("location:index.php");
}
if(!$GLOBALS["BO_CONF"]["ENTITIES"]){
header("location:agcList.php");
}
$AID = 0;
$values = array(':supp1' => 0, ':supp2' => 0);
if(isset($_GET["aid"])) {
$AID = intval($_GET["aid"]);
$agencyFilter = " AND id_agence=:id_agence";
$values[':id_agence'] = $AID;
}
else{
$agencyJoin = " LEFT JOIN ca_agences a ON a.id_agence = e.id_agence ";
$agencySelect = ", a.nom_agence";
$agenceWhere = " AND a.supp=:supp3";
$values[':supp3'] = 0;
}
$q = "SELECT nom_agence, initiales FROM ca_agences WHERE id_agence=:id_agence";
$v = array(':id_agence' => $AID);
$result = excuteQuery($q, $v);
$r = $result['stmt'];
$o = $r->fetchObject();
$AGENCE = $o->nom_agence;
$DATA = "";
$q = "SELECT e.id_entite, e.id_agence, e.entite, e.libelle, e.enabled".$agencySelect.", (SELECT COUNT(o.id_orientation) FROM ca_orientations o WHERE o.id_entite = e.id_entite AND o.id_agence = e.id_agence AND o.supp=:supp1) AS nbOrientations FROM ca_entites e".$agencyJoin." WHERE e.supp=:supp2 ".$agenceWhere.$agencyFilter;
$result = excuteQuery($q, $values);
$r = $result['stmt'];
while($o = $r->fetchObject()) {
$DATA .= "<tr>\r\n<td>".$o->libelle."</td>\r\n";
$DATA .= ($AID == 0) ? "<td>".$o->nom_agence."</td>\r\n" : "";
$DATA .= '<td>';
$DATA .= ($o->enabled ==1) ? "Actif" : "Inactif";
$DATA .= '<br><img src="img/';
$DATA .= ($o->enabled ==1) ? "green" : "red";
$DATA .= '.gif" width="15" height="15" border="0"></td>';
$DATA .= "\r\n<td><a href='orientationList.php?aid=".$o->id_agence."&eid=".$o->id_entite."'>Gérer (".$o->nbOrientations.")</a></td>";
if ($_SESSION['profil'] > 50) $DATA .= "\r\n<td><a href='entUpd.php?aid=".$o->id_agence."&eid=".$o->id_entite."' >Editer</a></td>";
$DATA .= "\r\n</tr>\r\n";
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php echo $PROJECT_TITLE;?> : Liste des entités</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">
$(document).ready( function () {
oTable = $('#AdminsDataTable').dataTable( {
"bJQueryUI": true,
"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="global">
<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 entités <?php echo ($AID != 0)?"de l'agence de <span class='agcTitle'>".$AGENCE."</span>" : ""; ?>
</div>
<div>
<?php if ((in_array("add_all_agences",$_SESSION['permissions']) || in_array("add_own_agence",$_SESSION['permissions'])) && $GLOBALS["BO_CONF"]["ENTITIES"]) {
$link = ($AID==0) ? "entNew.php" : 'entNew.php?aid='.$AID;
?>
<a href='<?php echo $link ?>' class='formNav2'><i class="fa fa-plus-circle" style="color:#ED1B2F;font-size:150%"></i> <span style="color:#ED1B2F;">Créer une nouvelle entité</span></a><br/><br/>
<?php } ?>
</div>
<div id="list">
<table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable">
<thead>
<tr>
<td>Libellé</td>
<?php echo ($AID==0) ? "<td>Agence</td>": "";?>
<td>Actif</td>
<td>Orientations</td>
<?php if ($_SESSION['profil'] > 50) {?><td>Actions</td><?php } ?>
</tr>
</thead>
<tbody>
<?php
echo $DATA;
?>
</tbody>
</table>
<br/>
</div>
</div>
</div>
</div>
<?php include 'footer.php';?>
</body>
</html>