@extends('admin.layouts.app')
@section('title', 'Finance Reconciliation')
@section('page-title', 'Finance Reconciliation')
@section('page-subtitle', 'Reconcile portal payments, Paystack reports, and bank statement credits')
@section('content')

@if(session('success'))<div class="alert alert-success">{{ session('success') }}</div>@endif
@if(session('error'))<div class="alert alert-danger">{{ session('error') }}</div>@endif

<div class="row g-4">
    <div class="col-lg-5">
        <div class="cardx p-4">
            <h6 class="mb-3">Run New Reconciliation</h6>
            <p class="text-muted small mb-3">
                Upload the Paystack <strong>Transaction Report</strong> and <strong>Payout Report</strong> CSV exports.
                Optionally upload your organization&apos;s <strong>bank statement</strong> (Excel, CSV, or PDF) to confirm
                Paystack payouts actually credited your account.
            </p>
            <form method="POST" action="{{ route('admin.finance-reconciliation.store') }}" enctype="multipart/form-data">
                @csrf
                <div class="mb-3">
                    <label class="form-label">Conference <span class="text-muted">(optional)</span></label>
                    <select name="conference_id" class="form-select @error('conference_id') is-invalid @enderror">
                        <option value="">All conferences</option>
                        @foreach($conferences as $conf)
                            <option value="{{ $conf->id }}" @selected(old('conference_id') == $conf->id)>{{ $conf->name }}</option>
                        @endforeach
                    </select>
                    @error('conference_id')<div class="invalid-feedback">{{ $message }}</div>@enderror
                </div>
                <div class="row g-2 mb-3">
                    <div class="col-md-6">
                        <label class="form-label">Portal payments from</label>
                        <input type="date" name="period_from" value="{{ old('period_from') }}" class="form-control @error('period_from') is-invalid @enderror">
                        @error('period_from')<div class="invalid-feedback">{{ $message }}</div>@enderror
                    </div>
                    <div class="col-md-6">
                        <label class="form-label">Portal payments to</label>
                        <input type="date" name="period_to" value="{{ old('period_to') }}" class="form-control @error('period_to') is-invalid @enderror">
                        @error('period_to')<div class="invalid-feedback">{{ $message }}</div>@enderror
                    </div>
                </div>
                <div class="mb-3">
                    <label class="form-label">Paystack Transaction Report (CSV)</label>
                    <input type="file" name="transactions_csv" accept=".csv,text/csv" class="form-control @error('transactions_csv') is-invalid @enderror" required>
                    @error('transactions_csv')<div class="invalid-feedback">{{ $message }}</div>@enderror
                </div>
                <div class="mb-3">
                    <label class="form-label">Paystack Payout Report (CSV)</label>
                    <input type="file" name="payouts_csv" accept=".csv,text/csv" class="form-control @error('payouts_csv') is-invalid @enderror" required>
                    @error('payouts_csv')<div class="invalid-feedback">{{ $message }}</div>@enderror
                </div>
                <div class="mb-3">
                    <label class="form-label">Bank Statement <span class="text-muted">(optional — Excel, CSV, or PDF)</span></label>
                    <input type="file" name="bank_statement" accept=".csv,.xlsx,.xls,.pdf,text/csv,application/pdf" class="form-control @error('bank_statement') is-invalid @enderror">
                    <div class="form-text">Upload the account statement Paystack settles into. Supports NIAE bank PDF/Excel exports (NIBSS:PAYSTACK credits). Excel/CSV is most reliable.</div>
                    @error('bank_statement')<div class="invalid-feedback">{{ $message }}</div>@enderror
                </div>
                <button type="submit" class="btn btn-green"><i class="fa fa-play me-1"></i>Run Reconciliation</button>
            </form>
        </div>
    </div>

    <div class="col-lg-7">
        <div class="cardx p-4">
            <h6 class="mb-3">Reconciliation History</h6>
            <div class="table-responsive">
                <table class="table">
                    <thead>
                        <tr>
                            <th>Run</th>
                            <th>Period</th>
                            <th>Matched</th>
                            <th>Issues</th>
                            <th>Status</th>
                            <th>Date</th>
                            <th></th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($runs as $run)
                            @php
                                $issues = $run->portal_only_count + $run->paystack_only_count + $run->amount_mismatch_count + $run->settlement_variance_count;
                                if ($run->hasBankStatement()) {
                                    $issues += $run->payout_not_in_bank_count + $run->bank_only_count + $run->bank_variance_count;
                                }
                            @endphp
                            <tr>
                                <td>#{{ $run->id }}</td>
                                <td>
                                    @if($run->period_from || $run->period_to)
                                        {{ $run->period_from?->format('M d, Y') ?? '—' }} – {{ $run->period_to?->format('M d, Y') ?? '—' }}
                                    @else
                                        <span class="text-muted">All dates</span>
                                    @endif
                                    @if($run->conference)
                                        <br><small class="text-muted">{{ $run->conference->short_name ?? $run->conference->name }}</small>
                                    @endif
                                </td>
                                <td>
                                    {{ number_format($run->matched_count) }} / {{ number_format($run->portal_payment_count) }}
                                    @if($run->hasBankStatement())
                                        <br><small class="text-muted">Bank: {{ number_format($run->bank_matched_count) }} matched</small>
                                    @endif
                                </td>
                                <td>
                                    @if($run->status === 'completed' && $issues === 0)
                                        <span class="badge bg-success">Balanced</span>
                                    @elseif($run->status === 'completed')
                                        <span class="badge bg-warning text-dark">{{ number_format($issues) }} issue(s)</span>
                                    @else
                                        —
                                    @endif
                                </td>
                                <td>
                                    @if($run->status === 'completed')
                                        <span class="badge bg-success">Completed</span>
                                    @elseif($run->status === 'failed')
                                        <span class="badge bg-danger" title="{{ $run->error_message }}">Failed</span>
                                    @else
                                        <span class="badge bg-secondary">{{ ucfirst($run->status) }}</span>
                                    @endif
                                </td>
                                <td>{{ $run->created_at->format('M d, Y H:i') }}</td>
                                <td>
                                    @if($run->status === 'completed')
                                        <a href="{{ route('admin.finance-reconciliation.show', $run) }}" class="btn btn-sm btn-outline-green">View</a>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr><td colspan="7" class="text-muted">No reconciliation runs yet.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
            {{ $runs->links() }}
        </div>
    </div>
</div>

@endsection