# 🌱 Seeder Guide - Test Data for Services & Providers
## 📋 What Was Created
### **3 New Seeders:**
1. **VenueServiceSeeder.php** - Creates 20 realistic services
2. **VenueServiceProviderSeeder.php** - Creates 15 test providers
3. **VenueServiceProviderServiceSeeder.php** - Links providers to their services
---
## 🚀 Quick Start
### **Step 1: Run Migrations (if not done yet)**
```bash
php artisan migrate
```
### **Step 2: Run All Seeders**
```bash
php artisan db:seed
```
**OR run specific seeders only:**
```bash
php artisan db:seed --class=VenueServiceSeeder
php artisan db:seed --class=VenueServiceProviderSeeder
php artisan db:seed --class=VenueServiceProviderServiceSeeder
```
---
## 📊 Test Data Overview
### **20 Services Created:**
**Medical (4 services):**
- General Consultation - €80 (30 min)
- Dental Checkup - €120 (45 min)
- Physical Therapy Session - €90 (60 min)
- Blood Test - €50 (15 min)
**Beauty & Wellness (4 services):**
- Haircut & Styling - €45 (60 min)
- Massage Therapy - €100 (90 min)
- Manicure & Pedicure - €60 (75 min)
- Facial Treatment - €85 (60 min)
**Legal (3 services):**
- Legal Consultation - €150 (60 min)
- Contract Review - €200 (90 min)
- Notary Services - €40 (20 min)
**Business (3 services):**
- Business Consulting - €180 (90 min)
- Tax Preparation - €120 (60 min)
- Accounting Services - €100 (60 min)
**Fitness (3 services):**
- Personal Training Session - €70 (60 min)
- Yoga Class - €35 (60 min)
- Nutrition Consultation - €90 (45 min)
**Education (3 services):**
- Language Tutoring - €50 (60 min)
- Music Lessons - €60 (60 min)
- Academic Tutoring - €55 (60 min)
---
### **15 Service Providers Created:**
**Medical Providers:**
1. **Dr. Sarah Johnson** - General Physician (€80/hr, 4.9★, 15 years)
- Services: General Consultation, Blood Test, Physical Therapy
2. **Dr. Michael Chen** - Dentist (€120/hr, 4.8★, 12 years)
- Services: Dental Checkup, General Consultation
3. **Emma Rodriguez** - Physical Therapist (€90/hr, 4.9★, 10 years)
- Services: Physical Therapy, Massage Therapy, Personal Training
**Beauty & Wellness:**
4. **Maria Garcia** - Hair Stylist (€45/hr, 4.7★, 8 years)
- Services: Haircut & Styling
5. **Sofia Petrova** - Massage Therapist (€100/hr, 5.0★, 14 years)
- Services: Massage Therapy, Facial Treatment
6. **Anna Dimitrova** - Beauty Specialist (€70/hr, 4.8★, 9 years)
- Services: Manicure & Pedicure, Facial Treatment, Haircut & Styling
**Legal:**
7. **John Smith** - Legal Consultant (€150/hr, 4.9★, 18 years)
- Services: Legal Consultation, Contract Review, Business Consulting
8. **Elena Ivanova** - Notary Public (€40/hr, 4.6★, 7 years)
- Services: Notary Services, Legal Consultation
**Business:**
9. **David Thompson** - Business Consultant (€180/hr, 4.9★, 20 years)
- Services: Business Consulting, Tax Preparation, Accounting
10. **Robert Wilson** - Accountant (€110/hr, 4.7★, 13 years)
- Services: Tax Preparation, Accounting, Business Consulting
**Fitness:**
11. **Alex Martinez** - Personal Trainer (€70/hr, 4.8★, 8 years)
- Services: Personal Training, Nutrition Consultation
12. **Lisa Anderson** - Yoga Instructor (€35/hr, 4.9★, 11 years)
- Services: Yoga Class, Personal Training, Massage Therapy
13. **Dr. Jennifer Lee** - Nutritionist (€90/hr, 4.8★, 9 years)
- Services: Nutrition Consultation, General Consultation
**Education:**
14. **Thomas Brown** - Language Tutor (€50/hr, 4.7★, 12 years)
- Services: Language Tutoring, Academic Tutoring
15. **Catherine Miller** - Music Teacher (€60/hr, 4.9★, 15 years)
- Services: Music Lessons, Academic Tutoring
---
## ✅ Verification
### **Check Services:**
```sql
SELECT * FROM venue_services;
```
**Expected:** 20 services
### **Check Providers:**
```sql
SELECT * FROM venue_service_providers;
```
**Expected:** 15 providers
### **Check Provider-Service Relationships:**
```sql
SELECT
vsp.name as provider_name,
vs.name as service_name,
vs.price
FROM venue_service_provider_service vsps
JOIN venue_service_providers vsp ON vsps.venue_service_provider_id = vsp.id
JOIN venue_services vs ON vsps.venue_service_id = vs.id
ORDER BY vsp.name, vs.name;
```
**Expected:** ~40 relationships
---
## 🧪 Testing the Dual Booking Flow
### **Test Service-First Flow:**
1. Visit: `/web/venue/{venue_id}?type=services`
2. Click "Choose Service First" tab
3. Select "Massage Therapy" service
4. Should see: Sofia Petrova, Lisa Anderson, Emma Rodriguez
5. Select a provider → Pick time → Book!
### **Test Provider-First Flow:**
1. Visit: `/web/venue/{venue_id}?type=services`
2. Click "Choose Provider First" tab
3. Select "Dr. Sarah Johnson"
4. Should see: General Consultation, Blood Test, Physical Therapy
5. Select a service → Pick time → Book!
---
## 🔄 Re-seeding
### **To clear and re-seed:**
```bash
php artisan migrate:fresh --seed
```
⚠️ **WARNING:** This will delete ALL data!
### **To add more data without clearing:**
Just run the seeders again:
```bash
php artisan db:seed
```
---
## 📝 Customization
### **To modify test data:**
**Edit services:** `database/seeders/VenueServiceSeeder.php`
**Edit providers:** `database/seeders/VenueServiceProviderSeeder.php`
**Edit relationships:** `database/seeders/VenueServiceProviderServiceSeeder.php`
Then re-run:
```bash
php artisan db:seed --class=VenueServiceSeeder
```
---
## 🎯 What's Next
After seeding:
1. ✅ Verify data in database
2. ✅ Test Service-first booking flow
3. ✅ Test Provider-first booking flow
4. ✅ Verify bookings are created correctly
5. ✅ Check `booking_appointments` table has correct data
**Follow the TESTING_GUIDE.md for complete testing procedures!**
---
## 🎉 Success!
You now have:
- ✅ 20 realistic services across 6 categories
- ✅ 15 professional service providers with photos
- ✅ ~40 provider-service relationships
- ✅ Complete test data for dual booking flow
- ✅ Ready to test immediately!
**Happy Testing!** 🚀