1 class Sheet < Pettanr::Item
6 validates :caption, :presence => true, :length => {:maximum => 100}
7 validates :width, :presence => true, :numericality => true, :natural_number => true
8 validates :height, :presence => true, :numericality => true, :natural_number => true
9 validates :visible, :presence => true, :numericality => true, :inclusion => {:in => 0..1}
10 accepts_nested_attributes_for :sheet_panels, :allow_destroy => true
24 def self.valid_encode_columns
25 super.merge ['caption']
28 def self.each_element_class_names
29 {'SheetPanel' => 'sheet_panels'}.each do |k, n|
34 def self.class_name_to_class k
38 def self.each_element_classes
39 self.each_element_class_names do |k|
40 e = self.class_name_to_class k
45 def elements_by_class_name class_name
46 self.__send__ class_name.tableize
50 self.visible = 0 if self.visible.blank?
54 return false unless au
55 self.author_id = au.id
59 roles = [roles] unless roles.respond_to?(:each)
60 au = Sheet.get_author_from_roles roles
61 return false unless au
62 self.author_id == au.id
66 if MagicNumber['run_mode'] == 0
67 return false unless guest_role_check(roles)
69 return false unless reader_role_check(roles)
71 return true if self.own?(roles)
72 return true if self.new_record?
84 'sheet' + self.tag_sheet_id
88 self.new_record? ? '0' : self.id.to_s
95 def self.default_page_size
99 def self.max_page_size
103 def self.default_panel_size
107 def self.max_panel_size
111 def self.page prm = nil
117 def self.page_size prm = self.default_page_size
119 page_size = self.max_page_size if page_size > self.max_page_size
120 page_size = self.default_page_size if page_size < 1
128 def self.mylist_where au
129 ['sheets.author_id = ?', au.id]
132 def self.himlist_where au
133 ['sheets.author_id = ? and sheets.visible > 0', au.id]
136 def self.list page = 1, page_size = self.default_page_size
137 Sheet.where(self.list_where()).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
140 def self.mylist au, page = 1, page_size = Author.default_sheet_page_size
141 Sheet.where(self.mylist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
144 def self.himlist au, page = 1, page_size = Author.default_sheet_page_size
145 Sheet.where(self.himlist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
148 def self.list_paginate page = 1, page_size = self.default_page_size
149 Kaminari.paginate_array(Array.new(Sheet.where(self.list_where()).count, nil)).page(page).per(page_size)
152 def self.mylist_paginate au, page = 1, page_size = Author.default_sheet_page_size
153 Kaminari.paginate_array(Array.new(Sheet.where(self.mylist_where(au)).count, nil)).page(page).per(page_size)
156 def self.himlist_paginate au, page = 1, page_size = Author.default_sheet_page_size
157 Kaminari.paginate_array(Array.new(Sheet.where(self.himlist_where(au)).count, nil)).page(page).per(page_size)
160 def self.list_by_story story_id, roles, page = 1, page_size = self.default_page_size
161 self.where(StorySheet.list_by_story_where(story_id)).includes(
162 {:story_sheets => {}}
163 ).order('story_sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
166 def self.list_by_panel panel_id, roles, page = 1, page_size = self.default_page_size
167 self.where(SheetPanel.list_by_panel_where(panel_id)).includes(
168 {:sheet_panels => {}}
169 ).order('sheet_panels.updated_at desc').offset((page -1) * page_size).limit(page_size)
172 def self.list_by_author_where author_id
173 ['sheets.author_id = ?', author_id]
176 def self.list_by_author author_id, roles, page = 1, page_size = self.default_page_size
177 self.where(self.list_by_author_where(author_id)).includes(self.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
181 {:sheet_panels => {:panel => {}}, :author => {} }
184 def self.list_json_opt
185 {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
188 def self.show sid, roles
190 opt.merge!(Sheet.show_opt)
191 res = Sheet.find(sid, opt)
192 raise ActiveRecord::Forbidden unless res.visible?(roles)
196 def self.edit sid, au
198 opt.merge!(Sheet.show_opt)
199 res = Sheet.find(sid, opt)
200 raise ActiveRecord::Forbidden unless res.own?(au)
205 {:include => {:sheet_panels => {:panel => {}}, :author => {}}}
208 def self.show_json_opt
209 {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
214 self.class.each_element_class_names do |k|
215 r += (self.elements_by_class_name(k) || [])
222 self.parts_element.each do |e|
230 self.parts_element.each do |e|
237 self.sheet_elements.size
241 self.sheet_elements.size + 1
244 def self.visible_count
245 Sheet.count 'visible > 0'
248 def self.collect_element_value elements, name
251 if o['_destroy'] or o[:_destroy]
260 def self.validate_serial ary, offset = 0
262 ary.compact.sort.each do |n|
263 break false unless n == i
266 ary.compact.size == i - offset
269 def self.validate_element_serial elements, name, offset = 0
270 Sheet.validate_serial(Sheet.collect_element_value(elements, name), offset)
273 def self.validate_elements_serial c
275 Sheet.validate_element_serial(conf[:elements], conf[:name], conf[:offset]) ? nil : false
279 def validate_serial_list
281 self.class.each_element_class_names do |k|
282 l << self.elements_by_class_name(k)
284 # l = [self.sheet_panels]
286 {:elements => l, :name => :t, :offset => 0},
287 {:elements => l, :name => :z, :offset => 1}
292 # r1 = Panel.validate_elements_id validate_id_list
293 Sheet.validate_elements_serial validate_serial_list
297 @new_element_index = 0
298 self.panel_elements.each do |elm|
300 elm.new_index = @new_element_index
301 @new_element_index += 1
308 self.errors.add :base, I18n.t('errors.invalid_json')
311 self.attributes = attr
315 self.sheet_elements.each do |elm|
320 unless validate_child
322 self.errors.add :base, I18n.t('errors.invalid_t')
323 raise ActiveRecord::Rollback
329 def destroy_with_sheet_panel
332 self.sheet_panels.each do |sheet_panel|
333 raise ActiveRecord::Rollback unless sheet_panel.destroy
335 raise ActiveRecord::Rollback unless self.destroy
353 def licensed_pictures
355 self.sheet_elements.each do |elm|
356 r.merge!(elm.licensed_pictures)
363 Sheet.each_element_class_names do |n|
364 self.elements_by_class_name(n).each do |elm|
365 next if elm.copyable?
375 attr = self.copy_attributes
376 Sheet.each_element_class_names do |n|
377 element_attr = Sheet.class_name_to_class(n).panelize(
378 self.elements_by_class_name(n).map {|elm|
379 elm.copy_attributes.merge elm.panel_attributes
382 attr.merge! element_attr
391 r.delete 'created_at'
392 r.delete 'updated_at'
396 def self.panelize sheet
397 attr = sheet.attributes