数据拆分、合并思路(Java)

String fileName = file.getOriginalFilename();
Date date = new Date();
try {
 //easyExcel导入表格数据
 List<SatisfactionInfoOfYearRes> satisfactionOfYearList = EasyExcel.read(new BufferedInputStream(file.getInputStream()))
 .head(SatisfactionInfoOfYearRes.class).sheet().doReadSync();
 //遍历,按季度拆分数据,分别操作
 satisfactionOfYearList.forEach(satisfactionInfoOfYearRes -> {
 if (satisfactionInfoOfYearRes.getProjectName() == null || satisfactionInfoOfYearRes.getProjectId() == null || satisfactionInfoOfYearRes.getYear() == null) {
 return;
 }
 MpSatisfactionInfoDO satisfactionInfoDO = new MpSatisfactionInfoDO();
 BeanUtils.copyProperties(satisfactionInfoOfYearRes, satisfactionInfoDO);
 Map<String,BigDecimal> quarter = new HashMap<>();
 BigDecimal firstQuarter = satisfactionInfoOfYearRes.getFirstQuarter();
 BigDecimal secondQuarter = satisfactionInfoOfYearRes.getSecondQuarter();
 BigDecimal thirdQuarter = satisfactionInfoOfYearRes.getThirdQuarter();
 BigDecimal fourthQuarter = satisfactionInfoOfYearRes.getFourthQuarter();
 quarter.put("1",firstQuarter);
 quarter.put("2",secondQuarter);
 quarter.put("3",thirdQuarter);
 quarter.put("4",fourthQuarter);
 quarter.forEach((k,v)->{
 if (v == null){
 return;
 }
 satisfactionInfoDO.setQuarter(k);
 satisfactionInfoDO.setSatisfaction(v);
 //每次新增前判断是否存在该数据
 String recordId = this.satisfactionInfoDao.selectRecordId(satisfactionInfoDO);
 if (StringUtils.isBlank(recordId)){
 //insert
 satisfactionInfoDO.setRecordId(TinyUUIDGenerator.generate());
 //这里将直接从请求头获取的数据进行urlCode解码
 satisfactionInfoDO.setCreateBy(URLDecoder.decode(userInfo.getRealName()));
 satisfactionInfoDO.setCreateTime(date);
 satisfactionInfoDO.setIsDeleted("00");
 satisfactionInfoDao.insert(satisfactionInfoDO);
 }else {
 //update
 satisfactionInfoDO.setRecordId(recordId);
 satisfactionInfoDO.setUpdateBy(URLDecoder.decode(userInfo.getRealName()));
 satisfactionInfoDO.setUpdateTime(date);
 this.satisfactionInfoDao.update(satisfactionInfoDO);
 }
 });
 } catch (IOException e) {
 throw new RuntimeException(e);
 }
 return BaseResponse.success("导入成功");

SELECT a.project_id,a.project_name,a.`quarter`,a.YEAR,a.satisfaction,a.create_time,a.create_by ,
-- 合并季度数据
GROUP_CONCAT(a.`quarter`) AS quarters,
-- 合并满意度数据,如果为空则赋值0
GROUP_CONCAT(IFNULL(a.satisfaction,0)) AS satisfactions
FROM
mp_satisfaction_info a
WHERE a.is_deleted = "00"
GROUP BY
a.YEAR,
a.project_id
order by a.`year`, a.`quarter`

Page<Object> page = PageHelper.startPage(pageNum, pageSize);
 List<MpSatisfactionInfoDO> list = satisfactionInfoDao.list(pageReq.getYear(),pageReq.getProjectName());
 //mergeList()方法的代码在下面
 List<SatisfactionInfoOfYearRes> resList = this.mergeList(list);
 PageResponse pageResponse = new PageResponse();
 pageResponse.setData(resList);
 pageResponse.setTotalNum(page.getTotal());
 pageResponse.setTotalPage(page.getPages());
 return pageResponse; 

private List<SatisfactionInfoOfYearRes> mergeList(List<MpSatisfactionInfoDO> list) {
 ArrayList<SatisfactionInfoOfYearRes> resList = new ArrayList<>();
 list.forEach(p ->{
 SatisfactionInfoOfYearRes satisfactionInfoOfYearRes = new SatisfactionInfoOfYearRes();
 BeanUtils.copyProperties(p, satisfactionInfoOfYearRes);
 String[] quarters = p.getQuarters().split(",");
 String[] satisfactions = p.getSatisfactions().split(",");
 for (int i = 0; i < quarters.length; i++){
 String quarter = quarters[i];
 BigDecimal satisfaction = new BigDecimal(satisfactions[i]);
 switch (quarter){
 case "1":
 satisfactionInfoOfYearRes.setFirstQuarter(satisfaction);
 break;
 case "2":
 satisfactionInfoOfYearRes.setSecondQuarter(satisfaction);
 break;
 case "3":
 satisfactionInfoOfYearRes.setThirdQuarter(satisfaction);
 break;
 case "4":
 satisfactionInfoOfYearRes.setFourthQuarter(satisfaction);
 }
 }
 resList.add(satisfactionInfoOfYearRes);
 });
 return resList;
 }