0x1998 - MANAGER
Edit File: aj_recapstats.php
<script charset="utf-8"> $(document).ready(function(){ $('#tableFacture').dataTable({ searching: true, "bStateSave": true, "pageLength": 25, "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": "<" }, } }); }); function charge(id,year,quadri,name) { $("#myModalLabel").html("<center>Détail quadrimestre "+quadri+" / "+year+" pour "+name+"</center>"); var loadurl='modal_stats.php?year='+year+'&id='+id+'&quadri='+quadri; var targ="#modal-body"; $.get(loadurl, function(data) { $(targ).html(data); $("#modal").modal('show'); }); } </script> <?php include "config/auth-config.php"; include "config/authcheck.php"; include "config/garde.php"; $annee=isset($_GET['annee']) ? $_GET['annee']:date("Y"); $quadri=isset($_GET['quadri']) ? $_GET['quadri']:1; $requete="select solde_activite.nom, solde_activite.name, sum(Total) as 'Total', sum(`Total P`) as 'Total poste', sum(`Total NC`) as 'Total Hors clinique', sum(Total)-(user_conso.volume*4) as 'Solde', activite_user from solde_activite inner join user_conso on user_conso.id=activite_user where year=".$annee." and quadri=".$quadri." group by activite_user order by nom"; $sql=mysqli_query($link,$requete) or die("erreur"); $_SESSION['requete'] = $requete; $_SESSION['fichier'] = "recap_stats.xls"; $_SESSION['debut']=1; $_SESSION['fin']=5; $_SESSION['onglet']="Q ".$quadri." ".$annee; // on determine les formats pour le fichier XLS for ($i=1;$i<=5;$i++) {$format[$i]=10;} // On passe le paramètre $_SESSION['format']=$format; echo " <table class=\"table table-bordered order-column\" id=\"tableFacture\"> <thead><tr>"; for ($i=1;$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=1;$i<=5;$i++) { echo " <td>"; if ($i==1) echo "<span class=\"hidden\">".$corps[0]."</span><span onclick=\"charge('".$corps['activite_user']."','".$annee."','".$quadri."','".$corps[1]."')\">"; echo $corps[$i]."</span></td>"; } echo " </tr>"; } echo " </tbody></table> <center><a href=\"export_xls.php\" target=\"_blank\" class=\"lienRetour\">Export Excel</a></center>"; ?> <div class="modal fade" id="modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button> <h4 class="modal-title" id="myModalLabel"></h4> </div> <div class="modal-body" id="modal-body"> <center><img src="./config/ajax-bar.gif" /> <br/> Merci de patienter </center> </div> </div> </div> </div>