@php $totalCustomerPaymentRecieved = 0; @endphp @foreach ($sales->whereBetween('sale_date',[$to,$from]) as $sale) @php $totalCustomerPaymentRecieved = $totalCustomerPaymentRecieved + $sale->total_paid; @endphp @endforeach

Sales
Invoice No	Date	Customer	Received
{{ $sale->invoice_no ? $sale->invoice_no : '' }}	{{ $sale->sale_date ? date('d-M-Y', strtotime($sale->sale_date)) : date('d-M-Y', strtotime($sale->created_at)) }}	{{ $sale->customer ? $sale->customer->customer_name : '' }}	{{ $sale->total_paid ? number_format($sale->total_paid, 2) : '' }}
Total			{{ number_format($totalCustomerPaymentRecieved, 2) }}

@php $cashTransPaid = 0; @endphp @foreach ($cashTrans->whereBetween('date',[$to,$from])->where('transaction_type', 'payment') as $cashTran) @php $cashTransPaid = $cashTransPaid + $cashTran->paid_amount; @endphp @endforeach

Cash Paid
Transaction ID	Date	Account Name	Paid
{{ $cashTran->transaction_id ? $cashTran->transaction_id : '' }}	{{ $cashTran->date ? date('d-M-Y', strtotime($cashTran->date)) : date('d-M-Y', strtotime($cashTran->created_at)) }}	{{ $cashTran->account_name ? $cashTran->account_name : '' }}	{{ $cashTran->paid_amount ? number_format($cashTran->paid_amount, 2) : '' }}
Total			{{ number_format($cashTransPaid, 2) }}

@php $cashTransRcvTotal = 0; @endphp @foreach ($cashTrans->whereBetween('date',[$to,$from])->where('transaction_type', 'recieve') as $cashTranRcv) @php $cashTransRcvTotal = $cashTransRcvTotal + $cashTranRcv->received_amount; @endphp @endforeach

Cash Received
Transaction ID	Date	Account Name	Paid
{{ $cashTranRcv->transaction_id ? $cashTranRcv->transaction_id : '' }}	{{ $cashTranRcv->date ? date('d-M-Y', strtotime($cashTranRcv->date)) : date('d-M-Y', strtotime($cashTranRcv->created_at)) }}	{{ $cashTranRcv->account_name ? $cashTranRcv->account_name : '' }}	{{ $cashTranRcv->received_amount ? number_format($cashTranRcv->received_amount, 2) : '' }}
Total			{{ number_format($cashTransRcvTotal, 2) }}

@php $bankTransTotalDeposit = 0; @endphp @foreach ($bankTransactions->whereBetween('transaction_date',[$to,$from])->where('transaction_type', 'deposit') as $key => $transDeposit) @php $bankTransTotalDeposit = $bankTransTotalDeposit + $transDeposit->deposit; @endphp @endforeach

Bank Deposits
Sl	Account Name	Account Number	Bank Name	Date	Deposit
{{ $key + 1 }}	{{ $transDeposit->account_name }}	{{ $transDeposit->account_number }}	{{ $transDeposit->bank_name }}	{{ date('d-M-Y', strtotime($transDeposit->transaction_date)) }}	{{ number_format($transDeposit->deposit, 2) }}
Total					{{ number_format($bankTransTotalDeposit, 2) }}

@php $bankTransTotalWithdraw = 0; @endphp @foreach ($bankTransactions->whereBetween('transaction_date',[$to,$from])->where('transaction_type', 'withdraw') as $key => $transWithdraw) @php $bankTransTotalWithdraw = $bankTransTotalWithdraw + $transWithdraw->withdraw; @endphp @endforeach

Bank Withdraws
Sl	Account Name	Account Number	Bank Name	Date	Withdraw
{{ $key + 1 }}	{{ $transWithdraw->account_name }}	{{ $transWithdraw->account_number }}	{{ $transWithdraw->bank_name }}	{{ date('d-M-Y', strtotime($transWithdraw->transaction_date)) }}	{{ number_format($transWithdraw->withdraw, 2) }}
Total					{{ number_format($bankTransTotalWithdraw, 2) }}

@php $PurchasetotalPaid = 0; @endphp @foreach ($purchases->whereBetween('purchase_date',[$to,$from]) as $purchase) @php $PurchasetotalPaid = $PurchasetotalPaid + $purchase->total_paid; @endphp @endforeach

Purchase
Invoice No	Date	Supplier	Paid
{{ $purchase->invoice_no ? $purchase->invoice_no : '' }}	{{ $purchase->purchase_date ? date('d-M-Y', strtotime($purchase->purchase_date)) : date('d-M-Y', strtotime($purchase->created_at)) }}	{{ $purchase->supplier ? $purchase->supplier->supplier_name : '' }}	{{ $purchase->total_paid ? number_format($purchase->total_paid, 2) : '' }}
Total			{{ number_format($PurchasetotalPaid, 2) }}

@php $totalPaidToSupplier = 0; @endphp @foreach ($supplier_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'payment') as $paidToSupplier) @php $totalPaidToSupplier = $totalPaidToSupplier + $paidToSupplier->amount; @endphp @endforeach

Paid to Suppliers
Invoice No	Date	Supplier	Paid
{{ $paidToSupplier->invoice ? $paidToSupplier->invoice->invoice_no : '' }}	{{ $paidToSupplier->date ? date('d-M-Y', strtotime($paidToSupplier->date)) : date('d-M-Y', strtotime($paidToSupplier->created_at)) }}	{{ $paidToSupplier->supplier ? $paidToSupplier->supplier->supplier_name : '' }}	{{ $paidToSupplier->amount ? number_format($paidToSupplier->amount, 2) : '' }}
Total			{{ number_format($totalPaidToSupplier, 2) }}

@php $totalRcvToSupplier = 0; @endphp @foreach ($supplier_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'recieve') as $RcvToSupplier) @php $totalRcvToSupplier = $totalRcvToSupplier + $RcvToSupplier->amount; @endphp @endforeach

Received from Suppliers
Transaction ID	Date	Supplier	Received
{{ $RcvToSupplier->transaction_id ? $RcvToSupplier->transaction_id : '' }}	{{ $RcvToSupplier->date ? date('d-M-Y', strtotime($RcvToSupplier->date)) : date('d-M-Y', strtotime($RcvToSupplier->created_at)) }}	{{ $RcvToSupplier->supplier ? $RcvToSupplier->supplier->supplier_name : '' }}	{{ $RcvToSupplier->amount ? number_format($RcvToSupplier->amount, 2) : '' }}
Total			{{ number_format($totalRcvToSupplier, 2) }}

@php $totalPaidCustomer = 0; @endphp @foreach ($customer_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'payment') as $paidToCustomer) @php $totalPaidCustomer = $totalPaidCustomer + $paidToCustomer->amount; @endphp @endforeach

Paid to Customers
Transaction ID	Date	Customer	Paid
{{ $paidToCustomer->transaction_id ? $paidToCustomer->transaction_id : '' }}	{{ $paidToCustomer->date ? date('d-M-Y', strtotime($paidToCustomer->date)) : date('d-M-Y', strtotime($paidToCustomer->created_at)) }}	{{ $paidToCustomer->customer ? $paidToCustomer->customer->customer_name : '' }}	{{ $paidToCustomer->amount ? number_format($paidToCustomer->amount, 2) : '' }}
Total			{{ number_format($totalPaidCustomer, 2) }}

@php $totalRcvCustomer = 0; @endphp @foreach ($customer_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'recieve') as $RcvToCustomer) @php $totalRcvCustomer = $totalRcvCustomer + $RcvToCustomer->amount; @endphp @endforeach

Received from Customers
Transaction ID	Date	Customer	Received
{{ $RcvToCustomer->transaction_id ? $RcvToCustomer->transaction_id : '' }}	{{ $RcvToCustomer->date ? date('d-M-Y', strtotime($RcvToCustomer->date)) : date('d-M-Y', strtotime($RcvToCustomer->created_at)) }}	{{ $RcvToCustomer->customer ? $RcvToCustomer->customer->customer_name : '' }}	{{ $RcvToCustomer->amount ? number_format($RcvToCustomer->amount, 2) : '' }}
Total			{{ number_format($totalRcvCustomer, 2) }}

@php $cashIn = $totalCustomerPaymentRecieved + $cashTransRcvTotal + $bankTransTotalDeposit + $totalRcvToSupplier + $totalRcvCustomer; $cashOut = $cashTransPaid + $bankTransTotalWithdraw + $PurchasetotalPaid + $totalPaidToSupplier + $totalPaidCustomer; @endphp