MAINHACK

Viewing / Editing File: all_room_booking.php

<?php
include('header.php');
$show=new Oops($db);
?>
<link href="src/facebox.css" media="screen" rel="stylesheet" type="text/css" />
<script src="src/facebox.js" type="text/javascript"></script>
  <script type="text/javascript">
	jQuery(document).ready(function($) {
	  $('a[rel*=facebox]').facebox({
		loadingImage : 'src/loading.gif',
		closeImage   : 'src/closelabel.png'
	  })
	})
	
	function send(){
		
		if(window.confirm("Do You Really Want To Delete The Data??")){
			
			return true;
		}
		else return false;
		
		
	}
  </script>
<div class="row">
		<div id="page-wrapper">

<div class="main-page">
				
					<div class="tables">
					
					 
					<div class="panel-body widget-shadow">
			<h3 class="title1" style="margin-top: 20px;">All Booked Rooms</h3>
	
			<table class="table" id='example'>
							<thead>
								<tr>  
                                <th>Sl</th>
                                <th>Date</th>
                                <th>Book Id </th>
                                <th>Cus Name/Em/Ph</th>
                               <th>Room Tariff</th>
                               <th>Tax</th>
                                <th>Extra</th>
                              <th>Total</th>
                                <th>Payment Type</th>
                                <th>Booking Mode</th>
                               
                                <th>Show Bill</th>
								</tr>
							 </thead>
			 <tbody>

<?php
$sq="select * from room_booking left join booked_room on room_booking.book_id=booked_room.book_id where room_booking.status='SUCCESS' group by booked_room.book_id";
$q=$con->prepare($sq);
$q->execute();
    while ($row = $q->fetch(PDO::FETCH_ASSOC)){
    extract($row);
    $id=$row['id']; 
    //$total +=$row['total'];
    //$tax +=$row['tax'];
   // $bill +=$row['bill_total'];
   // $extra +=$row['extra']; $bill_id=$row['bill_id'];
    echo "<tr>
    <td>$count</td>
    <td>".date('d-m-Y',strtotime($row['date']))."</td>
    <td>".$row['book_id']."</td>
    <td>".$row['customer_name']."<br>".$row['phone']."<br>".$row['email']."</td>
    <td style='background-color:#5ea8d5;color:#fff;'>".$row['total_tariff']."</td>
    <td style='background-color:#ea3636;color:#fff;'>".$row['gst']."</td>
    <td style='background-color:#2dae59;color:#fff;'>".$row['extra']."</td>
    <td style='background-color:#2dae59;color:#fff;'>".$row['total']."</td>
    <td>".$row['payment_type']."</td>
    <td>".$row['booking_mode']."</td>

<td>
    <a href='bill.php?id=$bill_id&table=$sr&url=".$_SERVER['REQUEST_URI']."' target='_blank' class='btn btn-xs btn-success'>Show Bill</a>
    </td>
</tr>";

++$count;
 }

?>							
</tbody>
</table>
<table style="width:200px;padding:10px;">
    <tr style="background-color:#95ca56"><td style="padding:10px;">Gross Total:</td><td><?=$total?></td></tr>
    <tr style="background-color:#95ca56"><td style="padding:10px;">Tax:</td><td><?=$tax?></td></tr>
    <tr style="background-color:#95ca56"><td style="padding:10px;">Extra:</td><td><?=$extra?></td></tr>
    <tr style="background-color:#95ca56"><td style="padding:10px;">Total:</td><td><?=$bill?></td></tr>
</table>
</div>
</div>
</div>
</div></div>

<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_room_booking.php

Server Info

System Features

User Info