mybatisplus模糊查询+时间模糊查询（demo）

 @Override
    public PageDTO<RoleDto> findRolesList(RoleReq req) {
        //查询条件
        String name = req.getName();
        Boolean enable = req.getEnable();
        String createdBy = req.getCreatedBy();
        LocalDate startTime = req.getStartTime();
        LocalDate endTime = req.getEndTime();

        LambdaQueryWrapper<SysRole> queryWrapper = new LambdaQueryWrapper<>();
        //角色名称
        if (name != null) {
            queryWrapper.eq(SysRole::getName, name);
        }
        //当前状态
        if (enable != null) {
            queryWrapper.eq(SysRole::getEnable, enable);
        }
        //创建人
        if (createdBy != null) {
            queryWrapper.eq(SysRole::getCreatedBy, createdBy);
        }
        //创建时间
        if (Objects.nonNull(startTime)) {
            queryWrapper.apply((ObjectUtil.isNotNull(startTime)), "DATE_FORMAT(created, '%Y-%m-%d') >= {0}", startTime);
        }
        if (Objects.nonNull(endTime)) {
            queryWrapper.apply((ObjectUtil.isNotNull(endTime)), "DATE_FORMAT(created, '%Y-%m-%d') <= {0}", endTime);
        }

        //分页查询
        IPage<SysRole> result = page(PageUtils.createPage(req.getCurrent(), req.getSize()), queryWrapper);
        List<RoleDto> tiems = sysRoleUntieConverter.toDtoList(result.getRecords());
        if (CollUtil.isEmpty(tiems)) {
            return PageUtils.build(result, null);
        }
        return PageUtils.build(result, tiems);
    }