t#32046:

[pettanr/pettanr.git] / app / models / sheet.rb

diff --git a/app/models/sheet.rb b/app/models/sheet.rb
new file mode 100644 (file)
index 0000000..a3b8bff
--- /dev/null
+++ b/app/models/sheet.rb
@@ -0,0 +1,172 @@
+class Sheet < ActiveRecord::Base
+  has_many :sheet_panels
+  has_many :story_sheets
+  belongs_to :author
+  
+  validates :caption, :presence => true, :length => {:maximum => 100}
+  validates :visible, :presence => true, :numericality => true, :inclusion => {:in => 0..1}
+  before_validation :valid_encode
+  
+  def valid_encode
+    ['caption', 'description'].each do |a|
+      next if attributes[a] == nil
+      raise Pettanr::BadRequest unless attributes[a].valid_encoding?
+    end
+  end
+  
+  def supply_default
+    self.visible = 0 if self.visible.blank?
+  end
+  
+  def overwrite au
+    return false unless au
+    self.author_id = au.id
+  end
+  
+  def own? roles
+    roles = [roles] unless roles.respond_to?(:each)
+    au = Sheet.get_author_from_roles roles
+    return false unless au
+    self.author_id == au.id
+  end
+  
+  def visible? roles
+    if MagicNumber['run_mode'] == 0
+      return false unless guest_role_check(roles)
+    else
+      return false unless reader_role_check(roles)
+    end
+    return true if self.own?(roles)
+    self.visible > 0
+  end
+  
+  def usable? au
+    visible? au
+  end
+  
+  def self.default_page_size
+    25
+  end
+  
+  def self.max_page_size
+    100
+  end
+  
+  def self.default_panel_size
+    30
+  end
+  
+  def self.max_panel_size
+    200
+  end
+  
+  def self.page prm = nil
+    page = prm.to_i
+    page = 1 if page < 1
+    page
+  end
+  
+  def self.page_size prm = self.default_page_size
+    page_size = prm.to_i
+    page_size = self.max_page_size if page_size > self.max_page_size
+    page_size = self.default_page_size if page_size < 1
+    page_size
+  end
+  
+  def self.list_where
+    'sheets.visible > 0'
+  end
+  
+  def self.mylist_where au
+    ['sheets.author_id = ?', au.id]
+  end
+  
+  def self.himlist_where au
+    ['sheets.author_id = ? and sheets.visible > 0', au.id]
+  end
+  
+  def self.list page = 1, page_size = self.default_page_size
+    Sheet.where(self.list_where()).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.mylist au, page = 1, page_size = Author.default_sheet_page_size
+    Sheet.where(self.mylist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.himlist au, page = 1, page_size = Author.default_sheet_page_size
+    Sheet.where(self.himlist_where(au)).includes(Sheet.list_opt).order('sheets.updated_at desc').offset((page -1) * page_size).limit(page_size)
+  end
+  
+  def self.list_paginate page = 1, page_size = self.default_page_size
+    Kaminari.paginate_array(Array.new(Sheet.where(self.list_where()).count, nil)).page(page).per(page_size)
+  end
+  
+  def self.mylist_paginate au, page = 1, page_size = Author.default_sheet_page_size
+    Kaminari.paginate_array(Array.new(Sheet.where(self.mylist_where(au)).count, nil)).page(page).per(page_size)
+  end
+  
+  def self.himlist_paginate au, page = 1, page_size = Author.default_sheet_page_size
+    Kaminari.paginate_array(Array.new(Sheet.where(self.himlist_where(au)).count, nil)).page(page).per(page_size)
+  end
+  
+  def self.list_opt
+    {:sheet_panels => {:panel => {}}, :author => {} }
+  end
+  
+  def self.list_json_opt
+    {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
+  end
+  
+  def self.show sid, roles
+    opt = {}
+    opt.merge!(Sheet.show_opt)
+    res = Sheet.find(sid, opt)
+    raise ActiveRecord::Forbidden unless res.visible?(roles)
+    res
+  end
+  
+  def self.edit sid, au
+    opt = {}
+    opt.merge!(Sheet.show_opt)
+    res = Sheet.find(sid, opt)
+    raise ActiveRecord::Forbidden unless res.own?(au)
+    res
+  end
+  
+  def self.show_opt
+    {:include => {:sheet_panels => {:panel => {}}, :author => {}}}
+  end
+  
+  def self.show_json_opt
+    {:include => {:sheet_panels => {:include => {:panel => {}}}, :author => {}}}
+  end
+  
+  def self.visible_count
+    Sheet.count 'visible > 0'
+  end
+  
+  def destroy_with_sheet_panel
+    res = false
+    Sheet.transaction do
+      self.sheet_panels.each do |sheet_panel|
+        raise ActiveRecord::Rollback unless sheet_panel.destroy
+      end
+      raise ActiveRecord::Rollback unless self.destroy
+      res = true
+    end
+    res
+  end
+  
+  def scenario
+    panels.map {|panel|
+      panel.scenario
+    }.join
+  end
+  
+  def plain_scenario
+    panels.map {|panel|
+      panel.plain_scenario
+    }.join
+  end
+  
+end