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.ZbStatisticZdgz; import com.by4cloud.platformx.business.entity.ZbStatisticZxyw; import com.by4cloud.platformx.business.mapper.ContractInvoiceMapper; import com.by4cloud.platformx.business.mapper.ContractMapper; import com.by4cloud.platformx.business.mapper.ZbStatisticZxywMapper; import com.by4cloud.platformx.business.service.ZbStatisticZxywService; import com.by4cloud.platformx.business.vo.GcpbkwcqkItemVo; import com.by4cloud.platformx.business.vo.PjdxcksxywwcqkVo; import com.by4cloud.platformx.common.core.util.R; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; import java.math.BigDecimal; import java.math.RoundingMode; import java.time.YearMonth; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Objects; import java.util.stream.Collectors; /** * 专项业务 * * @author syt * @date 2026-11-12 10:29:31 */ @Service @RequiredArgsConstructor public class ZbStatisticZxywServiceImpl extends ServiceImpl implements ZbStatisticZxywService { private final ContractInvoiceMapper contractInvoiceMapper; private final ContractMapper contractMapper; @Override public R genZxywwcqk(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); String curYear = queryDTO.getYearMonth().substring(0, 4); String curMonth = queryDTO.getYearMonth().substring(5); YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1); YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1); if (true) { //配件开票 List itemVoListMon = contractInvoiceMapper.pjsxywwcqk("1", monstart, monend); List itemVoListMonrLastYear = contractInvoiceMapper.pjsxywwcqk("1", monstartLastYear, monstartLastYear); if (CollUtil.isNotEmpty(itemVoListMon)) { itemVoListMon.stream().forEach(item -> { ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(item.getYw()); vo.setLb(item.getLb()); vo.setDw(item.getDw()); vo.setDywc(item.getWc()); if (StrUtil.equals(item.getDw(), "石煤机")) { vo.setCompId(2089995177814495234L); } if (StrUtil.equals(item.getDw(), "石工泵")) { vo.setCompId(2056556196124250113L); } if (StrUtil.equals(item.getDw(), "通方厂")) { vo.setCompId(2056556317461270529L); } if (StrUtil.equals(item.getDw(), "邢台厂")) { vo.setCompId(2056556421857497090L); } vo.setStatYm(queryDTO.getYearMonth()); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc());//去年同月 vo.setQntq(voQndy.getLjwc());//去年同期 vo.setYtb(vo.getDywc().subtract(vo.getQnty()));//当月同比 if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%");//当月同期比 } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc()));//累计完成 vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq()));//累计同比 if (ObjUtil.isNotNull(vo.getQntq()) && ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%");//累计同期比 } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } }); ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(itemVoListMon.get(0).getYw()); vo.setLb(itemVoListMon.get(0).getLb()); vo.setDw("集团"); vo.setStatYm(queryDTO.getYearMonth()); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); vo.setDywc(itemVoListMon.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } } // List itemVoListYear = contractInvoiceMapper.pjsxywwcqk("1", yearstart, yearend); // List itemVoListYearLastYear = contractInvoiceMapper.pjsxywwcqk("1", yearstartLastYear, yearendLastYear); // if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYear)) { // for (GcpbkwcqkItemVo itemVo : itemVoListYear // ) { // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, itemVo.getYw()) // .eq(ZbStatisticZxyw::getLb, itemVo.getLb()).eq(ZbStatisticZxyw::getDw, itemVo.getDw()) // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw())) { // vo.setLjwc(itemVo.getWc()); // } // if (CollUtil.isNotEmpty(itemVoListYearLastYear)) { // itemVoListYearLastYear.stream().forEach(item1 -> { // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw()) && item1.getWc().compareTo(new BigDecimal("0")) > 0) { // vo.setQntq(item1.getWc()); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // } // }); // } // baseMapper.updateById(vo); // } // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, "配件") // .eq(ZbStatisticZxyw::getLb, "销售收入").eq(ZbStatisticZxyw::getDw, "集团") // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // vo.setLjwc(itemVoListYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // if (CollUtil.isNotEmpty(itemVoListYearLastYear)) { // vo.setQntq(itemVoListYearLastYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // } // baseMapper.updateById(vo); // } //配件合同 List itemVoListMonHT = contractMapper.pjsxywwcqkHT("1", monstart, monend); List itemVoListMonrHTLastYear = contractMapper.pjsxywwcqkHT("1", monstartLastYear, monstartLastYear); if (CollUtil.isNotEmpty(itemVoListMonHT)) { itemVoListMonHT.stream().forEach(item -> { ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(item.getYw()); vo.setLb(item.getLb()); vo.setDw(item.getDw()); vo.setDywc(item.getWc()); vo.setStatYm(queryDTO.getYearMonth()); Long compId = null; if (StrUtil.equals(item.getDw(), "石煤机")) { compId = 2089995177814495234L; vo.setCompId(2089995177814495234L); } if (StrUtil.equals(item.getDw(), "石工泵")) { compId = 2056556196124250113L; vo.setCompId(2056556196124250113L); } if (StrUtil.equals(item.getDw(), "通方厂")) { compId = 2056556317461270529L; vo.setCompId(2056556317461270529L); } if (StrUtil.equals(item.getDw(), "邢台厂")) { compId = 2056556421857497090L; vo.setCompId(2056556421857497090L); } ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } }); ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(itemVoListMonHT.get(0).getYw()); vo.setLb(itemVoListMonHT.get(0).getLb()); vo.setDw("集团"); vo.setStatYm(queryDTO.getYearMonth()); vo.setDywc(itemVoListMonHT.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } } // List itemVoListYearHT = contractMapper.pjsxywwcqkHT("1", yearstart, yearend); // List itemVoListYearHTLastYear = contractMapper.pjsxywwcqkHT("1", yearstartLastYear, yearendLastYear); // if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYearHT)) { // // for (GcpbkwcqkItemVo itemVo : itemVoListYearHT // ) { // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, itemVo.getYw()) // .eq(ZbStatisticZxyw::getLb, itemVo.getLb()).eq(ZbStatisticZxyw::getDw, itemVo.getDw()) // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw())) { // vo.setLjwc(itemVo.getWc()); // } // if (CollUtil.isNotEmpty(itemVoListYearHTLastYear)) { // itemVoListYearHTLastYear.stream().forEach(item1 -> { // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw()) && item1.getWc().compareTo(new BigDecimal("0")) > 0) { // vo.setQntq(item1.getWc()); // vo.setLjtb(vo.getLjwc().subtract(item1.getWc())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // } // }); // } // // baseMapper.updateById(vo); // } // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, "配件") // .eq(ZbStatisticZxyw::getLb, "新增合同").eq(ZbStatisticZxyw::getDw, "集团") // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // vo.setLjwc(itemVoListYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // if (CollUtil.isNotEmpty(itemVoListYearHTLastYear)) { // vo.setQntq(itemVoListYearHTLastYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // // } // baseMapper.updateById(vo); // } } if (true) { //大修开票 List itemVoListMon = contractInvoiceMapper.dxsxywwcqk("2", monstart, monend); List itemVoListMonrLastYear = contractInvoiceMapper.dxsxywwcqk("2", monstartLastYear, monendLastYear); if (CollUtil.isNotEmpty(itemVoListMon)) { itemVoListMon.stream().forEach(item -> { ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(item.getYw()); vo.setLb(item.getLb()); vo.setDw(item.getDw()); vo.setDywc(item.getWc()); vo.setStatYm(queryDTO.getYearMonth()); Long compId = null; if (StrUtil.equals(item.getDw(), "石煤机")) { compId = 2089995177814495234L; vo.setCompId(2089995177814495234L); } if (StrUtil.equals(item.getDw(), "石工泵")) { compId = 2056556196124250113L; vo.setCompId(2056556196124250113L); } if (StrUtil.equals(item.getDw(), "通方厂")) { compId = 2056556317461270529L; vo.setCompId(2056556317461270529L); } if (StrUtil.equals(item.getDw(), "邢台厂")) { compId = 2056556421857497090L; vo.setCompId(2056556421857497090L); } ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } }); ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(itemVoListMon.get(0).getYw()); vo.setLb(itemVoListMon.get(0).getLb()); vo.setDw("集团"); vo.setStatYm(queryDTO.getYearMonth()); vo.setDywc(itemVoListMon.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } } // List itemVoListYear = contractInvoiceMapper.dxsxywwcqk("2", yearstart, yearend); // List itemVoListYearLastYear = contractInvoiceMapper.dxsxywwcqk("2", yearstartLastYear, yearendLastYear); // if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYear)) { // // for (GcpbkwcqkItemVo itemVo : itemVoListYear // ) { // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, itemVo.getYw()) // .eq(ZbStatisticZxyw::getLb, itemVo.getLb()).eq(ZbStatisticZxyw::getDw, itemVo.getDw()) // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw())) { // vo.setLjwc(itemVo.getWc()); // } // if (CollUtil.isNotEmpty(itemVoListYearLastYear)) { // itemVoListYearLastYear.stream().forEach(item1 -> { // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw()) && item1.getWc().compareTo(new BigDecimal("0")) > 0) { // vo.setQntq(item1.getWc()); // vo.setLjtb(vo.getLjwc().subtract(item1.getWc())); // if (vo.getQnwc().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getYtb().divide(vo.getQnwc(), 2, RoundingMode.HALF_UP) + "%"); // } // } // }); // } // baseMapper.updateById(vo); // } // // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, "大修") // .eq(ZbStatisticZxyw::getLb, "销售收入").eq(ZbStatisticZxyw::getDw, "集团") // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // vo.setLjwc(itemVoListYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // if (CollUtil.isNotEmpty(itemVoListYearLastYear)) { // vo.setQntq(itemVoListYearLastYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // // } // baseMapper.updateById(vo); // } //大修合同 List itemVoListMonHT = contractMapper.dxsxywwcqkHT("2", monstart, monend); List itemVoListMonrHTLastYear = contractMapper.dxsxywwcqkHT("2", monstartLastYear, monendLastYear); if (CollUtil.isNotEmpty(itemVoListMonHT)) { itemVoListMonHT.stream().forEach(item -> { ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(item.getYw()); vo.setLb(item.getLb()); vo.setDw(item.getDw()); vo.setDywc(item.getWc()); vo.setStatYm(queryDTO.getYearMonth()); Long compId = null; if (StrUtil.equals(item.getDw(), "石煤机")) { compId = 2089995177814495234L; vo.setCompId(2089995177814495234L); } if (StrUtil.equals(item.getDw(), "石工泵")) { compId = 2056556196124250113L; vo.setCompId(2056556196124250113L); } if (StrUtil.equals(item.getDw(), "通方厂")) { compId = 2056556317461270529L; vo.setCompId(2056556317461270529L); } if (StrUtil.equals(item.getDw(), "邢台厂")) { compId = 2056556421857497090L; vo.setCompId(2056556421857497090L); } ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } }); ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(itemVoListMonHT.get(0).getYw()); vo.setLb(itemVoListMonHT.get(0).getLb()); vo.setDw("集团"); vo.setStatYm(queryDTO.getYearMonth()); vo.setDywc(itemVoListMonHT.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } } // List itemVoListYearHT = contractMapper.dxsxywwcqkHT("2", yearstart, yearend); // List itemVoListYearHTLastYear = contractMapper.dxsxywwcqkHT("2", yearstartLastYear, yearendLastYear); // if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYearHT)) { // // for (GcpbkwcqkItemVo itemVo : itemVoListYearHT // ) { // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, itemVo.getYw()) // .eq(ZbStatisticZxyw::getLb, itemVo.getLb()).eq(ZbStatisticZxyw::getDw, itemVo.getDw()) // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw())) { // vo.setLjwc(itemVo.getWc()); // } // if (CollUtil.isNotEmpty(itemVoListYearHTLastYear)) { // itemVoListYearHTLastYear.stream().forEach(item1 -> { // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw()) && item1.getWc().compareTo(new BigDecimal("0")) > 0) { // vo.setQntq(item1.getWc()); // vo.setLjtb(vo.getLjwc().subtract(item1.getWc())); // if (vo.getQnwc().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getYtb().divide(vo.getQnwc(), 2, RoundingMode.HALF_UP) + "%"); // } // } // }); // } // baseMapper.updateById(vo); // } // // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, "大修") // .eq(ZbStatisticZxyw::getLb, "新增合同").eq(ZbStatisticZxyw::getDw, "集团") // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // vo.setLjwc(itemVoListYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // if (CollUtil.isNotEmpty(itemVoListYearHTLastYear)) { // vo.setQntq(itemVoListYearHTLastYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // } // baseMapper.updateById(vo); // } } if (true) { //出口开票 List itemVoListMon = contractInvoiceMapper.cksxywwcqk("1", monstart, monend); List itemVoListMonrLastYear = contractInvoiceMapper.cksxywwcqk("1", monstartLastYear, monendLastYear); if (CollUtil.isNotEmpty(itemVoListMon)) { itemVoListMon.stream().forEach(item -> { ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(item.getYw()); vo.setLb(item.getLb()); vo.setDw(item.getDw()); vo.setDywc(item.getWc()); vo.setStatYm(queryDTO.getYearMonth()); Long compId = null; if (StrUtil.equals(item.getDw(), "石煤机")) { compId = 2089995177814495234L; vo.setCompId(2089995177814495234L); } if (StrUtil.equals(item.getDw(), "石工泵")) { compId = 2056556196124250113L; vo.setCompId(2056556196124250113L); } if (StrUtil.equals(item.getDw(), "通方厂")) { compId = 2056556317461270529L; vo.setCompId(2056556317461270529L); } if (StrUtil.equals(item.getDw(), "邢台厂")) { compId = 2056556421857497090L; vo.setCompId(2056556421857497090L); } ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } }); ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(itemVoListMon.get(0).getYw()); vo.setLb(itemVoListMon.get(0).getLb()); vo.setDw("集团"); vo.setStatYm(queryDTO.getYearMonth()); vo.setDywc(itemVoListMon.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } } // List itemVoListYear = contractInvoiceMapper.cksxywwcqk("1", yearstart, yearend); // List itemVoListYearLastYear = contractInvoiceMapper.cksxywwcqk("1", yearstartLastYear, yearendLastYear); // if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYear)) { // // for (GcpbkwcqkItemVo itemVo : itemVoListYear // ) { // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, itemVo.getYw()) // .eq(ZbStatisticZxyw::getLb, itemVo.getLb()).eq(ZbStatisticZxyw::getDw, itemVo.getDw()) // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw())) { // vo.setLjwc(itemVo.getWc()); // } // if (CollUtil.isNotEmpty(itemVoListYearLastYear)) { // itemVoListYearLastYear.stream().forEach(item1 -> { // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw()) && item1.getWc().compareTo(new BigDecimal("0")) > 0) { // vo.setQntq(item1.getWc()); // vo.setLjtb(vo.getLjwc().subtract(item1.getWc())); // if (vo.getQnwc().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getYtb().divide(vo.getQnwc(), 2, RoundingMode.HALF_UP) + "%"); // } // } // }); // } // baseMapper.updateById(vo); // } // // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, "出口") // .eq(ZbStatisticZxyw::getLb, "销售收入").eq(ZbStatisticZxyw::getDw, "集团") // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // vo.setLjwc(itemVoListYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // if (CollUtil.isNotEmpty(itemVoListYearLastYear)) { // vo.setQntq(itemVoListYearLastYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // } // baseMapper.updateById(vo); // } //配件合同 List itemVoListMonHT = contractMapper.cksxywwcqkHT("1", monstart, monend); List itemVoListMonrHTLastYear = contractMapper.cksxywwcqkHT("1", monstartLastYear, monendLastYear); if (CollUtil.isNotEmpty(itemVoListMonHT)) { itemVoListMonHT.stream().forEach(item -> { ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(item.getYw()); vo.setLb(item.getLb()); vo.setDw(item.getDw()); vo.setDywc(item.getWc()); vo.setStatYm(queryDTO.getYearMonth()); Long compId = null; if (StrUtil.equals(item.getDw(), "石煤机")) { compId = 2089995177814495234L; vo.setCompId(2089995177814495234L); } if (StrUtil.equals(item.getDw(), "石工泵")) { compId = 2056556196124250113L; vo.setCompId(2056556196124250113L); } if (StrUtil.equals(item.getDw(), "通方厂")) { compId = 2056556317461270529L; vo.setCompId(2056556317461270529L); } if (StrUtil.equals(item.getDw(), "邢台厂")) { compId = 2056556421857497090L; vo.setCompId(2056556421857497090L); } ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } }); ZbStatisticZxyw vo = new ZbStatisticZxyw(); vo.setYw(itemVoListMonHT.get(0).getYw()); vo.setLb(itemVoListMonHT.get(0).getLb()); vo.setDw("集团"); vo.setStatYm(queryDTO.getYearMonth()); vo.setDywc(itemVoListMonHT.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, vo.getStatYm()).last("limit 1")); ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vo.getYw()) .eq(ZbStatisticZxyw::getLb, vo.getLb()).eq(ZbStatisticZxyw::getDw, vo.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo.setQnty(voQndy.getDywc()); vo.setQntq(voQndy.getLjwc()); vo.setYtb(vo.getDywc().subtract(vo.getQnty())); if (vo.getQnty().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getYtb().divide(vo.getQnty(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setYtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(voSy)) { vo.setLjwc(voSy.getLjwc().add(ObjUtil.isNull(vo.getDywc()) ? BigDecimal.ZERO : vo.getDywc())); vo.setLjtb(vo.getLjwc().subtract(ObjUtil.isNull(vo.getQntq()) ? BigDecimal.ZERO : vo.getQntq())); if (ObjUtil.isNotNull(vo.getQntq()) && vo.getQntq().compareTo(new BigDecimal("0")) > 0) { BigDecimal percent = vo.getLjtb().divide(vo.getQntq(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal(100)); vo.setLjtqb(percent.setScale(2, RoundingMode.HALF_UP) + "%"); } } if (ObjUtil.isNotNull(vo1)) { vo.setId(vo1.getId()); baseMapper.updateById(vo); } else { baseMapper.insert(vo); } } // List itemVoListYearHT = contractMapper.cksxywwcqkHT("1", yearstart, yearend); // List itemVoListYearHTLastYear = contractMapper.cksxywwcqkHT("1", yearstartLastYear, yearendLastYear); // if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYearHT)) { // // for (GcpbkwcqkItemVo itemVo : itemVoListYearHT // ) { // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, itemVo.getYw()) // .eq(ZbStatisticZxyw::getLb, itemVo.getLb()).eq(ZbStatisticZxyw::getDw, itemVo.getDw()) // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw())) { // vo.setLjwc(itemVo.getWc()); // } // if (CollUtil.isNotEmpty(itemVoListYearHTLastYear)) { // itemVoListYearHTLastYear.stream().forEach(item1 -> { // if (StrUtil.equals(vo.getYw(), itemVo.getYw()) && StrUtil.equals(vo.getLb(), itemVo.getLb()) && // StrUtil.equals(vo.getDw(), itemVo.getDw()) && item1.getWc().compareTo(new BigDecimal("0")) > 0) { // vo.setQntq(item1.getWc()); // vo.setLjtb(vo.getLjwc().subtract(item1.getWc())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // } // }); // } // baseMapper.updateById(vo); // } // // ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, "出口") // .eq(ZbStatisticZxyw::getLb, "新增合同").eq(ZbStatisticZxyw::getDw, "集团") // .eq(ZbStatisticZxyw::getStatYm, queryDTO.getYearMonth()).last("limit 1")); // vo.setLjwc(itemVoListYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // if (CollUtil.isNotEmpty(itemVoListYearHTLastYear)) { // vo.setQntq(itemVoListYearHTLastYear.stream().map(GcpbkwcqkItemVo::getWc).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); // vo.setLjtb(vo.getLjwc().subtract(vo.getQntq())); // if (ObjUtil.isNotNull(vo.getQntq())&&vo.getQntq().compareTo(new BigDecimal("0")) > 0) { // vo.setLjtqb(vo.getLjtb().divide(vo.getQntq(), 2, RoundingMode.HALF_UP) + "%"); // } // // } // baseMapper.updateById(vo); // } } String[] arrLb = {"销售收入", "新增合同"}; String[] arrDw = {"石煤机", "石工泵", "邢台厂", "通方厂"}; for (int i = 0; i < arrLb.length; i++) { for (int j = 0; j < arrDw.length; j++) { ZbStatisticZxyw vosmj = new ZbStatisticZxyw(); vosmj.setYw("以上三项合计"); String lb = arrLb[i]; String dw = arrDw[j]; vosmj.setLb(lb); vosmj.setDw(dw); vosmj.setStatYm(queryDTO.getYearMonth()); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosmj.getYw()) .eq(ZbStatisticZxyw::getLb, vosmj.getLb()).eq(ZbStatisticZxyw::getDw, vosmj.getDw()) .eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm()).last("limit 1")); if (ObjUtil.isNotNull(vo1)) { if (StrUtil.equals(vosmj.getLb(), "新增合同")) { List htList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "新增合同") .eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm())); List htqndyList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "新增合同") .eq(ZbStatisticZxyw::getStatYm, qndy)); if (CollUtil.isNotEmpty(htList)) { vo1.setDywc(htList.stream().map(item -> item.getDywc()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vo1.setDywc(BigDecimal.ZERO); } if (CollUtil.isNotEmpty(htqndyList)) { vo1.setQnty(htqndyList.stream().map(item -> item.getQnty()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vo1.setQnty(BigDecimal.ZERO); } } if (StrUtil.equals(vosmj.getLb(), "销售收入")) { List srList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm())); List srqndyList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, qndy)); if (CollUtil.isNotEmpty(srList)) { vo1.setDywc(srList.stream().map(item -> item.getDywc()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vo1.setDywc(BigDecimal.ZERO); } if (CollUtil.isNotEmpty(srqndyList)) { vo1.setQnty(srqndyList.stream().map(item -> item.getQnty()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vo1.setQnty(BigDecimal.ZERO); } } ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosmj.getYw()) .eq(ZbStatisticZxyw::getLb, vosmj.getLb()).eq(ZbStatisticZxyw::getDw, vosmj.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voSy)) { vo1.setLjwc(voSy.getLjwc().add(vo1.getDywc())); } else { vo1.setLjwc(vo1.getDywc()); } ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosmj.getYw()) .eq(ZbStatisticZxyw::getLb, vosmj.getLb()).eq(ZbStatisticZxyw::getDw, vosmj.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vo1.setQntq(voQndy.getLjwc()); } else { vo1.setQntq(BigDecimal.ZERO); } vo1.setYtb(vo1.getDywc().subtract(vo1.getQnty())); if (vo1.getQnty().compareTo(new BigDecimal("0")) > 0) { vo1.setYtqb(vo1.getYtb().divide(vo1.getQnty(), 2, RoundingMode.HALF_UP) + "%"); } vo1.setLjtb(vo1.getLjwc().subtract(vo1.getQntq())); if (vo1.getQntq().compareTo(new BigDecimal("0")) > 0) { vo1.setLjtqb(vo1.getLjtb().divide(vo1.getQntq(), 2, RoundingMode.HALF_UP) + "%"); } baseMapper.updateById(vo1); } else { if (StrUtil.equals(vosmj.getLb(), "新增合同")) { List htList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "新增合同") .eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm())); List htqndyList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "新增合同") .eq(ZbStatisticZxyw::getStatYm, qndy)); if (CollUtil.isNotEmpty(htList)) { vosmj.setDywc(htList.stream().map(item -> item.getDywc()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosmj.setDywc(BigDecimal.ZERO); } if (CollUtil.isNotEmpty(htqndyList)) { vosmj.setQnty(htqndyList.stream().map(item -> item.getQnty()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosmj.setQnty(BigDecimal.ZERO); } } if (StrUtil.equals(vosmj.getLb(), "销售收入")) { List srList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm())); List srqndyList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, qndy)); if (CollUtil.isNotEmpty(srList)) { vosmj.setDywc(srList.stream().map(item -> item.getDywc()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosmj.setDywc(BigDecimal.ZERO); } if (CollUtil.isNotEmpty(srqndyList)) { vosmj.setQnty(srqndyList.stream().map(item -> item.getQnty()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosmj.setQnty(BigDecimal.ZERO); } } ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosmj.getYw()) .eq(ZbStatisticZxyw::getLb, vosmj.getLb()).eq(ZbStatisticZxyw::getDw, vosmj.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voSy)) { vosmj.setLjwc(voSy.getLjwc().add(vosmj.getDywc())); } else { vosmj.setLjwc(vosmj.getDywc()); } ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosmj.getYw()) .eq(ZbStatisticZxyw::getLb, vosmj.getLb()).eq(ZbStatisticZxyw::getDw, vosmj.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vosmj.setQntq(voQndy.getLjwc()); } else { vosmj.setQntq(BigDecimal.ZERO); } vosmj.setYtb(vosmj.getDywc().subtract(vosmj.getQnty())); if (vosmj.getQnty().compareTo(new BigDecimal("0")) > 0) { vosmj.setYtqb(vosmj.getYtb().divide(vosmj.getQnty(), 2, RoundingMode.HALF_UP) + "%"); } vosmj.setLjtb(vosmj.getLjwc().subtract(vosmj.getQntq())); if (vosmj.getQntq().compareTo(new BigDecimal("0")) > 0) { vosmj.setLjtqb(vosmj.getLjtb().divide(vosmj.getQntq(), 2, RoundingMode.HALF_UP) + "%"); } baseMapper.insert(vosmj); } } } ZbStatisticZxyw vosxsr = new ZbStatisticZxyw(); vosxsr.setYw("以上三项合计"); vosxsr.setLb("销售收入"); vosxsr.setDw("装备"); vosxsr.setStatYm(queryDTO.getYearMonth()); ZbStatisticZxyw vo1 = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosxsr.getYw()) .eq(ZbStatisticZxyw::getLb, vosxsr.getLb()).eq(ZbStatisticZxyw::getDw, vosxsr.getDw()) .eq(ZbStatisticZxyw::getStatYm, vosxsr.getStatYm()).last("limit 1")); List srList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, vosxsr.getStatYm())); List srqndyList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, qndy)); if (CollUtil.isNotEmpty(srList)) { vosxsr.setDywc(srList.stream().map(item -> item.getDywc()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosxsr.setDywc(BigDecimal.ZERO); } if (CollUtil.isNotEmpty(srqndyList)) { vosxsr.setQnty(srqndyList.stream().map(item -> item.getQnty()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosxsr.setQnty(BigDecimal.ZERO); } ZbStatisticZxyw voSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosxsr.getYw()) .eq(ZbStatisticZxyw::getLb, vosxsr.getLb()).eq(ZbStatisticZxyw::getDw, vosxsr.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(voSy)) { vosxsr.setLjwc(voSy.getLjwc().add(vosxsr.getDywc())); } else { vosxsr.setLjwc(vosxsr.getDywc()); } ZbStatisticZxyw voQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosxsr.getYw()) .eq(ZbStatisticZxyw::getLb, vosxsr.getLb()).eq(ZbStatisticZxyw::getDw, vosxsr.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); if (ObjUtil.isNotNull(voQndy)) { vosxsr.setQntq(voQndy.getLjwc()); } else { vosxsr.setQntq(BigDecimal.ZERO); } vosxsr.setYtb(vosxsr.getDywc().subtract(vosxsr.getQnty())); if (vosxsr.getQnty().compareTo(new BigDecimal("0")) > 0) { vosxsr.setYtqb(vosxsr.getYtb().divide(vosxsr.getQnty(), 2, RoundingMode.HALF_UP) + "%"); } vosxsr.setLjtb(vosxsr.getLjwc().subtract(vosxsr.getQntq())); if (vosxsr.getQntq().compareTo(new BigDecimal("0")) > 0) { vosxsr.setLjtqb(vosxsr.getLjtb().divide(vosxsr.getQntq(), 2, RoundingMode.HALF_UP) + "%"); } if (ObjUtil.isNotNull(vo1)) { vosxsr.setId(vo1.getId()); baseMapper.updateById(vosxsr); } else { baseMapper.insert(vosxsr); } ZbStatisticZxyw vosxht = new ZbStatisticZxyw(); vosxht.setYw("以上三项合计"); vosxht.setLb("新增合同"); vosxht.setDw("装备"); vosxht.setStatYm(queryDTO.getYearMonth()); ZbStatisticZxyw voht = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosxht.getYw()) .eq(ZbStatisticZxyw::getLb, vosxht.getLb()).eq(ZbStatisticZxyw::getDw, vosxht.getDw()) .eq(ZbStatisticZxyw::getStatYm, vosxht.getStatYm()).last("limit 1")); List srhtList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, vosxht.getStatYm())); List srqndyhtList = baseMapper.selectList(Wrappers.lambdaQuery() .eq(ZbStatisticZxyw::getLb, "销售收入") .eq(ZbStatisticZxyw::getStatYm, qndy)); if (CollUtil.isNotEmpty(srhtList)) { vosxht.setDywc(srhtList.stream().map(item -> item.getDywc()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosxht.setDywc(BigDecimal.ZERO); } if (CollUtil.isNotEmpty(srqndyhtList)) { vosxht.setQnty(srqndyhtList.stream().map(item -> item.getQnty()).filter(Objects::nonNull).reduce(BigDecimal.ZERO, BigDecimal::add)); } else { vosxht.setQnty(BigDecimal.ZERO); } ZbStatisticZxyw vohtSy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosxht.getYw()) .eq(ZbStatisticZxyw::getLb, vosxht.getLb()).eq(ZbStatisticZxyw::getDw, vosxht.getDw()) .eq(ZbStatisticZxyw::getStatYm, sy).last("limit 1")); if (ObjUtil.isNotNull(vohtSy)) { vosxht.setLjwc(vohtSy.getLjwc().add(vosxht.getDywc())); } else { vosxht.setLjwc(vosxht.getDywc()); } ZbStatisticZxyw vohtQndy = baseMapper.selectOne(Wrappers.lambdaQuery().eq(ZbStatisticZxyw::getYw, vosxht.getYw()) .eq(ZbStatisticZxyw::getLb, vosxht.getLb()).eq(ZbStatisticZxyw::getDw, vosxht.getDw()) .eq(ZbStatisticZxyw::getStatYm, qndy).last("limit 1")); if (ObjUtil.isNotNull(vohtQndy)) { vosxht.setQntq(vohtQndy.getLjwc()); } else { vosxht.setQntq(BigDecimal.ZERO); } vosxht.setYtb(vosxht.getDywc().subtract(vosxht.getQnty())); if (vosxht.getQnty().compareTo(new BigDecimal("0")) > 0) { vosxht.setYtqb(vosxht.getYtb().divide(vosxht.getQnty(), 2, RoundingMode.HALF_UP) + "%"); } vosxht.setLjtb(vosxht.getLjwc().subtract(vosxht.getQntq())); if (vosxht.getQntq().compareTo(new BigDecimal("0")) > 0) { vosxht.setLjtqb(vosxht.getLjtb().divide(vosxht.getQntq(), 2, RoundingMode.HALF_UP) + "%"); } if (ObjUtil.isNotNull(voht)) { vosxht.setId(voht.getId()); baseMapper.updateById(vosxht); } else { baseMapper.insert(vosxht); } return R.ok(); } }