← 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/threecolumns_ledger.rml

  • Committer: JoshuaJan
  • Date: 2012-03-14 06:29:11 UTC
  • Revision ID: joshua@openerp.cn-20120314062911-oj55h9dodzca0b0s
修改报表的模版

Show diffs side-by-side

added added

removed removed

Lines of Context:
oecn_account_print/report/threecolumns_ledger.rml
152
152
    </initialize>
153
153
    <paraStyle name="P1" fontName="Helvetica" alignment="CENTER"/>
154
154
    <paraStyle name="P2" fontName="Helvetica" alignment="LEFT"/>
155
 
    <paraStyle name="P3" fontName="Helvetica" alignment="LEFT"/>
156
 
    <paraStyle name="P4" fontName="Helvetica" fontSize="7.0" leading="9" alignment="LEFT"/>
157
 
    <paraStyle name="P5" fontName="Helvetica" fontSize="7.0" leading="9" alignment="RIGHT"/>
158
 
    <paraStyle name="P6" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT"/>
159
 
    <paraStyle name="P7" fontName="Helvetica" alignment="LEFT"/>
 
155
    <paraStyle name="P3" fontName="Helvetica" alignment="RIGHT"/>
 
156
    <paraStyle name="P4" fontName="Helvetica" alignment="LEFT"/>
 
157
    <paraStyle name="P5" fontName="Helvetica" fontSize="7.0" leading="9" alignment="LEFT"/>
 
158
    <paraStyle name="P6" fontName="Helvetica" fontSize="7.0" leading="9" alignment="RIGHT"/>
 
159
    <paraStyle name="P7" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT"/>
160
160
    <paraStyle name="P8" fontName="Helvetica" alignment="RIGHT"/>
161
 
    <paraStyle name="P9" fontName="Helvetica" alignment="RIGHT"/>
162
 
    <paraStyle name="P10" fontName="Helvetica" alignment="LEFT"/>
163
 
    <paraStyle name="P11" fontName="Helvetica" fontSize="7.0" leading="9" alignment="RIGHT"/>
 
161
    <paraStyle name="P9" fontName="Helvetica" fontSize="7.0" leading="9" alignment="RIGHT"/>
 
162
    <paraStyle name="P10" fontName="Helvetica" fontSize="7.0" leading="9" alignment="LEFT"/>
164
163
    <paraStyle name="Standard" fontName="Helvetica"/>
165
164
    <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
166
165
    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
182
181
          <para style="P2">开始日期:[[data['all_date']['period_start_date_start'] ]] </para>
183
182
        </td>
184
183
        <td>
185
 
          <para style="P8">结束日期:[[data['all_date']['period_end_date_stop'] ]]</para>
 
184
          <para style="P3">结束日期:[[data['all_date']['period_end_date_stop'] ]]</para>
186
185
        </td>
187
186
      </tr>
188
187
    </blockTable>
189
188
    <blockTable colWidths="56.0,66.0,58.0,95.0,69.0,69.0,44.0,82.0" style="&#x8868;&#x683C;1">
190
189
      <tr>
191
190
        <td>
192
 
          <para style="P3">日期</para>
193
 
        </td>
194
 
        <td>
195
 
          <para style="P3">凭证字号</para>
196
 
        </td>
197
 
        <td>
198
 
          <para style="P3">摘要</para>
199
 
        </td>
200
 
        <td>
201
 
          <para style="P3">对方科目</para>
202
 
        </td>
203
 
        <td>
204
 
          <para style="P9">借方</para>
205
 
        </td>
206
 
        <td>
207
 
          <para style="P9">贷方</para>
208
 
        </td>
209
 
        <td>
210
 
          <para style="P3">方向</para>
211
 
        </td>
212
 
        <td>
213
 
          <para style="P9">余额</para>
 
191
          <para style="P4">日期</para>
 
192
        </td>
 
193
        <td>
 
194
          <para style="P4">凭证字号</para>
 
195
        </td>
 
196
        <td>
 
197
          <para style="P4">摘要</para>
 
198
        </td>
 
199
        <td>
 
200
          <para style="P4">对方科目</para>
 
201
        </td>
 
202
        <td>
 
203
          <para style="P8">借方</para>
 
204
        </td>
 
205
        <td>
 
206
          <para style="P8">贷方</para>
 
207
        </td>
 
208
        <td>
 
209
          <para style="P4">方向</para>
 
210
        </td>
 
211
        <td>
 
212
          <para style="P8">余额</para>
214
213
        </td>
215
214
      </tr>
216
215
    </blockTable>
217
216
    <blockTable colWidths="56.0,66.0,58.0,95.0,69.0,69.0,44.0,82.0" style="&#x8868;&#x683C;2">
218
217
      <tr>
219
218
        <td>
220
 
          <para style="P4">[[data['all_date']['period_start_date_start'] ]]</para>
221
 
        </td>
222
 
        <td>
223
 
          <para style="P4">
224
 
            <font color="white"> </font>
225
 
          </para>
226
 
        </td>
227
 
        <td>
228
 
          <para style="P4">期初余额</para>
229
 
        </td>
230
 
        <td>
231
 
          <para style="P4">
232
 
            <font color="white"> </font>
233
 
          </para>
234
 
        </td>
235
 
        <td>
236
 
          <para style="P5">
237
 
            <font color="white"> </font>
238
 
          </para>
239
 
        </td>
240
 
        <td>
241
 
          <para style="P5">
242
 
            <font color="white"> </font>
243
 
          </para>
244
 
        </td>
245
 
        <td>
246
 
          <para style="P4">
247
 
            <font color="white"> </font>
248
 
          </para>
249
 
        </td>
250
 
        <td>
251
 
          <para style="P5">[[formatLang(balance(date_stop=data['all_date']['period_start_date_start'])['balance'])]]</para>
 
219
          <para style="P5">[[data['all_date']['period_start_date_start'] ]]</para>
 
220
        </td>
 
221
        <td>
 
222
          <para style="P5">
 
223
            <font color="white"> </font>
 
224
          </para>
 
225
        </td>
 
226
        <td>
 
227
          <para style="P5">期初余额</para>
 
228
        </td>
 
229
        <td>
 
230
          <para style="P5">
 
231
            <font color="white"> </font>
 
232
          </para>
 
233
        </td>
 
234
        <td>
 
235
          <para style="P6">
 
236
            <font color="white"> </font>
 
237
          </para>
 
238
        </td>
 
239
        <td>
 
240
          <para style="P6">
 
241
            <font color="white"> </font>
 
242
          </para>
 
243
        </td>
 
244
        <td>
 
245
          <para style="P5">
 
246
            <font color="white"> </font>
 
247
          </para>
 
248
        </td>
 
249
        <td>
 
250
          <para style="P6">[[formatLang(balance(o.id,date_stop=data['all_date']['period_start_date_start'])['balance'])]]</para>
252
251
        </td>
253
252
      </tr>
254
253
    </blockTable>
255
254
    <section>
256
 
      <para style="P6">[[repeatIn(lines(),'period')]]</para>
 
255
      <para style="P7">[[repeatIn(lines(o.id),'period')]]</para>
257
256
      <section>
258
 
        <para style="P6">[[repeatIn(period['lines'],'line')]]</para>
 
257
        <para style="P7">[[repeatIn(period['lines'],'line')]]</para>
259
258
        <blockTable colWidths="56.0,66.0,58.0,95.0,69.0,69.0,44.0,82.0" style="&#x8868;&#x683C;3">
260
259
          <tr>
261
260
            <td>
262
 
              <para style="P4">[[ line.date ]]</para>
263
 
            </td>
264
 
            <td>
265
 
              <para style="P4">[[ line.move_id.name ]]</para>
266
 
            </td>
267
 
            <td>
268
 
              <para style="P4">[[line.name ]]</para>
269
 
            </td>
270
 
            <td>
271
 
              <para style="P4">[[ contrepartie([line.id])[line.id] ]]</para>
272
 
            </td>
273
 
            <td>
274
 
              <para style="P4">[[ formatLang(line.debit) ]]</para>
275
 
            </td>
276
 
            <td>
277
 
              <para style="P4">[[ formatLand(line.credit) ]]</para>
278
 
            </td>
279
 
            <td>
280
 
              <para style="P4">[[get_direction(line.debit-line.credit)]]</para>
281
 
            </td>
282
 
            <td>
283
 
              <para style="P4">
 
261
              <para style="P5">[[ line.date ]]</para>
 
262
            </td>
 
263
            <td>
 
264
              <para style="P5">[[ line.move_id.name ]]</para>
 
265
            </td>
 
266
            <td>
 
267
              <para style="P5">[[line.name ]]</para>
 
268
            </td>
 
269
            <td>
 
270
              <para style="P5">[[ contrepartie([line.id])[line.id] ]]</para>
 
271
            </td>
 
272
            <td>
 
273
              <para style="P6">[[ formatLang(line.debit) ]]</para>
 
274
            </td>
 
275
            <td>
 
276
              <para style="P6">[[ formatLang(line.credit) ]]</para>
 
277
            </td>
 
278
            <td>
 
279
              <para style="P5">[[get_direction(line.debit-line.credit)]]</para>
 
280
            </td>
 
281
            <td>
 
282
              <para style="P5">
284
283
                <font color="white"> </font>
285
284
              </para>
286
285
            </td>
290
289
      <blockTable colWidths="56.0,66.0,58.0,95.0,69.0,69.0,44.0,82.0" style="&#x8868;&#x683C;4">
291
290
        <tr>
292
291
          <td>
293
 
            <para style="P3">
294
 
              <font color="white"> </font>
295
 
            </para>
296
 
          </td>
297
 
          <td>
298
 
            <para style="P3">
299
 
              <font color="white"> </font>
300
 
            </para>
301
 
          </td>
302
 
          <td>
303
 
            <para style="P4">本期合计</para>
304
 
          </td>
305
 
          <td>
306
 
            <para style="P4">
307
 
              <font color="white"> </font>
308
 
            </para>
309
 
          </td>
310
 
          <td>
311
 
            <para style="P5">[[formatLang(reduce(lambda x,y:x+y.debit or 0 ,period['lines'],0))]]</para>
312
 
          </td>
313
 
          <td>
314
 
            <para style="P5">[[formatLang(reduce(lambda x,y:x+y.credit or 0 ,period['lines'],0))]]</para>
315
 
          </td>
316
 
          <td>
317
 
            <para style="P4">[[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>
318
 
          </td>
319
 
          <td>
320
 
            <para style="P5">[[formatLang(balance(date_stop=period['period'].date_stop)['balance'])]]</para>
 
292
            <para style="P4">
 
293
              <font color="white"> </font>
 
294
            </para>
 
295
          </td>
 
296
          <td>
 
297
            <para style="P4">
 
298
              <font color="white"> </font>
 
299
            </para>
 
300
          </td>
 
301
          <td>
 
302
            <para style="P5">本期合计</para>
 
303
          </td>
 
304
          <td>
 
305
            <para style="P5">
 
306
              <font color="white"> </font>
 
307
            </para>
 
308
          </td>
 
309
          <td>
 
310
            <para style="P6">[[formatLang(reduce(lambda x,y:x+y.debit or 0 ,period['lines'],0))]]</para>
 
311
          </td>
 
312
          <td>
 
313
            <para style="P6">[[formatLang(reduce(lambda x,y:x+y.credit or 0 ,period['lines'],0))]]</para>
 
314
          </td>
 
315
          <td>
 
316
            <para style="P5">[[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>
 
317
          </td>
 
318
          <td>
 
319
            <para style="P6">[[formatLang(balance(o.id, date_stop=period['period'].date_stop)['balance'])]]</para>
321
320
          </td>
322
321
        </tr>
323
322
        <tr>
324
323
          <td>
325
 
            <para style="P3">
326
 
              <font color="white"> </font>
327
 
            </para>
328
 
          </td>
329
 
          <td>
330
 
            <para style="P3">
331
 
              <font color="white"> </font>
332
 
            </para>
333
 
          </td>
334
 
          <td>
335
 
            <para style="P4">本年合计</para>
336
 
          </td>
337
 
          <td>
338
 
            <para style="P4">
339
 
              <font color="white"> </font>
340
 
            </para>
341
 
          </td>
342
 
          <td>
343
 
            <para style="P5">[[formatLang(balance(date_start=data['all_date']['period_start_date_start'],date_stop=days['date'])['debit'])]]</para>
344
 
          </td>
345
 
          <td>
346
 
            <para style="P5">[[formatLang(balance(date_start=data['all_date']['period_start_date_start'],date_stop=days['date'])['credit'])]]</para>
347
 
          </td>
348
 
          <td>
349
 
            <para style="P5">[[get_direction(balance(date_start=data['all_date']['period_start_date_start'],date_stop=days['date'])['debit'] -balance(date_start=data['all_date']['period_start_date_start'],date_stop=days['date'])['credit'])]]</para>
350
 
          </td>
351
 
          <td>
352
 
            <para style="P5">[[formatLang(balance(date_stop=period['period'].date_stop)['balance'])]]</para>
 
324
            <para style="P4">
 
325
              <font color="white"> </font>
 
326
            </para>
 
327
          </td>
 
328
          <td>
 
329
            <para style="P4">
 
330
              <font color="white"> </font>
 
331
            </para>
 
332
          </td>
 
333
          <td>
 
334
            <para style="P5">本年合计</para>
 
335
          </td>
 
336
          <td>
 
337
            <para style="P5">
 
338
              <font color="white"> </font>
 
339
            </para>
 
340
          </td>
 
341
          <td>
 
342
            <para style="P6">[[formatLang(balance(o.id, date_start=data['all_date']['period_start_date_start'],date_stop=period['period'].date_stop)['debit'])]]</para>
 
343
          </td>
 
344
          <td>
 
345
            <para style="P6">[[formatLang(balance(o.id, date_start=data['all_date']['period_start_date_start'],date_stop=period['period'].date_stop)['credit'])]]</para>
 
346
          </td>
 
347
          <td>
 
348
            <para style="P5">[[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>
 
349
          </td>
 
350
          <td>
 
351
            <para style="P6">[[formatLang(balance(o.id, date_stop=period['period'].date_stop)['balance'])]]</para>
353
352
          </td>
354
353
        </tr>
355
354
      </blockTable>
356
 
      <para style="P6">
357
 
        <font color="white"> </font>
358
 
      </para>
359
355
    </section>
360
356
  </story>
361
357
</document>