| ปีงบประมาณ |
จำนวนเงินที่
ใช้ในการพัฒนา
|
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
$Year_std = $rs['Year_std'];
?>
|
execQuery($query);
$rs7 = $dbObj->fetchArray($result7);
$dbObj->freeresult($rs7);
echo number_format($rs7['Sum2'],2,'.',',') ;
?>
|
| สรุปยอดรวม |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo "". number_format($rs6['Sum'],2,'.',',') ."";
?>
|
| ทั้งหมด ปี |
| ";
// Fetch all factory records
$strQuery111 = " SELECT * FROM $myTable GROUP BY Year_std ";
$result111 = $dbObj->execQuery($strQuery111);
//Iterate through each factory
if( $result111 ) {
while( $rs111 = $dbObj->fetchArray($result111) ) {
$Year = $rs111['Year_std'];
$sql3 = " SELECT SUM(Day) AS Day FROM $myTable WHERE Year_std='$rs111[Year_std]' ";
$result3 = $dbObj->execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
$strXML .= "";
} # while
} # if
$dbObj->freeresult($result111);
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D or Column3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|