@extends('layouts.app', ['title' => 'KUNDE - Projekte Übersicht'])
@section('content')
    <!-- main 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('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> --}}
    <div class="row">
        <div class="col">
            @include('layouts.breadcrumb', ['crumbs' => [ucfirst(Request::segment(1)), ucfirst(Request::segment(2))]])
        </div>

    </div>
    <br>
    <div class="p-2 bg-white mb-5 rounded">

        <div class="row justify-content-center align-items-center g-2 mb-3">
            <div class="col text-center">

            </div>

        </div>
        <div class=" mx-3 ">
            <div class="row ">
                <div class="col-10">
                    <h4>{{ $customer->name }}</h4>
                </div>
                <div class="col-2  text-end">

                    <a href="/kunde/{{ $customer->customer_id }}" class="btn btn-sm btn-success "><b
                            class="bi bi-person-vcard "></b> Kunde Kontaktsdaten/Info
                        <i class="bi bi-box-arrow-up-right"></i>
                    </a>
                </div>

            </div>
            <div class="row ">
                <div class="col-8">

                    <table class="table table-sm small table-borderless my-0">
                        <thead>
                            <th></th>
                            <th></th>
                        </thead>
                        <tbody>
                            <tr>
                                <td>Anschrift:</td>
                                <td>{{ $customer->address }}</td>
                            </tr>
                            <tr>
                                <td>Tel:</td>
                                <td>{{ $customer->tel }}</td>
                            </tr>
                            <tr>
                                <td>Mobile:</td>
                                <td>{{ $customer->mobile }}</td>
                            </tr>
                            <tr>
                                <td>Fax:</td>
                                <td>{{ $customer->fax }}</td>
                            </tr>
                            <tr>
                                <td>Email:</td>
                                <td>{{ $customer->email }}</td>
                            </tr>
                            <tr>
                                <td>Webseite:</td>
                                <td>{{ $customer->website }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>




        </div>

        <hr>

        <div class="row">

            <div class="col-1 m-1">
                {{-- <a href="{{ route('Projects') }}" class="text-decoration-none text-black"> --}}
                <div class=" p-2 border rounded ">
                    <div class="card-body">
                        <div class="col-12 text-center">
                            <h4>{{ $projects->count() }}</h4>
                            <h6 class="text-secondary ">Alle</h6>
                        </div>

                    </div>
                </div>
                </a>
            </div>

            <div class="col m-1 border rounded">
                <h6 class="text-center small m-1">Anfragen</h6>
                <div class="row">

                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small class="text-secondary ">
                                            {{ $projects->whereBetween('fk_status_in_company_id', [11, 12])->count() }}
                                            neue</small>
                                    </div>
                                    <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>
                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small
                                            class="text-secondary ">{{ $projects->where('fk_status_in_company_id', '14')->count() }}
                                            genehmigt</small>
                                    </div>
                                    <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>
                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small class="text-secondary ">
                                            {{ $projects->where('fk_status_in_company_id', '13')->count() }}
                                            abgelehnt</small>
                                    </div>
                                    <div class="col-12 bg-danger border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>

                </div>
            </div>
            <div class="col m-1 border rounded">
                <h6 class="text-center small m-1">Angebote</h6>
                <div class="row">

                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small class="text-secondary ">
                                            {{ $projects->whereBetween('fk_status_in_company_id', [1, 4])->count() }} in
                                            bearbeitung</small>
                                    </div>
                                    <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>
                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small class="text-secondary ">
                                            {{ $projects->where('fk_status_in_company_id', '6')->count() }}
                                            beauftragt</small>
                                    </div>
                                    <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>
                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small
                                            class="text-secondary ">{{ $projects->where('fk_status_in_company_id', '5')->count() }}
                                            abgesagt</small>
                                    </div>
                                    <div class="col-12 bg-danger border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>

                </div>
            </div>
            <div class="col m-1 border rounded">
                <h6 class="text-center small m-1">Aufträge</h6>
                <div class="row">

                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small class="text-secondary ">
                                            {{ $projects->whereBetween('fk_status_in_company_id', [31, 32])->count() }}
                                            in bearbeitung</small>
                                    </div>
                                    <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>

                    <div class="col">
                        <a class="text-decoration-none text-black">
                            <div class="p-2 border rounded">
                                <div class="card-body">
                                    <div class="col-12">

                                        <small class="text-secondary ">
                                            {{ $projects->where('fk_status_in_company_id', '39')->count() }}
                                            abgeschlossen</small>
                                    </div>
                                    <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                    </div>
                                </div>
                            </div>
                        </a>
                    </div>

                </div>
            </div>




        </div>
        <hr>
        {{-- <form action="{{ route('Projects') }}" 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 Name 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 class="text-info fs-6">
                            <th class="col" style="width: 3%">ID</th>
                            <th class="col" style="width: 3%">Kategorie

                            </th>
                            <th class="col-2">Bauvorhaben

                            </th>

                            @if (Auth::user()->get_employee->access_budget)
                                <th class="col-1 text-end " style="width: 8%">
                                    Budget
                                </th>
                            @endif
                            {{-- @if (Auth::user()->get_employee->access_budget)
                                <th class=" text-end" style="width: 7%">
                                    <form action="{{ route('projects-offer.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="budget">
                                        <button type="submit" class="btn btn-outline-info btn-sm">Budget
                                            @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">Kunde

                            </th>
                            <th class="col-2">Planer

                            </th>
                            <th class="col">Deadline


                            </th>
                            <th class="col">Status

                            </th>
                            <th class="col">Abteilung

                            </th>

                        </tr>
                    </thead>
                    <tbody id="clients-td-container" class="">
                        <!--ajax content here-->
                        <!--each row-->
                        @if ($projects->count() > 0)
                            @foreach ($projects as $item)
                                <tr id="" class="small align-middle">
                                    <td>
                                        <small>{{ $item->project_id }} {{ $item->id }}</small>
                                    </td>
                                    <td>
                                        @if ($item->fk_project_type_id == '1')
                                            <small>Anfrage</small>
                                        @elseif ($item->fk_project_type_id == '2')
                                            Angebot
                                        @elseif ($item->fk_project_type_id == '21')
                                            Angebot Ersatzteile
                                        @else
                                            <b> Auftrag</b>
                                        @endif

                                    </td>

                                    <td>
                                        @if ($item->fk_project_type_id == '1')
                                            <a href="/projekt-empfang/{{ $item->project_id }}"
                                                target="_blank">{{ $item->construction_project_name }}</a>
                                        @elseif ($item->fk_project_type_id == '2')
                                            <a href="{{ route('offer.project.show', ['id' => $item->project_id]) }}"
                                                target="_blank">{{ $item->construction_project_name }}</a>
                                        @elseif ($item->fk_project_type_id == '21')
                                            <a href="{{ route('offer.spare.show', ['id' => $item->id]) }}"
                                                target="_blank">{{ $item->title }}</a>
                                        @else
                                            <a href="{{ route('order.project.show', ['id' => $item->project_id]) }}"
                                                target="_blank">{{ $item->construction_project_name }}</a>
                                        @endif
                                    </td>
                                    @if (Auth::user()->get_employee->access_budget)
                                        <td class=" text-end">
                                            @if ($item->fk_project_type_id == '3')
                                                <b> {{ number_format($item->budget, 2, ',', '.') }}
                                                    €</b>
                                            @else
                                                <small> {{ number_format($item->budget, 2, ',', '.') }}
                                                    €</small>
                                            @endif


                                        </td>
                                    @endif
                                    <td>

                                        @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

                                    </td>
                                    <td>

                                        @if (!is_null($item->get_planner))
                                            @if (Auth::user()->get_employee->is_mgt)
                                                <a href="/projekte/kunde/{{ $item->fk_planner_customer_id }}"
                                                    class="small">

                                                    {{ $item->get_planner->name }}
                                                </a>
                                            @else
                                                {{ $item->get_planner->name }}
                                            @endif
                                        @endif

                                    </td>
                                    <td>
                                        {{ date('d.m.Y', strtotime($item->project_deadline)) }}
                                    </td>
                                    <td>
                                        <div class="btn btn-sm btn-{{ $item->get_status_in_company->color }}">
                                            {{ $item->get_status_in_company->name }}
                                        </div>
                                    </td>
                                    <td>
                                        <a>
                                            {{ $item->get_current_department->name }}
                                            {{-- {{ count($item->project_areas) }} --}}
                                        </a>
                                    </td>

                                </tr>
                                <!--each row-->
                            @endforeach
                            <tr class="">

                                <td colspan="3" class="text-end"> Summe die Aufträge:</td>
                                <td class="text-end">
                                    <b>{{ number_format($projects->where('fk_project_type_id', '3')->sum('budget'), 2, ',', '.') }}
                                        €</b>
                                </td>
                                <td></td>
                            </tr>
                        @else
                            <tr>
                                <td class=" text-center" colspan="100%">
                                    <h6 class=" text-center ">Keine Daten</h6>
                                </td>
                            </tr>
                        @endif
                    </tbody>

                </table>
                <br>
                <div class="d-flex justify-content-center pagination pagination-lg text-dark">
                    {{-- {!! $projects->links() !!} --}}
                </div>
            </div>
        </div>


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

        );
    </script>
    <script>
        function editItem(id) {
            $.get('/crm/kunden/' + id, function(item) {
                $("#id-edit").val(item.customer_id);
                $("#customer_category_id-edit").val(item.fk_customer_category_id);
                $("#name-edit").val(item.name);
                $("#address-edit").val(item.address);
                $("#tel-edit").val(item.tel);
                $("#mobile-edit").val(item.mobile);
                $("#fax-edit").val(item.fax);
                $("#email-edit").val(item.email);
                $("#website-edit").val(item.website);
                $("#edit-modal").modal('toggle');
            })
        }
    </script>
@endsection