@extends('layouts.site')

@php
    $i = 1;
    if(isset($_GET['page'])){

        $page = $_GET['page'];

        if($page > 1){
            $i = (($page -1 ) * 15) + 1;
        }
    }

    $page = session()->get('page');
    $sort = session()->get('sort');
    $direction = session()->get('direction');


    $zgloszenie_status_table = DB::connection('mysql-2')->table('zs102_sygnalista_status')
    ->get();

    $zgloszenie_all_count = DB::table('t080_sygnalista_zgloszenia')
    ->count();

    $status = session()->get('category');
    $filter = session()->get('filter');
    $HowManyRecords = DB::table('t080_sygnalista_zgloszenia')
    ->where('sprawa_identyfikator', 'like', '%'.$filter.'%')
    ->where('status', 'like', '%'.$status.'%')
    ->count();

@endphp

<script>
    setcookie($cookie_name,$cookie_value, time() + (86400 * 30), "/"); //name,value,time,url
</script>

@section('title','Strona Startowa')

@section('content')


<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.5.0/css/all.css">

<div class="border-rounded-top tab-content_2">

    <!-- Wyszukiwarka -->

    <div class="row col-12" style="justify-content: space-between; padding-right: 0px;">
        <div class="col-6">
            <div class="input-group wyszukiwarka">
            <label class="form-label my_HalfFrame" for="form1">Wybierz Filtr: </label>
            @foreach ($zgloszenie_status_table as $item)
                <a class="btn btn-{{ $item->kolor }}" href="{{ url('/m_syg_zgloszenia_list_filter',$item->id) }}" title="{{ $item->nazwa }}" style="margin-right: 3px;">
                    <i class="{{ $item->ikona }} fa-lg"></i>
                </a>
            @endforeach
                <a class="btn alert-dark" href="{{ url('/m_syg_zgloszenia_list_filter','0') }}" title="Wyczyść filtry">
                    <i class="fas fa-trash fa-lg"></i>
                </a>
            </div>


        </div>
        <div style="flex-basis: content;">

            <form action="{{ route('m_syg_zgloszenia_list_search') }}" method="POST">
                @csrf
                <div class="input-group wyszukiwarka">
                    <label class="form-label my_HalfFrame my_HalfFrameSearch" for="form1">Wyszukaj: </label>
                    <div class="form-outline">
                        <input id="search" name="search" class="form-control wyszukiwarka" value="{{ $filter }}"/>
                    </div>
                    <button type="submit" class="btn btn-primary" title="Wyszukaj">
                        <i class="fas fa-search fa-lg"></i>
                    </button>
                    <button type="submit" class="btn btn-danger" title="Wyczyść filtr wyszukiwania" onclick="my_setValue('search')">
                        <i class="fas fa-times fa-lg"></i>
                    </button>
                </div>
            </form>



        </div>

    </div>

    <!-- Wyszukiwarka - KONIEC -->

<!-- Sekcja nr 1 - START -->

    <!-- // Lista Użytkowników -->
    <table class="table table-sm table-striped table-hover">
        <thead>
            <tr class="tabela-naglowek">
                <th class="text-center" scope="col">@sortablelink('id', 'Lp')</th>
                <th class="text-center" scope="col">@sortablelink('sprawa_identyfikator', 'ID Sprawy')</th>
                <th class="text-center" scope="col">Osoba Zgłaszająca</th>
                <th class="text-center" scope="col">Grupa</th>
                <th class="text-center" scope="col">@sortablelink('created_at','Data zgłoszenia')</th>
                <th class="text-center" scope="col">Czas na obsługę<br/>(ilosć dni)</th>
                <th class="text-center" scope="col">@sortablelink('status','Status')</th>
                <th class="text-center" scope="col">Dodane przez</th>
                <th class="text-center" scope="col" class="table_action" style="text-align: right; width: 0;">
                    <a class="btn btn-success" href="{{ url('/m_syg_zgloszenia_add') }}" data-toggle="tooltip" title="Dodaj Nowy" style="width: -webkit-fill-available">
                        <i class="fa fa-plus fa-1x" aria-hidden="true"></i>
                    </a>
                </th>
            </tr>
        </thead>
        <tbody>

            <hr/>

        @if($zgloszenia->count() > 0)
            @foreach($zgloszenia as $zgl)
                <tr>
                    <th scope="row" class="text-center">{{ $i++ }}</th>
                    <td class="text-center">{{ $zgl->sprawa_identyfikator }}</td>
                    <td class="text-center">
                        @if($zgl->sygnalista_id)
                            @php
                                $sygnalista_user = DB::table('t080_sygnalista_user')
                                ->where('id','=',$zgl->sygnalista_id)
                                ->first();
                            @endphp
                            {{ $sygnalista_user->nazwisko }} {{ $sygnalista_user->imie }}
                        @else
                            Sygnalista
                        @endif
                    </td>
                    <td class="text-center">
                        @php
                            $sygnalista_grupa = DB::connection('mysql-2')->table('zs101_sygnalista_grupy')
                            ->where('id','=',$zgl->reprezentowana_grupa)
                            ->first();
                        @endphp
                        {{ $sygnalista_grupa->grupa_nazwa }}
                    </td>
                    <td class="text-center">{{ $zgl->created_at->format('d.m.Y') }}</td>
                    <td class="text-center">
                        @php
                            $date = $zgl->created_at;
                            $status_zgloszenia = $zgl->status;

                            $sygnalista_status_historia = DB::table('t083_sygnalista_status_historia')
                                ->where('zgloszenie_id',$zgl->id)
                                ->where('status_id',2)
                                ->first();

                            if($sygnalista_status_historia){
                                $date_status = $sygnalista_status_historia->created_at;
                            }else{
                                $date_status = $date;
                            }

                            $data_ile_dni = my_SignallerDate_HowManyDaysTo($date, $status_zgloszenia, $date_status);

                            if ($data_ile_dni[1] == "-" ){
                                $class = null;
                            }else if ($data_ile_dni[1] >= 3 && $data_ile_dni[1] <= 4 ){
                                $class = "text-warning font-weight-bold";
                            }else if($data_ile_dni[1] < 3){
                                $class = "text-danger font-weight-bold";
                            }else{
                                $class = null;
                            }
                        @endphp
                            <span class="{{ $class }}">{{ $data_ile_dni[1] }}</span>
                    </td>

                    <td class="text-center">
                        @php
                            $zgloszenie_status = DB::connection('mysql-2')->table('zs102_sygnalista_status')
                            ->where('id','=',$zgl->status)
                            ->first();
                        @endphp
                        <a class="btn btn-{{ $zgloszenie_status->kolor }}" href="#" title="{{ $zgloszenie_status->nazwa }}">
                            <i class="{{ $zgloszenie_status->ikona }} fa-lg"></i>
                        </a>
                    </td>

                    <td class="text-center">
                        @if($zgl->user_id)
                            @php
                                $user = DB::table('users')
                                ->where('id','=',$zgl->user_id)
                                ->first();
                            @endphp
                            {{ $user->name }}
                        @else
                            Sygnalista
                        @endif
                    </td>

                    <td class="table_action text-nowrap" style="text-align: right">
                        @if($zgl->status == 1)
                            <a class="btn btn-success" href="{{ route('m_syg_zgloszenia_form_status_first', $zgl->id) }}" title="Potwierdź przyjęcie zgłoszenia">
                                <i class="fas fa-check fa-lg" aria-hidden="true"></i>
                            </a>
                        @else
                            <a class="btn btn-primary" href="{{ url('/m_syg_zgloszenia_info', $zgl->id) }}" title="Szczegóły">
                                <i class="far fa-eye fa-lg" aria-hidden="true"></i>
                            </a>
                        @endif
                    </td>
                </tr>
            @endforeach
        @else
            <tr>
                <td colspan="11" scope="row" class="text-center"><div class="no_records">Brak rekordów spełniających wybrany warunek.</div></td>
            </tr>
        @endif
        </tbody>
    </table>

    <!-- // Paginacja -->
    @php

        $zgloszenia = $zgloszenia->appends(['sort' => $sort,'direction' => $direction])->links();

    @endphp


    <div class="HowManyRecords">{{ $HowManyRecords }} / {{ $zgloszenie_all_count }} </div>

    {!! $zgloszenia !!}



<script>
    function my_setValue(my_name, my_value = null){
        document.getElementById(my_name).value = my_value;
    }
</script>



<!-- Sekcja nr 1 - KONIEC -->
</div>
@endsection



<!-- Navbar section -->
@section('navbar')

@include('sites.syg._navbar_syg')

    <i class="fas fa-chevron-right separator"></i>
    <span class="navbar_navigate" title="Aktywna Strona">
        Lista Zgłoszeń
    </span>


@endsection

<!-- Menu section -->
@section('menu')
    @include('sites.syg.menu_syg')
@endsection