@extends('layouts.app', ['title' => 'Dashboard'])
@section('content')

{{-- News-Banner --}}
@include('dashboard.news')

{{-- Header --}}
<div class="row mb-3 align-items-center">
    <div class="col">
        @include('layouts.breadcrumb', ['crumbs' => ['Dashboard']])
    </div>
</div>

@if (session('msg'))
    <div class="alert alert-success alert-dismissible" id="success-alert">
        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        <p class="text-center">{{ session('msg') }}</p>
    </div>
    <script>
        $("#success-alert").fadeTo(2000, 500).slideUp(500, function () {
            $("#success-alert").slideUp(1000);
        });
    </script>
@endif

@if (!empty($projects))

{{-- KPI Karten --}}
<div class="row g-3 mb-4">

    {{-- Alle --}}
    <div class="col-6 col-md-3 col-xl-2">
        <div class="card border-0 shadow-sm h-100">
            <div class="card-body d-flex align-items-center gap-3">
                <div class="rounded-circle d-flex align-items-center justify-content-center flex-shrink-0"
                     style="width:48px;height:48px;background:rgba(74,158,255,0.12);">
                    <i class="bi bi-folder2-open fs-5" style="color:#4a9eff;"></i>
                </div>
                <div>
                    <div class="fs-4 fw-bold lh-1">{{ $count_all }}</div>
                    <div class="text-muted small">Gesamt</div>
                </div>
            </div>
            <div class="card-footer border-0 pt-0 pb-2 px-3">
                <div class="progress" style="height:3px;">
                    <div class="progress-bar" style="width:100%;background:#4a9eff;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Angebote: in Bearbeitung --}}
    <div class="col-6 col-md-3 col-xl-2">
        <div class="card border-0 shadow-sm h-100">
            <div class="card-body d-flex align-items-center gap-3">
                <div class="rounded-circle d-flex align-items-center justify-content-center flex-shrink-0"
                     style="width:48px;height:48px;background:rgba(13,110,253,0.10);">
                    <i class="bi bi-pencil-square fs-5 text-primary"></i>
                </div>
                <div>
                    <div class="fs-4 fw-bold lh-1">{{ $projects->whereBetween('fk_status_in_company_id', [1, 3])->count() }}</div>
                    <div class="text-muted small">Angebote offen</div>
                </div>
            </div>
            <div class="card-footer border-0 pt-0 pb-2 px-3">
                <div class="progress" style="height:3px;">
                    <div class="progress-bar bg-primary" style="width:100%;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Versendet --}}
    <div class="col-6 col-md-3 col-xl-2">
        <div class="card border-0 shadow-sm h-100">
            <div class="card-body d-flex align-items-center gap-3">
                <div class="rounded-circle d-flex align-items-center justify-content-center flex-shrink-0"
                     style="width:48px;height:48px;background:rgba(25,135,84,0.10);">
                    <i class="bi bi-send fs-5 text-success"></i>
                </div>
                <div>
                    <div class="fs-4 fw-bold lh-1">{{ $projects->where('fk_status_in_company_id', '4')->count() }}</div>
                    <div class="text-muted small">Versendet</div>
                </div>
            </div>
            <div class="card-footer border-0 pt-0 pb-2 px-3">
                <div class="progress" style="height:3px;">
                    <div class="progress-bar bg-success" style="width:100%;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Beauftragt --}}
    <div class="col-6 col-md-3 col-xl-2">
        <div class="card border-0 shadow-sm h-100">
            <div class="card-body d-flex align-items-center gap-3">
                <div class="rounded-circle d-flex align-items-center justify-content-center flex-shrink-0"
                     style="width:48px;height:48px;background:rgba(25,135,84,0.15);">
                    <i class="bi bi-patch-check fs-5 text-success"></i>
                </div>
                <div>
                    <div class="fs-4 fw-bold lh-1">{{ $projects->where('fk_status_in_company_id', '6')->count() }}</div>
                    <div class="text-muted small">Beauftragt</div>
                </div>
            </div>
            <div class="card-footer border-0 pt-0 pb-2 px-3">
                <div class="progress" style="height:3px;">
                    <div class="progress-bar bg-success" style="width:100%;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Projekte in Bearbeitung --}}
    <div class="col-6 col-md-3 col-xl-2">
        <div class="card border-0 shadow-sm h-100">
            <div class="card-body d-flex align-items-center gap-3">
                <div class="rounded-circle d-flex align-items-center justify-content-center flex-shrink-0"
                     style="width:48px;height:48px;background:rgba(255,193,7,0.12);">
                    <i class="bi bi-hammer fs-5 text-warning"></i>
                </div>
                <div>
                    <div class="fs-4 fw-bold lh-1">{{ $projects->whereBetween('fk_status_in_company_id', [31, 32])->count() }}</div>
                    <div class="text-muted small">In Ausführung</div>
                </div>
            </div>
            <div class="card-footer border-0 pt-0 pb-2 px-3">
                <div class="progress" style="height:3px;">
                    <div class="progress-bar bg-warning" style="width:100%;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Abgesagt --}}
    <div class="col-6 col-md-3 col-xl-2">
        <div class="card border-0 shadow-sm h-100">
            <div class="card-body d-flex align-items-center gap-3">
                <div class="rounded-circle d-flex align-items-center justify-content-center flex-shrink-0"
                     style="width:48px;height:48px;background:rgba(220,53,69,0.10);">
                    <i class="bi bi-x-circle fs-5 text-danger"></i>
                </div>
                <div>
                    <div class="fs-4 fw-bold lh-1">{{ $projects->where('fk_status_in_company_id', '5')->count() }}</div>
                    <div class="text-muted small">Abgesagt</div>
                </div>
            </div>
            <div class="card-footer border-0 pt-0 pb-2 px-3">
                <div class="progress" style="height:3px;">
                    <div class="progress-bar bg-danger" style="width:100%;"></div>
                </div>
            </div>
        </div>
    </div>

</div>

{{-- Suche + Tabelle --}}
<div class="card border shadow-sm">
    <div class="card-header bg-white border-bottom d-flex align-items-center gap-2 py-2">
        <i class="bi bi-table text-muted"></i>
        <span class="fw-semibold">Aktive Projekte &amp; Angebote</span>
        <form action="/" method="get" class="ms-auto d-flex" style="max-width:340px;">
            <input type="text" class="form-control form-control-sm rounded-start" name="name"
                   placeholder="Bauvorhaben oder Adresse suchen..." value="{{ request('name') }}">
            <button class="btn btn-sm btn-primary rounded-end px-3" type="submit">
                <i class="bi bi-search"></i>
            </button>
        </form>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover align-middle mb-0 small">
                <thead class="table-light">
                    <tr>
                        <th class="ps-3" style="width:5%">ID</th>
                        <th>Service</th>
                        <th>Bauvorhaben</th>
                        <th class="text-end">Budget</th>
                        <th>Kunde</th>
                        <th>Planer</th>
                        <th>Deadline</th>
                        <th>Status</th>
                        <th>Abteilung</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($projects->where('fk_status_in_company_id', '!=', '39')->where('fk_status_in_company_id', '!=', '5')->sortByDesc('project_id') as $item)
                        <tr>
                            <td class="ps-3 text-muted">{{ $item->project_id }}</td>
                            <td>{{ $item->get_service->name }}</td>
                            <td>
                                @if ($item->fk_project_type_id == '2')
                                    <a href="/projekte-anfrage/{{ $item->project_id }}" target="_blank" class="text-decoration-none fw-semibold">
                                        {{ $item->construction_project_name }}
                                    </a>
                                @else
                                    <a href="/projekt/{{ $item->project_id }}" target="_blank" class="text-decoration-none fw-semibold">
                                        {{ $item->construction_project_name }}
                                    </a>
                                @endif
                            </td>
                            <td class="text-end">
                                <span class="fw-semibold">{{ number_format($item->budget, 2, ',', '.') }} €</span>
                            </td>
                            <td>
                                @if (!is_null($item->get_customer))
                                    <a href="/projekte/kunde/{{ $item->fk_customer_id }}" class="text-decoration-none text-dark">
                                        {{ $item->get_customer->name }}
                                    </a>
                                @else
                                    <span class="text-muted">—</span>
                                @endif
                            </td>
                            <td>
                                @if (!is_null($item->get_planner))
                                    <a href="/projekte/kunde/{{ $item->fk_planner_customer_id }}" class="text-decoration-none text-dark">
                                        {{ $item->get_planner->name }}
                                    </a>
                                @else
                                    <span class="text-muted">—</span>
                                @endif
                            </td>
                            <td class="text-nowrap">
                                {{ date('d.m.Y', strtotime($item->project_deadline)) }}
                            </td>
                            <td>
                                <span class="badge rounded-pill bg-{{ $item->get_status_in_company->color }}">
                                    {{ $item->get_status_in_company->name }}
                                </span>
                            </td>
                            <td>{{ $item->get_current_department->name }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center text-muted py-4">Keine Projekte gefunden</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

@else
    <div class="text-center text-muted py-5">
        <i class="bi bi-inbox fs-1 d-block mb-2"></i>
        Keine Daten verfügbar
    </div>
@endif

<script>
    $(document).ready(function () {
        $("#success-alert").fadeTo(2000, 500).slideUp(500, function () {
            $("#success-alert").slideUp(1000);
        });
    });
</script>

@endsection