psr_report_test.lsc 5.28 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
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 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
<?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>
        <a:model-query fetchAll="true" model="psr.psr_datasource_test_result" rootPath="/model/banks"/>
        <dr:excel-report enableTask="false" fileName="banks.xlsx">
            <styles>
                <dr:cell-style name="title" align="ALIGN_CENTER">
                    <dr:font bold="true" fontName="黑体" height="18" italic="false"/>
                </dr:cell-style>
                <dr:cell-style name="header" align="ALIGN_CENTER">
                    <dr:font bold="true" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="foot">
                    <dr:font bold="true" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="footNumber" dataFormat="#,##0.000">
                    <dr:font bold="true" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="group">
                    <dr:font bold="true" fontName="宋体" height="12"/>
                </dr:cell-style>
            </styles>
            <sheets>
                <dr:sheet name="banks" autoSizeColumns="0,1,2,3,4,5" displayGridlines="false">
                    <dr:static-content>
                        <dr:cell-data cell="A" offset="false" range="$A$1:$E$1" row="1" stylename="title" type="content" value="银行清单"/>
                        <!--                         <dr:cell-data cell="A" offset="true" row="1" stylename="foot" type="content" value="备注"/>
 -->
                    </dr:static-content>
                    <dr:dynamic-content cell="A" datamodel="/model/banks" row="2">
                        <dr:columns>
                            <dr:table-column cellStyle="common" column_id="442" field="bank_code" grouplevel="2" merged="true" title="银行编号" titlestyle="header" type="content">
                                <!-- <dr:groups>
                                    <dr:subtotal-config column_id="443" formulaStyle="group" groupStyle="group" groupdesc="计数" groupfield="bank_code" groupformula="3" lineStyle="line" totaldesc="总计数"/>
                                </dr:groups> --><![CDATA[
                                
                                
                                
                                
                                
                                
                            ]]></dr:table-column>
                            <dr:table-column cellStyle="common" column_id="443" field="bank_name" grouplevel="2" merged="true" title="银行名称" titlestyle="header" type="content">
                                <!--   <dr:groups>
                                    <dr:subtotal-config column_id="443" formulaStyle="group" groupStyle="group" groupdesc="计数" groupfield="bank_code" groupformula="3" lineStyle="line" totaldesc="总计数"/>
                                </dr:groups> --><![CDATA[
                                
  
                            ]]></dr:table-column>
                            <dr:table-column cellStyle="common" column_id="444" field="bank_branch_code" grouplevel="1" merged="true" title="支行编号" titlestyle="header" type="content"><![CDATA[
                                
                            ]]></dr:table-column>
                            <dr:table-column cellStyle="common" column_id="445" field="branch_name" grouplevel="1" merged="true" title="支行名称" titlestyle="header" type="content">
                                <dr:groups>
                                    <dr:subtotal-config column_id="444" formulaStyle="group" groupStyle="group" groupdesc="计数" groupfield="bank_code,bank_branch_code" groupformula="3" lineStyle="line" totaldesc="总计数"/>
                                </dr:groups>
                            </dr:table-column>
                            <dr:table-column cellStyle="common" column_id="446" field="bank_account_num" title="支行账户号" titlestyle="header" type="content"/>
                            <!-- <table-column column_id="447" titlestyle="header" type="content" field="currency_code" title="币种">
                            <groups>
                                <subtotal-config groupdesc="计数" column_id="447" groupfield="bank_branch_code" groupformula="3" totaldesc="总计数"/>
                            </groups>
                        </table-column>
                        <table-column column_id="448" titlestyle="header" type="content" field="deposit" title="存款金额">
                            <groups>
                                <subtotal-config groupdesc="平均值" column_id="448" groupfield="bank_branch_code" groupformula="1" totaldesc="总计平均值"/>
                            </groups>
                        </table-column> -->
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet>
            </sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>