Reputation: 489
In a form, I'm trying to provide the available rooms via a dropdown menu, based on the filled in arrival and departure in that same form. I'm trying to achieve this via the controller action rooms_availability
.
Unfortunately I'm getting the error message
Processing by HotelsController#rooms_availability as JS
Parameters: {"arrival"=>"2019-11-26", "departure"=>"2019-11-27", "id"=>"22"}
User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]]
↳ /Users/username/.rbenv/versions/2.5.3/lib/ruby/gems/2.5.0/gems/activerecord-5.2.3/lib/active_record/log_subscriber.rb:98
Hotel Load (0.2ms) SELECT "hotels".* FROM "hotels" WHERE "hotels"."id" = $1 LIMIT $2 [["id", 22], ["LIMIT", 1]]
↳ app/controllers/hotels_controller.rb:122
CACHE Hotel Load (0.0ms) SELECT "hotels".* FROM "hotels" WHERE "hotels"."id" = $1 LIMIT $2 [["id", 22], ["LIMIT", 1]]
↳ app/controllers/hotels_controller.rb:103
RoomCategory Load (0.3ms) SELECT "room_categories".* FROM "room_categories" WHERE "room_categories"."hotel_id" = $1 [["hotel_id", 22]]
↳ app/controllers/hotels_controller.rb:103
Room Load (0.3ms) SELECT "rooms".* FROM "rooms" WHERE "rooms"."room_category_id" IN ($1, $2) [["room_category_id", 4], ["room_category_id", 9]]
↳ app/controllers/hotels_controller.rb:103
Room Load (0.4ms) SELECT "rooms".* FROM "rooms" WHERE "rooms"."room_category_id" IN (SELECT "room_categories"."id" FROM "room_categories" WHERE "room_categories"."hotel_id" = $1) [["hotel_id", 22]]
↳ app/controllers/hotels_controller.rb:113
Room Load (0.5ms) SELECT DISTINCT "rooms".* FROM "rooms" INNER JOIN "reservations" ON "reservations"."room_id" = "rooms"."id" WHERE "reservations"."hotel_id" = $1 AND (reservations.arrival <= '2019-11-26' AND '2019-11-27' >= reservations.departure) [["hotel_id", 22]]
↳ app/controllers/hotels_controller.rb:113
No template found for HotelsController#rooms_availability, rendering head :no_content
Completed 204 No Content in 406ms (ActiveRecord: 2.1ms)
Code
reservations_controller
def new
@hotel = Hotel.find(params[:hotel_id])
@reservation = @hotel.reservations.new
@room_categories = @hotel.room_categories
@rooms = Room.where(room_category: @room_categories)
authorize @reservation
end
reservations/new.html.erb
<%= simple_form_for [@hotel, @reservation] do |f|%>
<div class="col col-sm-3">
<%= f.input :arrival,
as: :string,
label:false,
placeholder: "From",
wrapper_html: { class: "inline_field_wrapper" },
input_html:{ id: "start_date"} %>
</div>
<div class="col col-sm-3">
<%= f.input :departure,
as: :string,
label:false,
placeholder: "From",
wrapper_html: { class: "inline_field_wrapper" },
input_html:{ id: "end_date"} %>
</div>
<div class="col col-sm-4">
<%= f.input :room_id, collection: @rooms, as: :grouped_select, group_by: proc { |room| room.room_category.name }, label:false %>
<%#= f.input :room_id, collection: @room_categories.order(:name), as: :grouped_select, group_method: :rooms, label:false %>
</div>
<%= f.button :submit, "Search", class: "create-reservation-btn"%>
<% end %>
script for reservations/new.html.erb
<script>
const checkIn = document.querySelector('#start_date');
const checkOut = document.querySelector('#end_date');
const checkInAndOut = [checkIn, checkOut];
checkInAndOut.forEach((item) => {
item.addEventListener('change', (event) => {
checkAvailability();
})
})
function checkAvailability(){
$.ajax({
url: "<%= rooms_availability_hotel_path(@hotel) %>" ,
dataType: 'json',
type: "POST",
data: `arrival=${start_date.value}&departure=${end_date.value}`,
success: function(data) {
console.log('succes')
console.log(data);
},
error: function(response) {
console.log('failure')
console.log(response);
}
});
};
</script>
hotels_controller
def rooms_availability
hotel = Hotel.includes(:rooms).find(params[:id])
arrival = Date.parse room_params[:arrival]
departure = Date.parse room_params[:departure]
time_span = arrival..departure
@unavailable_rooms = Room.joins(:reservations).where(reservations: {hotel: hotel}).where("reservations.arrival <= ? AND ? >= reservations.departure", arrival, departure).distinct
hotel_cats = hotel.room_categories
hotel_rooms = Room.where(room_category: hotel_cats)
@rooms = hotel_rooms - @unavailable_rooms
respond_to do |format|
format.js
end
end
def room_params
params.permit(:arrival, :departure, :format, :id)
end
models
class Reservation < ApplicationRecord
belongs_to :hotel
belongs_to :room
end
class Hotel < ApplicationRecord
has_many :room_categories, dependent: :destroy
has_many :rooms, through: :room_categories
has_many :reservations, dependent: :destroy
end
class RoomCategory < ApplicationRecord
belongs_to :hotel
has_many :rooms, dependent: :destroy
accepts_nested_attributes_for :rooms, allow_destroy: true
end
class Room < ApplicationRecord
belongs_to :room_category
validates :name, presence: true
has_many :reservations, dependent: :destroy
accepts_nested_attributes_for :room_category
end
Upvotes: 2
Views: 747
Reputation: 1722
You need a rooms_availability.js.erb
file. It's trying to render that and not able to find it. It is a similar error to if you have a new action and try to navigate to the new view with out the new.html.erb
.
In the js partial, you can target a div or something and render a partial through that with escape_javascript or something
Upvotes: 2