Account Report

Sri Vidya Saraswathi Shani Temples, Wargal

Generated on: {{ \Carbon\Carbon::now()->setTimezone('Asia/Kolkata')->format('d M Y H:i:s') }}

@if($selectedFromDate || $selectedToDate || $selectedCategory || $selectedSeva)

Applied Filters:

@if($selectedFromDate || $selectedToDate)
Date Range:
@if($selectedFromDate && $selectedToDate) {{ $selectedFromDate }} to {{ $selectedToDate }} @elseif($selectedFromDate) From {{ $selectedFromDate }} @elseif($selectedToDate) Until {{ $selectedToDate }} @endif
@endif @if($selectedCategory)
Category:
{{ $selectedCategory->name }} ({{ $selectedCategory->temple->name }})
@endif @if($selectedSeva)
Seva:
{{ $selectedSeva->name }}
@endif
@endif

Report Summary

Total Bookings: {{ $bookings->count() }}

Total Seva Items: {{ $bookings->sum(function($booking) { return count($booking->cart_data ?? []); }) }}

Total Amount: ₹{{ number_format($bookings->sum(function($booking) { return collect($booking->cart_data ?? [])->sum('price'); }), 2) }}

@if($bookings->count() > 0) @foreach($bookings as $booking) @foreach($booking->cart_data ?? [] as $cartItem) @endforeach @endforeach
Customer Category & Temple Booking Details Booking Date Amount Gateway Reference ID Transaction ID
{{ $booking->user->name }}
{{ $booking->user->email }}
{{ data_get($cartItem, 'category_name', 'N/A') }}
{{ data_get($cartItem, 'temple_name', 'N/A') }}
{{ data_get($cartItem, 'name') }}
Date: {{ \Carbon\Carbon::parse(data_get($cartItem, 'date'))->format('d M Y') }}
Time: {{ data_get($cartItem, 'time_slot', 'Any Time') }}
{{ \Carbon\Carbon::parse($booking->created_at)->setTimezone('Asia/Kolkata')->format('d M Y H:i') }} ₹{{ number_format($booking->total_amount, 2) }} {{ $booking->order->gateway_reference_id ?? 'N/A' }} {{ $booking->order->transaction_id ?? 'N/A' }}
@else

No records found matching the applied filters.

@endif

This report was generated on {{ \Carbon\Carbon::now()->setTimezone('Asia/Kolkata')->format('d M Y H:i:s') }} by the SVSST Wargal Admin System

For any queries, please contact the temple administration