[2026-05-15 21:07:06] Apply start preserved profile | {"chat_id":7851920105,"user_id":5,"customer_name":"","customer_email":"","customer_mobile":""}
[2026-05-15 21:08:39] Submit button received | {"chat_id":7851920105,"current_step":"vf_apply_review","data_keys":["customer_user_id","started_at","vehicle_type","vehicle_brand","vehicle_model","transmission_type","vehicle_condition","down_payment_percentage","down_payment_source","employment_status","monthly_income","company_name","employment_duration","residential_status","residential_address","witness1_first_name","witness1_last_name","witness1_relationship","witness1_contact_number","witness1_cnic_number","witness1_cnic_issue_date","witness1_cnic_expiry_date","witness1_date_of_birth","witness1_address","witness2_first_name","witness2_last_name","witness2_relationship","witness2_contact_number","witness2_cnic_number","witness2_cnic_issue_date","witness2_cnic_expiry_date","witness2_date_of_birth","witness2_address"]}
[2026-05-15 21:08:39] Customer profile lookup result | {"chat_id":7851920105,"user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","customer_mobile":"+34634753260","lookup_method":"users.id"}
[2026-05-15 21:08:39] Duplicate application blocked | {"chat_id":7851920105,"existing_reference":"VF-260515-8287AC68","existing_status":"Under Review"}
[2026-05-15 21:20:03] Customer profile lookup result | {"chat_id":7851920105,"user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","customer_mobile":"+34634753260","lookup_method":"users.id"}
[2026-05-15 21:20:03] Duplicate application blocked at apply start | {"chat_id":7851920105,"user_id":5,"customer_email":"awais.haider1089@gmail.com","existing_reference":"VF-260515-8287AC68","existing_status":"Under Review"}
[2026-05-15 21:22:10] Customer profile lookup result | {"chat_id":7851920105,"user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","customer_mobile":"+34634753260","lookup_method":"users.id"}
[2026-05-15 21:22:10] Duplicate application blocked at apply start | {"chat_id":7851920105,"user_id":5,"customer_email":"awais.haider1089@gmail.com","existing_reference":"VF-260515-8287AC68","existing_status":"Under Review"}
[2026-05-15 21:25:10] Customer profile lookup result | {"chat_id":7851920105,"user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","customer_mobile":"+34634753260","lookup_method":"users.id"}
[2026-05-15 21:25:10] Apply start preserved profile | {"chat_id":7851920105,"user_id":5,"customer_name":"","customer_email":"","customer_mobile":""}
[2026-05-15 21:26:46] Submit button received | {"chat_id":7851920105,"current_step":"vf_apply_review","data_keys":["customer_user_id","started_at","vehicle_type","vehicle_brand","vehicle_model","transmission_type","vehicle_condition","down_payment_percentage","down_payment_source","employment_status","monthly_income","company_name","employment_duration","residential_status","residential_address","witness1_first_name","witness1_last_name","witness1_relationship","witness1_contact_number","witness1_cnic_number","witness1_cnic_issue_date","witness1_cnic_expiry_date","witness1_date_of_birth","witness1_address","witness2_first_name","witness2_last_name","witness2_relationship","witness2_contact_number","witness2_cnic_number","witness2_cnic_issue_date","witness2_cnic_expiry_date","witness2_date_of_birth","witness2_address"]}
[2026-05-15 21:26:46] Customer profile lookup result | {"chat_id":7851920105,"user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","customer_mobile":"+34634753260","lookup_method":"users.id"}
[2026-05-15 21:26:46] DB helper added missing column | {"column":"internal_application_id"}
[2026-05-15 21:26:46] Customer profile lookup result | {"chat_id":7851920105,"user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","customer_mobile":"+34634753260","lookup_method":"users.id"}
[2026-05-15 21:26:46] Insert attempt | {"reference":"VF-260515-D49FE1A7","user_id":5,"customer_name":"ZSI Amazon Logistics LLC","customer_email":"awais.haider1089@gmail.com","columns":["application_reference","internal_application_id","user_id","telegram_id","customer_name","customer_email","customer_username","vehicle_type","vehicle_brand","vehicle_model","transmission_type","vehicle_condition","down_payment_percentage","down_payment_source","employment_status","monthly_income","company_name","employment_duration","residential_status","residential_address","witness1_first_name","witness1_last_name","witness1_relationship","witness1_contact_number","witness1_cnic_number","witness1_cnic_issue_date","witness1_cnic_expiry_date","witness1_date_of_birth","witness1_address","witness2_first_name","witness2_last_name","witness2_relationship","witness2_contact_number","witness2_cnic_number","witness2_cnic_issue_date","witness2_cnic_expiry_date","witness2_date_of_birth","witness2_address","application_status"]}
[2026-05-15 21:26:46] Insert success | {"id":12,"reference":"VF-260515-D49FE1A7"}
[2026-05-15 21:26:46] Email result normalized | {"sent":true,"email":"awais.haider1089@gmail.com","reason":"sent"}
[2026-05-16 13:19:17] Customer profile lookup result | {"chat_id":8697023311,"user_id":25,"customer_name":"Sadaf Hussain","customer_email":"mzoohaaan@gmail.com","customer_mobile":"+923036814535","lookup_method":"users.id"}
[2026-05-16 13:19:17] Apply start preserved profile | {"chat_id":8697023311,"user_id":25,"customer_name":"","customer_email":"","customer_mobile":""}
[2026-05-16 14:00:21] Submit button received | {"chat_id":8697023311,"current_step":"vf_apply_review","data_keys":["customer_user_id","started_at","vehicle_type","vehicle_brand","vehicle_model","transmission_type","vehicle_condition","down_payment_percentage","down_payment_source","employment_status","monthly_income","company_name","employment_duration","residential_status","residential_address","witness1_first_name","witness1_last_name","witness1_relationship","witness1_contact_number","witness1_cnic_number","witness1_cnic_issue_date","witness1_cnic_expiry_date","witness1_date_of_birth","witness1_address","witness2_first_name","witness2_last_name","witness2_relationship","witness2_contact_number","witness2_cnic_number","witness2_cnic_issue_date","witness2_cnic_expiry_date","witness2_date_of_birth","witness2_address"]}
[2026-05-16 14:00:21] Customer profile lookup result | {"chat_id":8697023311,"user_id":25,"customer_name":"Sadaf Hussain","customer_email":"mzoohaaan@gmail.com","customer_mobile":"+923036814535","lookup_method":"users.id"}
[2026-05-16 14:00:21] Customer profile lookup result | {"chat_id":8697023311,"user_id":25,"customer_name":"Sadaf Hussain","customer_email":"mzoohaaan@gmail.com","customer_mobile":"+923036814535","lookup_method":"users.id"}
[2026-05-16 14:00:21] Insert attempt | {"reference":"VF-260516-A4A7A348","user_id":25,"customer_name":"Sadaf Hussain","customer_email":"mzoohaaan@gmail.com","columns":["application_reference","internal_application_id","user_id","telegram_id","customer_name","customer_email","customer_username","vehicle_type","vehicle_brand","vehicle_model","transmission_type","vehicle_condition","down_payment_percentage","down_payment_source","employment_status","monthly_income","company_name","employment_duration","residential_status","residential_address","witness1_first_name","witness1_last_name","witness1_relationship","witness1_contact_number","witness1_cnic_number","witness1_cnic_issue_date","witness1_cnic_expiry_date","witness1_date_of_birth","witness1_address","witness2_first_name","witness2_last_name","witness2_relationship","witness2_contact_number","witness2_cnic_number","witness2_cnic_issue_date","witness2_cnic_expiry_date","witness2_date_of_birth","witness2_address","application_status"]}
[2026-05-16 14:00:21] Insert success | {"id":13,"reference":"VF-260516-A4A7A348"}
[2026-05-16 14:00:21] Email result normalized | {"sent":true,"email":"mzoohaaan@gmail.com","reason":"sent"}
[2026-05-16 17:34:29] Customer profile lookup result | {"chat_id":8697023311,"user_id":25,"customer_name":"Sadaf Hussain","customer_email":"mzoohaaan@gmail.com","customer_mobile":"+923036814535","lookup_method":"users.id"}
[2026-05-16 17:34:29] Duplicate application blocked at apply start | {"chat_id":8697023311,"user_id":25,"customer_email":"mzoohaaan@gmail.com","existing_reference":"VF-260516-A4A7A348","existing_status":"Under Review"}