<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: qwm $Date: 2013-8-30 上午11:11:35 $Revision: 1.0 $Purpose: --> <a:screen xmlns:a="http://www.leaf-framework.org/application"> <a:init-procedure> <a:model-query fetchAll="true" model="gld.gld_currency_vl" rootPath="acr512_currency_list"/> </a:init-procedure> <a:view> <a:link id="csh502_get_layout_code_link_id" model="cont.CON500.con_contract_get_layout_code" modelaction="update"/> <!-- <a:link id="CSH501D_QUERY_col_detail" url="${/request/@context_path}/modules/csh/CSH501/csh_payment_req.lview"/> --> <a:link id="csh_payment_query_detail_link" url="${/request/@context_path}/modules/csh/CSH505/csh_payment_query_detail.lview"/> <a:link id="csh_payment_req_doc_print_link" url="${/request/@context_path}/modules/csh/CSH502/csh_payment_doc_print.lview"/> <a:link id="csh502_csh_payment_req_link_id" url="${/request/@context_path}/modules/csh/CSH501/csh_payment_req.lview"/> <script type="text/javascript"><![CDATA[ function csh502_payment_query() { $('csh_payment_req_queryDs').query(); } function csh502_payment_reset() { $('csh_payment_req_query_ds').reset(); } function render_objectDs_grid(value, record, name) { if(name === 'print_flag'){ if(record.get('approval_status') === 'APPROVED'){ if(value === 'Y'){ return '已打印'; }else{ return '<font color="red">未打印</font>'; } } }else if (name === 'payment_req_number') { if (!record.isNew) { return '<a href="javascript:winOpen_req_pay(\'' + record.id + '\')">' + value + '</a>'; } } } function winOpen_req_pay(record_id) { var record = $('csh_payment_req_queryDs').findById(record_id); var param = {}; param['function_usage'] = 'QUERY'; param['maintain_type'] = 'READONLY'; param['payment_req_id'] = record.get('payment_req_id'); param['document_category'] = record.get('document_category'); param['business_type'] = record.get('business_type'); param['function_code'] = 'CSH505D'; param['winid'] = 'csh_payment_update_window'; param['url_title'] = '付款申请'; hls_doc_get_layout_code('csh502_get_layout_code_link_id', param, 'csh502_csh_payment_req_link_id', 'csh_payment_req_queryDs'); } // function openWin(ds_id){ // var record = $(ds_id).getCurrentRecord(); // maintain_type = 'UPDATE'; // param = record.data; // param['payment_req_id'] = record.get('payment_req_id'); // param['function_code'] = 'CSH505D'; // param['function_usage'] = 'MODIFY'; // //param['layout_debugger_flag']='Y'; // param['maintain_type'] = maintain_type; // param['url_title'] = '付款申请'; // hls_doc_get_layout_code('prj_project_get_layout_code_link_id', param, 'csh_payment_query_detail'); // } // function onOpenWin(value, record, name) { // return '<a href="javascript:openWin(\'' + record.ds.id + '\')">' + value + '</a>'; // } function onUpdate_payment_req(ds, record, name, value, oldvalue) { if (name == 'payment_req_number_from') { if (record.get('payment_req_number_to') == 'undefined' || record.get('payment_req_number_to') == null || record.get('payment_req_number_to') == '') { record.set('payment_req_number_to', value); } } else if (name == 'payment_req_number_to') { if (record.get('payment_req_number_from') == 'undefined' || record.get('payment_req_number_from') == null || record.get('payment_req_number_from') == '') { record.set('payment_req_number_from', value); } } else if (name == 'approval_date_from') { if (record.get('approval_date_to') == 'undefined' || record.get('approval_date_to') == null || record.get('approval_date_to') == '') { record.set('approval_date_to', value); } } else if (name == 'approval_date_to') { if (record.get('approval_date_from') == 'undefined' || record.get('approval_date_from') == null || record.get('approval_date_from') == '') { record.set('approval_date_from', value); } } else if (name == 'amount_from') { if (record.get('amount_to') == 'undefined' || record.get('amount_to') == null || record.get('amount_to') == '') { record.set('amount_to', value); } } else if (name == 'amount_to') { if (record.get('amount_from') == 'undefined' || record.get('amount_from') == null || record.get('amount_from') == '') { record.set('amount_from', value); } } else if (name == 'req_date_from') { if (record.get('req_date_to') == 'undefined' || record.get('req_date_to') == null || record.get('req_date_to') == '') { record.set('req_date_to', value); } } else if (name == 'req_date_to') { if (record.get('req_date_from') == 'undefined' || record.get('req_date_from') == null || record.get('req_date_from') == '') { record.set('req_date_from', value); } } else if (name == 'bp_code_from') { if (record.get('bp_code_to') == 'undefined' || record.get('bp_code_to') == null || record.get('bp_code_to') == '') { record.set('bp_code_to', value); } } else if (name == 'bp_code_to') { if (record.get('bp_code_from') == 'undefined' || record.get('bp_code_from') == null || record.get('bp_code_from') == '') { record.set('bp_code_from', value); } } else if (name == 'apply_pay_date_from') { if (record.get('apply_pay_date_to') == 'undefined' || record.get('apply_pay_date_to') == null || record.get('apply_pay_date_to') == '') { record.set('apply_pay_date_to', value); } } else if (name == 'apply_pay_date_to') { if (record.get('apply_pay_date_from') == 'undefined' || record.get('apply_pay_date_from') == null || record.get('apply_pay_date_from') == '') { record.set('apply_pay_date_from', value); } } else if (name == 'approval_date_from') { if (record.get('approval_date_to') == 'undefined' || record.get('approval_date_to') == null || record.get('approval_date_to') == '') { record.set('approval_date_to', value); } } else if (name == 'approval_date_to') { if (record.get('approval_date_from') == 'undefined' || record.get('approval_date_from') == null || record.get('approval_date_from') == '') { record.set('approval_date_from', value); } } else if (name == 'closed_date_from') { if (record.get('closed_date_to') == 'undefined' || record.get('closed_date_to') == null || record.get('closed_date_to') == '') { record.set('closed_date_to', value); } } else if (name == 'closed_date_to') { if (record.get('closed_date_from') == 'undefined' || record.get('closed_date_from') == null || record.get('closed_date_from') == '') { record.set('closed_date_from', value); } } } function check_data(records){ for(var i=0;i<records.length;i++){ if(records[i].get('approval_status') === 'APPROVED'){ continue; }else{ return false; } } return true; } function csh502_payment_doc_print() { var records = $('csh_payment_req_queryDs').getSelected(); if (records.length === 0) { Leaf.showMessage('${l:PROMPT}', '请选择至少一条记录'); return; }else if(!check_data(records)){ Leaf.showWarningMessage('提示','仅能打印汇签单列显示为<font color="red">未打印</font>或已打印的数据!'); return ; } var instr = ''; for (var i = 0;i < records.length;i++) { if (i == 0) { instr = instr + records[i].get('payment_req_id'); } else { instr = instr + ',' + records[i].get('payment_req_id'); } } var url = $('csh_payment_req_doc_print_link').getUrl() + '?payment_req_id=' + instr; window.open(url); } function summaryRenderer(datas, name) { var sum=0; var sum1=0; if(name=="approval_status_desc"){ return '合计:<font color="red"></font>'; } if(name=="amount"){ for(var i=0;i<datas.length;i++){ var record=datas[i]; var payment_amount_vl=record.get("amount"); var payment_amount=parseFloat(payment_amount_vl); if(!isNaN(payment_amount)){ sum+=payment_amount; } } return '<font color="red">' + Leaf.formatNumber(sum ,2)+ '</font>'; } if(name=='sum_act_amount'){ for(var i=0;i<datas.length;i++){ var record=datas[i]; var new_payment_amount_vl=record.get("sum_act_amount"); var new_payment_amount=parseFloat(new_payment_amount_vl); if(!isNaN(new_payment_amount)){ sum1+=new_payment_amount; } } return '<font color="red">' + Leaf.formatNumber(sum1 ,2)+ '</font>'; } } ]]></script> <a:dataSets> <a:dataSet id="closed_status_ds"> <a:datas> <a:record code_value="Y" code_value_name="是"/> <a:record code_value="N" code_value_name="否"/> <a:record code_value="" code_value_name="全部"/> </a:datas> </a:dataSet> <a:dataSet id="approval_status_ds" lookupCode="CSH_PAYMENT_REQ_APPROVAL_STATUS"/> <a:dataSet id="acr512_currency_ds"> <a:datas dataSource="/model/acr512_currency_list"/> </a:dataSet> <a:dataSet id="csh_payment_req_query_ds"> <a:fields> <a:field name="agent_flag" defaultValue="1"/> <a:field name="closed_flag_desc" displayfield="code_value_name" options="closed_status_ds" returnfield="closed_flag" valuefield="code_value"/> <a:field name="approval_status_desc" displayfield="code_value_name" options="approval_status_ds" returnfield="approval_status" valuefield="code_value"/> <a:field name="currency_name" displayField="currency_name" options="acr512_currency_ds" returnField="currency_code" valueField="currency_code"/> <a:field name="payment_flag_n" displayfield="code_value_name" options="closed_status_ds" returnfield="payment_flag" valuefield="code_value"/> <a:field name="print_flag_n" displayfield="code_value_name" options="closed_status_ds" returnfield="print_flag" valuefield="code_value"/> <a:field name="bp_code_from" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov" lovWidth="500"> <a:mapping> <a:map from="bp_code" to="bp_code_from"/> <a:map from="bp_name" to="bp_code_desc_from"/> </a:mapping> </a:field> <a:field name="bp_code_to" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov" lovWidth="500"> <a:mapping> <a:map from="bp_code" to="bp_code_to"/> <a:map from="bp_name" to="bp_code_desc_to"/> </a:mapping> </a:field> <a:field name="bp_id_tenant_n"/> </a:fields> <a:events> <a:event name="update" handler="onUpdate_payment_req"/> </a:events> </a:dataSet> <a:dataSet id="csh_payment_req_queryDs" autoPageSize="true" autoQuery="true" model="csh.CSH505.csh_payment_query" queryDataSet="csh_payment_req_query_ds" selectable="true"> <a:fields> <a:field name="closed_flag" checkedValue="Y" defaultValue="Y" readOnly="true" uncheckedValue="N"/> <a:field name="submitted_flag" checkedValue="Y" defaultValue="Y" readOnly="true" uncheckedValue="N"/> <a:field name="payment_flag" checkedValue="Y" readOnly="true" uncheckedValue="N"/> <a:field name="approval_status_desc" displayfield="code_value_name" options="approval_status_ds" returnfield="approval_status" valuefield="code_value"/> </a:fields> </a:dataSet> </a:dataSets> <a:screenBody> <a:screenTopToolbar> <a:gridButton click="csh502_payment_query" text="HAP_QUERY"/> <a:gridButton click="csh502_payment_reset" text="HLS.RESET"/> <!-- <a:gridButton click="csh502_payment_doc_print" text="汇签单打印"/> --> </a:screenTopToolbar> <a:form column="4" labelWidth="100" marginWidth="30" title="CSH502.CSH_PAYMENT_REQ_QUERY"> <a:textField name="payment_req_number" bindTarget="csh_payment_req_query_ds" prompt="申请编号"/> <a:textField name="contract_number" bindTarget="csh_payment_req_query_ds" prompt="合同编号"/> <a:datePicker name="req_date_from" bindTarget="csh_payment_req_query_ds" prompt="CSH502.CSH_REQ_DATE_FROM"/> <a:datePicker name="req_date_to" bindTarget="csh_payment_req_query_ds" prompt="CSH502.CSH_REQ_DATE_TO"/> <a:lov name="bp_code_from" bindTarget="csh_payment_req_query_ds" prompt="CSH502.CSH_PAYMENT_OBJ_FROM"/> <a:lov name="bp_code_to" bindTarget="csh_payment_req_query_ds" prompt="CSH502.CSH_PAYMENT_OBJ_TO"/> <a:textField name="bp_id_tenant_n" bindTarget="csh_payment_req_query_ds" prompt="承租人"/> <!-- <a:datePicker name="apply_pay_date_from" bindTarget="csh_payment_req_query_ds" prompt="申请付款日期从" width="150"/> <a:datePicker name="apply_pay_date_to" bindTarget="csh_payment_req_query_ds" prompt="申请付款日期到" width="150"/> --> <a:numberField name="amount_from" allowDecimals="true" allowFormat="true" bindTarget="csh_payment_req_query_ds" prompt="申请总金额从"/> <a:numberField name="amount_to" allowDecimals="true" allowFormat="true" bindTarget="csh_payment_req_query_ds" prompt="申请总金额到"/> <a:datePicker name="approval_date_from" bindTarget="csh_payment_req_query_ds" prompt="审批日期从"/> <a:datePicker name="approval_date_to" bindTarget="csh_payment_req_query_ds" prompt="审批日期到"/> <a:datePicker name="closed_date_from" bindTarget="csh_payment_req_query_ds" prompt="放款日期从"/> <a:datePicker name="closed_date_to" bindTarget="csh_payment_req_query_ds" prompt="放款日期到"/> <a:comboBox name="approval_status_desc" bindTarget="csh_payment_req_query_ds" prompt="审批状态"/> <a:comboBox name="payment_flag_n" bindTarget="csh_payment_req_query_ds" prompt="是否全额支付"/> <!-- <a:comboBox name="closed_flag_desc" bindTarget="csh_payment_req_query_ds" prompt="CSH502.CSH_CLOSED_FLAG"/> --> <!-- <a:comboBox name="print_flag_n" bindTarget="csh_payment_req_query_ds" prompt="汇签单是否打印"/> --> <!-- <a:textField name="submitted_flag" bindTarget="csh_payment_req_query_ds" prompt="CSH502.CSH_SUBMIT_STATE" width="150"/> --> </a:form> <a:grid id="csh_payment_req_grid_ds" bindTarget="csh_payment_req_queryDs" marginHeight="230" marginWidth="30" navBar="true"> <a:toolBar> <a:button type="excel"/> </a:toolBar> <a:columns> <a:column name="payment_req_number" lock="true" prompt="CSH502.CSH_REQ_NO" renderer="render_objectDs_grid" width="120"/> <!-- <a:column name="print_flag" align="center" prompt="汇签单" renderer="render_objectDs_grid" width="80"/> --> <a:column name="req_date" align="center" prompt="CSH502.CSH_REQ_DATE" renderer="Leaf.formatDate" width="80"/> <!-- <a:column name="project_number" prompt="申请编号" showTitle="true" width="100"/> --> <a:column name="bp_id_tenant_n" prompt="承租人名称" showTitle="true" width="140"/> <a:column name="contract_number" prompt="合同编号" showTitle="true" width="120"/> <a:column name="approval_date" align="center" prompt="CSH502.CSH_APR_DATE" renderer="Leaf.formatDate" width="80"/> <a:column name="approval_status_desc" align="center" footerRenderer="summaryRenderer" prompt="CSH502.CSH_APR_STATE" width="80"/> <a:column name="amount" align="right" footerRenderer="summaryRenderer" prompt="申请总金额" renderer="Leaf.formatMoney"/> <a:column name="sum_act_amount" footerRenderer="summaryRenderer" prompt="实际申请金额" renderer="Leaf.formatMoney" width="90"/> <a:column name="bp_name" prompt="CSH501.CSH_PAYMENT_OBJ_NAME" showTitle="true" width="100"/> <a:column name="bp_num" prompt="对象账号" showTitle="true" width="130"/> <a:column name="bp_bank_account_name" prompt="账户名称" showTitle="true" width="100"/> <a:column name="bank_full_name" prompt="银行" showTitle="true" width="90"/> <!-- <a:column name="bank_account_name" prompt="出租方账户名称" showTitle="true" width="200"/> --> <a:column name="payment_flag" align="center" prompt="是否全额支付" width="80"/> <a:column name="closed_date" align="center" prompt="放款日期" renderer="Leaf.formatDate" width="80"/> <!-- <a:column name="closed_flag" prompt="CSH502.CSH_CLOSED_FLAG" width="60"/> --> <!-- <a:column name="user_name" prompt="CSH502.CSH_PROPOSER"/> --> <!-- <a:column name="currency_code" align="center" prompt="HLS.CURRENCY" width="60"/> --> <!-- <a:column name="position_name" prompt="岗位"/> --> </a:columns> </a:grid> </a:screenBody> <a:screen-include screen="modules/cont/CON500/con_contract_get_layout_code.lview"/> </a:view> </a:screen>