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,  lambda { |date|
      date = Time.parse(date.to_s).utc.to_s(:db)
      { :conditions => [ 'valuta >= ?', date ] }
    }
    scope :end_date,    lambda{ |date|
      date = Time.parse(date.to_s).utc.to_s(:db)
      { :conditions => [ 'valuta <= ?', date ] }
    }
  end
end