
<?php

include("../include/FunctionDB.php");

include("../include/Function.php");

 ConnectDB();

$Flag = true;

$Teacher_code = htmlspecialchars(trim($_POST[Teacher_code]));

$code = htmlspecialchars(trim($_POST[code]));

$ProjectId = htmlspecialchars(trim($_POST[ProjectId]));

$No_in = htmlspecialchars(trim($_POST[No_in]));

$Detail = htmlspecialchars(trim($_POST[Detail]));

$Date = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];

$Date_start = $_POST['mYear1']."-".$_POST['mMonth1']."-".$_POST['mDate1'];

$Date_finish = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2'];

$Training_name = htmlspecialchars(trim($_POST[Training_name]));

$Training_type = htmlspecialchars(trim($_POST[Training_type]));

$Day =  htmlspecialchars(trim($_POST[Day]));

$Year_std =  htmlspecialchars(trim($_POST[Year_std]));

$TeacherId =  htmlspecialchars(trim($_POST[TeacherId]));

$Flag1 =  htmlspecialchars(trim($_POST[Flag1]));

$Flag2=  htmlspecialchars(trim($_POST[Flag2]));

$Budget_use =  htmlspecialchars(trim($_POST[Budget_use]));

////////////////////// check Code

if ($No_in =="")

{

$msg .="<li>กรุณาระบุ เลขที่หนังสือ";

$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\">";

$Flag = false;

}

///////////////////// check name

if ($Day =="")

{

$msg .="<li>กรุณาระบุ จำนวนวัน";

$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";

$Flag = false;

}

///////////////////// check name

if ($Year_std =="")

{

$msg .="<li>กรุณาระบุ ปีงบประมาณ";

$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";

$Flag = false;

}

////////////////////////// Check Status to Insert Data /////////////////////////////

   if( $Flag)

    {

             InsertTraining($Teacher_code,$Training_name,$Period_code,$Training_type,$Level,$Major,$Year_std,$Place,$Place_des,$Date_start,$Date_finish,$CNEU,$Total_hour,$Fund,$Fund_resource,$Organiz,$Date_sent,$Period_prop,$Apply); 

            

     $Training_code = mysql_insert_id();

              InsertFormA($Training_code,$Teacher_code,$code,$ProjectId,$No_in,$Detail,$Date,$Date_start ,$Date_finish,$Training_name,$Training_type,$Day,$Year_std,$TeacherId,$Flag1,$Falg2,$Budget_use);  

          

          InsertProject($Training_code,$Project_code,$ProjectId,$MoneyId,$MoneyS_C,$Faculty_code,$Teacher_code,$Ind,$Orderlist,$Project_plan,$Training_name,$Date,$Budget_use,$programId,$Budget_Year,$Year);

                $msg.="<li>ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว";

          echo"<meta http-equiv=\"refresh\" content=\"1;URL=FormAList.php?Teacher_code=$Teacher_code\">";         

    }

    CloseDB();

?>

<html>

<head>

<title>บันทึกข้อมูล....</title>

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

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

</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"marginwidth="0"marginheight="0">

<form>

<br>

  <table width="64%" border="0" cellspacing="0"cellpadding="2"align="center">

    <tr>

      <td><div align="center"><span><b><font color="#003399" size="4" face="Tahoma">::แบบฟอร์มการกรอกข้อมูลแผนการสอน::</font></b></span></div></td>

</tr>

<tr>

      <td> <table width="81%" border="0" cellspacing="1"cellpadding="0"align="center"bordercolor="#666666">

          <tr> 

            <td bgcolor="#D3E4F8"><div align="center"><b><font color="#333333" size="3" face="Tahoma">ระบบแจ้ง</font></b></div></td>

          </tr>

          <tr> 

            <td bgcolor="#000000"> 

              <table width="90%" border="0" cellspacing="0"cellpadding="2"align="center"class="table">

                <tr> 

                  <td><span><b><font color="#FFFFFF"><?php echo $msg;?></font></b></span></td>

                </tr>

              </table></td>

          </tr>

          <tr> 

            <td bgcolor="#D3E4F8">

<div align="center"><b><font color="#CCFF00"><?php echo $button;?></font></b></div></td>

          </tr>

        </table></td>

</tr>

</table>

  <br>

</form>

</body>

</html>