|
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/furniturevila/Admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("Includes/db.php");;
$bid = $_GET['id'];
$sql = "select * from tbl_order where id='$bid'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_row = mysqli_fetch_assoc($sql_res);
$state = $sql_row['state'];
$city = $sql_row['city'];
$dstate = $sql_row['dstate'];
$dcity = $sql_row['dcity'];
$sqls = "select * from tbl_states where id='$state'";
$sql_ress = mysqli_query($con, $sqls) or die(mysqli_error($con));
$sql_rows = mysqli_fetch_assoc($sql_ress);
$sqls = "select * from tbl_states where id='$dstate'";
$sql_ress = mysqli_query($con, $sqls) or die(mysqli_error($con));
$sql_rowsd = mysqli_fetch_assoc($sql_ress);
$states = $sql_rows['name'];
$statesd = $sql_rowsd['name'];
$sqlc = "select * from districts where id='$city'";
$sql_resc = mysqli_query($con, $sqlc) or die(mysqli_error($con));
$sql_rowc = mysqli_fetch_assoc($sql_resc);
$sqlc = "select * from districts where id='$dcity'";
$sql_resc = mysqli_query($con, $sqlc) or die(mysqli_error($con));
$sql_rowcd = mysqli_fetch_assoc($sql_resc);
$citys = $sql_rowc['name'];
$cityd = $sql_rowcd['name'];
$coup_co = $sql_row['coup_co'];
$sqlsc = "select * from tbl_coupon where id='$coup_co'";
$sql_ressc = mysqli_query($con, $sqlsc) or die(mysqli_error($con));
$sql_rowsc = mysqli_fetch_assoc($sql_ressc);
$cname = $sql_rowsc['name'];
$cprice = $sql_rowsc['price'];
?>
<!doctype html>
<html lang="en">
<head>
<?php include 'Includes/head.php'; ?>
</head>
<body data-sidebar="dark">
<!-- <body data-layout="horizontal" data-topbar="dark"> -->
<!-- Begin page -->
<div id="layout-wrapper">
<?php include 'Includes/header.php'; ?>
<!-- ========== Left Sidebar Start ========== -->
<div class="vertical-menu">
<div data-simplebar class="h-100">
<!--- Sidemenu -->
<?php include 'Includes/sidebar.php'; ?>
<!-- Sidebar -->
</div>
</div>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<!-- start page title -->
<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18"> Order View</h4>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<div class="invoice-title">
<h4 class="float-end font-size-16" style=" font-size: 15px!important;">Order # <?php echo $sql_row['order_no']; ?>
<br>
<!--<span>G.S.T No. :- 09AASFK9781E1ZK</span>-->
<br>
</h4>
<div class="mb-4">
<img src="../assets/img/logo/<?php echo $weblogo; ?>" alt="logo" height="20"/>
</div>
</div>
<hr>
<div class="row">
<div class="col-sm-6">
<address>
<strong>Billed To:</strong><br>
<?php echo $sql_row['fname'] . $sql_row['lname'] ; ?><br>
<?php echo $sql_row['email']; ?><br>
<?php echo $sql_row['phone']; ?><br>
</address>
</div>
<div class="col-sm-6 text-sm-end">
<address>
<strong>Shipped To:</strong><br>
<?php echo $sql_row['address']; ?><br>
<?php echo $states; ?><br>
<?php echo $citys; ?>
</address>
</div>
</div>
<div class="row">
<div class="col-sm-6 mt-3">
</div>
<div class="col-sm-6 mt-3 text-sm-end">
<address>
<strong>Order Date:</strong><br>
<?php echo $sql_row['order_date']; ?><br><br>
</address>
</div>
</div>
<div class="py-2 mt-3">
<h3 class="font-size-15 fw-bold">Order summary</h3>
</div>
<div class="table-responsive">
<table class="table table-nowrap">
<thead>
<tr>
<th style="width: 70px;">No.</th>
<th>Item</th>
<th class="text-end">Price</th>
<th class="text-end">Quanutity</th>
<th class="text-end">Total Price</th>
</tr>
</thead>
<tbody>
<?php
$bid = $_GET['id'];
$sqli = "select * from tbl_item where order_id='$bid'";
$sql_resi = mysqli_query($con, $sqli) or die(mysqli_error($con));
$sql_rowi = mysqli_fetch_array($sql_resi);
$pid = $sql_rowi['pid'];
$qtys = $sql_rowi['qty'];
$prices = $sql_rowi['price'];
$gd = $sql_rowi['goodies'];
$proid = explode(',', $pid);
$pqty = explode(',', $qtys);
$pprice = explode(',', $prices);
$gds = explode(',', $gd);
$p = 1;
for ($i=0; $i < count($proid) ; $i++) {
# code...
$pid = $proid[$i];
$s ="select * from tbl_product where id='$pid'";
$sql_r = mysqli_query($con, $s) or die(mysqli_error($con));
$sql_rs = mysqli_fetch_array($sql_r);
?>
<tr>
<td><?php echo $p; ?></td>
<td><?php echo $sql_rs['name']; ?> <br>
<?php if (empty($gd)) {
// echo 'io';
# code...
?>
<?php }
else
{?>
<label style="font-weight: bold;">Add some Goodies:</label> <br>
<?php
$j = 1;
for($k=0; $k<count($gds); $k++)
{
$gdv = $gds[$k];
$sql = "select * from tbl_goodies where id='$gdv'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_rowg = mysqli_fetch_array($sql_res);
?>
<div >
<span style="float: left;
position: relative;
"><?php echo $j; ?>.<?php echo $sql_rowg['name']; ?></span><br>
</div>
<?php $j++; } }
?>
</td>
<td class="text-end"><?php echo $pprice[$i];?></td>
<td class="text-end"><?php echo $pqty[$i]; ?></td>
<td class="text-end"><?php echo $pqty[$i] * $pprice[$i] ; ?></td>
</tr>
<?php $p++; } ?>
<tr>
<td colspan="4" class="text-end">Sub Total</td>
<td class="text-end"><i class="fa fa-rupee"></i><?php echo $sql_row['total_p']; ?><br></td>
</tr>
<tr>
<td colspan="4" class="border-0 text-end">
<strong>Total</strong></td>
<td class="border-0 text-end"><h4 class="m-0"><i class="fa fa-rupee"></i><?php echo $dis + $sql_row['total_p']; ?><br></h4></td>
</tr>
</tbody>
</table>
</div>
<div class="d-print-none">
<div class="float-end">
<a href="javascript:window.print()" class="btn btn-success waves-effect waves-light me-1"><i class="fa fa-print"></i></a>
</div>
</div>
</div>
</div>
</div>
</div><!-- end row -->
<!-- end row -->
<!-- end row -->
<!-- end row -->
</div>
<!-- container-fluid -->
</div>
<!-- End Page-content -->
<footer class="footer">
<?php include 'Includes/footer.php'; ?>
</footer>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right Sidebar -->
<!-- /Right-bar -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<?php include 'Includes/bscript.php'; ?>
</body>
</html>