0x1998 - MANAGER
Edit File: aj_listeeig.php
<script> $(document).ready(function(){ $('#tableEIG').dataTable({ searching: true, "columnDefs": [ { "targets": [ 0 ], "visible": true, "searchable": true } ], "order": [[ 0, 'desc' ]], "bStateSave": false, "language": { "search":"Rechercher", "lengthMenu": "Afficher _MENU_ enregistrements par page", "zeroRecords": "Pas de résultat", "info": "page _PAGE_ de _PAGES_", "infoEmpty": "Pas de réponse", "infoFiltered": "(fitré depuis _MAX_ EIG)", "paginate": { "first": "Première", "last": "Dernière", "next": ">", "previous": "<" }, } }); }); </script> <?php include "config/auth-config.php"; include "config/authcheck.php"; include "config/garde.php"; $onglet="Liste EIG au ".date('d-m-y'); $requete="select eig_id as id, DATE_FORMAT(eig_date,'%d/%m%/%Y')as 'DATE DECLARATION', DATE_FORMAT(eig_dateeig,'%d/%m%/%Y')as 'DATE EIG', eig_carmen as 'CARMEN', B.list_title as 'Nature', CASE WHEN (eig_osiris='Y' or eig_osiristtt='Y') THEN 'OUI' WHEN (eig_osiris='N' and eig_osiristtt='N') THEN 'NON' END as 'Osiris', C.list_title as 'Impact', user_type.nom as 'Declarant', CASE WHEN eig_statut='1' THEN 'A traiter' WHEN eig_statut='2' THEN 'En cours' WHEN eig_statut='3' or eig_statut='4' THEN 'Clos' END as 'Statut', eig_statut from eig A inner join user_type on id=eig_user left join list_itemeig B on B.list_code=A.eig_nature left join list_itemeig C on C.list_code=A.eig_impact "; if (!verif_autor($_SESSION['user'],3)) $requete.="where eig_user=".$_SESSION['user']." "; $sql=mysqli_query($link,$requete) or die("erreur"); $_SESSION['requete'] = $requete; $_SESSION['fichier'] = "liste_eig.xls"; $_SESSION['debut']=1; $_SESSION['fin']=8; $_SESSION['onglet']=$onglet; $_SESSION['format']=array ('1'=>'format13','2'=>'format13','3'=>'format13','4'=>'format13','5'=>'format13','6'=>'format13','7'=>'format13','8'=>'format13',); echo " <table class=\"table table-bordered \" id=\"tableEIG\"> <thead><tr>"; for ($i=0;$i<8;$i++) { echo "<th>".strtoupper(mysqli_field_name($sql,$i))."</th>"; } echo " </thead></tr></tbody>"; while ($corps=mysqli_fetch_array($sql)) { if ($corps['eig_statut']==1) $class="danger"; elseif ($corps['eig_statut']==2) $class="warning"; elseif ($corps['eig_statut']==3 or $corps['eig_statut']==4) $class="success"; echo " <tr class=\"".$class."\" ondblclick=\"load('eig','".$corps[0]."')\">"; for ($i=0;$i<8;$i++) { echo " <td>".$corps[$i]."</span></td>"; } echo " </tr>"; } echo " </tbody></table> <center><button class=\"btn btn-primary\" onclick=\"nouveau()\"> Nouvel incident</button> <a href=\"export_xls.php\" target=\"_blank\" class=\"lienRetour\">Export Excel</a> </center>"; ?>