| แสดงข้อมูลแผนการดำเนินการ แยกตามหน่วยงาน/ภาคฝ่าย |
| ปีงบประมาณ
execQuery($query3);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result3);
echo $rs3['Budget_Year'];
?> |
จำนวนเงิน ทั้งหมด / ปี |
fetchArray($result) ) {
$Budget_Year = $rs['Budget_Year'];
$Faculty_code = $rs['Faculty_code'];
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
 |
รหัส หน่วยงาน execQuery($query1);
$rs1 = $dbObj->fetchArray($result1);
echo $rs1['Faculty_name'];
?> |
execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
echo number_format($rs3['SumB1'],2,'.',',');
?>
|
| ทั้งหมด หน่วยงาน |
| ";
// Fetch all factory records
$strQuery = " SELECT * FROM $myTable2 WHERE Budget_Year='$Budget_Year' GROUP BY Faculty_code ";
$result111 = $dbObj->execQuery($strQuery);
//Iterate through each factory
if ($result111) {
while( $rs111 = $dbObj->fetchArray($result111) ) {
$query112 = " SELECT * FROM $myTable3 WHERE Faculty_code='$rs111[Faculty_code]' ";
$result112 = $dbObj->execQuery($query112);
$rs112 = $dbObj->fetchArray($result112);
$sql3 = " SELECT SUM(Budget_total) AS SumB1 FROM $myTable2 WHERE Budget_Year='$rs111[Budget_Year]' AND Faculty_code='$rs111[Faculty_code]' ";
$result3 = $dbObj->execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("charts/Pie3D.swf", "", $strXML, "", 760, 375, false, false);
?> |
|