|
Server IP : 217.21.85.138 / Your IP : 216.73.216.103 Web Server : LiteSpeed System : Linux in-mum-web906.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u915722082 ( 915722082) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u915722082/.nvm/../public_html/invoice/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
require_once 'db.php';
if(!isset($_SESSION["logs"])){
redirect("index.php");
}
$data["product"] = resultSet($con, "SELECT *
FROM product p
INNER JOIN stock v ON v.pid = p.pid ");
?>
<!DOCTYPE html>
<html lang="en">
<!--begin::Head-->
<head>
<base href="" />
<title>TDS Admin Hub</title>
<meta charset="utf-8" />
<meta name="description" content="The most advanced Bootstrap 5 Admin Theme with 40 unique prebuilt layouts on Themeforest trusted by 100,000 beginners and professionals. Multi-demo, Dark Mode, RTL support and complete React, Angular, Vue, Asp.Net Core, Rails, Spring, Blazor, Django, Express.js, Node.js, Flask, Symfony & Laravel versions. Grab your copy now and get life-time updates for free." />
<meta name="keywords" content="metronic, bootstrap, bootstrap 5, angular, VueJs, React, Asp.Net Core, Rails, Spring, Blazor, Django, Express.js, Node.js, Flask, Symfony & Laravel starter kits, admin themes, web design, figma, web development, free templates, free admin themes, bootstrap theme, bootstrap template, bootstrap dashboard, bootstrap dak mode, bootstrap button, bootstrap datepicker, bootstrap timepicker, fullcalendar, datatables, flaticon" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta property="og:locale" content="en_US" />
<meta property="og:type" content="article" />
<meta property="og:title" content="Metronic - The World's #1 Selling Bootstrap Admin Template - Metronic by KeenThemes" />
<meta property="og:url" content="https://keenthemes.com/metronic" />
<meta property="og:site_name" content="Metronic by Keenthemes" />
<link rel="canonical" href="https://preview.keenthemes.com/metronic8" />
<link rel="shortcut icon" href="assets/logo/favicon.ico" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Inter:300,400,500,600,700" />
<link href="assets/plugins/custom/datatables/datatables.bundle.css" rel="stylesheet" type="text/css" />
<link href="assets/plugins/global/plugins.bundle.css" rel="stylesheet" type="text/css" />
<link href="assets/css/style.bundle.css" rel="stylesheet" type="text/css" />
<script></script>
</head>
<!--end::Head-->
<!--begin::Body-->
<body id="kt_app_body" data-kt-app-layout="dark-sidebar" data-kt-app-header-fixed="true" data-kt-app-sidebar-enabled="true" data-kt-app-sidebar-fixed="true" data-kt-app-sidebar-hoverable="true" data-kt-app-sidebar-push-header="true" data-kt-app-sidebar-push-toolbar="true" data-kt-app-sidebar-push-footer="true" data-kt-app-toolbar-enabled="true" class="app-default">
<!--begin::Theme mode setup on page load-->
<script>var defaultThemeMode = "light"; var themeMode; if ( document.documentElement ) { if ( document.documentElement.hasAttribute("data-bs-theme-mode")) { themeMode = document.documentElement.getAttribute("data-bs-theme-mode"); } else { if ( localStorage.getItem("data-bs-theme") !== null ) { themeMode = localStorage.getItem("data-bs-theme"); } else { themeMode = defaultThemeMode; } } if (themeMode === "system") { themeMode = window.matchMedia("(prefers-color-scheme: dark)").matches ? "dark" : "light"; } document.documentElement.setAttribute("data-bs-theme", themeMode); }
</script>
<!--end::Theme mode setup on page load-->
<!--begin::App-->
<div class="d-flex flex-column flex-root app-root" id="kt_app_root">
<!--begin::Page-->
<div class="app-page flex-column flex-column-fluid" id="kt_app_page">
<!--begin::Header-->
<div id="kt_app_header" class="app-header" data-kt-sticky="true" data-kt-sticky-activate="{default: true, lg: true}" data-kt-sticky-name="app-header-minimize" data-kt-sticky-offset="{default: '200px', lg: '0'}" data-kt-sticky-animation="false">
<!--begin::Header container-->
<div class="app-container container-fluid d-flex align-items-stretch justify-content-between" id="kt_app_header_container">
<!--begin::Sidebar mobile toggle-->
<div class="d-flex align-items-center d-lg-none ms-n3 me-1 me-md-2" title="Show sidebar menu">
<div class="btn btn-icon btn-active-color-primary w-35px h-35px" id="kt_app_sidebar_mobile_toggle">
<i class="ki-duotone ki-abstract-14 fs-2 fs-md-1">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
</div>
<!--end::Sidebar mobile toggle-->
<!--begin::Mobile logo-->
<div class="d-flex align-items-center flex-grow-1 flex-lg-grow-0">
<a href="products.php" class="d-lg-none">
<img alt="Logo" src="assets/media/logos/default-small.svg" class="h-30px" />
</a>
</div>
<!--end::Mobile logo-->
<!--begin::Header wrapper-->
<div class="d-flex align-items-stretch justify-content-between flex-lg-grow-1" id="kt_app_header_wrapper">
<!--begin::Menu wrapper-->
<div class="app-header-menu app-header-mobile-drawer align-items-stretch" data-kt-drawer="true" data-kt-drawer-name="app-header-menu" data-kt-drawer-activate="{default: true, lg: false}" data-kt-drawer-overlay="true" data-kt-drawer-width="250px" data-kt-drawer-direction="end" data-kt-drawer-toggle="#kt_app_header_menu_toggle" data-kt-swapper="true" data-kt-swapper-mode="{default: 'append', lg: 'prepend'}" data-kt-swapper-parent="{default: '#kt_app_body', lg: '#kt_app_header_wrapper'}">
<!--begin::Menu-->
<div class="menu menu-rounded menu-column menu-lg-row my-5 my-lg-0 align-items-stretch fw-semibold px-2 px-lg-0" id="kt_app_header_menu" data-kt-menu="true">
<!--begin:Menu item-->
<!--end:Menu item-->
</div>
<!--end::Menu-->
</div>
<!--end::Menu wrapper-->
<!--begin::Navbar-->
<div class="app-navbar flex-shrink-0">
<!--begin::Search-->
<!--end::Search-->
<!--begin::Activities-->
<!--end::Activities-->
<!--begin::Notifications-->
<!--end::Notifications-->
<!--begin::Chat-->
<!--end::Chat-->
<!--begin::My apps links-->
<!--end::My apps links-->
<!--begin::Theme mode-->
<div class="app-navbar-item ms-1 ms-md-4">
<!--begin::Menu toggle-->
<a href="#" class="btn btn-icon btn-custom btn-icon-muted btn-active-light btn-active-color-primary w-35px h-35px" data-kt-menu-trigger="{default:'click', lg: 'hover'}" data-kt-menu-attach="parent" data-kt-menu-placement="bottom-end">
<i class="ki-duotone ki-night-day theme-light-show fs-1">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
<span class="path5"></span>
<span class="path6"></span>
<span class="path7"></span>
<span class="path8"></span>
<span class="path9"></span>
<span class="path10"></span>
</i>
<i class="ki-duotone ki-moon theme-dark-show fs-1">
<span class="path1"></span>
<span class="path2"></span>
</i>
</a>
<!--begin::Menu toggle-->
<!--begin::Menu-->
<div class="menu menu-sub menu-sub-dropdown menu-column menu-rounded menu-title-gray-700 menu-icon-gray-500 menu-active-bg menu-state-color fw-semibold py-4 fs-base w-150px" data-kt-menu="true" data-kt-element="theme-mode-menu">
<!--begin::Menu item-->
<div class="menu-item px-3 my-0">
<a href="#" class="menu-link px-3 py-2" data-kt-element="mode" data-kt-value="light">
<span class="menu-icon" data-kt-element="icon">
<i class="ki-duotone ki-night-day fs-2">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
<span class="path5"></span>
<span class="path6"></span>
<span class="path7"></span>
<span class="path8"></span>
<span class="path9"></span>
<span class="path10"></span>
</i>
</span>
<span class="menu-title">Light</span>
</a>
</div>
<!--end::Menu item-->
<!--begin::Menu item-->
<div class="menu-item px-3 my-0">
<a href="#" class="menu-link px-3 py-2" data-kt-element="mode" data-kt-value="dark">
<span class="menu-icon" data-kt-element="icon">
<i class="ki-duotone ki-moon fs-2">
<span class="path1"></span>
<span class="path2"></span>
</i>
</span>
<span class="menu-title">Dark</span>
</a>
</div>
<!--end::Menu item-->
<!--begin::Menu item-->
<div class="menu-item px-3 my-0">
<a href="#" class="menu-link px-3 py-2" data-kt-element="mode" data-kt-value="system">
<span class="menu-icon" data-kt-element="icon">
<i class="ki-duotone ki-screen fs-2">
<span class="path1"></span>
<span class="path2"></span>
<span class="path3"></span>
<span class="path4"></span>
</i>
</span>
<span class="menu-title">System</span>
</a>
</div>
<!--end::Menu item-->
</div>
<!--end::Menu-->
</div>
<!--end::Theme mode-->
<!--begin::User menu-->
<?php include "logo.php" ?>
<!--end::User menu-->
<!--begin::Header menu toggle-->
<div class="app-navbar-item d-lg-none ms-2 me-n2" title="Show header menu">
<div class="btn btn-flex btn-icon btn-active-color-primary w-30px h-30px" id="kt_app_header_menu_toggle">
<i class="ki-duotone ki-element-4 fs-1">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
</div>
<!--end::Header menu toggle-->
<!--begin::Aside toggle-->
<!--end::Header menu toggle-->
</div>
<!--end::Navbar-->
</div>
<!--end::Header wrapper-->
</div>
<!--end::Header container-->
</div>
<!--end::Header-->
<!--begin::Wrapper-->
<div class="app-wrapper flex-column flex-row-fluid" id="kt_app_wrapper">
<!--begin::Sidebar-->
<div id="kt_app_sidebar" class="app-sidebar flex-column" data-kt-drawer="true" data-kt-drawer-name="app-sidebar" data-kt-drawer-activate="{default: true, lg: false}" data-kt-drawer-overlay="true" data-kt-drawer-width="225px" data-kt-drawer-direction="start" data-kt-drawer-toggle="#kt_app_sidebar_mobile_toggle">
<!--begin::Logo-->
<div class="app-sidebar-logo px-6" id="kt_app_sidebar_logo">
<!--begin::Logo image-->
<a href="products.php">
<img alt="Logo" src="assets/media/logos/LOGO.png" class="h-25px app-sidebar-logo-default" />
<img alt="Logo" src="assets/media/logos/default-small.svg" class="h-20px app-sidebar-logo-minimize" />
</a>
<div id="kt_app_sidebar_toggle" class="app-sidebar-toggle btn btn-icon btn-shadow btn-sm btn-color-muted btn-active-color-primary h-30px w-30px position-absolute top-50 start-100 translate-middle rotate" data-kt-toggle="true" data-kt-toggle-state="active" data-kt-toggle-target="body" data-kt-toggle-name="app-sidebar-minimize">
<i class="ki-duotone ki-black-left-line fs-3 rotate-180">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
<!--end::Sidebar toggle-->
</div>
<!--end::Logo-->
<!--begin::sidebar menu-->
<?php include "sidebar.php" ?>
<!--end::sidebar menu-->
<!--begin::Footer-->
<!--end::Footer-->
</div>
<!--end::Sidebar-->
<!--begin::Main-->
<div class="app-main flex-column flex-row-fluid" id="kt_app_main">
<!--begin::Content wrapper-->
<div class="d-flex flex-column flex-column-fluid">
<!--begin::Toolbar-->
<div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
<!--begin::Toolbar container-->
<div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
<!--begin::Page title-->
<div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
<!--begin::Title-->
<h1 class="page-heading d-flex text-gray-900 fw-bold fs-3 flex-column justify-content-center my-0"> Stock Report</h1>
</div>
<!--end::Page title-->
<!--begin::Actions-->
<!--end::Actions-->
</div>
<!--end::Toolbar container-->
</div>
<!--end::Toolbar-->
<!--begin::Content-->
<div id="kt_app_content" class="app-content flex-column-fluid">
<!--begin::Content container-->
<div id="kt_app_content_container" class="app-container container-xxl">
<!--begin::Products-->
<div class="card card-flush">
<!--begin::Card header-->
<div class="card-header align-items-center py-5 gap-2 gap-md-5">
<!--begin::Card title-->
<div class="card-title">
<!--begin::Search-->
<div class="d-flex align-items-center position-relative my-1">
<i class="ki-duotone ki-magnifier fs-3 position-absolute ms-4">
<span class="path1"></span>
<span class="path2"></span>
</i>
<input type="text" id="category-search" class="form-control form-control-solid w-250px ps-12" placeholder="Stock Reports" />
</div>
<!--end::Search-->
</div>
<!--end::Card title-->
<!--begin::Card toolbar-->
<div class="card-toolbar flex-row-fluid justify-content-end gap-5">
<!--begin::Add product-->
<!-- <a href="add-greetings.php" class="btn btn-primary">Add Greetings</a> -->
<!--end::Add product-->
</div>
<!--end::Card toolbar-->
</div>
<!--end::Card header-->
<!--begin::Card body-->
<div class="card-body pt-0">
<!--begin::Table-->
<!-- <table class="table align-middle table-row-dashed fs-6 gy-5" id="kt_ecommerce_products_table"> -->
<table class="table align-middle table-row-dashed fs-6 gy-5" id='kt_ecommerce_category_table' >
<thead>
<tr class="text-start text-gray-500 fw-bold fs-7 text-uppercase gs-0">
<th class="w-10px pe-2">
<div class="form-check form-check-sm form-check-custom form-check-solid me-3">
<input class="form-check-input" type="checkbox" id="select-all-checkbox" />
</div>
</th>
<th>Product Name</th>
<th class="text-end min-w-100px">PACK NAME</th>
<th class="text-end min-w-100px">PACK TOTAL QTY</th>
<th class="text-end min-w-100px">PACK AVAILABLE QTY</th>
<th class="text-end min-w-100px">PACK SALES QTY</th>
<!-- <th class="text-end min-w-100px">SALES DATE</th>-->
<th class="text-end min-w-100px">Update Stock</th>
</tr>
</thead>
<tbody class="fw-semibold text-gray-600">
<?php foreach ($data["product"] as $row): ?>
<tr class="product-row">
<td>
<div class="form-check form-check-sm form-check-custom form-check-solid">
<input class="form-check-input product-checkbox" type="checkbox" />
</div>
</td>
<td >
<a href="#" class="text-gray-800 text-hover-primary fs-5 fw-bold"><?php echo $row['pname'] ; ?></a>
</td>
<td class='text-end'>
<a href="#" class="text-gray-800 text-hover-primary fs-5 fw-bold"><?php echo ($row['pack']); ?></a>
</td>
<td class='text-end'>
<a href="#" class="text-gray-800 text-hover-primary fs-5 fw-bold"><?php echo ($row['totalqty']); ?></a>
</td>
<td class='text-end'>
<a href="#" class="text-gray-800 text-hover-primary fs-5 fw-bold"><?php echo ($row['totalqty']-$row['quan']); ?></a>
</td>
<td class='text-end'>
<a href="#" class="text-gray-800 text-hover-primary fs-5 fw-bold"><?php echo ($row['quan']); ?></a>
</td>
<td class='text-end'>
<a href="" class="btn btn-primary fs-5 fw-bold" data-bs-toggle="modal"
data-bs-target="#kt_modal_update_details" data-pid='<?php echo $row['pid']; ?>' data-pname='<?php echo $row['pname'] ; ?>' data-pack='<?php echo ($row['pack']); ?>' >Update</a>
</td>
</tr>
<?php endforeach; ?>
<!-- More rows can follow -->
</tbody>
</table>
<!--end::Table-->
</div>
<!--end::Card body-->
</div>
<!--end::Products-->
</div>
<!--end::Content container-->
</div>
<!--end::Content-->
</div>
<!--end::Content wrapper-->
<!--begin::Footer-->
<div id="kt_app_footer" class="app-footer">
<!--begin::Footer container-->
<div class="app-container container-fluid d-flex flex-column flex-md-row flex-center flex-md-stack py-3">
<!--begin::Copyright-->
<div class="text-gray-900 order-2 order-md-1">
<span class="text-muted fw-semibold me-1">2025 ©</span>
<a href="https://thedotstudios.com/" target="_blank" class="text-gray-800 text-hover-primary">Copyright All rights reserved | Made with <span class="fa fa-heart text-danger"></span> <b> by TheDotStudios.</b></a>
</div>
<!--end::Copyright-->
<!--begin::Menu-->
<ul class="menu menu-gray-600 menu-hover-primary fw-semibold order-1">
<li class="menu-item">
<a href="https://thedotstudios.com/" target="_blank" class="menu-link px-2">About</a>
</li>
<li class="menu-item">
<a href="https://thedotstudios.com/" target="_blank" class="menu-link px-2">Support</a>
</li>
</ul>
<!--end::Menu-->
</div>
<!--end::Footer container-->
</div>
<!--end::Footer-->
</div>
<!--end:::Main-->
</div>
<!--end::Wrapper-->
</div>
<!--end::Page-->
</div>
<div id="kt_scrolltop" class="scrolltop" data-kt-scrolltop="true">
<i class="ki-duotone ki-arrow-up">
<span class="path1"></span>
<span class="path2"></span>
</i>
</div>
<div class="modal fade" id="kt_modal_update_details" tabindex="-1" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered mw-750px">
<div class="modal-content">
<form id="kt_ecommerce_add_category_form" class="" enctype="multipart/form-data" action="">
<div class="modal-header" id="kt_modal_update_user_header">
<h2 class="fw-bold">UPDATE STOCK</h2>
<div class="btn btn-icon btn-sm btn-active-icon-primary" data-kt-users-modal-action="close">
<span class="svg-icon svg-icon-1">
<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
<rect opacity="0.5" x="6" y="17.3137" width="16" height="2" rx="1" transform="rotate(-45 6 17.3137)" fill="currentColor" />
<rect x="7.41422" y="6" width="16" height="2" rx="1" transform="rotate(45 7.41422 6)" fill="currentColor" />
</svg>
</span>
</div>
</div>
<div class="modal-body py-10 px-lg-17">
<div class="form-group row">
<div class="col-md-4 ">
<h4 class='fw-bold'>PNAME</h4>
</div>
<div class="col-md-4">
<h4 class='fw-bold'>PACK NAME</h4>
</div>
<div class="col-md-4">
<h4 class='fw-bold'>QUANTITY</h4>
</div>
</div>
<div class="form-group pt-5 row align-items-center">
<div class="col-md-4">
<span class=''>
<input type="hidden" name="pid" id="pid" class='form-control' >
<h5 class='text-gray' id='pname'></h5>
</span>
</div>
<div class="col-md-4">
<span class=''>
<input type="hidden" name="packname" id="packname">
<h5 for="" id="packname_01"></h5>
</span>
</div>
<div class="col-md-4">
<input type="text" name="quan" id="quan" class='form-control' placeholder='Enter Quantity'>
</div>
</div>
<div class="d-flex justify-content-end mt-xl-5">
<button name="btn-submit" type="submit" id="btn-submit" class="btn btn-primary">
<span class="indicator-label">Submit</span>
<span class="indicator-progress">Please wait...
<span class="spinner-border spinner-border-sm align-middle ms-2"></span></span>
</button>
</div>
</div>
</form>
</div>
</div>
</div>
<script>var hostUrl = "assets/";</script>
<!--begin::Global Javascript Bundle(mandatory for all pages)-->
<script src="assets/plugins/global/plugins.bundle.js"></script>
<script src="assets/js/scripts.bundle.js"></script>
<!--end::Global Javascript Bundle-->
<!--begin::Vendors Javascript(used for this page only)-->
<script src="assets/plugins/custom/datatables/datatables.bundle.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script src="assets/js/custom/apps/ecommerce/catalog/products.js"></script>
<script src="assets/js/widgets.bundle.js"></script>
<script src="assets/js/custom/widgets.js"></script>
<script src="assets/js/custom/apps/chat/chat.js"></script>
<script src="assets/js/custom/utilities/modals/upgrade-plan.js"></script>
<script src="assets/js/custom/utilities/modals/create-app.js"></script>
<script src="assets/js/custom/utilities/modals/users-search.js"></script>
<script>
$(document).ready(function() {
$('#kt_ecommerce_add_category_form').on('submit', function(e) {
e.preventDefault();
var formData = new FormData(this);
$.ajax({
url: 'update_stock.php',
type: 'POST',
data: formData,
contentType: false,
processData: false,
beforeSend: function() {
$('#btn-submit .indicator-label').hide();
$('#btn-submit .indicator-progress').show();
},
success: function(response) {
Swal.fire('Success', response, 'success').then(function() {
location.reload();
});
$('#btn-submit .indicator-label').show();
$('#btn-submit .indicator-progress').hide();
// $('#kt_ecommerce_add_category_form')[0].reset();
},
error: function(xhr, status, error) {
Swal.fire('Error', 'Something went wrong: ' + error, 'error');
$('#btn-submit .indicator-label').show();
$('#btn-submit .indicator-progress').hide();
}
});
});
});
</script>
<script>
$(document).ready(function () {
$('[data-bs-target="#kt_modal_update_details"]').on('click', function () {
var pid = $(this).data('pid');
var pname = $(this).data('pname');
var pack = $(this).data('pack');
$('#pid').val(pid);
$('#pname').text(pname);
$('#packname').val(pack);
$('#packname_01').text(pack);
});
});
document.addEventListener("DOMContentLoaded", function() {
// Handle modal close button
const closeBtn = document.querySelector('[data-kt-users-modal-action="close"]');
if (closeBtn) {
closeBtn.addEventListener('click', function() {
// Hide the modal
const modal = document.getElementById('kt_modal_update_details');
const bsModal = bootstrap.Modal.getInstance(modal);
if (bsModal) {
bsModal.hide();
}
});
}
// Handle discard/cancel button
const cancelBtn = document.querySelector('[data-kt-users-modal-action="cancel"]');
if (cancelBtn) {
cancelBtn.addEventListener('click', function() {
const modal = document.getElementById('kt_modal_update_details');
const bsModal = bootstrap.Modal.getInstance(modal);
if (bsModal) {
bsModal.hide();
}
});
}
});
$(document).ready(function () {
var table = $("#kt_ecommerce_category_table").DataTable({
"paging": true,
"ordering": false,
"info": true,
"searching": true,
"lengthMenu": [10, 25, 50, 100],
"pageLength": 10,
"language": {
"emptyTable": "No customers records found",
}
});
// Hook up search input to the table's built-in search
$('#category-search').on('keyup', function () {
table.search(this.value).draw();
});
});
</script>
<!--end::Javascript-->
</body>
<!--end::Body-->
</html>