"; echo "


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

"; echo ""; exit(); } else { /** Configuration */ require_once( "../configuration.php" ); require_once( $_Config_absolute_path . "/includes/framework.php" ); require_once( "../includes/Function.php" ); /** Create Database Object */ $dbObj = new DBConn; /** Config Table for This Page */ $myTable = "project_mission"; $myTable1 = "faculty_tb"; $myTablePK = "missId"; //=== projectstdplan_tb // $query = " SELECT * FROM $myTable1 WHERE Faculty_code='$Faculty_code' "; $result1 = $dbObj->execQuery($query); $rs1 = $dbObj->fetchArray($result1); $query = " SELECT * FROM $myTable WHERE Budget_Year='$Budget_Year' "; $result = $dbObj->execQuery($query); $rs01 = $dbObj->fetchArray($result); $num = $dbObj->_numrows; /** Paging */ $page = $_GET['page']; if( $page == "" ) { $page = 1; } /** จำนวนข้อมูล ต่อ 1 หน้า */ $perpage = $_REQUEST['perpage']; if( $perpage == "" ) { $perpage = 50; } /** Parameters */ $params = "Budget_Year=$Budget_Year&Faculty_code=$Faculty_code"; } # else ?> ข้อมูลแผนดำเนินงานและรายงาน : ข้อมูลแผนดำเนินการ รายปีงบประมาณ
execQuery($query); $numrows = $dbObj->_numrows; /** Paging */ $display = ( !isset ($_GET['page']) ) ? 1 : $_GET['page']; $start = ( ($display * $limit) - $limit ); /** Paging */ if( isset($_GET['OrderBy']) ) { $query = " SELECT * FROM $myTable WHERE Budget_Year='$Budget_Year' ORDER BY $OrderBy $ASCDESC "; } elseif( !isset($_GET['OrderBy']) ) { $query = " SELECT * FROM $myTable WHERE Budget_Year='$Budget_Year' ORDER BY $myTablePK ASC "; } $query .= " LIMIT $start, $limit "; $result = $dbObj->execQuery($query); ?>
0 ) { ?> fetchArray($result) ) { $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?> fetchArray($result3) ) { */ $query2 = " SELECT * FROM project_submission WHERE missId= ' ".$rs['missId']." ' "; $result2 = mysql_query($query2); while($rss = mysql_fetch_array($result2)){ $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?>
แผนปฏิบัติการตามพันธกิจ execQuery($sql1); $rs1 = $dbObj->fetchArray($result1); echo $rs1['Faculty_name']; ?> ปีงบประมาณ
ลำดับ พันธกิจ execQuery($sql1); $rs1 = $dbObj->fetchArray($result1); echo $rs1['Faculty_name']; ?> เงินที่ตั้ง - เงินที่ใช้ = เงินคงเหลือ จำนวน
โครงการ/
กิจกรรม
execQuery($sql); $rs5 = $dbObj->fetchArray($result5); echo number_format($rs5['total'],2,'.',','); ?> execQuery($sql); $rs6 = $dbObj->fetchArray($result6); //echo number_format($rs5['total'],2,'.',','); $sql = " SELECT SUM(Budget_total) AS SumB1 FROM project_type_tb WHERE Budget_Year='$Budget_Year' AND Faculty_code='$Faculty_code' "; $result7 = $dbObj->execQuery($sql); $rs7 = $dbObj->fetchArray($result7); //echo number_format($rss3['SumB1'],2,'.',','); $per1 = ( $rs6['total'] * 100 ) / $rs7['SumB1'] ; echo number_format($per1,2,'.','.') ." %"; ?>
  execQuery($sql); $rs3 = $dbObj->fetchArray($result3); echo number_format($rs3['SumB1'],2,'.',','); ?> - execQuery($sql); $rs6= $dbObj->fetchArray($result6); echo number_format($rs6['SumB6'],2,'.',','); ?> = /
จำนวนเงิน execQuery($sql3); $rss3 = $dbObj->fetchArray($result3); echo number_format($rss3['SumB1'],2,'.',','); ?> - execQuery($sql); $rss6= $dbObj->fetchArray($result6); echo number_format($rss6['SumB6'],2,'.',','); ?> =
 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>