1#@!#!123s

32759 1#@!#!123s
: / home / aissorg / public_html / admin /
Filename : add-pooja.php
back
<?php
include('include/config.php');

// Initialize Alert Variables
$alert = '';
$alert_class = '';

// Handle POST requests
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title = mysqli_real_escape_string($con, $_POST['title']);
    $type = mysqli_real_escape_string($con, $_POST['type']);
    $date = mysqli_real_escape_string($con, $_POST['date']);
    $time = mysqli_real_escape_string($con, $_POST['time']);
    $description = mysqli_real_escape_string($con, $_POST['description']);
    $amount = mysqli_real_escape_string($con, $_POST['amount']);
    $dharshan_entry = mysqli_real_escape_string($con, $_POST['dharshan_entry']);
    $prashadham = mysqli_real_escape_string($con, $_POST['prashadham']);

    // Insert New Data
    if (isset($_POST['action']) && $_POST['action'] === 'insert') {
        $is_active = 1;
        $sql = "INSERT INTO upcoming_pooja (title, type, date, time, description, is_active, amount, dharshan_entry, prashadham) 
                VALUES ('$title', '$type', '$date', '$time', '$description', $is_active, '$amount', '$dharshan_entry', '$prashadham')";
        if (mysqli_query($con, $sql)) {
            header("Location: ".$_SERVER['PHP_SELF']."?msg=insert_success");
            exit;
        } else {
            $alert = 'Error: ' . mysqli_error($con);
            $alert_class = 'alert-danger';
        }
    }

    // Update Existing Data
    if (isset($_POST['action']) && $_POST['action'] === 'update') {
        $id = mysqli_real_escape_string($con, $_POST['id']);
        $is_active = isset($_POST['is_active']) ? 1 : 1;

        $sql = "UPDATE upcoming_pooja 
                SET title = '$title', type = '$type', date = '$date', time = '$time',
                    description = '$description', is_active = $is_active,
                    amount = '$amount', dharshan_entry = '$dharshan_entry', prashadham = '$prashadham'
                WHERE id = $id";
        if (mysqli_query($con, $sql)) {
            header("Location: ".$_SERVER['PHP_SELF']."?msg=update_success");
            exit;
        } else {
            $alert = 'Error: ' . mysqli_error($con);
            $alert_class = 'alert-danger';
        }
    }

    // Delete Data
    if (isset($_POST['action']) && $_POST['action'] === 'delete') {
        $id = mysqli_real_escape_string($con, $_POST['id']);
        $sql = "DELETE FROM upcoming_pooja WHERE id = $id";
        if (mysqli_query($con, $sql)) {
            header("Location: ".$_SERVER['PHP_SELF']."?msg=delete_success");
            exit;
        } else {
            $alert = 'Error: ' . mysqli_error($con);
            $alert_class = 'alert-danger';
        }
    }
}

// Show success message after redirect
if (isset($_GET['msg'])) {
    switch ($_GET['msg']) {
        case 'insert_success':
            $alert = 'Data added successfully.';
            $alert_class = 'alert-success';
            break;
        case 'update_success':
            $alert = 'Data updated successfully.';
            $alert_class = 'alert-success';
            break;
        case 'delete_success':
            $alert = 'Data deleted successfully.';
            $alert_class = 'alert-success';
            break;
    }
}

// Fetch All Categories
function fetchCategories($con) {
    $sql = "SELECT * FROM upcoming_pooja";
    $result = mysqli_query($con, $sql);
    $categories = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $categories[] = $row;
    }
    return $categories;
}
?>

<!DOCTYPE html>
<html lang="en" data-layout="vertical" data-topbar="light" data-sidebar="light" data-sidebar-size="lg" data-sidebar-image="none">
<head>
       <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Add Upcoming Pooja</title>
    <!-- Favicon -->
    <link rel="shortcut icon" type="image/x-icon" href="">
    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <!-- Fontawesome CSS -->
    <link rel="stylesheet" href="assets/plugins/fontawesome/css/fontawesome.min.css">
    <link rel="stylesheet" href="assets/plugins/fontawesome/css/all.min.css">
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Arimo:ital,wght@0,400..700;1,400..700&display=swap" rel="stylesheet">
    <!-- Feather CSS -->
    <link rel="stylesheet" href="assets/plugins/feather/feather.css">
    <!-- Datepicker CSS -->
    <link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css">
    <!-- Daterangepikcer CSS -->
    <link rel="stylesheet" href="assets/plugins/daterangepicker/daterangepicker.css">
    <!-- Datatables CSS -->
    <link rel="stylesheet" href="assets/plugins/datatables/datatables.min.css">
    <!-- Main CSS -->
    <link rel="stylesheet" href="assets/css/style.css">
    <!-- Layout Js -->
    <script src="assets/js/layout.js" type="text/javascript"></script>
</head>
<body>
    <div class="main-wrapper">
        <?php include("include/header.php")?>
        <?php include("include/sidebar.php")?>
        <div class="page-wrapper">
            <div class="content container-fluid">
                <!-- Page Header -->
                <div class="page-header">
                    <div class="content-page-header">
                        <h5>Upcoming Pooja List</h5>
                        <div class="list-btn">
                            <ul class="filter-list">
                                <li>
                                    <a class="btn btn-primary" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#add_Pooja">
                                        <i class="fa fa-plus-circle me" aria-hidden="true"></i> Add Upcoming Pooja
                                    </a>
                                </li>
                            </ul>
                        </div>
                    </div>
                </div>

                <!-- Dynamic Alert -->
                <?php if (!empty($alert)): ?>
                <div class="alert <?= $alert_class ?> alert-dismissible fade show" role="alert">
                    <strong><?= ($alert_class === 'alert-success') ? 'Success!' : 'Error!' ?></strong> <?= $alert ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                </div>
                <?php endif; ?>

                <!-- Table -->
                <div class="row">
                    <div class="col-sm-12">
                        <div class="card-table">
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-stripped table-hover datatable">
                                        <thead class="thead-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Title</th>
                                                <th>Type</th>
                                                <th>Date</th>
                                                <th>Time</th>
                                                <th>Description</th>
                                                <th>Amount</th>
                                                <th>Dharshan Entry</th>
                                                <th>Prashadham</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $categories = fetchCategories($con);
                                            foreach ($categories as $category) {
                                                echo "<tr>";
                                                echo "<td>" . $category['id'] . "</td>";
                                                echo "<td>" . htmlspecialchars($category['title']) . "</td>";
                                                echo "<td>" . htmlspecialchars($category['type']) . "</td>";
                                                echo "<td>" . htmlspecialchars($category['date']) . "</td>";
                                                echo "<td>" . htmlspecialchars($category['time']) . "</td>";
                                                echo "<td>" . htmlspecialchars($category['description']) . "</td>";
                                                echo "<td>" . (!empty($category['amount']) ? number_format($category['amount'], 2) : '-') . "</td>";
                                                echo "<td>" . htmlspecialchars($category['dharshan_entry'] ?? '-') . "</td>";
                                                echo "<td>" . htmlspecialchars($category['prashadham'] ?? '-') . "</td>";
                                                echo '<td class="d-flex align-items-center">';
                                                echo '<a class="btn-action-icon me-2" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#edit_' . $category['id'] . '"><i class="fe fe-edit"></i></a>';
                                                echo '<a class="btn-action-icon me-2" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#delete_modal_' . $category['id'] . '"><i class="fe fe-trash"></i></a>';
                                                echo '</td>';
                                                echo "</tr>";

                                                // Edit Modal
                                                echo '<div class="modal custom-modal fade" id="edit_' . $category['id'] . '" role="dialog">';
                                                echo '<div class="modal-dialog modal-dialog-centered modal-lg">';
                                                echo '<div class="modal-content">';
                                                echo '<div class="modal-header border-0 pb-0">';
                                                echo '<div class="form-header modal-header-title text-start mb-0">';
                                                echo '<h4 class="mb-0">Edit Pooja Category</h4>';
                                                echo '</div>';
                                                echo '<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>';
                                                echo '</div>';
                                                echo '<form method="POST" action="">';
                                                echo '<input type="hidden" name="action" value="update">';
                                                echo '<input type="hidden" name="id" value="' . $category['id'] . '">';
                                                echo '<div class="modal-body">';
                                                echo '<div class="row">';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Title</label><input type="text" class="form-control" name="title" value="' . htmlspecialchars($category['title']) . '" required></div></div>';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Type</label><input type="text" class="form-control" name="type" value="' . htmlspecialchars($category['type']) . '"></div></div>';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Date</label><input type="date" class="form-control" name="date" value="' . htmlspecialchars($category['date']) . '"></div></div>';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Time</label><input type="text" class="form-control" name="time" value="' . htmlspecialchars($category['time']) . '"></div></div>';
                                                echo '<div class="col-lg-6 col-md-12"><div class="input-block mb-3"><label>Description</label><textarea class="form-control" name="description">' . htmlspecialchars($category['description']) . '</textarea></div></div>';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Amount</label><input type="number" step="0.01" class="form-control" name="amount" value="' . (!empty($category['amount']) ? number_format($category['amount'], 2) : '') . '"></div></div>';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Dharshan Entry</label><input type="text" class="form-control" name="dharshan_entry" value="' . htmlspecialchars($category['dharshan_entry'] ?? '') . '"></div></div>';
                                                echo '<div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Prashadham</label><input type="text" class="form-control" name="prashadham" value="' . htmlspecialchars($category['prashadham'] ?? '') . '"></div></div>';
                                                echo '</div></div>';
                                                echo '<div class="modal-footer">';
                                                echo '<button type="button" data-bs-dismiss="modal" class="btn btn-back cancel-btn me-2">Cancel</button>';
                                                echo '<button type="submit" class="btn btn-primary paid-continue-btn">Update</button>';
                                                echo '</div>';
                                                echo '</form></div></div></div>';

                                                // Delete Modal
                                                echo '<div class="modal custom-modal fade" id="delete_modal_' . $category['id'] . '" role="dialog">';
                                                echo '<div class="modal-dialog modal-dialog-centered modal-md">';
                                                echo '<div class="modal-content">';
                                                echo '<div class="modal-body">';
                                                echo '<div class="form-header"><h3>Delete Pooja</h3><p>Are you sure you want to delete this item?</p></div>';
                                                echo '<div class="modal-btn delete-action">';
                                                echo '<div class="row">';
                                                echo '<div class="col-6"><form method="POST" action=""><input type="hidden" name="action" value="delete"><input type="hidden" name="id" value="' . $category['id'] . '"><button type="submit" class="w-100 btn btn-primary paid-continue-btn">Delete</button></form></div>';
                                                echo '<div class="col-6"><button type="button" data-bs-dismiss="modal" class="w-100 btn btn-primary paid-cancel-btn">Cancel</button></div>';
                                                echo '</div></div></div></div></div></div>';
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <!-- Add Pooja Modal -->
                <div class="modal custom-modal fade" id="add_Pooja" role="dialog">
                    <div class="modal-dialog modal-dialog-centered modal-lg">
                        <div class="modal-content">
                            <div class="modal-header border-0 pb-0">
                                <div class="form-header modal-header-title text-start mb-0">
                                    <h4 class="mb-0">Add Upcoming Pooja</h4>
                                </div>
                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                            </div>
                            <form method="POST" action="">
                                <input type="hidden" name="action" value="insert">
                                <div class="modal-body">
                                    <div class="row">
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Title</label><input type="text" class="form-control" name="title" placeholder="Enter Title" required></div></div>
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Type</label><input type="text" class="form-control" name="type" placeholder="Enter Type"></div></div>
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Date</label><input type="date" class="form-control" name="date" placeholder="Enter Date"></div></div>
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Time</label><input type="text" class="form-control" name="time" placeholder="Enter Time"></div></div>
                                        <div class="col-lg-6 col-md-12"><div class="input-block mb-3"><label>Description</label><textarea class="form-control" name="description" placeholder="Enter Description"></textarea></div></div>
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Amount</label><input type="number" step="0.01" class="form-control" name="amount" placeholder="Enter Amount"></div></div>
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Dharshan Entry</label><input type="text" class="form-control" name="dharshan_entry" placeholder="Dharshan Entry Type"></div></div>
                                        <div class="col-lg-4 col-md-12"><div class="input-block mb-3"><label>Prashadham</label><input type="text" class="form-control" name="prashadham" placeholder="Enter Prashadham Name"></div></div>
                                    </div>
                                </div>
                                <div class="modal-footer">
                                    <button type="button" data-bs-dismiss="modal" class="btn btn-back cancel-btn me-2">Cancel</button>
                                    <button type="submit" class="btn btn-primary paid-continue-btn">Save</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
<!-- /Main Wrapper -->
    <!-- jQuery -->
    <script data-cfasync="false" src="../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>
    <script src="assets/js/jquery-3.7.1.min.js" type="text/javascript"></script>
    <!-- Bootstrap Core JS -->
    <script src="assets/js/bootstrap.bundle.min.js" type="text/javascript"></script>
    <!-- Datatable JS -->
    <script src="assets/plugins/datatables/datatables.min.js" type="text/javascript"></script>
    <!-- select CSS -->
    <script src="assets/plugins/select2/js/select2.min.js" type="text/javascript"></script>
    <!-- Slimscroll JS -->
    <script src="assets/plugins/slimscroll/jquery.slimscroll.min.js" type="text/javascript"></script>
    <!-- Datepicker Core JS -->
    <script src="assets/plugins/moment/moment.min.js" type="text/javascript"></script>
    <script src="assets/js/bootstrap-datetimepicker.min.js" type="text/javascript"></script>
    <script src="assets/plugins/daterangepicker/daterangepicker.js" type="text/javascript"></script>
    <!-- multiselect JS -->
    <script src="assets/js/jquery-ui.min.js" type="text/javascript"></script>
    <!-- Theme Settings JS -->
    <script src="assets/js/theme-settings.js" type="text/javascript"></script>
    <script src="assets/js/greedynav.js" type="text/javascript"></script>
    <!-- Custom JS -->
    <script src="assets/js/script.js" type="text/javascript"></script>
    <script src="../../cdn-cgi/scripts/7d0fa10a/cloudflare-static/rocket-loader.min.js" data-cf-settings="|49" defer></script>
    <!-- Scripts remain unchanged -->
</body>
</html>