@php
    $company = DB::table('gnr_company')->first();
    $cashLedger = DB::table('acc_account_ledger')->where('accountTypeId', 4)->where('isGroupHead', 0)->where('status', 1)->first();
@endphp
<table>
    <thead>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>{{ $company->name }}</b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>{{ $company->address }}</b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>Receipt Payment Statement</b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>Project :  {{ $headInfo['project']}}</b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>Project Type : {{ $headInfo['projectType']}}</b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>Branch : {{ $headInfo['branch']}}</b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>Voucher Type: {{ $headInfo['cashType'] == 'cash' ? 'Cash' : 'Non Cash' }} </b>
            </th>
        </tr>
        <tr>
            <th  colspan="5" style="text-align: center; font-weight: bold;">
                <b>Report On : {{ $headInfo['dateTo'] }}</b>
            </th>
        </tr>
        <tr>
            <th width="100px"><strong>ID</strong></th>
            <th width="350px"><strong>LEDGER</strong></th>
            <th width="100px"><strong>LEDGER CODES</strong></th>
            <th width="200px"><strong>CREDIT/RECEIPT</strong></th>
            <th width="200px"><strong>DEBIT/PAYMENT</strong></th>
        </tr>
    </thead>

    <tbody id="table-body">
        @foreach ($ledgerData as $ledger)
            @if ($ledger['isGroupHead'] == 0)
                <tr>
                    <td style="mso-number-format:\@">{{ $ledger['id'] }}</td>
                    <td>{{ $ledger['name'] }}</td>
                    <td style="mso-number-format:\@">{{ $ledger['code'] }}</td>
                    <td style="mso-number-format:\@">{{ $ledger['receipt_column_2'] }}</td>
                    <td style="mso-number-format:\@">{{ $ledger['payment_column_2'] }}</td>
                    {{-- <td class="amount">{{ number_format($ledger['receipt_column_2']) }}</td>
                    <td class="amount">{{ number_format($ledger['payment_column_2']) }}</td> --}}
                </tr>
            @endif
        @endforeach
        @if ($cashLedger)
            <tr>
                <td style="mso-number-format:\@">{{ $cashLedger->id }}</td>
                <td>{{ $cashLedger->name }}</td>
                <td style="mso-number-format:\@">{{ $cashLedger->code }}</td>
                <td style="mso-number-format:\@">0</td>
                <td style="mso-number-format:\@">{{ $headInfo['closingBalance'] }}</td>
            </tr>
        @endif
    </tbody>
</table>