<?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="FindRelativeTeamQuery">
|
<![CDATA[
|
|
select
|
bbwt_name,
|
convert(GROUP_CONCAT(bbem_name, ', ') using utf8) bbem_name_list,
|
bbwt_id
|
from bb_work_type
|
left join fi_work_leader on fiwl_bbwt_id=bbwt_id
|
left join fi_work_leader_detail on fiwl_id=fiwd_fiwl_id
|
left join bb_employees on bbem_id=fiwd_bbem_id
|
where
|
1=1
|
and bbwt_name like concat(:bbwtName, '%')
|
and bbwt_id <> :bbwtId
|
and fiwl_factory_id=:fiwlFactoryId
|
and fiwl_year_month=:fiwlYearMonth
|
group by bbwt_id
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
