@extends('layouts.site')

@section('global_variables')
    @php
        // Sprawdzamy zakres uprawnień do danych
        //$function_id = 18;
        $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 (in_array('3', $permision_range)) {}
    $dzialy_pracownika = $get_permision->my_EmployeeDepartments(Auth::user()->pracownik_id);
    //dd($dzialy_pracownika);

    $dzial_pracownika_nazwa = "";
    $licznik = 1;
    $ilosc_dzialow = count($dzialy_pracownika);
    foreach ($dzialy_pracownika as $dzial_id) {
        $dzial_pracownika_nazwa .= my_DepartmentName($dzial_id);
        if($ilosc_dzialow > 1 && $licznik < $ilosc_dzialow){
            $dzial_pracownika_nazwa .= ", ";
        }
        $licznik++;
    }


    $RecordsPerSite = 15;
    $i = 1;

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

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

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

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

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

    $category = session()->get('category');
    $category_status = session()->get('category_status');
    $department = session()->get('department');



    // Początek zapytań do DB

    $HowManyAllRecords_sql = DB::connection('mysql-2')->table('zs020_odo_wzory_dokumentow');
    $HowManyRecords_sql = DB::connection('mysql-2')->table('zs020_odo_wzory_dokumentow');
    //$proces_list = t040_RejestrUmowPowierzenia::sortable();
    $dokumenty_list_sql = DB::connection('mysql-2')->table('zs020_odo_wzory_dokumentow');

    // Filtry
    if(isset($department)){
        $HowManyRecords_sql->where('wlasciciel_procesu_komorka_id',$department);
        $dokumenty_list_sql->where('wlasciciel_procesu_komorka_id',$department);
    }

    /*
    if(isset($category)){
        $category_val = null;
        if($category == 1){$category_val = null; $active1 = "active";}else{$active1 = null;}
        if($category == 2){$category_val = 1; $active2 = "active";}else{$active2 = null;}
        $HowManyRecords_sql->where('proces_cykliczny',$category_val);
        $dokumenty_list_sql->where('proces_cykliczny',$category_val);
    }
    */
    if(isset($category_status)){
        $category_status_val = null;
        if($category_status == 1){$category_status_val = 1; $active_status1 = "active";}else{$active_status1 = null;}
        if($category_status == 2){$category_status_val = null; $active_status2 = "active";}else{$active_status2 = null;}
        $HowManyRecords_sql->where('status_aktywny',$category_status_val);
        $dokumenty_list_sql->where('status_aktywny',$category_status_val);
    }
    // Koniec - Filtry
/*
    if(isset($permision_range)){
        if(in_array(3,$permision_range) || Auth::user()->rola_admin == 1){
            // $HowManyAllRecords_sql;
            // $HowManyRecords_sql;
            // $proces_list_sql
            $sql_4 = DB::table('sw020_komorki_organizacyjne');
            $komorki_organizacyjne = $sql_4->get();

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

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

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

            $sql_4 = DB::table('sw020_komorki_organizacyjne');
            foreach ($dzialy_pracownika as $dzial_id) {
                $sql_4->orWhere('id', '=', $dzial_id);
            }
            $komorki_organizacyjne = $sql_4->get();

            $lista_procesow_opis = $dzial_pracownika_nazwa;

        }else if(in_array(1,$permision_range)){
            $HowManyAllRecords_sql->where('user_id', Auth::user()->id);
            $HowManyRecords_sql->where('user_id', Auth::user()->id);
            $proces_list_sql->where('user_id', Auth::user()->id);

            $sql_4 = DB::table('sw020_komorki_organizacyjne');
            foreach ($dzialy_pracownika as $dzial_id) {
                $sql_4->orWhere('id', '=', $dzial_id);
            }
            $komorki_organizacyjne = $sql_4->get();

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

    }

    //$page = 2;
*/
    $HowManyAllRecords = $HowManyAllRecords_sql->count();

    $HowManyRecords_sql->Where('nazwa_szablonu', 'like', '%'.$filter.'%');
    $HowManyRecords = $HowManyRecords_sql->count();

    $dokumenty_list_sql->Where('nazwa_szablonu', 'like', '%'.$filter.'%');
    //$dokumenty_list = $dokumenty_list_sql->paginate(15,['*'],'page',$page);
    $dokumenty_list = $dokumenty_list_sql->get();


    //dd(session()->all());





@endphp

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

@section('content')
<!-- Sekcja nr 1 - START -->


<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>Wzory Dokumentów</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-success btn_table_status" href="{{ url('/m_odo_dokumenty_wzory_filter_status', 1) }}" data-toggle="tooltip" title="Aktywny" style="margin-right: 3px;">
                                <i class="fas fa-check fa-lg"></i>
                            </a></span>
                            <span class="my_FilterStatus {{ $active_status2 ?? '' }}"><a class="btn btn-secondary btn_table_status" href="{{ url('/m_odo_dokumenty_wzory_filter_status', 2) }}" data-toggle="tooltip" title="Nieaktywny" 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_dokumenty_wzory_filter','0') }}" data-toggle="tooltip" title="Wyczyść filtry">
                                <i class="fas fa-trash fa-lg"></i>
                            </a></span>
                        </div>


                    </div>

                    <div class="col-2" style="flex-basis: content; text-align: right;">
                        {{--
                        <!--/* Wyszukiwarka działy */-->
                        <form action="{{ route('m_odo_proces_lista_index_filter_ko') }}" method="POST">
                            @csrf
                            <div class="input-group wyszukiwarka">
                                <label class="form-label my_HalfFrame my_HalfFrameSearch" for="form1">Komórka Org.: </label>
                                <div class="form-outline">
                                    <select class="form-control form-check-inline" name="select_filter_ko" id="select_filter_ko" style="width: 5vw;" onchange="this.form.submit()">
                                        <option value="">---</option>
                                        @foreach($komorki_organizacyjne as $ko)
                                            <option value="{{$ko->id}}" {{ ( $ko->id == $department) ? 'selected' : '' }}>{{$ko->nazwa_skrot}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </form>
                        --}}



                    </div>

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

                        <form action="{{ route('m_odo_dokumenty_wzory_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">

                        {{-- // Lista Szablonów --}}
                        <input type="hidden" id="active_row" value="{{session()->get('active_record_'.$function_id) ?? '0'}}"/>
                        <table class="table table-sm new_table_app">
                            <thead>
                                <tr class="tabela-naglowek">
                                    <th scope="col" class="text-center">Lp</th>
                                    <th scope="col" class="text-center">ID</th>
                                    <th scope="col" class="text-center">Typ Szablonu</th>
                                    <th scope="col" class="text-center">Nazwa Szablonu</th>
                                    <th scope="col" class="text-center">Opis</th>
                                    <th scope="col" class="text-center">Status</th>
                                    <th class="separate-column"></th>
                                    <th class="text-center table_action">
                                        Akcja
                                        {{--
                                            my_TypSzablonuDokumentu_Name($id)

                                        <br/>
                                        <a type="button" class="btn btn-success btn_table color-white" data-toggle="tooltip" title="Wygeneruj Nowy Dokument" onclick="openModalForm('ModalForm_999'); setValueModalId('999');" >
                                            <i class="far fa-file-alt fa-1x" aria-hidden="true"></i>
                                        </a>
                                            --}}
                                    </th>
                                </tr>
                            </thead>
                            <tbody>
                                @if(isset($dokumenty_list) && $dokumenty_list->count() > 0)
                                    @foreach($dokumenty_list as $dokument)
                                        @php
                                            if($dokument->szablon_for_all == 1){
                                                $for_all = "Dotyczy: ";
                                            }else{
                                                $for_all = "";
                                            }
                                            $TypSzablonuDokumentu_Name = my_TypSzablonuDokumentu_Name($dokument->typ_szablonu_id);
                                        @endphp

                                        @php
                                            $active_row = my_GetActiveRecord($dokument->id);
                                            //dd($active_row);
                                        @endphp

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

                                            <td class="text-center">{{ $dokument->id }}</td>
                                            <td>
                                                {{ $TypSzablonuDokumentu_Name ?? '' }}
                                            </td>
                                            <td class="text-center">{{ $dokument->nazwa_szablonu }}</td>
                                            <td>{{ $for_all }} {{ $dokument->opis }}</td>


                                            <!-- /* Status  */ -->
                                            <td nowrap class="text-center">
                                                @if($dokument->status_aktywny < 1)
                                                    <div class="btn btn_table_status" data-toggle="tooltip" title="Nieaktywny">
                                                        <i class="fas fa-times-circle fa-lg text-secondary"></i>
                                                    </div>
                                                @else
                                                    <div class="btn btn_table_status" data-toggle="tooltip" title="Aktywny">
                                                        <i class="fas fa-check fa-lg text-success"></i>
                                                    </div>
                                                @endif
                                            </td>

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

                                            <td class="table_action text-center" style="font-size: x-small;">
                                                @php
                                                    /* Wzór dokumentu */
                                                    //$button_custom_array = array('btn-info','far fa-file-pdf fa-2x','Podgląd Dokumentu');
                                                    //$button_custom = my_TableButton($permision_functions_for_range,$button_custom_array,"/m_odo_dokumenty_wzory_preview/$dokument->id",null,"my_SetActiveRecord($dokument->id)","_blank",null,null,'new');
                                                    //echo $button_custom;
                                                @endphp

                                                @if($dokument->status_aktywny == 1)
                                                    <a type="button" class="btn new-btn-success btn_table" data-toggle="tooltip" title="Wygeneruj Nowy Dokument" onclick="openModalForm('ModalForm_dokument_generator'); setValueModalId({{ $dokument->id }}); my_SetActiveRecord({{ $dokument->id }});" >
                                                        <i class="far fa-file-alt fa-2x text-success"></i>
                                                    </a>
                                                @endif
                                                {{--
                                                <a type="button" class="btn btn-secondary btn_table color-white" data-toggle="tooltip" title="Szablon" onclick="openModalForm('ModalForm_szablon'); setValueModalId({{ $dokument->id }});" >
                                                    <i class="far fa-file-alt fa-1x" aria-hidden="true"></i>
                                                </a>
                                                --}}
                                            </td>
                                        </tr>
                                    @endforeach
                                @else
                                    <tr class="tr_no_records">
                                        <td colspan="8" 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">{!! $dokumenty_list->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;
    }

    function setValueModalId(my_value){
        $("input[name='szablon_dokumentu_id']").val(my_value);

        var el_div_form_proces_id = document.getElementById('div_form_proces_id');
        var el_form_proces_id = document.getElementById('form_proces_id');

        if(my_value == 14){
            el_div_form_proces_id.hidden = false;
            el_form_proces_id.required = true;
        }else{
            el_div_form_proces_id.hidden = true;
            el_form_proces_id.required = false;
        }

        /*get data from DB */
        var url = "zs020_OdoWzoryDokumentow_detail";
        $.get(url + '/' + my_value, function (data) {
            //success data
            console.log(data);
            // Wysłanie danych do DIV - jQuery
                $('#szablon_nazwa').html(data.nazwa_szablonu);
                $('#szablon_opis').html(data.opis);
        });

    }



</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">
        Wzory Dokumentów
    </span>

@endsection

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

<!--/* Modal Windows section */-->
@section('modal_windows')
    {{--@include('sites.odo.dokumenty.modal_forms.form_modal_for_all')--}}
    @include('sites.odo.dokumenty.modal_forms.form_modal_dokument_generator')
    {{--@include('sites.odo.dokumenty.modal_forms.form_modal_for_proces')--}}

    {{--


    @include('sites.odo.dokumenty.modal_forms.form_modal_szablon')
    @include('sites.odo.dokumenty.modal_forms.form_modal_999')

    {{--
    @include('sites.admin.procesy.m_admin_procesy_form_add_modal')
    @include('sites.admin.procesy.m_admin_procesy_form_edit_modal')
    @include('sites.admin.procesy.m_admin_procesy_form_delete_modal')
    --}}
@endsection