@foreach($clientledgerData as $clientledger) @php $billAmount = ''; @endphp @if($clientledger->type == 'bill' && $clientledger->description == 'Opening Balance') @elseif($clientledger->type == 'bill') @elseif($clientledger->type == 'cargo_bill') @elseif($clientledger->type == 'income') @endif @if($clientledger->type == 'bill' || $clientledger->type == 'cargo_bill') @php $billAmount = $clientledger->amount; @endphp @php $total_dr_amt += $billAmount; @endphp @else @endif @if($clientledger->type == 'income') @php $billAmount = $clientledger->amount; @endphp @php $total_cr_amt += $billAmount; @endphp @else @endif @if($clientledger->type == 'bill' || $clientledger->type == 'cargo_bill') @php $total_balance += $clientledger->amount; @endphp @elseif($clientledger->type == 'income') @php if ($clientledger->amount < 0) { $total_balance += $clientledger->amount; } else { $total_balance -= $clientledger->amount; } @endphp @endif @if($total_balance > 0) @else @endif @endforeach @php $finale_balance = $total_dr_amt - $total_cr_amt; if($finale_balance > 0) { $type = ' D'; } else { $type = ' C'; } @endphp

Date	Remarks	Db.Amt.	Cr.Amt.	Balance
{{ date("d M Y", strtotime($clientledger->created_at)) }}	{{$clientledger->description}}	Bill No. {{$clientledger->description}}	Cargo | Bill No. {{ $clientledger->description }}	{{$clientledger->description}}	{{ number_format($billAmount, 2, ".", "") }}		{{ number_format($billAmount, 2, ".", "") }}		{{ number_format($total_balance, 2, ".", "") . ' D' }}	{{ number_format($total_balance, 2, ".", "") . ' C' }}
Total Amount		{{number_format($total_dr_amt,2,".","")}}	{{number_format($total_cr_amt,2,".","")}}	{{number_format($finale_balance,2,".","")}} {{$type}}