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
| <?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="StuffEntryQuery">
| <![CDATA[
|
| select
| e.cgse_id,
| e.cgse_sn,
| e.cgse_bbbp_id,
| e.cgse_keeper,
| e.cgse_totle,
| e.cgse_arrears,
| e.cgse_invoice,
| e.cgse_flag_print,
| e.cgse_flag_entry,
| e.creator,
| e.create_time,
| e.modifier,
| e.modify_time,
| e.cgse_remrk,
| e.cgse_fivo_id1,
| e.cgse_fivo_id2,
| b.bbbp_name,
| e.cgse_entry_date,
| e.cgse_zhekou,
| d.cgsd_bbst_id,
| d.cgsd_volume,
| d.cgsd_statue,
| s.bbst_style,
| s.bbst_name,
| s.bbst_type,
| e.cgse_subject_id,
| e.cgse_pay_money,
| sum(ifnull(iosi_amount, 0)) exit_size
| from
| cg_stuff_entry e
| Left Join bb_business_partner b ON e.cgse_bbbp_id = b.bbbp_id
| Left Join cg_stuff_entry_detail d ON e.cgse_id = d.cgsd_cgse_id
| Left Join bb_stuff s ON d.cgsd_bbst_id = s.bbst_id
| left join io_stuff_exit_item on iosi_cgsd_id=d.cgsd_id
| left join bb_product p on p.bbpr_id=d.cgsd_bbpr_id
| where 1=1
| <<and e.cgse_entry_date >= :startEntryTime >>
| <<and e.cgse_entry_date <= :endEntryTime >>
| <<and e.cgse_id = :cgseId >>
| <<and e.cgse_id in (:cgseIds)>>
| <<and e.factory_id in (:factoryId)>>
| <<and e.cgse_flag_entry=:cgseFlagEntry>>
| <<and p.bbpr_name like concat("%",:bbprName,"%")>>
| <<and p.bbpr_style=:bbprStyle>>
| and ##CONDITIONS##
| GROUP BY e.cgse_id
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
