Actions

J1.5

Difference between revisions of "Using JPagination in your component"

From Joomla! Documentation

m
(Example JDatabase + made color coding)
Line 17: Line 17:
  
 
=====getPagesCounter()=====
 
=====getPagesCounter()=====
<pre>
+
<source lang="php">
 
/**
 
/**
 
* Create and return the pagination pages counter string
 
* Create and return the pagination pages counter string
Line 26: Line 26:
 
*/
 
*/
 
function getPagesCounter()
 
function getPagesCounter()
</pre>
+
</source>
  
 
Returns a string containing the current page and total pages as [[image:pagescounter.png]]
 
Returns a string containing the current page and total pages as [[image:pagescounter.png]]
  
 
=====getResultsCounter()=====
 
=====getResultsCounter()=====
<pre>
+
<source lang="php">
 
/**
 
/**
 
* Create and return the pagination result set counter string
 
* Create and return the pagination result set counter string
Line 40: Line 40:
 
*/
 
*/
 
function getResultsCounter()
 
function getResultsCounter()
</pre>
+
</source>
  
 
Returns a string containing the results currently being displayed as [[image:resultscounter.png]]
 
Returns a string containing the results currently being displayed as [[image:resultscounter.png]]
  
 
=====getPagesLinks()=====
 
=====getPagesLinks()=====
<pre>
+
<source lang="php">
 
/**
 
/**
 
* Create and return the pagination page list string, ie. Previous, Next, 1 2 3 ... x
 
* Create and return the pagination page list string, ie. Previous, Next, 1 2 3 ... x
Line 54: Line 54:
 
*/
 
*/
 
function getPagesLinks()
 
function getPagesLinks()
</pre>
+
</source>
  
 
Returns an HTML string to display the Pages Links as [[image:pageslinks.png]]
 
Returns an HTML string to display the Pages Links as [[image:pageslinks.png]]
  
 
=====getListFooter()=====
 
=====getListFooter()=====
<pre>
+
<source lang="php">
 
/**
 
/**
 
* Return the pagination footer
 
* Return the pagination footer
Line 68: Line 68:
 
*/
 
*/
 
function getListFooter()
 
function getListFooter()
</pre>
+
</source>
  
 
Returns a combination of the several page-related elements, including: the Display Limit dropdown, the Pages Links and the Pages Counter.  Appearance differs in the Front-end and Back-end due to additional CSS formatting applied with the Khepri template.
 
Returns a combination of the several page-related elements, including: the Display Limit dropdown, the Pages Links and the Pages Counter.  Appearance differs in the Front-end and Back-end due to additional CSS formatting applied with the Khepri template.
Line 77: Line 77:
  
 
=====getLimitBox()=====
 
=====getLimitBox()=====
<pre>
+
<source lang="php">
 
/**
 
/**
 
* Creates a dropdown box for selecting how many records to show per page
 
* Creates a dropdown box for selecting how many records to show per page
Line 86: Line 86:
 
*/
 
*/
 
function getLimitBox()
 
function getLimitBox()
</pre>
+
</source>
  
 
Returns an HTML string that will output the Display Limit dropdown as [[image:limitbox.png]]
 
Returns an HTML string that will output the Display Limit dropdown as [[image:limitbox.png]]
Line 94: Line 94:
 
=====orderDownIcon()=====
 
=====orderDownIcon()=====
  
 +
==Examples==
  
 +
===with JDatabase===
 +
Here is a nice method that uses the strength of mysql who knows pagination too.  Really!
 +
 +
''Most developers don't use the SQL_CALC_FOUND_ROWS and just double the query without limit.  Just don't!! ;-)''
 +
<source lang="php">
 +
$db =& JFactory::getDBO();
 +
$db->setQuery('SELECT SQL_CALC_FOUND_ROWS x, y, z FROM jos_content WHERE x');
 +
$rL=&$db->loadAssocList();
 +
if (empty($rL)) {$jAp->enqueueMessage($db->getErrorMsg(),'error'); return;}
 +
else {
 +
////Here the beauty starts
 +
$db->setQuery('SELECT FOUND_ROWS();');  //no reloading the query! Just asking for total without limit
 +
$lim = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons
 +
$lim0 = JRequest::getVar('limitstart', 0, '', 'int');
 +
jimport('joomla.html.pagination');
 +
$pageNav = new JPagination( $db->loadResult(), $lim0, $lim );
 +
foreach($rL as $r) {
 +
//your display code here
 +
}
 +
echo $pageNav->getListFooter(  ); //Displays a nice footer
 +
</source>
 
==Implementation==
 
==Implementation==
 
====Changes to the Model====
 
====Changes to the Model====
 
Declare $_total and $_pagination variables in the model; these will be returned by the functions getTotal() and getPagination(), respectively.
 
Declare $_total and $_pagination variables in the model; these will be returned by the functions getTotal() and getPagination(), respectively.
<pre>
+
<source lang="php">
 
   /**
 
   /**
 
   * Items total
 
   * Items total
Line 110: Line 132:
 
   */
 
   */
 
   var $_pagination = null;
 
   var $_pagination = null;
</pre>
+
</source>
  
 
Add to or create a __construct() function that will establish values for the $limitstart and $limit variables as these are needed by the JPagination class.
 
Add to or create a __construct() function that will establish values for the $limitstart and $limit variables as these are needed by the JPagination class.
<pre>
+
<source lang="php">
 
   function __construct()
 
   function __construct()
 
   {
 
   {
Line 130: Line 152:
 
$this->setState('limitstart', $limitstart);
 
$this->setState('limitstart', $limitstart);
 
   }
 
   }
</pre>
+
</source>
  
 
Revise the getData() function, adding the $limitstart and $limit values to the _getList() query.  This causes only the needed rows to be returned, rather than all rows.  
 
Revise the getData() function, adding the $limitstart and $limit values to the _getList() query.  This causes only the needed rows to be returned, rather than all rows.  
<pre>
+
<source lang="php">
 
   function getData()  
 
   function getData()  
 
   {
 
   {
Line 143: Line 165:
 
  return $this->_data;
 
  return $this->_data;
 
   }
 
   }
</pre>
+
</source>
  
 
Create a getTotal() function.  This function uses the _getListCount() method from JModel to return the total number of rows in the query.  The value returned will be used by the getPagination() function.
 
Create a getTotal() function.  This function uses the _getListCount() method from JModel to return the total number of rows in the query.  The value returned will be used by the getPagination() function.
<pre>
+
<source lang="php">
 
   function getTotal()
 
   function getTotal()
 
   {
 
   {
Line 156: Line 178:
 
  return $this->_total;
 
  return $this->_total;
 
   }
 
   }
</pre>
+
</source>
  
 
Create a getPagination() function.  The function will create and return a new Pagination object that can be accessed by the View.
 
Create a getPagination() function.  The function will create and return a new Pagination object that can be accessed by the View.
<pre>
+
<source lang="php">
 
   function getPagination()
 
   function getPagination()
 
   {
 
   {
Line 169: Line 191:
 
  return $this->_pagination;
 
  return $this->_pagination;
 
   }
 
   }
</pre>
+
</source>
  
  
 
====Changes to the View====
 
====Changes to the View====
 
Revise the View to obtain the pagination object created in the Model and assign it for use in the template.
 
Revise the View to obtain the pagination object created in the Model and assign it for use in the template.
<pre>
+
<source lang="php">
 
   ...
 
   ...
 
   // Get data from the model
 
   // Get data from the model
Line 184: Line 206:
 
$this->assignRef('pagination', $pagination);
 
$this->assignRef('pagination', $pagination);
 
   ...
 
   ...
</pre>
+
</source>
  
  
 
====Changes to the Template====
 
====Changes to the Template====
 
Add a footer area to the display table in the template which holds the pagination object.  The method getListFooter() from the JPagination class generates the buttons and their next/previous functionality as shown in the image above.  Edit colspan="9" to reflect the number of columns in the table.
 
Add a footer area to the display table in the template which holds the pagination object.  The method getListFooter() from the JPagination class generates the buttons and their next/previous functionality as shown in the image above.  Edit colspan="9" to reflect the number of columns in the table.
<pre>
+
<source lang="php">
 
   ...
 
   ...
 
   <tfoot>
 
   <tfoot>
Line 197: Line 219:
 
   </tfoot>
 
   </tfoot>
 
   ...
 
   ...
</pre>
+
</source>
  
 
[[Category:Development]]
 
[[Category:Development]]

Revision as of 11:50, 5 January 2009

Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.
Quill icon.png
Content is Incomplete

This article or section is incomplete, which means it may be lacking information. You are welcome to assist in its completion by editing it as well. If this article or section has not been edited in several days, please consider helping complete the content.
This article was last edited by E-builds (talk| contribs) 5 years ago. (Purge)


Contents

Class Overview

The JPagination class, introduced in Joomla! 1.5, allows developers to reliably and consistently add pagination to the Front-end and Back-end display of their components. The file containing the class can be found at /libraries/joomla/html/pagination.php.

Variables

The construct function of the class requires three variables:

  • $total - the total number of items in a list,
  • $limitstart - the offset of the item at which to start, and
  • $limit - the number of items to display per page.

Static Class Methods

getRowOffset($index)
getData()
getPagesCounter()
        /**
         * Create and return the pagination pages counter string
         *
         * @access      public
         * @return      string  Pagination pages counter string
         * @since       1.5
         */
        function getPagesCounter()

Returns a string containing the current page and total pages as Pagescounter.png

getResultsCounter()
        /**
         * Create and return the pagination result set counter string
         *
         * @access      public
         * @return      string  Pagination result set counter string
         * @since       1.5
         */
        function getResultsCounter()

Returns a string containing the results currently being displayed as Resultscounter.png

getPagesLinks()
        /**
         * Create and return the pagination page list string, ie. Previous, Next, 1 2 3 ... x
         *
         * @access      public
         * @return      string  Pagination page list string
         * @since       1.0
         */
        function getPagesLinks()

Returns an HTML string to display the Pages Links as Pageslinks.png

getListFooter()
        /**
         * Return the pagination footer
         *
         * @access      public
         * @return      string  Pagination footer
         * @since       1.0
         */
        function getListFooter()

Returns a combination of the several page-related elements, including: the Display Limit dropdown, the Pages Links and the Pages Counter. Appearance differs in the Front-end and Back-end due to additional CSS formatting applied with the Khepri template.

Front-end: Listfooter-front.png

Back-end: Pagination.png

getLimitBox()
        /**
         * Creates a dropdown box for selecting how many records to show per page
         *
         * @access      public
         * @return      string  The html for the limit # input box
         * @since       1.0
         */
        function getLimitBox()

Returns an HTML string that will output the Display Limit dropdown as Limitbox.png

orderUpIcon()
orderDownIcon()

Examples

with JDatabase

Here is a nice method that uses the strength of mysql who knows pagination too. Really!

Most developers don't use the SQL_CALC_FOUND_ROWS and just double the query without limit. Just don't!! ;-)

$db =& JFactory::getDBO();
$db->setQuery('SELECT SQL_CALC_FOUND_ROWS x, y, z FROM jos_content WHERE x');
$rL=&$db->loadAssocList();
if (empty($rL)) {$jAp->enqueueMessage($db->getErrorMsg(),'error'); return;}     
else {
////Here the beauty starts
$db->setQuery('SELECT FOUND_ROWS();');  //no reloading the query! Just asking for total without limit
$lim    = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons
$lim0   = JRequest::getVar('limitstart', 0, '', 'int');
jimport('joomla.html.pagination');
$pageNav = new JPagination( $db->loadResult(), $lim0, $lim );
foreach($rL as $r) {
//your display code here
}
echo $pageNav->getListFooter(  ); //Displays a nice footer

Implementation

Changes to the Model

Declare $_total and $_pagination variables in the model; these will be returned by the functions getTotal() and getPagination(), respectively.

  /**
   * Items total
   * @var integer
   */
  var $_total = null;
 
  /**
   * Pagination object
   * @var object
   */
  var $_pagination = null;

Add to or create a __construct() function that will establish values for the $limitstart and $limit variables as these are needed by the JPagination class.

  function __construct()
  {
        parent::__construct();
 
        global $mainframe, $option;
 
        // Get pagination request variables
        $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
        $limitstart = $mainframe->getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');
 
        // In case limit has been changed, adjust it
        $limitstart = ($limit != 0 ? (floor($limitstart / $limit) * $limit) : 0);
 
        $this->setState('limit', $limit);
        $this->setState('limitstart', $limitstart);
  }

Revise the getData() function, adding the $limitstart and $limit values to the _getList() query. This causes only the needed rows to be returned, rather than all rows.

  function getData() 
  {
        // if data hasn't already been obtained, load it
        if (empty($this->_data)) {
            $query = $this->_buildQuery();
            $this->_data = $this->_getList($query, $this->getState('limitstart'), $this->getState('limit'));    
        }
        return $this->_data;
  }

Create a getTotal() function. This function uses the _getListCount() method from JModel to return the total number of rows in the query. The value returned will be used by the getPagination() function.

  function getTotal()
  {
        // Load the content if it doesn't already exist
        if (empty($this->_total)) {
            $query = $this->_buildQuery();
            $this->_total = $this->_getListCount($query);       
        }
        return $this->_total;
  }

Create a getPagination() function. The function will create and return a new Pagination object that can be accessed by the View.

  function getPagination()
  {
        // Load the content if it doesn't already exist
        if (empty($this->_pagination)) {
            jimport('joomla.html.pagination');
            $this->_pagination = new JPagination($this->getTotal(), $this->getState('limitstart'), $this->getState('limit') );
        }
        return $this->_pagination;
  }


Changes to the View

Revise the View to obtain the pagination object created in the Model and assign it for use in the template.

  ...
        // Get data from the model
        $items =& $this->get('Data');   
        $pagination =& $this->get('Pagination');
 
        // push data into the template
        $this->assignRef('items', $items);      
        $this->assignRef('pagination', $pagination);
  ...


Changes to the Template

Add a footer area to the display table in the template which holds the pagination object. The method getListFooter() from the JPagination class generates the buttons and their next/previous functionality as shown in the image above. Edit colspan="9" to reflect the number of columns in the table.

  ...
  <tfoot>
    <tr>
      <td colspan="9"><?php echo $this->pagination->getListFooter(); ?></td>
    </tr>
  </tfoot>
  ...