1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
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">
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 .FixedColumns_Cloned th { background-color: white; }
13 td.index { background-color: white; border-right: 1px solid black; }
14 table.display th.sorting_disabled { border-bottom: 1px solid white; }
16 <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.js"></script>
17 <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script>
18 <script type="text/javascript" charset="utf-8" src="media/js/ColReorder.js"></script>
19 <script type="text/javascript" charset="utf-8" src="../FixedColumns/media/js/FixedColumns.js"></script>
20 <script type="text/javascript" charset="utf-8">
21 $(document).ready( function () {
22 var oTable = $('#example').dataTable( {
25 "sScrollXInner": "150%",
26 "bScrollCollapse": true,
27 "fnDrawCallback": function ( oSettings ) {
28 /* Need to redo the counters if filtered or sorted */
29 if ( oSettings.bSorted || oSettings.bFiltered ) {
30 for ( var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++ ) {
31 $('td:eq(0)', oSettings.aoData[ oSettings.aiDisplay[i] ].nTr ).html( i+1 );
36 { "bSortable": false, "sClass": "index", "aTargets": [ 0 ] }
38 "aaSorting": [[ 1, 'asc' ]],
43 new FixedColumns( oTable );
47 <body id="dt_example">
49 <div class="full_width big">
50 ColReorder example with FixedColumns
54 <p>While ColReorder works great with scrolling in DataTables (and thus FixedColumns),
55 it also presents an additional option called 'iFixedColumns' which allows you to not
56 let the user reorder certain columns (specific the number given, counting left to
57 right). So in the case of FixedColumns this is useful because you typically won't want
58 to let your fixed column be reordered. This is shown below in the FixedColumns index column
64 <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
67 <th width="3%"> </th>
68 <th>Rendering engine</th>
71 <th>Engine version</th>
77 <td class="center">1</td>
82 <td class="center">4</td>
83 <td class="center">X</td>
86 <td class="center">2</td>
91 <td class="center">5</td>
92 <td class="center">C</td>
95 <td class="center">3</td>
100 <td class="center">5.5</td>
101 <td class="center">A</td>
104 <td class="center">4</td>
109 <td class="center">6</td>
110 <td class="center">A</td>
113 <td class="center">5</td>
115 <td>Internet Explorer 7</td>
117 <td class="center">7</td>
118 <td class="center">A</td>
121 <td class="center">6</td>
123 <td>AOL browser (AOL desktop)</td>
125 <td class="center">6</td>
126 <td class="center">A</td>
129 <td class="center">7</td>
132 <td>Win 98+ / OSX.2+</td>
133 <td class="center">1.7</td>
134 <td class="center">A</td>
137 <td class="center">8</td>
140 <td>Win 98+ / OSX.2+</td>
141 <td class="center">1.8</td>
142 <td class="center">A</td>
145 <td class="center">9</td>
148 <td>Win 98+ / OSX.2+</td>
149 <td class="center">1.8</td>
150 <td class="center">A</td>
153 <td class="center">10</td>
156 <td>Win 2k+ / OSX.3+</td>
157 <td class="center">1.9</td>
158 <td class="center">A</td>
161 <td class="center">11</td>
165 <td class="center">1.8</td>
166 <td class="center">A</td>
169 <td class="center">12</td>
173 <td class="center">1.8</td>
174 <td class="center">A</td>
177 <td class="center">13</td>
179 <td>Netscape 7.2</td>
180 <td>Win 95+ / Mac OS 8.6-9.2</td>
181 <td class="center">1.7</td>
182 <td class="center">A</td>
185 <td class="center">14</td>
187 <td>Netscape Browser 8</td>
189 <td class="center">1.7</td>
190 <td class="center">A</td>
193 <td class="center">15</td>
195 <td>Netscape Navigator 9</td>
196 <td>Win 98+ / OSX.2+</td>
197 <td class="center">1.8</td>
198 <td class="center">A</td>
201 <td class="center">16</td>
204 <td>Win 95+ / OSX.1+</td>
205 <td class="center">1</td>
206 <td class="center">A</td>
209 <td class="center">17</td>
212 <td>Win 95+ / OSX.1+</td>
213 <td class="center">1.1</td>
214 <td class="center">A</td>
217 <td class="center">18</td>
220 <td>Win 95+ / OSX.1+</td>
221 <td class="center">1.2</td>
222 <td class="center">A</td>
225 <td class="center">19</td>
228 <td>Win 95+ / OSX.1+</td>
229 <td class="center">1.3</td>
230 <td class="center">A</td>
233 <td class="center">20</td>
236 <td>Win 95+ / OSX.1+</td>
237 <td class="center">1.4</td>
238 <td class="center">A</td>
241 <td class="center">21</td>
244 <td>Win 95+ / OSX.1+</td>
245 <td class="center">1.5</td>
246 <td class="center">A</td>
249 <td class="center">22</td>
252 <td>Win 95+ / OSX.1+</td>
253 <td class="center">1.6</td>
254 <td class="center">A</td>
257 <td class="center">23</td>
260 <td>Win 98+ / OSX.1+</td>
261 <td class="center">1.7</td>
262 <td class="center">A</td>
265 <td class="center">24</td>
268 <td>Win 98+ / OSX.1+</td>
269 <td class="center">1.8</td>
270 <td class="center">A</td>
273 <td class="center">25</td>
275 <td>Seamonkey 1.1</td>
276 <td>Win 98+ / OSX.2+</td>
277 <td class="center">1.8</td>
278 <td class="center">A</td>
281 <td class="center">26</td>
283 <td>Epiphany 2.20</td>
285 <td class="center">1.8</td>
286 <td class="center">A</td>
289 <td class="center">27</td>
293 <td class="center">125.5</td>
294 <td class="center">A</td>
297 <td class="center">28</td>
301 <td class="center">312.8</td>
302 <td class="center">A</td>
305 <td class="center">29</td>
309 <td class="center">419.3</td>
310 <td class="center">A</td>
313 <td class="center">30</td>
317 <td class="center">522.1</td>
318 <td class="center">A</td>
321 <td class="center">31</td>
325 <td class="center">420</td>
326 <td class="center">A</td>
329 <td class="center">32</td>
331 <td>iPod Touch / iPhone</td>
333 <td class="center">420.1</td>
334 <td class="center">A</td>
337 <td class="center">33</td>
341 <td class="center">413</td>
342 <td class="center">A</td>
345 <td class="center">34</td>
348 <td>Win 95+ / OSX.1+</td>
349 <td class="center">-</td>
350 <td class="center">A</td>
353 <td class="center">35</td>
356 <td>Win 95+ / OSX.2+</td>
357 <td class="center">-</td>
358 <td class="center">A</td>
361 <td class="center">36</td>
364 <td>Win 95+ / OSX.2+</td>
365 <td class="center">-</td>
366 <td class="center">A</td>
369 <td class="center">37</td>
372 <td>Win 95+ / OSX.2+</td>
373 <td class="center">-</td>
374 <td class="center">A</td>
377 <td class="center">38</td>
380 <td>Win 95+ / OSX.3+</td>
381 <td class="center">-</td>
382 <td class="center">A</td>
385 <td class="center">39</td>
388 <td>Win 88+ / OSX.3+</td>
389 <td class="center">-</td>
390 <td class="center">A</td>
393 <td class="center">40</td>
396 <td>Win 88+ / OSX.3+</td>
397 <td class="center">-</td>
398 <td class="center">A</td>
401 <td class="center">41</td>
403 <td>Opera for Wii</td>
405 <td class="center">-</td>
406 <td class="center">A</td>
409 <td class="center">42</td>
413 <td class="center">-</td>
414 <td class="center">A</td>
417 <td class="center">43</td>
419 <td>Nintendo DS browser</td>
421 <td class="center">8.5</td>
422 <td class="center">C/A<sup>1</sup></td>
425 <td class="center">44</td>
427 <td>Konqureror 3.1</td>
429 <td class="center">3.1</td>
430 <td class="center">C</td>
433 <td class="center">45</td>
435 <td>Konqureror 3.3</td>
437 <td class="center">3.3</td>
438 <td class="center">A</td>
441 <td class="center">46</td>
443 <td>Konqureror 3.5</td>
445 <td class="center">3.5</td>
446 <td class="center">A</td>
449 <td class="center">47</td>
451 <td>Internet Explorer 4.5</td>
453 <td class="center">-</td>
454 <td class="center">X</td>
457 <td class="center">48</td>
459 <td>Internet Explorer 5.1</td>
460 <td>Mac OS 7.6-9</td>
461 <td class="center">1</td>
462 <td class="center">C</td>
465 <td class="center">49</td>
467 <td>Internet Explorer 5.2</td>
469 <td class="center">1</td>
470 <td class="center">C</td>
473 <td class="center">50</td>
475 <td>NetFront 3.1</td>
476 <td>Embedded devices</td>
477 <td class="center">-</td>
478 <td class="center">C</td>
481 <td class="center">51</td>
483 <td>NetFront 3.4</td>
484 <td>Embedded devices</td>
485 <td class="center">-</td>
486 <td class="center">A</td>
489 <td class="center">52</td>
492 <td>Embedded devices</td>
493 <td class="center">-</td>
494 <td class="center">X</td>
497 <td class="center">53</td>
501 <td class="center">-</td>
502 <td class="center">X</td>
505 <td class="center">54</td>
509 <td class="center">-</td>
510 <td class="center">X</td>
513 <td class="center">55</td>
516 <td>Windows Mobile 6</td>
517 <td class="center">-</td>
518 <td class="center">C</td>
521 <td class="center">56</td>
525 <td class="center">-</td>
526 <td class="center">C</td>
529 <td class="center">57</td>
530 <td>Other browsers</td>
533 <td class="center">-</td>
534 <td class="center">U</td>
540 <th>Rendering engine</th>
543 <th>Engine version</th>
550 <div class="spacer"></div>
555 <li><a href="index.html">Basic initialisation</a></li>
556 <li><a href="alt_insert.html">Styling the insert cursor</a></li>
557 <li><a href="col_filter.html">Individual column filtering</a></li>
558 <li><a href="colvis.html">Integration with DataTables' ColVis plug-in</a></li>
559 <li><a href="fixedcolumns.html">Integration with DataTables' FixedColumns plug-in</a></li>
560 <li><a href="fixedheader.html">Integration with DataTables' FixedHeader plug-in</a></li>
561 <li><a href="predefined.html">Using a predefined column order set</a></li>
562 <li><a href="reset.html">Providing a user control to reset the column order</a></li>
563 <li><a href="scrolling.html">Column reordering shown with scrolling in DataTables</a></li>
564 <li><a href="server_side.html">Server-side processing support</a></li>
565 <li><a href="state_save.html">State saving of the column position</a></li>
566 <li><a href="theme.html">jQuery UI theme integration</a></li>
570 <h1>Initialisation code</h1>
571 <pre>$(document).ready( function () {
572 var oTable = $('#example').dataTable( {
575 "sScrollXInner": "150%",
576 "bScrollCollapse": true,
577 "fnDrawCallback": function ( oSettings ) {
578 /* Need to redo the counters if filtered or sorted */
579 if ( oSettings.bSorted || oSettings.bFiltered ) {
580 for ( var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++ ) {
581 $('td:eq(0)', oSettings.aoData[ oSettings.aiDisplay[i] ].nTr ).html( i+1 );
586 { "bSortable": false, "sClass": "index", "aTargets": [ 0 ] }
588 "aaSorting": [[ 1, 'asc' ]],
593 new FixedColumns( oTable );
596 <div id="footer" style="text-align:center;">
597 <span style="font-size:10px;">
598 ColReorder and DataTables © Allan Jardine 2010