|
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");
// $bid = $_GET['id'];
// $sql = "select * from tbl_item where id='$bid'";
// $sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
// $sql_row = mysqli_fetch_assoc($sql_res);
?>
<!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>All Items </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 class="btn-group moreaction" role="group" >
<button id="btnGroupVerticalDrop1" type="button" class="btn btn-light dropdown-toggle" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
More Actions <i class="mdi mdi-chevron-down"></i>
</button>
<div class="dropdown-menu" aria-labelledby="btnGroupVerticalDrop1" style="">
<a class="dropdown-item" id="btn_acti">Mark as Active</a>
<a class="dropdown-item" id="btn_ina">Mark as Inactive</a>
<a class="dropdown-item" id="btn_">Delete</a>
</div>
</div>
</div>
</div>
<div class="col-sm-6">
<div class="float-end d-none d-sm-block" style="margin-right: 9px;">
<a href="item_add.php" class="btn btn-success"><i class="fa fa-plus" aria-hidden="true"></i> New</a>
</div>
</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">
<?php
if(@$_SESSION['flash_message'] == 'add') {
$message = $_SESSION['flash_message'];
unset($_SESSION['flash_message']); ?>
<div class="alert alert-success login-error"><?php echo 'Data Added Sucessfully'; ?></div>
<?php }
if(@$_SESSION['flash_message'] == 'edit') {
$message = $_SESSION['flash_message'];
unset($_SESSION['flash_message']); ?>
<div class="alert alert-success login-error"><?php echo 'Data Edit Sucessfully'; ?></div>
<?php }
if(@$_SESSION['flash_message'] == 'sdelete') {
$message = $_SESSION['flash_message'];
unset($_SESSION['flash_message']); ?>
<div class="alert alert-danger login-error"><?php echo 'Data Delete Sucessfully '; ?></div>
<?php }
?>
<form method="POST">
<div class="row">
<div class="col-md-4">
<label> Warehouse </label>
<select name="wname" class="form-control state" id="form-field-select-4" data-placeholder="Choose a state" tabindex="1">
<option value="">Select Warehouse</option>
<?php
$select = " select * from tbl_warhouse";
$r = mysqli_query($con,$select);
while($marriage = mysqli_fetch_array($r))
{
?>
<option value="<?php echo $marriage['w_name'];?>"><?php echo $marriage['w_name'];?></option>
<?php }?>
</select>
</div>
<div class="col- form-group">
<button type="submit" name="find" class=" btn-md btn btn-primary" style="margin-top: 23px;"> <i class="fa fa-save"></i> submit</button>
</div>
</div>
</form>
<br><br>
<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><input id="select_all" class="slect_all" type="checkbox" value="Select All"></th>
<th>File</th>
<th>Name</th>
<th>Warhouse Name</th>
<th>SKU</th>
<th>STOCK ON HAND </th>
<th>REORDER LEVEL</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if(isset($_POST['find']))
{
$wname = $_POST['wname'];
if ($wname != '' && $wname!='all') {
$wname = " AND wname='$wname'";
} else {
$wname = '';
}
$sql = "select * from tbl_item where filter IS NULL AND item_type='item' $wname";
}
else
{
$sql = "select * from tbl_item where item_type='item'";
}
$count = 1;
// $sql = "select * from tbl_item where item_type='item'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($sql_row = mysqli_fetch_assoc($sql_res)){
$image = $sql_row['file'];
?>
<a href="item_view.php?id=<?php echo $sql_row['id']; ?>"><tr>
<td>
<div class="form-check mb-2">
<input class="checkbox" name="ratec" type="checkbox" value="<?php echo $sql_row['id']; ?>" id="sd<?php echo $sql_row['id']; ?>">
</div>
</td>
<td>
<?php
if($image != ''){ ?>
<a href="item/<?php echo $sql_row['file']; ?>" download><i class="fa fa-download"></i></a>
<?php }else{ ?>
<?php echo "No File Found "; ?>
<?php }
?>
</td>
<td><?php echo $sql_row['name']; ?></td>
<td><?php echo $sql_row['wname']; ?></td>
<td><?php echo $sql_row['sku']; ?></td>
<td><?php echo $sql_row['openstock']; ?></td>
<td><?php echo $sql_row['reorderpoint']; ?></td>
<td>
<a href="./item_view.php?id=<?php echo $sql_row['id']; ?>" class=" text-primary">
<i class="fa fa-eye font-size-18"></i>
</a>
<a href="./transfer_data.php?id=<?php echo $sql_row['id']; ?>" class=" text-primary">
<i class="mdi mdi-bank-transfer font-size-18"></i>
</a>
</td>
</tr></a>
<?php $count++;
} ?>
</tbody>
</table>
</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>
<script>
$(document).ready(function() {
$('.login-error').delay(3000).fadeOut(300);
});
</script>
<script>
$(document).ready(function() {
//set initial state.
$('.moreaction').hide();
$('.slect_all').click(function() {
if (this.checked) {
$('.checkbox').each(function() {
this.checked = true;
$('.moreaction').show();
});
} else {
$('.checkbox').each(function() {
this.checked = false;
$('.moreaction').hide();
});
}
});
});
</script>
<script>
// $(document).ready(function() {
// //set initial state.
// $('.moreaction').hide();
// $('.checkbox').click(function() {
// var id = $(this).attr('id').split('e').pop();
// alert(id);
// if (this.checked) {
// $('#sd'+id).(function() {
// this.checked = true;
// $('.moreaction').show();
// });
// } else {
// $('#sd'+id).each(function() {
// this.checked = false;
// $('.moreaction').hide();
// });
// }
// });
// });
</script>
<script>
$(document).ready(function(){
$("#btn_").click(function(){
var favorite = [];
$.each($("input[name='ratec']:checked"), function(){
favorite.push($(this).val());
});
// alert("My favourite sports are: " + favorite.join(", "));
var a =favorite.join(",");
$.ajax
({
url: 'Ajax/delete_item.php',
data: {"city": a},
type: 'post',
success: function(result)
{
alert('Data delete Sucessfully');
location.reload();
// window.location.href = "change_rate.php?id="+result;
}
});
});
});
</script>
<script>
$(document).ready(function(){
$("#btn_ina").click(function(){
var favorite = [];
$.each($("input[name='ratec']:checked"), function(){
favorite.push($(this).val());
});
// alert("My favourite sports are: " + favorite.join(", "));
var a =favorite.join(",");
$.ajax
({
url: 'Ajax/inactive_item.php',
data: {"city": a},
type: 'post',
success: function(result)
{
alert('Item Deactive Sucessfully');
location.reload();
// window.location.href = "change_rate.php?id="+result;
}
});
});
});
</script>
<script>
$(document).ready(function(){
$("#btn_acti").click(function(){
var favorite = [];
$.each($("input[name='ratec']:checked"), function(){
favorite.push($(this).val());
});
// alert("My favourite sports are: " + favorite.join(", "));
var a =favorite.join(",");
$.ajax
({
url: 'Ajax/active_item.php',
data: {"city": a},
type: 'post',
success: function(result)
{
alert('Item Active Sucessfully');
location.reload();
// window.location.href = "change_rate.php?id="+result;
}
});
});
});
</script>
<!-- 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>