<?php

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

$time_stamp = date('Y-m-d H:i:s');

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


  if(isset($_POST['book']))
  {   
    $booking_stops = implode("/", $_POST['booking_stops']);
    $booking_from=test_input($_POST['booking_from']);
    $booking_to=test_input($_POST['booking_to']);
    $extra_requirement = implode(",", $_POST['extra_requirement']);
    $pickup_date=date("Y-m-d",strtotime($_POST['pickup_date']));
    $drop_date=date("Y-m-d",strtotime($_POST['drop_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']);
    $incentive=test_input($_POST['incentive']);
    $pickup_address=test_input($_POST['address']);
    $drop_address=test_input($_POST['drop_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_tax=test_input($_POST['toll']);
    $parking=test_input($_POST['parking']);
    $state_tax=test_input($_POST['state_tax']);
    $remark=test_input($_POST['remark']);
    $extra_price=test_input($_POST['extra_price']);
    $carrier=test_input($_POST['carrier']);
    $driver_app=test_input($_POST['driver_app']);
    $company_booking_type=test_input($_POST['company_booking_type']);
    $company_booking_id=test_input($_POST['company_booking_id']);
    $city=test_input($_POST['city']);
    $package_id=test_input($_POST['package_id']);
    if ($trip_type=='Local') {
      $booking_from=$pickup_address;
      $booking_to=$city;
   }

   $sql = "UPDATE bookings SET
   user_id = '$user_id', 
   booking_from = '$booking_from', 
   booking_to = '$booking_to',
   pickup_date = '$pickup_date', 
   drop_date = '$drop_date', 
   pickup_time = '$pickup_time',
   pickup_address = '$pickup_address', 
   drop_add = '$drop_address', 
   cab_type = '$cab_name',
   trip_type = '$trip_type', 
   price = '$amount',
   incentive = '$incentive',
   admin_commission = '$commission', 
   distance = '$distance', 
   night_charge = '$night_charge',
   parking = '$parking',
   toll_tax = '$toll_tax', 
   state_tax = '$state_tax', 
   extra_price = '$extra_price',
   carrier = '$carrier',
   driver_app = '$driver_app',
   company_booking_type='$company_booking_type', 
   company_booking_id='$company_booking_id', 
   booking_stops='$booking_stops', 
   extra_requirement='$extra_requirement', 
   city='$city', 
   pid='$package_id', 
   remark = '$remark' 
   WHERE id = '$token'";


   if($conn->query($sql))
   {
      $admin_user_id=$_SESSION['session_login'];

      $sql=$conn->query("INSERT INTO user_role_activity(booking_id,user_id,type,created_at) VALUES ('$token','$admin_user_id','Edit Booking','$time_stamp')");
      $success=true;

   }
   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 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 where bookings.id=$token";
$result=$conn->query($sql);
if($result->num_rows>0)
{
 $booking=$result->fetch_assoc();
 $Extrarequirement = explode(',',$booking['extra_requirement']);

}

$sql="select * from booking_types";
$result=$conn->query($sql);
if($result->num_rows>0)
{
 while($row=$result->fetch_assoc())
 {
   $booking_types[]=$row;
}
}

$sql="select * from operate_cities";
$result=$conn->query($sql);
if($result->num_rows>0)
{
 while($row=$result->fetch_assoc())
 {
  $operate_city[]=$row;
}
}

$sql="SELECT * FROM package_types WHERE parent_id=0";
$result1=$conn->query($sql);
if($result1->num_rows>0)
{
 while($row=$result1->fetch_assoc())
 {
   $packages[]=$row;
}
}

$sql="select * from profiles";
$result=$conn->query($sql);
if($result->num_rows>0)
{
  $profile_data=$result->fetch_assoc();
}
?>             

<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>Customer</label>
               <select class="form-control select2" name="user_id" required>
                  <?php foreach($users as $user){ ?>
                     <option value="<?=$user['id']?>" <?php if($booking['user_id']==$user['id']){echo 'selected';} ?>><?=$user['name']?> - <?=$user['contact']?></option>
                  <?php } ?>
               </select>
            </div>
         </div>

         <div class="col-md-4">
            <div class="form-group">
             <label>Cab Type</label>
             <select class="form-control select2 w-100"  name="cab_name">
              <?php
              if(isset($cab_types))
              {
                 foreach($cab_types as $cab)
                 {
                  ?>
                  <option value="<?=$cab['type'];?>" <?php if($booking['cab_type']==$cab['type']){echo 'selected';} ?>><?=$cab['type']?></option>
                  <?php
               }
            }
            ?>
         </select>
      </div>
   </div>
   <div class="col-md-4">
    <div class="form-group">
     <label>Trip Type</label>
     <select class="form-control w-100" onchange="tripType(this.options[this.selectedIndex].id, this.value);" name="trip_type"> 
       <?php
       if (isset($packages)) {
        foreach ($packages as $package) {
         ?>
         <option value="<?= $package['type']; ?>" id="<?= $package['id']; ?>" <?php if($booking['trip_type']==$package['type']){echo 'selected';} ?>><?= $package['type'] ?></option>
         <?php
      }
   }
   ?>
</select>

</div>
</div>
<div class="col-md-4 package_display_none">
 <div class="form-group">
  <label>Select City</label>
  <select class="form-control select2 w-100" name="city">
   <?php
   if(isset($operate_city))
   {
      foreach($operate_city as $city)
      {
       ?>
       <option value="<?=$city['city'];?>" <?php if($booking['city']==$city['city']){echo 'selected';} ?>><?=$city['city']?></option>
    <?php } } ?>
 </select>
</div>
</div>
<div class="col-md-4 package_display_none">
 <div class="form-group">
  <label>Select Package</label>
  <select class="form-control select2 w-100" name="package_id" id="package_type">

  </select>
</div>
</div>

</div>
<div class="row round_list display_none">
   <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 <button type="button" class="add_field_button">Add Field</button></label>
     <input id="endaddress" class="form-control" name="booking_to" type="text" value="<?=$booking['booking_to'];?>" placeholder="To" >
  </div>
</div>

<?php
$i=1;
if (!empty($booking['booking_stops'])) {
 $booking_stop=explode('/', $booking['booking_stops']);
 $totalstops= count($booking_stop);
 foreach($booking_stop as $booking_s){ ?>

  <div class="col-md-4">
   <div class="form-group">
    <label>Booking Stops</label>
    <input id="bookingstops<?=$i;?>" class="form-control" type="text" name="booking_stops[]" value="<?=$booking_s;?>" placeholder="From">
 </div>
</div>

<?php $i++; } } ?>
</div>

<div class="row">
   <div class="col-md-4">
      <div class="form-group">
         <label>Pickup Address</label>
         <div class="input-group ">

            <input class="form-control" id="pickup_address" name="address" placeholder="Pickup address" value="<?=$booking['pickup_address'];?>" type="text" >
         </div>
      </div>
   </div>

   <div class="col-md-2">
      <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" type="date" value="<?=$booking['pickup_date'];?>" min="<?=date('Y-m-d')?>"  name="pickup_date" required>
         </div>
      </div>
   </div>

   <div class="col-md-2" 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" type="date" value="<?=$booking['drop_date'];?>" min="<?=date('Y-m-d')?>" name="drop_date">
         </div>
      </div>
   </div>

   <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="fa fa-clock"></i></span>
            </div>
            <input class="form-control" name="booking_time"  value="<?=$booking['pickup_time'];?>" placeholder="Select Time" type="time" required>
         </div>
      </div>
   </div>
   <div class="col-md-2">
      <div class="form-group">
         <label>Amount</label>
         <div class="input-group ">

            <input class="form-control" id="amountInput" name="amount" placeholder="Enter Amount"  value="<?=$booking['price'];?>" type="number" >
         </div>
      </div>
   </div>
   <div class="col-md-2">
      <div class="form-group">
         <label>Incentive</label>
         <div class="input-group ">

            <input type="number" class="form-control" name="incentive" placeholder="Enter Incentive" value="<?=$booking['incentive'];?>">
         </div>
      </div>
   </div>

   <div class="col-md-2">
      <div class="form-group">
         <label>Commission Amount</label>
         <div class="input-group ">
            <input class="form-control" id="admin_commission" 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 mt-20">
     <div class="form-group">
        <label>Parking</label>
        <select class="form-control w-100 valid" name="parking">
         <?php
         if($booking['parking']==0)
         {
           ?>
           <option value="0">Including</option>
           <option value="1">Excluding</option>
           <?php
        }
        else
        {
           ?>
           <option value="1">Excluding</option>
           <option value="0">Including</option>
           <?php
        }
        ?>
     </select>
  </div>
</div>
<div class="col-md-2 mt-20">
   <div class="form-group">
      <label>State Tax</label>
      <select class="form-control w-100" name="state_tax" required>
         <?php
         if($booking['state_tax']==1)
         {
           ?>
           <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-2">
   <div class="form-group">
      <label>Toll Tax</label>
      <select class="form-control w-100"  name="toll" required>

        <?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-2">
  <div class="3-group">
     <label>Carrier</label>
     <select class="form-control w-100"  name="carrier" >
        <option value="0" <?php if($booking['carrier']==0){ echo 'selected';}?>>No</option>
        <option value="1" <?php if($booking['carrier']==1){ echo 'selected';}?>>Yes</option>
     </select>
  </div>
</div>
<div class="col-md-3">
  <div class="3-group">
     <label>Driver App/Non App</label>
     <select class="form-control w-100" name="driver_app" >
        <option value="">Driver Non App</option>
        <option value="Use Driver App" <?php if($booking['driver_app']!=''){ echo 'selected';}?>>Driver App</option>
     </select>
  </div>
</div>

<div class="col-md-2">
   <div class="form-group">
      <label>Extra Price</label>
      <div class="input-group ">
         <input class="form-control " name="extra_price" placeholder="Extra Price" value="<?=$booking['extra_price'];?>" type="number">
      </div>
   </div>
</div>


<div class="col-md-3">
 <div class="form-group">
  <label>Booking Type</label>
  <select class="form-control select2 w-100"  name="company_booking_type" >
   <option value="">Select Booking Type</option>
   <?php
   if(isset($booking_types))
   {
      foreach($booking_types as $btype)
      {
       ?>
       <option value="<?=$btype['title'];?>" <?php if($booking['company_booking_type']==$btype['title']){ echo 'selected';}?>><?=$btype['title']?></option>
       <?php
    }
 }
 ?>
</select>
</div>
</div>
<div class="col-md-2">
  <div class="form-group">
     <label>Booking ID</label>
     <div class="input-group ">
        <input type="text" class="form-control" name="company_booking_id" placeholder="Booking ID" value="<?=$booking['company_booking_id'];?>">
     </div>
  </div>
</div>
<div class="col-md-4">
 <div class="form-group">
  <label>Extra Requirement</label>
  <select class="form-control select2 w-100" multiple name="extra_requirement[]">
   <option value="Diesel" <?php if (in_array("Diesel", $Extrarequirement)){echo 'selected';}?>>Diesel</option>
   <option value="Petrol" <?php if (in_array("Petrol", $Extrarequirement)){echo 'selected';}?>>Petrol</option>
   <option value="CNG" <?php if (in_array("CNG", $Extrarequirement)){echo 'selected';}?>>CNG</option>
</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-12">
   <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>

<?php 
require_once 'footer.php';
require_once 'jslinks.php';
?>

<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"}
     };

     var options2 = {
        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);

           //=============Input Fields 2 and Select it========
     var input3 = document.getElementById('pickup_address');
      //===============adding google location search event=================
     new google.maps.places.Autocomplete(input3,options2);

          //=============Input Fields 4 and Select it========
     var input4 = document.getElementById('drop_address');
      //===============adding google location search event=================
     new google.maps.places.Autocomplete(input4,options2);
  }

  google.maps.event.addDomListener(window, 'load', AutoComplete);


  function tripType(id,str)
  {
     if(str=='One Way')
     {
       $('.package_display_none').hide();
       $('.display_none').show();
       $('#drop').hide();
    }else if(str=="Local"){
       $('.display_none').hide();
       $('#drop').hide();
       $('.package_display_none').show();
       var select = $('#package_type'); 
       var selected = ''; 
       $.ajax({
         url: "fetch_package_types.php",
         method: "POST",
         data: { trip_id: id },  
         dataType: "json",
         success: function(data) {
           select.empty();
           select.append('<option value="">Select an option</option>');

           $.each(data, function(index, value) {
             selected = ('<?=$booking['pid']?>' == value.type) ? 'selected' : '';
             select.append('<option value="' + value.type + '" ' + selected + '>' + value.type + '</option>');
          });
        },
        error: function(xhr, status, error) {
           console.error("Error fetching data:", error);
        }
     });


    }else{
       $('.package_display_none').hide();
       $('.display_none').show();
       $('#drop').show();
    }
 }
</script>