"; 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"]; //ปีงบประมาณ /*//ปี พศ. $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); $res = RsFileCurl($rs["Research_Id"], $Research_code, $importance, $objective, $scope, $receive, $quality, $abbStract, $Filetex); echo "

3

"; }*/ } } # else ?> ข้อมูลทั่วไปบุคลากร - ข้อมูลแผนการสอน - แก้ไขประวัติผลงานวิจัย

หน้าหลัก » แก้ไขผลงาน

ระบบกำลังจัดการข้อมูลของท่านเรียบร้อยแล้ว
กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ
"; ?>

freeresult($result1); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>