<?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="FindOrderDetailToDeliverQuery">
|
<![CDATA[
|
|
|
select
|
o.prod_id AS iodd_prod_id,
|
o.prod_pror_id,
|
o.prod_bbpr_id AS iodd_bbpr_id,
|
o.prod_order_size,
|
o.prod_price AS iodd_sale_price,
|
o.prod_sale_type AS iodd_type,
|
o.prod_flags,
|
o.prod_remark,
|
o.prod_fenpei,
|
o.prod_pinpai,
|
o.prod_bbpr_style,
|
p.bbpr_name as iodd_product_name,
|
p.bbpr_style
|
FROM
|
pr_order_detail AS o
|
left join bb_product AS p on o.prod_bbpr_id = p.bbpr_id
|
left join pr_order on pror_id=prod_pror_id
|
WHERE o.prod_flags<> '完成'
|
<<and o.prod_pror_id in (:prorIds)>>
|
<<and o.prod_id in (:prodIds)>>
|
<<and pror_bbbp_id=:bbbpId>>
|
<<and bbpr_name like concat("%",:bbprName,"%")>>
|
<<and bbpr_style=:bbprStyle>>
|
<<and pror_send_date>=:beginSendDate>>
|
<<and pror_send_date<=:endSendDate>>
|
<<and pror_sn like concat("%", :prorSn, "%")>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
