";
// Fetch all factory records
$strQuery = " SELECT * FROM project_mission Where Budget_Year ='$Budget_Year' ";
$result11 = $dbObj->execQuery($strQuery);
//Iterate through each factory
if ($result11) {
while( $rs = $dbObj->fetchArray($result11) ) {
/*
$sql3 = "SELECT SUM(Budget_total) AS total FROM project_type_tb pt ,project_submission ps WHERE ps.missId='$rs[missId]' and pt.subId = ps.subId and pt.Budget_Year='$Budget_Year' ";
$result3 = $dbObj->execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
*/
$sql = " SELECT SUM(Budget_total) AS total FROM project_type_tb pt ,project_submission ps WHERE ps.missId='$rs[missId]' and pt.subId = ps.subId and pt.Budget_Year='$Budget_Year' ";
$result6 = $dbObj->execQuery($sql);
$rs6 = $dbObj->fetchArray($result6);
//echo number_format($rs5['total'],2,'.',',');
$sql = " SELECT SUM(Budget_total) AS SumB1 FROM project_type_tb WHERE Budget_Year='$Budget_Year' ";
$result7 = $dbObj->execQuery($sql);
$rs7 = $dbObj->fetchArray($result7);
//echo number_format($rss3['SumB1'],2,'.',',');
$Per = ( $rs6['total'] * 100 ) / $rs7['SumB1'] ;
$strXML .= " ";
// $strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Pie3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|