我想为“created_at”创建一个范围搜索函数(介于created_at_from和created_at_to之间)。但是这个函数只实现了created_at_from,而没有实现created_at_to,这意味着如果created_at_from:12.01.2019和created_at_to:01.01.2020,则还显示了01.01.2020之后的数据。如何为日期范围创建搜索功能?
下面是我的代码:paper.rb
scope :search, -> (search_params) do
return if search_params.blank?
box_name(search_params[:box])
.created_at_from(search_params[:created_at_from])
.created_at_to(search_params[:created_at_to])
end
scope :box_name, -> (box) { where('box LIKE ?', "%#{box}%") if box.present? }
scope :created_at_from, -> (from) { where('? <= created_at', from) if from.present? }
scope :created_at_to, -> (to) { where('? <= created_at', to) if to.present? }
papers_controller.rb
def index
@search_params = papaer_search_params
@papers = Paper.search(@search_params).order(created_at: "DESC")
end
.
.
.
def paper_search_params
params.fetch(:search, {}).permit(:box, :created_at_from, :created_at_to)
end
index.html.erb
<%= form_with(scope: :search, url: index_papers_path, method: :get, local: true) do |f| %>
<%= f.label :box, "Box" %>
<%= f.text_field :box, value: @search_params[:box], class: 'form-control' %>
<span id='date-form' class='input-custom'>
<%= f.label :created_at, t('views.payment.date_from').html_safe + ':' %>
<%= f.text_field :created_at_from, {value: @search_params[:created_at_from], :class => 'form-control datepicker', :required => false} %> ~
<%= f.text_field :created_at_to, {value: @search_params[:created_at_to], :class => 'form-control datepicker', :required => false} %>
<%= submit_tag 'Search', class: "button" %>
1条答案
按热度按时间n9vozmp41#
您的
from
和to
查询是相等的,因此其中一个查询不能按预期工作。只需将它们更改为: