execute_calendar_query.lwm 3.82 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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:s="leaf.plugin.script" xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false" defaultOrderBy="t1.times">
    <bm:fields>
        <bm:field name="contract_id"/>
        <bm:field name="lease_channel"/>
        <bm:field name="contract_number"/>
        <bm:field name="bp_name"/>
        <bm:field name="colour_scheme"/>
        <bm:field name="cf_direction"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long"/>
        <bm:field name="cf_item"/>
        <bm:field name="cf_item_n"/>
        <bm:field name="calc_date"/>
        <bm:field name="due_amount" databaseType="NUMBER" datatype="java.lang.Double"/>
        <bm:field name="principal" databaseType="NUMBER" datatype="java.lang.Double"/>
        <bm:field name="interest" databaseType="NUMBER" datatype="java.lang.Double"/>
        <bm:field name="received_amount" databaseType="NUMBER" datatype="java.lang.Double"/>
        <bm:field name="outstanding_prin_tax_incld" databaseType="NUMBER" datatype="java.lang.Double"/>
        <bm:field name="total_rental"/>
    </bm:fields>
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
          select t1.cashflow_id,
                       t1.contract_id,
                       (Select ch.description
                          from hls_lease_channel ch
                         Where ch.lease_channel = (select c.lease_channel
                                                    from con_contract c
                                                    where c.contract_id = t1.contract_id)) As lease_channel,
                       (select c.contract_number
                          from con_contract c
                         where c.contract_id = t1.contract_id) contract_number,
                       (select c.total_rental
                          from con_contract c
                         where c.contract_id = t1.contract_id) total_rental,
                       (select h.bp_name
                          from hls_bp_master h
                         where h.bp_id = (select c.bp_id_tenant
                                            from con_contract c
                                           where c.contract_id = t1.contract_id)) bp_name,
                       t1.colour_scheme,
                       (select v.code_value_name
                          from sys_code_values_v v
                         where v.code = 'CF_DIRECTION'
                           and v.code_value = t1.cf_direction) cf_direction,
                       t1.times,
                       t1.cf_item,
                       cf.description as cf_item_n,
                       to_char(t1.calc_date,'yyyy/mm/dd') calc_date,
                       t1.due_amount,
                       t1.principal,
                       t1.interest,
                       t1.received_amount,
                       t1.outstanding_prin_tax_incld
                  from con_contract_cashflow t1,
                       hls_cashflow_item     cf,
                       hls_cashflow_type     cft

                #WHERE_CLAUSE#
                 #ORDER_BY_CLAUSE#
                ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <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:data-filters>
        <bm:data-filter name="join" expression="t1.cf_item = cf.cf_item
                   and t1.cf_type = cft.cf_type
                   and t1.times &gt; 0
                   and t1.cf_item in(1,3,8,102,103,104)"/>
        <bm:data-filter expression="t1.contract_id = ${@contract_id}" name="contract_id"/>
    </bm:data-filters>
</bm:model>