Querying records in the bank via date

Navigation
0

I'm developing a Ruby sales management system with Rails, and the customer needs to query sales through dates on two calendars, which together make up the range of data he wants to get pulled from the database.

The graphical and functional part is being applied through a data helper: select_date (Time.now)% >

My problem is to make this helper really interfere in the table that the data will appear, bringing only the results from the database that are within the range selected by the user.

In order for this select_date (Time.now)% > to talk to my database's date columns, what would I have to add to my code?

    
asked by anonymous 25.10.2018 / 19:25

1 answer

1

You can use the gem Ransack

In your controller: 

def index
  @q = Person.ransack(params[:q])
  @people = @q.result
end

In your view: 

<%= search_form_for(@q) do |f| %>
  <%= f.date_field :data_gteq %>
  <%= f.date_field :data_lteq %>

  <%= f.submit %>
<% end %>
    
30.10.2018 / 21:46
Build Query with JOINS move_uploaded_file returns only FALSE