Examples with IPage com.baomidou.mybatisplus.core.metadata.IPage used on opensource projects

Example 56 with IPage

use of com.baomidou.mybatisplus.core.metadata.IPage in project springboot-manager by aitangbao.

the class SysDictController method findListByPage.

@ApiOperation(value = "查询分页数据")
@PostMapping("/listByPage")
@RequiresPermissions("sysDict:list")
public DataResult findListByPage(@RequestBody SysDictEntity sysDict) {
    Page page = new Page(sysDict.getPage(), sysDict.getLimit());
    LambdaQueryWrapper<SysDictEntity> queryWrapper = Wrappers.lambdaQuery();
    // 查询条件示例
    if (!StringUtils.isEmpty(sysDict.getName())) {
        queryWrapper.like(SysDictEntity::getName, sysDict.getName());
        queryWrapper.or();
        queryWrapper.like(SysDictEntity::getRemark, sysDict.getName());
    }
    queryWrapper.orderByAsc(SysDictEntity::getName);
    IPage<SysDictEntity> iPage = sysDictService.page(page, queryWrapper);
    return DataResult.success(iPage);
}

Example 57 with IPage

use of com.baomidou.mybatisplus.core.metadata.IPage in project springboot-manager by aitangbao.

the class SysFilesController method findListByPage.

@ApiOperation(value = "查询分页数据")
@PostMapping("/listByPage")
@RequiresPermissions("sysFiles:list")
public DataResult findListByPage(@RequestBody SysFilesEntity sysFiles) {
    Page page = new Page(sysFiles.getPage(), sysFiles.getLimit());
    IPage<SysFilesEntity> iPage = sysFilesService.page(page, Wrappers.<SysFilesEntity>lambdaQuery().orderByDesc(SysFilesEntity::getCreateDate));
    return DataResult.success(iPage);
}

Example 58 with IPage

use of com.baomidou.mybatisplus.core.metadata.IPage in project springboot-manager by aitangbao.

the class SysGeneratorController method findListByPage.

@ApiOperation(value = "查询分页数据")
@PostMapping("/listByPage")
@RequiresPermissions("sysGenerator:list")
public DataResult findListByPage(@RequestBody SysGenerator vo) {
    Page page = new Page(vo.getPage(), vo.getLimit());
    IPage<SysGenerator> iPage = sysGeneratorService.selectAllTables(page, vo);
    return DataResult.success(iPage);
}

Example 59 with IPage

use of com.baomidou.mybatisplus.core.metadata.IPage in project springboot-manager by aitangbao.

the class SysJobController method findListByPage.

@ApiOperation(value = "查询分页数据")
@PostMapping("/listByPage")
@RequiresPermissions("sysJob:list")
public DataResult findListByPage(@RequestBody SysJobEntity sysJob) {
    Page page = new Page(sysJob.getPage(), sysJob.getLimit());
    LambdaQueryWrapper<SysJobEntity> queryWrapper = Wrappers.lambdaQuery();
    // 查询条件示例
    if (!StringUtils.isEmpty(sysJob.getBeanName())) {
        queryWrapper.like(SysJobEntity::getBeanName, sysJob.getBeanName());
    }
    IPage<SysJobEntity> iPage = sysJobService.page(page, queryWrapper);
    return DataResult.success(iPage);
}

Example 60 with IPage

use of com.baomidou.mybatisplus.core.metadata.IPage in project springboot-manager by aitangbao.

the class UserServiceImpl method pageInfo.

@Override
public IPage<SysUser> pageInfo(SysUser vo) {
    Page page = new Page(vo.getPage(), vo.getLimit());
    LambdaQueryWrapper<SysUser> queryWrapper = Wrappers.lambdaQuery();
    if (!StringUtils.isEmpty(vo.getUsername())) {
        queryWrapper.like(SysUser::getUsername, vo.getUsername());
    }
    if (!StringUtils.isEmpty(vo.getStartTime())) {
        queryWrapper.gt(SysUser::getCreateTime, vo.getStartTime());
    }
    if (!StringUtils.isEmpty(vo.getEndTime())) {
        queryWrapper.lt(SysUser::getCreateTime, vo.getEndTime());
    }
    if (!StringUtils.isEmpty(vo.getNickName())) {
        queryWrapper.like(SysUser::getNickName, vo.getNickName());
    }
    if (null != vo.getStatus()) {
        queryWrapper.eq(SysUser::getStatus, vo.getStatus());
    }
    if (!StringUtils.isEmpty(vo.getDeptNo())) {
        LambdaQueryWrapper<SysDept> queryWrapperDept = Wrappers.lambdaQuery();
        queryWrapperDept.select(SysDept::getId).like(SysDept::getRelationCode, vo.getDeptNo());
        List<Object> list = sysDeptMapper.selectObjs(queryWrapperDept);
        queryWrapper.in(SysUser::getDeptId, list);
    }
    queryWrapper.orderByDesc(SysUser::getCreateTime);
    IPage<SysUser> iPage = sysUserMapper.selectPage(page, queryWrapper);
    if (!CollectionUtils.isEmpty(iPage.getRecords())) {
        for (SysUser sysUser : iPage.getRecords()) {
            SysDept sysDept = sysDeptMapper.selectById(sysUser.getDeptId());
            if (sysDept != null) {
                sysUser.setDeptName(sysDept.getName());
            }
        }
    }
    return iPage;
}