"; echo "


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

"; echo ""; exit(); } else { /** Configuration */ require_once( "../configuration.php" ); require_once( $_Config_absolute_path . "/includes/framework.php" ); require_once( "../includes/Function.php" ); require_once( "../includes/FunctionDB.php" ); /** Create Database Object */ $dbObj = new DBConn; /** Chart */ /** Config Table for This Page */ $myTable = "faculty_tb"; $myTable1 = "facultycon_tb"; $myTableFK = "conId"; $sql = "Select * From $myTable Where Faculty_code='$Faculty_code'"; $result = mysql_query($sql) or die(" Error").mysql_error(); $rss = mysql_fetch_array($result); ///////////////////////////////// $sql = "Select * From $myTable1 Where Faculty_code='$Faculty_code'"; $result1= mysql_query($sql) or die(" Error").mysql_error(); $num = $dbObj->_numrows; $row = mysql_fetch_array($result1); /** Botton Name Action */ $action = $_REQUEST['action']; $id = $_REQUEST['id']; /*if( isset($action) && !empty($action) ) { switch($action) { case "Delete" : $num = count($id); for( $i=0; $i<$num; $i++ ) { //--- tech_plan_tb $qrySel = " SELECT * FROM $myTable1 WHERE $myTableFK='$id[$i]' "; $resultSel = $dbObj->execQuery($qrySel); $rsSel = $dbObj->fetchObject($resultSel); $Faculty_code = $rsSel->Faculty_code; $qryDel = " DELETE FROM $myTable1 WHERE $myTableFK='$id[$i]' "; $resultDel = $dbObj->runQuery($qryDel); $dbObj->freeresult($resultDel); } break; } # switch } # if*/ if(isset($_REQUEST['action'])){ switch($_REQUEST['action']){ case "saveAdd" : $sql = "INSERT INTO facultycon_tb(Faculty_code, Group_name, Group_nameE) VALUES ('".$_REQUEST['Faculty_code']."', '".$_REQUEST['Group_name']."', '".$_REQUEST['Group_nameE']."')"; mysql_query($sql); $message = "เพิ่มข้อมูลกลุ่มงานเรียบร้อยแล้ว"; break; case "saveEdit" : $sql = "UPDATE facultycon_tb SET Faculty_code = '".$_REQUEST['Faculty_code']."', Group_name = '".$_REQUEST['Group_name']."', Group_nameE = '".$_REQUEST['Group_nameE']."' WHERE conId = '".$_REQUEST['conId']."'"; mysql_query($sql); $message = "แก้ไขข้อมูลกลุ่มงานเรียบร้อยแล้ว"; break; case "delete" : $sql = "DELETE FROM facultycon_tb WHERE conId = '".$_REQUEST["conId"]."'"; mysql_query($sql); $message = "ลบข้อมูลกลุ่มงานเรียบร้อยแล้ว"; break; } } } # else ?> <?=$_Config_sitename;?>
ข้อมูลกลุ่มงานใน หน่วยงาน/ฝ่าย
execQuery($query); $numrows = $dbObj->_numrows; ?> fetchArray($result) ) { $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?> freeresult($result1); ?>
  กลุ่มงาน :  ไทย: อังกฤษ: ".$row['Group_name'].((!empty($row['Group_nameE'])&&$row['Group_nameE']!="-")?" (".$row['Group_nameE'].")":"").""; } ?> " />
  กลุ่มงาน :  ไทย: อังกฤษ:  
       
         
disconn(); /** Unset Class */ unset($dbObj); ?>