应用场景:一个月内,每隔两周的周三会进行自评价,现需要做一个月报表,统计自评价截止上月累计评价分、本月评价分_未提交、本月评价分_未评价、本月评价分_优秀、本月评价分_小计、截止本月累计评价分,且编制时可自动带出。
解决方案:
1、通过sql获取每个月的自评价提交日,统计月份作为参数,返回当月评价日期字符串,以“,”连接
Dao 文件:public String findZpjDate(Date month);
xml文件:
<select id="findZpjDate" resultType="String">
select wm_concat(to_char(send_date, 'yyyy-mm-dd'))
from sys_date
where send_flag = 1
and to_char(send_date, 'yyyy-mm') = to_char(#{countTime}, 'yyyy-mm')
and del_flag = 0
order by send_date
</select>
2、将每个评价日期传入,得到当期评价分
dao:public List<WeekScoreZpjDet> findWeekScoreZpjDetList(String preMonth,String month);
xml:
<select id="findWeekScoreZpjDetList" resultType="weekScoreZpjDet">
SELECT uu.id AS "user.id",
uu.name AS "user.name",
case
when uu.gender = '2' then
'女'
else
'男'
end as "gender",