Search in sources :

Example 56 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project kms by mahonelau.

the class SysUserController method departUserList.

/**
 * 部门用户列表
 */
@RequestMapping(value = "/departUserList", method = RequestMethod.GET)
public Result<IPage<SysUser>> departUserList(@RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) {
    Result<IPage<SysUser>> result = new Result<IPage<SysUser>>();
    Page<SysUser> page = new Page<SysUser>(pageNo, pageSize);
    String depId = req.getParameter("depId");
    String username = req.getParameter("username");
    // 根据部门ID查询,当前和下级所有的部门IDS
    List<String> subDepids = new ArrayList<>();
    // 部门id为空时,查询我的部门下所有用户
    if (oConvertUtils.isEmpty(depId)) {
        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
        int userIdentity = user.getUserIdentity() != null ? user.getUserIdentity() : CommonConstant.USER_IDENTITY_1;
        if (oConvertUtils.isNotEmpty(userIdentity) && userIdentity == CommonConstant.USER_IDENTITY_2) {
            subDepids = sysDepartService.getMySubDepIdsByDepId(user.getDepartIds());
        }
    } else {
        subDepids = sysDepartService.getSubDepIdsByDepId(depId);
    }
    if (subDepids != null && subDepids.size() > 0) {
        IPage<SysUser> pageList = sysUserService.getUserByDepIds(page, subDepids, username);
        // 批量查询用户的所属部门
        // step.1 先拿到全部的 useids
        // step.2 通过 useids,一次性查询用户的所属部门名字
        List<String> userIds = pageList.getRecords().stream().map(SysUser::getId).collect(Collectors.toList());
        if (userIds != null && userIds.size() > 0) {
            Map<String, String> useDepNames = sysUserService.getDepNamesByUserIds(userIds);
            pageList.getRecords().forEach(item -> {
                // 批量查询用户的所属部门
                item.setOrgCode(useDepNames.get(item.getId()));
            });
        }
        result.setSuccess(true);
        result.setResult(pageList);
    } else {
        result.setSuccess(true);
        result.setResult(null);
    }
    return result;
}
Also used : Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) LoginUser(org.jeecg.common.system.vo.LoginUser) Result(org.jeecg.common.api.vo.Result) IPage(com.baomidou.mybatisplus.core.metadata.IPage)

Example 57 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project RuoYi-Vue-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 58 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project XHuiCloud by sindaZeng.

the class SqlFilterResolver method resolveArgument.

/**
 * @param parameter 入参集合
 * @param mavContainer model 和 view
 * @param webRequest web相关
 * @param binderFactory 入参解析
 * @return 检查后新的page对象
 * <p>
 * page 只支持查询 GET .如需解析POST获取请求报文体处理
 */
@Override
public Object resolveArgument(MethodParameter parameter, ModelAndViewContainer mavContainer, NativeWebRequest webRequest, WebDataBinderFactory binderFactory) {
    HttpServletRequest request = webRequest.getNativeRequest(HttpServletRequest.class);
    String[] ascs = request.getParameterValues("ascs");
    String[] descs = request.getParameterValues("descs");
    String current = request.getParameter("current");
    String size = request.getParameter("size");
    Page page = new Page();
    if (StrUtil.isNotBlank(current)) {
        page.setCurrent(Long.parseLong(current));
    }
    if (StrUtil.isNotBlank(size)) {
        page.setSize(Long.parseLong(size));
    }
    List<OrderItem> orderItemList = new ArrayList<>();
    Optional.ofNullable(ascs).ifPresent(s -> orderItemList.addAll(Arrays.stream(s).filter(sqlInjectPredicate()).map(OrderItem::asc).collect(Collectors.toList())));
    Optional.ofNullable(descs).ifPresent(s -> orderItemList.addAll(Arrays.stream(s).filter(sqlInjectPredicate()).map(OrderItem::desc).collect(Collectors.toList())));
    page.addOrder(orderItemList);
    return page;
}
Also used : HttpServletRequest(javax.servlet.http.HttpServletRequest) OrderItem(com.baomidou.mybatisplus.core.metadata.OrderItem) ArrayList(java.util.ArrayList) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page)

Example 59 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project kykms by mahonelau.

the class SysDepartRoleController method queryPageList.

/**
 * 分页列表查询
 *
 * @param sysDepartRole
 * @param pageNo
 * @param pageSize
 * @param req
 * @return
 */
@ApiOperation(value = "部门角色-分页列表查询", notes = "部门角色-分页列表查询")
@GetMapping(value = "/list")
public Result<?> queryPageList(SysDepartRole sysDepartRole, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, @RequestParam(name = "deptId", required = false) String deptId, HttpServletRequest req) {
    QueryWrapper<SysDepartRole> queryWrapper = QueryGenerator.initQueryWrapper(sysDepartRole, req.getParameterMap());
    Page<SysDepartRole> page = new Page<SysDepartRole>(pageNo, pageSize);
    LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
    List<String> deptIds = null;
    // if(oConvertUtils.isEmpty(deptId)){
    // if(oConvertUtils.isNotEmpty(user.getUserIdentity()) && user.getUserIdentity().equals(CommonConstant.USER_IDENTITY_2) ){
    // deptIds = sysDepartService.getMySubDepIdsByDepId(user.getDepartIds());
    // }else{
    // return Result.ok(null);
    // }
    // }else{
    // deptIds = sysDepartService.getSubDepIdsByDepId(deptId);
    // }
    // queryWrapper.in("depart_id",deptIds);
    // 我的部门,选中部门只能看当前部门下的角色
    queryWrapper.eq("depart_id", deptId);
    IPage<SysDepartRole> pageList = sysDepartRoleService.page(page, queryWrapper);
    return Result.ok(pageList);
}
Also used : Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) LoginUser(org.jeecg.common.system.vo.LoginUser) ApiOperation(io.swagger.annotations.ApiOperation)

Example 60 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project kykms by mahonelau.

the class SysUserController method departUserList.

/**
 * 部门用户列表
 */
@RequestMapping(value = "/departUserList", method = RequestMethod.GET)
public Result<IPage<SysUser>> departUserList(@RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) {
    Result<IPage<SysUser>> result = new Result<IPage<SysUser>>();
    Page<SysUser> page = new Page<SysUser>(pageNo, pageSize);
    String depId = req.getParameter("depId");
    String username = req.getParameter("username");
    // 根据部门ID查询,当前和下级所有的部门IDS
    List<String> subDepids = new ArrayList<>();
    // 部门id为空时,查询我的部门下所有用户
    if (oConvertUtils.isEmpty(depId)) {
        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
        int userIdentity = user.getUserIdentity() != null ? user.getUserIdentity() : CommonConstant.USER_IDENTITY_1;
        if (oConvertUtils.isNotEmpty(userIdentity) && userIdentity == CommonConstant.USER_IDENTITY_2) {
            subDepids = sysDepartService.getMySubDepIdsByDepId(user.getDepartIds());
        }
    } else {
        subDepids = sysDepartService.getSubDepIdsByDepId(depId);
    }
    if (subDepids != null && subDepids.size() > 0) {
        IPage<SysUser> pageList = sysUserService.getUserByDepIds(page, subDepids, username);
        // 批量查询用户的所属部门
        // step.1 先拿到全部的 useids
        // step.2 通过 useids,一次性查询用户的所属部门名字
        List<String> userIds = pageList.getRecords().stream().map(SysUser::getId).collect(Collectors.toList());
        if (userIds != null && userIds.size() > 0) {
            Map<String, String> useDepNames = sysUserService.getDepNamesByUserIds(userIds);
            pageList.getRecords().forEach(item -> {
                // 批量查询用户的所属部门
                item.setOrgCode(useDepNames.get(item.getId()));
            });
        }
        result.setSuccess(true);
        result.setResult(pageList);
    } else {
        result.setSuccess(true);
        result.setResult(null);
    }
    return result;
}
Also used : Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) LoginUser(org.jeecg.common.system.vo.LoginUser) Result(org.jeecg.common.api.vo.Result) IPage(com.baomidou.mybatisplus.core.metadata.IPage)

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