1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:sel="www.shanghai-electric.com" xmlns:msg="leaf.application.features.msg" xmlns:a="http://www.leaf-framework.org/application" xmlns:task="leaf.application.task" xmlns:dr="leaf.plugin.excelreport" xmlns:mail="leaf.plugin.mail" xmlns:et="leaf.plugin.export.task" xmlns:p="uncertain.proc" trace="true">
<a:init-procedure>
<p:switch test="/parameter/@bank_branch_name">
<p:case value="建行">
<a:model-query defaultWhereClause="t1.batch_id = ${/parameter/@batch_id};" fetchAll="true" model="csh.CSH533.csh_transaction_interface" rootPath="/model/datasource"/>
<dr:excel-report enableTask="false" filename="${/parameter/@file_name}">
<dr:styles>
<!-- <dr:cell-style name="title" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" cell_style_id="1" vertical="VERTICAL_CENTER">
<dr:font bold="false" cell_style_id="1" fontname="宋体" height="9"/>
</dr:cell-style> -->
<dr:cell-style name="cell1" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
<dr:font bold="false" fontName="宋体" height="9"/>
</dr:cell-style>
<dr:cell-style name="cell2" align="ALIGN_RIGHT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
<dr:font bold="false" fontName="Arial" height="9"/>
</dr:cell-style>
<dr:cell-style name="cell3" align="ALIGN_LEFT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
<dr:font bold="false" fontName="宋体" height="9"/>
</dr:cell-style>
<dr:cell-style name="cell4" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
<dr:font bold="false" fontName="Arial" height="9"/>
</dr:cell-style>
<dr:cell-style name="header" align="ALIGN_LEFT" borderbottom="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" cell_style_id="2" foregroundcolor="BLACK">
<dr:font bold="true" cell_style_id="2" fontname="宋体" height="10"/>
</dr:cell-style>
</dr:styles>
<dr:sheets>
<dr:sheet name="收入确认" autoSizeColumns="0,1,2,3,4,5,6,7,8,9,10,11" displayGridlines="false">
<dr:static-content>
<dr:cell-data cell="A" row="1" stylename="header" type="content" value="报表名"/>
<dr:cell-data cell="A" row="2" stylename="header" type="content" value="制表日期"/>
<dr:cell-data cell="A" row="3" stylename="header" type="content" value="期间"/>
<dr:cell-data cell="A" row="4" stylename="header" type="content" value="制表人"/>
<dr:cell-data cell="B" row="1" type="content" value="收入确认报表"/>
<!-- <dr:cell-data cell="B" row="2" type="content" value="${/model/header/record/@now_date}"/>
<dr:cell-data cell="B" row="3" type="content" value="${/parameter/@period_name}"/>
<dr:cell-data cell="B" row="4" type="content" value="${/model/header/record/@employee_name}"/> -->
</dr:static-content>
<dr:dynamic-content cell="A" dataModel="/model/datasource" row="5">
<dr:columns>
<dr:table-column cellStyle="cell4" field="ebank_cust_acc_num" title="卡号" titlestyle="header" type="content"/>
<dr:table-column cellStyle="cell1" field="csh_bp_bank_account_name" grouplevel="2" merged="true" title="姓名" titlestyle="header" type="content"/>
<dr:table-column cellStyle="cell2" field="ebank_trx_amt" grouplevel="2" merged="true" title="金额" titlestyle="header" type="content"/>
<!-- <dr:table-column cellStyle="cell3" title="所属期间" titlestyle="header" type="content"/> -->
</dr:columns>
</dr:dynamic-content>
</dr:sheet>
</dr:sheets>
</dr:excel-report>
</p:case>
<p:case><![CDATA[
]]></p:case>
</p:switch>
</a:init-procedure>
</a:service>