fhiiqm/vertrag_list12_csv.php
changeset 29 72f79dab938e
parent 26 3c1e3ac7089f
equal deleted inserted replaced
28:8d8bce56918f 29:72f79dab938e
    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').";";