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
| <?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="BbWorkTypeMembersQuery">
| <![CDATA[
|
| SELECT
| b1.bbwt_id,b1.bbwt_name,b1.bbwt_price,b1.bbwt_remark,b1.bbwt_need_run,b1.bbwt_calc_flag,b2.bbwt_members
| FROM
| bb_work_type b1
| LEFT JOIN (
| SELECT
| bbwt_id,
| bbwt_name,
| GROUP_CONCAT(bbem_name SEPARATOR ', ') bbwt_members
| FROM
| (
| SELECT
| bbwt_id,
| bbem_id,
| bbwt_name,
| bbem_name
| FROM
| fi_work_leader
| LEFT JOIN fi_work_leader_detail ON fiwl_id = fiwd_fiwl_id
| LEFT JOIN bb_employees ON bbem_id = fiwd_bbem_id
| LEFT JOIN bb_work_type ON fiwl_bbwt_id = bbwt_id
| WHERE
| 1 = 1
| AND fiwl_factory_id = :factoryId
| AND bbwt_factory_id = :factoryId
| AND fiwl_year_month = :yearMonth
| GROUP BY
| fiwl_bbwt_id,
| fiwd_bbem_id
| ) a1
| GROUP BY
| a1.bbwt_id
| ) b2 ON b1.bbwt_id = b2.bbwt_id
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
