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<ZbStatisticZxywMapper, ZbStatisticZxyw> 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<PjdxcksxywwcqkVo> 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<GcpbkwcqkItemVo> itemVoListMon = contractInvoiceMapper.pjsxywwcqk("1", monstart, monend);
|
List<GcpbkwcqkItemVo> 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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListYear = contractInvoiceMapper.pjsxywwcqk("1", yearstart, yearend);
|
// List<GcpbkwcqkItemVo> itemVoListYearLastYear = contractInvoiceMapper.pjsxywwcqk("1", yearstartLastYear, yearendLastYear);
|
// if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYear)) {
|
// for (GcpbkwcqkItemVo itemVo : itemVoListYear
|
// ) {
|
// ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListMonHT = contractMapper.pjsxywwcqkHT("1", monstart, monend);
|
List<GcpbkwcqkItemVo> 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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListYearHT = contractMapper.pjsxywwcqkHT("1", yearstart, yearend);
|
// List<GcpbkwcqkItemVo> itemVoListYearHTLastYear = contractMapper.pjsxywwcqkHT("1", yearstartLastYear, yearendLastYear);
|
// if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYearHT)) {
|
//
|
// for (GcpbkwcqkItemVo itemVo : itemVoListYearHT
|
// ) {
|
// ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListMon = contractInvoiceMapper.dxsxywwcqk("2", monstart, monend);
|
List<GcpbkwcqkItemVo> 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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListYear = contractInvoiceMapper.dxsxywwcqk("2", yearstart, yearend);
|
// List<GcpbkwcqkItemVo> itemVoListYearLastYear = contractInvoiceMapper.dxsxywwcqk("2", yearstartLastYear, yearendLastYear);
|
// if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYear)) {
|
//
|
// for (GcpbkwcqkItemVo itemVo : itemVoListYear
|
// ) {
|
// ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListMonHT = contractMapper.dxsxywwcqkHT("2", monstart, monend);
|
List<GcpbkwcqkItemVo> 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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListYearHT = contractMapper.dxsxywwcqkHT("2", yearstart, yearend);
|
// List<GcpbkwcqkItemVo> itemVoListYearHTLastYear = contractMapper.dxsxywwcqkHT("2", yearstartLastYear, yearendLastYear);
|
// if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYearHT)) {
|
//
|
// for (GcpbkwcqkItemVo itemVo : itemVoListYearHT
|
// ) {
|
// ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListMon = contractInvoiceMapper.cksxywwcqk("1", monstart, monend);
|
List<GcpbkwcqkItemVo> 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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListYear = contractInvoiceMapper.cksxywwcqk("1", yearstart, yearend);
|
// List<GcpbkwcqkItemVo> itemVoListYearLastYear = contractInvoiceMapper.cksxywwcqk("1", yearstartLastYear, yearendLastYear);
|
// if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYear)) {
|
//
|
// for (GcpbkwcqkItemVo itemVo : itemVoListYear
|
// ) {
|
// ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListMonHT = contractMapper.cksxywwcqkHT("1", monstart, monend);
|
List<GcpbkwcqkItemVo> 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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<GcpbkwcqkItemVo> itemVoListYearHT = contractMapper.cksxywwcqkHT("1", yearstart, yearend);
|
// List<GcpbkwcqkItemVo> itemVoListYearHTLastYear = contractMapper.cksxywwcqkHT("1", yearstartLastYear, yearendLastYear);
|
// if (CollUtil.isNotEmpty(list) && CollUtil.isNotEmpty(itemVoListYearHT)) {
|
//
|
// for (GcpbkwcqkItemVo itemVo : itemVoListYearHT
|
// ) {
|
// ZbStatisticZxyw vo = baseMapper.selectOne(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<ZbStatisticZxyw> htList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>lambdaQuery()
|
.eq(ZbStatisticZxyw::getLb, "新增合同")
|
.eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm()));
|
List<ZbStatisticZxyw> htqndyList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>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<ZbStatisticZxyw> srList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>lambdaQuery()
|
.eq(ZbStatisticZxyw::getLb, "销售收入")
|
.eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm()));
|
List<ZbStatisticZxyw> srqndyList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<ZbStatisticZxyw> htList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>lambdaQuery()
|
.eq(ZbStatisticZxyw::getLb, "新增合同")
|
.eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm()));
|
List<ZbStatisticZxyw> htqndyList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>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<ZbStatisticZxyw> srList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>lambdaQuery()
|
.eq(ZbStatisticZxyw::getLb, "销售收入")
|
.eq(ZbStatisticZxyw::getStatYm, vosmj.getStatYm()));
|
List<ZbStatisticZxyw> srqndyList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<ZbStatisticZxyw> srList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>lambdaQuery()
|
.eq(ZbStatisticZxyw::getLb, "销售收入")
|
.eq(ZbStatisticZxyw::getStatYm, vosxsr.getStatYm()));
|
List<ZbStatisticZxyw> srqndyList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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<ZbStatisticZxyw> srhtList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>lambdaQuery()
|
.eq(ZbStatisticZxyw::getLb, "销售收入")
|
.eq(ZbStatisticZxyw::getStatYm, vosxht.getStatYm()));
|
List<ZbStatisticZxyw> srqndyhtList = baseMapper.selectList(Wrappers.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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.<ZbStatisticZxyw>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();
|
}
|
}
|