# MPV OUT OF SERVICE - CONFIGURATION UPDATE

## ✅ CHANGES MADE:

### 1. Database Schema Updated
**File**: `database/schema.sql`
- MPV (Mercedes V-Class) set to `is_active = 0`
- Description updated to: "CURRENTLY OUT OF SERVICE"
- Vehicle will NOT appear in API calls (`/api/vehicles` filters by `is_active = 1`)

### 2. Fleet Page Updated
**File**: `public/fleet.html`
- Removed MPV/People Carrier card from display
- Added prominent "Out of Service" notice box:
  - Yellow warning banner
  - Clear message: "MPV (6 seaters) and larger vehicles are currently out of service"
  - Phone number for customers needing 5+ passengers

### 3. Quotation Page
**File**: `public/quotation.html`
- Already configured with MPV disabled in dropdown
- Shows "MPV (6-seater) — Out of service"
- Notice displayed: "MPV (6 seaters) and Mini Van (8 seaters) are currently out of service"

### 4. API Automatically Filters
**File**: `server/routes/vehicles.js`
- GET `/api/vehicles` only returns vehicles where `is_active = 1`
- MPV will NOT be returned in API responses
- Customers cannot book MPV through the system

---

## 📋 ACTIVE VEHICLES (3 Total):

### 1. ✅ Saloon (Mercedes E-Class)
- **Capacity**: Up to 4 passengers
- **Luggage**: 2 large suitcases
- **Price**: £2.00 per mile (min £25)
- **Status**: ACTIVE

### 2. ✅ Estate (Mercedes E-Class Estate)
- **Capacity**: Up to 4 passengers  
- **Luggage**: 3-4 large suitcases
- **Price**: £2.20 per mile (min £30)
- **Status**: ACTIVE

### 3. ✅ Executive (Mercedes S-Class)
- **Capacity**: Up to 4 passengers
- **Luggage**: 2-3 large suitcases
- **Price**: £3.00 per mile (min £40)
- **Status**: ACTIVE

---

## ⚠️ OUT OF SERVICE VEHICLE:

### ❌ MPV (Mercedes V-Class)
- **Capacity**: Up to 6 passengers
- **Luggage**: 4-5 large suitcases
- **Price**: £2.50 per mile (min £35)
- **Status**: INACTIVE - OUT OF SERVICE
- **Database**: `is_active = 0`
- **API**: NOT returned in vehicle lists
- **Bookings**: CANNOT be booked

---

## 🔄 TO RE-ACTIVATE MPV LATER:

When MPV is back in service, update the database:

```sql
-- Re-activate MPV
UPDATE vehicles 
SET is_active = 1, 
    description = 'Spacious for groups with Mercedes V-Class'
WHERE type = 'mpv';
```

Or via SQLite command:
```bash
cd /home/user/ashtransfer-fullstack
sqlite3 database/ashtransfer.db
sqlite> UPDATE vehicles SET is_active = 1 WHERE type = 'mpv';
sqlite> .exit
```

The vehicle will automatically appear in:
- API responses (`/api/vehicles`)
- Booking system
- Admin dashboard

You would also need to:
1. Remove the "Out of Service" notice from `public/fleet.html`
2. Enable the MPV option in `public/quotation.html`

---

## 📞 CUSTOMER GUIDANCE:

**For customers needing 5-6 passengers:**
- System displays clear notice on Fleet and Quotation pages
- Customers directed to call: **+44 7860 261578**
- Staff can arrange multiple vehicles if needed

---

## ✅ VERIFIED:

- [x] Database schema updated (MPV inactive)
- [x] Fleet page updated (MPV removed, notice added)
- [x] Quotation page already has MPV disabled
- [x] API filters inactive vehicles automatically
- [x] Customers cannot book MPV
- [x] Clear instructions for 5+ passengers

---

**Date**: January 29, 2025  
**Status**: MPV marked as OUT OF SERVICE  
**Active Vehicles**: 3 (Saloon, Estate, Executive)
