<?xml version="1.0" encoding="UTF-8"?> <a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true"> <a:init-procedure> <a:model-query fetchAll="true" model="cont.CON1240.con_get_period" rootPath="sys_default_time"/> </a:init-procedure> <a:view> <script type="text/javascript"><![CDATA[ function receipts_details_query() { $('receipts_details_grid_ds').query(); } function receipts_details_reset(){ $('receipts_details_form_ds').reset(); } function receipts_details_export() { $('source_to_grid')._export(null,'收款明细查询(二)'); } function aut_authority_list_validate_query(ds, qpara) { qpara['authority_flag'] = 'Y'; qpara['contract_ref_content_flag'] = 'Y'; qpara['trx_category'] = 'CONTRACT'; qpara['trx_id'] = 't1.contract_id'; } function summaryRenderer(datas, name) { var sum = 0; var sum1 = 0; var sum2 = 0; var sum3 = 0; if (name == "write_off_classification_n") { return '<font color="red">合计:</font>'; } if (name == "write_off_due_amount") { for (var i = 0; i < datas.length; i++) { var record = datas[i]; var payment_amount_vl = record.get("write_off_due_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 == "write_off_principal") { for (var i = 0; i < datas.length; i++) { var record = datas[i]; var payment_amount_vl = record.get("write_off_principal"); 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 == "write_off_interest") { for (var j = 0; j < datas.length; j++) { var record1 = datas[j]; var payment_amount_vl1 = record1.get("write_off_interest"); var payment_amount1 = parseFloat(payment_amount_vl1); if (!isNaN(payment_amount1)) { sum1 += payment_amount1; } } return '<font color="red">' + Leaf.formatNumber(sum1, 2) + '</font>'; } } ]]></script> <a:dataSets> <a:dataSet id="receipts_details_form_ds"> <a:fields> <a:field name="bp_name" autoComplete="true" lovGridHeight="350" lovHeight="500" lovService="cont.CON1250.con_bp_query" lovWidth="500" title="HLS.BP_TITLE"> <a:mapping> <a:map from="bp_name" to="bp_name"/> <a:map from="bp_code" to="bp_code"/> </a:mapping> </a:field> <a:field name="contract_number" lovGridHeight="400" lovHeight="500" lovLabelWidth="100" lovService="cont.CON1250.receipts_details_contract" lovWidth="500" title="合同编号"> <a:mapping> <a:map from="contract_number" to="contract_number"/> </a:mapping> </a:field> <a:field name="bp_agent_name" lovGridHeight="330" lovHeight="470" lovLabelWidth="120" lovService="cont.CON1250.con_bp_agent_query" lovWidth="700" title="代理商"> <a:mapping> <a:map from="bp_agent_name" to="bp_agent_name"/> </a:mapping> </a:field> <a:field name="bp_code"/> <a:field name="journal_date_from" defaultValue="${/model/sys_default_time/record/@month_first_day}"/> <a:field name="journal_date_to" defaultValue="${/model/sys_default_time/record/@now_date}"/> <a:field name="__async__" defaultValue="Y" prompt="异步导出"/> </a:fields> </a:dataSet> <a:dataSet id="receipts_details_grid_ds" autoQuery="false" model="cont.CON1250.receipts_detail_write" queryDataSet="receipts_details_form_ds" selectable="true" selectionModel="single" autoPageSize="false" pageSize="100"> <a:events> <a:event name="query" handler="aut_authority_list_validate_query"/> </a:events> </a:dataSet> </a:dataSets> <a:screenBody> <a:screenTopToolbar> <a:screenTitle/> <a:gridButton click="receipts_details_query" text="查询"/> <a:gridButton click="receipts_details_reset" text="重置"/> <a:gridButton click="receipts_details_export" text="导出"/> </a:screenTopToolbar> <a:form column="4" marginWidth="100" title="查询条件"> <a:lov name="contract_number" bindTarget="receipts_details_form_ds" prompt="合同编号" /> <a:lov name="bp_name" bindTarget="receipts_details_form_ds" prompt="客户名称" /> <a:lov name="bp_agent_name" bindTarget="receipts_details_form_ds" prompt="代理商名称" /> <a:textField name="transaction_num" bindTarget="receipts_details_form_ds" prompt="现金事务编号" /> <a:datePicker name="transaction_date_from" bindTarget="receipts_details_form_ds" prompt="收款日期从" /> <a:datePicker name="transaction_date_to" bindTarget="receipts_details_form_ds" prompt="收款日期到" /> <a:datePicker name="due_date_from" bindTarget="receipts_details_form_ds" prompt="应收日期从" /> <a:datePicker name="due_date_to" bindTarget="receipts_details_form_ds" prompt="应收日期到" /> <a:datePicker name="journal_date_from" bindTarget="receipts_details_form_ds" prompt="核销日期从" /> <a:datePicker name="journal_date_to" bindTarget="receipts_details_form_ds" prompt="核销日期到" /> <a:numberField name="csh_write_off_amount_sum_from" bindTarget="receipts_details_form_ds" prompt="总核销金额从"/> <a:numberField name="csh_write_off_amount_sum_to" bindTarget="receipts_details_form_ds" prompt="总核销金额到"/> </a:form> <a:grid id="source_to_grid" bindTarget="receipts_details_grid_ds" navBar="true" height="400" marginWidth="100"> <a:columns> <a:column name="contract_number" prompt="合同编号" width="120"/> <a:column name="bp_name" prompt="合同客户名" width="120"/> <a:column name="bp_agent_name" prompt="合同代理商" width="120"/> <a:column name="transaction_date" prompt="收款日期" width="100" renderer="Leaf.formatDate"/> <a:column name="cf_item_n" prompt="核销现金流" /> <a:column name="times" prompt="核销期数" width="80"/> <!-- <a:column name="write_off_classification_n" prompt="核销分类" width="100" footerRenderer="summaryRenderer"/>--> <a:column name="write_off_due_amount" prompt="核销金额" width="100" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/> <a:column name="write_off_principal" prompt="核销本金" width="100" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/> <a:column name="write_off_interest" prompt="核销利息" width="100" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/> <a:column name="due_date" prompt="应收日期" width="100" renderer="Leaf.formatDate"/> <a:column name="journal_date" prompt="核销基准日期" width="100" renderer="Leaf.formatDate"/> <a:column name="write_off_date" prompt="核销日期" width="100" renderer="Leaf.formatDate"/> <a:column name="transaction_num" prompt="现金事务编号" width="100"/> <a:column name="csh_write_off_amount_sum" prompt="总核销金额" width="100" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/> </a:columns> </a:grid> </a:screenBody> </a:view> </a:screen>