=== DEBUG: Booked Customers Issue === Checking actual advance_paid and registration_number values: ------------------------------------------------------------------------------------------------------------------------ ID | Name | Client | Advance Paid | AP Status | Reg# Status ------------------------------------------------------------------------------------------------------------------------ 145 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 146 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 157 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 158 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 159 | ganan stephen | 1 | 5000.00000000 | 5000.00000000 | NULL 160 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 171 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 172 | Workflow Test Customer | 1 | 500.00000000 | 500.00000000 | REG-2024-001 183 | K NADHAN | 1 | 5000.00000000 | 5000.00000000 | NULL ------------------------------------------------------------------------------------------------------------------------ Testing Booked Customers query: - ID: 159, Name: ganan stephen, Advance: 5000.00000000 - ID: 183, Name: K NADHAN, Advance: 5000.00000000 Total in Booked Customers: 2 Testing Enquiry query: Total in Enquiry: 0 Checking for problematic empty string values: Records with advance_paid = '' or '0': 0 Records with registration_number = '': 0 === DEBUG COMPLETE ===