I have this problem:
I have a controller:
def index
if params[:search_employee_by_cpf].present?
@employees = Employee.search_cpf(params[:search_employee_by_cpf]).all
@authorizations = Authorization.search_employee_by_cpf(params[:search_employee_by_cpf]).all
end
end
Authorization Model:
scope :search_employee_by_cpf, -> (cpf) { Authorization.joins("INNER JOIN employees ON employees.id = authorizations.employee_id INNER JOIN people ON employees.person_id = people.id").where("people.cpf LIKE ?", "%#{cpf}%") }
And the Employee model:
scope :search_cpf, -> (cpf) { joins(:person).where("people.cpf LIKE ?", "%#{cpf}%") }
I need two registers / matches, and I need to show permissions for each register / matrix. Actually, show all the authorizations for each register, and this is wrong! I just want to show the permissions of the corresponding register. How to do it?
UPDATE -------------------------
This is part of my submission authority.
<% @authorizations.each do |authorization| %>
<tr>
<td><%= check_box_tag 'authorization[contract_ids][]', authorization.contract_number %></td>
<td><%= authorization.contract_number %></td>
<td><%= number_to_currency authorization.parcel_value %></td>
<td><%= authorization.qtd_parcel %></td>
<td><%= number_to_currency authorization.total_value %></td>
<td>
<%= simple_form_for('/', remote: true) do |f| %>
<%= f.input :value_solve, label: false, placeholder: "Digit a value" %>
<%= f.submit 'Gravar valor' %>
<% end %>
</td>
</tr>
<% end %>
UPDATE 2 -------------------------
def new
if params[:authorization]
@selected_ids = params[:authorization][:contract_ids]
@authorizations = Authorization.where("contract_number in (?)", @selected_ids)
end
@employee = Employee.search_cpf(params[:search_employee_by_cpf])
@refinancing = Refinancing.new
end
new.html.erb (after it is installed and click on the button, go to the new one)
<table class="table table-condensed table-bordered">
<tr>
<td>Name:</td>
<td><%= @employee.person.name %></td>
</tr>
<tr>
<td>CPF:</td>
<td><%= @employee.person.cpf %></td>
</tr>
</table>