";
echo "| Re-Nr | Datum | Kunde | UStID | Brutto | Netto | MwSt | ";
$colsp=7;
if ($rechnungen[1]) {
//taxzone = 0
foreach ($rechnungen[1] as $row) { echo "".$row." % | "; $colsp++;};
//taxzone = 2
foreach ($rechnungen[1] as $row) { echo "".$row." % | "; };
}
echo "
|---|
\n";
$f = fopen('tmp/deb.csv','w');
foreach ($rechnungen[0] as $row) {
$transdate = split("-",$row["transdate"]);
$transdate = $transdate[2].".".$transdate[1].".";
$mwst = $row["amount"]- $row["netamount"];
if ($mwst<>0) {
$mwst = sprintf("%0.2f",$mwst) ;
} else {
$mwst = "";
if ($row["taxzone_id"]==1) {
$nettobrutto1 += $row["netamount"];
} else if ($row["taxzone_id"]==2) {
$nettobrutto2 += $row["netamount"];
} else if ($row["taxzone_id"]==3) {
$nettobrutto3 += $row["netamount"];
} else {
$nettobrutto += $row["netamount"];
}
}
if (substr($row["invnumber"],0,6) == "Storno") $row["invnumber"] = substr($row["invnumber"],9)."Sto";
echo sprintf($zeile,$row["id"],$row["invnumber"],$transdate,$row["cid"],$row["name"],$row["ustid"],sprintf("%0.2f",$row["amount"]),sprintf("%0.2f",$row["netamount"]),$mwst);
if ($row["taxzone_id"]==2) { echo " | | "; };
$m1 = 0;
$m2 = '';
foreach ($rechnungen[1] as $rate) {
$tax[$row["taxzone_id"]][$rate]['rate'] += $row[$rate];
$m1 += $row[$rate];
if ($row[$rate]) {
$tax[$row["taxzone_id"]][$rate]['amount'] += $row[$rate]/$rate*100;
echo "".sprintf("%0.2f",$row[$rate])." | ";
$m2 = sprintf("$tz%0.2f",$row[$rate]);
} else {
if ($row["taxzone_id"]==1 or $row["taxzone_id"]==3) $tax[$row["taxzone_id"]][$rate]['amount'] += $row["netamount"];
echo " | ";
}
};
if ($row["taxzone_id"]!=2) { echo " | | "; }
$brutto += $row["amount"];
$netto += $row["netamount"];
echo "$m1 ".round($mwst-$m1,3)." | \n";
$mwstsum += $m1;
$line = sprintf($zeilec,$row["invnumber"],$transdate,$row["name"],$row["ustid"],sprintf("%0.2f",$row["amount"]),sprintf("%0.2f",$row["netamount"]),$mwst,$m2);
fputs($f,$line);
}
echo "
|
";
echo " | | | | ".sprintf("%0.2f",$brutto)." | ".sprintf("%0.2f",$netto)," | ";
echo "".sprintf("%0.2f",($brutto-$netto))." | ";
if ($rechnungen[1]) {
while (list($key,$val) = each($tax[0])) {
echo "".$val['rate']." | ";
}
if ($tax[2]) while (list($key,$val) = each($tax[2])) {
echo "".$val['rate']." | ";
}
}
echo "$mwstsum |
";
echo "
";
echo "";
if ($tax[0]) foreach ($tax[0] as $key=>$mwst) {
echo "| Inland $key%: | ".sprintf("%0.2f",$mwst['amount'])." | ".sprintf("%0.2f",$mwst['rate'])." |
";
};
if ($tax[2]) foreach ($tax[2] as $key=>$mwst) {
echo "| EU ohne UStID $key%: | ".sprintf("%0.2f",$mwst['amount'])." | ".sprintf("%0.2f",$mwst['rate'])." |
";
};
echo "| EU mit UStID : | ".sprintf("%0.2f",$nettobrutto1)." | |
";
echo "| Ausland : | ".sprintf("%0.2f",$nettobrutto3)." | |
";
echo "| Brutto==Netto: (?) | ".$nettobrutto." | |
";
echo "
";
fclose($f);
echo '