#素材
-class ResourcePicture < ActiveRecord::Base
+class ResourcePicture < Pettanr::Item
belongs_to :artist
belongs_to :license
belongs_to :picture
- has_many :panel_pictures
belongs_to :original_picture
validates :ext, :presence => true, :length => {:maximum => 4}, :inclusion => {:in => ['png', 'jpeg', 'gif']}
validates :classname, :presence => true, :length => {:maximum => 50}
validates :picture_id, :presence => true, :numericality => true, :existence => {:both => false}
+ def self.singular
+ 'ResourcePicture'
+ end
+
+ def self.plural
+ 'ResourcePictures'
+ end
+
+ def self.owner_type
+ :author
+ end
+
+ def self.valid_encode_columns
+ super.merge ['artist_name', 'classname', 'credit', 'settings']
+ end
+
def supply_default
end
{:src => self.url('full'), :width => self.width, :height => self.height}
end
+ def symbol_option
+ self.tmb_opt_img_tag
+ end
+
def self.default_page_size
25
end
page_size
end
+ def self.mylist_where ar
+ ['resource_pictures.artist_id = ?', ar.id]
+ end
+
+ def self.himlist_where ar
+ ['resource_pictures.artist_id = ?', ar.id]
+ end
+
def self.list page = 1, page_size = self.default_page_size
- opt = {}
- opt.merge!(self.list_opt)
- opt.merge!({:limit => page_size, :offset => (page -1) * page_size}) if page_size > 0
- opt.merge!({:order => 'updated_at desc'})
- ResourcePicture.find(:all, opt)
+ ResourcePicture.includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.mylist ar, page = 1, page_size = Author.default_resource_picture_page_size
+ ResourcePicture.where(self.mylist_where(ar)).includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.himlist ar, page = 1, page_size = Author.default_resource_picture_page_size
+ ResourcePicture.where(self.himlist_where(ar)).includes(ResourcePicture.list_opt).order('resource_pictures.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(ResourcePicture.count, nil)).page(page).per(page_size)
+ end
+
+ def self.mylist_paginate ar, page = 1, page_size = Author.default_resource_picture_page_size
+ Kaminari.paginate_array(Array.new(ResourcePicture.where(self.mylist_where(ar)).count, nil)).page(page).per(page_size)
+ end
+
+ def self.himlist_paginate ar, page = 1, page_size = Author.default_resource_picture_page_size
+ Kaminari.paginate_array(Array.new(ResourcePicture.where(self.himlist_where(ar)).count, nil)).page(page).per(page_size)
+ end
+
+ def self.list_by_original_picture_where original_picture_id
+ ['resource_pictures.original_picture_id = ?', original_picture_id]
+ end
+
+ def self.list_by_original_picture original_picture_id, roles, page = 1, page_size = self.default_page_size
+ self.where(self.list_by_original_picture_where(original_picture_id)).includes(self.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_by_license_where license_id
+ ['resource_pictures.license_id = ?', license_id]
+ end
+
+ def self.list_by_license license_id, roles, page = 1, page_size = self.default_page_size
+ self.where(self.list_by_license_where(license_id)).includes(self.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_by_artist_where artist_id
+ ['resource_pictures.artist_id = ?', artist_id]
+ end
+
+ def self.list_by_artist artist_id, roles, page = 1, page_size = self.default_page_size
+ self.where(self.list_by_artist_where(artist_id)).includes(self.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
end
def self.list_opt
- {:include => {:license => {}, :artist => {}, :picture => {}} }
+ {:license => {}, :artist => {}, :picture => {} }
end
def self.list_json_opt
{:include => {:license => {}, :artist => {}, :picture => {}} }
end
- def self.mylist ar, page = 1, page_size = Author.default_resource_picture_page_size
- opt = {}
- opt.merge!(ResourcePicture.list_opt)
- opt.merge!({:limit => page_size, :offset => (page -1) * page_size}) if page_size > 0
- opt.merge!({:conditions => ['resource_pictures.artist_id = ?', ar.id], :order => 'resource_pictures.updated_at desc'})
- ResourcePicture.find(:all, opt)
- end
-
def self.show rid, roles
opt = {}
opt.merge!(self.show_opt)
res = false
self.overwrite self.original_picture
ResourcePicture.transaction do
+ self.original_picture.published_at = Time.now
+ self.original_picture.stopped_at = nil
+ raise ActiveRecord::Rollback unless self.original_picture.save
pc = self.new_picture imager
if pc
self.picture_id = pc.id
def unpublish
res = false
ResourcePicture.transaction do
+ self.original_picture.published_at = nil
+ self.original_picture.stopped_at = Time.now
+ raise ActiveRecord::Rollback unless self.original_picture.save
begin
PictureIO.resource_picture_io.delete(self.filename) if PictureIO.resource_picture_io.exist?(self.filename)
PictureIO.resource_picture_io.delete(self.filename, 'full') if PictureIO.resource_picture_io.exist?(self.filename, 'full')
ResourcePicture.count
end
+ def picture_data
+ Base64.encode64(self.restore 'full')
+ end
+
def credit_template
"#{self.classname.tableize}/attributes/credit"
end