2 class Story < Pettanr::Item
6 validates :comic_id, :presence => true, :numericality => true, :existence => {:both => false}
7 validates :title, :presence => true, :length => {:maximum => 100}
8 validates :visible, :presence => true, :numericality => true, :inclusion => {:in => 0..1}
9 validates :t, :presence => true, :numericality => {:greater_than_or_equal_to => 0}
23 def self.valid_encode_columns
24 super.merge ['title', 'description']
29 self.visible = 0 if self.visible.blank?
37 roles = [roles] unless roles.respond_to?(:each)
38 au = Story.get_author_from_roles roles
39 return false unless au
40 self.comic.author_id == au.id
44 if MagicNumber['run_mode'] == 0
45 return false unless guest_role_check(roles)
47 return false unless reader_role_check(roles)
49 return true if self.own?(roles)
58 I18n.t('stories.show.t', :t => self.disp_t)
62 self.disp_t_by_text + ':' + self.title
65 def story_sheets_count
66 StorySheet.where(['story_sheets.story_id = ?', self.id]).count
69 def self.default_page_size
73 def self.max_page_size
77 def self.default_panel_size
81 def self.max_panel_size
85 def self.page prm = nil
91 def self.page_size prm = self.default_page_size
93 page_size = self.max_page_size if page_size > self.max_page_size
94 page_size = self.default_page_size if page_size < 1
102 def self.mylist_where au
103 ['comics.author_id = ?', au.id]
106 def self.himlist_where au
107 ['comics.author_id = ? and stories.visible > 0', au.id]
110 def self.list page = 1, page_size = self.default_page_size
111 Story.where(self.list_where()).includes(Story.list_opt).order('stories.updated_at desc').offset((page -1) * page_size).limit(page_size)
114 def self.mylist au, page = 1, page_size = Author.default_story_page_size
115 Story.where(self.mylist_where(au)).includes(Story.list_opt).order('stories.updated_at desc').offset((page -1) * page_size).limit(page_size)
118 def self.himlist au, page = 1, page_size = Author.default_story_page_size
119 Story.where(self.himlist_where(au)).includes(Story.list_opt).order('stories.updated_at desc').offset((page -1) * page_size).limit(page_size)
122 def self.list_paginate page = 1, page_size = self.default_page_size
123 Kaminari.paginate_array(Array.new(Story.where(self.list_where()).includes(Story.list_opt).count, nil)).page(page).per(page_size)
126 def self.mylist_paginate au, page = 1, page_size = Author.default_story_page_size
127 Kaminari.paginate_array(Array.new(Story.where(self.mylist_where(au)).includes(Story.list_opt).count, nil)).page(page).per(page_size)
130 def self.himlist_paginate au, page = 1, page_size = Author.default_story_page_size
131 Kaminari.paginate_array(Array.new(Story.where(self.himlist_where(au)).includes(Story.list_opt).count, nil)).page(page).per(page_size)
134 def self.list_by_comic_where comic_id
135 ['stories.comic_id = ?', comic_id]
138 def self.list_by_comic comic_id, roles, page = 1, page_size = self.default_page_size
139 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)
142 def self.list_by_sheet sheet_id, roles, page = 1, page_size = self.default_page_size
143 self.where(StorySheet.list_by_sheet_where(sheet_id)).includes(
144 {:story_sheets => {}}
145 ).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
148 def self.list_by_author_where author_id
149 ['stories.author_id = ?', author_id]
152 def self.list_by_author author_id, roles, page = 1, page_size = self.default_page_size
153 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)
157 {:comic => {:author => {}} }
160 def self.list_json_opt
161 {:include => {:comic => {:include => {:author => {}}} }}
164 def self.show sid, roles
166 opt.merge!(Story.show_opt)
167 res = Story.find(sid, opt)
168 raise ActiveRecord::Forbidden unless res.visible?(roles)
172 def self.edit sid, au
174 opt.merge!(Story.show_opt)
175 res = Story.find(sid, opt)
176 raise ActiveRecord::Forbidden unless res.own?(au)
181 {:include => {:comic => {:author => {}} }}
184 def self.show_json_opt
185 {:include => {:comic => {:include => {:author => {}}} }}
188 def self.visible_count
189 Story.count 'visible > 0'
192 def destroy_with_story_sheet
195 self.story_sheets.each do |story_sheet|
196 raise ActiveRecord::Rollback unless story_sheet.destroy
198 raise ActiveRecord::Rollback unless self.destroy
204 def self.new_t comic_id
205 r = Story.max_t(comic_id)
206 r.blank? ? 0 : r.to_i + 1
209 def self.max_t comic_id
210 Story.maximum(:t, :conditions => ['comic_id = ?', comic_id])
213 def self.find_t comic_id, t
214 Story.find(:first, :conditions => ['comic_id = ? and t = ?', comic_id, t])
217 def self.collect_t story
218 r = Story.find(:all, :conditions => ['comic_id = ?', story.comic_id], :order => 't')
224 ary.compact.sort.each do |t|
225 break false unless t == i
228 ary.compact.size == i
231 def self.validate_t story
232 Story.serial?(Story.collect_t(story))
236 Story.update_all('t = t + 1', ['comic_id = ? and t >= ?', self.comic_id, self.t])
239 def lesser_shift old_t
240 self.t = 0 if self.t < 0
241 Story.update_all('t = t + 1', ['comic_id = ? and (t >= ? and t < ?)', self.comic_id, self.t, old_t])
244 def higher_shift old_t
245 nf = Story.find_t(self.comic_id, self.t)
246 max_t = Story.max_t(self.comic_id).to_i
247 self.t = max_t if self.t > max_t
248 Story.update_all('t = t - 1', ['comic_id = ? and (t > ? and t <= ?)', self.comic_id, old_t, self.t])
251 def update_shift old_t
259 def rotate old_t = nil
262 self.t = Story.new_t self.comic_id
269 self.update_shift old_t
275 return nil if self.comic_id == nil
279 def store au, old_t = nil
286 raise ActiveRecord::Forbidden
290 raise ActiveRecord::Rollback unless res
291 res = Story.validate_t(self)
293 self.errors.add :t, 'unserialized'
294 raise ActiveRecord::Rollback
300 def destroy_and_shorten
303 Story.update_all('t = t - 1', ['comic_id = ? and (t > ?)', self.comic_id, self.t])
304 raise ActiveRecord::Rollback unless self.destroy_with_story_sheet