1 class StorySheet < Pettanr::Item
6 validates :story_id, :presence => true, :numericality => true, :existence => {:both => false}
7 validates :sheet_id, :presence => true, :numericality => true, :existence => {:both => false}
8 validates :author_id, :presence => true, :numericality => true, :existence => {:both => false}
9 validates :t, :presence => true, :numericality => {:greater_than_or_equal_to => 0}
30 return false unless au
31 self.author_id = au.id
35 roles = [roles] unless roles.respond_to?(:each)
36 au = StorySheet.get_author_from_roles roles
37 return false unless au
38 self.author_id == au.id
42 if MagicNumber['run_mode'] == 0
43 return false unless guest_role_check(roles)
45 return false unless reader_role_check(roles)
47 return true if self.story.own?(roles)
48 self.story.visible? roles
51 def self.default_sheet_size
55 def self.max_sheet_size
59 def self.offset cnt, prm = nil
61 offset = cnt - 1 if offset >= cnt
62 offset = cnt - offset.abs if offset < 0
63 offset = 0 if offset < 0
67 def self.default_page_size
71 def self.max_page_size
75 def self.page prm = nil
81 def self.page_size prm = self.default_page_size
83 page_size = self.max_page_size if page_size > self.max_page_size
84 page_size = self.default_page_size if page_size < 1
88 def self.play_sheet_where sid
89 ['story_sheets.story_id = ?', sid]
96 def self.mylist_where au
97 ['story_sheets.author_id = ?', au.id]
100 def self.himlist_where au
101 ['story_sheets.author_id = ? and stories.visible > 0', au.id]
104 def self.play_sheet story, au, page = 1
105 ss = StorySheet.where(self.play_sheet_where(story.id)).includes(StorySheet.list_opt).order('story_sheets.t').offset(page -1).limit(1).first
108 Sheet.show(ss.sheet.id, au)
117 def self.list page = 1, page_size = self.default_page_size
118 StorySheet.where(self.list_where()).includes(StorySheet.list_opt).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
121 def self.mylist au, page = 1, page_size = Author.default_story_sheet_page_size
122 StorySheet.where(self.mylist_where(au)).includes(StorySheet.list_opt).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
125 def self.himlist au, page = 1, page_size = Author.default_story_sheet_page_size
126 StorySheet.where(self.himlist_where(au)).includes(StorySheet.list_opt).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
129 def self.list_paginate page = 1, page_size = self.default_page_size
130 Kaminari.paginate_array(Array.new(StorySheet.where(self.list_where()).includes(StorySheet.list_opt).count, nil)).page(page).per(page_size)
133 def self.mylist_paginate au, page = 1, page_size = Author.default_story_sheet_page_size
134 Kaminari.paginate_array(Array.new(StorySheet.where(self.mylist_where(au)).includes(StorySheet.list_opt).count, nil)).page(page).per(page_size)
137 def self.himlist_paginate au, page = 1, page_size = Author.default_story_sheet_page_size
138 Kaminari.paginate_array(Array.new(StorySheet.where(self.himlist_where(au)).includes(StorySheet.list_opt).count, nil)).page(page).per(page_size)
141 def self.play_paginate story, page
142 Kaminari.paginate_array(Array.new(StorySheet.where(self.play_sheet_where(story.id)).includes(StorySheet.list_opt).count, nil)).page(page).per(1)
145 def self.list_by_story_where story_id
146 ['story_sheets.story_id = ?', story_id]
149 def self.list_by_story story_id, roles, page = 1, page_size = self.default_page_size
150 self.where(self.list_by_story_where(story_id)).includes(self.list_opt).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
153 def self.list_by_sheet_where sheet_id
154 ['story_sheets.sheet_id = ?', sheet_id]
157 def self.list_by_sheet sheet_id, roles, page = 1, page_size = self.default_page_size
158 self.where(self.list_by_sheet_where(sheet_id)).includes(self.list_opt).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
172 def self.list_json_opt
176 :sheet => {:include => {:author => {}}}
180 def self.show spid, roles
182 opt.merge!(StorySheet.show_opt)
183 res = StorySheet.find spid, opt
184 raise ActiveRecord::Forbidden unless res.visible?(roles)
188 def self.edit spid, au
190 opt.merge!(StorySheet.show_opt)
191 res = StorySheet.find spid, opt
192 raise ActiveRecord::Forbidden unless res.own?(au)
206 def self.show_json_opt
210 :sheet => {:include => {:author => {}}}
218 def story_sheet_as_json au
219 panel_include = if self.panel and self.panel.visible?(au)
220 {:include => {:author => {}}, :methods => :elements}
222 {:include => {:author => {}}}
224 self.to_json({:include => {:scroll => {:include => {:author => {}}}, :author => {}, :panel => panel_include}})
227 def self.list_as_json_text ary, au
228 '[' + ary.map {|i| i.story_sheet_as_json(au) }.join(',') + ']'
231 def self.new_t story_id
232 r = StorySheet.max_t(story_id)
233 r.blank? ? 0 : r.to_i + 1
236 def self.top_sheet story, author
237 StorySheet.play_list(story, author).first
240 def self.max_t story_id
241 StorySheet.maximum(:t, :conditions => ['story_id = ?', story_id])
244 def self.find_t story_id, t
245 StorySheet.find(:first, :conditions => ['story_id = ? and t = ?', story_id, t])
248 def self.collect_t story_sheet
249 r = StorySheet.find(:all, :conditions => ['story_id = ?', story_sheet.story_id], :order => 't')
255 ary.compact.sort.each do |t|
256 break false unless t == i
259 ary.compact.size == i
262 def self.validate_t story_sheet
263 StorySheet.serial?(StorySheet.collect_t(story_sheet))
267 StorySheet.update_all('t = t + 1', ['story_id = ? and t >= ?', self.story_id, self.t])
270 def lesser_shift old_t
271 self.t = 0 if self.t < 0
272 StorySheet.update_all('t = t + 1', ['story_id = ? and (t >= ? and t < ?)', self.story_id, self.t, old_t])
275 def higher_shift old_t
276 nf = StorySheet.find_t(self.story_id, self.t)
277 max_t = StorySheet.max_t(self.story_id).to_i
278 self.t = max_t if self.t > max_t
279 StorySheet.update_all('t = t - 1', ['story_id = ? and (t > ? and t <= ?)', self.story_id, old_t, self.t])
282 def update_shift old_t
290 def rotate old_t = nil
293 self.t = StorySheet.new_t self.story_id
300 self.update_shift old_t
306 return nil if self.story_id == nil or self.sheet_id == nil
307 self.story.own?(self.author) and self.sheet.usable?(self.author)
310 def store old_t = nil
312 StorySheet.transaction do
317 raise ActiveRecord::Forbidden
321 raise ActiveRecord::Rollback unless res
322 res = StorySheet.validate_t(self)
324 self.errors.add :t, 'unserialized'
325 raise ActiveRecord::Rollback
331 def destroy_and_shorten
333 StorySheet.transaction do
334 StorySheet.update_all('t = t - 1', ['story_id = ? and (t > ?)', self.story_id, self.t])
335 raise ActiveRecord::Rollback unless self.destroy