@vite(['resources/css/app.css', 'resources/js/app.js'])
@endif
Business:
{{ $businessId ? \App\Models\Business::find($businessId)->name : 'All' }}
Branch:
{{ $branchId ? \App\Models\Branch::find($branchId)->name : 'All' }}
Category:
{{ $categoryId ? \App\Models\Category::find($categoryId)->name : 'All' }}
Method:
{{ $method ? ucfirst($method) : 'All' }}
Generated:
{{ now()->format('Y-m-d H:i:s') }}
User:
{{ Auth::user()->name }}
| Business > Category > Sub-Category | Cash Credit(Receipts) | Cash Debit(Payments) | Bank Credit(Receipts) | Bank Debit(Payments) | Net |
|---|---|---|---|---|---|
| {{ $summary['business_name'] }} > {{ $summary['category_name'] }} | SAR {{ number_format($summary['total_cash_credit'], 2) }} | SAR {{ number_format($summary['total_cash_debit'], 2) }} | SAR {{ number_format($summary['total_bank_credit'], 2) }} | SAR {{ number_format($summary['total_bank_debit'], 2) }} | SAR {{ number_format($summary['total_net'], 2) }} |
| No category data available. | |||||
| Total: | SAR {{ number_format($totalCashCredit, 2) }} | SAR {{ number_format($totalCashDebit, 2) }} | SAR {{ number_format($totalBankCredit, 2) }} | SAR {{ number_format($totalBankDebit, 2) }} | SAR {{ number_format($totalCashCredit + $totalBankCredit - $totalCashDebit - $totalBankDebit, 2) }} |
| Date | Branch | Business > Category > Sub-Category | Cash Credit(Receipts) | Cash Debit(Payments) | Cash Net | Bank Credit(Receipts) | Bank Debit(Payments) | Bank Net | Combined Net |
|---|---|---|---|---|---|---|---|---|---|
| {{ \Carbon\Carbon::parse($item['date'])->format('d/m/Y') }} | {{ $item['branch_name'] }} | {{ $item['business_name'] }} > {{ $item['category_name'] }} | SAR {{ number_format($item['cash_credit'], 2) }} | SAR {{ number_format($item['cash_debit'], 2) }} | SAR {{ number_format($item['cash_net'], 2) }} | SAR {{ number_format($item['bank_credit'], 2) }} | SAR {{ number_format($item['bank_debit'], 2) }} | SAR {{ number_format($item['bank_net'], 2) }} | SAR {{ number_format($item['combined_net'], 2) }} |
| No transactions in selected date range. | |||||||||
Datewise Business Report Summary - {{ \Carbon\Carbon::parse($fromDate)->format('d/m/Y') }} to {{ \Carbon\Carbon::parse($toDate)->format('d/m/Y') }} | Generated on {{ now()->format('Y-m-d H:i:s') }} | User: {{ Auth::user()->name }}