@extends('layouts.site')

@php
    use App\Models\ODO\Rejestr_Upowaznien\t042_View_RejestrUpowaznien;
    use App\Models\ODO\Rejestr_Upowaznien\t042_RejestrUpowaznien;
@endphp

@section('global_variables')
    @php
        // Sprawdzamy zakres uprawnień do danych
        //$function_id = 5;
        $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

@php

    if(isset($_GET['page'])){
        session()->flash('page_back_f5', $_GET['page']);
    }

@endphp

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

@section('content')

{{-- Poprawka UPO --}}
@include('sites.odo.rejestr_upowaznien._include_upo')

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

    $RecordsPerSite = 15;
    $i = 1;

    $page_back = session()->get('page_back_f5');

    if(isset($_GET['page'])){
        $page = $_GET['page'];
    }else if(isset($page_back)){
        $page = $page_back;
    }else{
        $page = null;
    }

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

    session()->flash('page_back_f5', $page);

    // Odczyt danych z sesji
    //$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');


    // Początek zapytań do DB
    $HowManyAllRecords_sql = DB::table('v042_upowaznienia');
    $HowManyRecords_sql = DB::table('v042_upowaznienia');
    //$HowManyAllRecords_sql = t042_View_RejestrUpowaznien::get();
    //$HowManyRecords_sql = t042_View_RejestrUpowaznien::get();
    $rejestr_upowaznien_sql = t042_View_RejestrUpowaznien::sortable();


    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)){
            // Tylko komórka organizacyjna

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

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

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

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

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

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

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

        }
    }


    $HowManyAllRecords = $HowManyAllRecords_sql->count();

    $HowManyRecords_sql->where(function($query) {
            $status_2 = session()->get('category_status');
            if($status_2 == 1){$status_31 = $status_32 = $status_33 = 1; }
            else if($status_2 == 2){ $status_31 = $status_32 = 0; $status_33 = null;}
            else{ $status_31 = null; $status_32 = 0; $status_33 = 1;}
            $query->where('v042_upowaznienie_status_aktualny', $status_31)
                ->orWhere('v042_upowaznienie_status_aktualny', $status_32)
                ->orWhere('v042_upowaznienie_status_aktualny', $status_33);
        })
        ->where(function($query_2) {
            $filter = session()->get('filter');
            $query_2->where('v042_upowaznienie_zakres_upowaznienia_opis', 'like', '%'.$filter.'%');

            if($filter == null){
                $query_2->orWhere('v042_upowaznienie_zakres_upowaznienia_opis', null);
            }
        });
    $HowManyRecords = $HowManyRecords_sql->count();

    $rejestr_upowaznien_sql->where(function($query) {
            $status_2 = session()->get('category_status');
            if($status_2 == 1){$status_31 = $status_32 = $status_33 = 1; }
            else if($status_2 == 2){ $status_31 = $status_32 = 0; $status_33 = null;}
            else{ $status_31 = null; $status_32 = 0; $status_33 = 1;}
            $query->where('v042_upowaznienie_status_aktualny', $status_31)
                ->orWhere('v042_upowaznienie_status_aktualny', $status_32)
                ->orWhere('v042_upowaznienie_status_aktualny', $status_33);
        })
        ->where(function($query_2) {
            $filter = session()->get('filter');
            $query_2->where('v042_osoba_nazwisko', 'like', '%'.$filter.'%')
                    ->orWhere('v042_osoba_imie', 'like', '%'.$filter.'%')
                    ->orWhere('v042_upowaznienie_zakres_upowaznienia_opis', 'like', '%'.$filter.'%');;

            if($filter == null){
                $query_2->orWhere('v042_upowaznienie_zakres_upowaznienia_opis', null);
            }
        });
    //$rejestr_upowaznien = $rejestr_upowaznien_sql->paginate($RecordsPerSite,['*'],'page',$page);
    $rejestr_upowaznien = $rejestr_upowaznien_sql->get();




/* 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 )
{
    $dzial_pracownika_id[] = $item->v021_dzial_id;
    $dzial_pracownika_nazwa = $item->v021_dzial_nazwa;
    $dzial_pracownika_nazwa_skrot = $item->v021_dzial_skrot;
}
//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 == 2 && $status_2 != null){ $active_status1 = "active";}else{$active_status1 = null;}
if($status_2 == 1){ $active_status2 = "active";}else{$active_status2 = null;}


@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 Upoważnień do PDO -
                                {{ $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_HalfFrameFilter my_FilterStatus" for="form1">Status: </label>

                            <span class="my_FilterStatus {{ $active_status2 }}"><a class="btn btn-success btn_table_status" href="{{ url('/m_odo_proces_upowaznienia_rejestr_filter_status', 1) }}" data-toggle="tooltip" title="Obowiązująca" style="margin-right: 3px;">
                                <i class="fas fa-check fa-lg"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active_status1 }}"><a class="btn btn-secondary btn_table_status" href="{{ url('/m_odo_proces_upowaznienia_rejestr_filter_status', 2) }}" data-toggle="tooltip" title="Nieaktualna" style="margin-right: 3px;">
                                <i class="fas fa-times-circle 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_proces_upowaznienia_rejestr_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_proces_upowaznienia_rejestr_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">@sortablelink('v042_id', 'Lp',[],['class' => 'sortable_column'])</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">@sortablelink('v042_osoba_nazwisko','Nazwisko',[],['class' => 'sortable_column'])</th>
                                    <th  class="text-center align-middle rotate-90" scope="col">@sortablelink('v042_osoba_imie','Imię',[],['class' => 'sortable_column'])</th>
                                    <th  class="text-center align-middle rotate-90" scope="col">Nr upoważnienia</th>
                                    <th  class="text-center align-middle rotate-90" scope="col">@sortablelink('v042_upowaznienie_data_wystawienia','Data wystawienia',[],['class' => 'sortable_column'])</th>
                                    <th  class="text-center align-middle rotate-90" scope="col">@sortablelink('v042_upowaznienie_data_od','Data nadania upoważnienia',[],['class' => 'sortable_column'])</th>
                                    <th  class="text-center align-middle rotate-90" scope="col">@sortablelink('v042_upowaznienie_data_do','Data odebrania upoważnienia',[],['class' => 'sortable_column'])</th>
                                    <th  class="text-center align-middle rotate-90" scope="col">@sortablelink('v042_upowaznienie_status_aktualny','Status',[],['class' => 'sortable_column'])</th>
                                    <th scope="col" class="text-center align-middle table_action" style="text-align: center !important">
                                        Wydruki
                                        <br/>
                                        <a class="btn new-table-add-btn-success" href="{{ url('/pdf_upowaznienie_do_pdo_all') }}" target="_blank" data-toggle="tooltip" type="btn" title="Upoważnienia - Wygeneruj Dokumenty - Wydruk zbiorowy">
                                            <i class="far fa-file-pdf fa-lg" aria-hidden="true"></i>
                                        </a>
                                    </th>
                                    <th class="separate-column"></th>
                                    <th class="table_action" style="text-align: center">
                                        @php
                                            // ($permision_functions_for_range,$function,$adress,$owner_tab,$onclick = null,$target = null)
                                            //$button_add = my_TableButton($permision_functions_for_range,"add",null,'none',"openModalForm('ModalForm_proces_add','m_odo_proces_lista_index')",'',null,null,'new-table-add');
                                            $button = my_TableButton($permision_functions_for_range,"add",null,'none',"openModalForm('ModalForm_add','$return_to')",null,null,null,'new-table-add');
                                            echo $button;

                                            $button_x = my_TableButton($permision_functions_for_range,"import","/m_odo_proces_upowaznienia_rejestr_add_from_file",'none',null,null,null,null,'new-table-add');
                                            echo $button_x;
                                        @endphp
                                    </th>
                                </tr>
                            </thead>
                            <tbody>
                                @if($rejestr_upowaznien->count() > 0)
                                    @foreach($rejestr_upowaznien as $rejestr)
                                    @php
                                        $owner_tab = my_OwnerRecord($rejestr->ko_id,$rejestr->v042_upowaznienie_user_id);
                                        $active_row = my_GetActiveRecord($rejestr->v042_id);
                                        //dd($owner_tab);

                                        $licznik_dzial = 0;

                                            $osoba_t035_osoby = DB::table('t035_osoby')
                                                ->where('id', $rejestr->v042_osoba_id)
                                                ->first();

                                            $count_dzialy_dla_osoby = DB::table('t021_pracownicy_w_dziale')
                                                ->where('pracownik_id', $rejestr->v042_osoba_id)
                                                ->where('status', 1)
                                                ->count();

                                            $dzialy_dla_osoby = DB::table('t021_pracownicy_w_dziale')
                                                ->where('pracownik_id', $rejestr->v042_osoba_id)
                                                ->where('status', 1)
                                                ->get();

                                    @endphp

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

                                        <!-- /* Komórka Organizacyjna */ -->
                                        <td nowrap class="text-start">
                                            @foreach($dzialy_dla_osoby as $dzial_dla_osoby)
                                                @php
                                                    $licznik_dzial++;

                                                    $dzial = DB::table('sw020_komorki_organizacyjne')
                                                        ->where('id', $dzial_dla_osoby->dzial_id)
                                                        ->first();

                                                @endphp
                                                @if($count_dzialy_dla_osoby > 1)
                                                    {{ $licznik_dzial ?? '' }} |
                                                @endif
                                                    {{ $dzial->nazwa_pelna ?? '---'}}
                                                @if ($licznik_dzial <= $count_dzialy_dla_osoby)
                                                    <br/>
                                                @endif
                                            @endforeach
                                            @if ($count_dzialy_dla_osoby == 0)
                                                    ---
                                            @endif
                                        </td>

                                        <!-- /* Osoba Nazwisko */ -->
                                        <td nowrap class="text-start">
                                            {{ $rejestr->v042_osoba_nazwisko ?? 'Brak' }}
                                        </td>

                                        <td nowrap class="text-start">
                                            {{ $rejestr->v042_osoba_imie ?? 'Brak' }}
                                        </td>


                                        <!-- /* Nr upo */ -->
                                        <td nowrap class="text-center">
                                            {{ my_NrUpo($rejestr->v042_id) }}
                                        </td>

                                        <!-- /* Data wystawienia upo */ -->
                                        <td nowrap class="text-center">
                                            @if(isset($rejestr->v042_upowaznienie_data_wystawienia))
                                                {{ date('Y-m-d', strtotime($rejestr->v042_upowaznienie_data_wystawienia)) ?? '' }}
                                            @else
                                                ---
                                            @endif
                                        </td>

                                        <!-- /* Data zawarcia umowy */ -->
                                        <td nowrap class="text-center">
                                            {{ date('Y-m-d', strtotime($rejestr->v042_upowaznienie_data_od)) }}
                                        </td>



                                        <!-- /* Okres obowiązywania umowy */ -->
                                        <td nowrap class="text-center">
                                            @php
                                                if($rejestr->v042_upowaznienie_data_do == null){ $data_do = "bezterminowo"; }else{ $data_do = date('Y-m-d', strtotime($rejestr->v042_upowaznienie_data_do)); }
                                            @endphp
                                            {{ date('Y-m-d', strtotime($rejestr->v042_upowaznienie_data_od)) }} - {{ $data_do }}
                                        </td>



                                        <!-- /* Status zgłoszenia */ -->
                                        <td nowrap class="text-center">
                                            @if($rejestr->v042_upowaznienie_status_aktualny < 1)
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Nieaktualne">
                                                    <i class="fas fa-times-circle fa-lg text-secondary"></i>
                                                </div>
                                            @else
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Obowiązujące">
                                                    <i class="fas fa-check fa-lg text-success"></i>
                                                </div>
                                            @endif
                                        </td>

                                        <!-- /* Wydruki */ -->
                                        <td class="text-center">
                                            <a class="btn btn_table_status" href="{{ url('/pdf_upowaznienie_do_pdo_osoba', $rejestr->v042_id) }}" target="_blank" data-toggle="tooltip" type="btn" title="Upoważnienie - Wygeneruj Dokument">
                                                <i class="far fa-file-pdf fa-lg" aria-hidden="true"></i>
                                            </a>
                                        </td>

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

                                        <!-- /* Akcja */ -->
                                        <td nowrap class="table_action text-center">
                                            @php
                                                $button_details = my_TableButton($permision_functions_for_range,"details","/m_odo_proces_upowaznienia_rejestr_form_info/$rejestr->v042_id",$owner_tab,"my_SetActiveRecord($rejestr->v042_id)",null,null,null,'new');
                                                echo $button_details;

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

                                                $button_delete = my_TableButton($permision_functions_for_range,"delete",null,$owner_tab,"my_SetActiveRecord($rejestr->v042_id)",null,$rejestr->v042_id,null,'new');
                                                echo $button_delete;

                                            @endphp
                                        </td>
                                    </tr>
                                    @endforeach
                                @else
                                    <tr class="tr_no_records">
                                        <td colspan="12" 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 -->
{{--
@php
    $rejestr_upowaznien = $rejestr_upowaznien->appends(['sort' => $sort,'direction' => $direction])->links();
@endphp
<div class="tab-pane" id="div_paginate">{!! $rejestr_upowaznien !!}</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 Upoważnień do Przetwarzania Danych
    </span>

@endsection

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


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