2
<document filename="test.pdf">
3
<template pageSize="(595.0,842.0)" title="Test" author="Martin Simon" allowSplitting="20">
4
<pageTemplate id="first">
5
<frame id="first" x1="57.0" y1="57.0" width="481" height="728"/>
9
<blockTableStyle id="Standard_Outline">
10
<blockAlignment value="LEFT"/>
11
<blockValign value="TOP"/>
13
<blockTableStyle id="Tableau1">
14
<blockAlignment value="LEFT"/>
15
<blockValign value="TOP"/>
16
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
17
<lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
18
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
19
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
20
<lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
21
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
22
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
23
<lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
24
<lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
25
<lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
26
<lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
27
<lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
28
<lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
29
<lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
30
<lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
31
<lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
32
<lineStyle kind="LINEAFTER" colorName="#000000" start="5,0" stop="5,-1"/>
33
<lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
34
<lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
35
<blockBackground colorName="#cccccc" start="0,0" stop="0,-1"/>
36
<blockBackground colorName="#cccccc" start="1,0" stop="1,-1"/>
37
<blockBackground colorName="#cccccc" start="2,0" stop="2,-1"/>
38
<blockBackground colorName="#cccccc" start="3,0" stop="3,-1"/>
39
<blockBackground colorName="#cccccc" start="4,0" stop="4,-1"/>
40
<blockBackground colorName="#cccccc" start="5,0" stop="5,-1"/>
42
<blockTableStyle id="Tableau2">
43
<blockAlignment value="LEFT"/>
44
<blockValign value="TOP"/>
45
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
46
<lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
47
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
48
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
49
<lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
50
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
51
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
52
<lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
53
<lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
54
<lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
55
<lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
56
<lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
57
<lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
58
<lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
59
<lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
60
<lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
61
<lineStyle kind="LINEAFTER" colorName="#000000" start="5,0" stop="5,-1"/>
62
<lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
63
<lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
65
<blockTableStyle id="Tableau3">
66
<blockAlignment value="LEFT"/>
67
<blockValign value="TOP"/>
68
<lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
69
<lineStyle kind="LINEAFTER" colorName="#000000" start="4,0" stop="4,-1"/>
70
<lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
71
<lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
72
<lineStyle kind="LINEAFTER" colorName="#000000" start="5,0" stop="5,-1"/>
73
<lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
74
<lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
76
<blockTableStyle id="Tableau4">
77
<blockAlignment value="LEFT"/>
78
<blockValign value="TOP"/>
79
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
80
<lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
81
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
82
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
83
<lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
84
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
85
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
86
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
87
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
88
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
89
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
90
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
91
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,2" stop="0,-1"/>
92
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
93
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,2" stop="1,-1"/>
94
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
95
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,2" stop="2,-1"/>
96
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,3" stop="0,-1"/>
97
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
98
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,3" stop="1,-1"/>
99
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
100
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,3" stop="2,-1"/>
101
<lineStyle kind="LINEBEFORE" colorName="#000000" start="0,4" stop="0,-1"/>
102
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
103
<lineStyle kind="LINEBEFORE" colorName="#000000" start="1,4" stop="1,-1"/>
104
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
105
<lineStyle kind="LINEBEFORE" colorName="#000000" start="2,4" stop="2,-1"/>
108
<paraStyle name="all" alignment="justify"/>
110
<paraStyle name="P1" fontName="Helvetica"/>
111
<paraStyle name="P2" fontName="Helvetica" alignment="RIGHT"/>
112
<paraStyle name="P3" fontName="Helvetica" alignment="CENTER"/>
113
<paraStyle name="P4" fontName="Helvetica-Oblique" alignment="CENTER"/>
114
<paraStyle name="P5" fontName="Helvetica-BoldOblique" alignment="RIGHT"/>
115
<paraStyle name="P6" fontName="Helvetica"/>
116
<paraStyle name="P7" fontName="Helvetica-Bold" fontSize="14.0" leading="17" alignment="CENTER"/>
117
<paraStyle name="P8" fontName="Helvetica" alignment="RIGHT"/>
118
<paraStyle name="P9" fontName="Helvetica-BoldOblique"/>
119
<paraStyle name="Standard" fontName="Times-Roman"/>
120
<paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
121
<paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
122
<paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
123
<paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
124
<paraStyle name="Index" fontName="Times-Roman"/>
125
<paraStyle name="Table Contents" fontName="Times-Roman"/>
126
<paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
130
<para style="P6">[[ repeatIn(objects,'o') ]]</para>
131
<para style="P6">[[ setLang('fr_FR') ]]</para>
132
<para style="P7">Cash Entries Report from [[ data['form']['date_start'] and formatLang(time.strptime(data['form']['date_start'],'%Y-%m-%d'), date=True) or '' ]] to [[ data['form']['date_stop'] and formatLang(time.strptime(data['form']['date_stop'],'%Y-%m-%d'), date=True) or '' ]]</para>
134
<font color="white"> </font>
136
<para style="P9">Balance at [[ data['form']['date_start'] and formatLang(time.strptime(data['form']['date_start'],'%Y-%m-%d'), date=True) or '' ]] : [[ formatLang(get_start_balance()) ]] €</para>
138
<font color="white"> </font>
140
<blockTable colWidths="62.0,45.0,147.0,68.0,79.0,79.0" style="Tableau1">
143
<para style="P1">Date</para>
146
<para style="P1">Number</para>
149
<para style="P1">Name</para>
152
<para style="P1">Reference</para>
155
<para style="P3">Debit</para>
158
<para style="P3">Credit</para>
162
<blockTable colWidths="62.0,45.0,147.0,68.0,79.0,79.0" style="Tableau2">
165
<para style="P4">[[ repeatIn(entries,'e') ]]</para>
166
<para style="P6">[[ formatLang(time.strptime(e.date,'%Y-%m-%d %H:%M:%S'), date=True) ]]</para>
169
<para style="P3">[[ e.number ]]</para>
172
<para style="P1">[[ e.name ]]</para>
175
<para style="P3">[[ e.reference ]]</para>
178
<para style="P2">[[ formatLang(e.debit) ]] €</para>
181
<para style="P2">[[ formatLang(e.credit) ]] €</para>
185
<blockTable colWidths="62.0,45.0,147.0,68.0,79.0,79.0" style="Tableau3">
189
<font color="white"> </font>
194
<font color="white"> </font>
199
<font color="white"> </font>
203
<para style="P5">Total</para>
206
<para style="P8">[[ formatLang(get_sums()[1]) ]] €</para>
209
<para style="P8">[[ formatLang(get_sums()[0]) ]] €</para>
214
<font color="white"> </font>
217
<font color="white"> </font>
220
<font color="white"> </font>
223
<font color="white"> </font>
225
<blockTable colWidths="97.0,105.0,279.0" style="Tableau4">
228
<para style="P6">Credit total</para>
231
<para style="P8">[[ formatLang(get_sums()[0]) ]] €</para>
235
<font color="white"> </font>
241
<para style="P6">Former Balance</para>
244
<para style="P8">[[ formatLang(get_start_balance()) ]] €</para>
248
<font color="white"> </font>
254
<para style="P1">Cumulative total</para>
257
<para style="P8">[[ formatLang(get_sums()[2]) ]] €</para>
261
<font color="white"> </font>
267
<para style="P6">Debit total</para>
270
<para style="P8">[[ formatLang(get_sums()[1]) ]] €</para>
274
<font color="white"> </font>
280
<para style="P1">New Balance</para>
283
<para style="P8">[[ formatLang(get_sums()[3]) ]] €</para>
287
<font color="white"> </font>
293
<font color="white"> </font>