/**
* The default function
*
* Set up some variables and add them to the view file data
*/
public function index()
{
/**
* This part is the same as the previous example. For brevity comments are removed.
*/
$content = '';
TINA_MVC\include_helper('pagination');
global $wpdb;
$base_sql = 'SELECT ID AS `Database ID`, user_login AS `User Login`, display_name AS `Display Name` FROM ' . $wpdb->users;
$count_sql = 'SELECT COUNT(ID) FROM ' . $wpdb->users;
$P = new TINA_MVC\pagination('my_paginator');
$P->set_count_from_sql($count_sql);
$P->set_base_url(TINA_MVC\get_controller_url('page-test-3'));
$P->filter_box_on_fields(array('User Login' => 'user_login', 'Display Name' => 'display_name', 'user_email' => 'user_email'));
$P->set_base_sql($base_sql);
$P->set_mid_range(9)->set_items_per_page(10)->set_default_sort_by('User Login')->set_default_sort_order('desc');
/**
* We will get the results and format custom HTML rows rather than allow
* the pagination helper to give us a generic table. You should use escaped
* HTML here.
*
* In this case we are just building some HTML. You would normally use a
* view file instead of putting HTML in your page controller.
*/
$rows = $P->get_sql_rows();
// TINA_MVC\prd( $rows );
/**
* Iterate throught the results and build some HTML
*/
foreach ($rows as $i => &$r) {
if ($i % 2) {
$bg = '#333';
$fg = '#ccc';
} else {
$bg = '#ccc';
$fg = '#333';
}
$r->{'Database ID'} = '<span style="color:' . $fg . ';background:' . $bg . '">' . $wpdb->escape($r->{'Database ID'}) . '</span>';
$r->{'User Login'} = '<span style="color:' . $fg . ';background:' . $bg . '"><a href="#" title="' . $wpdb->escape($r->{'Display Name'}) . '">' . $r->{'User Login'} . '</a></span>';
$r->{'A non-DB field (non-sortable)'} = '<span style="color:' . $fg . ';background:' . $bg . '"><a href="#" title="' . $wpdb->escape($r->{'Display Name'}) . '">' . $i . '</a></span>';
/**
* You can also unset() an entry here
*/
// $r->{'Display Name'} = '<span style="color:'.$fg.';background:'.$bg.'">'.$wpdb->escape($r->{'Display Name'}).'</span>';
unset($r->{'Display Name'});
}
/**
* Set the rows, overriding the use of the html table helper
*/
$P->set_html_rows($rows);
/**
* This will prevent the helper from adding sortable column HTML to the
* column heading 'A non-DB field (non-sortable)'.
*
* You cannot sort on columns that do not come directly from the database.
*/
$P->suppress_sort(array('A non-DB field (non-sortable)'));
$this->set_post_title('Pagination');
$this->set_post_content($P->get_html());
}
/**
* The default function
*
* Set up some variables and add them to the view file data
*/
public function index()
{
$content = '';
TINA_MVC\include_helper('pagination');
global $wpdb;
/**
* We are using custom SQL here to demonstrate the use of the pager.
*
* Have a look at the Demo Data Creator plugin if you want to create many
* dummy users for use with this example... or even better play with your own data
*
* The $base_sql is a properly escaped statement that will get you all the rows you want. ORDER BY and LIMIT clauses
* are not set - they will be set automatically.
*
* Pay particular attention to the field names and their aliases. These are relevent when it comes to setting
* sortable columns and a filter box (below).
*/
$base_sql = 'SELECT ID AS `Database ID`, user_login AS `User Login`, display_name AS `Display Name` FROM ' . $wpdb->users;
/**
* A SQL statement to get the total number of rows returned in the above statement.
*/
$count_sql = 'SELECT COUNT(ID) FROM ' . $wpdb->users;
/**
* The HTML table ID is set from the parameter you ppass to the constructor
*/
$P = new TINA_MVC\pagination('my_paginator');
$P->set_count_from_sql($count_sql);
/**
* The url required to get to the default table view
*/
$P->set_base_url(TINA_MVC\get_controller_url('page-test-1'));
/**
* Set up the filter.
*
* This allows a user to search on various fields (even if they are not
* selected for display). This will output a form at the top of the table
* of results.
*
* Parameter is array ( 'Display Name' => 'mysql_field_name' )
*
* These must match the field names and aliases in $base_sql
*/
$P->filter_box_on_fields(array('User Login' => 'user_login', 'Display Name' => 'display_name', 'user_email' => 'user_email'));
$P->set_base_sql($base_sql);
/**
* For the pagination links
*/
$P->set_mid_range(9)->set_items_per_page(10)->set_default_sort_by('User Login')->set_default_sort_order('desc');
/**
* Grab the html.
*/
$content = $P->get_html();
/**
* Sets the post title
*/
$this->set_post_title('Testing Pagination');
/**
* Sets the post content. Note we are not using a view file for this example
*/
$this->set_post_content($content);
}
/**
* The default function
*
* Set up some variables and add them to the view file data
*/
public function index()
{
/**
* This part is the same as the previous example. For brevity comments are removed.
*/
$content = '';
TINA_MVC\include_helper('pagination');
global $wpdb;
$base_sql = 'SELECT ID AS `Database ID`, user_login AS `User Login`, display_name AS `Display Name` FROM ' . $wpdb->users;
$count_sql = 'SELECT COUNT(ID) FROM ' . $wpdb->users;
$P = new TINA_MVC\pagination('my_paginator');
$P->set_count_from_sql($count_sql);
/**
* OK, not quite the same. The base url is obviously different!
*/
$P->set_base_url(TINA_MVC\get_controller_url('page-test-2'));
$P->filter_box_on_fields(array('User Login' => 'user_login', 'Display Name' => 'display_name', 'user_email' => 'user_email'));
$P->set_base_sql($base_sql);
$P->set_mid_range(9)->set_items_per_page(10)->set_default_sort_by('User Login')->set_default_sort_order('desc');
/**
* We will get the results and format custom HTML rows rather than allow
* the pagination helper to give us a generic table. You should use escaped
* HTML here.
*/
$rows = $P->get_sql_rows();
// TINA_MVC\prd( $rows );
/**
* Iterate throught the results and build some HTML
*/
foreach ($rows as $i => &$r) {
//echo $r->{'User Login'};
/**
* We'll use this is the view file to produce the alternating row styles
*/
$this->add_var('i', $i);
/**
* The row of data
*
* You need to be careful here if your array keys (or object variables) require escaping.
*/
$this->add_var_e('r', $r);
/**
* The view file here is only a HTML snippet. It renders only one row.
*
* It is the first example of using a view snippet to produce output.
*
* In this case, the view file is used to render headings or rows based on the value of $view_file_part
*/
$this->add_var('view_file_part', 'rows');
$r = $this->load_view('page_test_2');
}
/**
* Set the rows, overriding the use of the html table helper.
*
* This will also supress the table headings.
*/
$P->set_html_rows($rows);
/**
* Set the table headings. This is optional.
*
* In this case, the view file is used to render headings or rows based on the value of $view_file_part
*/
$this->add_var('view_file_part', 'headings');
$P->set_html_headings($this->load_view('page_test_2'));
/**
* Grab the html.
*/
$content = $P->get_html();
/**
* Sets the post title
*/
$this->set_post_title('Testing Pagination 2');
/**
* Sets the post content. Note we are not using a view file for this example
*/
$this->set_post_content($content);
}