@extends('layouts.app')

@section('content')
<div class="container-fluid">

    <div class="d-flex justify-content-between align-items-center m-3 mb-4">
        <div>
            <div class="d-flex align-items-center gap-2 mb-1">
                <i class="bi bi-people text-indigo-600 fs-4" style="color: #4f46e5;"></i>
                <h4 class="fw-bold text-dark mb-0">Customer Master Registry</h4>
            </div>
            <p class="text-muted small mb-0">Manage your master customer profiles database, unique contact entries, and
                demographic insights.</p>
        </div>
        <a href="{{ route('admin.customers.create') }}" class="btn btn-primary px-4 shadow-sm"
            style="background-color: #4f46e5; border: none; border-radius: 10px;">
            <i class="bi bi-plus-lg me-1"></i> Add New Profile
        </a>
    </div>

    <div class="alert alert-info py-1 small">Total Master Records in Database: {{ $customers->total() }}</div>

    <div class="card border-0 shadow-sm mb-4">

        {{-- 🟢 Success Alert Session Node --}}
        @if(session('success'))
        <div class="alert alert-success border-0 shadow-sm mb-3 d-flex align-items-center gap-2">
            <i class="bi bi-check-circle-fill text-success"></i>
            <div>{{ session('success') }}</div>
        </div>
        @endif

        {{-- 🔴 Critical/Database Error Alert Session Node --}}
        @if(session('error'))
        <div class="alert alert-danger border-0 shadow-sm mb-3 d-flex align-items-center gap-2">
            <i class="bi bi-exclamation-triangle-fill text-danger"></i>
            <div>{{ session('error') }}</div>
        </div>
        @endif
        <div class="card-body">
            <form action="{{ route('admin.customers.index') }}" method="GET">
                <div class="input-group">
                    <input type="text" name="search" class="form-control"
                        placeholder="Search by name, contact or city..." value="{{ request('search') }}">
                    <button class="btn btn-dark px-4" type="submit">Search</button>
                    @if(request('search'))
                    <a href="{{ route('admin.customers.index') }}" class="btn btn-outline-secondary">Clear</a>
                    @endif
                </div>
            </form>
        </div>
    </div>

    <div class="card border-0 shadow-sm">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover align-middle mb-0">
                    <thead class="table-light text-uppercase small fw-bold">
                        <tr>
                            <th class="ps-4 py-3" style="width: 80px;">Sr. No.</th>
                            <th class="py-3">Customer Name</th>
                            <th class="py-3">Contact Number</th>
                            <th class="py-3">Home City</th>
                            {{-- 📍 ADDED: Structural Billing Columns --}}
                            <th class="py-3">Latest Bill</th>
                            <th class="py-3">Purchase Date</th>
                            <th class="py-3 text-center">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($customers as $index => $customer)
                        @php
                        // Fetch the latest linked bill invoice for this specific customer
                        $latestBill = $customer->bills->last();
                        @endphp
                        <tr>
                            <td class="ps-4 fw-bold text-muted">
                                {{ $customers->firstItem() + $index }}
                            </td>

                            <td class="fw-bold text-dark">
                                {{ $customer->name }}
                                @if($customer->notes)
                                <i class="bi bi-info-circle text-muted ms-1 small" data-bs-toggle="tooltip"
                                    title="{{ $customer->notes }}"></i>
                                @endif
                            </td>
                            <td class="text-muted small">{{ $customer->contact }}</td>
                            <td><span class="badge bg-light text-dark border">{{ $customer->city }}</span></td>

                            {{-- 📍 Live Relationship Data Injection --}}
                            <td class="fw-bold text-primary">
                                ₹{{ $latestBill ? number_format($latestBill->bill_amount, 2) : '0.00' }}
                            </td>
                            <td class="small text-muted">
                                {{ $latestBill ? \Carbon\Carbon::parse($latestBill->purchase_date)->format('d M, Y') :
                                'N/A' }}
                            </td>

                            <td class="text-center">
                                <div class="btn-group shadow-sm">
                                    <a href="{{ route('admin.customers.edit', $customer->id) }}"
                                        class="btn btn-sm btn-outline-primary"><i class="bi bi-pencil"></i></a>

                                    <form action="{{ route('admin.customers.destroy', $customer->id) }}" method="POST"
                                        class="d-inline">
                                        @csrf
                                        @method('DELETE')
                                        <button type="submit" class="btn btn-sm btn-outline-danger"
                                            onclick="return confirm('Are you sure you want to delete this customer profile?')">
                                            <i class="bi bi-trash"></i>
                                        </button>
                                    </form>
                                </div>
                            </td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="7" class="text-center py-5 text-muted">
                                <i class="bi bi-inbox fs-2 d-block mb-2"></i>
                                No customer master profiles found.
                            </td>
                        </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="mt-4">
        {{ $customers->appends(request()->query())->links('pagination::bootstrap-5') }}
    </div>
</div>
@endsection