/**************************************************************

	Script		: Sortable Table
	Version		: 1.4
	Authors		: Samuel Birch
	Desc			: Sorts and filters table elements
	Licence		: Open Source MIT Licence

**************************************************************/

var sortableTable = new Class({
							  
	getOptions: function() {
		return {
			overCls: false,
			onClick: false,
			sortOn: 0,
			sortBy: 'ASC',
			filterHide: true,
			filterHideCls: 'hide',
			filterSelectedCls: 'selected'
		};
	},

	initialize: function(table, options) {
		this.setOptions(this.getOptions(), options);
		this.table = $(table);
		this.tHead = this.table.getElement('thead');
		this.tBody = this.table.getElement('tbody');
		this.tFoot = this.table.getElement('tfoot');
		
		this.elements = this.tBody.getChildren();
		this.filtered = false;
		
		this.elements.each(function(el,i) {
			if (this.options.overCls) {
				el.addEvent('mouseover', function() {
					el.addClass(options.overCls);
				}, this);
				el.addEvent('mouseout', function() {
					el.removeClass(options.overCls);
				});
			}
			if (this.options.onClick) {
				el.addEvent('click', options.onClick);
			}
		}, this);
		
		//setup header
		this.tHead.getElements('th').each(function(el,i) {
			if (el.axis) {
				el.addEvent('click', this.sort.bind(this,i));
				el.addEvent('mouseover', function() {
					el.addClass('tableHeaderOver');
				});
				el.addEvent('mouseout', function() {
					el.removeClass('tableHeaderOver');
				});
				el.getdate = function(str) {
					// inner util function to convert 2-digit years to 4
					function fixYear(yr) {
						yr = +yr;
						if (yr < 50) { 
						    yr += 2000; 
					    } else if (yr < 100) {
					        yr += 1900; 
				        }
						return yr;
					};
					var ret;
					if (str.length > 12) {
						strtime = str.substring(str.lastIndexOf(' ') + 1);
						strtime = strtime.substring(0, 2) + strtime.substr(-2);
					} else {
						strtime = '0000';
					}
					// YYYY-MM-DD
					if (ret = str.match(/(\d{2,4})-(\d{1,2})-(\d{1,2})/)) {
						return (fixYear(ret[1])*10000) + (ret[2]*100) + (+ret[3]) + strtime;
					}
					// DD/MM/YY[YY] or DD-MM-YY[YY]
					if (ret = str.match(/(\d{1,2})[\/-](\d{1,2})[\/-](\d{2,4})/)) {
						return (fixYear(ret[3])*10000) + (ret[2]*100) + (+ret[1]) + strtime;
					}
					return 999999990000; // So non-parsed dates will be last, not first
				};
				el.findData = function(elem) {
					var child = elem.getFirst();
					if (child) {
						return el.findData(child);
					} else {
						return elem.innerHTML.trim();
					}
				};
				el.compare = function(a,b) {
					var1 = el.findData(a.getChildren()[i]);
					var2 = el.findData(b.getChildren()[i]);
					
					if (el.axis == 'number') {
						var1 = parseFloat(var1);
						var2 = parseFloat(var2);
						
						if (el.sortBy == 'ASC') {
							return var1 - var2;
						} else {
							return var2 - var1;
						}
					} else if (el.axis == 'string') {
						var1 = var1.toUpperCase();
						var2 = var2.toUpperCase();
						
						if (var1 == var2) {
						    return 0;
					    }
						if (el.sortBy == 'ASC') {
							if (var1 < var2) {
							    return -1;
						    }
						} else {
							if (var1 > var2) {
							    return -1;
						    }
						}
						return 1;
					} else if (el.axis == 'date') {
						var1 = parseFloat(el.getdate(var1));
						var2 = parseFloat(el.getdate(var2));
						
						if (el.sortBy == 'ASC') {
							return var1 - var2;
						} else {
							return var2 - var1;
						}
					} else if (el.axis == 'currency') {
						var1 = parseFloat(var1.substr(1).replace(',',''));
						var2 = parseFloat(var2.substr(1).replace(',',''));
						
						if (el.sortBy == 'ASC') {
							return var1-var2;
						} else {
							return var2-var1;
						}
					}
				};
				if (i == this.options.sortOn) {
					el.fireEvent('click');
				}
			}
		}, this);
	},
	
	sort: function(index) {
		if (this.options.onStart) {
			this.fireEvent('onStart');
		}
		this.options.sortOn = index;
		var header = this.tHead.getElements('th');
		var el = header[index];
		
		header.each(function(e,i) {
			if (i != index) {
				e.removeClass('sortedASC');
				e.removeClass('sortedDESC');
				e.addClass('sortedNo');
			} else {
			    e.removeClass('sortedNo');
			}
		});
		
		if (el.hasClass('sortedASC')) {
			el.removeClass('sortedASC');
			el.addClass('sortedDESC');
			el.sortBy = 'DESC';
		} else if (el.hasClass('sortedDESC')) {
			el.removeClass('sortedDESC');
			el.addClass('sortedASC');
			el.sortBy = 'ASC';
		} else {
			if (this.options.sortBy == 'ASC') {
				el.addClass('sortedASC');
				el.sortBy = 'ASC';
			} else if (this.options.sortBy == 'DESC') {
				el.addClass('sortedDESC');
				el.sortBy = 'DESC';
			}
		}
		this.elements.sort(el.compare);
		this.elements.injectInside(this.tBody);
		if (this.filtered) {
			this.filteredAltRow();
		} else {
			this.altRow();
		}
		
		if (this.options.onComplete) {
			this.fireEvent('onComplete');
		}
	},
	
	altRow: function() {
		this.elements.each(function(el,i) {
			if (i % 2) {
				el.removeClass('dark');
				el.addClass('light');
			} else {
				el.removeClass('light');
				el.addClass('dark');
			}
		});
	},
	
	filteredAltRow: function() {
		this.table.getElements('.'+this.options.filterSelectedCls).each(function(el,i) {
			if (i % 2) {
				el.removeClass('altRow');
			} else {
				el.addClass('altRow');
			}
		});
	},
	
	filter: function(form) {
		var form = $(form);
		var col = 0;
		var key = '';
		
		form.getChildren().each(function(el,i) {
			if (el.id == 'column') {
				col = Number(el.value);
			}
			if (el.id == 'keyword') {
				key = el.value.toLowerCase();
			}
			if (el.type == 'reset') {
				el.addEvent('click',this.clearFilter.bind(this));
			}
		}, this);
		
		if (key) {
    		this.elements.each(function(el,i) {
    			if (this.options.filterHide) {
    				el.removeClass('altRow');
    			}
    			if (el.getChildren()[col].firstChild.data.toLowerCase().indexOf(key) > -1) {
    				el.addClass(this.options.filterSelectedCls);
    				if (this.options.filterHide) {
    					el.removeClass(this.options.filterHideCls);
    				}
    			} else {
    				el.removeClass(this.options.filterSelectedCls);
    				if (this.options.filterHide) {
    					el.addClass(this.options.filterHideCls);
    				}
    			}
    		}, this);
    		if (this.options.filterHide) {
    			this.filteredAltRow();
    			this.filtered = true;
    		}
		}
	},
	
	clearFilter: function() {
		this.elements.each(function(el,i) {
			el.removeClass(this.options.filterSelectedCls);
			if (this.options.filterHide) {
				el.removeClass(this.options.filterHideCls);
			}
		}, this);
		if (this.options.filterHide) {
			this.altRow();
			this.filtered = false;
		}
	}
});

sortableTable.implement(new Events);
sortableTable.implement(new Options);