How to use

Pageable

in

com.haoxuer.discover.data.page

@Override
public List<T> list(Pageable pageable) {
 List<T> result = null;
 List<Filter> filters = pageable.getFilters();
 List<Order> orders = pageable.getOrders();
 Finder finder = makeFinder(filters, orders);
 result = find(finder);
 return result;
}

@Override
public boolean equals(Object obj) {
 if (obj == null) {
  return false;
 }
 if (getClass() != obj.getClass()) {
  return false;
 }
 if (this == obj) {
  return true;
 }
 Pageable other = (Pageable) obj;
 return new EqualsBuilder().append(getPageNumber(), other.getPageNumber()).append(getPageSize(), other.getPageSize()).append(getSearchProperty(), other.getSearchProperty()).append(getSearchValue(), other.getSearchValue()).append(getOrderProperty(), other.getOrderProperty()).append(getOrderDirection(), other.getOrderDirection()).append(getFilters(), other.getFilters())
   .append(getOrders(), other.getOrders()).isEquals();
}

@Override
public List<Link> list() {
 Integer size = getInt("size");
 Integer id = getInt("id");
 Pageable pagex = new Pageable();
 pagex.setPageSize(size);
 pagex.setPageNumber(1);
 pagex.getFilters().add(Filter.eq("linkType.id", id));
 return linkService.list(0, size, pagex.getFilters(), pagex.getOrders());
}

@Override
public Pagination<T> findByPage(Pageable pageable) {
 List<Filter> filters = pageable.getFilters();
 List<Order> orders = pageable.getOrders();
 Finder finder = makeFinder(filters, orders);
 Pagination<T> page = find(finder, pageable.getPageNumber(), pageable.getPageSize());
 return page;
}

@RequiresPermissions("userlabel")
@RequestMapping("/admin/userlabel/view_list")
public String list(Pageable pageable, UserLabelSo so, ModelMap model) {
 if (pageable == null) {
  pageable = new Pageable();
 }
 if (pageable.getOrders().isEmpty()) {
  pageable.getOrders().add(Order.desc("id"));
 }
 pageable.getFilters().addAll(FilterUtils.getFilters(so));
 Page<UserLabel> pagination = manager.page(pageable);
 model.addAttribute("list", pagination.getContent());
 model.addAttribute("page", pagination);
 model.addAttribute("so", so);
 return "/admin/userlabel/list";
}

/**
 * 获取筛选
 *
 * @return 筛选
 */
public List<Filter> getFilters() {
 return pageable.getFilters();
}

 pageable = new Pageable();
if (StringUtils.isNotEmpty(pageable.getSearchProperty()) && StringUtils.isNotEmpty(pageable.getSearchValue())) {
 countQuery.add(Restrictions.like(pageable.getSearchProperty(), "%" + pageable.getSearchValue() + "%"));
Long total = count(countQuery, pageable.getFilters());
if (total == null) {
 total = 0l;
if (StringUtils.isNotEmpty(pageable.getSearchProperty()) && StringUtils.isNotEmpty(pageable.getSearchValue())) {
 criteriaQuery.add(Restrictions.like(pageable.getSearchProperty(), "%" + pageable.getSearchValue() + "%"));
addRestrictions(criteriaQuery, pageable.getFilters());
int totalPages = (int) Math.ceil((double) total / (double) pageable.getPageSize());
if (totalPages < pageable.getPageNumber()) {
 pageable.setPageNumber(totalPages);
if (StringUtils.isNotEmpty(pageable.getSearchAliasProperty()) && pageable.getSearchAliasValue() == null) {
 criteriaQuery.createAlias(pageable.getSearchAliasProperty().split("[.]")[0],
   pageable.getSearchAliasProperty().split("[.]")[0])
   .add(Restrictions.isNotNull(pageable.getSearchAliasProperty()));
if (StringUtils.isNotEmpty(pageable.getSearchAliasProperty()) && pageable.getSearchAliasValue() != null) {
 criteriaQuery.createAlias(pageable.getSearchAliasProperty().split("[.]")[0],
   pageable.getSearchAliasProperty().split("[.]")[0])
   .add(Restrictions.eq(pageable.getSearchAliasProperty(), pageable.getSearchAliasValue()));
criteriaQuery.setFirstResult((pageable.getPageNumber() - 1) * pageable.getPageSize());

/**
 * 获取页码
 *
 * @return 页码
 */
public int getPageNumber() {
 return pageable.getPageNumber();
}

@Override
public NotificationPage page(NotificationPageRequest request) {
 NotificationPage result = new NotificationPage();
 Long uid = UserUtils.getApp(request.getUserToken());
 UserInfo user = userDao.findById(uid);
 if (user == null) {
  result.setMsg("该用户不存在!");
  result.setCode(-101);
  return result;
 }
 Pageable pageable = new Pageable();
 pageable.setPageSize(request.getSize());
 pageable.setPageNo(request.getNo());
 pageable.getFilters().add(Filter.eq("user.id", uid));
 Page<UserNotificationMember> page = notificationMemberDao.page(pageable);
 ConverResourceUtils.coverPage(result, page, new UserNotificationSimpleFromMemberConver());
 
 return result;
}
 

@RequiresPermissions("appversion")
@RequestMapping("/app/view_list")
public String list(Pageable pageable, HttpServletRequest request, ModelMap model) {
 if (pageable == null) {
  pageable = new Pageable();
 }
 if (pageable.getOrders() == null || pageable.getOrders().size() == 0) {
  pageable.getOrders().add(Order.desc("id"));
 }
 Page<App> pagination = manager.page(pageable);
 model.addAttribute("list", pagination.getContent());
 model.addAttribute("page", pagination);
 return "/admin/app/list";
}

@Override
@Transactional
public UserNotification push(UserNotification bean) {
 bean.setStoreState(StoreState.normal);
 bean.setCategory(NotificationCategory.push);
 dao.save(bean);
 Integer total = 0;
 Pageable pageable = new Pageable();
 pageable.setPageSize(200);
 Page<User> page = userDao.page(pageable);
 total = total + sendUsers(bean, page);
 int totalPage = page.getTotalPages();
 for (int i = 2; i <= totalPage; i++) {
  pageable.setPageNumber(i);
  Page<User> pageData = userDao.page(pageable);
  total = total + sendUsers(bean, pageData);
 }
 bean.setNums(total);
 return bean;
}

private void addOrders(Criteria criteriaQuery, Pageable pageable) {
 if (criteriaQuery == null || pageable == null) {
  return;
 }
 if (StringUtils.isNotEmpty(pageable.getOrderProperty()) && pageable.getOrderDirection() != null) {
  if (pageable.getOrderDirection() == Direction.asc) {
   criteriaQuery.addOrder(org.hibernate.criterion.Order.asc(pageable.getOrderProperty()));
  } else if (pageable.getOrderDirection() == Direction.desc) {
   criteriaQuery.addOrder(org.hibernate.criterion.Order.desc(pageable.getOrderProperty()));
  }
 }
 if (pageable.getOrders() != null) {
  for (Order order : pageable.getOrders()) {
   if (order.getDirection() == Direction.asc) {
    criteriaQuery.addOrder(org.hibernate.criterion.Order.asc(order.getProperty()));
   } else if (order.getDirection() == Direction.desc) {
    criteriaQuery.addOrder(org.hibernate.criterion.Order.desc(order.getProperty()));
   }
  }
 }
}
 

/**
 * 获取排序
 *
 * @return 排序
 */
public List<Order> getOrders() {
 return pageable.getOrders();
}

/**
 * 初始化一个新创建的Page对象
 */
public Page() {
 this.total = 0L;
 this.pageable = new Pageable();
}

@RequiresPermissions("usermessage")
@RequestMapping("/admin/usermessage/view_list")
public String list(Pageable pageable, UserMessageSo so, ModelMap model) {
 if (pageable == null) {
  pageable = new Pageable();
 }
 if (pageable.getOrders().isEmpty()) {
  pageable.getOrders().add(Order.desc("id"));
 }
 pageable.getFilters().addAll(FilterUtils.getFilters(so));
 Page<UserMessage> pagination = manager.page(pageable);
 model.addAttribute("list", pagination.getContent());
 model.addAttribute("page", pagination);
 model.addAttribute("so", so);
 return "/admin/usermessage/list";
}

@Override
public Page<UserVerification> page(Pageable pageable, Object search) {
 List<Filter> filters = FilterUtils.getFilters(search);
 if (filters != null) {
  pageable.getFilters().addAll(filters);
 }
 return dao.page(pageable);
}
 

 private void initRedirectData(Pageable pageable, RedirectAttributes redirectAttributes) {
  redirectAttributes.addAttribute("pageNumber", pageable.getPageNumber());
 }
}

@Override
public Page<T> page(Pageable pageable) {
 Page<T> result = null;
 List<Filter> filters = pageable.getFilters();
 List<Order> orders = pageable.getOrders();
 Finder finder = makeFinder(filters, orders);
 Pagination<T> page = find(finder, pageable.getPageNumber(), pageable.getPageSize());
 result = new Page<T>(page.getList(), page.getTotalCount(), pageable);
 return result;
}

@RequiresPermissions("usercode")
@RequestMapping("/admin/usercode/view_list")
public String list(Pageable pageable, UserCodeSo so, ModelMap model) {
 if (pageable == null) {
  pageable = new Pageable();
 }
 if (pageable.getOrders().isEmpty()) {
  pageable.getOrders().add(Order.desc("id"));
 }
 pageable.getFilters().addAll(FilterUtils.getFilters(so));
 Page<UserCode> pagination = manager.page(pageable);
 model.addAttribute("list", pagination.getContent());
 model.addAttribute("page", pagination);
 model.addAttribute("so", so);
 return "/admin/usercode/list";
}

@RequiresPermissions("userloginlog")
@RequestMapping("/admin/userloginlog/view_list")
public String list(Pageable pageable, UserLoginLogSo so, ModelMap model) {
 if (pageable != null) {
  if (pageable.getOrders() == null || pageable.getOrders().isEmpty()) {
   pageable.getOrders().add(Order.desc("id"));
  }
 }
 pageable.getFilters().addAll(FilterUtils.getFilters(so));
 Page<UserLoginLog> pagination = manager.page(pageable);
 model.addAttribute("list", pagination.getContent());
 model.addAttribute("page", pagination);
 model.addAttribute("so", so);
 return "/admin/userloginlog/list";
}