Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1 Revision 2
Zeile 38... Zeile 38...
38 
				" . artikelDatabase( $shops_ID ) . ".language=Bestellung.Language
 38 
				" . artikelDatabase( $shops_ID ) . ".language=Bestellung.Language
39 
			where
 39 
			where
40 
				Bestellung.ID = " . $BestellID . "
 40 
				Bestellung.ID = " . $BestellID . "
41 
			and
41 
			and
42 
				artikel_to_Bestellung.Bestellung = Bestellung.ID
 42 
				artikel_to_Bestellung.Bestellung = Bestellung.ID
- 
 
 43 
            and
- 
 
 44 
                artikel_to_Bestellung.status != 'storniert'
43 
			and
 45 
			and
44 
				shops.ID = Bestellung.shops_ID
 46 
				shops.ID = Bestellung.shops_ID
- 
 
 47
45 
			order by
 48 
			order by
46 
				Father desc,
 49 
				Father desc,
47 
				" . artikelDatabase( $shops_ID ) . ".Kennung
 50 
				" . artikelDatabase( $shops_ID ) . ".Kennung
48 
			";
 51 
			";
Zeile 295... Zeile 298...
295 
                $items[] = "<td style='vertical-align:top;'>" . $zeile["Menge"] . "</td><td style='vertical-align:top;'>" . $zeile["kennung"] . "</td><td style='vertical-align:top;'>" . $zeile["kurzbezeichnung"] . " ".$optionen."</td><td style='vertical-align:top;' align='right'>" . number_format( $zeile["Preis_pro_Stueck"],2, ',', '.' ) . " &euro;</td><td style='vertical-align:top;' align='right'>" . number_format( $zeile["Menge"] * $zeile["Preis_pro_Stueck"], 2, ',', '.' ) . " &euro;</td>";
 298 
                $items[] = "<td style='vertical-align:top;'>" . $zeile["Menge"] . "</td><td style='vertical-align:top;'>" . $zeile["kennung"] . "</td><td style='vertical-align:top;'>" . $zeile["kurzbezeichnung"] . " ".$optionen."</td><td style='vertical-align:top;' align='right'>" . number_format( $zeile["Preis_pro_Stueck"],2, ',', '.' ) . " &euro;</td><td style='vertical-align:top;' align='right'>" . number_format( $zeile["Menge"] * $zeile["Preis_pro_Stueck"], 2, ',', '.' ) . " &euro;</td>";
296 
            }
 299 
            }
297 
        }
 300 
        }
298 
        $mwst = 19;
 301 
        $mwst = 19;
299 
        $mwst = $preis / ( 100 + $mwst ) * $mwst;
 302 
        $mwst = $preis / ( 100 + $mwst ) * $mwst;
- 
 
 303
- 
 
 304
300 
        $items[] = "<td style='vertical-align:top;' colspan='4'>Gesamtsumme (Brutto)</td><td style='vertical-align:top;' align='right'>" . number_format( $preis, 2, ',', '.' ) . " &euro;</td>";
 305 
        $items[] = "<td style='vertical-align:top;' colspan='4'>Enthaltene MwSt. (19 %): " . number_format( $mwst, 2, ',', '.' ) . " &euro;</td><td style='vertical-align:top;' align='right'></td>";
301 
        $items[] = "<td style='vertical-align:top;' colspan='4'>Enthaltene MwSt. (19 %):</td><td style='vertical-align:top;' align='right'>" . number_format( $mwst, 2, ',', '.' ) . " &euro;</td>";
 306 
        $items[] = "<td style='vertical-align:top;' colspan='4'>Gesamtsumme (Brutto)</td><td style='text-decoration:underline;vertical-align:top;' align='right'>" . number_format( $preis, 2, ',', '.' ) . " &euro;</td>";
302 
        $text .= "<tr>" . implode( "</tr><tr>", $items ) . "</tr>";
 307 
        $text .= "<tr>" . implode( "</tr><tr>", $items ) . "</tr>";
303 
        /*$text = $text . "\n___________________________________________________________________________\nGesamtsumme (Brutto): " .
 308 
        /*$text = $text . "\n___________________________________________________________________________\nGesamtsumme (Brutto): " .
304 
        str_pad( numberFormat($preis), 48, " ", STR_PAD_LEFT ) . " Euro\nEnthaltene MwSt. (19 %):" .
 309 
        str_pad( numberFormat($preis), 48, " ", STR_PAD_LEFT ) . " Euro\nEnthaltene MwSt. (19 %):" .
305 
        str_pad( numberFormat($mwst), 46, " ", STR_PAD_LEFT ) . " Euro";*/
 310 
        str_pad( numberFormat($mwst), 46, " ", STR_PAD_LEFT ) . " Euro";*/
306 
        $text .= " </table>";
 311 
        $text .= " </table>";