| แสดงข้อมูลรายรับ-จ่ายจำแนกรายปีงบประมาณ |
| ปีงบประมาณ |
จำนวนข้อมูล |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
 |
|
";
echo"ยังไม่ข้อมูล";
echo"";
}
else if ($r10 > 0)
{
echo"";
echo"$r10 ระเบียน";
echo"";
}
?>
|
| ทั้งหมด ปี |
| ";
// Fetch all factory records
$strQuery = " SELECT * FROM $myTable3 WHERE Faculty_code='$Faculty_code' GROUP BY Budget_Year ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
// $strQuery = " SELECT * FROM project_type_tb WHERE Budget_Year='$rs1[Budget_Year]' AND Faculty_code='$Faculty_code' ";
// $result2 = mysql_query($strQuery);
//$numAmt = mysql_num_rows($result2);
$sql4 = " SELECT SUM(Budget_use) AS SumB1 FROM project_type_tb WHERE Budget_Year='$rs1[Budget_Year]' AND Faculty_code='$rs1[Faculty_code]' ";
$result4 = $dbObj->execQuery($sql4);
$rs4 = $dbObj->fetchArray($result4);
$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);
?> |
|