← Back to branch summary

~openerp-commiter/openobject-addons/extra-6.0

« back to all changes in this revision

Viewing changes to account_financial_report/report/general_ledger_landscape.rml

  • Committer: Borja L.S.
  • Date: 2010-04-07 17:17:06 UTC
  • mto: This revision was merged to the branch mainline in revision 4498.
  • Revision ID: borjals@pexego.es-20100407171706-bdyhd0essc5237g2
[ADD] account_financial_report: Added the module from the 5.0 extra-addons.

  This module from the 5.0 extra-addons was missing on the 
  trunk extra-addons branch.
 
  We have just tested that it works with the 5.2 version.

  The module adds some extra financial/accounting reports:
  * Account chart list
  * Invoice list
  * Account move (journal ledger)
  * Account move line
  * Account balance compared period-fiscal year
  * Cumulative general ledger

Show diffs side-by-side

added added

removed removed

Lines of Context:
account_financial_report/report/general_ledger_landscape.rml
 
1
<?xml version="1.0"?>
 
2
<document filename="test.pdf">
 
3
   <template pageSize="(1120.0,770.0)" title="Test" author="Martin Simon" allowSplitting="20" >
 
4
    <pageTemplate id="first">
 
5
      <frame id="first" x1="22.0" y1="31.0" width="1080" height="680"/>
 
6
                        <pageGraphics>
 
7
                                <!--logo-->
 
8
                                <!--<fill color="darkblue"/>-->
 
9
                                <!--<stroke color="darkblue"/>-->
 
10
 
 
11
                                <!--TITLE COMPANY-->
 
12
                                <!-- <drawString x="4.6cm" y="28.7cm">[[ company.partner_id.name ]]</drawString> -->
 
13
 
 
14
                                <setFont name="Helvetica-Bold" size="9"/>
 
15
 
 
16
                                <!--COL 1-->
 
17
                                <drawString x="1.3cm" y="25.50cm">[[ company.name ]]</drawString>
 
18
                                <drawString x="35.00cm" y="25.50cm">General Ledger - [[ company.currency_id.name ]]</drawString>
 
19
 
 
20
                                <!--COL 2-->
 
21
                                <setFont name="Helvetica" size="9"/>
 
22
                                <drawString x="1.3cm" y="0.90cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString>
 
23
                                <drawString x="37.20cm" y="0.90cm">Page <pageNumber/></drawString>
 
24
 
 
25
                                <!--<drawRightString x="19.8cm" y="28cm">[[ company.rml_header1 ]]</drawRightString>-->
 
26
 
 
27
                            <lineMode width="0.7"/>
 
28
                                <lines>1.3cm 24.9cm 38.3cm 24.9cm</lines>
 
29
                                <setFont name="Helvetica" size="8"/>
 
30
                            </pageGraphics>
 
31
 
 
32
    </pageTemplate>
 
33
  </template>
 
34
   <stylesheet>
 
35
 
 
36
    <blockTableStyle id="tbl_header">
 
37
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 
38
      <blockValign value="TOP"/>
 
39
      <blockTopPadding length="2.0"/>
 
40
      <blockBottomPadding length="0.0"/>
 
41
    </blockTableStyle>
 
42
 
 
43
    <blockTableStyle id="tbl_content">
 
44
      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,1" stop="-1,-1"/>
 
45
      <blockValign value="TOP"/>
 
46
      <blockTopPadding length="2.0"/>
 
47
      <blockBottomPadding length="0.0"/>
 
48
    </blockTableStyle>
 
49
 
 
50
    <blockTableStyle id="Table5">
 
51
      <blockAlignment value="LEFT"/>
 
52
      <lineStyle kind="LINEBELOW" colorName="#777777" start="0,0" stop="0,0"/>
 
53
      <blockValign value="TOP"/>
 
54
    </blockTableStyle>
 
55
 
 
56
    <initialize>
 
57
      <paraStyle name="all" alignment="justify"/>
 
58
    </initialize>
 
59
    <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
60
    <paraStyle name="P2" fontName="Helvetica" fontSize="8.3" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
61
    <paraStyle name="date" fontName="Helvetica" fontSize="8.3" leading="10" spaceBefore="0.0" spaceAfter="6.0" alignment="CENTER"/>
 
62
    <paraStyle name="P2_content" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
63
    <paraStyle name="P3" fontName="Helvetica" fontSize="8.3" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
64
    <paraStyle name="P3_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
65
    <paraStyle name="P4" fontName="Helvetica" fontSize="8.3" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
66
    <paraStyle name="P4_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
67
    <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
68
    <paraStyle name="P6" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
69
    <paraStyle name="P7" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
70
    <paraStyle name="P8" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
71
    <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
72
    <paraStyle name="P9b" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
73
    <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 
74
    <paraStyle name="P11" fontName="Helvetica" fontSize="11.0" leading="14"/>
 
75
    <paraStyle name="P12" fontName="Helvetica" fontSize="14.0" leading="17"/>
 
76
    <paraStyle name="P13" fontName="Helvetica-Bold" fontSize="10.0" leading="8" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
77
    <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
78
    <paraStyle name="P15" fontName="Helvetica-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 
79
    <paraStyle name="P16" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Roman" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
80
    <paraStyle name="P17" fontName="Helvetica" alignment="LEFT" fontSize="12.0"  spaceAfter="0.0"/>
 
81
    <paraStyle name="Standard" fontName="Helvetica-Bold" fontSize="8.5"/>
 
82
    <paraStyle name="Account" fontName="Helvetica"/>
 
83
    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
84
    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
85
    <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
86
    <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
87
    <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 
88
    <paraStyle name="Index" fontName="Helvetica"/>
 
89
  </stylesheet>
 
90
  <story>
 
91
    <para style="P2">[[setLang(user.context_lang)]]</para>
 
92
    <blockTable colWidths="1000.0" repeatRows="1">
 
93
      <tr>
 
94
        <td>
 
95
                  <para style="P15">Fiscal year: [[ get_fiscalyear(data['form']) or removeParentNode('para') ]]</para>
 
96
          <para style="Standard">Periods/Date range: [[ get_periods(data['form']) or removeParentNode('para') ]]</para>
 
97
        </td>
 
98
      </tr>
 
99
    </blockTable>
 
100
 
 
101
    <para>[[ repeatIn(objects, 'a') ]]</para>
 
102
  
 
103
     <blockTable colWidths="60.0,60.0,50.0,150.0,150.0,266.0,50.0,68.0,68.0,69.0,58.0" style="tbl_header" repeatRows="1">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 
104
       <tr>
 
105
          <td><para style="P12"><font color="white"> </font></para><para style="date">Date</para></td>
 
106
          <td><para style="P12"><font color="white"> </font></para><para style="P2">Mvt</para></td>
 
107
          <td><para style="P12"><font color="white"> </font></para><para style="P2">JNRL</para></td>
 
108
          <td><para style="P12"><font color="white"> </font></para><para style="P2">Partner</para></td>
 
109
          <td><para style="P12"><font color="white"> </font></para><para style="P2">Ref</para></td>
 
110
          <td><para style="P12"><font color="white"> </font></para><para style="P3">Entry Label</para></td>
 
111
          <td><para style="P12"><font color="white"> </font></para><para style="P3">Counterpart</para></td>
 
112
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Debit</para></td>
 
113
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Credit</para></td>
 
114
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Balance</para></td>
 
115
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Currency</para></td>
 
116
       </tr>
 
117
     </blockTable>
 
118
    
 
119
     <section> 
 
120
    
 
121
      <para>[[ repeatIn(get_children_accounts(a,data['form']), 'o') ]]</para>
 
122
    
 
123
      <blockTable colWidths="60.0,60.0,50.0,150.0,150.0,266.0,50.0,68.0,68.0,69.0,58.0" style="tbl_content">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 
124
        <tr>
 
125
                <td>
 
126
                        <blockTable colWidths="779.0,68.0,68.0,69.0,59.00" style="tbl_content">
 
127
                                <tr>
 
128
                                        <td><para style="Standard">[[ o.code ]] [[ o.name ]]</para></td>
 
129
                                        <td><para style="Standard"></para></td>
 
130
                                        <td><para style="Standard"></para></td>
 
131
                                        <td><para style="Standard"></para></td>
 
132
                                        <td><para style="Standard"></para></td>
 
133
                                        </tr>
 
134
                        </blockTable>
 
135
                </td>
 
136
                <td><para style="Standard"></para></td>
 
137
                <td><para style="Standard"></para></td>
 
138
                <td><para style="Standard"></para></td>
 
139
                <td><para style="Standard"></para></td>
 
140
                <td><para style="Standard"></para></td>
 
141
                <td><para style="Standard"></para></td>
 
142
                <td><para style="Standard"></para></td>
 
143
                <td><para style="Standard"></para></td>
 
144
                <td><para style="Standard"></para></td>
 
145
                <td><para style="Standard"></para></td>
 
146
                </tr>
 
147
                <tr>
 
148
                        <td><para style="P2_content">[[ repeatIn(lines(o, data['form']), 'line') ]]<font> [[ formatLang(line['date'],date=True) ]]</font></para></td>
 
149
                        <td><para style="P2_content">[[ line['move'] ]]</para></td>
 
150
                        <td><para style="P2_content">[[ line['code'] ]]</para></td>
 
151
                        <td><para style="P2_content">[[ line['partner'] ]]</para></td>
 
152
                        <td><para style="P2_content">[[ line['ref'] ]]</para></td>
 
153
                        <td><para style="P3_content">[[ line['name'] ]]</para></td>
 
154
                        <td><para style="P3_content">[[ strip_name(line['line_corresp'],15) ]]</para></td>
 
155
                        <td><para style="P4_content">[[ line['debit'] and formatLang(line['debit']) or '' ]]</para></td>
 
156
                        <td><para style="P4_content">[[ line['credit'] and formatLang(line['credit']) or '' ]]</para></td>
 
157
                        <td><para style="P4_content">[[ formatLang(line['progress']) ]]</para></td>
 
158
                        <td><para style="P4_content">[[ formatLang(line['amount_currency'] or 0.00)]] [[ line['currency_code'] ]]</para></td>
 
159
                </tr>
 
160
        <tr>
 
161
                <td>
 
162
                        <blockTable colWidths="729.0,50.0,68.0,68.0,69.0,59.00" style="tbl_header">
 
163
                                <tr>
 
164
                                        <td><para style="Standard">[[ o.code ]] [[ o.name ]]</para></td>
 
165
                                        <td><para style="Standard">Total</para></td>
 
166
                                        <td alignment="right"><para style="P9b">[[ formatLang(sum_debit_account(o, data['form'])) ]]</para></td>
 
167
                                        <td alignment="right"><para style="P9b">[[ formatLang(sum_credit_account(o, data['form'])) ]]</para></td>
 
168
                                        <td><para style="P9b">[[ formatLang(sum_balance_account(o, data['form'])) ]]</para></td>
 
169
                                        <td><para style="P9b">[[ formatLang(sum_currency_amount_account(o, data['form'])) ]]</para></td>
 
170
                                        </tr>
 
171
                        </blockTable>
 
172
                </td>
 
173
                <td><para style="Standard"></para></td>
 
174
                <td><para style="Standard"></para></td>
 
175
                <td><para style="Standard"></para></td>
 
176
                <td><para style="Standard"></para></td>
 
177
                <td><para style="Standard"></para></td>
 
178
                <td><para style="Standard"></para></td>
 
179
                <td><para style="Standard"></para></td>
 
180
                <td><para style="Standard"></para></td>
 
181
                <td><para style="Standard"></para></td>
 
182
                <td><para style="Standard"></para></td>
 
183
                </tr>
 
184
          </blockTable>
 
185
        
 
186
        </section>
 
187
     
 
188
    <blockTable colWidths="60.0,60.0,50.0,166.0,150.0,309.0,50.0,68.0,68.0,69.0" style="tbl_header" repeatRows="1">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 
189
       <tr>
 
190
          <td><para style="P12"><font color="white"> </font></para><para style="date">Date</para></td>
 
191
          <td><para style="P12"><font color="white"> </font></para><para style="P2">Mvt</para></td>
 
192
          <td><para style="P12"><font color="white"> </font></para><para style="P2">JNRL</para></td>
 
193
          <td><para style="P12"><font color="white"> </font></para><para style="P2">Partner</para></td>
 
194
          <td><para style="P12"><font color="white"> </font></para><para style="P2">Ref</para></td>
 
195
          <td><para style="P12"><font color="white"> </font></para><para style="P3">Entry Label</para></td>
 
196
          <td><para style="P12"><font color="white"> </font></para><para style="P3">Counterpart</para></td>
 
197
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Debit</para></td>
 
198
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Credit</para></td>
 
199
          <td><para style="P12"><font color="white"> </font></para><para style="P4">Balance</para></td>
 
200
       </tr>
 
201
        </blockTable>
 
202
        
 
203
        <section>
 
204
        
 
205
                <para>[[ repeatIn(get_children_accounts(a,data['form']), 'o') ]]</para>
 
206
                
 
207
                <blockTable colWidths="60.0,60.0,50.0,166.0,150.0,309.0,50.0,68.0,68.0,69.0" style="tbl_content">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 
208
                <tr>
 
209
                        <td>
 
210
                                <blockTable colWidths="840.0,68.0,68.0,69.0" style="tbl_content">
 
211
                                                <tr>
 
212
                                                        <td><para style="Standard">[[ o.code ]] [[ o.name ]]</para></td>
 
213
                                                        <td><para style="Standard"></para></td>
 
214
                                                        <td><para style="Standard"></para></td>
 
215
                                                        <td><para style="Standard"></para></td>
 
216
                                                </tr>
 
217
                                        </blockTable>
 
218
                                </td>
 
219
                                <td><para style="Standard"></para></td>
 
220
                        <td><para style="Standard"></para></td>
 
221
                        <td><para style="Standard"></para></td>
 
222
                        <td><para style="Standard"></para></td>
 
223
                        <td><para style="Standard"></para></td>
 
224
                        <td><para style="Standard"></para></td>
 
225
                        <td><para style="Standard"></para></td>
 
226
                        <td><para style="Standard"></para></td>
 
227
                        <td><para style="Standard"></para></td>
 
228
                        </tr>
 
229
                        <tr>
 
230
                                <td><para style="P2_content">[[ repeatIn(lines(o, data['form']), 'line') ]]<font>[[ formatLang(line['date'],date=True) ]]</font></para></td>
 
231
                                <td><para style="P2_content">[[ line['move'] ]]</para></td>
 
232
                                <td><para style="P2_content">[[ line['code'] ]]</para></td>
 
233
                                <td><para style="P2_content">[[ line['partner'] ]]</para></td>
 
234
                                <td><para style="P2_content">[[ line['ref'] ]]</para></td>
 
235
                                <td><para style="P3_content">[[ line['name'] ]]</para></td>
 
236
                                <td><para style="P3_content">[[ strip_name(line['line_corresp'],15) ]]</para></td>
 
237
                                <td><para style="P4_content">[[ line['debit'] and formatLang(line['debit']) or '' ]]</para></td>
 
238
                                <td><para style="P4_content">[[ line['credit'] and formatLang(line['credit']) or '' ]]</para></td>
 
239
                                <td><para style="P4_content">[[ formatLang(line['progress']) ]]</para></td>
 
240
                        </tr>
 
241
                <tr>
 
242
                        <td>
 
243
                                <blockTable colWidths="790.0,50.0,68.0,68.0,69.0" style="tbl_header">
 
244
                                                <tr>
 
245
                                                        <td><para style="Standard">[[ o.code ]] [[ o.name ]]</para></td>
 
246
                                                        <td><para style="Standard">Total</para></td>
 
247
                                                        <td alignment="right"><para style="P9b">[[ formatLang(sum_debit_account(o, data['form']))]]</para></td>
 
248
                                                        <td alignment="right"><para style="P9b">[[formatLang(sum_credit_account(o, data['form']))]]</para></td>
 
249
                                                        <td><para style="P9b">[[formatLang(sum_balance_account(o, data['form'])) ]]</para></td>
 
250
                                                </tr>
 
251
                                        </blockTable>
 
252
                                </td>
 
253
                                <td><para style="Standard"></para></td>
 
254
                        <td><para style="Standard"></para></td>
 
255
                        <td><para style="Standard"></para></td>
 
256
                        <td><para style="Standard"></para></td>
 
257
                        <td><para style="Standard"></para></td>
 
258
                        <td><para style="Standard"></para></td>
 
259
                        <td><para style="Standard"></para></td>
 
260
                        <td><para style="Standard"></para></td>
 
261
                        <td><para style="Standard"></para></td>
 
262
                        </tr>
 
263
                </blockTable>
 
264
        
 
265
        </section>
 
266
 </story>
 
267
</document>