59 lines
1.6 KiB
PHP
59 lines
1.6 KiB
PHP
<?php
|
|
$data1 = $_POST['data1'];
|
|
$data2 = $_POST['data2'];
|
|
|
|
//PM
|
|
|
|
$connect = mysql_connect("sql.atm.home.pl","atm3","alan87") or die ("Nie mozna polaczyc sie z serwerem");
|
|
$db = mysql_select_db("atm3", $connect) or die ("Nie mozna wybrac nbazy danych");
|
|
$select = "SELECT
|
|
a.nrzlecenia AS W0,a.nrseryjny AS Identyfikator,a.data AS Data,a.miejscowosc as Miasto,a.ulica as Ulica,TIMEDIFF(godzzak,godzroz) as Czas_Naprawy,c.akcja As Akcja,d.bank as Bank,b.nazwisko as Nazwisko,b.imie as Imie FROM raporty a, uzytkownicy b, akcja c, bank d
|
|
WHERE a.id = b.id
|
|
AND a.id_akc = c.id_akc
|
|
AND a.id_ban = d.id_ban
|
|
AND a.usun = '0'
|
|
And c.id_akc = '21'
|
|
and a.dopuszczony='1'
|
|
and a.zrobiony='1'
|
|
and a.przystapiono='1'
|
|
AND a.data >= '".$_POST['data1']."'
|
|
AND a.data <= '".$_POST['data2']."'
|
|
ORDER BY a.data ASC";
|
|
|
|
$export = mysql_query($select);
|
|
$fields = mysql_num_fields($export);
|
|
|
|
|
|
|
|
for ($i = 0; $i < $fields; $i++) {
|
|
$header .= mysql_field_name($export, $i) . "; ";
|
|
}
|
|
|
|
|
|
while($row = mysql_fetch_row($export)) {
|
|
$line = '';
|
|
foreach($row as $value) {
|
|
if (!isset($value)) {
|
|
$value = "\t";
|
|
} else {
|
|
$value = str_replace('"', '', $value);
|
|
$value = $value . '; ';
|
|
}
|
|
$line .= $value;
|
|
}
|
|
$data .= trim($line)."\n";
|
|
}
|
|
$data = str_replace("\r","",$data);
|
|
|
|
if ($data == "") {
|
|
$data = "\nNie okreœlono daty!\n";
|
|
}
|
|
|
|
|
|
header("Content-type: text/csv");
|
|
header("Content-disposition: attachment; filename=PM " . date("Y-m-d").".csv");
|
|
header("Pragma: no-cache");
|
|
|
|
print "$header\n$data";
|
|
|
|
?>
|