@extends('layouts.app')
@section('content')
    <div class="page-title"><i class="fas fa-users me-2"></i>Clients Management</div>
    <p class="page-subtitle">Manage {{ $isSuperAdmin ? 'all' : '' }} clients for {{ $company->name ?? 'your company' }}</p>

    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            {{ session('success') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    @endif

    <div class="card mb-4">
        <div class="card-header d-flex justify-content-between align-items-center">
            <div><i class="fas fa-list me-2"></i>{{ $isSuperAdmin ? 'All Clients' : 'Clients' }}</div>
            <div class="btn-group" role="group">
                <a href="{{ route('clients.create') }}" class="btn btn-sm btn-success">
                    <i class="fas fa-user-plus me-1"></i>Add New Client
                </a>
                <a href="{{ route('clients.import') }}" class="btn btn-sm btn-info">
                    <i class="fas fa-file-excel me-1"></i>Import from Excel
                </a>
            </div>
        </div>
        <div class="card-body">
            <div class="row mb-3">
                @if($isSuperAdmin)
                    <div class="col-md-3">
                        <select name="company_id" class="form-select" onchange="window.location.href='{{ route('clients.index') }}?company_id=' + (this.value ? this.value : '')">
                            <option value="">All Companies</option>
                            @foreach($allCompanies as $comp)
                                <option value="{{ $comp->id }}" @selected($selectedCompanyId === $comp->id)>{{ $comp->name }}</option>
                            @endforeach
                        </select>
                    </div>
                @endif
                <div class="{{ $isSuperAdmin ? 'col-md-3' : 'col-md-6' }}">
                    <form method="GET" action="{{ route('clients.index') }}" class="input-group">
                        @if($selectedCompanyId)
                            <input type="hidden" name="company_id" value="{{ $selectedCompanyId }}">
                        @endif
                        <input type="text" name="search" class="form-control" placeholder="Search by name, account #, email or meter #..." value="{{ request('search') }}">
                        <button class="btn btn-primary" type="submit"><i class="fas fa-search"></i></button>
                    </form>
                </div>
                <div class="{{ $isSuperAdmin ? 'col-md-3' : 'col-md-3' }}">
                    <select name="status" class="form-select" onchange="window.location.href='{{ route('clients.index') }}{{ $selectedCompanyId ? '?company_id=' . $selectedCompanyId . '&' : '?' }}status=' + this.value">
                        <option value="">All Status</option>
                        @foreach($statuses as $status)
                            <option value="{{ $status }}" @selected(request('status') === $status)>{{ ucfirst($status) }}</option>
                        @endforeach
                    </select>
                </div>
            </div>

            @if($clients->count() > 0)
                <div class="table-responsive">
                    <table class="table table-hover">
                        <thead>
                            <tr>
                                <th>Name</th>
                                @if($isSuperAdmin)
                                    <th>Company</th>
                                @endif
                                <th>Account #</th>
                                <th>Block #</th>
                                <th>Lot #</th>
                                <th>Meter #</th>
                                <th>City</th>
                                <th>Status</th>
                                <th><i class="fas fa-exclamation-circle"></i> Overdue</th>
                                <th><i class="fas fa-hourglass-end"></i> Late Pay</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($clients as $client)
                                @php
                                    // Calculate overdue and late payment info
                                    $overdueCount = $client->billings()
                                        ->where('status', '!=', 'paid')
                                        ->where('due_date', '<', now())
                                        ->where('balance', '>', 0)
                                        ->count();
                                    
                                    $latePaymentCount = \App\Models\BillingCharge::where('client_id', $client->id)
                                        ->lateFees()->where('status', '!=', 'voided')->count();
                                @endphp
                                <tr>
                                    <td><strong>{{ $client->name }}</strong></td>
                                    @if($isSuperAdmin)
                                        <td>{{ $client->company->name }}</td>
                                    @endif
                                    <td><code>{{ $client->account_number }}</code></td>
                                    <td>{{ $client->block_number ?? 'N/A' }}</td>
                                    <td>{{ $client->lot_number ?? 'N/A' }}</td>
                                    <td>{{ $client->meter_number ?? 'N/A' }}</td>
                                    <td>{{ $client->city }}</td>
                                    <td>
                                        @if($client->status === 'active')
                                            <span class="badge bg-success">Active</span>
                                        @elseif($client->status === 'inactive')
                                            <span class="badge bg-warning">Inactive</span>
                                        @else
                                            <span class="badge bg-danger">Disconnected</span>
                                        @endif
                                    </td>
                                    <td>
                                        @if($overdueCount > 0)
                                            <span class="badge bg-danger">{{ $overdueCount }} <i class="fas fa-exclamation-circle"></i></span>
                                        @else
                                            <span class="badge bg-success">None</span>
                                        @endif
                                    </td>
                                    <td>
                                        @if($latePaymentCount > 0)
                                            <span class="badge bg-warning">{{ $latePaymentCount }} <i class="fas fa-hourglass-end"></i></span>
                                        @else
                                            <span class="badge bg-secondary">None</span>
                                        @endif
                                    </td>
                                    <td>
                                        <a href="{{ route('clients.show', $client) }}" class="btn btn-sm btn-info" title="View">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                        <a href="{{ route('clients.edit', $client) }}" class="btn btn-sm btn-warning" title="Edit">
                                            <i class="fas fa-edit"></i>
                                        </a>
                                        @if(Auth::user()->hasCompanyAdminAccess() || Auth::user()->isSuperAdmin())
                                        <form action="{{ route('clients.destroy', $client) }}" method="POST" style="display: inline;">
                                            @csrf
                                            @method('DELETE')
                                            <button type="submit" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure?')" title="Delete">
                                                <i class="fas fa-trash"></i>
                                            </button>
                                        </form>
                                        @endif
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>

                <nav class="mt-4">
                    {{ $clients->links('pagination::bootstrap-5') }}
                </nav>
            @else
                <div class="alert alert-info">
                    <i class="fas fa-info-circle me-2"></i>
                    No clients found. <a href="{{ route('clients.create') }}">Add your first client</a>
                </div>
            @endif
        </div>
    </div>
@endsection