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.*;
|
import com.by4cloud.platformx.business.service.ZbStatisticCpXssrService;
|
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:31:01
|
*/
|
@Service
|
@RequiredArgsConstructor
|
public class ZbStatisticCpXssrServiceImpl extends ServiceImpl<ZbStatisticCpXssrMapper, ZbStatisticCpXssr> implements ZbStatisticCpXssrService {
|
|
private final ContractMapper contractMapper;
|
private final ContractOutBoundMapper contractOutBoundMapper;
|
private final BipDictMapper bipDictMapper;
|
|
@Override
|
public R genCpxssrwcqk(ZBJTStatisticDTO queryDTO) {
|
if (StrUtil.isBlank(queryDTO.getYearMonth())) {
|
queryDTO.setYearMonth(DateUtil.format(new Date(), DatePattern.NORM_MONTH_PATTERN));
|
}
|
List<ZbStatisticCpXssr> 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<CpxssrwcqkItemVo> itemVoListDY = contractOutBoundMapper.cpxssrwcqk(monstart,monend);
|
List<CpxssrwcqkItemVo> itemVoListLJ = contractOutBoundMapper.cpxssrwcqk(yearstart,yearend);
|
List<CpxssrwcqkItemVo> itemVoListQN = contractOutBoundMapper.cpxssrwcqk(yearstartLastYear,yearendLastYear);
|
List<Integer> indexList = new ArrayList<>();
|
if (CollUtil.isNotEmpty(itemVoListDY)){
|
for (int i = 0; i < itemVoListDY.size(); i++) {
|
CpxssrwcqkItemVo item = itemVoListDY.get(i);
|
ZbStatisticCpXssr vo = new ZbStatisticCpXssr();
|
vo.setXm(item.getXm());
|
vo.setStatYm(queryDTO.getYearMonth());
|
vo.setSort(i);
|
BipDict dict = bipDictMapper.selectOne(Wrappers.<BipDict>lambdaQuery().eq(BipDict::getDictKey,"zb-cpmc")
|
.eq(BipDict::getParentId,0).eq(BipDict::getDictName,item.getXm()).last("limit 1"));
|
ZbStatisticCpXssr vo1 = baseMapper.selectOne(Wrappers.<ZbStatisticCpXssr>lambdaQuery().eq(ZbStatisticCpXssr::getXm,vo.getXm())
|
.eq(ZbStatisticCpXssr::getStatYm,vo.getStatYm()).last("limit 1"));
|
if (ObjUtil.isNull(dict)) {
|
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(list.size());
|
for (int i = 0; i < indexList.size()-1; i++) {
|
List<ZbStatisticCpXssr> sublist = list.subList(indexList.get(i),indexList.get(i+1));
|
ZbStatisticCpXssr vo = baseMapper.selectOne(Wrappers.<ZbStatisticCpXssr>lambdaQuery().eq(ZbStatisticCpXssr::getXm,list.get(indexList.get(i)).getXm())
|
.eq(ZbStatisticCpXssr::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);
|
}
|
}
|
ZbStatisticCpXssr vo = baseMapper.selectOne(Wrappers.<ZbStatisticCpXssr>lambdaQuery().eq(ZbStatisticCpXssr::getXm,"合计")
|
.eq(ZbStatisticCpXssr::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 ZbStatisticCpXssr();
|
vo.setXm("合计");
|
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()));
|
vo.setSort(64);
|
baseMapper.insert(vo);
|
}
|
return R.ok();
|
}
|
}
|