| 1234567891011121314151617 |
- 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
|
