@extends('layouts.app')
@section('title','Pharmacy Sales Report')
@section('content')
<h1 class="text-lg font-bold text-gray-900 mb-1">Pharmacy Sales Report</h1>
@php $exportType = 'pharmacy-sales'; @endphp
@include('reports._date-filter')
<div class="grid grid-cols-3 gap-3 mb-4"><div class="stat-card"><p class="text-xs text-gray-400">Total Sales</p><p class="text-xl font-bold">KES {{ number_format($sales->sum('total_price')) }}</p></div><div class="stat-card"><p class="text-xs text-gray-400">Prescription (Rx)</p><p class="text-xl font-bold text-blue-600">KES {{ number_format($rx->sum('total_price')) }}</p></div><div class="stat-card"><p class="text-xs text-gray-400">OTC Sales</p><p class="text-xl font-bold text-green-600">KES {{ number_format($otc->sum('total_price')) }}</p></div></div>
<div class="bg-white rounded-xl border shadow-sm overflow-x-auto"><table class="w-full"><thead><tr class="bg-gray-50"><th class="table-header">Drug</th><th class="table-header">Type</th><th class="table-header text-right">Qty</th><th class="table-header text-right">Revenue</th><th class="table-header">Date</th></tr></thead>
<tbody>@foreach($sales as $s)<tr class="border-b border-gray-50"><td class="table-cell text-xs font-medium">{{ $s->drugItem->name ?? '-' }}</td><td class="table-cell text-xs">{{ $s->prescription_id ? 'Rx' : 'OTC' }}</td><td class="table-cell text-right text-xs">{{ $s->quantity_dispensed }}</td><td class="table-cell text-right text-xs font-semibold">{{ number_format($s->total_price) }}</td><td class="table-cell text-xs text-gray-400">{{ $s->created_at->format('d M H:i') }}</td></tr>@endforeach</tbody></table></div>
@endsection