Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script type="text/javascript" charset="utf-8">
- /* <![CDATA[ */
- (function($) {
- $.fn.dataTableExt.oApi.fnGetColumnData = function(oSettings, iColumn, bUnique, bFiltered, bIgnoreEmpty) {
- // check that we have a column id
- if (typeof iColumn == "undefined") return new Array();
- // by default we only wany unique data
- if (typeof bUnique == "undefined") bUnique = true;
- // by default we do want to only look at filtered data
- if (typeof bFiltered == "undefined") bFiltered = true;
- // by default we do not wany to include empty values
- if (typeof bIgnoreEmpty == "undefined") bIgnoreEmpty = true;
- // list of rows which we're going to loop through
- var aiRows;
- // use only filtered rows
- if (bFiltered == true) aiRows = oSettings.aiDisplay;
- // use all rows
- else aiRows = oSettings.aiDisplayMaster; // all row numbers
- // set up data array
- var asResultData = new Array();
- for (var i = 0, c = aiRows.length; i < c; i++) {
- iRow = aiRows[i];
- var aData = this.fnGetData(iRow);
- var sValue = aData[iColumn];
- // ignore empty values?
- if (bIgnoreEmpty == true && sValue.length == 0) continue;
- // ignore unique values?
- else if (bUnique == true && jQuery.inArray(sValue, asResultData) > -1) continue;
- // else push the value onto the result data array
- else asResultData.push(sValue);
- }
- return asResultData;
- }
- }(jQuery));
- function fnCreateSelect(aData) {
- var r = '<select><option value=""></option>',
- i, iLen = aData.length;
- for (i = 0; i < iLen; i++) {
- r += '<option value="' + aData[i] + '">' + aData[i] + '</option>';
- }
- return r + '</select>';
- }
- $(document).ready(function() { /* Initialise the DataTable */
- var oTable = $('#wp-table-reloaded-id-1-no-1').dataTable({
- "oLanguage": {
- "sSearch": "Search all columns:"
- }
- });
- /* Add a select menu for each TH element in the table footer */
- $("tfoot th").each(function(i) {
- this.innerHTML = fnCreateSelect(oTable.fnGetColumnData(i));
- $('select', this).change(function() {
- oTable.fnFilter($(this).val(), i);
- });
- });
- }); /* ]]> */
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement