<?php session_start(); if(!isset($_SESSION['auth'])) { header("location:index.php"); } require_once("../inc/confNetisse.php"); $filter = $specificTitle = ""; if(isset($_REQUEST['pid'])){ $filter = " AND g.id_pole=".intval($_REQUEST['pid']); } $DATA = ""; $q = "SELECT g.id_grappe, g.nom_grappe, p.nom_pole,(SELECT count(id_agence) FROM ca_agences WHERE id_parent = g.id_grappe) as nbAgences FROM ca_grappes g LEFT JOIN ca_poles p ON p.id_pole = g.id_pole WHERE g.supp IS NULL".$filter." ORDER BY g.nom_grappe ASC"; // echo $q; $r = excuteQuery($q); if (!$r['status']) wts_die (var_dump($r['stmt']->errorInfo())); while($o = $r['stmt']->fetch(PDO::FETCH_OBJ)) { $DATA .= "<tr>\r\n<td>".$o->nom_grappe."</td>\r\n<td>".$o->nom_pole."</td>\r\n<td><a href='agcList.php?gid=".$o->id_grappe."'>Gérer(".$o->nbAgences.")</a></td>"; $DATA .= "\r\n<td><a href='grappeUpd.php?gid=".$o->id_grappe."' >Editer</a></td>"; if($filter){ $specificTitle = " du pôle : <span class='agcTitle'>".$o->nom_pole."</span>"; } } ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title><?php echo $PROJECT_TITLE;?> : Liste des grappes</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 grappes<?php echo $specificTitle;?> </div> <div> <?php if(in_array("add_all_agences",$_SESSION['permissions'])) { ?> <a href='grappeNew.php' class='formNav2'><i class="fa fa-plus-circle" style="color:#ED1B2F;font-size:150%"></i> <span style="color:#ED1B2F;">Créer une nouvelle grappe</span></a><br/><br/> <?php } ?> </div> <div id="list"> <table cellpadding="0" cellspacing="0" border="0" class="display" id="AdminsDataTable"> <thead> <tr> <td>Nom</td> <td>Pôle</td> <td>Agences</td> <td>Actions</td> </tr> </thead> <tbody> <?php echo $DATA; ?> </tbody> </table> <br/> </div> </div> <?php include 'footer.php';?> </body> </html>