← Back to branch summary

~vauxoo/addons-vauxoo/gbw

« back to all changes in this revision

Viewing changes to account/report/account_print_overdue.rml

  • Committer: Isaac Lopez
  • Date: 2012-05-08 22:46:41 UTC
  • Revision ID: isaac@vauxoo.com-20120508224641-ge7uo6srn4ift4mq
[ADD][account] account with patch requiered by facturae and digits_compute added on quantity field
[ADD][l10n_mx_invoice_discount] discount module customized GBW

Show diffs side-by-side

added added

removed removed

Lines of Context:
account/report/account_print_overdue.rml
 
1
<?xml version="1.0"?>
 
2
<document filename="Overdue Payments.pdf">
 
3
  <template pageSize="(595.0,842.0)" title="Overdue Payments" author="OpenERP S.A. (sales@openerp.com)" allowSplitting="20">
 
4
    <pageTemplate id="first">
 
5
      <frame id="first" x1="42.0" y1="28.0" width="511" height="786"/>
 
6
    </pageTemplate>
 
7
  </template>
 
8
  <stylesheet>
 
9
    <blockTableStyle id="Standard_Outline">
 
10
      <blockAlignment value="LEFT"/>
 
11
      <blockValign value="TOP"/>
 
12
    </blockTableStyle>
 
13
    <blockTableStyle id="Tableau2">
 
14
      <blockAlignment value="LEFT"/>
 
15
      <blockValign value="TOP"/>
 
16
    </blockTableStyle>
 
17
    <blockTableStyle id="Table1">
 
18
      <blockAlignment value="LEFT"/>
 
19
      <blockValign value="TOP"/>
 
20
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
 
21
      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
 
22
      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
 
23
      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
 
24
      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
 
25
      <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
 
26
      <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
 
27
      <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
 
28
    </blockTableStyle>
 
29
    <blockTableStyle id="Table3">
 
30
      <blockAlignment value="LEFT"/>
 
31
      <blockValign value="TOP"/>
 
32
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
 
33
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
 
34
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
 
35
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
 
36
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
 
37
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="5,-1" stop="5,-1"/>
 
38
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="6,-1" stop="6,-1"/>
 
39
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="7,-1" stop="7,-1"/>
 
40
    </blockTableStyle>
 
41
    <blockTableStyle id="Table2">
 
42
      <blockAlignment value="LEFT"/>
 
43
      <blockValign value="TOP"/>
 
44
      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
 
45
      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
 
46
      <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
 
47
      <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
 
48
      <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
 
49
    </blockTableStyle>
 
50
    <blockTableStyle id="Table4">
 
51
      <blockAlignment value="LEFT"/>
 
52
      <blockValign value="TOP"/>
 
53
      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
 
54
      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
 
55
      <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
 
56
    </blockTableStyle>
 
57
    <initialize>
 
58
      <paraStyle name="all" alignment="justify"/>
 
59
    </initialize>
 
60
    <paraStyle name="Standard" fontName="Helvetica"/>
 
61
    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
62
    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
63
    <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
64
    <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
65
    <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 
66
    <paraStyle name="Index" fontName="Helvetica"/>
 
67
    <paraStyle name="Heading" fontName="Helvetica" fontSize="15.0" leading="19" spaceBefore="12.0" spaceAfter="6.0"/>
 
68
    <paraStyle name="Footer" fontName="Helvetica"/>
 
69
    <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 
70
    <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
71
    <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 
72
    <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
73
    <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
74
    <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
75
    <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
76
    <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
77
    <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
78
    <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
79
    <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
80
    <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
81
    <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
82
    <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
83
    <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 
84
    <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
85
    <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
86
    <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
87
    <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
88
    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
89
    <images/>
 
90
  </stylesheet>
 
91
  <story>
 
92
  <pto>
 
93
  <pto_header>
 
94
    <blockTable colWidths="57.0,136.0,51.0,72.0,54.0,56.0,66.0,18.0" style="Table1">
 
95
      <tr>
 
96
        <td>
 
97
          <para style="terp_tblheader_Details">Date</para>
 
98
        </td>
 
99
        <td>
 
100
          <para style="terp_tblheader_Details">Description</para>
 
101
        </td>
 
102
        <td>
 
103
          <para style="terp_tblheader_Details_Centre">Ref</para>
 
104
        </td>
 
105
        <td>
 
106
          <para style="terp_tblheader_Details_Centre">Maturity date</para>
 
107
        </td>
 
108
        <td>
 
109
          <para style="terp_tblheader_Details_Right">Due</para>
 
110
        </td>
 
111
        <td>
 
112
          <para style="terp_tblheader_Details_Right">Paid</para>
 
113
        </td>
 
114
        <td>
 
115
          <para style="terp_tblheader_Details_Right">Maturity</para>
 
116
        </td>
 
117
        <td>
 
118
          <para style="terp_tblheader_Details_Centre">Li.</para>
 
119
        </td>
 
120
      </tr>
 
121
    </blockTable>
 
122
  </pto_header>
 
123
    <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
 
124
    <para style="terp_default_8">[[ setLang(o.lang) ]]</para>
 
125
    <blockTable colWidths="286.0,224.0" style="Tableau2">
 
126
      <tr>
 
127
        <td>
 
128
          <para style="terp_default_9">[[ repeatIn(adr_get(o, 'invoice'),'addr') ]]</para>
 
129
        </td>
 
130
        <td>
 
131
          <para style="terp_default_9">[[ o.title.name or '' ]] [[ o.name ]]</para>
 
132
          <para style="terp_default_9">[[ addr['street'] ]]</para>
 
133
          <para style="terp_default_9">[[ addr['street2'] or removeParentNode('para') ]]</para>
 
134
          <para style="terp_default_9">[[ addr['zip'] ]] [[ addr['city'] ]]</para>
 
135
          <para style="terp_default_9">[[ addr['state_id'] or removeParentNode('para')]]</para>
 
136
          <para style="terp_default_9">[[ addr['country_id'] ]]</para>
 
137
          <para style="terp_default_9">
 
138
            <font color="white"> </font>
 
139
          </para>
 
140
          <para style="terp_default_9">VAT: [[ o.vat or removeParentNode('para') ]]</para>
 
141
        </td>
 
142
      </tr>
 
143
    </blockTable>
 
144
    <para style="terp_default_8">
 
145
      <font color="white"> </font>
 
146
    </para>
 
147
    <para style="terp_default_8">
 
148
      <font color="white"> </font>
 
149
    </para>
 
150
    <para style="terp_default_9">Document: Customer account statement</para>
 
151
    <para style="terp_default_9">Date: [[ formatLang(time.strftime('%Y-%m-%d'),date=True) ]]</para>
 
152
    <para style="terp_default_9">Customer Ref: [[ o.ref or ' ']]</para>
 
153
    <para style="terp_default_9">
 
154
      <font color="white"> </font>
 
155
    </para>
 
156
    <para style="terp_default_9">Dear Sir/Madam,</para>
 
157
    <para style="terp_default_9">
 
158
      <font color="white"> </font>
 
159
    </para>
 
160
    <para style="terp_default_9">
 
161
      <font color="white"> </font>
 
162
    </para>
 
163
    <para style="terp_default_9">[[ message(o, company) ]]</para>
 
164
    <para style="terp_default_9">
 
165
      <font color="white"> </font>
 
166
    </para>
 
167
    <para style="terp_default_9">Best regards.</para>
 
168
    <para style="terp_default_9">
 
169
      <font color="white"> </font>
 
170
    </para>
 
171
    <blockTable colWidths="57.0,136.0,51.0,72.0,54.0,56.0,66.0,18.0" style="Table1">
 
172
      <tr>
 
173
        <td>
 
174
          <para style="terp_tblheader_Details">Date</para>
 
175
        </td>
 
176
        <td>
 
177
          <para style="terp_tblheader_Details">Description</para>
 
178
        </td>
 
179
        <td>
 
180
          <para style="terp_tblheader_Details_Centre">Ref</para>
 
181
        </td>
 
182
        <td>
 
183
          <para style="terp_tblheader_Details_Centre">Maturity date</para>
 
184
        </td>
 
185
        <td>
 
186
          <para style="terp_tblheader_Details_Right">Due</para>
 
187
        </td>
 
188
        <td>
 
189
          <para style="terp_tblheader_Details_Right">Paid</para>
 
190
        </td>
 
191
        <td>
 
192
          <para style="terp_tblheader_Details_Right">Maturity</para>
 
193
        </td>
 
194
        <td>
 
195
          <para style="terp_tblheader_Details_Centre">Li.</para>
 
196
        </td>
 
197
      </tr>
 
198
    </blockTable>
 
199
    <section>
 
200
      <para style="terp_default_8">[[repeatIn(getLines(o), 'line') ]]</para>
 
201
      <blockTable colWidths="57.0,136.0,52.0,71.0,55.0,56.0,66.0,17.0" style="Table3">
 
202
        <tr>
 
203
          <td>
 
204
            <para style="terp_default_9">[[ formatLang(line['date'],date=True) ]]</para>
 
205
          </td>
 
206
          <td>
 
207
            <para style="terp_default_9">[[ line['name'] ]]</para>
 
208
          </td>
 
209
          <td>
 
210
            <para style="terp_default_Centre_9">[[ line['ref'] ]]</para>
 
211
          </td>
 
212
          <td>
 
213
            <para style="terp_default_Centre_9">[[ line['date_maturity'] and formatLang(line['date_maturity'],date=True) or '' ]]</para>
 
214
          </td>
 
215
          <td>
 
216
            <para style="terp_default_Right_9">[[ (line['account_id']['type'] == 'receivable' and formatLang(line['debit']) or 0) or (line['account_id']['type'] == 'payable' and formatLang(line['credit'] * -1) or ' ') ]] </para>
 
217
          </td>
 
218
          <td>
 
219
            <para style="terp_default_Right_9">[[ (line['account_id']['type'] == 'receivable' and formatLang(line['credit']) or 0) or (line['account_id']['type'] == 'payable' and formatLang(line['debit'] * -1) or 0) ]]</para>
 
220
          </td>
 
221
          <td>
 
222
            <para style="terp_default_Right_9">[[ formatLang((line['date_maturity'] &lt; time.strftime('%Y-%m-%d'))) and formatLang(line['debit'] - line['credit']) ]] [[ company.currency_id.symbol ]]</para>
 
223
          </td>
 
224
          <td>
 
225
            <para style="terp_default_Centre_9">[[ line['blocked'] and 'X' or '' ]]</para>
 
226
          </td>
 
227
        </tr>
 
228
      </blockTable>
 
229
    </section>
 
230
    <blockTable colWidths="245.0,71.0,56.0,56.0,66.0,17.0" style="Table2">
 
231
      <tr>
 
232
        <td>
 
233
          <para style="terp_default_8">
 
234
            <font color="white"> </font>
 
235
          </para>
 
236
        </td>
 
237
        <td>
 
238
          <para style="terp_default_Bold_9">Sub-Total : </para>
 
239
        </td>
 
240
        <td>
 
241
          <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + ((y['account_id']['type'] == 'receivable' and y['debit'] or 0) or (y['account_id']['type'] == 'payable' and y['credit'] * -1 or 0)), getLines(o), 0))) ]] </para>
 
242
        </td>
 
243
        <td>
 
244
          <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + ((y['account_id']['type'] == 'receivable' and y['credit'] or 0) or (y['account_id']['type'] == 'payable' and y['debit'] * -1 or 0)), getLines(o), 0))) ]] </para>
 
245
        </td>
 
246
        <td>
 
247
          <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + (y['debit'] - y['credit']), filter(lambda x: x['date_maturity'] &lt; time.strftime('%Y-%m-%d'), getLines(o)), 0))) ]] [[ company.currency_id.symbol ]]</para>
 
248
        </td>
 
249
        <td>
 
250
          <para style="terp_default_9">
 
251
            <font color="white"> </font>
 
252
          </para>
 
253
        </td>
 
254
      </tr>
 
255
    </blockTable>
 
256
    <blockTable colWidths="250.0,66.0,62.0,131.0" style="Table4">
 
257
      <tr>
 
258
        <td>
 
259
          <para style="terp_default_8">
 
260
            <font color="white"> </font>
 
261
          </para>
 
262
        </td>
 
263
        <td>
 
264
          <para style="terp_default_Bold_9">Balance : </para>
 
265
        </td>
 
266
        <td>
 
267
          <para style="terp_tblheader_Details_Right">[[ formatLang((reduce(lambda x, y: x +(y['debit'] - y['credit']), getLines(o), 0))) ]] [[ company.currency_id.symbol ]]</para>
 
268
        </td>
 
269
        <td>
 
270
          <para style="terp_default_8">
 
271
            <font color="white"> </font>
 
272
          </para>
 
273
        </td>
 
274
      </tr>
 
275
    </blockTable>
 
276
    <para style="terp_default_9">
 
277
      <font color="white"> </font>
 
278
    </para>
 
279
    <para style="terp_default_9">
 
280
      <font color="white"> </font>
 
281
    </para>
 
282
    <para style="terp_default_9">Total amount due: [[ formatLang((reduce(lambda x, y: x + (y['debit'] - y['credit']), getLines(o), 0))) ]] [[ company.currency_id.symbol ]].</para>
 
283
    <para style="terp_default_8">
 
284
      <font color="white"> </font>
 
285
    </para>
 
286
  </pto>
 
287
  </story>
 
288
</document>
 
 
b'\\ No newline at end of file'