'; //} 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 ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
Normal Rates
WeekdayRM '.$wd_price.'
WeekendRM '.$we_price.'
Day Use (10am - 6pm)RM '.$day_use.'
Day Use (6pm - 10am)RM '.$day_use.'
'; //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 ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; 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 ''; echo ''; echo ''; echo ''; echo ''; if($status == 1){ echo ''; }else{ echo ''; } echo ''; }while($row2 = $result2-> fetch_object()); echo '
Offer/Promotion Rates
Start DateEnd DateNon-Member PriceMember Price
'.date('d M Y', strtotime($start_date)).''.date('d M Y', strtotime($end_date)).'RM '.$non_member.'RM '.$member.'

Edit

Disable

Enable

'; } }while($row = $result-> fetch_object()); } break; case 'rates': echo '

Update Room Rates / night

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; 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 ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; }while($row = $result-> fetch_object()); } echo '
Room typeNormalWeekendMemberSalesmanSalesman WeekendDay Use
(10am - 6pm)
Day Use
(6pm - 10am)
Day Use Extra HourAction
'.ucwords($type).'RM '.$price.'RM '.$we_price.'RM '.$member_price.'RM '.$salesman_price.'RM '.$salesman_we_price.'RM '.$day_use.'RM '.$day_use_e.'RM '.$day_use_extra.'

Edit

'; break; case 'tax': $result = db_query("SELECT value FROM setting WHERE type='tax' "); $row = $result-> fetch_object(); $tax = $row-> value; echo '

Update Tax

'; echo '
'; echo '

'; echo ' %

'; echo '

'; 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 '
'; echo '

'; echo ' %

'; echo '

'; 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 '
'; echo '

'; echo ' per night

'; echo '

'; 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 ''; $rtype = $type; }while($row = $result-> fetch_object()); } echo ''; echo '
'; echo '

'.$room_num.'

'; echo '

'.ucwords($type).'

'; echo '
'; break; default: break; } require_once('footer.php'); ?>