$('#commission-table').DataTable().clear().destroy();

   var table_table = $('#commission-table').DataTable({
        initComplete: function () {
            this.api().columns([0]).every(function () {
                var column = this;
                var select = $('<select><option value=""></option></select>')
                    .appendTo($(column.footer()).empty())
                    .on('change', function () {
                        var val = $.fn.dataTable.util.escapeRegex(
                            $(this).val()
                        );
                        column
                            .search(val ? '^' + val + '$' : '', true, false)
                            .draw();
                    });

                column.data().unique().sort().each(function (d, j) {
                    select.append('<option value="' + d + '">' + d + '</option>');
                    $('select').selectpicker('refresh');
                });
            });
        },
        responsive: true,
        fixedHeader: {
            header: true,
            footer: true
        },
        
        serverSide: true,
        ajax: {
            url: "{{ route('salary_commission.show',$employee->id) }}",
        },

        columns: [
            {
                data: 'month_year',
                name : 'month_year'
            },
            {
                data: 'commission_title',
                name : 'commission_title'
            },
            {
                data: 'commission_amount',
                name: 'commission_amount',
                render: function (data) {
                    if ('{{config('variable.currency_format') =='suffix'}}') {
                        return data + ' {{config('variable.currency')}}';
                    }else {
                        return '{{config('variable.currency')}} ' + data;
                    }
                }
            },
            {
                data: 'action',
                name: 'action',
                orderable: false
            }
        ],


        "order": [],
        'language': {
           
            "info": '{{trans("Showing")}} _START_ - _END_ (_TOTAL_)',
            "search": '{{trans("Search")}}',
            'paginate': {
                'previous': '{{trans("Previous")}}',
                'next': '{{trans("Next")}}'
            }
        },
        'columnDefs': [
            {
                "orderable": false,
                'targets': [0, 3],
            },
        ],


        {{-- 'select': {style: 'multi', selector: 'td:first-child'}, --}}
        'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
    });
    new $.fn.dataTable.FixedHeader(table_table);


    $('#create_commission_record').click(function () {

        $('.modal-title').text('{{__('Add Commission')}}');
        $('#commission_action_button').val('{{trans('Add')}}');
        $('#commission_action').val('{{trans('Add')}}');
        $('#CommissionformModal').modal('show');
    });

    $('#commission_sample_form').on('submit', function (event) {
        event.preventDefault();
        if ($('#commission_action').val() == '{{trans('Add')}}') {

            $.ajax({
                url: "{{ route('salary_commission.store',$employee) }}",
                method: "POST",
                data: new FormData(this),
                contentType: false,
                cache: false,
                processData: false,
                dataType: "json",
                success: function (data) {
                    console.log(data);
                    var html = '';
                    if (data.errors) {
                        html = '<div class="alert alert-danger">';
                        for (var count = 0; count < data.errors.length; count++) {
                            html += '<p>' + data.errors[count] + '</p>';
                        }
                        html += '</div>';
                    }
                    if (data.success) {
                        toastr.success(data.success, "Success!");
                        
                            $('#CommissionformModal').modal('hide');
                            $('#commission-table').DataTable().ajax.reload();
                            $('#commission_sample_form')[0].reset();
                  
                    }
                    $('#commission_form_result').html(html).slideDown(300).delay(5000).slideUp(300);
                }

            });
        }

        if ($('#commission_action').val() == '{{trans('Edit')}}') {
            $.ajax({
                url: "{{ route('salary_commission.update') }}",
                method: "POST",
                data: new FormData(this),
                contentType: false,
                cache: false,
                processData: false,
                dataType: "json",
                success: function (data) {
                    var html = '';
                    if (data.errors) {
                        html = '<div class="alert alert-danger">';
                        for (var count = 0; count < data.errors.length; count++) {
                            html += '<p>' + data.errors[count] + '</p>';
                        }
                        html += '</div>';
                    }
                    if (data.error) {
                        html = '<div class="alert alert-danger">' + data.error + '</div>';
                    }

                    if (data.success) {
                        toastr.success(data.success, "Success!");
                        setTimeout(function () {
                            $('#CommissionformModal').modal('hide');
                            $('#commission-table').DataTable().ajax.reload();
                            $('#commission_sample_form')[0].reset();
                        }, 1000);

                    }
                    $('#commission_form_result').html(html).slideDown(300).delay(5000).slideUp(300);
                }
            });
        }
    });

    $(document).ready(function () {
        $("#code_id").on("change", function () {
            const selectedCodeTitle = $(this).find(":selected").data("code-title");
    
            $("#commission_title_edit").val(selectedCodeTitle || "");
        });
    
        $("#code_id").trigger("change");
    });

    $(document).on('click', '.commission_edit', function () {

        var id = $(this).attr('id');

        var target = "{{ route('salary_commission.index') }}/" + id + '/edit';


        $.ajax({
            url: target,
            dataType: "json",
            success: function (html) {

                let id = html.data.id;

                $('.month_year').val(html.data.month_year);
                $('#commission_amount_edit').val(html.data.commission_amount);
                $('#commission_title_edit').val(html.data.commission_title);
                $('#code_id').val(html.data.code_id).trigger('change');
                $('#commission_hidden_id').val(html.data.id);
                $('.modal-title').text('{{trans('Edit')}}');
                $('#commission_action_button').val('{{trans('Edit')}}');
                $('#commission_action').val('{{trans('Edit')}}');
                $('#CommissionformModal').modal('show');
            }
        })
    });


    let commission_delete_id;

    $(document).on('click', '.commission_delete', function () {
    commission_delete_id = $(this).attr('id');
        $('.confirmModal').modal('show');
        $('.modal-title').text('{{__('DELETE Record')}}');
        $('.commission-ok').text('{{trans('OK')}}');
    });


    $('.commission-close').click(function () {
        $('#commission_sample_form')[0].reset();
        $('.confirmModal').modal('hide');
        $('#commission-table').DataTable().ajax.reload();
    });

    $('.commission-ok').click(function () {
        let target = "{{ route('salary_commission.index') }}/" + commission_delete_id + '/delete';
        $.ajax({
            url: target,
            beforeSend: function () {
                $('.commission-ok').text('{{trans('Deleting...')}}');
            },
            success: function (data) {
                setTimeout(function () {
                    $('.confirmModal').modal('hide');
                    $('#commission-table').DataTable().ajax.reload();
                }, 2000);
            }
        })
    });