@php $purchases = \App\Models\Purchase::whereDate('purchase_date','>=',$start_date)->whereDate('purchase_date','<=',$end_date)->where('purchase_type',2)->latest()->get(); @endphp

Purchase Report

Start Date: {{ \Carbon\Carbon::parse($start_date)->format('d/m/Y') }}

End Date: {{ \Carbon\Carbon::parse($end_date)->format('d/m/Y') }}

@foreach ($purchases as $item) @endforeach

Date	Purchase#	Supplier	Taxable Amount	Discount	Tax Amount	Gross Total
{{Carbon\Carbon::parse($item->purchase_date)->format('d/m/Y')}}	{{$item->purchase_number}}	{{$item->supplier->name??""}}	{{getFormattedCurrency($item->sub_total)}}	{{getFormattedCurrency($item->discount)}}	{{getFormattedCurrency($item->tax_amount)}}	{{getFormattedCurrency($item->total)}}

Total Purchases: {{$purchases->count()}}

Total Amount: {{getFormattedCurrency($purchases->sum('total'))}}

Total Discount: {{getFormattedCurrency($purchases->sum('discount'))}}

Total Tax: {{getFormattedCurrency($purchases->sum('tax_amount'))}}