"; echo "


กรุณาทำการ Login ก่อน

"; echo ""; exit(); } else { /** Check Session User Login */ /** Configuration */ require_once( "../configuration.php" ); require_once( $_Config_absolute_path . "/includes/framework.php" ); require_once( "../includes/Function.php" ); /** Chart */ include ("../includes/charts.php"); /** Create Database Object */ $dbObj = new DBConn; /** Config Table for This Page */ $myTable = "projectstdplan_tb"; $myTablePK = "Budget_Year"; $myTable2 = "project_type_tb"; $myTable2PK = "ProjectId"; $myTable3 = "project_tb"; $myTable3PK ="Project_code"; /* $queryUsr = " SELECT * FROM user_tb WHERE Username='$Username' "; $resultUsr = $dbObj->execQuery($queryUsr); $rss = $dbObj->fetchArray($resultUsr); */ //=== $query = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result = $dbObj->execQuery($query); $num = $dbObj->_numrows; } # else ?> ข้อมูลแผนดำเนินงานและรายงาน : ข้อมูลแผนดำเนินการ รายปีงบประมาณ
หน้าหลัก » ข้อมูลแผนภูมิสารสนเทศแผนดำเนินการ แสดงรายปีงบประมาณ
'" /> '" />

"; // Fetch all factory records $strQuery = " SELECT * FROM $myTable2 GROUP BY $myTablePK "; $result111 = $dbObj->execQuery($strQuery); //Iterate through each factory if ($result111) { while( $rs111 = $dbObj->fetchArray($result111) ) { $sql3 = " SELECT SUM(Budget_total) AS SumB1 FROM $myTable2 WHERE Budget_Year='$rs111[Budget_Year]' "; $result3 = $dbObj->execQuery($sql3); $rs3 = $dbObj->fetchArray($result3); $sql4 = " SELECT SUM(Budget_use) AS SumB2 FROM $myTable3 WHERE Budget_Year='$rs111[Budget_Year]' "; $result4 = $dbObj->execQuery($sql4); $rs4 = $dbObj->fetchArray($result4); $strXML .= ""; $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); ?>

 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>