3
1iWh @ sB d Z ddlZddlZddlZddlmZ ddlmZ ddlm Z m
Z
m Z m Z m
Z
mZmZ ddlmZmZ ddlmZmZ ddlmZ dd lmZ dd
lmZm Z m Z m Z dd l m Z dd lm!Z! dd
l"m#Z# ddl$m%Z% ddl&Z&ddl'Z'ddl(m)Z) ej*dZ+ej,edd G dd deZ-G dd de j.Z/G dd dZ0dS )z
* @author Xiaobo Sun
* created on 23.06.2018
* @copyright (C) 2018 Sogood International GmbH - all rights reserved
* @licence
* Unauthorized copying of this file, via any medium is strictly prohibited
* Proprietary and confidential
N)colors)A4)SimpleDocTemplate ParagraphSpacerImageTable
TableStyleFlowable)getSampleStyleSheetParagraphStyle)inchcm)
pdfmetrics)TTFont)TA_RIGHT TA_CENTERTA_LEFT
TA_JUSTIFY)canvas)mm)createBarcodeDrawing )stockup)
HRFlowabledjango
DejaVuSanszfonts/DejaVuSans.ttfc @ s& e Zd ZdZdd ZddddZdS )SampleFlowablezM
Sample Flowable Usage
Usage : elements.append(SampleFlowable())
c C s t j| d| _d| _d S )N2 )r
__init__widthheight)self r# +/data/git/entellipy_wy/pdf/nachlieferung.pyr * s
zSampleFlowable.__init__N)returnc C s | j jd| j| j| j dS )z
Draw a line
r N)canvliner! r )r" r# r# r$ draw/ s zSampleFlowable.draw)__name__
__module__ __qualname____doc__r r( r# r# r# r$ r $ s r c @ s4 e Zd ZdZdd ZddddZdddd ZdS )
NumberedCanvasz%
Page Number - Canvas Sample
c O s t jj| f|| g | _d S )N)r Canvasr _saved_page_states)r" argskwargsr# r# r$ r ; s zNumberedCanvas.__init__N)r% c C s | j jt| j | j dS )z
Show page
N)r/ appenddict__dict__
_startPage)r" r# r# r$ showPage? s zNumberedCanvas.showPagec C s8 x&| j D ] }| jj| tjj| qW tjj| dS )z:
Add page info to each page (page x of y)
N)r/ r4 updater r. r6 save)r" stater# r# r$ r8 F s zNumberedCanvas.save)r) r* r+ r, r r6 r8 r# r# r# r$ r- 6 s r- c @ sv e Zd ZdZdd ZddddZdddd Zddd
d Zddd d
ZddddZ dd Z
dd Z dd Z dS )SogoodPrintablez
Main Class
A4 is 210mm x 297mm, 8.27 x 11.69 inches. 1 inch is 72 points (not pixel)
dimension 592 x 842 points
c C s || _ || _|| _|dk| _|| _|| _|| _|| _|| _| | _ |
| _
| | _ | | _ |
| _
|| _|| _|| _|| _|| _|| _|| _|| _|| _dS )u
:param buffer:
:param is_sogood: False
:param platform_id(new): 9876543210 : if afterbuy-id available, else goodone-order id
:param order_date(new): "25.06.2018 09:30:00" - new
:param type(new): 0 Angebot, 1 Auftragsbestätigung, 2 Lieferschein, 3 Rechnung
:param tax(new): 19
:param customerCompany: "Muster International GmbH"
:param customerTitle(new): "Herr"
:param customerSurname: "Müller"
:param customerFirstname: "Thomas"
:param customerStreet: "Hans-Kohl-Str. 27"
:param customerPostcode: "64646"
:param customerCity: "Heppenheim"
:param customerCountry: "Deutschland"
:param customerMail: "thomas.müller@muster.de"
:param customerTelephone: "+49 151 00000000"
:param customerShippingCompany: "Muster International GmbH"
:param customerShippingSurname: "Müller"
:param customerShippingFirstname: "Thomas"
:param customerShippingStreet: "Hans-Kohl-Str. 27"
:param customerShippingPostcode: "64646"
:param customerShippingCity: "Heppenheim"
:param customerShippingCountry: "Deutschland"
:param paymentMethod: "Paypal"
:param paymentDetails: "http://url_to_qrcode"
:param paidSum: "289.00"
:param paidTax(new): "50.00"
:param shippingMethod: "DHL/DPD/EkremTranksport"
:param shippingDatails: "28.06.2018"
:param soldItems:
{"items":
[
{
"ean": "4250755330211",
"quantity": "1",
"price": "310.99",
"comment": "ECHT GLAS DUSCHE DUSCHABTRENNUNG DUSCHKABINE AUS SICHERHEITSGLAS RAVENNA17-2",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4250755304137",
"quantity": "3",
"price": "60.99",
"comment": "WC SITZ TOILETTENDECKEL KLODECKEL KLOBRILLE TOILETTENSITZ SOFTCLOSE WCD376",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4250755323091",
"quantity": "1",
"price": "260.99",
"comment": "140x200 cm Design Walk-In Duschabtrennung Bremen1 in grauem Glas mit 4-eckigem Stabilisator BRAM2
Breite (cm): 140 cm
Stabilisator: 4 - eckig (BRAM2)",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4250755323091",
"quantity": "2",
"price": "520.99",
"comment": "LUXUS DUSCHE DUSCHWAND DUSCHABTRENNUNG AUS ECHTGLAS VARIABEL 80-120CM BREMEN 1s",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "109.99",
"comment": "ABLAUFGARNITUR SIPHON DUSCHTASSE Ø90MM
ABLAUFLOCH GERUCHVERSCHLUSS AL02",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "29.95",
"comment": "Nano-M für Duschwand Wachbecken WC &
Bildet SOGOOD",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "29.95",
"comment": "Nano-M für Duschwand Wachbecken WC &
Bildet SOGOOD",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "29.95",
"comment": "Nano-M für Duschwand Wachbecken WC &
Bildet SOGOOD",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4250755323527",
"quantity": "1",
"price": "329.95",
"comment": "Bremen2ms 90x200 cm 10 mm (BR10703MS 90)",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "4250755323091",
"quantity": "1",
"price": "260.99",
"comment": "140x200 cm Design Walk-In Duschabtrennung Bremen1 in grauem Glas mit 4-eckigem Stabilisator BRAM2
Breite (cm): 140 cm
Stabilisator: 4 - eckig (BRAM2)",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "",
"quantity": "1",
"price": "-260.99",
"comment": "4% Rabatt auf Ihre Bestellung",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
},
{
"ean": "",
"quantity": "1",
"price": "-300.99",
"comment": "5% Rabatt auf Ihre Bestellung",
"tax": "19",
"stammbezeichnung": "sbz1",
"packstueck": "1"
}
]
}
:param comment: "testing memo..."
:param invoiceComment: "testing memo..."
:param orderId: "1197839669"
:param billingNr: "206437"
:param userId: "1129167235"
:param userIdPlattform: "Amazon-t4zhnxnjgrj83v3@marketplace.amazon.fr"
:param payment_date: "25.06.2018 09:30:00"
:param invoice_date: "25.06.2018 09:30:00"
:param shipping_date: "25.06.2018 09:30:00"
:param deal_with: ""
:param working_days: 3
z96994_sogood-de-ottoN)_buffer_type
_is_sogood_is_otto _platform_id _order_date_customer_company_customer_title_customer_surname_customer_firstname_customer_street_customer_postcode_customer_city_customer_country_customer_mail_customer_Telephone_userIdPlattform _elements_memo_erstellungsdatum_versand_orderId_xNachlieferungId)r" buffer is_sogood platform_id
order_datetypecustomerCompany
customerTitlecustomerSurnamecustomerFirstnamecustomerStreetcustomerPostcode customerCitycustomerCountry customerMailcustomerTelephoneelementsmemoerstellungsdatumversanduserIdPlattformorderIdxNachlieferungIdr# r# r$ r c s0 6
zSogoodPrintable.__init__N)r% c C s t jd| j d t }|jtdtd |jtdtd d}| jdkrRd}n| j d krbd
}nd }t
|d t d
t }|j |j
|j\}}|j||j
d |j |d |j|j |rd| jdkrdn| j| j| j| jd kr| jnd| j| j| j| j| jdkr dn| jdf
} t| |d }
dtjj j d } dtjj j d } | j d krjt| |d }
nt| |d }
|
|
gg}t |dt d}t d%d*d/g}|j | |j |j
|j\}}|j||j
d |j |d |j|j | dS )0zd
Header on each page
:param c: Canvas
:param doc: SimpleDocTemplate
zdeliverynote.py header() z xiaoboJustify)name alignmentRightzimages/doporro.pngTzimages/otto.jpgTruezimages/logo.pngzimages/maimai.pngg333333@g? a
%s %s %s
%s
%s
%s, %s
%s
RTel: %s
LTel: %s
N nullNormalal
Mai & Mai GmbH
Gutenbergring 1
63110 Rodgau Deutschland
Telefon: +49 6106 6670592
www.maimai24.de
%s
z%d.%m.%Y %H:%M:%Sau
Sogood International GmbH
Gutenbergring 1
63110 Rodgau Deutschland
Telefon: +49 6106 6667585
www.sogood.de
%s
) colWidthsFONTr r Helvetica LEFTPADDING< RIGHTPADDING)Nro r r ry ry ry )rs rx rz rt r r ry ry ry ry )ru r{ r| rv r r ry ry ry ry )rw r} r~ rv )!loggerinforH r addr r r r> r= r r
wrapr bottomMargindrawOn
leftMarginr! rB rD rC rA rE rF rG rJ r datetimenowstrftimer r setStyle)r" cdoc
is_first_pagestyleslogoimwh
customer_addrcustomer_addr_pvendor_maimai24_addrvendor_sogood_addr
vendor_addr_pdatatablestylew1h1r# r# r$ header1 sN
*
zSogoodPrintable.headerc C s | j dkrFdddddgddd d
d gd d
djdddgdd
d
ddgg}n:dddddgdddd
d gd d
djddd gdd
d
d d gg}td1d6d;d@g}t|d)t gd*t d+}|j| |j|j|j\}}|j ||j
| d,S )Az
Footer on each page
Runs demo demonstrating usage of Spreadsheet Tables.
:param c: Canvas
:param doc: SimpleDocTemplate
rl zSogood International GmbHzTelefon: +49 6106 6667585zAmtsgericht OffenbachzBankverbindung:zBIC: DRESDEFFXXXzGutenbergring 1zE-Mail: info@sogood.dez HRB 42229 CommerzbankzIBAN:z 63110 Rodgaurn u# Geschäftsführerin: Shaoyang Huangzutf-8z
BLZ: 50080000DE33500800000635289300 DeutschlandzKonto: 0635289300zUSt-IdNr:DE DE814341426zMai & Mai GmbHzTelefon: +49 6106 6670592zBIC: COBADEFF004zEMail:info@maimai24.dez HRB 44229u Geschäftsführerin: Wei Taoz
BLZ: 50040000zDE7250 0400000413058900zKonto: 4130589 00zUStIdNr: DE 265808049rs r r rt FONTSIZE ALIGNLEFTVALIGNMIDDLEgffffff
@g333333?)rr
rowHeightsNr r ry ry ry ry )rs r r rt r r ry ry ry ry )r r r r r r ry ry ry ry )r r r r r r ry ry ry ry )r r r r ) r= encoder r r r r r r r r )r" r r r r r r r r# r# r$ footer s,
zSogoodPrintable.footerc C s. |j | j||d | j|| |j dS )z[
First Page
:param c: Canvas
:param doc: SimpleDocTemplate
TN) saveStater r restoreState)r" r r r# r# r$ header_footer_first_page s z(SogoodPrintable.header_footer_first_pagec C s. |j | j||d | j|| |j dS )z[
First Page
:param c: Canvas
:param doc: SimpleDocTemplate
FN)r r r r )r" r r r# r# r$ header_footer_later_pages s z)SogoodPrintable.header_footer_later_pagesc C s t }|jtdtdd |jtdtd |jtdtd |jtdtdd d
|jtd d d
| j }|jt ||d |jt
d| jddd |jtd d | j dkrd}n>| j dkrd}n.| j dkrd}n | j dkrd}n| j d krd}|jt ||d d | j d | j
gg}t|d d gd!}|jtd6d;d&dAuftrag-Nr.: %srp Code128( x )valuer! r 0z#Angebot1u0 Auftrag Bestätigung2z2Ersatzlieferungsschein3z$Rechnung5zOriginale BestellNr: %szBestelldatum: %s )rr r r r r TEXTCOLORr z100%)r thicknesscolorug Vielen Dank für Ihre Bestellung.Wir liefern Ihnen wie vereinbart folgende Waren: zv
Erstellungsdatum: %s
Versand bis spaetestens: %s
u. Mit freundlichen Grüssen0 rl z$Ihr Sogood Teamz&Ihr Maimai24 TeamNr r ry ry ry ry )r r r r r r ry ry ry ry )r r r r )r r ry ry )ry ry )r r r r r r r2 r rQ r r r< rP r@ r r r r blackr table_articlesrN rO
talbe_commentr= )r" ra r ptextr r payment_infor# r# r$
write_content sf
z SogoodPrintable.write_contentc C s g }|j dg |j | jg |j dg |j dg t }|d }d|_d|_t|_g }xD|D ]<}g }x(tt|D ]}|j t || | qvW |j | q`W t
|dgd}t d ddd t j
fd
ddd t j
fg}|j| |S )NzMemo:zRechnungsvermerk:rn BodyTextCJK i )rr INNERGRIDr r g ?BOX)r r ry ry )ry ry )r r ry ry )ry ry )r2 rM r wordWrapr r rj rangelenr r r r r r ) r" r sdata_with_stylerowdata_with_style_rowitr r# r# r$ r 7 s*
z SogoodPrintable.talbe_commentc C s@ g }|j ddddg tj| jdd}|d }x|D ]}g }d}|d d
k r`t|d r`|d }|j | |j td |d d
d d}|d d
k r|d rtj|d dd}|j | d}|d d
k rt|d r|d }|j | |j | q4W t } | d } d| _ d| _
t | _ t }
|
d }
d|
_ d|
_
t
|
_ tddddd} g } xt|D ]\}
}g }xtt|D ]~}|
dkr|j || n^|dkr|j tt|| | n:|t|d kr|j tt|| |
n|j || qhW | j | qNW t| d d d d gd }td!d$d'd"tjfd#d(d+d"tjfg}|j| |S ),z]
Runs demo demonstrating usage of Spreadsheet Tables.
:return: Table
EANBarcodeNameCountF)strictra rn eanNr
r )r r! r ri )r countr r r FourthColumnStyle r )ri r r rj r S u r r )rr r g ?r )r r ry ry )ry ry )r r ry ry )ry ry )r2 jsonloadsrL strr textwrapfillr r r r rj r r enumerater r r r r r r r )r" r loaded_json
items_jsonxr r name_wrappedr r s_rights_fourth_columnr row_indexr r r r r# r# r$ r W s`
z SogoodPrintable.table_articlesc C s\ t jd t| jtddddd}g }| j| |j|| j| jt d | jj
}| jj |S )zC
Entry method of the class
:rtype: BytesIO
zdeliverynote.py do()H )pagesize rightMarginr topMarginr ) onFirstPage onLaterPages canvasmaker) r r r r; r r buildr r r- getvalueclose)r" r ra pdfr# r# r$ do s
zSogoodPrintable.do)
r) r* r+ r, r r r r r r r r r r# r# r# r$ r: \ s OR.
l Er: )1r, r r logging
reportlab.libr reportlab.lib.pagesizesr reportlab.platypusr r r r r r r
reportlab.lib.stylesr r reportlab.lib.unitsr
r reportlab.pdfbaser reportlab.pdfbase.ttfontsr reportlab.lib.enumsr r r r reportlab.pdfgenr r reportlab.graphics.barcoder rn r ior reportlab.platypus.flowablesr getLoggerr registerFontr r. r- r: r# r# r# r$ s. $
&