1 class SheetPanel < ActiveRecord::Base
6 validates :sheet_id, :presence => true, :numericality => true, :existence => {:both => false}
7 validates :panel_id, :presence => true, :numericality => true, :existence => {:both => false}
8 validates :author_id, :presence => true, :numericality => true, :existence => {:both => false}
9 validates :x, :presence => true, :numericality => true
10 validates :y, :presence => true, :numericality => true
11 validates :z, :presence => true, :numericality => {:greater_than => 0}
12 validates :t, :presence => true, :numericality => {:greater_than_or_equal_to => 0}
24 return false unless au
25 self.author_id = au.id
29 roles = [roles] unless roles.respond_to?(:each)
30 au = SheetPanel.get_author_from_roles roles
31 return false unless au
32 self.author_id == au.id
36 if MagicNumber['run_mode'] == 0
37 return false unless guest_role_check(roles)
39 return false unless reader_role_check(roles)
41 return true if self.sheet.own?(roles)
42 self.sheet.visible? roles
45 def self.default_panel_size
49 def self.max_panel_size
53 def self.offset cnt, prm = nil
55 offset = cnt - 1 if offset >= cnt
56 offset = cnt - offset.abs if offset < 0
57 offset = 0 if offset < 0
61 def self.panel_count cnt, prm = self.default_panel_size
63 count = self.max_panel_size if count > self.max_panel_size
64 count = self.default_panel_size if count < 1
68 def self.default_page_size
72 def self.max_page_size
76 def self.page prm = nil
82 def self.page_size prm = self.default_page_size
84 page_size = self.max_page_size if page_size > self.max_page_size
85 page_size = self.default_page_size if page_size < 1
89 def self.play_list_where cid
90 ['sheet_panels.sheet_id = ?', cid]
97 def self.mylist_where au
98 ['sheet_panels.author_id = ?', au.id]
101 def self.himlist_where au
102 ['sheet_panels.author_id = ? and sheets.visible > 0', au.id]
105 def self.play_list sheet, author, offset = 0, limit = SheetPanel.default_panel_size
106 SheetPanel.where(self.play_list_where(sheet.id)).includes(SheetPanel.list_opt).order('sheet_panels.t').offset(offset).limit(limit)
109 def self.list page = 1, page_size = self.default_page_size
110 SheetPanel.where(self.list_where()).includes(SheetPanel.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
113 def self.mylist au, page = 1, page_size = Author.default_sheet_panel_page_size
114 SheetPanel.where(self.mylist_where(au)).includes(SheetPanel.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
117 def self.himlist au, page = 1, page_size = Author.default_sheet_panel_page_size
118 SheetPanel.where(self.himlist_where(au)).includes(SheetPanel.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
121 def self.list_paginate page = 1, page_size = self.default_page_size
122 Kaminari.paginate_array(Array.new(SheetPanel.where(self.list_where()).includes(SheetPanel.list_opt).count, nil)).page(page).per(page_size)
125 def self.mylist_paginate au, page = 1, page_size = Author.default_sheet_panel_page_size
126 Kaminari.paginate_array(Array.new(SheetPanel.where(self.mylist_where(au)).includes(SheetPanel.list_opt).count, nil)).page(page).per(page_size)
129 def self.himlist_paginate au, page = 1, page_size = Author.default_sheet_panel_page_size
130 Kaminari.paginate_array(Array.new(SheetPanel.where(self.himlist_where(au)).includes(SheetPanel.list_opt).count, nil)).page(page).per(page_size)
141 :panel_pictures => {:picture => {:artist => {}, :license => {}}},
142 :speech_balloons =>{:balloon => {}, :speech => {}}
147 def self.list_json_opt
155 :panel_pictures => {:picture => {:artist => {}, :license => {}}},
156 :speech_balloons =>{:balloon => {}, :speech => {}}
161 def self.show spid, roles
163 opt.merge!(SheetPanel.show_opt)
164 res = SheetPanel.find spid, opt
165 raise ActiveRecord::Forbidden unless res.visible?(roles)
169 def self.edit spid, au
171 opt.merge!(SheetPanel.show_opt)
172 res = SheetPanel.find spid, opt
173 raise ActiveRecord::Forbidden unless res.own?(au)
185 :panel_pictures => {:picture => {:artist => {}, :license => {}}},
186 :speech_balloons =>{:balloon => {}, :speech => {}}
195 def sheet_panel_as_json au
196 panel_include = if self.panel and self.panel.visible?(au)
197 {:include => {:author => {}}, :methods => :elements}
199 {:include => {:author => {}}}
201 self.to_json({:include => {:sheet => {:include => {:author => {}}}, :author => {}, :panel => panel_include}})
204 def self.list_as_json_text ary, au
205 '[' + ary.map {|i| i.sheet_panel_as_json(au) }.join(',') + ']'
208 def self.licensed_pictures sheet_panels
210 sheet_panels.each do |sheet_panel|
211 r.merge!(sheet_panel.panel.licensed_pictures) if sheet_panel.panel
216 def self.new_t sheet_id
217 r = SheetPanel.max_t(sheet_id)
218 r.blank? ? 0 : r.to_i + 1
221 def self.max_t sheet_id
222 SheetPanel.maximum(:t, :conditions => ['sheet_id = ?', sheet_id])
225 def self.find_t sheet_id, t
226 SheetPanel.find(:first, :conditions => ['sheet_id = ? and t = ?', sheet_id, t])
229 def self.collect_t sheet_panel
230 r = SheetPanel.find(:all, :conditions => ['sheet_id = ?', sheet_panel.sheet_id], :order => 't')
236 ary.compact.sort.each do |t|
237 break false unless t == i
240 ary.compact.size == i
243 def self.validate_t sheet_panel
244 SheetPanel.serial?(SheetPanel.collect_t(sheet_panel))
248 SheetPanel.update_all('t = t + 1', ['sheet_id = ? and t >= ?', self.sheet_id, self.t])
251 def lesser_shift old_t
252 self.t = 0 if self.t < 0
253 SheetPanel.update_all('t = t + 1', ['sheet_id = ? and (t >= ? and t < ?)', self.sheet_id, self.t, old_t])
256 def higher_shift old_t
257 nf = SheetPanel.find_t(self.sheet_id, self.t)
258 max_t = SheetPanel.max_t(self.sheet_id).to_i
259 self.t = max_t if self.t > max_t
260 SheetPanel.update_all('t = t - 1', ['sheet_id = ? and (t > ? and t <= ?)', self.sheet_id, old_t, self.t])
263 def update_shift old_t
271 def rotate old_t = nil
274 self.t = SheetPanel.new_t self.sheet_id
281 self.update_shift old_t
287 return nil if self.sheet_id == nil or self.panel_id == nil
288 self.sheet.own?(self.author) and self.panel.usable?(self.author)
291 def store old_t = nil
293 SheetPanel.transaction do
298 raise ActiveRecord::Forbidden
302 raise ActiveRecord::Rollback unless res
303 res = SheetPanel.validate_t(self)
305 self.errors.add :t, 'unserialized'
306 raise ActiveRecord::Rollback
312 def destroy_and_shorten
314 SheetPanel.transaction do
315 SheetPanel.update_all('t = t - 1', ['sheet_id = ? and (t > ?)', self.sheet_id, self.t])
316 raise ActiveRecord::Rollback unless self.destroy