'; echo 'location.href = "reservation.php"'; echo ''; } if (isset($_POST['membernum'])) { $membernum = $_POST["membernum"]; $sql_c = mysql_query("select * from member where membernum='".$membernum."'"); if(mysql_num_rows($sql_c)) { $row = mysql_fetch_array($sql_c); $name=$row['lastname']; } } if (isset($_POST['copcode'])) { $copcode = $_POST["copcode"]; $sql_e = mysql_query("select * from corpmember where coprcode='".$copcode."'") or die(mysql_error()); if(mysql_num_rows($sql_e)) { $row = mysql_fetch_array($sql_e); $name=$row['companyname']; } } if (isset($_POST['pkgcode'])) { $pkgcode= $_POST['pkgcode']; }else{ $pkgcode = ''; } $query11 = "select * from packagehotel WHERE no = '$pkgcode'"; $result11 = mysql_query($query11); $num_rows11 = mysql_num_rows($result11); $row11 = mysql_fetch_array($result11); $pkg_codeor = $row11['pkg_code']; $pkg_title1 = $row11['pkg_title']; $stayperiod_from1 = $row11['stayperiod_from']; $stayperiod_to1 = $row11['stayperiod_to']; $starteddate1 = $row11['startdate']; $packagetype1 = $row11['packagetype']; $endeddate1 = $row11['endeddate']; $description1 = $row11['description']; $minimumpax1 = $row11['minimumpax']; $maxpax1 = $row11['maxpax']; $daystaying1 = $row11['daystaying']; $nightstaying1 = $row11['nightstaying']; $active1 = $row11['active']; $pricepkg1 = $row11['pricepkg']; $single_occu1 = $row11['single_occu']; $addnight_low1 = $row11['addnight_low']; $addnight_normal1 = $row11['addnight_normal']; $addnight_weekended1 = $row11['addnight_weekended']; $addnight_peak1 = $row11['addnight_peak']; $addnight_speak1 = $row11['addnight_speak']; $surchargeadult_low1 = $row11['surchargeadult_low']; $surchargeadult_weekend1 = $row11['surchargeadult_weekend']; $surchargeadult_peak1 = $row11['surchargeadult_peak']; $surchargeadult_speak1 = $row11['surchargeadult_speak']; $surchargechild_low1 = $row11['surchargechild_low']; $surchargechild_weekend1 = $row11['surchargechild_weekend']; $surchargechild_peak1 = $row11['surchargechild_peak']; $surchargechild_speak1 = $row11['surchargechild_speak']; $special_package1 = $row11['special_package']; $packagetype1 = $row11['packagetype']; $queryss = "select * from packagepic WHERE pkg_code = '$pkg_codeor' and title_pic ='MAIN'"; $resultss = mysql_query($queryss); $num_rowsss = mysql_num_rows($resultss); $rowss = mysql_fetch_array($resultss); $bigpicname = $rowss['bigpicname']; $thumbpicname = $rowss['thumbpicname']; $actualurl = $rowss['actualurl']; $extend_name = $rowss['extend_name']; if (isset($_POST['h_checkin'])) { $checkin = $_POST['h_checkin']; }else{ $checkin = ''; } if (isset($_POST['h_checkout'])) { $checkout = $_POST['h_checkout']; }else{ $checkout = ''; } if (isset($_POST['h_quantity'])) { $quantity = $_POST['h_quantity']; }else{ $quantity = ''; } if (isset($_POST['h_adult'])) { $adult = $_POST['h_adult']; }else{ $adult = ''; } if (isset($_POST['h_children'])) { $children = $_POST['h_children']; }else{ $children = ''; } if (isset($_POST['h_numofnights'])) { $numofnights = round($_POST['h_numofnights'],0); }else{ $numofnights = ''; } if (isset($_POST['h_ratetouselist'])) { $ratetouselist = $_POST['h_ratetouselist']; //if(strlen($ratetouselist)>2){ //$ratetouselist = substr($ratetouselist,0,strlen($ratetouselist)-1); //} $ratecode = ''; $arr_ratetouselist = explode(",",$ratetouselist); sort($arr_ratetouselist); $y = 0; for ($x = 0; $x < count($arr_ratetouselist); $x++){ if ($arr_ratetouselist[$x]!=""){ if($ratecode!=$arr_ratetouselist[$x]){ if($y==0){ $ratetouselist_trim = $arr_ratetouselist[$x]; }else{ $ratetouselist_trim .= "," . $arr_ratetouselist[$x]; } $y ++; $ratecode = $arr_ratetouselist[$x]; } } } }else{ $ratetouselist = ''; } if (isset($_POST['h_remark'])) { $remark = $_POST['h_remark']; }else{ $remark = ''; } if (isset($_POST['h_amount'])) { $amount = $_POST['h_amount']; }else{ $amount = ''; } if($pricepkg1!=''){ $amount=$pricepkg1; } if (isset($_POST['h_id'])) { $id = $_POST['h_id']; if($numofnights>1){ $normal = ''; $peak = ''; $superpeak = ''; $lowseason = ''; $weekend=''; $query = "SELECT f_roomtype FROM roomtype WHERE f_id = '$id' "; $result = mysql_query($query); $row = mysql_fetch_array($result); $roomtype = $row['f_roomtype']; }else{ $query = "SELECT f_normal,f_peak,f_superpeak,f_low,f_weekend FROM roomallot WHERE f_date = '$checkin' and f_roomid = '$id' "; $result = mysql_query($query); $row = mysql_fetch_array($result); $normal = $row['f_normal']; $peak = $row['f_peak']; $superpeak = $row['f_superpeak']; $lowseason = $row['f_low']; $weekend = $row['f_weekend']; $query = "SELECT f_roomtype FROM roomtype WHERE f_id = '$id' "; $result = mysql_query($query); $row = mysql_fetch_array($result); $roomtype = $row['f_roomtype']; } }else{ $id = ''; $roomtype = ''; } $smallkt=9; for ($i11 = 0; $i11 < $numofnights; $i11++) { $dt_checkin11 = mktime(0,0,0,substr($checkin,5,2),substr($checkin,8,2)+$i11,substr($checkin,0,4)); $dt_checkin11 = date("Y-m-d", $dt_checkin11); $querykt = "SELECT f_balance FROM roomallot WHERE f_date = '$dt_checkin11' and f_roomid = '$id' "; $resultkt = mysql_query($querykt); $rowkt = mysql_fetch_array($resultkt); $f_balancekt = $rowkt['f_balance']; if($f_balancekt<$smallkt){ $smallkt=$f_balancekt; } } if ($smallkt>3 && $smallkt<=8){ $word="Limited room"; } else if ($smallkt<=3){ $word="Only $smallkt left"; } $querykk = "select * from systemsetting where no='1'"; $resultkk = mysql_query($querykk); $num_rowskk = mysql_num_rows($resultkk); $rowkk = mysql_fetch_array($resultkk); $discountaddonshowkk = $rowkk['discountaddonshow']; $testmodekk = $rowkk['testmode']; ?>
 Hi,
*/ ?>
Avalaible
Package Code :
Arrival Date : formatDatePHP($checkin,1) ?>
Departure Date : formatDatePHP($checkout,1) ?>
Number of night(s) :
Room Type :
Room Quantity :
Adult :
Children :
Walk-In Rate (RM) :      
Online Rate (RM) :
0){ if($numofnights>=7){ $amount=$weekamount+(($numofnights-7)*$averageamount); } if ($numofnights>=$numofmonth){ $amount=$monthamount+(($numofnights-$numofmonth)*$averageamount); } } //earlybirds start $watday = date("N", strtotime($checkin)); $today = date('Y'.'-'.'m'.'-'.'d'); $ch1 = date($checkin); $earlyrate=0; //$erate="0%"; $daysbetween = (strtotime("$ch1") - strtotime("$today")) / (60 * 60 * 24); $query11="select * from earlybird where '$daysbetween'>=day and active ='Y' ORDER BY day desc"; $result11 = mysql_query($query11); $row11 = mysql_fetch_array($result11); $earlyrate = $row11['earlyrate']; $erate1 = $row11['erate']; $earlyrateprint=$earlyrate*100; $erate=$erate1.'%'; ?>
=$starteddate){ if ($checkin>=$stayingperiodstart && $checkin<=$stayingperiodend){ if ($quantity<$minimumroom9){ if ($earlyrate==0){$promotion = "NORMAL"; echo 'Booking quantity is less than minimun requirement.'; $membercode="normal rate"; } else if($earlyrate>0){$promotion = "EARLYBIRDS"; echo "Booking quantity is less than minimun requirement. Early Birds Discount is $earlyrateprint % "; $membercode="earlybirds"; } $discount=$earlyrate; $amount2=$amount*$earlyrate; } else if ($quantity>=$minimumroom9){ $queryee = "select count(*) from promotionalroomprice where memberid ='$membernum' and roomid ='$id'"; $listee=mysql_query($queryee); list($public_countee)=mysql_fetch_row($listee); //if ($public_count !=0){ if ($activefroomrates=="YES" && $public_countee !=0){ $promotion = "Promotional"; $queryktktkt="select roompricedis from promotionalroomprice where memberid ='$membernum' and roomid ='$id'"; $resultktktkt = mysql_query($queryktktkt); $rowktktkt = mysql_fetch_array($resultktktkt); $roompricedis = $rowktktkt['roompricedis']; $roompricedis=$roompricedis*$quantity*$numofnights; $discount=$amount-$roompricedis; $amount2=$discount; echo 'Promotional Discount is '; echo "RM $discount"; echo ''; $membercode=$membernum; } else if($activefroomrates=="NO"){ if($activediscount9=="YES"){ echo 'Promotional Discount is '; echo "RM $ddiscount_amount9"; echo ''; $promotion = "Promotional"; $membercode=$membernum; $discount=$ddiscount_amount9; $amount2=$ddiscount_amount9; } else if($activediscount9=="NO"){ $discount99=$discount9*100; echo "Promotional Discount is $discount99 %"; $promotion = "Promotional"; $membercode=$membernum; $discount=$discount9; $amount2=$amount*$discount9; } } } } else if ($checkin<$stayingperiodstart || $checkin>$stayingperiodend){ if ($earlyrate==0){$promotion = "NORMAL"; echo 'Your checkin date is out of staying period. '; $membercode="normal rate"; } else if($earlyrate>0){$promotion = "EARLYBIRDS"; echo "Your checkin date is out of staying period. Early Birds Discount is $earlyrateprint % "; $membercode="earlybirds"; } $discount=$earlyrate; $amount2=$amount*$earlyrate; } } else if ($today>$expirydate9){ if ($earlyrate==0){$promotion = "NORMAL"; echo 'Your Promotional code is Expired or Not started.'; $membercode="normal rate"; } if($earlyrate>0){$promotion = "EARLYBIRDS"; echo "Your Promotional code is Expired or Not started. Early Birds Discount is $earlyrateprint % "; $membercode="earlybirds"; } $discount=$earlyrate; $amount2=$amount*$earlyrate; } } else { if ($earlyrate==0){$promotion = "NORMAL"; echo 'Your Promotional code is Expired. '; $membercode="normal rate"; } else if($earlyrate>0){$promotion = "EARLYBIRDS"; echo "Your Promotional code is Expired. Early Birds Discount is $earlyrateprint % "; $membercode="earlybirds"; } $discount=$earlyrate; $amount2=$amount*$earlyrate; } } } else if (($_POST["membernum"])==null){ if ($earlyrate==0){ $promotion = ""; //echo 'Your Promotional code is Expired. '; $membercode="normal rate"; } else if($earlyrate>0){ $promotion = "EARLYBIRDS"; echo "Early Birds Discount is $earlyrateprint % "; $membercode="earlybirds"; } $discount=$earlyrate; $amount2=$amount*$earlyrate; } //special promotion $specialpromotion="on"; $totalamountdiscount=0; $amountdiscount=0; if($specialpromotion=="on"){ for ($iz = 0; $iz < $numofnights; $iz++) { $dt_checkinz = mktime(0,0,0,substr($checkin,5,2),substr($checkin,8,2)+$iz,substr($checkin,0,4)); $dt_checkinz = date("Y-m-d", $dt_checkinz); $dateone="2013-10-01"; $datetwo="2013-10-31"; $querycc = "SELECT f_normal,f_peak,f_superpeak,f_balance,f_low,f_weekend FROM roomallot WHERE f_date = '$dt_checkinz' and f_roomid = '$id' "; $resultcc = mysql_query($querycc); $rowcc = mysql_fetch_array($resultcc); $num_rowscc = mysql_num_rows($resultcc); $normalcc = $rowcc['f_normal']; $peakcc = $rowcc['f_peak']; $superpeakcc = $rowcc['f_superpeak']; $weekendcc = $rowcc['f_weekend']; $lowseasoncc = $rowcc['f_low']; $queryxx = "SELECT f_ratetouse FROM ratecalendar WHERE f_startdt = '$dt_checkinz' "; $resultxx = mysql_query($queryxx); $rowxx = mysql_fetch_array($resultxx); $num_rowsxx = mysql_num_rows($resultxx); $f_ratetousexx= $rowxx['f_ratetouse']; if ($f_ratetousexx=="NM" || $f_ratetousexx=="") $amountxx=$normalcc; if ($f_ratetousexx=="PE") $amountxx=$peakcc; if ($f_ratetousexx=="SP") $amountxx=$superpeakcc; if ($f_ratetousexx=="WK") $amountxx=$weekendcc; if ($f_ratetousexx=="LW") $amountxx=$lowseasoncc; if ($dt_checkinz>=$dateone && $dt_checkinz<=$datetwo){ $watday2 = date("N", strtotime($dt_checkinz)); if($watday2=="1" || $watday2=="2" || $watday2=="3" || $watday2=="4" || $watday2=="7"){ $amountdiscount=($amountxx*0.15)*$quantity; //echo "$amountdiscount- $amountxx - $watday2
"; } if($watday2=="5" || $watday2=="6" ){ $amountdiscount=($amountxx*0.1)*$quantity; //echo "$amountdiscount- $amountxx - $watday2
"; } $totalamountdiscount=$totalamountdiscount+$amountdiscount; //echo "$totalamountdiscount
"; } } $amount2=$totalamountdiscount; echo "Promotional Discount is $totalamountdiscount"; $promotion = "Special Promotion"; $discount=$totalamountdiscount; } ?>
(RM) :
Grand Total (RM) :
";} else{ echo "";} ?>
0){ ?>
'; echo ""; echo ""; echo ""; echo ""; echo ''; echo ''; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $cnt ++; } ?>
Add-ons                                      Pax        Night(s)/Set(s)
$fulldescr".$misc->listnumber('columncombobox2',"cboQty_$cnt","cboQty_$cnt","getAddOns(this)",1,0,30,'disabled')."             ".$misc->listnumber('columncombobox2',"cboNight_$cnt","cboNight_$cnt","getAddOns(this)",1,0,30,'disabled')."             
" />

: Currently users viewing this room
   

0){ while($row = mysql_fetch_array($result)) { $publish = $row['f_publish']; $descr = $row['f_descr']; } } $query = "SELECT * FROM roomphoto WHERE f_id = '$id' and f_photoid = 1 "; $result = mysql_query($query); $num_rows = mysql_num_rows($result); if ($num_rows>0){ while($row = mysql_fetch_array($result)) { $ftype = $row['f_ftype']; $photoname = $id.'_1.'.$ftype; //$photoname_s = $id.'_1_s.'.$ftype; } } ?>
"; } else { ?>



Currency Referrence
Currency : listcurrency('columncombobox','cboCurrencyType','cboCurrencyType',"displaycurrency()"); ?>
  :
USD