|
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/public_html/invoice/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
require_once 'db.php';
if(!isset($_SESSION["logs"])){
redirect("index.php");
}
// purchase_id, invoice_no, vendor_id, bill_date, created_at
$data["product"]=resultSet($con, "SELECT * FROM purchases p inner join purchase_items v on v.purchase_id = p.purchase_id inner join vendor ve on ve.veid =p.vendor_id group by p.purchase_id ");
?>
<!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" />
<!--begin::Fonts(mandatory for all pages)-->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Inter:300,400,500,600,700" />
<!--end::Fonts-->
<!--begin::Vendor Stylesheets(used for this page only)-->
<link href="assets/plugins/custom/datatables/datatables.bundle.css" rel="stylesheet" type="text/css" />
<!--end::Vendor Stylesheets-->
<!--begin::Global Stylesheets Bundle(mandatory for all pages)-->
<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" />
<!--end::Global Stylesheets Bundle-->
<script>// Frame-busting to prevent site from being loaded within a frame without permission (click-jacking) if (window.top != window.self) { window.top.location.replace(window.self.location.href); }</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">PurchaseEntry</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="product-search" class="form-control form-control-solid w-250px ps-12" placeholder="Search Purchase Name" />
<!-- <input type="text" data-kt-ecommerce-product-filter="search" class="form-control form-control-solid w-250px ps-12" placeholder="Search Product" /> -->
<!-- <link rel="stylesheet" href="styles.css"> -->
</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-purchaseEntry.php" class="btn btn-primary">Add PurchaseEntry</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_products_table">
<thead>
<tr class="text-start text-gray-500 fw-bold fs-7 text-uppercase gs-0">
<th class="w-10px pe-2">
</th>
<th>Invoice Number</th>
<th class="min-w-10px">Vendor Name</th>
<!-- <th>Description</th> -->
<!-- <th class="text-end min-w-13px">Base Price</th> -->
<!-- <th class="text-end min-w-100px">Qty</th>
<th class="text-end min-w-100px">Gst</th> -->
<th class="text-end min-w-100px">Bill Date</th>
<th class="text-center min-w-100px">Time</th>
<th class="text-end min-w-100px">Actions</th>
</tr>
</thead>
<tbody class="fw-semibold text-gray-600">
<!-- Static Row Example -->
<?php foreach ($data["product"] as $row): ?>
<tr class="product-row">
<td>
<!-- purchase_id, invoice_no, vendor_id, bill_date, created_at -->
</td>
<td>
<a href="#" class="text-gray-800 text-hover-primary fs-5 fw-bold"><?php echo $row['invoice_no']; ?></a>
</td>
<td>
<span class="fw-bold"><?php echo $row['vename']; ?></span>
</td>
<td class="text-end pe-0">
<?php echo $row['bill_date']; ?>
</td>
<td class='text-center'>
<?php echo $row['created_at']; ?>
</td>
<td class="text-end">
<a href="#" class="btn btn-sm btn-light btn-flex btn-center btn-active-light-primary" data-kt-menu-trigger="click" data-kt-menu-placement="bottom-end">Actions
<i class="ki-duotone ki-down fs-5 ms-1"></i>
</a>
<div class="menu menu-sub menu-sub-dropdown menu-column menu-rounded menu-gray-600 menu-state-bg-light-primary fw-semibold fs-7 w-125px py-4" data-kt-menu="true">
<form id="frm2" class="frm2" action="" method="POST">
<input type="hidden" name="action" id="action" value="edit">
<input type="hidden" name="pid" value="">
<div class="menu-item px-3">
<a href="edit-purchaseEntry.php?perid=<?php echo $row['purchase_id'] ?>" type="submit" name="submit" class="menu-link btn edit">Edit</a>
</div>
</form>
<form id="frm1" class="frm1" action="" method="POST">
<input type='hidden' name='action' id='action' value='delete'>
<input type="hidden" name="purchase_id" value="<?php echo $row["purchase_id"]; ?>">
<div class="menu-item px-3">
<a type="submit" name="submit" class="menu-link del_row btn" purchase_id='<?php echo $row["purchase_id"]; ?>'>Delete</a>
</div>
</form>
</div>
</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>
<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/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>
<!--end::Custom Javascript-->
<script>
$(document).ready(function () {
// Handle delete button click using event delegation
$(document).on("click", ".del_row", function (event) {
event.preventDefault(); // Prevent default action
var $this = $(this); // Reference to the clicked button
var productId = $this.closest("form").find("input[name='pid']").val();
var Product = $this.closest('.product-row').find('.fs-5').text().trim();
// First, check if deletion is allowed
$.ajax({
url: "ajax_product.php",
type: "POST",
data: { pid: productId, action: "check_delete" }, // New action to check before delete
dataType: "json",
success: function (response) {
if (response.status === "error") {
// Show error message and prevent deletion
swal.fire({
title: "Error",
text: response.message,
icon: "error"
});
} else {
// Show confirmation modal since deletion is allowed
swal.fire({
title: "Are you sure?",
html: "You are about to delete <strong>" + Product + "</strong>.",
icon: "warning",
showCancelButton: true,
confirmButtonColor: "#d33",
cancelButtonColor: "#3085d6",
confirmButtonText: "Yes, delete!"
}).then((result) => {
if (result.isConfirmed) {
$this.closest("form").submit(); // Submit the form to delete the product
}
});
}
},
error: function () {
swal.fire({
title: "Error",
text: "An error occurred while checking the product.",
icon: "error"
});
}
});
});
// Handle form submission (actual deletion)
$(document).on("submit", ".frm1", function (event) {
event.preventDefault(); // Prevent default form submission
var formData = $(this).serialize();
var $form = $(this);
// Send AJAX request to delete the record
$.ajax({
url: "ajax_product.php",
type: $form.attr("method"),
data: formData,
dataType: "json",
success: function (response) {
if (response.status === "success") {
swal.fire({
title: "Deleted!",
text: response.message,
icon: "success"
}).then(() => {
location.reload(); // Reload page after deletion
});
} else {
swal.fire({
title: "Error",
text: response.message,
icon: "error"
});
}
},
error: function () {
swal.fire({
title: "Error",
text: "An error occurred while deleting the item.",
icon: "error"
});
}
});
});
});
</script>
<script>
$(document).ready(function () {
var table = $("#kt_ecommerce_products_table").DataTable({
"paging": true, // Enable pagination
"ordering": true, // Enable sorting
"info": true, // Show table info
"searching": true, // Enable built-in search
"lengthMenu": [10, 25, 50, 100], // Entries per page options
"pageLength": 10, // Default rows per page
"language": {
"emptyTable": "No Purchase Entry Records Found", // Custom no results text
}
});
// Hook up search input to the table's built-in search
$('#product-search').on('keyup', function () {
table.search(this.value).draw();
});
});
</script>
<!--end::Javascript-->
</body>
<!--end::Body-->
</html>