rpt5012_result_query.lwmbak 2.34 KB
Newer Older
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
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WangYu  
    $Date: 2014-4-25 上午09:30:21  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            	select t.*
				from con_rental_balance_rpt t
				where t.month = ${@month}
        		order by t.contract_id desc
                
            ]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
		        begin
		           rpt5012_rental_balance_pkg.rental_balance_insert(
		           p_month   =>${@month},
                                 p_user_id      =>${/session/@user_id},
                                 p_batch_id       =>${@batch_id}
                                );
		        end;
        ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="agent_extra_name"/>
        <bm:field name="bp_tenant_name"/>
        <bm:field name="contract_number"/>
        <bm:field name="lease_start_date"/>
        <bm:field name="modelcd"/>
        <bm:field name="machine_number"/>
        <bm:field name="int_rate_diaplay"/>
        <bm:field name="lease_times"/>
        <bm:field name="down_payment_ratio"/>
        <bm:field name="lease_item_amount"/>
        <bm:field name="residual_amount"/>
        <bm:field name="contract_amount"/>
        <bm:field name="down_payment"/>
        <bm:field name="month_due_amount"/>
        <bm:field name="month_due_principal"/>
        <bm:field name="month_interest"/>
        <bm:field name="month_residual"/>
        <bm:field name="business_due_times"/>
        <bm:field name="business_due_amount"/>
        <bm:field name="deposit_amount"/>
        <bm:field name="contract_status_n"/>
        <bm:field name="residual_date"/>
        <bm:field name="terminate_date"/>



    </bm:fields>
<!--    <bm:query-fields>-->
<!--        <bm:query-field field="bp_id_tenant_n" queryExpression="t1.bp_id_tenant_n = ${@bp_id_tenant_n}"/>-->
<!--        <bm:query-field field="account_name" queryExpression="t1.account_name = ${@account_name}"/>-->
<!--        <bm:query-field field="account_id_n" queryExpression="t1.account_id_n = ${@account_id_n}"/>-->
<!--    </bm:query-fields>-->
</bm:model>