@extends('layouts.finance')

@section('title', 'Store Credit Detail')
@section('subtitle', 'Available store credit from the v3 database')

@section('content')
@php
    $rows = $details['rows'] ?? collect();
    $amountColumn = $details['amount_column'] ?? null;
    $nameColumns = $details['name_columns'] ?? ['name'];
    $businessColumns = $details['business_columns'] ?? ['business_name'];
    $statusColumns = $details['status_columns'] ?? ['status'];
    $source = $details['source'] ?? null;
    $rowCount = (int) ($details['row_count'] ?? $rows->count());
    $dateFilter = $dateFilter ?? ['active' => false, 'from' => null, 'to' => null, 'label' => null];
    $dashboardRouteParams = ($dateFilter['active'] ?? false) ? ['from' => $dateFilter['from'], 'to' => $dateFilter['to']] : [];
@endphp

<div class="mb-4">
    <a href="{{ route('dashboard', $dashboardRouteParams) }}" class="btn btn-ghost" style="font-size:13px">
        <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="15 18 9 12 15 6"/></svg>
        Back to Dashboard
    </a>
</div>

@include('dashboard.cards._date-filter', ['dateFilter' => $dateFilter, 'filterRoute' => 'dashboard.cards.store-credit'])

<section class="grid kpi-grid gap-3 mb-6">
    <div class="card kpi-card" style="background:var(--pink-soft);border-color:#fbcfe8">
        <div class="kpi-icon ico-bg-pink"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M20 12V7a2 2 0 0 0-2-2H6a2 2 0 0 0-2 2v10a2 2 0 0 0 2 2h12a2 2 0 0 0 2-2v-1"/><path d="M16 12h5v3h-5a1.5 1.5 0 0 1 0-3z"/></svg></div>
        <div class="kpi-label">Available Store Credit</div>
        <div class="kpi-value" style="color:#db2777">{{ $metrics->money($details['amount'] ?? 0, 'PKR') }}</div>
        <div class="kpi-sub">All positive available balances</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-indigo"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M4 7h16M4 12h16M4 17h16"/></svg></div>
        <div class="kpi-label">Source</div>
        <div class="kpi-value">{{ $source ?: 'Not found' }}</div>
        <div class="kpi-sub">v3 database lookup</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-teal"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M17 21v-2a4 4 0 0 0-4-4H5a4 4 0 0 0-4 4v2"/><circle cx="9" cy="7" r="4"/><path d="M23 21v-2a4 4 0 0 0-3-3.87"/></svg></div>
        <div class="kpi-label">Users / Rows</div>
        <div class="kpi-value">{{ number_format($rowCount) }}</div>
        <div class="kpi-sub">Rows with positive credit</div>
    </div>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>Available Store Credit Rows</h2>
        <span class="pill">PKR</span>
    </div>
    @if(! $source)
        <div class="card-pad muted">
            No v3 store credit source was detected. Add the correct table and amount column to the store credit candidates in the metrics service.
        </div>
    @else
        <table>
            <thead>
                <tr>
                    <th>ID</th>
                    <th>User Name</th>
                    <th>Business Name</th>
                    <th>Status</th>
                    <th class="right">Available Credit</th>
                </tr>
            </thead>
            <tbody>
                @forelse($rows as $row)
                    @php
                        $firstName = trim((string) ($row->first_name ?? ''));
                        $lastName = trim((string) ($row->last_name ?? ''));
                        $name = trim($firstName.' '.$lastName);
                        if ($name === '') {
                            foreach ($nameColumns as $column) {
                                if (isset($row->{$column}) && trim((string) $row->{$column}) !== '') {
                                    $name = $row->{$column};
                                    break;
                                }
                            }
                        }
                        $businessName = $row->BusinessName ?? null;
                        if (trim((string) $businessName) === '') {
                            foreach ($businessColumns as $column) {
                                if (isset($row->{$column}) && trim((string) $row->{$column}) !== '') {
                                    $businessName = $row->{$column};
                                    break;
                                }
                            }
                        }
                        $status = null;
                        foreach ($statusColumns as $column) {
                            if (isset($row->{$column}) && trim((string) $row->{$column}) !== '') {
                                $status = $row->{$column};
                                break;
                            }
                        }
                        $name = $name ?? ($row->user_id ?? ($row->id ?? 'Unknown'));
                        $businessName = $businessName ?? '-';
                        $status = $status ?? '-';
                        $statusValue = trim((string) $status);
                        $statusLabel = match ($statusValue) {
                            '1' => 'Active',
                            '0' => 'Pending',
                            default => $statusValue !== '' ? ucfirst($statusValue) : '-',
                        };
                        $statusPill = match ($statusValue) {
                            '1' => 'pill-green',
                            '0' => 'pill-red',
                            default => strtolower($statusValue) === 'active' ? 'pill-green' : (strtolower($statusValue) === 'pending' ? 'pill-red' : ''),
                        };
                        $amount = $amountColumn ? ($row->{$amountColumn} ?? 0) : 0;
                    @endphp
                    <tr class="row-hover">
                        <td>{{ $row->id ?? '-' }}</td>
                        <td style="font-weight:600">{{ $name }}</td>
                        <td>{{ $businessName }}</td>
                        <td><span class="pill {{ $statusPill }}">{{ $statusLabel }}</span></td>
                        <td class="right" style="font-weight:700">{{ $metrics->money($amount, 'PKR') }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="5" class="muted" style="text-align:center;padding:2rem 1rem">
                            No positive store credit rows found.
                        </td>
                    </tr>
                @endforelse
            </tbody>
        </table>
        @if($rowCount > $rows->count())
            <div class="card-pad muted" style="font-size:12px">
                Showing top {{ number_format($rows->count()) }} rows by available credit.
            </div>
        @endif
    @endif
</section>
@endsection