package com.by4cloud.platformx.business.service.impl; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.date.DatePattern; import cn.hutool.core.date.DateUtil; import cn.hutool.core.util.ObjUtil; import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.by4cloud.platformx.business.dto.ZBJTStatisticDTO; import com.by4cloud.platformx.business.entity.BipDict; import com.by4cloud.platformx.business.entity.ZbStatisticCpXssr; import com.by4cloud.platformx.business.entity.ZbStatisticCpXzht; import com.by4cloud.platformx.business.mapper.BipDictMapper; import com.by4cloud.platformx.business.mapper.ContractMapper; import com.by4cloud.platformx.business.mapper.ContractSubjectMatterMapper; import com.by4cloud.platformx.business.mapper.ZbStatisticCpXzhtMapper; import com.by4cloud.platformx.business.service.ZbStatisticCpXzhtService; import com.by4cloud.platformx.business.vo.CpxssrwcqkItemVo; import com.by4cloud.platformx.business.vo.CpxssrwcqkVo; import com.by4cloud.platformx.common.core.util.R; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Objects; /** * 产品新增合同完成情况 * * @author syt * @date 2026-11-12 10:30:21 */ @Service @RequiredArgsConstructor public class ZbStatisticCpXzhtServiceImpl extends ServiceImpl implements ZbStatisticCpXzhtService { private final ContractMapper contractMapper; private final ContractSubjectMatterMapper contractSubjectMatterMapper; private final BipDictMapper bipDictMapper; @Override public R genCpxzhtwcqk(ZBJTStatisticDTO queryDTO) { if (StrUtil.isBlank(queryDTO.getYearMonth())) { queryDTO.setYearMonth(DateUtil.format(new Date(), DatePattern.NORM_MONTH_PATTERN)); } List list = new ArrayList<>(); Date monstart = DateUtil.parseDateTime(queryDTO.getYearMonth()+"-01 00:00:00"); Date monend = DateUtil.parseDateTime(queryDTO.getYearMonth()+"-31 23:59:59"); Date monstartLastYear = DateUtil.offsetYear(DateUtil.parseDateTime(queryDTO.getYearMonth()+"-01 00:00:00"),-1); Date monendLastYear = DateUtil.offsetYear(DateUtil.parseDateTime(queryDTO.getYearMonth()+"-31 23:59:59"),-1); Date yearstart = DateUtil.parseDateTime(queryDTO.getYearMonth().substring(0,4)+"-01-01 00:00:00"); Date yearend = DateUtil.parseDateTime(queryDTO.getYearMonth()+"-31 23:59:59"); Date yearstartLastYear = DateUtil.offsetYear(DateUtil.parseDateTime(queryDTO.getYearMonth().substring(0,4)+"-01-01 00:00:00"),-1); Date yearendLastYear = DateUtil.offsetYear(DateUtil.parseDateTime(queryDTO.getYearMonth()+"-31 23:59:59"),-1); contractMapper.setSession(); List itemVoListDY = contractSubjectMatterMapper.cpxzhtwcqk(monstart,monend); List itemVoListLJ = contractSubjectMatterMapper.cpxzhtwcqk(yearstart,yearend); List itemVoListQN = contractSubjectMatterMapper.cpxzhtwcqk(yearstartLastYear,yearendLastYear); List indexList = new ArrayList<>(); if (CollUtil.isNotEmpty(itemVoListDY)){ for (int i = 0; i < itemVoListDY.size(); i++) { CpxssrwcqkItemVo item = itemVoListDY.get(i); ZbStatisticCpXzht vo = new ZbStatisticCpXzht(); vo.setXm(item.getXm()); vo.setStatYm(queryDTO.getYearMonth()); vo.setSort(i); BipDict dict = bipDictMapper.selectOne(Wrappers.lambdaQuery().eq(BipDict::getDictKey,"zb-cpmc") .eq(BipDict::getParentId,0).eq(BipDict::getDictName,item.getXm()).last("limit 1")); ZbStatisticCpXzht vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticCpXzht::getXm,vo.getXm()) .eq(ZbStatisticCpXzht::getStatYm,vo.getStatYm()).last("limit 1")); if (ObjUtil.isNull(dict)) { vo.setDyxsl(item.getXsl()); vo.setDyxssr(item.getXssr()); if (ObjUtil.isNotNull(vo1)) { vo1.setDyxsl(item.getXsl()); vo1.setDyxssr(item.getXssr()); if (CollUtil.isNotEmpty(itemVoListLJ)) { itemVoListLJ.stream().forEach(item1 -> { if (StrUtil.equals(vo.getXm(), item1.getXm())) { vo1.setLjxsl(item1.getXsl()); vo1.setLjxssr(item1.getXssr()); } }); } if (CollUtil.isNotEmpty(itemVoListQN)) { itemVoListQN.stream().forEach(item1 -> { if (StrUtil.equals(vo1.getXm(), item1.getXm())) { vo1.setQnljxsl(item1.getXsl()); vo1.setQnljxssr(item1.getXssr()); vo1.setTqbxsl(vo1.getLjxsl().subtract(vo1.getQnljxsl())); vo1.setTqbxssr(vo1.getLjxssr().subtract(vo1.getQnljxssr())); } }); } baseMapper.updateById(vo1); }else { vo.setDyxsl(item.getXsl()); vo.setDyxssr(item.getXssr()); if (CollUtil.isNotEmpty(itemVoListLJ)) { itemVoListLJ.stream().forEach(item1 -> { if (StrUtil.equals(vo.getXm(), item1.getXm())) { vo.setLjxsl(item1.getXsl()); vo.setLjxssr(item1.getXssr()); } }); } if (CollUtil.isNotEmpty(itemVoListQN)) { itemVoListQN.stream().forEach(item1 -> { if (StrUtil.equals(vo.getXm(), item1.getXm())) { vo.setQnljxsl(item1.getXsl()); vo.setQnljxssr(item1.getXssr()); vo.setTqbxsl(vo.getLjxsl().subtract(vo.getQnljxsl())); vo.setTqbxssr(vo.getLjxssr().subtract(vo.getQnljxssr())); } }); } baseMapper.insert(vo); } }else { indexList.add(i); if (ObjUtil.isNull(vo1)) { baseMapper.insert(vo); } } list.add(vo); } indexList.add(itemVoListDY.size()); for (int i = 0; i < indexList.size()-1; i++) { List sublist = list.subList(indexList.get(i),indexList.get(i+1)); ZbStatisticCpXzht vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticCpXzht::getXm,list.get(indexList.get(i)).getXm()) .eq(ZbStatisticCpXzht::getStatYm,list.get(indexList.get(i)).getStatYm()).last("limit 1")); vo.setDyxsl(sublist.stream().map(item->item.getDyxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO,BigDecimal::add)); vo.setDyxssr(sublist.stream().map(item->item.getDyxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO,BigDecimal::add)); vo.setLjxsl(sublist.stream().map(item->item.getLjxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO,BigDecimal::add)); vo.setLjxssr(sublist.stream().map(item->item.getLjxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO,BigDecimal::add)); vo.setQnljxsl(sublist.stream().map(item->item.getQnljxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO,BigDecimal::add)); vo.setQnljxssr(sublist.stream().map(item->item.getQnljxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO,BigDecimal::add)); vo.setTqbxsl(vo.getLjxsl().subtract(vo.getQnljxsl())); vo.setTqbxssr(vo.getLjxssr().subtract(vo.getQnljxssr())); baseMapper.updateById(vo); } ZbStatisticCpXzht vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticCpXzht::getXm,"合计") .eq(ZbStatisticCpXzht::getStatYm,queryDTO.getYearMonth()).last("limit 1")); if (ObjUtil.isNotNull(vo)) { vo.setDyxsl(list.stream().map(item -> item.getDyxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setDyxssr(list.stream().map(item -> item.getDyxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setLjxsl(list.stream().map(item -> item.getLjxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setLjxssr(list.stream().map(item -> item.getLjxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setQnljxsl(list.stream().map(item -> item.getQnljxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setQnljxssr(list.stream().map(item -> item.getQnljxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setTqbxsl(vo.getLjxsl().subtract(vo.getQnljxsl())); vo.setTqbxssr(vo.getLjxssr().subtract(vo.getQnljxssr())); baseMapper.updateById(vo); }else { vo = new ZbStatisticCpXzht(); vo.setXm("合计"); vo.setSort(64); vo.setStatYm(queryDTO.getYearMonth()); vo.setDyxsl(list.stream().map(item -> item.getDyxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setDyxssr(list.stream().map(item -> item.getDyxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setLjxsl(list.stream().map(item -> item.getLjxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setLjxssr(list.stream().map(item -> item.getLjxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setQnljxsl(list.stream().map(item -> item.getQnljxsl()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setQnljxssr(list.stream().map(item -> item.getQnljxssr()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); vo.setTqbxsl(vo.getLjxsl().subtract(vo.getQnljxsl())); vo.setTqbxssr(vo.getLjxssr().subtract(vo.getQnljxssr())); baseMapper.insert(vo); } } return R.ok(); } }