=== Customer Workflow Test ===

Test 1: Checking societe_extrafields table...
  ✓ Table exists

Test 2: Checking required columns...
  ✓ advance_paid column exists
  ✓ registration_number column exists

Test 3: Testing Enquiry query (NO advance_paid, NO registration_number)...
  Found: 2 customers in Enquiry list

Test 4: Testing Booked Customers query (WITH advance_paid, NO registration_number)...
  Found: 0 customers in Booked Customers list

Test 5: Testing Registered Customers query (WITH registration_number)...
  Found: 3 customers in Registered Customers list

Test 6: Sample customer data (first 5 customers)...
  - Workflow Test Customer (ID: 157)
    Type: Customer (1)
    Advance Paid: 500.00000000
    Registration Number: REG-2024-001
    → Workflow Status: Registered

  - Company num 17889512113 (ID: 150)
    Type: Customer (1)
    Advance Paid: 0
    Registration Number: (empty)
    → Workflow Status: Enquiry

  - Company num 17889512110 (ID: 147)
    Type: Customer (1)
    Advance Paid: 0
    Registration Number: (empty)
    → Workflow Status: Enquiry

  - Workflow Test Customer (ID: 146)
    Type: Customer (1)
    Advance Paid: 500.00000000
    Registration Number: REG-2024-001
    → Workflow Status: Registered

  - Workflow Test Customer (ID: 145)
    Type: Customer (1)
    Advance Paid: 500.00000000
    Registration Number: REG-2024-001
    → Workflow Status: Registered


=== Test Complete ===

Access URLs:
- Enquiry List: http://localhost/admin_crm/htdocs/societe/list.php?contextpage=enquiry
- Booked Customers: http://localhost/admin_crm/htdocs/societe/list.php?contextpage=booked_customers
- Registered Customers: http://localhost/admin_crm/htdocs/societe/list.php?contextpage=registered_customers