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
| <?php
require_once '../fonctions/connexion.php';
require_once '../fonctions/Formatage.php';
include '../fonctions/DateCsv.php';
if (isset($_GET['banq'], $_GET['dtd'], $_GET['dtf']) && !empty($_GET['banq']))
{
$bank = $_GET['banq'];
$datdeb = $_GET['dtd'];
$datfin = $_GET['dtf'];
//touch("listcheq.txt");
$filename = "listcheq.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 (Banque = '$bank'
AND DateChq BETWEEN '$datdeb' AND '$datfin'
AND Etat = 'Tiré')";
$req = $DB->query($sql);
$titre = "Chèques ".$bank." du ".$datdeb." au ".$datfin;
fwrite($f,$titre."<br/>");
//echo "<br/>";
while ($d = $req->fetch()) {
fwrite($f,Format($d['Num_Compte'], 24)." ");
//echo " ";
fwrite($f,Format(dateFRW($d['DateChq']), 10)." ");
//echo " ";
fwrite($f,Format($d['NumChq'], 8)." ");
//echo " ";
fwrite($f,Format($d['Beneficiaire'], 50)." ");
//echo " ";
fwrite($f,Format($d['MontRgl'], 10)." ");
//echo " ";
fwrite($f,Format("C", 1)."<br/>");
//echo "<br/>";
}
}
}
elseif (isset($_GET['dtd'], $_GET['dtf']) && empty($_GET['banq'])) {
$datdeb = $_GET['dtd'];
$datfin = $_GET['dtf'];
touch("operations.txt");
$operation_file = fopen("operation.txt", "w");
if (!($operation_file)) {
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 " . $bank . " du " . $datdeb . " au " . $datfin;
fwrite($f, $titre . "<br/>");
//echo "<br/>";
while ($d = $req->fetch()) {
fwrite($f, Format($d['Num_Compte'], 24) . " ");
//echo " ";
fwrite($f, Format(dateFRW($d['DateChq']), 10) . " ");
//echo " ";
fwrite($f, Format($d['NumChq'], 8) . " ");
//echo " ";
fwrite($f, Format($d['Beneficiaire'], 50) . " ");
//echo " ";
fwrite($f, Format($d['MontRgl'], 10) . " ");
//echo " ";
fwrite($f, Format("C", 1) . "<br/>");
//echo "<br/>";
}
}
}
$fw = fopen($filename, "w");
$taille = filesize($filename);
$contenu = fread($fw,$taille);
echo $contenu; |
Partager