← Back to branch summary

~vauxoo/addons-vauxoo/6.0-trunk

« back to all changes in this revision

Viewing changes to aging_due_report/report/detail_due_report.rml

  • Committer: moylop260
  • Date: 2012-09-08 02:03:25 UTC
  • Revision ID: moylop260@vauxoo.com-20120908020325-h5yurx5rqkc1ml6w
[ADD] [account_analytic_btree] Add module account_analytic_btree

Show diffs side-by-side

added added

removed removed

Lines of Context:
aging_due_report/report/detail_due_report.rml
 
1
<?xml version="1.0"?>
 
2
<document filename="test.pdf">
 
3
  <template pageSize="(280.0mm,220.0mm)" title="Test" author="Humberto Arocha" allowSplitting="20" showBoundary="0">
 
4
    <pageTemplate id="first">
 
5
        <pageGraphics>
 
6
            <setFont name="Helvetica-Oblique" size="8.0"/>
 
7
            <image x="10.0mm" y="195.0mm"  width="89.994mm" height="24.342mm">[[company.logo and company.logo or removeParentNode('image')]]</image>
 
8
            <drawString x="10mm" y="5mm">Reporte Impreso en OpenERP con ReportLab</drawString> 
 
9
            <drawRightString x="270mm" y="5mm">Fecha de Impresion:  [[formatLang(time.strftime('%Y-%m-%d'),date=True)]] [[time.strftime('%H:%m')]] / Pagina:<pageNumber/> </drawRightString> 
 
10
        </pageGraphics>
 
11
      <frame id="first"     x1="10.0mm"     y1="10mm"    width="260mm"  height="185.0mm"/>
 
12
    </pageTemplate>
 
13
  </template>
 
14
 
 
15
  <stylesheet>
 
16
                <blockTableStyle id="TITLE">
 
17
            <blockBackground colorName="black" start="1,0" stop="-1,-1"/>
 
18
            <blockValign value="TOP"/>
 
19
                </blockTableStyle>     
 
20
 
 
21
                <blockTableStyle id="TERMS">
 
22
            <blockBackground colorName="#a41d35ff" start="0,0" stop="-1,0"/>
 
23
            <blockValign value="TOP"/>
 
24
                        <lineStyle kind="GRID" colorName="white" start="0,0" stop="-1,0" thickness="0.5"/>
 
25
                        <lineStyle kind="GRID" colorName="#a41d35ff" start="0,1" stop="-1,-1" thickness="0.5"/>
 
26
                        <lineStyle kind="OUTLINE" colorName="#a41d35ff" thickness="0.5"/>
 
27
                </blockTableStyle>
 
28
        
 
29
                <blockTableStyle id="TERMSTABLEGREY">
 
30
            <blockBackground colorName="lightgrey" start="0,0" stop="-1,0"/>
 
31
            <blockValign value="TOP"/>
 
32
                        <lineStyle kind="GRID" colorName="#a41d35ff" start="0,0" stop="-1,0" thickness="0.5"/>
 
33
                        <lineStyle kind="GRID" colorName="#a41d35ff" start="0,1" stop="-1,-1" thickness="0.5"/>
 
34
                        <lineStyle kind="OUTLINE" colorName="#a41d35ff" thickness="0.5"/>
 
35
                </blockTableStyle>  
 
36
 
 
37
                <blockTableStyle id="ITEMSTITLE">
 
38
            <blockBackground colorName="black" start="0,0" stop="5,0"/>
 
39
            <blockValign value="TOP"/>
 
40
                        <lineStyle kind="GRID" colorName="white" start="0,0" stop="5,0" thickness="0.5"/>
 
41
                        <lineStyle kind="OUTLINE" colorName="black" thickness="0.5"/>
 
42
                </blockTableStyle>          
 
43
 
 
44
                <blockTableStyle id="ITEMS">
 
45
            <blockValign value="TOP"/>
 
46
                        <lineStyle kind="GRID" colorName="#4bacc6ff" start="0,0" stop="5,-1" thickness="0.5" />
 
47
                        <lineStyle kind="OUTLINE" colorName="black" thickness="0.5"/>
 
48
                </blockTableStyle>           
 
49
 
 
50
                <blockTableStyle id="TOTAL">
 
51
            <blockValign value="TOP"/>
 
52
            <blockBackground colorName="#d5eff9ff" start="0,0" stop="-1,-1"/>
 
53
                        <lineStyle kind="GRID" colorName="#4bacc6ff" start="0,0" stop="-1,-1" thickness="0.5" />
 
54
                </blockTableStyle>          
 
55
 
 
56
    <initialize>
 
57
      <paraStyle name="all" alignment="JUSTIFY" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="blue"/>
 
58
    </initialize>
 
59
    
 
60
    <paraStyle name="COMPANYNAME" alignment="LEFT" fontName="Helvetica-Bold" fontSize="16.0" leading="10" spaceBefore="3.0" textColor="black"/>    
 
61
    <paraStyle name="TITLE" alignment="CENTER" fontName="Helvetica" fontSize="10.0" leading="8" spaceBefore="3.0" textColor="white"/>
 
62
    <paraStyle name="CUSTOMERNAME" alignment="RIGHT" fontName="Helvetica-Oblique" fontSize="10.0" leading="12" spaceBefore="3.0" textColor="black"/>    
 
63
    <paraStyle name="CUSTOMERCENTER" alignment="CENTER" fontName="Times-BoldItalic" fontSize="10.0" leading="12" spaceBefore="3.0" textColor="black"/>    
 
64
    <paraStyle name="CUSTOMERTEXT" alignment="JUSTIFY" fontName="Times-BoldItalic" fontSize="10.0" leading="12" spaceBefore="3.0" textColor="black"/>    
 
65
    <paraStyle name="NOTEANDNUMBER" alignment="JUSTIFY" fontName="Helvetica" fontSize="10.0" leading="12" spaceBefore="3.0" textColor="darkblue"/>    
 
66
    <paraStyle name="BILLTO" alignment="LEFT" fontName="Helvetica-Bold" fontSize="8.0" leading="10" spaceBefore="3.0" textColor="white"/>    
 
67
    <paraStyle name="TERMS" alignment="CENTER" fontName="Helvetica-Bold" fontSize="8.0" leading="12" spaceBefore="3.0" textColor="white"/>
 
68
    <paraStyle name="ITEMSTITLELEFT" alignment="LEFT" fontName="Helvetica-Bold" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="white"/>    
 
69
    <paraStyle name="ITEMSTITLE" alignment="CENTER" fontName="Helvetica-Bold" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="white"/>    
 
70
    <paraStyle name="ITEMSTITLERIGHT" alignment="RIGHT" fontName="Helvetica-Bold" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="white"/>    
 
71
    <paraStyle name="ITEMSLEFT" alignment="LEFT" fontName="Helvetica-Bold" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="black"/>    
 
72
    <paraStyle name="ITEMSCENTER" alignment="CENTER" fontName="Helvetica-Bold" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="black"/>    
 
73
    <paraStyle name="ITEMSRIGHT" alignment="RIGHT" fontName="Helvetica-Bold" fontSize="6.0" leading="8" spaceBefore="3.0" textColor="black"/>    
 
74
 
 
75
 
 
76
  </stylesheet>
 
77
 
 
78
  <images/>
 
79
  <story>
 
80
<!--TABLA DE ITEMS-->   
 
81
    <section>
 
82
    <para>[[repeatIn(get_invoice_by_partner(objects),'o')]]</para>
 
83
    <para>[[ setLang(o.lang) ]]</para>
 
84
        <blockTable colWidths="35mm,97mm,80mm,60mm" style="TERMSTABLEGREY">
 
85
            <tr>
 
86
                <td><para style="ITEMSLEFT">[['%s-%s-%s'%(o.get('rp_brw').vat[2],o.get('rp_brw').vat[3:-1],o.get('rp_brw').vat[-1])]]</para></td>
 
87
                <td><para style="ITEMSLEFT">[[o.get('rp_brw').name]]</para></td>
 
88
                <td><para style="ITEMSLEFT">[[o.get('rp_brw').ref]]</para></td>
 
89
                <td><para style="ITEMSLEFT">[[o.get('rp_brw').user_id.name]]</para></td>
 
90
            </tr>
 
91
        </blockTable>
 
92
        <blockTable colWidths="35mm,20mm,20mm,17mm,20mm,20mm,20mm,20mm,20mm,20mm,20mm,20mm,20mm" repeatRows="1" style="TERMS">
 
93
            <tr noRowsplits="1">
 
94
                <td><para style="ITEMSTITLELEFT">FACTURA</para></td>
 
95
                <td><para style="ITEMSTITLELEFT">F/EMISION</para></td>
 
96
                <td><para style="ITEMSTITLELEFT">F/VENC.</para></td>
 
97
                <td><para style="ITEMSTITLERIGHT">DIAS/VENC.</para></td>
 
98
                <td><para style="ITEMSTITLERIGHT">BASE IMP.</para></td>
 
99
                <td><para style="ITEMSTITLERIGHT">IMP.</para></td>
 
100
                <td><para style="ITEMSTITLERIGHT">TOT/FACT.</para></td>
 
101
                <td><para style="ITEMSTITLERIGHT">RET.IVA.</para></td>
 
102
                <td><para style="ITEMSTITLERIGHT">RET.ISLR.</para></td>
 
103
                <td><para style="ITEMSTITLERIGHT">RET.MUN.</para></td>
 
104
                <td><para style="ITEMSTITLERIGHT">N/C</para></td>
 
105
                <td><para style="ITEMSTITLERIGHT">ABONO</para></td>
 
106
                <td><para style="ITEMSTITLERIGHT">SALDO</para></td>
 
107
            </tr>
 
108
        
 
109
            <tr>
 
110
                <td>
 
111
                    <para style="ITEMSLEFT">[[repeatIn(o['inv_ids'],'inv')]][[inv['inv_brw'].number]]</para>
 
112
                </td>
 
113
                <td><para style="ITEMSLEFT">[[ formatLang(inv['inv_brw'].date_invoice,date=True) ]]</para></td>
 
114
                <td><para style="ITEMSLEFT">[[ formatLang(inv['inv_brw'].date_due,date=True) ]]</para></td>
 
115
                <td><para style="ITEMSRIGHT">[[ inv.get('due_days') and '%s DIAS'%inv.get('due_days') or '0 DIAS' ]]</para></td>
 
116
                <td><para style="ITEMSRIGHT">[[ formatLang(inv['inv_brw'].amount_untaxed) or '0.00']]</para></td>
 
117
                <td><para style="ITEMSRIGHT">[[ formatLang(inv['inv_brw'].amount_tax) or '0.00']]</para></td>
 
118
                <td><para style="ITEMSRIGHT">[[ formatLang(inv['inv_brw'].amount_total) or '0.00']]</para></td>
 
119
                <td><para style="ITEMSRIGHT">[[ formatLang(inv.get('wh_vat')) or '0.00']]</para></td>
 
120
                <td><para style="ITEMSRIGHT">[[ formatLang(inv.get('wh_islr')) or '0.00']]</para></td>
 
121
                <td><para style="ITEMSRIGHT">[[ formatLang(inv.get('wh_muni')) or '0.00']]</para></td>
 
122
                <td><para style="ITEMSRIGHT">[[ formatLang(inv.get('credit_note')) or '0.00']]</para></td>
 
123
                <td><para style="ITEMSRIGHT">[[ formatLang(inv.get('payment_left')) or '0.00']]</para></td>
 
124
                <td><para style="ITEMSRIGHT">[[ formatLang(inv.get('residual')) or '0.00']]</para></td>
 
125
            </tr>
 
126
        </blockTable>
 
127
<!--TABLA DE TOTALES-->       
 
128
        <blockTable colWidths="132mm,20mm,20mm,20mm,20mm,20mm,20mm,20mm"  style="TERMSTABLEGREY">
 
129
                <tr>
 
130
                    <td><para style="ITEMSRIGHT">TOTAL</para></td>
 
131
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('inv_total')) or '0.00']]</para></td>
 
132
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('wh_vat')) or '0.00']]</para></td>
 
133
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('wh_islr')) or '0.00']]</para></td>
 
134
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('wh_muni')) or '0.00']]</para></td>
 
135
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('credit_note')) or '0.00']]</para></td>
 
136
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('pay_left_total')) or '0.00']]</para></td>
 
137
                    <td><para style="ITEMSRIGHT">[[ formatLang(o.get('due_total')) or '0.00']]</para></td>
 
138
                </tr>
 
139
        </blockTable>
 
140
    <spacer length="5mm"/>
 
141
    </section>
 
142
    <section>
 
143
        <para>[[repeatIn(get_total_by_comercial(objects),'p')]]</para>
 
144
        <blockTable colWidths="252mm,20mm" style="TERMSTABLEGREY">
 
145
            <tr noRowsplits="1">
 
146
                <td><para style="ITEMSRIGHT">TOTAL ESTE REPORTE</para></td>
 
147
                <td><para style="ITEMSRIGHT">[[ formatLang(p['total']) or '0.00']]</para></td>
 
148
            </tr>
 
149
        </blockTable>
 
150
        <blockTable colWidths="252mm,20mm" style="TERMSTABLEGREY">
 
151
            <tr>
 
152
                <td><para style="ITEMSRIGHT">[[repeatIn(p.get('vendor'),'vnd')]][[ vnd.get('usr_brw') and vnd.get('usr_brw').name or 'SIN ASESOR' ]]</para></td>
 
153
                <td><para style="ITEMSRIGHT">[[ formatLang(vnd.get('total')) or '0.00' ]]</para></td>
 
154
            </tr>
 
155
        </blockTable>
 
156
    </section>
 
157
  </story>
 
158
</document>