"; echo "


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

"; echo ""; exit(); } else { /** Configuration */ require_once( "../configuration.php" ); require_once( $_Config_absolute_path . "/includes/framework.php" ); require_once( "../include/Function.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 = "faculty_tb"; $myTable3PK = "Faculty_code"; //=== salary_repot_tb $query = " SELECT * FROM $myTable2 WHERE Budget_Year='$Budget_Year' Group By Faculty_code "; $result = $dbObj->execQuery($query); $num = $dbObj->_numrows; // $query = " SELECT * FROM $myTable2 WHERE Budget_Year='$Budget_Year' "; // $result11 = $dbObj->execQuery($query); // $rss = $dbObj->fetchArray($result11); // $num = $dbObj->_numrows; /** Parameters */ $params = "Budget_Year=$Budget_Year"; } # else ?> ข้อมูลทั่วไปบุคลากร - ข้อมูลการแผนดำเนินการ
‹ ย้อนกลับ
 
fetchArray($result) ) { $Budget_Year = $rs['Budget_Year']; $Faculty_code = $rs['Faculty_code']; $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?>
ปีงบประมาณ execQuery($query3); $rs3 = $dbObj->fetchArray($result3); $dbObj->freeresult($result3); echo $rs3['Budget_Year']; ?> จำนวนเงิน ทั้งหมด / ปี
execQuery($query1); $rs1 = $dbObj->fetchArray($result1); echo $rs1['Faculty_name']; ?> execQuery($sql3); $rs3 = $dbObj->fetchArray($result3); echo number_format($rs3['SumB1'],2,'.',','); ?>
ทั้งหมด หน่วยงาน
 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>