<?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="FiPieceWorkQuery">
|
<![CDATA[
|
|
select day(fipw_date) fipwDay, fipw_date,bbem_name,fipw_size,fipd_size,bbem_id 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 fipw_bbwt_id=:bbwtId>>
|
<<and year(fipw_date)=:fipwYear>>
|
<<and month(fipw_date)=:fipwMonth>>
|
and ##CONDITIONS##
|
order by fipd_bbem_id
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
