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