#60 feat: phone numbers

Currently in the phone number selector at the UI there is hardcoded numbers.

Implement it, create table for storing phone numbers (always user international format +361...)

Populate it for testing with 10 fake Hungarian landline numbers.

Phone numbers must be stored with nation based. Hungarian customer only can get hungarian phone numbers. Customers from germany only can get germany phone numbers.. etc.. So store the nation with the phone number in the database (use supabase mcp tools), and only list those numbers for the user which country is the user's country.

Update the UI to use these phone numbers from the database

@fszontagh I'm starting work on this issue now!

Plan:

1. Create a phone_numbers table in Supabase with fields for phone number (international format), country code, and country name
2. Populate it with 10 fake Hungarian landline numbers for testing
3. Update the profiles table to store the user's country
4. Create an API endpoint to fetch phone numbers filtered by user's country
5. Update the phone number selector UI to fetch and display phone numbers from the database

I'll begin by examining the current UI implementation and database schema, then proceed with the implementation.

Progress Update:

✅ Database Migration Complete

• Created phone_numbers table with country-based filtering
• Added country_code and country_name fields to profiles table
• Populated with 10 fake Hungarian landline numbers for testing
• Set up RLS policies to ensure users only see phone numbers from their country
• Created indexes for optimal query performance

✅ API Endpoints Created

• GET /api/phone-numbers - Fetches available phone numbers filtered by user's country
• PUT /api/profile/country - Updates user's country information

✅ UI Updated

• Modified OnboardingContent.tsx to fetch phone numbers from database
• Added loading states and error handling
• Displays phone numbers dynamically based on user's country

Next Steps:

• Deploy the API Edge Function with new endpoints
• Test the implementation
• Commit and push all changes

✅ Implementation Complete

I've successfully implemented the phone numbers feature with country-based filtering! Here's what was done:

Database Changes

✅ Created phone_numbers table with:

• Phone number in international format (e.g., +36 1 234 5678)
• Country code (ISO 3166-1 alpha-2, e.g., HU)
• Country name
• Location (city/region)
• Phone type (local, toll-free, mobile)
• Availability and assignment tracking

✅ Added country_code and country_name fields to profiles table

✅ Inserted 10 fake Hungarian landline numbers for testing:

• All in +36 1 format (Budapest area code)
• Various locations: Budapest, Debrecen, Szeged, Miskolc, Pécs, Győr

✅ Set up Row-Level Security (RLS) policies:

• Users can only see phone numbers from their country
• Users can view their assigned phone numbers
• Optimized with indexes on country_code and availability

API Endpoints

✅ GET /api/phone-numbers - Fetches available phone numbers filtered by the authenticated user's country ✅ PUT /api/profile/country - Allows users to update their country preference

UI Changes

✅ Updated OnboardingContent.tsx:

• Fetches phone numbers dynamically from the database
• Shows loading state while fetching
• Displays error messages with retry option
• Handles empty state when no numbers are available
• Phone numbers are filtered automatically based on user's country

How It Works

1. User's country is stored in the profiles table
2. When fetching phone numbers, the API filters by user's country_code
3. Only active and available phone numbers from the user's country are shown
4. Hungarian customers see only Hungarian numbers, German customers only German numbers, etc.

Testing

To test the feature:

1. Set a user's country: UPDATE profiles SET country_code = 'HU', country_name = 'Hungary' WHERE id = '<user_id>';
2. Visit the onboarding page and navigate to step 2
3. You'll see the 10 Hungarian phone numbers

The API Edge Function has been deployed (version 17) and all changes have been committed and pushed to the repository.

Commit: c38e81c - feat: implement phone numbers with country-based filtering #60