3
w^j @ s> 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"m&Z&m'Z'm(Z( ej)edd ej*ej+d 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)Drawing)eanbcqruspsZ
DejaVuSanszfonts/DejaVuSans.ttfz de_DE.UTF-8c @ 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/letter.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 @ sB e Zd ZdZdd ZddddZdddd Zddd
d 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 8 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 sL t | j}x0| jD ]&}| jj| | j| tjj| qW tjj| dS )z:
Add page info to each page (page x of y)
N) lenr. r3 updatedraw_page_numberr r- r5 save)r! num_pagesstater" r" r# r9 C s
zNumberedCanvas.savec C s. | j d | jdt dt d| j|f dS )zI
Draw page number
:param page_count: page number
d
z %d von %dN) setFontSizedrawCentredStringr _pageNumber)r! Z
page_countr" r" r# r8 N s
z NumberedCanvas.draw_page_number)r( r) r* r+ r r5 r9 r8 r" r" r" r# r, 3 s
r, c @ s e Zd ZdZdd ZddddZdddd Zddd
d Zddd d
ZddddZ e
dd Z dd Z dd Z
dd Zdd ZdS )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 || _ || _|| _|| _|| _|| _|| _|| _| | _|
| _ | | _
| | _ |
| _ || _
|| _|| _|| _|| _|| _|| _|| _|| _|| _|| _|| _|| _|| _| | _| | _ | | _ | | _ | | _ |!| _ |"| _!|#| _"|$| _#|%| _$|&| _%|'| _&|(| _'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"
},
{
"ean": "4250755304137",
"quantity": "3",
"price": "60.99",
"comment": "WC SITZ TOILETTENDECKEL KLODECKEL KLOBRILLE TOILETTENSITZ SOFTCLOSE WCD376",
"tax": "19"
},
{
"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"
},
{
"ean": "4250755323091",
"quantity": "2",
"price": "520.99",
"comment": "LUXUS DUSCHE DUSCHWAND DUSCHABTRENNUNG AUS ECHTGLAS VARIABEL 80-120CM BREMEN 1s",
"tax": "19"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "109.99",
"comment": "ABLAUFGARNITUR SIPHON DUSCHTASSE Ø90MM
ABLAUFLOCH GERUCHVERSCHLUSS AL02",
"tax": "19"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "29.95",
"comment": "Nano-M für Duschwand Wachbecken WC &
Bildet SOGOOD",
"tax": "19"},
{
"ean": "4251242935322",
"quantity": "1",
"price": "29.95",
"comment": "Nano-M für Duschwand Wachbecken WC &
Bildet SOGOOD",
"tax": "19"
},
{
"ean": "4251242935322",
"quantity": "1",
"price": "29.95",
"comment": "Nano-M für Duschwand Wachbecken WC &
Bildet SOGOOD",
"tax": "19"
},
{
"ean": "4250755323527",
"quantity": "1",
"price": "329.95",
"comment": "Bremen2ms 90x200 cm 10 mm (BR10703MS 90)",
"tax": "19"
},
{
"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"
},
{
"ean": "",
"quantity": "1",
"price": "-260.99",
"comment": "4% Rabatt auf Ihre Bestellung",
"tax": "19"
},
{
"ean": "",
"quantity": "1",
"price": "-300.99",
"comment": "5% Rabatt auf Ihre Bestellung",
"tax": "19"
}
]
}
:param comment: "testing memo..."
N)(_buffer_type
_is_sogood _platform_id _order_date_tax_customer_companyZ_customer_title_customer_surname_customer_firstname_customer_street_customer_postcode_customer_city_customer_countryZ_customer_mailZ_customer_Telephone_customer_shipping_company_customer_shipping_surname _customer_shipping_firstname_customer_shipping_street_customer_shipping_postcode_customer_shipping_city_customer_shipping_country_payment_method_payment_details _payment_sum _payment_taxZ_shipping_methodZ_shiping_details _sold_items_comment_memo_ab_docNo
_shippingDate_docDate_show_customer_name_in_doc_vat_nr _arbeitsort _customer_shipping_Telephone
_deal_with))r! buffer is_sogood platform_id
order_datetypetaxcustomerCompany
customerTitlecustomerSurnamecustomerFirstnamecustomerStreetcustomerPostcode customerCitycustomerCountry customerMailcustomerTelephonecustomerShippingCompanycustomerShippingSurnamecustomerShippingFirstnamecustomerShippingStreetcustomerShippingPostcodecustomerShippingCitycustomerShippingCountry
paymentMethodpaymentDetailspaidSumpaidTaxshippingMethodshippingDatails soldItemscommentmemo_abdocNo shippingDatedocDateshow_customer_name_in_docvat_nr
arbeitsortcustomerShippingTelephonedealWithr" r" r# r ` sR %zSogoodPrintable.__init__N)r$ c C sN t }|jtdtd |jtdtd d}| jr8d}t|dt dt }|j|j |j
\}}|r|j ||j dt
|j|j
d t n |j ||j dt
|j|j
|rJtd
d d d
} td
d d td}
d} | jdkrd} n2| jdkrd} n"| jdkrd} n| jdkrd} d} | jr(d} t| |d
}
td|d
}t| jdk rbtd |d
}| jd kr| jdkrd | j| j| j| j| j| j| j| jf }n$d | j| j | j | j | j | j | j!f }nJ| jdkrd | j| j| j| j| j| jf }n d!| j| j | j | j | j!f }t|| }d"}| j"d#kr2d$}| j"d%krBd&}| j"d'krRd(}| j#d)krj| jrjd*}t||
}| j$d+krd,| | j%| j&| j'f }nd-| | j%| j&| j'| j$f }t||
}|
||g||ggg}t(|d.t d/t
d0}t)d?dDdIdNg}|j*| |j|j |j
\}}|j ||j d |j |d |j|j
| d9t
d:S )Ozd
Header on each page
:param c: Canvas
:param doc: SimpleDocTemplate
ZJustify)name alignmentZRightzimages/maimai.pngzimages/logo_pdf.pngg333333@grh|? g?Normal r> )r fontSizeleading)r r r r zDokumenten-Nr.0z Angebots-Nr.1z Bestell-Nr.2zLieferschein-Nr.3z
Rechnungs-Nr.zs
Mai & Mai GmbH - Gutenbergring 1 - 63110 Rodgau
z
Sogood GmbH - Gutenbergring 1 - 63110 Rodgau
z
zYz
%s
%s %s
( %s )
%s
%s %s
%s
z
%s
%s %s
%s
%s %s
%s
z
%s
( %s )
%s
%s %s
%s
z
%s
%s
%s %s
%s
aX
Mai & Mai GmbH
Gutenbergring 1
63110 Rodgau
Tel.: +49 6106 6670592
www.doporro.com
zShowroom-Gelnhausena
Mai & Mai GmbH
Gutenbergring 1
63110 Rodgau
Tel.: +49 6106 667585
E-Mail: M.Oymak@doporro.de
www.doporro.com
zShowroom-Heusenstammu
Mai & Mai GmbH
Seligenstädter Grund 11
63150 Heusenstamm
Tel.: +49 6104 8023762
E-Mail: M.Oymak@doporro.de
www.doporro.com
zShowroom-Dietzenbachah
Mai & Mai GmbH
Albert-Einstein-Str. 6
63128 Dietzenbach
Tel.: +49 6074 9146769
E-Mail: M.Oymak@doporro.de
www.doporro.com
Z
ersatzteila1
Sogood international GmbH
Gutenbergring 1
63110 Rodgau
Tel.: +49 6106 6670592
www.sogood.de
z
%s: %s
Datum: %s
Lieferdatum: %s
z
%s: %s
Datum: %s
Lieferdatum: %s
MwSt-Nr.(VAT): %s
r= ) colWidths
rowHeightsFONTr Helvetica LEFTPADDING( RIGHTPADDINGVALIGNTOPU Nr 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 addr r r rE r r
wrapr bottomMargindrawOn
leftMarginr r rD r r6 rI ra rP rR rQ rd rS rT rU rV rK rJ rL rM rN rO rc re rb r^ r` r_ r r setStyle)r! cdocZ
is_first_pagestylesZlogoimwhZPaSt1ZPaSt2Z doc_nr_titleZvendor_addr_inLineZvendor_addr_inLine_pZempty_row_between_addrs_pZ
customer_addrZcustomer_addr_pZ vendor_addrZ
vendor_addr_pZdoc_infoZ
doc_info_pdatatablestyleZw1Zh1r" r" r# header- s *
zSogoodPrintable.headerc C s dddddgdddd d
gd d d
j dddgdd d ddgg}| jrzdddddgdddd dgd d dj ddd gdd d d d gg}td5d:d?dDg}t|d)d*d+d,d-gd.t d/}|j| |j|j|j\}}|j ||j
| d0S )Ez
Footer on each page
Runs demo demonstrating usage of Spreadsheet Tables.
:param c: Canvas
:param doc: SimpleDocTemplate
zMai & Mai GmbHzTelefon: +49 6106 6670592zAmtsgericht OffenbachzBankverbindung:zIBAN: DE7250 040000zGutenbergring 1zE-Mail: info@maimai24.dez HRB 44229Z Commerzbankz 0413 0589 00z 63110 Rodgaur u Geschäftsführerin: Wei Taozutf-8z
BLZ: 50040000zBIC: COBADEFF004Z DeutschlandzKonto: 413058900zUSt-IdNr: DE265808049zSogood International GmbHzTelefon: +49 6106 6667585zIBAN: DE3350 080000zE-Mail: info@sogood.dez HRB 42229z 0635 2893 00u Geschäftsführer: Shaoyan Huangz
BLZ: 50080000zBIC: DRESDEFFXXXzKonto: 635289300zUSt-IdNr: DE814341426r r r r FONTSIZEr< ALIGNLEFTr MIDDLEg/$V@g`")]@gOnB]@gV-U@g rV@g333333?)r r Nr 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 ) encoderE r 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
| jd kr|jtd d
d| j | j
f }|jt ||d |jt d| j dd
d d}d}| jdkrd}n.| jdkrd}n | jd krd}n| jdkrd}| jd kr|jtd d n|jtd d | jdkr0d }n(| jdkrBd }n| jd krTd }nd!}|jt ||d |jtd d" d#| }|jt ||d |jtd d$ d%| }|jt ||d |jtd d& |j| j
| jd kr |jtd d |j| j |jtd d' |jt d(| j |d | jd)kr| jd krd*}|jt ||d |jtd d$ td+d,t d-t }d.|_|j| tj| j}|j }|d, |d/ } |d0 |d }
td1d
d2| d/d/d2|
d/d/gd3} | j| |j| | jdkr@|jtd d d%| j }|jt ||d n:| jd krz|jtd d d%| j }|jt ||d |jtd d' d4}|jt ||d |jtd d$ d5S )6zC
write first page content
:param elements:
Z
MY_Justify )r r r ZMY_Right)r r Z MY_CenterZMY_Head zHelvetica-Bold)r r r fontNamer r x z$Auftrag %s am %sr ZCode128r )valuer r z Sehr geehrte Damen und Herrenr r u^ herzlichen Dank für Ihre Anfrage.
gerne unterbreiten wir Ihnen hiermit folgendes Angebot:r u vielen Dank für Ihre Bestellung. Wir freuen uns über Ihren Auftrag.
Details entnehmen Sie bitte der folgenden Übersicht:u^ wir bedanken uns für die gute Zusammenarbeit und liefern Ihnen wie vereinbart folgende Waren:r ut vielen Dank für Ihre Bestellung und das uns entgegengebrachte Vertrauen.
Wir berechnen Ihnen hiermit wie folgt: s z#Angebotu0 Auftragsbestätigungz(Lieferscheinz$Rechnung z%s,r> z%s z/Zahlungsmethode: %sZPaypalz{Mit Paypal zahlen Sie mittels QR-Code schnell und sicher.
Bitte scannen Sie den folgenden QR-Code:zimages/logo_paypal.pngr g333333?r r - g `@) transformuC Mit freundlichen Grüßen
Ihr Doporro TeamN)r r r r r r rD r1 r rF rG r r table1 tableSumInforW r r
ZhAlignr Z QrCodeWidgetrX Z getBoundsr r\ r] ) r! elementsr ptextZletter_greetingZ letter_textZi_p_logoZi_qrboundsr r Zi_qr_dr" r" r#
write_content; s
"
z SogoodPrintable.write_contentc s d} d}ddddddd gd
| | d d d
dddgd
| d ddddddgd
| d ddddddgd
| d ddddddgg}t d d _d _ fd d |D }t|d!d"d#d$d%d%d&gd'}td(d+d.d)tjfd*d/d2d)tjfg}|j| |S )3z]
Runs demo demonstrating usage of Spreadsheet Tables.
:return: Table
r r PosZEANArtikelbezeichnungZStammbezeichnungPAZPreisz%dZ
4251242935322u' ABLAUFGARNITUR SIPHON DUSCHTASSE Ø90MMzABLAUFGARNITUR AL02r z8,99r Z
4250755391915z140x200 cm Design Walk-In Duschabtrennung Bremen1 in grauem Glas mit 4-eckigem Stabilisator BRAM2 Breite (cm): 140 cm Stabilisator: 4 - eckig (BRAM2)zBremen01VG 140 + MMBR2z288,99r r z 4% Rabatt auf Ihre Bestellungz-8,99r z 5% Rabatt auf Ihre Bestellungz-10,99BodyTextCJK c s g | ]} fd d|D qS )c s g | ]}t | qS r" )r ).0cell)sr" r#
s z4SogoodPrintable.table...r" )r row)r r" r# r s z)SogoodPrintable.table..r P Z r r )r Z INNERGRIDg ?BOX)r r r r )r r )r r r r )r r )r wordWrapr r r r blackr )posir data_with_styletr r" )r r# r s&
zSogoodPrintable.tablec C s g }| j dkr$|jdddddg n|jdddg tj| jdd}|d }d
}x|D ]}g }|jt| |jd |d d
|d jdd | j dkr|j| jt|d d |j|d | j dkr|j| jt|d t|d d |j| |d
7 }qVW t }|d }d|_
d|_ t |_
t }|d }d|_
d|_ t|_
t } | d } d| _
d| _ t| _
g }
x0|D ]&}g } xtt|D ]} | j dkrR| dkr| jt|| | n| t|d
kr| jt|| | nd| t|d kr| jt|| | n<| t|d kr<| jt|| | n| jt|| | n>| dksf| dkr|| jt|| | n| jt|| | qW |
j| qzW | j dkrt|
ddd d d gd }
nt|
d d d!gd }
td*d$d+d.d%tjfg}|
j| |
S )/z]
Runs demo demonstrating usage of Spreadsheet Tables.
:return: Table
r r r Z EinzelpreisAnzahlZ GesamtpreisF)strictitemsr zr z
Artikelnummer: eanZ42507553Z42512429Zpricez EURquantityr r r r r r r i F < )r r i^ r= r r LINEBELOWg ?r r r r r r )r r r r )r r r r )r r )rD r1 jsonloadsr[ strreplace formatPricefloatr r r r r r r ranger6 r r r r r r )r! r loaded_json
items_json pos_countxr r s_rights_centerr data_with_style_rowr r r r" r" r# r sv
&
(
zSogoodPrintable.table1c C s g }d}ddd|d g}|j | t| jt| j }ddd| j|d g}|j | ddd| j d | j| jd g}|j | dddd | j| j d
g}|j | t }|d }d |_d
|_t |_
t } | d } d | _d
| _t | _
t }
|
d }
d |
_d
|
_t |
_
g } xp|D ]h} g }
xRt
t| D ]B}|t| d krT|
j t| | | n|
j t| | | q(W | j |
qW t| ddddgd}td dd d"dtjfdd%d(dtjfg}|j| |S ))zR
This table show the sum info of the order
:return: Table
z0,00r zVersandkosten : z EURzZwischensumme : zMwSt. z% : zGesamtsumme : zz EURr r r r r= )r r r r r r g ?g ?r r r r r r )r r r r )r r r r )r r r r )r r r r )r r )r1 r
rY rZ r rH r r r r r r r r r6 r r r r r r )r! r Z sum_1_valZsum_1Z sum_2_valZsum_2Zsum_3Zsum_4r r r r r r r r r r" r" r# r L sR
"
z SogoodPrintable.tableSumInfoc C s: t djt|}|jdd}|jdd}|jdd}|S )Nz {:12,.2f},#.)r formatr
r )r! pZp_newr" r" r# r s
zSogoodPrintable.formatPricec C sR t | jtddddd}g }| j| |j|| j| jtd | jj }| jj |S )zC
Entry method of the class
:rtype: BytesIO
+ r )pagesizeZ rightMarginr Z topMarginr )Z onFirstPageZ onLaterPagesZ canvasmaker)
r rC 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 staticmethodr r r r r" r" r" r" r# rB Y s N K*
m " ?rB )0r+ datetimer locale
reportlab.libr reportlab.lib.pagesizesr Zreportlab.platypusr r r r r r r
Zreportlab.lib.stylesr r reportlab.lib.unitsr
r reportlab.pdfbaser Zreportlab.pdfbase.ttfontsr Zreportlab.lib.enumsr r r r reportlab.pdfgenr r Zreportlab.graphics.barcoder Zreportlab.graphics.shapesr r r r registerFont setlocaleLC_ALLr r- r, rB r" r" r" r# s* $ &