Search in sources :

Example 76 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page 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);
}
Also used : Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) SysJobEntity(com.company.project.entity.SysJobEntity) RequiresPermissions(org.apache.shiro.authz.annotation.RequiresPermissions) ApiOperation(io.swagger.annotations.ApiOperation)

Example 77 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project springboot-manager by aitangbao.

the class SysLogController method pageInfo.

@PostMapping("/logs")
@ApiOperation(value = "分页查询系统操作日志接口")
@LogAnnotation(title = "系统操作日志管理", action = "分页查询系统操作日志")
@RequiresPermissions("sys:log:list")
public DataResult pageInfo(@RequestBody SysLog vo) {
    Page page = new Page(vo.getPage(), vo.getLimit());
    LambdaQueryWrapper<SysLog> queryWrapper = Wrappers.lambdaQuery();
    if (!StringUtils.isEmpty(vo.getUsername())) {
        queryWrapper.like(SysLog::getUsername, vo.getUsername());
    }
    if (!StringUtils.isEmpty(vo.getOperation())) {
        queryWrapper.like(SysLog::getOperation, vo.getOperation());
    }
    if (!StringUtils.isEmpty(vo.getStartTime())) {
        queryWrapper.gt(SysLog::getCreateTime, vo.getStartTime());
    }
    if (!StringUtils.isEmpty(vo.getEndTime())) {
        queryWrapper.lt(SysLog::getCreateTime, vo.getEndTime());
    }
    queryWrapper.orderByDesc(SysLog::getCreateTime);
    return DataResult.success(logService.page(page, queryWrapper));
}
Also used : SysLog(com.company.project.entity.SysLog) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) LogAnnotation(com.company.project.common.aop.annotation.LogAnnotation) RequiresPermissions(org.apache.shiro.authz.annotation.RequiresPermissions) ApiOperation(io.swagger.annotations.ApiOperation)

Example 78 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page 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;
}
Also used : SysUser(com.company.project.entity.SysUser) SysDept(com.company.project.entity.SysDept) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage)

Example 79 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project RuoYi-Cloud-Plus by JavaLionLi.

the class PageQuery method build.

public <T> Page<T> build() {
    Integer pageNum = ObjectUtil.defaultIfNull(getPageNum(), DEFAULT_PAGE_NUM);
    Integer pageSize = ObjectUtil.defaultIfNull(getPageSize(), DEFAULT_PAGE_SIZE);
    if (pageNum <= 0) {
        pageNum = DEFAULT_PAGE_NUM;
    }
    Page<T> page = new Page<>(pageNum, pageSize);
    OrderItem orderItem = buildOrderItem();
    if (ObjectUtil.isNotNull(orderItem)) {
        page.addOrder(orderItem);
    }
    return page;
}
Also used : OrderItem(com.baomidou.mybatisplus.core.metadata.OrderItem) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page)

Example 80 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project dolphinscheduler by apache.

the class ProcessDefinitionService method queryProcessDefinitionListPaging.

/**
 * query process definition list paging
 *
 * @param loginUser login user
 * @param projectName project name
 * @param searchVal search value
 * @param pageNo page number
 * @param pageSize page size
 * @param userId user id
 * @return process definition page
 */
public Map<String, Object> queryProcessDefinitionListPaging(User loginUser, String projectName, String searchVal, Integer pageNo, Integer pageSize, Integer userId) {
    Map<String, Object> result = new HashMap<>(5);
    Project project = projectMapper.queryByName(projectName);
    Map<String, Object> checkResult = projectService.checkProjectAndAuth(loginUser, project, projectName);
    Status resultStatus = (Status) checkResult.get(Constants.STATUS);
    if (resultStatus != Status.SUCCESS) {
        return checkResult;
    }
    Page<ProcessDefinition> page = new Page(pageNo, pageSize);
    IPage<ProcessDefinition> processDefinitionIPage = processDefineMapper.queryDefineListPaging(page, searchVal, userId, project.getId(), isAdmin(loginUser));
    PageInfo pageInfo = new PageInfo<ProcessData>(pageNo, pageSize);
    pageInfo.setTotalCount((int) processDefinitionIPage.getTotal());
    pageInfo.setLists(processDefinitionIPage.getRecords());
    result.put(Constants.DATA_LIST, pageInfo);
    putMsg(result, Status.SUCCESS);
    return result;
}
Also used : Status(org.apache.dolphinscheduler.api.enums.Status) Project(org.apache.dolphinscheduler.dao.entity.Project) PageInfo(org.apache.dolphinscheduler.api.utils.PageInfo) ConcurrentHashMap(java.util.concurrent.ConcurrentHashMap) HashMap(java.util.HashMap) JSONObject(com.alibaba.fastjson.JSONObject) ProcessDefinition(org.apache.dolphinscheduler.dao.entity.ProcessDefinition) IPage(com.baomidou.mybatisplus.core.metadata.IPage) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page)

Aggregations

Page (com.baomidou.mybatisplus.extension.plugins.pagination.Page)239 IPage (com.baomidou.mybatisplus.core.metadata.IPage)171 QueryWrapper (com.baomidou.mybatisplus.core.conditions.query.QueryWrapper)62 ApiOperation (io.swagger.annotations.ApiOperation)38 ArrayList (java.util.ArrayList)29 LoginUser (org.jeecg.common.system.vo.LoginUser)26 Test (org.junit.Test)24 SpringBootTest (org.springframework.boot.test.context.SpringBootTest)22 RequiresPermissions (org.apache.shiro.authz.annotation.RequiresPermissions)19 LambdaQueryWrapper (com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper)17 JSONObject (com.alibaba.fastjson.JSONObject)15 PageInfo (org.apache.dolphinscheduler.api.utils.PageInfo)13 Result (org.jeecg.common.api.vo.Result)12 User (org.apache.dolphinscheduler.dao.entity.User)11 OrderItem (com.baomidou.mybatisplus.core.metadata.OrderItem)9 java.util (java.util)9 HashMap (java.util.HashMap)9 Project (org.apache.dolphinscheduler.dao.entity.Project)9 Service (org.springframework.stereotype.Service)9 IOException (java.io.IOException)8