Examples of com.jpoweredcart.common.PageParam.addOrder()

    model.addAttribute("totalReviewApproval", reviewAdminModel.getTotalAwaitingApproval());
    model.addAttribute("totalAffiliate", affiliateAdminModel.getTotal(new AffiliateFilter()));
    model.addAttribute("totalAffiliateApproval", affiliateAdminModel.getTotalAwaitingApproval());
    
    PageParam orderListParam = PageParam.list(0, 10);
    orderListParam.addOrder("o.date_added", "DESC");
    model.addAttribute("orders", orderAdminModel.getList(orderListParam));
    
    return "/admin/common/home";
  }

      int start, int limit) {
    String sql = "SELECT vh.order_id, o.firstname, o.lastname, vh.amount, vh.date_added FROM "+
      quoteTable("voucher_history")+" vh LEFT JOIN "+quoteTable("order")+
      " o ON (vh.order_id = o.order_id) WHERE vh.voucher_id =?";
    PageParam pageParam = PageParam.list(start, limit);
    pageParam.addOrder("vh.date_added", "ASC");
    QueryBean query = createPaginationQuery(sql, pageParam);
    return getJdbcOperations().query(query.getSql(), query.getParameters(), 
      new VoucherHistoryRowMapper(){
      @Override
      public VoucherHistory mapRow(ResultSet rs, int rowNum)

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.