module ActsAsShareable::Shareable::SingletonMethods

# File lib/acts_as_shareable/shareable.rb, line 41
def find_by_shared_to(object, *opts)
  joins("LEFT OUTER JOIN shares s ON s.shareable_id = #{self.table_name}.id")
  .where("s.shareable_type =? and s.shared_to_type=? and s.shared_to_id = ?", self, object.class.base_class, object.id)
end

# File lib/acts_as_shareable/shareable.rb, line 47
def find_by_shared_to_and_user(object, user, *opts)
  joins("LEFT OUTER JOIN shares s ON s.shareable_id = #{self.table_name}.id")
  .where("s.user_id = ? AND s.shareable_type =? and s.shared_to_type=? and s.shared_to_id = ?", user.id, self, object.class.base_class, object.id)
end

# File lib/acts_as_shareable/shareable.rb, line 35
def find_shares_by_user(user, *opts)
  joins("LEFT OUTER JOIN shares s ON s.shareable_id = #{self.table_name}.id")
  .where("s.user_id = ? AND s.shareable_type =?", user.id, self)
end