@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 inforce</h1>
                </div>
                <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 inforce</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>

    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">

                            <div id="notification" class="alert alert-dark" style="display: none; position: absolute; top: 150px; left: 50%; transform: translateX(-50%); z-index: 1000; padding: 10px; background-color: #17a2b8; color: white; border-radius: 5px;">
                                Anda sedang mendownload Excel, harap menunggu...
                            </div>
                            
                            <form id="exportForm" action="{{ route('export-excel-inforce') }}" method="POST">
                                @csrf
                                <input type="hidden" id="selectedMonthExport" name="selectedMonthExport">
                                <input type="hidden" id="procedureExport" name="procedureExport">
                                <input type="hidden" id="filteredData" name="filteredData">

                                <table class="table">
                                    <tbody>
                                        <tr>
                                            <td><label for="procedure">Pilih Stored Procedure:</label></td>
                                            <td>
                                                <select id="procedure" class="form-control" name="procedure" style="width: 25.8%" required>
                                                    <option value="" disabled selected>Pilih Stored Procedure</option>
                                                    <option value="spr_ac08r_prm_def_bln_ojk_vs1">Data inforce KONVEN</option>
                                                    <option value="spr_ac08r_prm_def_bln_ojk_syh">Data inforce SYARIAH</option>
                                                </select>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>Pilih Bulan:</td>
                                            <td><input type="text" class="monthpicker" id="selectedMonth" name="selectedMonth"></td>
                                        </tr>
                                    </tbody>
                                </table>
                                <button type="button" id="exportButton" 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: 2rem; height: 2rem;">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-border text-danger loading-spinner" role="status" style="width: 2rem; height: 2rem;">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-grow text-warning loading-spinner" role="status" style="width: 2rem; height: 2rem;">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-border text-info loading-spinner" role="status" style="width: 2rem; height: 2rem;">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                            </div>

                            <table class="table table-hover inforce nowrap display bg-cyan" style="width:100%">
                                <thead>
                                    <tr>
                                    <th>br_id</th>
                                    <th>cob_id</th>
                                    <th>scob_id</th>
                                    <th>pol_num</th>
                                    <th>renew_num</th>
                                    <th>updt_num</th>
                                    <th>risk_num</th>
                                    <th>uw_yr</th>
                                    <th>cob_nm</th>
                                    <th>scob_nm</th>
                                    <th>inv_num</th>
                                    <th>grp_head_id</th>
                                    <th>officer_id</th>
                                    <th>commence_dt</th>
                                    <th>expired_dt</th>
                                    <th>close_dt</th>
                                    <th>insrd_pr_nm</th>
                                    <th>prm_pr_nm</th>
                                    <th>awal_dt_new</th>
                                    <th>akhir_dt_new</th>
                                    <th>crc_id</th>
                                    <th>crc_rate</th>
                                    <th>si_amt</th>
                                    <th>premi_bruto</th>
                                    <th>premi_reas</th>
                                    <th>premi_netto</th>
                                    <th>komisi_bayar</th>
                                    <th>komisi_reas</th>
                                    <th>komisi_netto</th>
                                    <th>diskon</th>
                                    <th>waktu</th>
                                    <th>pengali</th>
                                    <th>premi_bruto_akui</th>
                                    <th>premi_bruto_def</th>
                                    <th>premi_bruto_jln</th>
                                    <th>premi_reas_akui</th>
                                    <th>premi_reas_def</th>
                                    <th>premi_netto_akui</th>
                                    <th>premi_netto_def</th>
                                    <th>komisi_bayar_akui</th>
                                    <th>komisi_bayar_def</th>
                                    <th>komisi_reas_akui</th>
                                    <th>komisi_reas_def</th>
                                    <th>komisi_netto_akui</th>
                                    <th>komisi_netto_def</th>
                                    <th>premi_bruto_rls</th>
                                    <th>premi_reas_rls</th>
                                    <th>premi_netto_rls</th>
                                    <th>komisi_bayar_rls</th>
                                    <th>komisi_reas_rls</th>
                                    <th>komisi_netto_rls</th>
                                    <th>diskon_akui</th>
                                    <th>diskon_def</th>
                                    <th>diskon_rls</th>
                                    <th>premi_jiwa</th>
                                    <th>status_polis</th>
                                    <th>stat_def</th>
                                    <th>tenor</th>
                                    <th>akad</th>
                                    <th>polis_install</th>
                                    <th>rate_premi</th>
                                    <th>coi_st</th>
                                    <th>tga_pct</th>
                                    <th>endt_rem</th>
                                    <th>tgl1</th>
                                    <th>tgl2</th>
                                    <th>as_br_id</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
</div>

@push('js')
<script>
$(document).ready(function () {
    $('.monthpicker').datepicker({
    autoclose: true,
    clearBtn: true,
    minViewMode: 'months',
    format: 'yyyy-mm'
}).on('changeDate', function(e) {
    var selectedDate = $(this).datepicker('getDate');
    var lastDay = new Date(selectedDate.getFullYear(), selectedDate.getMonth() + 1, 0);
    var formattedDate = lastDay.getFullYear() + '-' + 
                        ('0' + (lastDay.getMonth() + 1)).slice(-2) + '-' + 
                        ('0' + lastDay.getDate()).slice(-2);
    $(this).val(formattedDate);
});


    var inforce = $(".inforce").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('inforce') }}",
            data: function (d) {
                d.month = $('#selectedMonth').val();
                d.procedure = $('#procedure').val();
            },
            beforeSend: function () {
                $(".loading-spinner").show();
            },
            complete: function () {
                $(".loading-spinner").hide();
            },
            dataSrc: function (json) {
                return json.data;
            },
        },
        deferRender: true,
        paging: true,
        pageLength: 10,
        ordering: false,
        columns: [
            { "data": "br_id" },
            { "data": "cob_id" },
            { "data": "scob_id" },
            { "data": "pol_num" },
            { "data": "renew_num" },
            { "data": "updt_num" },
            { "data": "risk_num" },
            { "data": "uw_yr" },
            { "data": "cob_nm" },
            { "data": "scob_nm" },
            { "data": "inv_num" },
            { "data": "grp_head_id" },
            { "data": "officer_id" },
            { "data": "commence_dt" },
            { "data": "expired_dt" },
            { "data": "close_dt" },
            { "data": "insrd_pr_nm" },
            { "data": "prm_pr_nm" },
            { "data": "awal_dt_new" },
            { "data": "akhir_dt_new" },
            { "data": "crc_id" },
            { "data": "crc_rate" },
            { "data": "si_amt" },
            { "data": "premi_bruto" },
            { "data": "premi_reas" },
            { "data": "premi_netto" },
            { "data": "komisi_bayar" },
            { "data": "komisi_reas" },
            { "data": "komisi_netto" },
            { "data": "diskon" },
            { "data": "waktu" },
            { "data": "pengali" },
            { "data": "premi_bruto_akui" },
            { "data": "premi_bruto_def" },
            { "data": "premi_bruto_jln" },
            { "data": "premi_reas_akui" },
            { "data": "premi_reas_def" },
            { "data": "premi_netto_akui" },
            { "data": "premi_netto_def" },
            { "data": "komisi_bayar_akui" },
            { "data": "komisi_bayar_def" },
            { "data": "komisi_reas_akui" },
            { "data": "komisi_reas_def" },
            { "data": "komisi_netto_akui" },
            { "data": "komisi_netto_def" },
            { "data": "premi_bruto_rls" },
            { "data": "premi_reas_rls" },
            { "data": "premi_netto_rls" },
            { "data": "komisi_bayar_rls" },
            { "data": "komisi_reas_rls" },
            { "data": "komisi_netto_rls" },
            { "data": "diskon_akui" },
            { "data": "diskon_def" },
            { "data": "diskon_rls" },
            { "data": "premi_jiwa" },
            { "data": "status_polis" },
            { "data": "stat_def" },
            { "data": "tenor" },
            { "data": "akad" },
            { "data": "polis_install" },
            { "data": "rate_premi" },
            { "data": "coi_st" },
            { "data": "tga_pct" },
            { "data": "endt_rem" },
            { "data": "tgl1" },
            { "data": "tgl2" },
            { "data": "as_br_id" }
        ],
    });


    $('.monthpicker').on('change', function () {
        var selectedMonth = $("#selectedMonth").val();
        if (selectedMonth) {
            $("#selectedMonthExport").val(selectedMonth); 
            inforce.draw();
        }
    });

    $('#exportButton').on('click', function () {
        var selectedMonth = $('#selectedMonth').val();
        var procedure = $('#procedure').val();

        $('#selectedMonthExport').val(selectedMonth);
        $('#procedureExport').val(procedure);
        $('#notification').show();

        $.ajax({
            type: 'GET',
            url: "{{ route('inforce') }}",
            data: {
                month: selectedMonth,
                procedure: procedure
            },
            success: function (response) {
                $('#filteredData').val(JSON.stringify(response.data));
                $('#exportForm').submit();
                $('#notification').hide();
            },
            error: function () {
                $('#notification').hide();
            }
        });
    });
});
</script>
@endpush

@endsection