| | |
| | | IPage<ProblemLog> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<ProblemLog> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.leftJoin(Member.class,Member::getOpenid,ProblemLog::getOpenid); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,ProblemLog::getUserId); |
| | | queryWrapper.selectAll(ProblemLog.class) |
| | | .selectAs(Member::getType,ProblemLog::getType); |
| | | .selectAs(Member::getType,ProblemLog::getType) |
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getName()), ProblemLog::getName, pageWrap.getModel().getName()) |
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), ProblemLog::getCompanyName, pageWrap.getModel().getCompanyName()) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getType()), Member::getType, pageWrap.getModel().getType()); |
| | | queryWrapper.orderByDesc(ProblemLog::getCreateDate); |
| | | IPage<ProblemLog> problemLogIPage = problemLogJoinMapper.selectJoinPage(page, ProblemLog.class, queryWrapper); |
| | | System.out.println(problemLogIPage); |