1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
| <?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="EntryDetailAddQuery">
| <![CDATA[
| select * from (
| SELECT
| cgpr_sn,
| bbbp_sn,
| cgpd_id,
| bbpr_id,
| bbpr_name,
| bbpr_sn,
| bbpr_style,
| cgpd_size,
| sum(cgpd_id) cged_size,
| bbbp_id,
| cgpd_entry_size,
| cgpr_bbbp_id cgen_bbbp_id,
| bbbp_name,
| cgpd_price
| FROM
| bb_product_item
| left join cg_procure_detail on bbit_cgpd_id=cgpd_id
| left join cg_procure on cgpr_id=cgpd_cgpr_id
| LEFT JOIN bb_product ON cgpd_bbpr_id = bbpr_id
| LEFT JOIN bb_business_partner ON bbbp_id = cgpr_bbbp_id
| WHERE
| 1 = 1
| AND bbit_cged_id IS NULL
| <<and cgpr_bbbp_id=:bbbpId>>
| <<and cgpd_locationid=:locationid>>
| <<and cgpr_locationid=:locationid>>
| <<and (cged_locationid=:locationid or cged_locationid is null)>>
| <<and bbpr_locationid=:locationid>>
| <<and cgpr_sn like concat('%', :cgprSn, '%')>>
| <<and bbbp_name like concat('%', :bbbpName, '%')>>
| <<and bbpr_name like concat('%', :bbprName, '%')>>
| <<and cgpd_id not in (:notCgpdIds) >>
|
| and ##CONDITIONS##
| ) a1
| where 1=1
| and cged_size > 0
| order by bbbp_id,bbbp_name, bbpr_name
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
