/*Data Format:
Decided upon on one common data store as makes intergrating pieChart, dataTable and barChart classes easier.
The data is stored as follows (in a cross tabular format):

chartData.rowLabels == an Array of strings of all row names
chartData.colLabels == an Array of string of all col names
chartData.tableColNames == an Array of strings of col names of non x-tab data
chartData.cols == no. of cols for x-tab data
chartData.rows == no. of rows for x-tab data
chartData.colours == an Array of random colours to use for pieChart, barChart etc.

chartData.row == an Array of rowObjects --> values == an Array of values for that row
											txt == an Array of strings of items (i.e contains acutal items/band names)
											name == string of the row name
											percs == an Array of percentage values (for xTab table) for that row
											angles == an Array of angles of percentages (for pie chart) for that row
											total == total of values for that row
											
chartData.col == an Array of colObjects --> SAME AS ABOVE BUT FOR COLS NOT ROWS 
											(Data repition but allows to edit data along both rows and cols:
											I can ask for the chartData.col[1].values and return all values for that col
											Likewise i can ask for chartData.row[1] and return all values for that row)
*/
											


import mx.data.components.*; //Import the components class so can refer to dataSet and XMLConnector components
import Math2; //Import the math2 class

class XTabData {
	
static var chartData:Object = new Object(); //Static variable for storing the data


static function getRandomData(items_ds:DataSet,items_xmlcon:XMLConnector) {
	//INIT OBJECT PROPERTIES
	var rows = 0;
	var cols = 0;
	var tableCols = 0;
	chartData.rowLabels = new Array();
	chartData.colLabels = new Array();
	chartData.tableColNames = new Array();
	chartData.rows = 0;
	chartData.cols = 0;
	chartData.colours = new Array();
	chartData.row = new Array();
	chartData.col = new Array();
	chartData.dataGridItems = new Array();
	
	//LOAD ROW LABEL NAMES FROM XML
	for(var i in items_xmlcon.results.firstChild.firstChild.attributes){ //Loop through attributes in the xml object
		var temp = items_xmlcon.results.firstChild.firstChild.attributes; //Reference to all the attributes in the xml object
		chartData.rowLabels[chartData.rows] = eval("temp."+i); //Combine the xml object with the specific attribute name (i) and evaluate
		chartData.rows++; //Save the row label and update number of rows
	}
	//LOAD COL LABEL NAMES FROM XML - SAA but for columns
	for(var i in items_xmlcon.results.firstChild.childNodes[1].attributes){
		var temp = items_xmlcon.results.firstChild.childNodes[1].attributes;
		chartData.colLabels[chartData.cols] = eval("temp."+i);
		chartData.cols++;
	}
	
	//LOAD NON X-TAB COL NAMES FROM XML - SAA but for non x-tab column names
	for(var i in items_xmlcon.results.firstChild.childNodes[2].attributes){
		var temp = items_xmlcon.results.firstChild.childNodes[2].attributes;
		chartData.tableColNames[tableCols] = eval("temp."+i);
		tableCols++;
	}
	
	//For each row
	for (var i=0; i<chartData.rows; i++) 
	{
		//Defined a new rowObject and init properties
		var rowObject:Object = new Object();
		rowObject.name = chartData.rowLabels[i];
		rowObject.txt = new Array();
		rowObject.values = new Array();
		rowObject.percs = new Array();
		rowObject.angles = new Array();
		rowObject.total = 0;
		for (var j=0; j<chartData.cols; j++) 
		{
			rowObject.txt[j] = " ";
			rowObject.values[j] = 0;//Math.round(range[0] + Math.random() * (range[1] - range[0]));
			rowObject.percs[j] = 0;
			rowObject.angles[j] = 0;
			
			//rowObject.total += rowObject.values[j];
		}
		
		//Push the rowObject onto the row array
		chartData.row[i] = rowObject;
	}
	
	//For each column
	for (var j=0; j<chartData.cols; j++) 
	{
		//Defined a new colObject and init it's properties
		var colObject:Object = new Object();
		colObject.name = chartData.colLabels[j];
		colObject.txt = new Array();
		colObject.values = new Array();
		colObject.percs = new Array();
		colObject.angles = new Array();
		colObject.total = 0;
		
		for (var i=0; i<chartData.rows; i++) 
		{
			colObject.txt[i] = "";
			colObject.values[i] = 0;//Math.round(range[0] + Math.random() * (range[1] - range[0]));
			colObject.percs[i] = 0;
			colObject.angles[i] = 0;
			
			//colObject.total += colObject.values[j];
		}

		//Push the colObject onto the col array
		chartData.col[j] = colObject;
	}
	
	//Get the xml schema field names (i.e. item, rowVar, colVar)
	var inputDataCols:Array = new Array();
	for (var p in items_ds.currentItem) {
		inputDataCols.push(p);
	}
	inputDataCols.reverse(); //Reverse, sa for...in statement reads backwards
	inputDataCols.pop(); //Remove default null value
	
	//For the number of data items in the dataset
	for (var i:Number = 0; i<items_ds.items.length; i++) {
		//Create a temp item of data item no. i in the dataset
		var item = items_ds.items[i];
		//Create a set of temp vars containing the individual values of that particular instance
		//Including the item name, the rowVar value and colVar value
		var tempItem = eval("item." + String(inputDataCols[0]));
		var tempRow = eval("item." + String(inputDataCols[1]));
		//var tempCol = eval("item." + String(inputDataCols[2]));
		var tempCol = chartData.colLabels[random(chartData.cols)]; //Assign a random column position to the data item
		//Init temp var for storing position on array
		
		var tempR:Number=0;
		var tempC:Number=0;
		
		//Check which row the item belongs to and store position
		for (var j:Number = 0; j<chartData.rows; j++) {
			if (tempRow == chartData.rowLabels[j]) {
				tempR = j;
				break;
			}
		}
		//Check wich col the item belongs to and store position
		for (var k:Number = 0; k<chartData.cols; k++) {
			if (tempCol == chartData.colLabels[k]) {
				tempC = k;
				break;
			}
		}
		
		//Push item onto the chartData
			chartData.dataGridItems[i] = {item:tempItem, rowVar:tempRow, colVar:tempCol, posRow:tempR, posCol:tempC};
			chartData.row[tempR].txt[tempC] += "\r" + tempItem;
			chartData.col[tempC].txt[tempR] += "\r" + tempItem;
			chartData.row[tempR].values[tempC] ++;
			chartData.col[tempC].values[tempR] ++;
			chartData.row[tempR].total ++;
			chartData.col[tempC].total ++;
			chartData.row[tempR].name = tempRow;
			chartData.col[tempC].name = tempCol;
			//chartData.rowLabels[tempR] = tempRow;
			//chartData.colLabels[tempC] = tempCol;
	}
	
	//Calculate percentages from data
	for (var i=0; i<chartData.rows; i++) {
		for (var j=0; j<chartData.cols; j++) {
			chartData.row[i].percs[j] = Math.round(chartData.row[i].values[j]/chartData.row[i].total*10000) /100;
			chartData.col[j].percs[i] = Math.round(chartData.col[j].values[i]/chartData.col[j].total*10000) /100;
		}
	}
	
	//Calculate angles from data
	for (var i=0; i<chartData.rows; i++) {
		for (var j=0; j<chartData.cols; j++) {
			chartData.row[i].angles[j] = Math.round(chartData.row[i].percs[j] * 3.6) + chartData.row[i].angles[j-1];
			chartData.col[j].angles[i]= Math.round(chartData.col[j].percs[i] * 3.6) + chartData.col[j].angles[i-1];
			if (j==0) {
				chartData.row[i].angles[j] = Math.round(chartData.row[i].percs[j] * 3.6);
			}
			if(i==0) {
				chartData.col[j].angles[i]= Math.round(chartData.col[j].percs[i] * 3.6);
			}
		}
	}
	
	//Calculate a random set of colours for number of cols in the dataset
	var barColours:Array = new Array();
	for (var i:Number = 0; i<chartData.cols;i++) {
		var newColour = Math.round( Math.random()*0xFFFFFF );
		barColours[i] = newColour;
	}
	chartData.colours = barColours;
	
	//return the data
	return chartData;
}











static function getData(items_ds:DataSet,items_xmlcon:XMLConnector) {
	//INIT OBJECT PROPERTIES
	var rows = 0;
	var cols = 0;
	var tableCols = 0;
	chartData.rowLabels = new Array();
	chartData.colLabels = new Array();
	chartData.tableColNames = new Array();
	chartData.rows = 0;
	chartData.cols = 0;
	chartData.colours = new Array();
	chartData.row = new Array();
	chartData.col = new Array();
	
	//LOAD ROW LABEL NAMES FROM XML
	for(var i in items_xmlcon.results.firstChild.firstChild.attributes){
		var temp = items_xmlcon.results.firstChild.firstChild.attributes;
		chartData.rowLabels[chartData.rows] = eval("temp."+i);
		chartData.rows++;
	}
	//LOAD COL LABEL NAMES FROM XML
	for(var i in items_xmlcon.results.firstChild.childNodes[1].attributes){
		var temp = items_xmlcon.results.firstChild.childNodes[1].attributes;
		chartData.colLabels[chartData.cols] = eval("temp."+i);
		chartData.cols++;
	}
	
	//LOAD NON X-TAB COL NAMES FROM XML
	for(var i in items_xmlcon.results.firstChild.childNodes[2].attributes){
		var temp = items_xmlcon.results.firstChild.childNodes[2].attributes;
		chartData.tableColNames[tableCols] = eval("temp."+i);
		tableCols++;
	}
	
	//For each row
	for (var i=0; i<chartData.rows; i++) 
	{
		//Defined a new rowObject and init properties
		var rowObject:Object = new Object();
		rowObject.name = "";
		rowObject.txt = new Array();
		rowObject.values = new Array();
		rowObject.percs = new Array();
		rowObject.angles = new Array();
		for (var j=0; j<chartData.cols; j++) 
		{
			rowObject.txt[j] = "";
			rowObject.values[j] = 0;
			rowObject.percs[j] = 0;
			rowObject.angles[j] = 0;
		}
		rowObject.total = 0;
		
		//Push the rowObject onto the row array
		chartData.row[i] = rowObject;
	}
	
	//For each column
	for (var j=0; j<chartData.cols; j++) 
	{
		//Defined a new colObject and init it's properties
		var colObject:Object = new Object();
		colObject.name = "";
		colObject.txt = new Array();
		colObject.values = new Array();
		colObject.percs = new Array();
		colObject.angles = new Array();
		for (var i=0; i<chartData.rows; i++) 
		{
			colObject.txt[i] = "";
			colObject.values[i] = 0;
			colObject.percs[i] = 0;
			colObject.angles[i] = 0;
		}
		colObject.total = 0;

		//Push the colObject onto the col array
		chartData.col[j] = colObject;
	}
	
	//Get the xml schema field names (i.e. item, rowVar, colVar)
	var inputDataCols:Array = new Array();
	for (var p in items_ds.currentItem) {
		inputDataCols.push(p);
	}
	inputDataCols.reverse(); //Reverse, sa for...in statement reads backwards
	inputDataCols.pop(); //Remove default null value
	
	//For the number of data items in the dataset
	for (var i:Number = 0; i<items_ds.items.length; i++) {
		//Create a temp item of data item no. i in the dataset
		var item = items_ds.items[i];
		//Create a set of temp vars containing the individual values of that particular instance
		//Including the item name, the rowVar value and colVar value
		var tempItem = eval("item." + String(inputDataCols[0]));
		var tempRow = eval("item." + String(inputDataCols[1]));
		var tempCol = eval("item." + String(inputDataCols[2]));
		//Init temp var for storing position on array
		var tempR:Number=0;
		var tempC:Number=0;
		
		//Check which row the item belongs to and store position
		for (var j:Number = 0; j<chartData.rows; j++) {
			if (tempRow == chartData.rowLabels[j]) {
				tempR = j;
				break;
			}
		}
		//Check wich col the item belongs to and store position
		for (var k:Number = 0; k<chartData.cols; k++) {
			if (tempCol == chartData.colLabels[k]) {
				tempC = k;
				break;
			}
		}
		
		//Push item onto the chartData
			chartData.row[tempR].txt[tempC] += "\r" + tempItem;
			chartData.col[tempC].txt[tempR] += "\r" + tempItem;
			chartData.row[tempR].values[tempC] ++;
			chartData.col[tempC].values[tempR] ++;
			chartData.row[tempR].total ++;
			chartData.col[tempC].total ++;
			chartData.row[tempR].name = tempRow;
			chartData.col[tempC].name = tempCol;
			//chartData.rowLabels[tempR] = tempRow;
			//chartData.colLabels[tempC] = tempCol;
	}
	
	//Calculate percentages from data
	for (var i=0; i<chartData.rows; i++) {
		for (var j=0; j<chartData.cols; j++) {
			chartData.row[i].percs[j] = Math.round(chartData.row[i].values[j]/chartData.row[i].total*10000) /100;
			chartData.col[j].percs[i] = Math.round(chartData.col[j].values[i]/chartData.col[j].total*10000) /100;
		}
	}
	
	//Calculate angles from data
	for (var i=0; i<chartData.rows; i++) {
		for (var j=0; j<chartData.cols; j++) {
			chartData.row[i].angles[j] = Math.round(chartData.row[i].percs[j] * 3.6) + chartData.row[i].angles[j-1];
			chartData.col[j].angles[i]= Math.round(chartData.col[j].percs[i] * 3.6) + chartData.col[j].angles[i-1];
			if (j==0) {
				chartData.row[i].angles[j] = Math.round(chartData.row[i].percs[j] * 3.6);
			}
			if(i==0) {
				chartData.col[j].angles[i]= Math.round(chartData.col[j].percs[i] * 3.6);
			}
		}
	}
	
	//Calculate a random set of colours for number of cols in the dataset
	var barColours:Array = new Array();
	for (var i:Number = 0; i<chartData.cols;i++) {
		var newColour = Math.round( Math.random()*0xFFFFFF );
		barColours[i] = newColour;
	}
	chartData.colours = barColours;
	
	//return the data
	return chartData;
}
}