1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| function ExportTOP100($typetop,$plaque)
{
$plaque2=$plaque[0]['territoire'];
if($typetop=="Montant")
{
$requete="SELECT DISTINCT 07_refclient,07_nomclient,07_numfact,07_refcde,07_datecptable,GC_lib,GC_categ,S5N_solde FROM ysdrpt007 ";
$requete.="INNER JOIN solde5N ON S5N_compte=07_refclient and 07_libtypefact='Facture Vte Reseaux' ";
$requete.="INNER JOIN gc ON GC_ac=07_agcom AND GC_territoire='$plaque2' ORDER BY S5N_solde DESC";
}
if($typetop=="Anciennete")
{
$requete="SELECT DISTINCT 07_refclient,07_nomclient,07_numfact,07_refcde,07_datecptable,GC_lib,GC_categ,S5N_solde FROM ysdrpt007 ";
$requete.="INNER JOIN solde5N ON S5N_compte=07_refclient and 07_libtypefact='Facture Vte Reseaux' ";
$requete.="INNER JOIN gc ON GC_ac=07_agcom AND GC_territoire='$plaque2' AND S5N_solde>0 ORDER BY 07_datecptable ASC";
}
$result = mysql_query($requete) or die('Problème de requête Export TOP100liste - impayes.php');
// Entêtes des colones dans le fichier Excel
$excel.="refclient,nomclient,numfact,refcde,date,agenceciale,domaine,solde\n";
//Les resultats de la requette
while($row = mysql_fetch_array($result)) {
$excel.="$row[07_refclient],$row[07_nomclient],$row[07_numfact],$row[07_refcde],$row[07_datecptable],$row[GC_lib],$row[GC_categ],$row[S5N_solde]\n";}header("Content-type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("content-disposition: attachment;filename=test.xls");
print $excel;
exit;
} |
