ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/product_main_categories.php |
<?php include "common/header.php" ?>
<?php
include 'connection/config.php';
// Fetch dropdown data
$productCategories = $pdo->query("SELECT * FROM product_categories ORDER BY name ASC")->fetchAll();
$productGenders = $pdo->query("SELECT * FROM products_gender ORDER BY gender_name ASC")->fetchAll();
// ---------- CREATE / UPDATE ----------
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_category'])) {
$name = trim($_POST['name']);
$categoryId = $_POST['category_id'] ?? null;
$genderId = $_POST['gender_id'] ?? null;
$imagePath = $editCategory['image'] ?? ''; // default for update
// Handle image upload
if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {
$uploadDir = '../uploads/maincategories/'; // Server path for saving file
if (!is_dir($uploadDir)) mkdir($uploadDir, 0755, true);
$fileName = time() . '_' . basename($_FILES['image']['name']);
$targetFile = $uploadDir . $fileName;
if (move_uploaded_file($_FILES['image']['tmp_name'], $targetFile)) {
// Store relative path in database for UI use
$imagePath = 'uploads/maincategories/' . $fileName;
}
}
if (!empty($name) && !empty($categoryId) && !empty($genderId)) {
try {
if (!empty($_POST['id'])) {
// ---------- UPDATE ----------
$stmt = $pdo->prepare("UPDATE main_categories SET name = :name, category_id = :category_id, gender_id = :gender_id, image = :image WHERE id = :id");
$stmt->execute([
'name' => $name,
'category_id' => $categoryId,
'gender_id' => $genderId,
'image' => $imagePath,
'id' => $_POST['id']
]);
echo "<script>
localStorage.setItem('swal_message', 'updated');
window.location.href='product_main_categories.php';
</script>";
exit;
} else {
// ---------- INSERT ----------
$stmt = $pdo->prepare("INSERT INTO main_categories (name, category_id, gender_id, image) VALUES (:name, :category_id, :gender_id, :image)");
$stmt->execute([
'name' => $name,
'category_id' => $categoryId,
'gender_id' => $genderId,
'image' => $imagePath
]);
echo "<script>
localStorage.setItem('swal_message', 'added');
window.location.href='product_main_categories.php';
</script>";
exit;
}
} catch (PDOException $e) {
if ($e->getCode() == 23000) {
echo "<script>
localStorage.setItem('swal_message', 'exists');
window.location.href='product_main_categories.php';
</script>";
exit;
} else {
echo "<script>
localStorage.setItem('swal_message', 'error');
window.location.href='product_main_categories.php';
</script>";
exit;
}
}
} else {
echo "<script>
localStorage.setItem('swal_message', 'empty');
window.location.href='product_main_categories.php';
</script>";
exit;
}
}
// ---------- DELETE ----------
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
$pdo->prepare("DELETE FROM main_categories WHERE id = :id")->execute(['id' => $id]);
echo "<script>
localStorage.setItem('swal_message', 'deleted');
window.location.href='product_main_categories.php';
</script>";
exit;
}
// ---------- EDIT ----------
$editCategory = null;
if (isset($_GET['edit'])) {
$id = (int) $_GET['edit'];
$stmt = $pdo->prepare("SELECT * FROM main_categories WHERE id = :id");
$stmt->execute(['id' => $id]);
$editCategory = $stmt->fetch();
}
// ---------- READ (List) ----------
$stmt = $pdo->query("SELECT mc.*, pc.name AS category_name, pg.gender_name
FROM main_categories mc
JOIN product_categories pc ON mc.category_id = pc.id
JOIN products_gender pg ON mc.gender_id = pg.id
ORDER BY mc.id ASC");
$categories = $stmt->fetchAll();
?>
<div class="page-content">
<div class="container-xxl">
<form method="POST" action="" enctype="multipart/form-data">
<div class="row">
<div class="col-xl-12 col-lg-12">
<div class="card">
<div class="card-header">
<h4 class="card-title"><?= $editCategory ? "Edit Category" : "General Information" ?></h4>
</div>
<div class="card-body">
<div class="row">
<input type="hidden" name="id" value="<?= $editCategory['id'] ?? '' ?>">
<!-- Image Input & Preview -->
<div class="col-lg-6">
<div class="mb-3">
<label class="form-label">Image</label>
<input type="file" name="image" id="imageInput" class="form-control" accept="image/*">
<div class="mt-2">
<img id="imagePreview" src="../<?= isset($editCategory['image']) ? htmlspecialchars($editCategory['image']) : '' ?>"
alt="Preview" style="max-width:150px; border-radius:8px; margin-top:10px; <?= isset($editCategory['image']) ? '' : 'display:none;' ?>">
</div>
</div>
</div>
<!-- Main Category Title -->
<div class="col-lg-6">
<div class="mb-3">
<label for="category-title" class="form-label">Main Category Title</label>
<input type="text" id="category-title" class="form-control"
name="name" placeholder="Enter Title" required
value="<?= htmlspecialchars($editCategory['name'] ?? '') ?>">
</div>
</div>
<!-- Product Category -->
<div class="col-lg-6">
<div class="mb-3">
<label for="category_id" class="form-label">Product Category</label>
<select class="form-control" name="category_id" id="category_id" required>
<option value="">Select Product Category</option>
<?php foreach ($productCategories as $pc): ?>
<option value="<?= $pc['id'] ?>" <?= ($editCategory && $editCategory['category_id'] == $pc['id']) ? 'selected' : '' ?>>
<?= htmlspecialchars($pc['name']) ?>
</option>
<?php endforeach; ?>
</select>
</div>
</div>
<!-- Product Gender -->
<div class="col-lg-6">
<div class="mb-3">
<label for="gender_id" class="form-label">Product Gender</label>
<select class="form-control" name="gender_id" id="gender_id" required>
<option value="">Select Gender</option>
<?php foreach ($productGenders as $pg): ?>
<option value="<?= $pg['id'] ?>" <?= ($editCategory && $editCategory['gender_id'] == $pg['id']) ? 'selected' : '' ?>>
<?= htmlspecialchars($pg['gender_name']) ?>
</option>
<?php endforeach; ?>
</select>
</div>
</div>
</div>
<!-- Buttons -->
<div class="row mt-3">
<div class="col-lg-12">
<button type="submit" name="save_category" class="btn btn-primary">
<?= $editCategory ? "Update Category" : "Save Category" ?>
</button>
<a href="product_category.php" class="btn btn-secondary">Back to List</a>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<!-- Categories List -->
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-header d-flex justify-content-between align-items-center gap-1">
<h4 class="card-title flex-grow-1">All Categories List</h4>
</div>
<div>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>ID</th>
<th>Main Category</th>
<th>Image</th>
<th>Product Category</th>
<th>Gender</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php if ($categories): ?>
<?php foreach ($categories as $row): ?>
<tr>
<td><?= htmlspecialchars($row['id']) ?></td>
<td><?= htmlspecialchars($row['name']) ?></td>
<td>
<?php if($row['image']): ?>
<img src="../<?= htmlspecialchars($row['image']) ?>" style="max-width:80px; border-radius:4px;">
<?php endif; ?>
</td>
<td><?= htmlspecialchars($row['category_name']) ?></td>
<td><?= htmlspecialchars($row['gender_name']) ?></td>
<td>
<div class="d-flex gap-2">
<a href="product_main_categories.php?edit=<?= $row['id'] ?>" class="btn btn-soft-primary btn-sm">
<iconify-icon icon="solar:pen-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
<a href="product_main_categories.php?delete=<?= $row['id'] ?>"
onclick="return confirm('Are you sure you want to delete this category?');"
class="btn btn-soft-danger btn-sm">
<iconify-icon icon="solar:trash-bin-minimalistic-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
</div>
</td>
</tr>
<?php endforeach; ?>
<?php else: ?>
<tr>
<td colspan="6" class="text-center">No categories found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "common/footer.php" ?>
</div>
<!-- SweetAlert -->
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
document.addEventListener("DOMContentLoaded", function() {
const swalMsg = localStorage.getItem("swal_message");
if (swalMsg) {
if (swalMsg === "added") {
Swal.fire("Success!", "Category added successfully!", "success");
} else if (swalMsg === "updated") {
Swal.fire("Success!", "Category updated successfully!", "success");
} else if (swalMsg === "deleted") {
Swal.fire("Deleted!", "Category deleted successfully!", "success");
} else if (swalMsg === "exists") {
Swal.fire("Warning!", "This category already exists.", "warning");
} else if (swalMsg === "empty") {
Swal.fire("Oops!", "Please fill all fields.", "warning");
} else if (swalMsg === "error") {
Swal.fire("Error!", "Something went wrong.", "error");
}
localStorage.removeItem("swal_message");
}
// Image preview
const imageInput = document.getElementById('imageInput');
const imagePreview = document.getElementById('imagePreview');
imageInput.addEventListener('change', function(event) {
const file = event.target.files[0];
if (file) {
const reader = new FileReader();
reader.onload = function(e) {
imagePreview.src = e.target.result;
imagePreview.style.display = 'block';
}
reader.readAsDataURL(file);
} else {
imagePreview.src = '';
imagePreview.style.display = 'none';
}
});
});
</script>
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........