@extends('layouts.layout')
@section('css')
@endsection
@section('body_class', 'nav-md')
@section('body_content')
<style>
.dataTables_wrapper .dataTables_paginate a {
    cursor: default !important;
}
</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">
                    <h3>Saldo Akun</i> Transaction</h3>
                </div>
                <div class="clearfix"></div>
            </div>
            {{-- 
            <div class="row">     
                <div class="col-xs-12 col-md-12">
                    <div class="x_panel">                        
                        <div class="x_content">
                            <div class="row">
                                <div class="col-sm-2">
                                    <div style="border: 1px solid #000; padding: 5px; text-align: center; min-height: 90px;">
                                        <h4 style="border-bottom: 1px dashed #000; padding-bottom: 5px;">Saldo Awal</h4>
                                        <span style="font-size: 13px; font-weight: bold;">Rp </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <div style="border: 1px solid #000; padding: 5px; text-align: center; min-height: 90px;">
                                        <h4 style="border-bottom: 1px dashed #000; padding-bottom: 5px;">Saldo Masuk</h4>
                                        <span style="font-size: 13px; font-weight: bold;">Rp </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <div style="border: 1px solid #000; padding: 5px; text-align: center; min-height: 90px;">
                                        <h4 style="border-bottom: 1px dashed #000; padding-bottom: 5px;">Bunga BBX</h4>
                                        <span style="font-size: 13px; font-weight: bold;">Rp </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <div style="border: 1px solid #000; padding: 5px; text-align: center; min-height: 90px;">
                                        <h4 style="border-bottom: 1px dashed #000; padding-bottom: 5px;">Penyesuaian</h4>
                                        <span style="font-size: 13px; font-weight: bold;">Rp. 000</span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <div style="border: 1px solid #000; padding: 5px; text-align: center; min-height: 90px;">
                                        <h4 style="border-bottom: 1px dashed #000; padding-bottom: 5px;">Saldo Keluar</h4>
                                        <span style="font-size: 13px; font-weight: bold;">Rp. </span>
                                    </div>
                                </div>
                                <div class="col-sm-2">
                                    <div style="border: 1px solid #000; padding: 5px; text-align: center; min-height: 90px;">
                                        <h4 style="border-bottom: 1px dashed #000; padding-bottom: 5px;">Saldo Akhir</h4>
                                        <span style="font-size: 13px; font-weight: bold;">Rp </span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
             --}}

            <div class="row">     
                <div class="col-xs-12 col-md-12">
                    <div class="x_panel">                        
                        <div class="x_content">
							<h4 style="margin: 0px;"><b><center>FILTER</center></b><hr style="border: 1px dashed #ccc;"></h4>
                            <form class="form-horizontal">
                                <div class="col-xs-12 col-sm-6">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Date From :</label>
                                        <div class="col-xs-12 col-sm-8">
                                            <input type="date" class="form-control" name="date_from" id="date_from" value="{{ $request['date_from'] }}" placeholder="Tanggal Mulai">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Date To :</label>
                                        <div class="col-xs-12 col-sm-8">
                                            <input type="date" class="form-control" name="date_to" id="date_to" value="{{ $request['date_to'] ? $request['date_to'] : now()->toDateString() }}" placeholder="Tanggal Akhir">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-xs-12 col-sm-6">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Tipe Transaksi :</label>
                                        <div class="col-xs-12 col-sm-8">
                                            <select name="transaction_type" id="transaction_type" class="form-control">
                                                <option value="all" {{ $request['transaction_type'] == 'all' ? 'selected' : '' }}>All</option>
                                                @foreach ($type_transaksi as $transaksi)
                                                    <option value="{{ $transaksi->id }}" {{ $request['transaction_type'] == $transaksi->id ? 'selected' : '' }}>
                                                        {{ $transaksi->type_name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Search :</label>
                                        <div class="col-xs-12 col-sm-8">
                                            <input type="text" class="form-control" name="search" id="search" value="{{ $request['search'] ?? '' }}" placeholder="Search">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-xs-12 text-center">
									<div class="col-xs-12 text-center">
                                        <hr style="border: 1px dashed #ccc;">
                                        <button type="submit" class="btn btn-success">Search</button>
                                        @if ($download_ready)
                                            @if ($download_ready->status == '0')
                                                <button class="btn btn-warning" id="prosess" disabled>
                                                    <i class="fa fa-pulse fa-clock-o"></i> Sedang mendownload file
                                                </button>
                                            @else
                                                <a href="{{ route('saldo_akun_reguler_download',[
                                                    'date_from' => $request['date_from'],
                                                    'date_to' => $request['date_to'],
                                                    'transaction_type' => $request['transaction_type'],
                                                    'search' => $request['search'],
                                                    ]) }}" class="btn btn-primary">
                                                    <i class="fa fa-download"></i> Download
                                                </a>
                                            @endif
										@else
											<a href="{{ route('saldo_akun_reguler_download',[
												'date_from' => $request['date_from'],
												'date_to' => $request['date_to'],
												'transaction_type' => $request['transaction_type'],
												'search' => $request['search'],
												]) }}" class="btn btn-primary">
												<i class="fa fa-download"></i> Download
											</a>
                                        @endif
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="form-group">
                                <p>
                                    <a class="btn btn-success" data-toggle="collapse" href="#collapseExample" role="button"
                                        aria-expanded="false" aria-controls="collapseExample">
                                        Log Download
                                    </a>
                                </p>
                                <div class="collapse" id="collapseExample">
                                    <div class="card card-body">
                                        <table id="myTable" class="table table-bordered table-striped"
                                            style="zoom: 0.75;">
                                            <thead>
                                                <tr>
                                                    <th class="text-center">Tanggal</th>
                                                    <th class="text-center">Nama</th>
                                                    <th class="text-center">File Name</th>
                                                    <th class="text-center">Status</th>
                                                    <th class="text-center">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody id="load_summary_customer">
                                                @foreach ($download_file as $data)
                                                    <tr>
                                                        <td class="text-left">{{ $data->created_at }}</td>
                                                        <td class="text-left">
                                                            {{ $data->users->name }}
                                                            <div>
                                                                <small>({{ $data->users->username }})</small>
                                                            </div>
                                                        </td>
                                                        <td class="text-left">{{ $data->file_name }}</td>
                                                        <td class="text-left">
                                                            @if ($data->status == '1')
                                                                Berhasil
                                                            @elseif ($data->status == '2')
                                                                <span class="text-danger"><i>Gagal, load data tinggi</i></span>
                                                            @endif
                                                        </td>
                                                        <td class="text-left">
                                                            @if ($data->status == '1')
                                                                @php
                                                                    $hasDownloadReady = true;
                                                                @endphp

                                                                <a href="{{ route('saldo_akun_reguler_download_ready_file', [
                                                                    'name' => $data->file_name,
                                                                ]) }}"
                                                                    target="_blank" class="btn btn-success"
                                                                    id="btn_ready_download" onclick="downloadReadyFile()"
                                                                    style="display: ;"><i class="fa fa fa-check"></i>
                                                                    Download File
                                                                </a>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">            
                        <div class="x_content" style="overflow: auto; zoom: 0.9;">
                            <table class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th class="text-center">Tanggal</th>
                                        <th class="text-center">Kode Transaksi</th>
                                        <th class="text-center">Kode Customer</th>
                                        <th class="text-center">Customer</th>
                                        <th class="text-center">Rekening</th>
                                        <th class="text-center">Nominal</th>
                                        <th class="text-center">Saldo Akhir</th>
                                        <th class="text-center">Tipe Transaksi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($saldo_transactions as $saldo_transaction)
                                    @php
                                        $wallet_customer = $saldo_transaction->wallet;
                                        $customer = $wallet_customer->customer;
                                        $tabungan = $wallet_customer->customer->tabungan->first();
                                    @endphp
                                        <tr>
                                            <td class="text-center">{{ $saldo_transaction->created_at }}</td>
                                            <td class="text-center">{{ $saldo_transaction->code }}</td>
                                            <td class="text-center">{{ $customer->code }}</td>
                                            @php
                                                $original = strtolower($customer->name); 
                                                $words = explode(' ', $original);
                                                $maskedWords = [];

                                                foreach ($words as $index => $word) {
                                                    $len = strlen($word);

                                                    if ($len <= 2) {
                                                        $maskedWords[] = $word; 
                                                    } else {
                                                        if ($index === 0) {
                                                            $firstChar = strtoupper(substr($word, 0, 1)); 
                                                            $masked = $firstChar . str_repeat('*', $len - 1);
                                                            $maskedWords[] = $masked;
                                                        } else {
                                                            $lastChar = substr($word, -1);
                                                            $masked = str_repeat('*', $len - 1) . $lastChar;
                                                            $maskedWords[] = $masked;
                                                        }
                                                    }
                                                }
                                                $maskedName = implode(' ', $maskedWords);
                                            @endphp
                                                <td class="text-center">{{ $maskedName }}<br>{{ \Carbon\Carbon::parse($customer->created_at)->format('d/m/Y')}}</td>
                                            <td class="text-center">{{ $tabungan->nomor_rekening ?? '-'}}</td>
                                            <td class="text-center">{{ number_format($saldo_transaction->nominal,2) }}<br>
                                                @if(in_array($saldo_transaction->type, [2, 11, 13]))
                                                    DB
                                                @elseif(in_array($saldo_transaction->type, [5, 7, 12]))
                                                    CR
                                                @endif
                                            </td>
                                            <td class="text-center">
                                                {{ $saldo_transaction->saldo_akhir ? number_format($saldo_transaction->saldo_akhir, 2, ',', '.') : '-' }}
                                            </td>
                                            <td class="text-center">{{ $saldo_transaction->transaksi_type->type_name}}</td>
                                        </tr>
                                    @empty
                                       <tr>
                                            <td colspan="10" class="text-center">No Data</td>
                                       </tr> 
                                    @endforelse
                                </tbody>
                            </table>
                            <div style="text-align:center">{{ $saldo_transactions->appends($_GET)->links() }}</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <input type="hidden" id="is_downloaded" value="0">

@endsection
@section('scripts')
    <script>
        $(document).ready(function() {
            $('#myTable').DataTable({
                searching: false,
                lengthChange: false,
                pageLength: 5,
                order: [
                    [0, 'desc']
                ]
            });
        });
         $(document).ready(function() {
            @if ($download_ready)
                @if ($download_ready->status == '0')
                    setInterval(() => {
                        var is_downloaded = $('#is_downloaded').val();
                        if (is_downloaded == '0') {
                            check_download_proceess({{ $download_ready->id }});
                        }
                    }, 5000);
                @endif
            @endif
        });
        function check_download_proceess(id) {
            $.ajax({
                url: "{{ url('saldo_akun/transaksi_saldo_akun_reguler/check_download_process') }}/" + id,
                method: "GET",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
            }).done(function(response) {
                if (response.status == "completed") {
                    $('#is_downloaded').val(1);
                    $('#file_download').show();
                    $('#prosess').hide();

                    alert("Proses Download Anda Selesai")
                    location.reload();
                }
            });
            return false;
        }
    </script>
@endsection