@extends('admin.layout')
@section('main')
    <div class="content-header row">
    </div>
    <div class="content-wrapper">
        <div class="content-header row">
        </div>
        <div class="content-body">
            <!-- Dashboard Ecommerce Starts -->
            <section id="dashboard-ecommerce">
                <div class="row match-height justify-content-end mb-1">
                    <div class="col-lg-12 mr-auto">
                        <h2>Clean Doctors<a href="" class="ml-1" data-toggle="tooltip" data-placement="right" title="Clean doctors database (email & mobile no) through excel import function."><i data-feather="help-circle"></i></a></h2>
                    </div>


                </div>


            </section>
            <section id="column-search-datatable">
                <div class="row justify-content-end">
                    <div class="col-lg-auto  col-md-6 my-1 text-right">
                        <div class="form-group">
                            <a href="{{ asset('samples/Doctors-clean-sample.xlsx') }}"
                                class="btn btn-success btn-toggle-sidebar waves-effect waves-float waves-light">
                                <span class=""><i data-feather="download" class="ml-1"></i> Download
                                    Sample</span>
                            </a>
                        </div>
                    </div>

                </div>
                <div class="row">
                    <div class="col-12">
                        <div class="card">

                            <div class="card-datatable p-1">
                                <div class="row">

                                    <div class="col-lg-4 my-auto">
                                        <div class="row">

                                            <div class="col-lg-10  col-md-6 my-auto">
                                                {{ Form::open(['url' => '#', 'name' => 'validateForm', 'id' => 'validateForm', 'enctype' => 'multipart/form-data']) }}
                                                <div class="form-group mt-2">
                                                    <button class="btn btn-outline-primary w-100">
                                                        <input type="file" id="file" name="file"
                                                            class="upload-file"
                                                            accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">
                                                        <span class="filename">Browse</span>
                                                        <i class="fa fa-upload ml-1" style="color: #db644d;"></i>
                                                    </button>
                                                    <label id="file-error" class="error" for="file"></label>



                                                    <p class="text-danger text-center mt-1">(Max. size 10 MB per file)</p>
                                                </div>
                                                <button class="btn btn-success mx-auto d-block mt-1" type="submit"
                                                    id="submit">
                                                    Upload
                                                </button>
                                                {{ Form::close() }}
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-8  my-auto">

                                        <h4 class="mb-2" style="text-decoration:underline">Instructions for Clean Doctor
                                            :</h4>
                                        <p><i class="fa fa-angle-double-right mr-1"></i>Please Import with <b>SC Code</b>
                                            </b></p>
                                        <p><i class="fa fa-angle-double-right mr-1"></i>Please ensure that you save and
                                            close the excel sheet in your computer before you upload the file </p>

                                    </div>
                                </div>

                            </div>
                        </div>
                    </div>
                </div>
                <div class="row">
                    <div class="col-12">
                        <div class="card">

                            <div class="card-datatable p-1 table-responsive">

                                <table class="dt-column-search table table-striped w-100 text-center display"
                                    id="dataTable">
                                    <thead>
                                        <tr>
                                            <th>Sr. No.</th>
                                            {{-- <th>Insert Count</th> --}}
                                            <th>Update Count</th>
                                            <th>Error Count</th>
                                            <th>Total Count</th>
                                            <th>Status</th>
                                            <th>Remarks</th>
                                            <th>Import Date & Time</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
            <!-- Dashboard Ecommerce ends -->

        </div>
    </div>
@endsection
@section('scripts')
    <script>
        $(function() {
            var columns = [{
                    data: 'DT_RowIndex',
                    name: 'DT_RowIndex',
                    "orderable": false,
                    searchable: false
                },
                // {
                //     data: 'insert_count',
                //     name: 'iInsertCount',
                // },
                {
                    data: 'update_count',
                    name: 'iUpdateCount',
                },
                {
                    data: 'error_count',
                    name: 'iErrorCount',
                },
                {
                    data: 'total_count',
                    name: 'iImportCount',
                },
                {
                    data: 'status',
                    name: 'eStatus',
                },
                {
                    data: 'vComment',
                    name: 'vComment',
                },
                {
                    data: 'created_at',
                },
            ];
            var columnDefs = [];
            getdatatable("{{ route('division.doctor.clean.paginate') }}", columns, columnDefs);
        });

        function getdatatable(url, columns, columnDefs) {
            $('#dataTable').DataTable({
                processing: true,
                serverSide: true,
                bDestroy: true,
                order: [],
                "scrollX": true,
                columns: columns,
                columnDefs: columnDefs,
                // ajax: "{{ url('participant-paginate') }}",
                ajax: {
                    method: 'post',
                    url: url,
                    data: function(d) {
                        d._token = "{{ csrf_token() }}"
                    }
                },
                "drawCallback": function(settings) {
                    new VenoBox({
                        selector: '.venobox_img',
                    });
                    feather.replace();

                    // alert();
                }
            });
        }


        $(document).ready(function() {
             
            $.validator.addMethod('filesize', function(value, element, param) {
                return this.optional(element) || (element.files[0].size <= param)
            }, 'File size must be less than {0}');
            $("#validateForm").validate({
                ignore: ".ignore",
                rules: {
                    file: {
                        required: true,
                        extension: "xlsx",
                        filesize: 15000000,
                    }
                },
                submitHandler: function(form) {
                    Swal.fire({
                        title: 'Are you sure?',
                        text: "You are going to import this sheet in" + $(
                            '#iDivisionIDNav option:selected').text() + " Division.",
                        icon: 'warning',
                        showCancelButton: true,
                        confirmButtonColor: '#3085d6',
                        cancelButtonColor: '#d33',
                        confirmButtonText: 'Yes, Approve it!'
                    }).then((result) => {
                        if (result.isConfirmed) {
                            // return false;
                            $("#submit").html('<span> Processing...</span>');
                            $("#submit").attr('disabled', true);

                            var formData = new FormData($("#validateForm")[0]);
                            $.ajax({
                                url: "{{ route('division.doctor.clean.save') }}",
                                type: 'POST',
                                data: formData,
                                processData: false,
                                contentType: false,
                                dataType: "json",
                                success: function(response) {
                                    if (response.status == 0) {
                                        $("#submit").html('Submit');
                                        $("#submit").attr('disabled', false);
                                        $.notify(response.message, "error");
                                    } else {
                                        $(".filename").html('Browse');
                                        $("#vLogo").rules("add", {
                                            required: true,
                                            accept: "png"
                                        });
                                        $.notify(response.message, "success");
                                        $("#submit").attr('disabled', false);
                                        $("#submit").html('Submit');
                                        $('#dataTable').DataTable().ajax.reload();
                                        $('#validateForm').trigger("reset");

                                    }
                                },
                                error: function(jqXHR, textStatus, errorThrown) {
                                    if (jqXHR.status == 419){
                            $.notify("Please refresh the Page", "error");
                        }else if (jqXHR.status == 500){
                            $.notify("Please try after a few minutes", "error");
                        }else{
                            $.notify(jqXHR.responseJSON.message, "error");
                        }
                                    var flag = 0;
                                    $("#submit").html('Submit');
                                    $("#submit").attr('disabled', false);
                                    $.each(jqXHR.responseJSON.errors, function(
                                        index,
                                        data) {
                                        if (flag == 0) {
                                            $('input[name="' + index + '"]')
                                                .focus();
                                            flag = 1;
                                        }
                                        if (document.getElementsByName(
                                                index)[0]
                                            .tagName == "INPUT" && document
                                            .getElementsByName(index)[0]
                                            .type !=
                                            'radio'
                                        ) {
                                            $('input[name="' + index + '"]')
                                                .after(
                                                    '<label id="' + index +
                                                    '-error" class="error" for="' +
                                                    index + '">' + data +
                                                    '</label>');
                                        } else if (document
                                            .getElementsByName(
                                                index)[0]
                                            .tagName == "SELECT") {
                                            $('select[name="' + index +
                                                    '"]')
                                                .after(
                                                    '<label id="' + index +
                                                    '-error" class="error" for="' +
                                                    index + '">' + data +
                                                    '</label>');
                                        } else if (document
                                            .getElementsByName(
                                                index)[0]
                                            .tagName == "TEXTAREA") {
                                            $('textarea[name="' + index +
                                                    '"]')
                                                .after(
                                                    '<label id="' + index +
                                                    '-error" class="error" for="' +
                                                    index + '">' + data +
                                                    '</label>');
                                        } else if (document
                                            .getElementsByName(
                                                index)[0]
                                            .tagName == "INPUT" && document
                                            .getElementsByName(index)[0]
                                            .type ==
                                            'radio'
                                        ) {
                                            $('input[name="' + index + '"]')
                                                .after(
                                                    '<label id="' + index +
                                                    '-error" class="error" for="' +
                                                    index + '">' + data +
                                                    '</label>');
                                        }
                                    });
                                }
                            }); //ajax
                        }
                    })
                }
            });
        });

        function setDivision(iDivisionID) {
            $.post("{{ route('division.set.session') }}", {
                    iDivisionID: iDivisionID,
                    _token: "{{ csrf_token() }}"
                },
                function(data, status) {
                    $('#dataTable').DataTable().ajax.reload();
                });
        }

        $('.upload-file').change(function() {
            var filename = $(this).val().replace(/C:\\fakepath\\/i, '');
            // console.log(filename);
            $(this).siblings('span').html(filename);
        });
    </script>
@endsection