<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:a="http://www.leaf-framework.org/application" xmlns:dr="leaf.plugin.excelreport" trace="true">
    <a:init-procedure>
        <a:model-query  fetchAll="true" model="rpt.RPT5014.rpt5014_six_month" rootPath="/model/day"/>
        <a:model-query  fetchAll="true" model="rpt.RPT5014.rpt5014_result_query" rootPath="/model/datasource"/>
        <dr:excel-report enableTask="true" filename="${/parameter/@file_name}">
            <dr:styles>
                <dr:cell-style  name="cell1" align="ALIGN_CENTER" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="Arial" height="10"/>
                </dr:cell-style>
                <dr:cell-style  name="cell2" pattern="SOLID_FOREGROUND" align="ALIGN_CENTER" vertical="VERTICAL_CENTER" foregroundcolor="YELLOW">
                    <dr:font bold="true" fontName="宋体" height="25"/>
                </dr:cell-style>
                <dr:cell-style name="cell3" align="ALIGN_CENTER" vertical="VERTICAL_CENTER">
                    <dr:font bold="true" fontName="Arial" height="10"/>
                </dr:cell-style>
                <dr:cell-style  name="green" pattern="SOLID_FOREGROUND" align="ALIGN_CENTER" vertical="VERTICAL_CENTER" foregroundcolor="BRIGHT_GREEN">
                    <dr:font bold="true" fontName="宋体" height="15"/>
                </dr:cell-style>
                <dr:cell-style  name="orange" pattern="SOLID_FOREGROUND" align="ALIGN_CENTER" vertical="VERTICAL_CENTER" foregroundcolor="ORANGE">
                    <dr:font bold="true" fontName="宋体" height="15"/>
                </dr:cell-style>
                <dr:cell-style  name="pink" pattern="SOLID_FOREGROUND" align="ALIGN_CENTER" vertical="VERTICAL_CENTER" foregroundcolor="PINK">
                    <dr:font bold="true" fontName="宋体" height="15"/>
                </dr:cell-style>
                <dr:cell-style  name="yellow" pattern="SOLID_FOREGROUND" align="ALIGN_CENTER" vertical="VERTICAL_CENTER" foregroundcolor="YELLOW">
                    <dr:font bold="true" fontName="宋体" height="15"/>
                </dr:cell-style>
                <dr:cell-style  name="blue" pattern="SOLID_FOREGROUND" align="ALIGN_CENTER" vertical="VERTICAL_CENTER" foregroundcolor="BLUE">
                    <dr:font bold="true" fontName="宋体" height="15"/>
                </dr:cell-style>
            </dr:styles>
            <dr:sheets>
                <dr:sheet name="明细表" autoSizeColumns="0,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,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119" displayGridlines="true">
                    <dr:static-content dataModel="/model/day">
                        <dr:cell-data cell="U" offset="false" row="1" styleName="cell3" type="content" value="三期类型"/>
                        <dr:cell-data cell="V" offset="false" row="1" styleName="cell3" type="content" value="A"/>
                        <dr:cell-data cell="V" offset="false" row="2" styleName="cell3" type="content" value="B"/>
                        <dr:cell-data cell="V" offset="false" row="3" styleName="cell3" type="content" value="C"/>
                        <dr:cell-data cell="F" offset="false" range="$F$2:$L$2" row="2" styleName="cell2" type="content" value="${/model/day/record/@befor_title}"/>
                        <dr:cell-data cell="w" offset="false" range="$w$1:$Z$1" row="1" styleName="cell3" type="content" value="GPS正常,且能连续还款"/>
                        <dr:cell-data cell="w" offset="false" range="$w$2:$Z$2" row="2" styleName="cell3" type="content" value="GPS正常,但不能连续还款"/>
                        <dr:cell-data cell="w" offset="false" range="$w$3:$Z$3" row="3" styleName="cell3" type="content" value="GPS无效,但能连续还款"/>
                        <dr:cell-data cell="AG" offset="false" row="1" styleName="cell3" type="content" value="E"/>
                        <dr:cell-data cell="AG" offset="false" row="2" styleName="cell3" type="content" value="D"/>
                        <dr:cell-data cell="AG" offset="false" row="3" styleName="cell3" type="content" value="F"/>
                        <dr:cell-data cell="AG" offset="false" row="4" styleName="cell3" type="content" value="G"/>
                        <dr:cell-data cell="AH" offset="false"  row="1" styleName="cell3" type="content" value="GPS无效,不能连续还款,但能确认机器位置"/>
                        <dr:cell-data cell="AH" offset="false" row="2" styleName="cell3" type="content" value="GPS无效,不能连续还款,且不能确认机器位置"/>
                        <dr:cell-data cell="AH" offset="false" row="3" styleName="cell3" type="content" value="人、机灭失F"/>
                        <dr:cell-data cell="AH" offset="false"  row="4" styleName="cell3" type="content" value="机器已拖回或已控制"/>
                        <dr:cell-data cell="A" offset="false" row="5" styleName="green" type="content" value="代理店名称"/>
                        <dr:cell-data cell="B" offset="false" row="5" styleName="green" type="content" value="客户"/>
                        <dr:cell-data cell="C" offset="false" row="5" styleName="green" type="content" value="分公司"/>
                        <dr:cell-data cell="D" offset="false" row="5" styleName="green" type="content" value="融资合同号"/>
                        <dr:cell-data cell="E" offset="false" row="5" styleName="green" type="content" value="起租日"/>
                        <dr:cell-data cell="F" offset="false" row="5" styleName="green" type="content" value="合同到期日"/>
                        <dr:cell-data cell="G" offset="false" row="5" styleName="green" type="content" value="机号"/>
                        <dr:cell-data cell="H" offset="false" row="5" styleName="green" type="content" value="机型"/>
                        <dr:cell-data cell="I" offset="false" row="5" styleName="green" type="content" value="合同总金额(A)"/>
                        <dr:cell-data cell="J" offset="false" row="5" styleName="green" type="content" value="合同期数"/>
                        <dr:cell-data cell="K" offset="false" row="5" styleName="green" type="content" value="销售价格"/>
                        <dr:cell-data cell="L" offset="false" row="5" styleName="green" type="content" value="首付金额"/>
                        <dr:cell-data cell="M" offset="false" row="5" styleName="green" type="content" value="留购金"/>
                        <dr:cell-data cell="N" offset="false" row="5" styleName="green" type="content" value="已收款(A-B)"/>
                        <dr:cell-data cell="O" offset="false" row="5" styleName="green" type="content" value="上月末应收款余额(B)"/>
                        <dr:cell-data cell="P" offset="false" row="5" styleName="green" type="content" value="期次"/>
                        <dr:cell-data cell="Q" offset="false" row="5" styleName="green" type="content" value="本月合同应收日期"/>
                        <dr:cell-data cell="R" offset="false" row="5" styleName="green" type="content" value="本月合同应收租金"/>
                        <dr:cell-data cell="S" offset="false" row="5" styleName="green" type="content" value="截止上月末提前支付"/>
                        <dr:cell-data cell="T" offset="false" row="5" styleName="green" type="content" value="本月合同应收租金(减提前支付)"/>
                        <dr:cell-data cell="U" offset="false" row="5" styleName="green" type="content" value="截止上月末逾期租金"/>
                        <dr:cell-data cell="V" offset="false" row="5" styleName="green" type="content" value="本月合计应收"/>
                        <dr:cell-data cell="W" offset="false" row="5" styleName="blue" type="content" value="${/model/day/record/@cur_overdue_times}"/>
                        <dr:cell-data cell="X" offset="false" row="5" styleName="orange" type="content" value="${/model/day/record/@cur_hour}"/>
                        <dr:cell-data cell="Y" offset="false" row="5" styleName="orange" type="content" value="${/model/day/record/@befor1_hour}"/>
                        <dr:cell-data cell="Z" offset="false" row="5" styleName="orange" type="content" value="${/model/day/record/@befor2_hour}"/>
                        <dr:cell-data cell="AA" offset="false" row="5" styleName="pink" type="content" value="${/model/day/record/@cur_amount}"/>
                        <dr:cell-data cell="AB" offset="false" row="5" styleName="pink" type="content" value="${/model/day/record/@befor1_amount}"/>
                        <dr:cell-data cell="AC" offset="false" row="5" styleName="pink" type="content" value="${/model/day/record/@befor2_amount}"/>
                        <dr:cell-data cell="AD" offset="false" row="5" styleName="pink" type="content" value="${/model/day/record/@befor3_amount}"/>
                        <dr:cell-data cell="AE" offset="false" row="5" styleName="pink" type="content" value="${/model/day/record/@befor4_amount}"/>
                        <dr:cell-data cell="AF" offset="false" row="5" styleName="pink" type="content" value="${/model/day/record/@befor5_amount}"/>
                        <dr:cell-data cell="AG" offset="false" row="5" styleName="yellow" type="content" value="GPS是否有效"/>
                        <dr:cell-data cell="AH" offset="false" row="5" styleName="yellow" type="content" value="提供照片/说明/逾期降至3期内/回购/结清"/>
                        <dr:cell-data cell="AI" offset="false" row="5" styleName="yellow" type="content" value="三期所属类型"/>
                        <dr:cell-data cell="AJ" offset="false" row="5" styleName="orange" type="content" value="客户三期原因及解决方案"/>
                    </dr:static-content>
                    <dr:dynamic-content cell="A" dataModel="/model/datasource" row="5">
                        <dr:columns>
                            <dr:table-column cellStyle="cell1" field="agent_extra_name"/>
                            <dr:table-column cellStyle="cell1" field="bp_tenant_name"/>
                            <dr:table-column cellStyle="cell1" field="branch_company"/>
                            <dr:table-column cellStyle="cell1" field="contract_number"/>
                            <dr:table-column cellStyle="cell1" field="lease_start_date"/>
                            <dr:table-column cellStyle="cell1" field="residual_date"/>
                            <dr:table-column cellStyle="cell1" field="machine_number"/>
                            <dr:table-column cellStyle="cell1" field="modelcd"/>
                            <dr:table-column cellStyle="cell1" field="contract_amount"/>
                            <dr:table-column cellStyle="cell1" field="lease_times"/>
                            <dr:table-column cellStyle="cell1" field="lease_item_amount"/>
                            <dr:table-column cellStyle="cell1" field="down_payment"/>
                            <dr:table-column cellStyle="cell1" field="residual_amount"/>
                            <dr:table-column cellStyle="cell1" field="before_received_amount"/>
                            <dr:table-column cellStyle="cell1" field="before_due_left"/>
                            <dr:table-column cellStyle="cell1" field="times"/>
                            <dr:table-column cellStyle="cell1" field="due_date"/>
                            <dr:table-column cellStyle="cell1" field="due_amount"/>
                            <dr:table-column cellStyle="cell1" field="advance_received_amount"/>
                            <dr:table-column cellStyle="cell1" field="due_amount"/>
                            <dr:table-column cellStyle="cell1" field="before_overdue_amount"/>
                            <dr:table-column cellStyle="cell1" field="due_total"/>
                            <dr:table-column cellStyle="cell1" field="over_due_times"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                            <dr:table-column cellStyle="cell1" field="cur_real"/>
                            <dr:table-column cellStyle="cell1" field="before1_real"/>
                            <dr:table-column cellStyle="cell1" field="before2_real"/>
                            <dr:table-column cellStyle="cell1" field="before3_real"/>
                            <dr:table-column cellStyle="cell1" field="before4_real"/>
                            <dr:table-column cellStyle="cell1" field="before5_real"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                            <dr:table-column cellStyle="cell1" field="null_column"/>
                        </dr:columns>
                    </dr:dynamic-content>

                </dr:sheet>
            </dr:sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>