/**************************************************************
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.getElements('tr');
        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);
                });
            }           
        }, 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';
                    }
                    if ( ret=str.match(/day$/)){                    
                        switch (str.toLowerCase()){
                            default:
                            case 'monday':    return 999999990001; break;
                            case 'tuesday':   return 999999990002; break;
                            case 'wednesday': return 999999990003; break;
                            case 'thursday':  return 999999990004; break;
                            case 'friday':    return 999999990005; break;
                            case 'saturday':  return 999999990006; break;
                            case 'sunday':    return 999999990007; break;
                        }
                    }
                    // HH
                    if ( ret=str.match(/^\d{1,2}$/) ){                    
                        return 999999990000 + ret[0]*100;
                    }
                    
                    // DD MMM YYYY
                    if (str.match(/(\d{1,2}) ([a-z]{3}) (\d{2,4})/i)) {                    	 
                    	return new Date(str).getTime();
                    }
                    
                    // YYYY(-| )MM(-| )DD HH:ii:ss
                    if (str.match(/\d{2,4}[- ]\d{2}[- ]\d{2} \d{2}:\d{2}:\d{2}/i) ) {                    	       
                    	str = str.replace(/(\/|-)/ig, "/");                    	                    	
                    	return new Date(str).getTime();
                    }
                    
                    // YYYY[-MM[-DD]]
                    if (ret=str.match(/(\d{2,4})(-(\d{1,2})(-(\d{1,2}))?)?/)) {                    
                        var tmp = (fixYear(ret[1])*10000);
                        if ( ret[3] ){
                            tmp += (ret[3]*100);
                        }
                        if ( ret[5] ){
                            tmp += (+ret[5]);
                        }
                        return tmp + strtime;//+ (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.replace(/,/g,''));
                        var2 = parseFloat(var2.replace(/,/g,''));                        

                        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(/,/g,''));
                        var2 = parseFloat(var2.substr(1).replace(/,/g,''));

                        if(el.sortBy == 'ASC'){
                            return var1-var2;
                        }else{
                            return var2-var1;
                        }
                    }
                };
                if(i == this.options.sortOn){
                    el.fireEvent('click');
                }
            }
        }, this);
        this.altRow.delay(500,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');
            }
        });

        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('altRow');
            }else{
                el.addClass('altRow');
            }
        });
    },

    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);

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