t#32471:add profiles

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

diff --git a/app/models/speech.rb b/app/models/speech.rb
index 2b33f65..7f31064 100644 (file)
--- a/app/models/speech.rb
+++ b/app/models/speech.rb
@@ -100,6 +100,22 @@ class Speech < ActiveRecord::Base
     Kaminari.paginate_array(Array.new(Speech.where(self.list_where()).includes(Speech.list_opt).count, nil)).page(page).per(page_size)
   end
   
+  def self.list_by_speech_balloon_where speech_balloon_id
+    ['speeches.speech_balloon_id = ?', speech_balloon_id]
+  end
+  
+  def self.list_by_speech_balloon speech_balloon_id, roles, page = 1, page_size = self.default_page_size
+    self.where(self.list_by_speech_balloon_where(speech_balloon_id)).includes(self.list_opt).order('speeches.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.list_by_writing_format_where writing_format_id
+    ['speeches.writing_format_id = ?', writing_format_id]
+  end
+  
+  def self.list_by_writing_format writing_format_id, roles, page = 1, page_size = self.default_page_size
+    self.where(self.list_by_writing_format_where(writing_format_id)).includes(self.list_opt).order('speeches.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
   def self.list_opt
     {:speech_balloon => {:panel => {:author => {}}, :balloon => {}, :speech_balloon_template => {}} }
   end