con_contract_cashflow_monthly.lview

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WangYu  
    $Date: 2014-4-25 上午09:31:11  
    $Revision: 1.0  
    $Purpose: 
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:view>
        <a:link id="con_cashflow_pre_query_id" model="cont.CON930.con_contract_cashflow_monthly" modelaction="update"/>
        <script><![CDATA[
        function CON321_con_contract_query() {
            if ($('con_contract_cashflow_monthly_query_ds').validate()){
                debugger;
                var headers_ds = $('con_contract_cashflow_monthly_query_ds');
                var record = headers_ds.getAt(0);
                record.data.division='';
                if(record.data.lease_name10=='Y'){
                    record.data.division=',10';
                }
                if(record.data.lease_name20=='Y'){
                    record.data.division=record.data.division+',20';
                }
                if(record.data.lease_name30=='Y'){
                    record.data.division=record.data.division+',30';
                }
                if(record.data.lease_name40=='Y'){
                    record.data.division=record.data.division+',40';
                }
                if(record.data.lease_name50=='Y'){
                    record.data.division=record.data.division+',50';
                }
                if(record.data.lease_name60=='Y'){
                    record.data.division=record.data.division+',60';
                }
                if(record.data.lease_name70=='Y'){
                    record.data.division=record.data.division+',70';
                };
                if(record.data.lease_name80=='Y'){
                    record.data.division=record.data.division+',80';
                };
                if(record.data.lease_name90=='Y'){
                    record.data.division=record.data.division+',90';
                };
                if(record.data.lease_name91=='Y'){//addby xsh35973 20221011 I-12357新增产品线
                    record.data.division=record.data.division+',91';
                };
                if(record.data.lease_name92=='Y'){//add by gzj 2022-12-19 10:17:53
                    record.data.division=record.data.division+',92';
                };
                record.data.division=record.data.division.substr(1,record.data.division.length);
                Leaf.Masker.mask(Ext.getBody(), '正在统计并查询，请稍等...');
                Leaf.request({
                    url: $('con_cashflow_pre_query_id').getUrl(),
                    para: {
                        due_date : record.get('due_date'),
                        division:record.data.division,
                        bp_id : record.get('bp_id'),
                        business_type : record.get('business_type'),
                        overday1:record.get('overdue_day1'),
                        overday2:record.get('overdue_day2'),
                        overday3:record.get('overdue_day3'),
                        not_overday1:record.get('not_overday1'),
                        not_overday2:record.get('not_overday2'),
                        not_overday3:record.get('not_overday3'),
                        not_overday4:record.get('not_overday4'),
                        not_overday5:record.get('not_overday5'),
                        not_overday6:record.get('not_overday6')
                    },
                    success: function(res) {
                        Leaf.Masker.unmask (Ext.getBody());
                        $('con_contract_cashflow_monthly_result_ds').query();
                        $('con_contract_cashflow_monthly_agent_result_ds').query();
                        $('con_contract_cashflow_monthly_result_lease_item_ds').query();

                    },
                    failure: function() {
                        Leaf.Masker.unmask (Ext.getBody());
                    },
                    error: function() {
                        Leaf.Masker.unmask (Ext.getBody());
                    },
                    scope: this
                });
            }
        }

        function CON321_con_contract_reset() {
            $('con_contract_cashflow_monthly_query_ds').reset();
        }
        ]]></script>
        <a:dataSets>
            <a:dataSet id="business_type_desc_ds">
                <a:datas>
                    <a:record code_value="LEASE" code_value_name="直租"/>
                    <a:record code_value="LEASEBACK" code_value_name="售后回租"/>
                </a:datas>
            </a:dataSet>
            <a:dataSet id="gld_accounts_ds" loadData="true" model="cont.CON930.gld_accounts_ds"/>
            <a:dataSet id="con_contract_cashflow_monthly_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="business_type"/>
                    <a:field name="business_type_desc" displayField="code_value_name" options="business_type_desc_ds"
                             returnField="business_type" valueField="code_value" prompt="业务类型"/>
                    <a:field name="due_date" required="true"  prompt="基准日期"/>
                    <a:field name="bp_id_agent_level1" />
                    <a:field name="bp_id_agent_level1_id" />
                    <a:field name="bp_id_agent_level1_desc" />
                    <a:field name="account_name" displayField="account_name" options="gld_accounts_ds" returnField="account_id" valueField="account_id"/>
                    <a:field name="bp_id_agent_level1_n" prompt="代理店" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov?bp_category=AGENT" lovWidth="500" title="HLS.BP_TITLE" >
                        <a:mapping>
                            <a:map from="bp_id" to="bp_id_agent_level1"/>
                            <a:map from="bp_name" to="bp_id_agent_level1_n" />
                        </a:mapping>
                    </a:field>
                    <a:field name="bp_name" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov?bp_category=AGENT" lovWidth="800" displayField="bp_name" valueField="bp_id">
                      <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="bp_id"/>
                    <a:field checkedValue="Y" name="lease_name10" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name20" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name30" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name40" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name50" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name60" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name70" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name80" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name90" uncheckedValue="N" defaultValue="N"/>
                    <a:field checkedValue="Y" name="lease_name92" uncheckedValue="N" defaultValue="N"/>
                    <a:field name="division" />
                    <a:field name="overdue_day1" required="true" prompt="已到期1个月界定天数" defaultValue="30"/>
                    <a:field name="overdue_day2" required="true" prompt="已到期2个月界定天数" defaultValue="60"/>
                    <a:field name="overdue_day3" required="true" prompt="已到期3个月界定天数" defaultValue="90"/>
                    <a:field name="not_overday1" required="true" prompt="未到期1个月界定天数" defaultValue="31"/>
                    <a:field name="not_overday2" required="true" prompt="未到期2个月界定天数" defaultValue="61"/>
                    <a:field name="not_overday3" required="true" prompt="未到期3个月界定天数" defaultValue="92"/>
                    <a:field name="not_overday4" required="true" prompt="未到期4个月界定天数" defaultValue="122"/>
                    <a:field name="not_overday5" required="true" prompt="未到期5个月界定天数" defaultValue="153"/>
                    <a:field name="not_overday6" required="true" prompt="未到期6个月界定天数" defaultValue="184"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="con_contract_cashflow_monthly_result_ds" model="cont.CON930.con_contract_cashflow_monthly" autoPageSize="true" queryDataSet="con_contract_cashflow_monthly_query_ds"/>
            <a:dataSet id="con_contract_cashflow_monthly_agent_result_ds" model="cont.CON930.con_contract_cashflow_monthly_agent"  autoPageSize="true" queryDataSet="con_contract_cashflow_monthly_query_ds"/>
            <a:dataSet id="con_contract_cashflow_monthly_result_lease_item_ds" model="cont.CON930.con_contract_cashflow_monthly_lease_item" autoPageSize="true" queryDataSet="con_contract_cashflow_monthly_query_ds"/>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:gridButton click="CON321_con_contract_query" text="HLS.QUERY"/>
                <a:gridButton click="CON321_con_contract_reset" text="HLS.RESET"/>
            </a:screenTopToolbar>
            <a:form bindTarget="con_contract_cashflow_balance_query_ds" column="3" title="收付款预定查询" marginWidth="40">

                <a:datePicker name="due_date" bindTarget="con_contract_cashflow_monthly_query_ds"/>
                <a:comboBox name="business_type_desc" bindTarget="con_contract_cashflow_monthly_query_ds"/>
               <!-- <a:lov name="bp_id_agent_level1_n" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="代理店">
                    <a:events>
                        <a:event name="commit" handler="bp_id_query_value_change"/>
                    </a:events>
                </a:lov>-->
                <a:multiLov displayField="bp_name" valueField="bp_id"
                            bindTarget="con_contract_cashflow_monthly_query_ds" name="bp_name" prompt="代理店"
                            lovWidth="300" lovHeight="300" lovGridHeight="300" title="代理店lov"  width="400"/>


                    <a:checkBox name="lease_name10" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="国产挖机"/>
                    <a:checkBox name="lease_name20" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="进口挖机"/>

                    <a:checkBox name="lease_name30" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="高空作业车"/>
                    <a:checkBox name="lease_name50" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="星邦高空作业车"/>

                    <a:checkBox name="lease_name60" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="新业务"/>
                    <a:checkBox name="lease_name70" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="铁甲业务"/>
                    <a:checkBox name="lease_name80" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="叉车"/>
                    <a:checkBox name="lease_name90" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="租赁二手机"/>
                    <a:checkBox name="lease_name40" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="其它"/>
                <a:checkBox name="lease_name91" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="神钢建机"/>//addby xsh35973 20221011 I-12357新增产品线
                <a:checkBox name="lease_name92" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="北京卡家"/>




                <!--                <a:lov name="bp_id_agent_level1_n" bindTarget="con_contract_cashflow_monthly_query_ds"/>-->
                <!--                <a:numberField name="overdue_day1" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="overdue_day2" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="overdue_day3" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="not_overday1" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="not_overday2" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="not_overday3" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="not_overday4" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="not_overday5" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
                <!--                <a:numberField name="not_overday6" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->

                <!--                <a:comboBox name="account_name" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="科目"/>-->
            </a:form>
            <a:tabPanel marginHeight="115" marginWidth="40">
                <a:tabs>
                    <a:tab prompt="合同维度" width="120">
                        <a:grid id="con_contract_cashflow_monthly_result_grid" bindTarget="con_contract_cashflow_monthly_result_ds" marginHeight="150" navBar="true" marginWidth="40">
                            <a:toolBar>
                                <a:button type="excel"/>
                            </a:toolBar>
                            <a:columns>
                                <a:column name="division_n" align="center" prompt="租赁物" width="220"/>
                                <a:column name="bp_id_agent_level1_n" align="center" prompt="代理店" width="200"/>
                                <a:column name="bp_id_telnet_n" align="center" prompt="承租人" width="120"/>
                                <a:column name="contract_number" align="center" prompt="合同号" width="120"/>
                                <a:column name="business_type_n" align="center" prompt="业务类型" width="80"/>
                                <a:column name="bp_code" align="center" prompt="业务伙伴号" width="100"/>
                                <a:column name="account_id_n" align="center" prompt="科目代码" width="120"/>
                                <a:column name="account_name" align="center" prompt="科目名称" width="180"/>
                                <a:column name="unreceived_sum_amount" align="center" prompt="总额" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="overdue_amount_1" align="center" prompt="已到期1个月" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="overdue_amount_2" align="center" prompt="已到期2个月" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="overdue_amount_3" align="center" prompt="已到期3个月" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="overdue_amount_left" align="center" prompt="已到期3个月以上" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="overdue_sum_amount" align="center" prompt="已到期余额合计" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="not_due_sum_amount" align="center" prompt="未到期余额" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="not_due_amount_1" align="center" prompt="未到期1个月" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="not_due_amount_2" align="center" prompt="未到期2个月" renderer="Leaf.formatMoney" width="100"/>
                                <a:column name="not_due_amount_3" align="center" prompt="未到期3个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_4" align="center" prompt="未到期4个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_5" align="center" prompt="未到期5个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_6" align="center" prompt="未到期6个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_left" align="center" prompt="未到期6个月以上" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_7" align="center" prompt="未到期7个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_8" align="center" prompt="未到期8个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_9" align="center" prompt="未到期9个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_10" align="center" prompt="未到期10个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_11" align="center" prompt="未到期11个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_12" align="center" prompt="未到期12个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_13" align="center" prompt="未到期13个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_14" align="center" prompt="未到期14个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_15" align="center" prompt="未到期15个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_16" align="center" prompt="未到期16个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_17" align="center" prompt="未到期17个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_18" align="center" prompt="未到期18个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_19" align="center" prompt="未到期19个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_20" align="center" prompt="未到期20个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_21" align="center" prompt="未到期21个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_22" align="center" prompt="未到期22个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_23" align="center" prompt="未到期23个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_24" align="center" prompt="未到期24个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_25" align="center" prompt="未到期25个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_26" align="center" prompt="未到期26个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_27" align="center" prompt="未到期27个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_28" align="center" prompt="未到期28个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_29" align="center" prompt="未到期29个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_30" align="center" prompt="未到期30个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_31" align="center" prompt="未到期31个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_32" align="center" prompt="未到期32个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_33" align="center" prompt="未到期33个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_34" align="center" prompt="未到期34个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_35" align="center" prompt="未到期35个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_36" align="center" prompt="未到期36个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_37" align="center" prompt="未到期37个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_38" align="center" prompt="未到期38个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_39" align="center" prompt="未到期39个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_40" align="center" prompt="未到期40个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_41" align="center" prompt="未到期41个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_42" align="center" prompt="未到期42个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_43" align="center" prompt="未到期43个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_44" align="center" prompt="未到期44个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_45" align="center" prompt="未到期45个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_46" align="center" prompt="未到期46个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_47" align="center" prompt="未到期47个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_48" align="center" prompt="未到期48个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_49" align="center" prompt="未到期49个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_50" align="center" prompt="未到期50个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_51" align="center" prompt="未到期51个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_52" align="center" prompt="未到期52个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_53" align="center" prompt="未到期53个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_54" align="center" prompt="未到期54个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_55" align="center" prompt="未到期55个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_56" align="center" prompt="未到期56个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_57" align="center" prompt="未到期57个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_58" align="center" prompt="未到期58个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_59" align="center" prompt="未到期59个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_60" align="center" prompt="未到期60个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_61" align="center" prompt="未到期61个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_62" align="center" prompt="未到期62个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_63" align="center" prompt="未到期63个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_64" align="center" prompt="未到期64个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_65" align="center" prompt="未到期65个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_66" align="center" prompt="未到期66个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_67" align="center" prompt="未到期67个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_68" align="center" prompt="未到期68个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_69" align="center" prompt="未到期69个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_70" align="center" prompt="未到期70个月" renderer="Leaf.formatMoney" width="80"/>
                                <!--<a:column name="not_due_amount_48_left" align="center" prompt="未到期48个月以上" renderer="Leaf.formatMoney" width="80"/>-->
                                <a:column name="not_due_amount_year_1" align="center" prompt="未到期1年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_2" align="center" prompt="未到期2年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_3" align="center" prompt="未到期3年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_4" align="center" prompt="未到期4年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_5" align="center" prompt="未到期5年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_5_left" align="center" prompt="未到期5年以上" renderer="Leaf.formatMoney" width="80"/>
                            </a:columns>
                        </a:grid>
                    </a:tab>
                    <a:tab prompt="代理店的租赁物维度" width="150">
                        <a:grid id="con_contract_cashflow_monthly_agent_result_grid" bindTarget="con_contract_cashflow_monthly_agent_result_ds" marginHeight="150" navBar="true" marginWidth="40">
                            <a:toolBar>
                                <a:button type="excel"/>
                            </a:toolBar>
                            <a:columns>
                                <a:column name="division_n" align="center" prompt="租赁物" width="220"/>
                                <a:column name="bp_id_agent_level1_n" align="center" prompt="代理店" width="200"/>
                                <a:column name="account_id_n" align="center" prompt="科目代码" width="120"/>
                                <a:column name="account_name" align="center" prompt="科目名称" width="180"/>
                                <a:column name="unreceived_sum_amount" align="center" prompt="总额" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_1" align="center" prompt="已到期1个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_2" align="center" prompt="已到期2个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_3" align="center" prompt="已到期3个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_left" align="center" prompt="已到期3个月以上" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_sum_amount" align="center" prompt="已到期余额合计" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_sum_amount" align="center" prompt="未到期余额" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_1" align="center" prompt="未到期1个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_2" align="center" prompt="未到期2个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_3" align="center" prompt="未到期3个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_4" align="center" prompt="未到期4个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_5" align="center" prompt="未到期5个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_6" align="center" prompt="未到期6个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_left" align="center" prompt="未到期6个月以上" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_7" align="center" prompt="未到期7个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_8" align="center" prompt="未到期8个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_9" align="center" prompt="未到期9个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_10" align="center" prompt="未到期10个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_11" align="center" prompt="未到期11个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_12" align="center" prompt="未到期12个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_13" align="center" prompt="未到期13个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_14" align="center" prompt="未到期14个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_15" align="center" prompt="未到期15个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_16" align="center" prompt="未到期16个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_17" align="center" prompt="未到期17个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_18" align="center" prompt="未到期18个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_19" align="center" prompt="未到期19个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_20" align="center" prompt="未到期20个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_21" align="center" prompt="未到期21个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_22" align="center" prompt="未到期22个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_23" align="center" prompt="未到期23个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_24" align="center" prompt="未到期24个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_25" align="center" prompt="未到期25个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_26" align="center" prompt="未到期26个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_27" align="center" prompt="未到期27个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_28" align="center" prompt="未到期28个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_29" align="center" prompt="未到期29个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_30" align="center" prompt="未到期30个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_31" align="center" prompt="未到期31个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_32" align="center" prompt="未到期32个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_33" align="center" prompt="未到期33个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_34" align="center" prompt="未到期34个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_35" align="center" prompt="未到期35个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_36" align="center" prompt="未到期36个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_37" align="center" prompt="未到期37个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_38" align="center" prompt="未到期38个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_39" align="center" prompt="未到期39个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_40" align="center" prompt="未到期40个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_41" align="center" prompt="未到期41个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_42" align="center" prompt="未到期42个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_43" align="center" prompt="未到期43个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_44" align="center" prompt="未到期44个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_45" align="center" prompt="未到期45个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_46" align="center" prompt="未到期46个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_47" align="center" prompt="未到期47个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_48" align="center" prompt="未到期48个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_48_left" align="center" prompt="未到期48个月以上" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_1" align="center" prompt="未到期1年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_2" align="center" prompt="未到期2年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_3" align="center" prompt="未到期3年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_4" align="center" prompt="未到期4年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_5" align="center" prompt="未到期5年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_5_left" align="center" prompt="未到期5年以上" renderer="Leaf.formatMoney" width="80"/>
                            </a:columns>
                        </a:grid>
                    </a:tab>
                    <a:tab prompt="租赁物维度" width="120">
                        <a:grid id="con_contract_cashflow_monthly_result_lease_item_grid" bindTarget="con_contract_cashflow_monthly_result_lease_item_ds" marginHeight="150" navBar="true" marginWidth="40">
                            <a:toolBar>
                                <a:button type="excel"/>
                            </a:toolBar>
                            <a:columns>
                                <a:column name="division_n" align="center" prompt="租赁物" width="220"/>
                                <a:column name="bp_id_agent_level1_n" align="center" prompt="代理店" width="220"/>
                                <a:column name="account_id_n" align="center" prompt="科目代码" width="120"/>
                                <a:column name="account_name" align="center" prompt="科目名称" width="180"/>
                                <a:column name="unreceived_sum_amount" align="center" prompt="总额" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_1" align="center" prompt="已到期1个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_2" align="center" prompt="已到期2个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_3" align="center" prompt="已到期3个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_amount_left" align="center" prompt="已到期3个月以上" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="overdue_sum_amount" align="center" prompt="已到期余额合计" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_sum_amount" align="center" prompt="未到期余额" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_1" align="center" prompt="未到期1个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_2" align="center" prompt="未到期2个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_3" align="center" prompt="未到期3个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_4" align="center" prompt="未到期4个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_5" align="center" prompt="未到期5个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_6" align="center" prompt="未到期6个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_left" align="center" prompt="未到期6个月以上" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_7" align="center" prompt="未到期7个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_8" align="center" prompt="未到期8个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_9" align="center" prompt="未到期9个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_10" align="center" prompt="未到期10个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_11" align="center" prompt="未到期11个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_12" align="center" prompt="未到期12个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_13" align="center" prompt="未到期13个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_14" align="center" prompt="未到期14个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_15" align="center" prompt="未到期15个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_16" align="center" prompt="未到期16个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_17" align="center" prompt="未到期17个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_18" align="center" prompt="未到期18个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_19" align="center" prompt="未到期19个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_20" align="center" prompt="未到期20个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_21" align="center" prompt="未到期21个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_22" align="center" prompt="未到期22个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_23" align="center" prompt="未到期23个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_24" align="center" prompt="未到期24个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_25" align="center" prompt="未到期25个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_26" align="center" prompt="未到期26个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_27" align="center" prompt="未到期27个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_28" align="center" prompt="未到期28个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_29" align="center" prompt="未到期29个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_30" align="center" prompt="未到期30个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_31" align="center" prompt="未到期31个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_32" align="center" prompt="未到期32个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_33" align="center" prompt="未到期33个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_34" align="center" prompt="未到期34个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_35" align="center" prompt="未到期35个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_36" align="center" prompt="未到期36个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_37" align="center" prompt="未到期37个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_38" align="center" prompt="未到期38个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_39" align="center" prompt="未到期39个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_40" align="center" prompt="未到期40个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_41" align="center" prompt="未到期41个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_42" align="center" prompt="未到期42个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_43" align="center" prompt="未到期43个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_44" align="center" prompt="未到期44个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_45" align="center" prompt="未到期45个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_46" align="center" prompt="未到期46个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_47" align="center" prompt="未到期47个月" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_48" align="center" prompt="未到期48个月" renderer="Leaf.formatMoney" width="80"/>
                                <!--<a:column name="not_due_amount_48_left" align="center" prompt="未到期48个月以上" renderer="Leaf.formatMoney" width="80"/>-->
                                <a:column name="not_due_amount_year_1" align="center" prompt="未到期1年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_2" align="center" prompt="未到期2年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_3" align="center" prompt="未到期3年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_4" align="center" prompt="未到期4年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_5" align="center" prompt="未到期5年" renderer="Leaf.formatMoney" width="80"/>
                                <a:column name="not_due_amount_year_5_left" align="center" prompt="未到期5年以上" renderer="Leaf.formatMoney" width="80"/>
                            </a:columns>
                        </a:grid>
                    </a:tab>
                </a:tabs>
            </a:tabPanel>
        </a:screenBody>
    </a:view>
</a:screen>