Viewing file:  EditResearch.php (12.31 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
/** Set Timezone **/
date_default_timezone_set('Asia/Bangkok');
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
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"]; //ปีงบประมาณ
/*//ปี พศ.
$Year_prop = $mYear;
//ปีการศีกษา แผยแพร่
if ($_POST[mMonth3] <= 5 and $_POST[mMonth3] != 0) $academic_year = $_POST[mYear3]-1 ;
if ($_POST[mMonth3] >= 6 and $_POST[mMonth3] != 0) $academic_year = $_POST[mYear3];
//ปีงบประมาณ แผยแพร่
if ($_POST[mMonth3] <= 9 and $_POST[mMonth3] != 0) $fiscal_year = $_POST[mYear3] ;
if ($_POST[mMonth3] >= 10 and $_POST[mMonth3] != 0) $fiscal_year = $_POST[mYear3]+1;
//ปีการศีกษา
if ($_POST[mMonth2] <= 5 and $_POST[mMonth2] != 0) $academic_year_finish = $_POST[mYear2]-1 ;
if ($_POST[mMonth2] >= 6 and $_POST[mMonth2] != 0) $academic_year_finish = $_POST[mYear2];
//ปีงบประมาณ
if ($_POST[mMonth2] <= 9 and $_POST[mMonth2] != 0) $fiscal_year_finish = $_POST[mYear2] ;
if ($_POST[mMonth2] >= 10 and $_POST[mMonth2] != 0) $fiscal_year_finish = $_POST[mYear2]+1;*/
//บวกจำนวนเงินที่ใช้จริง
$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' , 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);
//*----Curl---------*//
$res = RsSuccessCurl($_GET["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'";
$res = RsFileCurl($rs["Research_Id"], $Research_code, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex);
}
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' ";
$res = RsFileCurl($rs["Research_Id"], $Research_code, $importance, $objective, $scope, $receive, $quality, $abbStract, $rs["Filetex"]);
}
$result3= $dbObj->runQuery($query3);
$dbObj->freeresult($result3);
}
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);
$res = RsFileCurl($rs["Research_Id"], $Research_code, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex);
}
/*else{
InsertResearchText($Research_code, $collegeCode, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex);
}*/
}
} # else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="../js/utilities.js"></script>
<title>ข้อมูลทั่วไปบุคลากร - ข้อมูลแผนการสอน - แก้ไขประวัติผลงานวิจัย</title>
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include("../templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
<td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="30" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <span class="NOTE">แก้ไขผลงาน</span></strong></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td height="150" align="center"><span class="TEXT-GREEN10"><strong>ระบบแก้ไขข้อมูลของท่านเรียบร้อยแล้ว</strong></span><br />
กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ<br />
<?php echo "<meta http-equiv=\"refresh\" content=\"1; URL=Research.php\">"; ?></td>
</tr>
<tr>
<td height="234"> </td>
</tr>
</table>
</fieldset></td>
</tr>
</table>
<?php include("../templates/incFooter.php"); ?>
</body>
</html>
<?php
/** Free Resource */
$dbObj->freeresult($result1);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|