188 lines
7.6 KiB
Ruby
188 lines
7.6 KiB
Ruby
# == Schema Information
|
|
#
|
|
# Table name: attachments
|
|
#
|
|
# id :integer not null, primary key
|
|
# container_id :integer
|
|
# container_type :string(30)
|
|
# filename :string(255) default(""), not null
|
|
# disk_filename :string(255) default(""), not null
|
|
# filesize :integer default("0"), not null
|
|
# content_type :string(255) default("")
|
|
# digest :string(60) default(""), not null
|
|
# downloads :integer default("0"), not null
|
|
# author_id :integer default("0"), not null
|
|
# created_on :datetime
|
|
# description :text(65535)
|
|
# disk_directory :string(255)
|
|
# attachtype :integer default("1")
|
|
# is_public :integer default("1")
|
|
# copy_from :string(255)
|
|
# quotes :integer default("0")
|
|
# is_publish :integer default("1")
|
|
# publish_time :datetime
|
|
# resource_bank_id :integer
|
|
# unified_setting :boolean default("1")
|
|
# cloud_url :string(255) default("")
|
|
# course_second_category_id :integer default("0")
|
|
# delay_publish :boolean default("0")
|
|
# link :string(255)
|
|
# clone_id :integer
|
|
#
|
|
# Indexes
|
|
#
|
|
# index_attachments_on_author_id (author_id)
|
|
# index_attachments_on_clone_id (clone_id)
|
|
# index_attachments_on_container_id_and_container_type (container_id,container_type)
|
|
# index_attachments_on_created_on (created_on)
|
|
#
|
|
|
|
|
|
|
|
class Attachment < ApplicationRecord
|
|
include BaseModel
|
|
include Publicable
|
|
include Publishable
|
|
include Lockable
|
|
|
|
belongs_to :container, polymorphic: true, optional: true
|
|
belongs_to :author, class_name: "User", foreign_key: :author_id
|
|
# belongs_to :course, foreign_key: :container_id, optional: true
|
|
# has_many :attachment_group_settings, :dependent => :destroy
|
|
# has_many :attachment_histories, -> { order(version: :desc) }, :dependent => :destroy
|
|
# 二级目录
|
|
# belongs_to :course_second_category, optional: true
|
|
|
|
scope :by_filename_or_user_name, -> (keywords) { joins(:author).where("filename like :search or LOWER(CONCAT(users.lastname, users.firstname)) LIKE :search OR users.nickname LIKE :search",
|
|
:search => "%#{keywords.split(" ").join('|')}%") unless keywords.blank? }
|
|
scope :by_keywords, -> (keywords) { where("filename LIKE ?", "%#{keywords.split(" ").join('|')}%") unless keywords.blank? }
|
|
scope :ordered, -> (opts = {}) { order("#{opts[:sort_type]} #{opts[:sort] == 1 ? 'asc': 'desc'}") }
|
|
scope :by_course_second_category_id, -> (course_second_category_id = 0) { where(course_second_category_id: course_second_category_id) }
|
|
scope :contains_only_course, -> { where(container_type: 'Course') }
|
|
scope :contains_only_project, -> { where(container_type: 'Project') }
|
|
scope :contains_course_and_project, -> { contains_only_course.or(contains_only_project) }
|
|
scope :mine, -> (author_id) { where(author_id: author_id) }
|
|
scope :simple_columns, -> { select(:id, :filename, :filesize, :created_on, :cloud_url, :author_id, :content_type, :container_type, :container_id) }
|
|
scope :search_by_container, -> (ids) {where(container_id: ids)}
|
|
scope :unified_setting, -> {where("unified_setting = ? ", 1)}
|
|
|
|
validates_length_of :description, maximum: 100, message: "不能超过100个字符"
|
|
|
|
DCODES = %W(2 3 4 5 6 7 8 9 a b c f e f g h i j k l m n o p q r s t u v w x y z)
|
|
|
|
def diskfile
|
|
File.join(File.join(Rails.root, "files"), disk_directory.to_s, disk_filename.to_s)
|
|
end
|
|
|
|
def relative_path_filename
|
|
File.join(disk_directory.to_s, disk_filename.to_s)
|
|
end
|
|
|
|
def title
|
|
filename
|
|
# title = filename
|
|
# if container && container.is_a?(StudentWork) && author_id != User.current.id
|
|
# course = container&.homework_common&.course
|
|
# unless User.current.teacher_of_course?(course)
|
|
# title = "#{Time.now.strftime('%Y%m%d%H%M%S')}_#{DCODES.sample(8).join}" + File.extname(filename)
|
|
# end
|
|
# end
|
|
# title
|
|
end
|
|
|
|
def downloads_count
|
|
downloads
|
|
end
|
|
|
|
def quotes_count
|
|
quotes.nil? ? 0 : quotes
|
|
end
|
|
|
|
def self.associate_container(ids, container_id, container_type, attachtype=1)
|
|
return false if ids.blank? || !ids.is_a?(Array)
|
|
ids.each do |id|
|
|
attachment = Attachment.find id
|
|
attachment.update_attributes(container_id: container_id, container_type: container_type, attachtype: attachtype)
|
|
end
|
|
end
|
|
|
|
# Returns an unsaved copy of the attachment
|
|
def copy(attributes=nil)
|
|
copy = self.class.new
|
|
copy.attributes = self.attributes.dup.except("id", "downloads", "quotes")
|
|
copy.attributes = attributes if attributes
|
|
copy
|
|
end
|
|
|
|
def set_publish_time(publish_time)
|
|
self.unified_setting = 1
|
|
if publish_time.blank?
|
|
self.publish_time = Time.now
|
|
self.is_publish = 1
|
|
else
|
|
self.is_publish = publish_time.to_s > (format_time Time.now).to_s ? 0 : 1
|
|
self.publish_time = publish_time.to_s > (format_time Time.now).to_s ? publish_time : Time.now
|
|
end
|
|
end
|
|
|
|
def set_course_group_publish_time(course, course_group_publish_times)
|
|
self.unified_setting = 0
|
|
min_publish_time = ""
|
|
course_group_publish_times.each do |obj|
|
|
if obj && obj[:course_group_id]
|
|
publish_time = obj[:publish_time]
|
|
if !publish_time.blank? && publish_time < min_publish_time
|
|
min_publish_time = publish_time
|
|
elsif publish_time.blank?
|
|
publish_time = Time.now
|
|
end
|
|
attachment_group_setting = self.attachment_group_settings.where(course_group_id: obj[:course_group_id], course_id: course.id).first
|
|
if attachment_group_setting.present?
|
|
attachment_group_setting.update_columns(publish_time: publish_time)
|
|
else
|
|
self.attachment_group_settings.create(
|
|
:course_group_id => obj[:course_group_id],
|
|
:course_id => course.id,
|
|
:publish_time => publish_time
|
|
)
|
|
end
|
|
end
|
|
end
|
|
self.is_publish = min_publish_time > (format_time Time.now).to_s ? 0 : 1
|
|
self.publish_time = min_publish_time > (format_time Time.now).to_s ? min_publish_time : self.created_on
|
|
end
|
|
|
|
def become_history
|
|
history = self.attachment_histories.first
|
|
new_attachment_history = AttachmentHistory.new(self.attributes.except("id", "resource_bank_id", "unified_setting", "course_second_category_id", "delay_publish").merge(
|
|
attachment_id: self.id,
|
|
version: history.nil? ? 1 : history.version + 1,
|
|
))
|
|
new_attachment_history
|
|
end
|
|
|
|
def copy_attributes_from_new_attachment(new_attachment)
|
|
self.attributes = new_attachment.attributes.dup.except("id","container_id","container_type","is_public","downloads", "quotes",'is_publish','publish_time', "delay_publish")
|
|
end
|
|
|
|
def set_public(is_public)
|
|
if is_public == true
|
|
is_public = 1
|
|
elsif is_public == false
|
|
is_public = 0
|
|
end
|
|
end
|
|
|
|
#判断是否为pdf文件
|
|
def is_pdf?
|
|
is_pdf = false
|
|
file_content_type = content_type
|
|
file_ext_type = File.extname(filename).strip.downcase[1..-1]
|
|
if (file_content_type.present? && file_content_type.downcase.include?("pdf")) || (file_ext_type.present? && file_ext_type.include?("pdf"))
|
|
is_pdf = true
|
|
end
|
|
is_pdf
|
|
end
|
|
|
|
end
|