<?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="HistoryDeliverDetailQuery">
|
<![CDATA[
|
|
select p.bbpr_id,p.bbpr_name,p.bbpr_style,p.bbpr_unit,bbiv_size
|
d.iodd_id,d.iodd_cost_price,d.iodd_sale_price,d.iodd_size,d.iodd_remark,d.iodd_type,d.iodd_product_name,
|
e.iode_id,e.iode_bbbp_id,
|
IFNULL(bbiv.bbiv_size,0) as bbiv_szie,
|
IFNULL(bbiv.bbiv_reject_size,0) as bbiv_reject_szie
|
from io_deliver_detail d
|
left join io_deliver e on e.iode_id=d.iodd_iode_id
|
left join bb_product p on p.bbpr_id=d.iodd_bbpr_id
|
left join bb_product_invertory bbiv on (p.bbpr_id=bbiv.bbiv_bbpr_id and bbiv_factory_id in (:factoryIds) )
|
where 1=1
|
and if(bbiv.bbiv_id is null or bbiv_factory_id not in (:factoryIds),'1=1', bbiv_factory_id in (:factoryIds))
|
<<and e.iode_bbbp_id=:bbbpId>>
|
<<and i.factory_id in (:factoryIds)>>
|
GROUP BY d.iodd_bbpr_id
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
