addEvent(window, "load", sortables_init);
var SORT_COLUMN_INDEX;

function sortables_init() {
    // Find all tables with class sortable and make them sortable
    if (!document.getElementsByTagName) return;
    tbls = document.getElementsByTagName("table");
    for (ti=0;ti<tbls.length;ti++) {
        thisTbl = tbls[ti];
        if (((' '+thisTbl.className+' ').indexOf("sortable") != -1) && (thisTbl.id)) {
            //initTable(thisTbl.id);
            ts_makeSortable(thisTbl);
        }
    }            
}

function ts_makeSortable(table) {
    if (table.rows && table.rows.length > 0) {
        var firstRow = table.rows[0];
    }
    if (!firstRow) return;
    
    // We have a first row: assume it's the header, and make its contents clickable links
    
    var start = (table.id == 'tbl_myaccount') ? 1 : 0;
    
    for (var i=start;i<firstRow.cells.length;i++) {
        var cell = firstRow.cells[i];
        if(cell.className != 'ignoresort') {
          var txt = ts_getInnerText(cell);
          cell.innerHTML = '<a href="#" class="sortheader" '+ 
          'onclick="ts_resortTable(this, '+i+');return false;">' + 
          txt+'<span class="sortarrow"></span></a>';
        }
    }
    
    // if table sort preselected display arrow
    var sorted = document.getElementById('sorted');
    if(sorted) {
	    var lnk = sorted.getElementsByTagName('a');
	    lnk = lnk[0];    
	    ts_resortTable(lnk);
    }
}

function ts_getInnerText(el) {
	if (typeof el == "string") return el;
	if (typeof el == "undefined") { return el };
	if (el.innerText) return el.innerText;	//Not needed but it is faster
	var str = "";
	
	var cs = el.childNodes;
	var l = cs.length;
	for (var i = 0; i < l; i++) {
		switch (cs[i].nodeType) {
			case 1: //ELEMENT_NODE
				str += ts_getInnerText(cs[i]);
				break;
			case 3:	//TEXT_NODE
				str += cs[i].nodeValue;
				break;
		}
	}
	return str;
}

function ts_resortTable(lnk,clid) {
    // get the span
    var span;
    for (var ci=0;ci<lnk.childNodes.length;ci++) {
        if (lnk.childNodes[ci].tagName && lnk.childNodes[ci].tagName.toLowerCase() == 'span') span = lnk.childNodes[ci];
    }
    var spantext = ts_getInnerText(span);
    var td = lnk.parentNode;
    var column = clid || td.cellIndex;
    var table = getParent(td,'TABLE');
    
    // Work out a type for the column
    if (table.rows.length <= 1) return;
		// Check if row className is 'ignoreSort'
		// Get the first of the actual DATA rows
		startDataRow = 1;
		while(table.rows[startDataRow].className.indexOf('ignoreSort') > -1) {
			startDataRow++;
		}

    var itm = ts_getInnerText(table.rows[startDataRow].cells[column]);
    sortfn = ts_sort_caseinsensitive;
    if (itm.match(/^\d\d[\/-]\d\d[\/-]\d\d\d\d$/)) sortfn = ts_sort_date;
    if (itm.match(/^\d\d[\/-]\d\d[\/-]\d\d$/)) sortfn = ts_sort_date; 
    if (itm.match(/^\d\d\s[A-Za-z]{3}\s\d\d\d\d\s\d\d:\d\d$/)) sortfn = ts_sort_date; // added RS:20070711       
    if (itm.match(/^\d\d[\/-]\d\d\d\d$/)) sortfn = ts_sort_date; // added RS:20070711    
    if (itm.match(/^[�$]/)) sortfn = ts_sort_currency;
    if (itm.match(/^[\d\.]+$/)) sortfn = ts_sort_numeric;
		
	// What if the FIRST column contains NO data, but others do? -> Use the column heading to work this out
	if (ts_getInnerText(table.rows[0].cells[column]).indexOf("Date") > -1) { sortfn = ts_sort_date;} // DATE (added MF:20080220)    
		
    SORT_COLUMN_INDEX = column;
    var firstRow = new Array();
    var newRows = new Array();
    for (i=0;i<table.rows[0].length;i++) { firstRow[i] = table.rows[0][i]; }
    for (j=startDataRow;j<table.rows.length;j++) { newRows[j-startDataRow] = table.rows[j]; }
	
	newRows.sort(sortfn);
						
    if (span.getAttribute("sortdir") == 'down') {
        ARROW = '<img src="/gfx/myaccount/sort-descending.gif" alt="" title="Sort data"/>';
        newRows.reverse();
		span.setAttribute('sortdir','up');        				
    } else {
        ARROW = '<img src="/gfx/myaccount/sort-ascending.gif" alt="" title="Sort data"/>';
        span.setAttribute('sortdir','down');
    }
  
    // We appendChild rows that already exist to the tbody, so it moves them rather than creating new ones
    // don't do sortbottom rows
    for (i=0;i<newRows.length;i++) { if (!newRows[i].className || (newRows[i].className && (newRows[i].className.indexOf('sortbottom') == -1))) table.tBodies[0].appendChild(newRows[i]); }
    // do sortbottom rows only
    for (i=0;i<newRows.length;i++) { if (newRows[i].className && (newRows[i].className.indexOf('sortbottom') != -1)) table.tBodies[0].appendChild(newRows[i]);}
    
    // Delete any other arrows there may be showing
    var allspans = document.getElementsByTagName("span");
    for (var ci=0;ci<allspans.length;ci++) {
        if (allspans[ci].className == 'sortarrow') {
            if (getParent(allspans[ci],"table") == getParent(lnk,"table")) { // in the same table as us?
                allspans[ci].innerHTML = '&nbsp;&nbsp;';
            }
        }
    }
        
    span.innerHTML = ARROW;
}

function getParent(el, pTagName) {
	if (el == null) return null;
	else if (el.nodeType == 1 && el.tagName.toLowerCase() == pTagName.toLowerCase())	// Gecko bug, supposed to be uppercase
		return el;
	else
		return getParent(el.parentNode, pTagName);
}

function getMMfromMMM(mmm) { // added RS:20070711
  switch(mmm) {
    case "Jan": return '01'; break;
    case "Feb": return '02'; break;
    case "Mar": return '03'; break;
    case "Apr": return '04'; break;
    case "May": return '05'; break;
    case "Jun": return '06'; break;
    case "Jul": return '07'; break;
    case "Aug": return '08'; break;
    case "Sep": return '09'; break;
    case "Oct": return '10'; break;
    case "Nov": return '11'; break;
    case "Dec": return '12'; break;
  }
}

function ts_sort_date(a,b) {
    // y2k notes: two digit years less than 50 are treated as 20XX, greater than 50 are treated as 19XX
    aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
    bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);
		
    if (aa.length == 10) {
        dt1 = aa.substr(6,4)+aa.substr(3,2)+aa.substr(0,2);
    } else if(aa.length == 17) { // added RS:20070711
        dt1 = aa.substr(7,4)+getMMfromMMM(aa.substr(3,3))+aa.substr(0,2)+aa.substr(12,2)+aa.substr(15,2);
    } else if(aa.length == 7) { // added RS:20070711
        dt1 = aa.substr(3,4)+aa.substr(0,2);
    } else {
        yr = aa.substr(6,2);
        if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }
        dt1 = yr+aa.substr(3,2)+aa.substr(0,2);
    }
    
    if (bb.length == 10) {
        dt2 = bb.substr(6,4)+bb.substr(3,2)+bb.substr(0,2);
    } else if(bb.length == 17) { // added RS:20070711
        dt2 = bb.substr(7,4)+getMMfromMMM(bb.substr(3,3))+bb.substr(0,2)+bb.substr(12,2)+bb.substr(15,2);
    } else if(bb.length == 7) { // added RS:20070711
        dt2 = bb.substr(3,4)+bb.substr(0,2);
    } else {
        yr = bb.substr(6,2);
        if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }
        dt2 = yr+bb.substr(3,2)+bb.substr(0,2);
    }
    
    if (dt1==dt2) return 0;
    if (dt1<dt2) return -1;
    return 1;
}

function ts_sort_currency(a,b) { 
    aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g,'');
    bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g,'');
    return parseFloat(aa) - parseFloat(bb);
}

function ts_sort_numeric(a,b) { 
    aa = parseFloat(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]));
    if (isNaN(aa)) aa = 0;
    bb = parseFloat(ts_getInnerText(b.cells[SORT_COLUMN_INDEX])); 
    if (isNaN(bb)) bb = 0;
    return aa-bb;
}

function ts_sort_caseinsensitive(a,b) {
    aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).toLowerCase();
    bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).toLowerCase();
    if (aa==bb) return 0;
    if (aa<bb) return -1;
    return 1;
}

function ts_sort_default(a,b) {
    aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
    bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);
    if (aa==bb) return 0;
    if (aa<bb) return -1;
    return 1;
}


function addEvent(elm, evType, fn, useCapture)
// addEvent and removeEvent
// cross-browser event handling for IE5+,  NS6 and Mozilla
// By Scott Andrew
{
  if (elm.addEventListener){
    elm.addEventListener(evType, fn, useCapture);
    return true;
  } else if (elm.attachEvent){
    var r = elm.attachEvent("on"+evType, fn);
    return r;
  } else {
    alert("Handler could not be removed");
  }
} 

/**
 * Generate a CVS spreadsheet from a table  object
 * @author Richard Snazell (Modified by Matt Fellows)
 * @param {String} tableID - The id of the table to convert
 * @param {Array} skipcols - Optional. An array of column indexes to skip
 * @param {Array} skiprows - Optional. An array of row indexes to skip * 
 * @param {Array} outputVisible - Optional. If true will only export rows that are visible
 */
function generate_csv(tableID, skipcols, skiprows, outputVisible) {
  var output = '';
  var trs = document.getElementById(tableID).getElementsByTagName('tr');  
  
  for(i=0; i < trs.length; i++) { // loop each table row
		if(in_array(i, skiprows)) {}  // do nothing
		else if(outputVisible && trs[i].style.display == 'none') {}  // do nothing
		else {
	    var tds = (trs[i].getElementsByTagName("th").length != 0) ? trs[i].getElementsByTagName("th") : trs[i].getElementsByTagName("td");
	    for(j=0; j < tds.length; j++) { // loop each table cell
	      if(in_array(j, skipcols)) { 
					/* skip data */
				}
				else {
	        output += strip_tags(tds[j].innerHTML); 
	      }
				output += (j == (tds.length - 1)) ? '<br/>' : ',';								
	    }					
		}
  }

 var handle = window.open('','csv_output','');
  handle.document.writeln("<html><head><title>Download .CSV</title></head><body>" + output + "</body></html>");
  handle.document.close();
  return true;  
}

/**
 * Check if an item exists in an array
 * @param {Object} needle
 * @param {Object} haystack
 */
function in_array(needle, haystack) {
	if(haystack) {
	  for(var i=0; i < haystack.length; i++) {
	    if(haystack[i] == needle) { return true; }
	  }		
	}

  return false;
}
function strip_tags(str){ return str.replace(/<\/?[^>]+>/gi, ""); }