<?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="OpeningClosingForPrintQuery">
|
<![CDATA[
|
select
|
bbpr_id,bbbr_id,bbbr_name,bbpr_name,bbpr_bbbr_name_list,bbpr_bbbr_id_list,
|
bbiv_size
|
from
|
(
|
SELECT
|
bbpr_id,bbbr_id,bbbr_name,bbpr_name,bbpr_bbbr_name_list,bbpr_bbbr_id_list,
|
(
|
bbiv_size - ifnull((
|
select sum(cgsd_amount_w) from cg_stuff_entry_detail
|
left join cg_stuff_entry on cgse_id=cgsd_cgse_id
|
where 1=1
|
and cgsd_bbpr_id=bbpr_id
|
and cgse_entry_date>=:beginDate
|
),0) +
|
ifnull((
|
select sum(iodd_size) from io_deliver_detail
|
left join io_deliver on iode_id=iodd_iode_id
|
where 1=1
|
and iodd_bbpr_id=bbpr_id
|
and iode_send_date>=:beginDate
|
),0)
|
) bbiv_size
|
FROM
|
bb_product
|
left join bb_product_invertory on bbpr_id=bbiv_bbpr_id
|
left join bb_branch on bbpr_bbbr_id=bbbr_id
|
where 1=1
|
AND bbpr_bbbr_id_list REGEXP :bbbrIds
|
and bbiv_factory_id=:factoryId
|
and bbiv_size is not NULL
|
and bbpr_flag='Y'
|
) a1
|
where 1=1
|
and a1.bbiv_size > 0
|
order by bbbr_id, bbpr_name
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|