<?php include('innerpageheader.php'); include('config.php'); $cid = $_GET['cid']; ?> <script type="text/javascript"> function showsubheads(str) { if (str=="") { document.getElementById("governate").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("governate").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","show_subgovernates.php?q="+str,true); xmlhttp.send(); } function showgovsubheads(str1) { if (str1=="") { document.getElementById("location").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("location").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","show_sublocations.php?q="+str1,true); xmlhttp.send(); } function showgovsubheads1(str2, str3) { if (str2=="") { document.getElementById("hotels").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("hotels").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","show_subhotels.php?q="+str2+"&x="+str3,true); xmlhttp.send(); } </script> <section> <div class="content add-details"> <div class="in-content-wrapper"> <div class="box"> <div class="row"> <div class="col"> <div class="details-text"> <h4>Add Hotel Details</h4> </div><!-- end details-text --> </div><!-- End column --> </div><!-- end row --> <div class="hotel-listing-form"> <form class="text-center" method="post" action="save_hotelsforcustomers.php"> <input type="hidden" value="<?php echo $cid?>" id="cid" name="cid" /> <div class="row"> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Country :</label> </div> <select class="form-select" id="country" name="country" onchange="showsubheads(this.value)"> <option>SELECT COUNTRY</option> <?php $result = $js->prepare('SELECT * FROM `countries` ORDER BY `cname`'); $result->execute(); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $id = $row['id']; $cname = $row['cname']; echo "<option value=$id>$cname</option>"; } ?> </select> </div> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Governates</label> </div> <select class="form-select" id="governate" name="governate"> <option>SELECT GOVERNATE</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect00">Hotel Category</label> </div> <select class="form-select" id="category" name="category" onchange="showgovsubheads1(this.value, document.getElementById('governate').value)"> <option>SELECT CATEGORY</option> <option value="3">3 *</option> <option value="4">4 *</option> <option value="5">5 *</option> <option value="DESERT CAMP">DESERT CAMP</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> <div class="col-md"> <div class="form-group"> <div class="input-group"> <div class="input-group-prepend"> <label class="input-group-text" for="inputGroupSelect07" class="">Hotel Name:</label> </div> <select class="form-select" id="hotels" name="hotels"> <option>SELECT HOTEL</option> </select> </div> </div><!-- end form-group --> </div><!-- end column --> </div><!-- end row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Check-in Date:</label> <input type="date" class="form-control text-center" required id="cindate" name="cindate"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Check-out Date:</label> <input type="date" class="form-control text-center" required id="coutdate" name="coutdate"> </div><!-- end form-group --> </div> </div><!-- end form-row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Room Type:</label> <input type="text" class="form-control text-center" required id="roomtype" name="roomtype"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Meals:</label> <input type="text" class="form-control text-center" required id="meals" name="meals"> </div><!-- end form-group --> </div> </div> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">No of rooms:</label> <input type="text" class="form-control text-center" required id="rooms" name="rooms"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">No of Extra-beds:</label> <input type="text" class="form-control text-center" id="ebs" name="ebs"> </div><!-- end form-group --> </div> </div><!-- end form-row --> <div class="row"> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Room Rate:</label> <input type="text" class="form-control text-center" id="rrate" name="rrate"> </div><!-- end form-group --> </div> <div class="col-md"> <div class="form-group"> <label for="to7" class="">Extra-bed Rate:</label> <input type="text" class="form-control text-center" id="rebrate" name="rebrate"> </div><!-- end form-group --> </div> </div><!-- end form-row --> <div class="row"> <div class="form-group"> <textarea class="form-control textarea text-left p-3" id="remarks" name="remarks" rows="5" placeholder="Enter Remarks"></textarea> </div><!-- end form-group --> </div> <div class="row"> <div class="form-group"> <textarea class="form-control textarea text-left p-3" id="addservices" name="addservices" rows="5" placeholder="Additional Services"></textarea> </div><!-- end form-group --> </div> <ul class="list-inline"> <li class="list-inline-item"> <button type="submit" class="btn">Submit</button> </li> <li class="list-inline-item"> <a href="view_customers.php?id=<?php echo $cid?>" style="background-color:#FF3333; border-radius:5px; color:#fff;" class="btn"><strong>Back</strong></a> </li> </ul> </form> </div><!-- end hotel-listing-form --> </div><!-- end box --> <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>Category</th> <th>Room Type</th> <th>Meal Plan</th> <th>Check-in Date</th> <th>Check-out Date</th> <th>Action</th> </tr> </thead> <tbody> <?php $i = 1; $result1 = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid'); $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']; $meals = $row1['meals']; $cindate = date('d-m-Y', strtotime($row1['cindate'])); $coutdate = date('d-m-Y', strtotime($row1['coutdate'])); echo "<tr>"; echo "<td>$i</td>"; echo "<td>$hotelname</td>"; echo "<td>$location</td>"; echo "<td>$category *</td>"; echo "<td>$roomtype</td>"; echo "<td>$meals</td>"; echo "<td>$cindate</td>"; echo "<td>$coutdate</td>"; echo "<td>"; ?> <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> </div> </div> </div><!-- end in-content-wrapper --> </div><!-- end add-details --> </section> <!-- ===========End Innerpage-wrapper============= --> </div><!-- end wrapper --> <?php include('footer.php'); ?>