@extends('reports.savings.base')

@section('action-content')
<section class="content">

    <div class="box">
        <div class="box-header">
            <h3 class="box-title">Savings Statement</h3>
        </div>

        <div class="box-body">

            {{-- 🔍 SEARCH FORM --}}
            <form method="GET" action="{{ route('reports.savings.statement.search') }}">
                <div class="row mb-3">

                    <div class="col-md-4">
                        <label><strong>Account Number</strong></label>
                        <input type="text" name="account_number" class="form-control" required>
                    </div>

                    <div class="col-md-3">
                        <label><strong>From</strong></label>
                        <input type="date" name="from" class="form-control" required>
                    </div>

                    <div class="col-md-3">
                        <label><strong>To</strong></label>
                        <input type="date" name="to" class="form-control" required>
                    </div>

                    <div class="col-md-2 d-flex align-items-end">
                        <button class="btn btn-primary btn-block">Search</button>
                    </div>

                </div>
            </form>

            {{-- 📄 PDF BUTTON --}}
            @if(isset($transactions))
                <div class="text-right mb-3">
                    <a href="{{ route('reports.savings.statement.pdf', request()->all()) }}"
                       class="btn btn-danger">
                        📄 Download PDF
                    </a>
                </div>

                {{-- 📊 RESULTS TABLE --}}
                <div class="box box-primary">
                    <div class="box-body">

                        <table class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Type</th>
                                    <th>Remarks</th>
                                    <th>Debit (₵)</th>
                                    <th>Credit (₵)</th>
                                    <th>Balance (₵)</th>
                                </tr>
                            </thead>

                            <tbody>
                                @foreach($transactions as $trx)
                                    <tr>
                                        <td>{{ $trx->created_at->format('d-m-Y') }}</td>
                                        <td>{{ strtoupper(str_replace('_', ' ', $trx->type)) }}</td>
                                        <td>{{ $trx->remarks }}</td>

                                        <td>
                                            {{ in_array($trx->type, ['withdrawal','loan_repayment']) 
                                                ? number_format($trx->amount,2) : '0.00' }}
                                        </td>

                                        <td>
                                            {{ in_array($trx->type, ['deposit','interest_credit'])
                                                ? number_format($trx->amount,2) : '0.00' }}
                                        </td>

                                        <td>{{ number_format($trx->balance_after, 2) }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>

                    </div>
                </div>

                {{-- PAGINATION --}}
                <div class="mt-3">
                    {{ $transactions->links() }}
                </div>
            @endif

        </div>
    </div>

</section>
@endsection