|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 04/2012 |
|
6 * |
|
7 * Export Laserliste als csv-File |
|
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 $sql = "CALL laser_flist($sort,'" . $dir . "',$fnum, '" . $filter . "',$start,$zeil,@anz,@anzpl);"; |
|
29 // echo "sql = $sql<br />"; |
|
30 $result = $dbc ->queryObjectArray($sql); |
|
31 |
|
32 if ($result) |
|
33 { |
|
34 $crlf = array("\r\n","\n\r","\r","\n"); // Zeilenumbrueche |
|
35 $file ="Laser-ID;zu Laser-ID;Bezeichnung;Welle (nm);Art;Typ;Klasse;Schutzst.;Schutzst.-OD;Leistung;Energie;Apertur;Frequenz;Impulsbreite;in Betrieb;Abt.;Verantwortl.;Haus;Raum;Hersteller;Info\r\n"; |
|
36 foreach ($result as $row) |
|
37 { |
|
38 $file .= $row->las_ID . ";"; |
|
39 if ($row->las_ref_ID) |
|
40 $file .= $row->las_ref_ID .": " . $row->ref_bez . ";"; |
|
41 else |
|
42 $file .= ";"; |
|
43 $file .= "" . $row->las_bez . ";"; |
|
44 $file .= "" . str_replace(".",",",str_replace(".00","",$row->las_welle_von))." - ".str_replace(".",",",str_replace(".00","",$row->las_welle_bis)).";"; |
|
45 $file .= "" . $row->las_art_bez . ";"; |
|
46 $file .= "" . $row->las_typ_bez . ";"; |
|
47 $file .= "" . $row->las_klasse_bez . ";"; |
|
48 $file .= "" . $row->schutzst_bez . ";"; |
|
49 $file .= "" . $row->sst_od_bez . ";"; |
|
50 $file .= "" . $row->leistung . " " . $row->eleist . ";"; |
|
51 $file .= "" . $row->energie . " " . $row->eeng . ";"; |
|
52 $file .= "" . $row->apertur . " " . $row->eapt . ";"; |
|
53 $file .= "" . $row->frequenz . " " . $row->efrq . ";"; |
|
54 $file .= "" . $row->impulsbreite . " " . $row->eipb . ";"; |
|
55 $file .= ($row->aktiv) ? "ja;" : "nein;"; |
|
56 $file .= "" . $row->abt_name . ";"; |
|
57 $file .= "" . $row->vma . ";"; |
|
58 $file .= "" . $row->geb_ID . ";"; |
|
59 $file .= " ".$row->raum_nr . ";"; |
|
60 $file .= "" . $row->las_hersteller_bez . ";"; |
|
61 $file .= "" . str_replace($crlf,", ",$row->las_info); |
|
62 // $file .= "\n"; |
|
63 $file .= "\r\n"; |
|
64 } |
|
65 //header ("Content-Type: application/force-download"); |
|
66 header( 'Content-Type: text/csv' ); |
|
67 header('Content-Disposition: attachment; filename="laser.csv"'); |
|
68 header("Content-Length: " . strlen($file)); |
|
69 echo $file; |
|
70 } |
|
71 else echo "kein Ergebnis!"; |
|
72 |
|
73 |
|
74 ?> |