| แสดงข้อมูลแผนดำเนินการรายปี |
| ปีงบประมาณ |
จำนวนแผนงาน (ข้อย่อย) ทั้งหมด / ปี |
fetchArray($result) ) {
$Budget_Year = $rs['Budget_Year'];
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
 |
|
execQuery($query2);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result2);
echo $countnum;
?> |
| ทั้งหมด ปี |
| ";
// Fetch all factory records
$strQuery = " SELECT * FROM $myTable GROUP BY $myTablePK ";
$result111 = $dbObj->execQuery($strQuery);
//Iterate through each factory
if ($result111) {
while( $rs111 = $dbObj->fetchArray($result111) ) {
$strQuery = " SELECT * FROM $myTable2 WHERE $myTablePK='$rs111[Budget_Year]' ";
$result222 = $dbObj->execQuery($strQuery);
$numAmt = $dbObj->_numrows;
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|