|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 04/2012 |
|
6 * |
|
7 * Export der Raumdaten als csv-Datei |
|
8 * |
|
9 */ |
|
10 |
|
11 error_reporting(E_ALL ^ E_NOTICE); |
|
12 |
|
13 include_once($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/dbconnect.inc.php"); |
|
14 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
15 |
|
16 $sort = $_GET["s"]; // Sortierung nach Spalte |
|
17 if (!$sort) $sort = 2; |
|
18 $dir = $_GET["d"]; // Sortierrichtung |
|
19 if (!$dir) $dir = ''; |
|
20 $fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird |
|
21 if (!$fnum) $fnum = 1; |
|
22 $filter = $_GET["b"]; // Filterbegriff |
|
23 if (!$filter) $filter = ''; |
|
24 $start = $_GET["st"]; // Start-DS - 1 |
|
25 if (!$start) $start = 0; |
|
26 $zeil = $_GET["z"]; // Anzahl zu zeigender DS |
|
27 if (!$zeil) $zeil = 9999; |
|
28 |
|
29 $sql = "CALL raum_flist($sort,'" . $dir . "',$fnum, '" . $filter . "',$start,$zeil,@anz);"; |
|
30 |
|
31 $result = $dbc ->queryObjectArray($sql); |
|
32 |
|
33 if ($result) |
|
34 { |
|
35 $crlf = array("\r\n","\n\r","\r","\n"); // Zeilenumbrueche |
|
36 $file ="Raum-ID;Raum-Nr.;Raum-Bez.;Haus;Raum-Typ;Reinig.-Typ;R.-Typ-ID;Reinig.-Kat.;Reinig.-Turn.;R.-Turn.-ID;Boden-Typ;Reinig.-Fl.(m²);Fläche(m²);\r\n"; |
|
37 |
|
38 foreach ($result as $row) |
|
39 { |
|
40 $file .= $row->raum_ID . ";"; |
|
41 $file .= " ".$row->raum_nr . ";"; |
|
42 $file .= $row->raum_name . ";"; |
|
43 $file .= $row->geb_ID . ";"; |
|
44 $file .= $row->raumtyp_bez . ";"; |
|
45 $file .= $row->reinigung_typ_bez . ";"; |
|
46 $file .= $row->reinigung_typ_ID . ";"; |
|
47 $file .= $row->reinigung_kat. ";"; |
|
48 $file .= $row->reinigung_turnus_bez. ";"; |
|
49 $file .= str_replace(".",",",$row->reinigung_turnus_ID). ";"; |
|
50 $file .= $row->boden_typ_bez. ";"; |
|
51 $file .= number_format($row->reinigung_flaeche,2,",","."). ";"; |
|
52 $file .= number_format($row->raum_flaeche,2,",","."). ";"; |
|
53 $file .= "\r\n"; |
|
54 } |
|
55 header( 'Content-Type: text/csv' ); |
|
56 header('Content-Disposition: attachment; filename="raum.csv"'); |
|
57 header("Content-Length: " . strlen($file)); |
|
58 echo $file; |
|
59 } |
|
60 else echo "kein Ergebnis!"; |
|
61 ?> |