I'm trying to update the available rooms in a form, by making a POST request to my controller when arrival and departure dates are filled in the same form.
Unfortunately my inserted HTML doesn't seem to render, but I don't see where the bug is.
Code
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
hotels/rooms_availability.js.erb
var selectList = document.getElementById('reservation_room_id')
function empty() {
selectList.innerHTML = "";
}
empty();
<% unless @rooms.empty? %>
<% @hotel_cats.each do |cat|%>
selectList.insertAdjacentHTML('beforeend', '<optgroup label=<%= cat.name %>>');
<% cat.rooms.each do |room|%>
<% if @rooms.include? room %>
selectList.insertAdjacentHTML('beforeend', '<option value="<%= room.id %>"><%= room.name %></option>');
<% end %>
<% end %>
selectList.insertAdjacentHTML('beforeend', '<optgroup>');
<% end %>
<% end %>
Print screen of form html
<div class="form-group grouped_select optional reservation_room_id">
<select class="grouped_select optional" name="reservation[room_id]" id="reservation_room_id">
<option value=""></option>
<optgroup label="room category 1">
<option value="6">1</option>
<option value="7">2</option>
<option value="8">3</option>
</optgroup>
<optgroup label="room category 2">
<option value="16">1</option>
</optgroup>
</select>
</div>
logs
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.3ms) SELECT "hotels".* FROM "hotels" WHERE "hotels"."id" = $1 LIMIT $2 [["id", 22], ["LIMIT", 1]]
↳ app/controllers/hotels_controller.rb:125
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:115
Room Load (1.7ms) 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:115
Rendering hotels/rooms_availability.js.erb
Rendered hotels/rooms_availability.js.erb (0.6ms)
Completed 200 OK in 53ms (Views: 19.3ms | ActiveRecord: 3.3ms)
Aucun commentaire:
Enregistrer un commentaire