@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: Profit and Loss</h4>
                        <p class="f-m-light mt-1">Page for Profit and Loss</p>
                    </div>
                    <div class="d-flex align-items-center gap-2">
                        <form action="{{ route('accounting.report.profit-loss.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>
                        <button type="button" class="btn btn-secondary" onclick="window.print()">
                            <i class="bi bi-printer"></i>
                            Print
                        </button>
                    </div>
                </div>
            </div>
            <div class="card-body">
                <div class="">
                    <form action="{{ route('accounting.report.profit-loss.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.profit-loss.index') }}"
                                    class="btn btn-secondary">Reset</a>
                            </div>
                        </div>
                    </form>
                </div>
                <div class="table-responsive theme-scrollbar mt-3">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <div class="date-range-data">
                            <strong>Date range:</strong>
                            {{ request('start_date', date('Y-m-01')) }}
                            to
                            {{ request('end_date', date('Y-m-t')) }}
                        </div>
                        <div class="d-none d-print-block">
                            <small><i>Printed at: {{ now()->format('l, d F Y, H:i:s') }}</i></small>
                        </div>
                    </div>
                    <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>Total Debit</th>
                                <th>Total Credit</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if (count($data) < 1)
                                <tr>
                                    <td class="text-center" colspan="4">
                                        No data available in table for the selected date
                                        range
                                    </td>
                                </tr>
                            @else
                                @if (count($data) < 1)
                                    <tr>
                                        <td class="text-center" colspan="4">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;
                                    @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="4">
                                                <strong>Group - {{ $group }}</strong>
                                            </td>
                                        </tr>
                                        @foreach ($categories as $category => $subCategories)
                                            <tr>
                                                <td class="d-none"></td>
                                                <td colspan="4">
                                                    <strong>&nbsp;&nbsp;&nbsp;&nbsp;Category - {{ $category }}</strong>
                                                </td>
                                            </tr>
                                            @foreach ($subCategories as $subCategory => $accounts)
                                                <tr>
                                                    <td class="d-none"></td>
                                                    <td colspan="4">
                                                        <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sub Category
                                                            -
                                                            {{ $subCategory }}</strong>
                                                    </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'];
                                                    @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['debit'], 2) }}
                                                        </td>
                                                        <td class="text-end">
                                                            {{ number_format($item['credit'], 2) }}
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            @endforeach
                                        @endforeach
                                        {{-- Baris untuk Total Group --}}
                                        <tr class="table-warning">
                                            <td class="d-none"></td>
                                            <td colspan="2" class="text-end">
                                                <strong>Total - {{ $group }}:</strong>
                                            </td>
                                            <td class="text-end"><strong>{{ number_format($groupTotalDebit, 2) }}</strong>
                                            </td>
                                            <td class="text-end"><strong>{{ number_format($groupTotalCredit, 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>Profit Loss :</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>
                                    </tr>

                                    <tr class="table-danger">
                                        <td class="d-none"></td>
                                        <td colspan="2" class="text-end">
                                            @if ($grandTotalDebit > $grandTotalCredit)
                                                <h5><strong>Loss :</strong></h5>
                                            @else
                                                <h5><strong>Profit :</strong></h5>
                                            @endif
                                        </td>
                                        <td class="text-end">
                                            @if ($grandTotalDebit > $grandTotalCredit)
                                                <h5><strong>{{ number_format($grandTotalCredit - $grandTotalDebit, 2) }}</strong>
                                                </h5>
                                            @endif
                                        </td>
                                        <td class="text-end">
                                            @if ($grandTotalDebit < $grandTotalCredit)
                                                <h5><strong>{{ number_format($grandTotalCredit - $grandTotalDebit, 2) }}</strong>
                                                </h5>
                                            @endif
                                        </td>
                                    </tr>
                                @endif
                            @endif
                        </tbody>
                    </table>
                </div>
                <style>
                    .date-range-data {
                        display: none;
                    }

                    @media print {

                        /* Hide interactive controls when printing */
                        .btn,
                        form {
                            display: none !important;
                        }

                        .date-range-data {
                            display: block !important;
                            margin-bottom: 10px;
                        }

                        /* Ensure table prints with borders */
                        .table {
                            border-collapse: collapse !important;
                            width: 100% !important;
                        }

                        .table th,
                        .table td {
                            border: 1px solid #000 !important;
                            padding: 6px !important;
                        }
                    }
                </style>
            </div>
        </div>
    </div>
@endsection

@section('js')
@endsection