@extends('admin.layouts.app')
@section('title', get_setting('site_name').' | '.$fundLabel.' '.__('Employee Report'))
@section('content')
    @php
        $openDate = $period['start']->format('d.m.Y');
        $closeDate = $period['end']->format('d.m.Y');
        $hideProfitColumns = $hideProfitColumns ?? false;
    @endphp
    <div class="row mt-3 mb-3">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex flex-wrap justify-content-between align-items-center">
                    <div>
                        <h5 class="mb-0">{{ $fundLabel }} — {{ __('Employee Based Report') }}</h5>
                        <p class="text-muted small mb-0">{{ __('Finance year') }}: {{ $openDate }} — {{ $closeDate }}</p>
                    </div>
                    <div class="d-flex flex-wrap align-items-center" style="gap:8px;">
                        <a class="btn btn-sm btn-success"
                           href="{{ route($exportRoute, request()->query()) }}">
                            {{ __('Export Excel') }}
                        </a>
                    </div>
                </div>
                <div class="card-body border-bottom bg-light">
                    <form method="get" class="form-row align-items-end">
                        <div class="form-group col-md-6 col-lg-2">
                            <label class="small font-weight-bold text-uppercase">{{ __('Finance year ends') }}</label>
                            <select name="fiscal_year_end" class="form-control select2 fund-year-select" style="width:100%;">
                                @for($y = (int) date('Y') + 1; $y >= 2020; $y--)
                                    <option value="{{ $y }}" @selected($fiscal_year_end === $y)>30.06.{{ $y }}</option>
                                @endfor
                            </select>
                        </div>
                        @if(! $hideProfitColumns)
                        <div class="form-group col-md-6 col-lg-2">
                            <label class="small font-weight-bold text-uppercase">{{ __('Profit ratio (%)') }}</label>
                            <input type="number" step="0.0001" min="0" max="100" name="profit_ratio" class="form-control"
                                   value="{{ $profit_ratio_percent !== null ? $profit_ratio_percent : '' }}"
                                   placeholder="{{ __('If no posted interest') }}">
                        </div>
                        @endif
                        @unless(\App\Support\BranchWiseFeature::appliesToUser())
                        <div class="form-group col-md-6 col-lg-2">
                            <label class="small font-weight-bold text-uppercase">{{ __('Branch') }}</label>
                            <select name="warehouse_id" class="form-control select2" style="width:100%;">
                                <option value="">{{ __('All') }}</option>
                                @foreach($branches as $branch)
                                    <option value="{{ $branch->id }}" @selected((int) request('warehouse_id') === (int) $branch->id)>{{ $branch->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        @endunless
                        <div class="form-group col-md-6 col-lg-2">
                            <label class="small font-weight-bold text-uppercase">{{ __('Department') }}</label>
                            <select name="department_id" class="form-control select2" style="width:100%;">
                                <option value="">{{ __('All') }}</option>
                                @foreach($departments as $dept)
                                    <option value="{{ $dept->id }}" @selected((int) request('department_id') === (int) $dept->id)>{{ $dept->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-6 col-lg-2">
                            <div class="custom-control custom-checkbox mt-4">
                                <input type="checkbox" class="custom-control-input" id="hide_zero_rows" name="hide_zero_rows" value="1"
                                       @checked(request()->boolean('hide_zero_rows'))>
                                <label class="custom-control-label" for="hide_zero_rows">{{ __('Hide zero rows') }}</label>
                            </div>
                        </div>
                        <div class="form-group col-md-6 col-lg-2 mb-0">
                            <button type="submit" class="btn btn-primary btn-block">{{ __('Generate') }}</button>
                        </div>
                    </form>
                    <p class="small text-muted mb-0 mt-2">
                        {{ __('Balance before profit') }} = {{ __('Opening') }} + {{ __('Collection') }} − {{ __('Return') }} (+ {{ __('other ledger movements') }}).
                        @if(! $hideProfitColumns)
                        {{ __('Profit') }} = {{ __('posted interest for the year, or balance × profit ratio when interest is not posted.') }}
                        @endif
                        {{ __('Date rule') }}:
                        {{ __('payroll entries use payslip salary month; all other entries use ledger entry date.') }}
                    </p>
                </div>
                <div class="card-body table-responsive p-0">
                    <table class="table table-sm table-bordered mb-0" style="font-size:12px;">
                        <thead class="thead-light">
                        <tr>
                            <th rowspan="2" class="align-middle text-center">SL #</th>
                            <th rowspan="2" class="align-middle">{{ $fundShortLabel }} #</th>
                            <th rowspan="2" class="align-middle">SID #</th>
                            <th rowspan="2" class="align-middle">{{ __('Name of Staff') }}</th>
                            <th rowspan="2" class="align-middle">{{ __('Designation') }}</th>
                            <th rowspan="2" class="align-middle text-right">{{ __('Opening Balance') }}<br><small>({{ $openDate }})</small></th>
                            <th rowspan="2" class="align-middle text-right">{{ $fundShortLabel }} {{ __('Collection During the year') }}</th>
                            <th rowspan="2" class="align-middle text-right">{{ $fundShortLabel }} {{ __('Return During the year') }}</th>
                            <th rowspan="2" class="align-middle text-right">{{ $fundShortLabel }} {{ __('Balance') }}<br><small>({{ $closeDate }})</small></th>
                            @if(! $hideProfitColumns)
                            <th rowspan="2" class="align-middle text-right">{{ __('Profit Ratio') }}</th>
                            <th rowspan="2" class="align-middle text-right">{{ __('Profit this Year') }}</th>
                            @endif
                            <th rowspan="2" class="align-middle text-right">{{ __('Closing Balance') }}<br><small>({{ $closeDate }})</small></th>
                            <th rowspan="2" class="align-middle">{{ __('Remarks') }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        @forelse($rows as $row)
                            <tr>
                                <td class="text-center">{{ $row['sl'] }}</td>
                                <td>{{ $row['cpf_no'] }}</td>
                                <td>{{ $row['sid'] }}</td>
                                <td>{{ $row['name'] }}</td>
                                <td>{{ $row['designation'] }}</td>
                                <td class="text-right">{{ number_format($row['opening_balance'], 2) }}</td>
                                <td class="text-right">{{ number_format($row['collection'], 2) }}</td>
                                <td class="text-right">{{ number_format($row['returns'], 2) }}</td>
                                <td class="text-right">{{ number_format($row['balance_before_profit'], 2) }}</td>
                                @if(! $hideProfitColumns)
                                <td class="text-right">{{ number_format($row['profit_ratio'] * 100, 4) }}%</td>
                                <td class="text-right">{{ number_format($row['profit'], 2) }}</td>
                                @endif
                                <td class="text-right font-weight-bold">{{ number_format($row['closing_balance'], 2) }}</td>
                                <td class="small">{{ $row['remarks'] }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="{{ ($hideProfitColumns ?? false) ? 11 : 13 }}" class="text-center text-muted py-4">{{ __('No employees match these filters.') }}</td>
                            </tr>
                        @endforelse
                        </tbody>
                        @if(count($rows) > 0)
                            <tfoot class="bg-light font-weight-bold">
                            <tr>
                                <td colspan="5" class="text-right">{{ __('Total') }}</td>
                                <td class="text-right">{{ number_format($totals['opening_balance'], 2) }}</td>
                                <td class="text-right">{{ number_format($totals['collection'], 2) }}</td>
                                <td class="text-right">{{ number_format($totals['returns'], 2) }}</td>
                                <td class="text-right">{{ number_format($totals['balance_before_profit'], 2) }}</td>
                                @if(! $hideProfitColumns)
                                <td></td>
                                <td class="text-right">{{ number_format($totals['profit'], 2) }}</td>
                                @endif
                                <td class="text-right">{{ number_format($totals['closing_balance'], 2) }}</td>
                                <td></td>
                            </tr>
                            </tfoot>
                        @endif
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection