| 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/config.php';
$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'];
$address = $r['address1'];
$landmark = $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'];
$shipping = $r['shipping'];
$use_w_bal = $r['use_w_bal'];
$subtotal=0;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- Required meta tags -->
<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><?= 'Invoice id '. $id.' - '. $name ?></title>
<link href="../admin/css/styles.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css" rel="stylesheet" crossorigin="anonymous" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.css" />
<link rel="shortcut icon" href="../img/favicon.png" />
<style>
.text-sm {
font-size: 13px;
font-weight: bold;
color: blue;
}
@media print {
.no-print,
.no-print * {
display: none !important;
}
}
</style>
</head>
<body>
<div class="container">
<!-- Main content -->
<section class="invoice my-2">
<div class="row invoice-info">
<div class="col-sm-12 invoice-col text-center" style="border: 1px solid green; padding-top:5px;">
<div class="row">
<div class="col-2 text-center">
<img width="70%" src="../img/favicon.png" alt="">
</div>
<div class="col-8">
<strong style="font-size: 1.5rem;" >जीवनदायिनी जीविका गौसेवा सदन</strong><br>
<?= $shop['address'] ?><br>
Phone: <?= $shop['phone'] ?><br>
<!--<b>GSTIN: <?= $shop['gst'] ?></b>-->
</div>
<div class="col-2"></div>
</div>
</div>
<div class="col-12 text-center bg-secondary text-white" style="border: 1px solid green; font-weight:900;">Tax Invoice</div>
<!-- /.col -->
<div class="col-sm-6 invoice-col pl-4" style="border: 1px solid green; padding-top:10px;">
Bill to,
<div>
<strong><?= $name ?></strong><br>
<?= $address . '<br>' . $landmark ?><br>
<?= $city . ', ' . $state . ' - ' . $pin ?><br>
<?= $phone . ' ' . $alternate ?><br>
</div>
</div>
<!-- /.col -->
<div class="col-sm-6 invoice-col" style="border: 1px solid green; padding-top:10px;">
<b>Invoice No.: <?= $r['invoice_no']; ?></b><br>
<br>
<b>Order ID:</b> <?= $id ?><br>
<b>Order Date:</b> <?= date('d M Y; h:i A', strtotime($order_date)) ?><br>
<b>Amount:</b> <i class="fa fa-inr"></i> <?= $grand_total ?><br>
</div>
</div>
<!-- Table row -->
<div class="row" style="border: 1px solid green; padding:10px;">
<div class="col-xs-12 table-responsive">
<table class="table table-sm">
<tr>
<th>#</th>
<th>Product</th>
<!--<th>HSN</th>-->
<th>Qty</th>
<th>Price</th>
<th>Total</th>
</tr>
<?php
$i = 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);
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $r1['pname']; ?></td>
<!--<td><?php echo $r2['hsn']; ?></td>-->
<td><?php echo $r1['quantity']; ?></td>
<td><?php echo $r1['price']; ?></td>
<td><i class="fa fa-inr"></i> <?php echo $r1['quantity'] * $r1['price'] . '.00'; ?></td>
</tr>
<?php
$subtotal += $r1['quantity'] * $r1['price'];
}
?>
<tr>
<td colspan="3"></td>
<td>SubTotal</td>
<td><i class="fa fa-inr"></i> <?php echo $subtotal . '.00'; ?></td>
</tr>
<tr>
<td colspan="3"></td>
<td>Shipping(+)</td>
<td><i class="fa fa-inr"> <?php echo number_format(($shipping > 0 ? $shipping : ($grand_total + $use_w_bal - $subtotal)),2); ?></i></td>
</tr>
<tr>
<td colspan="3"></td>
<td>Use Wallet Balance(-)</td>
<td><i class="fa fa-inr"></i> <?php echo number_format($use_w_bal,2); ?></td>
</tr>
<tr>
<td colspan="3"></td>
<td>Final Value</td>
<td><i class="fa fa-inr"></i> <?php echo $grand_total; ?></td>
</tr>
</table>
</div>
</div>
<div class="text-center mt-5">
<button class="btn btn-sm btn-info no-print" onclick="window.print()">Print</button>
<button class="btn btn-sm btn-danger no-print" onclick="window.close()">Close</button>
</div>
</section>
</div>
</body>
</html>
<script>
//window.print();
</script>