require 'time'

module ActsAsAccount
  class Posting < ActiveRecord::Base
    self.table_name = :acts_as_account_postings

    belongs_to :account,       :class_name => 'ActsAsAccount::Account'
    belongs_to :other_account, :class_name => 'ActsAsAccount::Account'
    belongs_to :journal,       :class_name => 'ActsAsAccount::Journal'
    belongs_to :reference, :polymorphic => true

    scope :soll,       -> { where('amount >= 0') }
    scope :haben,      -> { where('amount < 0') }
    scope :start_date, -> date { where ['DATE(valuta) >= ?', date] }
    scope :end_date,   -> date { where ['DATE(valuta) <= ?', date] }
    scope :start_date, -> date {
      date = Time.parse(date.to_s).utc.to_s(:db)
      { :conditions => [ 'valuta >= ?', date ] }
    }
    scope :end_date,   -> date {
      date = Time.parse(date.to_s).utc.to_s(:db)
      { :conditions => [ 'valuta <= ?', date ] }
    }
  end
end