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
53
54
55
56
57
58
59
60
61
| <?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="FindOrderDetailToDeliverQuery">
| <![CDATA[
|
| select
| s.bbst_amount,
| s.bbst_style,
| s.bbst_occuption,
| o.prod_id AS iodd_prod_id,
| o.prod_pror_id,
| o.prod_bbpr_id AS iodd_bbpr_id,
| o.prod_bbst_id AS iodd_bbst_id,
| o.prod_order_size,
| o.prod_entry_size,
| o.prod_exit_size,
| o.prod_price AS iodd_sale_price,
| o.prod_quantity,
| o.prod_sale_goods AS iodd_goods_type,
| o.prod_sale_type AS iodd_type,
| o.prod_flagp,
| o.prod_flags,
| o.prod_flagt,
| o.prod_remark,
| p.bbpr_id,
| p.bbpr_name,
| p.bbpr_style,
| p.bbpr_occuption,
| p.bbpr_size,
| s.bbst_name,
| p.bbpr_reject_size,
| s.bbst_reject_amount,
| ifnull((select
| sum(b.prpd_now_size-ifnull((
| select sum(reop_size)
| from
| ref_order_product_entry
| where 1=1
| and reop_prpd_id=b.prpd_id
| and reop_flag='N'
| ),0))
| from
| pr_product_entry_detail b
| where 1=1
| and b.prpd_prod_id=o.prod_id
| ),0) actual_now_size
| FROM
| pr_order_detail AS o
| Left Join bb_stuff AS s ON o.prod_bbst_id = s.bbst_id left join
| bb_product AS p on o.prod_bbpr_id = p.bbpr_id
| WHERE o.prod_flagt='已审核' and o.prod_flags<> '完成' and o.prod_flagp<> '未生产'
| and o.prod_pror_id in (:prorIds)
| and ##CONDITIONS##
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
