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;
}
