<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<style type="text/css">
<!--
.carcar { 
    width:1000;
    background-color: #d7fef6;
}
-->
</style>

<div align='left'>&nbsp;&nbsp;<A HREF="?name=car&file=add&op=car_add"><IMG SRC="images/add.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp;<b>ทำการขอจองรถ</b></a>&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>


	<?
$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]);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=200 border=0>
      <TBODY>
        <TR>
          <TD  vAlign=top>
<table cellSpacing=1 cellPadding=1 width=100%  border=0>
		<tr>
		<td colspan=8 align=center ><font color=#990099><b>รายการจองรถของ<? echo $arr[user][category_name]; ?></b></font>
		</td>
		</tr>
		<tr>
		<td bgcolor="#0099CC" width="5%" align="center"><font color="#FFFFFF">ที่</td>
		<td bgcolor="#0099CC" width="10%" align="center"><font color="#FFFFFF">วัน เดือน ปี</td>
		<td bgcolor="#0099CC" width="35%" align="center"><font color="#FFFFFF">สถานที่</td>
		<td bgcolor="#0099CC" width="13%" align="center"><font color="#FFFFFF">ทะเบียนรถ</td>
		<td bgcolor="#0099CC" width="17%" align="center"><font color="#FFFFFF">คนขับ</td>
		<td bgcolor="#0099CC" width="20%" align="center"><font color="#FFFFFF">ผู้ขอใช้</td>
		</tr>
<?
$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]);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_CAR,"id","");
$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_CAR."  WHERE comment1='อนุญาต' and name='".$arr[user][category_name]."' ORDER BY date1  DESC LIMIT $goto, $limit");
$count=0;
$rank=1;
while($arr[car] = $db->fetch($res[car])){

	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE category_name='".$arr[car][name]."'  ");
	$arr[user] = $db->fetch($res[user]);
	if ($count==0) { echo "<TR>"; }
?>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?=$rank;?></td>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center" ><?echo ("".thai_date_short(strtotime($arr[car][date1]))."" );?><br /><? echo $arr[car][time1]; ?> น.</td>
			<TD bgcolor="<?=$ColorFill; ?>"  valign=top><?echo  $arr[car][na]; ?></td>
			<TD bgcolor="<?=$ColorFill; ?>"  valign=top align="center"><?echo  $arr[car][tabain]; ?></td>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><? echo $arr[car][driver]; ?></td>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top>&nbsp;&nbsp;&nbsp;<? echo $arr[car][name]; ?></a></td>
			</tr>
			<tr>
            <td height="1" align="left" class="dotline" colspan="5"></td>
			</tr>
<?
				$rank++;
}
$count++;
?>
		</table>
				<?
				SplitPage($page,$totalpage,"?name=car&person=".$_GET[person]."");
				echo $ShowPages ;
				?> 
		  </TD>
        </TR>
      </TBODY>
    </TABLE>