require_once('app_top.php');
//$chklvl = chklvl2cont($chk_level, 2);
$title = 'Hotel de Botani Admin Panel';
require_once('header.php');
$set = $_REQUEST['set'];
//if($chklvl){
//echo '';
//}
setting_menu($chk_level);
switch($set){
case 'offer':
echo '
Update Offer/Promotion Price
';
echo 'Add New Offer Price
';
$result = db_query("SELECT rtid, type, price, we_price, day_use, day_use_e FROM room_rates");
$row = $result-> fetch_object();
if($result-> num_rows > 0){
do{
$rtid = $row-> rtid;
$type = $row-> type;
$wd_price = $row-> price;
$we_price = $row-> we_price;
$day_use = $row-> day_use;
$day_use_e = $row-> day_use_e;
echo ''.ucwords($type).' Room
';
echo '';
echo '';
echo '| Normal Rates | ';
echo '
';
echo '';
echo '| Weekday | ';
echo 'RM '.$wd_price.' | ';
echo '
';
echo '';
echo '| Weekend | ';
echo 'RM '.$we_price.' | ';
echo '
';
echo '';
echo '| Day Use (10am - 6pm) | ';
echo 'RM '.$day_use.' | ';
echo '
';
echo '';
echo '| Day Use (6pm - 10am) | ';
echo 'RM '.$day_use.' | ';
echo '
';
echo '
';
//echo $rtid;
$result2 = db_query("SELECT prid, start_date, end_date, normal, member, status FROM promo_rates WHERE rtid='$rtid'");
$row2 = $result2-> fetch_object();
if($result2-> num_rows > 0){
echo '';
echo '';
echo '| Offer/Promotion Rates | ';
echo '
';
echo '';
echo '| Start Date | ';
echo 'End Date | ';
echo 'Non-Member Price | ';
echo 'Member Price | ';
echo '
';
do{
$prid = $row2-> prid;
$start_date = $row2-> start_date;
$end_date = $row2-> end_date;
$non_member = $row2-> normal;
$member = $row2-> member;
$status = $row2-> status;
if($status == 0){
echo '';
}else{
echo '
';
}
echo '| '.date('d M Y', strtotime($start_date)).' | ';
echo ''.date('d M Y', strtotime($end_date)).' | ';
echo 'RM '.$non_member.' | ';
echo 'RM '.$member.' | ';
echo 'Edit | ';
if($status == 1){
echo 'Disable | ';
}else{
echo 'Enable | ';
}
echo '
';
}while($row2 = $result2-> fetch_object());
echo '
';
}
}while($row = $result-> fetch_object());
}
break;
case 'rates':
echo 'Update Room Rates / night
';
echo '';
echo '';
echo '| Room type | ';
echo 'Normal | ';
echo 'Weekend | ';
echo 'Member | ';
echo 'Salesman | ';
echo 'Salesman Weekend | ';
echo 'Day Use (10am - 6pm) | ';
echo 'Day Use (6pm - 10am) | ';
echo 'Day Use Extra Hour | ';
echo 'Action | ';
echo '
';
$result = db_query("SELECT rtid,type,price, we_price, member_price, salesman_price, salesman_we_price, day_use, day_use_e, day_use_extra FROM room_rates");
$row = $result-> fetch_object();
if($result-> num_rows > 0){
do{
$rtid = $row-> rtid;
$type = $row-> type;
$price = $row-> price;
$we_price = $row-> we_price;
$member_price = $row-> member_price;
$salesman_price = $row-> salesman_price;
$salesman_we_price = $row-> salesman_we_price;
$day_use = $row-> day_use;
$day_use_e = $row-> day_use_e;
$day_use_extra = $row-> day_use_extra;
echo '';
echo '| '.ucwords($type).' | ';
echo 'RM '.$price.' | ';
echo 'RM '.$we_price.' | ';
echo 'RM '.$member_price.' | ';
echo 'RM '.$salesman_price.' | ';
echo 'RM '.$salesman_we_price.' | ';
echo 'RM '.$day_use.' | ';
echo 'RM '.$day_use_e.' | ';
echo 'RM '.$day_use_extra.' | ';
echo 'Edit | ';
echo '
';
}while($row = $result-> fetch_object());
}
echo '
';
break;
case 'tax':
$result = db_query("SELECT value FROM setting WHERE type='tax' ");
$row = $result-> fetch_object();
$tax = $row-> value;
echo 'Update Tax
';
echo '';
break;
case 'SST':
$result = db_query("SELECT value FROM setting WHERE type='SST' ");
$row = $result-> fetch_object();
$tax_SST = $row-> value;
echo 'Update SST
';
echo '';
break;
case 'LSC':
$result = db_query("SELECT value FROM setting WHERE type='lsc' ");
$row = $result->fetch_object();
$lsc = $row->value;
echo 'Update Local Service Charge (start from 1-1-25 MBI charges per room per night)
';
echo '';
break;
case 'room':
$count = 0;
echo 'Change room type/number
';
echo '';
echo '';
//$result = db_query("SELECT rid, room_num, type FROM room_list ORDER BY room_num ASC"); //abb 6-4-12 sort by room number
$result = db_query("SELECT rid, room_num, type FROM room_list ORDER BY room_num ASC"); //abb 6-4-12 sort by room number
$row = $result-> fetch_object();
if($result-> num_rows > 0){
$rtype = $row-> type;
do{
$rid = $row-> rid;
$type = $row-> type;
$room_num = $row-> room_num;
// if ($type != $rtype) //abb 14-5-12 if different room type
if ($count == 11) //abb 14-5-12 if different room type
{
$count = 0;
echo '
'."\n";
}
$count = $count + 1;
echo '| ';
echo ' '.$room_num.' ';
echo ''.ucwords($type).' ';
echo ' | ';
$rtype = $type;
}while($row = $result-> fetch_object());
}
echo '
';
echo '
';
break;
default:
break;
}
require_once('footer.php');
?>