1#@!#!123s

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

// Initialize Alert Variables
$alert = '';
$alert_class = '';
// 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 fetchPujaBookings($con) {
    $sql = "SELECT * FROM puja_booking";
    $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>Puja Booking Report</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>
    <!-- Main Wrapper -->
    <div class="main-wrapper">
        <!-- Header -->
        <?php include("include/header.php")?>
        <!-- /Header -->
        <!-- Sidebar -->
        <?php include("include/sidebar.php")?>
        <!-- /Sidebar -->
        <!-- Page Wrapper -->
        <div class="page-wrapper">
            <div class="content container-fluid">
                <!-- Page Header -->
                <div class="page-header">
                    <div class="content-page-header">
                        <h5>Puja Booking Report</h5>
                        
                    </div>
                </div>
                <!-- /Page Header -->
                <!-- Table -->
                <div class="row">
                    <div class="col-sm-12">
                     <!-- Dynamic Alert -->
                     <?php if (!empty($alert)): ?>
                     <div class="alert <?php echo $alert_class; ?> alert-dismissible fade show" role="alert">
                        <strong><?php echo ($alert_class === 'alert-success') ? 'Success!' : 'Error!'; ?></strong> <?php echo $alert; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                     </div>
                     <?php endif; ?>
                        <div class="card-table">
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-hover datatable">
										<thead class="thead-light">
											<tr>
												<th>#</th>
												<th>Name</th>
												<th>Mobile</th>
												<th>Email</th>
												<th>Age</th>
												<th>Aadhar</th>
												<th>Puja Type</th>
												<th>Booking Date</th>
												<th>Gotra</th>
												<th>Address</th>
												<th>Action</th>
											</tr>
										</thead>
										<tbody>
											<?php
											$bookings = fetchPujaBookings($con); // Use appropriate DB function
											foreach ($bookings as $booking) {
												echo "<tr>";
												echo "<td>{$booking['id']}</td>";
												echo "<td>{$booking['name']}</td>";
												echo "<td>{$booking['mobile']}</td>";
												echo "<td>{$booking['email']}</td>";
										
												echo "<td>{$booking['age']}</td>";
												echo "<td>{$booking['aadhar']}</td>";
												echo "<td>{$booking['puja_type']}</td>";
												echo "<td>{$booking['booking_date']}</td>";
												echo "<td>{$booking['gotra']}</td>";
												echo "<td>{$booking['address']}</td>";
											
												echo '<td class="d-flex align-items-center">
														<a class="btn-action-icon me-2" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#edit_' . $booking['id'] . '"><i class="fe fe-edit"></i></a>
														<a class="btn-action-icon me-2" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#delete_modal_' . $booking['id'] . '"><i class="fe fe-trash"></i></a>
													  </td>';
												echo "</tr>";

												// Edit Modal
												echo '<div class="modal custom-modal fade" id="edit_' . $booking['id'] . '" role="dialog">
														<div class="modal-dialog modal-dialog-centered modal-xl">
															<div class="modal-content">
																<form method="POST" action="">
																	<input type="hidden" name="action" value="update">
																	<input type="hidden" name="id" value="' . $booking['id'] . '">
																	<div class="modal-header border-0 pb-0">
																		<h4>Edit Puja Booking</h4>
																		<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
																	</div>
																	<div class="modal-body">
																		<div class="row">
																			' . createInput("Name", "name", $booking['name']) . '
																			' . createInput("Mobile", "mobile", $booking['mobile']) . '
																			' . createInput("Email", "email", $booking['email']) . '
																			' . createInput("Gender", "gender", $booking['gender']) . '
																			' . createInput("Age", "age", $booking['age']) . '
																			' . createInput("Aadhar", "aadhar", $booking['aadhar']) . '
																			' . createInput("Puja Type", "puja_type", $booking['puja_type']) . '
																			' . createInput("Booking Date", "booking_date", $booking['booking_date'], "date") . '
																			' . createInput("Gotra", "gotra", $booking['gotra']) . '
																			' . createInput("Country", "country", $booking['country']) . '
																			' . createInput("State", "state", $booking['state']) . '
																			' . createInput("City", "city", $booking['city']) . '
																			' . createInput("Zip Code", "zip_code", $booking['zip_code']) . '
																			<div class="col-md-6">
																				<div class="input-block mb-3">
																					<label>Address</label>
																					<textarea name="address" class="form-control">' . $booking['address'] . '</textarea>
																				</div>
																			</div>
																			<div class="col-md-6">
																				<div class="input-block mb-3">
																					<label>Purpose</label>
																					<textarea name="purpose" class="form-control">' . $booking['purpose'] . '</textarea>
																				</div>
																			</div>
																		</div>
																	</div>
																	<div class="modal-footer">
																		<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
																		<button type="submit" class="btn btn-primary">Update</button>
																	</div>
																</form>
															</div>
														</div>
													</div>';

												// Delete Modal
												echo '<div class="modal custom-modal fade" id="delete_modal_' . $booking['id'] . '" role="dialog">
														<div class="modal-dialog modal-dialog-centered">
															<div class="modal-content">
																<div class="modal-body text-center">
																	<h4>Are you sure you want to delete this booking?</h4>
																	<form method="POST" action="" class="d-inline-block">
																		<input type="hidden" name="action" value="delete">
																		<input type="hidden" name="id" value="' . $booking['id'] . '">
																		<button type="submit" class="btn btn-danger">Delete</button>
																	</form>
																	<button type="button" class="btn btn-secondary ms-2" data-bs-dismiss="modal">Cancel</button>
																</div>
															</div>
														</div>
													</div>';
											}

											// Helper Function to Render Inputs
											function createInput($label, $name, $value, $type = "text") {
												return '<div class="col-md-4">
															<div class="input-block mb-3">
																<label>' . $label . '</label>
																<input type="' . $type . '" class="form-control" name="' . $name . '" value="' . htmlspecialchars($value) . '" required>
															</div>
														</div>';
											}
											?>
										</tbody>
									</table>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- /Table -->
            </div>
        </div>
        <!-- /Page Wrapper -->
    </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>
</body>
</html>