@extends('layouts/contentLayoutMaster')

@section('title', __('locale.Pending and Critical Reports'))

@section('vendor-style')
    {{-- Page Css files --}}
    <link rel="stylesheet" href="{{ asset(mix('vendors/css/forms/select/select2.min.css')) }}">
    <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/dataTables.bootstrap5.min.css')) }}">
    <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/responsive.bootstrap5.min.css')) }}">
    <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/buttons.bootstrap5.min.css')) }}">
    <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/rowGroup.bootstrap5.min.css')) }}">
@endsection

@section('page-style')
    {{-- Page Css files --}}
    <link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/form-validation.css')) }}">
@endsection

@section('content')
    <!-- users list start -->
    <section class="companies-list">
        <!-- list and filter start -->
        <div class="card">
            <div class="card-body border-bottom">
                <h4 class="card-title">{{ __('locale.Report') }}</h4>
                {{-- <div class="row">
                    <div class="col-md-4 grup"></div>
                    <div class="col-md-4 company"></div>
                </div> --}}
            </div>
            <div class="card-datatable table-responsive pt-0">
                <table class="user-list-table table">
                    <thead class="table-light">
                        <tr>
                            <th>{{ __('locale.Table.Reports.Column.Groups') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Company') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Beneficiary') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Date of Incident') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Incident') }}</th>
                        </tr>
                    </thead>
                </table>
            </div>
            <!-- list and filter end -->
    </section>
    <!-- users list ends -->
@endsection

@section('vendor-script')
    {{-- Vendor js files --}}
    <script src="{{ asset(mix('vendors/js/forms/select/select2.full.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/jquery.dataTables.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.bootstrap5.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.responsive.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/responsive.bootstrap5.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/datatables.buttons.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/jszip.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/pdfmake.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/vfs_fonts.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/buttons.html5.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/buttons.print.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.rowGroup.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/forms/validation/jquery.validate.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/forms/cleave/cleave.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/forms/cleave/addons/cleave-phone.us.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/extensions/moment.min.js')) }}"></script>
    <script src="{{ asset(mix('vendors/js/extensions/sweetalert2.all.min.js')) }}"></script>
@endsection

@section('page-script')

    <script>

        var dtUserTable;

        $(function() {

            'use strict';

            dtUserTable = $('.user-list-table');

            let select = $('.select2');

            select.each(function() {
                var $this = $(this);
                $this.wrap('<div class="position-relative"></div>');
                $this.select2({
                    dropdownAutoWidth: true,
                    width: '100%',
                    dropdownParent: $this.parent()
                });
            });

            function transformData(data) {
                const monthNames = [
                    'Janeiro', 'Fevereiro', 'Março', 'Abril', 'Maio', 'Junho',
                    'Julho', 'Agosto', 'Setembro', 'Outubro', 'Novembro', 'Dezembro'
                ];

                let transformedData = [];

                data.forEach(row => {
                    
                    let monthName = '';
                    if (row.created_at) {
                        const date = new Date(row.created_at);
                        const month = date.getMonth();
                        monthName = monthNames[month];
                    }

                    if (row.holders && row.holders.length > 0) {
                        row.holders.forEach(holder => {
                            let newRow = { 
                                ...row, 
                                holder_name: holder.name,
                                holder_registration: holder.registration,
                                holder_cpf: holder.cpf,
                                holder_id: holder.id,
                                Observations: 'teste',
                                month_name: monthName
                            };
                            transformedData.push(newRow);
                        });
                    } else {
                        let newRow = {
                            ...row,
                            Observations: 'teste',
                            month_name: monthName
                        };
                        transformedData.push(newRow);
                    }
                });

                return transformedData;
            }

            if (dtUserTable.length) {
                dtUserTable = dtUserTable.DataTable({
                    ajax: {
                        url: "{{ route('api.pending-critical-reports.index') }}",
                        dataSrc: function(json) {
                            return transformData(json);
                        },
                        beforeSend: function(request) {
                            request.setRequestHeader("Authorization",
                                "Bearer {{ session('Authorization') }}")
                        }
                    },
                    columns: [
                        {
                            data: 'company.group.name'
                        },
                        {
                            data: 'company.name'
                        },
                        {
                            data: 'holder_name'
                        },
                        {
                            data: 'created_at'
                        },
                        {
                            data: 'Observations'
                        },
                        
                    ],
                    columnDefs: [
                        {
                            targets: 3,
                            render(data, type, full, meta) {
                                
                               
                                if (type === 'display') {
                                    var date = new Date(data);
                                    var day = String(date.getDate()).padStart(2, '0');
                                    var month = String(date.getMonth() + 1).padStart(2, '0');
                                    var year = date.getFullYear();
                                    return day + '/' + month + '/' + year;
                                }
                                return data;
                       
                                
                            }
                        },
                    ],
                    
                    order: [
                        [0, 'desc']
                    ],
                    pageLength: 50,
                    dom: '<"d-flex justify-content-between align-items-center header-actions mx-2 row mt-75"' +
                        '<"col-sm-12 col-lg-4 d-flex justify-content-center justify-content-lg-start" l>' +
                        '<"col-sm-12 col-lg-8 ps-xl-75 ps-0"<"dt-action-buttons d-flex align-items-center justify-content-center justify-content-lg-between flex-lg-nowrap flex-wrap"<"group d-inline-flex mt-50"><"company d-inline-flex mt-50"><"incident d-inline-flex mt-50">B>>' +
                        '>t' +
                        '<"d-flex justify-content-between mx-2 row mb-1"' +
                        '<"col-sm-12 col-md-6"i>' +
                        '<"col-sm-12 col-md-6"p>' +
                        '>',
                    language: {
                        sLengthMenu: "{{ __('locale.Listing') }} _MENU_",
                        search: "{{ __('locale.Search') }}",
                        searchPlaceholder: "{{ __('locale.Search') }}..",
                        paginate: {
                            previous: '&nbsp;',
                            next: '&nbsp;'
                        },
                        info: "{{ __('locale.ListingInfo') }}",
                        infoEmpty: "{{ __('locale.ListingEmpty') }}",
                        zeroRecords: "{{ __('locale.ZeroRecords') }}"

                    },
                    buttons: [
                        {
                            extend: 'collection',
                            className: 'btn btn-outline-secondary dropdown-toggle me-2',
                            text: feather.icons['external-link'].toSvg({
                                class: 'font-small-4 me-50'
                            }),
                            buttons: [
                                {
                                    extend: 'csv',
                                    text: feather.icons['file-text'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Csv',
                                    className: 'dropdown-item',
                                    filename: 'Pendências e Críticas',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4]
                                    }
                                },
                                {
                                    extend: 'pdf',
                                    text: feather.icons['clipboard'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Pdf',
                                    className: 'dropdown-item',
                                    filename: 'Pendências e Críticas',
                                    pageSize: 'A4',
                                    title: 'Pendências e Críticas',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4]
                                    }
                                },
                            ],
                            init: function(api, node, config) {
                                $(node).removeClass('btn-secondary');
                                $(node).parent().removeClass('btn-group');
                                setTimeout(function() {
                                    $(node).closest('.dt-buttons').removeClass('btn-group')
                                        .addClass('d-inline-flex mt-50');
                                }, 50);
                            }
                        }
                    ],
                    // responsive: {
                    //     details: {
                    //         display: $.fn.dataTable.Responsive.display.modal({
                    //             header: function(row) {
                    //                 var data = row.data();
                    //                 return 'Details of ' + data['full_name'];
                    //             }
                    //         }),
                    //     }
                    // },
                    responsive: false,
                    scrollX: true,
                    scrollCollapse: true,
                    initComplete: function() {

                        window.tableList = this.api();

                        this.api()
                        .columns(0)
                        .every(function() {
                            var column = this;
                            
                            var select = $(
                                    `<select id="FilterTransaction" class="form-select mb-md-0 mb-2xx"><option value=""> Grupos </option></select>`
                                )
                                .appendTo('.group')
                                .on('change', function() {
                                    var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                    column.search(val ? '^' + val + '$' : '', true, false).draw();
                                });

                            var groups = [];

                            column
                                .data()
                                .unique()
                                .sort()
                                .each(function(d, j) {
                                    if (d) {
                                        console.log(d)
                                        groups.push(d);
                                    }
                                });


                            if (groups.length > 0) {
                                groups = [...new Set(groups)];

                                groups.forEach(function(group) {
                                    select.append(
                                        '<option value="' +
                                        group +
                                        '" class="text-capitalize">' +
                                        group + 
                                        '</option>'
                                    );
                                });
                            }
                        });

                        this.api()
                        .columns(1)
                        .every(function() {
                            var column = this;
                            
                            var select = $(
                                    `<select id="FilterTransaction" class="form-select mb-md-0 mb-2xx"><option value=""> Empresas </option></select>`
                                )
                                .appendTo('.company')
                                .on('change', function() {
                                    var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                    column.search(val ? '^' + val + '$' : '', true, false).draw();
                                });

                            var companies = [];

                            column
                                .data()
                                .unique()
                                .sort()
                                .each(function(d, j) {
                                    if (d) {
                                        companies.push(d);
                                    }
                                });


                            if (companies.length > 0) {
                                companies = [...new Set(companies)];

                                companies.forEach(function(company) {
                                    select.append(
                                        '<option value="' +
                                        company +
                                        '" class="text-capitalize">' +
                                        company + 
                                        '</option>'
                                    );
                                });
                            }
                        });

                        this.api()
                        .columns(4)
                        .every(function() {
                            var column = this;
                            
                            var select = $(
                                    `<select id="FilterTransaction" class="form-select mb-md-0 mb-2xx"><option value=""> Incidente </option></select>`
                                )
                                .appendTo('.incident')
                                .on('change', function() {
                                    var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                    column.search(val ? '^' + val + '$' : '', true, false).draw();
                                });

                            var incidents = [];

                            column
                                .data()
                                .unique()
                                .sort()
                                .each(function(d, j) {
                                    if (d) {
                                        incidents.push(d);
                                    }
                                });


                            if (incidents.length > 0) {
                                incidents = [...new Set(incidents)];

                                incidents.forEach(function(incident) {
                                    select.append(
                                        '<option value="' +
                                        incident +
                                        '" class="text-capitalize">' +
                                        incident + 
                                        '</option>'
                                    );
                                });
                            }
                        });

                    }
                });
            }
        });
    </script>

@endsection