33 $result = $dbc ->queryObjectArray($sql); |
33 $result = $dbc ->queryObjectArray($sql); |
34 |
34 |
35 if ($result) |
35 if ($result) |
36 { |
36 { |
37 $crlf = array("\r\n","\n\r","\r","\n"); // Zeilenumbrueche |
37 $crlf = array("\r\n","\n\r","\r","\n"); // Zeilenumbrueche |
38 $file ="Vertrag-ID;Bezeichnung;Beschreibung;Typ;zu Produkt;Partner;Bearbeiter;Beginn;Ende;Verlängerung;Künd.Frist(mon);Bemerkung;E-Mail?;Jahr;Kosten\r\n"; |
38 $file ="Vertrag-ID;Partner;Bezeichnung;Beschreibung;Typ;zu Produkt;Bearbeiter;Beginn;Ende;Verlängerung;Künd.Frist(mon);Bemerkung;E-Mail?;Jahr;Kosten\r\n"; |
39 |
39 |
40 foreach ($result as $row) |
40 foreach ($result as $row) |
41 { |
41 { |
42 $file .= $row->contract_ID . ";"; |
42 $file .= $row->contract_ID . ";"; |
|
43 $file .= $row->partfirma . ";"; |
43 $file .= $row->cname . ";"; |
44 $file .= $row->cname . ";"; |
44 $file .= str_replace($crlf,", ",$row->clong) . ";"; |
45 $file .= str_replace($crlf,", ",$row->clong) . ";"; |
45 $file .= $row->typ . ";"; |
46 $file .= $row->typ . ";"; |
46 $file .= str_replace(";",":",$row->prod) . ";"; |
47 $file .= str_replace(";",":",$row->prod) . ";"; |
47 $file .= $row->partfirma . ";"; |
|
48 $file .= str_replace(";",":",$row->bearb) . ";"; |
48 $file .= str_replace(";",":",$row->bearb) . ";"; |
49 if ($row->cbegin) |
49 if ($row->cbegin) |
50 { |
50 { |
51 $cb = new DateTime($row->cbegin); |
51 $cb = new DateTime($row->cbegin); |
52 $file .= $cb->format('d.m.Y').";"; |
52 $file .= $cb->format('d.m.Y').";"; |