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
| <?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="IoDeliverDetailQuery">
| <![CDATA[
|
| select
| d.iodd_id,
| d.iodd_did,
| d.iodd_iode_id,
| d.iodd_bbpr_id,
| d.iodd_prod_id,
| d.iodd_cost_price,
| d.iodd_product_name,
| d.iodd_sale_price,
| d.iodd_size,
| d.iodd_sub_total,
| d.iodd_type,
| d.iodd_return_size,
| d.iodd_tax,
| d.iodd_remark,
| od.prod_bbpr_style,
| od.prod_pinpai,
| p.bbpr_unit,
| p.bbpr_name
| IFNULL(bbiv.bbiv_size,0) as bbiv_szie,
| IFNULL(bbiv.bbiv_reject_size,0) as bbiv_reject_szie
| from
| io_deliver_detail d
| left join bb_stuff s on d.iodd_bbst_id = s.bbst_id
| left join bb_product p on d.iodd_bbpr_id = p.bbpr_id
| left join pr_order_detail od on od.prod_id=d.iodd_prod_id
| left join bb_product_invertory bbiv on d.iodd_bbpr_id=bbiv.bbiv_bbpr_id
| where 1=1
| and if(bbiv.bbiv_id is null,'1=1', bbiv_factory_id in (:factoryIds))
| <<and d.iodd_iode_id in (:iodeId)>>
| and ##CONDITIONS##
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
