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
| <?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="OpeningClosingCheckedQuery">
| <![CDATA[
|
| SELECT
| bbpr_id,
| bbpr_id iocd_bbpr_id,
| bbpr_name,
| bbpr_bbbr_name_list,
| bbpr_brief_name,
| bbpr_style,
| bbpr_unit,
| bbpr_second_unit,
| bbpr_second_size,
| bbpr_remark,
| iocd_opening_size,
| iocd_in_size,
| iocd_out_size,
| iocd_closing_size,
| iocd_opening_reject_size,
| iocd_in_reject_size,
| iocd_out_reject_size,
| iocd_closing_reject_size,
| iocd_id,
| iocd_profit_cgsd_id,
| iocd_other_cgsd_id,
| iocd_loss_iodd_id,
| iocd_other_iodd_id,
| iocd_profit_loss,
| iocd_adjust_size,
| iocd_price,
| iocd_now_size,
| iocd_remark,
| iocd_prev_price,
| iocd_check_flag,
| bbiv_price_avg,
| iooc_remark,
| bbiv_size
| FROM
| io_opening_closing
| LEFT JOIN io_opening_closing_detail ON iocd_iooc_id = iooc_id
| LEFT JOIN bb_product ON bbpr_id = iocd_bbpr_id
| LEFT JOIN bb_product_invertory ON bbiv_bbpr_id = bbpr_id
| WHERE
| 1 = 1
| AND iooc_factory_id = :factoryId
| AND bbiv_factory_id = :factoryId
| AND iooc_year_month =:yearMonth
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
