fetch_object();
if($result-> num_rows > 0)
{
$log_id = $row-> log_id;
$guest_id = $row-> guest_id;
$checkin = $row-> checkin;
$checkin_strttYmd = strtotime(date('Y-m-d', strtotime($checkin))); //abb 20-8-12 in date('Y-m-d H:i:s') format
$checkout = $row-> checkout;
$checkout_strttYmd = strtotime(date('Y-m-d', strtotime($checkout))); //abb 20-8-12 in date('Y-m-d H:i:s') format
$status = $row-> status;
$room_id = $row-> room_id;
//echo '
line 110-logid-',$log_id,'
';
//echo $status.'
';
$room_num = return_value('room_list','room_num',"WHERE rid = '$room_id'");
//echo $choosen_date_strttYmd, ' - ', $checkin_strttYmd, ' - ', $checkout_strttYmd;
if ($choosen_date_strttYmd >= $checkin_strttYmd && $choosen_date_strttYmd <= $checkout_strttYmd && $status != 0)
{
/*
//abb 20-08-12 check if booked but not checkout
if($status == 1)
{
//abb 20-8-12 Even status 2 reserved but no log request then still force FORM
if($_REQUEST['log'] != '')
{
$action = 'info';
} else {
$action = 'info';
}
} else {
$action = 'info';
}
*/
//abb 20-08-12 check if reserved
if($status == 2 && $_REQUEST['log'] !='')
{
$action = 'info';
} else {
//abb 20-8-12 Even status 2 reserved but no log request then still force FORM
if($_REQUEST['log'] != '')
{
$action = 'info';
} else {
$action = 'info';
//$status = 0;
}
}
//echo 'line135';
} else {
$action = 'form';
}
//}while($row = $result-> fetch_object());
} else{ // if no previous record
$action = 'form';
$status = 0;
$room_id = $rid;
}
} //rtype
switch($action)
{
case 'info':
if ($_REQUEST['log'] != '')
{
$log_id = $_REQUEST['log'];
$status = return_value('room_log','status',"WHERE log_id='$log_id'");
}
if($_REQUEST['log'])
{
$log_id = $_REQUEST['log'];
$status = return_value('room_log','status',"WHERE log_id='$log_id'");
} else {
if ($status == 2)
{
$action = 'info';
$status = 1;
}
}
//echo $status;
//echo ' Status test : ', $status,'';
switch ($status)
{
default:
//TBA
break;
case '1': //booked
room_status_update($log_id, $room_id, $action, $status, $gid);
echo '';
booked_info($log_id, $room_num, $status, $user_id, $chk_level, $rid);
echo '
';
break; //end case 1
case '2': //reserved
room_status_update($log_id, $room_id, $action, $status, $gid);
echo '';
booked_info($log_id, $room_num, $status, $user_id, $chk_level, $rid);
echo '
';
break;
case '4':
room_status_update($log_id, $room_id, $action, $status, $gid);
$notes = return_value('room_log','notes',"WHERE log_id='$log_id'");
echo '';
echo '
Cleaning in progress.
';
echo '
Room No. : '. $room_num.'
';
echo '
Start Time : '.date('d M Y h:i A', strtotime($checkin)).'
' ;
echo '
Estimated End Time : '. date('d M Y h:i A', strtotime($checkout)) .'
';
echo '
';
echo '
';
echo '
Maintenance In Progress.
';
echo '
Room No. : '. $room_num.'
';
echo '
Start Time : '. date('d M Y h:i A', strtotime($checkin)) .'
' ;
echo '
Estimated End Time : '. date('d M Y h:i A', strtotime($checkout)) .'
';
echo '
';
echo '
';
booked_info($log_id, $room_num, $status, $user_id, $chk_level, $rid);
echo '
';
break; //end case 1
} //end switch status
break;
case 'form':
?>
= $checkin_strttYmd && $choosen_date_strttYmd <= $checkout_strttYmd)
{
room_status_update($log_id, $room_id, $action, $status, $gid);
}else{
room_status_update($log_id, $room_id, $action, 0, $gid);
}
}
if ($room_list_status != 'vip')
{
if (force_rid_ifbooked($rid)) //abb 27-8-12 force checkout screen even forgot checkout
{
$force_logid = force_rid_ifbooked($rid);
echo '';
exit();
} else {
echo '';
echo '';
search_room_management($log_id, $room_id, $action, $status,$atype, $gid, $rtype);
echo '
';
}
} else {
$room_num = return_value('room_list','room_num',"WHERE rid = '$room_id'");
$room_type = return_value('room_list','type',"WHERE rid = '$room_id'");
echo 'VIP!!! NO BOOKING / RESERVATION ALLOWED ON ROOM ',$room_num,' ( ',strtoupper($room_type),' ROOM ).
';
echo 'Downgrade to normal room?';
}
break;
}
if ($updateme == 1)
{
db_query("LOCK TABLES room_log WRITE");
db_query("UPDATE room_log SET gst = '0' WHERE log_id='$log_id'");
db_query("UNLOCK TABLES");
}
if ($updateme == 2)
{
db_query("LOCK TABLES room_log WRITE");
db_query("UPDATE room_log SET gst = '1' WHERE log_id='$log_id'");
db_query("UNLOCK TABLES");
}
$indicator = return_value('room_log', 'gst', "WHERE log_id='$log_id'");
/*echo 'version ';
echo '2.0 update-',$indicator,'
';*/
require_once('footer.php');
?>