| 1 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> |
| 2 |
<html> |
| 3 |
<head> |
| 4 |
<meta http-equiv="content-type" content="text/html; charset=utf-8"> |
| 5 |
<link rel="shortcut icon" type="image/ico" href="http://www.sprymedia.co.uk/media/images/favicon.ico"> |
| 6 |
|
| 7 |
<title>ColReorder example</title> |
| 8 |
<style type="text/css" title="currentStyle"> |
| 9 |
@import "../../media/css/demo_page.css"; |
| 10 |
@import "../../media/css/demo_table.css"; |
| 11 |
@import "media/css/ColReorder.css"; |
| 12 |
</style> |
| 13 |
<script type="text/javascript" charset="utf-8" src="../../media/js/jquery.js"></script> |
| 14 |
<script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script> |
| 15 |
<script type="text/javascript" charset="utf-8" src="media/js/ColReorder.js"></script> |
| 16 |
<script type="text/javascript" charset="utf-8"> |
| 17 |
$(document).ready( function () { |
| 18 |
var oTable = $('#example').dataTable( { |
| 19 |
"sDom": 'Rlfrtip', |
| 20 |
"bProcessing": true, |
| 21 |
"bServerSide": true, |
| 22 |
"sAjaxSource": "../../examples/server_side/scripts/objects.php", |
| 23 |
"aoColumns": [ |
| 24 |
{ "mDataProp": "engine" }, |
| 25 |
{ "mDataProp": "browser" }, |
| 26 |
{ "mDataProp": "platform" }, |
| 27 |
{ "mDataProp": "version" }, |
| 28 |
{ "mDataProp": "grade" } |
| 29 |
] |
| 30 |
} ); |
| 31 |
} ); |
| 32 |
</script> |
| 33 |
</head> |
| 34 |
<body id="dt_example"> |
| 35 |
<div id="container"> |
| 36 |
<div class="full_width big"> |
| 37 |
ColReorder example with server-side processing |
| 38 |
</div> |
| 39 |
|
| 40 |
<h1>Preamble</h1> |
| 41 |
<p>Server-side processing can be exceptionally useful in DataTables when dealing with |
| 42 |
massive data sets, and ColReorder works with this as would be expected. There must be |
| 43 |
special consideration for the column ordering on the server-side script since the |
| 44 |
columns can be in an unexpected order. For this you can either choose to use the |
| 45 |
<i>sName</i> parameter for each column and take this into account in the server-side |
| 46 |
script (the parameter 'sColumns' is a comma separated string of these sName parameters).</p> |
| 47 |
|
| 48 |
</p>Alternatively use the more flexible <a href="http://datatables.net/usage/columns#mDataProp">mDataProp</a> |
| 49 |
option for each column. This allows you to use JSON objects which DataTables, so order doesn't |
| 50 |
matter like it would do in an array. Again the server-side script must take this into account |
| 51 |
through the <i>mDataProp_{i}</i> which is sent for each column (so the server knows which |
| 52 |
column is to be sorted on).</p> |
| 53 |
|
| 54 |
|
| 55 |
<h1>Live example</h1> |
| 56 |
<form> |
| 57 |
<div id="demo"> |
| 58 |
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example"> |
| 59 |
<thead> |
| 60 |
<tr> |
| 61 |
<th>Rendering engine</th> |
| 62 |
<th>Browser</th> |
| 63 |
<th>Platform(s)</th> |
| 64 |
<th>Engine version</th> |
| 65 |
<th>CSS grade</th> |
| 66 |
</tr> |
| 67 |
</thead> |
| 68 |
<tfoot> |
| 69 |
<tr> |
| 70 |
<th>Rendering engine</th> |
| 71 |
<th>Browser</th> |
| 72 |
<th>Platform(s)</th> |
| 73 |
<th>Engine version</th> |
| 74 |
<th>CSS grade</th> |
| 75 |
</tr> |
| 76 |
</tfoot> |
| 77 |
<tbody> |
| 78 |
</tbody> |
| 79 |
</table> |
| 80 |
</div> |
| 81 |
</form> |
| 82 |
<div class="spacer"></div> |
| 83 |
|
| 84 |
|
| 85 |
<h1>Examples</h1> |
| 86 |
<ul> |
| 87 |
<li><a href="index.html">Basic initialisation</a></li> |
| 88 |
<li><a href="alt_insert.html">Styling the insert cursor</a></li> |
| 89 |
<li><a href="col_filter.html">Individual column filtering</a></li> |
| 90 |
<li><a href="colvis.html">Integration with DataTables' ColVis plug-in</a></li> |
| 91 |
<li><a href="fixedcolumns.html">Integration with DataTables' FixedColumns plug-in</a></li> |
| 92 |
<li><a href="fixedheader.html">Integration with DataTables' FixedHeader plug-in</a></li> |
| 93 |
<li><a href="predefined.html">Using a predefined column order set</a></li> |
| 94 |
<li><a href="reset.html">Providing a user control to reset the column order</a></li> |
| 95 |
<li><a href="scrolling.html">Column reordering shown with scrolling in DataTables</a></li> |
| 96 |
<li><a href="server_side.html">Server-side processing support</a></li> |
| 97 |
<li><a href="state_save.html">State saving of the column position</a></li> |
| 98 |
<li><a href="theme.html">jQuery UI theme integration</a></li> |
| 99 |
</ul> |
| 100 |
|
| 101 |
|
| 102 |
<h1>Initialisation code</h1> |
| 103 |
<pre>$(document).ready( function () { |
| 104 |
var oTable = $('#example').dataTable( { |
| 105 |
"sDom": 'Rlfrtip', |
| 106 |
"bProcessing": true, |
| 107 |
"bServerSide": true, |
| 108 |
"sAjaxSource": "../../examples/server_side/scripts/objects.php", |
| 109 |
"aoColumns": [ |
| 110 |
{ "mDataProp": "engine" }, |
| 111 |
{ "mDataProp": "browser" }, |
| 112 |
{ "mDataProp": "platform" }, |
| 113 |
{ "mDataProp": "version" }, |
| 114 |
{ "mDataProp": "grade" } |
| 115 |
] |
| 116 |
} ); |
| 117 |
} );</pre> |
| 118 |
|
| 119 |
<h1>Example JSON return from the server</h1> |
| 120 |
<pre>{ |
| 121 |
"sEcho": 1, |
| 122 |
"iTotalRecords": "57", |
| 123 |
"iTotalDisplayRecords": "57", |
| 124 |
"aaData": [ |
| 125 |
{ |
| 126 |
"engine": "Gecko", |
| 127 |
"browser": "Firefox 1.0", |
| 128 |
"platform": "Win 98+ / OSX.2+", |
| 129 |
"version": "1.7", |
| 130 |
"grade": "A" |
| 131 |
}, |
| 132 |
{ |
| 133 |
"engine": "Gecko", |
| 134 |
"browser": "Firefox 1.5", |
| 135 |
"platform": "Win 98+ / OSX.2+", |
| 136 |
"version": "1.8", |
| 137 |
"grade": "A" |
| 138 |
}, |
| 139 |
... |
| 140 |
] |
| 141 |
}</pre> |
| 142 |
|
| 143 |
<div id="footer" style="text-align:center;"> |
| 144 |
<span style="font-size:10px;"> |
| 145 |
ColReorder and DataTables © Allan Jardine 2010 |
| 146 |
</span> |
| 147 |
</div> |
| 148 |
</div> |
| 149 |
</body> |
| 150 |
</html> |
Parent Directory
| 
Revision Log