Skip to content

Xajax Pagination

Jump to bottom Edit New page
World Wide Web Server edited this page Jul 4, 2012 · 4 revisions

How to paginate a grid with xajax and codeigniter I take the pagination class that comes in the codeIgniter library and modify some lines to get it running with xajax. I hope this will useful for you, this works for me. Any improve will be welcomed.

1)Xajax_pagination Class (It is based on Pagination Class of CI) [code] <?php if (!defined('BASEPATH')) exit('No direct script access allowed'); /**

// ------------------------------------------------------------------------

/**

  • Pagination Class

  • @package CodeIgniter

  • @subpackage Libraries

  • @category Pagination

  • @author ExpressionEngine Dev Team

  • @link http://codeigniter.com/user_guide/libraries/pagination.html */ class Xajax_pagination {

    //Added by !Z var $function_to_call = ''; // The function registered by Xajax to call var $function_prefix = 'xajax';

    var $total_rows = ''; // Total number of items (database results) var $per_page = 10; // Max number of items you want shown per page var $num_links = 2; // Number of "digit" links to show before/after the currently viewed page var $cur_page = 0; // The current page being viewed var $first_link = '‹ First'; var $next_link = '>'; var $prev_link = '<'; var $last_link = 'Last ›'; var $uri_segment = 3; var $full_tag_open = ''; var $full_tag_close = ''; var $first_tag_open = ''; var $first_tag_close = ' '; var $last_tag_open = ' '; var $last_tag_close = ''; var $cur_tag_open = ' '; var $cur_tag_close = ''; var $next_tag_open = ' '; var $next_tag_close = ' '; var $prev_tag_open = ' '; var $prev_tag_close = ''; var $num_tag_open = ' '; var $num_tag_close = ''; //Added by !Z var $panel_to_update = '';

    /**

    • Constructor
    • @access public
    • @param array initialization parameters */ function Xajax_pagination($params = array()) { if (count($params) > 0) { $this->initialize($params);
      } log_message('debug', "Xajax Pagination Class Initialized"); }

    // --------------------------------------------------------------------

    /**

    • Initialize Preferences
    • @access public
    • @param array initialization parameters
    • @return void */ function initialize($params = array()) { if (count($params) > 0) { foreach ($params as $key => $val) { if (isset($this->$key)) { $this->$key = $val; } }
      } }

    // --------------------------------------------------------------------

    /**

    • Generate the pagination links

    • @access public

    • @return string */
      function create_links($cur_page = 0)//Parameter Added by !Z { $this->cur_page = $cur_page; // If our item count or per-page total is zero there is no need to continue. if ($this->total_rows == 0 OR $this->per_page == 0) { return ''; }

      // Calculate the total number of pages $num_pages = ceil($this->total_rows / $this->per_page);

      // Is there only one page? Hm... nothing more to do here then. if ($num_pages == 1) { return ''; }

      // Determine the current page number.
      $CI =& get_instance();

      if ($CI->uri->segment($this->uri_segment) != 0) { $this->cur_page = $CI->uri->segment($this->uri_segment);

       // Prep the current page - no funny business!
 $this->cur_page = (int) $this->cur_page;

      }

      $this->num_links = (int)$this->num_links;

      if ($this->num_links < 1) { show_error('Your number of links must be a positive number.'); }

      if ( ! is_numeric($this->cur_page)) { $this->cur_page = 0; }

      // Is the page number beyond the result range? // If so we show the last page if ($this->cur_page > $this->total_rows) { $this->cur_page = ($num_pages - 1) * $this->per_page; }

      $uri_page_number = $this->cur_page; $this->cur_page = floor(($this->cur_page/$this->per_page) + 1);

      // Calculate the start and end numbers. These determine // which number to start and end the digit links with $start = (($this->cur_page - $this->num_links) > 0) ? $this->cur_page - ($this->num_links - 1) : 1; $end = (($this->cur_page + $this->num_links) < $num_pages) ? $this->cur_page + $this->num_links : $num_pages;

      // And here we go... $output = '';

      // Render the "First" link //Modified by !Z if (($this->num_links - $this->cur_page) < 2 && $this->cur_page != 1) { //Modified by !Z

       $output .= $this->first_tag_open.$this->create_ajax_links($this->first_link,0).$this->first_tag_close;

      }

      // Render the "previous" link if ($this->cur_page != 1) {

       $i = $uri_page_number - $this->per_page;
 //if ($i == 0) $i = '';
 //Modified by !Z
 $output .= $this->prev_tag_open.$this->create_ajax_links($this->prev_link,$i).$this->prev_tag_close;

      }

      // Write the digit links for ($loop = $start -1; $loop <= $end; $loop++) { $i = ($loop * $this->per_page) - $this->per_page;

       if ($i >= 0)
 {
     if ($this->cur_page == $loop)
     {
         //Modified by !Z
         $output .= $this->cur_tag_open.$this->create_ajax_links($loop).$this->cur_tag_close; // Current page
     }
     else
     {
         //$n = ($i == 0) ? '' : $i;
         //Modified by !Z
         $output .= $this->num_tag_open.$this->create_ajax_links($loop,$i).$this->num_tag_close;
         //$output .= $this->num_tag_open.'<a >base_url.$n.'">'.$loop.'</a>'.$this->num_tag_close;
     }
 }

      }

      // Render the "next" link if ($this->cur_page < $num_pages) { //Modified by !Z $output .= $this->next_tag_open.$this->create_ajax_links($this->next_link,($this->cur_page * $this->per_page)).$this->next_tag_close; //$output .= $this->next_tag_open.'base_url.($this->cur_page * $this->per_page).'">'.$this->next_link.''.$this->next_tag_close; }

      // Render the "Last" link //Modified By !Z if (($this->cur_page) < $num_pages) { $i = (($num_pages * $this->per_page) - $this->per_page); $output .= $this->last_tag_open.$this->create_ajax_links($this->last_link,$i).$this->last_tag_close; //$output .= $this->last_tag_open.'base_url.$i.'">'.$this->last_link.''.$this->last_tag_close; }

      // Kill double slashes. Note: Sometimes we can end up with a double slash // in the penultimate link so we'll kill all double slashes. $output = preg_replace("#([^:])//+#", "\1/", $output);

      // Add the wrapper HTML if exists $output = $this->full_tag_open.$output.$this->full_tag_close;

      return $output;
      }

    function create_ajax_links($text,$page=""){ if($this->function_prefix != 'xajax') $html = "function_prefix."_".$this->function_to_call."('".$page."');return false;" />$text";
    else $html = "function_to_call."('".$page."');return false;" />$text"; return $html; } } // END Pagination Class

/* End of file xajax_pagination.php / / Location: ./application/libraries/xajax_pagination.php */ [/code]

2)Contoller [code] <?php class Users extends Controller { var $customConfig; function Usuarios(){ parent::Controller(); //you must have this to run xajax_pagination see the xajax perfect setup in the wiki section of CI $this->load->library("xajax"); $this->xajax->registerFunction(array("paginar",&$this,"paginar")); $this->xajax->processRequest(); $this->load->library("xajax_pagination"); }

function Index(){ $this->configPag(); $data['xajax_js'] = $this->xajax->getJavascript(base_url()); $data["usuarios_list"] = $this->users_model-> GetAllUsers($this->customConfig["per_page"],0); $data["links_pager"] = $this->xajax_pagination->create_links(); //This view is only the grid so we handle this like a control. $data["users_grid"] = $this->load->view("administration/users_grid",$data,true); $this->load->view("administration/users_view",$data); }

// this function is because xajax do not execute the constructor. function configPag(){ $this->customConfig['first_link'] = 'Primero'; $this->customConfig['last_link'] = 'Ultimo'; $this->customConfig['next_link'] = 'Siguiente'; $this->customConfig['prev_link'] = 'Anterior'; $this->customConfig['panel_to_update'] = 'grid'; //Div to update $this->customConfig['function_to_call'] = "paginar"; $this->customConfig['total_rows'] = $this->usuarios_model->GetNumRows(); $this->customConfig['per_page'] = 2; $this->xajax_pagination->initialize($this->customConfig); } function paginar($offset){ $objResponse = new xajaxResponse(); $this->configPag(); $ci =& get_instance(); $data["links_pager"] = $ci->xajax_pagination->create_links($offset); //$objResponse->alert(print_r($data,true)); //return $objResponse; $data["usuarios_list"] = $this->usuarios_model->GetAllUsuarios($this->customConfig["per_page"],$offset); $objResponse->assign($this->customConfig["panel_to_update"],"innerHTML",$this->load->view("administracion/usuarios_grid",$data,true)); return $objResponse; } }

[/code] 3)Views users_view [code]

<?php echo $usuarios_grid; ?>
[/code] users_grid [code] <?php foreach($usuarios_list as $usuario): ?> <?php endforeach; ?>
First Name Last Name E-Mail User
<?php echo $user->FName; ?> <?php echo $user->LName; ?> <?php echo $user->EMail; ?> <?php echo $user->Username; ?>
<?php echo $links_pager; ?>
[/code]

I wrote this very quickly maybe you can found some typo issues.

Thanks ;)

Add a custom footer
Add a custom sidebar
Clone this wiki locally