@extends('layouts.app') @section('title', 'Sales by Category Report') @push('styles') @endpush @section('content') @can('view_category_sales') @php $categoryCount = $categorySales->count(); $totalItems = $categorySales->sum('total_items'); $totalQuantity = $categorySales->sum('total_quantity'); $grandTotal = $categorySales->sum('total_sales'); $averagePerCategory = $categoryCount > 0 ? $grandTotal / $categoryCount : 0; @endphp

Sales by Category

Category-wise revenue breakdown & analysis

PDF
@include('reports.partials.branch-filter')

Categories

{{ $categoryCount }}

Items Sold

{{ number_format($totalItems) }}

Total Revenue

${{ number_format($grandTotal, 2) }}

Avg per Category

${{ number_format($averagePerCategory, 2) }}

@if($grandTotal > 0)

Revenue Share by Category

@foreach($categorySales as $cat) @php $pct = $grandTotal > 0 ? ($cat->total_sales / $grandTotal) * 100 : 0; @endphp
{{ $cat->category_name }}
{{ number_format($pct, 1) }}% — ${{ number_format($cat->total_sales, 2) }}
@endforeach
@endif

Category Breakdown

{{ displayDate(\Carbon\Carbon::parse($dateFrom)) }} — {{ displayDate(\Carbon\Carbon::parse($dateTo)) }}

@forelse($categorySales as $index => $cat) @php $pct = $grandTotal > 0 ? ($cat->total_sales / $grandTotal) * 100 : 0; @endphp @empty @endforelse @if($categorySales->count() > 0) @endif
# Category Items Sold Total Qty Total Sales Revenue Share
{{ $index + 1 }} {{ $cat->category_name }} {{ $cat->total_items }} {{ $cat->total_quantity }} ${{ number_format($cat->total_sales, 2) }}
{{ number_format($pct, 1) }}%

No data available

Total {{ $totalItems }} {{ $totalQuantity }} ${{ number_format($grandTotal, 2) }} 100%
@endcan @endsection