2013-10-18 03:59:07 +00:00
<!DOCTYPE html>
< html >
< head >
2016-01-10 22:24:57 +00:00
< meta charset = "utf-8" >
< title > jQuery tablesorter 2.0 - Pager Widget - Ajax< / title >
2013-10-18 03:59:07 +00:00
<!-- jQuery -->
2014-05-21 22:09:23 +00:00
< script src = "js/jquery-latest.min.js" > < / script >
2013-10-18 03:59:07 +00:00
<!-- Demo stuff -->
< link href = "css/jq.css" rel = "stylesheet" >
< link href = "css/prettify.css" rel = "stylesheet" >
< script src = "js/prettify.js" > < / script >
< script src = "js/docs.js" > < / script >
<!-- Tablesorter: required -->
< link href = "../css/theme.blue.css" rel = "stylesheet" >
< script src = "../js/jquery.tablesorter.js" > < / script >
< script src = "../js/jquery.tablesorter.widgets.js" > < / script >
<!-- Tablesorter: optional -->
< link rel = "stylesheet" href = "../addons/pager/jquery.tablesorter.pager.css" >
< script src = "../js/widgets/widget-pager.js" > < / script >
<!-- Tablesorter: optional -->
< script src = "../js/jquery.tablesorter.widgets.js" > < / script >
2018-03-17 20:30:25 +00:00
< script id = "js" > $ ( f u n c t i o n ( ) {
2013-10-18 03:59:07 +00:00
// Initialize tablesorter
// ***********************
$("table")
.tablesorter({
2013-10-18 12:49:57 +00:00
theme: 'blue',
2013-10-18 03:59:07 +00:00
widthFixed: true,
sortLocaleCompare: true, // needed for accented characters in the data
2013-11-09 05:49:30 +00:00
sortList: [ [0,1] ],
2013-10-18 03:59:07 +00:00
widgets: ['zebra', 'filter', 'pager'],
widgetOptions: {
2017-06-25 18:53:31 +00:00
// css class names of pager arrows
pager_css: {
container : 'tablesorter-pager',
errorRow : 'tablesorter-errorRow', // error information row (don't include period at beginning)
disabled : 'disabled' // class added to arrows @ extremes (i.e. prev/first arrows "disabled" on first page)
},
// jQuery selectors
pager_selectors: {
container : '.pager', // target the pager markup (wrapper)
first : '.first', // go to first page arrow
prev : '.prev', // previous page arrow
next : '.next', // next page arrow
last : '.last', // go to last page arrow
gotoPage : '.gotoPage', // go to page selector - select dropdown that sets the current page
pageDisplay : '.pagedisplay', // location of where the "output" is displayed
pageSize : '.pagesize' // page size selector - select dropdown that sets the "size" option
},
2013-10-18 03:59:07 +00:00
// output default: '{page}/{totalPages}'
2015-11-09 13:01:24 +00:00
// possible variables: {size}, {page}, {totalPages}, {filteredPages}, {startRow}, {endRow}, {filteredRows} and {totalRows}
// also {page:input} & {startRow:input} will add a modifiable input in place of the value
2013-10-18 03:59:07 +00:00
pager_output: '{startRow} - {endRow} / {filteredRows} ({totalRows})', //'{startRow} to {endRow} of {totalRows} rows', // '{page}/{totalPages}'
// apply disabled classname to the pager arrows when the rows at either extreme is visible
pager_updateArrows: true,
// starting page of the pager (zero based index)
pager_startPage: 0,
2017-06-25 18:53:31 +00:00
// Reset pager to this page after filtering; set to desired page number
// (zero-based index), or false to not change page at filter start
pager_pageReset: 0,
2013-10-18 03:59:07 +00:00
// Number of visible rows
pager_size: 25,
2017-06-25 18:53:31 +00:00
// f true, child rows will be counted towards the pager set size
pager_countChildRows: false,
2013-10-18 03:59:07 +00:00
// Save pager page & size if the storage script is loaded (requires $.tablesorter.storage in jquery.tablesorter.widgets.js)
pager_savePages: true,
2017-06-25 18:53:31 +00:00
// Saves tablesorter paging to custom key if defined. Key parameter name
// used by the $.tablesorter.storage function. Useful if you have
// multiple tables defined
pager_storageKey: "tablesorter-pager",
2013-10-18 03:59:07 +00:00
// if true, the table will remain the same height no matter how many records are displayed. The space is made up by an empty
// table row set to a height to compensate; default is false
pager_fixedHeight: false,
// remove rows from the table to speed up the sort of large tables.
// setting this to false, only hides the non-visible rows; needed if you plan to add/remove rows with the pager enabled.
pager_removeRows: false, // removing rows in larger tables speeds up the sort
2015-10-08 17:00:07 +00:00
// If you want to use ajaxUrl placeholders, here is an example:
// ajaxUrl: "http:/mydatabase.com?page={page}& size={size}& {sortList:col}"
// where {page} is replaced by the page number (or use {page+1} to get a one-based index),
// {size} is replaced by the number of records to show,
2013-10-18 03:59:07 +00:00
// {sortList:col} adds the sortList to the url into a "col" array, and {filterList:fcol} adds
// the filterList to the url into an "fcol" array.
// So a sortList = [[2,0],[3,0]] becomes "& col[2]=0& col[3]=0" in the url
// and a filterList = [[2,Blue],[3,13]] becomes "& fcol[2]=Blue& fcol[3]=13" in the url
pager_ajaxUrl: 'assets/City{page}.json?{filterList:filter}& {sortList:column}',
2015-10-08 17:00:07 +00:00
// use this option to manipulate and/or add additional parameters to the ajax url
2013-10-18 03:59:07 +00:00
pager_customAjaxUrl: function(table, url) {
// manipulate the url string as you desire
2015-10-08 17:00:07 +00:00
// url += '& currPage=' + window.location.pathname;
2013-10-18 03:59:07 +00:00
// trigger my custom event
$(table).trigger('changingUrl', url);
// send the server the current page
return url;
},
2015-08-19 21:33:32 +00:00
// ajax error callback from $.tablesorter.showError function
2018-03-17 20:30:25 +00:00
// pager_ajaxError: function( config, xhr, settings, exception ) { return exception; };
2015-08-19 21:33:32 +00:00
// returning false will abort the error message
pager_ajaxError: null,
2013-10-18 03:59:07 +00:00
// modify the $.ajax object to allow complete control over your ajax requests
pager_ajaxObject: {
2016-07-13 20:31:56 +00:00
type: 'GET', // default setting
2013-10-18 03:59:07 +00:00
dataType: 'json'
},
2017-06-25 18:53:31 +00:00
// Set this option to false if your table data is preloaded into the
// table, but you are still using ajax
pager_processAjaxOnInit: true,
// When processAjaxOnInit is set to false, set this option to contain
// the total number of rows and filtered rows to prevent an initial ajax
// call
initialRows: {
total: 100,
filtered: 100
},
2013-10-18 03:59:07 +00:00
// process ajax so that the following information is returned:
// [ total_rows (number), rows (array of arrays), headers (array; optional) ]
// example:
// [
// 100, // total rows
// [
// [ "row1cell1", "row1cell2", ... "row1cellN" ],
// [ "row2cell1", "row2cell2", ... "row2cellN" ],
// ...
// [ "rowNcell1", "rowNcell2", ... "rowNcellN" ]
// ],
// [ "header1", "header2", ... "headerN" ] // optional
// ]
2018-03-17 20:30:25 +00:00
pager_ajaxProcessing: function(data) {
2013-10-18 03:59:07 +00:00
if (data & & data.hasOwnProperty('rows')) {
2015-02-12 01:20:29 +00:00
var indx, r, row, c, d = data.rows,
2013-10-18 03:59:07 +00:00
// total number of rows (required)
total = data.total_rows,
// array of header names (optional)
headers = data.headers,
2015-02-12 01:20:29 +00:00
// cross-reference to match JSON key within data (no spaces)
headerXref = headers.join(',').replace(/\s+/g,'').split(','),
2013-10-18 03:59:07 +00:00
// all rows: array of arrays; each internal array has the table cell data for that row
rows = [],
// len should match pager set size (c.size)
len = d.length;
// this will depend on how the json is set up - see City0.json
// rows
for ( r=0; r < len ; r + + ) {
row = []; // new row array
// cells
for ( c in d[r] ) {
if (typeof(c) === "string") {
2015-02-12 01:20:29 +00:00
// match the key with the header to get the proper column index
indx = $.inArray( c, headerXref );
// add each table cell data to row array
if (indx >= 0) {
row[indx] = d[r][c];
}
2013-10-18 03:59:07 +00:00
}
}
rows.push(row); // add new row array to rows array
}
// in version 2.10, you can optionally return $(rows) a set of table rows within a jQuery object
return [ total, rows, headers ];
}
}
}
});
});< / script >
< / head >
< body id = "pager-demo" >
< div id = "banner" >
< h1 > table< em > sorter< / em > < / h1 >
< h2 > Pager Widget - Ajax< / h2 >
< h3 > Flexible client-side table sorting< / h3 >
< a href = "index.html" > Back to documentation< / a >
< / div >
< div id = "main" >
< p class = "tip" >
2016-01-10 22:24:57 +00:00
< em > NOTE!< / em >
< / p >
< ul >
2016-05-01 20:33:35 +00:00
< li >
In < span class = "version updated" > v2.26.0< / span > , a page size of "all" will be passed to the server when set; < span class = "label warning" > Note< / span > this change may break current server methods on number of pages to return.
< br > < br >
< / li >
2016-01-10 22:24:57 +00:00
< li > This pager WIDGET < em > can not< / em > be applied to the original tablesorter.< / li >
< li > Do not use this widget along with the pager plugin.< / li >
< li > The pager.css file also works with this pager widget.< / li >
< li > This widget is still in < span class = "beta" > development< / span > as it has not been throughly tested.< / li >
2016-05-01 20:33:35 +00:00
2016-01-10 22:24:57 +00:00
< li > Extensive documentation has not been included, as all functioning is essentially identical to the pager addon, but here are some important differences:
2013-10-18 03:59:07 +00:00
< ul >
2016-01-10 22:24:57 +00:00
< li > All of the options are now set within the < code > widgetOptions< / code > .< / li >
< li > Most option names have only been modified by adding < code > pager_< / code > as a prefix.< / li >
< li > Exceptions include moving all applied css class names into a < code > pager_css< / code > option and all selectors into < code > pager_selectors< / code > , including the original < code > container< / code > option.< / li >
< li > See the Javascript code below for a full example of how to use this widget with < strong > ajax< / strong > .< / li >
2013-10-18 03:59:07 +00:00
< / ul >
2016-01-10 22:24:57 +00:00
< / li >
< li > The "ID" column has a default filter setting of "> 30" and a descending sort, but neither is applied as this demo is not connected a server (just a basic JSON file).< / li >
< / ul >
2013-10-18 03:59:07 +00:00
< h1 > Demo< / h1 >
Original Ajax url: < span id = "origurl" > < / span > < br >
Current Ajax url: < span id = "url" > < / span >
< br >
< table class = "tablesorter" >
< thead >
2016-01-28 03:21:33 +00:00
< tr class = "tablesorter-ignoreRow" >
2013-10-18 03:59:07 +00:00
< td class = "pager sorter-false" colspan = "5" >
< img src = "../addons/pager/icons/first.png" class = "first" alt = "First" / >
< img src = "../addons/pager/icons/prev.png" class = "prev" alt = "Prev" / >
< span class = "pagedisplay" > < / span > <!-- this can be any element, including an input -->
< img src = "../addons/pager/icons/next.png" class = "next" alt = "Next" / >
< img src = "../addons/pager/icons/last.png" class = "last" alt = "Last" / >
< select class = "pagesize" >
< option value = "25" > 25< / option >
< / select >
< / td >
< / tr >
< tr >
2013-11-09 05:49:30 +00:00
< th data-value = ">30" > 1< / th >
2013-10-18 03:59:07 +00:00
< th > 2< / th >
< th > 3< / th >
< th > 4< / th >
< th > 5< / th >
< / tr >
< / thead >
< tfoot >
< tr >
< th > 1< / th >
< th > 2< / th >
< th > 3< / th >
< th > 4< / th >
< th > 5< / th >
< / tr >
< tr >
< td class = "pager" colspan = "5" >
< img src = "../addons/pager/icons/first.png" class = "first" alt = "First" / >
< img src = "../addons/pager/icons/prev.png" class = "prev" alt = "Prev" / >
< span class = "pagedisplay" > < / span > <!-- this can be any element, including an input -->
< img src = "../addons/pager/icons/next.png" class = "next" alt = "Next" / >
< img src = "../addons/pager/icons/last.png" class = "last" alt = "Last" / >
< select class = "pagesize" >
< option value = "25" > 25< / option >
< / select >
< / td >
< / tr >
< / tfoot >
< tbody >
< / tbody >
< / table >
< h1 > Javascript< / h1 >
< div id = "javascript" >
< pre class = "prettyprint lang-javascript" > < / pre >
< / div >
< h1 > CSS< / h1 >
< div >
< pre class = "prettyprint lang-css" > /* pager wrapper, div */
.pager {
padding: 5px;
}
/* pager wrapper, in thead/tfoot */
td.pager {
background-color: #e6eeee;
}
/* pager navigation arrows */
.pager img {
vertical-align: middle;
margin-right: 2px;
}
/* pager output text */
.pager .pagedisplay {
font-size: 11px;
padding: 0 5px 0 5px;
width: 50px;
text-align: center;
}
/*** loading ajax indeterminate progress indicator ***/
#tablesorterPagerLoading {
background: rgba(255,255,255,0.8) url(icons/loading.gif) center center no-repeat;
position: absolute;
z-index: 1000;
}
/*** css used when "updateArrows" option is true ***/
/* the pager itself gets a disabled class when the number of rows is less than the size */
.pager.disabled {
display: none;
}
/* hide or fade out pager arrows when the first or last row is visible */
.pager img.disabled {
/* visibility: hidden */
opacity: 0.5;
filter: alpha(opacity=50);
}< / pre >
< / div >
< h1 > HTML< / h1 >
< div id = "html" >
< pre class = "prettyprint lang-html" > < !-- jQuery -->
2014-05-21 22:09:23 +00:00
< script src=" js/jquery-latest.min.js" > < /script>
2013-10-18 03:59:07 +00:00
< !-- Tablesorter: required -->
< link href=" css/theme.blue.css" rel=" stylesheet" >
< script src=" js/jquery.tablesorter.js" > < /script>
< script src=" js/jquery.tablesorter.widgets.js" > < /script>
< !-- Tablesorter: pager widget -->
< link href=" css/jquery.tablesorter.pager.css" rel=" stylesheet" >
< script src=" js/widget-pager.js" > < /script>
< table class=" tablesorter" >
< thead>
2016-05-18 23:18:41 +00:00
< tr class=" tablesorter-ignoreRow" >
2015-02-13 03:10:38 +00:00
< td class=" pager" colspan=" 5" >
2013-10-18 03:59:07 +00:00
< img src=" ../addons/pager/icons/first.png" class=" first" />
< img src=" ../addons/pager/icons/prev.png" class=" prev" />
< span class=" pagedisplay" > < /span> < !-- this can be any element, including an input -->
< img src=" ../addons/pager/icons/next.png" class=" next" />
< img src=" ../addons/pager/icons/last.png" class=" last" />
< select class=" pagesize" >
< option value=" 25" > 25< /option>
< /select>
< /td>
< /tr>
< tr>
< th> 1< /th> < !-- thead text will be updated from the JSON; make sure the number of columns matches the JSON data -->
< th> 2< /th>
< th> 3< /th>
< th> 4< /th>
< th> 5< /th>
< /tr>
< /thead>
< tfoot>
< tr>
< th> 1< /th> < !-- tfoot text will be updated at the same time as the thead -->
< th> 2< /th>
< th> 3< /th>
< th> 4< /th>
< th> 5< /th>
< /tr>
< tr>
< td class=" pager" colspan=" 5" >
< img src=" ../addons/pager/icons/first.png" class=" first" />
< img src=" ../addons/pager/icons/prev.png" class=" prev" />
< span class=" pagedisplay" > < /span> < !-- this can be any element, including an input -->
< img src=" ../addons/pager/icons/next.png" class=" next" />
< img src=" ../addons/pager/icons/last.png" class=" last" />
< select class=" pagesize" >
< option value=" 25" > 25< /option>
< /select>
< /td>
< /tr>
< /tfoot>
< tbody> < !-- tbody will be loaded via JSON -->
< /tbody>
< /table> < / pre >
< / div >
< div class = "next-up" >
< hr / >
Next up: < a href = "example-pager-filtered.html" > Pager plugin + filter widget › › < / a >
< / div >
< / div >
< script >
var $url = $('#url');
$('table')
// show current URL for the DEMO ONLY
2018-03-17 20:30:25 +00:00
.on('changingUrl', function(e, url) {
2013-10-18 03:59:07 +00:00
$url.html(url);
})
2018-03-17 20:30:25 +00:00
.on('pagerInitialized', function() {
2013-10-18 03:59:07 +00:00
// allow THIS demo to sort the content; this variable is automatically set to true when ajax
// is used as there isn't any way to sort the server side data from the client side.
this.config.serverSideSorting = false;
// show original highlighted URL
$('#origurl').html( this.config.widgetOptions.pager_ajaxUrl.replace(/(\{.*?\})/g, '< span class = "results" > $1< / span > ') );
});
< / script >
< / body >
< / html >
