financing_query.lwm 2.22 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
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
             SELECT
                    t.product_plan_id,
                    t.if_self_definition,
                    t.product_type,
                    t.product_number,
                    t.times,
                    
         t.PRODUCT_NAME_WRITE,
         t.special_note,
        -- t.DOWN_PAYMENT_RATIO*100||'%',
         t.DOWN_PAYMENT_RATIO*100 DOWN_PAYMENT_RATIO,
         t.MARGIN_RATIO*100  MARGIN_RATIO,
          t1.btb_int_rate_implicit*100  btb_int_rate_implicit,
         t1.btb_int_rate_implicit*100 int_rate_display,
         t.TIMES lease_times,
         t.times_n lease_times_n,
         t.REPAYMENTS ANNUAL_PAY_TIMES,
         t.repayments_n ANNUAL_PAY_TIMES_n,
         t.PRICE_LIST,
         (select hl.description  from hls_price_list hl where hl.price_list=t.price_list) 
          price_list_n,
                  
                    
                    t.lease_charge_ratio*100  lease_charge_ratio
                FROM
                    HLS_PRODUCT_PLAN_DEFINITION_VL t,HLS_PRODUCT_PLAN_DEFINITION  t1
                WHERE
                    t.enable_flag = 'Y'
                    and t1.product_plan_id = t.product_plan_id
                    

             
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="product_number"/>
        <bm:field name="product_type"/>
        <bm:field name="times"/>
        <bm:field name="if_self_definition"/>
        <bm:field name="lease_charge_ratio"/>
        <bm:field name="product_plan_id"/>
        <bm:field name="special_note"/>
        <bm:field name="PRODUCT_NAME_WRITE"/>
        <bm:field name="DOWN_PAYMENT_RATIO"/>
        <bm:field name="MARGIN_RATIO"/>
        <bm:field name="btb_int_rate_implicit"/>
        <bm:field name="lease_times"/>
        <bm:field name="lease_times_n"/>
        <bm:field name="ANNUAL_PAY_TIMES"/>
        <bm:field name="ANNUAL_PAY_TIMES_n"/>
        <bm:field name="PRICE_LIST"/>
        <bm:field name="price_list_n"/>
        <bm:field name="int_rate_display"/>
    </bm:fields>
</bm:model>