EVOLUTION-NINJA

Edit File: log-2025-01-24.log

INFO - 2025-01-24 03:45:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 05:32:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:24:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 05:54:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:24:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 11:24:52 --> Promoter ID: 6 DEBUG - 2025-01-24 11:24:52 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 11:24:52 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:32:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:03:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 06:33:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:03:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:03:10 --> Promoter ID: 6 DEBUG - 2025-01-24 12:03:10 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:03:10 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:33:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:03:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:03:13 --> Promoter ID: 6 DEBUG - 2025-01-24 12:03:13 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:03:13 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:33:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:03:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:03:32 --> Promoter ID: 6 DEBUG - 2025-01-24 12:03:32 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:03:32 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:33:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:03:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:03:39 --> Promoter ID: 6 DEBUG - 2025-01-24 12:03:39 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:03:39 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:33:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:03:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:03:50 --> Promoter ID: 6 DEBUG - 2025-01-24 12:03:50 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:03:50 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:33:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:04:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:04:00 --> Promoter ID: 6 DEBUG - 2025-01-24 12:04:00 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:04:00 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:34:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:04:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:04:08 --> Promoter ID: 6 DEBUG - 2025-01-24 12:04:08 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:04:08 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:34:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:04:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:04:26 --> Promoter ID: 6 DEBUG - 2025-01-24 12:04:26 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:04:26 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:34:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:04:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:04:30 --> Promoter ID: 6 DEBUG - 2025-01-24 12:04:30 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:04:30 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:34:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:04:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:04:37 --> Promoter ID: 6 DEBUG - 2025-01-24 12:04:37 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:04:37 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:36:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:06:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 06:36:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:06:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 06:39:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:09:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:09:50 --> Promoter ID: 6 DEBUG - 2025-01-24 12:09:50 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:09:50 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:40:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:10:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:10:20 --> Promoter ID: 6 DEBUG - 2025-01-24 12:10:20 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:10:20 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:45:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:15:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:15:51 --> Promoter ID: 6 DEBUG - 2025-01-24 12:15:52 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:15:52 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:46:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:16:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:16:54 --> Promoter ID: 6 DEBUG - 2025-01-24 12:16:54 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:16:54 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:46:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:16:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:16:55 --> Promoter ID: 6 DEBUG - 2025-01-24 12:16:55 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:16:55 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 12:17:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 06:47:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:17:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:17:56 --> Promoter ID: 6 DEBUG - 2025-01-24 12:17:56 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `user`. `name`, `user`.`phone`, `user`.`email`, `user_details`.`address`, `user_details`.`city`, `user_details`.`state`, `user_details`.`account_no`, `user_details`.`account_holder_name`, `user_details`.`bank_name`, `user_details`.`ifsc_code`, `user_details`.`branch`, `user_details`.`upi_id`, `user_details`.`branch_address` FROM `user` LEFT JOIN `user_details` ON `user`.`id`= `user_details`.`user_id` WHERE `user`.`id` = '6' GROUP BY `user`.`promoter_id` DEBUG - 2025-01-24 12:17:56 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => PID5453 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [address] => N.BELATHURU VILLAGE AND POST [city] => H D KOTE [state] => Karnataka [account_no] => 31094335889 [account_holder_name] => Kavya t [bank_name] => STATE BANK OF INDIA [ifsc_code] => SBIN0007916 [branch] => VISHVESHVARAYYA CIRCLE [upi_id] => 8197714465@ybl [branch_address] => N. Belathur( v & p ) ) INFO - 2025-01-24 06:48:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:18:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:18:15 --> Promoter ID: 6 DEBUG - 2025-01-24 12:18:15 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:18:15 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:58:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:28:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:28:48 --> Promoter ID: 6 DEBUG - 2025-01-24 12:28:48 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:28:48 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 06:58:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:00:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:30:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:01:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:31:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:01:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:31:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:31:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:01:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:31:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:31:52 --> Promoter ID: 6 DEBUG - 2025-01-24 12:31:52 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:31:52 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 07:01:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:31:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:31:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:02:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:32:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:02:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:32:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:32:52 --> Promoter ID: 6 DEBUG - 2025-01-24 12:32:52 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:32:52 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 12:33:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:03:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:33:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:33:05 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email` FROM `admin` WHERE `admin`.`id` = '1' DEBUG - 2025-01-24 12:33:05 --> Admin Data: Array ( [id] => 1 [username] => kavya [role_name] => Super Admin [email] => kavyat7349@gmail.com ) DEBUG - 2025-01-24 12:33:05 --> Customer Query: SELECT COUNT(id) as total_pins FROM `promoter_repayment_requests` DEBUG - 2025-01-24 12:33:05 --> Customer Count: Array ( [total_customers] => 24 ) DEBUG - 2025-01-24 12:33:05 --> Amount Query: SELECT SUM(amount) as total_amount FROM `payments` DEBUG - 2025-01-24 12:33:05 --> Amount Data: Array ( [total_amount] => 21000 ) INFO - 2025-01-24 07:03:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:03:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:03:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:33:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:04:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:34:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:10:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:40:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:10:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:40:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:40:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:10:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:40:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:40:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:10:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:40:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:12:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:42:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:13:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:43:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:13:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:43:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 12:43:35 --> Promoter ID: 6 DEBUG - 2025-01-24 12:43:35 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 12:43:35 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 07:18:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:24:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 12:54:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:42:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 13:12:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 07:59:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 10:22:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 15:53:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 10:23:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 15:53:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 15:53:22 --> Promoter ID: 6 DEBUG - 2025-01-24 15:53:22 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 15:53:22 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 10:27:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 16:24:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:21:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:28:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:31:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:03:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:33:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:03:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:03:16 --> Promoter ID: 6 DEBUG - 2025-01-24 17:03:16 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 17:03:16 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 11:34:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:04:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:04:04 --> Promoter ID: 6 DEBUG - 2025-01-24 17:04:04 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `user`. `name`, `user`.`phone`, `user`.`email`, `user_details`.`address`, `user_details`.`city`, `user_details`.`state`, `user_details`.`account_no`, `user_details`.`account_holder_name`, `user_details`.`bank_name`, `user_details`.`ifsc_code`, `user_details`.`branch`, `user_details`.`upi_id`, `user_details`.`branch_address` FROM `user` LEFT JOIN `user_details` ON `user`.`id`= `user_details`.`user_id` WHERE `user`.`id` = '6' GROUP BY `user`.`promoter_id` DEBUG - 2025-01-24 17:04:04 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => PID5453 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [address] => N.BELATHURU VILLAGE AND POST [city] => H D KOTE [state] => Karnataka [account_no] => 31094335889 [account_holder_name] => Kavya t [bank_name] => STATE BANK OF INDIA [ifsc_code] => SBIN0007916 [branch] => VISHVESHVARAYYA CIRCLE [upi_id] => 8197714465@ybl [branch_address] => N. Belathur( v & p ) ) INFO - 2025-01-24 11:34:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:04:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:04:16 --> Promoter ID: 6 DEBUG - 2025-01-24 17:04:16 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `user`. `name`, `user`.`phone`, `user`.`email`, `user_details`.`address`, `user_details`.`city`, `user_details`.`state`, `user_details`.`account_no`, `user_details`.`account_holder_name`, `user_details`.`bank_name`, `user_details`.`ifsc_code`, `user_details`.`branch`, `user_details`.`upi_id`, `user_details`.`branch_address` FROM `user` LEFT JOIN `user_details` ON `user`.`id`= `user_details`.`user_id` WHERE `user`.`id` = '6' GROUP BY `user`.`promoter_id` DEBUG - 2025-01-24 17:04:16 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => PID5453 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [address] => N.BELATHURU VILLAGE AND POST [city] => H D KOTE [state] => Karnataka [account_no] => 31094335889 [account_holder_name] => Kavya t [bank_name] => STATE BANK OF INDIA [ifsc_code] => SBIN0007916 [branch] => VISHVESHVARAYYA CIRCLE [upi_id] => 8197714465@ybl [branch_address] => N. Belathur( v & p ) ) INFO - 2025-01-24 11:34:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:04:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:04:18 --> Promoter ID: 6 DEBUG - 2025-01-24 17:04:18 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 17:04:18 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 11:34:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:04:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:34:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:34:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:04:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:34:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:35:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:35:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:05:17 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email` FROM `admin` WHERE `admin`.`id` = '1' DEBUG - 2025-01-24 17:05:17 --> Admin Data: Array ( [id] => 1 [username] => kavya [role_name] => Super Admin [email] => kavyat7349@gmail.com ) DEBUG - 2025-01-24 17:05:17 --> Customer Query: SELECT COUNT(id) as total_pins FROM `promoter_repayment_requests` DEBUG - 2025-01-24 17:05:17 --> Customer Count: Array ( [total_customers] => 24 ) DEBUG - 2025-01-24 17:05:17 --> Amount Query: SELECT SUM(amount) as total_amount FROM `payments` DEBUG - 2025-01-24 17:05:17 --> Amount Data: Array ( [total_amount] => 21000 ) INFO - 2025-01-24 11:35:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:35:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:35:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:35:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:35:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:05:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:05:45 --> Promoter ID: 6 DEBUG - 2025-01-24 17:05:45 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 17:05:45 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 11:36:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:36:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:36:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:36:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:36:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:36:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 11:36:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:06:18 --> Promoter ID: 6 DEBUG - 2025-01-24 17:06:18 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 17:06:18 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 11:36:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:06:19 --> Promoter ID: 6 DEBUG - 2025-01-24 17:06:19 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `user`. `name`, `user`.`phone`, `user`.`email`, `user_details`.`address`, `user_details`.`city`, `user_details`.`state`, `user_details`.`account_no`, `user_details`.`account_holder_name`, `user_details`.`bank_name`, `user_details`.`ifsc_code`, `user_details`.`branch`, `user_details`.`upi_id`, `user_details`.`branch_address` FROM `user` LEFT JOIN `user_details` ON `user`.`id`= `user_details`.`user_id` WHERE `user`.`id` = '6' GROUP BY `user`.`promoter_id` DEBUG - 2025-01-24 17:06:19 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => PID5453 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [address] => N.BELATHURU VILLAGE AND POST [city] => H D KOTE [state] => Karnataka [account_no] => 31094335889 [account_holder_name] => Kavya t [bank_name] => STATE BANK OF INDIA [ifsc_code] => SBIN0007916 [branch] => VISHVESHVARAYYA CIRCLE [upi_id] => 8197714465@ybl [branch_address] => N. Belathur( v & p ) ) INFO - 2025-01-24 11:36:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 17:06:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-24 17:06:19 --> Promoter ID: 6 DEBUG - 2025-01-24 17:06:19 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-24 17:06:19 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 18 [total_request] => 1 [total_initial] => 4 ) INFO - 2025-01-24 11:42:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-24 15:12:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.