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

<?php
session_start();
include('include/config.php');
    
    $cust_mob = $_SESSION['cust_mob'];
    $cust_email = $_SESSION['cust_email'];
    $cust_name = $_SESSION['cust_name'];
    $cust_add = $_SESSION['cust_add'];
    $id = $_SESSION['id'];
    $origin = $_SESSION['origin'];
    $destination = $_SESSION['destination'];
    $pickup_date = $_SESSION['pickup_date'];
    $drop_date = $_SESSION['drop_date'];
    $pickup_time = $_SESSION['pickup_time'];
    $rate = $_SESSION['rate'];
    $paid = $_SESSION['paid'];
    $distance = $_SESSION['distance'];
    $trip_type = $_SESSION['trip_type'];
    $toll_tax = $_SESSION['toll_tax'];
    $state_tax = $_SESSION['state_tax'];
    $package_type = $_SESSION['package_type'];
    $lat_to = $_SESSION['lat_to'];
    $long_to = $_SESSION['long_to'];
    $lat_from = $_SESSION['lat_from'];
    $long_from = $_SESSION['long_from'];
    $passenger = $_SESSION['passenger'];
    $coupon = $_SESSION['coupon'];
    $drop_address = $_SESSION['drop_address'];
    $luggage = $_SESSION['luggage'];
    $package_id = $_SESSION['package_id'];
    
    $sql="select * from users where contact='".$cust_mob."' or email='".$cust_email."' "; 
    $result = $db->query($sql);

if ($result->num_rows > 0) 
    {
        $row = $result->fetch_assoc();
        $user_id=$row['id'];

}else{
       $query=$db->query("INSERT INTO users(name,email,contact)VALUES('$cust_name','$cust_email','$cust_mob')");
       if ($query) {
        $user_id = $db->insert_id;
    }
}

$sql="INSERT INTO `bookings` (`booking_from`, `booking_to`, `pickup_date`, `drop_date`, `pickup_time`, `cab_type`, 
    `trip_type`, `price`, `pickup_address`, `status`,`drop_address`, 
    `user_id`, `distance`, `cust_name`, `cust_email`, `cust_mob`, `cust_add`, `toll_tax`, `state_tax`, `latitude_from`, `longitude_from`, `latitude_to`, `longitude_to`, `coupon`, `luggage`,`pid`,`booking_type`,`payment_method`) 
VALUES ('$origin', '$destination', '$pickup_date', '$drop_date', 
    '$pickup_time', '$id', '$trip_type','$rate','$cust_add',  'booked', '$drop_address' ,'$user_id', '$distance',  '$cust_name', '$cust_email', '$cust_mob', '$cust_add', '$toll_tax', '$state_tax', '$lat_from', '$long_from', '$lat_to', '$long_to', '$coupon', '$luggage', '$package_id','Website','Online')";

if($db->query($sql)===true)
{
    $booking_id = $db->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','$paid',1)";

}

if($db->query($sql)===true)
{

$sql="select bookings.id,bookings.pickup_address,bookings.drop_address,bookings.booking_from,bookings.booking_to,bookings.pickup_date,bookings.pickup_time,users.email,users.name from bookings,users where bookings.id=$booking_id and bookings.user_id=users.id";
    $result = $db->query($sql);

if ($result->num_rows > 0) 
    {
        $row = $result->fetch_assoc();
        $email = $row['email'];
        $pick_date=date("d-m-Y", $p_date);
        $p_time = strtotime($row['pickup_time']);
        $pick_time=date("h:i A", $p_time);

include('admin/smtp/PHPMailerAutoload.php');
        $mail=new PHPMailer();
        $mail->isSMTP();
        $mail->Host='smtp.hostinger.com';
        $mail->Port=465;
        $mail->SMTPSecure="ssl";
        $mail->SMTPAuth=true;
        $mail->Username="info@rockonwheelstravels.in";
        $mail->Password="Rock@2022";
        $mail->setFrom("info@rockonwheelstravels.in");
        $mail->addAddress($email);
        $mail->AddAddress('rowtravels@gmail.com');
        $mail->isHTML(true);
        $mail->Subject="Booking Details";
        $mail->Body='<html lang="en">
        <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1"> 
        <meta http-equiv="X-UA-Compatible" content="IE=edge"> 
        <meta name="format-detection" content="telephone=no"> 
        <title></title>

table {
          border-spacing: 0;
      }

table td {
          border-collapse: collapse;
      }

.ExternalClass {
          width: 100%;
      }

.ExternalClass,
      .ExternalClass p,
      .ExternalClass span,
      .ExternalClass font,
      .ExternalClass td,
      .ExternalClass div {
          line-height: 100%;
      }

.ReadMsgBody {
          width: 100%;
          background-color: #ebebeb;
      }

table {
          mso-table-lspace: 0pt;
          mso-table-rspace: 0pt;
      }

img {
          -ms-interpolation-mode: bicubic;
      }

.yshortcuts a {
          border-bottom: none !important;
      }

@media only screen and (max-width: 600px) {
      *[class="gmail-fix"] {
        display: none !important;
    }
}
@media screen and (max-width: 599px) {
  table[class="force-row"],
  table[class="container"] {
    width: 100% !important;
    max-width: 100% !important;
}

table[class="force-row two"] {
    width: 50% !important;
    max-width: 50% !important;
}
}
@media screen and (max-width: 400px) {
  td[class*="container-padding"] {
    padding-left: 12px !important;
    padding-right: 12px !important;
}
}
.ios-footer a {
  color: #aaaaaa !important;
  text-decoration: underline;
}

@media screen and (max-width: 599px) {
  td[class="col"] {
    width: 50% !important;
    text-align: center;
}

td[class="cols-wrapper"] {
    padding-top: 18px;
}

img[class="image"] {
    padding-bottom: 10px;
}

div[class="subtitle"] {
    margin-top: 0 !important;
}
}
@media screen and (max-width: 400px) {
  td[class="cols-wrapper"] {
    padding-left: 0 !important;
    padding-right: 0 !important;
}

td[class="content-wrapper"] {
    padding-left: 12px !important;
    padding-right: 12px !important;
}
}
</style>

</head>
<body style="margin:0; padding:0;" bgcolor="#e1e1e1" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

</td>
</tr>
<tr>
<td class="content-wrapper" style="padding-left:24px;padding-right:24px;">
<p style="text-transform:capitalize;font-family:sans-serif;font-size: 26px !important;margin-top: 15px; margin-bottom: 15px;">Dear '.$row['name'].'</p>

<hr style="border-bottom: solid 1px #000; border-top: 0;">
</td>
</tr>
<tr>
<td style="padding:5px 25px;font-size:22px"><p>Your Booking ID : '.$row['id'].'</p>
<p>Pickup date & Time : '.$pick_date.' '.$pick_time.'.</p>
<p>From : '.$row['pickup_address'].' To '.$row['booking_to'].' is confirmed driver & cab details will be sent before 2 hr. of pickup time.</p>
<p>Thanks For Booking Rock On Wheels Travels.</p>
<p>24x7 Customer Support: 8630825351.</p>
<p>Online Booking visit: www.rockonwheelstravels.in</p></td>
</tr>

</td>
</tr>
<tr>
<td style="background:#fff;text-align:center;width:100%;height:25px;"></td>  
</tr>

</td>
</tr>
<tr>
<td style="background:#e1e1e1;text-align:center;width:100%;height:5px;"></td>  
</tr>
<tr>
<td style="background:#e1e1e1;text-align:center;">
<div style="font-family:Helvetica, Arial, sans-serif;font-size:13px !important;color:#000000;text-align: center;line-height:1.4;">
92 Dron Vihar Housing Society old Mitthi beri<br> Prem Nagar Dehradun Pin-248007<br>

</div>  
</td>  
</tr>
<tr>
<td style="background:#e1e1e1;text-align:center;width:100%;height:30px;"></td>  
</tr>

</table>

</td>
</tr>

</table>

</td>
</tr>
</table>

</body>
</html>';

$mail->send();
}
header("location:response.php");

}
else{
    echo "<script>if(confirm('Oops something went wrong please try again...!')){document.location.href='index'};</script>";    
}   
?>