meidu2021/daju/target/classes/cn/com/lzt/distributionstats/sql/DistributionStatsMinidaoDao_distributionStatsProsData.sql

SELECT cds.yearmonth yearmonth ,d.description pName, cds.pjt_id pid, sum(cds.people_num) peopleNum 
from t_bus_projpost_distribution_statistics cds
LEFT JOIN t_s_depart d
ON cds.pjt_id = d.ID
where 1=1
<#if ( distributionEntity.yearMonthList )?? && distributionEntity.yearMonthList ?size gt 0>
			and cds.yearmonth in(
			<#list distributionEntity.yearMonthList as item>        
			   '${item}'
			 <#if item_has_next>,</#if>
			 </#list>
			)
</#if>
GROUP BY cds.pjt_id