if ($result) { while ($ors = mysql_fetch_array($result)) { $indexCount++; //Create JavaScript code to add sub-array to data array //data is an array defined in JavaScript (see below) //We've added \t and \n to data so that if you View Source of the //output HTML, it will appear properly. It helps during debugging $jsVarString .= "\t\t data[" . $indexCount . "] = new Array(); \n"; //Now create second query to get date-wise details for this factory $strQuery = "select * from Factory_Output where FactoryId=" . $ors['FactoryId'] . " order by DatePro Asc"; $result2 = mysql_query($strQuery) or die(mysql_error()); if ($result2) { while ($ors2 = mysql_fetch_array($result2)) { //Put this data into JavaScript as another nested array. //Finally the array would look like data[factoryIndex][i][dataLabel/name,dataValue] $jsVarString .= "\t\t" . "data[" . $indexCount . "].push(new Array('" . datePart("d", $ors2["DatePro"]) . "/" . datePart("m", $ors2['DatePro']) . "'," . $ors2['Quantity'] . ")); \n"; } //free the resultset mysql_free_result($result2); } //Now create another query to get details for this factory $strQuery = "select sum(Quantity) as TotOutput from Factory_Output where FactoryId=" . $ors['FactoryId']; $result2 = mysql_query($strQuery) or die(mysql_error()); $ors2 = mysql_fetch_array($result2); //Generate <set name='..' value='..' link='..' /> //Note that we're setting link as updateChart(factoryIndex) - JS Function $strXML .= "<set name='" . $ors['FactoryName'] . "' value='" . $ors2['TotOutput'] . "' link='javaScript:updateChart(" . $indexCount . ")'/>"; } } //Finally, close <graph> element $strXML .= "</graph>";
//to get that factory id, get information from database and then show //a detailed chart. //Request the factory Id from Querystring $FactoryId = $_GET['FactoryId']; //Generate the chart element string $strXML = "<chart palette='2' caption='Factory " . $FactoryId . " Output ' subcaption='(In Units)' xAxisName='Date' showValues='1' labelStep='2' >"; // Connet to the DB $link = connectToDB(); //Now, we get the data for that factory $strQuery = "select * from Factory_Output where FactoryId=" . $FactoryId; $result = mysql_query($strQuery) or die(mysql_error()); //Iterate through each factory if ($result) { while ($ors = mysql_fetch_array($result)) { //Here, we convert date into a more readable form for set label. $strXML .= "<set label='" . datePart("d", $ors['DatePro']) . "/" . datePart("m", $ors['DatePro']) . "' value='" . $ors['Quantity'] . "'/>"; } } mysql_close($link); //Close <chart> element $strXML .= "</chart>"; //Create the chart - Column 2D Chart with data from strXML echo renderChart("../../FusionCharts/Column2D.swf", "", $strXML, "FactoryDetailed", 600, 300, false, false); ?> <BR/> <a class="qua qua-button" style="margin-left: 360px" href="Default.php?animate=0"><span>Back to Summary</span></a> </div> <div class="clear"></div> <p> </p>
//to get that factory id, get information from database and then show //a detailed chart. //Request the factory Id from Querystring $FactoryId = $_GET['FactoryId']; //Generate the graph element string $strXML = "<graph caption='Factory " . $FactoryId . " Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0'>"; // Connet to the DB $link = connectToDB(); //Now, we get the data for that factory $strQuery = "select * from Factory_Output where FactoryId=" . $FactoryId; $result = mysql_query($strQuery) or die(mysql_error()); //Iterate through each factory if ($result) { while ($ors = mysql_fetch_array($result)) { //Here, we convert date into a more readable form for set name. $strXML .= "<set name='" . datePart("d", $ors['DatePro']) . "/" . datePart("m", $ors['DatePro']) . "' value='" . $ors['Quantity'] . "' color='" . getFCColor() . "'/>"; } } mysql_close($link); //Close <graph> element $strXML .= "</graph>"; //Create the chart - Column 2D Chart with data from strXML echo renderChart("../../FusionCharts/FCF_Column2D.swf", "", $strXML, "FactoryDetailed", 600, 300); ?> <BR> <a href='Default.php'>Back to Summary</a> <BR><BR> <a href='../NoChart.html' target="_blank">Unable to see the chart above?</a> <H5 ><a href='../default.htm'>« Back to list of examples</a></h5> </CENTER> </BODY>