| 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/ |
Upload File : |
<?php session_start();
if (isset($_GET['order_id'])) {
$order_id = base64_decode($_GET['order_id']);
} else {
echo '<script>window.location.href="login";</script>';
die();
}
ini_set('display_errors', 1);
include 'action/config.php';
$qry = mysqli_query($con, "SELECT * FROM `orders` WHERE id='$order_id'");
$r = mysqli_fetch_array($qry);
$grand_total = $r['grand_total'];
$payment_status = $r['payment_status'];
$txnid = $r['txnid'];
$use_w_bal = $r['use_w_bal'];
?>
<!DOCTYPE html>
<html lang="en" data-bs-theme="light">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<meta name="keywords" content="">
<link rel="icon" href="assets/img/favicon.png" type="image/png" sizes="16x16">
<title><?= $domain . ' ' . $page . '-' . $r['invoice_no'] ?></title>
<link rel="stylesheet" href="assets/css/main.css">
<style>
@media print {
.no-print {
display: none;
}
}
</style>
</head>
<body class="bg-white">
<!--main content wrapper start-->
<div class="main-wrapper">
<?php include './header.php'; ?>
<!--invoice section start-->
<section class="invoice-section pt-6 pb-120">
<div class="container-fluid">
<div class="text-center">
<div class="col-md-12 col-12">
<div class="">
<a href="#"><img src="assets/img/logo.png" alt="logo" class="img-fluid"></a>
<h4 class="text-secondary"><?= $shop['name'] ?></h4>
<h6><?= $shop['address'] ?></h6>
<p class="mb-0 pb-0"><i class="fa fa-phone"></i> <?= $shop['phone'] . ', <i class="fa fa-envelope"></i> ' . $shop['email'] ?></p>
<p class="mt-0 pt-0"><i class="fas fa-globe"></i> <?= $domain ?></p>
</div>
</div>
</div>
<hr>
<div class="invoice-box py-4 px-4">
<div class="row g-5 justify-content-between">
<div class="col-md-7 col-7">
<h6 class="mb-2">Shipping Address</h6>
<p class="mb-0">
<?= $r['name'] ?><br>
<?= $r['address1'] . '<br>' . $r['address2'] ?><br>
<?= $r['city'] . ', ' . $r['state'] . ' - ' . $r['pin'] ?><br>
<?= $r['phone'] ?><br>
</p>
</div>
<div class="col-md-5 col-5">
<div class="invoice-title d-flex align-items-center">
<h3>Invoice</h3>
<span class="badge rounded-pill bg-primary-light text-primary fw-medium ms-3"><?= $r['order_status'] ?></span>
</div>
<table class="invoice-table-sm">
<tr>
<td><strong>Invoice No</strong></td>
<td>00<?= $r['invoice_no'] ?></td>
</tr>
<tr>
<td><strong>Date</strong></td>
<td><?= date('d M Y', strtotime($r['order_date'])) ?></td>
</tr>
<tr>
<td><strong>Amount</strong></td>
<td><i class="fa fa-inr"></i> <?= $r['grand_total'] ?></td>
</tr>
<tr>
<td><strong>Pay Mode</strong></td>
<td><?= 'Online' ?></td>
</tr>
</table>
</div>
</div>
<div class="table-responsive mt-6">
<table class="table table-bordered">
<tr>
<th>#</th>
<th>Product</th>
<th>Qty</th>
<th>Price</th>
<th>Cashback</th>
<th>CB Value</th>
<th>Total</th>
</tr>
<?php
$i = 0;
$subtotal = $unit2 = $total_cbvalue = 0;
$qry1 = mysqli_query($con, "SELECT * FROM `sales_item` WHERE order_id='$order_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 style="width: 35%"><?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><i class="fa fa-inr"></i> <?php echo $cbvalue = ($price*$disc/100)*$qty; ?></td>
<td><i class="fa fa-inr"></i> <?php echo $r1['quantity'] * $r1['price'] . '.00'; ?></td>
</tr>
<?php
$subtotal += $r1['quantity'] * $r1['price'];
$total_cbvalue += $cbvalue;
}
?>
<tr>
<td colspan="5">SubTotal</td>
<td><i class="fa fa-inr"></i> <?= $total_cbvalue ?></td>
<td><i class="fa fa-inr"></i> <?php echo $subtotal . '.00'; ?></td>
</tr>
<tr>
<td colspan="6">Shipping(+)</td>
<td><i class="fa fa-inr"></i> <?= $r['shipping'] . '.00' ?></td>
</tr>
<?php if ($use_w_bal > 0) { ?>
<tr>
<td colspan="6">Wallet Bal(-)</td>
<td><i class="fas fa-inr"></i> <?php echo number_format($use_w_bal, 2); ?></td>
</tr>
<?php } ?>
<tr>
<td colspan="6">Final Value</td>
<td><i class="fa fa-inr"></i> <?php echo $grand_total; ?></td>
</tr>
</table>
</div>
<div class="text-center no-print">
<button onclick="window.print();" class="btn btn-primary btn-md">Print Invoice</button>
</div>
</div>
</div>
</section>
<div class="no-print"><?php include './footer.php'; ?></div>
</body>
</html>