liuxiaolong
2019-05-09 0d1d88cdb668e75ea8609417ac18ae19947e9525
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?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 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>