mirror of
https://github.com/marcogll/AnchorOS.git
synced 2026-03-15 18:24:31 +00:00
583a25a6f6
Major changes: - Add customer registration with email/phone lookup (app/booking/registro) - Add customers API endpoint (app/api/customers/route) - Implement business hours for locations (mon-fri 10-7, sat 10-6, sun closed) - Fix availability function type casting issues - Add business hours utilities (lib/utils/business-hours.ts) - Update Location type to include business_hours JSONB - Add mock payment component for testing - Remove Supabase auth from booking flow - Fix /cita redirect path in booking flow Database migrations: - Add category column to services table - Add business_hours JSONB column to locations table - Fix availability functions with proper type casting - Update get_detailed_availability to use business_hours Features: - Customer lookup by email or phone - Auto-redirect to registration if customer not found - Pre-fill customer data if exists - Business hours per day of week - Location-specific opening/closing times
21 lines
732 B
SQL
21 lines
732 B
SQL
-- Test script to check database data
|
|
-- Execute in Supabase Dashboard: Database > SQL Editor
|
|
|
|
-- Check counts
|
|
SELECT
|
|
'Locations' as table_name, COUNT(*)::text as count FROM locations
|
|
UNION ALL
|
|
SELECT 'Services', COUNT(*)::text FROM services
|
|
UNION ALL
|
|
SELECT 'Staff', COUNT(*)::text FROM staff
|
|
UNION ALL
|
|
SELECT 'Resources', COUNT(*)::text FROM resources
|
|
UNION ALL
|
|
SELECT 'Bookings', COUNT(*)::text FROM bookings;
|
|
|
|
-- Show sample data
|
|
SELECT id, name, timezone, is_active FROM locations LIMIT 5;
|
|
SELECT id, name, duration_minutes, base_price, is_active FROM services LIMIT 5;
|
|
SELECT id, display_name, role, is_active, is_available_for_booking FROM staff LIMIT 5;
|
|
SELECT id, name, type, capacity, is_active FROM resources LIMIT 5;
|