@extends('reports.client-statement.base')

@section('action-content')
<section class="content">
    <div class="box box-primary">
        <div class="box-header with-border">
            <h3 class="box-title">
                <i class="fa fa-file-text-o"></i> Client Statement
            </h3>
        </div>

        <div class="box-body">

            {{-- FILTER FORM --}}
            <form method="POST" action="{{ route('reports.client.generate') }}" class="row g-3 mb-4">
                @csrf

                <div class="col-md-4">
                    <label class="form-label">Client Account Number</label>
                    <input type="text"
                           name="account_number"
                           value="{{ old('account_number', request('account_number')) }}"
                           class="form-control"
                           placeholder="Enter account number"
                           required>
                </div>

                <div class="col-md-3">
                    <label class="form-label">From Date</label>
                    <input type="date"
                           name="from"
                           value="{{ old('from', request('from')) }}"
                           class="form-control"
                           required>
                </div>

                <div class="col-md-3">
                    <label class="form-label">To Date</label>
                    <input type="date"
                           name="to"
                           value="{{ old('to', request('to')) }}"
                           class="form-control"
                           required>
                </div>

                <div class="col-md-2 d-flex align-items-end">
                    <button class="btn btn-success w-100">
                        <i class="fa fa-search"></i> Generate
                    </button>
                </div>
            </form>

            <hr>

            {{-- REPORT --}}
            @if(!empty($report))

                {{-- HEADER --}}
                <div class="d-flex justify-content-between align-items-center mb-3">
                    <div>
                        <h5 class="mb-1">
                            <strong>Client:</strong>
                            {{ $client->surname }} {{ $client->first_name }}
                            ({{ $client->account_number }})
                        </h5>
                        <small class="text-muted">
                            Period:
                            {{ \Carbon\Carbon::parse($from)->format('d M Y') }}
                            -
                            {{ \Carbon\Carbon::parse($to)->format('d M Y') }}
                        </small>
                    </div>

                    {{-- PDF EXPORT --}}
                    <form method="POST"
                          action="{{ route('reports.client.pdf') }}"
                          target="_blank">
                        @csrf
                        <input type="hidden" name="account_number" value="{{ $client->account_number }}">
                        <input type="hidden" name="from" value="{{ $from }}">
                        <input type="hidden" name="to" value="{{ $to }}">

                        <button class="btn btn-danger">
                            <i class="fa fa-file-pdf-o"></i> Export PDF
                        </button>
                    </form>
                </div>

                {{-- ACCOUNTS --}}
                @foreach($report as $section)
                    <div class="mb-4">

                        <h5 class="mt-4">
                            Account Type:
                            <span class="badge bg-info">
                                {{ strtoupper($section['account']->account_type) }}
                            </span>
                        </h5>

                        <p>
                            <strong>Opening Balance:</strong>
                            <span class="text-primary">
                                {{ number_format($section['openingBalance'], 2) }}
                            </span>
                        </p>

                        <div class="table-responsive">
                            <table class="table table-bordered table-hover table-sm align-middle">
                                <thead class="table-light">
                                    <tr>
                                        <th>Date</th>
                                        <th>Type</th>
                                        <th>Reference</th>
                                        <th>Payment Method</th>
                                        <th class="text-end">Debit</th>
                                        <th class="text-end">Credit</th>
                                        <th class="text-end">Balance</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($section['transactions'] as $t)
                                        <tr class="
    {{ $t['type'] === 'Deposit' ? 'table-success' : '' }}
    {{ $t['type'] === 'Withdrawal' ? 'table-danger' : '' }}
    {{ $t['type'] === 'Fixed Deposit Payout' ? 'table-info' : '' }}
">
                                            <td>{{ \Carbon\Carbon::parse($t['date'])->format('d-m-Y') }}</td>
                                            <td>{{ $t['type'] }}</td>
                                            <td>{{ $t['ref'] }}</td>
                                            <td>{{ $t['payment_method'] }}</td>
                                            <td class="text-end">
                                                {{ $t['debit'] > 0 ? number_format($t['debit'], 2) : '-' }}
                                            </td>
                                            <td class="text-end">
                                                {{ $t['credit'] > 0 ? number_format($t['credit'], 2) : '-' }}
                                            </td>
                                            <td class="text-end">
                                                {{ number_format($t['balance'], 2) }}
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="7" class="text-center text-muted">
                                                No transactions in this period
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>

                        <p>
                            <strong>Closing Balance:</strong>
                            <span class="text-success">
                                {{ number_format($section['closingBalance'], 2) }}
                            </span>
                        </p>

                        <hr>
                    </div>
                @endforeach

            @endif
        </div>
    </div>
</section>
@endsection