Firefly III: a personal finances manager
PHP accountingbudgetbudgetingbudgetscash-flowcashflowcredit-carddockerexpensesfinancefinancesfinanciallinuxmoneypaycheckpersonal-financephpphp7
@foreach($bills as $objectGroupOrder => $objectGroup)
@if(count($objectGroup['bills']) > 0)
<div class="row">
<div class="col-lg-12 col-sm-12 col-md-12">
<div class="card mb-2">
<x-elements.card-header-with-menu :cardTitle="$objectGroup['object_group_title']"
:route="route('subscriptions.create')"
:linkTitle="__('firefly.create_new_bill')"/>
<div class="card-body p-0">
<table class="table table-valign-middle table-hover table-sm" id="bill-sortable">
<thead>
<tr>
<th class="w-5"> </th>
<th class="w-25">{{ __('list.name') }}</th>
<th class="w-20 d-xl-table-cell d-none" {{-- hide on LG and smaller --}}>{{ __('list.linked_to_rules') }}</th>
<th class="w-5 text-end">{{ trans('list.matchingAmount') }}</th>
<th class="w-15">{{ trans('list.paid_current_period') }}</th>
<th class="w-15">{{ trans('list.next_expected_match') }}</th>
<th class="d-xl-table-cell d-none">{{ trans('list.repeat_freq') }}</th>
<th> </th>
</tr>
</thead>
@if(count($objectGroup['bills']) > 0)
<tbody class="bill-connected-list" data-title="{{ $objectGroup['object_group_title'] }}">
@foreach($objectGroup['bills'] as $entry)
<tr class="bill-sortable" data-id="{{ $entry['id'] }}" data-name="{{ $entry['name'] }}"
data-order="{{ $entry['order'] }}" data-position="{{ $loop->index }}">
<td>
<a class="btn btn-sm btn-outline-secondary bi bi-list bill-handle"></a>
</td>
<td>
@if(!$entry['active'])
<span class="bi bi-ban"></span>
@endif
<a href="{{ route('subscriptions.show',$entry['id']) }}"
title="{{ $entry['name'] }}">{{ $entry['name'] }}</a>
{{-- count attachments --}}
@if(count($entry['attachments']) > 0)
<span class="bi bi-paperclip"></span>
@endif
@if(null !== $entry['end_date'])
<br>
@if(carbonize($entry['end_date'])->lte($today))
<span
class="text-danger">{{ trans('firefly.bill_end_index_line', ['date' => carbonize($entry['end_date'])->isoFormat($monthAndDayFormat)]) }}</span>
@else
{{ trans('firefly.bill_end_index_line', ['date' => carbonize($entry['end_date'])->isoFormat($monthAndDayFormat)]) }}
@endif
@endif
@if($entry['extension_date'])
<br>
@if(carbonize($entry['extension_date'])->lte($today))
<span
class="text-danger">{{ trans('firefly.bill_extension_index_line', ['date' => carbonize($entry['extension_date'])->isoFormat($monthAndDayFormat)]) }}</span>
@else
{{ trans('firefly.bill_extension_index_line', ['date' => carbonize($entry['extension_date'])->isoFormat($monthAndDayFormat)]) }}
@endif
@endif
</td>
<td class="rules d-xl-table-cell d-none" {{-- hide on LG and smaller --}}>
@if(count($entry['rules']) > 0)
<ul class="list-unstyled">
@foreach($entry['rules'] as $rule)
<li>
<a href="{{ route('rules.edit', [$rule['id']]) }}?_from={{ urlencode($FF3_FROM) }}">
{{ $rule['title'] }}
</a>
@if(!$rule['active'])
({{ strtolower(__('firefly.list_inactive_rule')) }})
@endif
</li>
@endforeach
</ul>
@endif
</td>
<td class="text-end">
<span class="mr-2"
title="{{ e(format_amount_by_symbol($entry['amount_min'], $entry['currency_symbol'], $entry['currency_decimal_places'], false)) }} -- {{ e(format_amount_by_symbol($entry['amount_max'], $entry['currency_symbol'], $entry['currency_decimal_places'], false)) }}">
~ {!! format_amount_by_symbol(($entry['amount_max'] + $entry['amount_min'])/2, $entry['currency_symbol'], $entry['currency_decimal_places']) !!}
@if('0' !== $entry['pc_amount_max'] && null !== $entry['pc_amount_max'])
(~ {!! format_amount_by_symbol(($entry['pc_amount_max'] + $entry['pc_amount_min'])/2, $primaryCurrency->symbol, $primaryCurrency->decimal_places) !!}
)
@endif
</span>
</td>
{{--
paidDates = 0 (bill not paid in period)
pay_dates = 0 (bill not expected to be paid in this period)
bill is active.
--}}
@if(0 === count($entry['paid_dates']) && 0 === count($entry['pay_dates']) && $entry['active'])
<td class="paid_in_period text-muted">
{{ trans('firefly.not_expected_period') }}
</td>
<td class="expected_in_period">
@if($entry['next_expected_match'])
{{ carbonize($entry['next_expected_match'])->isoFormat($monthAndDayFormat) }}
@endif
</td>
@endif
{{--
paid_dates = 0 (bill not paid in period)
pay_dates > 0 (bill IS expected to be paid in this period)
bill is active
first pay date is in the past.
--}}
@if(0 === count($entry['paid_dates']) && count($entry['pay_dates']) > 0 && $entry['active'])
@if($entry['next_expected_match_diff'] === __('firefly.not_expected_period'))
{{-- terrible code, you should sue me for this. --}}
<td class="paid_in_period text-muted">
{{ $entry['next_expected_match_diff'] }}
</td>
@else
<td class="paid_in_period text-warning">
{{ $entry['next_expected_match_diff'] }}
<!-- {{ __('firefly.bill_expected_date', ['date' => $entry['next_expected_match_diff']]) }} -->
</td>
@endif
<td class="expected_in_period">
@foreach($entry['pay_dates'] as $date)
{{ carbonize($date)->isoFormat($monthAndDayFormat) }}<br>
@endforeach
</td>
@endif
{{--
paid_dates >= 0 (bill is paid X times).
Don't care about pay_dates.
--}}
@if(count($entry['paid_dates']) > 0 && $entry['active'])
<td class="paid_in_period text-success">
@foreach($entry['paid_dates'] as $currentPaid)
<a href="{{ route('transactions.show', $currentPaid['transaction_group_id']) }}">{{ carbonize($currentPaid['date'])->isoFormat($monthAndDayFormat) }}</a>
<br/>
@endforeach
</td>
<td class="expected_in_period">
<!-- not just show next expected match, loop all pay_dates. -->
@if($entry['next_expected_match'] && 1 === count($entry['pay_dates']))
{{ carbonize($entry['next_expected_match'])->isoFormat($monthAndDayFormat) }}
@elseif($entry['next_expected_match'] && count($entry['pay_dates']) > 0)
@foreach($entry['pay_dates'] as $date)
{{ carbonize($date)->isoFormat($monthAndDayFormat) }}<br>
@endforeach
@else
<span class="text-muted">{{ $entry['next_expected_match_diff'] }}</span>
@endif
</td>
@endif
{{-- bill is not active --}}
@if(!$entry['active'])
<td class="paid_in_period text-muted">
~
</td>
<td class="expected_in_period text-muted">~</td>
@endif
<td class="d-xl-table-cell d-none">
{{ __('firefly.repeat_freq_' . $entry['repeat_freq']) }}
@if($entry['skip'] > 0)
{{ __('firefly.skips_over') }} {{ $entry['skip'] }}
@endif
</td>
<td class="text-end">
<div class="dropdown">
<button class="btn btn-sm btn-outline-secondary dropdown-toggle" type="button" data-bs-toggle="dropdown" aria-expanded="false">
{{ __('firefly.actions') }}
</button>
<ul class="dropdown-menu">
<li><a class="dropdown-item" href="{{ route('subscriptions.edit',$entry['id']) }}?_from={{ urlencode($FF3_FROM) }}"><span class="bi bi-pencil"></span> {{ __('firefly.edit') }}</a></li>
<li><a class="dropdown-item text-danger" href="{{ route('subscriptions.delete',$entry['id']) }}?_from={{ urlencode($FF3_FROM) }}"><span class="bi bi-trash"></span> {{ __('firefly.delete') }}</a></li>
</ul>
</div>
</td>
</tr>
@endforeach
@if(array_key_exists($objectGroupOrder, $sums))
@foreach($sums[$objectGroupOrder] as $sum)
@if('0' !== $sum['avg'])
<tr {{-- hide on MD and smaller --}} class="d-lg-table-row d-none">
<td class="d-xl-table-cell d-none"> </td> <!-- handle -->
<td colspan="2" class="text-end"> <!-- title -->
<small>{{ __('firefly.sum') }} ({{ $sum['currency_name'] }})
({{ __('firefly.active_exp_bills_only') }})</small>
</td>
<td class="text-end"> <!-- amount -->
{!! format_amount_by_symbol($sum['avg'], $sum['currency_symbol'], $sum['currency_decimal_places']) !!}
</td>
<td colspan="4"> </td> <!-- handle -->
</tr>
@endif
@if('0' !== $sum['total_left_to_pay'])
<tr {{-- hide on MD and smaller --}} class="d-lg-table-row d-none">
<td class="d-xl-table-cell d-none"> </td> <!-- handle -->
<td colspan="2" class="text-end"> <!-- title -->
<small>{{ __('firefly.sum') }} ({{ $sum['currency_name'] }})
({{ __('firefly.left_to_pay_active_bills') }})</small>
</td>
<td class="text-end"> <!-- amount -->
{!! format_amount_by_symbol($sum['total_left_to_pay'], $sum['currency_symbol'], $sum['currency_decimal_places']) !!}
</td>
<td colspan="4"> </td> <!-- handle -->
</tr>
@endif
@if('0' !== $sum['per_period'])
<tr {{-- hide on MD and smaller --}} class="d-lg-table-row d-none">
<td class="d-xl-table-cell d-none"> </td> <!-- handle -->
<td colspan="2" class="text-end"> <!-- title -->
<small>{{ __('firefly.per_period_sum_' . $sum['period']) }}
({{ $sum['currency_name'] }})
({{ __('firefly.active_bills_only') }})</small>
</td>
<td class="text-end"> <!-- amount -->
{!! format_amount_by_symbol($sum['per_period'], $sum['currency_symbol'], $sum['currency_decimal_places']) !!}
</td>
<td colspan="4"> </td> <!-- handle -->
</tr>
@endif
@endforeach
@endif
</tbody>
@endif
</table>
</div>
<x-elements.card-footer-with-menu :route="route('subscriptions.create')"
:linkTitle="__('firefly.create_new_bill')"/>
</div>
</div>
</div>
@endif
@endforeach
@if(count($totals) > 0)
<h5 class="m-2">{{ __('firefly.totals') }}</h5>
<table class="table table-bordered table-sm table-hover mb-2">
<tbody>
@foreach($totals as $sum)
@if('0' !== $sum['avg'])
<tr>
<td class="text-end"> <!-- title -->
<small>{{ __('firefly.sum') }} ({{ $sum['currency_name'] }})
({{ __('firefly.active_exp_bills_only_total') }})</small>
</td>
<td class="text-end"> <!-- amount -->
{!! format_amount_by_symbol($sum['avg'], $sum['currency_symbol'], $sum['currency_decimal_places']) !!}
</td>
</tr>
@endif
@if('0' !== $sum['per_period'])
<tr>
<td class="text-end"> <!-- title -->
<small>{{ __('firefly.per_period_sum_' . $sum['period']) }} ({{ $sum['currency_name'] }})
({{ __('firefly.active_bills_only_total') }})</small>
</td>
<td class="text-end"> <!-- amount -->
{!! format_amount_by_symbol($sum['per_period'], $sum['currency_symbol'], $sum['currency_decimal_places']) !!}
</td>
</tr>
@endif
@endforeach
</tbody>
</table>
@endif