ruby-on-rails - 从今天开始的 3 天 b/w 目前仅计算今天的两个日期轨道

Question

def self.leave_day 
 self.where("? BETWEEN start_date AND end_date", Date.today).where(status: "Approved").count
end

但我想计算从今天到接下来的 3 天。现在它是计算 b/w 两个日期，如果给出日期范围 (Date.today +1)..(Date.today + 3.days) 它是今天的状态不接受

标签： ruby-on-railsruby-on-rails-5

Answer 1

可以在where.

我认为应该是这样的：

def self.leave_day 
  self.where("start_date >= ? AND end_date <= ?", Date.today, Date.today + 3.days).where(status: "Approved").count
end

来源：https ://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-where