<?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="PsingLeftQuery">
|
<![CDATA[
|
|
select a.ouqp_date,if(sum(a.weidayin)>0,'完成','未完成') as wancheng
|
from
|
(
|
select ouqp_date,if(ouqp_author is null,1,0) as weidayin from out_qingling_process
|
left join out_qingling_detail on ouqd_id=ouqp_ouqd_id
|
left join bb_warehouse on bbwh_id=ouqd_bbwh_id
|
where 1=1
|
<<and (ouqd_bbwh_id is null or bbwh_syus_ids like concat('%',:syusId,'%'))>>
|
and ouqp_locationid=:locationid
|
and ##CONDITIONS##
|
) as a
|
group by a.ouqp_date
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
