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 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 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 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.lambdaQuery().eq(ZbStatisticXszb::getXm,xm) .eq(ZbStatisticXszb::getDw,"石煤机").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1")); AnnualPlan planListSMJ = annualPlanMapper.selectOne(Wrappers.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.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.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.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.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.lambdaQuery().eq(ZbStatisticXszb::getXm,xm) .eq(ZbStatisticXszb::getDw,"石工泵").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1")); AnnualPlan planListSGB = annualPlanMapper.selectOne(Wrappers.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.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.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.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.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.lambdaQuery().eq(ZbStatisticXszb::getXm,xm) .eq(ZbStatisticXszb::getDw,"邢台厂").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1")); AnnualPlan planListXTC = annualPlanMapper.selectOne(Wrappers.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.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.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.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.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.lambdaQuery().eq(ZbStatisticXszb::getXm,xm) .eq(ZbStatisticXszb::getDw,"通方厂").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1")); AnnualPlan planListTFC = annualPlanMapper.selectOne(Wrappers.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.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.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.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.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.lambdaQuery().eq(ZbStatisticXszb::getXm,xm) .eq(ZbStatisticXszb::getDw,"一煤机").eq(ZbStatisticXszb::getStatYm,xszbSMJ.getStatYm()).last("limit 1")); AnnualPlan planListYMJ = annualPlanMapper.selectOne(Wrappers.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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; } }