@php
    $showActivity = (Auth::user()->can('hc_dash.view') && (isset($farmersWithAdvances) || isset($farmersWithDebtNoPhone) || isset($unbalancedJournals)))
        || (Auth::user()->can('pending_payment_vouchers.view') && isset($paymentVouchers) && $paymentVouchers->count())
        || (Auth::user()->can('recent_sponsorships.view') && !empty($sponsorship));
@endphp

@if ($showActivity)
<div class="chm-section">
    <div class="chm-section-title"><i class="fa-solid fa-clock-rotate-left"></i> Needs Attention</div>

    @if (Auth::user()->can('hc_dash.view') && (isset($farmersWithAdvances) || isset($farmersWithDebtNoPhone)))
    <div class="row g-3 mb-4">
        <div class="col-lg-6">
            <div class="chm-activity-card h-100">
                <div class="card-header">
                    <h6><i class="fa-solid fa-wallet text-warning"></i> Farmers with Outstanding Advances</h6>
                    <a href="{{ route('all.advances') }}" class="chm-kpi-link small">View all advances <i class="fa-solid fa-arrow-right fa-xs"></i></a>
                </div>
                <div class="table-responsive">
                    <table class="table align-middle mb-0">
                        <thead>
                            <tr>
                                <th>Farmer</th>
                                <th>Name</th>
                                <th class="text-end">Balance</th>
                                <th>Breakdown</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($farmersWithAdvances ?? [] as $row)
                            <tr>
                                <td>
                                    @can('farmer_profile.view')
                                        <a href="{{ route('farmer.profile.view', $row->farmer_id) }}" class="fw-medium text-decoration-none">
                                            {{ $row->farmer_number }}
                                        </a>
                                    @else
                                        <span class="fw-medium">{{ $row->farmer_number }}</span>
                                    @endcan
                                </td>
                                <td>{{ $row->name }}</td>
                                <td class="text-end fw-semibold text-danger">UGX {{ number_format($row->balance, 0) }}</td>
                                <td><span class="text-muted small">{{ $row->breakdown ?: '—' }}</span></td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="4" class="text-center text-muted py-4">
                                    <i class="fa-regular fa-circle-check me-1"></i> No farmers with outstanding advances.
                                </td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        <div class="col-lg-6">
            <div class="chm-activity-card h-100">
                <div class="card-header">
                    <h6><i class="fa-solid fa-phone-slash text-danger"></i> Farmers with Debt — No Phone</h6>
                    <a href="{{ Auth::user()->can('sms.send') ? route('sms.form') : route('all.farmers') }}" class="chm-kpi-link small">
                        {{ Auth::user()->can('sms.send') ? 'SMS Center' : 'All farmers' }}
                        <i class="fa-solid fa-arrow-right fa-xs"></i>
                    </a>
                </div>
                <div class="table-responsive">
                    <table class="table align-middle mb-0">
                        <thead>
                            <tr>
                                <th>Farmer</th>
                                <th>Name</th>
                                <th class="text-end">Balance</th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($farmersWithDebtNoPhone ?? [] as $row)
                            <tr>
                                <td><span class="fw-medium">{{ $row->farmer_number }}</span></td>
                                <td>{{ $row->name }}</td>
                                <td class="text-end fw-semibold text-danger">UGX {{ number_format($row->balance, 0) }}</td>
                                <td class="text-end">
                                    @can('farmer.edit')
                                        <a href="{{ route('edit.farmer', $row->farmer_id) }}" class="btn btn-sm btn-outline-primary">
                                            Add phone
                                        </a>
                                    @endcan
                                </td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="4" class="text-center text-muted py-4">
                                    <i class="fa-regular fa-circle-check me-1"></i> All farmers with debt have contact numbers on file.
                                </td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    @endif

    @if (Auth::user()->can('hc_dash.view') && isset($unbalancedJournals))
    <div class="chm-activity-card mb-4">
        <div class="card-header">
            <h6><i class="fa-solid fa-scale-unbalanced text-danger"></i> Unbalanced Journal Entries</h6>
            @can('balance_check.view')
                <a href="{{ route('balance.check') }}" class="chm-kpi-link small">Full balance check <i class="fa-solid fa-arrow-right fa-xs"></i></a>
            @endcan
        </div>
        <div class="table-responsive">
            <table class="table align-middle mb-0">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Reference</th>
                        <th>Description</th>
                        <th class="text-end">Difference</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($unbalancedJournals as $entry)
                    <tr>
                        <td><span class="text-muted">{{ $entry['entry_date'] ? \Carbon\Carbon::parse($entry['entry_date'])->format('M j, Y') : '—' }}</span></td>
                        <td><span class="fw-medium">{{ $entry['reference'] ?: '—' }}</span></td>
                        <td><span class="text-muted">{{ Str::limit($entry['description'] ?? '', 40) }}</span></td>
                        <td class="text-end fw-semibold text-danger">{{ number_format($entry['difference'], 2) }}</td>
                        <td class="text-end">
                            @can('journals.view')
                                <a href="{{ route('journals.show', $entry['id']) }}" class="btn btn-sm btn-outline-primary">View</a>
                            @endcan
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="5" class="text-center text-muted py-4">
                            <i class="fa-regular fa-circle-check me-1"></i> All journal entries in this period are balanced.
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
    @endif

    @if (Auth::user()->can('pending_payment_vouchers.view') && isset($paymentVouchers) && $paymentVouchers->count())
    <div class="chm-activity-card mb-4">
        <div class="card-header">
            <h6><i class="fa-solid fa-money-check-dollar text-success"></i> Payment Vouchers Pending Cash</h6>
            <a href="{{ route('all.payment.vouchers') }}" class="chm-kpi-link small">View all <i class="fa-solid fa-arrow-right fa-xs"></i></a>
        </div>
        <div class="table-responsive">
            <table class="table align-middle mb-0">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Voucher</th>
                        <th>Farmer</th>
                        <th class="text-end">Amount</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($paymentVouchers as $voucher)
                    <tr>
                        <td><span class="text-muted">{{ \Carbon\Carbon::parse($voucher->date_saved)->format('M j, Y') }}</span></td>
                        <td><span class="fw-medium">#{{ $voucher->id }}</span></td>
                        <td>{{ $voucher->farmer_fname }} {{ $voucher->farmer_lname }}</td>
                        <td class="text-end fw-semibold">UGX {{ number_format($voucher->net_pay, 0) }}</td>
                        <td>
                            @can('payment_voucher_pending_payment.view')
                                <a href="{{ route('payment.voucher.payment', $voucher->id) }}" class="btn btn-sm btn-primary">
                                    Pay
                                </a>
                            @endcan
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif

    @if (Auth::user()->can('recent_sponsorships.view') && !empty($sponsorship))
    <div class="chm-activity-card">
        <div class="card-header">
            <h6><i class="fa-solid fa-hand-holding-heart text-success"></i> Latest Sponsorships</h6>
            <a href="{{ route('all.children') }}" class="chm-kpi-link small">View all <i class="fa-solid fa-arrow-right fa-xs"></i></a>
        </div>
        <div class="table-responsive">
            <table class="table align-middle mb-0">
                <thead>
                    <tr>
                        <th>Child</th>
                        <th>Name</th>
                        <th>Sponsor</th>
                        <th>Start Date</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($sponsorship as $item)
                    <tr>
                        <td>
                            <div class="d-flex align-items-center gap-2">
                                <img src="{{ $item['child_photo'] }}" alt="" class="chm-avatar">
                                <a href="{{ route('child.profile.view', ['id_child' => $item['id_child']]) }}" class="fw-medium text-decoration-none">
                                    {{ $item['child_number'] }}
                                </a>
                            </div>
                        </td>
                        <td>{{ $item['child_name'] }}</td>
                        <td>{{ $item['sponsor_name'] }}</td>
                        <td><span class="text-muted">{{ $item['start_date'] }}</span></td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif
</div>
@endif