@extends('layouts.site')

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

    }
    // Sprawdzenie właściciela rekordu
    //$owner_tab = my_OwnerRecord(null,Auth::user()->id);
    //dd($owner_tab);

    $RecordsPerSite = 15;
    $i = 1;

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

    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_f21', $page);

    //$page = session()->get('page');
    $sort = session()->get('sort');
    $direction = session()->get('direction_'.$function_id);
    $filter = session()->get('filter_'.$function_id);

    $category = session()->get('category_'.$function_id);
    $category_status = session()->get('category_status_'.$function_id);
    $department = session()->get('department_'.$function_id);



    // Początek zapytań do DB
    $HowManyAllRecords_sql = DB::table('t060_analizy_ryzyka');
    $HowManyRecords_sql = DB::table('t060_analizy_ryzyka');
    //$proces_list = t040_RejestrUmowPowierzenia::sortable();
    $lista_analiz_sql = DB::table('t060_analizy_ryzyka');

    $lista_analiz_tmp_sql = DB::table('t060_analizy_ryzyka');


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

    //dd($department);


    if(isset($category_status) && $category_status > 0){
        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('tmp',$category_status_val);
        $lista_analiz_sql->where('tmp',$category_status_val);
    }
    // Koniec - Filtry

    //dd($permision_range);
    if(isset($permision_range) || Auth::user()->rola_admin == 1){
        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('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);
                }
            });

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

            $lista_analiz_tmp_sql->where(function($query) {
                $dzialy_pracownika = my_EmployeeDepartments(Auth::user()->pracownik_id);
                foreach ($dzialy_pracownika as $select) {
                    $query->orWhere('ko_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);
            $lista_analiz_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;
    //$lista_analiz = $lista_analiz_sql->get();
    $HowManyAllRecords = $HowManyAllRecords_sql->count();

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

    $lista_analiz_sql->Where('opis', 'like', '%'.$filter.'%');
    //$analiza_list = $lista_analiz_sql->paginate(15,['*'],'page',$page);
    $lista_analiz = $lista_analiz_sql->orderBy('id', 'DESC')->get();

    $lista_analiz_tmp = $lista_analiz_tmp_sql->where('tmp',1)->count();

    //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">
                <!-- /* START - Widoczne na wszystkich zakładkach */ -->
                <div class="row">
                    <div class="col-10">
                        <h5>
                            <i>Analizy Ryzyka -
                                {{ $lista_procesow_opis ?? '' }}
                            </i>
                        </h5>
                    </div>
                    <div class="col-2 text-right noprint">
                        @include('components.table-export-buttons', [
                            'routeName' => 'm_odo_view_export',
                            'routeParams' => ['source' => 'analiza_ryzyka_index']
                        ])
                    </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_analiza_ryzyka_index_filter', 1) }}" data-toggle="tooltip" title="Proces ciągły" style="margin-right: 3px;">
                                    <i class="fas fa-lg fa-circle-notch"></i>
                                </a></span>
                                <span class="my_FilterStatus {{ $active2 ?? '' }}"><a class="btn btn-warning btn_table_status" href="{{ url('/m_odo_analiza_ryzyka_index_filter', 2) }}" data-toggle="tooltip" title="Proces cykliczny" style="margin-right: 3px;">
                                    <i class="fas fa-lg fa-clock"></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-secondary btn_table_status" href="{{ url('/m_odo_analiza_ryzyka_index_filter_status', 1) }}" data-toggle="tooltip" title="Aktywny" style="margin-right: 3px;">
                                    <i class="fas fa-recycle fa-lg"></i>
                                </a></span>
                                <span class="my_FilterStatus {{ $active_status2 ?? '' }}"><a class="btn btn-success btn_table_status" href="{{ url('/m_odo_analiza_ryzyka_index_filter_status', 2) }}" data-toggle="tooltip" title="Nieaktywny" style="margin-right: 3px;">
                                    <i class="fas fa-save 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_analiza_ryzyka_index_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;">
                        <!--/* START - Wyszukiwarka działy */-->
                        <form action="{{ route('m_odo_analiza_ryzyka_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: 5.5vw;" onchange="this.form.submit()">
                                        <option value="">- wszystkie -</option>
                                        @foreach($komorki_organizacyjne as $ko)
                                            <option value="{{$ko->id}}" {{ ( $ko->id == $department) ? 'selected' : '' }}>{{$ko->nazwa_skrot}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </form>
                        <!--/* KONIEC - Wyszukiwarka działy */-->
                    </div>

                    <div style="flex-basis: content;">
                        <form action="{{ route('m_odo_analiza_ryzyka_index_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 Analiz --}}
                        <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 scope="col" class="text-center min-width">Lp</th>
                                        <th scope="col" class="text-center min-width">ID</th>
                                        <th scope="col" class="text-left">Opis Analizy</th>
                                        <th scope="col" class="text-center">Data Rozpoczęcia</th>
                                        <th scope="col" class="text-center">Data Zatwierdzenia Analizy</th>
                                        <th scope="col" class="text-center align-middle min-width">Właściciel<br>Analizy</th>
                                        <th scope="col" class="text-center align-middle min-width text-nowrap">Ilość Procesów<br>do Analizy</th>
                                        <th scope="col" class="text-center align-middle min-width text-nowrap">Stan wykonania Analizy</th>
                                        <th scope="col" class="text-center align-middle min-width">Status</th>
                                        <th class="separate-column"></th>
                                        <th scope="col" class="text-center table_action">
                                            @php
                                                // ($permision_functions_for_range,$function,$adress,$owner_tab,$onclick = null,$target = null)
                                                if($lista_analiz_tmp < 1){
                                                    //$button_extend = my_TableButton($permision_functions_for_range,"add","/m_odo_analiza_ryzyka_form_add",$owner_tab);
                                                    //echo $button_extend;

                                                    // ($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_add')",null,null,null,'new-table-add');
                                                    echo $button_add;
                                                }
                                            @endphp
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>

                                @if(isset($lista_analiz) && $lista_analiz->count() > 0)
                                    @foreach($lista_analiz as $analiza)
                                    @php
                                        // Sprawdzenie właściciela rekordu
                                        $owner_tab = my_OwnerRecord($analiza->ko_id,$analiza->user_id);
                                        $active_row = my_GetActiveRecord($analiza->id);

                                    @endphp

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

                                            <td class="text-center">{{ $analiza->id }}</td>
                                            <td>{{ $analiza->opis }}</td>
                                            <td class="text-center">{{ $analiza->created_at }}</td>
                                            <td class="text-center">{{ $analiza->data_zatwierdzono }}</td>
                                            <td nowrap class="text-center">
                                                @if (my_DepartmentName($analiza->ko_id,0))
                                                    {{ my_DepartmentName($analiza->ko_id,0) }}
                                                @endif

                                            </td>

                                            <!-- /* ilość procesów w analizie  */ -->
                                            @php
                                                $analiza_ilosc_przypisanych_procesow = DB::table('t061_ar_procesy')->where('id_analiza',$analiza->id)->count();
                                            @endphp
                                            <td nowrap class="text-center">
                                                @if($analiza_ilosc_przypisanych_procesow > 0)
                                                    <div class="btn btn-success btn_table_status" style="width: -webkit-fill-available" data-toggle="tooltip" title="Przypisano procesy">
                                                        {{$analiza_ilosc_przypisanych_procesow}}
                                                    </div>
                                                @else
                                                    <div class="btn btn-secondary btn_table_status" style="width: -webkit-fill-available" data-toggle="tooltip" title="Brak przypisanych procesów">
                                                        {{$analiza_ilosc_przypisanych_procesow}}
                                                    </div>
                                                @endif
                                            </td>
                                            {{-- KONIEC - ilość procesów w analizie  --}}

                                            <td class="text-center align-middle">
                                                @if($analiza_ilosc_przypisanych_procesow > 0)
                                                    <div class="progress my_progres_bar">
                                                        @php
                                                            $stany = my_ProcesBar_Analiza_Proces_Counter($analiza->id);
                                                            $stan_wykonania = $stany[1];
                                                            $stan_wymagany = $stany[0];
                                                            echo my_ProcesBar_Analiza($stan_wykonania,$stan_wymagany);
                                                        @endphp
                                                    </div>
                                                @else
                                                    ---
                                                @endif
                                            </td>

                                            {{-- Status  --}}
                                            <td nowrap class="text-center">
                                                @if($analiza->tmp == 1)
                                                    <div class="btn btn_table_status" data-toggle="tooltip" title="Analiza Robocza">
                                                        <i class="fas fa-recycle fa-lg text-secondary"></i>
                                                    </div>
                                                @else
                                                    <div class="btn btn_table_status" data-toggle="tooltip" title="Zapisana">
                                                        <i class="fas fa-save fa-lg text-success"></i>
                                                    </div>
                                                @endif
                                            </td>
                                            {{-- KONIEC - Status --}}

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

                                            <!-- /* Akcja */ -->
                                            <td class="table_action text-center">
                                                @php

                                                    // Przycisk kopiowania wyników analizy dla procesu
                                                    if(1 >= 0 && my_Localhost()){ //if($stan_wykonania >= $stan_wymagany){
                                                            $button_custom_array = array('btn-outline-success','far fa-copy fa-lg','Kopiuj wynik analizy do innego procesu');
                                                            $button_custom = my_TableButton($permision_functions_for_range,$button_custom_array,"/m_odo_analiza_ryzyka_aktywa_info/$analiza->id",$owner_tab,null,null,null,"m_odo_analiza_ryzyka_info/$analiza->id",'new');
                                                            echo $button_custom;
                                                        }

                                                    //$button_custom_array = array('klasa koloru','ikona buttonu','title');
                                                    //my_TableButton($permision_functions_for_range,$function,$adress,$owner_tab,$onclick = null,$target = null,$value = null,$return_to = null)
                                                    // $button_custom_array = array('btn-success','fas fa-layer-group','Analiza Procesy');
                                                    // $button_custom = my_TableButton($permision_functions_for_range,$button_custom_array,"/m_odo_analiza_ryzyka_procesy/$analiza->id",$owner_tab,null,null,null,'m_odo_analiza_ryzyka_index');
                                                    // echo $button_custom;

                                                    $button_info = my_TableButton($permision_functions_for_range,"details","/m_odo_analiza_ryzyka_info/$analiza->id",$owner_tab,"my_SetActiveRecord($analiza->id)",null,null,null,'new');
                                                    echo $button_info;

                                                    //$button_edit = my_TableButton($permision_functions_for_range,"edit",null,$owner_tab,"openModalForm('ModalForm_edit')");
                                                    //echo $button_edit;
                                                    if($analiza->tmp == 1){
                                                        $button_status = my_TableButton($permision_functions_for_range,"edit",null,$owner_tab,"my_SetActiveRecord($analiza->id)",null,$analiza->id,null,'new');
                                                        echo $button_status;
                                                    }

                                                @endphp
                                            </td>
                                        </tr>
                                    @endforeach
                                @else
                                    <tr class="tr_no_records">
                                        <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>
                        {{-- KONIEC - Lista Analiz --}}
                    </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">{!! $analiza_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;
    }

</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">
        Analizy Ryzyka - Lista
    </span>

@endsection

{{-- Menu section --}}
@section('menu')
    @include('sites.odo.menu_odo')
@endsection

{{-- ModalWindowssection --}}
@section('modal_windows')
    @php
        $edit_modal_return_to = "m_odo_analiza_ryzyka_index";
    @endphp
    @include('sites.odo.analiza_ryzyka.form_modal_analiza_add')
    @include('sites.odo.analiza_ryzyka.form_modal_analiza_edit')
    {{-- @include('sites.odo.analiza_ryzyka.form_modal_edit') --}}
@endsection