<?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="basic.hls_lease_channel_for_lov" rootPath="con1360_lease_list"/> <a:model-query defaultWhereClause="t1.business_type in ('LEASE','LEASEBACK')" fetchAll="true" model="basic.hls_business_type_for_lov" rootPath="business_type_path"/> </a:init-procedure> <a:view> <script type="text/javascript"><![CDATA[ function con_monthly_amortize_query() { $('con_monthly_amortize_grid_ds').query(); } function con_monthly_amortize_reset(){ $('con_monthly_amortize_form_ds').reset(); } function con_monthly_amortize_export() { $('source_to_grid')._export(); } ]]></script> <a:dataSet id="con1360_lease_channel_ds"> <a:datas dataSource="/model/con1360_lease_list"/> </a:dataSet> <a:dataSet id="business_type_ds"> <a:datas dataSource="/model/business_type_path"/> </a:dataSet> <a:dataSets> <a:dataSet id="con_monthly_amortize_form_ds"> <a:fields> <a:field name="query_year" required="true"/> <a:field name="lease_channel_n" displayField="description" options="con1360_lease_channel_ds" returnField="lease_channel" valueField="lease_channel"/> <a:field name="lease_channel" /> <a:field name="business_type_n" displayField="description" options="business_type_ds" returnField="business_type" valueField="business_type"/> <a:field name="business_type" /> <a:field name="req_status_n" displayField="value_name" options="req_status_ds" returnField="req_status" valueField="value_code" defaultValue="审批通过"/> <a:field name="req_status" defaultValue="APPROVED"/> </a:fields> </a:dataSet> <a:dataSet id="con_monthly_amortize_grid_ds" model="cont.CON1360.con_monthly_amortize" queryDataSet="con_monthly_amortize_form_ds" autoQuery="false" selectable="true" selectionModel="single"> </a:dataSet> </a:dataSets> <a:screenBody> <a:screenTopToolbar> <a:screenTitle/> <a:gridButton click="con_monthly_amortize_query" text="查询"/> <a:gridButton click="con_monthly_amortize_reset" text="重置"/> <a:gridButton click="con_monthly_amortize_export" text="导出"/> </a:screenTopToolbar> <a:form column="4" marginWidth="100" title="查询条件"> <a:numberField name="query_year" bindTarget="con_monthly_amortize_form_ds" prompt="年份" allowDecimals="false"/> <a:textField name="contract_number" bindTarget="con_monthly_amortize_form_ds" prompt="合同编号" /> <a:comboBox name="lease_channel_n" bindTarget="con_monthly_amortize_form_ds" prompt="业务类型" /> <a:comboBox name="business_type_n" bindTarget="con_monthly_amortize_form_ds" prompt="商业模式"/> <a:datePicker name="lease_execution_date_from" bindTarget="con_monthly_amortize_form_ds" prompt="执行日期从"/> <a:datePicker name="lease_execution_date_to" bindTarget="con_monthly_amortize_form_ds" prompt="执行日期到"/> <a:textField name="guarantor_info" bindTarget="con_monthly_amortize_form_ds" prompt="担保状况" /> </a:form> <a:grid id="source_to_grid" bindTarget="con_monthly_amortize_grid_ds" navBar="true" height="400" marginWidth="100"> <a:columns> <a:column name="contract_number" align="center" prompt="合同编号" width="130"/> <a:column name="lease_channel_n" align="center" prompt="业务类型" width="100"/> <a:column name="business_type_n" align="center" prompt="商业模式" width="100" /> <a:column name="lease_execution_date" align="center" prompt="执行日期" width="100" renderer="Leaf.formatDate"/> <a:column name="guarantor_info" align="center" prompt="担保状况" width="100" renderer="Leaf.formatMoney"/> <a:column name="jan_unearned" align="center" prompt="一月" width="100" renderer="Leaf.formatMoney"/> <a:column name="feb_unearned" align="center" prompt="二月" width="100" renderer="Leaf.formatMoney"/> <a:column name="mar_unearned" align="center" prompt="三月" width="100" renderer="Leaf.formatMoney"/> <a:column name="apr_unearned" align="center" prompt="四月" width="100" renderer="Leaf.formatMoney"/> <a:column name="may_unearned" align="center" prompt="五月" width="100" renderer="Leaf.formatMoney"/> <a:column name="jun_unearned" align="center" prompt="六月" width="100" renderer="Leaf.formatMoney"/> <a:column name="jul_unearned" align="center" prompt="七月" width="100" renderer="Leaf.formatMoney"/> <a:column name="aug_unearned" align="center" prompt="八月" width="100" renderer="Leaf.formatMoney"/> <a:column name="sep_unearned" align="center" prompt="九月" width="100" renderer="Leaf.formatMoney"/> <a:column name="oct_unearned" align="center" prompt="十月" width="100" renderer="Leaf.formatMoney"/> <a:column name="nov_unearned" align="center" prompt="十一月" width="100" renderer="Leaf.formatMoney"/> <a:column name="dec_unearned" align="center" prompt="十二月" width="100" renderer="Leaf.formatMoney"/> </a:columns> </a:grid> </a:screenBody> </a:view> </a:screen>