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


    <!-- main content -->
    @include('dashboard.news')
    <div class="row">
        <div class="col">
            APP > Projekte in bearbeitung und Aufträge
        </div>


    </div>
    <br>
    <div class="p-1 bg-white mb-5">
        @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-1  ">
                    <a href="/" class="text-decoration-none text-black text-center">
                        {{-- <a class="text-decoration-none text-black text-center"> --}}
                        <div class="p-2  border rounded ">
                            <div class="card-body">
                                <div class="col-12">
                                    <h4>{{ $count_all }}</h4>
                                    <h6 class="text-secondary ">Alle</h6>

                                </div>
                                {{-- <div class="col-12 bg-info border-2  rounded " style="height: 4px;">
                                </div> --}}
                            </div>
                        </div>
                    </a>
                </div>
                <div class="col mx-1  border rounded ">
                    <h6 class="text-center  m-0 pt-1 ">Projekte - in Bearbeitung</h6>
                    <div class="row p-0 ">

                        <div class="col ">
                            <a href="/projekte/alle/status-range/1/3" class=" text-decoration-none text-black">
                                <div class="  rounded">
                                    <div class="card-body p-0 m-0">
                                        <div class="col-12 text-center ">
                                            <div class=" ">
                                                {{ $projects->whereBetween('fk_status_in_company_id', [1, 3])->count() }}
                                            </div>

                                            <div class="text-secondary small">
                                                in
                                                bearbeitung</div>
                                        </div>
                                        <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                                        </div>
                                    </div>
                                </div>
                            </a>
                        </div>
                        <div class="col ">
                            <a href="/projekte/alle/status/4" class="text-decoration-none text-black">
                                <div class="  rounded">
                                    <div class="card-body">
                                        <div class="col-12 text-center">
                                            <div>{{ $projects->where('fk_status_in_company_id', '4')->count() }}</div>
                                            <div class="text-secondary  small">
                                                versendet</div>
                                        </div>
                                        <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                        </div>
                                    </div>
                                </div>
                            </a>
                        </div>
                        <div class="col ">
                            <a href="/projekte/alle/status/7" class="text-decoration-none text-black">
                                <div class="  rounded">
                                    <div class="card-body">
                                        <div class="col-12 text-center">
                                            <div>{{ $projects->where('fk_status_in_company_id', '7')->count() }}
                                            </div>
                                            <div class="text-secondary  small">
                                                ausgeschrieben</div>
                                        </div>
                                        <div class="col-12 bg-warning border-2  rounded " style="height: 4px;">
                                        </div>
                                    </div>
                                </div>
                            </a>
                        </div>
                        <div class="col">
                            <a href="/projekte/alle/status/6" class="text-decoration-none text-black">
                                <div class="  rounded ">
                                    <div class="card-body">
                                        <div class="col-12 text-center">
                                            <div>{{ $projects->where('fk_status_in_company_id', '6')->count() }}</div>
                                            <div class="text-secondary  small">

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

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

                        <div class="col">
                            <a href="/projekte/alle/status-range/31/32" class="text-decoration-none text-black">
                                <div class="  rounded">
                                    <div class="card-body">
                                        <div class="col-12 text-center">
                                            <div>{{ $projects->whereBetween('fk_status_in_company_id', [31, 32])->count() }}
                                            </div>
                                            <div class="text-secondary  small">

                                                in bearbeitung</div>
                                        </div>
                                        <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                                        </div>
                                    </div>
                                </div>
                            </a>
                        </div>

                        <div class="col">
                            <a href="/projekte/alle/status/39" class="text-decoration-none text-black">
                                <div class="  rounded">
                                    <div class="card-body">
                                        <div class="col-12 text-center">
                                            <div>{{ $projects->where('fk_status_in_company_id', '39')->count() }}</div>
                                            <div class="text-secondary  small">

                                                abgeschlossen</div>
                                        </div>
                                        <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                        </div>
                                    </div>
                                </div>
                            </a>
                        </div>

                    </div>
                </div>
                {{-- <a href=" /projekte/status/1" class="text-decoration-none text-black"> --}}
                {{-- <div class="col">
                  
                    <a 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 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 bearabeitung</h6>
                </div>
                <div class="col-12 bg-primary border-2  rounded " style="height: 4px;">
                </div>
            </div>
        </div>
    </a>
</div> --}}
                {{-- <div class="col"> <a href=" /projekte/status/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">
    <a href=" /projekte/status/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 ">Versendet</h6>
                </div>
                <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                </div>
            </div>
        </div>
    </a>
</div>

<div class="col"> <a href=" /projekte/status/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 ">Abgesagt</h6>
                </div>
                <div class="col-12 bg-danger border-2  rounded " style="height: 4px;">
                </div>
            </div>
        </div>
    </a>
</div> --}}



            </div>

            <hr>
            <form action="/" 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 ">
                                <th class="" style="width: 2%">
                                    ID

                                </th>
                                <th class="col-1">Service

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

                                </th>
                                <th class="col-1 text-end">
                                    Budget

                                </th>

                                <th class="col-2">
                                    Kunde

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

                                </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-->

                            {{-- @foreach ($projects->where('fk_status_in_company_id', '!=', '39')->where('fk_status_in_company_id', '!=', '4')->where('fk_status_in_company_id', '!=', '5')->where('fk_status_in_company_id', '!=', '6')->sortByDesc('project_id') as $item) --}}
                            @foreach ($projects->where('fk_status_in_company_id', '!=', '39')->where('fk_status_in_company_id', '!=', '5')->sortByDesc('project_id') as $item)
                                <tr id="" class="small align-middle">
                                    <td>
                                        <small>{{ $item->project_id }}</small>
                                    </td>
                                    <td>
                                        <small> {{ $item->get_service->name }}</small>
                                    </td>
                                    <td>
                                        @if ($item->fk_project_type_id == '2')
                                            <a href="/projekte-anfrage/{{ $item->project_id }}"
                                                target="_blank">{{ $item->construction_project_name }}</a>
                                        @else
                                            <a href="/projekt/{{ $item->project_id }}"
                                                target="_blank">{{ $item->construction_project_name }}</a>
                                        @endif
                                    </td>
                                    <td class="text-end">
                                        {{ number_format($item->budget, 2, ',', '.') }} €

                                    </td>
                                    <td>
                                        @if (!is_null($item->get_customer))
                                            <a href="/projekte/kunde/{{ $item->fk_customer_id }}" class="small">

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

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

                                                {{ $item->get_planner->name }}
                                            </a>
                                        @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 href="/projekte/abteilung/{{ $item->current_department_id }}"> --}}
                                        <a>
                                            {{ $item->get_current_department->name }}
                                            {{-- {{ count($item->project_areas) }} --}}
                                        </a>
                                    </td>
                                    <td class="" id="">
                                        <!--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->customer_id }}">
                            <i class="bi bi-trash"></i>
                            </button>
                            <!--edit-->
                            <button type="button" title="Bearbeiten" class="btn btn-sm btn-outline-success" onclick="editItem({{ $item->customer_id }})">
                                <i class="bi bi-pencil-square"></i>
                            </button>

                            <button type="button" title="Anzeigen" class="btn btn-sm btn-outline-primary">
                                <i class="bi bi-box-arrow-up-right"></i>
                            </button> --}}

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

                                    </td>

                                </tr>
                                <!--each row-->
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>

                            </tr>
                        </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 ";
            }

        );
    </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