audi_deposit_document_query.lview

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: wangwei  
    $Date: 2015-2-5 下午4:47:13  
    $Revision: 1.0  
    $Purpose: 奥迪表单
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
    <a:view>
        <script type="text/javascript"><![CDATA[
            function audi_deposit_ds_query(){
                $('audi_deposit_ds').query();
            }

        ]]></script>
        <a:dataSets>
            <a:dataSet id="hls_price_list_ds" loadData="true" model="cont.CON460.hls_price_list"/>
            <a:dataSet id="for_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="contract_number"/>
                    <a:field name="item_frame_number"/>
                    <a:field name="bp_name" lovGridHeight="330" lovHeight="470" lovLabelWidth="120" lovService="cont.CON460.hls_bp_master_v_all_lov?bp_category=TENANT" lovWidth="700" title="承租人">
                        <a:mapping>
                            <a:map from="bp_id" to="bp_id"/>
                            <a:map from="bp_name" to="bp_name"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="price_list_n" displayField="code_value_name" options="hls_price_list_ds" returnField="price_list" valueField="code_value"/>
                    <a:field name="prj_creation_date_from"/>
                    <a:field name="prj_creation_date_to"/>
                    <a:field name="con_creation_date_from"/>
                    <a:field name="con_creation_date_to"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="audi_deposit_ds" autoPageSize="true" autoQuery="true" model="cont.CON460.audi_deposit_document" queryDataSet="for_query_ds"/>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:gridButton click="audi_deposit_ds_query" text="查询"/>
            </a:screenTopToolbar>
            <a:form column="4" labelWidth="150" marginWidth="80" title="查询条件">
                <a:textField name="contract_number" bindTarget="for_query_ds" prompt="合同号"/>
                <a:lov name="bp_name" bindTarget="for_query_ds" prompt="承租人"/>
                <a:comboBox name="price_list_n" bindTarget="for_query_ds" prompt="价目表"/>
                <a:textField name="item_frame_number" bindTarget="for_query_ds" prompt="车架号"/>
                <a:datePicker name="prj_creation_date_from" bindTarget="for_query_ds" prompt="申请时间从"/>
                <a:datePicker name="prj_creation_date_to" bindTarget="for_query_ds" prompt="申请时间到"/>
                <a:datePicker name="con_creation_date_from" bindTarget="for_query_ds" prompt="通过时间从"/>
                <a:datePicker name="con_creation_date_to" bindTarget="for_query_ds" prompt="通过时间到"/>
            </a:form>
            <a:grid bindTarget="audi_deposit_ds" marginHeight="180" marginWidth="80" navBar="true">
                <a:toolBar>
                    <a:button type="excel"/>
                </a:toolBar>
                <a:columns>
                    <a:column name="contract_number" lock="true" prompt="合同号" width="120"/>
                    <a:column name="tenant_name" lock="true" prompt="承租人名称" width="250"/>
                    <a:column name="item_frame_number_1" prompt="租赁公司内部单据ID" width="180"/>
                    <a:column name="partner_code" prompt="合作伙伴代码" width="120"/>
                    <a:column name="agent_code" prompt="经销商代码" width="120"/>
                    <a:column name="agent_name" prompt="经销商名称" width="200"/>
                    <a:column name="brand_code" align="center" prompt="品牌" width="50"/>
                    <a:column name="special_flag" align="center" prompt="是否是专案" width="100"/>
                    <a:column name="special_approved_flag" align="center" prompt="专案审批状态" width="100"/>
                    <a:column name="prj_creation_date" align="center" prompt="申请时间" width="100"/>
                    <a:column name="con_creation_date" align="center" prompt="通过时间" width="100"/>
                    <a:column name="reject_date" align="center" prompt="拒绝时间" width="100"/>
                    <a:column name="cancel_date" align="center" prompt="撤单时间" width="100"/>
                    <a:column name="payment_completed_date" align="center" prompt="放款时间" width="100"/>
                    <a:column name="customer_rate" align="right" prompt="客户利率" width="120"/>
                    <a:column name="lease_charge_ratio" align="right" prompt="手续费率" width="120"/>
                    <a:column name="lease_charge" align="right" prompt="手续费金额" width="120"/>
                    <a:column name="return_value_ratio" align="right" prompt="经销商补贴比例" width="120"/>
                    <a:column name="return_value" align="right" prompt="经销商贴息金额" width="120"/>
                    <a:column name="other_fee" align="right" prompt="实际购车款" width="120"/>
                    <a:column name="finance_amount" align="right" prompt="融资金额" width="120"/>
                    <a:column name="down_payment_ratio" align="right" prompt="首付比例" width="120"/>
                    <a:column name="down_payment" align="right" prompt="首付金额" width="120"/>
                    <a:column name="deposit_ratio" align="right" prompt="保证金比例" width="120"/>
                    <a:column name="deposit" align="right" prompt="保证金金额" width="120"/>
                    <a:column name="end_value_ratio" align="right" prompt="尾款比例" width="120"/>
                    <a:column name="end_value" align="right" prompt="尾款金额" width="120"/>
                    <a:column name="lease_times" align="right" prompt="租赁期限" width="120"/>
                    <a:column name="annual_pay_times_n" align="right" prompt="租金支付周期" width="120"/>
                    <a:column name="paid_times" align="right" prompt="租金支付次数" width="120"/>
                    <a:column name="rentail_pay_type" align="right" prompt="租金支付方式" width="120"/>
                    <a:column name="pmt_first" align="right" prompt="首期租金" width="120"/>
                    <a:column name="total_rental" align="right" prompt="总租金" width="120"/>
                    <a:column name="business_type" align="right" prompt="业务类型" width="120"/>
                    <a:column name="out_finance" align="right" prompt="是否超额融资" width="120"/>
                    <a:column name="lease_term" align="right" prompt="保险融资年限" width="120"/>
                    <a:column name="insurance_fee" align="right" prompt="保险融资金额" width="120"/>
                    <a:column name="other_fee3" align="right" prompt="购置税融资金额" width="120"/>
                    <a:column name="license_value" align="right" prompt="上牌费融资金额" width="120"/>
                    <a:column name="fee_1" align="right" prompt="车船税融资金额" width="120"/>
                    <a:column name="fee_2" align="right" prompt="维修保养融资金额" width="120"/>
                    <a:column name="fee_3" align="right" prompt="精品装饰融资金额" width="120"/>
                    <a:column name="fee_3" align="right" prompt="精品装饰融资金额" width="120"/>
                    <a:column name="fee_4" align="right" prompt="GPS费用" width="120"/>
                    <a:column name="fee_5" align="right" prompt="其他费用" width="120"/>
                    <a:column name="contract_amount" align="right" prompt="总价合计" width="120"/>
                    <a:column name="deposit_return_type" prompt="保证金处理方式" width="120"/>
                    <a:column name="residual_type" prompt="车辆期末处理方式" width="120"/>
                    <a:column name="invoice_date" prompt="新车发票日期" width="120"/>
                    <a:column name="bp_category" align="center" prompt="客户类型" width="100"/>
                    <a:column name="bp_property" prompt="企业类型" width="200"/>
                    <a:column name="item_frame_number_2" prompt="底盘号" width="150"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>