@extends('layouts.site')

@php
    use App\Models\ODO\Rejestr_Szkolen\t051_Szkolenia;
@endphp

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

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

    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_f17', $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('t051_szkolenia');
    $HowManyRecords_sql = DB::table('t051_szkolenia');
    $rejestr_szkolen_sql = t051_Szkolenia::sortable();
    //DB::table('t051_szkolenia');


    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('created_kko_id', '=', $select);
                }
            });

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

            $rejestr_szkolen_sql->where(function($query) {
                    $dzialy_pracownika = my_EmployeeDepartments(Auth::user()->pracownik_id);
                    foreach ($dzialy_pracownika as $select) {
                        $query->orWhere('szkolenie_dla_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);
            $rejestr_szkolen_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(function($query) {
            $status_2 = session()->get('category_status');
            if($status_2 == 1){$status_31 = 1; $status_32 = $status_33 = $status_34 = 0; $status_null = null;}
            else if($status_2 == 2){$status_32 = 2; $status_31 = $status_33 = $status_34 = 0; $status_null = 'x';}
            else if($status_2 == 3){$status_33 = 3; $status_31 = $status_32 = $status_34 = 0; $status_null = 'x';}
            else if($status_2 == 4){$status_34 = 4; $status_31 = $status_32 = $status_33 = 0; $status_null = 'x';}
            else{ $status_31 = 1; $status_32 = 2; $status_33 = 3; $status_34 = 4; $status_null = null;}
            $query->where('status', $status_31)
                ->orWhere('status', $status_32)
                ->orWhere('status', $status_33)
                ->orWhere('status', $status_34)
                ->orWhere('status', $status_null);
        })
        ->where(function($query_2) {
            $filter = session()->get('filter');
            $query_2->where('temat', 'like', '%'.$filter.'%')
            ->orWhere('cel_szkolenia_opis', 'like', '%'.$filter.'%')
            ->orWhere('data', 'like', '%'.$filter.'%');
        });
    $HowManyRecords = $HowManyRecords_sql->count();

    $rejestr_szkolen_sql->where(function($query) {
            $status_2 = session()->get('category_status');
            if($status_2 == 1){$status_31 = 1; $status_32 = $status_33 = $status_34 = 0; $status_null = null;}
            else if($status_2 == 2){$status_32 = 2; $status_31 = $status_33 = $status_34 = 0; $status_null = 'x';}
            else if($status_2 == 3){$status_33 = 3; $status_31 = $status_32 = $status_34 = 0; $status_null = 'x';}
            else if($status_2 == 4){$status_34 = 4; $status_31 = $status_32 = $status_33 = 0; $status_null = 'x';}
            else{ $status_31 = 1; $status_32 = 2; $status_33 = 3; $status_34 = 4; $status_null = null;}
            $query->where('status', $status_31)
                ->orWhere('status', $status_32)
                ->orWhere('status', $status_33)
                ->orWhere('status', $status_34)
                ->orWhere('status', $status_null);
        })
        ->where(function($query_2) {
            $filter = session()->get('filter');
            $query_2->where('temat', 'like', '%'.$filter.'%')
            ->orWhere('cel_szkolenia_opis', 'like', '%'.$filter.'%')
            ->orWhere('data', 'like', '%'.$filter.'%');
        });

    //$rejestr_szkolen = $rejestr_szkolen_sql->paginate($RecordsPerSite,['*'],'page',$page);
    $rejestr_szkolen = $rejestr_szkolen_sql->get();




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



// 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 == 1 && $status_2 != null){ $active_status1 = "active";}else{$active_status1 = null;}
if($status_2 == 2 && $status_2 != null){ $active_status2 = "active";}else{$active_status2 = null;}
if($status_2 == 3 && $status_2 != null){ $active_status3 = "active";}else{$active_status3 = null;}
if($status_2 == 4 && $status_2 != null){ $active_status4 = "active";}else{$active_status4 = 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 Szkoleń ODO -
                                {{ $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_status1 }}"><a class="btn btn-warning btn_table_status" href="{{ url('/m_odo_proces_szkolenia_rejestr_filter', 1) }}" data-toggle="tooltip" title="W przygotowaniu" style="margin-right: 3px;">
                                <i class="fas fa-user-clock fa-lg"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active_status2 }}"><a class="btn btn-primary btn_table_status" href="{{ url('/m_odo_proces_szkolenia_rejestr_filter', 2) }}" data-toggle="tooltip" title="Zatwierdzone" style="margin-right: 3px;">
                                <i class="fas fa-clock fa-lg"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active_status3 }}"><a class="btn btn-success btn_table_status" href="{{ url('/m_odo_proces_szkolenia_rejestr_filter', 3) }}" data-toggle="tooltip" title="Zakończone" style="margin-right: 3px;">
                                <i class="fas fa-check fa-lg"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active_status4 }}"><a class="btn btn-secondary btn_table_status" href="{{ url('/m_odo_proces_szkolenia_rejestr_filter', 4) }}" data-toggle="tooltip" title="Anulowane" 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_szkolenia_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_szkolenia_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('id', 'Lp',[],['class' => 'sortable_column'])</th>
                                    <th class="text-center align-middle rotate-90" scope="col">@sortablelink('data','Data Szkolenia',[],['class' => 'sortable_column'])</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Temat</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Cel Szkolenia</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Szkoleniowiec</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Szkolona Komórka Organizacyjna</th>
                                    <th class="text-center align-middle rotate-90" scope="col">@sortablelink('rodzaj_szkolenia','Rodzaj',[],['class' => 'sortable_column'])</th>
                                    <th class="text-center align-middle rotate-90" scope="col">@sortablelink('forma_szkolenia','Forma',[],['class' => 'sortable_column'])</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Miejsce</th>
                                    <th class="text-center align-middle rotate-90" scope="col">Czas trwania</th>
                                    <th class="text-center align-middle rotate-90" scope="col">@sortablelink('status','Status',[],['class' => 'sortable_column'])</th>
                                    <th class="separate-column"></th>
                                    <th scope="col" class="text-center align-middle table_action">
                                        @php
                                            // ($permision_functions_for_range,$function,$adress,$owner_tab,$onclick = null,$target = null)
                                            $button = my_TableButton($permision_functions_for_range,"add",null,null,"openModalForm('ModalForm_add')",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",null,null,null,null,null,'new-table-add');
                                            echo $button_x;
                                        @endphp
                                    </th>
                                </tr>
                            </thead>
                            <tbody>
                                @if($rejestr_szkolen->count() > 0)
                                    @foreach($rejestr_szkolen as $rejestr)
                                    @php
                                        $owner_tab = my_OwnerRecord($rejestr->szkolenie_dla_ko_id,$rejestr->user_id);
                                        $active_row = my_GetActiveRecord($rejestr->id);
                                        //dd($owner_tab);

                                        $licznik_dzial = 0;

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

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

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

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


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

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

                                        <!-- /* Cel szkolenia */ -->
                                        <td class="text-start">
                                            @php
                                                $zmienna_org = nl2br($rejestr->cel_szkolenia_opis);
                                                $zmienna = substr($zmienna_org, 0, 190);
                                                echo $zmienna;
                                                if(strlen($zmienna_org) > 190){
                                                    echo " ... .";
                                                }
                                            @endphp
                                        </td>

                                        <!-- /* Szkoleniowiec */ -->
                                        <td nowrap class="text-center">
                                            {{ $rejestr->osoba_szkolaca ?? '---' }}
                                        </td>


                                        <!-- /* szkolenie_dla_ko_id */ -->
                                        @php
                                            $szkolona_ko = DB::table('sw020_komorki_organizacyjne')
                                                ->where('id', $rejestr->szkolenie_dla_ko_id)
                                                ->first();
                                        @endphp
                                        <td nowrap class="text-center">
                                            {{ $szkolona_ko->nazwa_skrot ?? 'Organizacja' }}
                                        </td>

                                        <!-- /* rodzaj_szkolenia */ -->
                                        @php
                                            $rodzaje_szkolen = DB::connection('mysql-2')
                                                ->table('zs050_rodzaj_szkolenia')
                                                ->where('id', $rejestr->rodzaj_szkolenia)
                                                ->first();
                                        @endphp
                                        <td nowrap class="text-center">
                                            {{ $rodzaje_szkolen->nazwa ?? '' }}
                                        </td>

                                        <!-- /* forma_szkolenia */ -->
                                        @php
                                            if($rejestr->forma_szkolenia == 1){
                                                $forma_szkolenia_tekst = "Stacjonarne";
                                            }else{
                                                $forma_szkolenia_tekst = "e-Learning";
                                            }
                                        @endphp
                                        <td nowrap class="text-center">
                                            {{ $forma_szkolenia_tekst }}
                                        </td>

                                        <!-- /* miejsce_szkolenia */ -->
                                        <td nowrap class="text-center">
                                            {{ $rejestr->miejsce_szkolenia }}
                                        </td>

                                        <!-- /* czas_trwania */ -->
                                        <td nowrap class="text-center">
                                            {{ $rejestr->czas_trwania }}
                                        </td>

                                        <!-- /* Status szkolenia */ -->
                                        <td nowrap class="text-center">
                                            @if($rejestr->status == 2)
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Zatwierdzone">
                                                    <i class="fas fa-clock fa-lg text-primary "></i>
                                                </div>
                                            @elseif($rejestr->status == 3)
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Zakończone">
                                                    <i class="fas fa-check fa-lg text-success"></i>
                                                </div>
                                            @elseif($rejestr->status == 4)
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="Anulowane">
                                                    <i class="fas fa-times-circle fa-lg text-secondary"></i>
                                                </div>
                                            @else
                                                <div class="btn btn_table_status" data-toggle="tooltip" title="W przygotowaniu">
                                                    <i class="fas fa-user-clock fa-lg text-warning"></i>
                                                </div>
                                            @endif
                                        </td>

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

                                        <!-- /* Akcja */ -->
                                        <td nowrap class="table_action text-left">
                                            @php
                                                $button_details = my_TableButton($permision_functions_for_range,"details","/m_odo_proces_szkolenia_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)",null,$rejestr->id,null,'new');
                                                echo $button_status;

                                                $button_delete = my_TableButton($permision_functions_for_range,"delete",null,$owner_tab,"my_SetActiveRecord($rejestr->id)",null,$rejestr->id,null,'new');
                                                echo $button_delete;
                                            @endphp
                                        </td>
                                    </tr>
                                    @endforeach
                                @else
                                    <tr class="tr_no_records">
                                        <td colspan="13" 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_szkolen = $rejestr_szkolen->appends(['sort' => $sort,'direction' => $direction])->links();
@endphp
<div class="tab-pane" id="div_paginate">{!! $rejestr_szkolen !!}</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 Szkoleń z Zakresu Ochrony Danych Osobowych
    </span>

@endsection

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


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