bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<head>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/clockpicker/0.0.7/bootstrap-clockpicker.min.css" rel="stylesheet">
</head>
<?php

if(isset($_GET['token']))
{
    $token=$_GET['token'];
}
else
{
    header("location:404");
}
require_once 'header.php';
require_once 'navbar.php';

if($_SERVER["REQUEST_METHOD"] == "POST")
{

if(isset($_POST['book']))
    {   
        $name=$_POST['name'];
        $email=$_POST['email'];
        $phone=$_POST['phone'];
        $booking_from=test_input($_POST['booking_from']);
		$booking_to=test_input($_POST['booking_to']);
		$pickup_date=date("Y-m-d",strtotime($_POST['pickup_date']));
		$pickup_time=date('H:i',strtotime($_POST['booking_time']));
        $cab_name=test_input($_POST['cab_name']);
        $trip_type=test_input($_POST['trip_type']);
        $amount=test_input($_POST['amount']);
        $pickup_address=test_input($_POST['address']);
         $distance=test_input($_POST['distance']); 
         $night_charge=test_input($_POST['night_charge']);
        $commission=test_input($_POST['commission']);
        $vendor_accepteds=test_input($_POST['vendor_accepted']);
        $user_id=test_input($_POST['user_id']);
        $toll=test_input($_POST['toll']);
        $remark=test_input($_POST['remark']);
        if($trip_type!='Round Trip')
        {

$sql = "update bookings JOIN users ON (bookings.user_id = users.id) 
SET bookings.booking_from = '$booking_from', 
    bookings.booking_to = '$booking_to',
    bookings.pickup_date = '$pickup_date', 
    bookings.pickup_time = '$pickup_time',
    bookings.pickup_address = '$pickup_address', 
    bookings.cab_type = '$cab_name',
    bookings.trip_type = '$trip_type', 
    bookings.price = '$amount',
    bookings.admin_commission = '$commission', 
    bookings.accepted_vendor = '$vendor_accepteds', 
    bookings.distance = '$distance', 
    bookings.night_charge = '$night_charge',
    bookings.toll_tax = '$toll_tax', 
    bookings.remark = '$remark', 
    users.name = '$name', 
    users.contact = '$phone',
    users.email = '$email'  
WHERE bookings.id = '$token'";

// $sql="update bookings set booking_from='$booking_from',booking_to='$booking_to',pickup_date='$pickup_date',pickup_time='$pickup_time',pickup_address='$pickup_address',cab_type='$cab_name',trip_type='$trip_type',price=$amount,admin_commission=$commission,accepted_vendor=$vendor_accepteds,distance=$distance,night_charge='$night_charge',toll_tax='$toll',remark='$remark', where id=$token";
        }
        else 
        {
            $drop_date=date("Y-m-d",strtotime($_POST['drop_date']));
            $sql = "update bookings JOIN users ON (bookings.user_id = users.id) 
SET bookings.booking_from = '$booking_from', 
    bookings.booking_to = '$booking_to',
    bookings.pickup_date = '$pickup_date', 
    bookings.drop_date = '$drop_date', 
    bookings.pickup_time = '$pickup_time',
    bookings.pickup_address = '$pickup_address', 
    bookings.cab_type = '$cab_name',
    bookings.trip_type = '$trip_type', 
    bookings.price = '$amount',
    bookings.admin_commission = '$commission', 
    bookings.accepted_vendor = '$vendor_accepteds', 
    bookings.distance = '$distance', 
    bookings.night_charge = '$night_charge',
    bookings.toll_tax = '$toll_tax', 
    bookings.remark = '$remark', 
    users.name = '$name', 
    users.contact = '$phone',
    users.email = '$email'  
WHERE bookings.id = '$token'";
        }
        
        if($conn->query($sql)===true)
        {
            $booking_id = $conn->insert_id;
            $ORDER_ID=$user_id.time().uniqid(mt_rand(),true);
            $sql="insert into payment_log(booking_id,txn_id,txn_amount,txn_status) values('$booking_id','$ORDER_ID',0,1)";
            if($conn->query($sql)===true)
            {
                $success=true;
                $title="New Booking";
				$content=$booking_from ." to ".$booking_to;
		    //	pushapi($title,$content,$link);
            }
                   
        }
        else    
        {
            $error=$conn->error;    
        }
    }
}
  $sql="select * from trips";
      	$result=$conn->query($sql);
      	if($result->num_rows>0)
      	{
      		while($row=$result->fetch_assoc())
              {
                  $trips[]=$row;
              }
      	}
      	  $sql="select * from cab_types";
      	$result=$conn->query($sql);
      	if($result->num_rows>0)
      	{
      		while($row=$result->fetch_assoc())
              {
                  $cab_types[]=$row;
              }
      	}
      		$sql="SELECT * FROM `package_types` ";
      	$result=$conn->query($sql);
      	if($result->num_rows>0)
      	{
      		while($row=$result->fetch_assoc())
              {
                  $packages[]=$row;
              }
      	}
      	
      	$sql="select name,contact,id from users";
      	$result=$conn->query($sql);
      	if($result->num_rows>0)
      	{
      		while($row=$result->fetch_assoc())
              {
                  $users[]=$row;
              }
      	}
      	
      		$sql="select * from bookings INNER JOIN users ON bookings.user_id=users.id where bookings.id=$token";
      	$result=$conn->query($sql);
      	if($result->num_rows>0)
      	{
      		$booking=$result->fetch_assoc();
              
      	}

// $sql="select bookings.*,users.* from bookings,users where users.id=bookings.user_id and id=$token";
        
?>					
				
						<div class="container-fluid pt-8">
							<div class="page-header mt-0 shadow p-4">
								<h3 class="mb-sm-0"> Edit Booking</h3>
								<ol class="breadcrumb mb-0">
									<li class="breadcrumb-item"><a href="#"><i class="fe fe-home"></i></a></li>
									<li class="breadcrumb-item active" aria-current="page">Edit Booking</li>
								</ol>
							</div>
			          </div>  
			          
			            <?php
            if(isset($success))
            {
                ?>
                 <div class="alert alert-success" id="success" >Success! Your Request has been submited.</div>
                <?php
            }
            else if(isset($error))
            {
                ?>
                 <div class="alert alert-danger" id="success" ><?=$error;?></div>
                <?php
            }
            ?>
			     <div class="alert alert-success" id="success" style="display:none">Success! Your Request has been submited.</div>
			     
			     <div class="card shadow">
            <div class="card-header">
               <h2 class="mb-0">Edit Bookings Now </h2>
            </div>
            <form id="cab_book" method="post" >
               <div class="card-body">
                  <div class="row">
                    <div class="col-md-4">
                        <div class="form-group">
                           <label>Name</label>
                           <input class="form-control" name="name" type="text" value="<?=$booking['name'];?>" placeholder="Name" >
                        </div>
                     </div>
                     <div class="col-md-4">
                        <div class="form-group">
                           <label>Phone Number</label>
                           <input class="form-control" name="phone" type="text" value="<?=$booking['contact'];?>" placeholder="Phone Number" >
                        </div>
                     </div>
                     <div class="col-md-4">
                        <div class="form-group">
                           <label>Email</label>
                           <input class="form-control" name="email" type="text" value="<?=$booking['email'];?>" placeholder="Email" >
                        </div>
                     </div>
                     <div class="col-md-4">
                        <div class="form-group">
                           <label>From</label>
                           <input id="startaddress" class="form-control" type="text" name="booking_from" value="<?=$booking['booking_from'];?>" placeholder="From">
                        </div>
                        
                     </div>
                     <div class="col-md-4">
                        <div class="form-group">
                           <label>To</label>
                           <input id="endaddress" class="form-control" name="booking_to" type="text" value="<?=$booking['booking_to'];?>" placeholder="To" >
                        </div>
                     </div>
                     <div class="col-md-4">
                        <div class="form-group">
                           <label>Pickup Address</label>
                           <div class="input-group ">
                            
                              <input class="form-control " name="address" placeholder="Pickup address" value="<?=$booking['pickup_address'];?>" type="textr" >
                           </div>
                        </div>
                     </div>
                     
                      
                      <div class="col-md-2">
                        <div class="form-group">
                           <label>Cab Type</label>
                           <select class="form-control select2 w-100"  name="cab_name" id="trip_type1" >
                              <?php
                                 if(isset($cab_types))
                                   {
                                       foreach($cab_types as $cab)
                                       {
                                           if($cab['type']==$booking['cab_type'])
                                           {
                                               ?>
                                               <option value="<?=$cab['type'];?>" selected><?=$cab['type']?></option>
                                               <?php
                                           }
                                           else
                                           {
                                           ?>
                              <option value="<?=$cab['type'];?>"><?=$cab['type']?></option>
                              <?php
                                           }
                                 }
                                 }
                                 ?>
                           </select>
                        </div>
                     </div>
                     <div class="col-md-2">
                        <div class="form-group">
                           <label>Trip Type</label>
                           <select class="form-control select2 w-100" onchange="change(this.value);" name="trip_type" id="trip_type1" >
                              <?php
                                 if(isset( $packages))
                                   {
                                       foreach( $packages as  $package)
                                       {
                                           if($package['type']==$booking['trip_type'])
                                           {
                                               ?>
                                               <option value="<?=$package['type'];?>" selected><?=$package['type']?></option>
                                               <?php
                                           }
                                           else
                                           {
                                           ?>
                                           ?>
                              <option value="<?=$package['type'];?>"><?=$package['type']?></option>
                              <?php
                                           }
                                 }
                                 }
                                 ?>
                           </select>
                        </div>
                     </div>
                    
                      
                     
                     <div class="col-md-3">
                        <div class="form-group">
                           <label>Pick up Date</label>
                           <div class="input-group ">
                              <div class="input-group-prepend">
                                 <span class="input-group-text"><i class="ni ni-calendar-grid-58"></i></span>
                              </div>
                              <input class="form-control" id="pickup_date" placeholder="Select date" type="date" value="<?=$booking['pickup_date'];?>"  name="pickup_date">
                           </div>
                        </div>
                     </div>
                     
                     <?php
                     if($booking['trip_type']=='Round Trip')
                     {
                         ?>
                      <div class="col-md-3" id="drop">
                        <div class="form-group">
                           <label>Drop Date</label>
                           <div class="input-group ">
                              <div class="input-group-prepend">
                                 <span class="input-group-text"><i class="ni ni-calendar-grid-58"></i></span>
                              </div>
                              <input class="form-control datepicker" id="drop_date" placeholder="Select date" type="text" value="<?=$booking['drop_date'];?>" name="drop_date">
                           </div>
                        </div>
                     </div>
                     <?php
                     }
                     ?>
                     
                    <div class="col-md-2">
                        <div class="form-group">
                           <label>Pick Up Time</label>
                           <div class="input-group ">
                              <div class="input-group-prepend">
                                 <span class="input-group-text"><i class="ni ni-clock"></i></span>
                              </div>
                              <input class="form-control timepicker" id="pickup_time" name="booking_time"  value="<?=date("h:i a",strtotime($booking['pickup_time']));?>"placeholder="Select Time" type="text" >
                           </div>
                        </div>
                     </div>
                     <div class="col-md-2">
                        <div class="form-group">
                           <label>Amount</label>
                           <div class="input-group ">
                              
                              <input class="form-control " name="amount" placeholder="Enter Amount"  value="<?=$booking['price'];?>" type="number" >
                           </div>
                        </div>
                     </div>
                    
                       <div class="col-md-2">
                        <div class="form-group">
                           <label>Commission Amount</label>
                           <div class="input-group ">
                              <input class="form-control " name="commission" value="<?=$booking['admin_commission'];?>" placeholder="Commission amount" type="number" >
                           </div>
                        </div>
                     </div>
                     
                     <div class="col-md-2">
                        <div class="form-group">
                           <label>Distance (Km)</label>
                           <div class="input-group ">
                              <input class="form-control " name="distance" value="<?=$booking['distance'];?>" placeholder="Distance" type="number" required>
                           </div>
                        </div>
                     </div>
                     
                     <div class="col-md-2">
                        <div class="form-group">
                           <label>Night Charge</label>
                           <div class="input-group ">
                              <input class="form-control " name="night_charge" value="<?=$booking['night_charge'];?>" placeholder="Night Charge" type="number">
                           </div>
                        </div>
                     </div>
                     
                     <div class="col-md-2">
                        <div class="form-group">
                           <label>Accept by Vendor</label>
                           <select class="form-control select2 w-100"name="vendor_accepted" >
                               <?php
                               if($booking['accepted_vendor'])
                               {
                                   ?>
                                   <option value="1">Yes</option>
                                   <option value="0">No</option>
                                   <?php
                               }
                               else
                               {
                                   ?>
                                    <option value="0">No</option>
                                   
                                    <option value="1">Yes</option>
                                <?php
                               }
                               ?>
                              
                           </select>
                        </div>
                     </div>
                     
                      <div class="col-md-4">
                        <div class="form-group">
                           <label>Toll Tax</label>
                           <select class="form-control select2 w-100"  name="toll"  >
                            
                            <?php
                            if($booking['toll_tax']==1 || $booking['toll_tax']=='')
                            {
                                ?> 
                                <option value="1">Excluding</option>
                                <option value="0">Including</option>
                                <?php
                            }
                            else
                            {
                                ?>
                                 <option value="0">Including</option>
                                  <option value="1">Excluding</option>
                                <?php
                            }
                            ?>  
                            
                           </select>
                        </div>
                     </div>
                     
                      
                     
                     <div class="col-md-4">
                        <div class="form-group">
                           <label>Remark</label>
                           <div class="input-group ">
                              <input class="form-control " name="remark" placeholder="Remark" value="<?=$booking['remark'];?>" type="text">
                           </div>
                        </div>
                     </div>
                     
                     
                     <div class="col-md-2">
                        <br>
                        <div class="form-group">
                           <button class="btn btn-icon btn-info mt-1 mb-1"   type="submit" name="book">
                           <span class="btn-inner--icon">
                           <span class="btn-inner--text">Book Now</span>
                           </button>
                        </div>
                     </div>
                  </div>
               </div>
            </form>
         </div>
		
<div class="modal fade" id="modal-default">
    <div class="modal-dialog">
        <div class="modal-content">
          <div class="card-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">&times;</span>
            </button>
               <div class="alert alert-danger"   id="error" style="display:none">Error! Your Request could not be submited.</div>
               
              <h4 style="text-align: left">Create New Customer Account</h4><div class="col-md-6 float-right" id="alert"></div>
          </div> 
          <form method="post" id="add_vendor">
          <div class="modal-body">
              <div class="row">
                 <div class="col-md-6">
                      <label>Full Name :</label><input type="text" class="form-control" name="name">
                  </div>
                  
                 <div class="col-md-6">
                      <label>Email :</label><input type="email" class="form-control" name="email">
                  </div>
                    <div class="col-md-6">
                     <label>Contact :</label><input type="number" id="contact" class="form-control" name="contact" title="Please Enter Correct Contact Number">
                  </div>
                  <div class="col-md-6">
                     <label>Alt Contact :</label><input type="number" id="contact" class="form-control" name="alt_contact" title="Please Enter Correct Contact Number">
                  </div>
                  
              </div>
            </div>
          <div class="modal-footer">
            <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
            <button type="submit" name="request" id="add" class="btn btn-primary" >Add</button>
          </div>
            </form>
        </div>
    
    </div>

</div>	          
<?php 
require_once 'footer.php';
require_once 'jslinks.php';
?>
<script src="assets/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/clockpicker/0.0.7/bootstrap-clockpicker.js"></script>
<script>

$('.datepicker').datepicker();
    $('.timepicker').clockpicker({
   align: 'left',
   donetext: 'Done',
   twelvehour: true,
   
   });
   
     $(document).ready(function(){
    
     
  $('#add_vendor').submit(function(e) {
      e.preventDefault();
      $("#global-loader").show();
   $.ajax({
				type: 'POST',
				url: 'ajax_user',
				data: new FormData(this),
				contentType: false,
				cache: false,
				processData:false,
				success:function(response){
                    $("#global-loader").fadeOut();
                    var obj=JSON.parse(response);
                if(obj.msg == "ok") {
                   
                    $('#user').append($('<option>', {value:obj.id, text:obj.name+","+obj.contact}));
                    
                    $("#user").val(obj.id);
                    $('#success').show();
                     $('#modal-default').modal('toggle');
            
            }
            else {
                $('#error').html(obj.msg);
             $('#error').show();
            }
      }
    })
      $('#add_vendor').trigger("reset");
  });
	 
 });
    
 
    
    
     flag=0;
    function change(str)
    {
        if(flag>0)
            {
                if(str=='One Way')
                    {
                        $('#drop').hide();
                    }
                else
                {
                    $('#drop').show();
                }
            }
        flag++;
    }
</script>
<script src="https://maps.google.com/maps/api/js?key=<?=$google_key?>&libraries=places&callback=initAutocomplete" type="text/javascript"></script>
   <script>
   function AutoComplete() {
  
          var options = {
          types:'cities',
          componentRestrictions: {country: "in"}
          };
           //=============Input Fields 1 and Select it========
         var input1 = document.getElementById('startaddress');
      //===============adding google location search event=================
      new google.maps.places.Autocomplete(input1,options);
   
           //=============Input Fields 2 and Select it========
         var input2 = document.getElementById('endaddress');
      //===============adding google location search event=================
      new google.maps.places.Autocomplete(input2,options);
   }
   
   //======================Register Focus out Listener on Input Fields so we calculate distance and Time
   // document.getElementById("startaddress").addEventListener("focusout", getDistance);
   // document.getElementById("endaddress").addEventListener("focusout", getDistance);
   
   
   
   //===========================Call The Autocomplete Function of Our Page Ready===============
   google.maps.event.addDomListener(window, 'load', AutoComplete);
   </script>