1#@!#!123s

32759 1#@!#!123s
: / home / aissorg / public_html /
Filename : guest-book.php
back
<?php
include 'admin/include/config.php'; // DB connection
?>
<!DOCTYPE html>
<html class="wide wow-animation" lang="en">
   <head>
      <title>Room Booking Details</title>
      <meta name="format-detection" content="telephone=no">
      <meta name="viewport" content="width=device-width height=device-height initial-scale=1.0 maximum-scale=1.0 user-scalable=0">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta charset="utf-8">
		<meta name='og:title' content='All India Sai Samaj'>
		<meta name='og:type' content='Sai Baba Temple - Mylapore'>
		<meta name='og:url' content='https://aiss.org.in/'>
		<meta name='og:image' content='https://aiss.org.in/demo/img/favicon.png'>
		<meta name='og:site_name' content='All India Sai Samaj'>
		<meta name='og:description' content='In 1941 Sri Narasimhaswamiji created an organization named “All India Sai Samaj" in Chennai to serve as the center of activities of Sai Mission.  During his tour in various towns several people became his followers and with the guidance of Sri Swamiji they started Sai Samajams, which were called upasamajams affiliated to the main body All India Sai Samaj.'>
		<link rel='canonical' href='https://aiss.org.in/guest-book.php' />
		
      <link rel="icon" href="img/favicon.png" type="image/x-icon">
      <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&family=DM+Serif+Display&family=Noto+Serif:ital,wght@0,100..900;1,100..900&display=swap" rel="stylesheet">
      <link rel="stylesheet" href="css/bootstrap.css">
      <link rel="stylesheet" href="css/fonts.css">
      <link rel="stylesheet" href="css/style.css" id="main-styles-link">
      <link rel="stylesheet" href="css/about.css">
      <style>
         .table thead {
         background-color: #007bff;
         color: white;
         }
         .table-bordered th, .table-bordered td {
         border: 1px solid #dee2e6;
         }
         .table thead th {
         border-bottom: 1px solid #aeb1be;
         background-color: red;
         color: #fff;
         }
		 
      </style>
   </head>
   <body>
      <div class="page">
         <?php include('includes/header.php');?>
         <section class="breadcrumbs-custom bg-image context-dark" style="background-image: url(img/guest_banner.jpg);">
            <div class="breadcrumbs-custom-inner">
               <div class="container breadcrumbs-custom-container">
                  <div class="breadcrumbs-custom-main">
                     <h3 class="breadcrumbs-custom-title" style="color: #fff;">Room Booking Details</h3>
                  </div>
                  <ul class="breadcrumbs-custom-path">
                     <li><a href="./">Home</a></li>
                     <li class="active">Room Booking Details</li>
                  </ul>
               </div>
            </div>
         </section>
         <section class="section section-xs text-center bg-image context-dark" style="background-image: url('images/call-to-action.jpg')">
                <div class="container">
                  <div class="row justify-content-center">
                    <div class="col-sm-10 col-md-12">
                      <div class="box-cta-thin">
                        <h4 class="wow-outer" style="color:#fff;"><span class="wow slideInRight">Join us in making a difference — Become a donor today!</h4>
                        <div class="wow-outer button-outer"><a class="button button-primary button-winona wow slideInLeft" href="donate-now.php">Donate Now</a></div>
                      </div>
                    </div>
                  </div>
                </div>
              </section>
         <section class="section section-lg">
            <div class="container">
               <div class="row row-50">
                  <div class="col-lg-4">
                     <!-- Profile Thin-->
                     <article class="profile-thin bg-color-theme">
                        <div class="profile-thin-aside">
                           <img class="profile-thin-image" src="img/ac3.jpg" alt="" width="168" height="168">
                           <a class="profile-thin-contact-button" href="mailto:#"><span class="icon mdi mdi-email-outline"></span><span class="icon mdi mdi-email-outline"></span></a>
                        </div>
                        <div class="profile-thin-main">
                           <h4 class="profile-thin-title">Become a Donar Today</h4>
                           <p>Temple donations are financial or material contributions made by devotees to support the maintenance, operations, and activities of a temple. These donations help fund various aspects such as Maintenance & Renovation, Daily Pooja & Rituals and Annadhanam.</p>
                           <div class="group group-xs group-middle">
							   <a class="icon icon-sm icon-creative mdi mdi-facebook" href="#"></a>
							   <a class="icon icon-sm icon-creative mdi mdi-twitter" href="#"></a>
							   <a class="icon icon-sm icon-creative mdi mdi-instagram" href="#"></a>
							</div>
                           
						   <a class="button button-sm button-primary-outline button-winona" href="donate-now.php">
                              <div class="content-original">Donate Now</div>
                              <div class="content-dubbed">Donate Now</div>
                           </a>
						   <a class="button button-primary button-winona" href="booknow.php">
									<div class="content-original">Book Now</div>
									<div class="content-dubbed">Book Now</div>
								</a>
						   <!--<a class="button button-sm button-primary-outline button-winona" href="online-pooja-booking.php">
                              <div class="content-original">Online Pooja Booking</div>
                              <div class="content-dubbed">Online Pooja Booking</div>
                           </a>--->
                        </div>
                     </article>
                  </div>
                  <div class="col-lg-8">
                     <article class="post-creative">
                        <div class="spiritual-title">
							<img src="img/saibaba.png" class="mandala-bg" alt="mandala pattern">
							<h1>Room Booking Details</h1>
						</div>
						
                        <ul class="post-creative-meta">
                           <li><span class="icon mdi mdi-calendar-clock"></span>
                              <time datetime="2019">Update : May 9, 2019 at 6:09 pm</time>
                           </li>
						   <li><span class="icon mdi mdi-tag-multiple"></span>
							<a href="#" style="font-size:25px">Rs. 1,600</a>
						   </li>
						   <li>
								<a class="button button-primary button-winona" href="booknow.php">
									<div class="content-original">Book Now</div>
									<div class="content-dubbed">Book Now</div>
								</a>
							</li>
                        </ul>
                        <img src="img/single-blog-post-1-770x458.jpg" alt="" width="770" height="458">
                        <p class="text-justify">Welcome to Sai Baba Temple Mandam, a serene and comfortable stay near Mylapore Sai Baba Temple. We offer 10 well-maintained rooms for devotees and visitors, ensuring a peaceful and spiritual experience during your stay.</p>
                        <!-- Quote Light-->
						<h4 class="profile-thin-title">Room Features:</h4>
						<ul class="list-marked">
							<li>Occupancy Limit: A maximum of 2 members are allowed per room.</li>

							<li>Spacious and well-ventilated rooms</li>

							<li>Comfortable bedding for a restful sleep</li>

							<li>Attached bathroom with 24/7 water supply</li>

							<li>Clean and hygienic environment</li>

							<li>Simple and traditional decor for a divine atmosphere</li>
						</ul>
						
						<?php

include('admin/include/config.php'); // Include database configuration

// Fixed total rooms
$totalRooms = 10;

// Query to calculate the sum of rooms for confirmed bookings (status = 1)
$sql = "SELECT SUM(rooms) AS occupied_rooms FROM rooms WHERE status = 1";
$stmt = $con->prepare($sql);
if (!$stmt) {
    die("Database error: " . $con->error);
}
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$stmt->close();

// Extract occupied rooms (default to 0 if null)
$occupiedRooms = $row['occupied_rooms'] ?? 0;

// Calculate available rooms
$availableRooms = $totalRooms - $occupiedRooms;

// Ensure available rooms do not go below 0
$availableRooms = max($availableRooms, 0);

// Display available rooms
echo '<h4 class="profile-thin-title">Available Rooms: ' . $availableRooms . ' Rooms</h4>';
?>

						
						<div class="wow slideInDown" style="visibility: visible; animation-name: slideInDown;">
						 <a class="button button-primary button-winona" href="booknow.php">
							<div class="content-original">Book Now</div>
							<div class="content-dubbed">Book Now</div>
						</a>
						</div>
						
                        <h4 class="profile-thin-title">Terms and Conditions for Room Booking:</h4>
						<ul class="list-marked">
							<li>Occupancy Limit: A maximum of 2 members are allowed per room.</li>

							<li>Identification Requirement: A valid Aadhaar card is mandatory for check-in.</li>

							<li>Refund & Transfer Policy: The booking amount is non-refundable and non-transferable.</li>

							<li>Children Policy: Entry for children below the age of 12 years is free.</li>

							<li>Entry Requirements: It is compulsory to show the ticket at the entry point of the temple.</li>

							<li>Darshan Date Policy: The darshan date cannot be rescheduled under any circumstances.</li>
						</ul>
						
                     </article>
                  </div>
               </div>
            </div>
         </section>
         <?php include('includes/footer.php'); ?>     
      </div>
      <div class="snackbars" id="form-output-global"></div>
      <script src="js/core.min.js"></script>
      <script src="js/script.js"></script>
   </body>
</html>