@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);
}
mybatisplus模糊查询+时间模糊查询(demo)
于 2021-06-07 14:26:37 首次发布