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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
| <?php
require_once '../fonctions/connexion.php';
require_once '../fonctions/Formatage.php';
include '../fonctions/DateCsv.php';
if(file_exists("../fichiers/ListChq.txt"))
{
unlink("../fichiers/ListChq.txt");
}
//Création ou modification du fichier
if (isset($_GET['banq'], $_GET['dtd'], $_GET['dtf']) && !empty($_GET['banq']))
{
$bank = $_GET['banq'];
$datdeb = $_GET['dtd'];
$datfin = $_GET['dtf'];
//touch("listcheq.txt");
$filename = "../fichiers/ListChq.txt";
$taille = filesize($filename);
$f = fopen($filename, "w");
if (!($f)) {
echo "Impossible d'ouvrir le fichier !";
} else {
$sql = "SELECT Id_cheque, Num_Compte, NumChq, Beneficiaire, MontRgl, DateChq
FROM prestation
WHERE (Banque = '$bank'
AND DateChq BETWEEN '$datdeb' AND '$datfin'
AND Etat = 'Tiré')";
$req = $DB->query($sql);
$titre = "Chèques ".$bank." du ".$datdeb." au ".$datfin;
fputs($f,$titre);
fputs($f,"\r\n");
while ($d = $req->fetch()) {
fputs($f,Format($d['Num_Compte'], 24)." ");
fputs($f,Format(dateFRW($d['DateChq']), 10)." ");
//echo " ";
fputs($f,Format($d['NumChq'], 8)." ");
//echo " ";
fputs($f,Format($d['Beneficiaire'], 50)." ");
//echo " ";
fputs($f,Format($d['MontRgl'], 10)." ");
//echo " ";
fputs($f,Format("C", 1));
fputs($f,"\r\n");
}
}
}
elseif (isset($_GET['dtd'], $_GET['dtf']) && empty($_GET['banq'])) {
$datdeb = $_GET['dtd'];
$datfin = $_GET['dtf'];
$filename = "../fichiers/ListChq.txt";
$f = fopen($filename, "w");
if (!($f)) {
echo "Impossible d'ouvrir le fichier !";
} else {
$sql = "SELECT Id_cheque, Num_Compte, NumChq, Beneficiaire, MontRgl, DateChq
FROM prestation
WHERE (DateChq BETWEEN '$datdeb' AND '$datfin'
AND Etat = 'Tiré')";
$req = $DB->query($sql);
$titre = "Chèques du " . $datdeb . " au " . $datfin;
fputs($f,$titre);
fputs($f,"\r\n");
while ($d = $req->fetch()) {
fputs($f,Format($d['Num_Compte'], 24)." ");
fputs($f,Format(dateFRW($d['DateChq']), 10)." ");
//echo " ";
fputs($f,Format($d['NumChq'], 8)." ");
//echo " ";
fputs($f,Format($d['Beneficiaire'], 50)." ");
//echo " ";
fputs($f,Format($d['MontRgl'], 10)." ");
//echo " ";
fputs($f,Format("C", 1));
fputs($f,"\r\n");
}
}
}
fclose($f);
// Téléchargement du fichier
if(file_exists($filename)){
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachement; filename="'.basename($filename).'"');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: '.$taille);
readfile($filename);
} |
Partager