@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 Produksi</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 Produksi</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="export-form" action="{{ route('export-excel-marketing') }}" method="POST">
                                @csrf
                                <input type="hidden" name="startDate" id="startDateHidden">
                                <input type="hidden" name="endDate" id="endDateHidden">
                                <input type="hidden" name="procedureExport" id="procedureExportHidden">
                                <input type="hidden" name="filteredData" id="filteredDataHidden">
                                <table class="table">
                                    <tbody>
                                        <tr>
                                            <td>
                                                <label for="procedure">Pilih Stored Procedure:</label>
                                            </td>
                                            <td>
                                                <select id="procedure" class="form-control" name="procedure" required>
                                                    <option value="" disabled selected>Pilih Stored Procedure</option>
                                                    <option value="generate_lap_mkt_gab">Data Produksi GABUNGAN</option>
                                                    <option value="generate_lap_mkt_konv">Data Produksi KONVEN</option>
                                                    <option value="generate_lap_mkt_syh">Data Produksi SYARIAH</option>
                                                </select>
                                            </td>
                                        </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="from" required>
                                                </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="to" required>
                                                </div>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>
                                <button type="button" id="export-button" 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">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-border text-danger loading-spinner" role="status">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-grow text-warning loading-spinner" role="status">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                                <div class="spinner-border text-info loading-spinner" role="status">
                                    <span class="visually-hidden">Loading...</span>
                                </div>
                            </div>

                            <table class="table table-hover marketing 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>commence_dt</th>
                                        <th>expired_dt</th>
                                        <th>prodr_type_cd</th>
                                        <th>biz</th>
                                        <th>insrd_pr_nm</th>
                                        <th>bank_pr_nm</th>
                                        <th>brk_pr_nm</th>
                                        <th>disc_pr_nm</th>
                                        <th>coi_pr_nm</th>
                                        <th>ceding_pr_nm</th>
                                        <th>company_grp_nm</th>
                                        <th>prm_sjp_eqv</th>
                                        <th>outgo_eqv</th>
                                        <th>prm_jw</th>
                                        <th>cls_dt</th>
                                        <th>cls_dt_2</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 marketing = $(".marketing").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('marketing') }}",
                data: function (d) {
                    d.from = $('#startDate').val();
                    d.to = $('#endDate').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: -1,
            ordering: false,
            columns: [
                { "data": "br_id" },
                { "data": "cob_id" },
                { "data": "pol_num" },
                { "data": "renew_num" },
                { "data": "updt_num" },
                { "data": "commence_dt" },
                { "data": "expired_dt" },
                { "data": "prodr_type_cd" },
                { "data": "biz" },
                { "data": "insrd_pr_nm" },
                { "data": "bank_pr_nm" },
                { "data": "brk_pr_nm" },
                { "data": "disc_pr_nm" },
                { "data": "coi_pr_nm" },
                { "data": "ceding_pr_nm" },
                { "data": "company_grp_nm" },
                { "data": "prm_sjp_eqv" },
                { "data": "outgo_eqv" },
                { "data": "prm_jw" },
                { "data": "cls_dt" },
                { "data": "cls_dt_2" }
            ],
        });

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

        $('#export-button').on('click', function () {
            var from = $("#startDate").val();
            var to = $("#endDate").val();
            var procedure = $('#procedure').val();

            $('#startDateHidden').val(from);
            $('#endDateHidden').val(to);
            $('#procedureExportHidden').val(procedure);
            $('#notification').show();

            $.ajax({
                type: 'GET',
                url: "{{ route('marketing') }}",
                data: {
                    from: from,
                    to: to,
                    procedure: procedure
                },
                success: function (response) {
                    $('#filteredDataHidden').val(JSON.stringify(response.data));
                    $('#export-form').submit();
                    $('#notification').hide();
                },
                error: function () {
                    $('#notification').hide();
                }
            });
        });
    });
</script>
@endpush

@endsection