invisio v2.0

<?php
	include('innerpageheader.php');
	include('config.php');
	
	$cid = $_GET['cid'];
?>

<div class="row no-gutters">
							<div class="col-12 table-responsive">
								<table id="example" class="table table-hover responsive listing">
									<thead>
										<tr>
											<th>#</th>
											<th>Hotel Name</th>
                                            <th>Location</th>
                                            <th>Room Type</th>
                                            <th>Meal Plan</th>
                                            <th>Check-in Date</th>
                                            <th>Check-out Date</th>
                                            <th>Reservation</th>
                                            <th>Action</th>
										</tr>
									</thead>
									<tbody>
                                        <?php
											
											$i = 1;
											
											$result1 = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid ORDER BY `cindate` ASC');
											$result1->execute(array(':cid' => $cid));
											
											while($row1 = $result1->fetch(PDO::FETCH_ASSOC)) 
											{
												$id = $row1['id'];
												$hotel = $row1['hotel'];
												$result2 = $js->prepare('SELECT * FROM `hotelvendor` WHERE id = :hotel ');
												$result2->execute(array(':hotel' => $hotel));
												while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) 
												{
													$hotelname = $row2['hotelname'];
													$location = $row2['location'];
													$category = $row2['category'];
												}
												$roomtype = $row1['roomtype'];
												$stat = $row1['res_status'];
												$meals = $row1['meals'];
												$cindate = date('d-m-Y', strtotime($row1['cindate']));
												$coutdate = date('d-m-Y', strtotime($row1['coutdate']));
												$res_status = $row1['res_status'];
												echo "<tr>";
													echo "<td>$i</td>";
													echo "<td>$hotelname</td>";
													echo "<td>$location</td>";
													echo "<td>$roomtype</td>";
													echo "<td>$meals</td>";
													echo "<td>$cindate</td>";
													echo "<td>$coutdate</td>";
													if($stat == 'Pending')
													{
														echo "<td><a href='send_reservation.php?hid=$id&cid=$cid'>Send Reservation</a>";
													}
													else if($stat == 'Confirmed')
													{
														echo "<td><a href='voucher.php?resid=$id&cid=$cid' target='_blank'><i class='fa fa-print' style='color:#006;'></i></a></td>";
													}
													else
													{
														echo "<td>$res_status</td>";	
													}
													echo "<td>";
											?>
                                            			<a href="edit_hotelsforcustomers.php?id=<?php echo $id?>&cid=<?php echo $cid?>"><i class="fa fa-edit" style="color:#006;"></i></a>
														<a href="delete_hotelsforcustomers.php?id=<?php echo $id?>&cid=<?php echo $cid?>"><i class="fa fa-times-circle" style="color:red"></i></a>
                                            <?php
													echo "</td>";
												echo "</tr>";
												$i++;
											}
										?>
                             		</tbody>
                                 </table>
                                 <table>
        	<tr>
                <td><a href="viewcustomers.php?id=<?php echo $cid?>" class="btn btn-primary" style="color:white;">Back</a></td>
             </tr>
        </table>
                               </div>
                               
      </div>
      
				</div>
			</div>
		</section>

</div>

<?php
	include('footer.php');
?>