<?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 defaultWhereClause="" fetchAll="true" model="rpt.RPT5010.rpt5010_result_query" rootPath="/model/datasource"/>
        <a:model-query fetchAll="true" model="rpt.RPT5010.rpt5010_date" rootPath="/model/day"/>
        <dr:excel-report enableTask="false" filename="${/parameter/@file_name}">
            <dr:styles>
                <dr:cell-style name="cell1" align="ALIGN_LEFT" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="宋体" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="cell2" align="ALIGN_RIGHT" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="Arial" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="cell3" align="ALIGN_CENTER" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="Arial" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="header" cell_style_id="2" foregroundcolor="BLACK">
                    <dr:font cell_style_id="2" fontname="宋体" height="10"/>
                </dr:cell-style>
            </dr:styles>
            <dr:sheets>
                <dr:sheet name="sheet1" 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 cell="A" dataModel="/model/day" row="1">
                        <dr:cell-data cell="A" offset="false" range="$A$1:$A$2" row="1" styleName="cell3" type="content" value="合同编号"/>
                        <dr:cell-data cell="B" offset="false" range="$B$1:$D$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_1}"/>
                        <dr:cell-data cell="E" offset="false" range="$E$1:$G$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_2}"/>
                        <dr:cell-data cell="H" offset="false" range="$H$1:$J$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_3}"/>
                        <dr:cell-data cell="K" offset="false" range="$K$1:$M$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_4}"/>
                        <dr:cell-data cell="N" offset="false" range="$N$1:$P$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_5}"/>
                        <dr:cell-data cell="Q" offset="false" range="$Q$1:$S$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_6}"/>
                        <dr:cell-data cell="T" offset="false" range="$T$1:$V$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_7}"/>
                        <dr:cell-data cell="W" offset="false" range="$W$1:$Y$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_8}"/>
                        <dr:cell-data cell="Z" offset="false" range="$Z$1:$AB$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_9}"/>
                        <dr:cell-data cell="AC" offset="false" range="$AC$1:$AE$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_10}"/>
                        <dr:cell-data cell="AF" offset="false" range="$AF$1:$AH$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_11}"/>
                        <dr:cell-data cell="AI" offset="false" range="$AI$1:$AK$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_12}"/>
                        <dr:cell-data cell="AL" offset="false" range="$AL$1:$AN$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_13}"/>
                        <dr:cell-data cell="AO" offset="false" range="$AO$1:$AQ$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_14}"/>
                        <dr:cell-data cell="AR" offset="false" range="$AR$1:$AT$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_15}"/>
                        <dr:cell-data cell="AU" offset="false" range="$AU$1:$AW$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_16}"/>
                        <dr:cell-data cell="AX" offset="false" range="$AX$1:$AZ$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_17}"/>
                        <dr:cell-data cell="BA" offset="false" range="$BA$1:$BC$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_18}"/>
                        <dr:cell-data cell="BD" offset="false" range="$BD$1:$BF$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_19}"/>
                        <dr:cell-data cell="BG" offset="false" range="$BG$1:$BI$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_20}"/>
                        <dr:cell-data cell="BJ" offset="false" range="$BJ$1:$BL$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_21}"/>
                        <dr:cell-data cell="BM" offset="false" range="$BM$1:$BO$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_22}"/>
                        <dr:cell-data cell="BP" offset="false" range="$BP$1:$BR$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_23}"/>
                        <dr:cell-data cell="BS" offset="false" range="$BS$1:$BU$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_24}"/>
                        <dr:cell-data cell="BV" offset="false" range="$BV$1:$BX$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_25}"/>
                        <dr:cell-data cell="BY" offset="false" range="$BY$1:$CA$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_26}"/>
                        <dr:cell-data cell="CB" offset="false" range="$CB$1:$CD$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_27}"/>
                        <dr:cell-data cell="CE" offset="false" range="$CE$1:$CG$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_28}"/>
                        <dr:cell-data cell="CH" offset="false" range="$CH$1:$CJ$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_29}"/>
                        <dr:cell-data cell="CK" offset="false" range="$CK$1:$CM$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_30}"/>
                        <dr:cell-data cell="CN" offset="false" range="$CN$1:$CP$1" row="1" styleName="cell3" type="content" value="${/model/day/record/@day_31}"/>
                    </dr:static-content>
                    <dr:dynamic-content cell="A" dataModel="/model/datasource" row="2">
                        <dr:columns>
                            <dr:table-column cellStyle="cell1" field="contract_number" title="合同编号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_1" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_1" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_1" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_2" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_2" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_2" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_3" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_3" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_3" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_4" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_4" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_4" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_5" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_5" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_5" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_6" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_6" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_6" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_7" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_7" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_7" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_8" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_8" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_8" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_9" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_9" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_9" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_10" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_10" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_10" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_11" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_11" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_11" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_12" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_12" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_12" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_13" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_13" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_13" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_14" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_14" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_14" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_15" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_15" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_15" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_16" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_16" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_16" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_17" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_17" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_17" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_18" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_18" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_18" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_19" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_19" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_19" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_20" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_20" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_20" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_21" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_21" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_21" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_22" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_22" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_22" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_23" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_23" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_23" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_24" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_24" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_24" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_25" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_25" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_25" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_26" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_26" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_26" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_27" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_27" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_27" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_28" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_28" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_28" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_29" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_29" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_29" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_30" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_30" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_30" title="利息总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="amount_31" title="租金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="principal_31" title="本金总额(未核销)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="interest_31" title="利息总额(未核销)" titlestyle="header" type="content"/>
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet>
            </dr:sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>