3
.+hn @ s6 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'ej(dZ)ej*edd G dd deZ+G dd de j,Z-G dd dZ.dS )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 )stockupdjango
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/deliverynote.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. r3 updater r- r5 save)r! stater" r" r# r7 E s zNumberedCanvas.save)r( r) r* r+ r r5 r7 r" r" r" r# r, 5 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_tax_customer_company_customer_title_customer_surname_customer_firstname_customer_street_customer_postcode_customer_city_customer_country_customer_mail_customer_Telephone_customer_shipping_company_customer_shipping_surname _customer_shipping_firstname_customer_shipping_street_customer_shipping_postcode_customer_shipping_city_customer_shipping_country _customer_shipping_telephone_payment_method_payment_details _payment_sum _payment_tax_shipping_method_shiping_details _sold_items_comment_invoice_comment_orderId
_billingNr_userId_userIdPlattform
_payment_dateZ
_invoice_date_shipping_date
_deal_with
_working_days _elements),r! buffer is_sogood platform_id
order_datetypetaxcustomerCompany
customerTitlecustomerSurnamecustomerFirstnamecustomerStreetcustomerPostcode customerCitycustomerCountry customerMailcustomerTelephonecustomerShippingCompanycustomerShippingSurnamecustomerShippingFirstnamecustomerShippingStreetcustomerShippingPostcodecustomerShippingCitycustomerShippingCountrycustomerShippingTelephone
paymentMethodpaymentDetailspaidSumpaidTaxshippingMethodshippingDatails soldItemscommentinvoiceCommentorderId billingNruserIduserIdPlattform payment_date invoice_date
shipping_datedealWith working_dayselementsr" r" r# r b sZ K
zSogoodPrintable.__init__N)r$ c C sn 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 |rjd| jdkrdn| j| jdkr| jn| j| jdkr| jn| j| jdkr | jn| j| jdkr"| jn| j| jdkr8| j n| j| j dkrN| j n| j | j dkrd| jn| j | j dkrxdn| j | j!dkrdn| j!f
} t"| |d }
dt#j#j$ j%d } dt#j#j$ j%d } | j d krt"| |d }
nt"| |d }
|
|
gg}t&|dt d}t'd#d(d-g}|j(| |j |j
|j\}}|j||j
d |j |d |j|j | dS ).zd
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 Normalal
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< RIGHTPADDINGr r r r r )r r r r r r r r r r )r r r r r r r r r r )r r r r ))loggerinforH r addr r r r= r< r r
wrapr bottomMargindrawOn
leftMarginr rB rM rD rL rC rK rA rN rE rO rF rP rG rQ rJ rR r datetimenowstrftimer r setStyle)r! cdoc
is_first_pagestyleslogoimwh
customer_addrcustomer_addr_pZvendor_maimai24_addrZvendor_sogood_addr
vendor_addr_pdatatablestylew1h1r" r" r# headerY 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
r zSogood International GmbHzTelefon: +49 6106 6667585zAmtsgericht OffenbachzBankverbindung:zBIC: DRESDEFFXXXzGutenbergring 1zE-Mail: info@sogood.dez HRB 42229 CommerzbankzIBAN:z 63110 Rodgaur u# Geschäftsführerin: Shaoyang Huangzutf-8z
BLZ: 50080000ZDE33500800000635289300 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 265808049r r r r FONTSIZE ALIGNLEFTVALIGNMIDDLEgffffff
@g333333?)r
rowHeightsNr r r r r r )r r r r r r r r r r )r r r r r r r r r r )r r r r r r r r r r )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| j f }|jt
||d |jt d| jddd |jtd d | j dkrd}n$| j dkrd}n| j dkrd}nd}|jt
||d |jtd d d| j
}|jt
||d |jtd d d }|jt
||d |jtd d d | j| jf }|jt
||d |jtd d |j| j |jtd d d | j| j| jf }|jt
||d |jtd d d | j| jf }|jt
||d |jtd d |j| j |jtd d d!}|jt
||d |jtd d" | jd#krtd$}nd%}|jt
||d |jtd d d&S )'zC
write first page content
:param elements:
MY_Justify )r r leadingMY_Right)r r MY_CenterMY_Head zHelvetica-Bold)r r fontSizefontNamer r z8Auftrag-Nr.: %s and Rechnung-Nr.: %sr Code128( x )valuer r 0z#Angebot1u0 Auftrag Bestätigung2z(Lieferscheinz$Rechnungz+Sehr geehrter Herr %s,uD gemäß Ihrer Bestellung liefern wir wie folgt z(Kunden-Nr.: %s / %sr z
Zahlungsmethode: %s
Zahlungsdatum: %s
Bearbeitungszeit: %s Tage
ze
Versandart: %s
Versanddatum: %s
u. Mit freundlichen Grüssen0 r z$Ihr Sogood Teamz&Ihr Maimai24 TeamN)r r r r r r r1 r r\ r] r r r; rC r^ r_ table_articlesrS r` rc rW ra
talbe_commentr< )r! r r ptextZ payment_infoZ
shipping_infor" r" r#
write_content s\
z SogoodPrintable.write_contentc C s g }|j dg |j | jg |j dg |j | jg t }|d }d|_d|_t|_g }xD|D ]<}g }x(tt |D ]}|j t
|| | qxW |j | qbW t |dgd}t dd
dd t
jfd ddd t
jfg}|j| |S )NzMemo:zRechnungsvermerk:BodyTextCJK i )r INNERGRIDr r g ?BOX)r r r r )r r )r r r r )r r )r1 rZ r[ r wordWrapr r r rangelenr r r r blackr ) r! r sdata_with_stylerowdata_with_style_rowitr r" r" r# r R s*
z SogoodPrintable.talbe_commentc C s0 g }|j ddddg tj| jdd}|d }x|D ]}g }|d d k r\t|d r\|d }|j | |j td
|d d d
|d d k r|d rtj|d dd}|j | |d d k rt|d r|j |d |j | q4W t }|d }d|_ d|_
t |_ t } | d } d| _ d| _
t
| _ tddddd}
g } xt|D ]\} }g }
xtt|D ]~}| dkrv|
j || n^|dkr|
j tt|| |
n:|t|d kr|
j tt|| | n|
j || qXW | j |
q>W t| dd 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)strictr eanNr
r )r r r r )r countr r r ZFourthColumnStyle r )r r r r r S u r )r r g ?r )r r r r )r r )r r r r )r r )r1 jsonloadsrd strr textwrapfillr r r r r r r enumerater r r r r r r r )r! r loaded_json
items_jsonxr r Z name_wrappedr s_rightZs_fourth_columnr Z row_indexr r r r r" r" r# r r sX
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 r pdfr" r" r# do s
zSogoodPrintable.do)
r( r) r* r+ r r r r r r r r r! r" r" r" r# r9 [ s xR.
_ Ar9 )/r+ 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 r r ior getLoggerr registerFontr r- r, r9 r" r" r" r# s, $
&