<?xml version="1.0"?>
|
<!DOCTYPE hibernate-mapping PUBLIC
|
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
|
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
|
<hibernate-mapping>
|
<sql-query name="IncomeStatementQuery">
|
<![CDATA[
|
|
SELECT
|
fisu_id,sum(fivd_debtor_money) sum_debit, sum(fivd_creditor_money) sum_credit,
|
fisu_name,fisu_sn,fisu_direction,
|
case when fisu_direction='借' then sum(fivd_debtor_money)
|
when fisu_direction='借' then sum(fivd_creditor_money)
|
else 0.0
|
end as lei_ji
|
FROM
|
fi_voucher v
|
LEFT JOIN fi_voucher_detail ON fivo_id = fivd_fivo_id
|
left join fi_subject on fivd_subject_id=fisu_id
|
where 1=1
|
and fivo_is_cancle<>'Y'
|
and fivo_type<>'初始化'
|
and fisu_type<>'损益类'
|
and fivo_date<=:fivoDate
|
and fivo_fiac_id=:fiboId
|
and v.factory_id=:factoryId
|
group by fisu_id
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
