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] }
  end
end