con_agent_query.lview 8.27 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
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 120
<?xml version="1.0" encoding="UTF-8"?>

<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:view>
        <script type="text/javascript"><![CDATA[
        function agent_query_query() {
            $('agent_query_grid_ds').query();
        }

        function agent_query_reset(){
            $('agent_query_form_ds').reset();
        }

        function agent_query_export() {
            $('source_to_grid')._export();
        }

        function aut_authority_list_validate_query(ds, qpara) {
            qpara['authority_flag'] = 'Y';
            qpara['trx_category'] = 'BP';
            qpara['master_type'] = 'BP';
            qpara['trx_id'] = 't1.bp_id';

        }

        ]]></script>

        <a:dataSets>
            <a:dataSet id="hls211_bp_class_ds" lookupCode="HLS211_BP_CLASS"/>
            <a:dataSet id="agent_query_form_ds">
                <a:fields>
                    <a:field name="bp_class"/>
                    <a:field name="bp_class_n" displayField="code_value_name" options="hls211_bp_class_ds" returnField="bp_class" valueField="code_value"/>
                    <a:field name="bp_code" autoComplete="true" lovGridHeight="350" lovHeight="500" lovService="cont.CON1230.con_bp_query" lovWidth="500" title="HLS.BP_TITLE">
                        <a:mapping>
                            <a:map from="bp_name" to="bp_name"/>
                            <a:map from="bp_code" to="bp_code"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="bp_name"/>
                    <a:field name="bp_code_lately" lovGridHeight="330" lovHeight="470" lovLabelWidth="120" lovService="cont.CON1230.con_bp_agent_query" lovWidth="700" title="代理商">
                        <a:mapping>
                            <a:map from="bp_code_lately" to="bp_code_lately"/>
                            <a:map from="bp_agent_name" to="bp_agent_name"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="bp_agent_name"/>
                    <a:field name="__async__"  defaultValue="Y" prompt="异步导出"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="agent_query_grid_ds"
                       model="cont.CON1230.con_agent_query"
                       queryDataSet="agent_query_form_ds" selectable="true" selectionModel="single">
                <a:events>
                    <a:event  name="query" handler="aut_authority_list_validate_query"/>
                </a:events>
            </a:dataSet>
        </a:dataSets>

        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="agent_query_query" text="查询"/>
                <a:gridButton click="agent_query_reset" text="重置"/>
                <a:gridButton click="agent_query_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" labelWidth="200" marginWidth="100" title="查询条件">
                <a:lov name="bp_code" bindTarget="agent_query_form_ds" prompt="客户编号" />
                <a:textField name="bp_name" bindTarget="agent_query_form_ds" prompt="客户名称"/>
                <a:lov name="bp_code_lately" bindTarget="agent_query_form_ds" prompt="代理商编号" />
                <a:comboBox name="bp_class_n" bindTarget="agent_query_form_ds" prompt="客户类型" />
                <a:numberField name="sum_quantity_terminate_from" bindTarget="agent_query_form_ds" prompt="已融资设备台数从" allowDecimals="false"/>
                <a:numberField name="sum_quantity_terminate_to" bindTarget="agent_query_form_ds" prompt="已融资设备台数到" allowDecimals="false"/>
                <a:numberField name="sum_quantity_from" bindTarget="agent_query_form_ds" prompt="融资中设备台数从" allowDecimals="false"/>
                <a:numberField name="sum_quantity_to" bindTarget="agent_query_form_ds" prompt="融资中设备台数到" allowDecimals="false"/>
                <a:numberField name="sum_finance_amount_from" bindTarget="agent_query_form_ds" prompt="融资总金额从" />
                <a:numberField name="sum_finance_amount_to" bindTarget="agent_query_form_ds" prompt="融资总金额到" />
                <a:numberField name="financing_amount_from" bindTarget="agent_query_form_ds" prompt="融资中金额从" />
                <a:numberField name="financing_amount_to" bindTarget="agent_query_form_ds" prompt="融资中金额到" />
                <a:datePicker name="min_lease_execution_date_from" bindTarget="agent_query_form_ds" prompt="第一台融资开始时间从" />
                <a:datePicker name="min_lease_execution_date_to" bindTarget="agent_query_form_ds" prompt="第一台融资开始时间到" />
                <a:numberField name="principal_total_from" bindTarget="agent_query_form_ds" prompt="逾期本金从" />
                <a:numberField name="principal_total_to" bindTarget="agent_query_form_ds" prompt="逾期本金到" />
                <!--<a:numberField name="sys_level_lately" bindTarget="agent_query_form_ds" prompt="最后一次AS评分等级" />-->
            </a:form>
            <a:grid id="source_to_grid" bindTarget="agent_query_grid_ds" navBar="true" height="400" marginWidth="100">
                <a:columns>
                    <a:column name="bp_code_lately" prompt="代理商编号(最近)" width="120"/>
                    <a:column name="bp_name_lately"  prompt="代理商名称(最近)" width="120"/>
                    <a:column name="contract_number_lately" prompt="合同编号(最近)" />
                    <a:column name="bp_code" prompt="客户编号"/>
                    <a:column name="bp_name"  prompt="客户名称" width="100" />
                    <a:column name="bp_class_n"  prompt="客户类型" width="100" />
                    <a:column name="sys_level_lately"  prompt="最后一次AS评分等级" width="150" />
                    <a:column name="bs_level"  prompt="执行中合同BS等级最差分数" width="200" />
                    <a:column name="sum_quantity_terminate"  prompt="已融资设备总台数" width="150" />
                    <a:column name="sum_quantity"  prompt="融资中设备台数" width="150" />
                    <a:column name="min_lease_execution_date"  prompt="第一台融资开始时间" width="150" renderer="Leaf.formatDate"/>
                    <a:column name="max_calc_date"  prompt="最后一台融资结束日期" width="150" renderer="Leaf.formatDate"/>
                    <a:column name="sum_finance_amount"  prompt="融资总金额" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="sum_received_amount"  prompt="已还融资金额" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="financing_amount"  prompt="融资中金额" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="principal_total"  prompt="逾期本金" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="interest_total"  prompt="逾期利息" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="overdue_total"  prompt="罚息" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="no_principal_total"  prompt="未到期本金" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="no_interest_total"  prompt="未到期利息" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="received_penalty"  prompt="已收罚息合计" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="contact_information"  prompt="客户联系方式" width="100" />
                    <a:column name="deduct_bank"  prompt="付款类型" width="100" />
                    <a:column name="overdue_times"  prompt="逾期期数合计" width="100" />
                    <a:column name="max_overdue_times"  prompt="最大逾期期数" width="100" />
                    <a:column name="mailing_address"  prompt="客户地址" width="300"/>
                    <a:column  name="is_excellent_customer_n" prompt="优秀客户" width="100" />
                    <a:column  name="excellent_customer_remark" prompt="优秀客户备注" width="100" />
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>