<script language="javascript">
<!--
var Open = ""
var Closed = ""

function preload(){
if(document.images){

Closed = new Image(16,13)

Closed.src = "closed.gif"
}}


function showhide(what,what2){
if (what.style.display=='none'){
what.style.display='';
}
else{
what.style.display='none'

}
}
-->
</script>
	<TABLE cellSpacing=0 cellPadding=0 width=100% height=450 border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>
				<TABLE width="800" bgcolor=FFFFFF align=center cellSpacing=0 cellPadding=0 border=0>
				<TR>
					<TD height="1" class="dotline"></TD>
				</TR>
				<TR>
					<TD  vAlign=top>
					<BR><B> <IMG SRC="images/icon/arrow_wap.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp; ระบบอกกเลขคำสั่งสำนักงานอิเลกทรอนิกส์</B>
					<BR><BR>
<?
 if($_GET[op] == "numbook_add" AND $_GET[action] == "add"){
	//////////////////////////////////////////// กรณีเพิ่ม Database
	if(CheckLevel($_SESSION['admin_user'],$_GET[op])){
		$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]);
		
		
		//echo $filesw_name;
		if ($filesw != '' ){
            
			  		//ทำการเพิ่มข้อมูลลงดาต้าเบส
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$db->add_db(TB_NUMBER,array(
			"year"=>"$_POST[YEAR]",
			"number1"=>"$_POST[NUMBER1]",
			"number2"=>"$_POST[NUMBER2]",
			"post_date"=>"".TIMESTAMP."",
			"update_date"=>"".TIMESTAMP.""));
		$db->closedb ();
} else {
			//ทำการเพิ่มข้อมูลลงดาต้าเบส
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$db->add_db(TB_NUMBER,array(
			"year"=>"$_POST[YEAR]",
			"number1"=>"$_POST[NUMBER1]",
			"number2"=>"$_POST[NUMBER2]",
			"post_date"=>"".TIMESTAMP."",
			"update_date"=>"".TIMESTAMP."",
		));
		$db->closedb ();
}

		$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=admin&file=main2\">";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "numbook_add"){
	//////////////////////////////////////////// กรณีเพิ่ม Form
	if(CheckLevel($_SESSION['admin_user'],$_GET[op])){
//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[number] = $db->select_query("SELECT * FROM ".TB_NUMBER." ORDER BY id DESC LIMIT 1 ");
		$arr[number] = $db->fetch($res[number]);
		$db->closedb ();
	//	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]);
		
		$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=admin&file=addtabainnumber&op=numbook_add&action=add" enctype="multipart/form-data" id="myform">
 <table width="770" border="0" cellspacing="0" cellpadding="0">
 <tr> 
      <td><div align="center">
<font color=red><B>**เลขเกียรติบัตรเริ่มที่ </B></font>
<INPUT TYPE="hidden"  size="5" NAME="NUMBER1" VALUE="0">
<INPUT TYPE="hidden"  size="8" NAME="YEAR" VALUE="<?=$arr[year][name];?>">
<INPUT TYPE="text"  size="5" NAME="NUMBER2" VALUE="0">
<INPUT TYPE="submit" value=" บันทึก" name="submit"> 
</td>
    </tr>
	</div></td>
    </tr>
    </tr>
  </table>
</FORM>
<BR><BR>
<?
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "number_del" AND $_GET[action] == "multidel"){
	//////////////////////////////////////////// กรณีลบ Multi
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
		while(list($key, $value) = each ($_POST['list'])){
			$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
			$res[number] = $db->select_query("SELECT * FROM ".TB_NUMBER." WHERE id='".$value."' ");
			$arr[number] = $db->fetch($res[number]);
			$db->del(TB_NUMBER," id='".$value."' "); 

			@unlink("numberdata/".$arr[number][post_date].".txt");
			@unlink("numbericon/".$arr[number][post_date].".jpg");
			@unlink("number/".$arr[number][full_text]);
			$db->closedb ();
		}
		$ProcessOutput .= "<BR><BR>";
		$ProcessOutput .= "<CENTER><A HREF=\"?name=number&file=main\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
		$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการลบเรียบร้อยแล้ว</B></FONT><BR><BR>";
		$ProcessOutput .= "<A HREF=\"?name=number&file=addschool&op=number_add\"><B>ส่งหนังสือถึงโรงเรียนใหม่</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "number_del"){
	//////////////////////////////////////////// กรณีลบ Form
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
//		$db->del(TB_NUMBER," id='".$_GET[id]."' ");
			$res[number] = $db->select_query("SELECT * FROM ".TB_NUMBER." WHERE id='".$_GET[id]."' ");
			$arr[number] = $db->fetch($res[number]);
			$db->del(TB_NUMBER," id='".$_GET[id]."' "); 

			@unlink("numberdata/".$arr[number][post_date].".txt");
			@unlink("numbericon/".$arr[number][post_date].".jpg");
			@unlink("number/".$arr[number][full_text]);
		$db->closedb ();
		$ProcessOutput .= "<BR><BR>";
		$ProcessOutput .= "<CENTER><A HREF=\"?name=user&file=main\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
		$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการลบเรียบร้อยแล้ว</B></FONT><BR><BR>";
		$ProcessOutput .= "<A HREF=\"?name=number&file=addschool&op=number_add\"><B>ส่งหนังสือถึงโรงเรียนใหม่</B></A>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
?>
				</TD>
				</TR>
			</TABLE>
			<!-- user -->
		  </TD>
        </TR>
      </TBODY>
    </TABLE>