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

// here we have a function for generic (schools) tables - headers are row[0]
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
    for (var i=0;i<firstRow.cells.length;i++) {
        var cell = firstRow.cells[i];
        var txt = ts_getInnerText(cell);
        var newtxt = ts_getInnerText(cell);
        var term_id = 0;
        var term_diff = 0;
        var term_se = 0;
        var term_signif = 0;
        var doit = 1;
//        var maplink = 0;
        // edit to change how the spanner looks
        // we have to add definition link here, not in table template
        // indexOf will return 0 if term starts in first position
        if   ( txt.indexOf("ID") >= 0 ) { 
            term_id = 1;
        }
        if   ( txt.indexOf("Difference") >= 0 && txt.indexOf("Standard") < 0 ) { 
            term_diff = 1;
        }
        if   ( txt.indexOf("Standard Error") >= 0 ) { 
            term_se = 1;
        }
        if   ( txt.indexOf("Significant") >= 0 ) { 
            term_signif = 1;
        }
        if   ( term_id ) { 
            newtxt = '<a href="/did/www/saipe/methods/saipeterms.html#ID" target="_term_id">'+txt+'</a>';
        }
        if   ( term_diff ) { 
            newtxt = '<a href="/did/www/saipe/methods/saipeterms.html#differenceestimate" target="_term_diff">'+txt+'</a>';
        }
        if   ( term_se ) { 
            newtxt = '<a href="/did/www/saipe/methods/saipeterms.html#seofdiffest" target="_term_se">'+txt+'</a>';
        }
        if   ( term_signif ) { 
            newtxt = '<a href="/did/www/saipe/methods/saipeterms.html#diffcheck" target="_term_signif">'+txt+'</a>';
        }
        // for map column only, link to a different page than saipeterms
//      if   ( txt.indexOf("Map") >= 0 ) {
//          maplink = 1;
//      }
//      if   ( maplink ) {
//          tmplnk = "javascript:openMapInfoWin('/did/www/saipe/data/statecounty/maps/mapinfo.html')";
//          newtxt = '<a href="'+tmplnk+'">'+txt+'</a>';
//      }
              
        // DO not allow sorting on the CI indexOf is like a substr()
//        if ( txt.indexOf("Interval") > 0 || txt.indexOf("Grade") >= 0 || txt.indexOf("Map") >= 0 ) { doit = 0; };  
        if ( txt.indexOf("State 1") >= 0 || txt.indexOf("State Estimate 1") >= 0 ) { doit = 0; };  
        if ( doit ) { 
            cell.innerHTML = '<a href="#" title="Sort" class="sortheader" onclick="ts_resortTable(this);return false;"><span class="sortarrow"><img alt="Sort this column" src="/did/www/saipe/img/uparrow.gif" border="0"></span></a> '+newtxt;
        }
        else {
            cell.innerHTML = newtxt;
        }
    }
}

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) {
    // 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 = td.cellIndex;
    var table = getParent(td,'TABLE');
    
    // Work out a type for the column
    if (table.rows.length <= 1) return;

    var itm = ts_getInnerText(table.rows[1].cells[column]);
    // sortfn = ts_sort_caseinsensitive;
    sortfn = ts_sort_numeric;
    if (itm.match(/^[\d\,]+/)) sortfn = ts_sort_numeric;
    if (itm.match(/^[A-z]+/)) sortfn = ts_sort_caseinsensitive;
    // If sort is numeric, IE handles the NA cases.
    if (itm.match(/\bNA\b/)) sortfn = ts_sort_numeric;
    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=1;j<table.rows.length;j++) { newRows[j-1] = table.rows[j]; }

    newRows.sort(sortfn);

    // if sorted at all, show a downward arrow, else show up arrow for unsorted row
    if (span.getAttribute("sortdir") == 'down') {
        ARROW = '<img src="/did/www/saipe/img/downarrow.gif" alt="Sort in reverse order" border="0">';
        newRows.reverse();
        span.setAttribute('sortdir','up');
    } else {
        ARROW = '<img alt="Sort in reverse order" src="/did/www/saipe/img/downarrow.gif" border="0">';
        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 = '<img border="0" src="/did/www/saipe/img/uparrow.gif" alt="Sort this column">';
            }
        }
    }
        
    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 ts_sort_numeric(a,b) { 
    // to deal with commas, bag them first and sort on unformatted numbers
    // av = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
    aa = parseFloat(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).replace(/,/g,''));
    if (isNaN(aa)) aa = 0;  
    // isNotaNumber 
    // if (av.match(/^[A-z]+/)) aa= 1000000;
    // bv = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
    bb = parseFloat(ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).replace(/,/g,'')); 
    // if (bv.match(/^[A-z]+/)) bb= 1000000;
    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");
  }
} 

function openMapInfoWin(lnk) {
     var newWin = window.open(lnk,"_mapinfo","menubar=yes,scrollbars=yes,toolbar=yes,resizable=yes,top=20,left=20,width=1000,height=400");
     newWin.focus();
}