package com.by4cloud.platformx.business.service.impl;
|
|
import cn.hutool.core.bean.BeanUtil;
|
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.AnnualPlan;
|
import com.by4cloud.platformx.business.entity.ZbStatisticXszb;
|
import com.by4cloud.platformx.business.mapper.*;
|
import com.by4cloud.platformx.business.service.ZbStatisticXszbService;
|
import com.by4cloud.platformx.business.vo.AnnualPlanTotalVo;
|
import com.by4cloud.platformx.business.vo.HomeZbjtVo;
|
import com.by4cloud.platformx.business.vo.ZyxszbwcqkVo;
|
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;
|
|
/**
|
* 销售指标
|
*
|
* @author syt
|
* @date 2026-11-12 10:26:32
|
*/
|
@Service
|
@RequiredArgsConstructor
|
public class ZbStatisticXszbServiceImpl extends ServiceImpl<ZbStatisticXszbMapper, ZbStatisticXszb> implements ZbStatisticXszbService {
|
|
private final PaymentSlipMapper paymentSlipMapper;
|
private final ContractInvoiceMapper contractInvoiceMapper;
|
private final ContractMapper contractMapper;
|
private final AnnualPlanMapper annualPlanMapper;
|
|
@Override
|
public R genZyxszbwcqk(ZBJTStatisticDTO queryDTO) {
|
if (StrUtil.isBlank(queryDTO.getYearMonth())){
|
queryDTO.setYearMonth(DateUtil.format(new Date(), DatePattern.NORM_MONTH_PATTERN));
|
}
|
List<ZyxszbwcqkVo> 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);
|
|
HomeZbjtVo hk = paymentSlipMapper.homeZbjtYearAndMon(monstart,monend,yearstart,yearend,
|
monstartLastYear,monendLastYear,yearstartLastYear,yearendLastYear);
|
handlezBJTVo("货款回收",hk,queryDTO.getYearMonth().substring(0,4), queryDTO.getYearMonth().substring(5), "3");
|
|
HomeZbjtVo kp = contractInvoiceMapper.homeZbjtYearAndMon(monstart,monend,yearstart,yearend);
|
|
handlezBJTVo("销售收入",kp,queryDTO.getYearMonth().substring(0,4), queryDTO.getYearMonth().substring(5), "2");
|
|
HomeZbjtVo htqd = contractMapper.homeZbjtYearAndMon(monstart,monend,yearstart,yearend);
|
|
handlezBJTVo("新增合同",htqd,queryDTO.getYearMonth().substring(0,4), queryDTO.getYearMonth().substring(5), "1");
|
return R.ok();
|
}
|
|
private void handlezBJTVo(String xm, HomeZbjtVo kp,String curYear,String curMonth,String planType) {
|
List<Long> compIds = new ArrayList<>();
|
compIds.add(2089995177814495234L);
|
compIds.add(2089996921978040321L);
|
compIds.add(2089997578009128962L);
|
compIds.add(2101966257365045249L);
|
ZbStatisticXszb xszbSMJ = new ZbStatisticXszb();
|
xszbSMJ.setXm(xm);
|
xszbSMJ.setDw("石煤机");
|
xszbSMJ.setStatYm(curYear+"-"+curMonth);
|
xszbSMJ.setCompId(2089995177814495234L);
|
ZbStatisticXszb xszbSmj = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石煤机").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1"));
|
AnnualPlan planListSMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
.eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
.in(AnnualPlan::getCompId, compIds).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmj)){
|
if (ObjUtil.isNotNull(planListSMJ)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListSMJ, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbSmj.setDyjh(curMonAmount);//当月计划
|
xszbSmj.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbSmj.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbSmj.setDywc(kp.getSmjby());//当月完成
|
if (xszbSmj.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbSmj.setYjhwc(xszbSmj.getDywc().divide(xszbSmj.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石煤机").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbSmj.setYtqb(xszbSmj.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbSmjSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石煤机").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjSy)) {
|
xszbSmj.setLjwc(xszbSmjSy.getLjwc().add(xszbSmj.getDywc()));//累计完成
|
if (xszbSmj.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbSmj.setNjhwc(xszbSmj.getLjwc().divide(xszbSmj.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbSmj.setNtqb(xszbSmj.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.updateById(xszbSmj);
|
}else {
|
if (ObjUtil.isNotNull(planListSMJ)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListSMJ, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbSMJ.setDyjh(curMonAmount);//当月计划
|
xszbSMJ.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbSMJ.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbSMJ.setDywc(kp.getSmjby());//当月完成
|
if (xszbSMJ.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbSMJ.setYjhwc(xszbSMJ.getDywc().divide(xszbSMJ.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石煤机").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbSMJ.setYtqb(xszbSMJ.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbSmjSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石煤机").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjSy)) {
|
xszbSMJ.setLjwc(xszbSmjSy.getLjwc().add(xszbSMJ.getDywc()));//累计完成
|
if (xszbSMJ.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbSMJ.setNjhwc(xszbSMJ.getLjwc().divide(xszbSMJ.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbSMJ.setNtqb(xszbSMJ.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.insert(xszbSMJ);
|
}
|
ZbStatisticXszb xszbSGB = new ZbStatisticXszb();
|
xszbSGB.setXm(xm);
|
xszbSGB.setDw("石工泵");
|
xszbSGB.setStatYm(curYear+"-"+curMonth);
|
xszbSGB.setCompId(2056556196124250113L);
|
ZbStatisticXszb xszbSgb = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石工泵").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1"));
|
AnnualPlan planListSGB = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
.eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
.eq(AnnualPlan::getCompId, 2056556196124250113L).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSgb)){
|
if (ObjUtil.isNotNull(planListSGB)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListSGB, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbSgb.setDyjh(curMonAmount);//当月计划
|
xszbSgb.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbSgb.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbSgb.setDywc(kp.getSmjby());//当月完成
|
if (xszbSgb.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbSgb.setYjhwc(xszbSgb.getDywc().divide(xszbSgb.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石工泵").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbSgb.setYtqb(xszbSgb.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbSgbSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石工泵").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSgbSy)) {
|
xszbSgb.setLjwc(xszbSgbSy.getLjwc().add(xszbSgb.getDywc()));//累计完成
|
if (xszbSgb.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbSgb.setNjhwc(xszbSgb.getLjwc().divide(xszbSgb.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbSgb.setNtqb(xszbSgb.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.updateById(xszbSgb);
|
}else {
|
if (ObjUtil.isNotNull(planListSGB)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListSGB, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbSGB.setDyjh(curMonAmount);//当月计划
|
xszbSGB.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbSGB.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbSGB.setDywc(kp.getSgbby());//当月完成
|
if (xszbSGB.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbSGB.setYjhwc(xszbSGB.getDywc().divide(xszbSGB.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石工泵").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbSGB.setYtqb(xszbSGB.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbSgbSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"石工泵").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSgbSy)) {
|
xszbSGB.setLjwc(xszbSgbSy.getLjwc().add(xszbSGB.getDywc()));//累计完成
|
if (xszbSGB.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbSGB.setNjhwc(xszbSGB.getLjwc().divide(xszbSGB.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbSGB.setNtqb(xszbSGB.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.insert(xszbSGB);
|
}
|
ZbStatisticXszb xszbXTC = new ZbStatisticXszb();
|
xszbXTC.setXm(xm);
|
xszbXTC.setDw("邢台厂");
|
xszbXTC.setStatYm(curYear+"-"+curMonth);
|
xszbXTC.setCompId(2056556317461270529L);
|
ZbStatisticXszb xszbXtc = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"邢台厂").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1"));
|
AnnualPlan planListXTC = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
.eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
.eq(AnnualPlan::getCompId, 2056556317461270529L).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbXtc)){
|
if (ObjUtil.isNotNull(planListXTC)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListXTC, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbXtc.setDyjh(curMonAmount);//当月计划
|
xszbXtc.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbXtc.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbXtc.setDywc(kp.getJxcby());//当月完成
|
if (xszbXtc.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbXtc.setYjhwc(xszbXtc.getDywc().divide(xszbXtc.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"邢台厂").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbXtc.setYtqb(xszbXtc.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbXtcSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"邢台厂").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbXtcSy)) {
|
xszbXtc.setLjwc(xszbXtcSy.getLjwc().add(xszbXtc.getDywc()));//累计完成
|
if (xszbXtc.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbXtc.setNjhwc(xszbXtc.getLjwc().divide(xszbXtc.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbXtc.setNtqb(xszbXtc.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.updateById(xszbXtc);
|
}else {
|
if (ObjUtil.isNotNull(planListXTC)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListXTC, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbXTC.setDyjh(curMonAmount);//当月计划
|
xszbXTC.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbXTC.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbXTC.setDywc(kp.getJxcby());//累计完成
|
if (xszbXTC.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbXTC.setYjhwc(xszbXTC.getDywc().divide(xszbXTC.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"邢台厂").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbXTC.setYtqb(xszbXTC.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbXtcSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"邢台厂").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbXtcSy)) {
|
xszbXTC.setLjwc(xszbXtcSy.getLjwc().add(xszbXTC.getDywc()));//累计完成
|
if (xszbXTC.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbXTC.setNjhwc(xszbXTC.getLjwc().divide(xszbXTC.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbXTC.setNtqb(xszbXTC.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.insert(xszbXTC);
|
}
|
ZbStatisticXszb xszbTFC = new ZbStatisticXszb();
|
xszbTFC.setXm(xm);
|
xszbTFC.setDw("通方厂");
|
xszbTFC.setStatYm(curYear+"-"+curMonth);
|
xszbTFC.setCompId(2056556421857497090L);
|
ZbStatisticXszb xszbTfc = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"通方厂").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1"));
|
AnnualPlan planListTFC = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
.eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
.eq(AnnualPlan::getCompId, 2056556421857497090L).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbTfc)){
|
if (ObjUtil.isNotNull(planListTFC)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListTFC, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbTfc.setDyjh(curMonAmount);//当月计划
|
xszbTfc.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbTfc.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbTfc.setDywc(kp.getTfby());//当月完成
|
if (xszbTfc.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbTfc.setYjhwc(xszbTfc.getDywc().divide(xszbTfc.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"通方厂").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbTfc.setYtqb(xszbTfc.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbTfcSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"通方厂").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbTfcSy)) {
|
xszbTfc.setLjwc(xszbTfcSy.getLjwc().add(xszbTfc.getDywc()));
|
if (xszbTfc.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbTfc.setNjhwc(xszbTfc.getLjwc().divide(xszbTfc.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbTfc.setNtqb(xszbTfc.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.updateById(xszbTfc);
|
}else {
|
if (ObjUtil.isNotNull(planListTFC)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListTFC, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbTFC.setDyjh(curMonAmount);//当月计划
|
xszbTFC.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbTFC.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbTFC.setDywc(kp.getTfby());//当月完成
|
if (xszbTFC.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbTFC.setYjhwc(xszbTFC.getDywc().divide(xszbTFC.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"通方厂").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbTFC.setYtqb(xszbTFC.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbTfcSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"通方厂").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbTfcSy)) {
|
xszbTFC.setLjwc(xszbTfcSy.getLjwc().add(xszbTFC.getDywc()));
|
if (xszbTFC.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbTFC.setNjhwc(xszbTFC.getLjwc().divide(xszbTFC.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbTFC.setNtqb(xszbTFC.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.insert(xszbTFC);
|
}
|
ZbStatisticXszb xszbYMJ = new ZbStatisticXszb();
|
xszbYMJ.setXm(xm);
|
xszbYMJ.setDw("一煤机");
|
xszbYMJ.setStatYm(curYear+"-"+curMonth);
|
xszbYMJ.setCompId(2056556535640576002L);
|
ZbStatisticXszb xszbYmj = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"一煤机").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1"));
|
AnnualPlan planListYMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
.eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
.eq(AnnualPlan::getCompId, 2056556535640576002L).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbYmj)){
|
if (ObjUtil.isNotNull(planListYMJ)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListYMJ, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbYmj.setDyjh(curMonAmount);//当月计划
|
xszbYmj.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbYmj.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbYmj.setDywc(kp.getYmjby());//当月完成
|
if (xszbYmj.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbYmj.setYjhwc(xszbYmj.getDywc().divide(xszbYmj.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"一煤机").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbYmj.setYtqb(xszbYmj.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbYmjSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"一煤机").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbYmjSy)) {
|
xszbYmj.setLjwc(xszbYmjSy.getLjwc().add(xszbYmj.getDywc()));
|
if (xszbYmj.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbYmj.setNjhwc(xszbYmj.getLjwc().divide(xszbYmj.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbYmj.setNtqb(xszbYmj.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.updateById(xszbYmj);
|
}else {
|
if (ObjUtil.isNotNull(planListYMJ)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListYMJ, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbYMJ.setDyjh(curMonAmount);//当月计划
|
xszbYMJ.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbYMJ.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
|
xszbYMJ.setDywc(kp.getYmjby());//当月完成
|
if (xszbYMJ.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbYMJ.setYjhwc(xszbYMJ.getDywc().divide(xszbYMJ.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"一煤机").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbYMJ.setYtqb(xszbYMJ.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbYmjSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"一煤机").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbYmjSy)) {
|
xszbYMJ.setLjwc(xszbYmjSy.getLjwc().add(xszbYMJ.getDywc()));
|
if (xszbYMJ.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbYMJ.setNjhwc(xszbYMJ.getLjwc().divide(xszbYMJ.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbYMJ.setNtqb(xszbYMJ.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.insert(xszbYMJ);
|
}
|
ZbStatisticXszb xszbZBJT = new ZbStatisticXszb();
|
xszbZBJT.setXm(xm);
|
xszbZBJT.setDw("装备集团");
|
xszbZBJT.setStatYm(curYear+"-"+curMonth);
|
ZbStatisticXszb xszbZbjt = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"装备集团").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1"));
|
AnnualPlanTotalVo planListZB = annualPlanMapper.selectPlanYear(curYear, planType);
|
if (ObjUtil.isNotNull(xszbZbjt)){
|
if (ObjUtil.isNotNull(planListZB)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListZB, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbZbjt.setDyjh(curMonAmount);//当月计划
|
xszbZbjt.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbZbjt.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbZbjt.setDywc(kp.safeAddAll(kp.getSmjby(),kp.getSgbby(),kp.getJxcby(),kp.getTfby(),kp.getYmjby()));//当月完成
|
if (ObjUtil.isNotNull(xszbZbjt.getDyjh())&&xszbZbjt.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbZbjt.setYjhwc(xszbZbjt.getDywc().divide(xszbZbjt.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"装备集团").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbZbjt.setYtqb(xszbZbjt.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbZbjtSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"装备集团").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbZbjtSy)) {
|
xszbZbjt.setLjwc(xszbZbjtSy.getLjwc().add(xszbZbjt.getDywc()));
|
if (ObjUtil.isNotNull(xszbZbjt.getLjjh()) && xszbZbjt.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbZbjt.setNjhwc(xszbZbjt.getLjwc().divide(xszbZbjt.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbZbjt.setNtqb(xszbZbjt.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.updateById(xszbZbjt);
|
}else {
|
if (ObjUtil.isNotNull(planListZB)) {
|
AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListZB, AnnualPlanTotalVo.class);
|
BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
xszbZBJT.setDyjh(curMonAmount);//当月计划
|
xszbZBJT.setNdjh(plansmj.getTotalAmount());//年度计划
|
xszbZBJT.setLjjh(plansmj.getToMonTotalAmount(curMonth));//累计计划
|
}
|
xszbZBJT.setDywc(kp.safeAddAll(kp.getSmjby(),kp.getSgbby(),kp.getJxcby(),kp.getTfby(),kp.getYmjby()));//当月完成
|
if (xszbZBJT.getDyjh().compareTo(new BigDecimal("0")) > 0) {//当月计划完成率
|
xszbZBJT.setYjhwc(xszbZBJT.getDywc().divide(xszbZBJT.getDyjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth qndy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusYears(1);
|
ZbStatisticXszb xszbSmjQNDY = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"装备集团").eq(ZbStatisticXszb::getStatYm,qndy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbSmjQNDY)&&xszbSmjQNDY.getDywc().compareTo(new BigDecimal("0"))>0){
|
xszbZBJT.setYtqb(xszbZBJT.getDywc().subtract(xszbSmjQNDY.getDywc()).divide(xszbSmjQNDY.getDywc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
YearMonth sy = YearMonth.of(Integer.valueOf(curYear), Integer.valueOf(curMonth)).minusMonths(1);
|
ZbStatisticXszb xszbZbjtSy = baseMapper.selectOne(Wrappers.<ZbStatisticXszb>lambdaQuery().eq(ZbStatisticXszb::getXm,xm)
|
.eq(ZbStatisticXszb::getDw,"装备集团").eq(ZbStatisticXszb::getStatYm,sy).last("limit 1"));
|
if (ObjUtil.isNotNull(xszbZbjtSy)) {
|
xszbZBJT.setLjwc(xszbZbjtSy.getLjwc().add(xszbZBJT.getDywc()));
|
if (xszbZBJT.getLjjh().compareTo(new BigDecimal("0")) > 0) {//累计计划完成率
|
xszbZBJT.setNjhwc(xszbZBJT.getLjwc().divide(xszbZBJT.getLjjh(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
if (ObjUtil.isNotNull(xszbSmjQNDY) && xszbSmjQNDY.getLjwc().compareTo(new BigDecimal("0")) > 0) {
|
xszbZBJT.setNtqb(xszbZBJT.getLjwc().subtract(xszbSmjQNDY.getLjwc()).divide(xszbSmjQNDY.getLjwc(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
.setScale(2, RoundingMode.HALF_UP) + "%");
|
}
|
}
|
baseMapper.insert(xszbZBJT);
|
}
|
// ZyxszbwcqkVo vosmj = new ZyxszbwcqkVo();
|
// vosmj.setXm(xm);
|
// vosmj.setDw("石煤机");
|
// ZyxszbwcqkVo vosgb = new ZyxszbwcqkVo();
|
// vosgb.setXm(xm);
|
// vosgb.setDw("石工泵");
|
// ZyxszbwcqkVo vojxc = new ZyxszbwcqkVo();
|
// vojxc.setXm(xm);
|
// vojxc.setDw("邢台厂");
|
// ZyxszbwcqkVo votf = new ZyxszbwcqkVo();
|
// votf.setXm(xm);
|
// votf.setDw("通方厂");
|
// ZyxszbwcqkVo voymj = new ZyxszbwcqkVo();
|
// voymj.setXm(xm);
|
// voymj.setDw("一煤机");
|
// ZyxszbwcqkVo vozb = new ZyxszbwcqkVo();
|
// vozb.setXm(xm);
|
// vozb.setDw("装备集团");
|
//
|
// //装备
|
// vosmj.setDrwc(kp.safeAddAll(kp.getSmjbr(),kp.getSgbbr(),kp.getJxcbr(),kp.getTfbr(),null));
|
// AnnualPlanTotalVo planListZB = annualPlanMapper.selectPlanYear(curYear, planType);
|
// if (ObjUtil.isNotNull(planListZB)) {
|
// AnnualPlanTotalVo planzb = BeanUtil.copyProperties(planListZB, AnnualPlanTotalVo.class);
|
// BigDecimal curMonAmount = planzb.getMonthAmount(curMonth);
|
// vozb.setDyjh(curMonAmount);
|
// vozb.setDywc(kp.safeAddAll(kp.getSmjby(),kp.getSgbby(),kp.getJxcby(),kp.getTfby(),null));
|
// if (vozb.getDyjh().compareTo(new BigDecimal("0")) > 0) {
|
// vozb.setYjhwc(vozb.getDywc().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
//
|
// BigDecimal qnby = kp.safeAddAll(kp.getSmjqnby(),kp.getSgbqnby(),kp.getJxcqnby(),kp.getTfqnby(),null);
|
// BigDecimal qnbytb = vozb.getDywc().subtract(qnby);
|
// if (qnby.compareTo(new BigDecimal("0"))>0){
|
// BigDecimal qnbytqb = qnbytb.divide(qnby,10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vozb.setYtqb(qnbytqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
//
|
// vozb.setNdjh(planzb.getTotalAmount());
|
// BigDecimal yearAmount = planzb.getTotalAmount();
|
// vozb.setLjjh(planzb.getToMonTotalAmount(curMonth));
|
// vozb.setLjwc(kp.safeAddAll(kp.getSmjbn(),kp.getSgbbn(),kp.getJxcbn(),kp.getTfbn(),null));
|
// if (vozb.getLjjh().compareTo(new BigDecimal("0")) > 0) {
|
// vozb.setNjhwc(vozb.getLjwc().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// BigDecimal qnbn = kp.safeAddAll(kp.getSmjqnbn(),kp.getSgbqnbn(),kp.getJxcqnbn(),kp.getTfqnbn(),null);
|
// BigDecimal qnbntb = vozb.getLjwc().subtract(qnby);
|
// if (qnbn.compareTo(new BigDecimal("0"))>0){
|
// BigDecimal qnbntqb = qnbntb.divide(qnbn,10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vozb.setYtqb(qnbntqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// }
|
// //石煤机收入
|
// AnnualPlan planListSMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
// .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
// .in(AnnualPlan::getCompId, compIds).last("limit 1"));
|
// vosmj.setDrwc(kp.getSmjbr());
|
// if (ObjUtil.isNotNull(planListSMJ)) {
|
//
|
// AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListSMJ, AnnualPlanTotalVo.class);
|
// BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth);
|
// vosmj.setDyjh(curMonAmount);
|
// if (ObjUtil.isNotNull(kp.getSmjby()) && kp.getSmjby().compareTo(new BigDecimal("0")) > 0) {
|
// vosmj.setDywc(kp.getSmjby());
|
// vosmj.setYjhwc(kp.getSmjby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnby())&& kp.getSmjqnby().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = vosmj.getDywc().subtract(kp.getSmjqnby());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnby(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vosmj.setYtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// vosmj.setNdjh(plansmj.getTotalAmount());
|
// BigDecimal yearAmount = plansmj.getTotalAmount();
|
// vosmj.setLjjh(plansmj.getToMonTotalAmount(curMonth));
|
// vosmj.setLjwc(kp.getSmjbn());
|
// if (ObjUtil.isNotNull(kp.getSmjbn()) && kp.getSmjbn().compareTo(new BigDecimal("0")) > 0) {
|
// vosmj.setNjhwc(kp.getSmjbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnbn())&& kp.getSmjqnbn().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = vosmj.getLjwc().subtract(kp.getSmjqnbn());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnbn(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vosmj.setNtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// }
|
// //石工泵收入
|
// vosgb.setDrwc(kp.getSgbbr());
|
// AnnualPlan planListSRSGB = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
// .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
// .eq(AnnualPlan::getCompId, 2056556196124250113L).last("limit 1"));
|
// if (ObjUtil.isNotNull(planListSRSGB)) {
|
// AnnualPlanTotalVo plansgb = BeanUtil.copyProperties(planListSRSGB, AnnualPlanTotalVo.class);
|
// BigDecimal curMonAmount = plansgb.getMonthAmount(curMonth);
|
// vosgb.setDyjh(curMonAmount);
|
// if (ObjUtil.isNotNull(kp.getSgbby()) && kp.getSgbby().compareTo(new BigDecimal("0")) > 0) {
|
// vosgb.setDywc(kp.getSgbby());
|
// vosgb.setYjhwc(kp.getSgbby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnby())&& kp.getSmjqnby().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = vosgb.getDywc().subtract(kp.getSmjqnby());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnby(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vosgb.setYtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// vosgb.setNdjh(plansgb.getTotalAmount());
|
// BigDecimal yearAmount = plansgb.getTotalAmount();
|
// vosgb.setLjjh(plansgb.getToMonTotalAmount(curMonth));
|
// vosgb.setLjwc(kp.getSgbbn());
|
// if (ObjUtil.isNotNull(kp.getSgbbn()) && kp.getSgbbn().compareTo(new BigDecimal("0")) > 0) {
|
// vosgb.setNjhwc(kp.getSgbbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnbn())&& kp.getSmjqnbn().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = vosgb.getLjwc().subtract(kp.getSmjqnbn());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnbn(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vosgb.setNtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// }
|
// //通方公司收入
|
// votf.setDrwc(kp.getTfbr());
|
// AnnualPlan planListSRTFGS = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
// .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
// .eq(AnnualPlan::getCompId, 2056556421857497090L).last("limit 1"));
|
// if (ObjUtil.isNotNull(planListSRTFGS)) {
|
// AnnualPlanTotalVo plantf = BeanUtil.copyProperties(planListSRTFGS, AnnualPlanTotalVo.class);
|
// BigDecimal curMonAmount = plantf.getMonthAmount(curMonth);
|
// votf.setDyjh(curMonAmount);
|
// if (ObjUtil.isNotNull(kp.getTfby()) && kp.getTfby().compareTo(new BigDecimal("0")) > 0) {
|
// votf.setDywc(kp.getTfby());
|
// votf.setYjhwc(kp.getTfby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnby())&& kp.getSmjqnby().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = votf.getDywc().subtract(kp.getSmjqnby());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnby(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// votf.setYtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// votf.setNdjh(plantf.getTotalAmount());
|
// BigDecimal yearAmount = plantf.getTotalAmount();
|
// votf.setLjjh(plantf.getToMonTotalAmount(curMonth));
|
// votf.setLjwc(kp.getTfbn());
|
// if (ObjUtil.isNotNull(kp.getTfbn()) && kp.getTfbn().compareTo(new BigDecimal("0")) > 0) {
|
// votf.setNjhwc(kp.getTfbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnbn())&& kp.getSmjqnbn().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = votf.getLjwc().subtract(kp.getSmjqnbn());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnbn(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// votf.setNtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// }
|
// //机械厂收入
|
// vojxc.setDrwc(kp.getJxcbr());
|
// AnnualPlan planListSRJXC = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
// .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
// .eq(AnnualPlan::getCompId, 2056556317461270529L).last("limit 1"));
|
// if (ObjUtil.isNotNull(planListSRJXC)) {
|
// AnnualPlanTotalVo planjxc = BeanUtil.copyProperties(planListSRJXC, AnnualPlanTotalVo.class);
|
// BigDecimal curMonAmount = planjxc.getMonthAmount(curMonth);
|
// vojxc.setDyjh(curMonAmount);
|
// if (ObjUtil.isNotNull(kp.getJxcby()) && kp.getJxcby().compareTo(new BigDecimal("0")) > 0) {
|
// vojxc.setDywc(kp.getJxcby());
|
// vojxc.setYjhwc(kp.getJxcby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnby())&& kp.getSmjqnby().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = vojxc.getDywc().subtract(kp.getSmjqnby());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnby(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vojxc.setYtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// vojxc.setNdjh(planjxc.getTotalAmount());
|
// BigDecimal yearAmount = planjxc.getTotalAmount();
|
// vojxc.setLjjh(planjxc.getToMonTotalAmount(curMonth));
|
// vojxc.setLjwc(kp.getJxcbn());
|
// if (ObjUtil.isNotNull(kp.getJxcbn()) && kp.getJxcbn().compareTo(new BigDecimal("0")) > 0) {
|
// vojxc.setNjhwc(kp.getJxcbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnbn())&& kp.getSmjqnbn().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = vojxc.getLjwc().subtract(kp.getSmjqnbn());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnbn(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// vojxc.setNtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// }
|
// //一煤机收入
|
// voymj.setDrwc(kp.getYmjbr());
|
// AnnualPlan planListHYMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery()
|
// .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, planType)
|
// .eq(AnnualPlan::getCompId, 2056556535640576002L).last("limit 1"));
|
// if (ObjUtil.isNotNull(planListHYMJ)) {
|
// AnnualPlanTotalVo planymj = BeanUtil.copyProperties(planListHYMJ, AnnualPlanTotalVo.class);
|
// BigDecimal curMonAmount = planymj.getMonthAmount(curMonth);
|
// voymj.setDyjh(curMonAmount);
|
// if (ObjUtil.isNotNull(kp.getYmjby()) && kp.getYmjby().compareTo(new BigDecimal("0")) > 0) {
|
// voymj.setDywc(kp.getYmjby());
|
// voymj.setYjhwc(kp.getYmjby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnby())&& kp.getSmjqnby().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = voymj.getDywc().subtract(kp.getSmjqnby());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnby(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// voymj.setYtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// voymj.setNdjh(planymj.getTotalAmount());
|
// BigDecimal yearAmount = planymj.getTotalAmount();
|
// voymj.setLjjh(planymj.getToMonTotalAmount(curMonth));
|
// voymj.setLjwc(kp.getYmjbn());
|
// if (ObjUtil.isNotNull(kp.getYmjbn()) && kp.getYmjbn().compareTo(new BigDecimal("0")) > 0) {
|
// voymj.setNjhwc(kp.getYmjbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100"))
|
// .setScale(2, RoundingMode.HALF_UP) + "%");
|
// }
|
// if (ObjUtil.isNotNull(kp.getSmjqnbn())&& kp.getSmjqnbn().compareTo(new BigDecimal("0")) > 0){
|
// BigDecimal tb = voymj.getLjwc().subtract(kp.getSmjqnbn());
|
// BigDecimal tqb = tb.divide(kp.getSmjqnbn(),10,RoundingMode.HALF_UP).multiply(new BigDecimal("100"));
|
// voymj.setNtqb(tqb.setScale(2,RoundingMode.HALF_UP)+"%");
|
// }
|
// }
|
// list.add(vosmj);
|
// list.add(vosgb);
|
// list.add(vojxc);
|
// list.add(votf);
|
// list.add(voymj);
|
// list.add(vozb);
|
// return list;
|
}
|
|
}
|