echo $value['room_description'];
?>
</option><?php
}
?>
</select></p>
<p><input type="reset" value="Reset" class="dash-controls">
<input type="submit" value="Check Availability" name="submit" class="dash-controls"></p>
</form>
<?php
if (isset($_POST['submit'])) {
$from = $_POST['start'];
$to = $_POST['end'];
$room_type = $_POST['room_type'];
$room_descrip = $_POST['description'];
$available = getAvailablerooms($from, $to, $room_type, $room_descrip);
?>
<table>
<caption>Start Date: <?php
echo $from;
?>
End Date: <?php
echo $to;
?>
</caption><tr><td>Room_no</td>
<td>Name</td>
<td>Description</td>
<td> Room type</td>
</tr>
<?php
if ($available) {
$totalamnt = $_POST['total-amount'];
$payment = $_POST['amount'];
$date = date_create($from);
$from = date_format($date, "Y-m-d 11:00:00");
$date = date_create($to);
$to = date_format($date, "Y-m-d 14:00:00");
$date_issue = date('Y-m-d');
$room = check_availablestandard($from, $to);
$stand_single = getAvailablerooms($from, $to, 1, 1);
$stand_double = getAvailablerooms($from, $to, 1, 2);
$stand_triple = getAvailablerooms($from, $to, 1, 3);
$deluxe_single = getAvailablerooms($from, $to, 2, 1);
$deluxe_double = getAvailablerooms($from, $to, 2, 2);
$sup_single = getAvailablerooms($from, $to, 3, 1);
$sup_double = getAvailablerooms($from, $to, 3, 2);
$sup_triple = getAvailablerooms($from, $to, 3, 3);
$query = "select * from invoice where cust_id={$cust} and section_id=5";
$invoice = getData($query);
$invoice_no = $invoice[0]['invoice_number'];
$amnt = $invoice[0]['amount'] + $totalamnt;
$query = "update invoice set amount={$amnt} where cust_id='" . $cust . "' and section_id='5'";
update($query);
$payid = getPayment();
if ($payment > 0) {
//insert amount paid into payment
$query = "insert into payment (pay_id, amount, section_id,cust_id) values ('" . $payid . "','" . $payment . "','5','" . $cust . "')";
update($query);
}
$cust_id = $cust;
//Standard single rooms
if (isset($_POST['standard_single'])) {
// unset $_SESSION variable for the run-time
session_destroy();
// destroy session data in storage
header('Location:index.php');
} else {
session_regenerate_id(true);
$_SESSION["last_acted_on"] = time();
$from = $_POST['arrival_date'];
$to = $_POST['departure_date'];
//check room availability
$room = check_availablestandard($from, $to);
$stand_single = getAvailablerooms($from, $to, 1, 1);
$stand_double = getAvailablerooms($from, $to, 1, 2);
$stand_triple = getAvailablerooms($from, $to, 1, 3);
$deluxe_single = getAvailablerooms($from, $to, 2, 1);
$deluxe_double = getAvailablerooms($from, $to, 2, 2);
if (!empty($_POST['reserve'])) {
$arrival = $_POST['arrival_date'];
$departure = $_POST['departure_date'];
}
if (isset($_POST['update'])) {
$no = $_POST['room_number'];
$name = $_POST['name'];
$tp = $_POST['room_type'];
$des = $_POST['description'];
$query = "update room set name='" . $name . "' , cat_id='" . $tp . "' , room_id='" . $des . "' where room_no='" . $no . "'";
//updateRoom($query);
//header('Location: home.php');
}
if (isset($_GET['order'])) {
$order = $_GET['order'];
