Transaction

@foreach($invoice_items as $orders)

{{ $pagedata['companys']->name }}
{{ $pagedata['companys']->address }}, {{ $pagedata['companys']->city }}, {{ $pagedata['companys']->state }}-{{ $pagedata['companys']->pincode }}
PH:{{ $pagedata['companys']->phone }}, E-mail : {{ $pagedata['companys']->email }}
GSTIN: {{ $pagedata['companys']->gst }}
LEDGER ACCOUNT - {{ (isset($orders[0]['customer']) && !empty($orders[0]['customer'])) ? $orders[0]['customer']['name']:'' }} ({{ $pagedata['dates'] }})

@if(isset($orders[0]['customer']) && !empty($orders[0]['customer'])) {{ $orders[0]['customer']['name'] }}
{{ $orders[0]['customer']['address'] }}, {{ $orders[0]['customer']['email'] }}
GSTIN: {{ $orders[0]['customer']['gstin'] }} Mobile: {{ $orders[0]['customer']['mobile'] }}
@endif

@php $balanceAmount = 0; @endphp @foreach($orders as $orderItems) @php $c++; if($orderItems['transaction_type'] == 1) { $transactionName = 'Sales'; } elseif($orderItems['transaction_type'] == 2) { $transactionName = 'Purchase'; } elseif($orderItems['transaction_type'] == 3) { $transactionName = 'Receipt'; } elseif($orderItems['transaction_type'] == 4) { $transactionName = 'Payment'; } elseif($orderItems['transaction_type'] == 5) { $transactionName = 'Opening Balance'; } elseif($orderItems['transaction_type'] == 6) { $transactionName = 'Ledger'; } elseif($orderItems['transaction_type'] == 7) { $transactionName = 'Sales Return'; } elseif($orderItems['transaction_type'] == 8) { $transactionName = 'Purchase Return'; } elseif($orderItems['transaction_type'] == 9) { $transactionName = 'Debit Note'; } elseif($orderItems['transaction_type'] == 10) { $transactionName = 'Credit Note'; } else { $transactionName = 'Other'; } if($orderItems['payment_type'] == 1) { $paymentTypeName = 'Cash'; } elseif($orderItems['payment_type'] == 2) { $paymentTypeName = 'Cheque'; } elseif($orderItems['payment_type'] == 3) { $paymentTypeName = 'DD'; } elseif($orderItems['payment_type'] == 4) { $paymentTypeName = 'RTGS'; } elseif($orderItems['payment_type'] == 5) { $paymentTypeName = 'NEFT'; } else { $paymentTypeName = 'Other'; } $balance = ($orderItems['debit_amount'] - $orderItems['credit_amount']); $amountBalance = $amountBalance + $balance; @endphp @endforeach

No	Date	Particulars	Vch Type	Vch No	Debit	Credit	Balance
{{ $c }}	{{ date("d-m-Y", strtotime($orderItems['transaction_date'])) }}	{{ substr($orderItems['description'], 0, 40) }}	{{ $transactionName }}	@php if($orderItems['parent_table'] == 1) { $saleData = \App\Models\Sale::where('id', $orderItems['parent_table_id'])->first(); echo($saleData->invoice_no); } elseif($orderItems['parent_table'] == 2) { $purchaseData = \App\Models\Purchase::where('id', $orderItems['parent_table_id'])->first(); echo($purchaseData->invoice_no); } elseif($orderItems['parent_table'] == 3) { $salesReturnData = \App\Models\SalesReturn::where('id', $orderItems['parent_table_id'])->first(); echo($salesReturnData->invoice_no); } elseif($orderItems['parent_table'] == 4) { $purchaseReturnData = \App\Models\PurchaseReturn::where('id', $orderItems['parent_table_id'])->first(); echo($purchaseReturnData->invoice_no); } else { echo($orderItems['transaction_no']); } @endphp	{{ $orderItems['debit_amount'] }}	{{ $orderItems['credit_amount'] }}	{{ $amountBalance }}

@php $debitSum = collect($orders)->sum('debit_amount'); $creditSum = collect($orders)->sum('credit_amount'); $totalDebitSum = $totalDebitSum + $debitSum; $totalCreditSum = $totalCreditSum + $creditSum; $drclosingAmount = $crclosingAmount = $adjustSum = 0; //if($debitSum > $creditSum) //{ //$drclosingAmount = ($debitSum - $creditSum); //$adjustSum = $debitSum; //} //else //{ //$crclosingAmount = ($creditSum - $debitSum); //$adjustSum = $creditSum; //} if($totalDebitSum > $totalCreditSum) { $drclosingAmount = ($debitSum - $creditSum); $adjustSum = $debitSum; } else { $crclosingAmount = ($creditSum - $debitSum); $adjustSum = $creditSum; } $drTotalClosingAmount = $drTotalClosingAmount + $drclosingAmount; $crTotalClosingAmount = $crTotalClosingAmount + $crclosingAmount; $adjustTotalSum = $adjustTotalSum + $adjustSum; @endphp @if($count == $c)

By Closing Balance

Total

@else

Continued...

@endif

@endforeach