@extends('layouts.authorized')

@section('headerCustom')
    @php
        $title = 'Laporan OJK (Formulir 3-B)';
    @endphp
@endsection

@section('title', $title)

@section('cssCustom')
    <style>
        .table-button {
            display: none;
        }
    </style>
@endsection

@section('content')

    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <span>{{ strtoupper($title) }}</span>
                </div>
                <div class="card-body">
                    <form action="{{ route('admin.report.ojkReport3bData') }}" method="POST">
                        <div class="form-group row">
                            <div class="col-md-12">
                                <div class="input-group input-date-range">
                                    <input name="dateFrom" type="text" class="customdatepickerinput form-control"
                                        value="{{ Carbon::now()->subMonths(1)->format('M Y') }}">
                                    <span class="input-group-addon">To</span>
                                    <input name="dateTo" type="text" class="customdatepickerinput form-control"
                                        value="{{ Carbon::now()->format('M Y') }}">
                                </div>
                            </div>
                            <div class="col-md-12 pull-right">
                                <button name="action" value="xlsx" class="btn table-setting btn-success btn-xs"
                                    tooltip="Download Excel" data-original-title="" title=""><i
                                        class="icon fa fa-file-excel-o"></i></button>
                                <button name="action" value="csv" class="btn table-setting btn-success btn-xs"
                                    tooltip="Download CSV" data-original-title="" title=""><i
                                        class="icon fa fa-file-text-o"></i></button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <span>Permohonan Pinjaman</span>
                </div>
                <div class="card-body table-responsive">
                    @tableconfig
                    @tableajax(route('admin.report.ojkReport3bData', ['dataset' => 'pendingTransaction']))
                        <thead>
                            <tr>
                                <th data-column-name="customerCount" data-sortable="false">Jml. Orang</th>
                                <th data-column-name="companyCount" data-sortable="false">Jml. Perusahaan</th>
                                <th data-column-name="totalTransactionGrandTotal" data-sortable="false">Jml. Uang (Rp)</th>
                                <th data-column-name="averageTransactionMarginRate" data-sortable="false">Rata-rata Tertimbang
                                    Bunga (%)</th>
                                <th data-column-name="averageTransactionPeriod" data-sortable="false">Rata-rata Tertimbang Tenor
                                </th>
                            </tr>
                        </thead>
                    @endtableajax
                </div>
            </div>
        </div>
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <span>Persetujuan Pembiayaan</span>
                </div>
                <div class="card-body table-responsive">
                    @tableconfig
                    @tableajax(route('admin.report.ojkReport3bData', ['dataset' => 'ongoingTransaction']))
                        <thead>
                            <tr>
                                <th data-column-name="customerCount" data-sortable="false">Jml. Orang</th>
                                <th data-column-name="companyCount" data-sortable="false">Jml. Perusahaan</th>
                                <th data-column-name="totalTransactionGrandTotal" data-sortable="false">Jml. Uang (Rp)</th>
                                <th data-column-name="averageTransactionMarginRate" data-sortable="false">Rata-rata Tertimbang
                                    Bunga (%)</th>
                                <th data-column-name="averageTransactionPeriod" data-sortable="false">Rata-rata Tertimbang Tenor
                                </th>
                            </tr>
                        </thead>
                    @endtableajax
                </div>
            </div>
        </div>
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <span>Status Pinjaman</span>
                </div>
                <div class="card-body table-responsive">
                    @tableconfig
                    @tableajax(route('admin.report.ojkReport3bData', ['dataset' => 'statusTransaction']))
                        <thead>
                            <tr>
                                <th data-column-name="fluentTransactionRate" data-sortable="false">Rata-rata Status Lancar(%)
                                </th>
                                <th data-column-name="arrearsTransactionRate" data-sortable="false">Rata-rata Status Tidak
                                    Lancar(%)</th>
                                <th data-column-name="suspendedTransactionRate" data-sortable="false">Rata-rata Kredit Macet(%)
                                </th>
                            </tr>
                        </thead>
                    @endtableajax
                </div>
            </div>
        </div>
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <span>Status Akumulasi Pinjaman</span>
                </div>
                <div class="card-body table-responsive">
                    @tableconfig
                    @tableajax(route('admin.report.ojkReport3bData', ['dataset' => 'overallTransaction']))
                        <thead>
                            <tr>
                                <th data-column-name="customerCount" data-sortable="false">Jml. Orang</th>
                                <th data-column-name="companyCount" data-sortable="false">Jml. Perusahaan</th>
                                <th data-column-name="totalTransactionGrandTotal" data-sortable="false">Jml. Uang (Rp)</th>
                                <th data-column-name="averageTransactionMarginRate" data-sortable="false">Rata-rata Tertimbang
                                    Bunga (%)</th>
                                <th data-column-name="averageTransactionPeriod" data-sortable="false">Rata-rata Tertimbang Tenor
                                </th>
                                <th data-column-name="fluentTransactionRate" data-sortable="false">Rata-rata Status Lancar(%)
                                </th>
                                <th data-column-name="arrearsTransactionRate" data-sortable="false">Rata-rata Status Tidak
                                    Lancar(%)</th>
                                <th data-column-name="suspendedTransactionRate" data-sortable="false">Rata-rata Kredit Macet(%)
                                </th>
                            </tr>
                        </thead>
                    @endtableajax
                </div>
            </div>
        </div>
    </div>

@endsection

@section('jsCustom')
    <script>
        $(document).ready(function() {
            $('.customdatepickerinput').datetimepicker({
                viewMode: 'years',
                format: 'MMM YYYY'
            });

            $('.customdatepickerinput').on('dp.change', function() {
                refreshDataTable();
            });
        })

        function customFilter(filter) {
            filter.dateFrom = $('[name=dateFrom]').val();
            filter.dateTo = $('[name=dateTo]').val();
            return filter;
        }

        function refreshDataTable() {
            $(dataTableList).each(function(index, data) {
                dataTableList[index].clear().draw();
            });
        }
    </script>
@endsection