← Back to branch summary

~openerp-commiter/openobject-addons/trunk-training

« back to all changes in this revision

Viewing changes to account_financial_report/report/general_ledger.rml

  • Committer: HDA(OpenERP)
  • Date: 2010-05-17 11:25:04 UTC
  • mfrom: (4287.4.283 trunk-extra-addons)
  • Revision ID: hda@tinyerp.com-20100517112504-5ygd4t4w26sdz9f5
Merged with main traun extra addons

Show diffs side-by-side

added added

removed removed

Lines of Context:
account_financial_report/report/general_ledger.rml
 
1
<?xml version="1.0"?>
 
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"/>
 
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="0.9cm" y="28.1cm">[[ company.name ]]</drawString>
 
18
                                <drawString x="16.8cm" y="28.1cm">General Ledger - [[ company.currency_id.name ]]</drawString>
 
19
 
 
20
                                <!--COL 2-->
 
21
                                <setFont name="Helvetica" size="9"/>
 
22
                                <drawString x="1.0cm" y="1cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString>
 
23
                                <drawString x="19.0cm" y="1cm">Page <pageNumber/></drawString>
 
24
                                <!--<drawRightString x="19.8cm" y="28cm">[[ company.rml_header1 ]]</drawRightString>-->
 
25
 
 
26
                            <lineMode width="0.7"/>
 
27
                                <lines>0.9cm 27.7cm 20.1cm 27.7cm</lines>
 
28
                                <setFont name="Helvetica" size="8"/>
 
29
                                </pageGraphics>
 
30
    </pageTemplate>
 
31
  </template>
 
32
   <stylesheet>
 
33
 
 
34
    <blockTableStyle id="tbl_header">
 
35
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 
36
      <blockValign value="TOP"/>
 
37
      <blockTopPadding length="2.0"/>
 
38
      <blockBottomPadding length="0.0"/>
 
39
    </blockTableStyle>
 
40
 
 
41
    <blockTableStyle id="tbl_content">
 
42
      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,1" stop="-1,-1"/>
 
43
      <blockValign value="TOP"/>
 
44
      <blockTopPadding length="2.0"/>
 
45
      <blockBottomPadding length="0.0"/>
 
46
    </blockTableStyle>
 
47
 
 
48
    <blockTableStyle id="Table5">
 
49
      <blockAlignment value="LEFT"/>
 
50
      <lineStyle kind="LINEBELOW" colorName="#777777" start="0,0" stop="0,0"/>
 
51
      <blockValign value="TOP"/>
 
52
    </blockTableStyle>
 
53
 
 
54
    <initialize>
 
55
      <paraStyle name="all" alignment="justify"/>
 
56
    </initialize>
 
57
    <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
58
    <paraStyle name="P2" fontName="Helvetica" fontSize="8.3" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
59
    <paraStyle name="date" fontName="Helvetica" fontSize="8.3" leading="10" spaceBefore="0.0" spaceAfter="6.0" alignment="CENTER"/>
 
60
    <paraStyle name="P2_content" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
61
    <paraStyle name="P3" fontName="Helvetica" fontSize="8.3" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
62
    <paraStyle name="P3_centre" fontName="Helvetica" fontSize="8.3" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
63
    <paraStyle name="P3_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
64
    <paraStyle name="P4" fontName="Helvetica" fontSize="8.3" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
65
    <paraStyle name="P4_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
66
    <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
67
    <paraStyle name="P6" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
68
    <paraStyle name="P7" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
69
    <paraStyle name="P8" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
70
    <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
71
    <paraStyle name="P9b" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
72
    <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 
73
    <paraStyle name="P11" fontName="Helvetica" fontSize="11.0" leading="14"/>
 
74
    <paraStyle name="P12" fontName="Helvetica" fontSize="14.0" leading="17"/>
 
75
    <paraStyle name="P13" fontName="Helvetica-Bold" fontSize="10.0" leading="8" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
76
    <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
77
    <paraStyle name="P15" fontName="Helvetica-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 
78
    <paraStyle name="P16" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Roman" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
79
    <paraStyle name="P17" fontName="Helvetica" alignment="LEFT" fontSize="12.0"  spaceAfter="0.0"/>
 
80
    <paraStyle name="Standard" fontName="Helvetica-Bold" fontSize="8.5"/>
 
81
    <paraStyle name="Account" fontName="Helvetica"/>
 
82
    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
83
    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
84
    <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
85
    <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
86
    <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 
87
    <paraStyle name="Index" fontName="Helvetica"/>
 
88
  </stylesheet>
 
89
  <story>
 
90
    <para style="P2">[[setLang(user.context_lang)]]</para>
 
91
    <blockTable colWidths="540.0" repeatRows="1">
 
92
      <tr>
 
93
        <td>
 
94
                  <para style="P15">Fiscal year: [[ get_fiscalyear(data['form']) or removeParentNode('para') ]]</para>
 
95
          <para style="Standard">Periods/Date range: [[ get_periods(data['form']) or removeParentNode('para') ]]</para>
 
96
        </td>
 
97
      </tr>
 
98
    </blockTable>
 
99
 
 
100
    <para>[[ repeatIn(objects, 'a') ]]</para>
 
101
      <blockTable colWidths="60.0,40.0,114.0,166.0,59.0,52.0,54.0" style="tbl_header" repeatRows="1">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 
102
        <tr>
 
103
          <td><para style="date">Date</para></td>
 
104
          <td><para style="P3">Mvt</para></td>
 
105
          <td><para style="P3">Partner</para></td>
 
106
          <td><para style="P3">Ref - Entry Label</para></td>
 
107
          <td><para style="P4">Debit</para></td>
 
108
          <td><para style="P4">Credit</para></td>
 
109
          <td><para style="P9">Balance</para></td>
 
110
        </tr>
 
111
      </blockTable>
 
112
      <section>    
 
113
     <para>[[ repeatIn(get_children_accounts(a,data['form']), 'o') ]]</para>
 
114
     <blockTable colWidths="60.0,40.0,114.0,166.0,59.0,52.0,54.0" style="tbl_content">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 
115
        <tr>
 
116
          <td>
 
117
                <blockTable colWidths="324.0,50.0,59.0,52.0,54.0" style="tbl_content">
 
118
                        <tr>
 
119
                          <td><para style="Standard">[[ o.code or '']] [[ o.name or '']]</para></td>
 
120
                          <td><para style="Standard"></para></td>
 
121
                          <td><para style="Standard"></para></td>
 
122
                          <td><para style="Standard"></para></td>
 
123
                          <td><para style="Standard"></para></td>
 
124
                        </tr>
 
125
                        </blockTable>
 
126
                        </td>
 
127
                        <td><para style="Standard"></para></td>
 
128
                <td><para style="Standard"></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
                <tr>
 
135
                          <td><para style="P3">[[ repeatIn(lines(o, data['form']), 'line') ]] <font>[[ formatLang(line['date'],date=True) ]]</font></para></td>
 
136
                          <td><para style="P3">[[ line['move'] or '']]</para></td>
 
137
                          <td><para style="P3">[[ line['partner'] or '']]</para></td>
 
138
                          <td><para style="P3">[[ line['ref'] or '']] [[ line['name'] or '' ]]</para></td>
 
139
                          <td><para style="P4">[[ formatLang(line['debit']) ]]</para></td>
 
140
                          <td><para style="P4">[[ formatLang(line['credit']) ]]</para></td>
 
141
                          <td><para style="P4">[[ formatLang(line['progress']) ]]</para></td>
 
142
            </tr>
 
143
        <tr>
 
144
          <td>
 
145
                <blockTable colWidths="324.0,50.0,59.0,52.0,54.0" style="tbl_header">
 
146
                        <tr>
 
147
                          <td><para style="Standard">[[ o.code or '']] [[ o.name or '']]</para></td>
 
148
                          <td><para style="Standard">Total</para></td>
 
149
                          <td alignment="right"><para style="P9b">[[formatLang(sum_debit_account(o, data['form'])) ]]</para></td>
 
150
                          <td alignment="right"><para style="P9b">[[formatLang(sum_credit_account(o, data['form'])) ]]</para></td>
 
151
                          <td><para style="P9b">[[formatLang(sum_balance_account(o, data['form'])) ]]</para></td>
 
152
                        </tr>
 
153
                        </blockTable>
 
154
                        </td>
 
155
                        <td><para style="Standard"></para></td>
 
156
                <td><para style="Standard"></para></td>
 
157
                <td><para style="Standard"></para></td>
 
158
                <td><para style="Standard"></para></td>
 
159
                <td><para style="Standard"></para></td>
 
160
                <td><para style="Standard"></para></td>
 
161
            </tr>
 
162
          </blockTable>
 
163
     </section>    
 
164
    
 
165
    
 
166
 
 
167
     <blockTable colWidths="60.0,40.0,105.0,156.0,50.0,50.0,50.0,50.0" style="tbl_header" repeatRows="1">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 
168
        <tr>
 
169
          <td><para style="date">Date</para></td>
 
170
          <td><para style="P3">Mvt</para></td>
 
171
          <td><para style="P3">Partner</para></td>
 
172
          <td><para style="P3">Ref - Entry Label</para></td>
 
173
          <td><para style="P4">Debit</para></td>
 
174
          <td><para style="P4">Credit</para></td>
 
175
          <td><para style="P4">Balance</para></td>
 
176
          <td><para style="P4">Currency</para></td>
 
177
        </tr>
 
178
     </blockTable>
 
179
     <section>
 
180
     <para>[[ repeatIn(get_children_accounts(a,data['form']), 'o') ]]</para>
 
181
     <blockTable colWidths="60.0,40.0,105.0,156.0,50.0,50.0,50.0,50.0" style="tbl_content">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 
182
       <tr>
 
183
          <td>
 
184
                <blockTable colWidths="305.00,50.0,50.0,50.0,50.0,50.00" style="tbl_content">
 
185
                        <tr>
 
186
                          <td><para style="Standard">[[ o.code or '' ]] [[ o.name or '' ]]</para></td>
 
187
                          <td><para style="Standard"></para></td>
 
188
                          <td><para style="Standard"></para></td>
 
189
                          <td><para style="Standard"></para></td>
 
190
                          <td><para style="Standard"></para></td>
 
191
                          <td><para style="Standard"></para></td>
 
192
                        </tr>
 
193
                        </blockTable>
 
194
                  </td>
 
195
                  <td><para style="Standard"></para></td>
 
196
              <td><para style="Standard"></para></td>
 
197
              <td><para style="Standard"></para></td>
 
198
              <td><para style="Standard"></para></td>
 
199
              <td><para style="Standard"></para></td>
 
200
              <td><para style="Standard"></para></td>
 
201
              <td><para style="Standard"></para></td>
 
202
            </tr>
 
203
                <tr>
 
204
                   <td><para style="P3">[[ repeatIn(lines(o, data['form']), 'line') ]] <font>[[ formatLang(line['date'],date=True) ]]</font></para></td>
 
205
                   <td><para style="P3">[[ line['move'] or '' ]]</para></td>
 
206
                   <td><para style="P3">[[ line['partner'] or '' ]]</para></td>
 
207
                   <td><para style="P3">[[ line['ref'] or '']] [[ line['name'] or '' ]]</para></td>
 
208
                   <td><para style="P4">[[ formatLang(line['debit']) ]]</para></td>
 
209
                   <td><para style="P4">[[ formatLang(line['credit']) ]]</para></td>
 
210
                   <td><para style="P4">[[ formatLang(line['progress']) ]]</para></td>
 
211
                   <td><para style="P4">[[ formatLang(line['amount_currency'] or 0.00) ]] [[ line['currency_code'] or '']]</para></td>
 
212
                </tr>
 
213
        <tr>
 
214
          <td>
 
215
                <blockTable colWidths="305.00,50.0,50.0,50.0,50.0,50.00" style="tbl_header">
 
216
                        <tr>
 
217
                          <td><para style="Standard">[[ o.code or '' ]] [[ o.name or '' ]]</para></td>
 
218
                          <td><para style="Standard">Total</para></td>
 
219
                          <td alignment="right"><para style="P9b">[[ formatLang(sum_debit_account(o, data['form'])) ]]</para></td>
 
220
                          <td alignment="right"><para style="P9b">[[formatLang(sum_credit_account(o, data['form'])) ]]</para></td>
 
221
                          <td><para style="P9b">[[formatLang(sum_balance_account(o, data['form'])) ]]</para></td>
 
222
                          <td><para style="P9b">[[formatLang(sum_currency_amount_account(o, data['form'])) ]]</para></td>
 
223
                        </tr>
 
224
                        </blockTable>
 
225
                  </td>
 
226
                  <td><para style="Standard"></para></td>
 
227
              <td><para style="Standard"></para></td>
 
228
              <td><para style="Standard"></para></td>
 
229
              <td><para style="Standard"></para></td>
 
230
              <td><para style="Standard"></para></td>
 
231
              <td><para style="Standard"></para></td>
 
232
              <td><para style="Standard"></para></td>
 
233
            </tr>
 
234
        </blockTable>
 
235
        </section>
 
236
  </story>
 
237
 
 
238
 
 
239
 
 
240
</document>