@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 BPPDAN</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 BPPDAN</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-dan') }}" 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-danger 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 dan nowrap display bg-cyan" style="width:100%">
                                <thead>
                                    <tr>
                                        <th>br_id</th>
                                        <th>cob_id</th>
                                        <th>pol_num</th>
                                        <th>renew_num</th>
                                        <th>updt_num</th>
                                        <th>risk_num</th>
                                        <th>commence_dt</th>
                                        <th>expiry_dt</th>
                                        <th>end_commence_dt</th>
                                        <th>end_expiry_dt</th>
                                        <th>close_dt</th>
                                        <th>insrd_pr_nm</th>
                                        <th>cvrg_41</th>
                                        <th>cvrg_42</th>
                                        <th>cvrg_43</th>
                                        <th>cvrg_44</th>
                                        <th>cvrg_48</th>
                                        <th>obj_descr</th>
                                        <th>risk_adrs</th>
                                        <th>street_nm</th>
                                        <th>pos_num</th>
                                        <th>km</th>
                                        <th>city</th>
                                        <th>kode_wil</th>
                                        <th>street_num</th>
                                        <th>geog_area_cd</th>
                                        <th>geog_area_descr</th>
                                        <th>construction_cls_id</th>
                                        <th>occp_id</th>
                                        <th>prm_crc_id</th>
                                        <th>prm_rate</th>
                                        <th>tol_pct</th>
                                        <th>si_amt_100</th>
                                        <th>prm_amt_100</th>
                                        <th>si_amt_sjp</th>
                                        <th>prm_amt_sjp</th>
                                        <th>disc_amt_eqv</th>
                                        <th>bpp_pct</th>
                                        <th>prm_bpp</th>
                                        <th>inv_par</th>
                                        <th>scob_descr</th>
                                        <th>br_descr</th>
                                        <th>inv_num</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 dan = $(".dan").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('dan') }}",
                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": "br_id" },
                { "data": "cob_id" },
                { "data": "pol_num" },
                { "data": "renew_num" },
                { "data": "updt_num" },
                { "data": "risk_num" },
                { "data": "commence_dt" },
                { "data": "expiry_dt" },
                { "data": "end_commence_dt" },
                { "data": "end_expiry_dt" },
                { "data": "close_dt"},
                { "data": "insrd_pr_nm" },
                { "data": "cvrg_41" },
                { "data": "cvrg_42" },
                { "data": "cvrg_43" },
                { "data": "cvrg_44" },
                { "data": "cvrg_48" },
                { "data": "obj_descr" },
                { "data": "risk_adrs" },
                { "data": "street_nm" },
                { "data": "pos_num" },
                { "data": "km" },
                { "data": "city" },
                { "data": "kode_wil" },
                { "data": "street_num" },
                { "data": "geog_area_cd" },
                { "data": "geog_area_descr" },
                { "data": "construction_cls_id" },
                { "data": "occp_id" },
                { "data": "prm_crc_id" },
                { "data": "prm_rate" },
                { "data": "tol_pct" },
                { "data": "si_amt_100" },
                { "data": "prm_amt_100" },
                { "data": "si_amt_sjp" },
                { "data": "prm_amt_sjp" },
                { "data": "disc_amt_eqv" },
                { "data": "bpp_pct" },
                { "data": "prm_bpp" },
                { "data": "inv_par" },
                { "data": "scob_descr" },
                { "data": "br_descr" },
                { "data": "inv_num" }
            ],
        });

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

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

@endsection