function sweetAlertSimple(icon, title, text) {
    toastr.remove();
    switch (icon) {
        case 'success':
            toastr.success(text);
            break;
        case 'info':
            toastr.info(text);
            break;
        case 'warning':
            toastr.warning(text);
            break;
        case 'error':
            toastr.error(text);
            break;
    }
}

function initSummaryTable() {
    var columns = [{
            data: '1',
            title: ''
        },
        {
            data: '2',
            title: ''
        }
    ];

    var table = $('#summaryTable').DataTable({
        initComplete: function() {
            // $('#summaryTable_wrapper .buttons-csv').click() 
        },
        columns: columns,
        "paging": false,
        "lengthChange": false,
        "searching": false,
        "ordering": false,
        // "destroy": true,
        "info": false,
        "autoWidth": false,
        "responsive": true,
        "lengthMenu": [
            [5, 50, 100, -1],
            [5, 50, 100, "All"]
        ],
        "buttons": [{
                extend: 'csv',
                text: 'CSV',
                filename: function() {
                    var filename = $('input[type=file]').val().replace(/.*(\/|\\)/, '');
                    return filename + '_summary';
                }
            },
            {
                extend: 'excel',
                text: 'Excel',
                filename: function() {
                    var filename = $('input[type=file]').val().replace(/.*(\/|\\)/, '');
                    return filename + '_summary';
                }
            },
            {
                extend: 'pdf',
                text: 'PDF',
                filename: function() {
                    var filename = $('input[type=file]').val().replace(/.*(\/|\\)/, '');
                    return filename + '_summary';
                }
            },
            "print",

        ]
    }).buttons().container().appendTo('#summaryTable_wrapper .col-md-6:eq(0)');
}

Dropzone.autoDiscover = false;
var search_type_filter = "Variant";

$(function() {
    var search_types = ["Variant", "Brand"]; 
    $.each(search_types, function(i, n) {
        $('.checker').append(`<li class="dropdown-item cursor-pointer py-0"><span class="text-sm">` + n + `</span></li>`);
    }); 

    $('.checker li').each(function() { 
        $(this).on('click', function() { 
            search_type_filter = $(this).text(); 
            $('#button-filter').text(search_type_filter); 
        }); 
    }); 

    $('#check-button').on('click', function(){ 
        var check_item = $('#check-search').val(); 

        $.ajax({ 
            type: 'POST',
            url: 'app/loader/finance_import.php',
            dataType: 'json',
            data: {
                item: check_item, 
                search: search_type_filter
            }, 
            beforeSend: function() {
                $('#alert-div').attr('hidden', false); 
                $('#alert-icon').removeClass('fa-check'); 
                $('#alert-icon').removeClass('fa-info'); 
                $('#alert-icon').removeClass('fa-ban'); 
                $('#alert-alert').removeClass('alert-success'); 
                $('#alert-alert').removeClass('alert-danger'); 
                $('#alert-alert').removeClass('alert-info'); 

                $('#check-message').text("Checking.."); 

                $('#loading-view').attr('hidden', false); 
                $('#alert-icon').attr('hidden', true); 
                $('#alert-alert').addClass('alert-info');
            }, 
            success: function(result) { // alert(result.count); 
                if(result.count == 0){
                    $('#alert-alert').removeClass('alert-info'); 

                    $('#loading-view').attr('hidden', true); 
                    $('#alert-icon').attr('hidden', false); 
                    $('#alert-icon').addClass('fa-ban'); 
                    $('#alert-alert').addClass('alert-danger'); 
                    $('#check-message').text("Not found"); 
                } 
                else {
                    $('#alert-alert').removeClass('alert-info'); 

                    $('#loading-view').attr('hidden', true); 
                    $('#alert-icon').attr('hidden', false); 
                    $('#alert-icon').addClass('fa-check'); 
                    $('#alert-alert').addClass('alert-success'); 
                    $('#check-message').text("In list"); 
                }
            }
        }); 
    }); 

    $('#modal-check').on('hidden.bs.modal', function (e) {
        $('#alert-div').attr('hidden', false); 
        $('#alert-icon').removeClass('fa-check'); 
        $('#alert-icon').removeClass('fa-info'); 
        $('#alert-icon').removeClass('fa-ban'); 
        $('#alert-alert').removeClass('alert-success'); 
        $('#alert-alert').removeClass('alert-danger'); 
        $('#alert-alert').removeClass('alert-info'); 

        $('#check-message').text(""); 

        $('#alert-div').attr('hidden', true); 
    }); 
    
    $("#upload-finance-excel").dropzone({
        url: "api/upload/upload_finance_spreadsheet.php", // If not using a form element
        acceptedFiles: '.csv, .xlsx, .xls', //allowed filetypes
        maxFilesize: 50,
        maxFiles: 1,
        clickable: true,
        addRemoveLinks: true,
        timeout: 0,
        autoProcessQueue: false,
        dictCancelUpload: '',
        removedfile: function(file) {
            // alert(file.upload.filename)
            $.ajax({
                type: 'POST',
                url: 'api/upload/upload_finance_spreadsheet.php',
                dataType: 'json',
                data: {
                    name: file.name,
                    request: 'delete'
                },
                sucess: function(data) {
                    console.log('success: ' + data);
                }
            });

            var _ref;
            return (_ref = file.previewElement) != null ? _ref.parentNode
                .removeChild(file
                    .previewElement) : void 0;
        },
        renameFile: function(file) {
            return file.name;
        },
        init: function() {

            var myDropzone = this;

            // Update selector to match your button
            $("#submit").on('click', function(e) {
                if (myDropzone.getQueuedFiles().length < 1) {
                    sweetAlertSimple('error', 'Oops...', 'Upload spreadsheet file.');
                    return;
                }
                e.preventDefault();
                $('#loader').fadeIn();
                $('#submit').attr('disabled', true);
                $('#invalid-report').fadeOut();
                $('#summary-report').fadeOut();
                myDropzone.processQueue();
            });

            this.on('sending', function(file, xhr, formData) {
                // Append all form inputs to the formData Dropzone will POST
                var data = $('#upload-finance-excel').serializeArray();
                $.each(data, function(key, el) {
                    formData.append(el.name, el.value);
                });
            });

            this.on("maxfilesexceeded", function(file) {
                // this.removeAllFiles();
                // this.addFile(file);
                sweetAlertSimple('error', 'Oops...', 'Only 1 file allowed.');
                return;
            });

            this.on("error", function(file) {
                // upload_image_name.splice($.inArray(file.upload.filename,
                //     upload_image_name), 1); //remove image
                // alert("Nice");
                myDropzone.removeFile(file);

                return;
            });

            this.on("complete", function(file) {
                if (this.getUploadingFiles().length === 0 && this.getQueuedFiles()
                    .length === 0) {
                    $('#loader').fadeOut();
                    $("#submit").prop("disabled", false);
                    Dropzone.forElement('#upload-finance-excel').removeAllFiles(true)
                    // sweetAlertSimple('success', 'Oops...', 'Upload done.');
                }
            });

            this.on("success", function(file, response) {
                var obj = jQuery.parseJSON(response)

                var summary_table = $('#summaryTable').DataTable();
                summary_table.destroy();
                var issue_table = $('#example2').DataTable();
                issue_table.destroy();

                // console.log(obj); 
                if (parseInt(obj.status) === 1) { 
                    $('#summaryTable > tbody').html('');
                    // $('#summaryTable').find('tbody').append(
                    //     "  <tr> <td>Company</td>  <td class='text-center'><h5><span class='badge bg-primary' id='summary-company'></span></h5></td> </tr>   <tr> <td>Dealer</td>  <td class='text-center'><h5><span class='badge bg-primary' id='summary-dealer'></span></h5></td> </tr>   <tr>   <td>Source DMS</td>  <td class='text-center'><h5><span class='badge ' id='summary-dms'></span></h5></td>  </tr> <tr>   <td>Database Type</td>  <td class='text-center'><h5><span class='badge ' id='summary-db'></span></h5></td> </tr>"
                    // );


                    $('#summaryTable').find('tbody').append(obj.data_count_list);

                    initSummaryTable();
                    $('#summary-report').fadeIn();

                } else if (parseInt(obj.status) === 2) {
                    $('#invalid-report').fadeIn();
                    var columns = [{
                        data: 'message',
                        title: 'Message'
                    }];
                    var table = $('#example2').DataTable({
                        initComplete: function() {
                            // $('#invalid-report .buttons-csv').click()
                        },
                        // data:information,
                        data: obj.header_column_not_found_message,
                        columns: columns,
                        columnDefs: [{
                            type: 'natural-nohtml',
                            targets: 0
                        }],
                        "paging": false,
                        "lengthChange": false,
                        "searching": false,
                        // "destroy": true,
                        "ordering": false,
                        "info": false,
                        "autoWidth": false,
                        "responsive": true,
                        "lengthMenu": [
                            [5, 50, 100, -1],
                            [5, 50, 100, "All"]
                        ],
                        // "buttons": [{
                        //         extend: 'csv',
                        //         text: 'CSV',
                        //         filename: function() {
                        //             var filename = $('input[type=file]')
                        //                 .val()
                        //                 .replace(/.*(\/|\\)/, '');
                        //             return filename + '_issues';
                        //         }
                        //     },
                        //     {
                        //         extend: 'excel',
                        //         text: 'Excel',
                        //         filename: function() {
                        //             var filename = $('input[type=file]')
                        //                 .val()
                        //                 .replace(/.*(\/|\\)/, '');
                        //             return filename + '_issues';
                        //         }
                        //     },
                        //     {
                        //         extend: 'pdf',
                        //         text: 'PDF',
                        //         filename: function() {
                        //             var filename = $('input[type=file]')
                        //                 .val()
                        //                 .replace(/.*(\/|\\)/, '');
                        //             return filename + '_issues';
                        //         }
                        //     },
                        //     "print",

                        // ]
                    }).buttons().container().appendTo(
                        '#example2_wrapper .col-md-6:eq(0)');
                }
            })
        }
    });
});

$(function() {
    $("#example1").DataTable({
        "responsive": true,
        "lengthChange": false,
        "autoWidth": false,
        "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)'); 
});

function isEmpty(string) {
    var flag = false;
    if (string == '') {
        flag = true;
    } else if (string == null) {
        flag = true;
    } else {
        if (string.trim() == '') {
            flag = true;
        }
    }

    return flag;
}