ADMIN MANAGEMENT
@php $adminAvatar = $adminAvatar ?? asset('images/bzmtch_logo.png'); @endphp

Sales Report

| >

Summary

@php $totalRevenue = $totalRevenue ?? 0; $transactionCount = $transactionCount ?? 0; $todayRevenue = $todayRevenue ?? 0; $todayTransactionCount = $todayTransactionCount ?? 0; $profitToday = $profitToday ?? 0; $activeCashiersCount = $activeCashiersCount ?? 0; @endphp
Total

₱{{ number_format($totalRevenue, 2) }}

Total Revenue

Today

{{ number_format($todayTransactionCount) }}

Transactions

Today

₱{{ number_format($profitToday, 2) }}

Profit Today

Active

{{ number_format($activeCashiersCount) }}

Active Cashiers

@php $manilaNow = \Carbon\Carbon::now('Asia/Manila'); $activeFilter = $activeFilter ?? request()->get('active_filter', 'day'); $cashiers = $cashiers ?? collect(); $sales = $sales ?? collect(); $filterYear = $filterYear ?? (int) $manilaNow->format('Y'); $filterMonth = $filterMonth ?? (int) $manilaNow->format('n'); $filterDay = $filterDay ?? (int) $manilaNow->format('j'); $filterCashier = $filterCashier ?? ''; $filterBranch = $filterBranch ?? ''; $branches = $branches ?? collect(); $quickFilter = $quickFilter ?? ''; $daysInMonth = $daysInMonth ?? (int) \Carbon\Carbon::create($filterYear, $filterMonth, 1, 0, 0, 0, 'Asia/Manila')->daysInMonth; $filterDay = min(max(1, $filterDay ?? 1), $daysInMonth); $resultsLabel = $resultsLabel ?? $manilaNow->format('F j, Y'); $monthNames = $monthNames ?? [1=>'January',2=>'February',3=>'March',4=>'April',5=>'May',6=>'June',7=>'July',8=>'August',9=>'September',10=>'October',11=>'November',12=>'December']; $currentYear = $currentYear ?? (int) $manilaNow->format('Y'); $currentMonth = $currentMonth ?? (int) $manilaNow->format('n'); $currentDay = $currentDay ?? (int) $manilaNow->format('j'); @endphp

Advanced Filters

Showing results for: {{ $resultsLabel }}
@forelse($sales as $sale) @php $soldAt = $sale->sold_at; $soldAtManila = $soldAt ? \Carbon\Carbon::parse($soldAt)->timezone('Asia/Manila') : null; $cashierName = $sale->cashier ? ($sale->cashier->full_name ?: $sale->cashier->username) : '—'; $totalCost = $sale->saleItems->sum(function ($item) { $costing = $item->product ? (float) $item->product->costing : 0; return $costing * (int) $item->quantity; }); $customerLabels = ['WALKIN' => 'WALK-IN', 'REGULAR' => 'Regular Customer', 'VIP' => 'VIP Customer']; $customerDisplay = isset($sale->customer) ? ($customerLabels[$sale->customer] ?? $sale->customer) : 'WALK-IN'; $profit = isset($sale->profit) ? (float) $sale->profit : (($sale->total ?? 0) - $totalCost); $tendered = (float) ($sale->amount_tendered ?? $sale->total ?? 0); $totalVal = (float) ($sale->total ?? 0); $isOutstanding = $totalVal > $tendered; @endphp @empty @endforelse @if($sales->total() > 0) @endif
Order Date Time Trans No. Customer Amt. Due Cost PL-Disc OV-Disc Payable Payment Profit Status
{{ $soldAtManila ? $soldAtManila->format('M d, Y') : '—' }} {{ $soldAtManila ? $soldAtManila->format('h:i A') : '—' }} {{ $sale->trans_no ?? '—' }} {{ $customerDisplay }} ₱{{ number_format($sale->subtotal ?? 0, 2) }} ₱{{ number_format($totalCost, 2) }} ₱{{ number_format($sale->discount ?? 0, 2) }} ₱{{ number_format($sale->override_discount ?? 0, 2) }} ₱{{ number_format($sale->total ?? 0, 2) }} ₱{{ number_format($sale->amount_tendered ?? $sale->total ?? 0, 2) }} ₱{{ number_format($profit, 2) }} @if($isOutstanding) Partially Paid @else Completed @endif

No transactions found

Try changing the date range or cashier filter.
@if($sales->hasPages())
{{ $sales->links() }}
@endif
Export Excel
@php $summaryGrossSales = $summaryGrossSales ?? 0; $summaryNetSales = $summaryNetSales ?? 0; $summaryTransCount = $summaryTransCount ?? 0; $summaryProfit = $summaryProfit ?? 0; $summaryPaidAmount = $summaryPaidAmount ?? 0; $summaryTotalDiscount = $summaryTotalDiscount ?? 0; $summarySystemTotal = $summarySystemTotal ?? 0; $summaryOutstanding = $summaryOutstanding ?? 0; @endphp

Sales Overview

Gross Sales

₱{{ number_format($summaryGrossSales, 2) }}

Net Sales

Trans Count

{{ number_format($summaryTransCount) }}

Transactions

Profit

₱{{ number_format($summaryProfit, 2) }}

After Deductions

Paid Amount

₱{{ number_format($summaryPaidAmount, 2) }}

Collected

Deductions & Adjustments

Void Sales

Voided product/transaction amounts

₱{{ number_format($summaryVoidAmount ?? 0, 2) }}

Cancelled

Not Counted

₱{{ number_format($summaryCancelledAmount ?? 0, 2) }}

Total PL Discount

Price List

₱{{ number_format($summaryTotalDiscount, 2) }}

Total OV Discount

Override

₱0.00

NET

Total Payment Received

₱{{ number_format($summaryPaidAmount, 2) }}

Net Received

DUE

Outstanding Balance

₱{{ number_format($summaryOutstanding, 2) }}

Pending Collection

SYS

System Total Sales

₱{{ number_format($summarySystemTotal, 2) }}

{{ number_format($summaryTransCount) }} Records

@include('admin.partials.inbox')