/
choose-table.php
115 lines (104 loc) · 5.53 KB
/
choose-table.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<!-- choose-table.php -->
<?php
if (isset($_POST['reservation'])) {
$res_id = $_POST['res_id'];
$reservation_name = $_POST['reservation_name'];
$reservation_phone = $_POST['reservation_phone'];
$reservation_date = $_POST['reservation_date'];
$reservation_time = $_POST['reservation_time'];
include 'template/header.php'; ?>
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous">
<body>
<?php include 'template/nav-bar.php'; ?>
<!-- END nav -->
<section class="home-slider owl-carousel" style="height: 400px;">
<div class="slider-item" style="background-image: url('images/bg_1.jpg');" data-stellar-background-ratio="0.5">
<div class="overlay"></div>
<div class="container">
<div class="row slider-text align-items-center justify-content-center">
<div class="col-md-10 col-sm-12 ftco-animate text-center" style="padding-bottom: 25%;">
<p class="breadcrumbs"><span class="mr-2"><a href="index.php">Home</a></span> <span>Tables</span></p>
<h1 class="mb-3">Choose Tables</h1>
</div>
</div>
</div>
</div>
</section>
<section class="ftco-section" style="background: #ffffff;">
<div class="container">
<div class="row justify-content-center mb-5 pb-5">
<div class="col-md-7 text-center heading-section ftco-animate">
<span class="subheading">Our Tables</span>
<h2>Choose Your Table</h2>
</div>
</div>
<form action="select-menu.php" method="POST">
<div class="row">
<div class="col-md-12 dish-menu">
<div class="tab-content py-5" id="v-pills-tabContent">
<div class="tab-pane fade show active" id="v-pills-home" role="tabpanel" aria-labelledby="v-pills-home-tab">
<div class="row">
<?php
include 'dbCon.php';
$con = connect();
$sql = "SELECT * FROM `restaurant_tables` WHERE res_id = '$res_id';";
$result = $con->query($sql);
foreach ($result as $r) {
$table_id = $r['id'];
?>
<div class="col-lg-3">
<nav class="menu2">
<input type="checkbox" name="table[]" value="<?php echo $table_id; ?>" class="menu-toggler2" >
<label for="menu-toggler2"></label>
<ul>
<?php
$sql2 = "SELECT * FROM `restaurant_chair` WHERE tbl_id = '$table_id';";
$result2 = $con->query($sql2);
foreach ($result2 as $r2) {
$c_id = $r2['id'];
$booked = false;
$cbbook = "SELECT `id`, `booking_id`, `chair_id`, `chair_no`, (SELECT booking_date FROM booking_details WHERE booking_chair.booking_id = booking_details.booking_id AND booking_details.booking_date = '$reservation_date') as bdate, (SELECT booking_time FROM booking_details WHERE booking_chair.booking_id = booking_details.booking_id AND booking_details.booking_time = '$reservation_time') as btime FROM `booking_chair` where booking_chair.chair_id = '$c_id';";
$cbbookresult = $con->query($cbbook);
if ($cbbookresult->num_rows > 0) {
$booked = true;
}
if ($booked == true) {
?>
<li class="menu-item2">
<input type="checkbox" name="chair[]" disabled="">
</li>
<?php } else{ ?>
<li class="menu-item2">
<input type="checkbox" name="chair[]" value="<?php echo $r2['id']; ?>">
</li>
<?php } ?>
<?php } ?>
</ul>
</nav>
</div>
<?php } ?>
<div class="col-lg-12" style="margin-top: 15%;text-align: center;">
<div class="form-group">
<input type="hidden" name="res_id" value="<?php echo $res_id; ?>">
<input type="hidden" name="reservation_name" value="<?php echo $reservation_name; ?>">
<input type="hidden" name="reservation_phone" value="<?php echo $reservation_phone; ?>">
<input type="hidden" name="reservation_date" value="<?php echo $reservation_date; ?>">
<input type="hidden" name="reservation_time" value="<?php echo $reservation_time; ?>">
<input type="submit" value="View Manue" name="selectChair" class="btn btn-primary py-3 px-5">
</div>
</div>
</div><!-- END -->
</div>
</div>
</div>
</form>
</div>
</section>
<?php include 'template/instagram.php' ?>
<?php include 'template/footer.php'; ?>
<?php include 'template/script.php'; ?>
</body>
</html>
<?php }else{
}
?>