|
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["attributes"] = resultSet($con, "SELECT * FROM attributes");
$data["groupofattr"] = resultSet($con, "SELECT * FROM groupofattr WHERE gaid={$_GET['gaid']}");
?>
<!DOCTYPE html>
<html lang="en">
<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/media/logos/favicon.ico" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<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" />
<style>
.ck-editor__editable[role="textbox"] {
min-height: 180px;
}
.single-row .remove-field {
display: none;
}
</style>
</head>
<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-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>
<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">
<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">
<div class="app-container container-fluid d-flex align-items-stretch justify-content-between" id="kt_app_header_container">
<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>
<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>
<div class="d-flex align-items-stretch justify-content-between flex-lg-grow-1" id="kt_app_header_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'}">
<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">
</div>
</div>
<div class="app-navbar flex-shrink-0">
<div class="app-navbar-item ms-1 ms-md-4">
<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>
<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">
<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>
<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>
<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>
</div>
</div>
<?php include "logo.php" ?>
<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>
</div>
</div>
</div>
</div>
<div class="app-wrapper flex-column flex-row-fluid" id="kt_app_wrapper">
<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">
<div class="app-sidebar-logo px-6" id="kt_app_sidebar_logo">
<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>
</div>
<?php include "sidebar.php" ?>
</div>
<div class="app-main flex-column flex-row-fluid" id="kt_app_main">
<div class="d-flex flex-column flex-column-fluid">
<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">
</div>
<div class="d-flex align-items-center gap-2 gap-lg-3">
<div class="m-0">
<div class="menu menu-sub menu-sub-dropdown w-250px w-md-300px" data-kt-menu="true" id="kt_menu_658cdaf4294b1">
<div class="px-7 py-5">
<div class="fs-5 text-gray-900 fw-bold">Filter Options</div>
</div>
<div class="separator border-gray-200"></div>
<div class="px-7 py-5">
<div class="mb-10">
<label class="form-label fw-semibold">Status:</label>
<div>
<select class="form-select form-select-solid" multiple="multiple" data-kt-select2="true" data-close-on-select="false" data-placeholder="Select option" data-dropdown-parent="#kt_menu_658cdaf4294b1" data-allow-clear="true">
<option></option>
<option value="1">Approved</option>
<option value="2">Pending</option>
<option value="2">In Process</option>
<option value="2">Rejected</option>
</select>
</div>
</div>
<div class="mb-10">
<label class="form-label fw-semibold">Member Type:</label>
<div class="d-flex">
<label class="form-check form-check-sm form-check-custom form-check-solid me-5">
<input class="form-check-input" type="checkbox" value="1" />
<span class="form-check-label">Author</span>
</label>
<label class="form-check form-check-sm form-check-custom form-check-solid">
<input class="form-check-input" type="checkbox" value="2" checked="checked" />
<span class="form-check-label">Customer</span>
</label>
</div>
</div>
<div class="mb-10">
<label class="form-label fw-semibold">Notifications:</label>
<div class="form-check form-switch form-switch-sm form-check-custom form-check-solid">
<input class="form-check-input" type="checkbox" value="" name="notifications" checked="checked" />
<label class="form-check-label">Enabled</label>
</div>
</div>
<div class="d-flex justify-content-end">
<button type="reset" class="btn btn-sm btn-light btn-active-light-primary me-2" data-kt-menu-dismiss="true">Reset</button>
<button type="submit" class="btn btn-sm btn-primary" data-kt-menu-dismiss="true">Apply</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-12">
<div id="kt_app_content" class="app-content flex-column-fluid">
<div id="kt_app_content_container" class="app-container container-xxl">
<h1 class="page-heading d-flex text-gray-900 fw-bold fs-3 flex-column my-0">Edit Group of attribute</h1>
<ul class="breadcrumb breadcrumb-separatorless fw-semibold fs-7 my-0 pt-1">
<li class="breadcrumb-item text-muted">
<a class="text-muted text-hover-primary">Attributes</a>
</li>
<li class="breadcrumb-item">
<span class="bullet bg-gray-500 w-5px h-2px"></span>
</li>
<li class="breadcrumb-item text-muted"> Edit Group of attribute</li>
</ul>
<form id="kt_ecommerce_add_category_form" class="form d-flex flex-column flex-lg-row" enctype="multipart/form-data">
<input type="hidden" name="update" value="update">
<div class="d-flex flex-column flex-row-fluid gap-5 gap-lg-6">
<div class="card card-flush py-4 mt-5">
<div class="card-header">
<div class="card-title">
<h2>Group</h2>
</div>
</div>
<?php foreach ($data["groupofattr"] as $rr): ?>
<input type="hidden" name="gaid[]" value="<?= $rr['gaid'] ?>">
<div class="row">
<div class="card-body pt-0">
<input type="text" required class="form-control" name="gname" value='<?php echo $rr['gname'] ?>' placeholder="Enter a Group name" id="variation" />
<div class="text-muted fs-7 mt-2">Enter Group Name values like color, size, or other defining features</div>
</div>
<div class="card-body pt-0 col-12">
<div class="input-fields mt-5">
<div class="row mb-4">
<div class="col-lg-3">
<select class="form-select gaid" data-control="select2" name="variation_grp[]" data-placeholder="Select an Attribute">
<option></option>
<?php foreach ($data["attributes"] as $row): ?>
<option
value="<?= $row['ID']; ?>"
<?php echo ($rr['aid'] == $row['ID']) ? 'selected' : ''; ?>
data-vals="<?= htmlspecialchars($row['VARIATION_VAL']); ?>"
<?php if($rr['aid'] == $row['ID']): ?>
data-selected-vals="<?= htmlspecialchars($rr['avalue']); ?>"
<?php endif; ?>
>
<?= $row['VARIATION']; ?>
</option>
<?php endforeach; ?>
</select>
</div>
<div class="col-lg-3">
<select class="form-select variation-value" data-control="select2" name="variation_grpval[]" required data-placeholder="Select an value" multiple>
<option></option>
</select>
</div>
<div class="col-lg-1">
<button class="btn btn-secondary remove-field" disabled><span class="fa fa-close"></span></button>
</div>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
</div>
<div class="d-flex justify-content-end">
<a href="group-attributes.php" id="kt_ecommerce_add_product_cancel" class="btn btn-light me-5">Cancel</a>
<button type="submit" id="btn-submit" class="btn btn-primary">
<span class="indicator-label">Save Changes</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>
</div>
<div id="kt_app_footer" class="app-footer">
<div class="app-container container-fluid d-flex flex-column flex-md-row flex-center flex-md-stack py-3">
<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>
<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>
</div>
</div>
</div>
</div>
</div>
</div>
<script>var hostUrl = "assets/";</script>
<script src="assets/plugins/global/plugins.bundle.js"></script>
<script src="assets/js/scripts.bundle.js"></script>
<script src="assets/plugins/custom/datatables/datatables.bundle.js"></script>
<script src="assets/plugins/custom/formrepeater/formrepeater.bundle.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 () {
// Remove a row
$(document).on('click', '.remove-field', function () {
const inputFieldsDiv = $(this).closest('.input-fields');
const rowCount = inputFieldsDiv.children('.row').length;
if (rowCount > 1) {
$(this).closest('.row').remove();
updateRemoveButtons(inputFieldsDiv);
updateGaidOptions();
}
});
// Add a new row
$(document).on('click', '.add-field', function () {
const inputFieldsDiv = $(this).prev('.input-fields');
let isValid = true;
// Validate inputs and selects
inputFieldsDiv.find('input, select').each(function () {
if (!$(this).val()) {
$(this).addClass('is-invalid');
isValid = false;
} else {
$(this).removeClass('is-invalid');
}
});
if (isValid) {
const originalRow = inputFieldsDiv.children('.row').first();
// Destroy select2 before cloning
originalRow.find('select').select2('destroy');
// Clone the row
const newRow = originalRow.clone();
// Reinitialize select2 on original row
originalRow.find('select').select2();
// Reset cloned inputs and selects
newRow.find('input').val('').removeClass('is-invalid');
newRow.find('select').val('').removeClass('is-invalid');
newRow.find('.variation-value').empty().append('<option></option>'); // Clear variation values
// Reinitialize select2 on the new row
newRow.find('select').select2();
// Append the cloned row
inputFieldsDiv.append(newRow);
updateRemoveButtons(inputFieldsDiv);
updateGaidOptions();
} else {
Swal.fire({
icon: 'error',
title: 'Error',
text: 'Please fill all required fields before adding a new input.',
});
}
});
// Update the state of remove buttons
function updateRemoveButtons(inputFieldsDiv) {
const rows = inputFieldsDiv.children('.row');
const rowCount = rows.length;
rows.each(function() {
const removeButton = $(this).find('.remove-field');
if (rowCount === 1) {
removeButton.prop('disabled', true).addClass('btn-secondary').removeClass('btn-danger');
inputFieldsDiv.addClass('single-row');
} else {
removeButton.prop('disabled', false).addClass('btn-danger').removeClass('btn-secondary');
inputFieldsDiv.removeClass('single-row');
}
});
}
// Handle .gaid change to populate .variation-value select
// Your existing change handler
$(document).on('change', '.gaid', function() {
populateVariationValues($(this));
updateGaidOptions(); // Prevent duplicates
});
// Extract the variation value population logic into a separate function
function populateVariationValues($gaidSelect) {
let selectedVals = $('option:selected', $gaidSelect).data('vals');
let selectedOption = $('option:selected', $gaidSelect);
let previouslySelectedVals = selectedOption.data('selected-vals') ? selectedOption.data('selected-vals').split(',') : [];
let $row = $gaidSelect.closest('.row');
let $variationValSelect = $row.find('.variation-value');
$variationValSelect.empty().append('<option></option>');
if (selectedVals) {
let valsArray = selectedVals.split(',');
// Show all possible values, but mark previously selected ones as selected
$.each(valsArray, function(i, val) {
let trimmedVal = val.trim();
let isSelected = previouslySelectedVals.includes(trimmedVal);
$variationValSelect.append(
'<option value="' + trimmedVal + '"' +
(isSelected ? ' selected' : '') +
'>' + trimmedVal + '</option>'
);
});
}
$variationValSelect.select2({
placeholder: "Select a value"
});
}
// Your existing function for preventing duplicates
function updateGaidOptions() {
let selectedValues = [];
// Get all selected gaid values
$('.gaid').each(function() {
let val = $(this).val();
if (val) selectedValues.push(val);
});
// Loop through all .gaid selects and update their options
$('.gaid').each(function() {
let currentVal = $(this).val();
$(this).find('option').each(function() {
let optionVal = $(this).val();
if (optionVal === '') return; // Skip the placeholder
if (optionVal !== currentVal && selectedValues.includes(optionVal)) {
$(this).prop('disabled', true);
} else {
$(this).prop('disabled', false);
}
});
// Refresh Select2
$(this).select2();
});
}
// Initialize on document ready
$(document).ready(function() {
// Initialize all .gaid elements with default values
$('.gaid').each(function() {
if ($(this).val()) {
// Populate variation values for preselected values
populateVariationValues($(this));
}
});
// Initialize the duplicate prevention
updateGaidOptions();
});
$('.input-fields').each(function() {
updateRemoveButtons($(this));
});
});
$('#btn-submit').on('click', function (e) {
e.preventDefault();
const gname = $('#variation').val().trim(); // Group Name
if (!gname) {
Swal.fire({
icon: 'warning',
title: 'Required',
text: 'Please enter a group name.',
});
return;
}
const formData = new FormData();
formData.append('gname', gname);
// Collect all GAIDs
$('input[name="gaid[]"]').each(function() {
formData.append('gaid[]', $(this).val());
});
let isValid = true;
let attributeCount = 0;
$('.input-fields .row').each(function(index) {
const aid = $(this).find('.gaid').val();
const avalueArr = $(this).find('.variation-value').val();
if (aid && avalueArr && avalueArr.length > 0) {
formData.append('aid[]', aid);
formData.append('avalue[]', avalueArr.join(','));
attributeCount++;
} else {
isValid = false;
}
});
if (!isValid || attributeCount === 0) {
Swal.fire({
icon: 'error',
title: 'Incomplete',
text: 'Please fill all attribute fields properly before submitting.',
});
return;
}
// Debug - Log form data before sending (can be removed in production)
console.log("Form data being sent:");
for (let pair of formData.entries()) {
console.log(pair[0] + ': ' + pair[1]);
}
$('#btn-submit .indicator-label').hide();
$('#btn-submit .indicator-progress').show();
$.ajax({
url: 'ajax_group_attr_update.php',
type: 'POST',
data: formData,
contentType: false,
processData: false,
dataType: 'json',
success: function (response) {
if (response.status === 'success') {
Swal.fire({
icon: 'success',
title: 'Saved!',
text: 'Attributes group updated successfully.',
timer: 1500,
showConfirmButton: false
}).then(() => {
window.location.href = 'group-attributes.php';
});
} else {
Swal.fire({
icon: 'error',
title: 'Error',
text: response.message || 'Something went wrong while updating the data.'
});
}
$('#btn-submit .indicator-label').show();
$('#btn-submit .indicator-progress').hide();
},
error: function (xhr, status, error) {
console.error("AJAX Error:", xhr.responseText);
Swal.fire({
icon: 'error',
title: 'Error',
text: 'Something went wrong while updating the data. Check console for details.'
});
$('#btn-submit .indicator-label').show();
$('#btn-submit .indicator-progress').hide();
}
});
});
</script>
</body>
</html>