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
<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:msg="leaf.application.features.msg" xmlns:a="http://www.leaf-framework.org/application" xmlns:task="leaf.application.task" xmlns:excel="leaf.application.task.excel" xmlns:dr="leaf.plugin.excelreport" xmlns:t="uncertain.composite.transform" xmlns:mail="leaf.plugin.mail" xmlns:p="uncertain.proc" trace="true">
<a:init-procedure>
<!--数据DS-->
<a:model-query defaultWhereClause="t1.contract_id =${@contract_id}" fetchAll="true" model="cont.CON114.con_contract_cashflow" rootPath="/model/basic_data"/>
<dr:excel-report enableTask="false" filename="现金流基本信息.xlsx" template="${/request/@context_path/autocrud}/template/con114_cashflow_info.xlsx">
<dr:styles>
<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="宋体" 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="宋体" 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="现金流基本信息" displayGridlines="false">
<dr:dynamic-content cell="A" dataModel="/model/basic_data" row="1">
<dr:columns>
<dr:table-column cellStyle="cell4" field="times" type="content"/>
<dr:table-column cellStyle="cell4" field="cf_item_n" type="content"/>
<dr:table-column cellStyle="cell4" field="calc_date_n" type="content"/>
<dr:table-column cellStyle="cell4" field="due_date_n" type="content"/>
<dr:table-column cellStyle="cell2" field="due_amount" type="content"/>
<dr:table-column cellStyle="cell2" field="principal" type="content"/>
<dr:table-column cellStyle="cell2" field="interest" type="content"/>
<dr:table-column cellStyle="cell4" field="outstanding_prin_tax_incld" type="content"/>
<dr:table-column cellStyle="cell4" field="generated_source" type="content"/>
</dr:columns>
</dr:dynamic-content>
</dr:sheet>
</dr:sheets>
</dr:excel-report>
</a:init-procedure>
</a:service>