@extends('admin.layouts.app')
@section('title', 'Reconciliation Report #'.$run->id)
@section('page-title', 'Reconciliation Report #'.$run->id)
@section('page-subtitle', 'Portal payments vs Paystack transactions and payouts')
@section('content')

@php
    $matches = collect($report['transaction_matches'] ?? []);
    $settlements = collect($report['settlement_reconciliation'] ?? []);
    $bankReport = $report['bank_reconciliation'] ?? null;
    $matched = $matches->where('status', 'matched');
    $portalOnly = $matches->where('status', 'portal_only');
    $paystackOnly = $matches->where('status', 'paystack_only');
    $mismatches = $matches->where('status', 'amount_mismatch');
    $bankPayoutMatches = collect($bankReport['payout_matches'] ?? []);
    $bankMatched = $bankPayoutMatches->where('status', 'matched');
    $payoutNotInBank = $bankPayoutMatches->where('status', 'payout_not_in_bank');
    $bankOnly = collect($bankReport['bank_only'] ?? []);
    $bankSettlements = collect($bankReport['bank_settlement_reconciliation'] ?? []);
    $balanced = $run->isBalanced();
@endphp

<div class="mb-3">
    <a href="{{ route('admin.finance-reconciliation.index') }}" class="btn btn-outline-secondary btn-sm"><i class="fa fa-arrow-left me-1"></i>Back to Reconciliation</a>
</div>

@if($balanced)
    <div class="alert alert-success"><i class="fa fa-circle-check me-1"></i> Reconciliation is balanced — portal, Paystack, payouts@if($run->hasBankStatement()) and bank credits@endif all align.</div>
@else
    <div class="alert alert-warning"><i class="fa fa-triangle-exclamation me-1"></i> Reconciliation has discrepancies. Review the sections below.</div>
@endif

@if(!empty($bankReport['warnings']))
    @foreach($bankReport['warnings'] as $warning)
        <div class="alert alert-info py-2 small mb-2"><i class="fa fa-info-circle me-1"></i> {{ $warning }}</div>
    @endforeach
@endif

<div class="row g-3 mb-4">
    <div class="col-md-3"><div class="cardx metric"><small>Portal Payments</small><h3>{{ number_format($run->portal_payment_count) }}</h3><small class="text-muted">₦{{ number_format($run->portal_gross_total, 2) }}</small></div></div>
    <div class="col-md-3"><div class="cardx metric"><small>Paystack Transactions</small><h3>{{ number_format($run->paystack_transaction_count) }}</h3><small class="text-muted">₦{{ number_format($run->paystack_gross_total, 2) }}</small></div></div>
    <div class="col-md-3"><div class="cardx metric"><small>Matched</small><h3>{{ number_format($run->matched_count) }}</h3><small class="text-muted">Net due: ₦{{ number_format($run->paystack_net_total, 2) }}</small></div></div>
    <div class="col-md-3"><div class="cardx metric"><small>Payouts Settled</small><h3>₦{{ number_format($run->payout_settled_total, 2) }}</h3><small class="text-muted">Fees: ₦{{ number_format($run->paystack_fees_total, 2) }}</small></div></div>
</div>

<div class="row g-3 mb-4">
    <div class="col-md-3"><div class="cardx metric border-warning"><small>Portal Only</small><h3 class="text-warning">{{ number_format($run->portal_only_count) }}</h3></div></div>
    <div class="col-md-3"><div class="cardx metric border-warning"><small>Paystack Only</small><h3 class="text-warning">{{ number_format($run->paystack_only_count) }}</h3></div></div>
    <div class="col-md-3"><div class="cardx metric border-danger"><small>Amount Mismatches</small><h3 class="text-danger">{{ number_format($run->amount_mismatch_count) }}</h3></div></div>
    <div class="col-md-3"><div class="cardx metric border-danger"><small>Settlement Variances</small><h3 class="text-danger">{{ number_format($run->settlement_variance_count) }}</h3></div></div>
</div>

@if($run->hasBankStatement())
<div class="row g-3 mb-4">
    <div class="col-md-3"><div class="cardx metric"><small>Bank Credits</small><h3>{{ number_format($run->bank_credit_count) }}</h3><small class="text-muted">₦{{ number_format($run->bank_credit_total, 2) }}</small></div></div>
    <div class="col-md-3"><div class="cardx metric"><small>Payouts in Bank</small><h3>{{ number_format($run->bank_matched_count) }}</h3></div></div>
    <div class="col-md-3"><div class="cardx metric border-warning"><small>Payout Not in Bank</small><h3 class="text-warning">{{ number_format($run->payout_not_in_bank_count) }}</h3></div></div>
    <div class="col-md-3"><div class="cardx metric border-warning"><small>Bank Only / Variances</small><h3 class="text-warning">{{ number_format($run->bank_only_count) }} / {{ number_format($run->bank_variance_count) }}</h3></div></div>
</div>
@endif

<ul class="nav nav-tabs mb-3" role="tablist">
    <li class="nav-item"><button class="nav-link active" data-bs-toggle="tab" data-bs-target="#tab-matched">Matched ({{ $matched->count() }})</button></li>
    <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-portal">Portal Only ({{ $portalOnly->count() }})</button></li>
    <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-paystack">Paystack Only ({{ $paystackOnly->count() }})</button></li>
    <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-mismatch">Mismatches ({{ $mismatches->count() }})</button></li>
    <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-settlement">Settlements ({{ $settlements->count() }})</button></li>
    @if($run->hasBankStatement())
        <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-bank-matched">Bank Matched ({{ $bankMatched->count() }})</button></li>
        <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-payout-not-bank">Payout Not in Bank ({{ $payoutNotInBank->count() }})</button></li>
        <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-bank-only">Bank Only ({{ $bankOnly->count() }})</button></li>
        <li class="nav-item"><button class="nav-link" data-bs-toggle="tab" data-bs-target="#tab-bank-settlement">Bank Settlements ({{ $bankSettlements->count() }})</button></li>
    @endif
</ul>

<div class="tab-content">
    <div class="tab-pane fade show active" id="tab-matched">
        <div class="cardx p-4">
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Reference</th><th>User</th><th>Conference</th><th>Portal</th><th>Paystack</th><th>Net Due</th><th>Fees</th><th>Settlement</th></tr></thead>
                    <tbody>
                        @forelse($matched as $row)
                            <tr>
                                <td>{{ $row['reference'] }}</td>
                                <td>{{ $row['portal_user'] ?? '—' }}<br><small class="text-muted">{{ $row['portal_email'] ?? '' }}</small></td>
                                <td>{{ $row['portal_conference'] ?? '—' }}</td>
                                <td>₦{{ number_format($row['portal_amount'], 2) }}</td>
                                <td>₦{{ number_format($row['paystack_amount'], 2) }}</td>
                                <td>₦{{ number_format($row['paystack_amount_due'], 2) }}</td>
                                <td>₦{{ number_format($row['paystack_fees'], 2) }}</td>
                                <td>{{ $row['settlement_date'] ?? '—' }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="8" class="text-muted">No matched transactions.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-portal">
        <div class="cardx p-4">
            <p class="text-muted small">Successful portal payments with no matching Paystack transaction reference in the uploaded report.</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Reference</th><th>User</th><th>Conference</th><th>Type</th><th>Amount</th><th>Paid At</th><th></th></tr></thead>
                    <tbody>
                        @forelse($portalOnly as $row)
                            <tr>
                                <td>{{ $row['reference'] }}</td>
                                <td>{{ $row['portal_user'] ?? '—' }}<br><small class="text-muted">{{ $row['portal_email'] ?? '' }}</small></td>
                                <td>{{ $row['portal_conference'] ?? '—' }}</td>
                                <td>{{ str_replace('_', ' ', ucfirst($row['portal_type'] ?? '')) }}</td>
                                <td>₦{{ number_format($row['portal_amount'], 2) }}</td>
                                <td>{{ $row['portal_paid_at'] ?? '—' }}</td>
                                <td>
                                    @if(!empty($row['payment_id']))
                                        <a href="{{ route('admin.payments.show', $row['payment_id']) }}" class="btn btn-sm btn-outline-green">View</a>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr><td colspan="7" class="text-muted">No unmatched portal payments.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-paystack">
        <div class="cardx p-4">
            <p class="text-muted small">Paystack transactions in the CSV with no matching portal payment record.</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Reference</th><th>Email</th><th>Amount</th><th>Net Due</th><th>Fees</th><th>Transaction Date</th><th>Settlement</th></tr></thead>
                    <tbody>
                        @forelse($paystackOnly as $row)
                            <tr>
                                <td>{{ $row['reference'] }}</td>
                                <td>{{ $row['paystack_email'] ?? '—' }}</td>
                                <td>₦{{ number_format($row['paystack_amount'], 2) }}</td>
                                <td>₦{{ number_format($row['paystack_amount_due'], 2) }}</td>
                                <td>₦{{ number_format($row['paystack_fees'], 2) }}</td>
                                <td>{{ $row['paystack_transaction_date'] ?? '—' }}</td>
                                <td>{{ $row['settlement_date'] ?? '—' }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="7" class="text-muted">No unmatched Paystack transactions.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-mismatch">
        <div class="cardx p-4">
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Reference</th><th>User</th><th>Portal Amount</th><th>Paystack Amount</th><th>Variance</th><th>Settlement</th></tr></thead>
                    <tbody>
                        @forelse($mismatches as $row)
                            <tr class="table-warning">
                                <td>{{ $row['reference'] }}</td>
                                <td>{{ $row['portal_user'] ?? '—' }}</td>
                                <td>₦{{ number_format($row['portal_amount'], 2) }}</td>
                                <td>₦{{ number_format($row['paystack_amount'], 2) }}</td>
                                <td>₦{{ number_format($row['variance'], 2) }}</td>
                                <td>{{ $row['settlement_date'] ?? '—' }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="6" class="text-muted">No amount mismatches.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-settlement">
        <div class="cardx p-4">
            <p class="text-muted small">Compares total <strong>Amount Due</strong> from transaction reports (by settlement date) against <strong>Settled Amount</strong> from payout reports.@if($run->hasBankStatement()) Bank credit totals are shown when available.@endif</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead>
                        <tr>
                            <th>Settlement Date</th>
                            <th>Transaction Net</th>
                            <th>Payout Settled</th>
                            <th>Paystack Variance</th>
                            @if($run->hasBankStatement())<th>Bank Credits</th><th>Bank Variance</th>@endif
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($settlements as $row)
                            <tr class="{{ $row['status'] === 'variance' || ($row['bank_status'] ?? null) === 'variance' ? 'table-warning' : '' }}">
                                <td>{{ $row['settlement_date'] }}</td>
                                <td>₦{{ number_format($row['transaction_net_total'], 2) }}</td>
                                <td>₦{{ number_format($row['payout_settled_total'], 2) }}</td>
                                <td>₦{{ number_format($row['variance'], 2) }}</td>
                                @if($run->hasBankStatement())
                                    <td>₦{{ number_format($row['bank_credit_total'] ?? 0, 2) }}</td>
                                    <td>{{ isset($row['bank_variance']) ? '₦'.number_format($row['bank_variance'], 2) : '—' }}</td>
                                @endif
                                <td>
                                    @if($row['status'] === 'matched' && (($row['bank_status'] ?? 'matched') === 'matched' || ! $run->hasBankStatement()))
                                        <span class="badge bg-success">Matched</span>
                                    @else
                                        <span class="badge bg-warning text-dark">Variance</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr><td colspan="{{ $run->hasBankStatement() ? 7 : 5 }}" class="text-muted">No settlement data found.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    @if($run->hasBankStatement())
    <div class="tab-pane fade" id="tab-bank-matched">
        <div class="cardx p-4">
            <p class="text-muted small">Paystack payouts matched to incoming bank credits by amount and date (within 3-day window).</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Payout Date</th><th>Payout Amount</th><th>Bank Date</th><th>Bank Amount</th><th>Days Diff</th><th>Description</th></tr></thead>
                    <tbody>
                        @forelse($bankMatched as $row)
                            <tr>
                                <td>{{ $row['payout_settlement_date'] }}</td>
                                <td>₦{{ number_format($row['payout_amount'], 2) }}</td>
                                <td>{{ $row['bank_date'] }}</td>
                                <td>₦{{ number_format($row['bank_amount'], 2) }}</td>
                                <td>{{ $row['days_difference'] }}</td>
                                <td>{{ Str::limit($row['bank_description'] ?? '—', 60) }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="6" class="text-muted">No payout-to-bank matches found.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-payout-not-bank">
        <div class="cardx p-4">
            <p class="text-muted small">Paystack reports a payout but no matching credit was found in the bank statement.</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Payout Date</th><th>Payout Amount</th></tr></thead>
                    <tbody>
                        @forelse($payoutNotInBank as $row)
                            <tr class="table-warning">
                                <td>{{ $row['payout_settlement_date'] }}</td>
                                <td>₦{{ number_format($row['payout_amount'], 2) }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="2" class="text-muted">All payouts were found in the bank statement.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-bank-only">
        <div class="cardx p-4">
            <p class="text-muted small">Bank credits not matched to any Paystack payout in the uploaded reports.</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Bank Date</th><th>Amount</th><th>Paystack-like</th><th>Description</th></tr></thead>
                    <tbody>
                        @forelse($bankOnly as $row)
                            <tr>
                                <td>{{ $row['bank_date'] }}</td>
                                <td>₦{{ number_format($row['bank_amount'], 2) }}</td>
                                <td>{{ !empty($row['is_paystack_like']) ? 'Yes' : 'No' }}</td>
                                <td>{{ Str::limit($row['bank_description'] ?? '—', 80) }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="4" class="text-muted">No unmatched bank credits.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="tab-pane fade" id="tab-bank-settlement">
        <div class="cardx p-4">
            <p class="text-muted small">Daily comparison of Paystack payout totals against bank credit totals.</p>
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead><tr><th>Date</th><th>Payout Settled</th><th>Bank Credits</th><th>Variance</th><th>Status</th></tr></thead>
                    <tbody>
                        @forelse($bankSettlements as $row)
                            <tr class="{{ $row['status'] === 'variance' ? 'table-warning' : '' }}">
                                <td>{{ $row['settlement_date'] }}</td>
                                <td>₦{{ number_format($row['payout_settled_total'], 2) }}</td>
                                <td>₦{{ number_format($row['bank_credit_total'], 2) }}</td>
                                <td>₦{{ number_format($row['variance'], 2) }}</td>
                                <td>
                                    @if($row['status'] === 'matched')
                                        <span class="badge bg-success">Matched</span>
                                    @else
                                        <span class="badge bg-warning text-dark">Variance</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr><td colspan="5" class="text-muted">No bank settlement data.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
</div>

<div class="cardx p-3 mt-4 text-muted small">
  Run by {{ $run->createdBy?->name ?? 'System' }} on {{ $run->created_at->format('M d, Y H:i') }}.
  @if($run->conference) Conference: {{ $run->conference->name }}. @endif
  @if($run->period_from || $run->period_to)
    Portal filter: {{ $run->period_from?->format('Y-m-d') ?? 'start' }} to {{ $run->period_to?->format('Y-m-d') ?? 'end' }}.
  @endif
  @if($run->hasBankStatement()) Bank statement included. @endif
</div>

@endsection