Viewing file: EditReAcademic.php (11.18 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/cURLRes.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Receive values */
$Research_code = trim( $_POST['Research_code'] );
$collegeCode = trim( $_POST['collegeCode'] ); // หน่วยงาน
$Research_name = trim( $_POST['Research_name'] ); // ชื่อโครงการงานวิจัย
$Branch = trim( $_POST['Branch'] ); // กลุ่มสาขาวิชาการ
$Research_type = trim( $_POST['Research_type'] );
$Budget_year = $_POST['Budget_year']; // ปีงบประมาณ
//$Year_start = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate']; // วัน/เดือน/ปีที่เริ่ม
//$Year_finish = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2']; // ปีที่แล้วเสร็จ
//$Year_sprop = $_POST['mYear3']."-".$_POST['mMonth3']."-".$_POST['mDate3']; // ปีที่แล้วเสร็จ
$Year_start = dmyE2ymdT($_REQUEST["mDate"]);
$Year_finish = dmyE2ymdT($_REQUEST["mDate2"]);
$Year_sprop = dmyE2ymdT($_REQUEST["mDate3"]);
$Fund_resourceIn = trim( $_POST['Fund_resourceIn'] ); // ภายใน
$Fund_resourceOut = trim( $_POST['Fund_resourceOut'] ); // ภายนอก
$FundIn = trim( $_POST['FundIn'] );
$FundOut = trim( $_POST['FundOut'] );
$FundUse = trim( $_POST['FundUse'] ); // จำนวนเงินทุน
$Resource_des = htmlspecialchars( trim( $_POST['Resource_des'] ) ); // ระบุ แหล่งเงินทุน
$r_type = trim( $_POST['r_type'] );
//*--------research_public_tb--------*//
$AreaRePbId1 = htmlspecialchars( trim( $_POST['AreaRePbId1'] ) ); //ระบุสถานที่
$AreaRePbId2 = htmlspecialchars( trim( $_POST['AreaRePbId2'] ) ); //ระบุสถานที่
$AreaRePbId3 = htmlspecialchars( trim( $_POST['AreaRePbId3'] ) ); //ระบุสถานที่
$AreaRePbId4 = htmlspecialchars( trim( $_POST['AreaRePbId4'] ) ); //ระบุสถานที่
//*-----------research_file_tb-------------*//
$importance = htmlspecialchars( trim( $_POST['importance'] ) ); // ความสำคัญและที่มาของปัญหา
$objective = htmlspecialchars( trim( $_POST['objective'] ) ); // วัตถุประสงค์ของโครงการงานวิจัย
$scope = htmlspecialchars( trim( $_POST['scope'] ) ); // ขอบเขตของโครงการงานวิจัย
$receive = htmlspecialchars( trim( $_POST['receive'] ) ); // ผลที่คาดว่าจะได้รับ
$quality = htmlspecialchars( trim( $_POST['quality'] ) ); // นำไปใช้ในการพัฒนาคุณภาพการศึกษา
$abbStract = htmlspecialchars( trim( $_POST['abbStract'] ) ); // บทคัดย่อ
$academic_year = ($_REQUEST["mDate3_Month"]<6)?$_REQUEST["mDate3_Year_ID"]-1:$_REQUEST["mDate3_Year_ID"]; //ปีการศีกษา แผยแพร่
$fiscal_year = ($_REQUEST["mDate3_Month"]<10)?$_REQUEST["mDate3_Year_ID"]:$_REQUEST["mDate3_Year_ID"]+1; //ปีงบประมาณ แผยแพร่
$academic_year_finish = $_REQUEST["academic_year_finish"]; //ปีการศีกษา
$fiscal_year_finish = $_REQUEST["fiscal_year_finish"]; //ปีงบประมาณ
//บวกจำนวนเงินที่ใช้จริง
$FundUse = $FundIn + $FundOut ;
$query1 = " UPDATE research_tb SET collegeCode='$collegeCode', Research_name='$Research_name' , Branch='$Branch', Research_type='$Research_type' , Research_char ='$Research_char', Research_char_else='$Research_char_else', ReFormId='$ReFormId' , Research_Form_else='$Research_Form_else' , Year_prop='$Year_prop' , ResearchDI='$ResearchDI' , ReTyId='$ReTyId' , ReAcId='$ReAcId', Year_start='$Year_start' , Year_finish='$Year_finish' , Year_sprop='$Year_sprop',Fund_resourceIn='$Fund_resourceIn', Fund_resourceOut='$Fund_resourceOut', FundIn='$FundIn', FundOut='$FundOut', FundUse='$FundUse', Resource_des='$Resource_des' , r_type='$r_type' , academic_year='$academic_year' , fiscal_year='$fiscal_year' , academic_year_finish='$academic_year_finish' ,fiscal_year_finish='$fiscal_year_finish' WHERE Research_code ='$Research_code' ";
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
/*---------ResearchCurl----------*/
// $res = rsResearchCurl($_REQUEST["Research_code"], $Research_name, $Branch, $Research_type, $Research_char, $Research_char_else, $ReFormId, $Research_Form_else, $Year_prop, $ResearchDI, $ReTyId, $Year_start, $Year_finish, $Fund_resourceIn, $Fund_resourceOut, $FundIn, $FundOut, $FundUse, $Resource_des, $r_type, $academic_year, $fiscal_year, $academic_year_finish, $fiscal_year_finish, $Year_sprop );
$sql = "SELECT * FROM research_public_tb where Research_code = $Research_code";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if($num_rows){
$query2 =" UPDATE research_public_tb SET collegeCode='$collegeCode' , ReTyId='$ReTyId', RePbId1='$RePbId1', AreaRePbId1='$AreaRePbId1', RePbId2='$RePbId2', AreaRePbId2='$AreaRePbId2', RePbId3='$RePbId3', AreaRePbId3='$AreaRePbId3', RePbId4='$RePbId4', AreaRePbId4='$AreaRePbId4' , RePbId5='$RePbId5', AreaRePbId5='$AreaRePbId5', RePbId6='$RePbId6', RePbId7='$RePbId7', RePbId8='$RePbId8' ,RePbId9='$RePbId9', RePbId10='$RePbId10', AreaRePbId10='$AreaRePbId10' , RePbId11='$RePbId11' Where Research_code ='$Research_code' ";
$result2 = $dbObj->runQuery($query2);
$dbObj->freeresult($result2);
//*--------- PublicCurl----------*//
// $res = rsPublicCurl($_REQUEST["Research_code"], $RepbCo, $Research_code, $ReTyId, $RePbId1, $AreaRePbId1, $RePbId2, $AreaRePbId2, $RePbId3, $AreaRePbId3, $RePbId4, $AreaRePbId4, $RePbId5, $AreaRePbId5, $RePbId6, $RePbId7, $RePbId8, $RePbId9, $RePbId10, $AreaRePbId10, $RePbId11);
}
else{
InsertPublic($Research_code, $ReTyId, $RePbId1,$AreaRePbId1, $RePbId2, $AreaRePbId2, $RePbId3, $AreaRePbId3, $RePbId4, $AreaRePbId4 , $RePbId5, $AreaRePbId5, $RePbId6, $RePbId7, $RePbId8 , $RePbId9, $RePbId10, $AreaRePbId10, $RePbId11, $collegeCode );
}
/*------------*/
$sql = "SELECT * FROM research_success_tb where Research_code = $Research_code";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if($num_rows){
$query4 =" UPDATE research_success_tb SET Research_code='$Research_code', collegeCode='$collegeCode' , Success ='$Success' , Knowledge='$Knowledge' , proId='$proId' , outreacId='$outreacId' , outSouse='$outSouse' , courseId='$courseId' Where Research_code ='$Research_code' "; $result4 = $dbObj->runQuery($query4);
$dbObj->freeresult($result4);
//$res = RsSuccessCurl($_REQUEST["Research_code"],$ResuccessId, $Research_code, $Success, $Knowledge, $proId, $outreacId, $outSouse, $courseId);
}
else{
InsertSuccess ( $Research_code, $collegeCode ,$Success , $Knowledge , $proId, $outreacId , $outSouse, $courseId );
}
/*--------------*/
$sql = "SELECT * FROM research_file_tb where Research_code = $Research_code";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
$rs = mysql_fetch_array($result);
if($num_rows){
if($_FILES['Filetex']['name'] != ""){
//ลบไฟล์เก่า
unlink($ResearchPicPath.$rs["Filetex"]);
//Upload ไฟล์เอกสารใหม่
$Filetex = date('YmdHis').strrchr($_FILES['Filetex']['name'], ".");
@copy( $_FILES['Filetex']['tmp_name'] , $ResearchPicPath.$Filetex );
@unlink( $_FILES['Filetex']['tmp_name'] );
$query3 = " UPDATE research_file_tb SET Research_code='$Research_code', importance='$importance', objective='$objective', scope='$scope', receive='$receive', quality='$quality', abbStract='$abbStract ', Filetex='$Filetex' Where Research_code='$Research_code'";
}
else{
$query3 = " UPDATE research_file_tb SET Research_code='$Research_code' , importance='$importance', objective='$objective' , scope='$scope' , receive='$receive' , quality='$quality', abbStract='$abbStract ' Where Research_code='$Research_code' ";
}
$result3= $dbObj->runQuery($query3);
$dbObj->freeresult($result3);
// $res = RsFileCurl($_REQUEST["Research_code"],$Research_Id, $Research_code, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex);
}
else{
if($_FILES['Filetex']['name'] != ""){
//Upload ไฟล์เอกสารใหม่
$Filetex = date('YmdHis').strrchr($_FILES['Filetex']['name'], ".");
@copy( $_FILES['Filetex']['tmp_name'] , $ResearchPicPath.$Filetex );
@unlink( $_FILES['Filetex']['tmp_name'] );
InsertResearchText($Research_code, $collegeCode, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex);
}
else{
InsertResearchText($Research_code, $collegeCode, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex);
}
}
} # else
?>
ข้อมูลทั่วไปบุคลากร - ข้อมูลแผนการสอน - แก้ไขประวัติผลงานวิจัย
|
|
freeresult($result1);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |