pivotdesigner.js

its a varypowrerfull javascript tool

/*
 *  $Id: pivotdesigner.js,v 1.1 2006/08/07 10:41:25 source Exp $
 *
 *  This file is part of the OpenLink Software Ajax Toolkit (OAT) project.
 *
 *  Copyright (C) 2006 Ondrej Zara and OpenLink Software
 *
 *  See LICENSE file for details.
 */
function pivot_design_prepare() {
	/* create pivot design form based on pivot_data object */
	OAT.Dom.clear("pivot_design_headercol");
	OAT.Dom.clear("pivot_design_headerrow");
	OAT.Dom.clear("pivot_design_data");
	OAT.Dom.clear("pivot_design_page");
	OAT.Dom.clear("pivot_design_base");
	pivot_gd.clearSources();
	
	var empty = {
		"pivot_design_headercol":"[drag aggregate columns here]",
		"pivot_design_headerrow":"[drag aggregate columns here]",
		"pivot_design_data":"[drag data column here]",
		"pivot_design_page":"[drag paging columns here]",
		"pivot_design_base":"[unused columns]"
		}
	
	for (p in empty) { $(p).innerHTML = empty[p]; }
	OAT.Dom.clear("pivot_design_base");
	
	var process = function(elm) { }
	
	var from_array = function(arr,val) {
		var index = -1;
		for (var i=0;i<arr.length;i++) if (arr[i] == val) { index = i; }
		if (index == -1) { return; }
		arr.splice(index,1);
	}
	
	var move = function(elm,index,source,target) {
		if (source == target) { return; }
		if (target.innerHTML == empty[target.id]) { OAT.Dom.clear(target); } /* clear default texts */
		switch (source.id) {
			case "pivot_design_headercol":
				from_array(pivot_data.headerColIndexes,index);
			break;
			case "pivot_design_headerrow":
				from_array(pivot_data.headerRowIndexes,index);
			break;
			case "pivot_design_data":
				pivot_data.dataColumnIndex = -1;
			break;
			case "pivot_design_page":
				from_array(pivot_data.filterIndexes,index);
			break;
		}
		
		switch (target.id) {
			case "pivot_design_headercol":
				pivot_data.headerColIndexes.push(index);
			break;
			case "pivot_design_headerrow":
				pivot_data.headerRowIndexes.push(index);
			break;
			case "pivot_design_data":
				if (target.childNodes.length) { $("pivot_design_base").appendChild(target.childNodes[0]); }
				pivot_data.dataColumnIndex = index;
			break;
			case "pivot_design_page":
				pivot_data.filterIndexes.push(index);
			break;
		} /* switch */
		
		target.appendChild(elm);
		if (source.childNodes.length == 0) { source.innerHTML = empty[source.id]; }
	}
	
	var register = function(div,index) {
		return function(target,x,y) {
			move(div,index,div.parentNode,target);
		} /* callback */
	} /* register */
	
	if (pivot_data.headerColIndexes.length) { OAT.Dom.clear("pivot_design_headercol"); }
	if (pivot_data.headerRowIndexes.length) { OAT.Dom.clear("pivot_design_headerrow"); }
	if (pivot_data.filterIndexes.length) { OAT.Dom.clear("pivot_design_page"); }

	for (var i=0;i<pivot_data.headerRow.length;i++) {
		var div = OAT.Dom.create("div",{margin:"1px",padding:"2px",backgroundColor:"#eee",border:"1px dotted #000",cursor:"pointer"});
		div.innerHTML = pivot_data.headerRow[i];
		$("pivot_design_base").appendChild(div);
		var ref = register(div,i);
		pivot_gd.addSource(div,process,ref);

		/* is this cell actually positioned in pivot? */
		if (i == pivot_data.dataColumnIndex) { OAT.Dom.clear("pivot_design_data"); $("pivot_design_data").appendChild(div); }

		for (var j=0;j<pivot_data.headerColIndexes.length;j++) if (pivot_data.headerColIndexes[j] == i) {
			$("pivot_design_headercol").appendChild(div);
		}
		for (var j=0;j<pivot_data.headerRowIndexes.length;j++) if (pivot_data.headerRowIndexes[j] == i) {
			$("pivot_design_headerrow").appendChild(div);
		}
		for (var j=0;j<pivot_data.filterIndexes.length;j++) if (pivot_data.filterIndexes[j] == i) {
			$("pivot_design_page").appendChild(div);
		}
	}

}

function pivot_refresh() {
	/* refresh pivot data */
	var callback = function(tmp) {
		var body = tmp[1];   /* pole poli, radku */
		pivot_data.dataRows = body;
		pivot.go();
	}
	if (pivot_data.query != "") { OAT.Xmla.execute(callback); }
}

function pivot_create() {
	/* create / update pivot based on pivot_data object */
	if (!(pivot_data.headerColIndexes.length + pivot_data.headerRowIndexes.length)) {
		alert('You must select at least one aggregate column');
		return;
	}
	if (pivot_data.dataColumnIndex == -1) {
		alert('You must select at least one data column');
		return;
	}
	dialogs.pivot_design.hide();
	OAT.Ajax.startRef();
	pivot = new OAT.Pivot("pivot_content","pivot_chart","pivot_page",pivot_data.headerRow,pivot_data.dataRows,
						pivot_data.headerRowIndexes,pivot_data.headerColIndexes,
						pivot_data.filterIndexes,pivot_data.dataColumnIndex);
	OAT.Ajax.endRef();
	tab.go(3);
}

function pivot_design_load(xmlStr) {
	var xml = OAT.Xml.getTreeString(xmlStr);
	var root = xml.documentElement;
	pivot_data.headerRowIndexes = [];
	var tmp = root.getElementsByTagName("headerRowIndexes")[0];
	var values = tmp.getElementsByTagName("value");
	for (var i=0;i<values.length;i++) { pivot_data.headerRowIndexes.push(OAT.Xml.textValue(values[i])); }
	pivot_data.headerColIndexes = [];
	var tmp = root.getElementsByTagName("headerColIndexes")[0];
	var values = tmp.getElementsByTagName("value");
	for (var i=0;i<values.length;i++) { pivot_data.headerColIndexes.push(OAT.Xml.textValue(values[i])); }
	pivot_data.filterIndexes = [];
	var tmp = root.getElementsByTagName("filterIndexes")[0];
	var values = tmp.getElementsByTagName("value");
	for (var i=0;i<values.length;i++) { pivot_data.filterIndexes.push(OAT.Xml.textValue(values[i])); }
	pivot_data.dataColumnIndex = OAT.Xml.textValue(root.getElementsByTagName("dataColumnIndex")[0]);
	
	OAT.Xmla.query = OAT.Xml.textValue(root.getElementsByTagName("query")[0]);
	pivot_data.query = OAT.Xmla.query;
	var callback = function(pole) {
		pivot_data.headerRow = pole[0];
		pivot_data.dataRows = pole[1];
		pivot_create();
	}
	OAT.Xmla.execute(callback);
}