SELECT o.pjt_id pid,d.departname pName,u.realname pidName,o.yearmonth,
convert(o.overtime_duration/60,decimal(10,2)) overtimeDuration , o.overtime_fee overtimeFee,o.unit_people_total unitPeopleTotal,
CONCAT(floor(o.overtime_duration/60),'小时',floor(o.overtime_duration - floor(o.overtime_duration/60)*60),'分钟') overtimeDurationStr
from t_bus_proj_overtime_statistics o
LEFT JOIN t_s_depart d
ON o.pjt_id = d.ID
LEFT JOIN t_s_base_user u
ON o.pm_id = u.ID
where 1=1
<#if ( overtimeEntity.attYear )??>
	and o.yearmonth like CONCAT('%', :overtimeEntity.attYear ,'%') 
</#if>
<#if ( overtimeEntity.pid )??>
	and o.pjt_id =:overtimeEntity.pid
</#if>
order by o.yearmonth

