@extends('layouts/contentLayoutMaster')

@section('title', __('locale.Refunds Paid 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.Client Name') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Holder name') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Beneficiary') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Request Date') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Value requested') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Protocol number') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Date of Protocol') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Value Received') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Date received') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Difference') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Status') }}</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,
                                valorSolicitado: '100,00',
                                valorRecebido: '50,00',
                                diferenca: '50,00',
                                status: 'Ativo',
                                dataRecebimento: '15/07/2024',
                                month_name: monthName 
                            };
                            transformedData.push(newRow);
                        });
                    } else {
                        let newRow = {
                            ...row,
                            valorSolicitado: '100,00',
                            valorRecebido: '50,00',
                            diferenca: '50,00',
                            status: 'Ativo',
                            dataRecebimento: '15/07/2024',
                            month_name: monthName 
                        };
                        transformedData.push(newRow);
                    }
                });

                return transformedData;
            }

            if (dtUserTable.length) {
                dtUserTable = dtUserTable.DataTable({
                    ajax: {
                        url: "{{ route('api.refunds-paid-reports.index') }}",
                         dataSrc: function(json) {
                            return transformData(json);
                        },
                        beforeSend: function(request) {
                            request.setRequestHeader("Authorization",
                                "Bearer {{ session('Authorization') }}")
                        }
                    },
                    columns: [
                        {
                            data: 'company.name'
                        },
                        {
                            data: 'holder_name'
                        },
                        {
                            data: 'holder_name'
                        },
                        {
                            data: 'created_at'
                        },
                        {
                            data: 'valorSolicitado'
                        },
                        {
                            data: 'protocol_number'
                        },
                        {
                            data: 'created_at'
                        },
                        {
                            data: 'valorRecebido'
                        },
                        {
                            data: 'dataRecebimento'
                        },
                        {
                            data: 'diferenca'
                        },
                        {
                            data: 'status'
                        },
                        
                    ],
                    columnDefs: [
                        {
                            targets: [3,6],
                            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;
                       
                                
                            }
                        },


                    ],
                    
                    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"<"company d-inline-flex mt-50"><"holder d-inline-flex mt-50"><"beneficiary d-inline-flex mt-50"><"status 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: 'Reembolsos Pagos',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
                                    }
                                },
                                {
                                    extend: 'pdf',
                                    text: feather.icons['clipboard'].toSvg({
                                        class: 'font-small-4 me-50'
                                    }) + 'Pdf',
                                    className: 'dropdown-item',
                                    filename: 'Reembolsos Pagos',
                                    orientation: 'landscape',
                                    pageSize: 'A4',
                                    title: 'Reembolsos Pagos',
                                    exportOptions: {
                                        columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
                                    }
                                },
                            ],
                            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=""> Empresa </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(1)
                        .every(function() {
                            var column = this;
                            
                            var select = $(
                                    `<select id="FilterTransaction" class="form-select mb-md-0 mb-2xx"><option value=""> Titular </option></select>`
                                )
                                .appendTo('.holder')
                                .on('change', function() {
                                    var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                    column.search(val ? '^' + val + '$' : '', true, false).draw();
                                });

                            var holders = [];

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


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

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

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

                            var beneficiaries = [];

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


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

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

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

                            var status = [];

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


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

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

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

@endsection