=== Fixing Workflow Data Issues ===

Step 1: Checking current data for these 3 customers...
----------------------------------------------------------------------------------------------------

Step 2: Fixing P Karthikeyan (should have NULL advance_paid)...
  ✓ P Karthikeyan updated - advance_paid and registration_number set to NULL

Step 3: Checking Hari's data...

Step 4: Testing workflow queries...

Booked Customers Query (should show ONLY James):
  Total: 0 (Expected: 1 - James only)

Registered Customers Query (should show Hari if has registration_number):
  Total: 0 (Expected: 1 - Hari if has registration)

Enquiry Query (should show P Karthikeyan):
  Total: 0 (Expected: 1 - P Karthikeyan)

=== FIX COMPLETE ===

Now test in browser:
1. Booked Customers: http://localhost/admin_crm/htdocs/societe/list.php?contextpage=booked_customers
   → Should show ONLY James
2. Registered Customers: http://localhost/admin_crm/htdocs/societe/list.php?contextpage=registered_customers
   → Should show Hari (if has registration_number)
3. Enquiry: http://localhost/admin_crm/htdocs/societe/list.php?contextpage=enquiry
   → Should show P Karthikeyan