<!-- wbcprint:header1 -->
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
<!-- wbcif:begin query="data" var="logo" -->
Image('{app.projects_dir}/{app.project}/{logo}',130,10,40)
<!-- wbcif:end -->
SetFont('Arial','',8)
SetXY(130,30)
Cell(40,4,'{firma}',0,'L')
SetXY(130,34)
MultiCell(40,4,'{anschrift}',0,'L')
SetXY(130,$this->GetY())
MultiCell(40,4,"Telefon: {telefon}\nTelefax: {telefax}\nE-Mail: {email}",0,'L')
<!-- wbc:end -->

<!-- wbc:begin table="sales" select="uid as userid" where="sid={getnum.sid}" -->
<!-- wbc:begin table="users" where="uid={userid}" maxrows="1" -->
SetXY(130,10)
Ln()
Write(4,'{firma}')
<!-- wbcif:begin query="data" var="name" -->
Ln()
Write(4,'<!-- wbc:begin table="properties" where="typ='an' and id='{user.anrede}'" -->{keyname}<!-- wbc:end --> {vorname} {name}')
<!-- wbcif:end -->
Ln()
Write(4,'{strasse}')
Ln()
Write(4,'{plz} {ort}')
<!-- wbc:begin table="properties" where="typ='co' and id='{land}'" -->
Ln()
SetFont('Arial','',6)
Write(4,'{kurzbez}')
SetFont('Arial','',8)
<!-- wbc:end -->

<!-- wbcif:begin query="data" var="zahlbed" value="27" operator="#" -->
SetY(40)
Ln()
SetFont('Arial','',6)
Write(4,'Bankverbindung')
SetFont('Arial','',8)
Ln()
Write(4,'{bank}')
Ln()
Write(4,'{blz}')
Ln()
Write(4,'{kontonr}')
Ln()
Write(4,'{kontoinh}')
<!-- wbcif:end -->

SetDrawColor(128,128,128)
SetFillColor(204,204,204)
SetXY(130,68)
Cell(20,4,'Kunden-Nr',1,0,'L',1)
Cell(40,4,'{knr}',1)
<!-- wbc:end -->

Ln()

<!-- wbc:end -->
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
SetY(75)
SetFont('Arial','',12)
<!-- wbcif:begin query="data" var="gid" value="1,2" operator="?" -->
Write(0,'ANGEBOT {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="3,4" operator="?" -->
Write(0,'AUFTRAG {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="5" operator="#" -->
Write(0,'LIEFERSCHEIN {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="6" operator="#" -->
Write(0,'RECHNUNG {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="7" operator="#" -->
Write(0,'GUTSCHRIFT {prefix}{lfdnr}')
<!-- wbcif:end -->
SetFont('Arial','',8)
SetY(80)
<!-- wbc:begin table="properties" where="typ='za' and id='{zahlbed}'" -->
Ln()
Write(4,'Zahlungsart: {kurzbez}')
<!-- wbc:end -->
<!-- wbc:begin table="properties" where="typ='va' and id='{versandart}'" -->
Ln()
Write(4,'Versandart: {kurzbez}')
<!-- wbc:end -->
Ln()
MultiCell(125,4,"{statustext}",0,'L')
SetXY(130,60)
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(20,4,'Datum',1,0,'L',1)
Cell(40,4,'{cdatum:datum}',1)
SetXY(130,64)
Cell(20,4,'Seite',1,0,'L',1)
Cell(40,4,$this->PageNo(),1)
<!-- wbcif:begin query="data" var="gid" value="3,4" operator="?" -->
SetXY(130,72)
Cell(20,4,'Info',1,0,'L',1)
MultiCell(40,4,"{notiz}",1,'L')
<!-- wbcif:end -->
Ln()
SetY(95)
SetDrawColor(128,128,128)
Rect($this->GetX(),100,183,160)
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(8,5,'Pos',1,0,'L',1)
Cell(95,5,'Artikel-Nr/Bezeichnung/Text',1,0,'L',1)
Cell(20,5,'Menge',1,0,'C',1)
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(15,5,'Preis {app.format_wrg}',1,0,'C',1)
Cell(10,5,' ',1,0,'L',1)
Cell(20,5,'Summe {app.format_wrg}',1,0,'C',1)
Cell(15,5,'#',1,0,'L',1)
<!-- wbcif:end -->
<!-- wbc:end -->
Ln()
SetY(100)


<!-- wbcprint:header2 -->
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
Image('{app.projects_dir}/{app.project}/{logo}',130,10,40)
SetFont('Arial','',8)
Ln()
SetY(35)
<!-- wbc:end -->
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
SetFont('Arial','',12)
<!-- wbcif:begin query="data" var="gid" value="1,2" operator="?" -->
Write(0,'ANGEBOT {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="3,4" operator="?" -->
Write(0,'AUFTRAG {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="5" operator="#" -->
Write(0,'LIEFERSCHEIN {prefix&#x7d;{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="6" operator="#" -->
Write(0,'RECHNUNG {prefix}{lfdnr}')
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="gid" value="7" operator="#" -->
Write(0,'GUTSCHRIFT {prefix}{lfdnr}')
<!-- wbcif:end -->
SetFont('Arial','',8)
SetXY(130,30)
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(20,4,'Datum',1,0,'L',1)
Cell(20,4,'{cdatum:datum}',1)
SetXY(130,34)
Cell(20,4,'Seite',1,0,'L',1)
Cell(20,4,$this->PageNo(),1)

Ln()
SetY(45)
SetDrawColor(128,128,128)
Rect($this->GetX(),50,183,210)
SetDrawColor(0,0,0)
SetFillColor(204,204,204)
Cell(8,5,'Pos',1,0,'L',1)
Cell(95,5,'Artikel-Nr/Bezeichnung/Text',1,0,'L',1)
Cell(20,5,'Menge',1,0,'C',1)
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(15,5,'Preis {app.format_wrg}',1,0,'C',1)
Cell(10,5,' ',1,0,'L',1)
Cell(20,5,'Summe {app.format_wrg}',1,0,'C',1)
Cell(15,5,'',1,0,'L',1)
Ln()
Cell(148,5,'Übertrag',1,0,'L',0)
Cell(20,5,$this->GetVar("zsumme","wrg"),1,0,'R',0)
Cell(15,5,' ',1,0,'L',0)
<!-- wbcif:end -->
<!-- wbc:end -->
Ln()
SetY(55)


<!-- wbcprint:footer1 -->
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
Ln()
SetY(265)
SetFont('Arial','',6)
Write(3,'{firma}')
Ln()
MultiCell(40,3,'{anschrift}',0,'L')
SetXY(50,265)
MultiCell(40,3,"Telefon: {telefon}\nTelefax: {telefax}\nE-Mail: {email}\nInternet: {www}",0,'L')
SetXY(100,265)
MultiCell(40,3,"UStID: {ustid}\nSteuer-Nr: {steuernr}\nHRB: {hrb}",0,'L')
SetXY(150,265)
MultiCell(40,3,"Bankverbindung:\n{bank1}\nBLZ: {blz1}\nKonto: {kontonr1}\nIBAN: {iban1}\nBIC: {bic1}",0,'L')
<!-- wbc:end -->

<!-- wbcprint:footer2 -->
Ln()
SetY(255)
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(148,5,'Übertrag',1,0,'L',0)
Cell(20,5,$this->GetVar("zsumme","wrg"),1,0,'R',0)
Cell(15,5,' ',1,0,'L',0)
<!-- wbcif:end -->
<!-- wbc:end -->

<!-- wbcprint:footer3 -->
Ln()
SetY(250)
SetFillColor(204,204,204)
SetDrawColor(128,128,128)
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(23,5,'Warenwert {app.format_wrg}',1,0,'C',1)
Cell(20,5,'Gwicht',1,0,'R',1)
Cell(20,5,'Versand {app.format_wrg}',1,0,'R',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'C',1)
Cell(20,5,'MwSt {mwst1}%',1,0,'C',1)
Cell(20,5,'MwSt {mwst2}%',1,0,'C',1)
Cell(25,5,'SUMME {app.format_wrg}',1,0,'C',1)
Cell(15,5,'',1,0,'R',1)
Ln()
Cell(23,5,'{basketbrutto:wrg}',1,0,'R')
Cell(20,5,'{gesgewicht:num}',1,0,'R')
Cell(20,5,'{vkostensum:wrg}',1,0,'R')
Cell(20,5,'',1,0,'R')
Cell(20,5,'',1,0,'R')
Cell(20,5,'{gesmwst1:wrg}',1,0,'R')
Cell(20,5,'{gesmwst2:wrg}',1,0,'R')
Cell(25,5,'{gesbrutto:wrg}',1,0,'R')
Cell(15,5,'',1,0,'R')
<!-- wbcif:end -->
<!-- wbc:end -->



<!-- wbcprint:body -->
<!-- wbc:begin table="salepos as b left join sales as d on d.sid=b.sid left join items as a on a.pid=b.pid left join properties as c on c.id=b.meh" select="a.*,b.*,c.keyname as mehtext,d.gid as gid,b.id as posid" where="b.sid={getnum.sid}" order="b.rindex asc" -->
<!-- wbcif:begin query="data" var="typ" value="1" -->
SetDrawColor(128,128,128)
Cell(8,5,'{b.pos:int}',0)
CellMax(95,5,'{a.produktid}',0)
SaveXY()
Ln()
SetX($this->GetX()+8)
CellMax(95,5,"{a.bezeichnung}",0)
<!-- wbc:begin table="merkmale" where="typ='SPOS' and lid={posid} and (mtyp='sel' or mtyp='ein')" select="*,id as merkmalid,mid as mediaid" -->
Ln()
SetX($this->GetX()+8)
CellMax(70,5,"<!-- wbc:begin table="properties" where=" id={mid}" -->{kurzbez} <!-- wbc:end --><!-- wbcif:begin query="data" var="mtyp" value="sel" -->		<!-- wbc:begin table="merkmale as a left join media as b on b.id=a.mid" where="a.typ=\"MKSP\" and a.lid={merkmalid}" select="a.id as merkmalid,a.lid,a.bezeichnung,b.bezeichnung as merkmaltext" maxrows="1" -->{merkmaltext}<!-- wbc:end --><!-- wbcif:end --><!-- wbcif:begin query="data" var="mtyp" value="ein" -->{bezeichnung}<!-- wbcif:end -->",0)
<!-- wbc:end -->
SaveVar("aktzz",$this->GetY(),0)
RestoreXY(0,0)
Cell(20,5,'{b.menge:num} {mehtext}',0,0,'R')
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(15,5,'{b.preis:wrg}',0,0,'R')
Cell(10,5,'{b.rabatt:num}',0,0,'R')
Cell(20,5,'{b.wert:wrg}',0,0,'R')
SaveVar("zsumme",{b.wert:num},1)
Cell(15,5,'',0,0,'R')
<!-- wbcif:end -->
<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="typ" value="2" -->
SetX($this->GetX()+8)
MultiCell(150,4,'{b.kurzbez}',0,'L')
SaveVar("aktzz",$this->GetY(),0)
<!-- wbcif:end -->
SetY($this->GetVar("aktzz"))
Ln()
Line($this->GetX(),$this->GetY(),$this->GetX()+183,$this->GetY())
<!-- wbc:end -->

<!-- wbc:begin table="sales" select="ladr as liefadr" where="sid={getnum.sid}" -->
<!-- wbcif:begin query="data" var="liefadr" value="0" operator="<" -->
<!-- wbc:begin table="users" where="uid={liefadr:int}" maxrows="1" -->
Ln()
Write(4,'Lieferadresse:')
Ln()
Write(4,'{firma}')
Ln()
Write(4,'{vorname} {name}')
Ln()
Write(4,'{strasse}')
Ln()
Write(4,'{plz} {ort}')
<!-- wbc:begin table="properties" where="typ='co' and id='{land}'" -->
Ln()
Write(4,'{kurzbez}')
<!-- wbc:end -->
<!-- wbc:end -->
<!-- wbcif:end -->
<!-- wbc:end -->

<!-- wbc:begin table="merkmale" where="typ='SALE' and lid={getnum.sid} and (mtyp='sel' or mtyp='ein')" select="*,id as merkmalid,mid as mediaid" -->
Ln()
MultiCell(150,4,"<!-- wbc:begin table="properties" where=" id={mid}" -->{kurzbez}:\n<!-- wbc:end --><!-- wbcif:begin query="data" var="mtyp" value="sel" -->		<!-- wbc:begin table="merkmale as a left join media as b on b.id=a.mid" where="a.typ=\"MKSP\" and a.lid={merkmalid}" select="a.id as merkmalid,a.lid,a.bezeichnung,b.bezeichnung as merkmaltext" maxrows="1" -->{merkmaltext&#x7d;<!-- wbc:end --><!-- wbcif:end --><!-- wbcif:begin query="data" var="mtyp" value="ein" -->{beschreibung}<!-- wbcif:end -->",0,'L')
<!-- wbc:end -->