<?php include("../cn.php");
$id = $_REQUEST["id"];
$date = date("d.m.Y H:i");
mysqli_query($connect, "UPDATE `rentedcars` set `Status`='Canceled',`ConfirmDate` = '$date', `driver_id`=NULL where Id='$id'");

$sql = mysqli_query($connect, "select rentedcars.*, cars.*
									from rentedcars 
										inner join cars ON cars.Id = rentedcars.car_id
										where rentedcars.id = '$id'");
$data = mysqli_fetch_assoc($sql);


$name = $data["Name"];
$phone = $data["Phone"];
$email = $data["Email"];
$car = $data["Car"];
$type = $data["Type"];
$amount = $data["Amount"];
$bookingdate = $data["BookingDate"];
$journeydate = $data["BookingDate"];
$status = $data["Status"];
$payment_status = $data["PaymentStatus"];
$payment_method = $data["PaymentMethod"];
$pickup = $data["Pickup"];
$destination = $data["Destination"];
$days = $data["Days"];
$notes = $data["Notes"];
$booking_number = $data["BookingNumber"];

$car_sql = mysqli_query($connect,"select * from cars where car_id = '$car'");
$car_data = mysqli_fetch_assoc($car_sql);

$car_name = $car_data["car_name"];

// $p_sql = mysqli_query($connect,"select * from emirates where Id = '$pickup'");
// $p_data = mysqli_fetch_assoc($p_sql);
// $pickup_name = $p_data["Title"];

// $d_sql = mysqli_query($connect,"select * from emirates where Id = '$destination'");
// $d_data = mysqli_fetch_assoc($d_sql);
// $destination_name = $d_data["Title"];




$str = "
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml'>
  <head>
    <meta name='viewport' content='width=device-width, initial-scale=1.0' />
    <meta name='x-apple-disable-message-reformatting' />
    <meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
    <meta name='color-scheme' content='light dark' />
    <meta name='supported-color-schemes' content='light dark' />
    <title></title>
    <style type='text/css' rel='stylesheet' media='all'>
    /* Base ------------------------------ */
    
    @import url('https://fonts.googleapis.com/css?family=Nunito+Sans:400,700&display=swap');
    body {
      width: 100% !important;
      height: 100%;
      margin: 0;
      -webkit-text-size-adjust: none;
    }
    
    a {
      color: #3869D4;
    }
    
    a img {
      border: none;
    }
    
    td {
      word-break: break-word;
    }
    
    .preheader {
      display: none !important;
      visibility: hidden;
      mso-hide: all;
      font-size: 1px;
      line-height: 1px;
      max-height: 0;
      max-width: 0;
      opacity: 0;
      overflow: hidden;
    }
    /* Type ------------------------------ */
    
    body,
    td,
    th {
      font-family: 'Nunito Sans', Helvetica, Arial, sans-serif;
    }
    
    h1 {
      margin-top: 0;
      color: #333333;
      font-size: 22px;
      font-weight: bold;
      text-align: left;
    }
    
    h2 {
      margin-top: 0;
      color: #333333;
      font-size: 16px;
      font-weight: bold;
      text-align: left;
    }
    
    h3 {
      margin-top: 0;
      color: #333333;
      font-size: 14px;
      font-weight: bold;
      text-align: left;
    }
    
    td,
    th {
      font-size: 16px;
    }
    
    p,
    ul,
    ol,
    blockquote {
      margin: .4em 0 1.1875em;
      font-size: 16px;
      line-height: 1.625;
    }
    
    p.sub {
      font-size: 13px;
    }
    /* Utilities ------------------------------ */
    
    .align-right {
      text-align: right;
    }
    
    .align-left {
      text-align: left;
    }
    
    .align-center {
      text-align: center;
    }
    /* Buttons ------------------------------ */
    
    .button {
      background-color: #3869D4;
      border-top: 10px solid #3869D4;
      border-right: 18px solid #3869D4;
      border-bottom: 10px solid #3869D4;
      border-left: 18px solid #3869D4;
      display: inline-block;
      color: #FFF;
      text-decoration: none;
      border-radius: 3px;
      box-shadow: 0 2px 3px rgba(0, 0, 0, 0.16);
      -webkit-text-size-adjust: none;
      box-sizing: border-box;
    }
    
    .button--green {
      background-color: #22BC66;
      border-top: 10px solid #22BC66;
      border-right: 18px solid #22BC66;
      border-bottom: 10px solid #22BC66;
      border-left: 18px solid #22BC66;
    }
    
    .button--red {
      background-color: #FF6136;
      border-top: 10px solid #FF6136;
      border-right: 18px solid #FF6136;
      border-bottom: 10px solid #FF6136;
      border-left: 18px solid #FF6136;
    }
    
    @media only screen and (max-width: 500px) {
      .button {
        width: 100% !important;
        text-align: center !important;
      }
    }
    /* Attribute list ------------------------------ */
    
    .attributes {
      margin: 0 0 21px;
    }
    
    .attributes_content {
      background-color: #F4F4F7;
      padding: 16px;
    }
    
    .attributes_item {
      padding: 0;
    }
    /* Related Items ------------------------------ */
    
    .related {
      width: 100%;
      margin: 0;
      padding: 25px 0 0 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
    }
    
    .related_item {
      padding: 10px 0;
      color: #CBCCCF;
      font-size: 15px;
      line-height: 18px;
    }
    
    .related_item-title {
      display: block;
      margin: .5em 0 0;
    }
    
    .related_item-thumb {
      display: block;
      padding-bottom: 10px;
    }
    
    .related_heading {
      border-top: 1px solid #CBCCCF;
      text-align: center;
      padding: 25px 0 10px;
    }
    /* Discount Code ------------------------------ */
    
    .discount {
      width: 100%;
      margin: 0;
      padding: 24px;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
      background-color: #F4F4F7;
      border: 2px dashed #CBCCCF;
    }
    
    .discount_heading {
      text-align: center;
    }
    
    .discount_body {
      text-align: center;
      font-size: 15px;
    }
    /* Social Icons ------------------------------ */
    
    .social {
      width: auto;
    }
    
    .social td {
      padding: 0;
      width: auto;
    }
    
    .social_icon {
      height: 20px;
      margin: 0 8px 10px 8px;
      padding: 0;
    }
    /* Data table ------------------------------ */
    
    .purchase {
      width: 100%;
      margin: 0;
      padding: 35px 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
    }
    
    .purchase_content {
      width: 100%;
      margin: 0;
      padding: 25px 0 0 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
    }
    
    .purchase_item {
      padding: 10px 0;
      color: #51545E;
      font-size: 15px;
      line-height: 18px;
    }
    
    .purchase_heading {
      padding-bottom: 8px;
      border-bottom: 1px solid #EAEAEC;
    }
    
    .purchase_heading p {
      margin: 0;
      color: #85878E;
      font-size: 12px;
    }
    
    .purchase_footer {
      padding-top: 15px;
      border-top: 1px solid #EAEAEC;
    }
    
    .purchase_total {
      margin: 0;
      text-align: right;
      font-weight: bold;
      color: #333333;
    }
    
    .purchase_total--label {
      padding: 0 15px 0 0;
    }
    
    body {
      background-color: #F4F4F7;
      color: #51545E;
    }
    
    p {
      color: #51545E;
    }
    
    p.sub {
      color: #6B6E76;
    }
    
    .email-wrapper {
      width: 100%;
      margin: 0;
      padding: 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
      background-color: #F4F4F7;
    }
    
    .email-content {
      width: 100%;
      margin: 0;
      padding: 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
    }
    /* Masthead ----------------------- */
    
    .email-masthead {
      padding: 25px 0;
      text-align: center;
    }
    
    .email-masthead_logo {
      width: 94px;
    }
    
    .email-masthead_name {
      font-size: 16px;
      font-weight: bold;
      color: #4ab9cf ;
      text-decoration: none;
      text-shadow: 0 1px 0 white;
    }
    /* Body ------------------------------ */
    
    .email-body {
      width: 100%;
      margin: 0;
      padding: 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
      background-color: #FFFFFF;
    }
    
    .email-body_inner {
      width: 570px;
      margin: 0 auto;
      padding: 0;
      -premailer-width: 570px;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
      background-color: #FFFFFF;
    }
    
    .email-footer {
      width: 570px;
      margin: 0 auto;
      padding: 0;
      -premailer-width: 570px;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
      text-align: center;
    }
    
    .email-footer p {
      color: #6B6E76;
    }
    
    .body-action {
      width: 100%;
      margin: 30px auto;
      padding: 0;
      -premailer-width: 100%;
      -premailer-cellpadding: 0;
      -premailer-cellspacing: 0;
      text-align: center;
    }
    
    .body-sub {
      margin-top: 25px;
      padding-top: 25px;
      border-top: 1px solid #EAEAEC;
    }
    
    .content-cell {
      padding: 35px;
    }
    /*Media Queries ------------------------------ */
    
    @media only screen and (max-width: 600px) {
      .email-body_inner,
      .email-footer {
        width: 100% !important;
      }
    }
    
    @media (prefers-color-scheme: dark) {
      body,
      .email-body,
      .email-body_inner,
      .email-content,
      .email-wrapper,
      .email-masthead,
      .email-footer {
        background-color: #333333 !important;
        color: #FFF !important;
      }
      p,
      ul,
      ol,
      blockquote,
      h1,
      h2,
      h3,
      span,
      .purchase_item {
        color: #FFF !important;
      }
      .attributes_content,
      .discount {
        background-color: #222 !important;
      }
      .email-masthead_name {
        text-shadow: none !important;
      }
    }
    
    :root {
      color-scheme: light dark;
      supported-color-schemes: light dark;
    }
    </style>
    <!--[if mso]>
    <style type='text/css'>
      .f-fallback  {
        font-family: Arial, sans-serif;
      }
    </style>
  <![endif]-->
  </head>
  <body>
    <span class='preheader'>This is an automatic email generated for your booking update made on $bookingdate</span>
    <table class='email-wrapper' width='100%' cellpadding='0' cellspacing='0' role='presentation'>
      <tr>
        <td align='center'>
          <table class='email-content' width='100%' cellpadding='0' cellspacing='0' role='presentation'>
            <tr>
              <td class='email-masthead'>
                <a href='https://vtl.ae' class='f-fallback email-masthead_name'>
                VTL
              </a>
              </td>
            </tr>
            <!-- Email Body -->
            <tr>
              <td class='email-body' width='100%' cellpadding='0' cellspacing='0'>
                <table class='email-body_inner' align='center' width='570' cellpadding='0' cellspacing='0' role='presentation'>
                  <!-- Body content -->
                  <tr>
                    <td class='content-cell'>
                      <div class='f-fallback'>
                        <h1>Hi  $name,</h1>
                        <p>We are sorry but your booking with VTL has been canceled. If you have any query please contact us. Followings are the details of your booking.</p>
                        <table class='attributes' width='100%' cellpadding='0' cellspacing='0' role='presentation'>
                          <tr>
                            <td class='attributes_content'>
                              <table width='100%' cellpadding='0' cellspacing='0' role='presentation'>
                                  <tr>
                                      <td class='email-masthead'>
                                        <a href='#' class='f-fallback email-masthead_name'>
                                         BOOKING NUMBER: $booking_number
                                      </a>
                                      </td>
                                    </tr>
                                <tr>
                                  <td class='attributes_item'>
                                    <span class='f-fallback'>
              <strong>Booking Charges:</strong>  $amount AED
            </span>
                                  </td>
                                </tr>
                                <tr>
                                  <td class='attributes_item'>
                                    <span class='f-fallback'>
              <strong>Booking Date:</strong>  $journeydate
            </span>
                                  </td>
                                </tr>
                                <tr>
                                  <td class='attributes_item'>
                                    <span class='f-fallback'>
              <strong>Booking Status:</strong>  $status
            </span>
                                  </td>
                                </tr>
                                 <tr>
                                  <td class='attributes_item'>
                                    <span class='f-fallback'>
              <strong>Payment Status:</strong>  $payment_status
            </span>
                                  </td>
                                </tr>
                              </table>
                            </td>
                          </tr>
                        </table>
                        <!-- Action -->
                        
                        <table class='purchase' width='100%' cellpadding='0' cellspacing='0'>
                          
                          <tr>
                            <td colspan='2'>
                              <table class='purchase_content' width='100%' cellpadding='0' cellspacing='0'>
                                <tr>
                                  <th class='purchase_heading' align='left'>
                                    <p class='f-fallback'>Customer Details</p>
                                  </th>
                                  <th class='purchase_heading' align='right'>
                                    <p class='f-fallback'></p>
                                  </th>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Customer Name</span></td>
                                  <td class='align-right' class='purchase_item'><span class='f-fallback'> $name</span></td>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Customer Phone:</span></td>
                                  <td class='align-right'  class='purchase_item'><span class='f-fallback'> $phone</span></td>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Customer Email:</span></td>
                                  <td class='align-right' class='purchase_item'><span class='f-fallback'> $email</span></td>
                                </tr>
                                <tr>
                                  <td  class='purchase_footer' valign='middle'>
                                    <p class='f-fallback purchase_total purchase_total--label'></p>
                                  </td>
                                  <td class='purchase_footer' valign='middle'>
                                    <p class='f-fallback purchase_total'></p>
                                  </td>
                                </tr>
                              </table>
                              
                            </td>
                          </tr>
                          <tr>
                            <td colspan='2'>
                              <table class='purchase_content' width='100%' cellpadding='0' cellspacing='0'>
                                <tr>
                                  <th class='purchase_heading' align='left'>
                                    <p class='f-fallback'>Booking Details</p>
                                  </th>
                                  <th class='purchase_heading' align='right'>
                                    <p class='f-fallback'></p>
                                  </th>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Car:</span></td>
                                  <td class='align-right' class='purchase_item'><span class='f-fallback'> $car_name</span></td>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Pick Up:</span></td>
                                  <td class='align-right' class='purchase_item'><span class='f-fallback'> $pickup</span></td>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Destination:</span></td>
                                  <td class='align-right'  class='purchase_item'><span class='f-fallback'> $destination </span></td>
                                </tr>
                                <tr>
                                  <td class='purchase_item'><span class='f-fallback'>Booking For:</span></td>
                                  <td class='align-right' class='purchase_item'><span class='f-fallback'> $days (days)</span></td>
                                </tr>

                                <tr>
                                  <td  class='purchase_footer' valign='middle'>
                                    <p class='f-fallback purchase_total purchase_total--label'></p>
                                  </td>
                                  <td class='purchase_footer' valign='middle'>
                                    <p class='f-fallback purchase_total'></p>
                                  </td>
                                </tr>
                                <tr>
                            <td>
                              <p class='f-fallback sub'><strong>Notes from Customer:</strong> $notes</p>
                            </td>
                          </tr>
                              </table>
                              
                            </td>
                          </tr>
                        </table>
                        <p>Thanks,
                          <br>Team Starlet</p>
                        <!-- Sub copy -->
                       
                      </div>
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
            <tr>
              <td>
                <table class='email-footer' align='center' width='570' cellpadding='0' cellspacing='0' role='presentation'>
                  <tr>
                    <td class='content-cell' align='center'>
                      <p class='f-fallback sub align-center'>&copy;  ".date('Y')." VTL. All rights reserved.</p>
                      
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
          </table>
        </td>
      </tr>
    </table>
  </body>
</html>";












// $messagebody = $str;
// $emailto = $email;
// $toname = $name;
// $emailfrom = 'booking@vtl.ae';
// $fromname = 'VTL';
// $subject = 'Booking Canceled'; 
//  $headers = 
//             	'Return-Path: ' . $emailfrom . "\r\n" . 
//             	'From: ' . $fromname . ' <' . $emailfrom . '>' . "\r\n" . 
//             	'X-Priority: 3' . "\r\n" . 
//             	'X-Mailer: PHP ' . phpversion() .  "\r\n" . 
//             	'Reply-To: ' . $fromname . ' <' . $emailfrom . '>' . "\r\n" .
//             	'MIME-Version: 1.0' . "\r\n" . 
//             	'Content-Transfer-Encoding: 8bit' . "\r\n" . 
//             	'Content-Type: text/html;charset=UTF-8' . "\r\n";
// $params = '-f ' . $emailfrom;
//             $test = mail($emailto, $subject, $messagebody, $headers, $params);

header("location:../booking-detail.php?id=$id");

?>