PHP Pagination::build方法代码示例

 /**
  * Displays URL Aliases with Pagination, also allows the
  * user to easily add/edit/remove existing aliases
  *
  * @return string
  */
 public function indexSection()
 {
     if (!$this->_acl->checkMulti(array('aliases_add', 'aliases_edit', 'aliases_delete'))) {
         throw new Module_NoPermission();
     }
     $this->setTitle(t('URL aliases'));
     $this->setOutputType(self::_OT_CONFIG);
     // Get all the needed aliases to display
     if ($this->inSector('SC') && $this->_input->has('get', 'page')) {
         $curPage = abs($this->_input->get('page') - 1);
     } else {
         $curPage = 0;
     }
     $aliases = $this->_model()->getAll(self::_PER_PAGE, self::_PER_PAGE * $curPage);
     $aliasCount = $this->_model()->getCount();
     if ($aliasCount > 0) {
         $pagination = new Pagination($aliasCount, self::_PER_PAGE);
     }
     // Build and display view
     $view = $this->loadView('overview.html');
     $view->assign(array('ALIASES' => $aliases));
     $view->assignHtml(array('PAGINATION' => isset($pagination) ? $pagination->build() : null, 'CSRF' => $this->_input->createToken(true)));
     // Autocomplete/suggest feature
     $this->_theme->addJsFile('jquery.autocomplete');
     $this->_theme->addCssFile('jquery.autocomplete.css');
     $this->addAsset('js/autocomplete.js');
     return $view->getOutput();
 }

 /**
  * Displays the last X registered users.
  *
  * @return string
  */
 public function indexSection()
 {
     $this->setTitle(t('User management'));
     $this->setOutputType(self::_OT_CONFIG);
     // Check user has correct permission
     if (!$this->_acl->checkMulti(array('users_add', 'users_edit', 'users_delete'))) {
         throw new Module_NoPermission();
     }
     try {
         $curPage = abs($this->_input->get('page') - 1);
     } catch (Input_KeyNoExist $e) {
         $curPage = 0;
     }
     /**
      * Configure Pagination, build and output the main view file
      */
     $pagination = new Pagination($this->_ugmanager->userCount() - 1, self::_PER_PAGE);
     $view = $this->loadView('config/main.html');
     $view->assign(array('USERS' => $this->_ugmanager->getAllUsers(null, self::_PER_PAGE, $curPage * self::_PER_PAGE)));
     $view->assignHtml(array('CSRF' => $this->_input->createToken(true), 'PAGINATION' => $pagination->build()));
     // Autocomplete/suggest feature
     $this->_theme->addJsFile('jquery.autocomplete');
     $this->_theme->addCssFile('jquery.autocomplete.css');
     $this->addAsset('js/autocomplete.js');
     return $view->getOutput();
 }

 /**
  * Displays an overview of pages for a user to manage. Only the parent
  * will be shown, non of the children will be.
  *
  * @return string
  */
 public function indexSection()
 {
     $this->setTitle(t('Manage pages'));
     $this->setOutputType(self::_OT_CONFIG);
     if (!$this->_acl->check('page_manage')) {
         throw new Module_NoPermission();
     }
     // Check what pagination page we are on, and get all pages
     try {
         $curPage = abs($this->_input->get('page') - 1);
     } catch (Input_KeyNoExist $e) {
         $curPage = 0;
     }
     $pages = $this->_model()->getAllPages(self::_PER_PAGE, $curPage * self::_PER_PAGE, 0);
     $pageCount = $this->_model()->getCount();
     if ($pageCount > 0) {
         $pagination = new Pagination($pageCount, self::_PER_PAGE);
     }
     // Build and return view
     $view = $this->loadView('config/overview.html');
     $view->assign(array('PAGES' => $pages));
     $view->assignHtml(array('PAGINATION' => isset($pagination) ? $pagination->build() : '', 'CSRF' => $this->_input->createToken(true)));
     // Autocomplete/suggest feature
     $this->_theme->addJsFile('jquery.autocomplete');
     $this->_theme->addCssFile('jquery.autocomplete.css');
     $this->addAsset('js/autocomplete.js');
     return $view->getOutput();
 }

 /**
  * Displays all of the contact forms, and can also delete the selected
  * contact forms.
  *
  * @return string|bool
  */
 public function indexSection()
 {
     $this->setTitle(t('Manage contact forms'));
     $this->setOutputType(self::_OT_CONFIG);
     if ($this->_input->checkToken()) {
         if (!$this->_acl->check('contact_delete')) {
             throw new Module_NoPermission();
         }
         try {
             $delCount = 0;
             foreach ($this->_input->post('contact_ids') as $fid) {
                 try {
                     $form = $this->_model()->getForm($fid);
                     // Check user has permission
                     $resource = 'contact-form-' . $form['id'];
                     if ($this->_acl->resourceExists($resource) && $this->_acl->check($resource)) {
                         $this->_model()->deleteForm($form['id']);
                         ++$delCount;
                     }
                 } catch (Contact_NoExist $e) {
                 }
             }
             if ($delCount) {
                 $this->_event->success(t('Deleted selected contact forms'));
             }
         } catch (Input_KeyNoExist $e) {
             $this->_event->error(t('No contact forms selected'));
         }
         return zula_redirect($this->_router->makeUrl('contact', 'config'));
     } else {
         if ($this->_acl->checkMulti(array('contact_edit', 'contact_add', 'contact_delete'))) {
             // Find out what page we are on
             try {
                 $curPage = abs($this->_input->get('page') - 1);
             } catch (Input_KeyNoExist $e) {
                 $curPage = 0;
             }
             $forms = $this->_model()->getAllForms(self::_PER_PAGE, $curPage * self::_PER_PAGE);
             $formCount = $this->_model()->getCount();
             if ($formCount > 0) {
                 $pagination = new Pagination($formCount, self::_PER_PAGE);
             }
             $view = $this->loadView('config/overview.html');
             $view->assign(array('FORMS' => $forms, 'COUNT' => $formCount));
             $view->assignHtml(array('PAGINATION' => isset($pagination) ? $pagination->build() : '', 'CSRF' => $this->_input->createToken(true)));
             return $view->getOutput();
         } else {
             throw new Module_NoPermission();
         }
     }
 }

 /**
  * Displays all polls (with pagination), or deletes the selected
  *
  * @return string|bool
  */
 public function indexSection()
 {
     $this->setTitle(t('Manage polls'));
     $this->setOutputType(self::_OT_CONFIG);
     if ($this->_input->checkToken()) {
         // Attempt to delete all selected polls
         if (!$this->_acl->check('poll_delete')) {
             throw new Module_NoPermission();
         }
         try {
             $pollIds = $this->_input->post('poll_ids');
             $count = 0;
             foreach ($pollIds as $pid) {
                 // check if user has permission to the poll
                 $aclResource = 'poll-' . $pid;
                 if ($this->_acl->resourceExists($aclResource) && $this->_acl->check($aclResource)) {
                     $this->_model()->deletePoll($pid);
                     ++$count;
                 }
             }
             if ($count > 0) {
                 $this->_event->success(t('Deleted selected polls'));
             }
         } catch (Input_KeyNoExist $e) {
             $this->_event->error(t('No polls selected'));
         }
         return zula_redirect($this->_router->makeUrl('poll', 'config'));
     } else {
         if ($this->_acl->checkMulti(array('poll_add', 'poll_edit', 'poll_delete'))) {
             // Display certain amount of polls
             try {
                 $curPage = abs($this->_input->get('page') - 1);
             } catch (Input_KeyNoExist $e) {
                 $curPage = 0;
             }
             $polls = $this->_model()->getAllPolls(self::_PER_PAGE, $curPage * self::_PER_PAGE);
             $pollCount = $this->_model()->getCount();
             if ($pollCount > 0) {
                 $pagination = new Pagination($pollCount, self::_PER_PAGE);
             }
             $view = $this->loadView('config/overview.html');
             $view->assign(array('POLLS' => $polls, 'COUNT' => $pollCount));
             $view->assignHtml(array('PAGINATION' => isset($pagination) ? $pagination->build() : '', 'CSRF' => $this->_input->createToken(true)));
             return $view->getOutput();
         } else {
             throw new Module_NoPermission();
         }
     }
 }

 /**
  * Shows comments that can be managed (Edited/deleted etc). Also handles
  * deleting or approving of selected comments.
  *
  * @return string
  */
 public function indexSection()
 {
     $this->setTitle(t('Manage comments'));
     $this->setOutputType(self::_OT_CONFIG);
     if (!$this->_acl->check('comments_manage')) {
         throw new Module_NoPermission();
     }
     if ($this->_input->checkToken()) {
         try {
             $commentIds = $this->_input->post('comments/ids');
             if ($this->_input->has('post', 'comments/approve')) {
                 foreach ($commentIds as $cid) {
                     $this->_model()->edit($cid, array('status' => 'accepted'));
                 }
                 $msg = t('Approved selected comments');
             } else {
                 $this->_model()->delete($commentIds);
                 $msg = t('Deleted selected comments');
             }
             $this->_event->success($msg);
         } catch (Input_KeyNoExist $e) {
             $this->_event->error(t('No comments selected'));
         }
         return zula_redirect($this->_router->makeUrl('comments', 'config'));
     } else {
         try {
             $type = $this->_input->get('type');
         } catch (Input_KeyNoExist $e) {
             $type = $this->_config->get('comments/moderate') ? 'moderation' : 'all';
         }
         // Display the correct comments respecting pagination and build form
         try {
             $curPage = abs($this->_input->get('page') - 1);
         } catch (Input_KeyNoExist $e) {
             $curPage = 0;
         }
         $comments = $this->_model()->get(null, $type, self::_PER_PAGE, self::_PER_PAGE * $curPage, 'DESC');
         $commentsCount = $this->_model()->getCount();
         if ($commentsCount > 0) {
             $pagination = new Pagination($commentsCount, self::_PER_PAGE);
         }
         $view = $this->loadView('config/main.html');
         $view->assign(array('count' => $commentsCount, 'type' => $type));
         $view->assignHtml(array('pagination' => isset($pagination) ? $pagination->build() : '', 'csrf' => $this->_input->createToken(true), 'comments' => $comments));
         return $view->getOutput();
     }
 }

    /**
     * Displays a selective amount of users per page, with details
     * about that users and links to their Profile.
     *
     * @return string
     */
    public function indexSection()
    {
        $this->setTitle(t('User list'));
        // Get correct page/offset
        if ($this->inSector('SC') && $this->_input->has('get', 'page')) {
            $curPage = abs($this->_input->get('page') - 1);
        } else {
            $curPage = 0;
        }
        // Gather all of the users and attach the group name onto the array
        $pdoSt = $this->_sql->prepare('SELECT
												u.id, u.group, u.username, u.email, u.hide_email, u.joined,
												g.name group_name
											FROM {PREFIX}users u
											LEFT JOIN {PREFIX}groups g ON g.id = u.group
											WHERE u.status = "active" AND u.id != ' . Ugmanager::_GUEST_ID . '
											LIMIT :limit OFFSET :offset');
        $pdoSt->bindValue(':limit', self::_PER_PAGE, PDO::PARAM_INT);
        $pdoSt->bindValue(':offset', $curPage * self::_PER_PAGE, PDO::PARAM_INT);
        $pdoSt->execute();
        $users = array();
        foreach ($pdoSt->fetchAll(PDO::FETCH_ASSOC) as $user) {
            if (!empty($user['hide_email']) && $user['id'] != $this->_session->getUserId() && !$this->_acl->check('users_edit')) {
                $user['email'] = t('Hidden');
            }
            $users[] = $user;
        }
        // How many users would have been returned without limit/offset?
        $query = $this->_sql->query('SELECT COUNT(id) FROM {PREFIX}users
											WHERE status = "active" AND id != ' . Ugmanager::_GUEST_ID);
        $totalUsers = $query->fetchColumn();
        $query->closeCursor();
        /**
         * Display the table with pagination
         */
        $pagination = new Pagination($totalUsers, self::_PER_PAGE);
        $view = $this->loadView('index/main.html');
        $view->assign(array('users' => $users));
        $view->assignHtml(array('pagination' => $pagination->build()));
        return $view->getOutput();
    }

 /**
  * Displays published articles for a given category (if any)
  *
  * @param string $category
  * @param bool $catSelector	Toggles the category selector
  * @return string
  */
 protected function displayArticles($category = false, $catSelector = true)
 {
     $this->setOutputType(self::_OT_CONTENT_INDEX);
     if (empty($category)) {
         $this->setTitle(t('Latest articles'));
         $categories = $this->_model()->getAllCategories();
         $cid = null;
     } else {
         /**
          * Attempt to get the single article category details, and check permission
          */
         try {
             $category = $this->_model()->getCategory($category, false);
             $this->setTitle($category['title']);
             $categories = array($category['id'] => $category);
             $cid = $category['id'];
             $resource = 'article-cat-' . $category['id'];
             if (!$this->_acl->resourceExists($resource) || !$this->_acl->check($resource)) {
                 throw new Module_NoPermission();
             }
         } catch (Article_CatNoExist $e) {
             throw new Module_ControllerNoExist();
         }
     }
     /**
      * Check how many to display per page, and what page we are on
      */
     try {
         $perPage = abs($this->_config->get('article/per_page'));
     } catch (Input_KeyNoExist $e) {
         $perPage = 12;
     }
     if ($this->inSector('SC') && $this->_input->has('get', 'page')) {
         $curPage = abs($this->_input->get('page') - 1);
     } else {
         $curPage = 0;
     }
     // Get the required articles and parse their first article part body
     $maxDisplayAge = $this->_config->get('article/max_display_age');
     $articles = array();
     foreach ($this->_model()->getAllArticles($perPage, $curPage * $perPage, $cid, false, $maxDisplayAge) as $tmpArticle) {
         if (isset($categories[$tmpArticle['cat_id']])) {
             $parts = $this->_model()->getArticleParts($tmpArticle['id']);
             $firstPart = current($parts);
             $editor = new Editor($firstPart['body']);
             $editor->setContentUrl($this->_router->makeUrl('article', 'view', $tmpArticle['identifier']));
             $tmpArticle['body'] = $editor->parse(true);
             $tmpArticle['category_title'] = $categories[$tmpArticle['cat_id']]['title'];
             $tmpArticle['category_identifier'] = $categories[$tmpArticle['cat_id']]['identifier'];
             $articles[] = $tmpArticle;
         }
     }
     $articleCount = $this->_model()->getCount();
     if ($articleCount > 0) {
         $pagination = new Pagination($articleCount, $perPage);
     }
     // Build up the view
     $view = $this->loadView('index/latest.html');
     $view->assign(array('META_FORMAT' => $this->getMetaFormat($this->_config->get('article/meta_format')), 'CAT_DETAILS' => $cid ? $category : null));
     $view->assignHtml(array('ARTICLES' => $articles, 'PAGINATION' => isset($pagination) ? $pagination->build() : null));
     if ($cid == false && $catSelector) {
         /** Prepend the category selector */
         $catSelectorView = $this->loadView('index/category_selector.html');
         $catSelectorView->assign(array('CATEGORIES' => $categories));
         return $catSelectorView->getOutput() . $view->getOutput(true);
     } else {
         return $view->getOutput(true);
     }
 }

 /**
  * Displays all articles with pagination (including unpublished articles).
  * It will also delete all selected articles.
  *
  * @return string|bool
  */
 public function indexSection()
 {
     $this->setTitle(t('Manage articles'));
     $this->setOutputType(self::_OT_CONFIG);
     if ($this->_input->checkToken()) {
         // Delete all selected articles
         if (!$this->_acl->check('article_delete_article')) {
             throw new Module_NoPermission();
         }
         try {
             $ids = $this->_input->post('article_ids');
             $count = 0;
             foreach ($ids as $aid) {
                 try {
                     $article = $this->_model()->getArticle($aid);
                     // Check user permission
                     $resource = 'article-cat-' . $article['cat_id'];
                     if ($this->_acl->resourceExists($resource) && $this->_acl->check($resource)) {
                         $this->_model()->deleteArticle($article['id']);
                         ++$count;
                     }
                 } catch (Article_NoExist $e) {
                 }
             }
             if ($count) {
                 $this->_event->success(t('Deleted selected articles'));
             }
         } catch (Input_KeyNoExist $e) {
             $this->_event->error(t('No articles selected'));
         }
         return zula_redirect($this->_router->makeUrl('article', 'config'));
     } else {
         if ($this->_acl->checkMulti(array('article_add_article', 'article_edit_article', 'article_delete_article'))) {
             /**
              * Attempt to get details for the category if one was provided
              */
             try {
                 if (($cid = $this->_input->get('cid')) != false) {
                     $category = $this->_model()->getCategory($cid);
                     // Check user has permission to this category
                     $resource = 'article-cat-' . $category['id'];
                     if ($this->_acl->resourceExists($resource) && $this->_acl->check($resource)) {
                         $this->setTitle(sprintf(t('Manage "%s" articles'), $category['title']));
                     } else {
                         throw new Module_NoPermission();
                     }
                 }
             } catch (Input_KeyNoExist $e) {
                 $cid = null;
             } catch (Article_CatNoExist $e) {
                 $cid = null;
             }
             // Get the page which we are on
             try {
                 $curPage = abs($this->_input->get('page') - 1);
             } catch (Input_KeyNoExist $e) {
                 $curPage = 0;
             }
             $articles = $this->_model()->getAllArticles(self::_PER_PAGE, $curPage * self::_PER_PAGE, $cid, true);
             $articleCount = $this->_model()->getCount();
             if ($articleCount > 0) {
                 $pagination = new Pagination($articleCount, self::_PER_PAGE);
             }
             // Build up the main view
             $view = $this->loadView('config/overview.html');
             $view->assign(array('ARTICLES' => $articles, 'COUNT' => $articleCount, 'CATEGORIES' => $this->_model()->getAllCategories(), 'CURRENT_CID' => $cid));
             $view->assignHtml(array('PAGINATION' => isset($pagination) ? $pagination->build() : '', 'CSRF' => $this->_input->createToken(true)));
             $this->_theme->addJsFile('jquery.autocomplete');
             $this->_theme->addCssFile('jquery.autocomplete.css');
             $this->addAsset('js/autocomplete.js');
             return $view->getOutput();
         } else {
             throw new Module_NoPermission();
         }
     }
 }

 public function overview($tpl = null, $pagination = 0, CustomDataFilter $filter = null)
 {
     if ($filter === null) {
         $filter = new CustomDataFilter($this->position);
         foreach ($this->mainFields as $field) {
             $filter->field($field);
         }
         $filter->orderBy(reset($this->mainFields));
     }
     $pages = '';
     if ($pagination > 0) {
         $pg = new Pagination($pagination, $filter->getAmount());
         $pg->setUri($this->baseUri);
         $pg->parsePage();
         $filter->limit($pg->getPerPage(), $pg->getOffset());
         $pages = $pg->build();
     }
     $tpl = Response::getObject()->appendTemplate($tpl ? $tpl : "/Cms/fields/data_categories");
     $tpl->assign('pages', $pages, false);
     $tpl->assign('list', $filter->retrieveList(), false);
     $tpl->assign('baseUri', $this->baseUri);
     $tpl->output();
 }

 /**
  * Builds the view to display latest media items from all
  * categories, or a specific category.
  *
  * @param string $category
  * @return string
  */
 protected function buildLatest($category = null)
 {
     if ($category == null) {
         $cid = null;
     } else {
         try {
             $category = $this->_model()->getCategory($category, false);
             $cid = $category['id'];
             $resource = 'media-cat_view_' . $category['id'];
             if (!$this->_acl->resourceExists($resource) || !$this->_acl->check($resource)) {
                 throw new Module_NoPermission();
             }
             $this->setTitle($category['name']);
             // Check if the user can upload/add items to this category
             if ($this->_acl->check('media-cat_upload_' . $cid)) {
                 $this->setPageLinks(array(t('Upload/add media item') => $this->_router->makeUrl('media', 'add')->queryArgs(array('cid' => $cid))));
             }
         } catch (Media_CategoryNoExist $e) {
             throw new Module_ControllerNoExist();
         }
     }
     // Check if details for the items should be displayed
     try {
         $showDetails = (bool) $this->_config->get('media/show_item_details');
     } catch (Config_KeyNoExist $e) {
         $showDetails = true;
     }
     // Get number of latest media items to display, and which page we are on
     $perPage = abs($this->_config->get('media/per_page'));
     if ($this->inSector('SC') && $this->_input->has('get', 'page')) {
         $curPage = abs($this->_input->get('page') - 1);
     } else {
         $curPage = 0;
     }
     $items = $this->_model()->getItems($perPage, $perPage * $curPage, $cid);
     $itemCount = $this->_model()->getItemCount();
     if ($itemCount) {
         $pagination = new Pagination($itemCount, $perPage);
     }
     $view = $this->loadView('index/latest.html');
     $view->assign(array('ITEMS' => $items, 'CATEGORY' => $category, 'SHOW_DETAILS' => $showDetails));
     $view->assignHtml(array('PAGINATION' => isset($pagination) ? $pagination->build() : ''));
     // Check if lightbox effect needs to be used
     if ($this->_config->get('media/use_lightbox')) {
         $this->_theme->addJsFile('jquery.tangobox');
         $this->_theme->addCssFile('jquery.tangobox.css');
         $view->assign(array('LIGHTBOX' => true));
     } else {
         $view->assign(array('LIGHTBOX' => false));
     }
     return $view->getOutput();
 }

 /**
  * Magic method - allows for shorter URL's eg:
  * /article/view/clean-title
  *
  * @param string $name
  * @param array $args
  * @return string
  */
 public function __call($name, $args)
 {
     $this->setOutputType(self::_OT_CONTENT_DYNAMIC);
     try {
         $article = $this->_model()->getArticle(substr($name, 0, -7), false);
         $this->setTitle($article['title']);
         $category = $this->_model()->getCategory($article['cat_id']);
         // Check permission to parent category
         $resource = 'article-cat-' . $category['id'];
         if (!$this->_acl->resourceExists($resource) || !$this->_acl->check($resource)) {
             throw new Module_NoPermission();
         } else {
             if (!$article['published']) {
                 throw new Module_ControllerNoExist();
             }
         }
         /**
          * Gather all parts for this article, and check the requested part actually exists
          */
         try {
             $part = abs($this->_input->get('part'));
         } catch (Input_KeyNoExist $e) {
             $part = 0;
         }
         $articleParts = array_values($this->_model()->getArticleParts($article['id'], false));
         # Done to reindex array
         try {
             // Get details for the correct part
             if (empty($part)) {
                 $partId = $articleParts[0]['id'];
             } else {
                 if (isset($articleParts[$part - 1]['id'])) {
                     $partId = $articleParts[$part - 1]['id'];
                 } else {
                     throw new Article_PartNoExist($part);
                 }
             }
             $requestedPart = $this->_model()->getPart($partId);
             $editor = new Editor($requestedPart['body']);
             $body = $editor->parse();
         } catch (Article_PartNoExist $e) {
             throw new Module_ControllerNoExist();
         }
         /**
          * Build up pagination and the main view file
          */
         try {
             $curPage = abs($this->_input->get('part') - 1);
         } catch (Input_KeyNoExist $e) {
             $curPage = 0;
         }
         $pagination = new Pagination(count($articleParts), 1, 'part');
         if (count($articleParts) > 1) {
             $this->addAsset('js/jumpbox.js');
         }
         $view = $this->loadView('view/article.html');
         $view->assign(array('META_FORMAT' => $this->getMetaFormat($this->_config->get('article/meta_format')), 'ARTICLE' => $article, 'REQUESTED_PART' => $requestedPart, 'ARTICLE_PARTS' => $articleParts, 'CATEGORY' => $category));
         $view->assignHtml(array('BODY' => $body, 'PAGINATION' => $pagination->build()));
         return $view->getOutput(true);
     } catch (Article_NoExist $e) {
         throw new Module_ControllerNoExist();
     }
 }

 protected function members()
 {
     $db = Database::getObject();
     $db->query("SELECT COUNT(*) FROM <p>user");
     $pp = Config::get('pagination.admin');
     $pg = new Pagination($pp, $db->fetchOne());
     $pg->parsePage();
     $pg->setUri(Uri::build('/Cms/admin/members'));
     $offset = $pg->getOffset();
     $db->query("SELECT * FROM <p>user ORDER BY surname, forename LIMIT <offset:int>, <pp:int>", compact("offset", "pp"));
     $data = array();
     while ($row = $db->fetchAssoc()) {
         $row['group'] = UserUtils::getGroupName($row['group_id']);
         $data[] = $row;
     }
     $tpl = Response::getObject()->appendTemplate("Cms/admin/members");
     $tpl->assign("pages", $pg->build(), false);
     $tpl->assign("data", $data);
     $tpl->output();
 }