| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/jeevikagaumaa.in/public_html/admin/ |
Upload File : |
<?php include '../action/check-login.php'; include '../action/config.php';
// ini_set('display_errors',1);
$order_id = $id = $_GET['id'];
$qry = mysqli_query($con,"SELECT * FROM `orders` WHERE id='$id'");
$r=mysqli_fetch_array($qry);
$userid = $r['userid'];
$name = $r['name'];
$email = $r['email'];
$phone = $r['phone'];
$alternate = $r['alternate'];
$address1 = $r['address1'];
$address2 = $r['address2'];
$city = $r['city'];
$state = $r['state'];
$pin = $r['pin'];
$order_type = $r['order_type'];
$order_date = $r['order_date'];
$items = $r['items'];
$grand_total = $r['grand_total'];
$payment_status = $r['payment_status'];
$order_status = $r['order_status'];
$txnid = $r['txnid'];
$date = date('Y-m-d H:i:s');
/*$cashback = calculateTotalCashback($userid, $order_id, $con);
if($cashback>0){
$qry = mysqli_query($con,"SELECT * FROM transaction WHERE remark='Total Cashback of Orderid $order_id' ");
if(mysqli_num_rows($qry)>0){
}else{
mysqli_query($con, "UPDATE `user_wallet` SET `wallet_bal` = wallet_bal+'$cashback',`total_income` = total_income+'$cashback' WHERE userid='$userid' ");
mysqli_query($con, "INSERT INTO `transaction`(`userid`, `tr_id`, `credit`, `tr_date`, `remark`) VALUES ('$userid','$txnid','$cashback','$date','Total Cashback of Orderid $order_id') ");
}
}*/
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<meta name="description" content="" />
<meta name="author" content="" />
<title></title>
<link href="css/styles.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css" rel="stylesheet" crossorigin="anonymous" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/js/all.min.js" crossorigin="anonymous"></script>
<link rel="shortcut icon" href="../assets/images/logo3.png" />
<style>
#blink {
font-weight: bold;
color: #007bff;
transition: 0.5s;
}
</style>
</head>
<body class="sb-nav-fixed">
<?php include 'sidebar_menu.php'; ?>
<main>
<div class="container-fluid">
<ol class="breadcrumb mb-4 mt-2">
<li class="breadcrumb-item font-weight-bold">Track Order Details</li>
</ol>
<!--<div class="card" id="blink">-->
<!--<h3 class="text-center">Page Under Construction</h3>-->
<!--</div>-->
<div class="row">
<div class="col-md-6">
<div class="card card-body">
<b><u>Shipping Address</u></b>
Name: <?php echo $name; ?><br>
Address1: <?php echo $address1; ?><br>
Address2: <?php echo $address2; ?><br>
City: <?php echo $city; ?><br>
State: <?php echo $state; ?><br>
Pin: <?php echo $pin; ?><br>
Phone: <?php echo $phone; ?>
</div>
</div>
<div class="col-md-6">
<div class="card card-body">
<b><u>Order Status</u></b>
Order Type: <?php echo $order_type; ?><br>
Order Date: <?php echo date('d M Y; h:i A', strtotime($order_date)); ?><br>
Total Amount: <?php echo $grand_total; ?><br>
Payment Status: <?php echo $payment_status; ?><br>
Current Order Status: <?php echo $order_status; ?><br>
<form method="POST">
<lable>Change Order Status : </lable>
<select name="od_st">
<option class="text-success font-weight-bold" ><?php echo $order_status; ?></option>
<option >confirmed</option>
<option >shipped</option>
<option >on the way</option>
<option >delivered</option>
</select>
<button class="btn btn-sm btn-primary" name="submit1">Submit</button>
</form>
Transaction Id: <?php echo $txnid; ?><br><br>
</div>
</div>
<div class="col-md-12 my-4">
<div class="card card-body">
<h5>Order Tracking Status Bar</h5>
<div class="progress">
<?php
if($order_status=='pending'){
echo '<div class="progress-bar bg-danger" style="width:25%">pending</div>';
} if($order_status=='confirmed'){
echo '<div class="progress-bar bg-warning" style="width:25%">confirmed</div>';
} if($order_status=='shipped'){
echo '<div class="progress-bar bg-warning" style="width:25%">confirmed</div>';
echo '<div class="progress-bar bg-primary" style="width:25%">shipped</div>';
} if($order_status=='on the way'){
echo '<div class="progress-bar bg-warning" style="width:25%">confirmed</div>';
echo '<div class="progress-bar bg-primary" style="width:25%">shipped</div>';
echo '<div class="progress-bar bg-info" style="width:25%">on the way</div>';
} if($order_status=='delivered'){
echo '<div class="progress-bar bg-warning" style="width:25%">confirmed</div>';
echo '<div class="progress-bar bg-primary" style="width:25%">shipped</div>';
echo '<div class="progress-bar bg-info" style="width:25%">on the way</div>';
echo '<div class="progress-bar bg-success" style="width:25%">delivered</div>';
}
?>
</div>
</div>
</div>
<div class="col-md-12">
<div class="card card-body">
<h5 class="font-weight-bold"><u>Product Details</u></h5>
<table class="table table-sm">
<tr>
<th>#</th>
<th>Image</th>
<th>Name</th>
<th>Qty</th>
<th>Price</th>
<th>Cashback</th>
<th>CB Value</th>
<th>Total</th>
</tr>
<?php
$i=0;
$total_cbvalue = $subtotal= $unit2 = 0;
$qry1 = mysqli_query($con,"SELECT * FROM `sales_item` WHERE order_id='$id'");
while($r1=mysqli_fetch_array($qry1)){
$i++;
$pid = $r1['p_id'];
$qry2 = mysqli_query($con,"SELECT * FROM `product` WHERE id='$pid'");
$r2=mysqli_fetch_array($qry2);
$unit2 += ($r1['quantity']*$r2['qty2']);
?>
<tr>
<td><?php echo $i ?></td>
<td><img width="80" height="80px" src="../<?php echo $r1['img1'] ?>"></td>
<td><?php echo $r1['pname']; ?></td>
<td><?php echo $qty = $r1['quantity']; ?></td>
<td><?php echo $price = $r1['price'] ?></td>
<td><?php echo $disc = $r2['disc']; ?>%</td>
<td><?php echo $cbvalue = ($price*$disc/100)*$qty; ?></td>
<td><?php echo number_format(($r1['quantity']*$r1['price']),2); ?></td>
</tr>
<?php
$subtotal += $r1['quantity']*$r1['price'];
$total_cbvalue += $cbvalue;
}
?>
<tr>
<td colspan="6"></td>
<td>Total Cashback</td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $total_cbvalue; ?></td>
</tr>
<tr>
<td colspan="6"></td>
<td>SubTotal</td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $subtotal.'.00'; ?></td>
</tr>
<tr>
<td colspan="6"></td>
<td>Shipping</td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $shipping = $r['shipping']; ?></td>
</tr>
<tr>
<td colspan="6"></td>
<td>Total</td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $subtotal+$shipping; ?></td>
</tr>
<tr>
<td colspan="6"></td>
<td>Use Wallet Balance</td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $r['use_w_bal']; ?></td>
</tr>
<tr>
<td colspan="6"></td>
<td>Final Value</td>
<td><i class="fas fa-rupee-sign"></i> <?php echo $grand_total; ?></td>
</tr>
</table>
</div>
</div>
</div>
<br><br>
<div class="text-center no-print">
<a target="_blank" class="btn btn-primary btn-sm" href="print-invoice2?id=<?=$id?>">Generate Invoice</a>
</div>
</div>
</main>
<?php include 'footer.php'; ?>
<script type="text/javascript">
var blink = document.getElementById('blink');
setInterval(function() {
blink.style.opacity = (blink.style.opacity == 0 ? 1 : 0);
}, 700);
</script>
</body>
</html>
<?php
if(isset($_POST['submit1'])){
$od_st = $_POST['od_st'];
date_default_timezone_set("Asia/Kolkata");
$date = date("d-m-Y h:i:s");
mysqli_query($con,"UPDATE `orders` SET `order_status` = '$od_st', od_st_date='$date' WHERE txnid='$txnid'");
echo '<script>window.location.href="";</script>';
}
?>