<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select to_char(add_months(to_date(${@month}, 'YYYYMM'), 0), 'MM')cur, to_char(add_months(to_date(${@month}, 'YYYYMM'), -1), 'MM')befor1, to_char(add_months(to_date(${@month}, 'YYYYMM'), -2), 'MM')befor2, to_char(add_months(to_date(${@month}, 'YYYYMM'), -3), 'MM')befor3, to_char(add_months(to_date(${@month}, 'YYYYMM'), -4), 'MM')befor4, to_char(add_months(to_date(${@month}, 'YYYYMM'), -5), 'MM')befor5, to_char(add_months(to_date(${@month}, 'YYYYMM'), -1), 'MM')||'月底三期机器分类情况明细表' befor_title, to_char(add_months(to_date(${@month}, 'YYYYMM'), 0), 'MM')||'月底逾期期次' cur_overdue_times, to_char(add_months(to_date(${@month}, 'YYYYMM'), 0), 'MM')||'月小时数' cur_hour, to_char(add_months(to_date(${@month}, 'YYYYMM'), -1), 'MM')||'月小时数' befor1_hour, to_char(add_months(to_date(${@month}, 'YYYYMM'), -2), 'MM')||'月小时数' befor2_hour, to_char(add_months(to_date(${@month}, 'YYYYMM'), 0), 'MM')||'月实收金额' cur_amount, to_char(add_months(to_date(${@month}, 'YYYYMM'), -1), 'MM')||'月实收金额' befor1_amount, to_char(add_months(to_date(${@month}, 'YYYYMM'), -2), 'MM')||'月实收金额' befor2_amount, to_char(add_months(to_date(${@month}, 'YYYYMM'), -3), 'MM')||'月实收金额' befor3_amount, to_char(add_months(to_date(${@month}, 'YYYYMM'), -4), 'MM')||'月实收金额' befor4_amount, to_char(add_months(to_date(${@month}, 'YYYYMM'), -5), 'MM')||'月实收金额' befor5_amount from dual ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:data-filters><![CDATA[ ]]></bm:data-filters> </bm:model>