function createRoomBooking($bean, $khachsan = '')
{
global $db;
$sql = "\r\n SELECT \r\n a.id \r\n FROM\r\n `roombookings` a \r\n JOIN `hotels_roombookings_c` b \r\n ON a.`id` = b.`hotels_rooc1a7ookings_idb` \r\n AND b.`deleted` = 0 \r\n AND b.`hotels_rooc622shotels_ida` = '{$khachsan->ks_id}' \r\n JOIN `groupprograroombookings_c` c \r\n ON c.`groupprogr952fookings_idb` = a.`id` \r\n AND c.`deleted` = 0 \r\n AND c.`groupprogra66erograms_ida` = '{$bean->id}' \r\n WHERE a.`deleted` = 0 \r\n ";
$RoomBooking = new RoomBookings();
$result = $db->query($sql);
while ($row = $db->fetchByAssoc($result)) {
$RoomBooking->id = $row['id'];
}
$RoomBooking->groupprogrambookings_name = $bean->groupprogram_code;
$RoomBooking->groupprogra66erograms_ida = $bean->id;
$hotel = new Hotels();
$hotel->retrieve($khachsan->ks_id);
$RoomBooking->hotels_rooc622shotels_ida = $hotel->id;
$RoomBooking->hotels_roombookings_name = $hotel->name;
$RoomBooking->hotel_address = $hotel->address;
$RoomBooking->hotel_tel = $hotel->tel;
$RoomBooking->hotel_fax = $hotel->fax;
$RoomBooking->confirm = 0;
$RoomBooking->name = 'Room Bookings To ' . $hotel->name;
$RoomBooking->assigned_user_name = $bean->assigned_user_name;
$RoomBooking->assigned_user_id = $bean->assigned_user_id;
$return = $RoomBooking->save();
return $return;
}
$check_notify = FALSE;
}
foreach ($focus->column_fields as $field) {
if (isset($_POST[$field])) {
$value = $_POST[$field];
$focus->{$field} = $value;
}
}
foreach ($focus->additional_column_fields as $field) {
if (isset($_POST[$field])) {
$value = $_POST[$field];
$focus->{$field} = $value;
}
}
$focus->name = $mod_strings['LBL_NAME_FIRST'] . '_' . $focus->hotels_roombookings_name;
$focus->save($check_notify);
$return_id = $focus->id;
$deleted_count = 0;
// Save RoombookingsLine
$roombookings_line = array('id' => $_POST['roombooking_line_id'], 'deleted' => $_POST['deleted'], 'type' => $_POST['type'], 'quantity' => $_POST['quantity'], 'price' => $_POST['price'], 'currency' => $_POST['currency'], 'check_in' => $_POST['check_in'], 'check_out' => $_POST['check_out']);
$roombookings_line_count = count($roombookings_line['id']);
for ($i = 0; $i < $roombookings_line_count; $i++) {
$deleted = $roombookings_line['deleted'][$deleted_count];
if (($roombookings_line['type'][$i] == '' || $roombookings_line['type'][$i] == '0') && ($roombookings_line['quantity'][$i] == '' || $roombookings_line['quantity'][$i] == '0') && ($roombookings_line['price'][$i] == '' || $roombookings_line['price'][$i] == '0') && ($roombookings_line['currency'][$i] == '' || $roombookings_line['currency'][$i] == '0') && ($roombookings_line['check_in'][$i] == '' || $roombookings_line['check_in'][$i] == '0') && ($roombookings_line['check_out'][$i] == '' || $roombookings_line['check_out'][$i] == '0')) {
$deleted = 1;
}
$roombookinglines = new RoomBookingsLine();
$roombookinglines->id = $roombookings_line['id'][$i];
$roombookinglines->deleted = $deleted;
$roombookinglines->type = $roombookings_line['type'][$i];
$roombookinglines->quantity = $roombookings_line['quantity'][$i];
