| | |
|---|
| | | * 获取采样客户列表 |
|---|
| | | * |
|---|
| | | * @param isSignFor |
|---|
| | | * @param tjNum |
|---|
| | | * @param tjNumber |
|---|
| | | * @param name |
|---|
| | | * @param pageNum |
|---|
| | | * @param pageSize |
|---|
| | |
|---|
| | | @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, |
|---|
| | |
|---|
| | | 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)) |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | 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); |
|---|
