@extends('layouts/contentLayoutMaster')

@section('title', __('locale.Customer report by location'))

@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.State') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.City') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Client Name') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Customer segment') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Product type') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Contracted product') }}</th>
                            <th>{{ __('locale.Table.Reports.Column.Total Clients') }}</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 transformDataWithCompanies(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.contract_company && row.contract_company.length > 0) {
                        row.contract_company.forEach(company => {

                            if (row.contract_products && row.contract_products.length > 0) {
                                row.contract_products.forEach(product => {
                                    let newRow = {
                                        ...row,
                                        company_name: company.company || '',
                                        activity_branch: company.activity_branch || '',
                                        cnpj: company.cnpj || '',
                                        product_name: product.product ? product.product.name : '',
                                        valorContrato: '2000,00',
                                        valorFaturado: '1000,00',
                                        pecentual: '10%',
                                        valorCorretagem: '1000,00',
                                        valorFee: '500,00',
                                        valorImposto: '200,00',
                                        copay: 'sim',
                                        month_name: monthName 
                                    };
                                    transformedData.push(newRow);
                                });
                            } else {

                                let newRow = {
                                    ...row,
                                    company_name: company.company || '',
                                    activity_branch: company.activity_branch || '',
                                    cnpj: company.cnpj || '',
                                    valorContrato: '2000,00', 
                                    valorFaturado: '1000,00',
                                    pecentual: '10%',
                                    valorCorretagem: '1000,00',
                                    valorFee: '500,00',
                                    valorImposto: '200,00',
                                    copay: 'sim',
                                    month_name: monthName 
                                };
                                transformedData.push(newRow);
                            }
                        });
                    } else {

                        if (row.contract_products && row.contract_products.length > 0) {
                            row.contract_products.forEach(product => {
                                let newRow = {
                                    ...row,
                                    product_name: product.product ? product.product.name : '', 
                                    valorContrato: '2000,00',
                                    valorFaturado: '1000,00',
                                    pecentual: '10%',
                                    valorCorretagem: '1000,00',
                                    valorFee: '500,00',
                                    valorImposto: '200,00',
                                    copay: 'sim',
                                    month_name: monthName 
                                };
                                transformedData.push(newRow);
                            });
                        } else {
                            
                            let newRow = {
                                ...row,
                                valorContrato: '2000,00', 
                                valorFaturado: '1000,00',
                                pecentual: '10%',
                                valorCorretagem: '1000,00',
                                valorFee: '500,00',
                                valorImposto: '200,00',
                                copay: 'sim',
                                month_name: monthName 
                            };
                            transformedData.push(newRow);
                        }
                    }
                });

                return transformedData;
            }

            if (dtUserTable.length) {
                dtUserTable = dtUserTable.DataTable({
                    ajax: {
                        url: "{{ route('api.customer-location-reports.index') }}",
                        dataSrc: function(json) {
                            return transformDataWithCompanies(json);
                        },
                        beforeSend: function(request) {
                            request.setRequestHeader("Authorization",
                                "Bearer {{ session('Authorization') }}")
                        }
                    },
                    columns: [
                        {
                            data: 'company_name.address.state'
                        },
                        {
                            data: 'company_name.address.city'
                        },
                        {
                            data: 'company_name.name'
                        },
                        {
                            data: 'company_name.activity_branch'
                        },
                        {
                            data: 'product_type.name'
                        },
                        {
                            data: 'product_name'
                        },
                        {
                            data: 'total_holders'
                        },
                        
                    ],
                    columnDefs: [
                        

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

                            var products = [];

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


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

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

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

                            var state = [];

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


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

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

                            var city = [];

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


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

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

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

@endsection