Kaminari.paginate_array(Array.new(Sheet.where(self.himlist_where(au)).count, nil)).page(page).per(page_size)
end
+ def self.list_by_story story_id, roles, page = 1, page_size = self.default_page_size
+ self.where(StorySheet.list_by_story_where(story_id)).includes(
+ {:story_sheets => {}}
+ ).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_by_panel panel_id, roles, page = 1, page_size = self.default_page_size
+ self.where(SheetPanel.list_by_panel_where(panel_id)).includes(
+ {:sheet_panels => {}}
+ ).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_by_author_where author_id
+ ['sheets.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('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
def self.list_opt
{:sheet_panels => {:panel => {}}, :author => {} }
end