@extends('layouts.app', ['title' => 'Aufträge | Bauvorhaben '])
@section('content')
    {{-- 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"></h5>
                        </div>

                    </div>
                    <div class="row mt-2">
                        <div class="col">
                            <p class="border p-2 justify-center" id="noticeMsg"></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>
    {{-- 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 modal-dialog-centered">
            <div class="modal-content">
                <form action="{{ route('order.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>
    <!-- main content -->

    <div class="row">
        <div class="{{ Auth::user()->get_employee->is_mgt == '1' ? 'col-11' : ' col-12 ' }}">
            <label class="bg-white border px-2 p-1 w-100 fs-4 rounded shadow-sm">Aufträge - Bauvorhaben</label>
        </div>

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

                <a href="{{ route('order.project.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 (Auth::user()->get_employee->is_mgt)
            <small class="text-danger"> Hinweis: Auftragsnummer wird automatisch erzeugt, dann können Sie in Excel-Liste
                eintragen. </small>
        @endif --}}
        @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('order.project.active') }}" 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('order.project.status', ['id' => '31']) }}" 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('order.project.status', ['id' => '32']) }}" 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-2 border-start  border-dark"> <a href="{{ route('order.project.status', ['id' => '39']) }}"
                        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 ">abgeschlossen</h6>
                                </div>
                                <div class="col-12 bg-success border-2  rounded " style="height: 4px;">
                                </div>
                            </div>
                        </div>
                    </a>
                </div>



            </div>
            <hr>
            <form action="{{ route('order.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('order.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="fk_order_nr_id">
                                        <button type="submit" class="btn btn-outline-info btn-sm">
                                            <small>Kst.</small>
                                            @if (Session::get('projects_confirmed_sort') == 'fk_order_nr_id')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_confirmed_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: 4%">
                                    Service
                                </th>
                                @if (Auth::user()->get_employee->access_budget)
                                    <th class="col-1 text-end">
                                        <form action="{{ route('order.project.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_confirmed_sort') == 'budget')
                                                    <span class="sorting-icons"> <i
                                                            class="bi bi-sort-numeric-{{ Session::get('projects_confirmed_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">
                                    <small> Title/Bauvorhaben</small>

                                </th>


                                <th class="col-2 ps-1 ">
                                    <small class="text-decoration-none text-info">Auftraggeber/Planer
                                        <span class="sorting-icons"><i class="ti-arrows-vertical"></i></span></small>
                                </th>
                                <th class="col-1 ps-1">
                                    <form action="{{ route('order.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_confirmed_sort') == 'project_deadline')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_confirmed_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">
                                    <form action="{{ route('order.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_confirmed_sort') == 'fk_status_in_company_id')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_confirmed_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 text-center">
                                    <small class=" text-decoration-none text-info">Leistungstand/ Abteilung
                                        <span class="sorting-icons"><i class="ti-arrows-vertical"></i></span></small>
                                </th>
                                <th class="col-1 ps-1">Mitarbeiter

                                </th>
                                <th class="col-1 ps-0">
                                    <form action="{{ route('order.project.sort') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="sort" value="last_contact">
                                        <button type="submit" class="btn btn-outline-info btn-sm">letzter Hinweis am
                                            @if (Session::get('projects_confirmed_sort') == 'last_contact')
                                                <span class="sorting-icons"> <i
                                                        class="bi bi-sort-numeric-{{ Session::get('projects_confirmed_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-->

                            @foreach ($projects as $item)
                                <tr id="" class="fs-6 align-middle small">
                                    <td class="small p-1">
                                        {{-- <small> {{ $item->fk_order_nr_id }}</small> --}}
                                        @if (!is_null($item->cost_center))
                                            <b>
                                                @if ($item->cost_center->old_number)
                                                    {{ $item->cost_center->old_number }}
                                                    {{-- {{ $project->cost_center->number }} --}}
                                                @else
                                                    {{ $item->cost_center->number }}
                                                @endif
                                                {{-- {{ $project->cost_center->number }} --}}

                                            </b>
                                        @else
                                            <b>{{ $item->fk_order_nr_id }}</b>
                                        @endif


                                    </td>
                                    <td class="small p-1">
                                        <small>{{ $item->get_service->name }}</small>
                                    </td>
                                    @if (Auth::user()->get_employee->access_budget)
                                        <td class="col-1 text-end"> <small>
                                                @if ($item->budget == 0)
                                                    {{ number_format($item->budget_total, 2, ',', '.') }}
                                                @else
                                                    {{ number_format($item->budget, 2, ',', '.') }}
                                                @endif

                                                €
                                            </small>

                                        </td>
                                    @endif
                                    <td class="small p-1">

                                        <a
                                            href="{{ route('order.project.show', ['id' => $item->project_id]) }}">{{ $item->construction_project_name }}</a>
                                        <small class="text-secondary">
                                            @if (!is_null($item->fk_project_location_id))
                                                <br>
                                                BV. {{ $item->get_project_location->name }}
                                            @else
                                                <br>
                                                BV. nicht ausgewählt
                                            @endif
                                            {{-- <a
                                                href="/projekt-empfang/{{ $item->project_id }}">{{ $item->construction_project_name }}</a> --}}
                                        </small>
                                        {{-- @if (!is_null($item->fk_project_location_id))
                                            <a
                                                href="{{ route('order.project.show', ['id' => $item->project_id]) }}">{{ $item->get_project_location->name }}</a>
                                        @else
                                            <a class="text-danger"
                                                href="{{ route('order.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">AG.: </b>
                                                <a href="/projekte/kunde/{{ $item->fk_customer_id }}" class="small">
                                                    {{ Str::limit($item->get_customer->name, 30) }}
                                                </a>
                                            @else
                                                <b class="small">AG.: </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">
                                        {{ date('d.m.Y', strtotime($item->project_deadline)) }}
                                    </td>
                                    <td class="small p-1">
                                        <div class="btn btn-sm btn-{{ $item->get_status_in_company->color }}">
                                            {{ $item->get_status_in_company->name }}
                                            {{-- {{ $item->get_status_in_company->status_in_company_id }} --}}
                                        </div>
                                    </td>
                                    <td class="small p-1">
                                        <div class="progress rounded-0 " role="progressbar"
                                            aria-label="Animated striped example" aria-valuenow="36" aria-valuemin="0"
                                            aria-valuemax="100">
                                            <div class="progress-bar progress-bar-striped progress-bar-animated bg-success"
                                                style="width: {{ $item->progress }}%">{{ $item->progress }}%
                                            </div>
                                        </div>
                                        <div class="text-center">
                                            {{ $item->get_current_department->name }}
                                            {{-- {{ count($item->project_areas) }} --}}
                                        </div>
                                    </td>
                                    <td class="small p-1 text-center">
                                        @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">
                                        <a>
                                            {{-- @if ($item->timelines->where('is_note', '1')->count() > 0)
                                                {{ date('d.m.Y',strtotime($item->timelines->where('is_note', '=', '1')->sortByDesc('timeline_id')->first()->created_at)) }} --}}
                                            {{-- {{ $item->timelines->where('is_note', '=', '1')->sortby('timeline_id')->first()->created_at }} --}}
                                            @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>
                                                {{-- {{ 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,
                                                    ),
                                                ) }} --}}
                                            @else
                                                - - -
                                            @endif


                                            {{-- {{ count($item->project_areas) }} --}}

                                        </a>
                                    </td>
                                    @if (Auth::user()->get_employee->is_mgt)
                                        <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->project_id }}">
                                                    <i class="bi bi-trash"></i>
                                                </button>
                                                <!--edit-->
                                                <a href="{{ route('order.project.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('order.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
                        </tbody>
                        <tfoot>
                            <tr>

                            </tr>
                        </tfoot>
                    </table>
                    <br>
                    @if (Auth::user()->get_employee->access_budget)
                        <hr>
                        <div class="row justify-content-center align-items-center g-2 text-center">
                            <div class="col">Summe(Netto):
                                {{ number_format($projects->sum('budget_total'), 2, ',', '.') }} €</div>
                            <div class="col"> MwSt:
                                {{ number_format($projects->sum(fn($project) => $project->budget_total * $project->tax), 2, ',', '.') }}€
                            </div>
                            <div class="col">Summe(brutto):
                                {{ number_format($projects->sum('budget_total_tax'), 2, ',', '.') }} €
                            </div>
                        </div>
                        <hr>
                    @endif
                    <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');
            })
        }

        function noticeItem(id) {
            var url = "{{ route('order.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