@extends('layouts.app', ['title' => strtoupper(Request::segment(1)) . ' | ' . strtoupper(Request::segment(2))])
@section('content')

    {{-- delete modal --}}
    <div class="modal fade modal-dialog-scrollable modal-lg" id="delete-item" data-bs-backdrop="static" data-bs-keyboard="false"
        tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">

        <div class="modal-dialog">
            <div class="modal-content">
                <form action="{{ route('offer.project.delete') }}" method="POST" class="needs-validation" novalidate>
                    @csrf

                    <input id="id" name="id" value="" hidden>
                    <div class="modal-header">
                        <h5 class="modal-title " id="staticBackdropLabel"> Projekt löschen </h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                    </div>

                    <div class="modal-body">

                        <div class="row mt-2">
                            <div class="col">
                                <h4 class="text-center">Möchten Sie den Projekt löschen ? </h4>
                            </div>

                        </div>

                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Abbrechen</button>
                        <button type="submit" class="btn btn-danger">Löschen</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    {{-- Hinweis modal --}}
    <div class="modal fade modal-dialog-scrollable " id="notice-item" data-bs-backdrop="static" data-bs-keyboard="false"
        tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">

        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">


                <div class="modal-body">

                    <div class="row mt-2">
                        <div class="col">
                            <h5 class="border p-2" id="noticeUser">Möchten Sie den Projekt löschen ? </h5>
                        </div>

                    </div>
                    <div class="row mt-2">
                        <div class="col">
                            <p class="border p-2 justify-center" id="noticeMsg">Möchten Sie den Projekt löschen ? </p>
                        </div>

                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">schließen</button>

                </div>

            </div>
        </div>
    </div>
    <!-- main content -->

    <div class="row">

        <div
            class="{{ (Auth::user()->get_employee->is_mgt or Auth::user()->get_employee->is_mkt) ? 'col-11' : ' col-12 ' }}">
            <label class="bg-white border px-2 p-1 w-100 fs-4 rounded shadow-sm">Angebote - fertige Spielgeräte</label>
        </div>


        @if (Auth::user()->get_employee->is_mgt or Auth::user()->get_employee->is_mkt)
            <div class="col float-end text-end">

                <a href="{{ route('offer.direct.new') }}" class="p-2 btn btn-success shadow-sm w-100">
                    <i class="bi bi-plus-square"></i> Neu
                </a>

            </div>
        @endif

    </div>
    <br>
    <div class="container-fluid bg-white mb-5 rounded border">
        @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

        <br>
        @if (!empty($projects))
            <div class="row ">

                <div class="col">
                    <a href="{{ route('offer.direct.index') }}" class="text-decoration-none text-black">
                        <div class=" p-2 border rounded ">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_all }}</h4>
                                    <h6 class="text-secondary ">aktuell offen</h6>
                                </div>
                                <div class="col-12 bg-info border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>
                <div class="col">
                    <a href="{{ route('offer.direct.status', ['id' => '1']) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_new }}</h4>
                                    <h6 class="text-secondary ">unbearbeitet</h6>
                                </div>
                                <div class="col-12 bg-secondary border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>
                <div class="col">
                    <a href="{{ route('offer.direct.status', ['id' => '2']) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_inpro }}</h4>
                                    <h6 class="text-secondary ">in Bearbeitung</h6>
                                </div>
                                <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>
                {{-- <div class="col"> <a
                        href="{{ route('offer.project.status', [
                            'id' => '3',
                        ]) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_closed }}</h4>
                                    <h6 class="text-secondary ">wartet auf Versand</h6>
                                </div>
                                <div class="col-12 bg-info border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div> --}}
                <div class="col-1 border-start  border-dark">
                    <a href="{{ route('offer.direct.status', ['id' => '4']) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_com }}</h4>
                                    <h6 class="text-secondary small">versendet</h6>
                                </div>
                                <div class="col-12 bg-secondary border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>


                <div class="col-1 "> <a
                        href="{{ route('offer.direct.status', ['id' => '7']) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_ausgesch }}</h4>
                                    <h6 class="text-secondary small">ausgeschrieben</h6>
                                </div>
                                <div class="col-12 bg-warning border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>
                {{-- <div class="col-1 "> <a
                        href=" {{ route('offer.project.status', [
                            'id' => '6',
                        ]) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_acpt }}</h4>
                                    <h6 class="text-secondary small">beauftragt</h6>
                                </div>
                                <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>
                <div class="col-1 "> <a
                        href=" {{ route('offer.project.status', [
                            'id' => '5',
                        ]) }}"
                        class="text-decoration-none text-black">
                        <div class="p-2 border rounded">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_can }}</h4>
                                    <h6 class="text-secondary small ">abgesagt</h6>
                                </div>
                                <div class="col-12 bg-danger border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div> --}}
            </div>

            <hr>
            <form action="{{ route('offer.project.active') }}" method="get">

                <div class="row mt-1 mb-2">

                    <div class="col-3 text-center">
                    </div>
                    <div class="col-6 text-center">
                        <div class="input-group   ">
                            <input type="text" class="form-control  rounded-0"
                                placeholder="Suche nach Bauvorhaben, Namen oder Adresse" id="name" name="name">
                            <div class="input-group-append   ">
                                <button class="btn  text-white bg-primary rounded-0 " type="submit"> <i
                                        class="bi bi-search"></i>
                                </button>
                            </div>
                        </div>
                    </div>
                    <div class="col-3 text-center">
                    </div>

                </div>
            </form>
            <div class="">
                <div class=" ">
                    <table class="table table-hover no-wrap contact-list" data-page-size="5">
                        <thead>
                            <tr>
                                <td colspan="100%"><small>* Um den letzten Hinweis anzuzeigen, klicken Sie bitte auf das
                                        Datum des Hinweises.</small></td>
                            </tr>
                            <tr class="text-info fs-6 align-middle">

                                <th class=" ps-1" style="width: 4%">
                                    <form action="{{ route('offer.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="project_id">
                                        <button type="submit" class="btn btn-outline-info btn-sm">ID
                                            @if (Session::get('projects_offer_sort') == 'project_id')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_offer_sort_range') == 'asc' ? 'down' : 'up' }}"></i></span>
                                            @else
                                                <i class="bi bi-filter-left"></i>
                                            @endif
                                        </button>
                                    </form>
                                </th>
                                </th>
                                <th class="col-1 " style="">
                                    Service

                                </th>
                                <th class=" px-1 text-center" style="width: 6%">

                                    <form action="{{ route('offer.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="priority">
                                        <button type="submit" class="btn btn-outline-info btn-sm">Priorität
                                            @if (Session::get('projects_offer_sort') == 'priority')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_offer_sort_range') == 'asc' ? 'down' : 'up' }}"></i></span>
                                            @else
                                                <i class="bi bi-filter-left"></i>
                                            @endif
                                        </button>
                                    </form>
                                </th>
                                @if (Auth::user()->get_employee->access_budget)
                                    <th class=" text-end" style="width: 7%">
                                        <form action="{{ route('offer.project.sort') }}" method="post">
                                            @csrf
                                            <input type="hidden" name="sort" value="budget">
                                            <button type="submit" class="btn btn-outline-info btn-sm">Budget(netto)
                                                @if (Session::get('projects_offer_sort') == 'budget')
                                                    <span class="sorting-icons"> <i
                                                            class="bi bi-sort-numeric-{{ Session::get('projects_offer_sort_range') == 'asc' ? 'down' : 'up' }}"></i></span>
                                                @else
                                                    <i class="bi bi-filter-left"></i>
                                                @endif
                                            </button>
                                        </form>
                                    </th>
                                @endif
                                <th class="col-2 ps-1">Bauvorhabensort/Title

                                </th>


                                <th class="col-2 ps-1">Kunde/Planer

                                </th>
                                <th class=" ps-1 text-center" style="width: 7%">
                                    <form action="{{ route('offer.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="project_deadline">
                                        <button type="submit" class="btn btn-outline-info btn-sm">Deadline
                                            @if (Session::get('projects_offer_sort') == 'project_deadline')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_offer_sort_range') == 'asc' ? 'down' : 'up' }}"></i></span>
                                            @else
                                                <i class="bi bi-filter-left"></i>
                                            @endif
                                        </button>
                                    </form>


                                </th>
                                <th class=" ps-1 text-center" style="width: 8%">
                                    <form action="{{ route('offer.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="fk_status_in_company_id">
                                        <button type="submit" class="btn btn-outline-info btn-sm">Status
                                            @if (Session::get('projects_offer_sort') == 'fk_status_in_company_id')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_offer_sort_range') == 'asc' ? 'down' : 'up' }}"></i></span>
                                            @else
                                                <i class="bi bi-filter-left"></i>
                                            @endif
                                        </button>
                                    </form>

                                </th>
                                <th class=" ps-1" style="width: 3%">Abteilung

                                </th>
                                <th class="col-1 ps-1">Mitarbeiter

                                </th>
                                <th class="col-1 ps-0 small">
                                    <form action="{{ route('offer.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="last_contact">
                                        <button type="submit" class="btn btn-outline-info btn-sm small">letzter
                                            Hinweis
                                            @if (Session::get('projects_offer_sort') == 'last_contact')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_offer_sort_range') == 'asc' ? 'down' : 'up' }}"></i></span>
                                            @else
                                                <i class="bi bi-filter-left"></i>
                                            @endif
                                        </button>
                                    </form>


                                </th>
                                {{-- <th class="col-1 ps-1 small">
                                    <small> letzter Hinweis am</small>


                                </th> --}}
                                @if (Auth::user()->get_employee->is_mgt)
                                    <th class="col-1">Aktion

                                    </th>
                                @endif
                            </tr>
                        </thead>
                        <tbody id="clients-td-container" class="">
                            <!--ajax content here-->
                            <!--each row-->

                            {{-- ss{{ $projects->get('fk_project_location_id') }} --}}
                            @foreach ($projects->groupBy('fk_project_location_id') as $itemb)
                                <tr id="" class="fs-6 align-middle small">
                                    <td></td>
                                    @if (Auth::user()->get_employee->access_budget)
                                        <td></td>
                                    @endif

                                    <td></td>
                                    <td></td>
                                    <td colspan="100%">
                                        <b>
                                            @if (!is_null($itemb[0]->fk_project_location_id))
                                                BV. {{ $itemb[0]->get_project_location->name }}
                                            @else
                                                BV. nicht ausgewählt
                                            @endif

                                            {{-- BV. {{ $itemb[0]->get_project_location->name }} --}}
                                        </b>


                                    </td>
                                </tr>
                                {{-- @foreach ($itemb as $item)
                                    BV. {{ $item->get_project_location->name }}
                                @endforeach --}}
                                {{-- @foreach ($projects as $item) --}}
                                @foreach ($itemb->sortBy('budget') as $item)
                                    <tr id="" class="fs-6 align-middle small">
                                        <td class="small p-1">
                                            {{ $item->project_id }}
                                        </td>
                                        <td class="small p-1">
                                            {{ $item->get_service->name }}
                                        </td>
                                        <td class="small p-1 text-center">
                                            {{ $item->priority }}
                                        </td>
                                        @if (Auth::user()->get_employee->access_budget)
                                            <td class=" text-end"> <small>{{ number_format($item->budget, 2, ',', '.') }}
                                                    €</small>

                                            </td>
                                        @endif
                                        <td class="small ">
                                            <div class="row p-0 m-0">
                                                <div class="col-12 pt-0">
                                                    <small class="text-secondary">
                                                        {{-- @if (!is_null($item->fk_project_location_id))
                                                            BV. {{ $item->get_project_location->name }}
                                                        @else
                                                            BV. nicht ausgewählt
                                                        @endif --}}

                                                    </small>
                                                </div>
                                                <div class="col-12"> <a
                                                        href="{{ route('offer.direct.show', ['id' => $item->project_id]) }}">{{ $item->construction_project_name }}</a>
                                                </div>
                                            </div>


                                            {{-- <a href="/projekte-anfrage/{{ $item->project_id }}" --}}





                                            {{-- @if (!is_null($item->fk_project_location_id))
                                            <a href="{{ route('offer.project.show', ['id' => $item->project_id]) }}">
                                                <small>ALT. {{ $item->construction_project_name }}</small> <br>
                                                BV. {{ $item->get_project_location->name }}</a>
                                        @else
                                            <a class="text-danger"
                                                href="{{ route('offer.project.show', ['id' => $item->project_id]) }}">{{ $item->construction_project_name }}</a>
                                        @endif --}}

                                        </td>

                                        <td class="small p-1">
                                            {{-- @if (!is_null($item->get_customer))
                                            @if (Auth::user()->get_employee->is_mgt)
                                                <a href="/projekte/kunde/{{ $item->fk_customer_id }}" class="small">

                                                    {{ $item->get_customer->name }}
                                                </a>
                                            @else
                                                {{ $item->get_customer->name }}
                                            @endif
                                        @endif --}}
                                            @if (!is_null($item->get_customer))
                                                @if (Auth::user()->get_employee->is_mgt)
                                                    <b class="small">K.: </b>
                                                    <a href="/projekte/kunde/{{ $item->fk_customer_id }}" class="small">
                                                        {{ Str::limit($item->get_customer->name, 30) }}
                                                    </a>
                                                @else
                                                    <b class="small">K.: </b>
                                                    {{ Str::limit($item->get_customer->name, 30) }}
                                                @endif
                                            @endif
                                            @if (!is_null($item->get_planner))
                                                <br>
                                                @if (Auth::user()->get_employee->is_mgt)
                                                    <b class="small">P.: </b>
                                                    <a href="/projekte/kunde/{{ $item->fk_planner_customer_id }}"
                                                        class="small">
                                                        {{ Str::limit($item->get_planner->name, 30) }}
                                                    </a>
                                                @else
                                                    <b class="small">P.: </b>
                                                    {{ Str::limit($item->get_planner->name, 30) }}
                                                @endif
                                            @endif

                                        </td>
                                        <td class="small p-1 text-center">

                                            {{ date('d.m.Y', strtotime($item->project_deadline)) }}
                                            @if ($item->fk_status_in_company_id == '7')
                                                <br>
                                                ausg. bis:
                                                <br>
                                                {{ $item->advertised_until_year }} KW {{ $item->advertised_until_week }}
                                            @endif
                                        </td>
                                        <td class="small p-1 text-center">
                                            <div class="btn btn-sm btn-{{ $item->get_status_in_company->color }} ">
                                                <small> {{ $item->get_status_in_company->name }}</small>
                                            </div>
                                        </td>
                                        <td class="small p-1">
                                            <a>
                                                {{ $item->get_current_department->name }}
                                                {{-- {{ count($item->project_areas) }} --}}
                                            </a>
                                        </td>
                                        <td class="small p-1">
                                            @if ($item->assigned_employees->count() > 0)
                                                @foreach ($item->assigned_employees as $emp)
                                                    <small>{{ $emp->employee->first_name }} </small>
                                                    @if (!$loop->last)
                                                        ,
                                                    @endif
                                                @endforeach
                                            @endif
                                        </td>

                                        <td class="small p-1">
                                            @if (
                                                $item->timelines->filter(function ($value, $key) {
                                                        if (data_get($value, 'is_note') == '1' or
                                                            data_get($value, 'is_call') == '1' or
                                                            data_get($value, 'is_email') == '1' or
                                                            data_get($value, 'is_post') == '1' or
                                                            data_get($value, 'is_personally') == '1'
                                                        ) {
                                                            # code...
                                                            return $value;
                                                        }
                                                    })->count() > 0)
                                                <button type="button" title="Hinweis anzeigen "
                                                    class="btn btn-secondary notice_btn btn-sm"
                                                    onclick="noticeItem({{ $item->timelines->filter(function ($value, $key) {
                                                            if (
                                                                data_get($value, 'is_note') == '1' or
                                                                data_get($value, 'is_call') == '1' or
                                                                data_get($value, 'is_email') == '1' or
                                                                data_get($value, 'is_post') == '1' or
                                                                data_get($value, 'is_personally') == '1'
                                                            ) {
                                                                # code...
                                                                return $value;
                                                            }
                                                        })->sortByDesc('timeline_id')->first()->timeline_id }} )">
                                                    {{ date(
                                                        'd.m.Y',
                                                        strtotime(
                                                            $item->timelines->filter(function ($value, $key) {
                                                                    if (
                                                                        data_get($value, 'is_note') == '1' or
                                                                        data_get($value, 'is_call') == '1' or
                                                                        data_get($value, 'is_email') == '1' or
                                                                        data_get($value, 'is_post') == '1' or
                                                                        data_get($value, 'is_personally') == '1'
                                                                    ) {
                                                                        # code...
                                                                        return $value;
                                                                    }
                                                                })->sortByDesc('timeline_id')->first()->created_at,
                                                        ),
                                                    ) }}
                                                </button>
                                                {{-- <div class="btn btn-outline-secondary " data-bs-html="true"
                                                    data-bs-toggle="tooltip" data-bs-placement="left"
                                                    title=" {{ $item->timelines->filter(function ($value, $key) {
                                                            if (
                                                                data_get($value, 'is_note') == '1' or
                                                                data_get($value, 'is_call') == '1' or
                                                                data_get($value, 'is_email') == '1' or
                                                                data_get($value, 'is_post') == '1' or
                                                                data_get($value, 'is_personally') == '1'
                                                            ) {
                                                                # code...
                                                                return $value;
                                                            }
                                                        })->sortByDesc('timeline_id')->first()->get_employee->first_name }} {{ $item->timelines->filter(function ($value, $key) {
                                                            if (
                                                                data_get($value, 'is_note') == '1' or
                                                                data_get($value, 'is_call') == '1' or
                                                                data_get($value, 'is_email') == '1' or
                                                                data_get($value, 'is_post') == '1' or
                                                                data_get($value, 'is_personally') == '1'
                                                            ) {
                                                                # code...
                                                                return $value;
                                                            }
                                                        })->sortByDesc('timeline_id')->first()->get_employee->last_name }}

                                                           :<br> {{ $item->timelines->filter(function ($value, $key) {
                                                                   if (
                                                                       data_get($value, 'is_note') == '1' or
                                                                       data_get($value, 'is_call') == '1' or
                                                                       data_get($value, 'is_email') == '1' or
                                                                       data_get($value, 'is_post') == '1' or
                                                                       data_get($value, 'is_personally') == '1'
                                                                   ) {
                                                                       # code...
                                                                       return $value;
                                                                   }
                                                               })->sortByDesc('timeline_id')->first()->event_msg }}  ">



                                                    {{ date(
                                                        'd.m.Y',
                                                        strtotime(
                                                            $item->timelines->filter(function ($value, $key) {
                                                                    if (
                                                                        data_get($value, 'is_note') == '1' or
                                                                        data_get($value, 'is_call') == '1' or
                                                                        data_get($value, 'is_email') == '1' or
                                                                        data_get($value, 'is_post') == '1' or
                                                                        data_get($value, 'is_personally') == '1'
                                                                    ) {
                                                                        # code...
                                                                        return $value;
                                                                    }
                                                                })->sortByDesc('timeline_id')->first()->created_at,
                                                        ),
                                                    ) }}





                                                </div> --}}
                                            @else
                                                - - -
                                            @endif

                                        </td>
                                        @if (Auth::user()->get_employee->is_mgt)
                                            <td class="small p-1">
                                                <!--action button-->
                                                <span class="list-table-action dropdown font-size-inherit">
                                                    <!--delete-->
                                                    <button type="button" title="Löschen"
                                                        class="btn btn-sm btn-outline-danger delete_btn "
                                                        data-bs-toggle="modal" data-bs-target="#delete-item"
                                                        data-id="{{ $item->project_id }}">
                                                        <i class="bi bi-trash"></i>
                                                    </button>
                                                    <!--edit-->
                                                    <a href="{{ route('offer.direct.edit', [
                                                        'id' => $item->project_id,
                                                    ]) }}"
                                                        type="button" title="Bearbeiten"
                                                        class="btn btn-sm btn-outline-success">
                                                        <i class="bi bi-pencil-square"></i>
                                                    </a>

                                                    {{-- <a href="{{ route('offer.project.show', [
                                                    'id' => $item->project_id,
                                                ]) }}
                                               "
                                                    title="Anzeigen" target="_blank"
                                                    class="btn btn-sm btn-outline-primary">
                                                    <i class="bi bi-box-arrow-up-right"></i>
                                                </a> --}}


                                                </span>
                                                <!--action button-->

                                            </td>
                                        @endif

                                    </tr>

                                    <!--each row-->
                                @endforeach
                            @endforeach

                        </tbody>
                        <tfoot>
                            @if (Auth::user()->get_employee->access_budget)
                                <tr> </tr>
                                <tr>
                                    <td></td>


                                    <td colspan="2 " class="text-end">Beste Angebote Summe(netto):</td>
                                    <td class="text-end border  border-dark">
                                        @php
                                            $bg = 0.0;
                                            foreach (
                                                $projects->groupBy('fk_project_location_id')->sortBy('budget')
                                                as $itemb
                                            ) {
                                                # code...

                                                $bg = $bg + (float) $itemb->min('budget');
                                                // echo $bg . '   <br>';
                                            }
                                        @endphp

                                        <b> {{ number_format($bg, 2, ',', '.') }} €</b>

                                    </td>
                                    <td colspan="100%"></td>
                                </tr>
                            @endif
                        </tfoot>
                    </table>
                    <br>
                    <div class="d-flex justify-content-center pagination pagination-lg text-dark">
                        {!! $projects->links() !!}
                    </div>
                </div>
            </div>
        @else
            <div class="row">
                <h6>Keine Daten</h6>
            </div>
        @endif

    </div>
    <script>
        $(document).on('click', '.delete_btn', function() {
                let id = $(this).attr('data-id');
                $('#id').val(id);
                // document.getElementById('ptitle').innerHTML = "You pressed ";
            }

        );
        const tooltipTriggerList = document.querySelectorAll('[data-bs-toggle="tooltip"]');
        const tooltipList = [...tooltipTriggerList].map(tooltipTriggerEl => new bootstrap.Tooltip(tooltipTriggerEl));

        function noticeItem(id) {
            var url = "{{ route('offer.project.notice', ':id') }}";
            url = url.replace(':id', id);
            $.get(url, function(item) {
                $("#noticeUser").html(item.user);
                $("#noticeMsg").html(item.notice);


                $("#notice-item").modal('toggle');

            })
        }
    </script>

@endsection