芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/rentandbuyrealty.com/ProZigzagbus Web Admin 1.2/getbook.php

<?php
require 'inc/Prozigzig.php';
$h = new Prozigzig($probus);
$query = "SELECT * FROM `tbl_setting`";
		 $set = $h->fetchData($query);
		 if(isset($_SESSION['stype']))
	{
		if($_SESSION['stype'] == 'sowner')
		{
	
		$query = "SELECT * FROM `tbl_bus_operator` where email='".$_SESSION['busname']."'";
		 $sdata = $h->fetchData($query);
		}
	}
if(isset($_POST['start_date']) && isset($_POST['end_date']))
{
	$start_date = $_POST['start_date'];
	$end_date = $_POST['end_date'];
	$user_type = $_POST['user_type'];
	
	if($_SESSION['stype'] == 'sowner')
						 {
							 $city = $h->queryfire("SELECT * FROM `tbl_book` where book_date between '".$start_date."' and '".$end_date."' and user_type='".$user_type."' and operator_id=".$sdata["id"]." order by id desc");
						 }
						 else 
						 {
										$city = $h->queryfire("SELECT * FROM `tbl_book` where book_date between '".$start_date."' and '".$end_date."' and user_type='".$user_type."' order by id desc");
						 }
										$i=0;
										while($row = $city->fetch_assoc())
										{
											$busdata = $h->queryfire("SELECT * from tbl_bus where id=".$row['bus_id']."")->fetch_assoc();
											$totalseat = $h->queryfire("SELECT COUNT(*) AS total_count, GROUP_CONCAT(seat_no) AS total_seats FROM tbl_book_pessenger WHERE book_id=" . $row['id'])->fetch_assoc();
											$i = $i + 1;
											?>
											<tr>
 <td>
 <?php echo $i; ?>
 </td>
 
												
												
 
												
												<td>
 <?php echo $busdata['title']; ?>
 </td>
												
												<td>
 <?php $dateTime = new DateTime($row['bus_board_date']); 
													echo $dateTime->format('jS M Y, g:i A');
													?>
 </td>
												
												<td>
 <?php 
 $dateTime = new DateTime($row['bus_drop_date']);
echo $dateTime->format('jS M Y, g:i A');
													?>
 </td>
 
 <td>
 <?php echo $row['total_seat']; ?>
 </td>
												
												<td>
 <?php echo $row['ticket_price'].$set['currency']; ?> 
 </td>
												
												
												<td><?php echo $totalseat['total_seats'];?></td>
												
												<td>
 <?php echo $row['name']; ?>
 </td>
												<td>
 <?php echo $row['ccode'].$row['mobile']; ?>
 </td>
												
												<td>
 "><?php echo $row['book_status']; ?>
 </td>
												
												<td>
 <?php echo $row['subtotal'].$set['currency']; ?>
 </td>
												
												<td>
 <?php echo $row['wall_amt'].$set['currency']; ?>
 </td>
												
												<td>
 <?php echo $row['cou_amt'].$set['currency']; ?>
 </td>
												
												<td>
 <?php echo $row['tax_amt'].$set['currency']; ?>
 </td>
												
												<td>
 <?php echo $row['total'].$set['currency']; ?>
 </td>
												
												<td>
 <?php echo $row['commission'].$set['currency'].'('.$row['comm_per'].'%)';?>
 </td>
												
												<td>
 <?php echo (($row['subtotal']-$row['cou_amt']) * $row['ope_commission']/100).$set['currency'].'('.$row['ope_commission'].'%)';?>
 </td>
												
												<td>
 <?php echo ($row['subtotal']-($row['cou_amt']+$row['commission'])) - (($row['subtotal']-$row['cou_amt']) * $row['ope_commission']/100).$set['currency'];?>
 </td>
												
												<td>
 <?php if ($row['user_type'] === 'USER') { ?>
 <?php echo $lang['USER'];?>
 <?php } else if ($row['user_type'] === 'AGENT') { ?>
 <?php echo $lang['AGENT'];?>
 <?php }else { ?>
 <?php echo $lang['OPERATOR'];?>
 <?php } ?>
</td>
												
												
												
												
												
 
												
 
										 
 </tr>
											<?php 
										}
										
}
?>