@php
    if(isset($_GET['checkRecords'])){
        $getRecord = "on";
    }else{
        $getRecord = "off";
    }
    $grand_total_debit = 0;
    $grand_total_credit = 0; 
@endphp
<table>
    <tbody>
    @php
        $grand_total_debit = 0;
        $grand_total_credit = 0;
        $allData = $data; 
    
        foreach($data as $groupKey => $groupData){
            $group_total_debit =0;
            $group_total_credit = 0;
            foreach($groupData["accounts"] as $key => $account){
                $total_debit = 0;
                $total_credit = 0;
                $total_balance = 0;
                if(count($account["ledgers"])>1){
                foreach ($account["ledgers"] as $ledgersKey => $ledgers){
                    $total_debit = $total_debit+(float)$ledgers->debit;
                    $total_credit = $total_credit+(float)$ledgers->credit;
                    $total_balance = (float)$ledgers->balance;
                }

                }
                $group_total_debit = $group_total_debit+(float)$total_debit;
                $group_total_credit = $group_total_credit+(float)$total_credit;
                $data[$groupKey]["group_total_debit"] = $group_total_debit;
                $data[$groupKey]["group_total_credit"] = $group_total_credit;

        }
            
        }
    @endphp
    @foreach($data as $groupKey => $groupData)
        @if(count($groupData["accounts"])>1)
            @if($data[$groupKey]["group_total_debit"] > 0 || $data[$groupKey]["group_total_credit"] > 0)
                <tr>
                    <td colspan="6" style="font-weight:bold;">{{ $groupData["groupname"] }}</td>
                </tr>
            @else
                @if($getRecord != 'on')
                    <tr>
                        <td colspan="6" style="font-weight:bold;">{{ $groupData["groupname"] }}</td>
                    </tr>
                @endif
            @endif
            @php
                $group_total_debit = 0;
                $group_total_credit = 0;
            @endphp
            @foreach($groupData["accounts"] as $key => $account)
                
                @if(count($account["ledgers"])>1)
                <tr>
                    <td colspan="3" style="font-weight:bold;">{{ $account["accounttitle"] }}</td>
                    <td style="font-weight:bold;">Debit</td>
                    <td style="font-weight:bold;">Credit</td>
                    <td style="font-weight:bold;">Balance</td>
                </tr>
                @else
                    @if($getRecord != 'on')
                    <tr>
                        <td colspan="5" style="font-weight:bold;">{{ $account["accounttitle"] }}</td>
                        <td>{{ number_format($account["ledgers"][0]->balance,2) }}</td>
                        </tr>  
                    @endif
                @endif

                
                    @php
                        $total_debit = 0;
                        $total_credit = 0;
                        $total_balance = 0;
                    @endphp
                @if(count($account["ledgers"])>1)
                    <tr>
                        <td colspan="5" style="font-weight:bold;">Opening Balance</td>
                        <td>{{ number_format($account["ledgers"][0]->balance,2) }}</td>
                    </tr>
                    @foreach ($account["ledgers"] as $ledgersKey => $ledgers)
                        @php
                        $start_date = $_GET['start_date'];
                        if($ledgers->voucher_date > $start_date){
                            $total_debit = $total_debit+(float)$ledgers->debit;
                            $total_credit = $total_credit+(float)$ledgers->credit;
                        }
                            $total_balance = (float)$ledgers->balance;
                        @endphp
                        @if($ledgersKey>0)
                            <tr>
                                <td>{{ $ledgers->voucher_number }}</td>
                                <td>{{ $ledgers->voucher_date }}</td>
                                <td>{{ $ledgers->detail_remarks }}</td>
                                <td>{{ number_format($ledgers->debit,2) == 0 ? '-' : number_format($ledgers->debit,2)  }}</td>
                                <td>{{ number_format($ledgers->credit,2) == 0 ? '-' : number_format($ledgers->credit,2)  }}</td>
                                <td>{{ number_format($ledgers->balance,2) }}</td>
                            </tr>
                        @endif
                    @endforeach
                @endif
                @if($total_balance != 0 && $getRecord != 'on')
                <tr>
                    <td colspan="3">Total</td>
                    @if($total_debit > 0)
                        <td>{{ number_format($total_debit,2) }}</td>
                    @else
                        <td></td>
                    @endif
                    @if($total_credit > 0)
                        <td>{{ number_format($total_credit,2) }}</td>
                    @else
                        <td></td>
                    @endif
                    <td>{{ number_format($total_balance,2) }}</td>
                </tr>
                @else
                @endif
                @php
                    $group_total_debit = $group_total_debit+(float)$total_debit;
                    $group_total_credit = $group_total_credit+(float)$total_credit;
                @endphp
            @endforeach
            @if($group_total_debit == 0 && $group_total_credit == 0 && $getRecord != 'on')
            <tr>
                <td colspan="3">Group Total</td>
                    <td>{{ number_format($group_total_debit,2) }}</td>
                
                    <td>{{ number_format($group_total_credit,2) }}</td>
                
                <td></td>
            </tr>
            @else
            @endif
            @php
                $grand_total_debit = $grand_total_debit+(float)$group_total_debit;
                $grand_total_credit = $grand_total_credit+(float)$group_total_credit;
            @endphp
            @endif
    @endforeach
    <tr>
        <td colspan="3">Grand Total</td>
            <td>{{ number_format($grand_total_debit,2) }}</td>
        
            <td>{{ number_format($grand_total_credit,2) }}</td>
        
        <td></td>
    </tr>       
        
    </tbody>
</table>