| | |
| | | package com.by4cloud.platformx.business.service.impl; |
| | | |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import cn.hutool.core.date.DateUtil; |
| | | import cn.hutool.core.util.ObjUtil; |
| | | import cn.hutool.core.util.StrUtil; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.by4cloud.platformx.admin.api.entity.SysDept; |
| | |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.time.LocalTime; |
| | | import java.util.ArrayList; |
| | | import java.util.Comparator; |
| | | import java.util.List; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | import java.util.stream.IntStream; |
| | | |
| | |
| | | private final ContractInvoiceMapper contractInvoiceMapper; |
| | | private final CurrentOverdueMapper currentOverdueMapper; |
| | | private final HistoryOverdueMapper historyOverdueMapper; |
| | | private final AnnualPlanMapper annualPlanMapper; |
| | | private final PaymentReceiveMapper paymentReceiveMapper; |
| | | private final RemoteDeptService remoteDeptService; |
| | | private final RemoteDictService remoteDictService; |
| | | |
| | |
| | | if (CollUtil.isNotEmpty(contractProvinces)){ |
| | | contractProvinces.stream().forEach(province->{ |
| | | HomeZgsData homeZgsData = contractInvoiceMapper.homeZgsData(SecurityUtils.getUser().getCompId(),province); |
| | | if (ObjUtil.isNotNull(homeZgsData)) { |
| | | SysDictItem result = items.stream() |
| | | .filter(item -> item != null && province.equals(item.getItemValue())) |
| | | .findFirst() |
| | |
| | | homeZgsData.setProvinceName(result.getLabel()); |
| | | } |
| | | list.add(homeZgsData); |
| | | } |
| | | }); |
| | | return R.ok(list); |
| | | } |
| | | return R.ok(); |
| | | } |
| | | |
| | | @Override |
| | | public R zbjtStatistic() { |
| | | List<ZbjtStatisticVo> statisticVoList = new ArrayList<>(); |
| | | String curYear = DateUtil.year(new Date())+""; |
| | | String curMonth = DateUtil.month(new Date())+""; |
| | | //合同 |
| | | ZbjtStatisticVo htVo = contractMapper.zbjtStatisticByContract(); |
| | | AnnualPlanTotalVo planListHt = annualPlanMapper.selectPlanYear(curYear,"1"); |
| | | if (ObjUtil.isNotNull(htVo)&&ObjUtil.isNotNull(planListHt)){ |
| | | BigDecimal monAmount = planListHt.getMonthAmount(curMonth); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | htVo.setBmwc(new BigDecimal(htVo.getBm()).multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | BigDecimal yearAmount = planListHt.getTotalAmount(); |
| | | if (ObjUtil.isNotNull(yearAmount)&&yearAmount.compareTo(new BigDecimal("0"))>0){ |
| | | htVo.setBnwc(new BigDecimal(htVo.getBn()).multiply(new BigDecimal("100")).divide(yearAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | } |
| | | statisticVoList.add(htVo); |
| | | //开票 |
| | | ZbjtStatisticVo kpVo = contractInvoiceMapper.zbjtStatisticByInvoice(); |
| | | AnnualPlanTotalVo planListFP = annualPlanMapper.selectPlanYear(curYear,"2"); |
| | | if (ObjUtil.isNotNull(kpVo)&&ObjUtil.isNotNull(planListFP)){ |
| | | BigDecimal monAmount = planListFP.getMonthAmount(curMonth); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | kpVo.setBmwc(new BigDecimal(kpVo.getBm()).multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | BigDecimal yearAmount = planListFP.getTotalAmount(); |
| | | if (ObjUtil.isNotNull(yearAmount)&&yearAmount.compareTo(new BigDecimal("0"))>0){ |
| | | kpVo.setBnwc(new BigDecimal(kpVo.getBn()).multiply(new BigDecimal("100")).divide(yearAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | } |
| | | statisticVoList.add(kpVo); |
| | | //回款 |
| | | ZbjtStatisticVo hkVo = paymentSlipMapper.zbjtStatisticByPayment(); |
| | | AnnualPlanTotalVo planListHK = annualPlanMapper.selectPlanYear(curYear,"2"); |
| | | if (ObjUtil.isNotNull(hkVo)&&ObjUtil.isNotNull(planListHK)){ |
| | | BigDecimal monAmount = planListHK.getMonthAmount(curMonth); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | hkVo.setBmwc(new BigDecimal(hkVo.getBm()).multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | BigDecimal yearAmount = planListHK.getTotalAmount(); |
| | | if (ObjUtil.isNotNull(yearAmount)&&yearAmount.compareTo(new BigDecimal("0"))>0){ |
| | | hkVo.setBnwc(new BigDecimal(hkVo.getBn()).multiply(new BigDecimal("100")).divide(yearAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | } |
| | | statisticVoList.add(hkVo); |
| | | return R.ok(statisticVoList); |
| | | } |
| | | |
| | | @Override |
| | | public R zbjtStatisticContractAmount() { |
| | | JSONObject jsonObject = new JSONObject(); |
| | | ZbjtStatisticByContractAmountVo hte = contractMapper.zbjtStatisticByContractAmount(); |
| | | jsonObject.put("hte",hte); |
| | | ZbjtStatisticByContractAmountProVo htp = contractMapper.zbjtStatisticByContractAmountPro(); |
| | | jsonObject.put("cpbk",htp); |
| | | ZbjtStatisticByContractAmountClassVo sc = contractMapper.zbjtStatisticByContractAmountClass(); |
| | | jsonObject.put("sczb",sc); |
| | | ZbjtStatisticByContractAmountSupplyVo yw = contractMapper.zbjtStatisticByContractAmountSupply(); |
| | | jsonObject.put("ywzb",yw); |
| | | ZbjtStatisticByContractAmountClassVo ys = contractMapper.zbjtStatisticByContractAmountYS(); |
| | | jsonObject.put("yszb",ys); |
| | | return R.ok(jsonObject); |
| | | } |
| | | |
| | | @Override |
| | | public R zbjtIndicatorTrend() { |
| | | JSONObject jsonObject = new JSONObject(); |
| | | Integer curYear = DateUtil.year(new Date()); |
| | | String startMon = (curYear-3)+"-01-01"; |
| | | String endMon = curYear+"-12-01"; |
| | | List<ZbjtIndicatorTrendVo> trendList = contractMapper.zbjtIndicatorTrend(startMon,endMon); |
| | | JSONObject zbqs_ht = new JSONObject(); |
| | | zbqs_ht.put((curYear-3)+"",trendList.stream().filter(item->item.getYearMon().startsWith((curYear-3)+"")).collect(Collectors.toList())); |
| | | zbqs_ht.put((curYear-2)+"",trendList.stream().filter(item->item.getYearMon().startsWith((curYear-2)+"")).collect(Collectors.toList())); |
| | | zbqs_ht.put((curYear-1)+"",trendList.stream().filter(item->item.getYearMon().startsWith((curYear-1)+"")).collect(Collectors.toList())); |
| | | zbqs_ht.put(curYear+"",trendList.stream().filter(item->item.getYearMon().startsWith(curYear+"")).collect(Collectors.toList())); |
| | | jsonObject.put("zbqs-ht",zbqs_ht); |
| | | List<ZbjtIndicatorTrendVo> trendInvoiceList = contractInvoiceMapper.zbjtIndicatorTrend(startMon,endMon); |
| | | JSONObject zbqs_sr = new JSONObject(); |
| | | zbqs_sr.put((curYear-3)+"",trendInvoiceList.stream().filter(item->item.getYearMon().startsWith((curYear-3)+"")).collect(Collectors.toList())); |
| | | zbqs_sr.put((curYear-2)+"",trendInvoiceList.stream().filter(item->item.getYearMon().startsWith((curYear-2)+"")).collect(Collectors.toList())); |
| | | zbqs_sr.put((curYear-1)+"",trendInvoiceList.stream().filter(item->item.getYearMon().startsWith((curYear-1)+"")).collect(Collectors.toList())); |
| | | zbqs_sr.put(curYear+"",trendInvoiceList.stream().filter(item->item.getYearMon().startsWith(curYear+"")).collect(Collectors.toList())); |
| | | jsonObject.put("zbqs-sr",zbqs_sr); |
| | | List<ZbjtIndicatorTrendVo> trendSlipList = paymentSlipMapper.zbjtIndicatorTrend(startMon,endMon); |
| | | JSONObject zbqs_hs = new JSONObject(); |
| | | zbqs_hs.put((curYear-3)+"",trendSlipList.stream().filter(item->item.getYearMon().startsWith((curYear-3)+"")).collect(Collectors.toList())); |
| | | zbqs_hs.put((curYear-2)+"",trendSlipList.stream().filter(item->item.getYearMon().startsWith((curYear-2)+"")).collect(Collectors.toList())); |
| | | zbqs_hs.put((curYear-1)+"",trendSlipList.stream().filter(item->item.getYearMon().startsWith((curYear-1)+"")).collect(Collectors.toList())); |
| | | zbqs_hs.put(curYear+"",trendSlipList.stream().filter(item->item.getYearMon().startsWith(curYear+"")).collect(Collectors.toList())); |
| | | jsonObject.put("zbqs-hk",zbqs_hs); |
| | | return R.ok(jsonObject); |
| | | } |
| | | |
| | | @Override |
| | | public R zbjtPlanAchieced() { |
| | | String curYear = DateUtil.year(new Date())+""; |
| | | JSONObject jsonObject = new JSONObject(); |
| | | JSONObject ht = new JSONObject(); |
| | | AnnualPlanTotalVo planListHt = annualPlanMapper.selectPlanYear(curYear,"1"); |
| | | List<ZbjtIndicatorTrendVo> trendVoList = contractMapper.zbjtPlanAchieced(null); |
| | | if (ObjUtil.isNotNull(planListHt)&&CollUtil.isNotEmpty(trendVoList)){ |
| | | trendVoList.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHt.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | ht.put("zb",trendVoList); |
| | | List<Long> compIds = new ArrayList<>(); |
| | | compIds.add(2089995177814495234L); |
| | | compIds.add(2089996921978040321L); |
| | | compIds.add(2089997578009128962L); |
| | | compIds.add(2101966257365045249L); |
| | | |
| | | AnnualPlan planListHtSMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .in(AnnualPlan::getCompId,compIds).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> smjtrendVoList = contractMapper.zbjtPlanAchiecedSmj(); |
| | | if (ObjUtil.isNotNull(planListHtSMJ)&&CollUtil.isNotEmpty(smjtrendVoList)){ |
| | | smjtrendVoList.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHtSMJ.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | ht.put("smj",smjtrendVoList); |
| | | AnnualPlan planListHtSGB = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556196124250113L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> sgbtrendVoList = contractMapper.zbjtPlanAchieced(2056556196124250113L); |
| | | if (ObjUtil.isNotNull(planListHtSGB)&&CollUtil.isNotEmpty(sgbtrendVoList)){ |
| | | sgbtrendVoList.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHtSGB.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | ht.put("sgb",sgbtrendVoList); |
| | | AnnualPlan planListHTfgs = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556421857497090L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> tfgstrendVoList = contractMapper.zbjtPlanAchieced(2056556421857497090L); |
| | | if (ObjUtil.isNotNull(planListHTfgs)&&CollUtil.isNotEmpty(tfgstrendVoList)){ |
| | | tfgstrendVoList.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHTfgs.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | ht.put("tfgs",tfgstrendVoList); |
| | | AnnualPlan planListHjxc = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556317461270529L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> jxctrendVoList = contractMapper.zbjtPlanAchieced(2056556317461270529L); |
| | | if (ObjUtil.isNotNull(planListHjxc)&&CollUtil.isNotEmpty(jxctrendVoList)){ |
| | | jxctrendVoList.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHjxc.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | ht.put("jxc",jxctrendVoList); |
| | | AnnualPlan planListHYMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556535640576002L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> ymjtrendVoList = contractMapper.zbjtPlanAchieced(2056556535640576002L); |
| | | if (ObjUtil.isNotNull(planListHYMJ)&&CollUtil.isNotEmpty(ymjtrendVoList)){ |
| | | ymjtrendVoList.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHYMJ.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | ht.put("ymj",ymjtrendVoList); |
| | | jsonObject.put("ht",ht); |
| | | JSONObject sr = new JSONObject(); |
| | | AnnualPlanTotalVo planLisSR = annualPlanMapper.selectPlanYear(curYear,"1"); |
| | | List<ZbjtIndicatorTrendVo> trendVoList1 = contractInvoiceMapper.zbjtPlanAchieced(null); |
| | | if (ObjUtil.isNotNull(planLisSR)&&CollUtil.isNotEmpty(trendVoList1)){ |
| | | trendVoList1.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planLisSR.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | sr.put("zb",trendVoList1); |
| | | |
| | | AnnualPlan planListSRSMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"2") |
| | | .in(AnnualPlan::getCompId,compIds).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> smjtrendVoList1 = contractInvoiceMapper.zbjtPlanAchiecedSmj(); |
| | | if (ObjUtil.isNotNull(planListSRSMJ)&&CollUtil.isNotEmpty(smjtrendVoList1)){ |
| | | smjtrendVoList1.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListSRSMJ.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | sr.put("smj",smjtrendVoList1); |
| | | //石工泵收入 |
| | | AnnualPlan planListSRSGB = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556196124250113L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> sgbtrendVoList1 = contractInvoiceMapper.zbjtPlanAchieced(2056556196124250113L); |
| | | if (ObjUtil.isNotNull(planListSRSGB)&&CollUtil.isNotEmpty(sgbtrendVoList1)){ |
| | | sgbtrendVoList1.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListSRSGB.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | sr.put("sgb",sgbtrendVoList1); |
| | | //通方公司收入 |
| | | AnnualPlan planListSRTFGS = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556421857497090L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> tfgstrendVoList1 = contractInvoiceMapper.zbjtPlanAchieced(2056556421857497090L); |
| | | |
| | | if (ObjUtil.isNotNull(planListSRTFGS)&&CollUtil.isNotEmpty(tfgstrendVoList1)){ |
| | | tfgstrendVoList1.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListSRTFGS.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | sr.put("tfgs",tfgstrendVoList1); |
| | | //机械厂收入 |
| | | AnnualPlan planListSRJXC = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556317461270529L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> jxctrendVoList1 = contractInvoiceMapper.zbjtPlanAchieced(2056556317461270529L); |
| | | |
| | | |
| | | if (ObjUtil.isNotNull(planListSRJXC)&&CollUtil.isNotEmpty(jxctrendVoList1)){ |
| | | jxctrendVoList1.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListSRJXC.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | sr.put("jxc",jxctrendVoList1); |
| | | //一煤机收入 |
| | | AnnualPlan planListSRYMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556317461270529L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> ymjtrendVoList1 = contractInvoiceMapper.zbjtPlanAchieced(2056556535640576002L); |
| | | |
| | | |
| | | if (ObjUtil.isNotNull(planListSRYMJ)&&CollUtil.isNotEmpty(ymjtrendVoList1)){ |
| | | ymjtrendVoList1.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListSRYMJ.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | sr.put("ymj",ymjtrendVoList1); |
| | | jsonObject.put("sr",sr); |
| | | |
| | | JSONObject hk = new JSONObject(); |
| | | //回款 |
| | | AnnualPlanTotalVo planLisHK = annualPlanMapper.selectPlanYear(curYear,"1"); |
| | | List<ZbjtIndicatorTrendVo> trendVoList2 = paymentSlipMapper.zbjtPlanAchieced(null); |
| | | if (ObjUtil.isNotNull(planLisHK)&&CollUtil.isNotEmpty(trendVoList2)){ |
| | | trendVoList2.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planLisHK.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | hk.put("zb",trendVoList2); |
| | | //石煤机回款 |
| | | AnnualPlan planListHKSMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"2") |
| | | .in(AnnualPlan::getCompId,compIds).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> smjtrendVoList2 = paymentSlipMapper.zbjtPlanAchiecedSmj(); |
| | | if (ObjUtil.isNotNull(planListHKSMJ)&&CollUtil.isNotEmpty(smjtrendVoList2)){ |
| | | smjtrendVoList2.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHKSMJ.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | hk.put("smj",smjtrendVoList2); |
| | | //石工泵回款 |
| | | AnnualPlan planListHKSGB = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556196124250113L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> sgbtrendVoList2 = paymentSlipMapper.zbjtPlanAchieced(2056556196124250113L); |
| | | |
| | | |
| | | if (ObjUtil.isNotNull(planListHKSGB)&&CollUtil.isNotEmpty(sgbtrendVoList2)){ |
| | | sgbtrendVoList2.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHKSGB.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | hk.put("sgb",sgbtrendVoList2); |
| | | //tfgs回款 |
| | | AnnualPlan planListHKTFGS = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556421857497090L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> tfgstrendVoList2 = paymentSlipMapper.zbjtPlanAchieced(2056556421857497090L); |
| | | |
| | | if (ObjUtil.isNotNull(planListHKTFGS)&&CollUtil.isNotEmpty(tfgstrendVoList2)){ |
| | | tfgstrendVoList2.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHKTFGS.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | hk.put("tfgs",tfgstrendVoList2); |
| | | //机械厂回款 |
| | | AnnualPlan planListHKJXC = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556317461270529L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> jxctrendVoList2 = paymentSlipMapper.zbjtPlanAchieced(2056556317461270529L); |
| | | |
| | | if (ObjUtil.isNotNull(planListHKJXC)&&CollUtil.isNotEmpty(jxctrendVoList2)){ |
| | | jxctrendVoList2.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHKJXC.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | |
| | | hk.put("jxc",jxctrendVoList2); |
| | | //一煤机回款 |
| | | AnnualPlan planListHKYMJ = annualPlanMapper.selectOne(Wrappers.<AnnualPlan>lambdaQuery() |
| | | .eq(AnnualPlan::getPlanYear,curYear).eq(AnnualPlan::getPlanType,"1") |
| | | .eq(AnnualPlan::getCompId,2056556535640576002L).last("limit 1")); |
| | | List<ZbjtIndicatorTrendVo> ymjtrendVoList2 = paymentSlipMapper.zbjtPlanAchieced(2056556535640576002L); |
| | | |
| | | if (ObjUtil.isNotNull(planListHKYMJ)&&CollUtil.isNotEmpty(ymjtrendVoList2)){ |
| | | ymjtrendVoList2.stream().forEach(trendVo->{ |
| | | BigDecimal monAmount = planListHKYMJ.getMonthAmount(trendVo.getYearMon()); |
| | | if (ObjUtil.isNotNull(monAmount)&&monAmount.compareTo(new BigDecimal("0"))>0){ |
| | | trendVo.setWc(trendVo.getJe().multiply(new BigDecimal("100")).divide(monAmount,2,RoundingMode.HALF_UP)+"%"); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | hk.put("ymj",ymjtrendVoList2); |
| | | jsonObject.put("hk",hk); |
| | | return R.ok(jsonObject); |
| | | } |
| | | |
| | | @Override |
| | | public R zbjtReceiveScale() { |
| | | |
| | | JSONObject hk = new JSONObject(); |
| | | //回款 |
| | | List<ZbjtIndicatorTrendVo> trendVoList = paymentReceiveMapper.zbjtReceiveScale(null); |
| | | hk.put("zb",trendVoList); |
| | | //石煤机回款 |
| | | |
| | | List<Long> compIds = new ArrayList<>(); |
| | | compIds.add(2089995177814495234L); |
| | | compIds.add(2089996921978040321L); |
| | | compIds.add(2089997578009128962L); |
| | | compIds.add(2101966257365045249L); |
| | | |
| | | List<ZbjtIndicatorTrendVo> trendVoListSMJ = paymentReceiveMapper.zbjtReceiveScaleSMJ(); |
| | | hk.put("smj",trendVoListSMJ); |
| | | //石工泵回款 |
| | | List<ZbjtIndicatorTrendVo> trendVoListSGB = paymentReceiveMapper.zbjtReceiveScale(2056556196124250113L); |
| | | |
| | | hk.put("sgb",trendVoListSGB); |
| | | //tfgs |
| | | List<ZbjtIndicatorTrendVo> trendVoListTFGS = paymentReceiveMapper.zbjtReceiveScale(2056556421857497090L); |
| | | hk.put("tfgs",trendVoListTFGS); |
| | | //机械厂回款 |
| | | List<ZbjtIndicatorTrendVo> trendVoListJXC = paymentReceiveMapper.zbjtReceiveScale(2056556317461270529L); |
| | | hk.put("jxc",trendVoListJXC); |
| | | //一煤机回款 |
| | | List<ZbjtIndicatorTrendVo> trendVoListYMJ = paymentReceiveMapper.zbjtReceiveScale(2056556535640576002L); |
| | | hk.put("ymj",trendVoListYMJ); |
| | | return R.ok(hk); |
| | | } |
| | | } |