<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<?
$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);
if ($_GET[year]) {
	$SQLwhere = " year='" . $_GET[year] . "' ";
	$SQLwhere2 = " WHERE year='" . $_GET[year] . "' ";
}

$res[kamsang] = $db->select_query("SELECT * FROM " . TB_KAMSANG . " $SQLwhere2  ");
$arr[kamsang] = $db->fetch($res[kamsang]);

$res[category] = $db->select_query("SELECT * FROM " . TB_YEARS_CAT . " WHERE name='" . $arr[kamsang][year] . "' ");
$arr[category] = $db->fetch($res[category]);
?>
<table width=100% height=500 border="0" align="left" cellpadding="0" cellspacing="0">
	<tr>
		<td Valign="top">
			<form name="form3" method="post" action="?name=search&&file=tabainkamsangsema&op=kamsang_read&year=<? echo $arr[category][name]; ?>">
				<table width=100% border="0" align="left" cellpadding="0" cellspacing="0">
					<tr class="unnamed1">
						<td align="left" width="60%" class="unnamed2"><A HREF="?name=search&file=from">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle"></A>&nbsp;&nbsp;<B>ทะเบียนคำสั่ง <? echo $arr[category][name]; ?></B></td>
						<td width="20%" class="unnamed2">
							<div align="right"><B>ระบุชื่อหนังสือที่ต้องการคันหา&nbsp;&nbsp;</B> </div>
						</td>
						<td align="right" width="15%"><input name="search" type="text" id="search" value="<?= $_GET["search"]; ?>"></td>
						<td width="5%">
							<div align="right"><input type="submit" name="Submit2" value="ค้นหา">&nbsp;&nbsp;</div>
						</td>
					</tr>
				</table>
			</form>
			<br>
			<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#999999" bordercolordark="#FFFFFF">
				<tr height=25 bgcolor="#6dbae0">
					<td width="7%" class="unnamed2">
						<font color="#FFFFFF">
							<div align="center" class="style3"><B>แก้ไข</B></div>
						</font>
					</td>
					<td width="8%" class="unnamed2">
						<font color="#FFFFFF">
							<div align="center" class="style3"><B>เลขที่คำสั่ง</B></div>
						</font>
					</td>
					<td width="40%" class="unnamed2">
						<font color="#FFFFFF">
							<div align="center" class="style3">เรื่อง</div>
						</font>
					</td>
					<td width="15%" class="unnamed2">
						<font color="#FFFFFF">
							<div align="center" class="style3"><B>ทั้งนี้ต้งแต่วันที่</B></div>
						</font>
					</td>
					<td width="15%" class="unnamed2">
						<font color="#FFFFFF">
							<div align="center" class="style3"><B>สั่ง ณ วันที่</B></div>
						</font>
					</td>
					<td width="15%" class="unnamed2">
						<font color="#FFFFFF">
							<div align="center" class="style3"><B>ไฟล์แนบ</B></div>
						</font>
					</td>
				</tr>



				<?
				if ($_GET[year]) {
					$SQLwhere = " year='" . $_GET[year] . "' ";
					$SQLwhere2 = " WHERE year='" . $_GET[year] . "' ";
				}
				$db->connectdb(DB_NAME, DB_USERNAME, DB_PASSWORD);
				$limit = 10;
				$SUMPAGE = $db->num_rows(TB_KAMSANG, "id", "$SQLwhere and  topic like '%$search%'  ");
				$page = $_GET[page];
				if (empty($page)) {
					$page = 1;
				}
				$rt = $SUMPAGE % $limit;
				$totalpage = ($rt != 0) ? floor($SUMPAGE / $limit) + 1 : floor($SUMPAGE / $limit);
				$goto = ($page - 1) * $limit;

				$res[kamsang] = $db->select_query("SELECT * FROM " . TB_KAMSANG . " $SQLwhere2 and topic like '%$search%' ORDER BY id DESC LIMIT $goto, $limit ");
				$count = 0;
				while ($arr[kamsang] = $db->fetch($res[kamsang])) {

					$res[user] = $db->select_query("SELECT * FROM " . TB_user . " WHERE id='" . $arr[kamsang][category] . "'  ");
					$arr[user] = $db->fetch($res[user]);
				?>










					<tr bgcolor="#FFFFFF">
						<td width="30" class="unnamed2">
							<div align="center"><A HREF="?name=kamsang&file=addedit&op=kamsang_edit&id=<? echo $arr[kamsang][id]; ?>"><B><img src=" images/admin/edit.gif"></B></a> </div>
						</td>
						<td width="70" class="unnamed2">
							<div align="center"><? echo $arr[kamsang][idtabain]; ?>/<? echo $arr[kamsang][year]; ?></div>
						</td>
						<td class="unnamed2">
							<div align="left"><? echo $arr[kamsang][topic]; ?></div>
						</td>
						<td valign="top">
							<div align="left">&nbsp;<? echo thai_date_fullmonth(strtotime($arr[kamsang][date]), '', ''); ?></div>
						</td>
						<td valign="top">
							<div align="left">&nbsp;<? echo thai_date_fullmonth(strtotime($arr[kamsang][date1]), '', ''); ?></div>
						</td>
						<td valign="top" align="center">
							<?
							if ($arr[kamsang][full_text]) {
							?>
								<a href="data/kamsang/<? echo $arr[kamsang][full_text]; ?>">ไฟล์ 1</A>,
							<? } else {
								echo "ไม่มีไฟล์แนบ";
							} ?>
							<?
							if ($arr[kamsang][full_texts]) {
							?>
								<a href="data/kamsang/<? echo $arr[kamsang][full_texts]; ?>">ไฟล์ 2</A>,
							<? } ?>
							<?
							if ($arr[kamsang][full_textu]) {
							?>
								<a href="data/kamsang/<? echo $arr[kamsang][full_textu]; ?>">ไฟล์ 3</A>,
							<? } ?>
							<?
							if ($arr[kamsang][full_texto]) {
							?>
								<a href="data/kamsang/<? echo $arr[kamsang][full_texto]; ?>">ไฟล์ 4</A>,
							<? } ?>
							</div>
						</td>
					</tr>
					<tr>
						<td colspan="6" height="1" class="dotline" color=FFFF00></td>
					</tr>
				<?
				}
				?>
			</table>
			<?
			SplitPage($page, $totalpage, "?name=search&file=tabainkamsangsema&year=" . $arr[category][name] . "&search=$search");
			echo $ShowSumPages;
			echo $ShowPages;
			?>
		</td>
	</tr>
</table>