<?php
require_once 'header.php';
require_once 'navbar.php';
include('smtp/PHPMailerAutoload.php');
if(isset($_POST['book'])){
    $name=$_POST['name'];
    $email=$_POST['email'];
    $phone=$_POST['phone'];

    $booking_stops = implode("/", $_POST['booking_stops']);
    $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:s',strtotime($_POST['booking_time']));
    $cab_type=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']);
    $parking=test_input($_POST['parking']);
    $user_id=test_input($_POST['user_id']);
    $toll=test_input($_POST['toll']);
    $state_tax=test_input($_POST['state_tax']);
    $extra_price=test_input($_POST['extra_price']);
    $luggage=test_input($_POST['luggage']);
    $remark=test_input($_POST['remark']);
    $passenger=test_input($_POST['passenger']);
    $no_of_day=test_input($_POST['no_of_day']);
        // $advance=test_input($_POST['advance']);
    $drop_date=date("Y-m-d",strtotime($_POST['drop_date']));
    
    $result=$conn->query("select * from users where contact='".$phone."' or email='".$email."'"); 

    if ($result->num_rows > 0) 
    {
        $row = $result->fetch_assoc(); 
        $user_id = $row['id'];
    }else{
        $user=$conn->query("INSERT INTO users (name, contact, email) VALUES ('$name', '$phone', '$email')");
        $user_id = $conn->insert_id;
    }

    $sql="INSERT into booking_quotation(booking_from,drop_date,booking_to,booking_stops,pickup_date,pickup_time,pickup_address,cab_type,trip_type,price,status,admin_commission,user_id,distance,night_charge,toll_tax,state_tax,remark,parking,booking_type,number_passenger,no_of_day,luggage,after_extra_price) values('$booking_from','$drop_date','$booking_to','$booking_stops','$pickup_date','$pickup_time','$pickup_address','$cab_type','$trip_type','$amount','Pending',$commission,'$user_id','$distance','$night_charge','$toll','$state_tax','$remark','$parking','Admin','$passenger','$no_of_day','$luggage','$extra_price')";


    if($conn->query($sql)===true)
    {
        $booking_id = $conn->insert_id;
        $result=$conn->query("SELECT * FROM profiles LIMIT 1");
        $settings=$result->fetch_assoc();
        $address=$settings['address'];

        $result2=$conn->query("SELECT * FROM users WHERE id='$user_id'");
        $user=$result2->fetch_assoc();

        if ($toll_tax==0) {
          $toll_tax="Included";
      }else{
          $toll_tax="Excluded";
      }
      if ($state_tax==0) {
          $state_tax="Included";
      }else{
          $state_tax="Excluded";
      }
      if ($parking==1) {
          $parking="Included";
      }else{
          $parking="Excluded";
      }

      $success=true;

$msg = "Hi  ".$user['name']." 
Booking ID  C4U".$booking_id."  
From - ".$booking_from." 
To - ".$booking_to." 
Pickup Address - ".$pickup_address." 
Pickup Date - ".$pickup_date." 
Drop Date - ".$drop_date." 
Pickup Time - ".$pickup_time."
Cab Type - ".$cab_name." 
Trip Type - ".$trip_type." 

State Tax - ".$state_tax." 
Toll Tax - ".$toll_tax." 
Parking - ".$parking." 

Distance  ".$distance."Kms.

Remark  ".$remark."

Welcome to 
cabz4U Taxi Service 
Contact number 
      👇
7830530004 7060000113 7830530005 
      👇
🚕Book now taxi 🚕

Customer App - http://bit.ly/41iYU8I
Website - http://www.cabz4you.com/";

whatsapp($user['contact'],$msg);

      $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 order by contact";
$result=$conn->query($sql);
if($result->num_rows>0)
{
    while($row=$result->fetch_assoc())
    {
      $users[]=$row;
  }
}

$sql="SELECT * FROM `package_types` ";
$result=$conn->query($sql);
if($result->num_rows>0)
{
    while($row=$result->fetch_assoc())
    {
      $packages[]=$row;
  }
}
?>                  
<style>
    #show{
        position: relative;
    }
    #show ul{
        position: absolute;
        padding-left: 0;
        max-height: 200px;
        overflow-y: auto;
        background-color: #fff;
        width: 100%;
        z-index: 1;
        background-color: #f2f2f2;
    }
    #show ul li{
        padding: 5px 10px;
        cursor: pointer;
        border-bottom: 1px solid #e7e4e4;
    }
</style>
<div class="container-fluid pt-8">
    <div class="page-header mt-0 shadow p-2">
        <h3 class="mb-sm-0"> Create Quotation</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">Create Quotation</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">Book Your Cab Now </h2>
           </div> -->
           <form id="cab_book" method="post" autocomplete="off">
             <div class="card-body">
              <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                       <label>Phone Number</label>
                       <input class="form-control" onkeyup="userdetail(this.value)" name="phone" id="phone" type="text" placeholder="Phone Number" required>
                       <div id="show"><ul style="display:none;"></ul></div>
                   </div>
               </div>
               <div class="col-md-4">
                <div class="form-group">
                   <label>Name</label>
                   <input class="form-control" name="name" id="name" type="text" placeholder="Name" required>
               </div>
           </div>
           <div class="col-md-4">
            <div class="form-group">
               <label>Email</label>
               <input class="form-control" name="email" id="email" type="text" placeholder="Email" required>
           </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" placeholder="From" required>
     </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" placeholder="To" >
   </div>
</div>
<div class="col-md-4">
    <label class="w-100">Booking Stops <button type="button" class="badge badge-success px-2 py-2 add_field_button float-right">Add Field</button></label>
    <input id="bookingstop" class="form-control" name="booking_stops[]" type="text" placeholder="Booking Stops" autocomplete="off">
</div>
</div>
<div class="row round_list"></div>
<div class="row">
 <div class="col-md-4 mt-20">
    <div class="form-group">
     <label>Pickup Address</label>
     <div class="input-group ">

      <input id="pickup_address" class="form-control " name="address" placeholder="Pickup address" type="text" required>
  </div>
</div>
</div>


<div class="col-md-3 mt-20">
    <div class="form-group">
     <label>Cab Type</label>
     <select class="form-control select2 w-100"  name="cab_name" required>
      <?php
      if(isset($cab_types))
      {
         foreach($cab_types as $cab)
         {
             ?>
             <option value="<?=$cab['type'];?>"><?=$cab['type']?></option>
             <?php
         }
     }
     ?>
 </select>
</div>
</div>
<div class="col-md-2">
    <div class="form-group">
       <label>No. of Passenger </label>
       <div class="input-group ">

          <input class="form-control " name="passenger" id="passenger" placeholder="Number of Passenger" type="number" >
      </div>
  </div>
</div>

<div class="col-md-3 mt-20">
    <div class="form-group">
     <label>Trip Type</label>
     <select class="form-control w-100" id="trip_type" name="trip_type" required>
      <?php
      if(isset($packages))
      {
         foreach($packages as $package)
         {
             $selected="";
             if(strtolower($package['type']) == "one way")
             {
                 $selected="selected";
             }
             ?>
             <option value="<?=$package['type'];?>" <?=$selected?>><?=$package['type']?></option>
             <?php
         }
     }
     ?>
 </select>
</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 datepicker" id="pickup_date" onchange="datediff()" placeholder="Select date" type="date" value="<?=date('Y-m-d')?>" name="pickup_date" min="<?=date('Y-m-d')?>">
</div>
</div>
</div>

<div class="col-md-2" id="drops" >
    <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" onchange="datediff()" type="date" value="<?=date("Y-m-d",strtotime('+1 days'));?>" name="drop_date" min="<?=date('Y-m-d')?>">
</div>
</div>
</div>

<div class="col-md-2">
    <div class="form-group">
       <label>Number Of Days</label>
       <div class="input-group ">

          <input class="form-control" id="no_of_days" placeholder="Number Of Days" type="number" name="no_of_day">
      </div>
  </div>
</div>

<div class="col-md-2 mt-20">
    <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" id="pickup_time" name="booking_time" placeholder="Select Time" type="time" required>
</div>
</div>
</div>
<div class="col-md-2 mt-20">
    <div class="form-group">
     <label>Booking Amount</label>
     <div class="input-group ">

      <input class="form-control " name="amount" placeholder="Enter Amount" type="number" required>
  </div>
</div>
</div>

<div class="col-md-2 mt-20">
    <div class="form-group">
     <label>Commission Amount</label>
     <div class="input-group ">
      <input class="form-control " name="commission" placeholder="Commission amount" type="number">
  </div>
</div>
</div>
<!-- <div class="col-md-2 mt-20">
    <div class="form-group">
       <label>Advance Amount</label>
       <div class="input-group ">

          <input class="form-control " name="advance" placeholder="Enter Advance" type="number" value="0" required>
      </div>
  </div>
</div> -->



<div class="col-md-2 mt-20">
    <div class="form-group">
     <label>Distance (Km)</label>
     <div class="input-group ">
      <input class="form-control " name="distance" placeholder="Distance" type="number" required>
  </div>
</div>
</div>

<div class="col-md-2 mt-20">
    <div class="form-group">
     <label>Night Charge</label>
     <div class="input-group ">
      <input class="form-control " name="night_charge" placeholder="Night Charge" type="number" value="0">
  </div>
</div>
</div>
<div class="col-md-3 mt-20">
    <div class="form-group">
     <label>Parking</label>
     <select class="form-control select2 w-100"  name="parking">
        <option value="0">Excluding</option>
        <option value="1">Including</option>
    </select>
</div>
</div>
<div class="col-md-2">
    <div class="form-group">
       <label>Luggage</label>
       <input class="form-control " name="luggage" placeholder="Luggage" type="text">
   </div>
</div>
<div class="col-md-3">
    <div class="form-group">
       <label>Extra Price</label>
       <input class="form-control " name="extra_price" placeholder="Extra Price" type="number">
   </div>
</div>

<div class="col-md-3 mt-20">
    <div class="form-group">
     <label>Toll</label>
     <select class="form-control select2 w-100"  name="toll">

       <option value="0">Excluding</option>
       <option value="1">Including</option>
   </select>
</div>
</div>
<div class="col-md-3 mt-20">
    <div class="form-group">
     <label>State Tax</label>
     <select class="form-control select2 w-100"  name="state_tax">
       <option value="0">Excluding</option>
       <option value="1">Including</option>
   </select>
</div>
</div>
<div class="col-md-3 mt-20">
    <div class="form-group">
     <label>Remark</label>
     <div class="input-group ">
      <input class="form-control " name="remark" placeholder="Remark" type="text">
  </div>
</div>
</div>




<div class="col-md-2 mt-20">
    <br>
    <div class="form-group">
     <button class="btn btn-icon mt-1 mb-1" id="btn_sumbit" type="submit" name="book">
         <span class="btn-inner--icon">
             <span class="btn-inner--text">Book Now</span>
         </button>
     </div>
 </div>
</div>
</div>
</form>
</div>

<script src="https://cdn.ckeditor.com/4.13.1/standard/ckeditor.js"></script>
<script>
 CKEDITOR.replace( 'editor');
</script>
<?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"}
  };
           //=============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,options);

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

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


// ===============onkey up============
$('#trip_type').on('change',function(){
    var val = this.value;
    if(val=='Tour Trip' || val=='Char Dham Yatra'){
        $('#itinerary').show();
    }else{
        $('#itinerary').hide();
    }
})

// ===============onkey up============
function userdetail(phone){
    if (phone != ''){
        $.ajax({
            url: "check.php",
            method: "POST",
            data: { phone: phone},
            success: function(data){
                $("#show ul").fadeIn("fast").html(data);
            }
        });
    }else{
        $("#show ul").fadeOut();
    }
}

function getuserdata(name,email,contact){
    console.log(name,email,contact);
    $("#name").val(name);
    $("#phone").val(contact);
    $("#email").val(email);
    $("#show ul").fadeOut();
}
</script>