@extends('admin.layouts.app')
@section('title', get_setting('site_name').' | '.__('PF Yearly Summary'))
@section('content')
    @php
        $types = ['OPENING_BALANCE','INTEREST','CONTRIB_EMP','CONTRIB_EMPLOYER','LOAN_DISBURSE','LOAN_REPAY','WITHDRAWAL','ADJUST'];
    @endphp
    <div class="row mt-3 mb-3">
        <div class="col-12 col-xl-11 mx-auto">
            <div class="card">
                <div class="card-header d-flex flex-wrap justify-content-between align-items-center">
                    <h5 class="mb-0">{{ __('Provident Fund — Yearly Summary') }} ({{ $year }})</h5>
                    <form method="get" class="form-inline">
                        <label class="mr-2 mb-0">{{ __('Year') }}</label>
                        <select name="year" class="select2 form-control custom-select fund-year-select fund-year-select-auto-submit" style="width: 120px; min-width: 120px;"
                                data-placeholder="{{ __('Year') }}">
                            @for($y = (int) date('Y'); $y >= 2020; $y--)
                                <option value="{{ $y }}" @selected($year === $y)>{{ $y }}</option>
                            @endfor
                        </select>
                    </form>
                </div>
                <div class="card-body table-responsive">
                    <p class="text-muted small">{{ __('Totals from PF ledger by calendar month and entry type (organization-wide).') }}</p>
                    <table class="table table-sm table-bordered">
                        <thead class="thead-light">
                        <tr>
                            <th>{{ __('Month') }}</th>
                            @foreach($types as $t)
                                <th class="text-right">{{ $t }}</th>
                            @endforeach
                            <th class="text-right">{{ __('Month Total') }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach(range(1, 12) as $m)
                            @php
                                $rowTotal = 0;
                                foreach ($types as $t) {
                                    $rowTotal += (float) ($monthly[$m][$t] ?? 0);
                                }
                            @endphp
                            <tr>
                                <td>{{ \Carbon\Carbon::create(2000, $m, 1)->format('F') }}</td>
                                @foreach($types as $t)
                                    <td class="text-right">{{ number_format((float) ($monthly[$m][$t] ?? 0), 2) }}</td>
                                @endforeach
                                <td class="text-right font-weight-bold">{{ number_format($rowTotal, 2) }}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('script')
    <script>
        $(function () {
            $('.fund-year-select-auto-submit').on('change', function () {
                $(this).closest('form').submit();
            });
        });
    </script>
@endsection