@extends('layouts.layout')

@section('body_class', 'nav-md')

@section('body_content')
    <div class="container body">
        <div class="main_container">
            @include('includes.sidebar')
            <div class="right_col" role="main">
                <div class="page-title">
                    <div class="title_left">
                        <h3>Reporting Transaksi Laku Titip</h3>
                    </div>
                    <div class="clearfix"></div>
                </div>

                <div class="row">
                    <div class="col-xs-12">
                        <ol class="breadcrumb">
                            <li><a href="{{ url('/dashboard') }}">Home</a></li>
                            <li><a href="{{ url('/reporting/transaksi_lakuemas') }}">Reporting</a></li>
                            <li class="active">Transaksi Laku Titip</li>
                        </ol>
                    </div>

                    <div class="row" style="margin-top: 15px">
                        <label class="col-xs-1 control-label" style="margin-left: 550px;">Jenis Filter</label>
                        <div class="col-xs-3">
                            <select id="filterType" class="form-control" onchange="toggleFilterElements()">
                                <option value="pilihfilter">-- Pilih filter --</option>
                                <option value="rekening">Filter Rekening Laku Titip</option>
                                <option value="maturity" onchange="setMaturity()">Filter Maturity</option>
                            </select>
                        </div>
                    </div>

                    <div class="col-xs-6">
                        <div class="x_panel">
                            <div class="x_title">
                                <h2><b>Filter Rekening Laku Simpan</b></h2>
                                <ul class="nav navbar-right panel_toolbox">
                                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                                </ul>
                                <div class="clearfix"></div>
                            </div>
                            <div class="x_content">
                                <form id="form_filter" class="form-horizontal">
                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tanggal Mulai</label>
                                        <div class="col-sm-10">
                                            <input name="date_start" type="date" class="form-control"
                                                value="{{ @$_GET['date_start'] }}">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tanggal Selesai</label>
                                        <div class="col-sm-10">
                                            <input name="date_end" type="date" class="form-control"
                                                value="{{ @$_GET['date_end'] }}">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">RM Referral</label>
                                        <div class="col-sm-10">
                                            <input name="rm_referral" type="text" class="form-control"
                                                placeholder="RM Referral" value="{{ $request['rm_referral'] }}">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Status</label>
                                        <div class="col-sm-10">
                                            <select class="form-control" name="status">
                                                <option value="">All</option>
                                                <option value="1" @if ($request['status'] == '1') selected @endif>
                                                    Aktif</option>
                                                <option value="0" @if ($request['status'] == '0') selected @endif>
                                                    Tidak Aktif</option>
                                            </select>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <div class="col-sm-offset-2 col-sm-10">
                                            <button type="submit" class="btn btn-default"><i
                                                    class="fa fa-search"></i>Cari</button>
                                        </div>
                                    </div>

                            </div>
                        </div>
                    </div>

                    <div class="col-xs-6">
                        <div class="x_panel">
                            <div class="x_title">
                                <h2><b>Filter Maturity</b></h2>
                                <ul class="nav navbar-right panel_toolbox">
                                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                                </ul>
                                <div class="clearfix"></div>
                            </div>
                            <div class="x_content">
                                <div class="form-horizontal">
                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tanggal Mulai</label>
                                        <div class="col-sm-10">
                                            <input name="start_tempo" id="start_tempo" type="date" class="form-control"
                                                value="{{ @$_GET['start_tempo'] }}" onchange="setDateStartMaturity()"
                                                readonly>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tanggal Selesai</label>
                                        <div class="col-sm-10">
                                            <input name="end_tempo" id="end_tempo" type="date" class="form-control"
                                                value="{{ @$_GET['end_tempo'] }}" readonly>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Perpanjangan</label>
                                        <div class="col-sm-10">
                                            <select class="form-control" name="transaksi" id="transaksiSelect" disabled>
                                                <option value="">All</option>
                                                <option value="1" @if ($request['transaksi'] == '1') selected @endif>
                                                    Tidak Perpanjang</option>
                                                <option value="2" @if ($request['transaksi'] == '2') selected @endif>
                                                    Pokok</option>
                                                <option value="3" @if ($request['transaksi'] == '3') selected @endif>
                                                    Pokok + Bunga</option>
                                            </select>
                                        </div>
                                    </div>

                                    <div class="form-group" hidden>
                                        <label class="col-sm-2 control-label">Status Maturity</label>
                                        <div class="col-sm-10">
                                            <select class="form-control" name="status_maturity" id="status_maturity">
                                                <option value="">All</option>
                                                <option value="0" @if ($request['status_maturity'] == '0') selected @endif>
                                                    Tidak Aktif</option>
                                            </select>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <div class="col-sm-offset-2 col-sm-10">
                                            <p style="font-size:10px;">*Batas maksimal pencarian data adalah 4 bulan dari
                                                tanggal mulai.</p>
                                            {{-- <p >Range tanggal Filter Maturity : {{ @$_GET['start_tempo'] }} -  {{ @$_GET['end_tempo'] }}</p> --}}
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <div class="col-sm-offset-2 col-sm-10">
                                            <button type="submit" class="btn btn-default"><i
                                                    class="fa fa-search"></i>Cari</button>
                                        </div>
                                    </div>
                                </div>
                                </form>
                            </div>
                        </div>
                    </div>


                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="x_title">
                                <div class="row">
                                    <h2 class="col-md-2">Data Transaksi</h2>
                                    <div class="col-md-10 text-right">
                                        <a class="btn btn-primary btn-download"
                                            href="{{ route('transaksi_lakutitipan_excel', [
                                                'start_tempo' => request()->get('start_tempo'),
                                                'end_tempo' => request()->get('end_tempo'),
                                                'date_start' => request()->get('date_start'),
                                                'date_end' => request()->get('date_end'),
                                                'status' => request()->get('status'),
                                                'rm_referral' => request()->get('rm_referral'),
                                                'transaksi' => request()->get('transaksi'),
                                                'status_maturity' => request()->get('status_maturity'),
                                            ]) }}">
                                            <i class="fa fa-download" aria-hidden="true"></i> Unduh
                                        </a>
                                    </div>
                                </div>
                                <div class="clearfix"></div>
                            </div>
                            <div class="x_content">
                                <table id="table_transaksi" class="table table-condensed table-striped table-hover">
                                    <thead>
                                        <tr>
                                            <th class="text-center">#</th>
                                            <th>Nomor Rekening</th>
                                            <th>Tanggal Buka</th>
                                            <th>Tanggal Tutup</th>
                                            <th>Tanggal Break</th>
                                            <th>Nama Customer</th>
                                            <th>No HP</th>
                                            <th>Berat (gram)</th>
                                            <th>Periode</th>
                                            <th>Bunga</th>
                                            {{-- <th>RM Referral</th> --}}
                                            <th>Pajak</th>
                                            <th>Penalty Rate</th>
                                            <th>Tujuan Rekening</th>
                                            <th>Perpanjangan</th>
                                            <th>Status</th>
                                            <th></th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($transaksi as $idx => $item_tx)
                                            <tr>
                                                <td class="text-center">
                                                    {{ $idx + 1 + (empty($_GET['page']) ? 0 : $_GET['page'] - 1) * 30 }}
                                                </td>
                                                <td class="text-center">{{ $item_tx->nomor_rekening }}</td>
                                                <td class="text-center">
                                                    {{ \Carbon\Carbon::parse($item_tx->tanggal_buka)->format('Y-m-d') }}
                                                </td>
                                                <td class="text-center">
                                                    {{ \Carbon\Carbon::parse($item_tx->jatuh_tempo)->format('Y-m-d') }}
                                                </td>
                                                <td class="text-center">
                                                    @if ($item_tx->breaked_at)
                                                        {{ \Carbon\Carbon::parse($item_tx->breaked_at)->format('Y-m-d') }}
                                                    @else
                                                        -
                                                    @endif
                                                </td>
                                                <td>{{ $item_tx->nama_customer }}</td>
                                                <td width="8%">{{ $item_tx->handphone }}</td>
                                                <td class="text-center">
                                                    {{ $item_tx->berat >= 1000 ? number_format($item_tx->berat, fmod($item_tx->berat, 1) == 0 ? 0 : 4, '.', ',') : $item_tx->berat + 0 }}
                                                </td>
                                                <td class="text-center">{{ $item_tx->lama_titipan_hari ? : $item_tx->lama_titipan * 30 }} hari</td>
                                                <td class="text-right">{{ $item_tx->suku_bunga }} %</td>
                                                {{-- <td width="8%">{{ $item_tx->rm }}</td> --}}
                                                <td class="text-right">{{ @$item_tx->pajak }} %</td>
                                                <td class="text-right">
                                                    @if ($item_tx->penalty_rate)
                                                        {{ @$item_tx->penalty_rate }} %
                                                    @else
                                                        -
                                                    @endif
                                                </td>
                                                <td class="text-center">{{ $item_tx->tujuan_rekening }}</td>
                                                <td>
                                                    @if ($item_tx->perpanjangan == '1')
                                                        Tidak Perpanjang
                                                    @elseif($item_tx->perpanjangan == '2')
                                                        Pokok
                                                    @elseif($item_tx->perpanjangan == '3')
                                                        Pokok + Bunga
                                                    @endif
                                                </td>
                                                <td width="6%">
                                                    @if ($item_tx->status_aktif == '1')
                                                        Aktif
                                                    @elseif($item_tx->status_aktif == '0')
                                                        Tidak Aktif
                                                    @endif
                                                </td>
                                                <td>
                                                    @if ($item_tx->status_aktif == 1)
                                                        <a tid="{{ encrypt($item_tx->id_titipan) }}"
                                                            class="btn btn-default btn-resend-certificate"
                                                            title="Resend Certificate"><i class="fa fa-send"></i></a>
                                                    @endif
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                            <div class="text-center">
                                {{ $transaksi->appends(['date_start' => @$_GET['date_start'], 'date_end' => @$_GET['date_end'], 'start_tempo' => @$_GET['start_tempo'], 'end_tempo' => @$_GET['end_tempo'], 'status' => @$_GET['status'], 'status_maturity' => @$_GET['status_maturity']])->links() }}
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            @include('includes.footer')
        </div>
    </div>
@endsection

@section('scripts')
    <!--<script src="{{ url('js/vendors/datatables.net/js/jquery.dataTables.min.js') }}"></script>
        <script src="{{ url('/js/reporting_transaksi_lakutitipan_list.min.js') }}"></script>-->
    <script>
        var previousStartDate = "{{ @$_GET['start_tempo'] }}";
        var previousEndDate = "{{ @$_GET['end_tempo'] }}";
        $(function() {
            $(".fa-bars").trigger("click");
            $("#table_transaksi").on("click", ".btn-resend-certificate", function() {
                cmp = $(this);
                cmp.hide();
                cmp.parent().append($("<i>").attr({
                    class: "fa fa-spinner fa-spin"
                }));
                tr = $(this).parents("tr");
                $.post("{{ url('reporting/transaksi_lakusimpan/resend_certificate') }}", {
                    id: $(this).attr("tid"),
                    _token: "{{ csrf_token() }}"
                }, function(data) {
                    if (data.err == 0) {
                        alert(data.msg + " ke email " + tr.find("td:nth-child(5)").html() + " [" +
                            data.email + "]");
                        window.location.reload();
                    }
                }, "json").fail(function(data) {
                    alert(data.responseJSON.msg);
                    cmp.parent().find(".fa-spinner").remove();
                    cmp.show();
                });
            });
        });

        function setDateStartMaturity() {
            var start_date_maturity = $('#start_tempo').val();

            if (start_date_maturity) {
                $('#end_tempo').prop('readonly', false);
            } else {
                $('#end_tempo').prop('readonly', true);
            }
        }

        // Code pembatasan 4 bulan
        // document.addEventListener('DOMContentLoaded', function() {
        //     var startTempo = document.getElementById('start_tempo');
        //     var endTempo = document.getElementById('end_tempo');

        //     startTempo.addEventListener('input', function() {
        //         var startDate = new Date(startTempo.value);
        //         var endDate = new Date(startDate);
        //         endDate.setMonth(startDate.getMonth() + 4);

        //         // Format the date to be compatible with the input type 'date'
        //         var formattedEndDate = endDate.toISOString().split('T')[0];

        //         endTempo.setAttribute('max', formattedEndDate);
        //     });
        // });

        // lepas limit batas bulan
        document.addEventListener('DOMContentLoaded', function() {
            var startTempo = document.getElementById('start_tempo');
            var endTempo = document.getElementById('end_tempo');

            startTempo.addEventListener('input', function() {
                // Get the selected start date
                var startDate = new Date(startTempo.value);

                // Remove any previously set maximum date
                endTempo.removeAttribute('max');

                // Optionally, you can set the minimum date for the end date
                // If you want to ensure that the end date is after the start date
                var formattedStartDate = startDate.toISOString().split('T')[0];
                endTempo.setAttribute('min', formattedStartDate);
            });
        });


        function toggleFilterElements() {
            var selectedFilter = $('#filterType').val();

            if (selectedFilter === 'pilihfilter') {
                $('#form_filter input, #form_filter select').prop('disabled', true);
            } else if (selectedFilter === 'rekening') {
                $('#form_filter input, #form_filter select').prop('disabled', false);
                resetDateFormat(); // Reset tanggal
            } else if (selectedFilter === 'maturity') {
                $('#form_filter input, #form_filter select').prop('disabled', true);
                $('#start_tempo').prop('readonly', false);

                // Masukkan kembali nilai-nilai tanggal sebelumnya
                $('#start_tempo').val(previousStartDate);
                $('#end_tempo').val(previousEndDate);
            }
        }



        $(document).ready(function() {
            toggleFilterElements();
        });

        function resetDateFormat() {
            $('#start_tempo, #end_tempo').val('');
            $('#start_tempo, #end_tempo').attr('placeholder', 'dd-mm-yyyy');
        }

        document.addEventListener('DOMContentLoaded', function() {
            // Panggil fungsi saat halaman dimuat
            toggleTransaksiSelect();

            // Tambahkan event listener untuk memantau perubahan pada elemen filterType
            document.getElementById('filterType').addEventListener('change', function() {
                toggleTransaksiSelect();
            });
        });

        function toggleTransaksiSelect() {
            // Dapatkan nilai filterType
            var selectedFilter = document.getElementById('filterType').value;

            // Dapatkan elemen transaksiSelect
            var transaksiSelect = document.getElementById('transaksiSelect');

            var startTempo = document.getElementById('start_tempo');
            var sstatus_maturitytartTempo = document.getElementById('status_maturity');


            // Nonaktifkan elemen transaksiSelect jika filterType bukan "maturity", aktifkan sebaliknya
            transaksiSelect.disabled = (selectedFilter !== 'maturity');
            startTempo.disabled = (selectedFilter !== 'maturity');
            status_maturity.disabled = (selectedFilter !== 'maturity');
            status_maturity.value = (selectedFilter === 'maturity') ? 0 : null;

        }
    </script>
@endsection