= DATE_FORMAT(checkin, '%Y-%m-%d') AND '$cur_sel_date' <= DATE_FORMAT(checkout, '%Y-%m-%d')"; $table = 'room_log'; } if($table == ''){ $table = 'room_log'; } //echo $condition; echo '
'; //abb 14-6-12 the input below is for hms.js first initialization for replace g error echo ''; echo ''; //echo 'date:'.$date; if($_POST['date'] != NULL) { $cur_sel_date = strtotime($_POST['date']); //echo $cur_sel_date; } else { $cur_sel_date = strtotime(date('Y-m-d H:i:s')); //abb 14-5-12 H:i:s needed for day use function //echo $cur_sel_date; } if ($_SESSION['sortlog_cat'] == '') { $sortby = 'ORDER BY log_id DESC'; } else { $cat = $_SESSION['sortlog_cat']; if ($_SESSION['sortlog_'.$cat] == 1) { $upis1 = 'ASC'; } else { $upis1 = 'DESC'; } $sortby = 'ORDER BY '.$cat. ' ' .$upis1; } # /* echo '
'; if($search_status == '0'){ echo '

Search Historic Reservation

'; } if($search_status == '1'){ echo '

Search Active Reservation

'; } // guest name echo '
'; //echo $_SERVER['REQUEST_URI']. ; echo ' '; echo ''; echo '
'; //room no. echo '
'; echo ' '; echo ''; echo '
'; // phone search echo '
'; echo ''; echo ''; echo '
'; // log search echo '
'; echo ''; echo ''; echo '
'; // search by date log_date_form($search_status); //$ymd_cur_sel_date = date('Y-m-d', $cur_sel_date); echo '
'; */ if($status == 0){ echo 'historic'; if ($table == 'guest') { $query = "SELECT guest_id FROM $table WHERE "; $sortby = ' ORDER BY guest_id ASC '; } else { $query = "SELECT log_id FROM $table WHERE status!=1 AND status!=3 AND status!=4 AND type != 'cleaning' AND type != 'maintenance'"; } } if($status == 1){ echo 'active'; //$query = "SELECT log_id FROM room_log WHERE status != 0 AND type != 'cleaning' AND type != 'maintenance' $condition "; $query = "SELECT log_id FROM $table WHERE status != 0 AND type != 'cleaning' AND type != 'maintenance'"; } if($status == 2){ echo 'active'; //$query = "SELECT log_id FROM room_log WHERE status != 0 AND type != 'cleaning' AND type != 'maintenance' $condition "; $query = "SELECT log_id FROM $table WHERE gst = 1 AND type != 'cleaning' AND type != 'maintenance'"; } $query = $query . ' '.$condition; # if ($_SESSION['pagingquery'] != '') { //echo $_SESSION['pagingquery'] . '****
'; view_reservation($status, $_SESSION['pagingquery'], $sortby, $chk_level, $pageno, $table); $_SESSION['pagingquery'] = ''; } else { view_reservation($status, $query, $sortby, $chk_level, $pageno, $table); } //view_reservation($status, $condition1, $condition2, $cur_sel_date); echo '
'; break; case 'room' : //echo 'list room'; $date = $_POST['date']; view_booking($list, $date); break; case 'maintenance': echo '

Maintenance Log

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $result = db_query("SELECT guest_id, checkin, checkout, type, status, room_id FROM room_log WHERE type='maintenance' OR status='3'"); $row = $result-> fetch_object(); if($result-> num_rows > 0){ do{ $guest_id = $row-> guest_id; $start_time = $row-> checkin; $end_time = $row-> checkout; $type = $row-> type; $status = $row-> status; $rid = $row-> room_id; $room = db_query("SELECT room_num FROM room_list WHERE rid = '$rid' "); $row = $room-> fetch_object(); $room_num = $row-> room_num; ?> fetch_object()); } echo '
Room No. Start TimeEnd TimeStatus
'; break; case 'cleaning': echo '

Today\'s Cleaning Log

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $today = date('Y-m-d'); $result = db_query("SELECT guest_id, checkin, checkout, type, status, room_id FROM room_log WHERE DATE_FORMAT(checkin,'%Y-%m-%d')='$today' AND (status='4' OR type='cleaning')"); $row = $result-> fetch_object(); if($result-> num_rows > 0){ do{ $guest_id = $row-> guest_id; $start_time = $row-> checkin; $end_time = $row-> checkout; $type = $row-> type; $status = $row-> status; $rid = $row-> room_id; $room = db_query("SELECT room_num FROM room_list WHERE rid = '$rid' "); $row = $room-> fetch_object(); $room_num = $row-> room_num; ?> fetch_object()); } echo '
Room No. Start TimeEnd TimeStatus
'; break; } require_once('footer.php'); ?>