| 1234567891011121314151617 |
- SELECT d.description pjName,u.realname pidName,a.yearmonth
- ,CONCAT(floor(a.datum_work_duration/60) ,'小时',floor(a.datum_work_duration - floor(a.datum_work_duration/60)*60),'分钟') datumWorkDuration
- ,CONCAT(floor(a.attendance_duration/60) ,'小时',floor(a.attendance_duration - floor(a.attendance_duration/60)*60),'分钟') attendanceDuration
- ,convert(a.attendance_rate,decimal(10,2)) attendanceRate
- from t_bus_proj_attendance_statistics a
- LEFT JOIN t_s_depart d
- ON a.pjt_id = d.ID
- LEFT JOIN t_s_base_user u
- ON a.pm_id = u.ID
- where 1=1
- <#if ( statsDao.attYear )??>
- and a.yearmonth like CONCAT('%', :statsDao.attYear ,'%')
- </#if>
- <#if ( statsDao.pid )??>
- and a.pjt_id =:statsDao.pid
- </#if>
- order by a.yearmonth
|
