{% set sum_min =0 %} {% set sum_max =0 %} {% set expected_total = 0 %} {% set count = 0 %} {% for entry in bills %} {% if entry.active %} {% set count = count + 1 %} {% set sum_min = sum_min + entry.amount_min %} {% set sum_max = sum_min + entry.amount_max %} {% set expected_total = expected_total + ((entry.amount_min + entry.amount_max) / 2) %} {% endif %} {# paidDates = 0 (bill not paid in period) pay_dates = 0 (bill not expected to be paid in this period) bill is active. #} {% if entry.paid_dates|length == 0 and entry.pay_dates|length == 0 and entry.active %} {% endif %} {# paid_dates = 0 (bill not paid in period) pay_dates > 0 (bill IS expected to be paid in this period) bill is active #} {% if entry.paid_dates|length == 0 and entry.pay_dates|length > 0 and entry.active %} {% endif %} {# paid_dates >= 0 (bill is paid X times). Don't care about pay_dates. #} {% if entry.paid_dates|length > 0 and entry.active %} {% endif %} {# bill is not active #} {% if not entry.active %} {% endif %} {% endfor %} {# calculate total#} {% if count > 0 %} {% set avg_min = (sum_min / count) %} {% set avg_max = (sum_max / count) %} {% else %} {% set avg_min = 0 %} {% set avg_max = 0 %} {% endif %}

	{{ trans('list.name') }}	{{ trans('list.linked_to_rules') }}	{{ trans('list.matchingAmount') }}	{{ trans('list.paid_current_period') }}	{{ trans('list.next_expected_match') }}	{{ trans('list.repeat_freq') }}
	{% if not entry.active %} {% endif %} {{ entry.name }} {# count attachments #} {% if entry.attachments_count > 0 %} {% endif %}	{% if entry.rules\|length > 0 %} {% for rule in entry.rules %} {{ rule.title }} {% if not rule.active %}({{ 'list_inactive_rule'\|_\|lower }}){% endif %} {% endfor %} {% endif %}	~ {{ formatAmountByCurrency(entry.currency, (entry.amount_max + entry.amount_min)/2) }}	{{ trans('components.not_expected_period') }}	{{ formatDate(entry.next_expected_match, monthAndDayFormat) }}	{{ trans('components.not_or_not_yet') }}	{{ formatDate(entry.next_expected_match, monthAndDayFormat) }}	{% for date in entry.paid_dates %} {{ formatDate(date, monthAndDayFormat) }} {% endfor %}	{{ formatDate(entry.next_expected_match, monthAndDayFormat) }}	~	~	{{ ('repeat_freq_'~entry.repeat_freq)\|_ }} {% if entry.skip > 0 %} {{ 'skips_over'\|_ }} {{ entry.skip }} {% endif %}
{{ 'sum'\|_ }} ({{ 'active_bills_only'\|_ }})			{{ formatAmountBySymbol(sum_min,'¤') }}	{{ formatAmountBySymbol(sum_max,'¤') }}
{{ 'average_per_bill'\|_ }} ({{ 'active_bills_only'\|_ }})			{{ formatAmountBySymbol(avg_min,'¤') }}	{{ formatAmountBySymbol(avg_max,'¤') }}
{{ 'expected_total'\|_ }} ({{ 'active_bills_only'\|_ }})			~ {{ formatAmountBySymbol(expected_total,'¤') }}