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)
64 return true if self.new_record?
73 'sheet' + self.tag_sheet_id
77 self.new_record? ? '0' : self.id.to_s
84 def self.default_page_size
88 def self.max_page_size
92 def self.default_panel_size
96 def self.max_panel_size
100 def self.page prm = nil
106 def self.page_size prm = self.default_page_size
108 page_size = self.max_page_size if page_size > self.max_page_size
109 page_size = self.default_page_size if page_size < 1
117 def self.mylist_where au
118 ['sheets.author_id = ?', au.id]
121 def self.himlist_where au
122 ['sheets.author_id = ? and sheets.visible > 0', au.id]
125 def self.list page = 1, page_size = self.default_page_size
126 Sheet.where(self.list_where()).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
129 def self.mylist au, page = 1, page_size = Author.default_sheet_page_size
130 Sheet.where(self.mylist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
133 def self.himlist au, page = 1, page_size = Author.default_sheet_page_size
134 Sheet.where(self.himlist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
137 def self.list_paginate page = 1, page_size = self.default_page_size
138 Kaminari.paginate_array(Array.new(Sheet.where(self.list_where()).count, nil)).page(page).per(page_size)
141 def self.mylist_paginate au, page = 1, page_size = Author.default_sheet_page_size
142 Kaminari.paginate_array(Array.new(Sheet.where(self.mylist_where(au)).count, nil)).page(page).per(page_size)
145 def self.himlist_paginate au, page = 1, page_size = Author.default_sheet_page_size
146 Kaminari.paginate_array(Array.new(Sheet.where(self.himlist_where(au)).count, nil)).page(page).per(page_size)
150 {:sheet_panels => {:panel => {}}, :author => {} }
153 def self.list_json_opt
154 {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
157 def self.show sid, roles
159 opt.merge!(Sheet.show_opt)
160 res = Sheet.find(sid, opt)
161 raise ActiveRecord::Forbidden unless res.visible?(roles)
165 def self.edit sid, au
167 opt.merge!(Sheet.show_opt)
168 res = Sheet.find(sid, opt)
169 raise ActiveRecord::Forbidden unless res.own?(au)
174 {:include => {:sheet_panels => {:panel => {}}, :author => {}}}
177 def self.show_json_opt
178 {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
183 self.class.each_element_class_names do |k|
184 r += (self.elements_by_class_name(k) || [])
191 self.parts_element.each do |e|
199 self.parts_element.each do |e|
206 self.sheet_elements.size
210 self.sheet_elements.size + 1
213 def self.visible_count
214 Sheet.count 'visible > 0'
217 def self.collect_element_value elements, name
220 if o['_destroy'] or o[:_destroy]
229 def self.validate_serial ary, offset = 0
231 ary.compact.sort.each do |n|
232 break false unless n == i
235 ary.compact.size == i - offset
238 def self.validate_element_serial elements, name, offset = 0
239 Sheet.validate_serial(Sheet.collect_element_value(elements, name), offset)
242 def self.validate_elements_serial c
244 Sheet.validate_element_serial(conf[:elements], conf[:name], conf[:offset]) ? nil : false
248 def validate_serial_list
250 self.class.each_element_class_names do |k|
251 l << self.elements_by_class_name(k)
253 # l = [self.sheet_panels]
255 {:elements => l, :name => :t, :offset => 0},
256 {:elements => l, :name => :z, :offset => 1}
261 # r1 = Panel.validate_elements_id validate_id_list
262 Sheet.validate_elements_serial validate_serial_list
266 @new_element_index = 0
267 self.panel_elements.each do |elm|
269 elm.new_index = @new_element_index
270 @new_element_index += 1
277 self.errors.add :base, I18n.t('errors.invalid_json')
280 self.attributes = attr
284 self.panel_elements.each do |elm|
288 unless validate_child
290 self.errors.add :base, I18n.t('errors.invalid_t')
291 raise ActiveRecord::Rollback
297 def destroy_with_sheet_panel
300 self.sheet_panels.each do |sheet_panel|
301 raise ActiveRecord::Rollback unless sheet_panel.destroy
303 raise ActiveRecord::Rollback unless self.destroy
321 def licensed_pictures
323 self.sheet_elements.each do |elm|
324 r.merge!(elm.licensed_pictures)
330 attr = self.copy_attributes
331 Sheet.each_element_class_names do |n|
332 attr.merge! Sheet.class_name_to_class(n).panelize(self.elements_by_class_name(n).map {|elm| elm.copy_attributes})
341 r.delete 'created_at'
342 r.delete 'updated_at'
346 def self.panelize sheet
347 attr = sheet.attributes