Home / Questions / 100251
Accepted
Hector Hernandez
Asked: 2020-09-06 22:53:27 +0800 CST 2020-09-06 22:53:27 +0800 CST

Filtering associated table records that match the current Rails session

  • 772

I have been trying to create a filter for the users who applied for X job offer, but to have a better overview I will explain my association and my problem:

class Job < ApplicationRecord
  belongs_to :enterprise
  has_many   :job_candidates
end

class JobCandidate < ApplicationRecord
  belongs_to  :job
  belongs_to  :user
end

class User < ApplicationRecord
  has_many :job_candidates
end

class User < ApplicationRecord
  has_many :jobs
end

I have the users (User)who apply for the jobs (Job)that the companies (Enterprise)publish, for this at the moment in which the user X applies to X job, within the table (JobCandidate)it is stored, who applied for the offer (user_id), since the job was applied for (job_id), only those 2 fields, now, therefore JobCandidateit is related to the User and Job models, now within the Enterprise dashboard I need to print all those records JobCandidatewhere their relationship job_candidate.user.enterprise.idcoincides with the current user, however the first idea that came to me was to perform a scope, but apparently within the scope of the model I can't compare it to a current session ie(current_enterprise), therefore the controller comes to mind, but I can't filter that data, something that would be like:

def dashboard
  @job_candidates = JobCandidate.all.where(job_candidate.job.enterprise_id: current_enterprise.id)
end

It is an idea that is quite vague, because I have not been able to come up with an exact way to compare the id of the companies of the jobs to which they applied (job.enterprise.id)with the session of the current company (current_enterprise), the idea is to filter both the jobs and the users to who the company will see who applied for their jobs

I do not know if I have managed to make myself understood, but I will be very grateful if you can give me a better idea, greetings!

ruby-on-rails

1 Answers

  1. Best Answer

    To obtain the users ( User) who applied for a specific job ( Job), it would be better to consult the model directly Useror, through a relation has_many :through, the model Job; so you will get all the users for a certain job in an object ActiveRecord::Relation.

    The first thing you should do is set the relationship has_many :throughon the model Job:

    class Job < ApplicationRecord
  belongs_to :enterprise
  has_many   :job_candidates
  has_many   :users, through: job_candidates
end

    With this relation you will be able to obtain the users for a job without the need to explicitly use the model JobCandidates; For example, you could get the users who have applied for the job with id = 1:

    @job   = Job.find(1)
@users = @job.users

    Or, if you prefer it in one line:

    @users = Job.find(1).users

    The result will be a collection ( ActiveRecord::Relation) of the objects Userthat are related, through the model JobCandidates, to the selected object Job(ie with id = 1).

    So, assuming you want to display all the jobs at a particular company on one page, and each job shows the users who have applied, you would do the following:

    Controller

    def show
  @enterprise = Enterprise.find(params[:id])
end

    Here I assume that you arrive at the page through a indexwhere all the listed companies are, where you click on one, which would take you to the action showof the other controller, passing idthe company as a parameter.

    In case your way of getting idfrom the company is different, just change it in the action of the controller you are using (in my example the action is show).

    View

    <% @enterprise.jobs.each do |job| %>
  <div>
    <h3><%= job.title %><h3>
    <ul>
      <% job.users.each do |user| %>
        <li><%= user.name %></li>
      <% end %>
    </ul>
  </div>
<% end %>

    I am assuming that the model Jobhas an attribute called titleand the model Userhas an attribute calledname.

    The result will be a section ( div) for each job ( Job), which contains the list of users ( User) who have applied for that job.

    • 0