<?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>