<?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="TaskDetailMappingQuery">
|
<![CDATA[
|
|
select prta_id,prtd_id,prta_number,prta_sn,prta_line,prta_team,prta_task_date,prta_require_date,
|
prta_members,bbbp_name,bbpr_name,bbpr_style,bbst_name,bbst_style,
|
ceil(prtd_size/bbst_ratio) stuffSize,prtd_size,prtd_entry_size,
|
prtd_flag_produce,prtd_normal_amount,prtd_unnormal_amount,prtd_remark,bbst_ratio,bbst_id,bbst_amount,bbst_occuption,prod_urgent,
|
iosp_sn,prod_remark
|
from pr_task_detail
|
left join pr_order_detail on prod_id = prtd_prod_id
|
left join pr_order on prod_pror_id=pror_id
|
left join bb_business_partner on pror_bbbp_id=bbbp_id
|
left join sys_dictionary on bbbp_sydi_id=sydi_id
|
left join bb_product on prod_bbpr_id=bbpr_id
|
left join bb_stuff on bbst_id=prod_bbst_id
|
left join pr_task on prta_id=prtd_prta_id left join
|
io_stuff_pick on iosp_prod_id=prod_id
|
where 1=1
|
<<and prtd_prta_id in (:prtdPrtaId)>>
|
<<and prta_sn in (:prtaSns)>>
|
|
and ##CONDITIONS##
|
order by prta_line desc,prta_number asc,prta_sn
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
