include_once dirname(__FILE__) . "/OTA/advancedFeatures/adv_functions.php";
$profileid = modify_advProfile(0, 0, 1, $firstname, $middlename, $lastname, '0000-00-00', 'M', 'en', 'en', '', 'Profile auto created from Guest Check-In');
modify_advPhone(0, 0, $profileid, PTT_VOICE, PUT_CONTACT, PLT_DIRECT, "", "", $phone, "");
modify_advDocument(0, 0, $profileid, DOC_NID, '0000-00-00', '000-00-00', "", "", $nationality, $guestname, $localid, "");
modify_advEmail(0, 0, $profileid, 0, EAT_PERSONAL, $email, "");
modify_advAddress(0, 0, $profileid, AUT_CONTACT, CLT_HOME, "", "", "", "", $address, $town, "", $countrycode, $postal_code);
$guestid = $profileid;
} else {
$guestid = modify_guest(0, $lastname, $firstname, $middlename, '', $localid, '', $countrycode, $address, $town, $postal_code, $phone, $email, '', '', '', $nationality);
}
}
if (!$guestid) {
// break out of the loop if no guest ID set.
break;
}
$book_id = modify_booking($book_id, $res_id, $bill_id, $guestid, $no_adults, $no_child6_12, $no_child1_5, $no_babies, $checkindate, $checkoutdate, $roomid, $roomtypeid, $ratesid, $instr, $checkedin_by, $checkedin_date, $checkedout_by, $checkedout_date, $cctype, $CCnum, $expiry, $CVV, $voucher_no, $book_status, $details_id);
if (is_ebridgeCustomer()) {
include_once dirname(__FILE__) . "/OTA/advancedFeatures/adv_functions.php";
CustomPagesFormRead(HTL_PAGE_BOOK, $book_id);
}
if (!$book_id) {
echo "<div align=\"center\"><h1>" . $_L['REG_error1'] . "</h1></div>";
} else {
if ($action == $_L['REG_checkinbox']) {
update_booking_status($book_id, BOOK_CHECKEDIN);
} else {
if ($action == $_L['REG_Rcheckout']) {
update_booking_status($book_id, BOOK_CHECKEDIN);
update_room_status($roomid, BOOKED);
update_reservation_status($res_id, RES_CHECKIN);
if ($details_id) {
/**
* Get the booking detail by the reservation id
* This is the combination of user detail, country detail
* @ingroup BOOKING_MANAGEMENT
* @param $res_id [in] Reservation ID
* @param $resDetail_id [in] Reservation Details ID
* @param $booking [in/out] result array
*
* @return number of elements in booking
*/
function get_booking_byresid($res_id, $resDetail_id, &$booking)
{
global $conn;
if (!$conn) {
$conn = connect_Hotel_db(HOST, USER, PASS, DB, PORT);
}
if (!$conn) {
return 0;
}
$booking = array();
$sql = "SELECT book_id FROM booking WHERE reservation_id=" . strip_specials($res_id) . "and res_det_id=" . $resDetail_id;
// print "Res id".$res_id."<br/>";
$stmt = $conn->prepare($sql);
$results = $stmt->execute();
$row = $stmt->fetch();
if ($row['book_id']) {
// print "Found".$res_id."<br/>";
return get_booking($row['book_id'], $booking);
}
$stmt = null;
$res = array();
$book_id = 0;
$today = date("d/m/Y H:i");
if (get_reservation($res_id, $res, $resDetail_id)) {
// print "Not found load new".$res_id."<br/>";
switch ($res['status']) {
case RES_QUOTE:
$book_status = BOOK_REGISTERED;
break;
case RES_ACTIVE:
case RES_CHECKIN:
$book_status = BOOK_CHECKEDIN;
break;
case RES_CHECKOUT:
$book_status = BOOK_CHECKEDOUT;
break;
case RES_CANCEL:
case RES_EXPIRE:
case RES_VOID:
case RES_CLOSE:
$book_status = BOOK_CLOSE;
break;
default:
$book_status = BOOK_CHECKEDIN;
}
$book_id = modify_booking(0, $res_id, $res['bill_id'], $res['guestid'], $res['no_adults'], $res['no_child6_12'], $res['no_child1_5'], $res['no_babies'], $res['checkindate'], $res['checkoutdate'], $res['roomid'], $res['roomtypeid'], $res['ratesid'], $res['instructions'], $_SESSION['userid'], $res['checkedin_date'], '', '', $res['cctype'], $res['CCnum'], $res['expiry'], $res['CVV'], $res['voucher_no'], $book_status, $resDetail_id);
if ($book_id && $res['roomid']) {
update_room_status($res['roomid'], BOOKED);
}
}
if (!$book_id) {
return 0;
}
return get_booking($book_id, $booking);
}
