@extends('layout.admin')

@section('content')

<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Data SIPESAT</h1>
                </div><!-- /.col -->
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">Data SIPESAT</li>
                    </ol>
                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.container-fluid -->
    </div>

    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <form action="{{ route('export-excel-sipesat') }}" method="POST">
                                @csrf
                                <table class="table">
                                    <tbody>
                                        <tr>
                                        <td><label for="cabang">Pilih Cabang : </label></td>
                                        <td>
                                            <select id="cabang" class="form-control" name="cabang">
                                                <option class="text-center" value="" disabled selected>- Pilih -</option>
                                                <option value="Konvensional">Konvensional</option>
                                                <option value="Syariah">Syariah</option>
                                            </select>
                                        </td>
                                        </tr>
                                        <tr>
                                        </tr>
                                        <tr>
                                            <td><label for="startDate">Minimum date:</label></td>
                                            <td>
                                                <div class="input-group">
                                                    <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
                                                    <input type="text" class="form-control datepicker" id="startDate" name="startDate">
                                                </div>
                                            </td>
                                            <td><label for="endDate">Maximum date:</label></td>
                                            <td>
                                                <div class="input-group">
                                                    <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
                                                    <input type="text" class="form-control datepicker" id="endDate" name="endDate">
                                                </div>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>
                                <div style="display: flex; justify-content: space-between;"></div>
                                <button type="submit" class="btn btn-dark">Download Excel</button>
                            </form>
                            <br>
                            <br>

                            <div class="d-flex justify-content-center">
                                <div class="spinner-grow text-success loading-spinner" role="status" style="width: 2;height: 2">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-border text-sipesatger loading-spinner" role="status" style="width: 2;height: 2">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-grow text-warning loading-spinner" role="status" style="width: 2;height: 2">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-border text-info loading-spinner" role="status" style="width: 2;height: 2">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                            </div>

                            <table class="table table-hover sipesat nowrap display bg-cyan" style="width:100%">
                                <thead>
                                    <tr>
                                    <th>idpjk</th>
                                    <th>KodeNasabah</th>
                                    <th>NamaNasabah</th>
                                    <th>TempatLahir</th>
                                    <th>TanggalLahir</th>
                                    <th>Alamat</th>
                                    <th>NoKtp</th>
                                    <th>NoIdLain</th>
                                    <th>NoCIF</th>
                                    <th>NoNPWP</th>
                                    <th>JenisNasabah</th>
                                    <th>close_dt</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
</div>

@push('js')
<script>
    $(document).ready(function () {
        $('.datepicker').datepicker({
            autoclose: true,
            clearBtn: true,
            format: 'yyyy-mm-dd'
        });

        var sipesat = $(".sipesat").DataTable({
            bFilter: false,
            autoWidth: true,
            scrollX: true,
            scrollY: '310px',
            scroller: {
                loadingIndicator: false,
            },
            searching: false,
            select: true,
            cache: true,
            destroy: true,
            processing: true,
            serverSide: true,
            ajax: {
                type: 'GET',
                url: "{{ route('sipesat') }}",
                data: function (d) {
                    d.from = $('#startDate').val();
                    d.to = $('#endDate').val();
                    d.cabang = $('#cabang').val();
                },
                beforeSend: function () {
                    $(".loading-spinner").show();
                },
                complete: function () {
                    $(".loading-spinner").hide();
                },
                dataSrc: function (json) {
                    return json.data;
                },
            },
            deferRender: true,
            paging: true,
            pageLength: -1,
            ordering: false,
            columns: [
                { "data": "idpjk" },
                { "data": "KodeNasabah" },
                { "data": "NamaNasabah" },
                { "data": "TempatLahir" },
                { "data": "TanggalLahir" },
                { "data": "Alamat" },
                { "data": "NoKtp" },
                { "data": "NoIdLain" },
                { "data": "NoCIF" },
                { "data": "NoNPWP" },
                { "data": "JenisNasabah" },
                { "data": "close_dt" }
            ],
        });

        $('.datepicker').on('change', function () {
            var from = $("#startDate").val();
            var to = $("#endDate").val();
            if (from && to) {
                sipesat.draw();
            }
        });

        $('#cabang').on('change', function () {
            sipesat.draw();
        });
    });
</script>
@endpush

@endsection