<?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="PrintPsingA4GetProductQuery">
|
<![CDATA[
|
|
select
|
a.*,sum(a.ouqp_size) as process_size,GROUP_CONCAT(a.ouqp_author)
|
as authors
|
from
|
(
|
select
|
bbpr_id,bbpr_sn,bbpr_name,bbpr_brand,sydi_name as bbpr_lei_xing,bbpr_size,ouqp_author,
|
ouqp_size
|
from out_qingling_process
|
left join out_qingling_detail on ouqp_ouqd_id=ouqd_id
|
left join bb_warehouse on ouqd_bbwh_id=bbwh_id
|
left join bb_product on ouqd_bbpr_id=bbpr_id
|
left join sys_dictionary on sydi_id=bbpr_sydi_id
|
where 1=1
|
<<and ouqp_date=:ouqpDate>>
|
and (ouqd_bbwh_id is null or bbwh_syus_ids like concat('%',',:syusId,','%'))
|
and ouqp_locationid=:locationid
|
and ouqd_bbpr_id in (:bbprIds)
|
and ##CONDITIONS##
|
) as a
|
group by a.bbpr_id
|
ORDER BY a.bbpr_name
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
