芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/rentandbuyrealty.com/ProZigzagbus Web Admin 1.2/getsales.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'];
	if($_SESSION['stype'] == 'sowner')
						 {
	$city = $h->queryfire("SELECT * FROM `tbl_book` where book_status='Completed' and book_date between '".$start_date."' and '".$end_date."' and operator_id=".$sdata["id"]." order by id desc");
						 }
						 else 
						 {
							 $city = $h->queryfire("SELECT * FROM `tbl_book` where book_status='Completed' and book_date between '".$start_date."' and '".$end_date."' order by id desc"); 
						 }
	
										$i=0;
										while($row = $city->fetch_assoc())
										{
											$busdata = $h->queryfire("SELECT title from tbl_bus where id=".$row['bus_id']."")->fetch_assoc();
											
											$i = $i + 1;
											?>
											<tr>
 <td>
 <?php echo $i; ?>
 </td>
												<td>
 <?php echo $row['id']; ?>
 </td>
 
												<td>
 <?php echo $busdata['title']; ?>
 </td>
												
												
												<td>
 <?php echo $row['subtotal'].$set['currency']; ?>
 </td>
												<td>
 <?php echo $row['tax_amt'].$set['currency'].'('.$row['tax'].'%)'; ?>
 </td>
												<td>
 <?php echo $row['wall_amt'].$set['currency']; ?>
 </td>
												
												<td>
 <?php echo $row['cou_amt'].$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 echo $row['total'].$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 
										}
}
?>