MAINHACK

Viewing / Editing File: room_booking.php

<?php include 'header.php' ;

$show=new Oops($db);
?>

#fli,#fli1
	{
	
	}
	#display
	{
		position:absolute;
		width:315px;
		margin-left:0;
		margin-top:0px;
		max-height:300px;
		padding:2px;
		display:none;
		border-top:0px;
		overflow:auto;
		border:1px #CCC solid;
		background-color: white;
		z-index:1000;
	}	
	
	.show,.show1
	{
		padding:7px; 
		border-bottom:1px #999 dashed;
		font-size:15px; 
		
	}
	
	.show:hover,.show1:hover
	{
		background:#4f52ba;
		color:#FFF;
		cursor:pointer;
	}	
.widget{
	overflow:visible !important;
	
}	
</style>
<script>
function fill(Value,Value1,Value2,Value3)
{
$('#cid').val(Value);
$('#c_name').val(Value1);
$('#phone').val(Value2);
$('#email').val(Value3);
$('#display').hide();

}

$(document).ready(function(){
$("#phone").keyup(function() {
var cphone = $('#phone').val();

if(cphone=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "cphone="+ cphone ,
success: function(html){
$("#display").html(html).show();
}
});
}
});
});

$(document).ready(function(){
$("#search").click(function() {
var from = $('#date1').val(); 
var to = $('#date2').val();// alert(from);
var book_id = $('#book_id').val(); 
if(from=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "from_date="+ from+"&to_date="+to+"&bid="+book_id ,
success: function(html){
$("#show_book").html(html).show();
}
});
}
});
});
function room(Value,Value1,Value2,Value3,Value4,Value5,Value6){
var from1 = $('#date1').val(); 
var to1 = $('#date2').val();
var bookd = $('#book_id').val();
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "insert_room_data="+ Value+"&p_id="+Value1+"&room_no="+Value2+"&pax="+Value3+"&price="+Value4+"&category="+Value5+"&from_date="+ from1+"&to_date="+to1+"&book_id="+bookd+"&gst="+Value6,
success: function(data){
$('#show_book').hide();
show_booked(bookd);
$('#cus_details').show();

}
});
}
function show_booked(data){
$.ajax({
type: "POST",
url: "selected_room.php",
data: "bid="+ data,
success: function(html){ 
$('#room_details').html(html).show();

}
    
});  
}
$(document).ready(function(){
$("#extra").keyup(function() {
$('#extra_tot').show();
 
var a=$('#room_total').val(); 
 var b=$('#total_gst').val(); 
 var extra=$('#extra').val(); 
 var t=parseFloat(a)+parseFloat(b)+parseFloat(extra);
  $('#total_amt').val(t);
});

});
</script>

<div id="page-wrapper">
<div class="main-page">
    
 <div class="row">
                            <div class="form-grids row widget-shadow">
                            <div class="form-title">
                            <h4>Book a Room  :</h4>
                          <form method="post">
                            <input type="hidden" value="<?='HRB'.date('Ymdh').rand(0,9999)?>" name="book_id" id="book_id">
                             </div><br>
                            <div class="form-group">
                            <div class="col-md-3">
                            <label>From Date</label>
                            <div class="input-group">
                            <input type="text" class="form-control" id="date1" value="<?=date('d-m-Y')?>" placeholder="Table No">
                            <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                            </div>    
                            </div>
						    <div class="col-md-3">
                            <label>To Date</label>
                            <div class="input-group">
                            <input type="text" class="form-control" id="date2" value="<?=date('d-m-Y')?>" placeholder="Table No">
                            <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                            </div>    
                            </div>
                            <div class="col-md-3">
                            <input type="button" id="search" name="sub" value="Search" class="btn btn-info">
                           </div>
                           	<div class="clearfix"></div>
                            <br>
                            </div>
                           <div id="show_book"></div>
                           <div class="form-group" style="background-color:#c7e8c7;" id="room_details">
					
						<div class="clearfix"></div>
                           	</div>										
                            
                            <div id="cus_details" class="form-group" style="display:none">
                            <div class="col-md-12">
                            <h4>Customer details</h4>
                            </div>     
                            <hr>
							<div class="col-md-3">	
							<label>Customer Phone</label>
                            <input type="text" name="phone" id="phone" pattern="[0-9]+" title="phone no only" maxlength="10" class="form-control" placeholder="Customer Phone" required />
							<div id="display"></div>
							</div>
						   <div class="col-md-3">	
							<label>Customer Name</label>
                            <input type="text" name="c_name" id="c_name"  class="form-control" required />
                            <input type="hidden" name="customer_id" id="cid" />

</div>   
							<div class="col-md-3">	
							<label>Email</label>
                            <input type="text" name="email" id="email" class="form-control" required />
							</div>
							<div class="col-md-3">	
							<label>Payment Type</label>
                            <select class="form-control" id="paytype" name="payment_type" required />
                            <option value="">Choose</option>
                            <option value="CARD">CARD</option>
                            <option value="CASH">CASH</option>
                            </select>
							</div>
							<div class="col-md-3">	
							<label>Payment Status</label>
                            <select class="form-control"  name="payment_status" required />
                            <option value="">Choose</option>
                            <option value="PAID">PAID</option>
                            <option value="UNPAID">UNPAID</option>
                            </select>
							</div>
							<div class="col-md-3">	
							<label>Extra any thing</label>
                            <input type="text" name="extra_reason"  class="form-control" required />
							</div>
								<div class="col-md-3">	
							<label>Extra Charges</label>
                            <input type="text" name="extra"  id="extra" class="form-control" required />
							</div>
							
							<div class="col-md-3" id="extra_tot" style="display:none">	
							<label>Total</label>
                            <input type="text"  id="total_amt" class="form-control" required />
							</div>
                            <div class="col-md-3">
                            <div class="form-group" style="padding:10px">	
    						<input type="submit" name="book_now" value="Book Now" class="btn btn-info">
                            
	                        </div></div>
	                       <div class="clearfix"></div>

</div>		
                                    </form>	
<?php 
if(isset($_POST['book_now']))
{
 if($_POST['customer_id']==""){
    $cid=$show->getid('ids','CID'); 
    $data=array(
        'client_id'=>$cid,
         'name'=>$_POST['c_name'],
        'phone'=>$_POST['phone'],
        'email'=>$_POST['email'],
       
         );
 }else{$cid=$_POST['customer_id'];}
 
$sq=$show->readwithdata('booked_room','book_id',$_POST['book_id']);
$c=$sq->rowCount();$count=1;
while($row = $sq->fetch(PDO::FETCH_ASSOC)){  
$total +=$row['room_price'];
$total_gst +=($row['room_gst']/100)*$row['room_price'];
$total_tar =(($row['room_gst']/100)*$row['room_price'])+$total;
}
  $data=array(
        'book_id'=>$_POST['book_id'],
        'customer_name'=>$_POST['book_id'],
        'phone'=>$_POST['phone'],
        'email'=>$_POST['email'],
        'customer_id'=>$cid,
        'total_tariff'=>$total,
        'gst'=>$total_gst,
        'extra_reason'=>$_POST['extra_reason'],
        'extra'=>$_POST['extra'],
        'total'=>$total_tar+$_POST['extra'],
        'payment_type'=>$_POST['payment_type'],
        'payment_status'=>$_POST['payment_status'],
        'payment_type'=>$_POST['payment_type'],
        'date'=>date('Y-m-d'),
        'booking_mode'=>'OFFLINE',
        'updated_by'=>'ADMIN',
        'status'=>'SUCCESS'
         );   
        // print_r($data);
   $r=$show->insert('room_booking',$data);
if($r){
$s="update booked_room set status='BOOKED' where book_id='".$_POST['book_id']."'";
$s1=$con->prepare($s); $s1->execute();
  echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "Your Room has been booked",
            type: "success"
        }, function() {
            window.location = "all_room_booking.php";
        });
    }, 1000);
</script>';

}      
         
}

?>						
        </div>	</div>
        
        </div>
        </div>
        </div>
                   
             
	    
</div>
	</div>
				
				
<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: room_booking.php

Server Info

System Features

User Info