
<?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/FunctionDB.php" );

        /**  Create Database Object  */

        $dbObj = new DBConn;

        

             /**  Config Table for This Page  */

        $myTable1 = "personal_tb";

        $myTable2 = "history_accumu";

        

        

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

    

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

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

    

        //###  user_tb

        $checkid = 0;

        $sql11 = " Select  *  From  $myTable2  Where   Teacher_code='$Teacher_code'  ";

        $result11 = mysql_query($sql11);

        while ($rs11 = mysql_fetch_array($result11)){

                if ($rs11["Year"] == $Year){

                        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{

                        $checkid = 1;

                }

        }

        if ($check == 0){

        //###  user_tb

                    InsertAccumu($Year,$Teacher_code,$Times_total , $Absent_code );

                      

              $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>Edit </title>

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

</head>



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

</body>

</html>