=== 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: 0 customers in Enquiry list

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

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

Test 6: Sample customer data (first 5 customers)...
  - K NADHAN (ID: 183)
    Type: Customer (1)
    Advance Paid: 5000.00000000
    Registration Number: (empty)
    → Workflow Status: Booked

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

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

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

  - ganan stephen (ID: 159)
    Type: Customer (1)
    Advance Paid: 5000.00000000
    Registration Number: (empty)
    → Workflow Status: Booked


=== 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