ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/policy.php |
<?php include "common/header.php" ?>
<?php
include 'connection/config.php';
// ---------- CREATE / UPDATE ----------
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_policy'])) {
$policyName = trim($_POST['policy_name']);
$description = trim($_POST['description']);
if (!empty($policyName) && !empty($description)) {
try {
if (!empty($_POST['id'])) {
// ---------- UPDATE ----------
$stmt = $pdo->prepare("UPDATE policy SET policy_name = :policy_name, policy_description = :policy_description WHERE id = :id");
$stmt->execute([
'policy_name' => $policyName,
'policy_description' => $description,
'id' => $_POST['id']
]);
echo "<script>
localStorage.setItem('swal_message', 'updated');
window.location.href='policy.php';
</script>";
exit;
} else {
// ---------- INSERT ----------
$stmt = $pdo->prepare("INSERT INTO policy (policy_name, policy_description) VALUES (:policy_name, :policy_description)");
$stmt->execute([
'policy_name' => $policyName,
'policy_description' => $description
]);
echo "<script>
localStorage.setItem('swal_message', 'added');
window.location.href='policy.php';
</script>";
exit;
}
} catch (PDOException $e) {
if ($e->getCode() == 23000) {
echo "<script>
localStorage.setItem('swal_message', 'exists');
window.location.href='policy.php';
</script>";
exit;
} else {
echo "<script>
localStorage.setItem('swal_message', 'error');
window.location.href='policy.php';
</script>";
exit;
}
}
} else {
echo "<script>
localStorage.setItem('swal_message', 'empty');
window.location.href='policy.php';
</script>";
exit;
}
}
// ---------- DELETE ----------
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
$pdo->prepare("DELETE FROM policy WHERE id = :id")->execute(['id' => $id]);
echo "<script>
localStorage.setItem('swal_message', 'deleted');
window.location.href='policy.php';
</script>";
exit;
}
// ---------- EDIT ----------
$editPolicy = null;
if (isset($_GET['edit'])) {
$id = (int) $_GET['edit'];
$stmt = $pdo->prepare("SELECT * FROM policy WHERE id = :id");
$stmt->execute(['id' => $id]);
$editPolicy = $stmt->fetch();
}
// ---------- READ (List) ----------
$policies = $pdo->query("SELECT * FROM policy ORDER BY id ASC")->fetchAll();
?>
<!-- ==================================================== -->
<div class="page-content">
<div class="container-xxl">
<form method="POST" action="">
<div class="row">
<div class="col-xl-12 col-lg-12">
<div class="card">
<div class="card-header">
<h4 class="card-title"><?= $editPolicy ? "Edit Policy" : "General Information" ?></h4>
</div>
<div class="card-body">
<div class="row">
<input type="hidden" name="id" value="<?= $editPolicy['id'] ?? '' ?>">
<!-- Column 1: Policy Name -->
<div class="col-lg-6">
<div class="mb-3">
<label for="policy_name" class="form-label">Policy Name</label>
<input type="text" id="policy_name" class="form-control"
name="policy_name" placeholder="Enter Policy Name" required
value="<?= htmlspecialchars($editPolicy['policy_name'] ?? '') ?>">
</div>
</div>
<!-- Column 2: Policy Description -->
<div class="col-lg-12">
<div class="mb-3">
<label for="blog_description" class="form-label">Description</label>
<textarea class="form-control bg-light-subtle" id="blog_description" name="description" rows="3" placeholder="Enter Description"><?= $editPolicy ? html_entity_decode($editPolicy['policy_description']) : '' ?></textarea>
<script src="ckeditor/ckeditor.js"></script>
<script>CKEDITOR.replace('blog_description', { height: '300', width: 'auto' });</script>
</div>
</div>
</div>
<!-- Buttons row -->
<div class="row mt-3">
<div class="col-lg-12">
<button type="submit" name="save_policy" class="btn btn-primary">
<?= $editPolicy ? "Update Policy" : "Save Policy" ?>
</button>
<a href="policy.php" class="btn btn-secondary">Back to List</a>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<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 Policies 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>Policy Name</th>
<th>Description</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php if ($policies): ?>
<?php foreach ($policies as $row): ?>
<tr>
<td><?= htmlspecialchars($row['id']) ?></td>
<td><?= htmlspecialchars($row['policy_name']) ?></td>
<td><?= html_entity_decode($row['policy_description']) ?></td>
<td>
<div class="d-flex gap-2">
<a href="policy.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="policy.php?delete=<?= $row['id'] ?>"
onclick="return confirm('Are you sure you want to delete this policy?');"
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="4" class="text-center">No policies 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!", "Policy added successfully!", "success");
} else if (swalMsg === "updated") {
Swal.fire("Success!", "Policy updated successfully!", "success");
} else if (swalMsg === "deleted") {
Swal.fire("Deleted!", "Policy deleted successfully!", "success");
} else if (swalMsg === "exists") {
Swal.fire("Warning!", "This policy 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");
}
});
</script>
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........