0x1998 - MANAGER
Edit File: aj_listpers.php
<script> $(document).ready(function(){ $('#tableFacture').dataTable({ searching: true, "bStateSave": true, "bSort":true, "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_ personnels)", "paginate": { "first": "Première", "last": "Dernière", "next": ">", "previous": "<" }, } }); }); </script> <?php include "config/auth-config.php"; include "config/authcheck.php"; include "config/garde.php"; $list=isset($_GET['list']) ? $_GET['list'] :""; $_SESSION['list'] = $list; //if (isset($_GET['list'])) {$list=$_GET['list']; $_SESSION['list'] = $list;} //ON CHERCHE LE NOM DE LA LISTE SOUHAITEE... $sql=mysqli_query($link,"select list_skill_denom from list_skill where list_skill_id=".$list); $result=mysqli_fetch_array($sql); $onglet="Liste ".$result[0]." au ".date('d-m-y'); $requete="select user_id as id,nom, name as 'IDENTITE', email as 'Mail', gsm as 'Tel', APH, presence from ".PREF."users inner join user_skill on user_id=".PREF."users.id inner join user_type on user_type.id=".PREF."users.id where block=0 and user_skill=".$list ." order by nom"; $sql=mysqli_query($link,$requete) or die("erreur"); $_SESSION['requete'] = $requete; $_SESSION['fichier'] = "liste_personnels.xls"; $_SESSION['debut']=2; $_SESSION['fin']=5; $_SESSION['onglet']=$onglet; $_SESSION['format']=array ('1'=>'format8','2'=>'format13','3'=>'format13','4'=>'format8','5'=>'format13'); echo " <table class=\"table table-bordered order-column\" id=\"tableFacture\"> <thead><tr>"; for ($i=2;$i<5;$i++) { echo "<th>".strtoupper(mysqli_field_name($sql,$i))."</th>"; } echo " </thead></tr></tbody>"; while ($corps=mysqli_fetch_array($sql)) { echo " <tr>"; for ($i=2;$i<5;$i++) { echo " <td>"; if ($i==2) echo "<span class=\"hidden\">".$corps[1]."</span>"; echo $corps[$i]."</span></td>"; } echo " </tr>"; } echo " </tbody></table> <center><a href=\"export_xls.php\" target=\"_blank\" class=\"lienRetour\">Export Excel</a></center>"; ?>