|
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/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
include ("Admin/Includes/db.php");
@$uid = $_SESSION['userid'] ;
$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);
$rname = $sql_row['rname'];
$rphone = $sql_row['rphone'];
$order_no = $sql_row['order_no'];
$dis = $sql_row['discount'];
$name = $sql_row['fname'] . $sql_row['lname'] ;
$email = $sql_row['email'];
$phone = $sql_row['phone'];
$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);
$statesd = $sql_rowsd['name'];
$states = $sql_rows['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);
$cityd = $sql_rowcd['name'];
$citys = $sql_rowc['name'];
$add = $sql_row['address'];
$dadd = $sql_row['daddress'];
$dpincod = $sql_row['dpincod'];
$dlandmark = $sql_row['dlandmark'];
$deliver_date = $sql_row['deliver_date'];
$paymethod = $sql_row['payment_method'];
$odate = $sql_row['order_date'];
$total = $sql_row['total_p'];
$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">
<?php include 'include/head.php'; ?>
<style>
.list{
width: 100%;
height: 180px;
overflow: auto !important;
}
.nice-select{
float: none;
}
.tb{
font-size: 14px;
color: #ffffff;
font-weight: 500;
text-transform: capitalize;
background: #222222;
border-radius: 3px;
}
.borders table{
border: 1px solid black;
}
.borders th {
border: 1px solid black;
}
.borders td {
border: 1px solid black;
}
</style>
<body>
<div class="page-loader">
<div class="spinner-border" role="status">
<span class="sr-only">Loading...</span>
</div>
</div>
<div class="wrapper">
<!-- ======================== Navigation ======================== -->
<?php include 'include/header.php'; ?>
<!-- ======================== About ======================== -->
<section class="blog blog-category blog-animated pt-0">
<!--Header-->
<header>
<div class="container">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item active" aria-current="page">View Order</li>
</ol>
<h2 class="title">View Order</h2>
<div class="text">
<!--<p>Suspendisse scelerisque odio eu felis eleifend</p>-->
</div>
</div>
</header>
<!--Content-->
<div class="container">
<div class="row">
<div class="col-md-12 col-sm-12">
<!-- Form Start -->
<div class="card">
<div class="card-body">
<div id="DivIdToPrint">
<table style="width: 100%;max-width: 100%;margin-bottom: 5px;border-collapse: collapse;">
<tr style="">
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;">
<img src="assets/img/logo/<?php echo $weblogo; ?>" style="height: 60px;"></td>
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;float: right;font-size: 1.5rem;
font-weight: 600;">Order # <?php echo $order_no; ?>
<br>
<span>G.S.T No. :- 09AASFK9781E1ZK</span>
</td>
</tr>
</table>
<table style="width: 100%;max-width: 100%;margin-bottom: 20px;border-collapse: collapse;">
<thead>
<tr>
<td colspan="2" style="border: 1px solid #000;padding: 8px;line-height: 1.42857143;vertical-align: top;font-weight: bold;border-top: 1px solid #2a6282;border-right: 1px solid #2a6282;border-bottom: 1px solid #2a6282;font-weight: 600;white-space: nowrap;text-overflow: ellipsis;text-overflow: ellipsis-word;text-overflow: clip;overflow: hidden;padding: 5px 6px;">Order Details</td>
</tr>
</thead>
<tbody>
<tr>
<td style="width: 50%;border:1px solid #000;padding: 8px;line-height: 1.42857143;vertical-align: top;">
<h5 style="font-size: 1.5rem;font-weight: 600;">Billed To:</h5>
<h5 class="font-size-15 mb-2"><?php echo $name; ?></h5>
<p class="mb-1"><?php echo $email; ?></p>
<p class="mb-1"><?php echo $phone; ?></p>
</td>
<td style="width: 50%;border:1px solid #000;padding: 8px;line-height: 1.42857143;vertical-align: top;">
<h5 style="font-size: 1.5rem;font-weight: 600;">Shipped To:</h5>
<p class="mb-1"><?php echo $add; ?></p>
<p class="mb-1"><?php echo $citys; ?></p>
<p class="mb-1"><?php echo $states ; ?></p>
<h5 style="font-size: 1.5rem;font-weight: 600;">Order Date:</h5>
<p> <?php echo $odate; ?></p>
</td>
</tr>
</tbody>
</table>
<div class="py-2 borders">
<h5 class="font-size-15">Order summary</h5>
<table style="width: 100%;max-width: 100%;margin-bottom: 5px;border-collapse: collapse;">
<h3> </h3>
<thead>
<tr>
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;"><b>No</b></td>
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;"><b>Item</b></td>
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;"><b>Price</b></td>
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;"><b>Quanutity</b></td>
<td style="padding: 8px;line-height: 1.42857143;vertical-align: top;"><b>Total Price </b></td>
</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 style=" border-top: 1px solid #dee2e6;;padding: 8px;line-height: 1.42857143;vertical-align: top;"><?php echo $p; ?> </td>
<td style=" border-top: 1px solid #dee2e6;;padding: 8px;line-height: 1.42857143;vertical-align: top;">
<h5 style="font-size: 1.5rem;font-weight: 600;"><?php echo $sql_rs['name']; ?></h5>
</td>
<td class="text-center" style=" border-top: 1px solid #dee2e6;;padding: 8px;line-height: 1.42857143;vertical-align: top;"><?php echo $pprice[$i] ; ?></td>
<td class="text-center" style=" border-top: 1px solid #dee2e6;;padding: 8px;line-height: 1.42857143;vertical-align: top;"><?php echo $pqty[$i]; ?></td>
<td class="text-center" style=" border-top: 1px solid #dee2e6;;padding: 8px;line-height: 1.42857143;vertical-align: top;"><?php echo $pqty[$i] * $pprice[$i] ; ?></td>
</tr>
<?php $p++; } ?>
<tr>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line "><h5 class="m-0"> Sub Total</h5></td>
<td class="no-line">
<h5 class="m-0" style="text-align: center;"> <i class="fa fa-rupee"></i><?php echo $total; ?></h5>
</td>
</tr>
<tr>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line "><h4 style="font-size: 1.5rem;font-weight: 600;"> Total Price </h4></td>
<td class="no-line">
<h5 class="m-0" style="text-align: center;font-size: 1.5rem;font-weight: 600;"><i class="fa fa-rupee"></i><?php echo $total; ?></h5>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Form End -->
</div>
</div> <!--/row-->
</div><!--/container-->
</section>
<?php include 'include/footer.php'; ?>
</div> <!--/wrapper-->
<!--Scripts -->
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/ion.rangeSlider.js"></script>
<script src="js/magnific-popup.js"></script>
<script src="js/owl.carousel.js"></script>
<script src="js/tilt.jquery.js"></script>
<script src="js/jquery.easypiechart.js"></script>
<script src="js/bigtext.js"></script>
<script src="js/main.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#state').on('change', function() {
var stateID = $(this).val();
// alert(conID);
$.ajax({
type: 'POST',
url: 'Admin/get_state.php',
data: {city: stateID },
success: function(response) {
// alert(response);
$('#citys').html(response);
$('select').niceSelect('update');
// content.html(response);
}
});
});
});
</script>
</body>
</html>