annotate DataTables-1.9.4/extras/FixedColumns/server-side-processing.html @ 6:42076db43d42 draft

Fixed auto resizing plus various other minor bugs
author saskia-hiltemann
date Mon, 16 Nov 2015 08:56:22 -0500
parents ac5f9272033b
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
2 <html>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
3 <head>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
4 <meta http-equiv="content-type" content="text/html; charset=utf-8">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
5 <link rel="shortcut icon" type="image/ico" href="http://www.sprymedia.co.uk/media/images/favicon.ico">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
6
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
7 <title>FixedColumns example</title>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
8 <style type="text/css" title="currentStyle">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
9 @import "../../media/css/demo_page.css";
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
10 @import "../../media/css/demo_table.css";
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
11 </style>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
12 <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.js"></script>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
13 <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
14 <script type="text/javascript" charset="utf-8" src="media/js/FixedColumns.js"></script>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
15 <script type="text/javascript" charset="utf-8">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
16 $(document).ready( function () {
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
17 var oTable = $('#example').dataTable( {
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
18 "bProcessing": true,
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
19 "bServerSide": true,
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
20 "sAjaxSource": "../../examples/server_side/scripts/server_processing.php",
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
21 "sScrollX": "100%",
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
22 "sScrollXInner": "150%",
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
23 "fnInitComplete": function () {
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
24 new FixedColumns( oTable );
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
25 }
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
26 } );
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
27 } );
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
28 </script>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
29 </head>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
30 <body id="dt_example">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
31 <div id="container">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
32 <div class="full_width big">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
33 FixedColumns example - server-side processing
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
34 </div>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
35
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
36 <h1>Preamble</h1>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
37 <p>This example shows how FixedColumns can be used with server-side processing in DataTables to cope with very large tables. The only special thing to consider here is that the FixedColumns instance must be initialised once the table has completed its full initialisation - this is done using <i>fnInitComplete</i>.</p>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
38
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
39 <h1>Live example</h1>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
40 <div id="demo">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
41 <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
42 <thead>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
43 <tr>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
44 <th>Rendering engine</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
45 <th>Browser</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
46 <th>Platform(s)</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
47 <th>Engine version</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
48 <th>CSS grade</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
49 </tr>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
50 </thead>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
51 <tfoot>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
52 <tr>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
53 <th>Rendering engine</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
54 <th>Browser</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
55 <th>Platform(s)</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
56 <th>Engine version</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
57 <th>CSS grade</th>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
58 </tr>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
59 </tfoot>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
60 <tbody>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
61 </tbody>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
62 </table>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
63 </div>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
64 <div class="spacer"></div>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
65
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
66
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
67 <h1>Initialisation code</h1>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
68 <pre>$(document).ready( function () {
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
69 var oTable = $('#example').dataTable( {
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
70 "bProcessing": true,
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
71 "bServerSide": true,
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
72 "sAjaxSource": "../../examples/server_side/scripts/server_processing.php",
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
73 "sScrollX": "100%",
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
74 "sScrollXInner": "150%",
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
75 "fnInitComplete": function () {
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
76 new FixedColumns( oTable );
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
77 }
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
78 } );
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
79 } );</pre>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
80
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
81
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
82 <h1>Documentation</h1>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
83 <ul>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
84 <li><a href="http://datatables.net/extras/fixedcolumns">Usage</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
85 <li><a href="http://datatables.net/docs/FixedColumns">API / parameters</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
86 </ul>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
87
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
88 <h1>Basic examples</h1>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
89 <ul>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
90 <li><a href="index.html">Basic demo of FixedColumns with zero initialisation</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
91 <li><a href="left_right_columns.html">Fix the left and right columns in place</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
92 <li><a href="index_column.html">Index column attached to side of the table</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
93 <li><a href="x_y_scrolling.html">Index column, but with Y scrolling and no pagination</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
94 <li><a href="two_columns.html">Two columns fixed in place</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
95 <li><a href="right_column.html">Fix the right column in place</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
96 <li><a href="css_size.html">Speeding up row height matching with CSS</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
97 <li><a href="themed.html">jQuery UI themed table with FixedColumns</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
98 </ul>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
99
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
100 <h1>Advanced examples</h1>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
101 <ul>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
102 <li><a href="rowspan.html">Using ROWSPAN with FixedColumns</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
103 <li><a href="server-side-processing.html">Server-side processing with FixedColumns</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
104 <li><a href="col_filter.html">Individual column filtering</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
105 <li><a href="scale_fixed.html">Setting the fixed column width and resizing the table</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
106 <li><a href="scale_relative.html">Setting the fixed column width with relative sizing</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
107 <li><a href="row_grouping_height.html">Row grouping by grouping like rows in the fixed column</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
108 <li><a href="row_grouping.html">Row grouping by inserting a grouping row</a></li>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
109 <ul>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
110
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
111
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
112 <div id="footer" style="text-align:center;">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
113 <span style="font-size:10px;">
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
114 FixedColumns and DataTables &copy; Allan Jardine 2011.<br>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
115 </span>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
116 </div>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
117 </div>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
118 </body>
ac5f9272033b first upload
saskia-hiltemann
parents:
diff changeset
119 </html>