<?php session_start(); if(!isset($_SESSION['auth'])) { header("location:index.php"); } require_once("../inc/confNetisse.php"); $DATA = ""; $q = "SELECT id_cr, nom_cr, (SELECT count(d.id_dr) FROM ca_drs d WHERE c.id_cr = d.id_cr) as nbDrs FROM ca_crs c WHERE supp IS NULL ORDER BY nom_cr ASC"; $r = excuteQuery($q); if (!$r['status']) wts_die (var_dump($r['stmt']->errorInfo())); if($r && $r['stmt']->rowCount()>0){ while($o = $r['stmt']->fetch(PDO::FETCH_OBJ)) { $DATA .= "<tr>\r\n<td>".$o->nom_cr."</td>"; $DATA .= "\r\n<td><a href='drList.php?cid=".$o->id_cr."'>GĂ©rer(".$o->nbDrs.")</a></td>"; $DATA .= "\r\n<td><a href='crUpd.php?cid=".$o->id_cr."' >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 CRs</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 CRs </div> <div> <?php if(in_array("add_all_agences",$_SESSION['permissions'])) { ?> <a href='crNew.php' class='formNav2'><i class="fa fa-plus-circle" style="color:#ED1B2F;font-size:150%"></i> <span style="color:#ED1B2F;">Créer une nouvelle CR</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>Directions</td> <td>Actions</td> </tr> </thead> <tbody> <?php echo $DATA; ?> </tbody> </table> <br/> </div> </div> <?php include 'footer.php';?> </body> </html>