@extends('layouts.layout')

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

@section('body_content')
<style>
    th {
        vertical-align: middle !important;
        text-align: center;
    }
</style>
    <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">
                        <div class="row">
                            <div class="col-xs-6 col-sm-6 col-md-6">
                                <h2 class="title-dashboard text-left">
                                    <h3><i class="fa fa-cubes"></i> Report Piutang</h3>
                                </h2>
                            </div>
                            <div class="clearfix"></div>
                        </div>
                    </div>
                </div>
                <style>
                    .bottom-align {
                        vertical-align: bottom;
                    }
                </style>

                <div class="row">
                    <div class="col-xs-8 col-sm-8">
                        <div class="x_title">
                            Filter
                        </div>
                        <div class="x_content">
                            <form id="form-search" class="form-horizontal">
                                <div class="col-xs-12 col-sm-12">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-2 control-label">Start Date :</label>
                                        <div class="col-xs-8 col-sm-4">
                                            <input type="date" class="form-control" id="start_date" name="start_date"
                                                value="{{ request('start_date', date('Y-m-01')) }}">
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-2 control-label">End Date :</label>
                                        <div class="col-xs-8 col-sm-4">
                                            <input type="date" class="form-control" id="end_date" name="end_date"
                                                value="{{ request('end_date', date('Y-m-d')) }}">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-2 control-label">Type Cicil :</label>
                                        <div class="col-xs-8 col-sm-4">
                                            <select name="filter" id="filter" class="form-control">
                                                <option value="digital" {{ $request['filter'] == 'digital' ? 'selected' : '' }}>Digital</option>
                                                <option value="fisik" {{ $request['filter'] == 'fisik' ? 'selected' : '' }}>Fisik</option>
                                            </select>
                                        </div>
                                    </div>
                                    {{-- <option value="virtual_account" {{ $request['payment_filter'] == 'virtual_account' ? 'selected' : '' }}>Virtual Account</option>
                                    <option value="transfer" {{ $request['payment_filter'] == 'transfer' ? 'selected' : '' }}>Transfer</option>
                                    <option value="saldo_akun" {{ $request['payment_filter'] == 'saldo_akun' ? 'selected' : '' }}>Saldo Akun</option> --}}



                                    <div class="form-group" style="margin-top:20px">
                                        <label class="col-xs-2 col-sm-2 control-label"></label>
                                        <div class="col-xs-6 col-sm-6">
                                            <button type="submit" class="btn btn-primary btn-search">
                                                <i class="fa fa-search"></i> Search</button>
                                            <button type="button" id="btn-reset" class="btn btn-warning">
                                                <i class= "fa fa-refresh"></i> Reset
                                            </button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-xs-12 col-sm-12">
                            <div class="x_panel">
                                  @php
                                    $saldoAwal = 0;

                                    if(isset($request['filter'])) {
                                        if($request['filter'] == 'fisik') {
                                            $saldoAwal = $saldo_cicil ? $saldo_cicil[0]->saldo_awal_laku_cicil_fisik : 0;
                                        } 
                                        elseif($request['filter'] == 'digital') {
                                            $saldoAwal = $saldo_cicil ? $saldo_cicil[0]->saldo_awal_laku_cicil_digital : 0;
                                        }
                                    }

                                    $runningSaldo = $saldoAwal;
                                    $total_emas = 0;
                                @endphp
                                <div class="row mb-3">
                                    <div class="col-xs-6">
                                        <h4 class="mb-0">
                                            @if ($request['filter'] == 'fisik')
                                                Saldo Awal Fisik :
                                                {{ $saldo_cicil[0]->saldo_awal_laku_cicil_fisik ?? 0 }}
                                            @elseif($request['filter'] == 'digital')
                                                Saldo Awal Digital :
                                                {{ $saldo_cicil[0]->saldo_awal_laku_cicil_digital ?? 0 }}
                                            @else
                                                Saldo Awal :
                                            @endif
                                        </h4>
                                    </div>

                                    <div class="col-xs-6 text-right">
                                        <h4 class="mb-0">
                                            @if ($request['filter'] == 'fisik')
                                                Saldo Akhir Fisik :
                                                {{ number_format($saldoAwal + collect($details)->sum('total_weight_gold'), 4) }}
                                            @elseif($request['filter'] == 'digital')
                                                Saldo Akhir Digital :
                                                {{ number_format($saldoAwal + collect($details)->sum('total_weight_gold'), 4) }}
                                            @else
                                                Saldo Akhir :
                                            @endif
                                        </h4>
                                    </div>
                                </div>
                                <div class="x_content">
                                    <table id="table" class="table table-bordered table-striped table-hover">
                                        <thead>
                                            <tr>
                                                <th class="text-center">Nomor Laku Cicil</th>
                                                <th class="text-center">Nomor Lakuemas</th>
                                                <th class="text-center">Nama</th>
                                                <th class="text-center">type</th>
                                                <th class="text-center">Tanggal Pengajuan</th>
                                                <th class="text-center">Tanggal Jatuh Tempo</th>
                                                <th class="text-center">Status</th>
                                                <th class="text-center">Jumlah Emas</th>
                                                <th class="text-center">Saldo Akhir</th>
                                            </tr>
                                        </thead>
                                        @php
                                            $saldoAwal = 0;
                                            // $reports = [
                                            //     'Digital' => $detail_digital,
                                            //     'Fisik'   => $detail_fisik,
                                            // ];
                                            if(isset($request['filter'])) {
                                                if($request['filter'] == 'fisik') {
                                                    $saldoAwal = $saldo_cicil ? $saldo_cicil[0]->saldo_awal_laku_cicil_fisik : 0;
                                                } 
                                                elseif($request['filter'] == 'digital') {
                                                    $saldoAwal = $saldo_cicil ? $saldo_cicil[0]->saldo_awal_laku_cicil_digital : 0;
                                                }
                                            }
                                            $runningSaldo = $saldoAwal;
                                            $total_emas = 0;
                                        @endphp
                                        {{-- @foreach ($detail_digital as $data) --}}
                                        @foreach ($details as $key => $row)
                                        @php
                                            $runningSaldo += $row->total_weight_gold;
                                            $total_emas += $row->total_weight_gold;
                                        @endphp
                                            <tr>
                                                <td class="text-center">{{ $row->nomor_laku_cicil }}</td>
                                                <td class="text-center">{{ $row->nomor_lakuemas }}</td>
                                                <td class="text-center">{{ $row->nama_customer }}</td>
                                                <td class="text-center">{{ $row->type }}</td>
                                                <td class="text-center">{{ $row->date_transaction }}</td>
                                                <td class="text-center">{{ $row->due_date }}</td>
                                                <td class="text-center">{{ $row->status }}</td>
                                                <td class="text-right">{{ number_format($row->total_weight_gold, 4) }}</td>
                                                <td class="text-right">{{ number_format($runningSaldo, 4) }}</td>
                                            </tr>
                                        @endforeach
                                        <tfoot>
                                            <tr>
                                                <td colspan="7" class="text-right">total</td>
                                                <td class="text-right">{{number_format($total_emas, 4)}}</td>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    {{-- <div class="row">
                        <div class="col-xs-3 col-sm-3">
                            <div class="x_panel">
                                <div class="x_content">
                                    @if ($request['filter'] == 'fisik')
                                    <h4>Saldo Akhir Fisik : {{number_format($runningSaldo,4)}}</h4>    
                                    @elseif($request['filter'] == 'digital')
                                        <h4>Saldo Akhir Digital : {{number_format($runningSaldo,4)}}</h4>    
                                    @else
                                        <h4>Saldo Akhir : 0</h4>    
                                    @endif
                                </div>
                            </div>
                        </div>
                    </div> --}}
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="rekap_modal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog modal-lg" style="width: 80%;" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="rekap_lakusimpan"><i class="fa fa-cubes"></i> Mutasi Lakusimpan <b>(<span
                                id="item_name">XXX</span>)</b> <a id="download-excel" href="#" style="float: right;">
                        </a></h5>
                </div>

                <div>
                    <div class="x_panel">
                        <div class="x_content" id="rekap_detail_lakusimpan">
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    {{-- <script>
        function detailStock(periode, tipe) {
            let start_date, end_date;
            let today = new Date();
            let currentYear = today.getFullYear();
            let currentMonth = (today.getMonth() + 1).toString().padStart(2, "0");
            let currentDate = today.getDate().toString().padStart(2, "0");

            if (periode) {
                let parts = periode.split("-");
                let year = parts[0];
                let month = parts[1].padStart(2, "0");

                start_date = `${year}-${month}-01 00:00:00`;

                if (year == currentYear && month == currentMonth) {
                    start_date = `${year}-${month}-01 00:00:00`;
                    end_date = $('#end_date').val() + " 23:59:59";
                } else {
                    let lastDay = new Date(year, month, 0).getDate();
                    end_date = `${year}-${month}-${lastDay} 23:59:59`;
                }
            } else {
                start_date = `${year}-${month}-01 00:00:00`;
                end_date = $('#end_date').val() + " 23:59:59";
            }

            console.log("Start Date:", start_date);
            console.log("End Date:", end_date);

            $('#cover-spin').show();
            $.ajax({
                url: "{{ url('rekap_lakusimpan_detail') }}",
                method: "POST",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                data: {
                    'start_date': start_date,
                    'end_date': end_date,
                    'periode': periode,
                    'tipe': tipe
                },
                success: function(response) {
                    $('#rekap_detail_lakusimpan').html(response);
                    $('#item_name').html(periode);
                    $('#rekap_modal').modal('show');
                    $('#cover-spin').hide();
                },
                error: function(response) {
                    var response = response.responseJSON;
                    alert(response.error);
                    $('#cover-spin').hide();
                }
            });
        }
    </script> --}}

@endsection