<?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="RejectionRatioReportQuery">
|
<![CDATA[
|
|
select sum(prpd_size) sum_prpd_size,
|
sum(prpd_reject_size) sum_prpd_reject_size,b.prpe_entry_date
|
|
from pr_product_entry_detail left join
|
pr_product_entry b on b.prpe_id=prpd_prpe_id left join
|
bb_product c on c.bbpr_id=prpd_bbpr_id
|
|
where 1=1
|
and b.prpe_method='生产'
|
and (prpd_size>0 or prpd_reject_size>0)
|
<<and b.prpe_entry_date>=:beginDate>>
|
<<and b.prpe_entry_date<=:endDate>>
|
<<and c.bbpr_name=:bbprName>>
|
<<and c.bbpr_style=:bbprStyle>>
|
<<and b.prpe_team=:prpeTeam>>
|
<<and (b.prpe_members like concat(:prpeMembers, ',%') or b.prpe_members like concat('%,',:prpeMembers, ',%') or b.prpe_members like concat('%,',:prpeMembers) ) >>
|
<<and (b.prpe_line like concat(:prpeLine, ',%') or b.prpe_line like concat('%,',:prpeLine, ',%') or b.prpe_line like concat('%,',:prpeLine) ) >>
|
group by b.prpe_entry_date
|
order by b.prpe_entry_date desc
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
