@extends('layouts.site')

@php
    use App\Models\ODO\Zgloszenia\t045_Zgloszenia;
@endphp

@section('global_variables')
    @php
        // Sprawdzamy zakres uprawnień do danych
        //$function_id = 14;
        $function_id = session()->get('function_id');
        $get_permision = new my_GetPermission();
        $permision_range = $get_permision->my_range($function_id);
        $permision_functions = $get_permision->my_function_values($function_id);
        $permision_functions_for_range = $get_permision->my_function_values_for_range($function_id);
        $active_rekord_id = session()->get('active_record_'.$function_id);

        $return_to = my_Return('return_to');
        $return_to_before = my_Return('return_to_before');
        $return_to_after_delete = Route::current()->getName();
        // dd($permision_range);
        // dd($permision_functions);
        // dd($permision_functions_for_range);

        // val. 1 - wpisy własne
        // val. 2 - wpisy komórki organizacyjnej
        // val. 3 - wpisy wszystkie w organizacji
    @endphp
@endsection

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

@section('content')

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

    $RecordsPerSite = 15;
    $i = 1;
    if(isset($_GET['page'])){

        $page = $_GET['page'];

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

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

    $status = session()->get('category');
    $status_2 = session()->get('category_status');
    $filter = session()->get('filter');



/* Pobieram wszystkie działy */
$dzialy = DB::table('sw020_komorki_organizacyjne')
    ->get();


$pracownik_dzial = DB::table('v021_pracownicy_w_dziale')
    ->where('v021_osoba_id', Auth::user()->id)
    ->get();

//$dzial_pracownika[] = 1;
foreach ( $pracownik_dzial as $item )
{
    $rola_pracownika_id = 'x';
    $rola_pracownika_nazwa = 'y';
}
//echo $dzial_pracownika[3];
// Pobieram nazwę roli zalogowanego użytkownika



// Kolorowanie filtrów - podkreślenie
if($status == 1){ $active1 = "active";}else{$active1 = null;}
if($status == 2){ $active2 = "active";}else{$active2 = null;}
if($status == 3){ $active3 = "active";}else{$active3 = null;}
if($status == 4){ $active4 = "active";}else{$active4 = null;}

if($status_2 == 0 && $status_2 != null){ $active_status1 = "active";}else{$active_status1 = null;}
if($status_2 == 1){ $active_status2 = "active";}else{$active_status2 = null;}



// Początek zapytań do DB
    $HowManyAllRecords_sql = DB::table('t045_zgloszenia');
    $HowManyRecords_sql = DB::table('t045_zgloszenia');
    $zgloszenia_sql = t045_Zgloszenia::sortable();
    //$zgloszenia_sql = DB::table('t045_zgloszenia')->get();

    //dd($zgloszenia_sql);
    if(isset($permision_range)){
        if(in_array(3,$permision_range) || Auth::user()->rola_admin == 1){

            // $HowManyAllRecords_sql;
            // $HowManyRecords_sql;
            // $rejestr_umow_powierzenia_sql;

            $tytul_okna_opis = "Jednostka Organizacyjna";

        }else if(in_array(2,$permision_range)){

            $HowManyAllRecords_sql->where(function($query) {
                $dzialy_pracownika = my_EmployeeDepartments(Auth::user()->pracownik_id);
                foreach ($dzialy_pracownika as $select) {
                    $query->orWhere('ko_id', '=', $select);
                }
            });

            $HowManyRecords_sql->where(function($query) {
                    $dzialy_pracownika = my_EmployeeDepartments(Auth::user()->pracownik_id);
                    foreach ($dzialy_pracownika as $select) {
                        $query->orWhere('ko_id', '=', $select);
                    }
                });

            $zgloszenia_sql->where(function($query) {
                    $dzialy_pracownika = my_EmployeeDepartments(Auth::user()->pracownik_id);
                    foreach ($dzialy_pracownika as $select) {
                        $query->orWhere('ko_id', '=', $select);
                    }
                });

            $tytul_okna_opis = my_EmployeeDepartmentsNames(Auth::user()->id);

        }else if(in_array(1,$permision_range)){
        // Tylko właściciel

            $HowManyAllRecords_sql->where('user_id', '=' , Auth::user()->id);
            $HowManyRecords_sql->where('user_id', '=' , Auth::user()->id);
            $zgloszenia_sql->where('user_id', '=' , Auth::user()->id);

            $tytul_okna_opis = "Własnych (tych które dodałeś do systemu)";

        }
    }

    $HowManyAllRecords = $HowManyAllRecords_sql->count();

    $HowManyRecords_sql->where('opis', 'like', '%'.$filter.'%')
    ->where('rodzaj_zgloszenia', 'like', '%'.$status.'%')
    ->where('status', 'like', '%'.$status_2.'%');
    $HowManyRecords = $HowManyRecords_sql->count();

    $zgloszenia_sql->where('opis', 'like', '%'.$filter.'%')
    ->where('rodzaj_zgloszenia', 'like', '%'.$status.'%')
    ->where('status', 'like', '%'.$status_2.'%');
    //$zgloszenia = $zgloszenia_sql->paginate(15);
    $zgloszenia = $zgloszenia_sql->get();


@endphp

<div class="tab-content_2">
    <div class="row">
        <div class="col-sm-12">


            <div class="" id="nav-tabContent">
                <!-- /* Widoczne na wszystkich zakładkach */ -->
                <div class="row">
                    <div class="col-10">
                        <h5>
                            <i>Rejestr Zgłoszeń -
                                {{ $tytul_okna_opis }}
                            </i>
                        </h5>
                    </div>
                </div>
                <hr class="separator_site">

                <!-- 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 my_FilterStatus" for="form1">Wybierz Filtr: </label>

                            <span class="my_FilterStatus {{ $active1 }}"><a class="btn btn-success btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter', 1) }}" data-toggle="tooltip" title="Kontakt z IOD" style="margin-right: 3px;">
                                <i class="far fa-lg fa-comment"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active2 }}"><a class="btn btn-info btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter', 2) }}" data-toggle="tooltip" title="Nowy Proces" style="margin-right: 3px;">
                                <i class="fas fa-lg fa-bolt"></i>
                            </a></span>
                            {{--
                            <span class="my_FilterStatus {{ $active3 }}"><a class="btn btn-warning btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter', 3) }}" data-toggle="tooltip" title="Udostępnienie Danych" style="margin-right: 3px;">
                                <i class="fas fa-lg fa-user-check"></i>
                            </a></span>
                             --}}
                            <span class="my_FilterStatus {{ $active4 }}"><a class="btn btn-danger btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter', 4) }}" data-toggle="tooltip" title="Naruszenie ODO" style="margin-right: 3px;">
                                <i class="far fa-lg fa-bell"></i>
                            </a></span>

                        <label class="form-label my_HalfFrame my_HalfFrameFilter my_FilterStatus" for="form1">Status: </label>

                            <span class="my_FilterStatus {{ $active_status1 }}"><a class="btn btn-warning btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter_status', 0) }}" data-toggle="tooltip" title="Oczekujący" style="margin-right: 3px;">
                                <i class="far fa-hourglass fa-lg"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active_status2 }}"><a class="btn btn-success btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter_status', 1) }}" data-toggle="tooltip" title="Zakończony" style="margin-right: 3px;">
                                <i class="fas fa-check fa-lg"></i>
                            </a></span>


                        <label class="form-label my_HalfFrame my_HalfFrameFilter my_FilterStatus" for="form1">Wyczyść: </label>

                            <span class="my_FilterStatusNone"><a class="btn alert-dark btn_table_status" href="{{ url('/m_odo_zgl_rejestr_zgloszen_filter','0') }}" data-toggle="tooltip" title="Wyczyść filtry">
                                <i class="fas fa-trash fa-lg"></i>
                            </a></span>
                        </div>


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

                        <form action="{{ route('m_odo_zgl_rejestr_zgloszen_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 btn_table_status" data-toggle="tooltip" title="Wyszukaj">
                                    <i class="fas fa-search fa-lg"></i>
                                </button>
                                <button type="submit" class="btn btn-danger btn_table_status" data-toggle="tooltip" title="Wyczyść filtr wyszukiwania" onclick="my_setValue('search')">
                                    <i class="fas fa-times fa-lg"></i>
                                </button>
                            </div>
                        </form>



                    </div>

                </div>

                <!-- Wyszukiwarka - KONIEC -->

                <!-- /* KONIEC - Widoczne na wszystkich zakładkach */ -->
                <div class="col-sm-12 m-md-auto div_new_table">
                    <div class="tab-pane fade show active div_TableScroll tableFixHead my_scrollbar_new">

                        <input type="hidden" id="active_row" value="{{session()->get('active_record_'.$function_id) ?? '0'}}"/>
                        <table id="TableHorizontalScroll" class="table table-sm new_table_app">
                            <thead>
                                <tr class="tabela-naglowek">
                                    <th class="text-center align-middle rotate-90" scope="col">Lp</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Komórka Organizacyjna</th>
                                    <th class="text-center align-middle rotate-90" scope="col" colspan="2">Rodzaj Zgłoszenia</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Osoba Zgłaszająca</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Opis</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Data Dodania</th>
                                    <th class="separate-column"></th>
                                    <th class="text-center align-middle rotate-90" scope="col">Status</th>
                                    <th class="separate-column"></th>
                                    <th scope="col" class="text-center table_action">
                                        <!-- /*
                                        <a class="btn btn-success" href="{{ url('/m_odo_zgl_kontakt_iod') }}" data-toggle="tooltip" title="Dodaj Nowy" style="width: 8.3rem" onclick="$.cookie('rzgl_tab', '', { expires: -1 });" >
                                            <i class="fa fa-plus fa-1x" aria-hidden="true"></i>
                                        </a>
                                        */ -->
                                    </th>
                                </tr>
                                <tr class="tabela-naglowek">
                                    <th class="text-center align-middle" scope="col">1</th>
                                    <th class="text-center align-middle" scope="col">2</th>
                                    <th class="text-center align-middle" scope="col">3</th>
                                    <th class="text-center align-middle" scope="col">4</th>
                                    <th class="text-center align-middle" scope="col">5</th>
                                    <th class="text-center align-middle" scope="col">6</th>
                                    <th class="text-center align-middle" scope="col">7</th>
                                    <th class="text-center align-middle" scope="col"></th>
                                    <th class="text-center align-middle" scope="col">8</th>
                                    <th class="text-center align-middle" scope="col"></th>
                                    <th class="text-center align-middle" scope="col">9</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if($zgloszenia->count() > 0)
                                    @foreach($zgloszenia as $rejestr)
                                    @php
                                        $owner_tab = my_OwnerRecord($rejestr->ko_id,$rejestr->user_id);
                                        $active_row = my_GetActiveRecord($rejestr->id)
                                        //dd($owner_tab);
                                    @endphp

                                    <tr id="tr_id_{{$rejestr->id}}" class="{{$active_row}}">
                                        <th scope="row" class="text-center">{{ $i++ }}
                                        @php
                                            echo my_SetAnchor($rejestr->id);
                                        @endphp
                                        </th>

                                        @php
                                            $users = DB::table('users')
                                                ->where('id', $rejestr->user_id)
                                                ->first();

                                            $ko = DB::table('sw020_komorki_organizacyjne')
                                                    ->where('id', $rejestr->ko_id)
                                                    ->get();
                                                    foreach($ko as $ko_item){
                                                        $ko_nazwa_pelna = $ko_item->nazwa_pelna;
                                                    }
                                        @endphp

                                        <!-- /* Komórka organizacyjna */ -->
                                        <td class="text-start nowrap">

                                            {{ $ko_nazwa_pelna ?? '---'}}

                                        </td>

                                        <!-- /* Rodzaj Zgłoszenia ikona */ -->
                                        <td class="text-center nowrap">
                                            @if($rejestr->rodzaj_zgloszenia == 1)
                                                <span class="btn btn_table_status"><i class="far fa-lg fa-comment text-success"></i></span>
                                            @elseif($rejestr->rodzaj_zgloszenia == 2)
                                                <span class="btn btn_table_status"><i class="fas fa-lg fa-bolt text-info"></i></span>
                                            @elseif($rejestr->rodzaj_zgloszenia == 3)
                                                <span class="btn btn_table_status"><i class="fas fa-lg fa-user-check text-warning"></i></span>
                                            @elseif($rejestr->rodzaj_zgloszenia == 4)
                                                <span class="btn btn_table_status"><i class="far fa-lg fa-bell text-danger"></i></span>
                                            @endif
                                        </td>

                                        <!-- /* Rodzaj Zgłoszenia */ -->
                                        <td nowrap class="text-start">
                                            {{my_RodzajZgloszenia_Name($rejestr->rodzaj_zgloszenia)}}
                                        </td>

                                        <!-- /* Nazwisko i Imię */ -->
                                        <td class="text-center" >
                                            {{ $users->name ?? '---'}} <br/> {{ $users->email ?? '---'}}
                                        </td>

                                        <!-- /* Opis zgłoszenia */ -->
                                        <td class="text-start">
                                            {{ $rejestr->opis ?? '---'}}
                                        </td>

                                        <!-- /*  */ -->
                                        <td class="text-center" style="white-space: nowrap;">
                                            {{ date('Y-m-d', strtotime($rejestr->created_at)) ?? '---'}}
                                        </td>

                                        <td nowrap class="text-center align-middle"></td>

                                        <!-- /* Status zgłoszenia */ -->
                                        <td nowrap class="text-center">
                                            @if($rejestr->status < 1)
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Oczekuje">
                                                    <i class="far fa-hourglass fa-lg text-warning"></i>
                                                </div>
                                            @else
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Zakończono">
                                                    <i class="fas fa-check fa-lg text-success"></i>
                                                </div>
                                            @endif
                                        </td>

                                        <td nowrap class="text-center align-middle"></td>

                                        <!-- /* Akcja */ -->
                                        <td nowrap class="table_action text-left">
                                            @php
                                                //$button_info = my_TableButton($permision_functions_for_range,"details","/m_odo_ocena_skutkow_info/$ocena->id",$owner_tab,"my_SetActiveRecord($rejestr->id)",null,null,null,'new');

                                                $button_details = my_TableButton($permision_functions_for_range,"details","/m_odo_zgl_rejestr_form_info/$rejestr->id",$owner_tab,"my_SetActiveRecord($rejestr->id)",null,null,null,'new');
                                                echo $button_details;

                                                $button_status = my_TableButton($permision_functions_for_range,"status",null,$owner_tab,"my_SetActiveRecord($rejestr->id); openModalForm('ModalForm_status')",null,$rejestr->id,null,'new');
                                                //$button_status = my_TableButton($permision_functions_for_range,"status",null,$owner_tab,"openModalForm('ModalForm_status-$rejestr->id')",null,null,null,'new');
                                                echo $button_status;

                                                $button_edit = my_TableButton($permision_functions_for_range,"edit",null,$owner_tab,"my_SetActiveRecord($rejestr->id); openModalForm('ModalForm_edit')",null,$rejestr->id,null,'new');
                                                echo $button_edit;
                                            @endphp
                                            <!--/*
                                            <a class="btn btn-info" href="{{ url('/m_odo_zgl_form_info', $rejestr->id) }}" title="Szczegóły" onclick="$.cookie('rup_szczegoly_tab', 'part1', { expires: -1 });" >
                                                <i class="far fa-eye fa-lg" aria-hidden="true"></i>
                                            </a>
                                            <a class="btn btn-primary" onclick="$.cookie('rup_szczegoly_tab', '', { expires: -1 });"  href="{{ url('m_odo_zgl_form_edit', $rejestr->id) }}" title="Edycja" >
                                                <i class="fa fa-edit fa-lg" aria-hidden="true"></i>
                                            </a>
                                            <a class="btn btn-warning" href="{{ url('/m_odo_zgl_form_status', $rejestr->id) }}" title="Zmień Status" onclick="$.cookie('rup_szczegoly_tab', 'part1', { expires: -1 });" >
                                                <i class="fas fa-sync-alt fa-lg" aria-hidden="true"></i>
                                            </a>
                                            */-->
                                        </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>
                    </div>
                </div>

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



<!-- // Informacja o ilości rekordów wyświetlanych na stronie -->
<div class="HowManyRecords">{{ $HowManyRecords }} / {{ $HowManyAllRecords }} </div>

{{--
<!-- // Paginacja -->
<div class="tab-pane" id="div_paginate">{!! $zgloszenia->links() !!}</div>
--}}

<!-- Sekcja nr 1 - KONIEC -->


<script>
    // Pobieram id aktywnego rekordu i przewijam tabelę do tego rekordu
    $(document).ready(function() {
        const thead = document.querySelector("table > thead");
        var thead_height = thead.offsetHeight;

        const div_TableScroll = document.querySelector("div.div_TableScroll");
        var div_TableScroll_height = div_TableScroll.offsetHeight;
        //console.log(div_TableScroll_height);
        targetElm_2 = document.querySelector('div.no_records');
        //console.log(targetElm_2);
        if(targetElm_2){
            div_TableScroll_height_final = div_TableScroll_height - thead_height - 25;
            targetElm_2.style.height = div_TableScroll_height_final+'px';
        }

        var active_row_value = document.getElementById('active_row').value;
        //console.log(active_row_value);
        // location.hash = '#' + active_row_value;
        //$('div').animate({ scrollTop: $('#' + active_row_value).offset().top }, 800);
        //$('div').scrollTop: $('#' + active_row_value).offset().top;
        targetElm = document.querySelector('.active_row');
        if(targetElm){
            targetElm.style.scrollMargin = thead_height+'px';
            targetElm.scrollIntoView({ behavior: 'smooth', block: 'start' });
        }
    });


    function my_SetActiveRecord(id_row){
        var id_row;

        var element = document.getElementById('tr_id_'+id_row);
        //console.log(element);
        const boxes = Array.from(document.getElementsByClassName('active_row'));
        //console.log(boxes);
        boxes.forEach(box => {
            // Remove class from each element
            box.classList.remove('active_row');
            // Add class to each element
            // box.classList.add('small');
        });

        var element = document.getElementById('tr_id_'+id_row);
        //console.log(id_row);
        element.classList.add("active_row");
        //$('div').animate({ scrollTop: $('#' + element).offset().top }, 800);
        //var active_row_value = document.getElementById('active_row').value;
        //targetElm = document.querySelector('.active_row');
        const thead = document.querySelector("table > thead");
        var thead_height = thead.offsetHeight;
        element.style.scrollMargin = thead_height+'px';
        element.scrollIntoView({ behavior: 'smooth', block: 'start' });

        var baseUrl = "{{URL::to('/')}}";

        $.ajax({
            url: baseUrl+"/set_session",
            type: "GET",
            data: {
                //type: 100,
                active_record: id_row
                //email: 'email',
                //city: 'city'
            } /*,
            cache: false,
            success: function(dataResult){
                console.log(dataResult);
            }
            */
        });

    }

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


@endsection




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

    @include('sites.odo._navbar_odo')

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

@endsection

<!-- Menu section -->
@section('menu')
    @include('sites.odo.menu_odo')
@endsection

<!--/* Modal Windows section */-->
@section('modal_windows')
    @include('sites.odo.zgloszenia.form_modal_status')
    @include('sites.odo.zgloszenia.form_modal_edit')
@endsection