Customer "' . $guest_name . '" selected. Please continue by selecting room.'; } ?>
Showing room list for date ',date('d-M-Y', $cur_sel_date); $nextday = strtotime("+1 day", $cur_sel_date); echo ' || Next day ( ',date('d-M-Y', $nextday),' )'; //echo ' || Next day'; $previousday = strtotime("-1 day", $cur_sel_date); echo ' || Previous day ( ',date('d-M-Y', $previousday),' )'; echo ''; /*echo '94-',$_SESSION['current_shift_session_sid']; echo '95-', $_SESSION['shift_session_start_sid']; echo '96-',$_SESSION['shift_session_start']; */ // function check out notifications abb 14-5-12 /* $curr = date('Y-m-d H:i:s'); echo '
',$curr; $checkout = date('2012-05-11 17:17:00'); echo '
',$checkout; checkout_timer($curr, $checkout); checkout_timer($curr, $checkout, 1); */ $curr = date('Y-m-d H:i:s'); $currdate = date('Y-m-d H:i:s', $cur_sel_date); //$currdate = date('2012-05-13 12:00:00'); check_today_checkout($currdate); echo '

Show All || Show Available || Show Booked || Show Reserved

'; if ($showroom == 0 || $showroom == '') { //show_room_old($cur_sel_date, $condition); ?> '; $x = 0; // dummy indicator $count = 0; $result = db_query("SELECT rid, rtid, room_num, type, status 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; $i = 0; //print all room id in booked_room table do { $rid = $row-> rid; $rtid = $row-> rtid; $type = $row-> type; $room_num = $row-> room_num; $rlstatus = $row-> status; // if (($type != $rtype) || ($i == 10)) //abb 14-5-12 if different room type if ($count == 9) //abb 14-5-12 break every 10 room { $count = 0; echo ''."\n"; } $count = $count + 1; // abb 14-5-12 start checking status and pass SESSION //echo $room_status.'-'.$room_log_id.'-'.$rid.'
'; chk_current_booking_status($cur_sel_date, $rid); //chk_current_booking_status2($cur_sel_date, $rid); $room_status = $_SESSION['current_room_status']; //echo $_SESSION['current_room_status']; $room_log_id = $_SESSION['current_log_id']; $room_log_id_checkout = $_SESSION['current_room_log_id_checkout']; $_SESSION['current_room_status'] = ''; //abb 14-5-=12 reset $_SESSION['current_room_status']; $_SESSION['current_log_id'] = ''; //abb 14-5-=12 reset $_SESSION['current_log_id']; $_SESSION['current_room_log_id_checkout'] = ''; //abb 14-5-=12 reset $_SESSION['current_log_id']; //echo $room_status; //abs - to take other booking room in same date and same room $o_room_status = $_SESSION['o_current_room_status']; $o_room_log_id = $_SESSION['o_current_log_id']; //$o_room_log_id_checkout = $_SESSION['o_current_room_log_id_checkout']; $_SESSION['o_current_room_status'] = ''; //abb 14-5-=12 reset $_SESSION['current_room_status']; $_SESSION['o_current_log_id'] = ''; //abb 14-5-=12 reset $_SESSION['current_log_id']; //$_SESSION['o_current_room_log_id_checkout'] = ''; //abb 14-5-=12 reset $_SESSION['current_log_id']; echo ''; } $room_log_id = ''; ?>
'; //abb 7-5-15 show guest name and car reg $guest_id = return_value('room_log', 'guest_id', "WHERE log_id = '$room_log_id' AND room_id = '$rid'"); $guest_name_in_short = return_value('guest', 'guest1', "WHERE guest_id = '$guest_id'"); $car_reg = return_value('guest', 'car_reg1', "WHERE guest_id = '$guest_id'"); //echo '
',substr($guest_name_in_short, 0, 10), '...
'; echo '
',$guest_name_in_short, ' 
'; echo '
',$car_reg,' 
'; if ($gid != '') //abb 20-8-12 if gid exits then use for book room { echo '

'.$room_num.'

'; } else { echo '

'.$room_num.'

'; } echo '

'.ucwords($type).'

'; //echo $rid . ' - '. $room_num.'
'; //echo 'o_id/sts:'.$o_room_log_id.'- '.$o_room_status; //echo $room_status.'-'.$room_log_id.'-'.$rid; // check room status in room_list table - abs 2-7-12 $vip_room_check = return_value('room_list','status',"WHERE rid = '$rid'"); if($vip_room_check != 'vip') { if($room_status == '0') { if ($rlstatus == '18'){ // abs 24.7 - if 'Need Cleaning', remove the available status $booking_status = ''; echo 'NC'; }else{ $booking_status = 'available'; echo '

'.$booking_status.'

'; } } if($room_status == '1') { //echo $room_log_id_checkout; if (date("Y-m-d H:i:s", strtotime($room_log_id_checkout)) <= date("Y-m-d H:i:s")) { $booking_status = 'B - N. ChkOut'; } else { $booking_status = 'B'; } echo ''.$booking_status.''; } if($room_status == '3') { $booking_status = 'M'; echo ''.$booking_status.''; } if($room_status == '4') { $booking_status = 'CIP'; echo ''.$booking_status.''; } if($room_status == '6') //abb 20-8-12 day use is 6 { //echo $room_log_id_checkout; if (date("Y-m-d H:i:s", strtotime($room_log_id_checkout)) <= date("Y-m-d H:i:s")) { $booking_status = 'DU - N. ChkOut'; } else { $booking_status = 'DU'; } //$booking_status = 'day use'; echo ''.$booking_status.''; } } else { $booking_status = 'VIP'; echo ''.$booking_status.''; } if ($room_status == 0 || $room_status == 3 || $room_status == 4) {} else { //chkout_notification($room_log_id_checkout, $room_status, $booking_status, $curr, $checkout, $cur_sel_date, $selected_date); echo ''; //chk_paymentneeded_notification($room_log_id); echo ''; } //chk_current_rid_status(strtotime($curr), $rid); //echo ''; //chk other booking here for reservation abb 20-8-13 // chk_current_room_reservation($log_id, $cur_sel_date, $rid, 2); echo ''; ?> '; $rtype = $type; $i = $i + 1; $room_status = '0'; // reset room status to 0 } while($row = $result-> fetch_object()); // abb 14-5-12 End Do While loop for room number printing echo '