<!-- wbcprint:header1 -->
SetFont('Arial','',8)
SetDrawColor(128,128,128)
SetFillColor(255,255,255)
Cell(40,4,'Bestellvorschlag',1,0,'L',0)
Cell(20,4,'{app.datum}',1,0,'L',0)
Cell(20,4,'Seite '.$this->PageNo(),1,0,'L',0)
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
Cell(100,4,'{firma}',1,0,'L',0)
<!-- wbc:end -->
Ln()
Ln()
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(25,5,'Artikel-Nr',1,0,'L',1)
Cell(70,5,'Bezeichnung/Text',1,0,'L',1)
Cell(15,5,'Bestand',1,0,'R',1)
Cell(15,5,'AufMenge',1,0,'R',1)
Cell(15,5,'Vorschlag',1,0,'R',1)
Cell(15,5,'BestMenge',1,0,'R',1)
Cell(25,5,'Lieferant',1,0,'L',1)
Ln()


<!-- wbcprint:header2 -->
SetFont('Arial','',8)
SetDrawColor(128,128,128)
SetFillColor(255,255,255)
Cell(40,4,'Bestellvorschlag',1,0,'L',0)
Cell(20,4,'{app.datum}',1,0,'L',0)
Cell(20,4,'Seite '.$this->PageNo(),1,0,'L',0)
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
Cell(100,4,'{firma}',1,0,'L',0)
<!-- wbc:end -->
Ln()
Ln()
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(25,5,'Artikel-Nr',1,0,'L',1)
Cell(70,5,'Bezeichnung/Text',1,0,'L',1)
Cell(15,5,'Bestand',1,0,'R',1)
Cell(15,5,'AufMenge',1,0,'R',1)
Cell(15,5,'Vorschlag',1,0,'R',1)
Cell(15,5,'BestMenge',1,0,'R',1)
Cell(25,5,'Lieferant',1,0,'L',1)
Ln()


<!-- wbcprint:footer2 -->
SetFillColor(204,204,204)
Cell(140,5,'',1,0,'L',1)

<!-- wbcprint:footer3 -->
SetFillColor(204,204,204)
Cell(95,5,'Anzahl Artikel: '.$this->GetVar("sumitems","int"),1,0,'L',1)
Cell(85,5,'',1,0,'L',1)


<!-- wbcprint:body -->
<!-- wbc:begin table="items as a left join suppliers as b on b.pid=a.pid and b.aktiv>0 left join users as lieferant on lieferant.uid=b.lid" counton="a.pid" select="a.*,(a.lbestand-a.amenge) as vmenge,(a.amenge-a.lbestand-a.bmenge%2Ba.mbestand) as vbmenge,a.parentid as parentvar,b.*,lieferant.username as liefname" where="((a.lager=1 and a.varianten=0 and (a.lbestand-a.amenge%2Ba.bmenge)<a.mbestand) or (a.lager=0 and (a.amenge>a.bmenge)))" group="a.pid" ordernum="1" order="lieferant.username,a.produktid" -->
SetDrawColor(128,128,128)
Cell(25,5,'{a.produktid}',1,0,'L',0)
CellMax(70,5,'<!-- wbcif:begin query="data" var="parentvar" value="0" operator="<" --><!-- wbc:begin table="items" where="pid={parentvar}" maxrows="1" select="bezeichnung" -->{bezeichnung} <!-- wbc:end --><!-- wbcif:end -->{a.bezeichnung}',1,0,'L',0)
Cell(15,5,'{lbestand:num}',1,0,'R',0)
Cell(15,5,'{amenge:num}',1,0,'R',0)
Cell(15,5,'{vbmenge:num}',1,0,'R',0)
Cell(15,5,'{bmenge:num}',1,0,'R',0)
CellMax(25,5,'{liefname}',1,0,'L',0)
SaveVar("sumitems",1,1)
Ln()
<!-- wbc:end -->