<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<link href="style_web.css" rel="stylesheet" type="text/css">
<script language="JavaScript">

//******************************************
function checkregis() {
if(document.myform.rdo1.checked == false && document.myform.rdo2.checked == false && document.myform.rdo3.checked == false&& document.myform.rdo4.checked == false  )   
{        
alert('กรุณาเลือกประเภท ');       
return false;    
}    

if(document.myform.KOM.value=="") {
alert("กรุณาเลือกกลุ่ม") ;
document.myform.KOM.select() ;
return false ;
}

if(document.myform.TOPIC.value=="") {
alert("กรุณากรอกเรื่อง") ;
document.myform.TOPIC.select() ;
return false ;
}

//********************************************
}
</script>
	<TABLE align=center cellSpacing=0 cellPadding=0 width=1005 height=500  border=0>
      <TBODY>
        <TR>
          <TD align=center>บันทึกการนิเทศ ออกตรวจเยี่ยม โรงเรียนในสังกัด
		<BR>
		<TABLE width="900" align=center cellSpacing=0 cellPadding=0 border=0 background="images/124.jpg">
			<TR>
				<TD>

<?
 if($_GET[op] == "supper_add" AND $_GET[action] == "add"){
	//////////////////////////////////////////// กรณีเพิ่ม Database
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);

	if (!$_POST[CATEGORY] OR !$_POST[TOPIC]){
		echo "<script language='javascript'>" ;
		echo "alert('กรุณากรอกข้อมูลต่างๆให้ครบถ้วน')" ;
		echo "</script>" ;
		echo "<script language='javascript'>javascript:history.back()</script>";
		exit();
}
//ทำการเพิ่มข้อมูลลงดาต้าเบส
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$db->add_db(TB_SUPPER,array(
			"category"=>"$_POST[CATEGORY]",
			"year"=>"$_POST[YEAR]",
			"approval_id"=>"$_POST[APPROVAL_ID]",
			"topic"=>"$_POST[TOPIC]",
			"school"=>"$_POST[SCHOOL]",
			"laysen"=>"$_POST[LAYSEN]",
			"edit"=>"15",
			"posted"=>"$_POST[POSTED]",
			"post_date"=>"".TIMESTAMP."",
			"enable_comment"=>"1"));
		$db->closedb ();
} else {
//ทำการเพิ่มข้อมูลลงดาต้าเบส
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$db->add_db(TB_SUPPER,array(
			"category"=>"$_POST[CATEGORY]",
			"year"=>"$_POST[YEAR]",
			"approval_id"=>"$_POST[APPROVAL_ID]",
			"topic"=>"$_POST[TOPIC]",
			"school"=>"$_POST[SCHOOL]",
			"laysen"=>"$_POST[LAYSEN]",
			"edit"=>"15",
			"posted"=>"$_POST[POSTED]",
			"post_date"=>"".TIMESTAMP."",
			"enable_comment"=>"1"));
		$db->closedb ();
}
//ทำการสร้างไฟล์ text ของข่าวสาร
		$Filename = TIMESTAMP.".txt";
		$txt_name = "data/suppertext/".$Filename."";
		$txt_open = @fopen("$txt_name", "w");
		@fwrite($txt_open, "".$_POST[DETAIL]."");
		@fclose($txt_open);

		$ProcessOutput .= "<BR><BR>";
		$ProcessOutput .= "<CENTER><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
		$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการเพิ่ม  เข้าสู่ระบบเรียบร้อยแล้ว</B></FONT><BR><BR>";
		$ProcessOutput .= "<meta http-equiv=\"refresh\" content=\"1 ;url=?name=supper&file=bookperson&category=".$arr[user][id]."\">";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	
	echo $ProcessOutput ;
}
else if($_GET[op] == "supper_add"){
	//////////////////////////////////////////// กรณีเพิ่ม Form
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);
//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[year] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id DESC LIMIT 1");
		$arr[year] = $db->fetch($res[year]);
		?>

<FORM NAME="myform" METHOD=POST ACTION="?name=supper&file=add&op=supper_add&action=add" enctype="multipart/form-data" id="myform" onSubmit="return checkregis()">
<INPUT TYPE="hidden" NAME="YEAR" size="80" VALUE="<?=$arr[year][name];?>" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr> 
    <td >	
<br>
<B>หัวข้อ :</B>
<INPUT TYPE="text" NAME="TOPIC"  VALUE="<?=$arr[supper][topic];?>" style="WIDTH: 830px">
<br>
<b>โรงเรียน :</b><SELECT NAME="SCHOOL"><option></option>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE radab='1' and status='1' ORDER BY name ");
while ($arr[usersch] = $db->fetch($res[usersch])){
	   echo "<option value=\"".$arr[usersch][name]."\"";
	   echo ">".$arr[usersch][name]."</option>";
}
$db->closedb ();
?>
</SELECT>
<BR>
<B>อ้างถึง <select NAME="APPROVAL_ID" style="WIDTH: 840px" >
<option > ++ เลือกเอกสารขออนุญาตไปราชการที่อ้างถึง ++</option>
<?
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[category] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE  cat='".$arr[user][id]."' OR person like '%,".$arr[user][id].",%' ORDER BY id DESC LIMIT 15");
		while ($arr[category] = $db->fetch($res[category])){
	   echo "<option value=\"".$arr[category][id]."\"";
	   echo ">หนังสือ ".$arr[category][topic]." วันที่ ".thai_date_fullmonth(strtotime($arr[category][date]))." ถึงวันที่ ".thai_date_fullmonth(strtotime($arr[category][date1]))."</option>";
}
?>
</select> 

<br>
<b>รายละเอียด</b>				
<CENTER>
<?
include("FCKeditor/fckeditor.php") ;
$oFCKeditor = new FCKeditor('DETAIL') ;
$oFCKeditor->BasePath	= 'FCKeditor/' ;
$oFCKeditor->Width	= '100%' ;
$oFCKeditor->Height	= '300' ;
$oFCKeditor->Value		= $TextContent ;
$oFCKeditor->Create() ;
?>
</CENTER>
	</td>
	</tr> 
 <table width="100%" align=center border="0" cellspacing="0" cellpadding="0">
	  <tr> 
      <td colspan="4"><div align="center">
	<IMG SRC="laysen/<?=$arr[user][id];?>.jpg">
	<BR>
	(<?=$arr[user][category_name];?>)
	<BR>
	<?=$arr[user][posit];?>
<?
	 if($arr[user][level]=='6'){ 	  
?>
	<?=$arr[user][school];?>
<? }?>
	<BR>
<?
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
	$arr[user] = $db->fetch($res[user]);
?>
	<INPUT TYPE="hidden" NAME="CATEGORY" VALUE="<?=$arr[user][id];?>" readonly style=\"color: #FF0000" >
	<INPUT TYPE="hidden" NAME="LAYSEN" VALUE="<?=$arr[user][id];?>.jpg" readonly style=\"color: #FF0000">
	<INPUT TYPE="hidden" NAME="POSTED" VALUE="<?=$arr[user][id];?>" readonly style=\"color: #FF0000">
	<INPUT TYPE="submit" value=" บันทึกเอกสาร" name="submit" style="background-color:#FFFF99" onClick="this.form.submit();this.disabled=true;this.value=' Wait... '">
	</div>
	</td>
    </tr>
    </tr>
  </table>
</FORM>
<?	
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
?>
					</TD>
				</TR>
			</TABLE>
			<BR><BR>
			<!-- user -->
		  </TD>
        </TR>
      </TBODY>
    </TABLE>