<?php
@session_start();
if(!isset($_SESSION['auth'])) {
header("location:index.php");
}
require_once("../inc/confNetisse.php");
$AID = $EID = 0;
if(isset($_GET["aid"])) {
$AID = intval($_GET["aid"]);
}
if(isset($_GET["eid"])) {
$EID = intval($_GET["eid"]);
}
$FILTER = "";
$agences = array();
if (!in_array("view_all_orientations",$_SESSION['permissions']) ) {
if($_SESSION['agences']){
$agences = array_merge($_SESSION['agences'],array($_SESSION['agence']));
$agences = array_unique($agences);
$FILTER = " AND o.id_agence IN (:id_agence) ";
$values[':id_agence'] = implode(',',$agences);
}
}
$multilang = (isset($GLOBALS["BORNE_CONF"]["LANGUAGES"]) && count($GLOBALS["BORNE_CONF"]["LANGUAGES"])>1) ? true : false;
$DATA = "";
$values = array(':supp' => 0);
$q = "SELECT o.id_orientation, o.id_agence, o.label, a.nom_agence, o.default_msg
FROM ca_orientations o
LEFT JOIN ca_agences a ON a.id_agence = o.id_agence
WHERE a.supp=0 AND o.orientation = 4 AND o.supp = :supp";
if($AID > 0){
$q .= " AND o.id_agence= :id_agence";
$values[':id_agence'] = $AID;
}else{
$q .= $FILTER;
}
$q .= " GROUP BY o.id_orientation";
// print $q;
$result = excuteQuery($q, $values);
$r = $result['stmt'];
$nb = 0;
$nb = $r->rowCount();
while($o = $r->fetchObject()) {
$AGENCE = $o->nom_agence;
$DATA .= '<tr><td>'.$o->label.'</td>';
if(!$AID){
$DATA .= '<td>'.$AGENCE.'</td>';
}
$lnk = "?p=".$o->id_orientation."&aid=".$o->id_agence."&n=".$o->default_msg;
if ($_SESSION['profil'] > 50) {
if($multilang){
$DATA .= "<td>";
foreach($GLOBALS["BORNE_CONF"]["LANGUAGES"] as $lang){
$DATA .= $o->id_lang. "<a href='siteMapUpd.php".$lnk."&lang=".strtolower($lang)."' width='30%' ><img src='/assets/img/icons/borne/langs/".strtolower($lang).".png' alt='".$lang."' title='".$lang."' height='20'/></a> ";
}
$DATA .= "</td>";
}
else if(in_array("edit_all_orientations",$_SESSION['permissions']) || in_array("edit_own_orientations",$_SESSION['permissions'])) {
$DATA .= "<td><a href='siteMapUpd.php".$lnk."' >Editer</a></td>";
}
}
$DATA .= "</tr>";
}
if($nb == 0){
if($AID > 0){
$values = array(':id_agence' => $AID);
$q = "SELECT nom_agence FROM ca_agences WHERE id_agence=:id_agence";
$result = excuteQuery($q, $values);
$r = $result['stmt'];
$nameObj = $r->fetchObject();
$AGENCE = $nameObj->nom_agence;
}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php echo $PROJECT_TITLE;?> : Liste des plans du site</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 plans du site <?php if($AID >0){ echo "de l'agence ".$AGENCE;} ?>
</div>
<div>
<?php
$link = ($AID==0) ? "siteMapNew.php" : 'siteMapNew.php?N=2&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 un nouveau plan</span>
</a><br/><br/>
</div>
<div id="list">
<table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable">
<thead>
<tr>
<td>Titre</td>
<?php if(!$AID) { ?>
<td>Agence</td>
<?php } ?>
<td>Actions</td>
</tr>
</thead>
<tbody>
<?php
echo $DATA;
?>
</tbody>
</table>
<br/>
</div>
</div>
</div>
</div>
<?php include 'footer.php';?>
</body>
</html>