OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	12/31/2022 06:53:36 AM	rwxr-xr-x
📄 .filter_template.js.swp	20 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 .ws.core.js.swp	20 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 chartPrefs.js	14.4 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 compute.js	6.11 KB	08/14/2022 11:05:25 AM	rw-r--r--
📄 display.js	13.24 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 dtree.js	14.88 KB	08/14/2022 11:05:25 AM	rw-r--r--
📁 files	-	08/14/2022 11:05:24 AM	rwxr-xr-x
📄 filterClass.js	5.17 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 filter_template.js	87.03 KB	08/14/2022 11:05:25 AM	rw-r--r--
📄 filter_template.js_17Feb2020	85.47 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 filter_template.js_19jan18	81.31 KB	08/14/2022 11:05:25 AM	rw-r--r--
📄 ws.app.js	22.03 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 ws.core.js	46.33 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 ws.ext.js	34.42 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 ws.ext.js_09dec2019	33.16 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 ws.ext.js_10dec2019	32.45 KB	08/14/2022 11:05:25 AM	rw-r--r--
📄 ws.ext.js_28Aug2019	23.55 KB	08/14/2022 11:05:25 AM	rw-r--r--
📄 ws.lib.js	35.14 KB	08/14/2022 11:05:25 AM	rw-r--r--
📄 ws.lib.js_19jan18	30.59 KB	08/14/2022 11:05:24 AM	rw-r--r--
📄 wsAll.js	143.54 KB	08/14/2022 11:05:24 AM	rw-r--r--

Editing: ws.lib.js

function setCookie(c_name,value,exdays) {
	var exdate=new Date();
	exdate.setDate(exdate.getDate() + exdays);

var c_value=escape(value) + ((exdays==null) ? "" : "; expires="+exdate.toUTCString());
	document.cookie=c_name + "=" + c_value;
}

function convertXmlToJson(xml) {

// Create the return object
        var obj = {};

if (xml.nodeType == 1) { // element
                // do attributes
                if (xml.attributes.length > 0) {
                obj["@attributes"] = {};
                        for (var j = 0; j < xml.attributes.length; j++) {
                                var attribute = xml.attributes.item(j);
                                obj["@attributes"][attribute.nodeName] = decodeXML(attribute.nodeValue);
                        }
                }
        } else if (xml.nodeType == 3) { // text
                obj = xml.nodeValue;
        }

// do children
        // If just one text node inside
        if (xml.hasChildNodes() && xml.childNodes.length === 1 && xml.childNodes[0].nodeType === 3) {
                obj = xml.childNodes[0].nodeValue;
        }
        else if (xml.hasChildNodes()) {
                for(var i = 0; i < xml.childNodes.length; i++) {
                        var item = xml.childNodes.item(i);
                        var nodeName = item.nodeName;
                        if (typeof(obj[nodeName]) == "undefined") {
                                obj[nodeName] = convertXmlToJson(item);
                        } else {
                                if (typeof(obj[nodeName].push) == "undefined") {
                                        var old = obj[nodeName];
                                        obj[nodeName] = [];
                                        obj[nodeName].push(old);
                                }
                                obj[nodeName].push(convertXmlToJson(item));
                        }
                }
        }
        if(Object.keys(obj).length == 0)
                obj = '';
        return obj;
}

/*Array.prototype.max = function() {
	var max = this[0];
	var len = this.length;
	for (var i = 1; i < len; i++) if (this[i] > max) max = this[i];
	return max;
}
Array.prototype.min = function() {
	var min = this[0];
	var len = this.length;
	for (var i = 1; i < len; i++) if (this[i] < min) min = this[i];
	return min;
}*/

function isWeekColumn(Column){
	Column=Column.toLowerCase();
	if(Column == 'week' || Column == 'finwk')
		return true;
	else
		return false;
}

function isTimeColumn(Column){
	Column=Column.toLowerCase();
	if(Column == "year" || Column== "month" || Column=="finmth" || Column == "quarter" || Column == "finqtr" || Column == "week" || Column == "finwk" || Column == "finmth" || Column == "finyr" || Column == "dayofweek" || Column == "day" || Column == "date" || Column == "hour")
		return true;
	else
		return false;
}
function convertToDisplay(value, Column){
	Column=Column.toLowerCase();
	if(isTimeColumn(Column))
		return decodeTime(Column, value);
	else
		return value;
}
function decodeTime(type, value){
	var month =   ['','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
	/*var finMonthArray = ['','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'];*/
        var finMonthArray = ['','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct'];
	var quarter = ['','Qtr-1','Qtr-2','Qtr-3','Qtr-4'];
	var weekdays =['','Monday','Tuesday','Wednesday','Thursday','Friday', 'Saturday', 'Sunday'];

if(type == "month")
		return month[value];
	if(type == "finmth")
		return finMonthArray[value];
	else if(type == "quarter" || type == "finqtr")
		return quarter[value];
	else if(type == "dayofweek")
		return weekdays[value];
	else if(type == "week" || type == "finwk")
		return "Week-"+value;

return value;
}

function encodeTime(type, value){
	var month = new Array();
	month['Jan'] = 1; month['Feb'] = 2; month['Mar'] = 3; month['Apr'] = 4; month['May'] = 5; month['Jun'] = 6; month['Jul'] = 7; month['Aug'] = 8;
	month['Sep'] = 9; month['Oct'] = 10; month['Nov'] = 11; month['Dec'] = 12;

var quarter = new Array();
	quarter['Qtr-1'] = 1; quarter['Qtr-2'] = 2; quarter['Qtr-3'] = 3; quarter['Qtr-4'] = 4;

var weekdays = new Array();
	weekdays['Monday'] = 1; weekdays['Tuesday'] = 2; weekdays['Wednesday'] = 3; weekdays['Thursday'] = 4; 
	weekdays['Friday'] = 5; weekdays['Saturday'] = 6; weekdays['Sunday'] = 7;

if(type == "month")
		return month[value];
	else if(type == "quarter")
		return quarter[value];
	else if(type == "dayofweek")
		return weekdays[value];

return value;
}

function decodeoper(oper){  
	if (oper == "bw")        
		return "Between";
	else if (oper ==  "gt")   
		return ">";       
	else if (oper ==  "lt")
		return "<";
	else if (oper ==  "ne")
		return "!=";
	else if (oper ==  "lk")
		return "Like";
	else if (oper ==  "ge")
		return ">=";
	else if (oper ==  "le")
		return "<=";
	else if (oper ==  "nb")
		return "Not Between"; 
	else if (oper ==  "td")
		return "TD";
	else    
		return "=";

}
function sort_unique(arr) {
	if(typeof arr == 'undefined' || arr.length<1)
		return arr;
	arr = arr.sort(function (a, b) { return a*1 - b*1; });
	var ret = [arr[0]];
	for (var i = 1; i < arr.length; i++) { // start loop at 1 as element 0 can never be a duplicate
		if (arr[i-1] !== arr[i]) {
			ret.push(arr[i]);
		}
	}
	return ret;
}

function formatReportData(ReportData, dims, layout, topn){
	var monthArray = ['','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
	/*var finMonthArray = ['','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'];*/
        var finMonthArray = ['','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct'];
	var quarterArray=['','Qtr-1','Qtr-2','Qtr-3','Qtr-4'];
	var weekdays =['','Monday','Tuesday','Wednesday','Thursday','Friday', 'Saturday', 'Sunday'];
	var mIndex=-1, fIndex=-1, qIndex=-1, wIndex=-1, dIndex=-1, ymIndex=-1; var i=0; var j=0; var ndims=0, tmpstr;

var nrows=ReportData.length;
	var ncols=ReportData[0].length;

for ( i = 1; i < nrows; i++) { //i=1 because leaving heading in ReportData

if(mIndex > -1 && parseInt(ReportData[i][mIndex]) >0 && parseInt(ReportData[i][mIndex]) <=12 ){
			ReportData[i][mIndex] = monthArray[ReportData[i][mIndex]];
		}
		if(qIndex > -1 && parseInt(ReportData[i][qIndex]) >0 && parseInt(ReportData[i][qIndex]) <=5){
			ReportData[i][qIndex] = quarterArray[ReportData[i][qIndex]];
		}
		if(fIndex > -1 && parseInt(ReportData[i][fIndex]) >0 && parseInt(ReportData[i][fIndex]) <=12){
			ReportData[i][fIndex] = finMonthArray[ReportData[i][fIndex]];
		}
		if(wIndex > -1 && parseInt(ReportData[i][wIndex]) >=0){
			ReportData[i][wIndex] = 'Week-'+ReportData[i][wIndex];
		}
		if(dIndex > -1 && parseInt(ReportData[i][dIndex]) >=0 && parseInt(ReportData[i][dIndex]) <=7){
			ReportData[i][dIndex] = weekdays[ReportData[i][dIndex]];
		}
		if(ymIndex > -1 && parseInt(ReportData[i][ymIndex]) >=0){
			var yrmth = ReportData[i][ymIndex].split("-");
                        ReportData[i][ymIndex] = yrmth[0]+"-"+monthArray[parseInt(yrmth[1])];
                }
	}

for( i=1; i<nrows; i++){
		for( j=ndims; j<ReportData[i].length; j++){
			if(ReportData[i][j]=="")
				ReportData[i][j]=0;
		}
	}

if(layout == "CrossTab"){
		ndims=dims.length;
		if(dims[ndims -1] == "month"){
			for( j=ndims-1; j<ncols; j++){
				var tmpArray=ReportData[0][j].split("~_");
				tmpstr=monthArray[tmpArray[0]];
				if(tmpstr)
					tmpArray[0]=tmpstr;
				ReportData[0][j]=tmpArray.join("~_");
			}
		}
		else if(dims[ndims -1] == "finmth"){
			for( j=ndims-1; j<ncols; j++){
				var tmpArray=ReportData[0][j].split("~_");
				tmpstr=finMonthArray[tmpArray[0]];
				if(tmpstr)
					tmpArray[0]=tmpstr;
				ReportData[0][j]=tmpArray.join("~_");
			}
		}
		else if(dims[ndims -1] == "quarter" || dims[ndims -1] == "finqtr"){
			for( j=ndims-1; j<ncols; j++){
				var tmpArray=ReportData[0][j].split("~_");
				tmpstr=quarterArray[tmpArray[0]];
				if(tmpstr)
					tmpArray[0]=tmpstr;
				ReportData[0][j]=tmpArray.join("~_");
			}
		}
		else if(dims[ndims -1] == "week" || dims[ndims -1] == "finwk"){
			for( j=ndims-1; j<ncols; j++){
				var tmpArray=ReportData[0][j].split("~_");
				tmpstr="Week-"+tmpArray[0];
				if(tmpstr)
					tmpArray[0]=tmpstr;
				ReportData[0][j]=tmpArray.join("~_");
			}
		}
		else{
			for( j=ndims-1; j<ncols; j++){
				var tmpArray=ReportData[0][j].split("~_");
				ReportData[0][j]=tmpArray.join("~_");
			}
		}
	}
	//Handling Rest Totals for topx reports
	if(topn > 0 && userLanguage!="English"){
		for(i=topn; i<nrows;){
			if(ReportData[i+1][dimLen-1].indexOf("Rest(") >=0)
				ReportData[i+1][dimLen-1]=getLabel("Rest Total");
			i=i+topn+1;
		}
	}

return ReportData;
}
function unique(dimArray) {
	var uniqArray = [];
	var l = dimArray.length;
	for(var i=0; i<l; i++) {
		for(var j=i+1; j<l; j++) {
			if (dimArray[i] === dimArray[j])
				j = ++i;
		}
		uniqArray.push(dimArray[i]);
	}
	return uniqArray;
};

/*
 *  * Function to make normal report data to crosstab report data
 *   */
function makeXtab(DataTable){
	var i=0, j=0;
	var Hash= new Array();
	var Dim1= new Array();
	var Dim2= new Array();

for(i=1; i<DataTable.length; i++){
		Dim1.push(DataTable[i][0]);
		Dim2.push(DataTable[i][1]);
	}
	Dim1=unique(Dim1.sort());
	Dim2=unique(Dim2.sort());
	for(i=1; i<DataTable.length; i++){
		str=DataTable[i][0]+":"+DataTable[i][1];
		Hash[str]=DataTable[i][2];
	}
	var col_values=new Array(Dim1.length+1);
	col_values[0]=new Array(Dim2.length+1);
	col_values[0][0]=DataTable[0][0];

for(i=0; i<Dim1.length; i++){
		col_values[i+1]=new Array(Dim2.length+1);
		col_values[i+1][0]=Dim1[i];
		for(j=0; j<Dim2.length; j++){
			col_values[0][j+1]=Dim2[j]+"~_"+DataTable[0][2];
			if(Hash[Dim1[i]+":"+Dim2[j]])
				col_values[i+1][j+1]=Hash[Dim1[i]+":"+Dim2[j]];
			else
				col_values[i+1][j+1]=0;
		}
	}
	return col_values;
}

/*
 *  *Revert report data. Row to column and column to row to display crosstab reports like CUBOT is showing.
 *   */
function revertRowColumn(DataTable, measure){
	var col_values=new Array(DataTable[0].length);
	for(i=0; i<DataTable[0].length; i++){
		col_values[i]=new Array(DataTable.length-1);
		DataTable[0][i]=DataTable[0][i].replace(measure,'');
	}

for(i=0; i<DataTable.length; i++){
		for(j=0; j<DataTable[i].length; j++){
			col_values[j][i]=DataTable[i][j];
		}
	}
	for(i=1; i<=DataTable.length-1; i++){
		col_values[0][i]=col_values[0][i]+' '+measure;
	}

return col_values;
}

/*
 * Check if value exists in the array
 *
 */
function ifExists(valArray, currentValue){
	if(typeof valArray == 'undefined' || valArray.length<1)
		return false;

for(var i=0; i<valArray.length; i++){
		if(valArray[i] == currentValue)
			return true;
	}

return false;

}
/*
 * Get the operator combo
 */
function getFilterOperatorCombo(itemId, operator){
	var htmlStr='<select itemId="'+itemId+'" class=filterOperator>'; 
	htmlStr+='<option value="eq">Equals to</option>'; 
	htmlStr+='<option value="bw">Between</option>'; 
	htmlStr+='<option value="gt">Greater then</option>'; 
	htmlStr+='<option value="lt">Less then</option>'; 
	htmlStr+='<option value="ne">Not Equals</option>'; 
	htmlStr+='<option value="lk">Like</option>'; 
	htmlStr+='<option value="ge">Greater then Equals</option>'; 
	htmlStr+='<option value="le">Less then Equals</option>'; 
	htmlStr+='<option value="nb">Not Between</option>'; 
	htmlStr+='<option value="td">Till Date</option>'; 
	htmlStr+='</select>';

htmlStr=htmlStr.replace('value="'+operator+'"', 'value="'+operator+'" selected="selected"');

return htmlStr;
}

/*
 *
 */

function printItemList(authToken, myfunc){
	var metaDataCollection=createItemList(authToken);
	var item="";
	a = new dTree('a');
	a.config.useStatusText=true;
	a.config.closeSameLevel=false;
	a.config.useCookies=false;
	a.config.target="";
	/*add(id, pid, name, url, udelete, title, target, icon, iconOpen, open, element)*/

a.add("0", "0", "Dimension");
	for(var i=0; i<metaDataCollection.dimensionTree.length; i++){
		item = metaDataCollection.dimensionTree[i];
		a.add(item.Id, item.ParentId, item.Name);
		for(var j=0; j<metaDataCollection.dimensionTree[i].items.length; j++){
			item = metaDataCollection.dimensionTree[i].items[j];
			a.add(item.Id, item.ParentId, item.Name, "javascript:"+myfunc+"("+item.Id+",'"+item.Name+"','"+item.Column+"')", "","","",getIcon(item.DataType));
		}
	}
/*	a.add("10000", "10000", "Measures");
	for(var i=0; i<metaDataCollection.measureTree.length; i++){
		item = metaDataCollection.measureTree[i];
		a.add(item.Id, item.ParentId, item.Name);
		for(var j=0; j<metaDataCollection.measureTree[i].items.length; j++){
			item = metaDataCollection.measureTree[i].items[j];
			a.add(item.Id, item.ParentId, item.Name, "javascript:"+myfunc+"("+item.Id+",'"+item.Name+"','"+item.Format+"')", "","","",getIcon(item.DataType));
		}
	} */
	/*a.add("50000", "50000", "Targets");
	for(var i=0; i<metaDataCollection.targetTree.length; i++){
		item = metaDataCollection.targetTree[i];
		a.add(item.Id, item.ParentId, item.Name, "javascript:"+myfunc+"("+item.Id+",'"+item.Name+"')", "","","",getIcon(item.DataType));
		for(var j=0; (typeof metaDataCollection.targetTree[i].items != "undefined" && j<metaDataCollection.targetTree[i].items.length); j++){
			item = metaDataCollection.targetTree[i].items[j];
			a.add(item.Id, item.ParentId, item.Name, "javascript:"+myfunc+"("+item.Id+",'"+item.Name+"')", "","","",getIcon(item.DataType));
		}
	}*/
	return a;

}

function isstring(val){
	if(typeof val == "undefined" || val=="")
		return false;
	return true;
}

$("#"+Id).dialog({
		title:Title,
		height:Height,
		width: Width,
		modal: true,
		resizable: true,
		autoResize: false,
		autoOpen: false,
		position:['center',50],
		buttons: [ { text: "Apply", click: function() {applyFunc(params1, params2)} } ]
	});
	$("#"+Id).html(htmlstr).dialog("open");
}
/*
 *  * Get view port width. Helpful as resolution differs for different monitor.
 *   */
function getMwidth(){
	var viewportwidth;
	if (typeof window.innerWidth != 'undefined') {
		viewportwidth = window.innerWidth;
	}
	else if (typeof document.documentElement != 'undefined' && typeof document.documentElement.clientWidth != 'undefined' && document.documentElement.clientWidth != 0) {
		viewportwidth = document.documentElement.clientWidth;
	}
	else {
		viewportwidth = document.getElementsByTagName('body')[0].clientWidth;
	}
	return viewportwidth;
}

/*
 *  * Get view port height. Helpful as resolution differs for different monitor.
 *   */
function getMheight(){
	var viewportheight;
	if (typeof window.innerWidth != 'undefined') {
		viewportheight = window.outerHeight;
	}
	else if (typeof document.documentElement != 'undefined' && typeof document.documentElement.clientWidth != 'undefined' && document.documentElement.clientWidth != 0) {
		viewportheight = document.documentElement.clientHeight;
	}
	else {
		viewportheight = document.getElementsByTagName('body')[0].clientHeight;
	}
	return viewportheight;
}

//var format = 'cup2z-TYGY';
function formatNumber(val, format){
		//return formatTime(val);
	var Gsym=','; // Grouping Symbol
	var dec='.'; //Decimal symbol

var precesionVal=0, prefixval="", suffixval="";  /* We will not use precesion, prefix,suffix for axis formatting */

if(typeof format == "undefined")
		format=getFormat();

if (format && format.currency == "e") {
		Gsym='.';
		dec=',';
	}
	if(format && format.suffix){ /* Suffix means percent so no more short format */
		suffixval=format.suffix;
	}
	else{
		if(format && format.currency == "i") {
			if(Math.abs(val)>=10000000){
				val=val/10000000;
				suffixval='Cr';
				precesionVal=2;
			}
			else if(Math.abs(val)>=100000){
				val=val/100000;
				suffixval='L';
				precesionVal=2;
			}
			else if(Math.abs(val)>=1000){
				val=val/1000;
				suffixval='K';
				precesionVal=1;
			}
		}
		else{
			if(Math.abs(val)>=1000000000000){
				val=val/1000000000000;
				suffixval='T';
				precesionVal=2;
			}
			else if(Math.abs(val)>=1000000000){
				val=val/1000000000;
				suffixval='B';
				precesionVal=2;
			}
			else if(Math.abs(val)>=1000000){
				val=val/1000000;
				suffixval='M';
				precesionVal=1;
			}
			else if(Math.abs(val)>=1000){
				val=val/1000;
				suffixval='K';
				precesionVal=1;
			}
			/*else if(Math.abs(val)>=100){
			  val=val/1000;
			  suffixval='K';
			  precesionVal=1;
			  }*/
			 else if(Math.abs(val)<5){
				if(Number.isInteger(val))
					precesionVal=0
				else
					precesionVal=1
					                                
                      }
		}
	}
	/*if(format.prec<precesionVal)
		precesionVal=format.prec;*/

if(format.prefix != '')
		prefixval=format.prefix;

return formatMoney(val, prefixval, suffixval, precesionVal, dec, Gsym);
}

/*function formatMoney(m,a,b,c, d, t){
	var n = m, c = isNaN(c = Math.abs(c)) ? 2 : c, d = d == undefined ? "," : d, t = t == undefined ? "." : t, s = n < 0 ? "-" : "", i = parseInt(n = Math.abs(+n || 0).toFixed(c)) + "", j = (j = i.length) > 3 ? j % 3 : 0;
	return a+""+s + (j ? i.substr(0, j) + t : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + t) + (c ? d + Math.abs(n - i).toFixed(c).slice(2) : "")+b;
}*/

function formatMoney(val,prefixval,suffixval,precesionVal, dec, Gsym){
        var tmpVal = val,
            precesionVal = isNaN(precesionVal = Math.abs(precesionVal)) ? 2 : precesionVal,
            dec = dec == undefined ? "," : dec,
            Gsym = Gsym == undefined ? "." : Gsym,
            sign = tmpVal < 0 ? "-" : "",
            numWithoutPrec = parseInt(tmpVal = Math.abs(+tmpVal || 0).toFixed(precesionVal)) + "",
            threeDivident = (threeDivident = numWithoutPrec.length) > 3 ? threeDivident % 3 : 0,
            firstOddThree=(threeDivident ? numWithoutPrec.substr(0, threeDivident) + Gsym : ""),
            allEvenThree=numWithoutPrec.substr(threeDivident).replace(/(\d{3})(?=\d)/g, "$1" + Gsym),
            restWithPrec=(precesionVal ? dec + Math.abs(tmpVal - numWithoutPrec).toFixed(precesionVal).slice(2) : "");

if(parseFloat(restWithPrec)==0)
		restWithPrec="";
      
        return prefixval + sign + firstOddThree + allEvenThree + restWithPrec + suffixval;
}

function formatMoneyIndia(val,prefixval,suffixval,precesionVal, dec, Gsym){
	var tmpVal = val,
	    precesionVal = isNaN(precesionVal = Math.abs(precesionVal)) ? 2 : precesionVal,
	    dec = dec == undefined ? "," : dec,
	    Gsym = Gsym == undefined ? "." : Gsym,
	    sign = tmpVal < 0 ? "-" : "",
	    numWithoutPrec = parseInt(tmpVal = Math.abs(+tmpVal || 0).toFixed(precesionVal)) + "",
	    lastOddThree=numWithoutPrec.substring(numWithoutPrec.length-3),
	    allEvenTwo=numWithoutPrec.substring(0,numWithoutPrec.length-3).replace(/\B(?=(\d{2})+(?!\d))/g, Gsym),
	    restWithPrec=(precesionVal ? dec + Math.abs(tmpVal - numWithoutPrec).toFixed(precesionVal).slice(2) : "");

return prefixval + sign + allEvenTwo +(allEvenTwo.length>0?Gsym:"")+ lastOddThree + restWithPrec + suffixval;
}

function formatTimeTicks(val){
	if(val ==0)
		return 0;
	var sec_num = parseInt(val, 10);
	var days = Math.floor(sec_num / 86400);
	var hours   = Math.floor((sec_num - (days*86400) ) / 3600);
	var minutes = Math.floor((sec_num - (days*86400) - (hours * 3600)) / 60);
	var seconds = sec_num - (days*86400) - (hours * 3600) - (minutes * 60);

if(days >0) {
		days = days+ (days>1?" Days ":" Day ");
	} 
	else{
		days="";
	}
	if (hours   > 0) {
		hours   = hours+(hours>1?" Hours ":" Hour ");
	} 
	else { 
		hours="";
	}
	if (minutes > 0) {
		minutes = minutes+(minutes>1?" Minutes ":" Minute ");
	} 
	else {
		minutes="";
	}
	if (seconds > 0) {
		seconds = seconds+(seconds>1?" Seconds":" Second");
	} 
	else {
		seconds="";
	}
	if(days)
                return days;
        else if(hours)
                return hours;
        else if(minutes)
                return minutes;
        else
		return days+''+hours+''+minutes+''+seconds;
}	
function formatTime(val){
	var sec_num = parseInt(val, 10);
	var days = Math.floor(sec_num / 86400);
	var hours   = Math.floor((sec_num - (days*86400) ) / 3600);
	var minutes = Math.floor((sec_num - (days*86400) - (hours * 3600)) / 60);
	var seconds = sec_num - (days*86400) - (hours * 3600) - (minutes * 60);

if(days >0) {days = days+ (days>1?" Days ":" Day ");} else{days="";}
	if (hours   < 10) {hours   = "0"+hours;}
	if (minutes < 10) {minutes = "0"+minutes;}
	if (seconds < 10) {seconds = "0"+seconds;}

var time    = days+""+hours+':'+minutes+':'+seconds;
	//var time    = hours+' H, '+minutes+' M, '+seconds+' S';
	return time;
}
function makeTimeMinMax(minMaxArr){
	var min=minMaxArr[0];
	var max=minMaxArr[1];

if(min > (86400*2)){ /* if more then 2 days */
		tmp=Math.floor(min/86400);
		min=tmp*86400;
	}       
	else if(min > (3600*3)){ /* if more then 3 hours */
		tmp=Math.floor(min/3600);
		min=tmp*3600;
	}       
	else if(min > 3600){ /* more then 1 hour */
		tmp=Math.floor(max/60);
		min=tmp*60;
	}       
	minMaxArr[0]=min;

if(max > (86400*2)){ /* if more then 2 days */
		tmp=Math.ceil(max/86400);
		max=tmp*86400;
	}
	else if(max > (3600*3)){ /* if more then 3 hours */
		tmp=Math.ceil(max/3600);
		max=tmp*3600;
	}
	else if(max > 3600){ /* more then 1 hour */
		tmp=Math.ceil(max/60);
		max=tmp*60;
	}
	minMaxArr[1]=max;

return minMaxArr;

}
function getFromURL(reqStr){
	        if(document.URL.length >0 && document.URL.split(reqStr+'=').length >1)
			                return(document.URL.split(reqStr+'=')[1].split('&')[0].replace('#',''));
}

function getFormat(formatter){
	var format={
			currency : 'u',
			unit:'1', //Actual=1. Short=2	   
			prefix : '', 
			suffix : '', 
			prec : '', 
			dec : '.', //Decimal symbol
			Gsym : ',' // Grouping Symbol
	};
	if((typeof formatter === 'undefined') || (formatter.length<1))
		return format;

var cur = formatter.indexOf("c");
	if(cur >=0)
		format.currency=formatter.substr(cur + 1, 1);
	
	var unit = formatter.indexOf("U");
	if(unit >=0)
		format.unit=formatter.substr(unit + 1, 1);

var precesion = formatter.indexOf("p");
	if(precesion >=0)
		format.prec=formatter.substr(precesion + 1, 1);

var prefix = formatter.indexOf("P");
	if(prefix>=0)
		format.prefix = formatter.substr(prefix + 1, 1);

var suffix = formatter.indexOf("S");
	if(suffix >= 0)
		format.suffix = formatter.substr(suffix + 1, 1);

if (formatter.charAt(1) == "e") {
		format.Gsym='.';
		format.dec=',';
	}
	return format;
}
function formatSmallScale(val, format){
	        return  String(formatData(val, format, 1)).replace(" Days", "D").replace(" Day", "D").replace(" Hours", "H").replace(" Hour", "H").replace(" Minutes", "M").replace(" Minute", "M").replace(" Seconds", "S").replace(" Second", "S");
}

/* Replacement of d3.csv.parse(inData.join('\n'));  Optimized to save time. */
function parse2DArray(data){
	var header=new Array(), objArr=new Array();
	for(var i=0; i<data.length; i++){
		if (i) {
			var o = {}, j = -1, m = header.length;
			while (++j < m) o[header[j]] = data[i][j];
			objArr.push(o);
		}
		else {
			header = data[i];
		}
	}
	return objArr;
}

function prepareNshowChart(authToken, divId, gType, title, ReportObj ){
	var metaDataCollection=createItemList(authToken);

//var dispObj=new displayOptions();
	var callback=callbackReportData;  /*Should be a function name which you want to call after getting data */

ReportObj.setgtype(gType);
	ReportObj.settitle(title);
	/*if(!ReportObj.topn || ReportObj.topn<0)
		ReportObj.settopn(1000);*/
	
	//if(gType != 'M'){
		for(var i=0; i<G_FilterList.filterList.length; i++){
			ReportObj.filterList.filterList.push(G_FilterList.filterList[i]);
		}
	//}
	ReportObj.setdimensionFilters(ReportObj.filterList.getFilterString("D"));
	ReportObj.setmeasureFilters(ReportObj.filterList.getFilterString("M"));

var mapType="World";
	if(ReportObj.dispObj.RD && ReportObj.dispObj.RD.General.mapType)
		mapType=ReportObj.dispObj.RD.General.mapType;

var displayObj=new displayOptions();
	displayObj.RDsetGeneral();
	displayObj.RD.General.divId=divId;
	displayObj.RD.General.portlet=0;
	displayObj.RD.General.authToken=authToken;
	displayObj.RD.General.mapType=mapType;
	ReportObj.dispObj=displayObj;

if(ReportObj.dimensions && ReportObj.dimensions.length>0){
		if(gType != 'M'){
		ReportObj.setsystitle(ReportObj.measures.join(',')+ ' by '+ ReportObj.dimensions.join(',')); /*Required for Table Chart */

ReportObj.setsubtitle(G_FilterList.getReadableFilterString('D') + G_FilterList.getReadableFilterString('M'));

$(".portletTitle", $("div#"+divId).parent().parent()).html(G_FilterList.getReadableFilterString('D'));
		}

createReport(authToken, false, callback, ReportObj);
		for(var i=0; i<G_FilterList.filterList.length; i++){
			ReportObj.filterList.clearFilter(G_FilterList.filterList[i]);
		}
	}
	else{
		$("#"+divId).html("<center><b><br><br>Please click settings icon to add dimensions and measures.</b></center>");
	}

return ReportObj;
}

function getGtypeCombo(chgFunc){
	var gTypesFull=['Text','Pie','Line','Bar','Stack Bar','Combo',   'Column','Bullet','Gauge','PC', 'Tree','Map','Heat', 'Radar', 'Stock', 'SVG', 'Waterfall'];
	var gTypes=['T','P','L','B','S','C',   'N','Bullet','G','PC', 'Tree','M','Heat',      'Radar','Stock','SVG', 'WF'];
	var gDisp =['Text','Pie','Line','Bar','Stack Bar','Bar+Line','Column','Bullet','Gauge','KPI','Tree','Map','Heat Chart','Radar', 'Stock', 'Custom', 'Waterfall'];

var htmlStr='<select class=gtypeCombo'+(typeof chgFunc != "undefined"? " onchange="+chgFunc+"()":"")+'>'; 
	for(var i=0; i<gTypes.length; i++){
		htmlStr+='<option value="'+gTypes[i]+'">'+gDisp[i]+'</option>'; 
	}
	htmlStr+='</select>'; 
	return htmlStr;
}

function getMapLocationCombo(){
	var mLoc=["World","Brazil","India","India-Telecom","India-States","Bangalore","Punjab","India-Odisha","usa","North America","South America","Africa","Asia","Southeast Asia","Australia","Europe","Malaysia","Singapore"];
	var mLocFull=["World", "Brazil", "India","India(Telecom)","India(States)","Bangalore(India)","Punjab(India)","Odisha(India)","America","America(North)","America(South) ","Africa","Asia","Asia(Southeast) ","Australia","Europe","Malaysia","Singapore"];

var htmlStr='<select class=mapTypeCombo>'; 
	for(var i=0; i<mLoc.length; i++){
		htmlStr+='<option value="'+mLoc[i]+'">'+mLocFull[i]+'</option>'; 
	}
	htmlStr+='</select>'; 
	return htmlStr;
}

function getVDBdetailsFromDB(authToken, portlet, type){
	var ReportObj = new Report(), itemObj="";

initReportObj(ReportObj);
	ReportObj.gtype=gtype[portlet];

var report = getContentData(authToken, type, portlet);

if(report.length>0)
		report=$.evalJSON(report);
	else
		return ReportObj;

var metaDataCollection=createItemList(authToken);
	for(var i=0; i<report.dimensionIds.length; i++){
		itemObj=metaDataCollection.getItemById(report.dimensionIds[i]);
		ReportObj.addDimensionToReport(itemObj);
	}

for(var i=0; i<report.measureIds.length; i++){
		itemObj=metaDataCollection.getItemById(report.measureIds[i]);
		ReportObj.addMeasureToReport(itemObj);
	}

if(report.formats != undefined)
		ReportObj.formats=report.formats;

ReportObj.filterList.filterList=report.filterList;

ReportObj.setgtype(report.gtype);
	ReportObj.setlayout(report.layout);
	ReportObj.settopn(report.topn);

ReportObj.dispObj=new displayOptions();
	ReportObj.dispObj.RDsetGeneral();
	if(report.mapType)
		ReportObj.dispObj.RD.General.mapType=report.mapType;
	else
		ReportObj.dispObj.RD.General.mapType="World";

return ReportObj;
}

function freezeTextHeader(modContId){
	var container=$("#"+modContId);
	var table=container.children();

if(table.prop("class") == "sorttable"){
		$('th, td', $('thead tr', table)).each(function(i){
				$(this).css('width',$(this).width()+'px');
				});
		$('td', $('tbody tr:first', table)).each(function(i){
				$(this).css('width',$(this).width()+'px');
				$(this).css('min-width',$(this).width()+'px');
				});
		$('td', $('tfoot tr:first', table)).each(function(i){
				$(this).css('width',$(this).width()+'px');
				});
		container.prepend('<div><table border="0" cellspacing="1" cellpadding="3" class="tbl_border"><THEAD>'+table[0].tHead.innerHTML+'</THEAD></table></div>');
		table[0].deleteTHead();
		table.wrap('<div style="height:220px;overflow:auto;"></div>');
		container.append('<div><table border="0" cellspacing="1" cellpadding="3" class="tbl_border"><TFOOT>'+table[0].tFoot.innerHTML+'</TFOOT></table></div>');
		table[0].deleteTFoot();
	}
	else{
		if((container.children().length == 3) && (container.children().eq(1).children().prop("class") == "sorttable")){
			table=container.children().eq(1).children();
			table[0].tHead=container.children().eq(0).children()[0].tHead;	
			table[0].tFoot=container.children().eq(2).children()[0].tFoot;	
			container.children().eq(0).remove(); 
			container.children().eq(1).remove(); /* child shifted, so 1 */
			table.unwrap();
		}
	}
}
function makeProperHeight(Height, divId){
	if(Height === 'undefined' || String(Height).length<1 || parseFloat(Height)<50)
		Height=parseFloat($("div#"+divId).css('height'));
	return Height;
}
function makeProperWidth(Width, divId){
	if(Width === 'undefined' || String(Width).length<1 || parseFloat(Width)<50)
		Width=parseFloat($("div#"+divId).css('width'));
	return Width;
}
function getReportTypeByClassName(className){
	var gType="T";

if(className=="actionReportGauge") gType="G";
	else if(className=="actionReportMap") gType= "M";
	else if(className=="actionReportBar") gType= "B";
	else if(className=="actionReportPie") gType= "P";
	else if(className=="actionReportDonut") gType= "D";
	else if(className=="actionReportColumn") gType= "N";
	else if(className=="actionReportLine") gType= "L";
	else if(className=="actionReportStack") gType= "S";
	else if(className=="actionReportStackedArea") gType= "SA";
	else if(className=="actionFilledArea") gType= "FA";
	else if(className=="actionReportCombo") gType= "C";
	else if(className=="actionReportText") gType= "T";
	else if(className=="actionReportPC") gType= "PC";
	else if(className=="actionReportBullet") gType= "Bullet";
	else if(className=="actionReportTree") gType= "Tree";
	else if(className=="actionReportStock") gType= "Stock";
	else if(className=="actionReportHeat") gType= "Heat";
	else if(className=="actionReportRadar") gType= "Radar";
	else if(className=="actionReportSunburst") gType= "Sun";
	else if(className=="actionReportZoomTree") gType= "ZT";
	else if(className=="actionWaterfall") gType= "WF";
	else if(className=="actionFunnelChart") gType= "FUN";
	else if(className=="actionCalendar") gType= "Cal";
	else if(className=="actionReportSVG") gType= "SVG";
	else if(className=="actionReportStatusBar") gType= "A";
	else if(className=="actionReportTraffic") gType= "F";
	else if(className=="actionReportDataTable") gType= "DT";
	return gType;
}