<?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="ProcureListQuery">
|
<![CDATA[
|
|
SELECT
|
cgpr_id,cgpr_sn,'' syde_name,bbbp_name,bbpr_sn,bbpr_name,cgpd_size,cgpd_entry_size,cgpd_price*cgpd_entry_size cgpd_subtotal,cgpr_order_date,cgpd_finish_state
|
FROM
|
cg_procure
|
LEFT JOIN cg_procure_detail ON cgpr_id = cgpd_cgpr_id
|
left join bb_business_partner on cgpd_bbbp_id=bbbp_id
|
left join bb_product on cgpd_bbpr_id=bbpr_id
|
WHERE
|
1 = 1
|
<<and cgpr_order_date>=:beginOrderDate>>
|
<<and cgpr_order_date<=:endOrderDate>>
|
<<and cgpr_sn like concat('%',:cgprSn,'%')>>
|
<<and bbbp_name like concat('%',:bbbpName,'%')>>
|
<<and bbpr_sn like concat('%',:bbprSn,'%')>>
|
<<and bbpr_name like concat('%',:bbprName,'%')>>
|
<<and cgpd_finish_state=:cgpdFinishState>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
