temp

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

diff --git a/app/models/panel.rb b/app/models/panel.rb
index e4e82f3..0f133cb 100644 (file)
--- a/app/models/panel.rb
+++ b/app/models/panel.rb
@@ -1,8 +1,8 @@
 #コマ
 class Panel < ActiveRecord::Base
   belongs_to :author
-  belongs_to :resource_picture
   has_many :scroll_panels
+  has_many :sheet_panels
   has_many :panel_pictures, :dependent => :destroy
   has_many :speech_balloons, :dependent => :destroy
   has_many :ground_pictures, :dependent => :destroy
@@ -188,6 +188,32 @@ class Panel < ActiveRecord::Base
     Kaminari.paginate_array(Array.new(Panel.where(self.himlist_where(au)).count, nil)).page(page).per(page_size)
   end
   
+  def self.list_by_scroll scroll_id, roles, page = 1, page_size = self.default_page_size
+    self.where(ScrollPanel.list_by_scroll_where(scroll_id)).includes(
+      {:scroll_panels => {}}
+    ).order('scroll_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.list_by_sheet sheet_id, roles, page = 1, page_size = self.default_page_size
+    self.where(SheetPanel.list_by_sheet_where(sheet_id)).includes(
+      {:sheet_panels => {}}
+    ).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.list_by_speech_balloon_template speech_balloon_template_id, roles, page = 1, page_size = self.default_page_size
+    self.where(SpeechBalloon.list_by_speech_balloon_template_where(speech_balloon_template_id)).includes(
+      {:speech_balloons => {}}
+    ).order('speech_balloons.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.list_by_author_where author_id
+    ['panels.author_id = ?', author_id]
+  end
+  
+  def self.list_by_author author_id, roles, page = 1, page_size = self.default_page_size
+    self.where(self.list_by_author_where(author_id)).includes(self.list_opt).order('panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
   def self.list_opt
     r = {
       :author => {}