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