论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2012-02-17 14:44 |只看该作者 |倒序浏览

datatable用法（3）

jquerydatatablestruts2json.

再添加一个功能，对各个列进行过滤。
添加js代码：

1.function fnCreateSelect( aData )
2.{
3. var r='<select><option value=""></option>', i, iLen=aData.length;
4. for ( i=0 ; i<iLen ; i++ )
5. {
6. r += '<option value="'+aData[i]+'">'+aData[i]+'</option>';
7. }
8. return r+'</select>';
9.}
10.
11.
12.(function($) {
13. /*
14. * Function: fnGetColumnData
15. * Purpose: Return an array of table values from a particular column.
16. * Returns: array string: 1d data array
17. * Inputs: object:oSettings - dataTable settings object. This is always the last argument past to the function
18. * int:iColumn - the id of the column to extract the data from
19. * bool:bUnique - optional - if set to false duplicated values are not filtered out
20. * bool:bFiltered - optional - if set to false all the table data is used (not only the filtered)
21. * bool:bIgnoreEmpty - optional - if set to false empty values are not filtered from the result array
22. * Author: Benedikt Forchhammer <b.forchhammer /AT\ mind2.de>
23. */
24. $.fn.dataTableExt.oApi.fnGetColumnData = function ( oSettings, iColumn, bUnique, bFiltered, bIgnoreEmpty ) {
25. // check that we have a column id
26. if ( typeof iColumn == "undefined" ) return new Array();
27.
28. // by default we only wany unique data
29. if ( typeof bUnique == "undefined" ) bUnique = true;
30.
31. // by default we do want to only look at filtered data
32. if ( typeof bFiltered == "undefined" ) bFiltered = true;
33.
34. // by default we do not wany to include empty values
35. if ( typeof bIgnoreEmpty == "undefined" ) bIgnoreEmpty = true;
36.
37. // list of rows which we're going to loop through
38. var aiRows;
39.
40. // use only filtered rows
41. if (bFiltered == true) aiRows = oSettings.aiDisplay;
42. // use all rows
43. else aiRows = oSettings.aiDisplayMaster; // all row numbers
44.
45. // set up data array
46. var asResultData = new Array();
47.
48. for (var i=0,c=aiRows.length; i<c; i++) {
49. iRow = aiRows[i];
50. var aData = this.fnGetData(iRow);
51. var sValue = aData[iColumn];
52.
53. // ignore empty values?
54. if (bIgnoreEmpty == true && sValue.length == 0) continue;
55.
56. // ignore unique values?
57. else if (bUnique == true && jQuery.inArray(sValue, asResultData) > -1) continue;
58.
59. // else push the value onto the result data array
60. else asResultData.push(sValue);
61. }
62.
63. return asResultData;
64. }}(jQuery));