lims项目框架修改优化--后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
zhuo
2025-05-12 f201f17d7e25e71d22b9c8b821e387bdc8fba52d 
 inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderServiceImpl.java


@@ -1,6 +1,8 @@


package com.ruoyi.inspect.service.impl;




import cn.hutool.core.collection.CollUtil;


import cn.hutool.core.date.DateTime;


import cn.hutool.core.date.DateUtil;


import cn.hutool.core.util.ObjectUtil;


import cn.hutool.core.util.StrUtil;


import cn.hutool.json.JSONUtil;


@@ -8,34 +10,34 @@


import com.alibaba.excel.ExcelWriter;


import com.alibaba.excel.write.metadata.WriteSheet;


import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;


import com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;


import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;


import com.baomidou.mybatisplus.core.metadata.IPage;


import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;


import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;


import com.baomidou.mybatisplus.core.toolkit.Wrappers;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import com.ruoyi.basic.mapper.IfsInventoryQuantityMapper;


import com.ruoyi.basic.mapper.StandardProductListMapper;


import com.ruoyi.basic.mapper.StructureItemParameterMapper;


import com.ruoyi.basic.pojo.IfsInventoryQuantity;


import com.ruoyi.basic.pojo.StandardProductList;


import com.ruoyi.basic.pojo.StructureItemParameter;


import com.ruoyi.basic.pojo.StructureTestObject;


import com.ruoyi.common.constant.InsOrderTypeConstants;


import com.ruoyi.common.core.domain.Result;


import com.ruoyi.common.core.domain.entity.User;


import com.ruoyi.common.numgen.NumberGenerator;


import com.ruoyi.common.utils.*;


import com.ruoyi.common.utils.api.IfsApiUtils;


import com.ruoyi.framework.exception.ErrorException;


import com.ruoyi.inspect.dto.*;


import com.ruoyi.inspect.mapper.*;


import com.ruoyi.inspect.pojo.*;


import com.ruoyi.inspect.service.InsOrderService;


import com.ruoyi.inspect.service.InsOrderStateService;


import com.ruoyi.inspect.service.InsProductService;


import com.ruoyi.inspect.service.InsSampleService;


import com.ruoyi.inspect.vo.InsOrderPrintingVo;


import com.ruoyi.inspect.vo.SampleDefectsFatherVo;


import com.ruoyi.system.mapper.CustomMapper;


import com.ruoyi.system.mapper.UserMapper;


import lombok.AllArgsConstructor;


import org.apache.commons.lang3.StringUtils;


@@ -47,6 +49,7 @@


import java.io.IOException;


import java.math.BigDecimal;


import java.net.URLEncoder;


import java.text.SimpleDateFormat;


import java.time.LocalDate;


import java.time.LocalDateTime;


import java.time.Month;


@@ -70,25 +73,23 @@


    private InsSampleMapper insSampleMapper;


    private InsProductService insProductService;


    private InsProductMapper insProductMapper;


    private InsProductUserMapper insProductUserMapper;


    private InsSampleUserMapper insSampleUserMapper;


    private InsOrderStateMapper insOrderStateMapper;


    private InsOrderStateService insOrderStateService;


    private UserMapper userMapper;


    private IfsInventoryQuantityMapper ifsInventoryQuantityMapper;


    private CustomMapper customMapper;


    private final NumberGenerator<InsOrder> numberGenerator;


    private InsReportMapper insReportMapper;


    private InsUnqualifiedRetestProductMapper insUnqualifiedRetestProductMapper;


    private IfsApiUtils ifsApiUtils;


    private SpotCheckQuarterItemMapper spotCheckQuarterItemMapper;


    private StandardProductListMapper standardProductListMapper;


    private StructureItemParameterMapper structureItemParameterMapper;








    //获取检验下单数据


    @Override


    public IPage<SampleOrderDto> selectInsOrderParameter(IPage<InsOrder> page, SampleOrderDto sampleOrderDto) {


        //todo: 只看我判断全部,个人,组织的权限


        String laboratory = null;


        // 判断是否是全部


        String isOrderAll = null;


@@ -96,11 +97,15 @@


            isOrderAll = "1";


            sampleOrderDto.setState(null);


        }


        IPage<SampleOrderDto> sampleOrderDtoIPage = insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll);


        return insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll);


    }






    /**


     * 分配检验人


     *


     * @return


     */


    @Override


    @Transactional(rollbackFor = Exception.class)


    public int upInsOrder(Integer orderId, Integer sampleId, String appointed, Integer userId, String sonLaboratory) {


@@ -109,13 +114,15 @@


        insOrder.setAppointed(StringUtils.isNotEmpty(appointed) ? LocalDate.parse(appointed) : null);


        insOrder.setSendTime(LocalDateTime.now());


        insOrderMapper.updateById(insOrder);


        List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId));


        List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList());


        List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId));


        List<Integer> ids = insSamples.stream().map(InsSample::getId).collect(Collectors.toList());


        List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()


                .in(InsProduct::getInsSampleId, ids)


                .eq(InsProduct::getState, 1)


                .select(InsProduct::getSonLaboratory).groupBy(InsProduct::getSonLaboratory));


        for (InsProduct insProduct : insProducts) {




        // 批量添加检验任务状态表


        List<InsOrderState> insOrderStateList = insProducts.stream().map(insProduct -> {


            InsOrderState insOrderState = new InsOrderState();


            insOrderState.setInsOrderId(orderId);


            try {


@@ -124,8 +131,10 @@


                throw new ErrorException("该检验单有未维护实验室的检验项目");


            }


            insOrderState.setInsState(0);


            insOrderStateMapper.insert(insOrderState);


        }


            return insOrderState;


        }).collect(Collectors.toList());


        insOrderStateService.saveBatch(insOrderStateList);




        if (userId != null) {


            InsSampleUser insSampleUser = new InsSampleUser();


            insSampleUser.setState(0);


@@ -145,12 +154,63 @@


            spotCheckQuarterItem.setSamplingUser(user.getName());


            spotCheckQuarterItemMapper.updateById(spotCheckQuarterItem);


        }




        return 1;


    }






    public static String getWeek(String dayStr) {


        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


        try {


            Date date = sdf.parse(dayStr);


            Calendar calendar = Calendar.getInstance();


            calendar.setTime(date);


            int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);


            int day = calendar.get(Calendar.DAY_OF_MONTH);


            return getWeekDay(dayOfWeek);


        } catch (Exception e) {


            e.printStackTrace();


        }


        return null;


    }




    public static String getWeekDay(int dayOfWeek) {


        switch (dayOfWeek) {


            case Calendar.MONDAY:


                return "周一";


            case Calendar.TUESDAY:


                return "周二";


            case Calendar.WEDNESDAY:


                return "周三";


            case Calendar.THURSDAY:


                return "周四";


            case Calendar.FRIDAY:


                return "周五";


            case Calendar.SATURDAY:


                return "周六";


            case Calendar.SUNDAY:


                return "周日";


            default:


                return "未知";


        }


    }






    // 如果你使用 Java 8+，也可以用 Stream API 简化代码：


    public List<StandardProductList> findMissingItemsWithStream(List<StandardProductList> standardList,


                                                                List<InsProduct> insList) {


        Set<Integer> insIds = insList.stream()


                .map(InsProduct::getStructureItemParameterId)


                .collect(Collectors.toSet());




        return standardList.stream()


                .filter(product -> !insIds.contains(product.getStructureItemParameterId()))


                .collect(Collectors.toList());


    }




    @Override


    @Transactional(rollbackFor = Exception.class)


    public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing) {


    public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder) {


        // todo: 下单判断抽样计划的唯一性


        if (insOrder.getQuarterItemId() != null) {


            Long quarterItemCount = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery()


@@ -160,7 +220,6 @@


                throw new ErrorException("该抽样计划已被绑定过");


            }


        }




        insOrder.setState(0);




        LocalDate appointed = insOrder.getAppointed();


@@ -286,9 +345,11 @@


                        .set(IfsInventoryQuantity::getInspectStatus, 0));


            }




            // 审核检验单


            upInsOrderOfState(insOrder);


            upInsOrder(insOrder.getId(), null, appointed != null ? appointed.toString() : null, SecurityUtils.getUserId().intValue(), "原材料");




            // 分配检验人


            upInsOrder(insOrder.getId(), null, appointed != null ? appointed.toString() : null, SecurityUtils.getUserId().intValue(), "原材料");




            // 根据零件号判断是否是辅材


            boolean isRaw = false;


@@ -355,6 +416,9 @@


                if (StringUtils.isBlank(product.getAsk()) || StringUtils.isBlank(product.getTell())) {


                    throw new ErrorException("有检验项的要求值或要求描述为空, 请先去标准库配置要求值或要求描述");


                }


                if (StringUtils.isBlank(product.getSonLaboratory())) {


                    throw new ErrorException("有检验项的的子实验室为绑定, 请先绑定子实验室");


                }


                insProductMapper.insert(product);


            }


        }


@@ -379,6 +443,11 @@


        return map;


    }




    /**


     * 审核检验单


     * @param insOrder


     * @return


     */


    @Override


    public int upInsOrderOfState(InsOrder insOrder) {


        insOrder.setExamineTime(LocalDateTime.now());


@@ -446,16 +515,6 @@


        Map<String, Object> map = new HashMap<>();


        InsOrder insOrder = insOrderMapper.selectById(id);


        List<SampleProductDto> list = insSampleMapper.getInsOrderAndSample(id, laboratory);


        for (SampleProductDto sampleProductDto : list) {


            List<Integer> ids = sampleProductDto.getInsProduct().stream().map(InsProduct::getId).collect(Collectors.toList());


            List<InsProductUser> insProductUsers = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery()


                    .in(InsProductUser::getInsProductId, ids));


            if (CollectionUtils.isNotEmpty(insProductUsers)) {


                List<Integer> userIds = insProductUsers.stream().map(InsProductUser::getCreateUser).distinct().collect(Collectors.toList());


                String collect = userMapper.selectBatchIds(userIds).stream().map(User::getName).collect(Collectors.joining(","));


                sampleProductDto.setCheckName(collect);


            }


        }


        map.put("insOrder", insOrder);


        map.put("sampleProduct", list);


        //查询所有记录模版去重


@@ -475,112 +534,12 @@


        return productDto2IPage;


    }




    @Override


    public IPage<CostStatisticsDto> costStatistics(IPage<CostStatisticsDto> page, CostStatisticsDto costStatisticsDto) {


        String dates = costStatisticsDto.getDates();


        String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(",");


        costStatisticsDto.setDates(null);




        //todo:仅看自己




        IPage<CostStatisticsDto> dtoIPage = insOrderMapper.selectCostStatistics(page, QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59"));


        List<CostStatisticsDto> collect = dtoIPage.getRecords().stream().map(dto -> {


            Set<String> uniqueTags = new HashSet<>();


            if (dto.getInspectionItem().contains(",")) {


                for (String s : dto.getInspectionItem().split(",")) {


                    uniqueTags.add(s.split("@")[0]);


                }


            } else {


                uniqueTags.add(dto.getInspectionItem().split("@")[0]);


            }


            dto.setInspectionItem(uniqueTags.toString());


            return dto;


        }).collect(Collectors.toList());


        dtoIPage.setRecords(collect);


        return dtoIPage;


    }




    @Override


    public Map<String, Object> costStatistics2(CostStatisticsDto costStatisticsDto) {


        Map<String, Object> map = new HashMap<>();


        String dates = costStatisticsDto.getDates();


        String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(",");


        costStatisticsDto.setDates(null);


        List<CostStatisticsDto> costStatisticsDtos = insOrderMapper.selectCostStatistics2(QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59"));


        double totalPrice = costStatisticsDtos.stream()


                .filter(dto -> dto.getPrice() != null) // 过滤掉价格为 null 的对象


                .mapToDouble(value -> value.getPrice().doubleValue() * value.getNum())


                .sum();


        map.put("total", totalPrice);


        return map;


    }




    @Override


    public Map<String, Object> selectSampleDefects(Page page, String inspectionItems, String orderNumber) {


        List<SampleDefectsFatherVo> sampleDefectsFatherVos = insOrderMapper.selectSampleDefects(page, inspectionItems, orderNumber);


        Map<String, Object> map = new HashMap<>();


        map.put("records", sampleDefectsFatherVos);


        Long aLong = insOrderMapper.getCount(inspectionItems, orderNumber);


        map.put("total", aLong);


        return map;


    }




    @Override


    public int updateStatus(Integer id) {


        return insOrderMapper.updateStatus(id);


    }






    @Override


    public void export(CostStatisticsDto costStatisticsDto, HttpServletResponse response) throws IOException {


        //查询导出的费用统计数据


        String dates = costStatisticsDto.getDates();


        String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(",");


        costStatisticsDto.setDates(null);


        List<CostStatisticsDto> costStatisticsDtos = insOrderMapper.selectCostStatistics2(QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59"));


        costStatisticsDtos = costStatisticsDtos.stream().map(dto -> {


            Set<String> uniqueTags = new HashSet<>();


            if (dto.getInspectionItem().contains(",")) {


                for (String s : dto.getInspectionItem().split(",")) {


                    uniqueTags.add(s.split("@")[0]);


                }


            } else {


                uniqueTags.add(dto.getInspectionItem().split("@")[0]);


            }


            dto.setInspectionItem(uniqueTags.toString());


            return dto;


        }).collect(Collectors.toList());




        response.setContentType("application/vnd.ms-excel");


        response.setCharacterEncoding("UTF-8");


        // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系


        String fileName = URLEncoder.encode("样品费用统计导出", "UTF-8");


        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");


        Map<String, List<CostStatisticsDto>> groupByCompany =


                costStatisticsDtos.stream().filter(e -> StrUtil.isNotEmpty(e.getCompany()))


                        .collect(Collectors.groupingBy(CostStatisticsDto::getCompany));


        try {


            // 新建ExcelWriter


            // 新建ExcelWriter


            ExcelWriter excelWriter =


                    EasyExcel.write(response.getOutputStream())


                            .registerWriteHandler(new SimpleColumnWidthStyleStrategy(25))


                            .build();


            for (Map.Entry<String, List<CostStatisticsDto>> companyDataEntry : groupByCompany.entrySet()) {


                String sheetName = companyDataEntry.getKey();


                List<CostStatisticsDto> dataList = companyDataEntry.getValue();


                WriteSheet mainSheet = EasyExcel.writerSheet(sheetName)


                        .head(CostStatisticsDto.class)


                        .registerWriteHandler(new SimpleColumnWidthStyleStrategy(25))


                        .build();


                excelWriter.write(dataList, mainSheet);


            }


            // 关闭流


            excelWriter.finish();


        } catch (IOException e) {


            throw new RuntimeException("导出失败");


        }


    }




    /**


     * 获取ifs库存信息


@@ -664,7 +623,7 @@


            ifsInventoryQuantity.setIsSource(1);


            ifsInventoryQuantity.setState(0);




            IfsInventoryQuantity one = ifsInventoryQuantityMapper.selectOne(new LambdaQueryWrapper<IfsInventoryQuantity>()


            Long count = ifsInventoryQuantityMapper.selectCount(new LambdaQueryWrapper<IfsInventoryQuantity>()


                    .eq(IfsInventoryQuantity::getOrderNo, ifsInventoryQuantity.getOrderNo())


                    .eq(IfsInventoryQuantity::getLineNo, ifsInventoryQuantity.getLineNo())


                    .eq(IfsInventoryQuantity::getReleaseNo, ifsInventoryQuantity.getReleaseNo())


@@ -676,8 +635,7 @@


                    .eq(IfsInventoryQuantity::getWaivDevRejNo, ifsInventoryQuantity.getWaivDevRejNo())


                    .eq(IfsInventoryQuantity::getActivitySeq, ifsInventoryQuantity.getActivitySeq())


            );


            if(Objects.isNull(one)) {




            if(count == 0) {


                ifsInventoryQuantity.setIsFirst(0);


                // 查询产业链检测数据


                String industryChainAttrFields = IndustryChainUtils.getIndustryChainAttrFields(ifsInventoryQuantity.getOrderNo(),


@@ -917,6 +875,10 @@




        // 修改检验项


        for (SampleProductDto sampleProductDto : insOrderUpdateDto.getSampleProduct()) {


            insSampleService.update(Wrappers.<InsSample>lambdaUpdate()


                    .eq(InsSample::getId, sampleProductDto.getId())


                    .set(InsSample::getSpecialStandardMethod, sampleProductDto.getSpecialStandardMethod()));




            insProductService.updateBatchById(sampleProductDto.getInsProduct());


        }




@@ -952,7 +914,8 @@


        // 查询标准树


        List<StandardProductList> standardProductLists = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery()


                .eq(StandardProductList::getStandardMethodListId, insProduct.getStandardMethodListId())


                .eq(StandardProductList::getTree, tree));


                .eq(StandardProductList::getTree, tree)


                .orderByAsc(StandardProductList::getSort));


        for (StandardProductList standardProductList : standardProductLists) {


            standardProductList.setId(null);


        }


@@ -977,6 +940,7 @@


                product.setCreateUser(null);


                product.setUpdateTime(null);


                product.setUpdateUser(null);


                product.setSection(null);


                product.setInsSampleId(omitOrderProductDto.getInsSampleId());


                if (StringUtils.isBlank(product.getCableTag())) {


                    product.setCableTag(null);


@@ -1001,16 +965,21 @@


     */


    @Override


    public void rawAllInsOrderExport(SampleOrderDto sampleOrderDto, HttpServletResponse response) {


        //判断全部,个人,组织的权限


        //todo:仅看我获取当前人所属实验室id


        String laboratory = null;


        // 判断是否是全部


        String isOrderAll = null;


        if (sampleOrderDto.getState() != null && sampleOrderDto.getState() == -2) {


            isOrderAll = "1";


            sampleOrderDto.setState(null);


        List<SampleOrderDto> sampleOrderDtoList = new ArrayList<>();


        if (StringUtils.isNotBlank(sampleOrderDto.getIds())) {


            List<String> orderIds = StrUtil.split(sampleOrderDto.getIds(), ",");


            sampleOrderDtoList = insOrderMapper.getInsOrderExportByIds(orderIds);


        } else {


            String laboratory = null;


            // 判断是否是全部


            String isOrderAll = null;


            if (sampleOrderDto.getState() != null && sampleOrderDto.getState() == -2) {


                isOrderAll = "1";


                sampleOrderDto.setState(null);


            }


            sampleOrderDto.setIds(null);


            sampleOrderDtoList = insOrderMapper.rawAllInsOrderExport(QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll);


        }


        List<SampleOrderDto> sampleOrderDtoList = insOrderMapper.rawAllInsOrderExport(QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll);




        // 判断是否是不合格, 不合格查询不合格项


        for (SampleOrderDto orderDto : sampleOrderDtoList) {


@@ -1043,6 +1012,140 @@


        }


    }




    /**


     * 修改样品型号


     * @param insSample


     */


    @Override


    public void updateSampleModel(InsSample insSample) {


        // 判断当前订单是否生成了报告, 生成了报告不能修改单号


        Long count = insReportMapper.selectCount(Wrappers.<InsReport>lambdaQuery()


                .eq(InsReport::getInsOrderId, insSample.getInsOrderId()));


        if (count > 0 ) {


            throw new ErrorException("当前订单已经生成了报告不能修改编号");


        }




        insSampleService.update(Wrappers.<InsSample>lambdaUpdate()


                .eq(InsSample::getId, insSample.getId())


                .set(InsSample::getModel, insSample.getModel()));


    }




    /**


     * 查询当前时间是否没有该检测项的抽样计划


     * @param sampleList


     * @param insOrder


     * @return


     */


    @Override


    public Result judgeNotSpotCheckOrder(List<SampleProductDto> sampleList, InsOrder insOrder) {


        // todo: 下单判断抽样计划的唯一性


        if (insOrder.getQuarterItemId() != null) {


            Long quarterItemCount = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery()


                    .eq(InsOrder::getQuarterItemId, insOrder.getQuarterItemId())


                    .notIn(InsOrder::getState, -1 ,2 ,3));


            if (quarterItemCount > 0) {


                throw new ErrorException("该抽样计划已被绑定过");


            }


        }




        // 判断是否是抽样检测


        if (insOrder.getOrderType().equals(InsOrderTypeConstants.SPOT_CHECK)) {


            Set<String> monthMessageSet = new HashSet<>();


            Set<String> quarterMessageSet = new HashSet<>();


            Set<String> yearMessageSet = new HashSet<>();




            String formatTime = "yyyy-MM-dd HH:mm:ss";


            // 查询当前所有样品的检验项


            for (SampleProductDto sampleProductDto : sampleList) {


                List<StandardProductList> standardProductList = getProductTreeBySampleId(sampleProductDto.getId());




                Set<Integer> insIds = sampleProductDto.getInsProduct().stream()


                        .map(InsProduct::getStructureItemParameterId)


                        .collect(Collectors.toSet());




                List<StandardProductList> productLists = standardProductList.stream()


                        .filter(product -> !insIds.contains(product.getStructureItemParameterId()))


                        .collect(Collectors.toList());




                // 查询检验项基础表, 查询是否有月度, 季度, 年度的检验项


                List<StructureItemParameter> itemParameterList = structureItemParameterMapper.selectList(Wrappers.<StructureItemParameter>lambdaQuery()


                        .in(StructureItemParameter::getId, productLists.stream().map(StandardProductList::getStructureItemParameterId).collect(Collectors.toList())));




                for (StructureItemParameter item : itemParameterList) {


                    if (StringUtils.isNotBlank(item.getSpotCheckType())) {


                        switch (item.getSpotCheckType()) {


                            case "1": // 月度


                                // 查询当月是否有该检测项的抽样计划


                                // 当月开始时间


                                DateTime monthStart = DateUtil.beginOfMonth(DateUtil.date());


                                String monthStartTime = monthStart.toString(formatTime);


                                // 当月结束时间


                                DateTime monthEnd = DateUtil.endOfMonth(DateUtil.date());


                                String monthEndTime = monthEnd.toString(formatTime);


                                Integer count = insOrderMapper.selectNotSpotCheckOrder(item.getId(), monthStartTime, monthEndTime);


                                if (count == 0) {


                                    String monthMessage = item.getInspectionItemClass() +


                                            item.getInspectionItem() +


                                            item.getInspectionItemSubclass();


                                    monthMessageSet.add(monthMessage);


                                }


                                break;


                            case "2": // 季度


                                DateTime quarterStart = DateUtil.beginOfQuarter(DateUtil.date());


                                String quarterStartTime = quarterStart.toString(formatTime);


                                // 当月结束时间


                                DateTime quarterEnd = DateUtil.endOfQuarter(DateUtil.date());


                                String quarterEndTime = quarterEnd.toString(formatTime);


                                Integer quarterCount = insOrderMapper.selectNotSpotCheckOrder(item.getId(), quarterStartTime, quarterEndTime);


                                if (quarterCount == 0) {


                                    String quarterMessage = item.getInspectionItemClass() +


                                            item.getInspectionItem() +


                                            item.getInspectionItemSubclass();


                                    quarterMessageSet.add(quarterMessage);


                                }




                                break;


                            case "3": // 年度


                                DateTime yearStart = DateUtil.beginOfQuarter(DateUtil.date());


                                String yearStartTime = yearStart.toString(formatTime);


                                // 当月结束时间


                                DateTime yearEnd = DateUtil.endOfQuarter(DateUtil.date());


                                String yearEndTime = yearEnd.toString(formatTime);


                                Integer yearCount = insOrderMapper.selectNotSpotCheckOrder(item.getId(), yearStartTime, yearEndTime);


                                if (yearCount == 0) {


                                    String yearMessage = item.getInspectionItemClass() +


                                            item.getInspectionItem() +


                                            item.getInspectionItemSubclass();


                                    yearMessageSet.add(yearMessage);


                                }




                                break;


                        }


                    }


                }


            }




            String message = "";


            if (CollectionUtils.isNotEmpty(monthMessageSet)) {


                message += StrUtil.format("<p>检验项<span style=\"color: red\">{}</span>当月还未进行抽样检测, 请查看是否需要添加当前检验项</p>", CollUtil.join(monthMessageSet, ", "));


            }




            if (CollectionUtils.isNotEmpty(quarterMessageSet)) {


                message += StrUtil.format("<p>检验项<span style=\"color: red\">{}</span>当前季度还未进行抽样检测, 请看是否需要添加当前检验项</p>", CollUtil.join(quarterMessageSet, ", "));


            }




            if (CollectionUtils.isNotEmpty(yearMessageSet)) {


                message += StrUtil.format("<p>检验项<span style=\"color: red\">{}</span>今年还未进行抽样检测, 请看是否需要添加当前检验项</p>", CollUtil.join(yearMessageSet, ", "));


            }




            if (StringUtils.isNotBlank(message)) {


                return Result.success(false, message);


            }


        }


        return Result.success(true);




    }




}