2026-06-11 08:15:07 - === SEARCH.PHP STARTED ===
2026-06-11 08:15:07 - Request Method: GET
2026-06-11 08:15:07 - POST Data: Array
(
)

2026-06-11 13:45:07 - Config included, session started
2026-06-11 13:45:07 - Database connected successfully
2026-06-11 13:45:07 - User logged in: 38578
2026-06-11 13:45:07 - Customers table exists check: YES
2026-06-11 08:15:19 - === SEARCH.PHP STARTED ===
2026-06-11 08:15:19 - Request Method: POST
2026-06-11 08:15:19 - POST Data: Array
(
    [search_type] => aadhar
    [search_value] => 240446462309
)

2026-06-11 13:45:19 - Config included, session started
2026-06-11 13:45:19 - Database connected successfully
2026-06-11 13:45:19 - User logged in: 38578
2026-06-11 13:45:19 - Customers table exists check: YES
2026-06-11 13:45:19 - AJAX request detected
2026-06-11 13:45:19 - Search Type: aadhar
2026-06-11 13:45:19 - Search Value: 240446462309
2026-06-11 13:45:19 - Customers table columns: id, customer_id, name, address, dob, aadhar_number, pan_card, photo_path, is_educated, uses_online, power_status, salary_status, power_status_type, ippb_percentage, ob_percentage, total_percentage, created_by, created_at, manual_created_date, card_fess_status, ob_fees_status, ob_salary_status, staff1_id, staff1_name, staff2_id, staff2_name, staff3_id, staff3_name, updated_by_id, updated_by_name, updated_at, dbt, scheme_name, OB, own, percentage, staff_1_id, staff_2_id, staff_3_id, staff_4_id
2026-06-11 13:45:19 - Final Query: SELECT * FROM customers WHERE 1=1 AND aadhar_number = '240446462309'
2026-06-11 13:45:19 - Query returned 1 rows
2026-06-11 13:45:19 - Customer found: CUST202605257609
2026-06-11 13:45:19 - Sending response: {"success":true,"found":true,"message":"\u2705 Customer found!","debug":["Search Type: aadhar","Search Value: 240446462309","Available columns: id, customer_id, name, address, dob, aadhar_number, pan_card, photo_path, is_educated, uses_online, power_status, salary_status, power_status_type, ippb_percentage, ob_percentage, total_percentage, created_by, created_at, manual_created_date, card_fess_status, ob_fees_status, ob_salary_status, staff1_id, staff1_name, staff2_id, staff2_name, staff3_id, staff3_name, updated_by_id, updated_by_name, updated_at, dbt, scheme_name, OB, own, percentage, staff_1_id, staff_2_id, staff_3_id, staff_4_id","Query: SELECT * FROM customers WHERE 1=1 AND aadhar_number = '240446462309'","Rows found: 1"],"sql_errors":[],"data":{"customer":{"id":"12","customer_id":"CUST202605257609","name":"Meri Laduu","address":"ladu para ","dob":"0000-00-00","aadhar_number":"240446462309","pan_card":null,"photo_path":"uploads\/CUST202605257609_circle.png","is_educated":"Yes","uses_online":"No","power_status":"0","salary_status":"Paid","power_status_type":"none","ippb_percentage":"0","ob_percentage":"83","total_percentage":"83","created_by":"2","created_at":"2026-05-25 04:02:18","manual_created_date":"2026-05-25","card_fess_status":"Pending","ob_fees_status":"Pending","ob_salary_status":"Pending","staff1_id":"2","staff1_name":"Sachin","staff2_id":"4","staff2_name":"Kapil Sharma","staff3_id":"6","staff3_name":"Config","updated_by_id":null,"updated_by_name":null,"updated_at":null,"dbt":"","scheme_name":null,"OB":"no","own":"watching","percentage":"0.00","staff_1_id":null,"staff_2_id":null,"staff_3_id":null,"staff_4_id":null}}}