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 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.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 homeZbjt() { List homeZbjtVoList = new ArrayList<>(); //出货 // HomeZbjtVo ch = contractOutBoundMapper.homeZbjt(); // homeZbjtVoList.add(ch); //只保留销售收入 回款 新增合同 //开票 HomeZbjtVo kp = contractInvoiceMapper.homeZbjt(); homeZbjtVoList.add(kp); //回款 HomeZbjtVo hk = paymentSlipMapper.homeZbjt(); homeZbjtVoList.add(hk); //合同签订 sgb smj jxc tfgs ymj HomeZbjtVo htqd = contractMapper.homeZbjt(); 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(homeZbjtVoList); } @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); } }