+ scope :with_scroll, -> do
+ includes(:scroll)
+ end
+
+ scope :find_index, -> do
+ with_scroll.where(Scroll.arel_table[:visible].gt 0).references(:scroll)
+ end
+
+ scope :find_private, -> (operators) do
+ with_scroll.where(Scroll.arel_table[:author_id].eq operators.author.id).references(:scroll)
+ end
+
+ scope :by_scroll, -> (scroll_id) do
+ where(scroll_id: scroll_id)
+ end
+
+ scope :find_by_scroll, -> (scroll_id) do
+ find_index.by_scroll(scroll_id).references(:scroll)
+ end
+
+ scope :find_by_panel, -> (panel_id) do
+ find_index.where(panel_id: panel_id).references(:scroll)
+ end
+
+ scope :find_by_author, -> (author_id) do
+ find_index.where(Scroll.arel_table[:author_id].eq author_id).references(:scroll)
+ end
+
+ scope :find_play, -> (scroll_id) do
+ find_by_scroll(scroll_id)
+ end
+
+ scope :find_private_play, -> (scroll_id, operators) do
+ find_private(operators).by_scroll(scroll_id)
+ end
+