<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: 6590 Richen.Xu $Date: 2015-5-15 下午4:45:49 $Revision: 1.0 $Purpose: --> <a:screen xmlns:a="http://www.leaf-framework.org/application"> <a:init-procedure> <a:model-query defaultWhereClause="t1.document_category = 'JE'" fetchAll="true" model="basic.hls_document_type_for_lov" queryOrderBy="document_type desc" rootPath="hls1001_document_type_path"/> </a:init-procedure> <a:view package="leaf.ui.std" template="default"> <script type="text/javascript"><![CDATA[ function query() { $('hls1001_journal_data').query(); } function reset() { $('hls1001_journal_query_ds').reset(); } function hls1001_journal_grid_excel(){ Leaf.showConfirm('提示','您确定要导出以下所有数据吗',function(){ $('hls_1001_journal_grid')._export('xls','凭证接口字段'); var recs = $('hls1001_journal_data').getAll(); for(var i=0;i<recs.length;i++){ recs[i].set('_status','update',false); } $('hls1001_journal_data').submit(); }); } function hls1001_onSubmitSuccess(ds,res){ $('hls1001_journal_data').query(); } // function hls1001_journal_go_back(){ // $('export_journal_window').close(); // } ]]></script> <a:dataSets> <a:dataSet id="hls1001_post_gl_status_ds" lookupCode="SUBSYSTEM_POST_GL_FLAG"/> <a:dataSet id="hls1001_export_flag_ds" lookupCode="HLS_EXPORT_FLAG"/> <a:dataSet id="hls1001_document_type_ds"> <a:datas dataSource="/model/hls1001_document_type_path"/> </a:dataSet> <a:dataSet id="hls1001_journal_query_ds"> <a:fields> <a:field name="journal_num"/> <a:field name="category_code_desc" displayField="description" options="hls1001_document_type_ds" returnField="category_code" valueField="document_type"/> <a:field name="journal_date_from"/> <a:field name="journal_date_to"/> <a:field name="total_amount_dr_from"/> <a:field name="total_amount_dr_to"/> <a:field name="period_name"/> <a:field name="external_journal_num"/> <a:field name="bp_id_tenant"/> <a:field name="bp_id_tenant_desc" lovGridHeight="350" lovHeight="550" lovService="basic.hls_bp_master_v_for_lov?bp_category=TENANT" lovWidth="500"> <a:mapping> <a:map from="bp_name" to="bp_id_tenant_desc"/> <a:map from="bp_id" to="bp_id_tenant"/> </a:mapping> </a:field> <a:field name="source_table"/> <a:field name="reference1"/> <a:field name="je_transaction_code"/> <a:field name="je_transaction_desc" lovGridHeight="420" lovHeight="550" lovPageSize="20" lovService="gld.GLD104.gld_je_transaction_for_lov" lovWidth="500"> <a:mapping> <a:map from="je_transaction_code" to="je_transaction_code"/> <a:map from="je_transaction_desc" to="je_transaction_desc"/> </a:mapping> </a:field> <a:field name="post_gl_status" defaultValue="N"/> <a:field name="post_gl_status_desc" defaultValue="未过账" displayField="code_value_name" options="hls1001_post_gl_status_ds" returnField="post_gl_status" valueField="code_value"/> <a:field name="responsibility_center_name_from" lovHeight="500" lovLabelWidth="100" lovService="fnd.FND2110.fnd_responsibility_centers_lov" lovWidth="550" title="HLS.RESPONSIBILITY_CENTER_NAME"> <a:mapping> <a:map from="responsibility_center_id" to="responsibility_center_id"/> <a:map from="responsibility_center_code" to="responsibility_center_code_from"/> <a:map from="responsibility_center_name" to="responsibility_center_name_from"/> </a:mapping> </a:field> <a:field name="responsibility_center_name_to" lovHeight="500" lovLabelWidth="100" lovService="fnd.FND2110.fnd_responsibility_centers_lov" lovWidth="550" title="HLS.RESPONSIBILITY_CENTER_NAME"> <a:mapping> <a:map from="responsibility_center_code" to="responsibility_center_code_to"/> <a:map from="responsibility_center_name" to="responsibility_center_name_to"/> </a:mapping> </a:field> <a:field name="account_code_from" autoComplete="true" lovHeight="500" lovLabelWidth="100" lovService="hls.HLS301.hls_journal_account_for_lov" lovWidth="500" title="HLS530.ACCOUNT_NAME"> <a:mapping> <a:map from="account_code" to="account_code_from"/> <a:map from="description" to="account_name_from"/> </a:mapping> </a:field> <a:field name="account_code_to" autoComplete="true" lovHeight="500" lovLabelWidth="100" lovService="hls.HLS301.hls_journal_account_for_lov" lovWidth="500" title="HLS530.ACCOUNT_NAME"> <a:mapping> <a:map from="account_code" to="account_code_to"/> <a:map from="description" to="account_name_to"/> </a:mapping> </a:field> <a:field name="company_short_name" lovHeight="500" lovLabelWidth="100" lovService="fnd.fnd_companies_lov" lovWidth="550" title="HLS530.JOURNAL_COMPANY"> <a:mapping> <a:map from="company_id" to="je_company_id"/> <a:map from="company_short_name" to="company_short_name"/> </a:mapping> </a:field> <a:field name="currency_name" lovHeight="500" lovLabelWidth="100" lovService="basic.gld_currency_v_lov" lovWidth="550"> <a:mapping> <a:map from="currency_code" to="currency_code"/> <a:map from="currency_name" to="currency_name"/> </a:mapping> </a:field> <a:field name="export_flag_n" displayField="code_value_name" options="hls1001_export_flag_ds" returnField="export_flag" valueField="code_value"/> </a:fields> </a:dataSet> <a:dataSet id="hls1001_journal_data" model="hls.HLS1001.export_journal_data" queryDataSet="hls1001_journal_query_ds"> <a:fields> <a:field name="export_flag" checkedValue="Y" defaultValue="N" readOnly="true" uncheckedValue="N"/> </a:fields> <a:events> <a:event name="submitsuccess" handler="hls1001_onSubmitSuccess"/> </a:events> </a:dataSet> </a:dataSets> <a:screenBody> <a:screenTopToolbar> <a:screenTitle/> <!-- <a:toolbarButton click="hls1001_journal_go_back" text="HLS.EXIT"/> --> <a:toolbarButton click="reset" text="HLS.RESET"/> <a:toolbarButton click="query" text="HLS.QUERY"/> <a:toolbarButton click="hls1001_journal_grid_excel" text="导出"/> </a:screenTopToolbar> <a:form column="5" labelSeparator=" " labelWidth="100" marginWidth="30" title="HAP_QUERY_TITLE"> <a:lov name="account_code_from" bindTarget="hls1001_journal_query_ds" prompt="HLS530.ACCOUNT_NAME_FROM"/> <a:lov name="account_code_to" bindTarget="hls1001_journal_query_ds" prompt="HLS530.ACCOUNT_NAME_TO"/> <a:lov name="responsibility_center_name_from" bindTarget="hls1001_journal_query_ds" prompt="HLS530.RESPONSIBILITY_CENTER_NAME_FROM"/> <a:lov name="responsibility_center_name_to" bindTarget="hls1001_journal_query_ds" prompt="HLS530.RESPONSIBILITY_CENTER_NAME_TO"/> <a:lov name="company_short_name" bindTarget="hls1001_journal_query_ds" prompt="HLS530.JOURNAL_COMPANY"/> <a:datePicker name="journal_date_from" bindTarget="hls1001_journal_query_ds" prompt="HLS530.JOURNAL_DATE_FROM"/> <a:datePicker name="journal_date_to" bindTarget="hls1001_journal_query_ds" prompt="HLS530.JOURNAL_DATE_TO"/> <a:numberField name="total_amount_dr_from" allowFormat="true" bindTarget="hls1001_journal_query_ds" prompt="HLS530.TOTAL_AMOUNT_DR_FROM"/> <a:numberField name="total_amount_dr_to" allowFormat="true" bindTarget="hls1001_journal_query_ds" prompt="HLS530.TOTAL_AMOUNT_DR_TO"/> <a:textField name="journal_num" bindTarget="hls1001_journal_query_ds" prompt="HLS530.JOURNAL_NUM"/> <a:textField name="project_name" bindTarget="hls1001_journal_query_ds" prompt="HLS.PROJECT_NAME"/> <a:lov name="je_transaction_desc" bindTarget="hls1001_journal_query_ds" prompt="HLS530.JE_TRANSACTION"/> <a:lov name="currency_name" bindTarget="hls1001_journal_query_ds" prompt="HLS.CURRENCY"/> <a:lov name="bp_id_tenant_desc" bindTarget="hls1001_journal_query_ds" prompt="HLS.TENANT_CODE"/> <a:comboBox name="post_gl_status_desc" bindTarget="hls1001_journal_query_ds" prompt="HLS530.IS_POSTED"/> <a:comboBox name="export_flag_n" bindTarget="hls1001_journal_query_ds" prompt="导出状态"/> </a:form> <a:grid id="hls_1001_journal_grid" bindTarget="hls1001_journal_data" marginHeight="255" marginWidth="20" navBar="true"> <a:columns> <a:column name="export_flag" editor="hls1001_cb" forExport="false" lock="true" prompt="已导出"/> <a:column name="period_year" lock="true" prompt="会计年" width="60"/> <a:column name="period_num" lock="true" prompt="会计期间" width="60"/> <a:column name="journal_date" lock="true" prompt="制单日期" width="80"/> <a:column name="journal_type" lock="true" prompt="凭证类别" width="50"/> <a:column name="journal_num" lock="true" prompt="凭证号" width="100"/> <a:column name="created_by_n" lock="true" prompt="制单人" width="60"/> <a:column name="document" prompt="所附单据数"/> <a:column name="note1" prompt="备注1"/> <a:column name="note2" prompt="备注2"/> <a:column name="account_id_n" prompt="科目编码"/> <a:column name="line_description" prompt="摘要"/> <a:column name="settle_method" prompt="结算方式编码"/> <a:column name="bill_num" prompt="票据号"/> <a:column name="bill_date" prompt="票据日期"/> <a:column name="currency_code_n" prompt="币种名称"/> <a:column name="rate" prompt="汇率"/> <a:column name="price" prompt="单价"/> <a:column name="dr_num" prompt="借方数量"/> <a:column name="cr_num" prompt="贷方数量"/> <a:column name="amount_dr" prompt="原币借方"/> <a:column name="amount_cr" prompt="原币贷方"/> <a:column name="amount_fuc_dr" prompt="借方金额" renderer="Leaf.formatMoney"/> <a:column name="amount_fuc_cr" prompt="贷方金额" renderer="Leaf.formatMoney"/> <a:column name="responsibility_center_code" prompt="部门编码"/> <a:column name="em_code" prompt="职员编码"/> <a:column name="ref_v05" prompt="客户编码"/> <a:column name="ref_v10" prompt="供应商编码"/> <a:column name="project_item_code" prompt="项目大类编码"/> <a:column name="project_number" prompt="项目编码"/> <a:column name="salesman" prompt="业务员"/> <a:column name="define_1" prompt="自定义项1"/> <a:column name="define_2" prompt="自定义项2"/> <a:column name="define_3" prompt="自定义项3"/> <a:column name="define_4" prompt="自定义项4"/> <a:column name="define_5" prompt="自定义项5"/> <a:column name="define_6" prompt="自定义项6"/> <a:column name="define_7" prompt="自定义项7"/> <a:column name="define_8" prompt="自定义项8"/> <a:column name="define_9" prompt="自定义项9"/> <a:column name="define_10" prompt="自定义项10"/> <a:column name="define_11" prompt="自定义项11"/> <a:column name="define_12" prompt="自定义项12"/> <a:column name="define_13" prompt="自定义项13"/> <a:column name="define_14" prompt="自定义项14"/> <a:column name="define_15" prompt="自定义项15"/> <a:column name="define_16" prompt="自定义项16"/> <a:column name="cash_flow_item" prompt="现金流量项目"/> <a:column name="cash_flow_dr" prompt="现金流量借方金额"/> <a:column name="cash_flow_cr" prompt="现金流量贷方金额"/> </a:columns> <a:editors> <a:checkBox id="hls1001_cb"/> </a:editors> </a:grid> </a:screenBody> <script type="text/javascript"><![CDATA[ Leaf.onReady(function(){ if(!Leaf.isEmpty('${/parameter/@export_flag}')){ $('hls1001_journal_query_ds').getAt(0).set('export_flag','${/parameter/@export_flag}'); $('hls1001_journal_query_ds').getAt(0).set('export_flag_n',decodeURI(decodeURI('${/parameter/@export_flag_n}'))); } if(!Leaf.isEmpty('${/parameter/@journal_num}')){ $('hls1001_journal_query_ds').getAt(0).set('journal_num','${/parameter/@journal_num}'); } if(!Leaf.isEmpty('${/parameter/@account_code_from}')){ $('hls1001_journal_query_ds').getAt(0).set('account_code_from','${/parameter/@account_code_from}'); $('hls1001_journal_query_ds').getAt(0).set('account_name_from',decodeURI(decodeURI('${/parameter/@account_name_from}'))); } if(!Leaf.isEmpty('${/parameter/@account_code_to}')){ $('hls1001_journal_query_ds').getAt(0).set('account_code_to','${/parameter/@account_code_to}'); $('hls1001_journal_query_ds').getAt(0).set('account_name_to',decodeURI(decodeURI('${/parameter/@account_name_to}'))); } if(!Leaf.isEmpty('${/parameter/@responsibility_center_code_to}')){ $('hls1001_journal_query_ds').getAt(0).set('responsibility_center_code_to','${/parameter/@responsibility_center_code_to}'); $('hls1001_journal_query_ds').getAt(0).set('responsibility_center_name_to',decodeURI(decodeURI('${/parameter/@responsibility_center_name_to}'))); } if(!Leaf.isEmpty('${/parameter/@responsibility_center_code_from}')){ $('hls1001_journal_query_ds').getAt(0).set('responsibility_center_code_from','${/parameter/@responsibility_center_code_from}'); $('hls1001_journal_query_ds').getAt(0).set('responsibility_center_name_from',decodeURI(decodeURI('${/parameter/@responsibility_center_name_from}'))); } if(!Leaf.isEmpty('${/parameter/@je_company_id}')){ $('hls1001_journal_query_ds').getAt(0).set('je_company_id','${/parameter/@je_company_id}'); $('hls1001_journal_query_ds').getAt(0).set('company_short_name',decodeURI(decodeURI('${/parameter/@company_short_name}'))); } if(!Leaf.isEmpty('${/parameter/@journal_date_from}')){ $('hls1001_journal_query_ds').getAt(0).set('journal_date_from','${/parameter/@journal_date_from}'); } if(!Leaf.isEmpty('${/parameter/@journal_date_to}')){ $('hls1001_journal_query_ds').getAt(0).set('journal_date_to','${/parameter/@journal_date_to}'); } if(!Leaf.isEmpty('${/parameter/@total_amount_dr_from}')){ $('hls1001_journal_query_ds').getAt(0).set('total_amount_dr_from','${/parameter/@total_amount_dr_from}'); } if(!Leaf.isEmpty('${/parameter/@total_amount_dr_to}')){ $('hls1001_journal_query_ds').getAt(0).set('total_amount_dr_to','${/parameter/@total_amount_dr_to}'); } if(!Leaf.isEmpty('${/parameter/@project_name}')){ $('hls1001_journal_query_ds').getAt(0).set('project_name',decodeURI(decodeURI('${/parameter/@project_name}'))); } if(!Leaf.isEmpty('${/parameter/@je_transaction_code}')){ $('hls1001_journal_query_ds').getAt(0).set('je_transaction_code','${/parameter/@je_transaction_code}'); $('hls1001_journal_query_ds').getAt(0).set('je_transaction_desc',decodeURI(decodeURI('${/parameter/@je_transaction_desc}'))); } if(!Leaf.isEmpty('${/parameter/@currency_code}')){ $('hls1001_journal_query_ds').getAt(0).set('currency_code','${/parameter/@currency_code}'); $('hls1001_journal_query_ds').getAt(0).set('currency_name',decodeURI(decodeURI('${/parameter/@currency_name}'))); } if(!Leaf.isEmpty('${/parameter/@bp_id_tenant}')){ $('hls1001_journal_query_ds').getAt(0).set('bp_id_tenant','${/parameter/@bp_id_tenant}'); $('hls1001_journal_query_ds').getAt(0).set('bp_id_tenant_desc',decodeURI(decodeURI('${/parameter/@bp_id_tenant_desc}'))); } if(!Leaf.isEmpty('${/parameter/@post_gl_status}')){ $('hls1001_journal_query_ds').getAt(0).set('post_gl_status','${/parameter/@post_gl_status}'); $('hls1001_journal_query_ds').getAt(0).set('post_gl_status_desc',decodeURI(decodeURI('${/parameter/@post_gl_status_desc}'))); } $('hls1001_journal_data').query(); }); ]]></script> </a:view> </a:screen>