@extends('layouts.app', ['title' => 'Kunden Umsätze'])
@section('content')

<div class="container-fluid py-4" style="max-width:1000px;">

    <div class="d-flex align-items-center justify-content-between mb-4">
        <h4 class="fw-bold mb-0"><i class="bi bi-bar-chart-line me-2 text-primary"></i>Kunden Umsätze</h4>
    </div>

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

    {{-- Statistik --}}
    @php
        $totalBg      = $customers->sum('projects_sum_budget_total_tax');
        $totalSmall   = $customers->sum(fn($c) => $c->orders_repair_sum_budget_total_tax + $c->orders_spare_sum_budget_total_tax);
        $totalAll     = $totalBg + $totalSmall;
        $countActive  = $customers->filter(fn($c) => $c->projects_sum_budget_total_tax > 0 || ($c->orders_repair_sum_budget_total_tax + $c->orders_spare_sum_budget_total_tax) > 0)->count();
    @endphp
    <div class="row g-3 mb-4">
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="text-muted small mb-1">Gesamtumsatz</div>
                    <h3 class="fw-bold mb-0">{{ number_format($totalAll, 2, ',', '.') }} €</h3>
                    <div class="mt-2 rounded" style="height:4px;background:#0d6efd;"></div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="text-muted small mb-1">Bauvorhaben</div>
                    <h3 class="fw-bold mb-0">{{ number_format($totalBg, 2, ',', '.') }} €</h3>
                    <div class="mt-2 rounded" style="height:4px;background:#198754;"></div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="text-muted small mb-1">Kleine Aufträge</div>
                    <h3 class="fw-bold mb-0">{{ number_format($totalSmall, 2, ',', '.') }} €</h3>
                    <div class="mt-2 rounded" style="height:4px;background:#fd7e14;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Suche --}}
    <div class="card border-0 shadow-sm mb-3">
        <div class="card-body py-2 px-3">
            <input type="text" id="searchInput" class="form-control form-control-sm" placeholder="Kunde suchen...">
        </div>
    </div>

    {{-- Tabelle --}}
    <div class="card border-0 shadow-sm">
        <div class="card-body p-0">
            <table class="table table-hover align-middle mb-0" style="font-size:0.82rem;">
                <thead class="table-light">
                    <tr>
                        <th class="ps-3">Auftraggeber</th>
                        <th class="text-end">Bauvorhaben</th>
                        <th class="text-end pe-3">Kleine Aufträge</th>
                    </tr>
                </thead>
                <tbody id="tableBody">
                    @forelse($customers->filter(fn($c) => $c->projects_sum_budget_total_tax > 0 || ($c->orders_repair_sum_budget_total_tax + $c->orders_spare_sum_budget_total_tax) > 0) as $item)
                        <tr>
                            <td class="ps-3 fw-semibold">{{ $item->name }}</td>
                            <td class="text-end">
                                @if($item->projects_sum_budget_total_tax > 0)
                                    {{ number_format($item->projects_sum_budget_total_tax, 2, ',', '.') }} €
                                @else
                                    <span class="text-muted">—</span>
                                @endif
                            </td>
                            <td class="text-end pe-3">
                                @php $small = $item->orders_repair_sum_budget_total_tax + $item->orders_spare_sum_budget_total_tax; @endphp
                                @if($small > 0)
                                    {{ number_format($small, 2, ',', '.') }} €
                                @else
                                    <span class="text-muted">—</span>
                                @endif
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="3" class="text-center py-5 text-muted">
                                <i class="bi bi-inbox d-block fs-2 opacity-25 mb-2"></i>
                                Keine Daten vorhanden
                            </td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-light fw-semibold">
                    <tr>
                        <td class="ps-3">Gesamt ({{ $countActive }} Kunden)</td>
                        <td class="text-end">{{ number_format($totalBg, 2, ',', '.') }} €</td>
                        <td class="text-end pe-3">{{ number_format($totalSmall, 2, ',', '.') }} €</td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>

</div>

<script>
document.getElementById('searchInput').addEventListener('input', function () {
    const q = this.value.toLowerCase();
    document.querySelectorAll('#tableBody tr').forEach(function (row) {
        const name = row.querySelector('td')?.textContent.toLowerCase() ?? '';
        row.style.display = name.includes(q) ? '' : 'none';
    });
});
</script>

@endsection