t#32471:add profiles

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

diff --git a/app/models/story.rb b/app/models/story.rb
index 804c586..3d20165 100644 (file)
--- a/app/models/story.rb
+++ b/app/models/story.rb
@@ -123,6 +123,28 @@ class Story < ActiveRecord::Base
     Kaminari.paginate_array(Array.new(Story.where(self.himlist_where(au)).includes(Story.list_opt).count, nil)).page(page).per(page_size)
   end
   
+  def self.list_by_comic_where comic_id
+    ['stories.comic_id = ?', comic_id]
+  end
+  
+  def self.list_by_comic comic_id, roles, page = 1, page_size = self.default_page_size
+    self.where(self.list_by_comic_where(comic_id)).includes(self.list_opt).order('stories.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(StorySheet.list_by_sheet_where(sheet_id)).includes(
+      {:story_sheets => {}}
+    ).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.list_by_author_where author_id
+    ['stories.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('stories.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
   def self.list_opt
     {:comic => {:author => {}} }
   end