webdivane / table

add/table.js

var strAsc = String.fromCharCode(9650); //▲
var strDesc = String.fromCharCode(9660);//▼
var xmlhttp;
var d;

var table = new function () {
    this.rq = null;
    this.tail = [];

    this.ReloadData = function (tableId) {
        var request = {};
        this.BuildRequest(request, tableId);
        this.LoadData(tableId, request);
    };

    this.BuildRequest = function (request, crntTableId, skipPropertyArray) {
        this.rq = request;
        this.checkSkip = function (skipProperty) {
            var result = false;
            if (skipPropertyArray && Object.prototype
                    .toString.call(skipPropertyArray) === '[object Array]') {
                if (skipPropertyArray.indexOf(skipProperty) >= 0) {
                    result = true;
                }
            }
            return result;
        };
        this.getSort = function () {
            var table = document.getElementById(crntTableId);
            var thTags = table.getElementsByTagName("thead")[0]
                    .getElementsByTagName("th");
            for (var i = 0; i < thTags.length; i++) {
                if (thTags[i].getElementsByTagName("a")[0] && thTags[i]
                        .getElementsByTagName("a")[0].getElementsByTagName("span")
                        .length === 1
                        ) {
                    var order = thTags[i].getElementsByTagName("a")[0]
                            .getElementsByTagName("span")[0].innerHTML;
                    if (order.length === 1) {
                        this.rq.colNo = i;
                        this.rq.colOrd = (order === window.strDesc) ?
                                "desc" : "asc";
                    }
                }
            }
        };
        this.getFilter = function () {
            var r = this.getFilterFieldsByTbaleID(crntTableId);
            if (r.filter !== null) {
                this.rq.filter = r.filter;
            }
            if (r.filterBy !== null) {
                this.rq.filterBy = r.filterBy;
            }
        };

        /* Build request object */
        if (!this.checkSkip("sort")) {
            this.getSort();
        }
        if (!this.checkSkip("filter")) {
            this.getFilter();
        }

        this.rq.tableId = crntTableId;
        return this.rq;
    };

    this.RequestToUrl = function (rq) {
        var url = location.pathname + ".json" + location.search;
        if (typeof rq === "object") {
            var getUrlVarName = {
                colNo: "col", colOrd: "ord", filter: "filter",
                filterBy: "filter-by", pageNo: "pg", exportType: "export",
                tableId: "table-id"
            };
            var flagFirst = location.search.length < 1 ? true : false;
            for (var r in rq) {

A for in loop automatically includes the property of any prototype object, consider checking the key using hasOwnProperty.

                var clue = flagFirst === true ? "?" : "&";
                url += clue + getUrlVarName[r] + "=" + rq[r];
                flagFirst = false;
            }
        }
        return url;
    };

    this.Filter = function (field) {
        var crntTableId = this.FilterGetTableId(field);
        if (crntTableId !== null) {
            var request = {};
            var exRq = this.rq;
            this.BuildRequest(request, crntTableId);
            if (exRq === null ||
                request.filter !== exRq.filter ||
                request.filterBy !== exRq.filterBy
            ) {
                this.LoadData(crntTableId, request);
            }
        }
    };

    this.FilterGetTableId = function (field) {
        if (field.tagName.toLowerCase() !== "select") {
            return field.getAttribute("data-table-id");
        } else {
            var f = field.parentNode.parentNode.getElementsByTagName("input")[0];
            return '' === f.value ? null : f.getAttribute("data-table-id");
        }
    };

    this.GoPage = function (lnk) {
        var request = {};
        var table = this.getParent(lnk, "table");
        var crntTableId = table.getAttribute("id");
        this.BuildRequest(request, crntTableId);
        //check & serve pagination jump links
        var jumpDir = lnk.innerHTML.trim().substr(0, 1);
        if (jumpDir === "+" || jumpDir === "-") {
            var current = table.querySelector("tfoot .paging .a").innerHTML;
            var jump = lnk.innerHTML.replace("K", "000").replace("M", "000000000");
            var jumpPage = (parseInt(current) + parseInt(jump));
            lnk.parentNode.setAttribute("data-page", jumpPage);
            lnk.style.transform = "none";
        }
        request.pageNo = lnk.parentNode.hasAttribute("data-page") ?
                lnk.parentNode.getAttribute("data-page") :
                lnk.innerHTML;
        this.LoadData(crntTableId, request);
        return false;
    };

    this.Export = function (lnk, eType) {
        var request = {};
        var crntTableId = this.getParent(lnk, "table").getAttribute("id");
        this.BuildRequest(request, crntTableId);
        request.exportType = ["CSV", "Excel"].indexOf(eType) >= 0 ? eType : "csv";
        window.open(this.RequestToUrl(request));
        return false;
    };

    this.Sort = function (colNo, lnk) {
        var request = {};
        var crntTableId = this.getParent(lnk, "table").getAttribute("id");
        this.BuildRequest(request, crntTableId);
        if (Math.round(colNo) === request.colNo) {
            request.colOrd = request.colOrd === "asc" ? "desc" : "asc";
        } else {
            request.colNo = Math.round(colNo);
            request.colOrd = "asc";
        }
        this.LoadData(crntTableId, request);
        /* Clear and add new sort arrow */
        var headSpans = this.getParent(lnk, "thead").getElementsByTagName("span");
        var length = headSpans.length;
        for (var i = 0; i < length; i++) {
            headSpans[i].innerHTML = "";
        }
        lnk.getElementsByTagName("span")[0].innerHTML = (request.colOrd === "desc" ? window.strDesc : window.strAsc);
    };

    this.DrawSection = function (tableContainer, dt, tSection) {
        var section = tSection === "tfoot" ? "tfoot" : "tbody";
        tSection = document.getElementById(tableContainer).
                getElementsByTagName(section)[0];
        this.clearSection(tSection);
        for (var i = 0; i < dt.length; i++) {
            var row = dt[i];
            var tRow = document.createElement("tr");

            this.DrawRow(row, tRow);

            tSection.appendChild(tRow);
            if (section === "tfoot") {
                this.footerProcessPaginationLinks(tSection);
            }
            this.AppendRowCalback(tableContainer);
        }
    };

    this.DrawRow = function(row, tRow){
        for(var cell in row){

A for in loop automatically includes the property of any prototype object, consider checking the key using hasOwnProperty.

            var tCell = document.createElement("td");
            if(typeof row[cell] === "string" || typeof row[cell] === "number"){
                tCell.innerHTML = row[cell];
            } else if(typeof row[cell] === "object"){
                this.DrawCellFromObject(row, cell, tCell);
            }
            tRow.appendChild(tCell);
        }
    };

    this.DrawCellFromObject = function (row, cell, tCell) {
        for (var attr in row[cell]) {
            if (typeof row[cell][attr] === "string") {
                tCell.innerHTML = row[cell][attr];
            } else if (typeof row[cell][attr] === "object") {
                for (var v in row[cell][attr]) {
                    tCell.setAttribute(v, row[cell][attr][v]);
                }
            }
        }
    };

    this.footerProcessPaginationLinks = function (tSection) {
        var pLinks = tSection.querySelectorAll(".paging a");
        if (pLinks.length > 0) {
            for (var j = 0; j < pLinks.length; j++) {
                pLinks[j].setAttribute("href", "javascript:void(0);");
                pLinks[j].setAttribute("onclick", "return table.GoPage(this);");
            }
        }
    };

    this.clearSection = function (tSection) {
        if (this.iePrior(9)) {
            if (tSection.firstChild) {
                while (tSection.firstChild) {
                    tSection.removeChild(tSection.firstChild);
                }
            }
        } else {
            tSection.innerHTML = "";
        }
    };

    this.SetTheTableColumnsHoverEffect = function (tableContainer) {
        if (this.iePrior(9)) {
            return;
        }
        var tContainer = document.getElementById(tableContainer);
        var tHcells = tContainer.rows[0].cells;
        for (var i = 0; i < tHcells.length; i++) {
            if (tHcells[i].firstChild.tagName === "A") {
                tHcells[i].firstChild.setAttribute("onmouseover", "table.ColumnHover('" + tableContainer + "'," + i + ");");
                tHcells[i].firstChild.setAttribute("onmouseout", "table.ColumnHover('" + tableContainer + "');");
            }
        }
        var pLinks = tContainer.querySelectorAll("tfoot .paging a");
        if (pLinks.length > 0) {
            for (var j = 0; j < pLinks.length; j++) {
                pLinks[j].setAttribute("href", "javascript:void(0);");
                pLinks[j].setAttribute("onclick", "return table.GoPage(this);");
            }
        }
    };

    this.ColumnHover = function (tableContainer, index) {
        if (this.iePrior(9)) {
            return;
        }
        var tRow = document.getElementById(tableContainer).rows;
        index = Math.round(index);
        for (var i = 0; i < (tRow.length - 1); i++) {
            if (index >= 0) {
                tRow[i].cells[index].setAttribute("lang", "col-hover");
            } else {
                for (var j = 0; j < tRow[i].cells.length; j++) {
                    if (tRow[i].cells[j].lang) {
                        tRow[i].cells[j].removeAttribute("lang");
                    }
                }
            }
        }
    };

    this.getFilterFieldsByTbaleID = function (tableID) {
        var fields = {filterBy: null, filter: null};
        var filterDiv = this.getFilterDivByTableIDOrNull(tableID);
        if (filterDiv !== null) {
            var selectObj = filterDiv.getElementsByTagName("select")[0];
            var textObj = filterDiv.getElementsByTagName("input")[0];
            fields.filterBy = (selectObj === null || selectObj.options[selectObj.selectedIndex].value === "all") ? null : selectObj.options[selectObj.selectedIndex].value;
            fields.filter = (textObj === null || textObj.value.length === 0) ? null : encodeURIComponent(textObj.value.trim());
        }
        return fields;
    };

    this.getFilterDivByTableIDOrNull = function (tableID) {
        var res = null;
        if (document.getElementById(tableID).parentNode.getElementsByTagName("div").length > 0) {
            for (var i = 0; i < document.getElementById(tableID).parentNode.getElementsByTagName("div").length; i++) {
                if (document.getElementById(tableID).parentNode.getElementsByTagName("div")[i].getAttribute("class") === "filter") {
                    return document.getElementById(tableID).parentNode.getElementsByTagName("div")[i];
                }
            }

        }
        return res;
    };

    this.LoadData = function (tableContainer, rq) {
        this.setVisability(tableContainer, false);
        if (window.XMLHttpRequest) {
            xmlhttp = new XMLHttpRequest();/* code for IE7+, Firefox, Chrome, Opera, Safari */
        } else { /** global: ActiveXObject */
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");/*code for IE6, IE5 */
        }
        for (var i = 0; i < this.tail.length; i++) {
            var ex_xmlhttp = this.tail.shift();
            ex_xmlhttp.abort();
        }
        xmlhttp.onreadystatechange = function () {
            if (xmlhttp.readyState === 4 && xmlhttp.status === 200) {
                d = JSON.parse(xmlhttp.responseText);
                table.DrawSection(tableContainer, d.body);
                table.DrawSection(tableContainer, d.footer, "tfoot");
                table.LoadEndCalback(tableContainer);
                table.setVisability(tableContainer, true);
                if (typeof rq === "object") {
                    table.ColumnHover(tableContainer, rq.colNo);
                }
            }
        };
        xmlhttp.open("GET", this.RequestToUrl(rq), true);
        xmlhttp.send();
        this.tail.push(xmlhttp); //put in tail to may later abort any previous
    };

    this.setVisability = function (tableContainer, rq) {
        var tbl = document.getElementById(tableContainer);
        if (rq === true) {
            tbl.style.filter = "none";
            tbl.style.opacity = "1";
            tbl.style.cursor = "auto";
        } else if (rq === false) {
            tbl.style.filter = "blur(1px)";
            tbl.style.opacity = "0.8";
            tbl.style.cursor = "wait";
        } else {
            console.log("table error in the rq value"); /*Shows error*/
        }
    };

    this.getParent = function (obj, objType) {
        while (obj && obj.tagName !== objType.toUpperCase()) {
            obj = obj.parentNode;
        }
        return obj;
    };

    this.init = function (tableId) {
        this.SetTheTableColumnsHoverEffect(tableId);
    };

    this.iePrior = function (v) {
        var rv = false;
        if (/** global: navigator */ navigator.appName === 'Microsoft Internet Explorer') {
            var ua = navigator.userAgent;
            var re = new RegExp("MSIE ([0-9]{1,}[\.0-9]{0,})");
            if (re.exec(ua) !== null) {
                rv = parseFloat(RegExp.$1);
            }
            rv = rv < v ? true : false;
        }
        return rv;
    };
    this.loadJS = function (src) {
        var s = document.createElement('script');
        s.src = src;
        document.getElementsByTagName('head')[0].appendChild(s);
    };
    this.loadCSS = function (src) {
        var s = document.createElement('link');
        s.href = src;
        s.rel = "stylesheet";
        document.getElementsByTagName('head')[0].appendChild(s);
    };

    this.LoadEndCalback = function (tableId) {
        if (tableId) {/*Allows override*/
        }
    };
    this.AppendRowCalback = function (tableId) {
        if (tableId) {/*Allows override*/
        }
    };
};

/** Moves custom created filter to the Table's filter
 * @param {string} filterId
 * @param {string} tableId
 * @param {boolean} delay - needed in case the table is istill not executed */
function moveSelectorToTheTableFilter(filterId, tableId, delay) {
    if (delay === true) {
        setTimeout(function () {
            var filterDiv = document.getElementById(tableId)
                    .getElementsByTagName("div")[0];
            filterDiv.appendChild(document.getElementById(filterId));
        }, 500);
    } else {
        var filterDiv = document.getElementById(tableId)
                .getElementsByTagName("div")[0];
        filterDiv.appendChild(document.getElementById(filterId));
    }
}
function changeListCustomFilter(selectObj) {
    var fId = selectObj.options[selectObj.selectedIndex].value;
    var hasValue = fId !== "{!--Empty--!}";
    var varName = selectObj.getAttribute("name");
    var varPos = (document.URL.indexOf(varName) - (hasValue ? 0 : 1));
    if (varPos > 0) {
        var url = document.URL.substring(0, varPos);
    } else {
        var separator = document.URL.indexOf("?") > 0 ? "&" : "?";
        url = document.URL + (hasValue ? separator : "");
    }
    var newUrl = url + (hasValue ? (varName + "=" + fId) : "");
    location.assign(newUrl);
}


function tablesLoadData() {
    var tables = document.getElementsByTagName("table");
    var envPrior9 = table.iePrior(9);
    for (var i = 0; i < tables.length; i++) {
        var isProcessable = envPrior9 ?
                typeof tables[i]["data-table"] !== 'undefined' :
                tables[i].hasAttribute("data-table");
        if (isProcessable && tables[i].getAttribute("data-table") === "js") {
            table.LoadData(tables[i].id);
            table.SetTheTableColumnsHoverEffect(tables[i].id);
        }
    }
    if (table.iePrior(10)) {
        table.loadJS("/add/helpers/table/add/json2.js");
    }

    /*if(table.iePrior(8)){ //can be used to add apropriate tables links modifications
     // loadCSS("/add/helpers/table/add/ie7-and-down.css");
     }*/
}

/*if(window.addEventListener){window.addEventListener('load',tablesLoadData,false);} else if(window.attachEvent){window.attachEvent('onload',tablesLoadData);}*/