get_total_contract_count.lwm 845 Bytes
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
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: hty
    $Date: 2018/5/18 10:30
    $Revision: 1.0 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT count(*) contract_count
                FROM
                  con_contract c
                WHERE
                  c.contract_status NOT IN (
                    'CANCEL',
                    'HISTORY',
                    'REJECT')
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="contract_count" databaseType="NUMBER" datatype="java.lang.Long" forDisplay="true" forQuery="true" physicalName="contract_count" prompt="员工号"/>
    </bm:fields>
</bm:model>