<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<style type="text/css">
<!--
.calendarcar { 
    width:1000;
    background-color: #d7fef6;
}
-->
</style>
<link href="style_web.css" rel="stylesheet" type="text/css" />
	<TABLE cellSpacing=0 cellPadding=0 width=100% height=500  border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>	  
<div align='left'>&nbsp;&nbsp;<IMG SRC="images/icon/calendar.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp;<b>E-Note</b>&nbsp;&nbsp;
	<div align='center'><font color=red><b>จัดการปฏิทินการใช้รถยนต์ส่วนกลาง</b></font>
						<?
						if(!$_GET['month']){
							$_GET['month'] = date("m");
						}
						if(!$_GET['year']){
							$_GET['year'] = date("Y");
						}
						$cal = new Mycalendarp;
						echo $cal->getmonthView($_GET['month'],$_GET['year'] );
						?>
	</div>
		  <?
if($_GET[op] == "car_read"){
	//////////////////////////////////////////// กรณีแก้ไข Form
	if(CheckLevelUser($_SESSION['user_user'], $_GET[op])){
{

//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[years] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id ");
		$arr[years] = $db->fetch($res[years]);		
?>
		
<TABLE width="100%" align=center cellSpacing=0 cellPadding=0 border=0 >
<form action="?name=admin&file=car&op=car_del&action=multidel" name="myform" method="post">
 <table width="100%" cellspacing="2" cellpadding="1" >
  <tr bgcolor="#336633" height=25>
  <td width="20%"  align=center ><font color="#FFFFFF"><B>ว/ด/ป </B></font></td>
  <td width="20%" align=center ><font color="#FFFFFF"><B>ผู้ขอใช้</B></font></td>
   <td  align=center width="30%"><font color="#FFFFFF"><B>รายการ</B></font></td>
   <td width="10%" align=center ><font color="#FFFFFF"><B>เลขทะเบียน</B></font></td>
   <td width="10%" align=center ><font color="#FFFFFF"><B>คนขับ</B></font></td>
   <td width="5%" align=center ><font color="#FFFFFF"><B>ยกเลิก</B></font></td>
  </tr>  
<?
//แสดงข่าวสาร/ประชาสัมพันธ์ 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_CALENDARCAR,"id","$SQL where  and year='".$arr[years][person]."' ");
$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[car] = $db->select_query("SELECT * FROM ".TB_CALENDARCAR."  WHERE  year='".$arr[years][name]."'  ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[car] = $db->fetch($res[car])){
	if ($count==0) { echo "<TR>"; }

  if ($i%2==0) 
{
	?><tr bgcolor="#C9FBC8" class="unnamed1"><?
} else {
	?><tr bgcolor="#E6FE99" class="unnamed2"><?
} ?>
   <td align="center"  ><?echo ("".thai_date_short(strtotime($arr[car][date_event]))."" );?> เวลา <?echo ($arr[car][timeout]." น." );?></td>
<td align="center"  ><? echo $arr[car][person];?></td>
     <td valign="top"><?echo $arr[car][subject];?></td>
<td align="center"  ><? echo $arr[car][tabain];?></td>
<td align="top"  ><?=$arr[car][work];?> </td>
<td align="center"  ><a href="javascript:Confirm('?name=car&file=index3&op=car_del&id=<? echo $arr[car][id];?>&prefix=<? echo $arr[car][post_date];?>','ต้องการลบแน่ใจหรือไม่');"><IMG SRC="images/delete.gif"></a>
</td>

	 </TR>
<?
	$i++;

?>
	<?
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 				
			<!-- End tkk3 -->

				</table>

 </form>		</TR></TD></TABLE>
				<BR>
				<table border="0" cellpadding="0" cellspacing="1" width="100%" align=right>
					<tr>
						<td>แสดงหน้า
				<?
				SplitPage($page,$totalpage,"?name=car&op=car_read&category=".$_GET[category]."");
			echo $ShowPages ;
				?> 

					
			<!-- End tkk3 -->
<?
	}
?>	

<?
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "car_del" AND $_GET[action] == "multidel"){
	//////////////////////////////////////////// กรณีลบ Multi
	if(CheckLevel($_SESSION['user_user'],$_GET[op])){
		while(list($key, $value) = each ($_POST['list'])){
			$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
			$res[car] = $db->select_query("SELECT * FROM ".TB_CALENDARCAR." WHERE id='".$value."' ");
			$arr[car] = $db->fetch($res[car]);
			$db->del(TB_CAR," id='".$value."' "); 

			@unlink("cardata/".$arr[car][post_date].".txt");
			@unlink("caricon/".$arr[car][post_date].".jpg");
			@unlink("car/".$arr[car][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=user&file=tkk3\"><B>กลับหน้า จัดการ</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "car_del"){
	//////////////////////////////////////////// กรณีลบ Form
	if(CheckLevel($_SESSION['user_user'],$_GET[op])){
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
//	$db->del(TB_TKK3," id='".$_GET[id]."' ");
			$res[car] = $db->select_query("SELECT * FROM ".TB_CALENDARCAR." WHERE id='".$_GET[id]."' ");
			$arr[car] = $db->fetch($res[car]);
			$db->del(TB_CAR," id='".$_GET[id]."' "); 

			@unlink("cardata/".$arr[car][post_date].".txt");
			@unlink("caricon/".$arr[car][post_date].".jpg");
			@unlink("car/".$arr[car][full_text]);
		$db->closedb ();
		$ProcessOutput .= "<BR><BR>";
		$ProcessOutput .= "<CENTER><A HREF=\"?name=admin&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=car&file=index\"><B>กลับหน้าู้</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
?>

						<BR><BR>
					</TD>
				</TR>
			</TABLE>
			<BR><BR>
			<!-- Admin -->
		  </TD>
        </TR>
      </TBODY>
    </TABLE>