<?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="ChuZhiRatioReportQuery">
|
<![CDATA[
|
|
select sum(prpd_size) sum_prpd_size,
|
sum(prpd_reject_size) sum_prpd_reject_size,b.prpe_entry_date,
|
sum(d.iose_amount) sum_iose_amount,sum(d.iose_reject_amount) sum_iose_reject_amount,
|
sum(e.bbst_ratio*iose_amount) ideal_prpd_size
|
|
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 left join
|
io_stuff_exit d on b.prpe_id=d.iose_prpe_id left join
|
bb_stuff e on d.iose_bbst_id=e.bbst_id
|
|
where 1=1
|
and b.prpe_method='生产'
|
and b.prpe_is_run='已运转'
|
and d.iose_good='成品'
|
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) or b.prpe_members=:prpeMembers) >>
|
<<and (b.prpe_line like concat(:prpeLine, ',%') or b.prpe_line like concat('%,',:prpeLine, ',%') or b.prpe_line like concat('%,',:prpeLine) or b.prpe_line=:prpeLine ) >>
|
group by b.prpe_entry_date
|
order by b.prpe_entry_date desc
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
