| 123456789101112131415 |
- SELECT w.pjt_id pid,d.departname pName,u.realname pidName,w.yearmonth
- ,w.unit_people_total peopleTotal,w.wage_pay_total wagePayTotal
- from t_bus_proj_wage_statistics w
- LEFT JOIN t_s_depart d
- ON w.pjt_id = d.ID
- LEFT JOIN t_s_base_user u
- ON w.pm_id = u.ID
- where 1=1
- <#if ( wageEntity.attYear )??>
- and w.yearmonth like CONCAT('%', :wageEntity.attYear ,'%')
- </#if>
- <#if ( wageEntity.pid )??>
- and w.pjt_id =:wageEntity.pid
- </#if>
- order by w.yearmonth
|
