@php
    use App\Models\FMS\PPACodes;
    $ppaCodes = PPACodes::query()->get();

    $item = $data;

@endphp

<style>
    table {
        border-collapse: collapse;
        font-family: Calibri, sans-serif;
        width: 100%;
    }
    @page {
        margin-top:5%;
        margin-right: 2%;
        margin-left: 2%;
        margin-bottom: 2%;
        font-family: "Courier New", Courier, "Lucida Sans Typewriter", "Lucida Typewriter", monospace; font-size: 10px; font-style: normal; font-variant: normal; font-weight: 700;
    }
</style>

<div class="content">
    <table border="1">
        <thead>
            <tr>
                <th>
                Account Title
                </th>
                <th>
                Account code
                </th>
                <th>
                GASS
                </th>
                <th>
                STO
                </th>
                <th>
                Higher Education
                </th>
                <th>
                Advance Education
                </th>
                <th>
                Research
                </th>
                <th>
                Extension
                </th>
                <th>
                Total
                </th>
            </tr>
        </thead>
        <tbody>
            @php
            foreach ($item as $key => $value) {
                $total = 0;
            @endphp
            <tr>
                <td>
                    {{ $value['title'] }} 
                </td>
                <td>
                    {{ $value['accountCode'] }} 
                    
                </td>
                @foreach($ppaCodes as $ppa)
                    @php

                        $index = preg_replace('/\s+/', '',$ppa->desc);
                    @endphp
                    @foreach($value['amount'] as $amountkey => $amountValue)
                        @if($amountkey == $index)
                            <td>{{$value['amount'][$amountkey]['total']}}</td>
                            @php
                            $total += $value['amount'][$amountkey]['total'];
                        @endphp
                        @endif
                    @endforeach
                @endforeach
                <td>{{$total}}</td>
            </tr>
                @php
                if(count($value['children']) > 0){
                    foreach ($value['children'] as $i => $v) {
                @endphp
                <tr>
                    <td style="padding-left: 2%">
                        {{ $v['title'] }} 
                    </td>
                    <td>
                        {{ $v['accountCode'] }} 
                    </td>
                    @foreach($ppaCodes as $ppa)
                    @php
                        $index = preg_replace('/\s+/', '',$ppa->desc);
                    @endphp
                    @foreach($value['amount'] as $amountkey => $amountValue)
                        @if($amountkey == $index)
                            <td>{{$value['amount'][$amountkey]['total']}}</td>
                            @php
                                $total += $value['amount'][$amountkey]['total'];
                            @endphp
                        @endif
                    @endforeach
                @endforeach
                <td>{{$total}}</td>
                </tr>
            @php
            }}}
            @endphp
        </tbody>
    </table>
</div>