/**
* @projectDescription tableFilter, a table filtering/paging/sorting plugin for jquery.
*
* @author John Wilson (daemach) daemach@gmail.com
* @version 1.1
* @since 1.0
*/
/**
* jQuery plugin to create a new tableFilter instance from a jQuery result set.
*
* @param {Object} tblOptions A javascript object containing key-value pairs that set table-level options for the plugin.
* @param {Object} colOptions A javascript object containing key-value pairs that set column-level options for the plugin.
* @return {jQuery} Returns a jQuery object
* @example
*
* Automatic:
* $("#yourTable").tableFilter();
*
* Manual:
* $("##mListTbl").tableFilter({sortOnLoad: 10}, //tblOptions - global. sortOnLoad takes a column number.
* { //colOptions - config object key is the column number.
5:{dataType:"string",bFilter:true,bSort:true},
6:{dataType:"date",bFilter:true,bSort:true,fieldType:"select | text"},
8:{dataType:"number",bFilter:true,bSort:true}
}
);
*
* Table-level options:
* stripeClass: "offColor", // the css class used to stripe table rows
pageLength: "25", // default number of rows to show
paging: true, // toggle paging
bSort: true, // toggle sorting
bFilter: true, // toggle filtering
sortOnLoad: 0, // if false, no sorting on load. Otherwise a valid column number on which to sort
sortOnLoadDir: null, // 'asc | desc'
decimalPlaces: 2, // level of precision of numeric values
loadPlugins: true, // false to not load any plugins
showDebug: false, // true to show debug information in the firebug console
imagePath: "/images/icons" //path to the icon files used for the paging buttons.
*
* Column-level options:
* dataType: "string | date | number", // override auto datatype sensing
* bFilter: true, // toggle filtering
* bSort: true, // toggle sorting
* fieldType: "text | select" // filter field type
*
*
*/
jQuery.fn.tableFilter = function(tblOptions, colOptions){
var newTableFilter;
return this.each(function(){
newTableFilter = new jQuery.tblFilter(this, tblOptions, colOptions);
if (window.$daemach.debug) {
if (typeof $daemach.tableFilter == "undefined") {
$daemach.tableFilter = [];
}
$daemach.tableFilter.push(newTableFilter);
}
});
};
/*
colOptions: {1:{dataType:"string",bFilter:true,bSort:true,fieldType:"select")}
*/
/**
* Create a new instance of tableFilter.
*
* @classDescription This class creates a new tableFilter object.
* @return {Object} Returns a new tableFilter object.
* @constructor
*/
jQuery.tblFilter = function(tbl, tblOptions, colOptions){
if ($("#tableFilter_header", tbl).size()) {
return
};
var root = this;
this.version = "1.0 b2";
this.userSettings = (jQuery.cookie) ? (JSON.parse($.cookie('daemach.tf.userSettings')) ||
{}) : {};
this.settings = jQuery.extend({}, jQuery.tblFilter.defaults, tblOptions, this.userSettings);
this.settings = jQuery.extend(this.settings, this.userSettings);
this.getText = this.getBrowserTextField();
this.browserSucks = jQuery.browser.msie;
this.table = tbl;
this.allRows = [];
this.visibleRows = [];
this.columnList = [];
this.cols = [];
this.headerRows = [];
this.footerRows = [];
this.lastCell = null;
this.currentPage = 1;
this.maxPage = 1;
this.colSettings = colOptions ||
{};
this.totalElements = 0;
this.lastFilterEvent = false;
this.lastFilterElement = false;
this.lastFilterCtrl = false;
this.buildComplete = false;
this.filterList = [];
this.sortList = [];
this.uniqueLength = 1;
this.plugins = {};
this.pluginList = [];
this.menu ={
id: "",
count: 0,
isAnimating: false,
enablePlugins: function(root){
if (confirm("Are you sure you want to " + ((root.settings.loadPlugins) ? "disable" : "enable") + " plugins?")) {
root.saveUserSettings("loadPlugins", ((root.settings.loadPlugins) ? false : true));
window.location.reload();
};
},
showDebug: function(root){
$d.debug = (root.settings.showDebug) ? false : true;
root.saveUserSettings("showDebug", ((root.settings.showDebug) ? false : true));
if (confirm("Debug " + ((root.settings.showDebug) ? "disabled." : "enabled.") + " Reload? " + ((root.settings.showDebug) ? "" : "(You're going to need firebug to see this...)"))) {
window.location.reload();
};
},
setAnchor: function(root){
}
};
$d.debug = this.settings.showDebug;
$d.time("Total Build Time");
var row;
this.parseTable();
if (this.browserSucks) {
$d.cm.setRule("td", "display:none");
}
/*
$d.delay(function(){
var t = ((root.browserSucks && root.lastCell.currentStyle.display == "none") || (!root.browserSucks && root.lastCell.offsetTop == 0));
console.log((!root.browserSucks && root.lastCell.offsetTop == 0),t);
return t;
},root.buildBody,root);
*/
this.parseColumns();
this.buildColumns();
if (this.browserSucks) {
$d.cm.setRule("td", "display:''");
}
this.lockColumns();
$d.timeEnd("Total Build Time");
$d.log(" ");
// console.profile();
if (this.cols.length && !(typeof this.settings.sortOnLoad == "boolean")) {
this.cols[this.settings.sortOnLoad].sortColumn(this.settings.sortOnLoadDir);
};
// console.profileEnd();
jQuery(window).bind("resize", function(e){
root.lockColumns(true);
root.menu.setAnchor(root);
});
jQuery(window).bind("load", function(e){
root.menu.setAnchor(root);
});
this.buildComplete = true;
return this;
};
jQuery.extend(jQuery.tblFilter, {
defaults: {
stripeClass: "offColor",
pageLength: "25",
paging: true,
bSort: true,
bFilter: true,
sortOnLoad: 0,
sortOnLoadDir: null,
decimalPlaces: 2,
loadPlugins: true,
showDebug: false,
imagePath: "/images/icons"
},
prototype: {
getVisibleRows: function(){
var ta = [];
var vr = this.visibleRows;
var rs = {};
rs.recordcount = vr.length;
rs.columnlist = this.columnList;
rs.data = {};
for (var c = 0; c < rs.columnlist.length; c++) {
ta = [];
for (var r = 0; r < rs.rowcount; r++) {
ta.push(vr[r][0][c][1]);
}
rs.data[rs.columnlist[c]] = ta;
}
return rs;
},
filterTable: function(op){
var sort = (op === "sort") ? true : false;
var page = (op === "page") ? true : false;
var filter = (op === "filter") ? true : false;
var root = this;
var fl = this.filterList;
var pl = this.pluginList;
var ar = this.allRows;
var vrows = this.visibleRows;
var show = false;
var vr = 0; // visible record count
var pr = 0; // page record count
var fc = 0; // filter count
var sc = this.settings.stripeClass;
var minRow = (((this.currentPage - 1) * this.settings.pageLength) + 1);
var maxRow = (this.currentPage * this.settings.pageLength);
var fltChk = false;
var row, r, i;
$d.time("Filtering " + fl.length + " column" + ((fl.length == 1) ? "" : "s"));
if (this.settings.loadPlugins) {
// init plugins
for (i = 0; i < pl.length; i++) {
pl[i].startPlugins(filter, page, sort);
};
};
// start looping...
for (var r = 0; r < ar.length; r++) {
row = ar[r][1];
// sort early to try and buy %^$@^%$@^%$ IE some time
if (sort) {
this.tbody.appendChild(row);
}
// filter first - if there is nothing in the filter list, show everything
fltChk = (fl.length) ? false : true;
for (i = 0; i < fl.length; i++) {
fltChk = fl[i].cFilter(ar[r][0][fl[i].index]);
if (!fltChk) {
break;
}; // break after first failure
};
if (fltChk) {
vr++;
show = (vr >= minRow && vr <= maxRow);
}
else {
show = false;
};
ar[r][2] = show;
if (show) {
vrows.push(ar[r]);
}
if (this.settings.loadPlugins) {
// process filter plugins
for (i = 0; i < pl.length; i++) {
pl[i].processPlugins(fltChk, show, ar[r][0][pl[i].index], r);
};
};
// stripe and hide
if (!this.browserSucks) {
if (show) {
row.style.display = "";
if (!(fc++ % 2)) {
$(row).addClass(sc);
}
else {
$(row).removeClass(sc);
};
}
else {
row.style.display = "none";
};
};
};
fc = 0; // grumble...
// I despise IE...
if (this.browserSucks) {
for (var i = 0; i < ar.length; i++) {
e = ar[i][1];
if (ar[i][2]) {
e.style.display = "";
if (!(fc++ % 2))
$(e).addClass(sc);
else
$(e).removeClass(sc);
}
else {
e.style.display = "none";
};
};
}; // IE sucks
if (this.settings.loadPlugins) {
// process filter plugins
for (i = 0; i < pl.length; i++) {
pl[i].finishPlugins();
};
};
$d.timeEnd("Filtering " + fl.length + " column" + ((fl.length == 1) ? "" : "s"));
this.maxPage = Math.floor(vr / this.settings.pageLength) + ((vr % this.settings.pageLength) ? 1 : 0);
this.updatePageNav(vr, ar.length, this.settings.pageLength); // currently visible, total records
},
sortTable: function(){
var sl = this.sortList;
var tb = this.tbody;
var a = "var sortProxy = function (a,b){ return alphaSort(";
var b = "";
var c = ",";
var d = "";
var e = ")}";
$d.time("Sorting " + sl.length + " column" + ((sl.length == 1) ? "" : "s"));
for (var i = 0; i < sl.length; i++) {
// a[0][c][1-2]
b += ((i) ? "+" : "") + ((sl[i].sortAsc) ? "a" : "b") + "[0][" + sl[i].index + "][0]";
c += ((i) ? "+" : "") + ((sl[i].sortAsc) ? "b" : "a") + "[0][" + sl[i].index + "][0]";
}
eval(a + b + c + d + e);
var alphaSort = function(a, b){
if (a == b) {
return 0;
};
if (a < b) {
return -1;
};
return 1;
};
// sort it
this.allRows.sort(sortProxy);
$d.timeEnd("Sorting " + sl.length + " column" + ((sl.length == 1) ? "" : "s"));
this.filterTable("sort");
},
pageNav: function(e){
var p = e.target.id.indexOf("_") + 5;
var action = e.target.id.substr(p, e.target.id.length - p);
var curPage = this.currentPage;
var maxPage = this.maxPage;
var val;
switch (action) {
case "First":
if (curPage !== 1) {
this.currentPage = 1;
}
;
break;
case "Prev":
if (curPage > 1) {
this.currentPage = this.currentPage - 1;
}
;
break;
case "Current":
val = parseInt($('#' + this.table.id + '_pageCurrent').val());
if (val != this.currentPage) {
this.currentPage = (val > maxPage) ? maxPage : val;
}
;
break;
case "Next":
if (curPage < maxPage) {
this.currentPage = this.currentPage + 1;
}
;
break;
case "Last":
if (curPage !== maxPage) {
this.currentPage = maxPage;
}
;
break;
case "Records":
val = parseInt($("#" + this.table.id + "_pageRecords").val());
if (val != this.settings.pageLength) {
this.currentPage = 1;
this.settings.pageLength = val;
this.saveUserSettings("pageLength", this.settings.pageLength);
}
;
break;
};
this.filterTable("filter");
},
updatePageNav: function(v, t, l){
var root = this;
var re = /(\-disabled\.gif)/;
var disable = function(str){
var tmp;
if (re.test(str)) {
return str;
}
else {
tmp = str.split(".");
tmp.pop();
return tmp.join(".") + "-disabled.gif"
};
};
var enable = function(str){
var tmp;
if (re.test(str)) {
return str.replace(re, ".gif");
}
else {
return str;
};
};
$('#' + this.table.id + '_pageFirst').add('#' + this.table.id + '_pagePrev').attr("src", function(){
return (root.maxPage === 1 || root.currentPage == 1) ? disable(this.src) : enable(this.src);
});
$('#' + this.table.id + '_pageCurrent').val(this.currentPage.toString());
$('#' + this.table.id + '_pageLast').add('#' + this.table.id + '_pageNext').attr("src", function(){
return (root.maxPage === 1 || root.currentPage == root.maxPage) ? disable(this.src) : enable(this.src);
});
$('#' + this.table.id + '_pageCount').text(this.maxPage.toString());
$('#' + this.table.id + '_pageVisible').text(v.toString());
$('#' + this.table.id + '_pageTotal').text(t.toString());
},
saveUserSettings: function(key, value){
var setting = {};
if (jQuery.cookie) {
setting[key] = value;
this.userSettings = JSON.toJSONString(jQuery.extend({}, this.userSettings, setting));
jQuery.cookie('daemach.tf.userSettings', this.userSettings, {
expires: 10,
path: '/'
});
};
},
parseTable: function(){
$d.time("Parse Table");
var headRows = []; //temp storage in case we find no thead
var footRows = []; //temp storage in case we find no tfoot
var cellsLength = [];
var allRows = this.table.rows;
var lengthChange = false;
var footDone = false;
var thisRow;
var root = this;
var ip = this.settings.imagePath;
// halfway through the table we're going to look for header rows
var half = allRows.length - Math.round((allRows.length / 2), 0);
for (var r = allRows.length - 1; r >= 0; r--) {
thisRow = allRows[r];
if (r == allRows.length - 1) {
cellsLength.push([allRows[r].cells.length, r]); // first pass - set initial value
};
lengthChange = allRows[r].cells.length !== cellsLength[cellsLength.length - 1][0];
if (headRows.length || ((r < half) && lengthChange) || r == 0) {
// found a candidate - push the rest of the rows
headRows.push(allRows[r]);
};
if ((r > half) && !footDone) {
if (lengthChange) {
footDone = true;
}
else {
footRows.push(allRows[r]);
};
};
if (lengthChange) {
cellsLength.push([allRows[r].cells.length, r]);
lengthChange = false;
}; //store the length and row number
};
this.cellsLength = cellsLength;
// deal with heaers/footers
var head = jQuery('thead', this.table);
var foot = jQuery('tfoot', this.table);
if (!head.size()) {
//make a header block
head = jQuery('').prependTo(this.table);
var cl = this.cellsLength.reverse();
if (cl.length == 2 && (cl[1][1] - cl[0][1]) > half) { // 2 size changes, last one occurred after the halfway point
if (cl[0][0] < cl[1][0]) { // if there are less cells in the caught header than in the rest of the table, grab a new one.
headRows.reverse().push(allRows[cl[0][1] + 1]);
headRows.reverse();
};
};
jQuery(headRows).each(function(){
jQuery(this).prependTo(head);
});
};
if (!foot.size()) {
//make a footer block
foot = jQuery('').prependTo(this.table);
if (footRows.length < 3) {
// jQuery(footRows).each(function(){ jQuery(this).prependTo(foot); }); //take a shot...
};
};
this.headerRows[0] = jQuery('tr:last-child', head)[0]; // sorting row
this.headerRows[1] = jQuery(this.headerRows[0]).clone().attr("id", "tableFilter_header").appendTo(head).children().empty().end()[0]; // filtering row
// set tbody after creating thead and tfoot
this.tbody = jQuery('tbody', this.table)[0];
//this.lastCell = this.tbody.rows[this.tbody.rows.length-1].cells[this.tbody.rows[0].cells.length-1];
var tbodyWidth = 0;
// determine cell counts
var cellCount = jQuery('tr', this.tbody)[0];
cellCount = jQuery(cellCount).children();
cellCount.each(function(){
var tmp = jQuery(this).attr('colspan');
tbodyWidth += (tmp) ? tmp : 1;
});
// make it so
this.actualCellCount = tbodyWidth;
this.cellCount = cellCount.size();
//make sure on initial parse that the saved/default value is not larger than the actual number of rows or there is no way to get to the paging bar
this.settings.pageLength = (this.settings.pageLength > this.tbody.rows.length) ? this.tbody.rows.length : this.settings.pageLength;
if (this.settings.paging && this.tbody.rows.length) {
this.maxPage = Math.floor(this.tbody.rows.length / this.settings.pageLength) + ((this.tbody.rows.length % this.settings.pageLength) ? 1 : 0);
this.pagingRow = jQuery(this.headerRows[1]).clone().removeAttr("id").empty().appendTo(foot); // paging row
this.pagingRow.append('   Page of ' + this.maxPage + '    Showing: rows per page - ( visible/ total) | ').find("img").css("cursor", "pointer").bind("click", this, function(e){
e.data.pageNav(e)
}).end().find("input").addClass("filter").bind("change", this, function(e){
e.data.pageNav(e)
}).bind("blur", this, function(e){
e.data.pageNav(e)
}).bind("keydown", function(e){
if (!((e.keyCode >= 48 && e.keyCode <= 57) || (e.keyCode >= 96 && e.keyCode <= 105)) && e.keyCode != 46 && e.keyCode != 8 && e.keyCode != 9)
return false;
});
// create menu pass either elements or jQuery selectors for base and trigger. id must be a valid id string.
this.createMenu(this.table.id + "_p_menu", "#" + this.table.id + "_p_base", this.pagingRow[0], "up", "#" + this.table.id + "_p_menu_trigger", "click");
this.createMenuItem("TableFilter " + this.version, this.menu.element);
this.createSeparator(this.menu.element);
this.createMenuItem(((this.settings.loadPlugins) ? "Disable" : "Enable") + " plugins", this.menu.element, function(){
root.menu.enablePlugins(root);
});
this.createMenuItem(((this.settings.showDebug) ? "Hide" : "Show") + " debug info", this.menu.element, function(){
root.menu.showDebug(root);
});
this.createSeparator(this.menu.element);
}
// set up colgoup for locking
this.colgroup = jQuery('colgroup', this.table);
if (!this.colgroup.size()) {
this.colgroup = jQuery('' + "".repeat(this.cellCount) + '').prependTo(this.table);
}
else {
this.colgroup = this.colgroup[0];
};
$d.timeEnd("Parse Table");
},
/**************************** Menu functions *********************************/
createMenu: function(eid, base, container, direction, trigger, inEvent, outEvent, menuClass){
var menu, mColor, lbColor, dbColor, root = this, setClass = false, tid = this.table.id;
base = $(base).css("position", "relative")[0];
var cont = (container === null) ? base : container;
this.menu.id = eid || tid + '_' + "menu_" + this.menu.count++;
if (!this.menu.mClass) {
this.menu.mClass = this.menu.id;
setClass = true;
}
if (menuClass) {
setClass = true;
}
else {
menuClass = this.menu.mClass;
}
if (setClass) {
// we're going to modify the menu colors to match the paging row
mColor = $d.cw.rgb2hex($d.cm.getRootStyle(base, "backgroundColor"));
// ie... it actually prepends a #!!! wth?
mColor = mColor.substring(mColor.length - 6);
lbColor = $d.cw.ccLighter(mColor, .15);
dbColor = $d.cw.ccDarker(mColor, .15);
// create CSS class specific to this menu
$d.cm.setRule("." + menuClass + " li", "border: 1px solid; border-color: #" + lbColor + " #" + dbColor + " #" + dbColor + " #" + lbColor + "; background-color: #" + mColor + ";");
$d.cm.setRule("." + menuClass + " li:hover", "border: 1px solid; border-color: #" + dbColor + " #" + lbColor + " #" + lbColor + " #" + dbColor + ";");
$d.cm.setRule("." + menuClass + " li.separator", "border: 1px solid; border-color: #" + dbColor + " #" + lbColor + " #" + lbColor + " #" + dbColor + ";");
if (this.browserSucks) {
$d.cm.setRule("." + menuClass + " li.separator", "display:inline; background-color: #" + mColor + ";");
$d.cm.setRule("." + menuClass + " .submenu", "background-color: #" + mColor + ";");
$d.cm.setRule(".menu li ul", "bottom: -3; left: 137px;");
}
// add background-color to menu div
$d.cm.setRule(".menu", "background-color: #" + mColor + ";");
}
this.menu.element = $('').appendTo(base);
this.menu.setAnchor = function(root){
var loc = (direction == "up") ? "bottom" : "top";
var rh = parseInt(cont.offsetHeight) + parseInt(cont.style.padding || 0) + parseInt(cont.style.borderBottomWidth || 0) + parseInt(cont.style.borderTopWidth || 0);
var dh = parseInt(base.offsetHeight) + parseInt(base.style.padding || 0) + parseInt(base.style.borderBottomWidth || 0) + parseInt(base.style.borderTopWidth || 0);
var ca = (dh + ((rh - dh) / 2)) + "px";
var la = $('#' + root.menu.id + '_trigger')[0].offsetLeft + "px";
var ed = (cont.nodeName.toLowerCase() == "td" && cont.cellIndex == root.cellCount - 1) ? "right" : "left";
var ps = (ed == "right") ? "-2px" : la;
var menu = $(root.menu.element);
menu.css(loc, ca).css("left", la).css(ed, ps);
};
this.menu.setAnchor(root);
menu = this.menu.element;
if (trigger) {
inEvent = inEvent || "mouseover";
outEvent = outEvent || "mouseout";
// bind open/close triggers
jQuery(trigger).bind(inEvent, function(menu){
if (!root.menu.isAnimating) {
// yeah - slideDown? What's that about..
$('#' + root.menu.id).slideToggle("slow", function(){
root.menu.isAnimating = false;
});
root.menu.isAnimating = true;
}
return false;
});
if (outEvent === "mouseout") {
jQuery('#' + this.menu.id).truemouseout(function(){
var temp = root.menu;
if (!root.menu.isAnimating) {
$(this).slideUp("slow", function(){
root.menu.isAnimating = false;
});
root.menu.isAnimating = true;
}
return false;
});
}
else {
jQuery('#' + this.menu.id).bind(outEvent, function(){
var temp = root.menu;
if (!root.menu.isAnimating) {
$(this).slideUp("slow", function(){
root.menu.isAnimating = false;
});
root.menu.isAnimating = true;
}
return false;
});
}
};
},
createSubMenu: function(text, target){
target = jQuery(target).children('ul').eq(0);
var sm = jQuery('').appendTo(target).hover(function(){
$(this).addClass("over")
}, function(){
$(this).removeClass("over")
}).append('');
return sm;
},
createMenuItem: function(text, target, fn, id){
target = jQuery(target).children('ul').eq(0);
var mi = jQuery('' + text + '').appendTo(target);
if (fn) {
mi.bind('click', fn);
};
if (id) {
mi.attr("id", id);
};
return mi;
},
createSeparator: function(target){
target = jQuery(target).children('ul').eq(0);
// var mi = jQuery(''+((this.browserSucks)?'':' ')+'').appendTo(target);
var mi = jQuery('').appendTo(target);
},
guessDataType: function(rows, c){ // null rows suck. To avoid reparsing, test 10 rows
var dt1, dt2, chk, cell, lc = 0, same = 0, tc = 0;
if (rows.length > 100) {
chk = Math.floor(rows.length * .1);
}
else {
chk = Math.floor(rows.length * .2) || 1;
};
for (var r = 0; r < rows.length; r++) { // get first non-null cell
cell = rows[r].cells[c];
dt1 = this.getText(cell).trim();
if (dt1.length) {
dt1 = this.getDataType(dt1);
break;
};
};
lc = r + 1;
while (lc < rows.length) {
dt2 = this.getText(rows[lc].cells[c]).trim();
dt2 = this.getDataType(dt2);
if (!dt2.length || dt1 == dt2) { // if no length, go with it. This is best-guess...
same++;
};
lc += chk;
tc++;
};
if ((same / tc) < .75) {
return "string";
}
else {
return dt1;
};
},
makeTempColumn: function(dataType, c){
this.tmpCol = {};
var tc = this.tmpCol;
tc.cDataType = dataType;
tc.dataType = (typeof this.colSettings[c] != "undefined" && this.colSettings[c].dataType) ? this.colSettings[c].dataType : dataType;
tc.uniqueCount = 0;
tc.root = this;
tc.index = c;
switch (tc.dataType) {
case "string":
tc.uniqueText = [];
break;
case "date":
tc.uniqueYears = [];
tc.uniqueMonths = [];
break;
case "number":
tc.decimals = false;
tc.lengthChange = false;
tc.uniqueText = [];
break;
};
tc.sortAsc = null;
tc.defaultSortAsc = true;
tc.maxLen = null;
tc.reparse = false;
},
parseColumns: function(){
$d.time("Parse Column Data");
//var col = $(this.colgroup).children().get();
var rows = this.tbody.rows;
var rLen = rows.length;
var cLen = this.cellCount;
var row, cell, tCell, nCell, tmp, text, html, cn, textLength, dataType, cols = {};
for (var c = 0; c < cLen; c++) {
//col[c].style.display = "none";
dataType = this.guessDataType(rows, c);
this.makeTempColumn(dataType, c);
textLength = 0;
$d.time("Parsing Column " + c);
for (var r = 0; r < rLen; r++) {
this.totalElements++;
row = rows[r];
cell = row.cells[c];
// init the row on the first column only
if (!c) {
this.allRows[r] = [[], rows[r], true];
};
cn = "c" + c + " r" + r + " " + cell.className;
text = (!this.browserSucks) ? cell.textContent.trim() : cell.innerText.trim();
/*
* attemping creating a spankin new node and replacing for IE *fail*
if (this.browserSucks){
html = cell.innerHTML;
nCell = row.cells[c+1];
tCell = document.createElement('td');
tCell.className = cn;
tCell.innerHTML = html;
row.removeChild(cell);
if (c<=row.cells.length-1){
row.insertBefore(tCell,nCell);
}else{
row.appendChild(tCell);
}
// attemping cloning the node, adding className and replacing for IE *fail*
// tCell = cell.cloneNode(true);
// tCell.className = cn;
// row.replaceChild(tCell,cell);
}
*/
if (!this.browserSucks || rLen < 500) {
cell.className = cn;
}
this.allRows[r][0][c] = this.parseText(text);
if (text.length) {
textLength += text.length;
};
};
$d.timeEnd("Parsing Column " + c);
if (this.tmpCol.reparse) {
$d.time("Reparsing column " + c);
for (r = 0; r < rLen; r++) {
text = this.allRows[r][0][c][1];
if (text.length) {
this.allRows[r][0][c] = this.parseText(text);
};
};
$d.timeEnd("Reparsing column " + c);
};
if (textLength) {
switch (this.tmpCol.dataType) {
case "string":
this.tmpCol.uniqueText.sort();
break;
case "date":
this.tmpCol.uniqueMonths.sort();
this.tmpCol.uniqueYears.sort();
break;
case "number":
this.tmpCol.uniqueText.sort();
break;
};
this.cols[c] = new jQuery.colFilter(this.tmpCol);
if (this.settings.loadPlugins) {
this.addPlugins(this.cols[c]);
}
};
//col[c].style.display = "";
}//for column
$d.timeEnd("Parse Column Data");
},
addPlugins: function(col){
var tfp = jQuery.tblFilter.tfPlugins, name;
if (tfp[col.dataType].length) {
for (var i = 0; i < tfp[col.dataType].length; i++) {
col.pluginList.push(new tfp[col.dataType][i](col));
//get plugin name
name = col.pluginList[col.pluginList.length - 1].name;
if (!this.plugins[name]) {
this.plugins[name] = {};
};
};
this.pluginList.push(col);
col.initPlugins();
};
},
parseText: function(text){
var arr, tc = this.tmpCol;
if (text.length) {
arr = this.parse[tc.dataType](tc, text);
}
else {
switch (tc.dataType) {
case "date":
arr = ["00000101", "01/01/0000"];
break;
case "number":
arr = ["0".repeat(tc.maxLen), 0, 0];
break;
case "string":
arr = ["", ""];
break;
};
};
return arr;
},
parse: {
string: function(tmpCol, text){
var arr = [];
arr[0] = text.toLowerCase().replace(/[^\w]*/g, "");
arr[1] = text;
if (tmpCol.uniqueCount <= tmpCol.root.uniqueLength && tmpCol.uniqueText.indexOf(text) < 0) {
tmpCol.uniqueText.push(text);
tmpCol.uniqueCount++;
};
if (tmpCol.maxLen === null) {
tmpCol.maxLen = arr[1].length;
};
if (tmpCol.maxLen < arr[1].length) {
tmpCol.maxLen = arr[1].length;
};
return arr;
},
date: function(tmpCol, text){
var arr = [], s, tmp, month, year, day;
var _zeroPad = function(num){
s = '0' + num;
return s.substring(s.length - 2);
};
var _unique = function(month, year){
if (tmpCol.uniqueMonths.length < 12 && tmpCol.uniqueMonths.indexOf(month) < 0) {
tmpCol.uniqueMonths.push(month);
};
if (tmpCol.uniqueCount <= tmpCol.root.uniqueLength && tmpCol.uniqueYears.indexOf(year) < 0) {
tmpCol.uniqueYears.push(year);
tmpCol.uniqueCount++;
};
};
var _getYear = function(d){
return d.getFullYear().toString();
};
var _getMonth = function(d){
return _zeroPad(d.getMonth() + 1);
};
var _getDay = function(d){
return _zeroPad(d.getDate());
};
tmp = Date.parse(text);
if (isNaN(tmp)) {
tmpCol.dataType = "string";
tmpCol.reparse = true; // bah - bad guess
};
if (!tmpCol.reparse) {
tmp = new Date(tmp);
year = _getYear(tmp);
month = _getMonth(tmp);
day = _getDay(tmp);
_unique(month, year);
arr[0] = year + month + day;
}
else {
arr[0] = "00000000";
};
arr[1] = text;
return arr;
},
number: function(tmpCol, text){
var asc, tmp, dp, num, dec = false, arr = [];
var pad = ["0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0"];
dp = tmpCol.root.settings.decimalPlaces;
num = Number(text.replace(/[$ŁĄ€,~+]?/g, ''));
if (isNaN(num)) {
tmpCol.dataType = "string";
tmpCol.reparse = true; // bah - bad guess
};
asc = num.toFixed(dp).split(".");
if (!tmpCol.reparse) {
tmpCol.decimals = (text.indexOf(".") >= 0);
if (tmpCol.maxLen === null) {
tmpCol.maxLen = 8;
};
if (tmpCol.maxLen < asc[0].length) {
tmpCol.reparse = true;
tmpCol.maxLen = asc[0].length;
}
else
if (!tmpCol.reparse) {
// padding majik
asc[0] = pad.slice(0, tmpCol.maxLen - asc[0].length).concat(asc[0].split("")).join("");
};
if (tmpCol.uniqueCount <= tmpCol.root.uniqueLength && tmpCol.uniqueText.indexOf(text) < 0) {
tmpCol.uniqueText.push(text);
tmpCol.uniqueCount++;
};
arr[0] = asc.join(".");
arr[1] = text;
arr[2] = num;
}
else {
if (tmpCol.maxLen < asc[0].length) {
tmpCol.maxLen = asc[0].length;
};
arr[0] = 0;
arr[1] = text;
arr[2] = 0;
}
return arr;
}
},
lockColumns: function(resize){
$d.time("Lock Columns");
var col = jQuery(this.colgroup).children().get();
var tcol = 0;
var tbl = this.table;
tbl.style.tableLayout = "";
tbl.style.width = "";
for (var i = 0; i < col.length; i++) {
tcol = col[i];
tcol.style.width = "";
}
for (var i = 0; i < col.length; i++) {
tcol = col[i];
tcol.style.width = tcol.offsetWidth + "px";
}
tbl.style.width = tbl.offsetWidth + "px";
if (!this.browserSucks) {
// this.table.style.tableLayout = "fixed";
};
$d.timeEnd("Lock Columns");
},
buildColumns: function(){
$d.time("Build Headers");
var root = this;
var ccol;
var col = jQuery(this.colgroup).children();
var sRow = jQuery(this.headerRows[0]).children();
var hRow = jQuery(this.headerRows[1]).children();
jQuery.each(root.cols, function(i, v){
jQuery(col[i]).addClass("sortable-col");
if (v) {
ccol = v.buildSort(sRow[i]);
root.columnList.push(ccol.fieldName);
if ((v.dataType == "date" && v.uniqueMonths.length > 1) || (v.dataType != "date" && v.uniqueText.length > 1)) {
v.buildFilter(hRow[i]);
}
};
});
$d.timeEnd("Build Headers");
},
getDataType: function(str){
if (!isNaN(Date.parse(str))) {
return "date";
}
else
if (!isNaN(Number(str.replace(/[$ŁĄ€,~+]?/g, '')))) {
return "number";
}
else {
return "string";
};
},
getBrowserTextField: function(){
return (document.body.innerText) ? function(ele){
return ele.innerText
}
: function(ele){
return ele.textContent
};
},
clearSortList: function(){
var sl = this.sortList;
for (var c = sl.length - 1; c >= 0; c--) {
sl[c].clearSort();
sl.pop();
}
},
clearFilterList: function(){
var fl = this.filterList;
for (var c = fl.length - 1; c >= 0; c--) {
fl[c].clearFilter();
fl.pop();
}
},
filterFocus: function(e, ele){
var fl = this.filterList;
if (fl.indexOf(e.data) >= 0 && e.ctrlKey && !(ele === this.lastFilterElement && this.lastFilterEvent == "change" && e.type == "click")) {
fl.splice(fl.indexOf(e.data), 1);
e.data.clearFilter();
}
else {
this.lastFilterElement = e.target;
this.lastFilterCtrl = e.ctrlKey;
};
}
},
tfPlugins: {
date: [],
number: [],
string: []
},
addPlugin: function(constructor, dataType){
if (typeof dataType == "undefined" || dataType == "all") {
jQuery.tblFilter.tfPlugins["date"].push(constructor);
jQuery.tblFilter.tfPlugins["string"].push(constructor);
jQuery.tblFilter.tfPlugins["number"].push(constructor);
}
else {
jQuery.tblFilter.tfPlugins[dataType].push(constructor);
};
// add init methods
jQuery.extend(constructor.prototype, {
addRow: function(location, clone){
var root = this.col.root, newRow;
if (typeof location == "undefined") {
location = "footer";
};
if (typeof clone == "undefined") {
clone = "blank";
};
if (root.plugins[this.name].row) {
newRow = jQuery(root.plugins[this.name].row);
}
else {
switch (clone) {
case "blank":
newRow = root.plugins[this.name].row = jQuery(root.allRows[0][1]).clone().removeClass(root.settings.stripeClass);
break;
case "sortRow":
newRow = root.plugins[this.name].row = jQuery(root.headerRows[1]).clone();
break;
case "pageRow":
newRow = root.plugins[this.name].row = jQuery(root.headerRows[1]).clone();
break;
};
newRow.children().empty().each(function(){
var temp = $(this);
temp.text("");
});
switch (location) {
case "header":
newRow.attr("id", this.name + "_row").addClass(this.name + "_row").appendTo("thead", root.table).children().empty().end();
break;
case "footer":
var foot = $(root.table).children("tfoot");
newRow.attr("id", this.name + "_row").addClass(this.name + "_row").prependTo(foot).children().empty().end();
break;
};
};
return newRow;
},
getHeaderText: function(){
var ele = jQuery(this.col.root.headerRows[0]).children().eq(this.col.index);
return jQuery(ele).text();
},
preInit: function(){
var root = this.col.root;
this.cmi = 0;
if (typeof root.plugins[this.name] == "undefined") {
root.plugins[this.name] = {};
}
if (typeof root.plugins[this.name].bFirstRun == "undefined") {
root.plugins[this.name].bFirstRun = true;
}
},
postInit: function(){
var root = this.col.root;
this.cmi = 0;
root.plugins[this.name].bFirstRun = false;
},
getMainMenuRoot: function(){
var root = this.col.root;
if (!root.plugins[this.name].menu) {
root.plugins[this.name].menu = root.createSubMenu(this.name, root.menu.element);
}
return root.plugins[this.name].menu;
},
isFirstRun: function(){
var root = this.col.root;
return root.plugins[this.name].bFirstRun
},
addMenu: function(id, base, container, direction, trigger, inEvent, outEvent){
var root = this.col.root, ci = this.col.index;
return root.createMenu(id, base, container, direction, trigger, inEvent, outEvent);
},
addSubMenu: function(text, target){
var root = this.col.root;
return root.createSubMenu(text, target);
},
addSeparator: function(target){
var root = this.col.root;
return root.createSeparator(target);
},
addMenuItem: function(text, target, fn){
var root = this.col.root, ci = this.col.index, mi, id, smid;
smid = jQuery(target).children('ul').eq(0).attr("id");
id = smid + '_mi_' + this.cmi;
mi = jQuery('#' + id);
if (!mi.size()) {
root.createMenuItem(text, target, fn, id);
}
this.cmi++
}
});
}
});
// Column constructor
jQuery.colFilter = function(col){
jQuery.extend(this, jQuery.colFilter.defaults, col);
this.pluginList = [];
this.lastFilterVal = "";
};
jQuery.extend(jQuery.colFilter, {
defaults: {
dataType: "text", //text/date/number
filterType: "search", // search/auto
filter: true,
sort: true
},
prototype: {
sortColumn: function(e){
var sl = this.root.sortList;
var ele = this.sortParentEle;
if ((sl.indexOf(this) >= 0)) {
// column is already on the sort stack
if (e.ctrlKey) {
this.clearSort();
sl.splice(sl.indexOf(this), 1);
}
else {
var oClass = (this.sortAsc) ? "asc" : "desc";
var nClass = (!this.sortAsc) ? "asc" : "desc";
jQuery(ele).removeClass("sorted-" + oClass).addClass("sorted-" + nClass);
this.sortAsc = !this.sortAsc;
};
}
else {
// not on the stack yet
this.sortAsc = this.defaultSortAsc;
if (e == "asc" || e == "desc") {
this.sortAsc = (e == "asc") ? true : false;
}
if (sl.length && !e.ctrlKey) {
// user clicked on another column without using the ctrl key so clear the sort stack
this.root.clearSortList();
};
// add this column to the sort stack
sl.push(this);
if (this.sortAsc) {
jQuery(ele).addClass("sorted-asc");
}
else {
jQuery(ele).addClass("sorted-desc");
};
jQuery(this.parentCol).addClass("sorted-col");
};
$d.time("Total sort time");
if (sl.length) {
this.root.sortTable(e);
};
$d.timeEnd("Total sort time");
$d.log(" ");
},
clearSort: function(){
var tClass = (this.sortAsc) ? "asc" : "desc";
jQuery(this.sortParentEle).removeClass("sorted-" + tClass);
jQuery(this.parentCol).removeClass("sorted-col");
this.sortAsc = this.defaultSortAsc;
},
buildSort: function(ele){
this.sortParentEle = ele;
this.parentCol = jQuery(this.root.colgroup).children()[this.index];
this.fieldName = jQuery(ele).text();
this.fieldType = (typeof this.root.colSettings[this.index] != "undefined" && this.root.colSettings[this.index].fieldType) ? this.root.colSettings[this.index].fieldType : this.cDataType;
jQuery(ele).addClass("sortable").css("cursor", "pointer").bind("click", this, function(e){
e.data.sortColumn(e, this);
});
return this;
},
filterColumn: function(e){
var fl = this.root.filterList;
var ff = this.filterField;
var svl = (ff.length > 1) ? ff[0].value.length + ff[1].value.length : ff[0].value.length;
var col = this;
var _numCheck = function(){
var ffv = ff[0].value;
if (col.dataType == "number") {
if (!ffv.match(/(^[\.><=-])(\d+)/) && !ffv.match(/(^[><]=)(\d*\.*\d+)/) && !ffv.match(/(\d*\.*\d+)\s*-\s*(\d*\.*\d+)/) && !ffv.match(/(^\d*\.*\d+$)/)) {
return false;
};
};
return true;
};
if (e.type != "keyup" || (e.type == "keyup" && !ff[0].value.length) || (e.type == "keyup" && ff[0].value != this.lastFilterVal && _numCheck())) {
if (fl.indexOf(this) < 0 && svl) {
if (fl.length && this.root.lastFilterElement == e.target && !this.root.lastFilterCtrl && !(e.type == "keyup" && (e.ctrlKey || e.shiftKey || e.altKey))) {
// $.log(fl.length,(this.root.lastFilterElement == e.target), !this.root.lastFilterCtrl,!(e.type == "keyup" && (e.ctrlKey || e.shiftKey || e.altKey)));
this.root.clearFilterList();
};
fl.push(this);
jQuery(this.filterParentEle).addClass("filtered");
}
else
if ((!svl && fl.indexOf(this) >= 0)) {
fl.splice(fl.indexOf(this), 1);
this.clearFilter();
};
this.lastFilterVal = ff[0].value;
this.root.currentPage = 1;
// get a new filter for the current value
this.cFilter = this.getFilter();
$d.time("Total filter time");
this.root.filterTable("filter");
$d.timeEnd("Total filter time");
$d.log(" ");
}
},
clearFilter: function(){
jQuery(this.filterParentEle).removeClass("filtered");
jQuery(this.filterField).val("").trigger("change");
this.root.lastFilterCtrl = false;
this.root.lastFilterElement = null;
},
getFilter: function(){
switch (this.dataType) {
case "string":
return function(arg){
return (arg[0].length) ? (arg[0].indexOf(this.filterField[0].value.toLowerCase().replace(/[^\w]*/g, "")) >= 0) : false;
};
break;
case "date":
return function(arg){
var ff, ffml, ffyl, m, y;
if (arg[0] === null || !arg[0].length) {
return false;
}
else {
ff = this.filterField;
ffml = ff[0].value.length;
ffyl = ff[1].value.length;
m = (ffml && ff[0].value == arg[0].substr(4, 2));
y = (ffyl && ff[1].value == arg[0].substr(0, 4));
return ((ffml && ffyl && m & y) || (!ffyl && ffml && m) || (!ffml && ffyl && y));
};
};
break;
case "number":
var ffv = this.filterField[0].value;
var re;
//match: < or > + digits
if (ffv.match(/(^[><])(\d*\.*\d+)/)) {
re = /(^[><])(\d*\.*\d+)/.exec(ffv);
return function(arg){
var v = arg[2];
return (arg[0].length) ? ((re[1] == ">") ? (v > re[2]) : (v < re[2])) : false;
};
//match: <= or >= + digits
}
else
if (ffv.match(/(^[><]=)(\d*\.*\d+)/)) {
re = /(^[><]=)(\d*\.*\d+)/.exec(ffv);
return function(arg){
var v = arg[2];
return (arg[0].length) ? ((re[1] == ">=") ? (v >= re[2]) : (v <= re[2])) : false;
};
//match: digits-digits (range)
}
else
if (ffv.match(/(\d*\.*\d+)\s*-\s*(\d*\.*\d+)/)) {
re = /(\d*\.*\d+)\s*-\s*(\d*\.*\d+)/.exec(ffv);
return function(arg){
var v = arg[2];
return (arg[0].length) ? (v > re[1] && v < re[2]) : false;
};
//match: =digits
}
else
if (ffv.match(/(^=)(\d*\.*\d+)/)) {
re = /(^=)(\d*\.*\d+)/.exec(ffv);
return function(arg){
var v = arg[2];
return (arg[0].length) ? (v == re[2]) : false;
};
}
else {
return function(arg){
return (arg[0].length) ? (arg[1].indexOf(this.filterField[0].value) >= 0) : false;
};
}
;
break;
};
},
buildFilter: function(ele){
var tmp;
this.filterParentEle = ele;
this.filterField = [];
jQuery(ele).addClass("filterRow");
switch (this.dataType) {
case "string":
if (this.uniqueText.length <= this.root.uniqueLength) {
this.addField(ele, "select", this.uniqueText);
}
else {
this.addField(ele, "text");
}
;
break;
case "date":
// this.addField(ele,"text");
this.addField(ele, "select", this.uniqueMonths);
this.addField(ele, "select", this.uniqueYears);
break;
case "number":
if (this.uniqueText.length <= this.root.uniqueLength) {
this.addField(ele, "select", this.uniqueText);
}
else {
this.addField(ele, "text", null, true);
}
;
break;
};
},
addField: function(target, type, options, numeric){
options = options || [];
type = type || "text";
numeric = numeric || false;
var len, tmp, opt, fld = {
text: '',
select: document.createElement('select'), //document.createElement('select')
option: ''
};
switch (type) {
case "text":
len = (this.maxLen > 20) ? "20" : this.maxLen;
tmp = jQuery(fld.text);
tmp = tmp.attr("size", len).appendTo(target).addClass("filter").bind("keyup", this, function(e){
e.data.filterColumn(e, this);
}).bind("click", this, function(e){
e.data.root.filterFocus(e, this);
});
if (numeric) {
tmp.bind("keypress", this, function(e){
var v = this.value;
var c = e.charCode || e.keyCode;
var t = 0;
// . == 46
var _isN = function(k){
k = k || c;
var tmp = ((k >= 48 && k <= 57) || k === 46) ? true : false;
return tmp;
};
var _isS = function(k){
k = k || c;
var tmp = (k === 45 || k === 60 || k === 61 || k === 62) ? true : false;
return tmp;
};
var _isD = function(k){
k = k || c;
var tmp = (k === 8 || k === 46) ? true : false;
return tmp;
};
switch (v.length) {
case 0:
if (!_isN(c) && !_isS(c)) {
return false;
}
;
break;
case 1:
t = v.charCodeAt(0);
if ((t === 60 || t === 62) && c !== 61 && !_isN(c) && !_isD(c)) {
return false;
}
else
if ((t === 45 || t === 61) && !_isN(c) && !_isD(c)) {
return false;
}
else
if (!_isN(c) && !_isD(c) && c !== 61 && c !== 45) {
return false;
}
else
if (c == 46 && v.indexOf(".") >= 0) {
return false;
}
;
break;
default:
var rng = v.match(/([<>=-])/g);
if (!_isN() && !_isD(c) && c !== 45 || (c === 45 && rng)) {
return false;
}
;
break;
};
});
}
;
break;
case "select":
tmp = jQuery(fld.select).appendTo(target).addClass("filter");
opt = fld.option;
for (var i = 0; i < options.length; i++) {
opt += ''
}
;
jQuery(tmp).append(opt);
tmp.bind("change", this, function(e){
e.data.root.lastFilterEvent = e.type;
e.data.filterColumn(e, this);
}).bind("click", this, function(e){
e.data.root.filterFocus(e, this);
}).val("");
$(target).attr("nowrap", "nowrap");
break;
};
this.filterField.push(tmp[0]);
},
initPlugins: function(){
var fp = this.pluginList;
for (var i = 0; i < fp.length; i++) {
$d.time("Plugin init: " + fp[i].name + " column " + fp[i].col.index);
fp[i].preInit();
fp[i].init();
fp[i].postInit();
$d.timeEnd("Plugin init: " + fp[i].name + " column " + fp[i].col.index);
};
},
startPlugins: function(f, p, s){
var fp = this.pluginList;
for (var i = 0; i < fp.length; i++) {
fp[i].start(f, p, s);
};
},
processPlugins: function(r, v, p, a){
var fp = this.pluginList;
for (var i = 0; i < fp.length; i++) {
fp[i].process(r, v, p, a);
};
},
finishPlugins: function(){
var fp = this.pluginList;
for (var i = 0; i < fp.length; i++) {
fp[i].finish();
};
}
}
});