<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:sel="www.shanghai-electric.com" xmlns:msg="leaf.application.features.msg" xmlns:a="http://www.leaf-framework.org/application" xmlns:task="leaf.application.task" xmlns:dr="leaf.plugin.excelreport" xmlns:mail="leaf.plugin.mail" xmlns:et="leaf.plugin.export.task" xmlns:p="uncertain.proc" trace="true">
    <a:init-procedure>
        <a:model-query fetchAll="true" model="cont.CON620N.con_contract_overdue_lv" rootPath="/model/datasource"/>
        <dr:excel-report enableTask="false" filename="回访报告明细.xlsx" template="D:\project\web\excel_template\visit_report1.xlsx">
            <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_LEFT" 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" fontcolor="RED" 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:cell-style name="header2" cell_style_id="2" foregroundcolor="RED">
                    <dr:font cell_style_id="2" fontcolor="RED" fontname="宋体" height="10"/>
                </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" displayGridlines="true">
                    <dr:dynamic-content cell="A" dataModel="/model/datasource">
                        <dr:columns>
                            <dr:table-column cellStyle="cell1" field="bp_id_tenant_n" title="承租人" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell1" field="search_term_1" title="合同号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="serial_number" title="机编号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="inception_of_lease" title="起租日" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="lease_term" title="融资期限" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="overdue_times" title="拜访时逾期期数" titlestyle="header" type="content"/>
                            <!--   <dr:table-column cellStyle="cell2" field="overdue_amount" title="拜访时逾期租金" titlestyle="header" type="content"/> -->
                            <dr:table-column cellStyle="cell2" title="拜访日期" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="起始时段" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="结束时段" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="拜访地点" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="bp_id_guarantor_n" title="担保人" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="担保人是否拜访（Y/N)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="collector_user_id_n" title="客户服务专员" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="逾期原因" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="客户家庭成员" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="客户社会关系" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="购机前家庭主要收入来源" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="购机后家庭主要收入来源" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="其他动产不动产情况" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="从事工程状况" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="工程设备使用小时数" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="工程机械施工地点" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="是否存在保险问题" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="是否存在机器质量问题" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="客户还款态度" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="客户还款计划" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="担保人是否联系" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="担保人工作单位" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="担保人主要家庭收入来源" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="其他动产及不动产情况" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="bp_id_vender_n" title="分公司" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="employee_id_n" title="业务员" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="employee_phone" title="业务员电话" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="分公司经理及业务员对该客户的催款态度" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="分公司对保险或机器质量问题的处理意见及态度" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="综合信息" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell1" title="广告品赠送（Y/N)" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="广告品名称" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" title="广告品数量" titlestyle="header" type="content"/>
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet>
                <!--  <dr:sheet name="备注" autoSizeColumns="0,1,2,3" displayGridlines="true">
                    <dr:dynamic-content cell="C" dataModel="/model/datasource">
                        <dr:columns>
                            <dr:table-column cellStyle="cell1" title="电话催收:CALL电子邮件催收:EMAIL催款函催收:LETTER短信催收:MESSAGE上门拜访:VISIT" titlestyle="header2" type="content"/>
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet> -->
            </dr:sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>
