@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>DCS Document Report<a href="" class="ml-1" data-toggle="tooltip" data-placement="right"
                                              title="create DCS Report base on DCS ID of excel upload."><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/DCS-document-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
                                    DCS Document 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">
                                                    <select class="select2 select-label form-control w-100"
                                                            id="iStepID" name="iStepID">
                                                        <option value=""> Select Document</option>
                                                        @foreach ($steps as $key => $value)
                                                            <option value="{{ $value['iStepID'] }}">
                                                                {{ $value['vStep'] }}</option>
                                                        @endforeach
                                                    </select>
                                                    <label id="iStepID-error" class="error"
                                                           for="iStepID"></label>
                                                </div>
                                                <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 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
                                            DCS Document
                                            :</h4>
                                        <p><i class="fa fa-angle-double-right mr-1"></i>Please Import with correct <b>DCS ID</b></p>
                                        <p><i class="fa fa-angle-double-right mr-1"></i>Please download sample excel
                                            sheet for better understanding of import functionality </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>Document Type</th>
{{--                                        <th>Insert Count</th>--}}
{{--                                        <th>Update Count</th>--}}
                                       <th>Error Count</th>
{{--                                        <th>Total Count</th>--}}
                                        <th>zip</th>
                                        <th>Excel</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: 'step_type',
                    name: 'StepType',
                    "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: 'zip_download',
                    name: 'zip_download',
                    "orderable": false,
searchable: false
                },
                {
                    data: 'excel_download',
                    name: 'excel_download',
                    "orderable": false,
searchable: false
                },
                {
                    data: 'status',
                    name: 'eStatus',
                },
                {
                    data: 'vComment',
                    name: 'vComment',
                },
                {
                    data: 'created_at',
                },
            ];
            var columnDefs = [];
            getdatatable("{{ route('division.import.dcs.paginate') }}", columns, columnDefs);
        });

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

                    $('.unlock_center_code').hide();
                    $('.unlock_center').hide();
                    $('.center_code_div').on('click', function() {
                        $(this).children('.unlock_center').toggle();
                        $(this).children('.lock_center').toggle();
                        $(this).children('.unlock_center_code').toggle();
                    })
                }
            });
        }


        $(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,
                    },
                    iStepID: {
                        required: true,
                    }
                },
                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.import.dcs') }}",
                                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