@extends('layouts.app')
@section('title', 'Flat Status Report')

@section('content')
    <div class="d-flex align-items-center justify-content-between mb-4">
        <div>
            <h4 class="mb-0"><i class="bi bi-house-door me-2"></i>Flat Status Report</h4>
            <p class="text-muted mb-0 small">All flats with current status, customer, and payment progress</p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('reports.export', ['format' => 'pdf', 'report' => 'flat-status'] + request()->all()) }}"
                class="btn btn-danger btn-sm" target="_blank"><i class="bi bi-file-pdf me-1"></i>PDF</a>
            <a href="{{ route('reports.export', ['format' => 'excel', 'report' => 'flat-status'] + request()->all()) }}"
                class="btn btn-success btn-sm"><i class="bi bi-file-earmark-excel me-1"></i>Excel</a>
            <a href="{{ route('reports.export', ['format' => 'csv', 'report' => 'flat-status'] + request()->all()) }}"
                class="btn btn-info text-white btn-sm"><i class="bi bi-filetype-csv me-1"></i>CSV</a>
            <button class="btn btn-secondary btn-sm" onclick="window.print()"><i class="bi bi-printer me-1"></i>Print</button>
        </div>
    </div>

    {{-- Filters --}}
    <div class="card mb-3">
        <div class="card-body py-2">
            <form method="GET" class="row g-2 align-items-end">
                <div class="col-md-4">
                    <label class="form-label small mb-1">Project</label>
                    <select name="project_id" class="form-select form-select-sm" onchange="this.form.submit()">
                        <option value="">All Projects</option>
                        @foreach ($projects as $p)
                            <option value="{{ $p->id }}" {{ $projectId == $p->id ? 'selected' : '' }}>{{ $p->project_name }}
                            </option>
                        @endforeach
                    </select>
                </div>
            </form>
        </div>
    </div>

    {{-- Summary Cards --}}
    @php
        $statusCounts = $data->groupBy('status')->map->count();
        $totalOutstanding = $data->sum('outstanding');
    @endphp
    <div class="row g-3 mb-4">
        <div class="col-sm-3">
            <div class="stat-card stat-success">
                <div class="stat-icon"><i class="bi bi-check-circle"></i></div>
                <div class="stat-info">
                    <h3>{{ $statusCounts['available'] ?? 0 }}</h3>
                    <p>Available</p>
                </div>
            </div>
        </div>
        <div class="col-sm-3">
            <div class="stat-card stat-warning">
                <div class="stat-icon"><i class="bi bi-bookmark"></i></div>
                <div class="stat-info">
                    <h3>{{ $statusCounts['booked'] ?? 0 }}</h3>
                    <p>Booked</p>
                </div>
            </div>
        </div>
        <div class="col-sm-3">
            <div class="stat-card stat-primary">
                <div class="stat-icon"><i class="bi bi-bag-check"></i></div>
                <div class="stat-info">
                    <h3>{{ $statusCounts['sold'] ?? 0 }}</h3>
                    <p>Sold</p>
                </div>
            </div>
        </div>
        <div class="col-sm-3">
            <div class="stat-card stat-danger">
                <div class="stat-icon"><i class="bi bi-currency-exchange"></i></div>
                <div class="stat-info">
                    <h3>৳{{ number_format($totalOutstanding) }}</h3>
                    <p>Outstanding</p>
                </div>
            </div>
        </div>
    </div>

    {{-- Data Table --}}
    <div class="card">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover table-sm mb-0">
                    <thead>
                        <tr>
                            <th>Project</th>
                            <th>Building</th>
                            <th>Flat #</th>
                            <th>Type</th>
                            <th>Size</th>
                            <th class="text-end">Price</th>
                            <th>Status</th>
                            <th>Customer</th>
                            <th class="text-end">Paid</th>
                            <th class="text-end">Outstanding</th>
                            <th>Progress</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($data as $row)
                            <tr>
                                <td>{{ $row['project'] }}</td>
                                <td>{{ $row['building'] }}</td>
                                <td class="fw-semibold">{{ $row['flat_number'] }}</td>
                                <td>{{ $row['type'] }}</td>
                                <td>{{ $row['size'] }}</td>
                                <td class="text-end">৳{{ number_format($row['price']) }}</td>
                                <td><span class="badge badge-{{ $row['status'] }}">{{ ucfirst($row['status']) }}</span></td>
                                <td>{{ $row['customer'] }}</td>
                                <td class="text-end text-success">৳{{ number_format($row['total_paid']) }}</td>
                                <td class="text-end text-danger">৳{{ number_format($row['outstanding']) }}</td>
                                <td style="min-width: 100px;">
                                    @if($row['progress'] > 0)
                                        <div class="progress" style="height: 6px;">
                                            <div class="progress-bar bg-success" style="width: {{ $row['progress'] }}%"></div>
                                        </div>
                                        <small class="text-muted">{{ $row['progress'] }}%</small>
                                    @else
                                        <span class="text-muted">—</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="11" class="text-center py-4 text-muted">No flats found.</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection