<?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"/>--> <a:link id="con_cashflow_pre_query_id" model="cont.CON930.con_contract_cashflow_monthly_n" modelaction="update"/> <a:link id="con_cashflow_pre_update_id" model="cont.CON930.insert_con_cash_temp_data_job" 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'; //}; if(record.data.lease_name99=='Y'){//add by gzj 2022-12-19 10:17:53 record.data.division=record.data.division+',99'; }; if(record.data.lease_name93=='Y'){//add by gzj 2022-12-19 10:17:53 record.data.division=record.data.division+',93'; }; 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_update() { var headers_ds = $('con_contract_cashflow_monthly_query_ds'); var record = headers_ds.getAt(0); //基准日期校验 if(record.get('due_date') == null || record.get('due_date') == ''){ Leaf.showMessage('提示', '请选择报表的基准日期'); return false; } Leaf.Masker.mask(Ext.getBody(), '正在更新数据,请稍等...'); Leaf.request({ url: $('con_cashflow_pre_update_id').getUrl(), para: { due_date : record.get('due_date'), business_type : record.get('business_type') }, success: function(res) { Leaf.Masker.unmask (Ext.getBody()); }, 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 checkedValue="Y" name="lease_name99" uncheckedValue="N" defaultValue="N"/> <a:field checkedValue="Y" name="lease_name93" 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_update" text="更新全量数据"/> <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_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_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:checkBox name="lease_name99" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="工程机械"/> <a:checkBox name="lease_name93" 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_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_left" align="center" prompt="未到期6个月以上" 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:column name="full_name" align="center" prompt="设备名称" width="220"/> </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>