Viewing file: InsertHreduhis.php (8.06 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | ";
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" );
require_once( "../includes/cURL.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Receive values */
$Major = htmlspecialchars( trim( $_POST['Major'] ) );
$qname = htmlspecialchars( trim( $_POST['qname'] ) );
$cname = htmlspecialchars( trim( $_POST['cname'] ) ); // เรื่อง
$startdeerdate = dmyE2ymdE2($_REQUEST["mDate1"]);
$enddeerdate = dmyE2ymdE2($_REQUEST["mDate2"]);
$levelHig = (isset($_REQUEST["levelHig"]))?$_REQUEST["levelHig"]:"0";
$levelPos = (isset($_REQUEST["levelPos"]))?$_REQUEST["levelPos"]:"0";
$eyear = $_REQUEST["mDate2_Year_ID"];
if(isset($_REQUEST["HiseduId"])){
$sql = "SELECT * FROM dev_hreduhis Where HiseduId = '".$_REQUEST["HiseduId"]."'" ;
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
}
if($_REQUEST["qflag"] == "1"){
if(isset($_REQUEST["levelHig"]) && $_REQUEST["levelHig"] == "1"){
$sql = "UPDATE dev_hreduhis SET levelHig = '0' WHERE perid = '".$_REQUEST["perid"]."'";
mysql_query($sql);
}
if(isset($_REQUEST["levelPos"]) && $_REQUEST["levelPos"] == "1"){
$sql = "UPDATE dev_hreduhis SET levelPos = '0' WHERE perid = '".$_REQUEST["perid"]."'";
mysql_query($sql);
}
if($num_rows){
$rs = mysql_fetch_object($result);
$query =" UPDATE dev_hreduhis SET levelPos='$levelPos' , levelHig='$levelHig' , levelcode='$levelcode' , qcode='$qcode' , qname='$qname' , Major='$Major' , institute ='$institute' , univId='$univId' , countrycode ='$countrycode' , startdeerdate='$startdeerdate' , enddeerdate='$enddeerdate' , eyear='$eyear' , qflag='$qflag' , mflag='$mflag' Where HiseduId ='$HiseduId' and perid='$perid' " ;
$result = $dbObj->runQuery($query);
$dbObj->freeresult($result);
$res = hrEduCurl($rs->HiseduId, $perid, $levelPos, $levelHig, $levelcode, $qcode, $qname, $Major, $institute, $univId, $countrycode, $startdeerdate, $enddeerdate, $eyear, $qflag, $mflag);
}
else{
InsertHreduhis( $perid , $levelPos , $levelHig , $levelcode , $qcode, $qname , $Major , $institute , $univId, $countrycode , $startdeerdate, $enddeerdate , $eyear , $qflag , $mflag );
$res = hrEduCurl(mysql_insert_id(), $perid, $levelPos, $levelHig, $levelcode, $qcode, $qname, $Major, $institute, $univId, $countrycode, $startdeerdate, $enddeerdate, $eyear, $qflag, $mflag);
}
}
else{
if($num_rows){
$rs = mysql_fetch_object($result);
$levelPos = "0";
$levelHig = "0";
$query =" UPDATE dev_hreduhis SET levelPos='$levelPos' , levelHig='$levelHig' , levelcode='$levelcode' , qcode='$qcode' , qname='$qname' , Major='$Major' , institute ='$institute' , univId='$univId' , countrycode ='$countrycode' , startdeerdate='$startdeerdate' , enddeerdate='$enddeerdate' , eyear='$eyear' , qflag='$qflag' , mflag='$mflag' Where HiseduId ='$HiseduId' and perid='$perid' " ;
$result = $dbObj->runQuery($query);
$dbObj->freeresult($result);
$res = hrEduCurl($rs->HiseduId, $perid, $levelPos, $levelHig, $levelcode, $qcode, $qname, $Major, $institute, $univId, $countrycode, $startdeerdate, $enddeerdate, $eyear, $qflag, $mflag);
}
else{
InsertHreduhis( $perid , $levelPos , $levelHig , $levelcode , $qcode, $qname , $Major , $institute , $univId, $countrycode , $startdeerdate, $enddeerdate , $eyear , $qflag , $mflag );
$res = hrEduCurl(mysql_insert_id(), $perid, $levelPos, $levelHig, $levelcode, $qcode, $qname, $Major, $institute, $univId, $countrycode, $startdeerdate, $enddeerdate, $eyear, $qflag, $mflag);
}
}
//--- Table --> 'dev_his'
/* $sql = "SELECT * FROM dev_hreduhis Where HiseduId ='$HiseduId' and perid='$perid'" ;
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if($num_rows){
$rs = mysql_fetch_object($result);
$query =" UPDATE dev_hreduhis SET levelPos='$levelPos' , levelHig='$levelHig' , levelcode='$levelcode' , qcode='$qcode' , qname='$qname' , Major='$Major' , institute ='$institute' , univId='$univId' , countrycode ='$countrycode' , startdeerdate='$startdeerdate' , enddeerdate='$enddeerdate' , eyear='$eyear' , qflag='$qflag' , mflag='$mflag' Where HiseduId ='$HiseduId' and perid='$perid' " ;
$result = $dbObj->runQuery($query);
$dbObj->freeresult($result);
$res = hrEduCurl($rs->HiseduId, $perid, $levelPos, $levelHig, $levelcode, $qcode, $qname, $Major, $institute, $univId, $countrycode, $startdeerdate, $enddeerdate, $eyear, $qflag, $mflag);
}
else{
InsertHreduhis( $perid , $levelPos , $levelHig , $levelcode , $qcode, $qname , $Major , $institute , $univId, $countrycode , $startdeerdate, $enddeerdate , $eyear , $qflag , $mflag );
$res = hrEduCurl(mysql_insert_id(), $perid, $levelPos, $levelHig, $levelcode, $qcode, $qname, $Major, $institute, $univId, $countrycode, $startdeerdate, $enddeerdate, $eyear, $qflag, $mflag);
}*/
} # else
?>
ข้อมูลทั่วไปบุคลากร - ข้อมูลการพัฒนาบุคลากร - เพิ่มข้อมูลประวัติการพัฒนาตนเอง
freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |