<?php $resid = $_GET['resid']; $cid = $_GET['cid']; include('config.php'); $result1 = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :cid AND id = :resid ORDER BY `cindate` ASC'); $result1->execute(array(':cid' => $cid, ':resid' => $resid)); while($row1 = $result1->fetch(PDO::FETCH_ASSOC)) { $id = $row1['id']; $voucherno = $row1['entryid']; $result = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :cid'); $result->execute(array(':cid' => $cid)); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $custname = $row['custname']; $pax = $row['pax']; } $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']; $address = $row2['address']; $phone = $row2['hotelphone']; } $roomtype = $row1['roomtype']; $stat = $row1['res_status']; $meals = $row1['meals']; $indate = $row1['cindate']; $outdate = $row1['coutdate']; $days = daysDifference($outdate,$indate); $cindate = date('d-m-Y', strtotime($row1['cindate'])); $coutdate = date('d-m-Y', strtotime($row1['coutdate'])); $remarks = $row1['remarks']; $addservices = $row1['addservices']; $rooms = $row1['norooms']; $ebs = $row1['noebs']; if($ebs == '') { $totalacc = $rooms." Room(s)"; } else { $totalacc = $rooms." + ".$ebs."Extra-Bed"; } } ?> <title>RESERVATION VOUCHER</title> <!-- Right Click Disable --> <script type="text/javascript"> <!-- var message=""; function clickIE() {if (document.all) {(message);return false;}} function clickNS(e) {if (document.layers||(document.getElementById&&!document.all)) { if (e.which==2||e.which==3) {(message);return false;}}} if (document.layers) {document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;} else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;} document.oncontextmenu=new Function("return false"); document.onkeydown = function(e) { if(e.keyCode == 123) { return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'I'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'J'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.keyCode == 'U'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'C'.charCodeAt(0)){ return false; } } </script> <!-- Right Click Disable --> <div style='margin:auto;padding:2px;width:1000px;'> <table style='width:1000px;margin:auto' cellpadding='3' cellspacing='3'> <tr> <td style='text-align:center'><span style='font-size:25px;'><b>RESERVATION CONFIRMATION VOUCHER</b><br/> <?php echo $voucherno?></span></td> </tr> </table> </div> <div style='margin:auto;padding:2px;width:1000px;border:1px solid black'> <table style='width:1000px;margin:auto' cellpadding='3' cellspacing='3'> <tr> <td style='text-align: center;' colspan='2'><img src="images/logodmc.png" alt="" style="/*margin-top: -50px;*/"/><br/> THE FALCON EXPEDITIONS TRADE LLC <br/></td> </tr> <tr> <td style='float:left'>Registration No : 1503838</td> <td style='float:right'>Tax Card No : 18915887</td> </tr> </table> <hr style='margin-top: -6px;'/> <table width="956" style="margin:auto;border-collapse:collapse"> <tr> <td><table width="956" style="margin:auto;border-collapse:collapse"> <tr> <td width='3%'>To,</td> <td></td> </tr> <tr> <td></td> <td>The Manager<br/> <?php echo $hotelname?> <br /> <?php echo $address?> <br/> Ph: <?php echo $phone?> </td> </tr> <tr> <td colspan='2' style='padding:20px;text-align:center'><b>In Exchange of this voucher, please provide <?php echo $days?> night(s) accommodation with <?php echo $meals?> and applicable taxes against Hotel <?php echo $remarks?> as per below: </td> </tr> </table> <table border='1' cellpadding='3' cellspacing='3' width='956' style='width:fixed;margin:auto;border-collapse:collapse'> <tr bgcolor='#b2beb5'> <th colspan='4'><b>GUEST DETAILS</b></th> </tr> <tr> <td width='15%'>Guest Name</td> <td width='35%'><?php echo $custname?></td> <td width='15%'>No of Pax</td> <td width='35%'><?php echo $pax?></td> </tr> <tr bgcolor='#b2beb5'> <th colspan='4'><b>RESERVATION DETAILS</b></th> </tr> <tr> <td>Hotel</td> <td><?php echo $hotelname?> - <?php echo $location?></td> <td>Room Type</td> <td><?php echo $roomtype?></td> </tr> <tr> <td>Check In</td> <td><?php echo $cindate?></td> <td>No of Rooms</td> <td><?php echo $totalacc?></td> </tr> <tr> <td>Check Out</td> <td><?php echo $coutdate?></td> <td>Meal Plan</td> <td><?php echo $meals?></td> </tr> </table> <br/> <table width='956'> <tr> <td><img src="header3.jpg" width="956" /></td> </tr> </table> <table width='956' style='margin:auto' cellpadding='3' cellspacing='3'> <tr> <td colspan='3' style='text-align:center'><b>RESERVATION AND PAYMENT THROUGH : </b></td> </tr> <tr> <td style='padding:20px'>Central Reservations <br/> The Falcon Expeditions<br/> Al-Khuwai, Muscat, Sultanate of Oman<br /> Ph: 941 55255, 7719 0959<br/> email : reservations@thefalconexpeditions.com || web :www.thefalconexpeditions.com</td> <td style='/*border-bottom:1px dashed black;*/text-align:center'><img src="images/STAMP AND SIGN.jpg" alt="" style="text-align:right" /><br/> ---------------------------<br/> Seal and Sign</td> </tr> </table></td> </tr> <tr> <td><hr/> <b>ADDITIONAL SERVICES:</b> <input type="text" style="width:420px; border:none; font-weight:bold;" value='<?php echo $addservices?>' /> <br /> <b>All extras (if any) to be paid directly to Hotel/Service Provider</b> <hr/></td> </tr> <tr> <td><br/> <div align="justify" style="margin:auto;width:956px;"> <span style="margin:auto; font-size:14px"><strong><u>Terms &amp; Conditions</u></strong><br /> <strong>Vouchers</strong> are not transferable and valid only for the services mentioned therein. Any services not specifically requested, confirmed and noted on vouchers will not be rendered. All extras to be paid directly to the hotels/the service providers<br /> <strong><u>Cancellation/Refunds</u></strong><br /> <span style="text-align:justify">Cancellation charges will be levied for bookings cancelled after issuance of the vouchers. Requests for refund should be made in writing within 14 days after the scheduled completion of the services. Refund requests for curtailed stays cannot be processed unless provided with documentary evidence from hotel/the service provider. All refund requests are subject to obtaining a refund approval from the hotel/the service provider and no refund can be given without this approval. The hotel/the service provider reserve the right to process and whether or not to approve the refund request and if necessary charge an administrative fee. For packages, no refunds can be processed for partially utilized services and no-shows.<br /> </span> <strong><u>Responsibility</u></strong><br /> It is understood that, we act as agent only for all services covered hereby. Further we shall not be responsible for any loss, injury or damage resulting from acts of God, dangers, fire, breakdown of machinery, equipment or vehicles, acts of government authority, wars, civil disturbances, riots, thefts, pilferage, epidemics, quarantines or any delays or changes including any extra expenses which the passenger may incur as a result of any of the foregoing causes.<br/> <span style="text-align:justify"><strong><u>General Hotel Policy</u></strong><br/> a. It is mandatory for guests to present <strong>valid photo identification</strong> at the time of check-in. <br/> b. The inclusion of extra bed with a booking is facilitated with a folding cot or a mattress as an extra bed. <br/> c. Early check-in or late check-out is subject to availability and may be chargeable by the hotel. <br/> d. The room tariff includes all taxes. The amount paid for the room does not include charges for optional services and facilities (such as room service, mini bar, snacks or telephone calls). These will be charged at the time of check-out. </span><br/> <strong><u>Assistance</u></strong><br /> <span style="text-align:justify;color:red">For any reservation assistance please contact +968 9753 1234</span><br /> </div> <br/> <br/> <span style='padding-left:390px'>Verified By FALCON IT Dept.</span></td> </tr> </table> </span></span></span></span> <?php function daysDifference($endDate, $beginDate) { //explode the date by "-" and storing to array $date_parts1=explode("-", $beginDate); $date_parts2=explode("-", $endDate); //gregoriantojd() Converts a Gregorian date to Julian Day Count $start_date=gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]); $end_date=gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]); return $end_date - $start_date; } ?>