@extends('Layouts.main')
@section('container')
    <div class="row">
        <div class="col-12">
            <table id="dt-table" class="table table-bordered table-striped" width="100%">
                <thead>
                    <tr>
                        <th>No</th>
                        <th>Kode Jabatan</th>
                        <th>Nama Jabatan</th>
                        <th>Nama</th>
                        <th>NIP</th>
                        <th>Bagian</th>
                        <th>Action</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
    <!-- /.card -->
    <script>
        $(document).ready(function() {

            listData();

            $('#import').change(function() {
                validateForm();
            });

        });

        function listData() {

            var table = $('#dt-table').DataTable({
                responsive: true,
                processing: true,
                serverSide: true,
                destroy: true,
                language: {
                    search: "",
                    searchPlaceholder: "Cari data"
                },
                dom: "<'row'<'col-sm-12 col-md-6 d-flex justify-content-start pl-0'f><'col-sm-12 col-md-6 d-flex justify-content-end'B>>" +
                    "<'row'<'col-sm-12'tr>>" +
                    "<'row'<'col-sm-12 col-md-5'i><'col-sm-12 col-md-7'p>>",

                buttons: {
                    dom: {
                        button: {
                            className: ''
                        }
                    },
                    buttons: [{
                            extend: 'excel',
                            text: '<i class="fas fa-file-excel fa-sm"></i>',
                            titleAttr: 'Export',
                            className: 'btn btn-sm btn-secondary',
                            extension: '.xlsx',
                            action: function() {
                                window.location.href = "{{ url('/pejabat/export') }}"
                            }

                        },
                        {
                            text: '<i class="fas fa-plus fa-sm mr-2"></i>Tambah',
                            titleAttr: 'Tambah Data',
                            className: 'btn btn-sm btn-primary',
                            action: function() {
                                window.location.href = "{{ url('/pejabat/form') }}"
                            }

                        }
                    ]
                },
                ajax: {
                    url: "{{ url('/pejabat/list') }}",
                    type: "POST"
                },
                order: [
                    [1, 'asc']
                ],
                columns: [{
                        data: 'DT_RowIndex'
                    },
                    {
                        data: 'kode'
                    },
                    {
                        data: 'jabatan',
                    },
                    {
                        data: 'nama'
                    },
                    {
                        data: 'nidn'
                    },
                    {
                        data: 'bagian'
                    },
                    {
                        data: 'action',
                        className: 'dt-body-center',
                        orderable: false,
                        searchable: false
                    },
                ],
                columnDefs: [{
                    searchable: false,
                    sortable: false,
                    targets: [0]
                }, {
                    className: 'dt-head-center',
                    targets: [0, 1, 2, 3, 4, 5, 6]
                }]
            });

            $('#dt-table_wrapper .dt-buttons').removeClass('btn-group')
            $('#dt-table_filter, #dt-table_filter label,#dt-table_filter input').css({
                'width': '100%',
                'display': 'inline-block'
            });
        }

        function validateForm() {

            function hasExtension(inputID, exts) {
                var fileName = document.getElementById(inputID).value;
                return (new RegExp('(' + exts.join('|').replace(/\./g, '\\.') + ')$')).test(fileName);
            }

            if (!hasExtension('import', ['.xlsx'])) {
                alert("Only .xlsx allowed");
                return false;
            } else {
                $('.loading-wrapper').removeClass('hide-this')
                $('#port').trigger('click');
            }

        }
    </script>
@endsection