<?php
//We've included ../Includes/FusionCharts.php, which contains functions
//to help us easily embed the charts.
include("../Includes/FusionCharts.php");
?>
<HTML>
<HEAD>
	<TITLE>
	FusionCharts - Array Example using Stacked Column 3D Chart
	</TITLE>
	<?php
	//You need to include the following JS file, if you intend to embed the chart using JavaScript.
	//Embedding using JavaScripts avoids the "Click to Activate..." issue in Internet Explorer
	//When you make your own charts, make sure that the path to this JS file is correct. Else, you would get JavaScript errors.
	?>	
	<SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT>
	<style type="text/css">
	<!--
	body {
		font-family: Arial, Helvetica, sans-serif;
		font-size: 12px;
	}
	-->
	</style>
</HEAD>
<BODY>

<CENTER>
<h2>FusionCharts Examples</h2>
<h4>Plotting Stacked Chart from data contained in Array.</h4>
<?php
	//In this example, we plot a Stacked chart from data contained
	//in an array. The array will have three columns - first one for Quarter Name
	//and the next two for data values. The first data value column would store sales information
	//for Product A and the second one for Product B.
		
	//Store Name of Products
	$arrData[0][1] = "Quarter 1";
	$arrData[1][1] = "Quarter 2";
	$arrData[2][1] = "Quarter 3";
	$arrData[3][1] = "Quarter 4";
	// Sales data for Product A
	$arrData[0][2] = 567500;
	$arrData[1][2] = 815300;
	$arrData[2][2] = 556800;
	$arrData[3][2] = 734500;
	// Sales data for Product B
	$arrData[0][3] = 547300;
	$arrData[1][3] = 594500;
	$arrData[2][3] = 754000;
	$arrData[3][3] = 456300;	

	//Now, we need to convert this data into multi-series XML. 
	//We convert using string concatenation.
	// $strXML - Stores the entire XML
	// $strCategories - Stores XML for the <categories> and child <category> elements
	// $strDataProdA - Stores XML for current year's sales
	// $strDataProdB - Stores XML for previous year's sales
	
	//Initialize <chart> element
	$strXML = "<chart caption='Sales' numberPrefix='$' formatNumberScale='0'>";
	
	//Initialize <categories> element - necessary to generate a stacked chart
	$strCategories = "<categories>";
	
	//Initiate <dataset> elements
	$strDataProdA = "<dataset seriesName='Product A'>";
	$strDataProdB = "<dataset seriesName='Product B'>";
	
	//Iterate through the data	
	foreach ($arrData as $arSubData) {
		//Append <category name='...' /> to strCategories
		$strCategories .= "<category name='" . $arSubData[1] . "' />";
		//Add <set value='...' /> to both the datasets
		$strDataProdA .= "<set value='" . $arSubData[2] . "' />";
		$strDataProdB .= "<set value='" . $arSubData[3] . "' />";
	}
	
	//Close <categories> element
	$strCategories .= "</categories>";
	
	//Close <dataset> elements
	$strDataProdA .= "</dataset>";
	$strDataProdB .= "</dataset>";
	
	//Assemble the entire XML now
	$strXML = $strXML . $strCategories . $strDataProdA . $strDataProdB . "</chart>";
	
	//Create the chart - Stacked Column 3D Chart with data contained in strXML
	echo renderChart("../../FusionCharts/StackedColumn3D.swf", "", $strXML, "productSales", 500, 300, false, false);
?>
<BR><BR>
<a href='../NoChart.html' target="_blank">Unable to see the chart above?</a>
</CENTER>
</BODY>
</HTML>