<?xml version="1.0" encoding="UTF-8"?>
<a:screen xmlns:a="http://www.leaf-framework.org/application">
    <a:init-procedure/>
    <a:view>
        <script type="text/javascript"><![CDATA[
			function query_overdue_query_result_ds(){
				$('overdue_query_result_ds').query();
			}
			function reset_overdue_query_query_ds(){
				$('overdue_query_query_ds').reset();
			}
			 function render_grid_id(value, record, name) {

                    if(value<1 && value>0){
                    return "0" + value;
                    }
                return value;
            }
		]]></script>
        <a:dataSets>
            <a:dataSet id="contract_status_ds" lookupCode="CON390_CONTRACT_STATUS"/>
            <a:dataSet id="overdue_query_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="project_number"/>
                    <a:field name="contract_status_n" displayField="code_value_name" options="contract_status_ds" returnField="contract_status_n" valueField="code_value_name"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="overdue_query_result_ds" autoQuery="true" model="cont.CON924.overdue_query" queryDataSet="overdue_query_query_ds">
                <a:fields>
                    <a:field name="contract_number"/>
                    <a:field name="product_plan_id_n"/>
                    <a:field name="province_sp"/>
                    <a:field name="city_sp"/>
                    <a:field name="invoice_agent_id_n"/>
                    <a:field name="bp_class_n"/>
                    <a:field name="withhold_way_n"/>
                    <a:field name="project_number"/>
                    <a:field name="bp_name"/>
                    <a:field name="overdue_status_type_n"/>
                    <a:field name="overdue_due_date"/>
                    <a:field name="contract_status_n"/>
                    <a:field name="inception_of_lease"/>
                    <a:field name="risk_rank"/>
                    <a:field name="overdue_times"/>
                    <a:field name="overdue_max_days"/>
                    <a:field name="overdue_amount_sum"/>
                    <a:field name="overdue_principal"/>
                    <a:field name="overdue_interest"/>
                    <a:field name="penalty"/>
                    <a:field name="principal"/>
                    <a:field name="due_amount"/>
                    <a:field name="total_principal"/>
                    <a:field name="due_date"/>
                    <a:field name="lease_times"/>
                    <a:field name="group_name"/>
                    <a:field name="staff_name"/>
                    <a:field name="cell_phone"/>
                    <a:field name="bp_name_sp"/>
                    <a:field name="cell_phone_sp"/>
                    <a:field name="collecting_fee"/>
                    <a:field name="age"/>
                    <a:field name="position_n"/>
                    <a:field name="down_payment"/>
                    <a:field name="down_payment_ratio"/>
                    <a:field name="balloon"/>
                    <a:field name="balloon_ratio"/>
                    <a:field name="direct_debit_bank_id_n"/>
                    <a:field name="dd_bank_account_num"/>
                    <a:field name="dd_bank_account_name"/>
                    <a:field name="car_type_n"/>
                    <a:field name="business_type_n"/>
                    <a:field name="insurance_flag"/>
                    <a:field name="gps_flag"/>
                    <a:field name="producer"/>
                    <a:field name="brand_id_n"/>
                    <a:field name="series_id_n"/>
                    <a:field name="model_id_n"/>
                    <a:field name="item_frame_number"/>
                    <a:field name="color_of_apprearance"/>
                    <a:field name="item_engine_number"/>
                    <a:field name="license_number"/>
                    <a:field name="invoice_price"/>
                    <a:field name="guide_price"/>
                    <a:field name="finance_amount"/>
                    <a:field name="int_rate_display"/>
                    <a:field name="pmt"/>
                    <a:field name="bp_info"/>
                    <a:field name="id_type"/>
                    <a:field name="id_card_no"/>
                    <a:field name="work_unit"/>
                    <a:field name="work_unit_address"/>
                    <a:field name="living_address"/>
                    <a:field name="address_on_resident_booklit"/>
                    <a:field name="gps1"/>
                </a:fields>
            </a:dataSet>
        </a:dataSets>
        <a:screenTopToolbar>
            <a:screenTitle/>
            <a:gridButton click="query_overdue_query_result_ds" text="查询"/>
        </a:screenTopToolbar>
        <a:form column="4" labelWidth="100" marginWidth="30" title="逾期查询">
            <a:textField name="invoice_agent_id_n" bindTarget="overdue_query_query_ds" prompt="经销商名称"/>
            <a:textField name="project_number" bindTarget="overdue_query_query_ds" prompt="申请编号"/>
            <a:textField name="contract_number" bindTarget="overdue_query_query_ds" prompt="合同编号"/>
            <a:comboBox name="contract_status_n" bindTarget="overdue_query_query_ds" prompt="合同状态"/>
        </a:form>
        <a:grid id="grid_id" bindTarget="overdue_query_result_ds" marginHeight="230" marginWidth="30" navBar="true">
            <a:toolBar>
                <a:button type="excel"/>
            </a:toolBar>
            <a:columns>
                <a:column name="contract_number" prompt="合同编号" width="100"/>
                <a:column name="product_plan_id_n" prompt="产品名称" width="100"/>
                <a:column name="province_sp" prompt="省" width="100"/>
                <a:column name="city_sp" prompt="市" width="100"/>
                <a:column name="invoice_agent_id_n" prompt="提报店名称" width="100"/>
                <a:column name="bp_class_n" prompt="申请类型" width="100"/>
                <a:column name="withhold_way_n" prompt="扣款方式" width="100"/>
                <a:column name="project_number" prompt="申请编号" width="100"/>
                <a:column name="bp_name" prompt="客户名称" width="100"/>
                <!--  <a:column name="overdue_status_type_n" prompt="逾期状态" width="100"/> -->
                <a:column name="overdue_due_date" prompt="逾期日期" renderer="Leaf.formatDate" width="100"/>
                <a:column name="contract_status_n" prompt="合同状态" width="100"/>
                <a:column name="inception_of_lease" prompt="合同生效日期" renderer="Leaf.formatDate" width="100"/>
                <!--  <a:column name="risk_rank" prompt="风险等级" width="100"/>
                <a:column name="overdue_times" prompt="逾期期数" width="100"/>
                <a:column name="overdue_max_days" prompt="实际逾期天数" width="100"/> -->
                <!--  <a:column name="overdue_amount_sum" prompt="逾期金额" width="100"/> -->
                <a:column name="overdue_principal" prompt="逾期本金" width="100"/>
                <a:column name="overdue_interest" prompt="逾期利息" width="100"/>
                <a:column name="penalty" prompt="逾期罚息" width="100"/>
                <a:column name="principal" prompt="剩余本金" width="100"/>
                <!-- <a:column name="due_amount" editor="grid_id_numberField_id" width="100"/>
                <a:column name="total_principal" prompt="剩余本金" width="100"/> -->
                <a:column name="due_date" prompt="还款日" renderer="Leaf.formatDate" width="100"/>
                <a:column name="lease_times" prompt="期限" width="100"/>
                <!--  <a:column name="group_name" prompt="催收组别" width="100"/>
                <a:column name="staff_name" prompt="催收人员" width="100"/> -->
                <a:column name="cell_phone" prompt="手机号码" width="100"/>
                <a:column name="bp_name_sp" prompt="配偶姓名" width="100"/>
                <a:column name="cell_phone_sp" prompt="配偶手机号" width="100"/>
                <a:column name="collecting_fee" prompt="催收费用" width="100"/>
                <a:column name="age" prompt="申请人年龄" width="100"/>
                <a:column name="position_n" prompt="申请人职业" width="100"/>
                <a:column name="down_payment" prompt="首付款" width="100"/>
                <a:column name="down_payment_ratio" prompt="首付款比例" renderer="render_grid_id" width="100"/>
                <a:column name="balloon" prompt="尾款" width="100"/>
                <a:column name="balloon_ratio" prompt="尾付款比例" renderer="render_grid_id" width="100"/>
                <a:column name="direct_debit_bank_id_n" prompt="自动扣款银行" width="100"/>
                <a:column name="dd_bank_account_num" prompt="自动扣款账号" width="100"/>
                <a:column name="dd_bank_account_name" prompt="自动扣款账号名" width="100"/>
                <a:column name="car_type_n" prompt="车辆类型" width="100"/>
                <a:column name="business_type_n" prompt="租赁类型" width="100"/>
                <a:column name="insurance_flag" prompt="是否融保险" width="100"/>
                <a:column name="gps_flag" prompt="是否融GPS" width="100"/>
                <a:column name="producer" prompt="制造商" width="100"/>
                <a:column name="brand_id_n" prompt="车辆品牌" width="100"/>
                <a:column name="series_id_n" prompt="车系" width="100"/>
                <a:column name="model_id_n" prompt="车型" width="100"/>
                <a:column name="item_frame_number" prompt="车架号" width="100"/>
                <a:column name="color_of_apprearance" prompt="颜色" width="100"/>
                <a:column name="item_engine_number" prompt="发动机号" width="100"/>
                <a:column name="license_number" prompt="车牌号" width="100"/>
                <a:column name="invoice_price" prompt="实际销售价" width="100"/>
                <a:column name="guide_price" prompt="市场指导价" width="100"/>
                <a:column name="finance_amount" prompt="租赁融资额" width="100"/>
                <a:column name="int_rate_display" editor="grid_id_numberField_id" prompt="租赁年利率" renderer="render_grid_id" width="100"/>
                <a:column name="pmt" prompt="每期租金" width="100"/>
                <a:column name="bp_info" prompt="店面属性" width="100"/>
                <a:column name="id_type" prompt="证件类型" width="100"/>
                <a:column name="id_card_no" prompt="证件号码" width="100"/>
                <a:column name="work_unit" prompt="单位名称" width="100"/>
                <a:column name="work_unit_address" prompt="单位地址" width="100"/>
                <a:column name="living_address" prompt="现居住地址" width="100"/>
                <a:column name="address_on_resident_booklit" prompt="户籍地地址" width="100"/>
                <a:column name="gps1" prompt="GPS/SIM卡号" width="100"/>
            </a:columns>
            <!-- <a:editors>
                <a:numberField id="grid_id_numberField_id"/>
                <a:textField id="grid_id_textField_id"/>
            </a:editors> -->
        </a:grid>
        <a:hBox/>
    </a:view>
</a:screen>
