perf(lb-qms): 优化查询功能和时间范围筛选

baoshiwei

2025-05-20 eafecc3ac0227960f2b8fa377be27f066e10e50f

 ruoyi-modules/lb-qms/src/main/java/cn/shlanbao/qms/service/impl/LbTestResultServiceImpl.java

@@ -15,6 +15,8 @@
import cn.shlanbao.qms.mapper.LbTestResultMapper;
import cn.shlanbao.qms.service.ILbTestResultService;

import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.*;

/**
@@ -76,6 +78,7 @@
    @Override
    public List<LbTestResultVo> queryList(LbTestResultBo bo) {
        if (StringUtils.isNotBlank(bo.getProdModel())) {

            return baseMapper.selectByProdModelAndConditions(bo);
        } else {
            LambdaQueryWrapper<LbTestResult> lqw = buildQueryWrapper(bo);
@@ -116,8 +119,13 @@
        lqw.eq(bo.getTestValue() != null, LbTestResult::getTestValue, bo.getTestValue());
        lqw.eq(StringUtils.isNotBlank(bo.getJudgeDetail()), LbTestResult::getJudgeDetail, bo.getJudgeDetail());
        lqw.eq(StringUtils.isNotBlank(bo.getTestResult()), LbTestResult::getTestResult, bo.getTestResult());
        lqw.between(params.get("beginCreateTime") != null && params.get("endCreateTime") != null,
                LbTestResult::getCreateTime, params.get("beginCreateTime"), params.get("endCreateTime"));
      // 设置开始时间和结束时间的时分秒
        if (params.get("beginCreateTime") != null && params.get("endCreateTime") != null) {
            LocalDateTime beginTime = ((LocalDateTime) params.get("beginCreateTime")).with(LocalTime.MIN);
            LocalDateTime endTime = ((LocalDateTime) params.get("endCreateTime")).with(LocalTime.MAX);
            lqw.between(LbTestResult::getCreateTime, beginTime, endTime);
        }

        lqw.orderByAsc(LbTestResult::getCreateTime);
        return lqw;
    }