query( 'SELECT s.id, s.code, s.label, s.icon, s.total_slots, s.price_per_hour, a.available_slots, a.last_updated FROM service_types s JOIN availability a ON a.service_type_id = s.id ORDER BY s.id' )->fetchAll(); ?>
Real-Time Status

Live Availability

Slots update automatically. Page refreshes every 30 seconds.

LIVE Last updated:
0 ? round(($totalAvail / $totalSlots) * 100) : 0; ?>
OVERALL AVAILABILITY
/
% of all slots currently available
Book Now
Available (>50%)
Limited (20–50%)
Almost Full (<20%)
0 ? round(($svc['available_slots'] / $svc['total_slots']) * 100) : 0; $fillClass = $pct > 50 ? 'fill-green' : ($pct > 20 ? 'fill-amber' : 'fill-red'); $badgeClass = $pct > 50 ? 'badge-green' : ($pct > 20 ? 'badge-amber' : 'badge-red'); $badgeText = $pct > 50 ? 'AVAILABLE' : ($pct > 0 ? 'LIMITED' : 'FULL'); ?>
0 ? '₹' . number_format($svc['price_per_hour'], 2) . ' / hr' : 'Complimentary' ?>
Availability /
0): ?> Book No slots