X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=app%2Fmodels%2Fscroll_panel.rb;h=dbc4de2ca2dc8448a8d16d0fdf6f2edbeadffb6f;hb=HEAD;hp=44885a61910f5badd409e967fba3f551d99d4d42;hpb=f20e087a523621b9e3efc6778509267fc25e5a70;p=pettanr%2Fpettanr.git diff --git a/app/models/scroll_panel.rb b/app/models/scroll_panel.rb index 44885a61..dbc4de2c 100644 --- a/app/models/scroll_panel.rb +++ b/app/models/scroll_panel.rb @@ -8,6 +8,42 @@ class ScrollPanel < Peta::Leaf validates :panel_id, :presence => true, :numericality => true, :existence => {:both => false} validates :t, :presence => true, :numericality => {:greater_than_or_equal_to => 0} + 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 + def supply_default self.scroll_id = nil self.panel_id = nil @@ -15,20 +51,14 @@ class ScrollPanel < Peta::Leaf end def overwrite operators - return false unless operators.author - self.author_id = operators.author.id end - def self.public_list_where + def self.public_list_where list 'scrolls.visible > 0' end def self.by_author_list_includes - { - :scroll => { - :author => {} - } - } + [:scroll => :author] end def self.show_opt