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