forgeplus/app/models/attachment.rb

# == 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

  def to_builder 
    Jbuilder.new do |attachment|
      attachment.id self.id
      attachment.title self.title
      attachment.filesize self.filesize
      attachment.is_pdf self.is_pdf?
      attachment.created_on self.created_on.strftime("%Y-%m-%d %H:%M")
      attachment.content_type self.content_type
    end
  end
end