1 class SheetPanel < Pettanr::Item
5 accepts_nested_attributes_for :panel, :allow_destroy => true
7 validates :sheet_id, :numericality => {:allow_blank => true}
8 validates :panel_id, :numericality => {:allow_blank => true}
9 validates :author_id, :presence => true, :numericality => true, :existence => {:both => false}
10 validates :x, :presence => true, :numericality => true
11 validates :y, :presence => true, :numericality => true
12 validates :z, :presence => true, :numericality => {:greater_than => 0}
13 validates :t, :presence => true, :numericality => {:greater_than_or_equal_to => 0}
31 self.t = self.sheet.new_t
32 self.z = self.sheet.new_z
42 return false unless au
43 self.author_id = au.id
47 roles = [roles] unless roles.respond_to?(:each)
48 au = SheetPanel.get_author_from_roles roles
49 return false unless au
50 self.author_id == au.id
54 if MagicNumber['run_mode'] == 0
55 return false unless guest_role_check(roles)
57 return false unless reader_role_check(roles)
59 return true if self.sheet.own?(roles)
60 self.sheet.visible? roles
63 def self.default_page_size
67 def self.max_page_size
71 def self.page prm = nil
77 def self.page_size prm = self.default_page_size
79 page_size = self.max_page_size if page_size > self.max_page_size
80 page_size = self.default_page_size if page_size < 1
84 def self.play_list_where cid
85 ['sheet_panels.sheet_id = ?', cid]
92 def self.mylist_where au
93 ['sheet_panels.author_id = ?', au.id]
96 def self.himlist_where au
97 ['sheet_panels.author_id = ? and sheets.visible > 0', au.id]
100 def self.play_list sheet, author
101 SheetPanel.where(self.play_list_where(sheet.id)).includes(SheetPanel.list_opt).order('sheet_panels.t')
104 def self.list page = 1, page_size = self.default_page_size
105 SheetPanel.where(self.list_where()).includes(SheetPanel.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
108 def self.mylist au, page = 1, page_size = Author.default_sheet_panel_page_size
109 SheetPanel.where(self.mylist_where(au)).includes(SheetPanel.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
112 def self.himlist au, page = 1, page_size = Author.default_sheet_panel_page_size
113 SheetPanel.where(self.himlist_where(au)).includes(SheetPanel.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
116 def self.list_paginate page = 1, page_size = self.default_page_size
117 Kaminari.paginate_array(Array.new(SheetPanel.where(self.list_where()).includes(SheetPanel.list_opt).count, nil)).page(page).per(page_size)
120 def self.mylist_paginate au, page = 1, page_size = Author.default_sheet_panel_page_size
121 Kaminari.paginate_array(Array.new(SheetPanel.where(self.mylist_where(au)).includes(SheetPanel.list_opt).count, nil)).page(page).per(page_size)
124 def self.himlist_paginate au, page = 1, page_size = Author.default_sheet_panel_page_size
125 Kaminari.paginate_array(Array.new(SheetPanel.where(self.himlist_where(au)).includes(SheetPanel.list_opt).count, nil)).page(page).per(page_size)
128 def self.list_by_sheet_where sheet_id
129 ['sheet_panels.sheet_id = ?', sheet_id]
132 def self.list_by_sheet sheet_id, roles, page = 1, page_size = self.default_page_size
133 self.where(self.list_by_sheet_where(sheet_id)).includes(self.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
136 def self.list_by_panel_where panel_id
137 ['sheet_panels.panel_id = ?', panel_id]
140 def self.list_by_panel panel_id, roles, page = 1, page_size = self.default_page_size
141 self.where(self.list_by_panel_where(panel_id)).includes(self.list_opt).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
152 :panel_pictures => {:picture => {:artist => {}, :license => {}}},
153 :speech_balloons =>{:balloon => {}, :speech => {}}
158 def self.list_json_opt
166 :panel_pictures => {:picture => {:artist => {}, :license => {}}},
167 :speech_balloons =>{:balloon => {}, :speech => {}}
172 def self.show spid, roles
174 opt.merge!(SheetPanel.show_opt)
175 res = SheetPanel.find spid, opt
176 raise ActiveRecord::Forbidden unless res.visible?(roles)
180 def self.edit spid, au
182 opt.merge!(SheetPanel.show_opt)
183 res = SheetPanel.find spid, opt
184 raise ActiveRecord::Forbidden unless res.own?(au)
196 :panel_pictures => {:picture => {:artist => {}, :license => {}}},
197 :speech_balloons =>{:balloon => {}, :speech => {}}
206 def sheet_panel_as_json au
207 panel_include = if self.panel and self.panel.visible?(au)
208 {:include => {:author => {}}, :methods => :elements}
210 {:include => {:author => {}}}
212 self.to_json({:include => {:sheet => {:include => {:author => {}}}, :author => {}, :panel => panel_include}})
215 def self.list_as_json_text ary, au
216 '[' + ary.map {|i| i.sheet_panel_as_json(au) }.join(',') + ']'
219 def licensed_pictures
221 self.panel.licensed_pictures
227 def self.panelize elements_attributes
228 elements_attributes = [elements_attributes] unless elements_attributes.is_a?(Array)
231 elements_attributes.each do |element_attributes|
232 hash[self.to_s.tableize + '_attributes'] ||= {}
233 n = if element_attributes['id']
234 element_attributes['id'].to_s
239 hash[self.to_s.tableize + '_attributes'][n] = element_attributes
248 r.delete 'panel_id' # create panel
249 r.delete 'created_at'
250 r.delete 'updated_at'
255 if self.panel and self.panel.publish? == false
264 self.panel.author_id = au.id
265 self.panel.panel_elements.each do |elm|
274 {'panel_attributes' => self.panel.copy}
280 def self.new_t sheet_id
281 r = SheetPanel.max_t(sheet_id)
282 r.blank? ? 0 : r.to_i + 1
285 def self.max_t sheet_id
286 SheetPanel.maximum(:t, :conditions => ['sheet_id = ?', sheet_id])
289 def self.find_t sheet_id, t
290 SheetPanel.find(:first, :conditions => ['sheet_id = ? and t = ?', sheet_id, t])
293 def self.collect_t sheet_panel
294 r = SheetPanel.find(:all, :conditions => ['sheet_id = ?', sheet_panel.sheet_id], :order => 't')
300 ary.compact.sort.each do |t|
301 break false unless t == i
304 ary.compact.size == i
307 def self.validate_t sheet_panel
308 SheetPanel.serial?(SheetPanel.collect_t(sheet_panel))
312 SheetPanel.update_all('t = t + 1', ['sheet_id = ? and t >= ?', self.sheet_id, self.t])
315 def lesser_shift old_t
316 self.t = 0 if self.t < 0
317 SheetPanel.update_all('t = t + 1', ['sheet_id = ? and (t >= ? and t < ?)', self.sheet_id, self.t, old_t])
320 def higher_shift old_t
321 nf = SheetPanel.find_t(self.sheet_id, self.t)
322 max_t = SheetPanel.max_t(self.sheet_id).to_i
323 self.t = max_t if self.t > max_t
324 SheetPanel.update_all('t = t - 1', ['sheet_id = ? and (t > ? and t <= ?)', self.sheet_id, old_t, self.t])
327 def update_shift old_t
335 def rotate old_t = nil
338 self.t = SheetPanel.new_t self.sheet_id
345 self.update_shift old_t
351 return nil if self.sheet_id == nil or self.panel_id == nil
352 self.sheet.own?(self.author) and self.panel.usable?(self.author)
355 def store old_t = nil
357 SheetPanel.transaction do
362 raise ActiveRecord::Forbidden
366 raise ActiveRecord::Rollback unless res
367 res = SheetPanel.validate_t(self)
369 self.errors.add :t, 'unserialized'
370 raise ActiveRecord::Rollback
376 def destroy_and_shorten
378 SheetPanel.transaction do
379 SheetPanel.update_all('t = t - 1', ['sheet_id = ? and (t > ?)', self.sheet_id, self.t])
380 raise ActiveRecord::Rollback unless self.destroy
387 def self.colum_structures
388 @@colum_structures ||= {
392 def self.path_name with_engine = false
413 self.sheet || @new_sheet
417 'sheet' + self.tag_sheet_id + self.tag_element_type + self.tag_element_id + c.to_s
425 self.get_sheet == nil or self.get_sheet.new_record? ? '0' : self.get_sheet.id.to_s
429 self.new_record? ? '0' : self.id.to_s
440 def path_name with_engine = false
441 self.class.path_name(with_engine)
444 def form_template with_engine = false
445 self.path_name(with_engine) + '/form'
448 def scenario_template with_engine = false
449 self.path_name(with_engine) + '/scenario'
452 def element_face_template with_engine = false
453 self.path_name(with_engine) + '/element_face'
456 def form_helper_template(colum_name)
457 self.class.colum_structures[colum_name][:helper]
460 def tag_attributes column = nil, opt = {}
462 :id => self.field_tag_id(column), :sheet_id => self.tag_sheet_id,
463 :element_id => self.tag_element_id, :element_type => self.tag_element_type
467 def field_tag_attributes column, no_attr, opt = {}
468 self.tag_attributes(column).merge(
469 {:column => column, :new_index => self.tag_new_index, :no_attr => no_attr}
473 #render element by body
474 def any_tag_attributes name = nil, opt = {}
475 r = self.tag_attributes(name)
477 {:new_index => self.tag_new_index}
482 def select_tag_attributes(selected, column, no_attr)
485 {:html => {:selected => selected}},
486 self.field_tag_attributes(column, no_attr)
490 def tag_attr column = nil, opt = {}
491 self.tag_attributes(column, opt).to_attr
494 def field_tag_attr column, no_attr, opt = {}
495 self.field_tag_attributes(column, no_attr, opt).to_attr
498 def any_tag_attr name = nil, opt = {}
499 self.any_tag_attributes(name, opt).to_attr