package com.by4cloud.platformx.business.service.impl; import cn.hutool.core.bean.BeanUtil; 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.JSONArray; 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 com.by4cloud.platformx.admin.api.entity.SysDictItem; import com.by4cloud.platformx.admin.api.feign.RemoteDeptService; import com.by4cloud.platformx.admin.api.feign.RemoteDictService; import com.by4cloud.platformx.business.dto.AgingQueryDTO; import com.by4cloud.platformx.business.dto.AnalysisCommonDTO; import com.by4cloud.platformx.business.dto.HomeQueryDTO; import com.by4cloud.platformx.business.dto.HomeZbjtDTO; import com.by4cloud.platformx.business.entity.*; import com.by4cloud.platformx.business.mapper.*; import com.by4cloud.platformx.business.service.StatisticService; import com.by4cloud.platformx.business.vo.*; import com.by4cloud.platformx.common.core.util.R; import com.by4cloud.platformx.common.data.datascope.DataScope; import com.by4cloud.platformx.common.security.util.SecurityUtils; import com.github.yulichang.wrapper.MPJLambdaWrapper; import lombok.RequiredArgsConstructor; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import java.math.BigDecimal; import java.math.RoundingMode; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.LocalTime; import java.util.*; import java.util.stream.Collectors; import java.util.stream.IntStream; @Service @RequiredArgsConstructor public class StatisticServiceImpl implements StatisticService { private final ContractMapper contractMapper; private final ContractPaymentScheduleMapper contractPaymentScheduleMapper; private final BusinessCustomerMapper businessCustomerMapper; private final PaymentSlipMapper paymentSlipMapper; private final ContractOutBoundMapper contractOutBoundMapper; 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; @Value("${dept.smj}") private String smj; @Value("${dept.sgb}") private String sgb; @Value("${dept.jxc}") private String jxc; @Value("${dept.tfgs}") private String tfgs; @Value("${dept.ymj}") private String ymj; @Override public R contractAmountAnalysis(AnalysisCommonDTO commonDTO) { List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractAmountAnalysisVoList = contractMapper.contractAmountAnalysis(commonDTO, compIds); return R.ok(contractAmountAnalysisVoList); } @Override public R contractAmountAnalysisByComp(AnalysisCommonDTO commonDTO) { List contractIncomeAnalysisVoList = contractMapper.contractAmountAnalysisByComp(commonDTO, SecurityUtils.getUser().getCompId()); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractIncomeAnalysis(AnalysisCommonDTO commonDTO) { List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = contractMapper.contractIncomeAnalysis(commonDTO, compIds); if (CollUtil.isNotEmpty(contractIncomeAnalysisVoList)) { contractIncomeAnalysisVoList.stream().forEach(contractIncomeAnalysisVo -> { if (StrUtil.equals(contractIncomeAnalysisVo.getCompId(), sgb)) { contractIncomeAnalysisVo.setCompName("石工泵"); } if (StrUtil.equals(contractIncomeAnalysisVo.getCompId(), smj)) { contractIncomeAnalysisVo.setCompName("石煤机"); } if (StrUtil.equals(contractIncomeAnalysisVo.getCompId(), ymj)) { contractIncomeAnalysisVo.setCompName("一煤机"); } if (StrUtil.equals(contractIncomeAnalysisVo.getCompId(), tfgs)) { contractIncomeAnalysisVo.setCompName("通方公司"); } if (StrUtil.equals(contractIncomeAnalysisVo.getCompId(), jxc)) { contractIncomeAnalysisVo.setCompName("机械厂"); } }); } return R.ok(contractIncomeAnalysisVoList); } @Override public R contractIncomeAnalysisByComp(AnalysisCommonDTO commonDTO) { List contractIncomeAnalysisVoList = contractMapper.contractIncomeAnalysisByComp(commonDTO, SecurityUtils.getUser().getCompId()); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractAmountAnalysisByArea(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("company_area"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("地区字典分类获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = items.stream().map(item -> { ContractIncomeAnalysisAreaVo analysisAreaVo = new ContractIncomeAnalysisAreaVo(); analysisAreaVo.setAreaId(item.getItemValue()); analysisAreaVo.setAreaName(item.getLabel()); return analysisAreaVo; }).collect(Collectors.toList()); List statisticList = contractMapper.contractAmountAnalysisByArea(commonDTO , compIds, Long.valueOf(smj), Long.valueOf(sgb), Long.valueOf(jxc), Long.valueOf(tfgs), Long.valueOf(ymj)); contractIncomeAnalysisVoList.stream().forEach(vo1 -> { statisticList.stream().forEach(vo2 -> { if (StrUtil.equals(vo1.getAreaId(), vo2.getAreaId())) { vo1.setJxczb(vo2.getJxczb()); vo1.setJxcze(vo2.getJxcze()); vo1.setSgbzb(vo2.getSgbzb()); vo1.setSgbze(vo2.getSgbze()); vo1.setSmjzb(vo2.getSmjzb()); vo1.setSmjze(vo2.getSmjze()); vo1.setTfzb(vo2.getTfzb()); vo1.setTfze(vo2.getTfze()); vo1.setYmjzb(vo2.getYmjzb()); vo1.setYmjze(vo2.getYmjze()); } }); }); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractAmountAnalysisByIndustry(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("industry_sector"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("行业字典分类获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = items.stream().map(item -> { ContractIncomeAnalysisAreaVo analysisAreaVo = new ContractIncomeAnalysisAreaVo(); analysisAreaVo.setAreaId(item.getItemValue()); analysisAreaVo.setAreaName(item.getLabel()); return analysisAreaVo; }).collect(Collectors.toList()); List statisticList = contractMapper.contractAmountAnalysisByIndustry(commonDTO , compIds, Long.valueOf(smj), Long.valueOf(sgb), Long.valueOf(jxc), Long.valueOf(tfgs), Long.valueOf(ymj)); contractIncomeAnalysisVoList.stream().forEach(vo1 -> { statisticList.stream().forEach(vo2 -> { if (StrUtil.equals(vo1.getAreaId(), vo2.getAreaId())) { vo1.setJxczb(vo2.getJxczb()); vo1.setJxcze(vo2.getJxcze()); vo1.setSgbzb(vo2.getSgbzb()); vo1.setSgbze(vo2.getSgbze()); vo1.setSmjzb(vo2.getSmjzb()); vo1.setSmjze(vo2.getSmjze()); vo1.setTfzb(vo2.getTfzb()); vo1.setTfze(vo2.getTfze()); vo1.setYmjzb(vo2.getYmjzb()); vo1.setYmjze(vo2.getYmjze()); } }); }); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractAmountAnalysisByMarket(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("market_type"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("市场类型字典分类获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = items.stream().map(item -> { ContractIncomeAnalysisAreaVo analysisAreaVo = new ContractIncomeAnalysisAreaVo(); analysisAreaVo.setAreaId(item.getItemValue()); analysisAreaVo.setAreaName(item.getLabel()); return analysisAreaVo; }).collect(Collectors.toList()); List statisticList = contractMapper.contractAmountAnalysisByMarket(commonDTO , compIds, Long.valueOf(smj), Long.valueOf(sgb), Long.valueOf(jxc), Long.valueOf(tfgs), Long.valueOf(ymj)); contractIncomeAnalysisVoList.stream().forEach(vo1 -> { statisticList.stream().forEach(vo2 -> { if (StrUtil.equals(vo1.getAreaId(), vo2.getAreaId())) { vo1.setJxczb(vo2.getJxczb()); vo1.setJxcze(vo2.getJxcze()); vo1.setSgbzb(vo2.getSgbzb()); vo1.setSgbze(vo2.getSgbze()); vo1.setSmjzb(vo2.getSmjzb()); vo1.setSmjze(vo2.getSmjze()); vo1.setTfzb(vo2.getTfzb()); vo1.setTfze(vo2.getTfze()); vo1.setYmjzb(vo2.getYmjzb()); vo1.setYmjze(vo2.getYmjze()); } }); }); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractAmountAnalysisBySpcBus(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("supply_attribute"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("供应属性字典分类获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = items.stream().map(item -> { ContractIncomeAnalysisAreaVo analysisAreaVo = new ContractIncomeAnalysisAreaVo(); analysisAreaVo.setAreaId(item.getItemValue()); analysisAreaVo.setAreaName(item.getLabel()); return analysisAreaVo; }).collect(Collectors.toList()); List statisticList = contractMapper.contractAmountAnalysisBySpcBus(commonDTO , compIds, Long.valueOf(smj), Long.valueOf(sgb), Long.valueOf(jxc), Long.valueOf(tfgs), Long.valueOf(ymj)); contractIncomeAnalysisVoList.stream().forEach(vo1 -> { statisticList.stream().forEach(vo2 -> { if (StrUtil.equals(vo1.getAreaId(), vo2.getAreaId())) { vo1.setJxczb(vo2.getJxczb()); vo1.setJxcze(vo2.getJxcze()); vo1.setSgbzb(vo2.getSgbzb()); vo1.setSgbze(vo2.getSgbze()); vo1.setSmjzb(vo2.getSmjzb()); vo1.setSmjze(vo2.getSmjze()); vo1.setTfzb(vo2.getTfzb()); vo1.setTfze(vo2.getTfze()); vo1.setYmjzb(vo2.getYmjzb()); vo1.setYmjze(vo2.getYmjze()); } }); }); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractAmountAnalysisByExportBus(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("export_attr"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("区域字段获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = items.stream().map(item -> { ContractIncomeAnalysisAreaVo analysisAreaVo = new ContractIncomeAnalysisAreaVo(); analysisAreaVo.setAreaId(item.getItemValue()); analysisAreaVo.setAreaName(item.getLabel()); return analysisAreaVo; }).collect(Collectors.toList()); List statisticList = contractMapper.contractAmountAnalysisByExportBus(commonDTO , compIds, Long.valueOf(smj), Long.valueOf(sgb), Long.valueOf(jxc), Long.valueOf(tfgs), Long.valueOf(ymj)); contractIncomeAnalysisVoList.stream().forEach(vo1 -> { statisticList.stream().forEach(vo2 -> { if (StrUtil.equals(vo1.getAreaId(), vo2.getAreaId())) { vo1.setJxczb(vo2.getJxczb()); vo1.setJxcze(vo2.getJxcze()); vo1.setSgbzb(vo2.getSgbzb()); vo1.setSgbze(vo2.getSgbze()); vo1.setSmjzb(vo2.getSmjzb()); vo1.setSmjze(vo2.getSmjze()); vo1.setTfzb(vo2.getTfzb()); vo1.setTfze(vo2.getTfze()); vo1.setYmjzb(vo2.getYmjzb()); vo1.setYmjze(vo2.getYmjze()); } }); }); return R.ok(contractIncomeAnalysisVoList); } @Override public R contractAmountAnalysisBySaleModel(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("sales_model"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("销售模式字典分类获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List contractIncomeAnalysisVoList = items.stream().map(item -> { ContractIncomeAnalysisAreaVo analysisAreaVo = new ContractIncomeAnalysisAreaVo(); analysisAreaVo.setAreaId(item.getItemValue()); analysisAreaVo.setAreaName(item.getLabel()); return analysisAreaVo; }).collect(Collectors.toList()); contractMapper.setSession(); List statisticList = contractMapper.contractAmountAnalysisBySaleModel(commonDTO , compIds, Long.valueOf(smj), Long.valueOf(sgb), Long.valueOf(jxc), Long.valueOf(tfgs), Long.valueOf(ymj)); contractIncomeAnalysisVoList.stream().forEach(vo1 -> { statisticList.stream().forEach(vo2 -> { if (StrUtil.equals(vo1.getAreaId(), vo2.getAreaId())) { vo1.setJxczb(vo2.getJxczb()); vo1.setJxcze(vo2.getJxcze()); vo1.setSgbzb(vo2.getSgbzb()); vo1.setSgbze(vo2.getSgbze()); vo1.setSmjzb(vo2.getSmjzb()); vo1.setSmjze(vo2.getSmjze()); vo1.setTfzb(vo2.getTfzb()); vo1.setTfze(vo2.getTfze()); vo1.setYmjzb(vo2.getYmjzb()); vo1.setYmjze(vo2.getYmjze()); } }); }); return R.ok(contractIncomeAnalysisVoList); } @Override public R agingAnalysisByArea(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("company_area"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("地区字典分类获取异常"); } // List companys = contractPaymentScheduleMapper.selectAgingCompany(DataScope.of("comp_id")); // if (CollUtil.isEmpty(companys)){ // return R.failed("暂无账龄"); // } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List result = new ArrayList<>(); AgingQueryDTO queryDTO = new AgingQueryDTO(); if (CollUtil.contains(compIds, SecurityUtils.getUser().getCompId())) { queryDTO.setCompanyId(SecurityUtils.getUser().getCompId()); } List agingVoList = contractPaymentScheduleMapper.selectAgingTotal(queryDTO); items.stream().forEach(item -> { AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName(item.getLabel()); queryDTO.setAreaId(item.getItemValue()); List companyAgingVo = contractPaymentScheduleMapper.selectAgingTotal(queryDTO); //补全数据 if (CollUtil.isEmpty(companyAgingVo)) { companyAgingVo = new ArrayList<>(); AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); companyAgingVo.add(agingVo2); companyAgingVo.add(agingVo3); companyAgingVo.add(agingVo4); companyAgingVo.add(agingVo5); companyAgingVo.add(agingVo6); } else { List overdueRanges = companyAgingVo.stream().map(AgingVo::getOverdueRange).collect(Collectors.toList()); if (!CollUtil.contains(overdueRanges, "0-30天")) { AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); } if (!CollUtil.contains(overdueRanges, "31-60天")) { AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); companyAgingVo.add(agingVo2); } if (!CollUtil.contains(overdueRanges, "61-90天")) { AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); companyAgingVo.add(agingVo3); } if (!CollUtil.contains(overdueRanges, "91-180天")) { AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); companyAgingVo.add(agingVo4); } if (!CollUtil.contains(overdueRanges, "181-365天")) { AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); companyAgingVo.add(agingVo5); } if (!CollUtil.contains(overdueRanges, "1年以上")) { AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo6); } } companyAgingVo.sort(Comparator.comparing(AgingVo::getSort)); agingAnalysisVo.setAmount(companyAgingVo.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List finalCompanyAgingVo = companyAgingVo; agingAnalysisVo.setPercent(IntStream.range(0, agingVoList.size()) .mapToObj(i -> { BigDecimal part = finalCompanyAgingVo.get(i).getTotalAmount(); BigDecimal total = agingVoList.get(i).getTotalAmount(); if (total == null || total.compareTo(BigDecimal.ZERO) == 0) { return null; } return part.divide(total, 4, RoundingMode.HALF_UP) .multiply(new BigDecimal("100")) .setScale(2, RoundingMode.HALF_UP); }) .collect(Collectors.toList())); result.add(agingAnalysisVo); }); //合计 AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName("合计"); agingAnalysisVo.setAmount(agingVoList.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List percent = IntStream.range(0, agingAnalysisVo.getAmount().size()) .mapToObj(i -> { if (agingAnalysisVo.getAmount().get(i) == null || agingAnalysisVo.getAmount().get(i).compareTo(BigDecimal.ZERO) == 0) { return null; } else { return new BigDecimal("100"); } }) .collect(Collectors.toList()); agingAnalysisVo.setPercent(percent); result.add(agingAnalysisVo); return R.ok(result); } @Override public R agingAnalysisByIndustry(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("industry_sector"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("行业字典分类获取异常"); } List compIds = new ArrayList<>(); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(jxc)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); List result = new ArrayList<>(); AgingQueryDTO queryDTO = new AgingQueryDTO(); if (CollUtil.contains(compIds, SecurityUtils.getUser().getCompId())) { queryDTO.setCompanyId(SecurityUtils.getUser().getCompId()); } List agingVoList = contractPaymentScheduleMapper.selectAgingTotal(queryDTO); items.stream().forEach(item -> { AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName(item.getLabel()); queryDTO.setIndustryId(item.getItemValue()); List companyAgingVo = contractPaymentScheduleMapper.selectAgingTotal(queryDTO); //补全数据 if (CollUtil.isEmpty(companyAgingVo)) { companyAgingVo = new ArrayList<>(); AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); companyAgingVo.add(agingVo2); companyAgingVo.add(agingVo3); companyAgingVo.add(agingVo4); companyAgingVo.add(agingVo5); companyAgingVo.add(agingVo6); } else { List overdueRanges = companyAgingVo.stream().map(AgingVo::getOverdueRange).collect(Collectors.toList()); if (!CollUtil.contains(overdueRanges, "0-30天")) { AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); } if (!CollUtil.contains(overdueRanges, "31-60天")) { AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); companyAgingVo.add(agingVo2); } if (!CollUtil.contains(overdueRanges, "61-90天")) { AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); companyAgingVo.add(agingVo3); } if (!CollUtil.contains(overdueRanges, "91-180天")) { AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); companyAgingVo.add(agingVo4); } if (!CollUtil.contains(overdueRanges, "181-365天")) { AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); companyAgingVo.add(agingVo5); } if (!CollUtil.contains(overdueRanges, "1年以上")) { AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo6); } } companyAgingVo.sort(Comparator.comparing(AgingVo::getSort)); agingAnalysisVo.setAmount(companyAgingVo.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List finalCompanyAgingVo = companyAgingVo; agingAnalysisVo.setPercent(IntStream.range(0, agingVoList.size()) .mapToObj(i -> { BigDecimal part = finalCompanyAgingVo.get(i).getTotalAmount(); BigDecimal total = agingVoList.get(i).getTotalAmount(); if (total == null || total.compareTo(BigDecimal.ZERO) == 0) { return null; } return part.divide(total, 4, RoundingMode.HALF_UP) .multiply(new BigDecimal("100")) .setScale(2, RoundingMode.HALF_UP); }) .collect(Collectors.toList())); result.add(agingAnalysisVo); }); //合计 AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName("合计"); agingAnalysisVo.setAmount(agingVoList.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List percent = IntStream.range(0, agingAnalysisVo.getAmount().size()) .mapToObj(i -> { if (agingAnalysisVo.getAmount().get(i) == null || agingAnalysisVo.getAmount().get(i).compareTo(BigDecimal.ZERO) == 0) { return null; } else { return new BigDecimal("100"); } }) .collect(Collectors.toList()); agingAnalysisVo.setPercent(percent); result.add(agingAnalysisVo); return R.ok(result); } @Override public R agingAnalysis(AnalysisCommonDTO commonDTO) { if (commonDTO.getAgingType().equals("2")) { List compIds = new ArrayList<>(); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(jxc)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); List result = new ArrayList<>(); AgingQueryDTO queryDTO = new AgingQueryDTO(); List agingVoList = contractPaymentScheduleMapper.selectAgingTotalShip(null); compIds.stream().forEach(compId -> { R r = remoteDeptService.getById(compId); if (!r.isOk()) { return; } SysDept dept = r.getData(); AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName(dept.getName()); queryDTO.setCompanyId(dept.getDeptId()); List companyAgingVo = contractPaymentScheduleMapper.selectAgingTotalShip(queryDTO); //补全数据 if (CollUtil.isEmpty(companyAgingVo)) { companyAgingVo = new ArrayList<>(); AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); companyAgingVo.add(agingVo2); companyAgingVo.add(agingVo3); companyAgingVo.add(agingVo4); companyAgingVo.add(agingVo5); companyAgingVo.add(agingVo6); } else { List overdueRanges = companyAgingVo.stream().map(AgingVo::getOverdueRange).collect(Collectors.toList()); if (!CollUtil.contains(overdueRanges, "0-30天")) { AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); } if (!CollUtil.contains(overdueRanges, "31-60天")) { AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); companyAgingVo.add(agingVo2); } if (!CollUtil.contains(overdueRanges, "61-90天")) { AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); companyAgingVo.add(agingVo3); } if (!CollUtil.contains(overdueRanges, "91-180天")) { AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); companyAgingVo.add(agingVo4); } if (!CollUtil.contains(overdueRanges, "181-365天")) { AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); companyAgingVo.add(agingVo5); } if (!CollUtil.contains(overdueRanges, "1年以上")) { AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo6); } } companyAgingVo.sort(Comparator.comparing(AgingVo::getSort)); agingAnalysisVo.setAmount(companyAgingVo.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List finalCompanyAgingVo = companyAgingVo; agingAnalysisVo.setPercent(IntStream.range(0, agingVoList.size()) .mapToObj(i -> { BigDecimal part = finalCompanyAgingVo.get(i).getTotalAmount(); BigDecimal total = agingVoList.get(i).getTotalAmount(); if (total == null || total.compareTo(BigDecimal.ZERO) == 0) { return null; } return part.divide(total, 4, RoundingMode.HALF_UP) .multiply(new BigDecimal("100")) .setScale(2, RoundingMode.HALF_UP); }) .collect(Collectors.toList())); result.add(agingAnalysisVo); }); //合计 AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName("合计"); agingAnalysisVo.setAmount(agingVoList.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List percent = IntStream.range(0, agingAnalysisVo.getAmount().size()) .mapToObj(i -> { if (agingAnalysisVo.getAmount().get(i) == null || agingAnalysisVo.getAmount().get(i).compareTo(BigDecimal.ZERO) == 0) { return null; } else { return new BigDecimal("100"); } }) .collect(Collectors.toList()); agingAnalysisVo.setPercent(percent); result.add(agingAnalysisVo); return R.ok(result); } if (commonDTO.getAgingType().equals("3")) { List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); List result = new ArrayList<>(); AgingQueryDTO queryDTO = new AgingQueryDTO(); List agingVoList = contractPaymentScheduleMapper.selectAgingTotalInvoice(null); compIds.stream().forEach(compId -> { R r = remoteDeptService.getById(compId); if (!r.isOk()) { return; } SysDept dept = r.getData(); AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName(dept.getName()); queryDTO.setCompanyId(dept.getDeptId()); List companyAgingVo = contractPaymentScheduleMapper.selectAgingTotalInvoice(queryDTO); //补全数据 if (CollUtil.isEmpty(companyAgingVo)) { companyAgingVo = new ArrayList<>(); AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); companyAgingVo.add(agingVo2); companyAgingVo.add(agingVo3); companyAgingVo.add(agingVo4); companyAgingVo.add(agingVo5); companyAgingVo.add(agingVo6); } else { List overdueRanges = companyAgingVo.stream().map(AgingVo::getOverdueRange).collect(Collectors.toList()); if (!CollUtil.contains(overdueRanges, "0-30天")) { AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); } if (!CollUtil.contains(overdueRanges, "31-60天")) { AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); companyAgingVo.add(agingVo2); } if (!CollUtil.contains(overdueRanges, "61-90天")) { AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); companyAgingVo.add(agingVo3); } if (!CollUtil.contains(overdueRanges, "91-180天")) { AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); companyAgingVo.add(agingVo4); } if (!CollUtil.contains(overdueRanges, "181-365天")) { AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); companyAgingVo.add(agingVo5); } if (!CollUtil.contains(overdueRanges, "1年以上")) { AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo6); } } companyAgingVo.sort(Comparator.comparing(AgingVo::getSort)); agingAnalysisVo.setAmount(companyAgingVo.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List finalCompanyAgingVo = companyAgingVo; agingAnalysisVo.setPercent(IntStream.range(0, agingVoList.size()) .mapToObj(i -> { BigDecimal part = finalCompanyAgingVo.get(i).getTotalAmount(); BigDecimal total = agingVoList.get(i).getTotalAmount(); if (total == null || total.compareTo(BigDecimal.ZERO) == 0) { return null; } return part.divide(total, 4, RoundingMode.HALF_UP) .multiply(new BigDecimal("100")) .setScale(2, RoundingMode.HALF_UP); }) .collect(Collectors.toList())); result.add(agingAnalysisVo); }); //合计 AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName("合计"); agingAnalysisVo.setAmount(agingVoList.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List percent = IntStream.range(0, agingAnalysisVo.getAmount().size()) .mapToObj(i -> { if (agingAnalysisVo.getAmount().get(i) == null || agingAnalysisVo.getAmount().get(i).compareTo(BigDecimal.ZERO) == 0) { return null; } else { return new BigDecimal("100"); } }) .collect(Collectors.toList()); agingAnalysisVo.setPercent(percent); result.add(agingAnalysisVo); return R.ok(result); } return R.ok(); } @Override public R agingAnalysisByMarket(AnalysisCommonDTO commonDTO) { R> r = remoteDictService.getDictByType("market_type"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("市场类型字典分类获取异常"); } List result = new ArrayList<>(); AgingQueryDTO queryDTO = new AgingQueryDTO(); List agingVoList = contractPaymentScheduleMapper.selectAgingTotal(null); items.stream().forEach(item -> { AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName(item.getLabel()); queryDTO.setClassId(item.getItemValue()); List companyAgingVo = contractPaymentScheduleMapper.selectAgingTotal(queryDTO); //补全数据 if (CollUtil.isEmpty(companyAgingVo)) { companyAgingVo = new ArrayList<>(); AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); companyAgingVo.add(agingVo2); companyAgingVo.add(agingVo3); companyAgingVo.add(agingVo4); companyAgingVo.add(agingVo5); companyAgingVo.add(agingVo6); } else { List overdueRanges = companyAgingVo.stream().map(AgingVo::getOverdueRange).collect(Collectors.toList()); if (!CollUtil.contains(overdueRanges, "0-30天")) { AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); } if (!CollUtil.contains(overdueRanges, "31-60天")) { AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); companyAgingVo.add(agingVo2); } if (!CollUtil.contains(overdueRanges, "61-90天")) { AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); companyAgingVo.add(agingVo3); } if (!CollUtil.contains(overdueRanges, "91-180天")) { AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); companyAgingVo.add(agingVo4); } if (!CollUtil.contains(overdueRanges, "181-365天")) { AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); companyAgingVo.add(agingVo5); } if (!CollUtil.contains(overdueRanges, "1年以上")) { AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo6); } } companyAgingVo.sort(Comparator.comparing(AgingVo::getSort)); agingAnalysisVo.setAmount(companyAgingVo.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List finalCompanyAgingVo = companyAgingVo; agingAnalysisVo.setPercent(IntStream.range(0, agingVoList.size()) .mapToObj(i -> { BigDecimal part = finalCompanyAgingVo.get(i).getTotalAmount(); BigDecimal total = agingVoList.get(i).getTotalAmount(); if (total == null || total.compareTo(BigDecimal.ZERO) == 0) { return null; } return part.divide(total, 4, RoundingMode.HALF_UP) .multiply(new BigDecimal("100")) .setScale(2, RoundingMode.HALF_UP); }) .collect(Collectors.toList())); result.add(agingAnalysisVo); }); //合计 AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName("合计"); agingAnalysisVo.setAmount(agingVoList.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List percent = IntStream.range(0, agingAnalysisVo.getAmount().size()) .mapToObj(i -> { if (agingAnalysisVo.getAmount().get(i) == null || agingAnalysisVo.getAmount().get(i).compareTo(BigDecimal.ZERO) == 0) { return null; } else { return new BigDecimal("100"); } }) .collect(Collectors.toList()); agingAnalysisVo.setPercent(percent); result.add(agingAnalysisVo); return R.ok(result); } @Override public R agingAnalysisTotalScale(AnalysisCommonDTO commonDTO) { List compIds = new ArrayList<>(); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(jxc)); compIds.add(Long.valueOf(ymj)); List result = new ArrayList<>(); AgingQueryDTO queryDTO = new AgingQueryDTO(); List agingVoList = contractPaymentScheduleMapper.selectAgingTotalScale(null); compIds.stream().forEach(compId -> { R r = remoteDeptService.getById(compId); if (!r.isOk()) { return; } SysDept dept = r.getData(); AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName(dept.getName()); queryDTO.setCompanyId(dept.getDeptId()); List companyAgingVo = contractPaymentScheduleMapper.selectAgingTotalScale(queryDTO); //补全数据 if (CollUtil.isEmpty(companyAgingVo)) { companyAgingVo = new ArrayList<>(); AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); companyAgingVo.add(agingVo2); companyAgingVo.add(agingVo3); companyAgingVo.add(agingVo4); companyAgingVo.add(agingVo5); companyAgingVo.add(agingVo6); } else { List overdueRanges = companyAgingVo.stream().map(AgingVo::getOverdueRange).collect(Collectors.toList()); if (!CollUtil.contains(overdueRanges, "0-30天")) { AgingVo agingVo1 = new AgingVo(1L, "0-30天", new BigDecimal("0"), null); companyAgingVo.add(agingVo1); } if (!CollUtil.contains(overdueRanges, "31-60天")) { AgingVo agingVo2 = new AgingVo(2L, "31-60天", new BigDecimal("0"), null); companyAgingVo.add(agingVo2); } if (!CollUtil.contains(overdueRanges, "61-90天")) { AgingVo agingVo3 = new AgingVo(3L, "61-90天", new BigDecimal("0"), null); companyAgingVo.add(agingVo3); } if (!CollUtil.contains(overdueRanges, "91-180天")) { AgingVo agingVo4 = new AgingVo(4L, "91-180天", new BigDecimal("0"), null); companyAgingVo.add(agingVo4); } if (!CollUtil.contains(overdueRanges, "181-365天")) { AgingVo agingVo5 = new AgingVo(5L, "181-365天", new BigDecimal("0"), null); companyAgingVo.add(agingVo5); } if (!CollUtil.contains(overdueRanges, "1年以上")) { AgingVo agingVo6 = new AgingVo(6L, "1年以上", new BigDecimal("0"), null); companyAgingVo.add(agingVo6); } } companyAgingVo.sort(Comparator.comparing(AgingVo::getSort)); agingAnalysisVo.setAmount(companyAgingVo.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List finalCompanyAgingVo = companyAgingVo; agingAnalysisVo.setPercent(IntStream.range(0, agingVoList.size()) .mapToObj(i -> { BigDecimal part = finalCompanyAgingVo.get(i).getTotalAmount(); BigDecimal total = agingVoList.get(i).getTotalAmount(); if (total == null || total.compareTo(BigDecimal.ZERO) == 0) { return null; } return part.divide(total, 4, RoundingMode.HALF_UP) .multiply(new BigDecimal("100")) .setScale(2, RoundingMode.HALF_UP); }) .collect(Collectors.toList())); result.add(agingAnalysisVo); }); //合计 AgingAnalysisVo agingAnalysisVo = new AgingAnalysisVo(); agingAnalysisVo.setCompanyName("合计"); agingAnalysisVo.setAmount(agingVoList.stream().map(AgingVo::getTotalAmount).collect(Collectors.toList())); List percent = IntStream.range(0, agingAnalysisVo.getAmount().size()) .mapToObj(i -> { if (agingAnalysisVo.getAmount().get(i) == null || agingAnalysisVo.getAmount().get(i).compareTo(BigDecimal.ZERO) == 0) { return null; } else { return new BigDecimal("100"); } }) .collect(Collectors.toList()); agingAnalysisVo.setPercent(percent); result.add(agingAnalysisVo); return R.ok(result); } @Override public R homeZbjtChart(HomeZbjtDTO queryDTO) { if (StrUtil.isBlank(queryDTO.getType())) { return R.failed("请传type"); } JSONObject result = new JSONObject(); HomeZbjtVo kp = contractInvoiceMapper.homeZbjt(); result.put("chart-sr", handleChart(kp, queryDTO.getType())); HomeZbjtVo hk = paymentSlipMapper.homeZbjt(); result.put("chart-hk", handleChart(hk, queryDTO.getType())); HomeZbjtVo htqd = contractMapper.homeZbjt(); result.put("chart-ht", handleChart(htqd, queryDTO.getType())); return R.ok(result); } // private JSONArray handleTable(HomeZbjtVo kp, String type) { // kp.calcZbjt(kp); // JSONArray array = new JSONArray(); // if (StrUtil.equals(type, "1")) { // JSONObject smj = new JSONObject(); // smj.put("name", "石煤机"); // smj.put("lj", kp.getSmjby() == null ? BigDecimal.ZERO : kp.getSmjby()); // smj.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbby()) && kp.getZbby().compareTo(new BigDecimal("0")) > 0) { // smj.put("zb", smj.getBigDecimal("lj").divide(kp.getZbby(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // smj.put("tb", ""); // array.add(smj); // JSONObject sgb = new JSONObject(); // sgb.put("name", "石工泵"); // sgb.put("lj", kp.getSgbby() == null ? BigDecimal.ZERO : kp.getSgbby()); // sgb.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbby()) && kp.getZbby().compareTo(new BigDecimal("0")) > 0) { // sgb.put("zb", sgb.getBigDecimal("lj").divide(kp.getZbby(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // sgb.put("tb", ""); // array.add(sgb); // JSONObject tf = new JSONObject(); // tf.put("name", "通方公司"); // tf.put("lj", kp.getTfby() == null ? BigDecimal.ZERO : kp.getTfby()); // tf.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbby()) && kp.getZbby().compareTo(new BigDecimal("0")) > 0) { // tf.put("zb", tf.getBigDecimal("lj").divide(kp.getZbby(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // // tf.put("tb", ""); // array.add(tf); // JSONObject jxc = new JSONObject(); // jxc.put("name", "机械厂"); // jxc.put("lj", kp.getJxcby() == null ? BigDecimal.ZERO : kp.getJxcby()); // // jxc.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbby()) && kp.getZbby().compareTo(new BigDecimal("0")) > 0) { // jxc.put("zb", jxc.getBigDecimal("lj").divide(kp.getZbby(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // jxc.put("tb", ""); // array.add(jxc); // JSONObject ymj = new JSONObject(); // ymj.put("name", "一煤机"); // ymj.put("lj", kp.getYmjby() == null ? BigDecimal.ZERO : kp.getYmjby()); // ymj.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbby()) && kp.getZbby().compareTo(new BigDecimal("0")) > 0) { // ymj.put("zb", ymj.getBigDecimal("lj").divide(kp.getZbby(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // // ymj.put("tb", ""); // array.add(ymj); // } // if (StrUtil.equals(type, "2")) { // JSONObject smj = new JSONObject(); // smj.put("name", "石煤机"); // smj.put("lj", kp.getSmjbn() == null ? BigDecimal.ZERO : kp.getSmjbn()); // smj.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbbn()) && kp.getZbbn().compareTo(new BigDecimal("0")) > 0) { // smj.put("zb", smj.getBigDecimal("lj").divide(kp.getZbbn(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // smj.put("tb", ""); // array.add(smj); // JSONObject sgb = new JSONObject(); // sgb.put("name", "石工泵"); // sgb.put("lj", kp.getSgbbn() == null ? BigDecimal.ZERO : kp.getSgbbn()); // sgb.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbbn()) && kp.getZbbn().compareTo(new BigDecimal("0")) > 0) { // sgb.put("zb", sgb.getBigDecimal("lj").divide(kp.getZbbn(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // sgb.put("tb", ""); // array.add(sgb); // JSONObject tf = new JSONObject(); // tf.put("name", "通方公司"); // tf.put("lj", kp.getTfbn() == null ? BigDecimal.ZERO : kp.getTfbn()); // tf.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbbn()) && kp.getZbbn().compareTo(new BigDecimal("0")) > 0) { // tf.put("zb", tf.getBigDecimal("lj").divide(kp.getZbbn(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // tf.put("tb", ""); // array.add(tf); // JSONObject jxc = new JSONObject(); // jxc.put("name", "机械厂"); // jxc.put("lj", kp.getJxcbn() == null ? BigDecimal.ZERO : kp.getJxcbn()); // jxc.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbbn()) && kp.getZbbn().compareTo(new BigDecimal("0")) > 0) { // jxc.put("zb", jxc.getBigDecimal("lj").divide(kp.getZbbn(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // jxc.put("tb", ""); // array.add(jxc); // JSONObject ymj = new JSONObject(); // ymj.put("name", "一煤机"); // ymj.put("lj", kp.getYmjbn() == null ? BigDecimal.ZERO : kp.getYmjbn()); // ymj.put("zb", ""); // if (ObjUtil.isNotNull(kp.getZbbn()) && kp.getZbbn().compareTo(new BigDecimal("0")) > 0) { // ymj.put("zb", ymj.getBigDecimal("lj").divide(kp.getZbbn(), 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // ymj.put("tb", ""); // array.add(ymj); // } // return array; // } private List handleChart(HomeZbjtVo htqd, String type) { if (StrUtil.equals(type, "1")) { List srList = new ArrayList<>(); srList.add(htqd.getSmjby() == null ? BigDecimal.ZERO : htqd.getSmjby()); srList.add(htqd.getSgbby() == null ? BigDecimal.ZERO : htqd.getSgbby()); srList.add(htqd.getTfby() == null ? BigDecimal.ZERO : htqd.getTfby()); srList.add(htqd.getJxcby() == null ? BigDecimal.ZERO : htqd.getJxcby()); srList.add(htqd.getYmjby() == null ? BigDecimal.ZERO : htqd.getYmjby()); return srList; } if (StrUtil.equals(type, "2")) { List srList = new ArrayList<>(); srList.add(htqd.getSmjbn() == null ? BigDecimal.ZERO : htqd.getSmjbn()); srList.add(htqd.getSgbbn() == null ? BigDecimal.ZERO : htqd.getSgbbn()); srList.add(htqd.getTfbn() == null ? BigDecimal.ZERO : htqd.getTfbn()); srList.add(htqd.getJxcbn() == null ? BigDecimal.ZERO : htqd.getJxcbn()); srList.add(htqd.getYmjbn() == null ? BigDecimal.ZERO : htqd.getYmjbn()); return srList; } return null; } @Override public R homeZbjt() { // List homeZbjtVoList = new ArrayList<>(); // String curYear = DateUtil.year(new Date()) + ""; // String curMonth = DateUtil.month(new Date()) + ""; //出货 // HomeZbjtVo ch = contractOutBoundMapper.homeZbjt(); // homeZbjtVoList.add(ch); //只保留销售收入 回款 新增合同 //开票 // HomeZbjtVo kp = contractInvoiceMapper.homeZbjt(); // kp.calcZbjt(kp); // // kp = handleWCAndTB("2", curMonth, curYear, kp); // // homeZbjtVoList.add(kp); //回款 // HomeZbjtVo hk = paymentSlipMapper.homeZbjt(); // hk.calcZbjt(hk); // hk = handleWCAndTB("3", curMonth, curYear, hk); // // homeZbjtVoList.add(hk); //合同签订 sgb smj jxc tfgs ymj // HomeZbjtVo htqd = contractMapper.homeZbjt(); // htqd.calcZbjt(htqd); // hk = handleWCAndTB("1", curMonth, curYear, htqd); // homeZbjtVoList.add(htqd); //赊销产生值 今天发货加今天开票额 // if (ObjUtil.isNotNull(ch)&&ObjUtil.isNotNull(kp)){ // HomeZbjtVo sxsy = ch.add(kp); // homeZbjtVoList.add(sxsy); // }else if (ObjUtil.isNotNull(ch)&&ObjUtil.isNull(kp)){ // homeZbjtVoList.add(ch); // }else if (ObjUtil.isNull(ch)&&ObjUtil.isNotNull(kp)){ // homeZbjtVoList.add(kp); // }else { // homeZbjtVoList.add(new HomeZbjtVo()); // } //赊销累计剩余值 今日发货且没开票的出货 // HomeZbjtVo sx = contractOutBoundMapper.homeZbjtSX(); // homeZbjtVoList.add(sx); // HomeZbjtVo yq = currentOverdueMapper.homeZbjt(); // //逾期累计剩余 今日产生逾期 含历史 // HomeZbjtVo ls = historyOverdueMapper.homeZbjt(); // if (ObjUtil.isNotNull(ls)&&ObjUtil.isNotNull(yq)){ // homeZbjtVoList.add(yq.add(ls)); // }else if (ObjUtil.isNotNull(ls)&&ObjUtil.isNull(yq)){ // homeZbjtVoList.add(ls); // }else if (ObjUtil.isNull(ls)&&ObjUtil.isNotNull(yq)){ // homeZbjtVoList.add(yq); // }else { // homeZbjtVoList.add(new HomeZbjtVo()); // } // //逾期产生值 今天产生-今天已付 // // homeZbjtVoList.add(yq); return R.ok(); } private HomeZbjtVo handleWCAndTB(String planType, String curMonth, String curYear, HomeZbjtVo kp) { List compIds = new ArrayList<>(); compIds.add(2089995177814495234L); compIds.add(2089996921978040321L); compIds.add(2089997578009128962L); compIds.add(2101966257365045249L); //装备 // AnnualPlanTotalVo planListZB = annualPlanMapper.selectPlanYear(curYear, planType); // if (ObjUtil.isNotNull(planListZB)) { // AnnualPlanTotalVo planzb = BeanUtil.copyProperties(planListZB, AnnualPlanTotalVo.class); // BigDecimal curMonAmount = planzb.getMonthAmount(curMonth); // if (ObjUtil.isNotNull(kp.getZbby()) && kp.getZbby().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getZbby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // BigDecimal yearAmount = planzb.getTotalAmount(); // if (ObjUtil.isNotNull(kp.getZbbn()) && kp.getZbbn().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getZbbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .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")); // if (ObjUtil.isNotNull(planListSMJ)) { // AnnualPlanTotalVo plansmj = BeanUtil.copyProperties(planListSMJ, AnnualPlanTotalVo.class); // BigDecimal curMonAmount = plansmj.getMonthAmount(curMonth); // if (ObjUtil.isNotNull(kp.getSmjby()) && kp.getSmjby().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getSmjby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // BigDecimal yearAmount = plansmj.getTotalAmount(); // if (ObjUtil.isNotNull(kp.getSmjbn()) && kp.getSmjbn().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getSmjbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // } // //石工泵收入 // 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); // if (ObjUtil.isNotNull(kp.getSgbby()) && kp.getSgbby().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getSgbby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // BigDecimal yearAmount = plansgb.getTotalAmount(); // if (ObjUtil.isNotNull(kp.getSgbbn()) && kp.getSgbbn().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getSgbbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // } // //通方公司收入 // 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); // if (ObjUtil.isNotNull(kp.getTfby()) && kp.getTfby().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getTfby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // BigDecimal yearAmount = plantf.getTotalAmount(); // if (ObjUtil.isNotNull(kp.getTfbn()) && kp.getTfbn().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getTfbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // } // //机械厂收入 // 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); // if (ObjUtil.isNotNull(kp.getJxcby()) && kp.getJxcby().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getJxcby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // BigDecimal yearAmount = planjxc.getTotalAmount(); // if (ObjUtil.isNotNull(kp.getJxcbn()) && kp.getJxcbn().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getJxcbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // } // //一煤机收入 // 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); // if (ObjUtil.isNotNull(kp.getYmjby()) && kp.getYmjby().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getYmjby().divide(curMonAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // BigDecimal yearAmount = planymj.getTotalAmount(); // if (ObjUtil.isNotNull(kp.getYmjbn()) && kp.getYmjbn().compareTo(new BigDecimal("0")) > 0) { // kp.setSmjbywc(kp.getYmjbn().divide(yearAmount, 10, RoundingMode.HALF_UP).multiply(new BigDecimal("100")) // .setScale(2, RoundingMode.HALF_UP) + "%"); // } // } return kp; } @Override public R homeZgs() { List homeZbjtVoList = new ArrayList<>(); // //出货 // HomeZgsVo ch = contractOutBoundMapper.homeZgs(SecurityUtils.getUser().getCompId()); // homeZbjtVoList.add(ch); //开票 HomeZgsVo kp = contractInvoiceMapper.homeZgs(SecurityUtils.getUser().getCompId()); homeZbjtVoList.add(kp); //回款 HomeZgsVo hk = paymentSlipMapper.homeZgs(SecurityUtils.getUser().getCompId()); homeZbjtVoList.add(hk); //合同签订 华北 西北 东北 海外 HomeZgsVo htqd = contractMapper.homeZgs(SecurityUtils.getUser().getCompId()); homeZbjtVoList.add(htqd); //赊销产生值 // if (ObjUtil.isNotNull(ch)&&ObjUtil.isNotNull(kp)){ // HomeZgsVo sxsy = ch.add(kp); // homeZbjtVoList.add(sxsy); // }else if (ObjUtil.isNotNull(ch)&&ObjUtil.isNull(kp)){ // homeZbjtVoList.add(ch); // }else if (ObjUtil.isNull(ch)&&ObjUtil.isNotNull(kp)){ // homeZbjtVoList.add(kp); // }else { // homeZbjtVoList.add(new HomeZgsVo()); // } //赊销累计剩余值 // HomeZgsVo sx = contractOutBoundMapper.homeZgsSX(SecurityUtils.getUser().getCompId()); // homeZbjtVoList.add(sx); // // HomeZgsVo yq = currentOverdueMapper.homeZgs(SecurityUtils.getUser().getCompId()); // // //逾期产生值 // HomeZgsVo ls = historyOverdueMapper.homeZgs(SecurityUtils.getUser().getCompId()); // if (ObjUtil.isNotNull(ls)&&ObjUtil.isNotNull(yq)){ // homeZbjtVoList.add(yq.add(ls)); // }else if (ObjUtil.isNotNull(ls)&&ObjUtil.isNull(yq)){ // homeZbjtVoList.add(ls); // }else if (ObjUtil.isNull(ls)&&ObjUtil.isNotNull(yq)){ // homeZbjtVoList.add(yq); // }else { // homeZbjtVoList.add(new HomeZgsVo()); // } // //逾期累计剩余 // homeZbjtVoList.add(yq); return R.ok(homeZbjtVoList); } @Override public R homeZbjtFlag() { Long userId = SecurityUtils.getUser().getCompId(); List compIds = new ArrayList<>(); compIds.add(Long.valueOf(sgb)); compIds.add(Long.valueOf(smj)); compIds.add(Long.valueOf(tfgs)); compIds.add(Long.valueOf(ymj)); compIds.add(Long.valueOf(jxc)); if (compIds.contains(userId)) { return R.ok(false); } ; return R.ok(true); } @Override public R homeContract(HomeQueryDTO queryDTO) { LocalDateTime now = LocalDateTime.now(); LocalDate today = now.toLocalDate(); // 开始时间:今天 00:00:00 LocalDateTime startOfDay = today.atStartOfDay(); // 结束时间:今天 23:59:59.999999999 (或者使用 nextDay 00:00:00 配合 lt) LocalDateTime endOfDay = today.atTime(LocalTime.MAX); // --- 场景二:查询当月数据 --- // 开始时间:当月1号 00:00:00 LocalDateTime startOfMonth = today.withDayOfMonth(1).atStartOfDay(); // 结束时间:当月最后一天 23:59:59 LocalDateTime endOfMonth = today.withDayOfMonth(today.lengthOfMonth()).atTime(LocalTime.MAX); // 开始时间:当年1月1号 00:00:00 LocalDateTime startOfYear = today.withDayOfYear(1).atStartOfDay(); // 结束时间:当年12月31号 23:59:59 LocalDateTime endOfYear = today.withDayOfYear(today.lengthOfYear()).atTime(LocalTime.MAX); MPJLambdaWrapper wrapper = new MPJLambdaWrapper() .selectAll(Contract.class) .leftJoin(BusinessCustomer.class, BusinessCustomer::getId, Contract::getPartyAId) .eq(ObjUtil.isNotNull(queryDTO.getQueryCompId()), Contract::getCompId, queryDTO.getQueryCompId()) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), Contract::getSignDate, startOfDay) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), Contract::getSignDate, endOfDay) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), Contract::getSignDate, startOfMonth) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), Contract::getSignDate, endOfMonth) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), Contract::getSignDate, startOfYear) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), Contract::getSignDate, endOfYear) .eq(StrUtil.isNotEmpty(queryDTO.getQueryArea()), BusinessCustomer::getAreaId, queryDTO.getQueryArea()) .eq(StrUtil.isNotEmpty(queryDTO.getQueryServiceAttr()), BusinessCustomer::getExportServiceAttr, queryDTO.getQueryServiceAttr()) .orderByDesc(Contract::getCreateTime); return R.ok(contractMapper.selectList(wrapper)); } @Override public R homePaymentSlip(HomeQueryDTO queryDTO) { LocalDateTime now = LocalDateTime.now(); LocalDate today = now.toLocalDate(); // 开始时间:今天 00:00:00 LocalDateTime startOfDay = today.atStartOfDay(); // 结束时间:今天 23:59:59.999999999 (或者使用 nextDay 00:00:00 配合 lt) LocalDateTime endOfDay = today.atTime(LocalTime.MAX); // --- 场景二:查询当月数据 --- // 开始时间:当月1号 00:00:00 LocalDateTime startOfMonth = today.withDayOfMonth(1).atStartOfDay(); // 结束时间:当月最后一天 23:59:59 LocalDateTime endOfMonth = today.withDayOfMonth(today.lengthOfMonth()).atTime(LocalTime.MAX); // 开始时间:当年1月1号 00:00:00 LocalDateTime startOfYear = today.withDayOfYear(1).atStartOfDay(); // 结束时间:当年12月31号 23:59:59 LocalDateTime endOfYear = today.withDayOfYear(today.lengthOfYear()).atTime(LocalTime.MAX); MPJLambdaWrapper wrapper = new MPJLambdaWrapper() .selectAll(PaymentSlip.class) .leftJoin(BusinessCustomer.class, BusinessCustomer::getId, PaymentSlip::getBusGuestId) .eq(ObjUtil.isNotNull(queryDTO.getQueryCompId()), Contract::getCompId, queryDTO.getQueryCompId()) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), PaymentSlip::getPaymentTime, startOfDay) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), PaymentSlip::getPaymentTime, endOfDay) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), PaymentSlip::getPaymentTime, startOfMonth) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), PaymentSlip::getPaymentTime, endOfMonth) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), PaymentSlip::getPaymentTime, startOfYear) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), PaymentSlip::getPaymentTime, endOfYear) .eq(StrUtil.isNotEmpty(queryDTO.getQueryArea()), BusinessCustomer::getAreaId, queryDTO.getQueryArea()) .eq(StrUtil.isNotEmpty(queryDTO.getQueryServiceAttr()), BusinessCustomer::getExportServiceAttr, queryDTO.getQueryServiceAttr()) .orderByDesc(PaymentSlip::getCreateTime); return R.ok(paymentSlipMapper.selectList(wrapper)); } @Override public R homeOutBound(HomeQueryDTO queryDTO) { LocalDateTime now = LocalDateTime.now(); LocalDate today = now.toLocalDate(); // 开始时间:今天 00:00:00 LocalDateTime startOfDay = today.atStartOfDay(); // 结束时间:今天 23:59:59.999999999 (或者使用 nextDay 00:00:00 配合 lt) LocalDateTime endOfDay = today.atTime(LocalTime.MAX); // --- 场景二:查询当月数据 --- // 开始时间:当月1号 00:00:00 LocalDateTime startOfMonth = today.withDayOfMonth(1).atStartOfDay(); // 结束时间:当月最后一天 23:59:59 LocalDateTime endOfMonth = today.withDayOfMonth(today.lengthOfMonth()).atTime(LocalTime.MAX); // 开始时间:当年1月1号 00:00:00 LocalDateTime startOfYear = today.withDayOfYear(1).atStartOfDay(); // 结束时间:当年12月31号 23:59:59 LocalDateTime endOfYear = today.withDayOfYear(today.lengthOfYear()).atTime(LocalTime.MAX); MPJLambdaWrapper wrapper = new MPJLambdaWrapper() .selectAll(ContractOutBound.class) .select(Contract::getContractNo) .selectAs(BusinessCustomer::getCompanyName, "busGuestName") .select(ContractSubjectMatter::getUnitPrice) .leftJoin(Contract.class, Contract::getId, ContractOutBound::getContractId) .leftJoin(BusinessCustomer.class, BusinessCustomer::getId, ContractOutBound::getBusGuestId) .leftJoin(ContractSubjectMatter.class, on -> on.eq(ContractSubjectMatter::getContractId, ContractOutBound::getContractId) .eq(ContractSubjectMatter::getMaterialCode, ContractOutBound::getSubjectMatterCode) ) .eq(ObjUtil.isNotNull(queryDTO.getQueryCompId()), Contract::getCompId, queryDTO.getQueryCompId()) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), ContractOutBound::getOutBoundTime, startOfDay) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), ContractOutBound::getOutBoundTime, endOfDay) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), ContractOutBound::getOutBoundTime, startOfMonth) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), ContractOutBound::getOutBoundTime, endOfMonth) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), ContractOutBound::getOutBoundTime, startOfYear) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), ContractOutBound::getOutBoundTime, endOfYear) .eq(StrUtil.isNotEmpty(queryDTO.getQueryArea()), BusinessCustomer::getAreaId, queryDTO.getQueryArea()) .eq(StrUtil.isNotEmpty(queryDTO.getQueryServiceAttr()), BusinessCustomer::getExportServiceAttr, queryDTO.getQueryServiceAttr()) .orderByDesc(ContractOutBound::getCreateTime); return R.ok(contractOutBoundMapper.selectJoinList(HomeOutBoundVo.class, wrapper)); } @Override public R homeInvoice(HomeQueryDTO queryDTO) { LocalDateTime now = LocalDateTime.now(); LocalDate today = now.toLocalDate(); // 开始时间:今天 00:00:00 LocalDateTime startOfDay = today.atStartOfDay(); // 结束时间:今天 23:59:59.999999999 (或者使用 nextDay 00:00:00 配合 lt) LocalDateTime endOfDay = today.atTime(LocalTime.MAX); // --- 场景二:查询当月数据 --- // 开始时间:当月1号 00:00:00 LocalDateTime startOfMonth = today.withDayOfMonth(1).atStartOfDay(); // 结束时间:当月最后一天 23:59:59 LocalDateTime endOfMonth = today.withDayOfMonth(today.lengthOfMonth()).atTime(LocalTime.MAX); // 开始时间:当年1月1号 00:00:00 LocalDateTime startOfYear = today.withDayOfYear(1).atStartOfDay(); // 结束时间:当年12月31号 23:59:59 LocalDateTime endOfYear = today.withDayOfYear(today.lengthOfYear()).atTime(LocalTime.MAX); MPJLambdaWrapper wrapper = new MPJLambdaWrapper() .selectAll(ContractInvoice.class) .select(Contract::getContractNo) .selectAs(BusinessCustomer::getCompanyName, "busGuestName") .leftJoin(Contract.class, Contract::getId, ContractInvoice::getContractId) .leftJoin(BusinessCustomer.class, BusinessCustomer::getId, Contract::getPartyAId) .eq(ObjUtil.isNotNull(queryDTO.getQueryCompId()), Contract::getCompId, queryDTO.getQueryCompId()) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), ContractInvoice::getInvoiceTime, startOfDay) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), ContractInvoice::getInvoiceTime, endOfDay) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), ContractInvoice::getInvoiceTime, startOfMonth) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), ContractInvoice::getInvoiceTime, endOfMonth) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), ContractInvoice::getInvoiceTime, startOfYear) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), ContractInvoice::getInvoiceTime, endOfYear) .eq(StrUtil.isNotEmpty(queryDTO.getQueryArea()), BusinessCustomer::getAreaId, queryDTO.getQueryArea()) .eq(StrUtil.isNotEmpty(queryDTO.getQueryServiceAttr()), BusinessCustomer::getExportServiceAttr, queryDTO.getQueryServiceAttr()) .orderByDesc(ContractInvoice::getCreateTime); return R.ok(contractInvoiceMapper.selectJoinList(HomeInvoiceVo.class, wrapper)); } @Override public R homeCreditSale(HomeQueryDTO queryDTO) { LocalDateTime now = LocalDateTime.now(); LocalDate today = now.toLocalDate(); // 开始时间:今天 00:00:00 LocalDateTime startOfDay = today.atStartOfDay(); // 结束时间:今天 23:59:59.999999999 (或者使用 nextDay 00:00:00 配合 lt) LocalDateTime endOfDay = today.atTime(LocalTime.MAX); // --- 场景二:查询当月数据 --- // 开始时间:当月1号 00:00:00 LocalDateTime startOfMonth = today.withDayOfMonth(1).atStartOfDay(); // 结束时间:当月最后一天 23:59:59 LocalDateTime endOfMonth = today.withDayOfMonth(today.lengthOfMonth()).atTime(LocalTime.MAX); // 开始时间:当年1月1号 00:00:00 LocalDateTime startOfYear = today.withDayOfYear(1).atStartOfDay(); // 结束时间:当年12月31号 23:59:59 LocalDateTime endOfYear = today.withDayOfYear(today.lengthOfYear()).atTime(LocalTime.MAX); MPJLambdaWrapper wrapper = new MPJLambdaWrapper() .selectAll(ContractOutBound.class) .select(Contract::getContractNo) .selectAs(BusinessCustomer::getCompanyName, "busGuestName") .select(ContractSubjectMatter::getUnitPrice) .leftJoin(Contract.class, Contract::getId, ContractOutBound::getContractId) .leftJoin(BusinessCustomer.class, BusinessCustomer::getId, Contract::getPartyAId) .leftJoin(ContractSubjectMatter.class, on -> on.eq(ContractSubjectMatter::getContractId, ContractOutBound::getContractId) .eq(ContractSubjectMatter::getMaterialCode, ContractOutBound::getSubjectMatterCode) ) .eq(ObjUtil.isNotNull(queryDTO.getQueryCompId()), Contract::getCompId, queryDTO.getQueryCompId()) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), ContractOutBound::getOutBoundTime, startOfDay) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), ContractOutBound::getOutBoundTime, endOfDay) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), ContractOutBound::getOutBoundTime, startOfMonth) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), ContractOutBound::getOutBoundTime, endOfMonth) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), ContractOutBound::getOutBoundTime, startOfYear) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), ContractOutBound::getOutBoundTime, endOfYear) .eq(StrUtil.isNotEmpty(queryDTO.getQueryArea()), BusinessCustomer::getAreaId, queryDTO.getQueryArea()) .eq(StrUtil.isNotEmpty(queryDTO.getQueryServiceAttr()), BusinessCustomer::getExportServiceAttr, queryDTO.getQueryServiceAttr()) .orderByDesc(ContractOutBound::getCreateTime); return R.ok(contractOutBoundMapper.selectJoinList(HomeCreditSaleVo.class, wrapper)); } @Override public R homeOverdue(HomeQueryDTO queryDTO) { LocalDateTime now = LocalDateTime.now(); LocalDate today = now.toLocalDate(); // 开始时间:今天 00:00:00 LocalDateTime startOfDay = today.atStartOfDay(); // 结束时间:今天 23:59:59.999999999 (或者使用 nextDay 00:00:00 配合 lt) LocalDateTime endOfDay = today.atTime(LocalTime.MAX); // --- 场景二:查询当月数据 --- // 开始时间:当月1号 00:00:00 LocalDateTime startOfMonth = today.withDayOfMonth(1).atStartOfDay(); // 结束时间:当月最后一天 23:59:59 LocalDateTime endOfMonth = today.withDayOfMonth(today.lengthOfMonth()).atTime(LocalTime.MAX); // 开始时间:当年1月1号 00:00:00 LocalDateTime startOfYear = today.withDayOfYear(1).atStartOfDay(); // 结束时间:当年12月31号 23:59:59 LocalDateTime endOfYear = today.withDayOfYear(today.lengthOfYear()).atTime(LocalTime.MAX); MPJLambdaWrapper wrapper = new MPJLambdaWrapper() .selectAll(CurrentOverdue.class) .select(Contract::getContractNo) .selectAs(BusinessCustomer::getCompanyName, "busGuestName") .leftJoin(BusinessCustomer.class, BusinessCustomer::getId, CurrentOverdue::getBusGuestId) .leftJoin(Contract.class, Contract::getId, CurrentOverdue::getContractId) .eq(ObjUtil.isNotNull(queryDTO.getQueryCompId()), Contract::getCompId, queryDTO.getQueryCompId()) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), CurrentOverdue::getContractExpirTime, startOfDay) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "1"), CurrentOverdue::getContractExpirTime, endOfDay) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), CurrentOverdue::getContractExpirTime, startOfMonth) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "2"), CurrentOverdue::getContractExpirTime, endOfMonth) .ge(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), CurrentOverdue::getContractExpirTime, startOfYear) .le(StrUtil.isNotEmpty(queryDTO.getQueryType()) && StrUtil.equals(queryDTO.getQueryType(), "3"), CurrentOverdue::getContractExpirTime, endOfYear) .eq(StrUtil.isNotEmpty(queryDTO.getQueryArea()), BusinessCustomer::getAreaId, queryDTO.getQueryArea()) .eq(StrUtil.isNotEmpty(queryDTO.getQueryServiceAttr()), BusinessCustomer::getExportServiceAttr, queryDTO.getQueryServiceAttr()) .orderByDesc(CurrentOverdue::getCreateTime); return R.ok(currentOverdueMapper.selectJoinList(HomeOverdueVo.class, wrapper)); } @Override public R homeOverdueHis(HomeQueryDTO queryDTO) { List homeOverdueVos = new ArrayList<>(); HomeOverdueStaVo current = currentOverdueMapper.selectCurrentOverdue(queryDTO); if (ObjUtil.isNotNull(current)) { current.setOverdueType("当前"); homeOverdueVos.add(current); } HomeOverdueStaVo history = historyOverdueMapper.selectHistoryOverdue(queryDTO); if (ObjUtil.isNotNull(history)) { history.setOverdueType("历史"); homeOverdueVos.add(history); } return R.ok(homeOverdueVos); } @Override public R homeZgsColum() { R> r = remoteDictService.getDictByType("province"); List items = r.getData(); if (CollUtil.isEmpty(items)) { return R.failed("客商省份字典分类获取异常"); } List list = new ArrayList<>(); List contractProvinces = contractMapper.homeZgsColum(SecurityUtils.getUser().getCompId()); 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() .orElse(null); homeZgsData.setProvinceCode(province); if (ObjUtil.isNotNull(result)) { homeZgsData.setProvinceName(result.getLabel()); } list.add(homeZgsData); } }); return R.ok(list); } return R.ok(); } @Override public R zbjtStatistic() { List 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 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 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 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 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 compIds = new ArrayList<>(); compIds.add(2089995177814495234L); compIds.add(2089996921978040321L); compIds.add(2089997578009128962L); compIds.add(2101966257365045249L); AnnualPlan planListHtSMJ = annualPlanMapper.selectOne(Wrappers.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .in(AnnualPlan::getCompId, compIds).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556196124250113L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556421857497090L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556317461270529L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556535640576002L).last("limit 1")); List 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 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "2") .in(AnnualPlan::getCompId, compIds).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556196124250113L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556421857497090L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556317461270529L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556317461270529L).last("limit 1")); List 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 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "2") .in(AnnualPlan::getCompId, compIds).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556196124250113L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556421857497090L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556317461270529L).last("limit 1")); List 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.lambdaQuery() .eq(AnnualPlan::getPlanYear, curYear).eq(AnnualPlan::getPlanType, "1") .eq(AnnualPlan::getCompId, 2056556535640576002L).last("limit 1")); List 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 trendVoList = paymentReceiveMapper.zbjtReceiveScale(null); hk.put("zb", trendVoList); //石煤机回款 List compIds = new ArrayList<>(); compIds.add(2089995177814495234L); compIds.add(2089996921978040321L); compIds.add(2089997578009128962L); compIds.add(2101966257365045249L); List trendVoListSMJ = paymentReceiveMapper.zbjtReceiveScaleSMJ(); hk.put("smj", trendVoListSMJ); //石工泵回款 List trendVoListSGB = paymentReceiveMapper.zbjtReceiveScale(2056556196124250113L); hk.put("sgb", trendVoListSGB); //tfgs List trendVoListTFGS = paymentReceiveMapper.zbjtReceiveScale(2056556421857497090L); hk.put("tfgs", trendVoListTFGS); //机械厂回款 List trendVoListJXC = paymentReceiveMapper.zbjtReceiveScale(2056556317461270529L); hk.put("jxc", trendVoListJXC); //一煤机回款 List trendVoListYMJ = paymentReceiveMapper.zbjtReceiveScale(2056556535640576002L); hk.put("ymj", trendVoListYMJ); return R.ok(hk); } }