修改采样查询

zhaowenxuan

2025-03-26 920bde97c899638bf26d8ee31ec1a961c9fcb790

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjSamplingController.java

@@ -219,7 +219,7 @@
    @GetMapping("/getCusList")
    @ApiOperation(value = "获取采样客户列表")
    public AjaxResult getCusList(@RequestParam(defaultValue = "1") @ApiParam(value = "0是1否") Integer isSignFor,
                                 @RequestParam(required = false) @ApiParam(value = "体检号") String tjNum,
                                 @RequestParam(required = false) @ApiParam(value = "体检号") String tjNumber,
                                 @RequestParam(required = false) @ApiParam(value = "客户姓名") String name,
                                 @RequestParam(required = false) @ApiParam(value = "单位") String dw,
                                 @ApiParam(value = "页码数(默认1)") @RequestParam(defaultValue = "1") Integer pageNum,
@@ -229,8 +229,8 @@
        Page<TjSampling> samplingPage = new Page<>(pageNum, pageSize);
        LambdaQueryWrapper<TjSampling> wrapper = new LambdaQueryWrapper<>();
        wrapper.eq(TjSampling::getIsSignFor, isSignFor);
        if (null != tjNum && StrUtil.isNotBlank(tjNum))
            wrapper.like(TjSampling::getTjNum, tjNum);
        if (null != tjNumber && StrUtil.isNotBlank(tjNumber))
            wrapper.like(TjSampling::getTjNum, tjNumber);
        if (null != name && StrUtil.isNotBlank(name))
            wrapper.like(TjSampling::getCusName, name);
        if (null != beginTime && null != endTime && StrUtil.isNotBlank(beginTime) && StrUtil.isNotBlank(endTime))
@@ -246,7 +246,7 @@
            }
        }

        wrapper.groupBy(TjSampling::getCusId);
        wrapper.groupBy(TjSampling::getTjNum);
        wrapper.orderByDesc(TjSampling::getCreateTime);
//        wrapper.last("LIMIT " + (pageNum - 1) * pageSize + "," + pageSize);
        Page<TjSampling> page = tjSamplingService.page(samplingPage, wrapper);