芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/rentandbuyrealty.com/ProZigzagbus Web Admin 1.2/getdaily.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['book_date']))
{
$timestamp = $_POST['book_date'];
 if($_SESSION['stype'] == 'sowner')
						 {
							 $totalbook = $h->queryfire("select count(*) as total_book from tbl_book where book_date='".$timestamp."' and operator_id=".$sdata["id"]."")->fetch_assoc();
						 $totalcom = $h->queryfire("select count(*) as total_complete from tbl_book where book_date='".$timestamp."' and book_status='Completed' and operator_id=".$sdata["id"]."")->fetch_assoc();
						 $totalcan = $h->queryfire("select count(*) as total_complete from tbl_book where book_date='".$timestamp."' and book_status='Cancelled' and operator_id=".$sdata["id"]."")->fetch_assoc();
						 $sales = $h->queryfire("SELECT sum((subtotal -(cou_amt+commission)) - ((subtotal -cou_amt) * ope_commission/100)) as total_earning FROM `tbl_book` where book_status='Completed' and book_date='".$timestamp."'")->fetch_assoc();
	
	
	$bs=0;
	if(empty($sales['total_earning'])){}else {$bs = number_format((float)($sales['total_earning']), 2, '.', ''); }
	
	
						 }
						 else 
						 {
						 $totalbook = $h->queryfire("select count(*) as total_book from tbl_book where book_date='".$timestamp."'")->fetch_assoc();
						 $totalcom = $h->queryfire("select count(*) as total_complete from tbl_book where book_date='".$timestamp."' and book_status='Completed'")->fetch_assoc();
						 $totalcan = $h->queryfire("select count(*) as total_complete from tbl_book where book_date='".$timestamp."' and book_status='Cancelled'")->fetch_assoc();
						 $sales = $h->queryfire("SELECT sum(subtotal+tax_amt-cou_amt) as total_earning FROM `tbl_book` where book_status='Completed' and book_date='".$timestamp."'")->fetch_assoc();
	
	
	$bs=0;
	if(empty($sales['total_earning'])){}else {$bs = number_format((float)($sales['total_earning']), 2, '.', ''); }
	
	
						 }
	
	
?>
<tr>
											
											<td>
 <?php echo $lang['Total_Booked_Tickets'];?>
 </td>
												
 <td>
 <?php echo $totalbook['total_book']; ?>
 </td>
 </tr>
												
												<tr>
												<td>
 <?php echo $lang['Total_Completed_Tickets'];?>
 </td>
												
 <td>
 <?php echo $totalcom['total_complete']; ?>
 </td>
												
 </tr>
												
												<tr>
												<td>
 <?php echo $lang['Total_Cancelled_Tickets'];?>
 </td>
												
 <td>
 <?php echo $totalcan['total_complete']; ?>
 </td>
												
 </tr>
												
												<tr>
												<td>
 <?php echo $lang['Total_Sales'];?>
 </td>
												
 <td>
 <?php echo $bs.$set['currency']; ?>
 </td>
												
 </tr>
												
												
<?php 
}
?>