{"customers":[{"id":1,"name":"AbdulBassir","last_name":"Mohammadi","phone":"0774881183","passport_no":"P0948485844","email":"abdulbassirmohammadi0110@gmail.com","gender":"Male","date_of_birth":"2016-01-05","created_at":"2026-06-08 13:12:56"},{"id":2,"name":"Najeeb","last_name":"Mohammadi","phone":"0774881183","passport_no":"P0948485877","email":"abdulbassirmohammadi0110@gmail.com","gender":"Male","date_of_birth":"2017-01-05","created_at":"2026-06-08 13:25:05"},{"id":3,"name":"omar","last_name":"sedeqi","phone":"0774881183","passport_no":"P0948485888","email":"omar@gmail.com","gender":"Male","date_of_birth":"2009-12-28","created_at":"2026-06-08 13:37:03"},{"id":4,"name":"ahmad","last_name":"ahmadi","phone":"0774881183","passport_no":"P0948485866","email":"ahmad2@gmail.com","gender":"Male","date_of_birth":"2010-01-06","created_at":"2026-06-08 13:46:02"}],"visa_partners":[],"other_services":[],"visa_applications":[{"id":1,"customer_id":1,"country":"Turkey","visa_type":"Tourist","total_fee":7000,"paid_amount":7000,"remaining_amount":0,"status":"completed","submitted_date":"2026-06-09","notes":"","created_at":"2026-06-08 13:14:06"},{"id":2,"customer_id":2,"country":"India","visa_type":"Business","total_fee":2500,"paid_amount":2500,"remaining_amount":0,"status":"approved","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:25:37"},{"id":3,"customer_id":1,"country":"UAE","visa_type":"Business","total_fee":6000,"paid_amount":6000,"remaining_amount":0,"status":"completed","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:27:53"},{"id":4,"customer_id":2,"country":"India","visa_type":"Tourist","total_fee":1500,"paid_amount":1500,"remaining_amount":0,"status":"completed","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:31:08"},{"id":5,"customer_id":3,"country":"Saudi Arabia","visa_type":"Medical","total_fee":1200,"paid_amount":1200,"remaining_amount":0,"status":"completed","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:37:30"},{"id":6,"customer_id":1,"country":"India","visa_type":"Medical","total_fee":1400,"paid_amount":1400,"remaining_amount":0,"status":"completed","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:44:17"},{"id":7,"customer_id":2,"country":"India","visa_type":"Business","total_fee":2000,"paid_amount":2000,"remaining_amount":0,"status":"refunded","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:44:57"},{"id":8,"customer_id":4,"country":"Tajikistan","visa_type":"Tourist","total_fee":1500,"paid_amount":1500,"remaining_amount":0,"status":"completed","submitted_date":"2026-06-08","notes":"","created_at":"2026-06-08 13:46:25"}],"wallets":[{"id":1,"customer_id":1,"balance":5500,"total_deposited":12400,"total_used":6900},{"id":2,"customer_id":2,"balance":5500,"total_deposited":6500,"total_used":1000},{"id":3,"customer_id":3,"balance":0,"total_deposited":320,"total_used":320},{"id":4,"customer_id":4,"balance":0,"total_deposited":1500,"total_used":1500}],"bookings":[{"id":1,"customer_id":1,"passenger_name":"AbdulBassir Mohammadi","passenger_passport":"P0948485844","passenger_phone":"0774881183","flight_origin":"kabul","flight_destination":"alaska","flight_date":"2025-11-29","flight_time":"12:00","flight_number":"Km0971","airline":"Kam aire","baggage_allowance":"30","amount":2000,"status":"confirmed","created_at":"2026-06-08 13:12:56"},{"id":2,"customer_id":2,"passenger_name":"Najeeb Mohammadi","passenger_passport":"P0948485877","passenger_phone":"0774881183","flight_origin":"dubai","flight_destination":"mazar","flight_date":"2023-12-27","flight_time":"12:59","flight_number":"Km0979","airline":"Kam aire","baggage_allowance":"20","amount":500,"status":"confirmed","created_at":"2026-06-08 18:04:37"},{"id":3,"customer_id":3,"passenger_name":"omar sedeqi","passenger_passport":"P0948485888","passenger_phone":"0774881183","flight_origin":"kabul","flight_destination":"herat","flight_date":"2025-01-01","flight_time":"01:00","flight_number":"Km0979","airline":"Kam aire","baggage_allowance":"20","amount":120,"status":"confirmed","created_at":"2026-06-08 18:22:43"}],"refunds":[{"id":1,"item_type":"visa","item_id":2,"customer_id":2,"customer_name":"Najeeb","original_amount":2500,"refund_amount":2000,"reason":"for rejecting visa 2000$ refunded.","status":"approved","admin_notes":"","created_at":"2026-06-08 13:56:00","processed_at":"2026-06-08 13:56:18"},{"id":2,"item_type":"visa","item_id":1,"customer_id":1,"customer_name":"AbdulBassir","original_amount":7000,"refund_amount":4000,"reason":"for rejecting visa","status":"approved","admin_notes":"","created_at":"2026-06-08 14:00:09","processed_at":"2026-06-08 14:00:18"},{"id":3,"item_type":"visa","item_id":3,"customer_id":1,"customer_name":"AbdulBassir","original_amount":6000,"refund_amount":5500,"reason":"for rejecting visa","status":"approved","admin_notes":"","created_at":"2026-06-08 14:01:30","processed_at":"2026-06-08 14:01:34"},{"id":4,"item_type":"visa","item_id":4,"customer_id":2,"customer_name":"Najeeb","original_amount":1500,"refund_amount":1000,"reason":"for rejecting visa.","status":"approved","admin_notes":"","created_at":"2026-06-08 14:10:30","processed_at":"2026-06-08 14:12:18"},{"id":5,"item_type":"visa","item_id":5,"customer_id":3,"customer_name":"omar","original_amount":1200,"refund_amount":1000,"reason":"rejected visa","status":"approved","admin_notes":"","created_at":"2026-06-08 14:11:36","processed_at":"2026-06-08 14:11:49"},{"id":6,"item_type":"visa","item_id":6,"customer_id":1,"customer_name":"AbdulBassir","original_amount":1400,"refund_amount":1000,"reason":"for visa rejection","status":"pending","admin_notes":null,"created_at":"2026-06-08 17:18:25","processed_at":null},{"id":7,"item_type":"visa","item_id":7,"customer_id":2,"customer_name":"Najeeb","original_amount":2000,"refund_amount":1500,"reason":"visa rejection","status":"approved","admin_notes":null,"created_at":"2026-06-08 17:24:11","processed_at":null}],"users":[{"id":1,"username":"Mohammadi","email":"abdulbassirmohammadi0110@gmail.com","password":"$2b$10$cbKfmWcgORp0DVm0beubneNGI1ZZqLYddlET5EMlsJGgqhyrxav8e","role":"admin","status":"active","last_login":null,"created_at":"2026-06-09 13:02:38"},{"id":2,"username":"Najeeb","email":"najeeb@gmail.com","password":"$2b$10$Lxwwv48Be5.pIH67atail.FWUoWyoGGkXVub3/NkLuX5gC6PanH2y","role":"manager","status":"active","last_login":"2026-06-09 13:48:23","created_at":"2026-06-09 13:09:51"}],"wallet_transactions":[{"id":1,"customer_id":1,"type":"purchase","amount":2000,"balance_before":0,"balance_after":0,"reference":"Booking #1","notes":"Flight ticket - kabul→alaska","created_at":"2026-06-08 13:12:56"},{"id":2,"customer_id":1,"type":"deposit","amount":1500,"balance_before":0,"balance_after":1500,"reference":"Visa #1","notes":"Visa prepayment - Turkey Tourist","created_at":"2026-06-08 13:14:06"},{"id":3,"customer_id":1,"type":"deposit","amount":5500,"balance_before":1500,"balance_after":7000,"reference":"Visa #1","notes":"Visa payment update - Turkey Tourist","created_at":"2026-06-08 13:15:45"},{"id":4,"customer_id":2,"type":"deposit","amount":1000,"balance_before":0,"balance_after":1000,"reference":"Visa #2","notes":"Visa prepayment - India Business","created_at":"2026-06-08 13:25:37"},{"id":5,"customer_id":2,"type":"withdraw","amount":2500,"balance_before":1000,"balance_after":-1500,"reference":"Visa #2","notes":"Visa completed - India Business","created_at":"2026-06-08 13:26:09"},{"id":6,"customer_id":1,"type":"withdraw","amount":7000,"balance_before":7000,"balance_after":0,"reference":"Visa #1","notes":"Visa completed - Turkey Tourist","created_at":"2026-06-08 13:27:09"},{"id":7,"customer_id":1,"type":"deposit","amount":2000,"balance_before":0,"balance_after":2000,"reference":"Visa #3","notes":"Visa prepayment - UAE Business","created_at":"2026-06-08 13:27:53"},{"id":8,"customer_id":2,"type":"deposit","amount":1500,"balance_before":-1500,"balance_after":0,"reference":"","notes":"","created_at":"2026-06-08 13:28:52"},{"id":9,"customer_id":1,"type":"withdraw","amount":6000,"balance_before":2000,"balance_after":-4000,"reference":"Visa #3","notes":"Visa completed - UAE Business","created_at":"2026-06-08 13:29:29"},{"id":10,"customer_id":2,"type":"deposit","amount":500,"balance_before":0,"balance_after":500,"reference":"Visa #4","notes":"Visa prepayment - India Tourist","created_at":"2026-06-08 13:31:08"},{"id":11,"customer_id":2,"type":"deposit","amount":200,"balance_before":500,"balance_after":700,"reference":"Visa #4","notes":"Visa payment update - India Tourist","created_at":"2026-06-08 13:31:35"},{"id":12,"customer_id":3,"type":"deposit","amount":200,"balance_before":0,"balance_after":200,"reference":"Visa #5","notes":"Visa prepayment - Saudi Arabia Medical","created_at":"2026-06-08 13:37:30"},{"id":13,"customer_id":3,"type":"withdraw","amount":1200,"balance_before":200,"balance_after":-1000,"reference":"Visa #5","notes":"Visa completed - Saudi Arabia Medical","created_at":"2026-06-08 13:37:59"},{"id":14,"customer_id":1,"type":"deposit","amount":400,"balance_before":-4000,"balance_after":-3600,"reference":"Visa #6","notes":"Visa prepayment - India Medical","created_at":"2026-06-08 13:44:17"},{"id":15,"customer_id":2,"type":"deposit","amount":1000,"balance_before":700,"balance_after":1700,"reference":"Visa #7","notes":"Visa prepayment - India Business","created_at":"2026-06-08 13:44:57"},{"id":16,"customer_id":2,"type":"deposit","amount":1000,"balance_before":1700,"balance_after":2700,"reference":"Visa #7","notes":"Additional payment - India Business","created_at":"2026-06-08 13:45:24"},{"id":17,"customer_id":2,"type":"withdraw","amount":2000,"balance_before":2700,"balance_after":700,"reference":"Visa #7","notes":"Visa completed - India Business","created_at":"2026-06-08 13:45:24"},{"id":18,"customer_id":4,"type":"deposit","amount":500,"balance_before":0,"balance_after":500,"reference":"Visa #8","notes":"Visa prepayment - Tajikistan Tourist","created_at":"2026-06-08 13:46:25"},{"id":19,"customer_id":4,"type":"deposit","amount":1000,"balance_before":500,"balance_after":1500,"reference":"Visa #8","notes":"Additional payment - Tajikistan Tourist","created_at":"2026-06-08 13:46:49"},{"id":20,"customer_id":4,"type":"withdraw","amount":1500,"balance_before":1500,"balance_after":0,"reference":"Visa #8","notes":"Visa completed - Tajikistan Tourist","created_at":"2026-06-08 13:46:49"},{"id":21,"customer_id":2,"type":"deposit","amount":2000,"balance_before":700,"balance_after":2700,"reference":"Refund #1","notes":"Refund for visa #2","created_at":"2026-06-08 13:56:18"},{"id":22,"customer_id":2,"type":"deposit","amount":800,"balance_before":2700,"balance_after":3500,"reference":"Visa #4","notes":"Additional payment - India Tourist","created_at":"2026-06-08 13:58:26"},{"id":23,"customer_id":2,"type":"withdraw","amount":1500,"balance_before":3500,"balance_after":2000,"reference":"Visa #4","notes":"Visa completed - India Tourist","created_at":"2026-06-08 13:58:27"},{"id":24,"customer_id":1,"type":"deposit","amount":1000,"balance_before":-3600,"balance_after":-2600,"reference":"Visa #6","notes":"Additional payment - India Medical","created_at":"2026-06-08 13:58:36"},{"id":25,"customer_id":1,"type":"withdraw","amount":1400,"balance_before":-2600,"balance_after":-4000,"reference":"Visa #6","notes":"Visa completed - India Medical","created_at":"2026-06-08 13:58:37"},{"id":26,"customer_id":1,"type":"deposit","amount":4000,"balance_before":-4000,"balance_after":0,"reference":"Refund #2","notes":"Refund for visa #1","created_at":"2026-06-08 14:00:18"},{"id":27,"customer_id":1,"type":"deposit","amount":5500,"balance_before":0,"balance_after":5500,"reference":"Refund #3","notes":"Refund for visa #3","created_at":"2026-06-08 14:01:34"},{"id":28,"customer_id":2,"type":"deposit","amount":1000,"balance_before":2000,"balance_after":3000,"reference":"Refund #4","notes":"Refund for visa #4","created_at":"2026-06-08 14:10:56"},{"id":29,"customer_id":3,"type":"deposit","amount":1000,"balance_before":-1000,"balance_after":0,"reference":"Refund #5","notes":"Refund for visa #5","created_at":"2026-06-08 14:11:49"},{"id":30,"customer_id":2,"type":"deposit","amount":1000,"balance_before":3000,"balance_after":4000,"reference":"Refund #4","notes":"Refund for visa #4","created_at":"2026-06-08 14:12:18"},{"id":31,"customer_id":2,"type":"deposit","amount":1500,"balance_before":4000,"balance_after":5500,"reference":"Refund #7","notes":"Refund for visa #7","created_at":"2026-06-08 17:24:11"},{"id":32,"customer_id":2,"type":"purchase","amount":500,"balance_before":5500,"balance_after":5500,"reference":"Booking #2","notes":"Flight ticket - dubai→mazar","created_at":"2026-06-08 18:04:37"},{"id":33,"customer_id":3,"type":"purchase","amount":120,"balance_before":0,"balance_after":0,"reference":"Booking #3","notes":"Flight ticket - kabul→herat","created_at":"2026-06-08 18:22:43"}],"transactions":[{"id":1,"type":"income","category":"Ticket Sale","description":"Booking #1 - kabul→alaska","amount":2000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:12:56"},{"id":2,"type":"income","category":"Visa Fee","description":"Visa #1 - Turkey Tourist","amount":1500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:14:06"},{"id":3,"type":"income","category":"Visa Fee","description":"Visa #1 - Turkey Tourist","amount":5500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:15:45"},{"id":4,"type":"income","category":"Visa Fee","description":"Visa #2 - India Business","amount":1000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:25:37"},{"id":5,"type":"income","category":"Visa Fee","description":"Visa #2 - India Business","amount":2500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:26:09"},{"id":6,"type":"income","category":"Visa Fee","description":"Visa #1 - Turkey Tourist","amount":7000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:27:09"},{"id":7,"type":"income","category":"Visa Fee","description":"Visa #3 - UAE Business","amount":2000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:27:53"},{"id":8,"type":"income","category":"Visa Fee","description":"Visa #3 - UAE Business","amount":6000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:29:29"},{"id":9,"type":"income","category":"Visa Fee","description":"Visa #4 - India Tourist","amount":500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:31:08"},{"id":10,"type":"income","category":"Visa Fee","description":"Visa #4 - India Tourist","amount":200,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:31:35"},{"id":11,"type":"income","category":"Visa Fee","description":"Visa #5 - Saudi Arabia Medical","amount":200,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:37:30"},{"id":12,"type":"income","category":"Visa Fee","description":"Visa #5 - Saudi Arabia Medical","amount":1200,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:37:59"},{"id":13,"type":"income","category":"Visa Fee","description":"Visa #6 - India Medical","amount":400,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:44:17"},{"id":14,"type":"income","category":"Visa Fee","description":"Visa #7 - India Business","amount":1000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:44:57"},{"id":15,"type":"income","category":"Visa Fee","description":"Visa #8 - Tajikistan Tourist","amount":500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:46:25"},{"id":16,"type":"expense","category":"Refund","description":"Refund #1 - visa","amount":2000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 13:56:18"},{"id":17,"type":"expense","category":"Refund","description":"Refund #2 - visa","amount":4000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 14:00:18"},{"id":18,"type":"expense","category":"Refund","description":"Refund #3 - visa","amount":5500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 14:01:34"},{"id":19,"type":"expense","category":"Refund","description":"Refund #4 - visa","amount":1000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 14:10:56"},{"id":20,"type":"expense","category":"Refund","description":"Refund #5 - visa","amount":1000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 14:11:49"},{"id":21,"type":"expense","category":"Refund","description":"Refund #4 - visa","amount":1000,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 14:12:18"},{"id":22,"type":"expense","category":"Refund","description":"Refund #7 - visa","amount":1500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 17:24:11"},{"id":23,"type":"income","category":"Ticket Sale","description":"Booking #2 - dubai→mazar","amount":500,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 18:04:37"},{"id":24,"type":"income","category":"Ticket Sale","description":"Booking #3 - kabul→herat","amount":120,"date":"2026-06-08","payment_method":"system","reference":null,"created_at":"2026-06-08 18:22:43"}],"airlines":[]}