Creating JOIN tables within the create action involves assigning related ids to each table

Question

Creating JOIN tables within the create action involves assigning related ids to each table

I am currently working on a room reservation system that involves including options for each room. Data related to the options and their join table, reservation_options, are successfully inserted into the params. However, I am facing an issue with assigning the option_quantity value of the join table as it triggers an error message stating "no implicit conversion of Symbol into Integer".

Since the options are dynamically generated based on the selected room_type in the form, I attempted to handle them within the create action. Unfortunately, I encountered difficulties iterating over the params and constructing them (refer to the create action for my approach).

Params

 // Parameters content here

Models

// Models content here

Reservation controller

// Reservation controller content here

output 1 for reservation_option

=> <ActionController::Parameters {"option_id"=>"110", "option_quantity"=>"1"} permitted: false>

output 2 for reservation_option

=> #<ActiveRecord::AssociationRelation [#<ReservationOption id: 62, option_id: 110, reservation_id: 142, option_quantity: nil, created_at: "2019-10-25 12:27:45", updated_at: "2019-10-25 12:27:45">]>

javascript jquery ruby-on-rails activerecord

Answer 1

Answer №1

I believe this code snippet may be the solution you are seeking:

class ReservationsController < ApplicationController

  def create
    @user = current_user
    @hotel = Hotel.find(params[:hotel_id])
    @reservation = @hotel.reservations.new(reservation_params)
    if @reservation.save
      params[:reservation_options_attributes].each do |reservation_option|
        if @option = Option.find_by(id: reservation_option[:option_id])
          @reservation.options << @option
          reservation_option = @reservation.reservation_options.where(option: @option)
          reservation_option.update(option_quantity: reservation_option[:option_quantity])
        end
      end
      authorize @reservation
      redirect_to hotel_path(@hotel)
    else
      @room_type_list = @hotel.room_types
      render 'new'
    end
  end

This code assumes that Reservation belongs_to :hotel, a relationship not currently depicted in your Reservation model. It also presumes that Hotel has_many :reservations.

In addition, it is assumed that your ReservationOption model contains an attribute named option_quantity. Such an attribute would logically belong there.

Answer 2

I believe this code snippet may be the solution you are seeking:

class ReservationsController < ApplicationController

  def create
    @user = current_user
    @hotel = Hotel.find(params[:hotel_id])
    @reservation = @hotel.reservations.new(reservation_params)
    if @reservation.save
      params[:reservation_options_attributes].each do |reservation_option|
        if @option = Option.find_by(id: reservation_option[:option_id])
          @reservation.options << @option
          reservation_option = @reservation.reservation_options.where(option: @option)
          reservation_option.update(option_quantity: reservation_option[:option_quantity])
        end
      end
      authorize @reservation
      redirect_to hotel_path(@hotel)
    else
      @room_type_list = @hotel.room_types
      render 'new'
    end
  end

This code assumes that Reservation belongs_to :hotel, a relationship not currently depicted in your Reservation model. It also presumes that Hotel has_many :reservations.

In addition, it is assumed that your ReservationOption model contains an attribute named option_quantity. Such an attribute would logically belong there.

Creating JOIN tables within the create action involves assigning related ids to each table

Answer №1

Similar questions

applying different styles to various elements

Limiting the jQuery UI Datepicker to only allow past dates: How to make it happen?

Vuetify's data table now displays the previous and next page buttons on the left side if the items-per-page option is hidden

An issue arises when trying to import the modal popup

Another option instead of using $index for displaying serial numbers in ng-repeat

What is the best way to efficiently load all of my web applications within the web application that I am currently developing?

Encountering an issue when trying to upload a file for the second time

Receiving an inaccurate value from the input with type='number' attribute

Stop the automatic hiding of the sticky header when reaching the bottom of the page

What is the best way to ensure that a specific number of XHR callbacks have successfully completed before proceeding with further actions?

What steps can be taken to resolve the error message "Module '../home/featuredRooms' cannot be found, or its corresponding type declarations"?

Various conditional statements based on the dropdown menu choice

Python sends back a list containing garbled characters to Ajax

Why is the state object empty in this React Native function?

Is it possible to directly utilize functions from an imported JavaScript library, such as Change Case, within the template of a Vue component?

Initial page load experiencing issues with paroller.js functionality

The placement is set to absolute, with a designated height

Is my implementation of Model and Views in backbone.js accurate?

Draggable resizing of the Accordion component in React.js using Material-UI

What could be the reason for the sudden failure of my jQuery + AJAX functionality?