<?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="FindWorkLeaderForAddQuery">
|
<![CDATA[
|
|
SELECT
|
0.0 fiwd_days,fipd_bbem_id fiwd_bbem_id, bbem_name fiwd_bbem_name,0.0 fiwl_total,
|
0.0 fiwd_tax,0 fiwl_bbwt_id,'' fiwl_year_month
|
FROM
|
fi_piece_work
|
LEFT JOIN fi_piece_work_detail ON fipw_id = fipd_fipw_id
|
left join bb_employees on fipd_bbem_id=bbem_id
|
where 1=1
|
and fipd_size > 0
|
and DATE_FORMAT(fipw_date, '%Y-%m') = :yearMonth
|
and fipw_factory_id=:fipwFactoryId
|
and fipw_bbwt_id=:fipwBbwtId
|
group by fipd_bbem_id
|
having count(fipd_id) > 0
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
