@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 }}
Agent:
{{ \App\Models\Agent::find($agentId)->name ?? 'All' }}
SubCategory:
{{ \App\Models\Category::find($subcategoryId)->name ?? 'All' }}
| Balances | |
|---|---|
| Opening Cash Balance | SAR {{ number_format($openingCashBalance, 2) }} |
| Opening Bank Balance | SAR {{ number_format($openingBankBalance, 2) }} |
| Closing Cash Balance | SAR {{ number_format($closingCashBalance, 2) }} |
| Closing Bank Balance | SAR {{ number_format($closingBankBalance, 2) }} |
| Transactions | |
|---|---|
| Total Cash Credit(Receipts) | SAR {{ number_format($totalCashCredit, 2) }} |
| Total Bank Credit(Receipts) | SAR {{ number_format($totalBankCredit, 2) }} |
| Total Cash Debit(Payments) | SAR {{ number_format($totalCashDebit, 2) }} |
| Total Bank Debit(Payments) | SAR {{ number_format($totalBankDebit, 2) }} |
| 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) | Bank Credit(Receipts) | Cash Debit(Payments) | Bank Debit(Payments) | Cash Net | Bank Net | Combined Net | Action |
|---|---|---|---|---|---|---|---|---|---|---|
| {{ \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['bank_credit'], 2) }} | SAR {{ number_format($item['cash_debit'], 2) }} | SAR {{ number_format($item['bank_debit'], 2) }} | SAR {{ number_format($item['cash_net'], 2) }} | SAR {{ number_format($item['bank_net'], 2) }} | SAR {{ number_format($item['combined_net'], 2) }} | View |
| No transactions in selected date range. | ||||||||||
There are no transactions for the selected period and filters.
Date-wise Business Report - {{ \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 }}