<?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="PsinfLeftQuery">
|
<![CDATA[
|
|
select ouqd_process_date,ouqd_
|
from out_qingling_detail
|
left join out_qingling on ouql_id=ouqd_ouql_id
|
where 1=1
|
and ouql_state='保存'
|
and ouql_flow_state=100
|
and ouqd_send_size<ouqd_size
|
and ouqd_state <> '完成'
|
|
and ouqd_process_date is not null
|
and ( ouqd_pei_huo_author='' or ouqd_pei_huo_author is null)
|
and ouql_locationid=:locationid
|
and 0=0
|
group by ouqd_process_date
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
