OSDN Git Service

t#32471:add profiles
[pettanr/pettanr.git] / app / models / panel_picture.rb
index de574a7..8aa6809 100644 (file)
@@ -186,6 +186,14 @@ class PanelPicture < ActiveRecord::Base
     Kaminari.paginate_array(Array.new(PanelPicture.where(self.himlist_where(au)).includes(PanelPicture.list_opt).count, nil)).page(page).per(page_size)
   end
   
+  def self.list_by_panel_where panel_id
+    ['panel_pictures.panel_id = ?', panel_id]
+  end
+  
+  def self.list_by_panel panel_id, roles, page = 1, page_size = self.default_page_size
+    self.where(self.list_by_panel_where(panel_id)).includes(self.list_opt).order('panel_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
   def self.list_opt
     {:panel => {:author => {}}, :picture => {:artist => {}, :license => {}} }
   end