~openerp-commiter/openobject-addons/stable-sja-branch

« back to all changes in this revision

Viewing changes to sale_category/report/sale_category_report.rml

  • Committer: sja-axelor
  • Date: 2009-10-13 09:52:57 UTC
  • Revision ID: suniljagyasi@gmail.com-20091013095257-8u26ww0r20z9y6ey
add

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<?xml version="1.0" ?>
 
2
<document filename="test.pdf">
 
3
        <template allowSplitting="20" author="Martin Simon" pageSize="(595.0,842.0)" title="Test">
 
4
                <pageTemplate id="first">
 
5
                        <frame height="758" id="first" width="527" x1="34.0" y1="42.0"/>
 
6
                </pageTemplate>
 
7
        </template>
 
8
        <stylesheet>
 
9
                <blockTableStyle id="Standard_Outline">
 
10
                        <blockAlignment value="LEFT"/>
 
11
                        <blockValign value="TOP"/>
 
12
                </blockTableStyle>
 
13
                <blockTableStyle id="Tableau1">
 
14
                        <blockAlignment value="LEFT"/>
 
15
                        <blockValign value="TOP"/>
 
16
                </blockTableStyle>
 
17
                <blockTableStyle id="Tableau2">
 
18
                        <blockAlignment value="LEFT"/>
 
19
                        <blockValign value="TOP"/>
 
20
                        <lineStyle colorName="black" kind="GRID"/>
 
21
                        <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
 
22
                        <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
 
23
                        <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
 
24
                        <blockBackground colorName="#e6e6e6" start="3,0" stop="3,0"/>
 
25
                        <blockBackground colorName="#e6e6e6" start="4,0" stop="4,0"/>
 
26
                        <blockBackground colorName="#e6e6e6" start="5,0" stop="5,0"/>
 
27
                        <blockBackground colorName="#e6e6e6" start="6,0" stop="6,0"/>
 
28
                </blockTableStyle>
 
29
                <blockTableStyle id="Tableau3">
 
30
                        <blockAlignment value="LEFT"/>
 
31
                        <blockValign value="TOP"/>
 
32
                </blockTableStyle>
 
33
                <blockTableStyle id="Tableau8">
 
34
                        <blockAlignment value="LEFT"/>
 
35
                        <blockValign value="TOP"/>
 
36
                </blockTableStyle>
 
37
                <blockTableStyle id="Tableau9">
 
38
                        <blockAlignment value="LEFT"/>
 
39
                        <blockValign value="TOP"/>
 
40
                </blockTableStyle>
 
41
                <blockTableStyle id="Tableau4">
 
42
                        <blockAlignment value="LEFT"/>
 
43
                        <blockValign value="TOP"/>
 
44
                </blockTableStyle>
 
45
                <initialize>
 
46
                        <paraStyle alignment="justify" name="all"/>
 
47
                </initialize>
 
48
                <paraStyle fontName="Times-Roman" fontSize="9.0" leading="11" name="P1"/>
 
49
                <paraStyle fontName="Times-Roman" fontSize="8.0" leading="10" name="P2"/>
 
50
                <paraStyle alignment="LEFT" fontName="Times-Roman" fontSize="10.0" leading="13" name="P3"/>
 
51
                <paraStyle alignment="LEFT" fontName="Times-Roman" name="P4"/>
 
52
                <paraStyle alignment="LEFT" fontName="Times-Roman" name="P5"/>
 
53
                <paraStyle fontName="Times-Bold" fontSize="9.0" leading="11" name="P6"/>
 
54
                <paraStyle fontName="Times-Bold" fontSize="9.0" leading="11" name="P7"/>
 
55
                <paraStyle alignment="LEFT" fontName="Times-Roman" fontSize="9.0" leading="11" name="P8"/>
 
56
                <paraStyle alignment="CENTER" fontName="Times-Roman" fontSize="9.0" leading="11" name="P9"/>
 
57
                <paraStyle alignment="RIGHT" fontName="Times-Roman" fontSize="9.0" leading="11" name="P10"/>
 
58
                <paraStyle alignment="LEFT" fontName="Times-Roman" fontSize="9.0" leading="11" name="P11"/>
 
59
                <paraStyle alignment="RIGHT" fontName="Times-Roman" fontSize="9.0" leading="11" name="P12"/>
 
60
                <paraStyle alignment="LEFT" fontName="Times-BoldItalic" fontSize="9.0" leading="11" name="P13"/>
 
61
                <paraStyle alignment="LEFT" fontName="Times-Italic" fontSize="9.0" leading="11" name="P14"/>
 
62
                <paraStyle alignment="RIGHT" fontName="Times-Bold" fontSize="9.0" leading="11" name="P15"/>
 
63
                <paraStyle fontName="Times-Bold" fontSize="9.0" leading="11" name="P16"/>
 
64
                <paraStyle fontName="Times-Roman" fontSize="10.0" leading="13" name="P17"/>
 
65
                <paraStyle fontName="Times-Roman" fontSize="10.0" leading="13" name="P18"/>
 
66
                <paraStyle fontName="Times-Roman" fontSize="4.0" leading="5" name="P19"/>
 
67
                <paraStyle fontName="Times-Roman" fontSize="4.0" leading="5" name="P20"/>
 
68
                <paraStyle fontName="Times-Roman" fontSize="11.0" leading="14" name="P21"/>
 
69
                <paraStyle fontName="Times-Roman" fontSize="11.0" leading="14" name="P22"/>
 
70
                <paraStyle fontName="Times-Roman" fontSize="16.0" leading="20" name="P23"/>
 
71
                <paraStyle fontName="Times-Bold" fontSize="8.0" leading="10" name="P24"/>
 
72
                <paraStyle alignment="CENTER" fontName="Times-Bold" fontSize="8.0" leading="10" name="P25"/>
 
73
                <paraStyle alignment="LEFT" fontName="Times-BoldItalic" fontSize="6.0" leading="8" name="P26"/>
 
74
                <paraStyle alignment="LEFT" fontName="Times-Bold" fontSize="12.0" leading="15" name="P27"/>
 
75
                <paraStyle fontName="Times-Roman" fontSize="7.0" leading="9" name="P28"/>
 
76
                <paraStyle fontName="Times-Roman" fontSize="11.0" leading="14" name="P29"/>
 
77
                <paraStyle fontName="Times-Roman" fontSize="7.0" leading="9" name="P30"/>
 
78
                <paraStyle alignment="RIGHT" fontName="Times-Bold" fontSize="9.0" leading="11" name="P31"/>
 
79
                <paraStyle fontName="Times-Roman" name="Standard"/>
 
80
                <paraStyle fontName="Times-Roman" name="Text body" spaceAfter="6.0" spaceBefore="0.0"/>
 
81
                <paraStyle fontName="Helvetica" fontSize="14.0" leading="17" name="Heading" spaceAfter="6.0" spaceBefore="12.0"/>
 
82
                <paraStyle fontName="Times-Roman" name="List" spaceAfter="6.0" spaceBefore="0.0"/>
 
83
                <paraStyle fontName="Times-Roman" name="Table Contents"/>
 
84
                <paraStyle alignment="CENTER" fontName="Times-Roman" name="Table Heading"/>
 
85
                <paraStyle fontName="Times-Roman" fontSize="12.0" leading="15" name="Caption" spaceAfter="6.0" spaceBefore="6.0"/>
 
86
                <paraStyle fontName="Times-Roman" name="Index"/>
 
87
        </stylesheet>
 
88
        <images/>
 
89
        <story>
 
90
                <para style="P1">
 
91
                        [[ repeatIn(objects,'o') ]] 
 
92
                        <font face="Times-Roman">
 
93
                                [[ setLang(o.partner_id.lang) ]]
 
94
                        </font>
 
95
                </para>
 
96
                <blockTable colWidths="257.0,50.0,220.0" style="Tableau1">
 
97
                        <tr>
 
98
                                <td>
 
99
                                        <para style="P6">
 
100
                                                Shipping address :
 
101
                                        </para>
 
102
                                        <para style="P17">
 
103
                                                [[ o.partner_id.title or '' ]] [[ o.partner_id.name ]]
 
104
                                        </para>
 
105
                                        <para style="P17">
 
106
                                                [[ o.partner_shipping_id.title or '' ]] [[ o.partner_shipping_id.name ]]
 
107
                                        </para>
 
108
                                        <para style="P17">
 
109
                                                [[ o.partner_shipping_id.street ]]
 
110
                                        </para>
 
111
                                        <para style="P17">
 
112
                                                [[ o.partner_shipping_id.street2 or '' ]]
 
113
                                        </para>
 
114
                                        <para style="P18">
 
115
                                                <font face="Times-Roman">
 
116
                                                        [[ o.partner_shipping_id.zip or '' ]]
 
117
                                                </font>
 
118
                                                 [[ o.partner_shipping_id.city or '' ]]
 
119
                                        </para>
 
120
                                        <para style="P18">
 
121
                                                [[ o.partner_shipping_id.state_id and o.partner_shipping_id.state_id.name or '' ]]
 
122
                                        </para>
 
123
                                        <para style="P18">
 
124
                                                [[ o.partner_shipping_id.country_id and o.partner_shipping_id.country_id.name or '' ]]
 
125
                                        </para>
 
126
                                        <para style="P19">
 
127
                                                <font color="white">
 
128
                                                         
 
129
                                                </font>
 
130
                                        </para>
 
131
                                        <para style="P7">
 
132
                                                Invoice address :
 
133
                                        </para>
 
134
                                        <para style="P18">
 
135
                                                [[ o.partner_invoice_id.street ]][[ o.partner_invoice_id.street2 and ', %s' % o.partner_invoice_id.street2 or '' ]]
 
136
                                        </para>
 
137
                                        <para style="P18">
 
138
                                                [[ o.partner_invoice_id.zip or '' ]] [[ o.partner_invoice_id.city or '' ]] [[ ', %s' % (o.partner_invoice_id.country_id and o.partner_invoice_id.country_id.name or '') ]]
 
139
                                        </para>
 
140
                                </td>
 
141
                                <td>
 
142
                                        <para style="P21">
 
143
                                                <font color="white">
 
144
                                                         
 
145
                                                </font>
 
146
                                        </para>
 
147
                                </td>
 
148
                                <td>
 
149
                                        <para style="P22">
 
150
                                                [[ o.partner_id.title or '' ]] [[ o.partner_id.name ]]
 
151
                                        </para>
 
152
                                        <para style="P22">
 
153
                                                [[ o.partner_order_id.title or '' ]] [[ o.partner_order_id.name ]]
 
154
                                        </para>
 
155
                                        <para style="P22">
 
156
                                                [[ o.partner_order_id.street ]]
 
157
                                        </para>
 
158
                                        <para style="P22">
 
159
                                                [[ o.partner_order_id.street2 or '' ]]
 
160
                                        </para>
 
161
                                        <para style="P22">
 
162
                                                [[ o.partner_order_id.zip or '' ]] [[ o.partner_order_id.city or '' ]]
 
163
                                        </para>
 
164
                                        <para style="P22">
 
165
                                                [[ o.partner_order_id.state_id and o.partner_order_id.state_id.name or '' ]]
 
166
                                        </para>
 
167
                                        <para style="P22">
 
168
                                                [[ o.partner_order_id.country_id and o.partner_order_id.country_id.name or '' ]]
 
169
                                        </para>
 
170
                                        <para style="P20">
 
171
                                                <font color="white">
 
172
                                                         
 
173
                                                </font>
 
174
                                        </para>
 
175
                                        <para style="P17">
 
176
                                                Tél. : [[ o.partner_order_id.phone or removeParentNode('para') ]]
 
177
                                        </para>
 
178
                                        <para style="P17">
 
179
                                                Fax : [[ o.partner_order_id.fax or removeParentNode('para') ]]
 
180
                                        </para>
 
181
                                        <para style="P17">
 
182
                                                TVA : [[ o.partner_id.vat or removeParentNode('para') ]]
 
183
                                        </para>
 
184
                                </td>
 
185
                        </tr>
 
186
                </blockTable>
 
187
                <para style="P2">
 
188
                        <font color="white">
 
189
                                 
 
190
                        </font>
 
191
                </para>
 
192
                <para style="P23">
 
193
                        [[ o.state=='draft' and 'Quotation ' or 'Order ' ]] N° : [[ o.name ]]
 
194
                </para>
 
195
                <para style="P17">
 
196
                        <font color="white">
 
197
                                 
 
198
                        </font>
 
199
                </para>
 
200
                <para style="P29">
 
201
                        Your order reference : [[ o.client_order_ref or '' ]]
 
202
                </para>
 
203
                <para style="P29">
 
204
                        Date ordered : [[ time.strftime('%d/%m/%Y', time.strptime(o.date_order, '%Y-%m-%d')) ]]
 
205
                </para>
 
206
                <para style="P29">
 
207
                        Our salesman : [[ o.user_id.name ]]
 
208
                </para>
 
209
                <para style="P3">
 
210
                        [[ o.topnotes or '' ]] 
 
211
                </para>
 
212
                <blockTable colWidths="218.0,66.0,50.0,57.0,28.0,54.0,55.0" repeatRows="1" style="Tableau2">
 
213
                        <tr>
 
214
                                <td>
 
215
                                        <para style="P24">
 
216
                                                Product Description
 
217
                                        </para>
 
218
                                </td>
 
219
                                <td>
 
220
                                        <para style="P25">
 
221
                                                Applicable Taxes
 
222
                                        </para>
 
223
                                </td>
 
224
                                <td>
 
225
                                        <para style="P24">
 
226
                                                Date Promised
 
227
                                        </para>
 
228
                                </td>
 
229
                                <td>
 
230
                                        <para style="P24">
 
231
                                                Qty
 
232
                                        </para>
 
233
                                </td>
 
234
                                <td>
 
235
                                        <para style="P24">
 
236
                                                Disc.
 
237
                                        </para>
 
238
                                </td>
 
239
                                <td>
 
240
                                        <para style="P24">
 
241
                                                Unit Price
 
242
                                        </para>
 
243
                                </td>
 
244
                                <td>
 
245
                                        <para style="P24">
 
246
                                                Net Price
 
247
                                        </para>
 
248
                                </td>
 
249
                        </tr>
 
250
                </blockTable>
 
251
                <section>
 
252
                        <para style="P26">
 
253
                                [[repeatIn(order_lines_by_categ(o), 'cat')]]
 
254
                        </para>
 
255
                        <para style="P27">
 
256
                                [[cat[0][1] ]]
 
257
                        </para>
 
258
                        <section>
 
259
                                <para style="P26">
 
260
                                        [[ repeatIn(cat[1],'line') ]]
 
261
                                </para>
 
262
                                <blockTable colWidths="219.0,66.0,49.0,57.0,28.0,53.0,55.0" style="Tableau3">
 
263
                                        <tr>
 
264
                                                <td>
 
265
                                                        <para style="P8">
 
266
                                                                [[ line.name ]]
 
267
                                                        </para>
 
268
                                                </td>
 
269
                                                <td>
 
270
                                                        <para style="P9">
 
271
                                                                [[ ', '.join(map(lambda x: x.name, line.tax_id))]]
 
272
                                                        </para>
 
273
                                                </td>
 
274
                                                <td>
 
275
                                                        <para style="P9">
 
276
                                                                [[ time.strftime('%d/%m/%Y', time.strptime( line.date_planned, '%Y-%m-%d')) ]]
 
277
                                                        </para>
 
278
                                                </td>
 
279
                                                <td>
 
280
                                                        <para style="P11">
 
281
                                                                [[ line.product_uom_qty ]] [[ line.product_uom.name ]]
 
282
                                                        </para>
 
283
                                                </td>
 
284
                                                <td>
 
285
                                                        <para style="P8">
 
286
                                                                [[ (line.discount and str(line.discount)+'%')or '' ]]
 
287
                                                        </para>
 
288
                                                </td>
 
289
                                                <td>
 
290
                                                        <para style="P12">
 
291
                                                                [[ '%.2f' % line.price_unit ]]
 
292
                                                        </para>
 
293
                                                </td>
 
294
                                                <td>
 
295
                                                        <para style="P10">
 
296
                                                                [[ '%.2f' % line.price_subtotal ]]
 
297
                                                        </para>
 
298
                                                </td>
 
299
                                        </tr>
 
300
                                </blockTable>
 
301
                                <para style="P26">
 
302
                                        <font color="white">
 
303
                                                 
 
304
                                        </font>
 
305
                                </para>
 
306
                        </section>
 
307
                        <blockTable colWidths="52.0,366.0,110.0" style="Tableau8">
 
308
                                <tr>
 
309
                                        <td>
 
310
                                                <para style="P13">
 
311
                                                        [[ repeatIn((line.notes and [line.notes]) or [], 'l') ]]
 
312
                                                </para>
 
313
                                                <para style="P13">
 
314
                                                        [[ l or removeParentNode('blockTable') ]]
 
315
                                                </para>
 
316
                                        </td>
 
317
                                        <td>
 
318
                                                <para style="P14">
 
319
                                                        [[ l ]] [[ setTag('para','xpre') ]]
 
320
                                                </para>
 
321
                                        </td>
 
322
                                        <td>
 
323
                                                <para style="P13">
 
324
                                                        <font color="white">
 
325
                                                                 
 
326
                                                        </font>
 
327
                                                </para>
 
328
                                        </td>
 
329
                                </tr>
 
330
                        </blockTable>
 
331
                </section>
 
332
                <blockTable colWidths="348.0,69.0,110.0" style="Tableau9">
 
333
                        <tr>
 
334
                                <td>
 
335
                                        <para style="P30">
 
336
                                                <font color="white">
 
337
                                                         
 
338
                                                </font>
 
339
                                        </para>
 
340
                                </td>
 
341
                                <td>
 
342
                                        <para style="P31">
 
343
                                                Net Total :
 
344
                                        </para>
 
345
                                </td>
 
346
                                <td>
 
347
                                        <para style="P31">
 
348
                                                [[ '%.2f' % o.amount_untaxed ]] [[ o.pricelist_id.currency_id.name ]]
 
349
                                        </para>
 
350
                                </td>
 
351
                        </tr>
 
352
                        <tr>
 
353
                                <td>
 
354
                                        <para style="P30">
 
355
                                                <font color="white">
 
356
                                                         
 
357
                                                </font>
 
358
                                        </para>
 
359
                                </td>
 
360
                                <td>
 
361
                                        <para style="P31">
 
362
                                                Taxes :
 
363
                                        </para>
 
364
                                </td>
 
365
                                <td>
 
366
                                        <para style="P31">
 
367
                                                [[ '%.2f' % o.amount_tax ]] [[ o.pricelist_id.currency_id.name ]]
 
368
                                        </para>
 
369
                                </td>
 
370
                        </tr>
 
371
                        <tr>
 
372
                                <td>
 
373
                                        <para style="P28">
 
374
                                                <font color="white">
 
375
                                                         
 
376
                                                </font>
 
377
                                        </para>
 
378
                                </td>
 
379
                                <td>
 
380
                                        <para style="P15">
 
381
                                                TOTAL :
 
382
                                        </para>
 
383
                                </td>
 
384
                                <td>
 
385
                                        <para style="P15">
 
386
                                                [[ '%.2f' % o.amount_total ]] [[ o.pricelist_id.currency_id.name ]]
 
387
                                        </para>
 
388
                                </td>
 
389
                        </tr>
 
390
                </blockTable>
 
391
                <para style="P16">
 
392
                        <font color="white">
 
393
                                 
 
394
                        </font>
 
395
                </para>
 
396
                <para style="P16">
 
397
                        <font color="white">
 
398
                                 
 
399
                        </font>
 
400
                </para>
 
401
                <blockTable colWidths="527.0" style="Tableau4">
 
402
                        <tr>
 
403
                                <td>
 
404
                                        <para style="P4">
 
405
                                                [[ format(o.note or '') ]]
 
406
                                        </para>
 
407
                                </td>
 
408
                        </tr>
 
409
                        <tr>
 
410
                                <td>
 
411
                                        <para style="P4">
 
412
                                                [[ format((o.partner_id.property_payment_term and o.partner_id.property_payment_term[1]) or '') ]]
 
413
                                        </para>
 
414
                                </td>
 
415
                        </tr>
 
416
                </blockTable>
 
417
                <para style="P5">
 
418
                        <font color="white">
 
419
                                 
 
420
                        </font>
 
421
                </para>
 
422
        </story>
 
423
</document>