Module: DoubleEntry::Reporting Private

Extended by:: Reporting

Includes:: Configurable

Included in:: Reporting

Defined in:: lib/double_entry/reporting.rb,
lib/double_entry/reporting/aggregate.rb,
lib/double_entry/reporting/day_range.rb,
lib/double_entry/reporting/hour_range.rb,
lib/double_entry/reporting/time_range.rb,
lib/double_entry/reporting/week_range.rb,
lib/double_entry/reporting/year_range.rb,
lib/double_entry/reporting/month_range.rb,
lib/double_entry/reporting/line_aggregate.rb,
lib/double_entry/reporting/aggregate_array.rb,
lib/double_entry/reporting/time_range_array.rb

This module is part of a private API. You should avoid using this module if possible, as it may be removed or be changed in the future.

Defined Under Namespace

Classes: Aggregate, AggregateArray, AggregateFunctionNotSupported, Configuration, DayRange, HourRange, LineAggregate, MonthRange, TimeRange, TimeRangeArray, WeekRange, YearRange

Instance Method Summary collapse

#aggregate(function, account, code, options = {}) ⇒ Object private
Perform an aggregate calculation on a set of transfers for an account.
#aggregate_array(function, account, code, options = {}) ⇒ Array[Money/Fixnum] private
Perform an aggregate calculation on a set of transfers for an account and return the results in an array partitioned by a time range type.
#reconciled?(account) ⇒ Boolean private
This is used by the concurrency test script.
#scopes_with_minimum_balance_for_account(minimum_balance, account_identifier) ⇒ Array<Fixnum> private
Identify the scopes with the given account identifier holding at least the provided minimum balance.

Methods included from Configurable

included

Instance Method Details

#aggregate(function, account, code, options = {}) ⇒ `Object`

This method is part of a private API. You should avoid using this method if possible, as it may be removed or be changed in the future.

Perform an aggregate calculation on a set of transfers for an account.

The transfers included in the calculation can be limited by time range and provided custom filters.

Examples:

Find the sum for all $10 :save transfers in all :checking accounts in the current month (assume the date is January 30, 2014).

time_range = DoubleEntry::TimeRange.make(2014, 1)
class ::DoubleEntry::Line
  scope :ten_dollar_transfers, -> { where(:amount => 10_00) }
end
DoubleEntry.aggregate(:sum, :checking, :save, range: time_range, filter: [:ten_dollar_transfers])

Parameters:

function (Symbol) —
The function to perform on the set of transfers. Valid functions are :sum, :count, and :average
account (Symbol) —
The symbol identifying the account to perform the aggregate calculation on. As specified in the account configuration.
code (Symbol) —
The application specific code for the type of transfer to perform an aggregate calculation on. As specified in the transfer configuration.
options (Hash) (defaults to: {}) —
a customizable set of options

Options Hash (options):

:range (DoubleEntry::TimeRange) —
Only include transfers in the given time range in the calculation.
:filter (Array[Symbol], or Array[Hash<Symbol,Parameter>]) —
A custom filter to apply before performing the aggregate calculation. Currently, filters must be monkey patched as scopes into the DoubleEntry::Line class in order to be used as filters, as the example shows. If the filter requires a parameter, it must be given in a Hash, otherwise pass an array with the symbol names for the defined scopes.

Returns:

Returns a Money object for :sum and :average calculations, or a Fixnum for :count calculations.

Raises:

(Reporting::AggregateFunctionNotSupported) —
The provided function is not supported.



62
63
64

# File 'lib/double_entry/reporting.rb', line 62

def aggregate(function, account, code, options = {})
  Aggregate.new(function, account, code, options).formatted_amount
end

#aggregate_array(function, account, code, options = {}) ⇒ `Array[Money/Fixnum]`

This method is part of a private API. You should avoid using this method if possible, as it may be removed or be changed in the future.

Perform an aggregate calculation on a set of transfers for an account and return the results in an array partitioned by a time range type.

The transfers included in the calculation can be limited by a time range and provided custom filters.

Examples:

Find the number of all $10 :save transfers in all :checking accounts per month for the entire year (Assume the year is 2014).

DoubleEntry.aggregate_array(:sum, :checking, :save, range_type: 'month', start: '2014-01-01', finish: '2014-12-31')

Parameters:

function (Symbol) —
The function to perform on the set of transfers. Valid functions are :sum, :count, and :average
account (Symbol) —
The symbol identifying the account to perform the aggregate calculation on. As specified in the account configuration.
code (Symbol) —
The application specific code for the type of transfer to perform an aggregate calculation on. As specified in the transfer configuration.
options (Hash) (defaults to: {}) —
a customizable set of options

Options Hash (options):

:filter (Array[Symbol], or Array[Hash<Symbol,Parameter>]) —
A custom filter to apply before performing the aggregate calculation. Currently, filters must be monkey patched as scopes into the DoubleEntry::Line class in order to be used as filters, as the example shows. If the filter requires a parameter, it must be given in a Hash, otherwise pass an array with the symbol names for the defined scopes.
:range_type (String) —
The type of time range to return data for. For example, specifying 'month' will return an array of the resulting aggregate calculation for each month. Valid range_types are 'hour', 'day', 'week', 'month', and 'year'
:start (String) —
The start date for the time range to perform calculations in. The default start date is the start_of_business (can be specified in configuration). The format of the string must be as follows: 'YYYY-mm-dd'
:finish (String) —
The finish (or end) date for the time range to perform calculations in. The default finish date is the current date. The format of the string must be as follows: 'YYYY-mm-dd'

Returns:

(Array[Money/Fixnum]) —
Returns an array of Money objects for :sum and :average calculations, or an array of Fixnum for :count calculations. The array is indexed by the range_type. For example, if range_type is specified as 'month', each index in the array will represent a month.

Raises:

(Reporting::AggregateFunctionNotSupported) —
The provided function is not supported.



105
106
107

# File 'lib/double_entry/reporting.rb', line 105

def aggregate_array(function, account, code, options = {})
  AggregateArray.new(function, account, code, options)
end

#reconciled?(account) ⇒ `Boolean`

This method is part of a private API. You should avoid using this method if possible, as it may be removed or be changed in the future.

This is used by the concurrency test script.

Returns:

(Boolean) —
true if all the amounts for an account add up to the final balance, which they always should.

# File 'lib/double_entry/reporting.rb', line 135

def reconciled?(account)
  scoped_lines = Line.where(:account => "#{account.identifier}", :scope => "#{account.scope}")
  sum_of_amounts = scoped_lines.sum(:amount)
  final_balance  = scoped_lines.order(:id).last[:balance]
  cached_balance = AccountBalance.find_by_account(account)[:balance]
  final_balance == sum_of_amounts && final_balance == cached_balance
end

#scopes_with_minimum_balance_for_account(minimum_balance, account_identifier) ⇒ `Array<Fixnum>`

This method is part of a private API. You should avoid using this method if possible, as it may be removed or be changed in the future.

Identify the scopes with the given account identifier holding at least the provided minimum balance.

Examples:

Find users with at least $1,000,000 in their savings accounts

DoubleEntry.scopes_with_minimum_balance_for_account(
  Money.new(1_000_000_00),
  :savings
) # might return user ids: [ 1423, 12232, 34729 ]

Parameters:

minimum_balance (Money) —
Minimum account balance a scope must have to be included in the result set.
account_identifier (Symbol)

Returns:

(Array<Fixnum>) —
Scopes

# File 'lib/double_entry/reporting.rb', line 121

def scopes_with_minimum_balance_for_account(minimum_balance, account_identifier)
  select_values(sanitize_sql_array(["    SELECT scope\n      FROM \#{AccountBalance.table_name}\n     WHERE account = ?\n       AND balance >= ?\n  SQL\nend\n", account_identifier, minimum_balance.cents])).map {|scope| scope.to_i }

Module: DoubleEntry::Reporting Private

Defined Under Namespace

Instance Method Summary collapse

Methods included from Configurable

Instance Method Details

#aggregate(function, account, code, options = {}) ⇒ Object

Examples:

Find the sum for all $10 :save transfers in all :checking accounts in the current month (assume the date is January 30, 2014).

#aggregate_array(function, account, code, options = {}) ⇒ Array[Money/Fixnum]

Examples:

Find the number of all $10 :save transfers in all :checking accounts per month for the entire year (Assume the year is 2014).

#reconciled?(account) ⇒ Boolean

#scopes_with_minimum_balance_for_account(minimum_balance, account_identifier) ⇒ Array<Fixnum>

Examples:

Find users with at least $1,000,000 in their savings accounts

#aggregate(function, account, code, options = {}) ⇒ `Object`

#aggregate_array(function, account, code, options = {}) ⇒ `Array[Money/Fixnum]`

#reconciled?(account) ⇒ `Boolean`

#scopes_with_minimum_balance_for_account(minimum_balance, account_identifier) ⇒ `Array<Fixnum>`