<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: gaoyang $Date: 2013-7-15 下午05:16:39 $Revision: 1.0 $Purpose: --> <a:screen xmlns:c="leaf.application.action" xmlns:w="leaf.plugin.export.word" xmlns:a="http://www.leaf-framework.org/application" xmlns:p="uncertain.proc" customizationEnabled="true" trace="true"> <a:init-procedure> <a:model-query defaultWhereClause="t1.project_id=${@project_id}" model="prj.PRJ501.prj_project_detail" rootPath="project_detail"/> <a:model-query defaultWhereClause="t1.project_id=${@project_id}" model="prj.PRJ501.survey_less_item" rootPath="less_item_detail"/> <a:model-query defaultWhereClause="t1.project_id=${@project_id}" model="prj.PRJ501.project_calculator_hd" rootPath="calculator_hd_detail"/> <a:model-query defaultWhereClause="t1.project_id=${@project_id}" model="prj.PRJ501.survey_tenant_detail" rootPath="tenant_detail"/> <a:model-query defaultWhereClause="t1.project_id=${@project_id}" fetchAll="true" model="prj.PRJ501.guar_type" rootPath="guar_type_detail"/> <!--承租企业--> <a:model-query defaultWhereClause="t1.project_id=${@project_id} and (t1.bp_category='TENANT' or t1.bp_category='TENANT_SEC' ) " fetchAll="true" model="prj.PRJ501.get_guar_four_year" rootPath="tenant_four_year"/> <a:model-query defaultWhereClause="t1.fin_statement_type='BALANCE_SHEET' and t1.fin_statement_item in('BANK_CASH','ACC_REC','OTHER_REC','PMT_IN_ADV','INV','TOT_CURR_AST','LT_EQI_INVMT','CONSTR_IN_PROG','FIXED_AST','TOT_AST','ST_BORR','ACC_PAYABLE','REC_IN_ADV','TOT_CURR_LIAB','LT_BORR','TOT_NON_CURR_LIAB','TOT_LIAB','TOT_EQUITY') " fetchAll="true" model="prj.PRJ501.survey_tenant_statement_ln" rootPath="tenant_statement_ln"/> <a:model-query defaultWhereClause="t1.fin_statement_type='INCOME_STATEMENT' and t1.fin_statement_item in ('MAIN_BIZ_INC','MAIN_BIZ_CST','MAIN_BIZ_TAX_ADD','MAIN_BIZ_PFT','MGT_EXP','NET_FIN_EXP','PROFIT_FROM_OPER','PROFIT_BEFORE_TAX','NET_PROFIT') " fetchAll="true" model="prj.PRJ501.survey_tenant_statement_ln" rootPath="tenant_statement_ln_1"/> <a:model-query defaultWhereClause="t1.fin_statement_type='CASHFLOW_STATEMENT' and t1.fin_statement_item in ('SUB_TOT_CSH_INFLOW_OPERA_ACT','SUB_TOT_CSH_OUTFLOW_OPERA_ACT','NET_CSH_FLOW_OPERA_ACT','SUB_TOT_CSH_INFLOW_INV_ACT','SUB_TOT_CSH_OUTFLOW_INV_ACT','NET_CSH_FLOW_INV_ACT','SUB_TOT_CSH_INFLOW_FIN_ACT','SUB_TOT_CSH_OUTFLOW_FIN_ACT','NET_CSH_FLOW_FIN_ACT','NET_INCREASE_CSH_CSH_EQUI') " fetchAll="true" model="prj.PRJ501.survey_tenant_statement_ln" rootPath="tenant_statement_ln_2"/> <a:model-query defaultWhereClause="t1.indicator_code in ('TAST_INC_RT','OPPFT_INC_RT','OPINC_INC_RT','AST_LIAB_RT','CURRENT_RT','QUICK_RT','GR_PFT_RT','NT_PFT_RT','PFT_MRG_NTAST','RCV_TNOV_RT','INV_TNOV_RT')" fetchAll="true" model="prj.PRJ501.survey_tenant_indicator_ln" rootPath="tenant_indicator_ln"/> <!----> <!--担保企业--> <a:model-query defaultWhereClause="t1.project_id=${@project_id} and t1.bp_category='GUARANTOR' and t1.bp_class='ORG' AND T1.BP_TYPE='GUTA_ORG'" fetchAll="true" model="prj.PRJ501.get_guar_four_year" rootPath="guarantor_four_year"/> <a:model-query defaultWhereClause="t1.fin_statement_type='BALANCE_SHEET' and t1.fin_statement_item in('BANK_CASH','ACC_REC','OTHER_REC','PMT_IN_ADV','INV','TOT_CURR_AST','LT_EQI_INVMT','CONSTR_IN_PROG','FIXED_AST','TOT_AST','ST_BORR','ACC_PAYABLE','REC_IN_ADV','TOT_CURR_LIAB','LT_BORR','TOT_NON_CURR_LIAB','TOT_LIAB','TOT_EQUITY') " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_guar" rootPath="guarantor_statement_ln_1"/> <a:model-query defaultWhereClause="t1.fin_statement_type='INCOME_STATEMENT' and t1.fin_statement_item in ('MAIN_BIZ_INC','MAIN_BIZ_CST','MAIN_BIZ_TAX_ADD','MAIN_BIZ_PFT','MGT_EXP','NET_FIN_EXP','PROFIT_FROM_OPER','PROFIT_BEFORE_TAX','NET_PROFIT') " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_guar" rootPath="guarantor_statement_ln_2"/> <a:model-query defaultWhereClause="t1.fin_statement_type='CASHFLOW_STATEMENT' and t1.fin_statement_item in ('SUB_TOT_CSH_INFLOW_OPERA_ACT','SUB_TOT_CSH_OUTFLOW_OPERA_ACT','NET_CSH_FLOW_OPERA_ACT','SUB_TOT_CSH_INFLOW_INV_ACT','SUB_TOT_CSH_OUTFLOW_INV_ACT','NET_CSH_FLOW_INV_ACT','SUB_TOT_CSH_INFLOW_FIN_ACT','SUB_TOT_CSH_OUTFLOW_FIN_ACT','NET_CSH_FLOW_FIN_ACT','NET_INCREASE_CSH_CSH_EQUI') " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_guar" rootPath="guarantor_statement_ln_3"/> <!--担保企业--> <w:word-export name="信审报告.doc" template="leaf.plugin.export.word/print_project_credit_check.xml"><![CDATA[ ]]></w:word-export> </a:init-procedure> </a:screen>