penalty_reduction_excel.lsc

<?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.CON1020.con_penalty_query"  rootPath="/model/con_penalty_query"/>
        <dr:excel-report enableTask="false" filename="滞纳金减免详细内容.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_BOTTOM">
                    <dr:font bold="false" fontName="宋体" height="10"/>
                </dr:cell-style>
                <dr:cell-style name="cell4" align="ALIGN_RIGHT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_BOTTOM">
                    <dr:font bold="false" fontName="Arial" height="10"/>
                </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_BOTTOM">
                    <dr:font bold="false" fontName="宋体" height="10"/>
                </dr:cell-style>
                <dr:cell-style name="cell2" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_BOTTOM">
                    <dr:font bold="false" fontName="微软雅黑" height="11" />
                </dr:cell-style>
                <dr:cell-style name="header" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" cell_style_id="2" foregroundcolor="BLACK" vertical="VERTICAL_BOTTOM">
                    <dr:font bold="true" cell_style_id="2" fontname="微软雅黑" height="11"/>
                </dr:cell-style>

            </dr:styles>
            <dr:sheets>
                <dr:sheet name="滞纳金减免详情表" autoSizeColumns="0,1,2,3,4,5,6,7,8" displayGridlines="true">
                    <dr:dynamic-content cell="A" row="1" dataModel="/model/con_penalty_query"  >
                        <dr:columns>
                            <dr:table-column cellStyle="cell2" field="penalty_batch_number" titlestyle="header" type="Number" title="批次号"/>
                            <dr:table-column cellStyle="cell2" field="contract_number" titlestyle="header" type="Number" title="合同号"/>
                            <dr:table-column cellStyle="cell2" field="bp_name_agent" titlestyle="header" type="content" title="代理店简称"/>
                            <dr:table-column cellStyle="cell2" field="bp_name_tenant" titlestyle="header" type="content" title="客户名称"/>
                            <dr:table-column cellStyle="cell2" field="breach_type_n" titlestyle="header" type="content" title="违约金类型"/>
                            <dr:table-column cellStyle="cell2" field="reduce_amount_total" titlestyle="header" type="Number" title="减免总金额"/>
                            <dr:table-column cellStyle="cell2" field="base_date" titlestyle="header" type="Number" title="基准日"/>
                            <dr:table-column cellStyle="cell2" field="created_by_n" titlestyle="header"  title="创建人"/>
                            <dr:table-column cellStyle="cell2" field="status_n" titlestyle="header" type="content" title="状态"/>
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet>
            </dr:sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>