print_project_application.lview 5.96 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
<?xml version="1.0" encoding="UTF-8"?>
<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" tag="true" trace="true">
    <a:init-procedure>
        <a:model-query defaultWhereClause="t1.project_id=${@project_id}" fetchAll="true" model="prj.PRJ501.survey_less_item" rootPath="lease_item_detail"/>
        <a:model-query defaultWhereClause="t1.project_id=${@project_id} and (t1.bp_category=&apos;TENANT&apos; or t1.bp_category=&apos;TENANT_SEC&apos;)" fetchAll="true" model="prj.PRJ501.opinion_vote_bp_detail" rootPath="tenant_name_detail"/>
        <a:model-query defaultWhereClause="t1.project_id=${@project_id}" fetchAll="true" model="prj.PRJ501.prj_project_print" rootPath="project_detail"/>
        <a:model-query defaultWhereClause="t1.project_id=${@project_id}" fetchAll="true" model="prj.PRJ501.hls_fin_calculator_hd_print" rootPath="calculator_hd_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=&apos;TENANT&apos; or  t1.bp_category=&apos;TENANT_SEC&apos;) and t1.bp_class=&apos;ORG&apos;" fetchAll="true" model="prj.PRJ501.get_guar_four_year" rootPath="tenant_four_year"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;BALANCE_SHEET&apos;  and t1.fin_statement_item in(&apos;FIXED_AST&apos;,&apos;TOT_AST&apos;,&apos;TOT_LIAB&apos;) " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_tenant" rootPath="tenant_statement_ln_1"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;INCOME_STATEMENT&apos; and t1.fin_statement_item in(&apos;MAIN_BIZ_INC&apos;,&apos;PROFIT_FROM_OPER&apos;,&apos;NET_PROFIT&apos;) " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_tenant" rootPath="tenant_statement_ln_2"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;CASHFLOW_STATEMENT&apos; and t1.fin_statement_item in(&apos;NET_CSH_FLOW_OPERA_ACT&apos;,&apos;NET_INCREASE_CSH_CSH_EQUI&apos;) " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_tenant" rootPath="tenant_statement_ln_3"/>
        <a:model-query defaultWhereClause="t1.indicator_code in(&apos;AST_LIAB_RT&apos;,&apos;CURRENT_RT&apos;)" fetchAll="true" model="prj.PRJ501.rsc_fin_indicator_ln_tenant" rootPath="guarantor_indicator_ln_1"/>
        <a:model-query defaultWhereClause=" t1.indicator_code in(&apos;GR_PFT_RT&apos;,&apos;NT_PFT_RT&apos;,&apos;PFT_MRG_NTAST&apos;)" fetchAll="true" model="prj.PRJ501.rsc_fin_indicator_ln_tenant" rootPath="guarantor_indicator_ln_2"/>
        <!--担保企业-->
        <a:model-query defaultWhereClause="t1.project_id=${@project_id} and t1.bp_category=&apos;GUARANTOR&apos; and t1.bp_class=&apos;ORG&apos; AND T1.BP_TYPE=&apos;GUTA_ORG&apos;" fetchAll="true" model="prj.PRJ501.get_guar_four_year" rootPath="guarantor_four_year"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;BALANCE_SHEET&apos; and t1.fin_statement_item in(&apos;TOT_AST&apos;,&apos;TOT_LIAB&apos;,&apos;TOT_EQUITY&apos;) " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_guar" rootPath="guar_statement_ln_1"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;INCOME_STATEMENT&apos; and t1.fin_statement_item in(&apos;MAIN_BIZ_INC&apos;,&apos;PROFIT_FROM_OPER&apos;,&apos;NET_PROFIT&apos;) " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_guar" rootPath="guar_statement_ln_2"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;CASHFLOW_STATEMENT&apos; and t1.fin_statement_item in(&apos;NET_CSH_FLOW_OPERA_ACT&apos;,&apos;NET_INCREASE_CSH_CSH_EQUI&apos;) " fetchAll="true" model="prj.PRJ501.rsc_fin_statement_ln_guar" rootPath="guar_statement_ln_3"/>
        <a:model-query defaultWhereClause="t1.indicator_code in(&apos;AST_LIAB_RT&apos;,&apos;CURRENT_RT&apos;)" fetchAll="true" model="prj.PRJ501.rsc_fin_indicator_ln_guar" rootPath="guar_indicator_ln_1"/>
        <a:model-query defaultWhereClause=" t1.indicator_code in(&apos;GR_PFT_RT&apos;,&apos;NT_PFT_RT&apos;,&apos;PFT_MRG_NTAST&apos;)" fetchAll="true" model="prj.PRJ501.rsc_fin_indicator_ln_guar" rootPath="guar_indicator_ln_2"/>
        <!--个人担保信息-->
        <a:model-query defaultWhereClause="t1.project_id=${@project_id}" fetchAll="true" model="prj.PRJ501.guar_np_info" rootPath="guar_np_info"/>
        <!--承租医院-->
        <a:model-query defaultWhereClause="t1.project_id=${@project_id} and t1.bp_category=&apos;TENANT&apos; and  t1.bp_class=&apos;HOS&apos;" fetchAll="true" model="prj.PRJ501.hls_bp_master_hos" rootPath="tenant_hos_info"/>
        <a:model-query defaultWhereClause="t1.project_id=${@project_id} and t1.bp_category=&apos;TENANT&apos; and t1.bp_class=&apos;HOS&apos; " fetchAll="true" model="prj.PRJ501.get_guar_four_year" rootPath="tenant_hos_four_year"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;BALANCE_SHEET&apos;  and t1.fin_statement_item in(&apos;DIV_REC_PI&apos;,&apos;OTHER_REC_PI&apos;,&apos;HD_TO_MT_INVMT_PI&apos;,&apos;INVMT_PROP_PI&apos;,&apos;TOT_AST_PI&apos;,&apos;TOT_LIAB_PI&apos;) " fetchAll="true" model="prj.PRJ501.hospital_tenant_statement_ln" rootPath="tenant_hos_statement_ln"/>
        <a:model-query defaultWhereClause="t1.fin_statement_type=&apos;INCOME_STATEMENT&apos;  and t1.fin_statement_item in(&apos;MAIN_BIZ_INC_PI&apos;,&apos;MAIN_BIZ_PFT_PI&apos;,&apos;MGT_EXP_PI&apos;) " fetchAll="true" model="prj.PRJ501.hospital_tenant_statement_ln" rootPath="tenant_hos_statement_ln_1"/>
        <a:model-query defaultWhereClause=" t1.indicator_code in(&apos;AST_LIAB_RT&apos;,&apos;CURRENT_RT&apos;)" fetchAll="true" model="prj.PRJ501.tenant_hos_indicator_ln" rootPath="tenant_hos_indicator_ln"/>
        <w:word-export name="项目立项申请表.doc" template="leaf.plugin.export.word/print_project_application.xml"/>
    </a:init-procedure>
</a:screen>