1 class Sheet < ActiveRecord::Base
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
11 before_validation :valid_encode
14 ['caption'].each do |a|
15 next if attributes[a] == nil
16 raise Pettanr::BadRequest unless attributes[a].valid_encoding?
20 def self.each_element_class_names
21 {'SheetPanel' => 'sheet_panels'}.each do |k, n|
26 def self.class_name_to_class k
30 def self.each_element_classes
31 self.each_element_class_names do |k|
32 e = self.class_name_to_class k
37 def elements_by_class_name class_name
38 self.__send__ class_name.tableize
42 self.visible = 0 if self.visible.blank?
46 return false unless au
47 self.author_id = au.id
51 roles = [roles] unless roles.respond_to?(:each)
52 au = Sheet.get_author_from_roles roles
53 return false unless au
54 self.author_id == au.id
58 if MagicNumber['run_mode'] == 0
59 return false unless guest_role_check(roles)
61 return false unless reader_role_check(roles)
63 return true if self.own?(roles)
72 'sheet' + self.tag_sheet_id
76 self.new_record? ? '0' : self.id.to_s
83 def self.default_page_size
87 def self.max_page_size
91 def self.default_panel_size
95 def self.max_panel_size
99 def self.page prm = nil
105 def self.page_size prm = self.default_page_size
107 page_size = self.max_page_size if page_size > self.max_page_size
108 page_size = self.default_page_size if page_size < 1
116 def self.mylist_where au
117 ['sheets.author_id = ?', au.id]
120 def self.himlist_where au
121 ['sheets.author_id = ? and sheets.visible > 0', au.id]
124 def self.list page = 1, page_size = self.default_page_size
125 Sheet.where(self.list_where()).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
128 def self.mylist au, page = 1, page_size = Author.default_sheet_page_size
129 Sheet.where(self.mylist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
132 def self.himlist au, page = 1, page_size = Author.default_sheet_page_size
133 Sheet.where(self.himlist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
136 def self.list_paginate page = 1, page_size = self.default_page_size
137 Kaminari.paginate_array(Array.new(Sheet.where(self.list_where()).count, nil)).page(page).per(page_size)
140 def self.mylist_paginate au, page = 1, page_size = Author.default_sheet_page_size
141 Kaminari.paginate_array(Array.new(Sheet.where(self.mylist_where(au)).count, nil)).page(page).per(page_size)
144 def self.himlist_paginate au, page = 1, page_size = Author.default_sheet_page_size
145 Kaminari.paginate_array(Array.new(Sheet.where(self.himlist_where(au)).count, nil)).page(page).per(page_size)
149 {:sheet_panels => {:panel => {}}, :author => {} }
152 def self.list_json_opt
153 {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
156 def self.show sid, roles
158 opt.merge!(Sheet.show_opt)
159 res = Sheet.find(sid, opt)
160 raise ActiveRecord::Forbidden unless res.visible?(roles)
164 def self.edit sid, au
166 opt.merge!(Sheet.show_opt)
167 res = Sheet.find(sid, opt)
168 raise ActiveRecord::Forbidden unless res.own?(au)
173 {:include => {:sheet_panels => {:panel => {}}, :author => {}}}
176 def self.show_json_opt
177 {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
182 self.class.each_element_class_names do |k|
183 r += (self.elements_by_class_name(k) || [])
190 self.parts_element.each do |e|
198 self.parts_element.each do |e|
205 self.sheet_elements.size
209 self.sheet_elements.size + 1
212 def self.visible_count
213 Sheet.count 'visible > 0'
216 def self.collect_element_value elements, name
219 if o['_destroy'] or o[:_destroy]
228 def self.validate_serial ary, offset = 0
230 ary.compact.sort.each do |n|
231 break false unless n == i
234 ary.compact.size == i - offset
237 def self.validate_element_serial elements, name, offset = 0
238 Sheet.validate_serial(Sheet.collect_element_value(elements, name), offset)
241 def self.validate_elements_serial c
243 Sheet.validate_element_serial(conf[:elements], conf[:name], conf[:offset]) ? nil : false
247 def validate_serial_list
249 self.class.each_element_class_names do |k|
250 l << self.elements_by_class_name(k)
252 # l = [self.sheet_panels]
254 {:elements => l, :name => :t, :offset => 0},
255 {:elements => l, :name => :z, :offset => 1}
260 # r1 = Panel.validate_elements_id validate_id_list
261 Sheet.validate_elements_serial validate_serial_list
266 self.errors.add :base, I18n.t('errors.invalid_json')
269 self.attributes = attr
274 unless validate_child
276 self.errors.add :base, I18n.t('errors.invalid_t')
277 raise ActiveRecord::Rollback
283 def destroy_with_sheet_panel
286 self.sheet_panels.each do |sheet_panel|
287 raise ActiveRecord::Rollback unless sheet_panel.destroy
289 raise ActiveRecord::Rollback unless self.destroy
307 def licensed_pictures
309 self.sheet_elements.each do |elm|
310 r.merge!(elm.licensed_pictures)
316 attr = self.copy_attributes
317 Sheet.each_element_class_names do |n|
318 attr.merge! Sheet.class_name_to_class(n).panelize(self.elements_by_class_name(n).map {|elm| elm.copy_attributes})
327 r.delete 'created_at'
328 r.delete 'updated_at'
332 def self.panelize sheet
333 attr = sheet.attributes