验证重叠 Gem 多个范围相互覆盖

我正在使用 Validates_Overlap Gem，可以在这里找到：https://github.com/robinbortlik/validates_overlap https://github.com/robinbortlik/validates_overlap

本质是我有两个房间可以预订。我希望当同一房间已在同一房间中确认预订时进行验证。当预订了其他房间，或者预订了同一房间但尚未确认时，它不应该给我带来错误。

到目前为止我的代码如下

validates :start_time, :end_time, 
    :overlap => {
        :exclude_edges => ["starts_at", "ends_at"],
        :scope => { "bookings.studio_id" => proc {|booking| booking.studio_id}} &&  { "bookings.is_confirmed" => proc {|booking| booking.is_confirmed == true}}
        }, on: :update

这会从我的服务器返回以下内容：

Booking Exists (0.4ms)  SELECT  1 AS one FROM "bookings"  WHERE ((bookings.end_time IS NULL OR bookings.end_time >= '2014-10-23 20:00:00.000000') AND (bookings.start_time IS NULL OR bookings.start_time <= '2014-10-24 03:00:00.000000') AND bookings.id != 9 AND bookings.is_confirmed  = 't') LIMIT 1

还有另外两个预订（使用此 studio_id），但均未得到确认。是什么赋予了？

以下是所有带有 :studio_id => 2 的预订

[#<Booking id: 1, studio_id: 2, engineer_id: 5, is_confirmed: false, title: "", allDay: false, created_at: "2014-10-23 19:59:01", updated_at: "2014-10-23 19:59:01", start_time: "2014-10-23 19:00:00", end_time: "2014-10-23 21:00:00", user_id: nil, booker: "Client", client_id: 3>,
 #<Booking id: 8, studio_id: 2, engineer_id: 1, is_confirmed: false, title: "", allDay: false, created_at: "2014-10-24 03:07:34", updated_at: "2014-10-24 03:07:34", start_time: "2014-10-23 19:00:00", end_time: "2014-10-23 22:00:00", user_id: nil, booker: "Pat Sullivan", client_id: nil>,
 #<Booking id: 9, studio_id: 2, engineer_id: 2, is_confirmed: false, title: "", allDay: false, created_at: "2014-10-24 03:26:17", updated_at: "2014-10-24 03:26:17", start_time: "2014-10-23 20:00:00", end_time: "2014-10-24 03:00:00", user_id: nil, booker: "Client", client_id: 4>]

Update我注意到 studio_id 没有被范围行中的 && 注意到。我怎样才能让范围同时注册？我可以在范围线内完成它还是应该创建一个方法？

我也尝试过更简单的

    validates :start_time, :end_time, 
    :overlap => {
        :exclude_edges => ["starts_at", "ends_at"],
        :scope => "is_confirmed" && "studio_id"
        }, on: :update

这做了同样的事情——只使用后面的“studio_id”

我知道，选项的名称令人困惑，对此我感到抱歉。

我建议您实现名为 :confirmed 的命名范围并将其作为 :query_option 参数传递。

我想，它应该是这样的：

class Booking < ActiveRecord::Base
  scope :confirmed_scope, -> {confirmed: true}  
  validates :start_time, :end_time, :overlap => {
    :exclude_edges => ["starts_at", "ends_at"],
    :scope => "studio_id",
    :query_options => {:confirmed_scope => nil}
    }, on: :update
end

顺便说一句...如果您使用 Rails 4.1，请小心，有一个变化https://github.com/robinbortlik/validates_overlap#rails-41-update https://github.com/robinbortlik/validates_overlap#rails-41-update

简短说明：您作为 :scope 选项传递的内容，其行为类似于属性。但你可以通过 :query_options 扩展它。查询选项内部的内容将在查询链中调用。所以内部会这样调用：

Booking.confirmed_scope.where("starts_at > 18-02-2014 AND ends_at < 20-02-2014 AND studio_id = 1")

现在更清楚了吗？