<?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:init-procedure> <a:model-query defaultWhereClause="t1.document_category='CONTRACT'" fetchAll="true" model="basic.hls_document_type_for_lov" rootPath="con501_document_type_path"/> </a:init-procedure> <a:view> <script type="text/javascript"><![CDATA[ function CON321_con_contract_query() { $('con_contract_cashflow_balance_result_ds').query(); } function CON321_con_contract_reset() { $('con_contract_cashflow_balance_query_ds').reset(); } function CON321_render_contract_number(value, record, name) { if(name=="contract_number") { if (record.get('overdue_max_days') >= 1) { return '<u><a style="color:red" >' + value + '</a></u>'; } else { return value ; } } if(name=="penalty") { if (value > 0) { return '<u><a style="color:red" >' + value + '</a></u>'; } else { return '<a >' + value + '</a>'; } } } ]]></script> <a:dataSets> <a:dataSet id="con321_contract_status_ds" lookupCode="CON500_CONTRACT_STATUS"/> <a:dataSet id="over_status_flag_ds"> <a:datas> <a:record name="Y" value="是"/> <a:record name="N" value="否"/> </a:datas> </a:dataSet> <a:dataSet id="con501_document_type_name_ds"> <a:datas dataSource="/model/con501_document_type_path"/> </a:dataSet> <a:dataSet id="con_contract_cashflow_balance_query_ds" autoCreate="true"> <a:fields> <a:field name="document_type_desc" displayField="description" options="con501_document_type_name_ds" returnField="document_type" valueField="document_type"><![CDATA[ ]]></a:field> <a:field name="contract_number_from"/> <a:field name="contract_number_to"/> <a:field name="bp_id_tenant_n" lovGridHeight="350" lovHeight="500" lovLabelWidth="100" lovService="basic.hls_bp_master_v_for_lov?bp_category=TENANT" lovWidth="520" title="HLS.BP_TITLE"> <a:mapping> <a:map from="bp_name" to="bp_id_tenant_n"/> <a:map from="bp_id" to="bp_id_tenant"/> </a:mapping> </a:field> <a:field name="cf_item_desc" autoComplete="true" lovGridHeight="350" lovHeight="500" lovLabelWidth="100" lovService="cont.CON321.hls_cashflow_item_v_lov" lovWidth="520" title="现金流项目"> <a:mapping> <a:map from="cf_item" to="cf_item"/> <a:map from="cf_item_desc" to="cf_item_desc"/> </a:mapping> </a:field> <a:field name="price_list_name" autoComplete="true" fetchSingle="true" lovGridHeight="350" lovHeight="500" lovService="hls.HLS050.hls_price_list_for_lov" lovWidth="500" title="HLS.PRICE_LIST"> <a:mapping> <a:map from="price_list" to="price_list"/> <a:map from="description" to="price_list_name"/> <a:map from="calc_method" to="calc_method"/> </a:mapping> </a:field> <a:field name="contract_status"/> <a:field name="contract_status_desc" displayField="code_value_name" options="con321_contract_status_ds" returnField="contract_status" valueField="code_value"/> <a:field name="overdue_status" defaultValue="Y"/> <a:field name="write_off_flag_desc" displayField="value" options="over_status_flag_ds" returnField="write_off_flag" valueField="name"/> <a:field name="over_status_flag_desc" defaultValue="是" displayField="value" options="over_status_flag_ds" returnField="overdue_status" valueField="name"/> <a:field name="company_authority" defaultValue="${/session/@company_id}"/> </a:fields> </a:dataSet> <a:dataSet id="con_contract_cashflow_balance_result_ds" model="cont.CON321.con_contract_cashflow_balance" pageSize="12" queryDataSet="con_contract_cashflow_balance_query_ds" selectable="true" selectionModel="single"/> </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="5" title="合同现金流余额查询" width="1200"> <a:textField name="contract_number_from" bindTarget="con_contract_cashflow_balance_query_ds" prompt="合同编号从"/> <a:textField name="contract_number_to" bindTarget="con_contract_cashflow_balance_query_ds" prompt="合同编号到"/> <a:comboBox name="contract_status_desc" bindTarget="con_contract_cashflow_balance_query_ds" prompt="合同状态"/> <a:lov name="bp_id_tenant_n" bindTarget="con_contract_cashflow_balance_query_ds" prompt="承租人"/> <a:lov name="cf_item_desc" bindTarget="con_contract_cashflow_balance_query_ds" prompt="现金流项目"/> <a:comboBox name="over_status_flag_desc" bindTarget="con_contract_cashflow_balance_query_ds" prompt="逾期标志"/> <a:datePicker name="due_date_from" bindTarget="con_contract_cashflow_balance_query_ds" prompt="应收日从"/> <a:datePicker name="due_date_to" bindTarget="con_contract_cashflow_balance_query_ds" prompt="应收日到"/> <a:numberField name="due_amount_from" bindTarget="con_contract_cashflow_balance_query_ds" prompt="应收金额从"/> <a:numberField name="due_amount_to" bindTarget="con_contract_cashflow_balance_query_ds" prompt="应收金额到"/> <a:numberField name="received_amount_from" bindTarget="con_contract_cashflow_balance_query_ds" prompt="实收金额从"/> <a:numberField name="received_amount_to" bindTarget="con_contract_cashflow_balance_query_ds" prompt="实收金额到"/> <a:numberField name="unreceived_amount_from" bindTarget="con_contract_cashflow_balance_query_ds" prompt="未收金额从"/> <a:numberField name="unreceived_amount_to" bindTarget="con_contract_cashflow_balance_query_ds" prompt="未收金额到"/> <a:datePicker name="last_received_date" bindTarget="con_contract_cashflow_balance_query_ds" prompt="最后收款日"/> <a:lov name="price_list_name" bindTarget="con_contract_cashflow_balance_query_ds" prompt="价目表"/> <a:comboBox name="document_type_desc" bindTarget="con_contract_cashflow_balance_query_ds" prompt="HLS.CONTRACT_TYPE"/> <a:comboBox name="write_off_flag_desc" bindTarget="con_contract_cashflow_balance_query_ds" prompt="是否核销"/> </a:form> <a:grid bindTarget="con_contract_cashflow_balance_result_ds" height="380" navBar="true" width="1200"> <a:toolBar> <a:button type="excel"/> </a:toolBar> <a:columns> <a:column name="contract_number" lock="true" prompt="合同编号" renderer="CON321_render_contract_number" width="120"/> <a:column name="contract_name" align="center" prompt="合同名称" width="150"/> <a:column name="contract_status_n" align="center" prompt="合同状态" width="80"/> <a:column name="document_type_n" align="center" prompt="HLS.CONTRACT_TYPE" width="90"/> <a:column name="price_list_n" align="center" prompt="报价类型" width="150"/> <a:column name="bp_id_tenant_n" align="center" prompt="承租人" width="150"/> <a:column name="cf_item_desc" prompt="现金流项目"/> <a:column name="times" align="center" prompt="期数" width="50"/> <a:column name="due_date" align="center" prompt="应收日" renderer="Leaf.formatDate" width="80"/> <a:column name="due_amount" align="right" prompt="应收金额" renderer="Leaf.formatMoney" width="80"/> <a:column name="principal" align="right" prompt="应收本金" renderer="Leaf.formatMoney" width="80"/> <a:column name="interest" align="right" prompt="应收利息" renderer="Leaf.formatMoney" width="80"/> <a:column name="estimated_due_amount" align="right" prompt="预估金额" renderer="Leaf.formatMoney" width="80"/> <a:column name="received_amount" align="right" prompt="实收金额" renderer="Leaf.formatMoney" width="80"/> <a:column name="received_principal" align="right" prompt="实收本金" renderer="Leaf.formatMoney" width="80"/> <a:column name="received_interest" align="right" prompt="实收利息" renderer="Leaf.formatMoney" width="80"/> <a:column name="unreceived_amount" align="right" prompt="未收金额" renderer="Leaf.formatMoney" width="80"/> <a:column name="unreceived_principal" align="right" prompt="未收本金" renderer="Leaf.formatMoney" width="80"/> <a:column name="unreceived_interest" align="right" prompt="未收利息" renderer="Leaf.formatMoney" width="80"/> <a:column name="last_received_date" align="center" prompt="最后收款日" renderer="Leaf.formatDate" width="80"/> <a:column name="overdue_status" align="center" prompt="逾期标志" width="80"/> <a:column name="overdue_max_days" align="center" prompt="逾期天数" width="80"/> <a:column name="penalty" align="right" prompt="逾期罚金" renderer="Leaf.formatMoney" width="80"/> </a:columns> </a:grid> </a:screenBody> </a:view> </a:screen>