+ 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
+