Utilities & Detergents Report

{{-- PAGE HEAD --}}

Utilities & Detergents

{{ $start->format('d M Y') }} – {{ $end->format('d M Y') }}

← Reports

{{-- FILTER --}}

{{-- KPI STRIP --}}

Grand Total

KSh {{ number_format($grandTotal, 0) }}

Utilities + Detergents

⚡ Electricity

KSh {{ number_format($electricityTotal, 0) }}

{{ $electricityTokens > 0 ? number_format($electricityTokens, 1).' kWh' : $electricity->count().' entries' }}

💧 Water

KSh {{ number_format($waterTotal, 0) }}

{{ $waterUnits > 0 ? number_format($waterUnits, 1).' m³' : $water->count().' entries' }}

🧴 Detergents

KSh {{ number_format($totalDetergents, 0) }}

{{ $detergents->count() }} purchases

@if($otherUtilities->isNotEmpty())

🔌 Other Utilities

KSh {{ number_format($otherUtilities->sum('amount'), 0) }}

{{ $otherUtilities->count() }} entries

@endif

{{-- CHARTS ROW --}}

6-Month Spend Trend utilities vs detergents

Spend Breakdown this period

{{-- ELECTRICITY --}}

⚡ Electricity

@if($electricityTokens > 0) {{ number_format($electricityTokens,1) }} kWh total @endif KSh {{ number_format($electricityTotal, 2) }}

@if($electricity->isEmpty())

No electricity records in this period.

@else

@foreach($electricity as $e) @php $m = $e->meta ?? []; $st = $e->status; @endphp @endforeach

Date	Token / Ref	Provider	kWh	Amount	Bal. Remaining	Status
{{ $e->expense_date->format('d M Y') }}	{{ $m['tokens'] ?? ($e->description ?? '—') }}	{{ $m['provider'] ?? '—' }}	{{ isset($m['units']) ? number_format($m['units'],1) : '—' }}	KSh {{ number_format($e->amount, 2) }}	@if(isset($m['remaining_balance'])) KSh {{ number_format($m['remaining_balance'],2) }} @else — @endif	{{ $st }}
Total				KSh {{ number_format($electricityTotal,2) }}

@endif

{{-- WATER --}}

💧 Water

@if($waterUnits > 0) {{ number_format($waterUnits,1) }} m³ total @endif KSh {{ number_format($waterTotal, 2) }}

@if($water->isEmpty())

No water records in this period.

@else

@foreach($water as $e) @php $m = $e->meta ?? []; $st = $e->status; @endphp @endforeach

Date	Description	m³	Amount	Bal. Remaining	Status
{{ $e->expense_date->format('d M Y') }}	{{ Str::limit($e->description ?? '—', 40) }}	{{ isset($m['units']) ? number_format($m['units'],1) : '—' }}	KSh {{ number_format($e->amount, 2) }}	@if(isset($m['remaining_balance'])) KSh {{ number_format($m['remaining_balance'],2) }} @else — @endif	{{ $st }}
Total			KSh {{ number_format($waterTotal,2) }}

@endif

{{-- OTHER UTILITIES --}} @if($otherUtilities->isNotEmpty())

🔌 Other Utilities KSh {{ number_format($otherUtilities->sum('amount'), 2) }}

@foreach($otherUtilities as $e) @php $st = $e->status; @endphp @endforeach

Date	Type	Description	Amount	Status
{{ $e->expense_date->format('d M Y') }}	{{ $e->sub_category ?? '—' }}	{{ Str::limit($e->description ?? '—', 50) }}	KSh {{ number_format($e->amount, 2) }}	{{ $st }}
Total			KSh {{ number_format($otherUtilities->sum('amount'),2) }}

@endif {{-- DETERGENTS --}}

🧴 Detergents & Chemicals KSh {{ number_format($totalDetergents, 2) }}

{{-- Type pills --}} @if($detergentByType->isNotEmpty())

@foreach($detergentByType as $type => $data) {{ $type }} {{ $data['count'] }} KSh {{ number_format($data['amount'],0) }} @endforeach

{{-- Detergent bar chart --}}

@endif @if($detergents->isEmpty())

No detergent records in this period.

@else

@foreach($detergents as $e) @php $m = $e->meta ?? []; $st = $e->status; @endphp @endforeach

Date	Product	Type	Qty	Unit Price	Total	Supplier	Status
{{ $e->expense_date->format('d M Y') }}	{{ $m['product_name'] ?? ($e->description ?? '—') }}	{{ $m['detergent_type'] ?? ($e->sub_category ?? '—') }}	{{ isset($m['quantity']) ? $m['quantity'].' '.($m['unit'] ?? '') : '—' }}	{{ isset($m['unit_price']) ? 'KSh '.number_format($m['unit_price'],2) : '—' }}	KSh {{ number_format($e->amount, 2) }}	{{ $m['supplier'] ?? '—' }}	{{ $st }}
Total					KSh {{ number_format($totalDetergents,2) }}

@endif

{{-- end ur-container --}}

{{-- end ur-wrap --}} @push('scripts') @endpush