@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>Import Field Person<a href="" class="ml-1" data-toggle="tooltip" data-placement="right" title="Import persons in the DigiCon System through excel import."><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/field-import-sample-v3.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 mt-1">(Max. size 15 MB per file ,accepted file type (i.e. please upload .xlsx, .xls))</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 Import
                                            Field Person:</h4>
                                        <p><i class="fa fa-angle-double-right mr-1"></i>Please Import with <b>Position
                                                Code</b> & <b>Employee Code</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.field.import.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) {
                    // return false;
                    $("#submit").html('<span> Processing...</span>');
                    $("#submit").attr('disabled', true);

                    var formData = new FormData($("#validateForm")[0]);
                    $.ajax({
                        url: "{{ route('division.field.import.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