<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: Administrator
$Date: 2014-8-26 上午9:57:16
$Revision: 1.0
$Purpose:
-->
<bm:model xmlns:s="leaf.plugin.script" xmlns:bm="http://www.leaf-framework.org/schema/bm">
<bm:operations>
<bm:operation name="query">
<bm:query-sql><![CDATA[
select *
from (select a.contract_id,
a.virtual_con_number,
a.project_id,
a.contract_number,
a.contract_name,
a.finance_amount,
a.lease_aomunt_recevied_date,
a.pre_incept_date,
a.lease_start_date,
sign(a.pre_incept_date-sysdate)tag,
a.employee_id,
a.employee_name,
a.unit_id,
a.unit_name,
to_char(a.inception_of_lease,'yyyy-mm-dd')inception_of_lease,
a.lease_channel,
a.lease_channel_desc,
a.division,
a.division_desc,
a.bp_id_tenant,
a.bp_name,
a.owner_user_id,
a.lease_organization,
a.company_id,
a.inception_need_submit_flag,
a.incept_req_print_status,
nvl(a.incept_before_lend,'N') incept_before_lend,
nvl(a.incept_status,'NEW')incept_status,
a.contract_status_desc,
a.contract_status,
a.hn_industry_classification,
a.hn_industry_classification_n,
a.hn_adjust_review_flag
from con_contract_v a
where a.contract_status in('SIGN','INCEPT')
) t1 #WHERE_CLAUSE#
order by t1.contract_id desc
]]></bm:query-sql>
</bm:operation>
<bm:operation name="update">
<bm:query-sql><![CDATA[
begin
con_contract_incept_apply_pkg.contract_print_status_update(p_contract_id =>${@contract_id},
p_user_id =>${/session/@user_id});
end;
]]></bm:query-sql>
</bm:operation>
<bm:operation name="execute">
<bm:query-sql><![CDATA[
begin
con_contract_incept_apply_pkg.workflow_start(p_contract_id =>${@contract_id},
p_user_id =>${/session/@user_id});
end;
]]></bm:query-sql>
<bm:parameters>
<bm:parameter name="contract_id" output="true" outputPath="@contract_id"/>
<bm:parameter name="unit_id" input="true" inputPath="@unit_id"/>
</bm:parameters>
</bm:operation>
</bm:operations>
<bm:fields>
<bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long"/>
<bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long"/>
<bm:field name="virtual_con_number" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="contract_name" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="finance_amount" databaseType="NUMBER" datatype="java.lang.Double"/>
<bm:field name="pre_incept_date" databaseType="DATE" datatype="java.util.Date"/>
<bm:field name="lease_aomunt_recevied_date" databaseType="DATE" datatype="java.util.Date"/>
<bm:field name="employee_id" databaseType="NUMBER" datatype="java.lang.Long"/>
<bm:field name="employee_name" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Long"/>
<bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="lease_channel" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="lease_channel_desc" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="division_desc" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="incept_before_lend" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="unit_id" databaseType="NUMBER" datatype="java.lang.Long"/>
<bm:field name="unit_name" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="incept_req_print_status" databaseType="VARCHAR2" datatype="java.lang.String"/>
<bm:field name="incept_status" databaseType="VARCHAR2" datatype="java.lang.String" lookupCode="CON_WFL_STATUS" lookupField="incept_status_des"/>
<bm:field name="incept_status_des" forInsert="false" forUpdate="false"/>
<bm:field name="tag" forInsert="false" forUpdate="false"/>
<bm:field name="contract_status_desc"/>
<bm:field name="contract_status"/>
<bm:field name="inception_need_submit_flag"/>
<bm:field name="inception_of_lease"/>
<bm:field name="owner_user_id"/>
<bm:field name="lease_start_date" databaseType="DATE" datatype="java.util.Date"/>
<bm:field name="lease_organization"/>
<bm:field name="hn_industry_classification"/>
<bm:field name="hn_industry_classification_n"/>
<bm:field name="hn_adjust_review_flag"/>
</bm:fields>
<bm:features>
<s:bm-script><![CDATA[
var cx = Packages.leaf.javascript.Context.getCurrentContext();
Packages.leaf.plugin.script.engine.ScriptImportor.defineExternScript(cx, this, $ctx.getData(), "aut_authority_bm_validate.js");
]]></s:bm-script>
</bm:features>
<bm:query-fields>
<bm:query-field field="incept_status" queryExpression=" nvl(t1.incept_status,'NEW') in ${:@incept_status}"/>
<!-- <bm:query-field field="inception_need_submit_flag" queryOperator="="/> -->
<bm:query-field field="contract_id" queryOperator="="/>
<bm:query-field field="contract_number" queryOperator="="/>
<bm:query-field field="employee_id" queryOperator="="/>
<bm:query-field field="unit_id" queryOperator="="/>
<bm:query-field field="lease_channel" queryOperator="="/>
<bm:query-field field="division" queryOperator="="/>
<bm:query-field field="incept_before_lend" queryOperator="="/>
<bm:query-field field="contract_status" queryOperator="="/>
<bm:query-field field="bp_name" queryOperator="like"/>
<bm:query-field field="contract_name" queryOperator="like"/>
<bm:query-field name="loan_date_f" queryExpression="t1.loan_date >=to_date(${@loan_date_f},'yyyy-mm-dd')"/>
<bm:query-field name="loan_date_t" queryExpression="t1.loan_date <=to_date(${@loan_date_t},'yyyy-mm-dd')"/>
<bm:query-field name="incept_date_f" queryExpression="t1.inception_of_lease >=${@incept_date_f}"/>
<bm:query-field name="incept_date_t" queryExpression="t1.inception_of_lease <=${@incept_date_t}"/>
<bm:query-field name="pre_incept_date_f" queryExpression="t1.lease_aomunt_recevied_date >=trunc(to_date(${@pre_incept_date_f},'yyyy-mm-dd'))"/>
<bm:query-field name="pre_incept_date_t" queryExpression="trunc(t1.lease_aomunt_recevied_date) <=to_date(${@pre_incept_date_t},'yyyy-mm-dd')"/>
<bm:query-field name="check_flag" queryExpression="${@check_flag}='Y' and exists(select 1 from con_contract_cashflow ccc where ccc.contract_id=t1.contract_id and ccc.times=0 and ccc.cf_direction='OUTFLOW' and ccc.cf_status='RELEASE' and ccc.write_off_flag='FULL')"/>
</bm:query-fields>
<bm:data-filters>
<bm:data-filter name="1" enforceOperations="query" expression="t1.contract_status = ${@contract_status}"/>
<!-- <bm:data-filter name="2" enforceOperations="query" expression="t.incept_status = ${@incept_status}" />
<bm:data-filter name="3" enforceOperations="query" expression="t.inception_need_submit_flag = ${@inception_need_submit_flag}" /> -->
<!-- <bm:data-filter name="4" enforceOperations="query" expression="t1.owner_user_id = ${/session/@user_id}"/> -->
<bm:data-filter name="5" enforceOperations="query" expression="t1.company_id = ${/session/@company_id}"/>
<bm:data-filter name="6" enforceOperations="query" expression="nvl(t1.hn_adjust_review_flag,'N')='Y'"/>
</bm:data-filters>
</bm:model>