INDORE SPINE CENTRE & INDORE WOMEN CARE CENTRE

126 Anoop Nagar, LIG Square, Near LIC Building Indore - 452011 (M.P.)

Bill Report From {{ $start_date }} TO {{ $end_date }}

DATE: {{ now()->format('d/m/Y') }}

@php $grouped = $bookings->groupBy(function ($b) { return optional($b->purchase_services->first())->service_name ?? 'Others'; }); $total_billed = 0; $total_disc = 0; $net_billed = 0; $net_collect = 0; $total_paid = 0; $due = 0 @endphp @foreach($bookings as $b) @if(isset($b->purchase_services)) @else @endif @endforeach
Order ID P. ID Name Service Type Billed Discount T. After Discount Due Cash Bank Transfer
{{$b->id}} P{{$b->patient_id}} {{$b->patient->name}}{{ optional($b->purchase_services->first())->service_name }}Other{{ $b->base_amount }} {{ $b->total_discount }} {{ $b->base_amount - $b->total_discount }} {{ (float)$b->final_amount - (float)$b->paid_amount }} {{ $b->cash_amount }} {{ $b->online_amount }}
Total {{ (float)$bookings->sum('base_amount') }} {{ (float)$bookings->sum('total_discount') }} {{ (float)$bookings->sum('base_amount') - (float)$bookings->sum('total_discount') }} {{ (float)($bookings->sum('final_amount') ?? 0) - (float)($bookings->sum('paid_amount')) }} {{ (float)$bookings->sum('cash_amount') }} {{ (float)$bookings->sum('online_amount') }}
@foreach($grouped as $service => $items) @endforeach
Service Type Cash Bank Transfer Total
{{ $service }} {{ (float)$items->sum('cash_amount') }} {{ (float)$items->sum('online_amount') }} {{ (float)$items->sum('cash_amount') + (float)$items->sum('online_amount') }}
Billing Report Amount
Billed {{ (float)$bookings->sum('base_amount') }}
Discount {{ (float)$bookings->sum('total_discount') }}
Net Billed {{ (float)$bookings->sum('base_amount') - (float)$bookings->sum('total_discount') }}
Net Collected {{ (float)$bookings->sum('cash_amount') + (float)$bookings->sum('online_amount') }}
Total Due {{ (float)($bookings->sum('final_amount') ?? 0) - (float)($bookings->sum('paid_amount') ?? 0) }}


Authorised signature
{{ now()->format('d-M-Y h:i A') }}