class Work < ActiveRecord::Base
  has_and_belongs_to_many :chronicleperiods
  has_and_belongs_to_many :timeevents
  has_many :prizes
  has_many :awards, :through => :prizes
  belongs_to :creator
  belongs_to :category

  validates_presence_of :category_id
  validates_presence_of :creator_id
  validates_presence_of :name
  #validates_uniqueness_of :name
  def name_with_year
    "#{name} (#{years})"
  end

  end
  def self.sort(sort)
    if sort
      find(:all, :conditions => ["creator1 like ?;", sort + '%%'], :order => 'creator1' )
      #find_all_by_creator1(params[:creator1], :order_by => "creator1 ASC")
      #find_by_sql ["SELECT TRIM(CONCAT(SUBSTRING_INDEX(REPLACE(TRIM(creators.name),'  ',' '), ' ',-1), ' ', SUBSTRING_INDEX(creators.name, ' ',1))) AS creator1, creators.name as creator FROM creators WHERE SUBSTRING_INDEX(REPLACE(TRIM(creators.name),'  ',' '), ' ',-1) like ? ORDER BY creator1;", sort + '%%']

    else
      find(:all, :order => 'creator1')
    end
  end
  def years
    (year_range_ends.blank?) ? year : "#{year} - #{year_range_ends}"
  end
  def award_ids=(param)
    self.awards = param.collect {|p| Award.find p}
  end
  def prize_won_year(award_id)
    rc = ''
    self.prizes.each do |p|
      if p.award.id == award_id
        rc = p.year_prize.to_s
        break
      end
    end
    rc
  end
  def prize_won_title(award_id)
    rc = ''
    self.prizes.each do |p|
      if p.award.id == award_id
        rc = 'selected="selected"' if (p.won == 0)
        break
      end
    end
    rc
  end
end


class Creator < ActiveRecord::Base
  has_many :works
  validates_presence_of :name
  validates_uniqueness_of :name

  def self.creator1=(creator1)
     creator1=find_by_sql ["SELECT TRIM(CONCAT(SUBSTRING_INDEX(REPLACE(TRIM(creators.name),'  ',' '), ' ',-1), ' ', SUBSTRING_INDEX(creators.name, ' ',1))) AS creator1 FROM creators WHERE creator.id = ?;", :id]
  end
end