@extends('layouts.app')
@section('content')
<div class="flex items-center flex-wrap justify-between gap20 mb-30">
    <h3>SOA</h3>
</div>
<div class="wg-box">
    <div class="flex flex-column justify-content-center text-center">
        <h3>Request Transaction History</h3>
        <br>
        <div class="body-title text-muted">{{$filters["from"]??""}} - {{$filters["to"]??""}}</div>
    </div>

   <div class="wg-table table-all-user">
        <!-- Table Header -->
        <ul class="table-title flex gap20 mb-14">
            <li><div class="body-title">Date</div></li>
            <li><div class="body-title">Time</div></li>
            <li><div class="body-title">Reference No.</div></li>
            <li><div class="body-title">Description</div></li>
            <li><div class="body-title">Debit</div></li>
            <li><div class="body-title">Credit</div></li>
            <li><div class="body-title text-end">Balance</div></li>
        </ul>

        <!-- Starting Balance -->
        @php
            $first = $soa_query->first();
            if ($first) {
                if ($first->type === 'CREDIT') {
                    $starting_balance = $first->balance - $first->amount;
                } elseif ($first->type === 'DEBIT') {
                    $starting_balance = $first->balance + $first->amount;
                } else {
                    $starting_balance = $first->balance ?? 0;
                }
            } else {
                $starting_balance = 0;
            }
        @endphp

        <ul class="table-title flex gap20 mb-14">
            <li><div class="body-title"></div></li>
            <li><div class="body-title"></div></li>
            <li><div class="body-title"></div></li>
            <li><div class="body-title">STARTING BALANCE</div></li>
            <li><div class="body-title"></div></li>
            <li><div class="body-title"></div></li>
            <li><div class="body-title text-end">₱{{ number_format($starting_balance, 2) }}</div></li>
        </ul>

        <!-- Transactions -->
        <ul class="flex flex-column">
            @php
                $total_debit = 0;
                $total_credit = 0;
            @endphp

            @foreach($soa_query as $soa)
                @php
                    if ($soa->type === 'DEBIT') $total_debit += $soa->amount;
                    if ($soa->type === 'CREDIT') $total_credit += $soa->amount;
                @endphp
                <li class="wg-product item-row">
                    <div class="body-text">{{ date('M d, Y', strtotime($soa->created_at)) }}</div>
                    <div class="body-text">{{ date('h:i A', strtotime($soa->created_at)) }}</div>
                    <div class="body-text">{{ $soa->reference }}</div>
                    <div class="body-text">{{ $soa->description }}</div>
                    <div class="body-text">
                        @if($soa->type === 'DEBIT')
                            ₱{{ number_format($soa->amount, 2) }}
                        @endif
                    </div>
                    <div class="body-text">
                        @if($soa->type === 'CREDIT')
                            ₱{{ number_format($soa->amount, 2) }}
                        @endif
                    </div>
                    <div class="body-text text-end">₱{{ number_format($soa->balance, 2) }}</div>
                </li>
            @endforeach
        </ul>

        <!-- Totals -->
        <ul class="flex flex-column" style="margin-top: 15px;">
            <li class="wg-product item-row">
                <div class="body-text"></div>
                <div class="body-text"></div>
                <div class="body-text"></div>
                <div class="body-text">TOTAL DEBIT</div>
                <div class="body-text">₱{{ number_format($total_debit, 2) }}</div>
                <div class="body-text"></div>
                <div class="body-text text-end"></div>
            </li>
        </ul>

        <ul class="flex flex-column">
            <li class="wg-product item-row">
                <div class="body-text"></div>
                <div class="body-text"></div>
                <div class="body-text"></div>
                <div class="body-text">TOTAL CREDIT</div>
                <div class="body-text"></div>
                <div class="body-text">₱{{ number_format($total_credit, 2) }}</div>
                <div class="body-text text-end"></div>
            </li>
        </ul>

        <!-- Ending Balance -->
        @php
            $ending_balance = $soa_query->last()->balance ?? 0;
        @endphp

        <ul class="flex flex-column">
            <li class="wg-product item-row">
                <div class="body-text"></div>
                <div class="body-text"></div>
                <div class="body-text"></div>
                <div class="body-text fw-bold">ENDING BALANCE</div>
                <div class="body-text"></div>
                <div class="body-text fw-bold"></div>
                <div class="body-text text-end fw-bold">₱{{ number_format($ending_balance, 2) }}</div>
            </li>
        </ul>
    </div>

</div>
<!-- /all-user -->
@endsection
@section('page_script')
@parent
<script>
    $(".soa").addClass("active");
</script>
@endsection
<!-- App js -->