@extends('layouts.app')

@section('content')
    <div class="row">
        <div class="card">
            <div class="card-header">
                <div class="d-flex justify-content-between align-items-center">
                    <div class="">
                        <h4>Report: Balance Sheet</h4>
                        <p class="f-m-light mt-1">Page for Balance Sheet</p>
                    </div>
                    <div class="">
                        <form action="{{ route('accounting.report.balance-sheet.export') }}" method="POST">
                            @csrf
                            <input type="hidden" name="start_date" value="{{ request('start_date') }}">
                            <input type="hidden" name="end_date" value="{{ request('end_date') }}">
                            <button type="submit" class="btn btn-success">
                                <i class="bi bi-excel"></i>
                                Export to Excel
                            </button>
                        </form>
                    </div>
                </div>
            </div>
            <div class="card-body">
                <div class="">
                    <form action="{{ route('accounting.report.balance-sheet.index') }}" method="GET">
                        <div class="row g-3">
                            <div class="col-md-3">
                                <label for="start_date" class="form-label">Start Date</label>
                                <input class="form-control" type="date" name="start_date" id="start_date"
                                    value="{{ request('start_date', date('Y-m-01')) }}" required>
                            </div>
                            <div class="col-md-3">
                                <label for="end_date" class="form-label">End Date</label>
                                <input class="form-control" type="date" name="end_date" id="end_date"
                                    value="{{ request('end_date', date('Y-m-t')) }}" required>
                            </div>
                            <div class="col-md-3 align-self-end">
                                <button type="submit" class="btn btn-primary">Filter</button>
                                <a href="{{ route('accounting.report.balance-sheet.index') }}"
                                    class="btn btn-secondary">Reset</a>
                            </div>
                        </div>
                    </form>
                </div>
                <div class="table-responsive theme-scrollbar mt-3">
                    <table class="table table-hover table-bordered table-striped" id="basic-1">
                        <thead>
                            <tr class="bg-light-primary text-dark">
                                <th class="d-none"></th>
                                <th>Account Code</th>
                                {{-- <th>Account Name</th> --}}
                                <th>Opening Balance</th>
                                <th>Total Debit</th>
                                <th>Total Credit</th>
                                <th>Ending Balance</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if (count($data) < 1)
                                <tr>
                                    <td class="text-center" colspan="5">
                                        No data available in table for the selected date range
                                    </td>
                                </tr>
                            @else
                                {{-- Inisialisasi Grand Total --}}
                                @php
                                    $grandTotalOpeningBalance = 0;
                                    $grandTotalDebit = 0;
                                    $grandTotalCredit = 0;
                                    $grandTotalEndingBalance = 0;
                                    $grandTotalEndingActiva = 0;
                                    $grandTotalEndingPasiva = 0;
                                @endphp

                                @foreach ($data as $group => $categories)
                                    {{-- Inisialisasi Total Group --}}
                                    @php
                                        $groupTotalOpeningBalance = 0;
                                        $groupTotalDebit = 0;
                                        $groupTotalCredit = 0;
                                        $groupTotalEndingBalance = 0;
                                    @endphp
                                    <tr>
                                        <td class="d-none"></td>
                                        <td colspan="5">
                                            <strong>Group - {{ $group }}</strong>
                                        </td>
                                    </tr>
                                    @foreach ($categories as $category => $subCategories)
                                        <tr>
                                            <td class="d-none"></td>
                                            <td colspan="5">
                                                <strong>&nbsp;&nbsp;&nbsp;&nbsp;Category - {{ $category }}</strong>
                                            </td>
                                        </tr>
                                        @foreach ($subCategories as $subCategory => $values)
                                            @php
                                                // Tambahkan ke total group
                                                $groupTotalOpeningBalance += $values['opening_balance'];
                                                $groupTotalDebit += $values['debit'];
                                                $groupTotalCredit += $values['credit'];
                                                $groupTotalEndingBalance += $values['ending_balance'];

                                                if ($group === 'ASSETS') {
                                                    $grandTotalEndingActiva += $values['ending_balance'];
                                                } elseif ($group === 'LIABILITIES' || $group === 'EQUITY') {
                                                    $grandTotalEndingPasiva += $values['ending_balance'];
                                                }
                                            @endphp

                                            <tr>
                                                <td class="d-none"></td>
                                                <td>
                                                    <strong>
                                                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sub Category -
                                                        {{ $subCategory }}
                                                    </strong>
                                                </td>
                                                <td class="text-end">
                                                    {{ number_format($values['opening_balance'], 2) }}
                                                </td>
                                                <td class="text-end">{{ number_format($values['debit'], 2) }}</td>
                                                <td class="text-end">{{ number_format($values['credit'], 2) }}</td>
                                                <td class="text-end">
                                                    {{ number_format($values['ending_balance'], 2) }}
                                                </td>
                                            </tr>
                                            {{-- @foreach ($accounts as $item)
                                                @php
                                                    // Tambahkan ke total group
                                                    $groupTotalOpeningBalance += $item['opening_balance'];
                                                    $groupTotalDebit += $item['debit'];
                                                    $groupTotalCredit += $item['credit'];
                                                    $groupTotalEndingBalance += $item['ending_balance'];

                                                    if ($group === 'ASSETS') {
                                                        $grandTotalEndingActiva += $item['ending_balance'];
                                                    } elseif ($group === 'LIABILITIES' || $group === 'EQUITY') {
                                                        $grandTotalEndingPasiva += $item['ending_balance'];
                                                    }
                                                @endphp
                                                <tr>
                                                    <td class="d-none"></td>
                                                    <td>
                                                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $item['account_code'] }}
                                                    </td>
                                                    <td>{{ $item['account_name'] }}</td>
                                                    <td class="text-end">
                                                        {{ number_format($item['opening_balance'], 2) }}
                                                    </td>
                                                    <td class="text-end">{{ number_format($item['debit'], 2) }}</td>
                                                    <td class="text-end">{{ number_format($item['credit'], 2) }}</td>
                                                    <td class="text-end">
                                                        {{ number_format($item['ending_balance'], 2) }}
                                                    </td>
                                                </tr>
                                            @endforeach --}}
                                        @endforeach
                                    @endforeach
                                    {{-- Baris untuk Total Group --}}
                                    <tr class="table-warning">
                                        <td class="d-none"></td>
                                        <td colspan="1" class="text-end">
                                            <strong>Total - {{ $group }}:</strong>
                                        </td>
                                        <td class="text-end">
                                            <strong>{{ number_format($groupTotalOpeningBalance, 2) }}</strong>
                                        </td>
                                        <td class="text-end">
                                            <strong>{{ number_format($groupTotalDebit, 2) }}</strong>
                                        </td>
                                        <td class="text-end">
                                            <strong>{{ number_format($groupTotalCredit, 2) }}</strong>
                                        </td>
                                        <td class="text-end">
                                            <strong>{{ number_format($groupTotalEndingBalance, 2) }}</strong>
                                        </td>
                                    </tr>
                                    @php
                                        // Tambahkan ke Grand Total
                                        $grandTotalOpeningBalance += $groupTotalOpeningBalance;
                                        $grandTotalDebit += $groupTotalDebit;
                                        $grandTotalCredit += $groupTotalCredit;
                                        $grandTotalEndingBalance += $groupTotalEndingBalance;
                                    @endphp
                                @endforeach

                                {{-- Baris untuk Grand Total --}}
                                <tr class="table-danger">
                                    <td class="d-none"></td>
                                    {{-- <td colspan="2" class="text-end">
                                        <h5><strong>BALANCE :</strong></h5>
                                    </td>
                                    <td class="text-end">
                                        <h5><strong>{{ number_format($grandTotalOpeningBalance, 2) }}</strong></h5>
                                    </td>
                                    <td class="text-end">
                                        <h5><strong>{{ number_format($grandTotalDebit, 2) }}</strong></h5>
                                    </td>
                                    <td class="text-end">
                                        <h5><strong>{{ number_format($grandTotalCredit, 2) }}</strong></h5>
                                    </td>
                                    <td class="text-end">
                                        <h5><strong>{{ number_format($grandTotalEndingBalance, 2) }}</strong></h5>
                                    </td> --}}
                                    <td colspan="2" class="text-end">
                                        <h5>
                                            <strong>BALANCE :</strong>
                                        </h5>
                                    </td>
                                    <td class="text-end" colspan="2">
                                        <h5>
                                            <strong>{{ number_format($grandTotalEndingActiva, 2) }}</strong>
                                        </h5>
                                    </td>
                                    <td class="text-end" colspan="2">
                                        <h5>
                                            <strong>{{ number_format($grandTotalEndingPasiva, 2) }}</strong>
                                        </h5>
                                    </td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
@endsection