← Back to branch summary

~openerp-chinese-team/openerp-china/openerp-china

« back to all changes in this revision

Viewing changes to oecn_account_print/report/general_ledger.rml

  • Committer: JoshuaJan
  • Date: 2012-08-29 09:37:27 UTC
  • Revision ID: popkar77@gmail.com-20120829093727-14mxsq818t2kcvzo
1.凭证变成一页打印2张2.科目名字输出全名3.方向由余额决定

Show diffs side-by-side

added added

removed removed

Lines of Context:
oecn_account_print/report/general_ledger.rml
38
38
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="6,0" stop="6,-1"/>
39
39
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="6,0" stop="6,0"/>
40
40
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="6,-1" stop="6,-1"/>
41
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="7,0" stop="7,-1"/>
42
 
      <lineStyle kind="LINEAFTER" colorName="#008000" thickness="0.5"  start="7,0" stop="7,-1"/>
43
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="7,0" stop="7,0"/>
44
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="7,-1" stop="7,-1"/>
 
41
      <lineStyle kind="LINEAFTER" colorName="#008000" thickness="0.5"  start="6,0" stop="6,-1"/>
45
42
    </blockTableStyle>
46
43
    <blockTableStyle id="&#x8868;&#x683C;3">
47
44
      <blockAlignment value="LEFT"/>
67
64
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="6,0" stop="6,-1"/>
68
65
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="6,0" stop="6,0"/>
69
66
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="6,-1" stop="6,-1"/>
70
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="7,0" stop="7,-1"/>
71
 
      <lineStyle kind="LINEAFTER" colorName="#008000" thickness="0.5"  start="7,0" stop="7,-1"/>
72
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="7,0" stop="7,0"/>
73
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="7,-1" stop="7,-1"/>
74
 
    </blockTableStyle>
 
67
      <lineStyle kind="LINEAFTER" colorName="#008000" thickness="0.5"  start="6,0" stop="6,-1"/>
 
68
      </blockTableStyle>
75
69
    <blockTableStyle id="&#x8868;&#x683C;4">
76
70
      <blockAlignment value="LEFT"/>
77
71
      <blockValign value="TOP"/>
78
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="0,0" stop="0,-1"/>
79
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="0,0" stop="0,0"/>
80
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="0,-1" stop="0,-1"/>
81
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="1,0" stop="1,-1"/>
82
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="1,0" stop="1,0"/>
83
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="1,-1" stop="1,-1"/>
84
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="2,0" stop="2,-1"/>
85
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="2,0" stop="2,0"/>
86
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="2,-1" stop="2,-1"/>
87
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="3,0" stop="3,-1"/>
88
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="3,0" stop="3,0"/>
89
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="3,-1" stop="3,-1"/>
90
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="4,0" stop="4,-1"/>
91
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="4,0" stop="4,0"/>
92
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="4,-1" stop="4,-1"/>
93
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="5,0" stop="5,-1"/>
94
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="5,0" stop="5,0"/>
95
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="5,-1" stop="5,-1"/>
96
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="6,0" stop="6,-1"/>
97
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="6,0" stop="6,0"/>
98
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="6,-1" stop="6,-1"/>
99
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="7,0" stop="7,-1"/>
100
 
      <lineStyle kind="LINEAFTER" colorName="#008000" thickness="0.5"  start="7,0" stop="7,-1"/>
101
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="7,0" stop="7,0"/>
102
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="7,-1" stop="7,-1"/>
103
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="0,1" stop="0,-1"/>
104
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="0,1" stop="0,1"/>
105
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="0,-1" stop="0,-1"/>
106
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="1,1" stop="1,-1"/>
107
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="1,1" stop="1,1"/>
108
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="1,-1" stop="1,-1"/>
109
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="2,1" stop="2,-1"/>
110
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="2,1" stop="2,1"/>
111
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="2,-1" stop="2,-1"/>
112
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="3,1" stop="3,-1"/>
113
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="3,1" stop="3,1"/>
114
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="3,-1" stop="3,-1"/>
115
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="4,1" stop="4,-1"/>
116
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="4,1" stop="4,1"/>
117
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="4,-1" stop="4,-1"/>
118
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="5,1" stop="5,-1"/>
119
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="5,1" stop="5,1"/>
120
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="5,-1" stop="5,-1"/>
121
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="6,1" stop="6,-1"/>
122
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="6,1" stop="6,1"/>
123
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="6,-1" stop="6,-1"/>
124
 
      <lineStyle kind="LINEBEFORE" colorName="#008000" thickness="0.5"  start="7,1" stop="7,-1"/>
125
 
      <lineStyle kind="LINEAFTER" colorName="#008000" thickness="0.5"  start="7,1" stop="7,-1"/>
126
 
      <lineStyle kind="LINEABOVE" colorName="#008000" thickness="0.5"  start="7,1" stop="7,1"/>
127
 
      <lineStyle kind="LINEBELOW" colorName="#008000" thickness="0.5"  start="7,-1" stop="7,-1"/>
128
 
    </blockTableStyle>
 
72
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="0,0" stop="0,-1"/>
 
73
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="1,0" stop="1,-1"/>
 
74
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="2,0" stop="2,-1"/>
 
75
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="3,0" stop="3,-1"/>
 
76
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="4,0" stop="4,-1"/>
 
77
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="5,0" stop="5,-1"/>
 
78
      <lineStyle kind="GRID" colorName="#008000" thickness="0.5"  start="6,0" stop="6,-1"/>
 
79
      </blockTableStyle>
129
80
    <initialize>
130
81
      <paraStyle name="all" alignment="justify"/>
131
82
    </initialize>
132
83
    <paraStyle name="P1" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT"/>
133
 
    <paraStyle name="P2" fontName="Helvetica" alignment="CENTER"/>
134
 
    <paraStyle name="P3" fontName="Helvetica" alignment="LEFT"/>
135
 
    <paraStyle name="P4" fontName="Helvetica" alignment="RIGHT"/>
 
84
    <paraStyle name="P2" fontName="Helvetica" alignment="CENTER" leading="9"/>
 
85
    <paraStyle name="P3" fontName="Helvetica" alignment="LEFT" fontSize="8.0" leading="9"/>
 
86
    <paraStyle name="P4" fontName="Helvetica" alignment="RIGHT" fontSize="8.0" leading="9"/>
136
87
    <paraStyle name="P5" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
137
88
    <paraStyle name="P6" fontName="Helvetica" alignment="LEFT"/>
138
89
    <paraStyle name="P7" fontName="Helvetica" fontSize="7.0" leading="9" alignment="RIGHT"/>
159
110
    <images/>
160
111
  </stylesheet>
161
112
  <story>
 
113
  <para style="P1">[[repeatIn(objects,'o')]]</para>
162
114
  <pto>
163
115
    <para style="P2">总分类账</para>
164
116
    <blockTable colWidths="269.0,269.0" style="&#x8868;&#x683C;2">
165
117
      <tr>
166
 
        <td>
167
 
          <para style="P3">开始日期:[[data['all_date']['period_start_date_start'] ]] </para>
168
 
        </td>
169
 
        <td>
170
 
          <para style="P4">结束日期:[[data['all_date']['period_end_date_stop'] ]]</para>
171
 
        </td>
 
118
        <td><para style="P3">科目：[[account_name(o.id)]]</para></td>
 
119
        <td>><para style="P4"></para></td>
 
120
      </tr>
 
121
      <tr>
 
122
       <td><para style="P3">开始日期:[[data['all_date']['period_start_date_start'] ]] </para></td>
 
123
       <td><para style="P4">结束日期:[[data['all_date']['period_end_date_stop'] ]]</para></td>
172
124
      </tr>
173
125
    </blockTable>
174
126
    <pto_header>
175
 
    <blockTable colWidths="24.0,24.0,126.0,66.0,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;1">
 
127
    <blockTable colWidths="24.0,24.0,192.0,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;1">
176
128
      <tr>
177
129
        <td>
178
130
          <para style="P6">月</para>
181
133
          <para style="P6">日</para>
182
134
        </td>
183
135
        <td>
184
 
          <para style="P6">会计科目</para>
185
 
        </td>
186
 
        <td>
187
136
          <para style="P6">摘要</para>
188
137
        </td>
189
138
        <td>
201
150
      </tr>
202
151
    </blockTable>
203
152
    </pto_header>
204
 
        <blockTable colWidths="24.0,24.0,126.0,66.0,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;1">
 
153
        <blockTable colWidths="24.0,24.0,192.0,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;1">
205
154
      <tr>
206
155
        <td>
207
156
          <para style="P6">月</para>
210
159
          <para style="P6">日</para>
211
160
        </td>
212
161
        <td>
213
 
          <para style="P6">会计科目</para>
214
 
        </td>
215
 
        <td>
216
162
          <para style="P6">摘要</para>
217
163
        </td>
218
164
        <td>
229
175
        </td>
230
176
      </tr>
231
177
    </blockTable>
232
 
    <section>
233
 
      <para style="P1">[[repeatIn(objects,'o')]]</para>
234
 
      <blockTable colWidths="24.0,24.0,126.0,66.0,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;3">
 
178
      <blockTable colWidths="24.0,24.0,192,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;3">
235
179
        <tr>
236
180
          <td>
237
181
            <para style="P12">[[data['all_date']['fiscalyear_obj_date_start'][5:7] ]]</para>
240
184
            <para style="P12">[[data['all_date']['fiscalyear_obj_date_start'][8:10] ]]</para>
241
185
          </td>
242
186
          <td>
243
 
            <para style="P5">[[o.code]] [[o.name]]</para>
244
 
          </td>
245
 
          <td>
246
187
            <para style="P5">年初余额</para>
247
188
          </td>
248
189
          <td>
267
208
      </blockTable>
268
209
      <section>
269
210
        <para style="P1">[[repeatIn(lines(o.id),'period') ]]</para>
270
 
        <blockTable colWidths="24.0,24.0,126.0,66.0,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;4">
 
211
        <blockTable colWidths="24.0,24.0,192,78.0,78.0,39.0,105.0" style="&#x8868;&#x683C;4">
271
212
          <tr>
272
213
            <td>
273
214
              <para style="P19">[[period['period'].date_start[5:7] ]]</para>
276
217
              <para style="P18">[[period['period'].date_start[8:10] ]]</para>
277
218
            </td>
278
219
            <td>
279
 
              <para style="P9">
280
 
                <font color="white"> </font>
281
 
              </para>
282
 
            </td>
283
 
            <td>
284
220
              <para style="P10">本期合计</para>
285
221
            </td>
286
222
            <td>
290
226
              <para style="P7">[[formatLang(reduce(lambda x,y:x+y.credit or 0 ,period['lines'],0))]]</para>
291
227
            </td>
292
228
            <td>
293
 
              <para style="P8">[[get_direction(reduce(lambda x,y:x+y['debit'] or 0 ,period['lines'],0)-reduce(lambda x,y:x+y['credit'] or 0 ,period['lines'],0)) ]]</para>
 
229
              <para style="P8">[[get_direction(balance(date_stop=period['period'].date_stop)['balance']) ]]</para>
294
230
            </td>
295
231
            <td>
296
 
              <para style="P7">[[formatLang(balance(date_stop=period['period'].date_stop)['balance'])]]</para>
 
232
              <para style="P7">[[formatLang(abs(balance(date_stop=period['period'].date_stop)['balance']))]]</para>
297
233
            </td>
298
234
          </tr>
299
235
          <tr>
308
244
              </para>
309
245
            </td>
310
246
            <td>
311
 
              <para style="P5">
312
 
                <font color="white"> </font>
313
 
              </para>
314
 
            </td>
315
 
            <td>
316
247
              <para style="P5">本年合计</para>
317
248
            </td>
318
249
            <td>
322
253
              <para style="P7">[[formatLang(balance(o.id, date_start=data['all_date']['period_start_date_start'],date_stop=period['period'].date_stop)['credit'])]]</para>
323
254
            </td>
324
255
            <td>
325
 
              <para style="P8">[[get_direction(balance(o.id, date_start=data['all_date']['period_start_date_start'],date_stop=period['period'].date_stop)['debit'] -balance(o.id, date_start=data['all_date']['period_start_date_start'],date_stop=period['period'].date_stop)['credit'])]]</para>
 
256
              <para style="P8">[[get_direction(balance(o.id, date_stop=period['period'].date_stop)['balance'])]]</para>
326
257
            </td>
327
258
            <td>
328
 
              <para style="P7">[[formatLang(balance(o.id, date_stop=period['period'].date_stop)['balance'])]]</para>
 
259
              <para style="P7">[[formatLang(abs(balance(o.id, date_stop=period['period'].date_stop)['balance']))]]</para>
329
260
            </td>
330
261
          </tr>
331
262
        </blockTable>
332
263
      </section>
333
 
    </section>
334
264
    </pto>
335
265
  </story>
336
266
</document>