hlcm_business_daily.lsc 4.42 KB
Newer Older
gzj34291's avatar
gzj34291 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
<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:a="http://www.leaf-framework.org/application" xmlns:s="leaf.plugin.script"
           xmlns:dr="leaf.plugin.excelreport" trace="true">
    <a:init-procedure>
        <a:model-query fetchAll="true" model="cont.CON4000.hlcm_business_daily" rootPath="/model/hlcm_business_daily"/>
        <dr:excel-report enableTask="false" filename="营业日报.xlsx">
            <dr:styles>
                <dr:cell-style name="header" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN"
                               borderright="BORDER_THIN" bordertop="BORDER_THIN">
                    <dr:font bold="true" fontname="宋体" height="10" italic="false"/>
                </dr:cell-style>
                <dr:cell-style name="cell1" align="ALIGN_LEFT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN"
                               borderright="BORDER_THIN" bordertop="BORDER_THIN">
                    <dr:font bold="false" fontname="宋体" height="10" italic="false"/>
                </dr:cell-style>
                <dr:cell-style name="cell2" align="ALIGN_RIGHT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN"
                               borderright="BORDER_THIN" bordertop="BORDER_THIN">
                    <dr:font bold="false" fontname="Arial" height="10" italic="false"/>
                </dr:cell-style>
            </dr:styles>
            <dr:sheets>
                <dr:sheet name="建机营业日表" autoSizeColumns="0,1,2,3,4,5," displayGridlines="false" dataModel="/model/hlcm_business_daily">
                    <dr:static-content>
                        <dr:cell-data cell="C" row="1" stylename="header" type="content" value="新规案件" />
                        <dr:cell-data cell="D" row="1" stylename="header" type="content" value="新规案件" tablecolmerge="3"/>
                        <dr:cell-data cell="E" row="1" stylename="header" type="content" value="新规案件" tablecolmerge="3"/>
                        <dr:cell-data cell="F" row="1" stylename="header" type="content" value="资产余额"/>
                        <dr:cell-data cell="A" row="2" stylename="header" type="content" value="业务"/>
                        <dr:cell-data cell="B" row="2" stylename="header" type="content" value="类别"/>
                        <dr:cell-data cell="C" row="2" stylename="header" type="content" value="今日"/>
                        <dr:cell-data cell="D" row="2" stylename="header" type="content" value="累计(本月)"/>
                        <dr:cell-data cell="E" row="2" stylename="header" type="content" value="累计(本财年)"/>
                        <dr:cell-data cell="F" 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="3" stylename="header" type="content" value="台数"/>
                        <dr:cell-data cell="B" row="4" stylename="header" type="content" value="金额"/>
                        <dr:cell-data cell="C" row="3" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@day_num}"/>
                        <dr:cell-data cell="D" row="3" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@month_num}"/>
                        <dr:cell-data cell="E" row="3" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@year_num}"/>
                        <dr:cell-data cell="F" row="3" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@all_num}"/>
                        <dr:cell-data cell="C" row="4" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@day_money}"/>
                        <dr:cell-data cell="D" row="4" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@month_money}"/>
                        <dr:cell-data cell="E" row="4" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@year_money}"/>
                        <dr:cell-data cell="F" row="4" stylename="header" type="content" value="${/model/hlcm_business_daily/record/@all_money}"/>
                    </dr:static-content>
                </dr:sheet>
            </dr:sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>