@extends('layouts/contentLayoutMaster')

@section('title', __('locale.Upgrade 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 company_type"></div>
                    <div class="col-md-4 company_country"></div>
                    <div class="col-md-4 company_status"></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.Request Date') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Execution Date') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Previous Product') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Previous Current') }}</th>
                            <th style="display: none;">mes</th>
                            {{-- <th>{{ __('locale.Table.Reports.Column.Status') }}</th>
                            <th>{{ __('locale.Table.Company.Column.Actions') }}</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>
        /**
         * @param {number} company_id
         * @return void
         */
        const deleteCompany = async (company_id) => {

            let confirmed = false;

            let swal;

            if (window.Swal !== undefined) {
                swal = await Swal.fire({
                    title: "{{ __('locale.Pages.Company.Alert.Attention') }}",
                    text: "{{ __('locale.Pages.Company.Alert.Question') }}",
                    icon: 'question',
                    showConfirmButton: true,
                    showCancelButton: true,
                    confirmButtonText: "{{ __('locale.Pages.Company.Button.Confirm') }}",
                    cancelButtonText: "{{ __('locale.Pages.Company.Button.Cancel') }}"
                });

                if (swal.isConfirmed) confirmed = true;

            } else {
                confirmed = window.confirm("{{ __('locale.Pages.Company.Alert.Question') }}");
            }

            if (confirmed) {

                let {
                    data: json,
                    ...response
                } = await axios({
                    method: 'delete',
                    url: `{{ route('api.companies.delete', '') }}/${company_id}`,
                    headers: {
                        "Authorization": "Bearer {{ session('Authorization') }}"
                    }
                }).catch((e) => {

                    let response = e.response;

                    @if (env('APP_DEBUG'))
                        console.warn(e)
                    @endif

                    if (response.status === 400 || response.status === 422) {
                        Swal.fire({
                            title: 'Ops!',
                            text: response.data.message,
                            icon: 'error',
                            cancelButtonText: "{{ __('locale.Pages.Company.Botton.ToClose') }}"
                        })
                    } else if (response.status === 404) {
                        Swal.fire({
                            title: 'Ops!',
                            text: "{{ __('locale.Pages.Company.Alert.Required') }}",
                            icon: 'error',
                            cancelButtonText: "{{ __('locale.Pages.Company.Botton.ToClose') }}"
                        })
                    } else {

                        Swal.fire({
                            title: 'Ops!',
                            text: "{{ __('locale.Pages.Company.Alert.Erro') }}",
                            icon: 'error',
                            cancelButtonText: "{{ __('locale.Pages.Company.Botton.ToClose') }}"
                        })

                    }
                });

                if (response.status === 204) {
                    swal = await window.Swal.fire({
                        title: 'Uhuul!',
                        text: "{{ __('locale.Pages.Company.Alert.Excluded') }}",
                        icon: 'success'
                    });

                    if (swal.isConfirmed) {
                        dtUserTable.ajax.reload()
                    }

                }

            }


        }

        var dtUserTable;

        $(function() {

            'use strict';

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

            let select = $('.select2');


            let statusObj = {
                1: {
                    title: "{{ __('locale.Active') }}",
                    class: 'badge-light-success '
                },
                0: {
                    title: "{{ __('locale.Inactive') }}",
                    class: 'badge-light-secondary'
                }
            };

            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 => {
                    // Extraí o mês do campo `created_at` e converta para o nome do mês
                    let monthName = '';
                    if (row.created_at) {
                        const date = new Date(row.created_at);
                        const month = date.getMonth(); // Mês baseado em zero (0 para Janeiro, 1 para Fevereiro, etc.)
                        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 // Adiciona o nome do mês
                            };
                            transformedData.push(newRow);
                        });
                    } else {
                        let newRow = {
                            ...row,
                            Observations: 'teste',
                            month_name: monthName // Adiciona o nome do mês
                        };
                        transformedData.push(newRow);
                    }
                });

                return transformedData;
            }

            if (dtUserTable.length) {
                dtUserTable = dtUserTable.DataTable({
                    ajax: {
                        url: "{{ route('api.upgrade-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: 'created_at'
                        },
                        {
                            data: 'product.name'
                        },
                        {
                            data: 'product.name'
                        },
                        {
                            data: 'month_name'
                        },
                        
                    ],
                    columnDefs: [
                        {
                            targets: [3, 4],
                            render(data, type, full, meta) {
                                
                                console.log(full);
                                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;
                       
                                
                            }
                        },

                        {
                            targets: 7,
                            visible: false,
                            render(data, type, full, meta) {
                                
                                
                                return full.month_name;
                       
                                
                            }
                        },


                    ],
                    
                    order: [
                        [0, 'desc']
                    ],
                    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"><"client d-inline-flex mt-50"><"period d-inline-flex mt-50">>>' +
                        '>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: 'print',
                                    text: feather.icons['printer'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Print',
                                    className: 'dropdown-item',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4, 5, 6, 7]
                                    }
                                },
                                {
                                    extend: 'csv',
                                    text: feather.icons['file-text'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Csv',
                                    className: 'dropdown-item',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4, 5, 6, 7]
                                    }
                                },
                                {
                                    extend: 'excel',
                                    text: feather.icons['file'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Excel',
                                    className: 'dropdown-item',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4, 5, 6, 7]
                                    }
                                },
                                {
                                    extend: 'pdf',
                                    text: feather.icons['clipboard'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Pdf',
                                    className: 'dropdown-item',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4, 5, 6, 7]
                                    }
                                },
                                {
                                    extend: 'copy',
                                    text: feather.icons['copy'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Copy',
                                    className: 'dropdown-item',
                                    exportOptions: {
                                        columns: [1, 2, 3, 4, 5]
                                    }
                                }
                            ],
                            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) {
                                        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=""> Clientes </option></select>`
                                )
                                .appendTo('.client')
                                .on('change', function() {
                                    var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                    column.search(val ? '^' + val + '$' : '', true, false).draw();
                                });

                            var periods = [];

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


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

                                periods.forEach(function(period) {
                                    select.append(
                                        '<option value="' +
                                        period +
                                        '" class="text-capitalize">' +
                                        period + 
                                        '</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=""> Período </option></select>`
                        //         )
                        //         .appendTo('.client')
                        //         .on('change', function() {
                        //             var val = $.fn.dataTable.util.escapeRegex($(this).val());
                        //             column.search(val ? '^' + val + '$' : '', true, false).draw();
                        //         });

                        //     var clients = [];

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


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

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

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

                            var movements = [];

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


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

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

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

@endsection