|
Server IP : 103.53.40.154 / Your IP : 18.188.91.223 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home2/ppcad7no/agkeymaker.in/../indiatourbus.com/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include_once('admin/config.php');
function db_query($sql) {
global $db;
$result = $db->query($sql);
if (!$result) {
die("Query failed: " . $db->error);
}
return $result;
}
$old_ss = "SELECT ord_id FROM tbl_order WHERE ord_id='".$_GET['payment_request_id']."'";
$res = mysqli_query($db, $old_ss);
$datass = mysqli_fetch_assoc($res);
$old_id=$datass['ord_id'];
if($old_id==$_GET['payment_request_id']) {
if ($_GET['payment_status'] === 'Credit') {
$paymentRequestId = $_GET['payment_request_id'];
$transaction_id = $_GET['transaction_id'];
$sql = "UPDATE tbl_order SET ord_status='Paid', transaction_id='$transaction_id' WHERE ord_id='$paymentRequestId'";
// $res = mysqli_query($db, $sql);
$result=mysqli_query($db, $sql);
if($result){
$checkSql = "SELECT * FROM tbl_order WHERE ord_id='$paymentRequestId'";
$results = db_query($checkSql);
$order = $results->fetch_assoc();
$orderStatus = $order['ord_status'];
@extract($order);
if ($orderStatus === 'Paid') {
$hostName = 'India Tour Bus';
$msgmail="<!doctype html>
<html>
<head>
<meta charset='utf-8'>
<title>IndiaTourBus</title>
</head>
<body style='margin:0px; padding:0px; font-family:arial; line-height:1.5; font-size:12px;'>
<div style='width:650px; margin:auto;'>
<div style='margin:10px; border:solid 2px #efefef; padding:10px;'>
<div>
<p style='width:200px; float:left; color:#000; margin:0px; padding:0px; color:#000;'>Date - ".date('d M Y')."</p>
<p style='width:200px; float:left; text-align:center; color:#000; margin:0px; padding:0px; color:#000;'><img src='https://www.indiatourbus.com/admin/images/header_logo_20240228052327.png'></p>
<p style='width:200px; float:right; text-align:center; color:#000; margin:0px; padding:0px; color:#000; font-weight:bold;'>$ord_ord_name <br>
PNR Number<br>
<span style=' font-weight:normal;'>$ord_pnr_no</span></p>
</div>
<div style='clear:both;'></div>
<div>
<p style='width:110px; float:left; margin:0px; padding:0px;'> </p>
<p style='width:400px; float:left; margin:0px; padding:0px; text-align:center; color:#000;'><strong>9597-9603 Sardar Thana Road,<br>
Motia Khan Pahar Ganj, New Delhi-110055</strong></p>
<p style='width:110px; float:left; margin:0px; padding:0px; color:#000;'> </p>
</div>
<div style='clear:both;'></div>
<div style='float:left; width:507px; margin-top:2px;'>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Customer Name</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>$ord_person_name</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Customer Email</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>$ord_email</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Bus Category</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>$ord_ord_name</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Nationality </p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>Indian</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>No of Person </p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>$ord_person_no</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Contact No</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>$ord_mobile</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Pick-up Point</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>$ord_pickup_point</p>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:600;'>Date of journey</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:240px; float:left; margin:0px; padding:0px; color:#000;'>".date("d M Y",strtotime($order['ord_doj']))."</p>
</div>
<div style='float:left; margin:0px; padding:0px;'>
</div>
<div style='clear:both;'></div>
<div style='margin-top:10px;'>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:bold;'>Booked by</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:420px; float:left; margin:0px; padding:0px; color:#000; text-transform:uppercase;'>India Tour Bus </p>
</div>
<div style='clear:both;'></div>
<div style='margin-top:10px;'>
<p style='width:130px; float:left; margin:0px; padding:0px; color:#000; font-weight:bold;'>Contact Number</p>
<p style='width:50px; float:left; margin:0px; padding:0px; color:#000;'><strong>:</strong></p>
<p style='width:420px; float:left; margin:0px; padding:0px; color:green; text-transform:uppercase; font-weight:600;'>+91-9643-457-009, +91-99994-44497</p>
</div>
<div style='clear:both;'></div>
<div style='margin-top:10px;'>
<p style='float:left; margin:0px; padding:0px; color:#000;'>Please Show this $ord_ord_name ticket to Attendant upon entry in Vehicle. Enjoy your tour. Kindly carry estable with you</p>
</div>
<div style='clear:both;'></div>
<div style='float:left; width:300px; margin-top:10px;'>
<p style='margin:0px; padding:0px; color:#000; font-weight:bold;'>Pick-up Time<br>
<span style='font-weight:normal;'>$ord_pickup_point</span></p>
</div>
<div style='float:left; width:300px; margin-top:10px;'>
<p style='float:right; margin:0px; padding:0px; color:#000; font-weight:bold;'>Pick-up Points<br>
<span style='font-weight:normal;'>$ord_pickup_point</span></p>
</div>
<div style='clear:both;'></div>
</div>
</div>
</body>
</html>";
$senderName = $ord_person_name;
$senderEmail = $ord_email;
$toEmail = "info@indiatourbus.com";
$subject = "Booking Details From $hostName";
$from="$senderEmail";
$Headers1 = "From: $senderName <$senderEmail>\r\n";
$Headers1 .= "Reply-To: $senderEmail\r\n";
$Headers1 .= "X-Mailer: PHP/" . phpversion() . "\r\n";
$Headers1 .= "X-Priority: 3\r\n";
$Headers1 .= "MIME-Version: 1.0\r\n";
$Headers1 .= "Content-Type: text/html; charset=iso-8859-1\r\n";
@mail("$toEmail", "$subject", "$msgmail","$Headers1","-fenquiry@tradekeyindia.com");
$toEmail."<br>";
///////////////****** Mailer to client end here **********************//////////////
$toEmail =$ord_email;
$subject = "Booking confirmation on IndiaTourBus";
$from="info@indiatourbus.com";
$Headers1 = "From: info@indiatourbus.com<$from>\n";
$Headers1 .= "Reply-To: info@indiatourbus.com\r\n";
$Headers1 .= "X-Mailer: PHP/" . phpversion() . "\r\n";
$Headers1 .= "X-Priority: 3\r\n";
$Headers1 .= "MIME-Version: 1.0\r\n";
$Headers1 .= "Content-Type: text/html; charset=iso-8859-1\r\n";
@mail("$toEmail", "$subject", "$msgmail","$Headers1","-fenquiry@tradekeyindia.com");
$toEmail."<br>";
// Mailer ENd
}
else {
// header("Location: failure.php");
// exit();
}
}
}
else
{
header("Location: failure.php");
exit();
}
}
?>
<!doctype html>
<html lang="en">
<head>
<?php include "links.php";?>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Thanks</title>
</head>
<body>
<!--<div class="preloader">-->
<!-- <div class="loader">-->
<!-- <span></span>-->
<!-- <span></span>-->
<!-- <span></span>-->
<!-- <span></span>-->
<!-- </div>-->
<!--</div>-->
<?php include "header.php";?>
<!-- breadcum area -->
<section id="marquee">
<div class="container-fluid">
<div class="row">
<div class="col-md-12 mp-0s" style="background-color:#ed1c24; padding:3.1px;">
<marquee behavior="scroll" direction="left" onmouseover="this.stop();" onmouseout="this.start();" scrollamount="4" style="color:#fff; font-weight:bold; font-size:20px; position:relative; top:2px;">
Agra Tour : <span>699/- </span> Delhi Sighseeing : <span>499/- </span> Jaipur Tour : <span>5499/- </span>
</marquee>
</div>
</div>
</div>
</section>
<div class="breadcrumb breadcrumb-style-one">
<div class="container">
<div class="col-lg-12 text-center">
<h1 class="breadcrumb-title">Thanks</h1>
<ul class="d-flex justify-content-center breadcrumb-items">
<li class="breadcrumb-item"><a href="index.html">Home</a></li>
<li class="breadcrumb-item active">Thanks</li>
</ul>
</div>
</div>
</div>
<div class="about-main-wrappper pt-50">
<div class="container">
<div class="about-tab-wrapper">
<div class="row justify-content-center align-items-center">
<div class="col-lg-12">
<div class="about-tab-image-grid text-center">
<div class="about-video d-inline-block">
<h2 style="color:green;"> Ticket Booking confirm. We will contact you soon!!!</h2>
<!--<img width="100%" src="bus-img/about-us-1.png" alt="">-->
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "footer.php" ?>
</html>