fix: any

[pettanr/pettanr.git] / app / models / sheet_panel.rb

diff --git a/app/models/sheet_panel.rb b/app/models/sheet_panel.rb
index fa0c1b6..4cc2654 100644 (file)
--- a/app/models/sheet_panel.rb
+++ b/app/models/sheet_panel.rb
@@ -12,6 +12,42 @@ class SheetPanel < Peta::Element
   validates :z, :presence => true, :numericality => {:greater_than => 0}
   validates :t, :presence => true, :numericality => {:greater_than_or_equal_to => 0}
   
+  scope :with_sheet, -> do
+    includes(:sheet)
+  end
+  
+  scope :find_index, -> do
+    with_sheet.where(Sheet.arel_table[:visible].gt 0).references(:sheet)
+  end
+  
+  scope :find_private, -> (operators) do 
+    with_sheet.where(Sheet.arel_table[:author_id].eq operators.author.id).references(:sheet)
+  end
+  
+  scope :by_sheet, -> (sheet_id) do 
+    where(sheet_id: sheet_id)
+  end
+  
+  scope :find_by_sheet, -> (sheet_id) do 
+    find_index.by_sheet(sheet_id).references(:sheet)
+  end
+  
+  scope :find_by_panel, -> (panel_id) do 
+    find_index.where(panel_id: panel_id).references(:sheet)
+  end
+  
+  scope :find_by_author, -> (author_id) do 
+    find_index.where(Sheet.arel_table[:author_id].eq author_id).references(:sheet)
+  end
+  
+  scope :find_play, -> (sheet_id) do 
+    find_by_sheet(sheet_id)
+  end
+  
+  scope :find_private_play, -> (sheet_id, operators) do 
+    find_private(operators).by_sheet(sheet_id)
+  end
+  
   def y
     self.attributes['y']
   end