
<?php



    session_start();

    

    /**  Define Validate Access  */

    define( '_VALID_ACCESS', 1 );



    /**  Check Session User Login  */

    if (! session_is_registered("valid_user") ) {

        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;

        //###  รับค่าจาก Form

        $Destination  = htmlspecialchars(trim($_POST['Destination']));

        $TopicName  = htmlspecialchars(trim($_POST['TopicName']));

        $DatePublic = dmyE2ymdT($_REQUEST["mDate4"]);

      

     $Path = "../Research_pic"; 

        //###  Upload Text File  -----*//

        if( $_FILES['Filetex']['name'] != "" ) {

            $Filetex = date('YmdHis').strrchr($_FILES['Filetex']['name'], ".");

            @copy( $_FILES['Filetex']['tmp_name'] , $ResearchPicPath.$Filetex);

            @unlink( $_FILES['Filetex']['tmp_name'] );

        }

           $sql = "SELECT * FROM   research_dissemination   Where    pubId='$pubId'     ";

           $result1 = mysql_query($sql);

           $num_rows = mysql_num_rows($result1);

           

           if($num_rows){

                if($Filetex){

                 $query1 = " UPDATE    research_dissemination   SET   Feature='$Feature', Flag='$Flag' , Warsan='$Warsan', Quality='$Quality' , Proceeding='$Proceeding' , Results='$Results' ,DatabaseName='$DatabaseName' , JournalName='$JournalName' , Year='$Year' , Issue='$Issue' , Page='$Page', fiscal_year_finish='$fiscal_year_finish' , academic_year_finish='$academic_year_finish' , MeetingName='$MeetingName' , Agencies='$Agencies' , DatePublic='$DatePublic' , Filetex='$Filetex'    WHERE    pubId='$pubId'   ";  

                    }

                else{

                 $query1 = " UPDATE   research_dissemination   SET    Feature='$Feature' , Flag='$Flag' , Warsan='$Warsan' ,Quality='$Quality' , Proceeding='$Proceeding'  ,Results='$Results' , DatabaseName='$DatabaseName' , JournalName='$JournalName' , Year='$Year' , Issue='$Issue' , Page='$Page', fiscal_year_finish='$fiscal_year_finish' , academic_year_finish='$academic_year_finish' , MeetingName='$MeetingName' , Agencies='$Agencies' , DatePublic='$DatePublic'   WHERE  pubId='$pubId'  ";

                 /*----Curl---*/

                 $res =  rsDisseCurl($pubId, $Research_code, $Feature, $Warsan, $Quality, $Proceeding, $Results, $DatabaseName, $JournalName, $Year, $Issue, $Page, $fiscal_year_finish, $academic_year_finish, $MeetingName, $Agencies, $DatePublic, $Filetex );

                  }

                    $result1 = $dbObj->runQuery($query1);

                    $dbObj->freeresult($result1);

                    }

                   else{

                    InsertPubliczing($Research_code, $Feature,  $Warsan ,  $Quality , $Proceeding , $Results, $DatabaseName, $JournalName, $Year, $Issue, $Page, $fiscal_year_finish , $academic_year_finish, $MeetingName, $Agencies , $DatePublic ,$Filetex );

                  }

           

                     

              $dbObj->disconn();

                unset($dbObj);

                echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";

                echo "<script>alert('บันทึกข้อมูลเรียบร้อยแล้ว');</script>";

                echo "<script>window.opener.document.all.myForm; window.opener.location.reload(); window.close();</script>";

                exit();

        

        

            } # 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" />

<title>-</title>

<link href="../css/default.css" rel="stylesheet" type="text/css" />

</head>



<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">

</body>

</html>