@extends('printlayout')
@section('content')

    <div class="row invoice-box">
        <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12 ">
            <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12 text-center ">
                <h1 style="font-size:26px;">
                    {{ __('sitelabel.StoreExpenseDetailReport') }}
                </h1>
            </div>
            <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12 text-center ">
                <span style="font-size:16px; padding:10px;"><strong>{{ __('sitelabel.StartDate') }}: </strong></span>
                <span style="padding:10px;">
                    {{ \Carbon\Carbon::parse(request('txtStartDate'))->format('d-F-Y') }}
                </span>
                <span style="font-size:16px; padding:10px;"><strong>{{ __('sitelabel.EndDate') }}: </strong></span>
                <span style="padding:10px;">
                    {{ \Carbon\Carbon::parse(request('txtEndDate'))->format('d-F-Y') }}
                </span>
            </div>
        </div>
    </div>

    <div class="row table-row">
        <table class="table table-striped">
            <thead>
                <tr>
                    <th class="text-center" style="width:5%">{{ __('sitelabel.SerialNumber') }}</th>
                    <th class="text-left" style="width:20%">{{ __('sitelabel.ExpenseDate') }}</th>
                    <th class="text-left" style="width:20%">{{ __('sitelabel.RefNo') }}</th>
                    <th class="text-left" style="width:25%">{{ __('sitelabel.Description') }}</th>
                    <th class="text-right" style="width:10%">{{ __('sitelabel.Amount') }}</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $grandTotal = 0;
                @endphp

                @foreach ($groupedExpenses as $expenseId => $group)
                    @php
                        $grandTotal += $group['TotalAmount'];
                    @endphp
                    <!-- Expense Group Header -->
                    <tr>
                        <td colspan="6">
                            <strong>{{ __('sitelabel.ExpenseName') }}: </strong>{{ $group['Name'] }}
                        </td>
                    </tr>

                    <!-- Expense Group Details -->
                    @foreach ($group['Details'] as $detail)
                        <tr>
                            <td class="text-center">{{ $loop->iteration }}</td>
                            <td class="text-left">{{ $detail->FormattedExpenseDate }}</td>
                            <td class="text-left">{{ $detail->RefNo }}</td>
                            <td class="text-left">{{ $detail->Description }}</td>
                            <td class="text-right">{{ number_format($detail->Amount, 2) }}</td>
                        </tr>
                    @endforeach

                    <!-- Total Amount for Current ExpenseId -->
                    <tr>
                        <td colspan="4" class="text-right font-weight-bold">{{ __('sitelabel.Total') }}</td>
                        <td class="text-right font-weight-bold">{{ number_format($group['TotalAmount'], 2) }}</td>
                    </tr>
                    <tr>
                        <td colspan="5"></td>
                    </tr>
                @endforeach

                <!-- Grand Total -->
                <tr>
                    <td colspan="4" class="text-right font-weight-bold">{{ __('sitelabel.GrandTotal') }}</td>
                    <td class="text-right font-weight-bold">{{ number_format($grandTotal, 2) }}</td>
                </tr>
            </tbody>
        </table>
    </div>

    @include('sign-subview.signandbuttons')
@endsection