class Payment < ActiveRecord::Base

  def self.rocnik
    Time.now.year
  end
  
  def self.zlomove_datum
    (self.rocnik-2).to_s+'-11-01'
  end
  
  def self.amount_paid_by_vs(vs,year=nil)
    Payment.payments_by_vs(vs,year).sum(:castka).to_i
  end

  def self.date_paid_by_vs(vs,year=nil)
    Payment.payments_by_vs(vs,year).last.andand.datum
  end
  
  def self.payments_by_vs(vs,year=nil)
    @vs = vs
    Payment.where("datum > '#{Payment.zlomove_datum}'").where("vs REGEXP '^0*#{vs}' OR identifikace = '#{vs}'").order('id')
  end
  
end