@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 GL</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 GL</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-gl') }}" method="POST">
                                @csrf
                                <input type="hidden" id="selectedMonthExport" name="selectedMonthExport">
                                <input type="hidden" id="search" name="search">
                                <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_GL_AKT_konven">Data GL KONVEN</option>
                                                    <option value="spr_GL_AKT_syariah">Data GL SYARIAH</option>
                                                </select>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td><label for="search">Search GL:</label></td>
                                            <td>
                                                <input type="text" class="form-control" id="searchInput" name="search" style="width: 25%;">
                                            </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 gl nowrap display bg-cyan" style="width:100%">
                                <thead>
                                    <tr>
                                        <th>coa</th>
                                        <th>coa_nm</th>
                                        <th>sd_db_amt</th>
                                        <th>sd_cr_amt</th>
                                        <th>sd_tr_db_amt</th>
                                        <th>sd_tr_cr_amt</th>
                                        <th>tgl</th>
                                        <th>crc_id</th>
                                        <th>db_idr_amt</th>
                                        <th>cr_idr_amt</th>
                                        <th>ket</th>
                                        <th>doc_id</th>
                                        <th>rp_dt</th>
                                        <th>br_id</th>
                                        <th>led_sub</th>
                                        <th>opening_ket</th>
                                        <th>br_nm</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'
    });

    var gl = $(".gl").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('gl') }}",
            data: function (d) {
                d.month = $('#selectedMonth').val();
                d.search = $('#searchInput').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": "coa" },
            { "data": "coa_nm" },
            { "data": "sd_db_amt" },
            { "data": "sd_cr_amt" },
            { "data": "sd_tr_db_amt" },
            { "data": "sd_tr_cr_amt" },
            { "data": "tgl" },
            { "data": "crc_id" },
            { "data": "db_idr_amt" },
            { "data": "cr_idr_amt" },
            { "data": "ket" },
            { "data": "doc_id" },
            { "data": "rp_dt" },
            { "data": "br_id" },
            { "data": "led_sub" },
            { "data": "opening_ket" },
            { "data": "br_nm" }
        ],
    });

    $('#searchInput').on('input', function () {
        gl.draw();
    });

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

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

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

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

@endsection