Examples with Page com.baomidou.mybatisplus.extension.plugins.pagination.Page used on opensource projects

Example 96 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project mybatis-plus-samples by baomidou.

the class PaginationTest method tests1.

@Test
void tests1() {
    log.error("----------------------------------baseMapper 自带分页-------------------------------------------------------");
    Page<User> page = new Page<>(1, 5);
    page.addOrder(OrderItem.asc("age"));
    Page<User> userIPage = mapper.selectPage(page, Wrappers.<User>lambdaQuery().eq(User::getAge, 20).like(User::getName, "Jack"));
    assertThat(page).isSameAs(userIPage);
    log.error("总条数 -------------> {}", userIPage.getTotal());
    log.error("当前页数 -------------> {}", userIPage.getCurrent());
    log.error("当前每页显示数 -------------> {}", userIPage.getSize());
    List<User> records = userIPage.getRecords();
    assertThat(records).isNotEmpty();
    log.error("----------------------------------json 正反序列化-------------------------------------------------------");
    String json = JSON.toJSONString(page);
    log.info("json ----------> {}", json);
    Page<User> page1 = JSON.parseObject(json, new TypeReference<Page<User>>() {
    });
    List<User> records1 = page1.getRecords();
    assertThat(records1).isNotEmpty();
    assertThat(records1.get(0).getClass()).isEqualTo(User.class);
    log.error("----------------------------------自定义 XML 分页-------------------------------------------------------");
    MyPage<User> myPage = new MyPage<User>(1, 5).setSelectInt(20).setSelectStr("Jack");
    ParamSome paramSome = new ParamSome(20, "Jack");
    MyPage<User> userMyPage = mapper.mySelectPage(myPage, paramSome);
    assertThat(myPage).isSameAs(userMyPage);
    log.error("总条数 -------------> {}", userMyPage.getTotal());
    log.error("当前页数 -------------> {}", userMyPage.getCurrent());
    log.error("当前每页显示数 -------------> {}", userMyPage.getSize());
}

Example 97 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project mybatis-plus-samples by baomidou.

the class PaginationTest method test.

@Test
void test() {
    userService.lambdaQuery().like(User::getName, "a").list().forEach(System.out::println);
    Page page = userService.lambdaQuery().like(User::getName, "a").page(new Page<>(1, 10));
    page.getRecords().forEach(System.out::println);
}

Example 98 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project jeebiz-boot by Jeebiz.

the class BaseServiceImpl method getPagedList.

/**
 * 分页查询
 *
 * @param t
 * @return
 */
@Override
public Page<T> getPagedList(PaginationEntity<T> model) {
    Page<T> page = new Page<T>(model.getPageNo(), model.getLimit());
    if (!CollectionUtils.isEmpty(model.getOrders())) {
        for (OrderItem orderBy : model.getOrders()) {
            page.addOrder(orderBy);
        }
    }
    List<T> records = getBaseMapper().getPagedList(page, model);
    page.setRecords(records);
    return page;
}

Example 99 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project mogu_blog_v2 by moxi624.

the class CommentServiceImpl method getPageList.

@Override
public IPage<Comment> getPageList(CommentVO commentVO) {
    QueryWrapper<Comment> queryWrapper = new QueryWrapper<>();
    if (StringUtils.isNotEmpty(commentVO.getKeyword()) && !StringUtils.isEmpty(commentVO.getKeyword().trim())) {
        queryWrapper.like(SQLConf.CONTENT, commentVO.getKeyword().trim());
    }
    if (commentVO.getType() != null) {
        queryWrapper.eq(SQLConf.TYPE, commentVO.getType());
    }
    if (StringUtils.isNotEmpty(commentVO.getSource()) && !SysConf.ALL.equals(commentVO.getSource())) {
        queryWrapper.eq(SQLConf.SOURCE, commentVO.getSource());
    }
    if (StringUtils.isNotEmpty(commentVO.getUserName())) {
        String userName = commentVO.getUserName();
        QueryWrapper<User> userQueryWrapper = new QueryWrapper<>();
        userQueryWrapper.like(SQLConf.NICK_NAME, userName);
        userQueryWrapper.eq(SQLConf.STATUS, EStatus.ENABLE);
        List<User> list = userService.list(userQueryWrapper);
        if (list.size() > 0) {
            List<String> userUid = new ArrayList<>();
            list.forEach(item -> {
                userUid.add(item.getUid());
            });
            queryWrapper.in(SQLConf.USER_UID, userUid);
        } else {
            // 当没有查询到用户时，默认UID
            queryWrapper.in(SQLConf.USER_UID, SysConf.DEFAULT_UID);
        }
    }
    Page<Comment> page = new Page<>();
    page.setCurrent(commentVO.getCurrentPage());
    page.setSize(commentVO.getPageSize());
    queryWrapper.eq(SQLConf.STATUS, EStatus.ENABLE);
    queryWrapper.orderByDesc(SQLConf.CREATE_TIME);
    IPage<Comment> pageList = commentService.page(page, queryWrapper);
    List<Comment> commentList = pageList.getRecords();
    Set<String> userUidSet = new HashSet<>();
    Set<String> blogUidSet = new HashSet<>();
    commentList.forEach(item -> {
        if (StringUtils.isNotEmpty(item.getUserUid())) {
            userUidSet.add(item.getUserUid());
        }
        if (StringUtils.isNotEmpty(item.getToUserUid())) {
            userUidSet.add(item.getToUserUid());
        }
        if (StringUtils.isNotEmpty(item.getBlogUid())) {
            blogUidSet.add(item.getBlogUid());
        }
    });
    // 获取博客
    Collection<Blog> blogList = new ArrayList<>();
    if (blogUidSet.size() > 0) {
        blogList = blogService.listByIds(blogUidSet);
    }
    Map<String, Blog> blogMap = new HashMap<>();
    blogList.forEach(item -> {
        // 评论管理并不需要查看博客内容，因此将其排除
        item.setContent("");
        blogMap.put(item.getUid(), item);
    });
    // 获取头像
    Collection<User> userCollection = new ArrayList<>();
    if (userUidSet.size() > 0) {
        userCollection = userService.listByIds(userUidSet);
    }
    final StringBuffer fileUids = new StringBuffer();
    userCollection.forEach(item -> {
        if (StringUtils.isNotEmpty(item.getAvatar())) {
            fileUids.append(item.getAvatar() + SysConf.FILE_SEGMENTATION);
        }
    });
    String pictureList = null;
    if (fileUids != null) {
        pictureList = this.pictureFeignClient.getPicture(fileUids.toString(), SysConf.FILE_SEGMENTATION);
    }
    List<Map<String, Object>> picList = webUtil.getPictureMap(pictureList);
    Map<String, String> pictureMap = new HashMap<>();
    picList.forEach(item -> {
        pictureMap.put(item.get(SQLConf.UID).toString(), item.get(SQLConf.URL).toString());
    });
    Map<String, User> userMap = new HashMap<>();
    userCollection.forEach(item -> {
        // 判断头像是否为空
        if (pictureMap.get(item.getAvatar()) != null) {
            item.setPhotoUrl(pictureMap.get(item.getAvatar()));
        }
        userMap.put(item.getUid(), item);
    });
    for (Comment item : commentList) {
        try {
            ECommentSource commentSource = ECommentSource.valueOf(item.getSource());
            item.setSourceName(commentSource.getName());
        } catch (Exception e) {
            log.error("ECommentSource 转换异常");
        }
        if (StringUtils.isNotEmpty(item.getUserUid())) {
            item.setUser(userMap.get(item.getUserUid()));
        }
        if (StringUtils.isNotEmpty(item.getToUserUid())) {
            item.setToUser(userMap.get(item.getToUserUid()));
        }
        if (StringUtils.isNotEmpty(item.getBlogUid())) {
            item.setBlog(blogMap.get(item.getBlogUid()));
        }
    }
    pageList.setRecords(commentList);
    return pageList;
}

Example 100 with Page

use of com.baomidou.mybatisplus.extension.plugins.pagination.Page in project mogu_blog_v2 by moxi624.

the class LinkServiceImpl method getPageList.

@Override
public IPage<Link> getPageList(LinkVO linkVO) {
    QueryWrapper<Link> queryWrapper = new QueryWrapper<>();
    if (StringUtils.isNotEmpty(linkVO.getKeyword()) && !StringUtils.isEmpty(linkVO.getKeyword().trim())) {
        queryWrapper.like(SQLConf.TITLE, linkVO.getKeyword().trim());
    }
    if (linkVO.getLinkStatus() != null) {
        queryWrapper.eq(SQLConf.LINK_STATUS, linkVO.getLinkStatus());
    }
    if (StringUtils.isNotEmpty(linkVO.getOrderByAscColumn())) {
        String column = StringUtils.underLine(new StringBuffer(linkVO.getOrderByAscColumn())).toString();
        queryWrapper.orderByAsc(column);
    } else if (StringUtils.isNotEmpty(linkVO.getOrderByDescColumn())) {
        String column = StringUtils.underLine(new StringBuffer(linkVO.getOrderByDescColumn())).toString();
        queryWrapper.orderByDesc(column);
    } else {
        queryWrapper.orderByDesc(SQLConf.SORT);
    }
    Page<Link> page = new Page<>();
    page.setCurrent(linkVO.getCurrentPage());
    page.setSize(linkVO.getPageSize());
    queryWrapper.eq(SQLConf.STATUS, EStatus.ENABLE);
    IPage<Link> pageList = linkService.page(page, queryWrapper);
    List<Link> linkList = pageList.getRecords();
    final StringBuffer fileUids = new StringBuffer();
    // 给友情链接添加图片
    linkList.forEach(item -> {
        if (StringUtils.isNotEmpty(item.getFileUid())) {
            fileUids.append(item.getFileUid() + SysConf.FILE_SEGMENTATION);
        }
    });
    String pictureList = null;
    Map<String, String> pictureMap = new HashMap<>();
    if (fileUids != null) {
        pictureList = pictureFeignClient.getPicture(fileUids.toString(), SysConf.FILE_SEGMENTATION);
    }
    List<Map<String, Object>> picList = webUtil.getPictureMap(pictureList);
    picList.forEach(item -> {
        pictureMap.put(item.get(SysConf.UID).toString(), item.get(SysConf.URL).toString());
    });
    for (Link item : linkList) {
        // 获取图片
        if (StringUtils.isNotEmpty(item.getFileUid())) {
            List<String> pictureUidsTemp = StringUtils.changeStringToString(item.getFileUid(), Constants.SYMBOL_COMMA);
            List<String> pictureListTemp = new ArrayList<>();
            pictureUidsTemp.forEach(picture -> {
                pictureListTemp.add(pictureMap.get(picture));
            });
            item.setPhotoList(pictureListTemp);
        }
    }
    pageList.setRecords(linkList);
    return pageList;
}