EVOLUTION-NINJA

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

INFO - 2025-01-15 12:08:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:38:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:38:29 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-15 17:38:29 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-15 17:38:29 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-15 17:38:29 --> Customer Count: Array
(
    [total_customers] => 17
)

DEBUG - 2025-01-15 17:38:29 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-15 17:38:29 --> Amount Data: Array
(
    [total_amount] => 21000
)

INFO - 2025-01-15 12:08:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:38:45 --> SQL Query: SELECT *
FROM `payments`
DEBUG - 2025-01-15 17:38:47 --> SQL Query: SELECT *
FROM `payments`
WHERE `payments`.`scheme` = '2'
INFO - 2025-01-15 12:08:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:38:52 --> SQL Query: SELECT *
FROM `payments`
DEBUG - 2025-01-15 17:38:53 --> SQL Query: SELECT *
FROM `payments`
DEBUG - 2025-01-15 17:38:55 --> SQL Query: SELECT *
FROM `payments`
INFO - 2025-01-15 12:09:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:09:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:12:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:13:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:13:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:43:10 --> SQL Query: SELECT *
FROM `payments`
DEBUG - 2025-01-15 17:43:13 --> SQL Query: SELECT *
FROM `payments`
DEBUG - 2025-01-15 17:43:17 --> SQL Query: SELECT *
FROM `payments`
WHERE `payments`.`scheme` = '6'
DEBUG - 2025-01-15 17:43:26 --> SQL Query: SELECT *
FROM `payments`
WHERE `payments`.`scheme` = '7'
INFO - 2025-01-15 12:13:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:43:32 --> SQL Query: SELECT *
FROM `payments`
INFO - 2025-01-15 12:13:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:43:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:43:45 --> Promoter ID: 1
DEBUG - 2025-01-15 17:43:45 --> 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` = '1'
GROUP BY `user`.`promoter_id`
DEBUG - 2025-01-15 17:43:45 --> Data: 
INFO - 2025-01-15 12:13:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:43:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:43:51 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-15 17:43:51 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-15 17:43:51 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-15 17:43:51 --> Customer Count: Array
(
    [total_customers] => 17
)

DEBUG - 2025-01-15 17:43:51 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-15 17:43:51 --> Amount Data: Array
(
    [total_amount] => 21000
)

INFO - 2025-01-15 12:19:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:49:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:49:47 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-15 17:49:47 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-15 17:49:47 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-15 17:49:47 --> Customer Count: Array
(
    [total_customers] => 17
)

DEBUG - 2025-01-15 17:49:47 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-15 17:49:47 --> Amount Data: Array
(
    [total_amount] => 21000
)

INFO - 2025-01-15 12:19:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:49:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:49:54 --> Promoter ID: 1
DEBUG - 2025-01-15 17:49:54 --> 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` = '1'
GROUP BY `user`.`promoter_id`
DEBUG - 2025-01-15 17:49:54 --> Data: 
INFO - 2025-01-15 12:19:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:49:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:49:58 --> Promoter ID: 1
DEBUG - 2025-01-15 17:49:58 --> 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` = '1'
GROUP BY `user`.`promoter_id`
DEBUG - 2025-01-15 17:49:58 --> Data: 
INFO - 2025-01-15 12:19:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 17:50:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 17:50:00 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-15 17:50:00 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-15 17:50:00 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-15 17:50:00 --> Customer Count: Array
(
    [total_customers] => 17
)

DEBUG - 2025-01-15 17:50:00 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-15 17:50:00 --> Amount Data: Array
(
    [total_amount] => 21000
)

INFO - 2025-01-15 18:11:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:41:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:11:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 18:11:18 --> Promoter ID: 6
DEBUG - 2025-01-15 18:11: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-15 18:11:18 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 3700
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 11
    [total_request] => 1
    [total_initial] => 2
)

INFO - 2025-01-15 12:41:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:15:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:46:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:16:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:47:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:17:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:48:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:49:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:19:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:49:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:49:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:19:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:49:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:19:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 18:19:51 --> Promoter ID: 6
DEBUG - 2025-01-15 18:19:51 --> 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-15 18:19:51 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 2
)

INFO - 2025-01-15 12:50:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:20:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:25:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:25:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 12:57:41 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:27:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 18:27:43 --> Promoter ID: 6
DEBUG - 2025-01-15 18:27:43 --> 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-15 18:27:43 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => mysore
    [state] => karnataka 
    [account_no] => 31094335889
    [account_holder_name] => Kavya
    [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-15 12:58:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:28:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 18:28:12 --> Promoter ID: 6
DEBUG - 2025-01-15 18:28:12 --> 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-15 18:28:12 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 3
)

INFO - 2025-01-15 18:33:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:03:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:33:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 18:33:06 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-15 18:33:06 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-15 18:33:06 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-15 18:33:06 --> Customer Count: Array
(
    [total_customers] => 18
)

DEBUG - 2025-01-15 18:33:06 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-15 18:33:06 --> Amount Data: Array
(
    [total_amount] => 21000
)

INFO - 2025-01-15 13:03:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:03:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:04:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 18:34:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:19:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:49:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:19:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 19:19:22 --> Promoter ID: 6
DEBUG - 2025-01-15 19:19: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-15 19:19:22 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 3
)

INFO - 2025-01-15 13:49:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:19:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 19:20:03 --> Promoter ID: 6
DEBUG - 2025-01-15 19:20:03 --> 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-15 19:20:03 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 3
)

INFO - 2025-01-15 13:50:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 19:20:38 --> Promoter ID: 6
DEBUG - 2025-01-15 19:20:38 --> 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-15 19:20:38 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 3
)

INFO - 2025-01-15 13:50:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:50:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:20:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 19:20:58 --> Promoter ID: 6
DEBUG - 2025-01-15 19:20:58 --> 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-15 19:20:58 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 3
)

INFO - 2025-01-15 13:51:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:21:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:22:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:22:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 13:52:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-15 19:22:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-15 19:22:14 --> Promoter ID: 6
DEBUG - 2025-01-15 19:22:14 --> 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-15 19:22:14 --> Data: Array
(
    [id] => 6
    [name] => kavya 
    [email] => Kvy547@gmail.com
    [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] => 4200
    [total_amount] => 12000
    [city] => mysore
    [total_customers] => 12
    [total_request] => 1
    [total_initial] => 4
)