<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: hty $Date: 2018/5/17 23:43 $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 overdue_amount from ( SELECT nvl(SUM((nvl(cc.due_amount, 0) - nvl(cc.received_amount, 0))), 0) AS overdue_amount FROM con_contract_cashflow cc WHERE cc.overdue_status = 'Y' AND to_char(cc.due_date, 'yyyyiw') = to_char(trunc(sysdate), 'yyyyiw')) t1 where t1.overdue_amount > 0 ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="overdue_amount" databaseType="NUMBER" datatype="java.lang.Double" forDisplay="true" forQuery="true" physicalName="overdueAmount" prompt="员工号"/> </bm:fields> </bm:model>