EVOLUTION-NINJA

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

INFO - 2025-01-27 05:58:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 05:58:33 --> ErrorException: Undefined property: App\Controllers\Report::$db
[Method: POST, Route: get-initialPins-report]
in APPPATH/Controllers/Report.php on line 71.
 1 APPPATH/Controllers/Report.php(71): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Undefined property: App\\Controllers\\Report::$db', '/home/injayblues/public_html/Green_Palace_Heritage/app/Controllers/Report.php', 71)
 2 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_initialPins_report()
 3 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 05:59:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:01:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:32:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:02:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:32:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 11:32:39 --> Promoter ID: 6
DEBUG - 2025-01-27 11:32: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-27 11:32: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] => 15250
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 39
    [total_request] => 1
    [total_initial] => 4
)

INFO - 2025-01-27 06:03:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:33:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:04:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:05:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 06:05:44 --> CodeIgniter\View\Exceptions\ViewException: Invalid file: "report/repayment_pins_report.php"
[Method: GET, Route: repayment-pins-report]
in SYSTEMPATH/Exceptions/FrameworkException.php on line 41.
 1 SYSTEMPATH/View/View.php(222): CodeIgniter\Exceptions\FrameworkException::forInvalidFile('report/repayment_pins_report.php')
 2 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('report/repayment_pins_report', [], true)
 3 APPPATH/Controllers/Home.php(237): view('report/repayment_pins_report')
 4 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Home->repayment_pins_report()
 5 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
 6 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 8 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 9 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 06:07:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:07:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:09:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:39:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 11:39:04 --> Promoter ID: 6
DEBUG - 2025-01-27 11:39:04 --> 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-27 11:39: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] => 6
    [role] => 1
    [role_name] => promoter
    [created_at] => 0000-00-00 00:00:00.000000
    [user_id] => 6
    [total_earnings] => 15500
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 40
    [total_request] => 1
    [total_initial] => 4
)

INFO - 2025-01-27 06:10:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:44:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:15:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:45:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:16:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:46:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:17:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:47:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:18:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:48:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:18:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:48:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:21:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:52:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:22:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:53:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:28:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 11:58:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:00:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:30:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 06:30:48 --> CodeIgniter\View\Exceptions\ViewException: Invalid file: "report/withdraw_report.php"
[Method: GET, Route: Withdraw-report]
in SYSTEMPATH/Exceptions/FrameworkException.php on line 41.
 1 SYSTEMPATH/View/View.php(222): CodeIgniter\Exceptions\FrameworkException::forInvalidFile('report/withdraw_report.php')
 2 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('report/withdraw_report', [], true)
 3 APPPATH/Controllers/Home.php(189): view('report/withdraw_report')
 4 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Home->withdraw_report()
 5 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
 6 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 8 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 9 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 06:31:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:31:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:01:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:32:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:32:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:32:41 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:34:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:34:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 06:34:14 --> CodeIgniter\View\Exceptions\ViewException: Invalid file: "report/payment_report.php"
[Method: GET, Route: payment-report]
in SYSTEMPATH/Exceptions/FrameworkException.php on line 41.
 1 SYSTEMPATH/View/View.php(222): CodeIgniter\Exceptions\FrameworkException::forInvalidFile('report/payment_report.php')
 2 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('report/payment_report', [], true)
 3 APPPATH/Controllers/Home.php(225): view('report/payment_report')
 4 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Home->payment_report()
 5 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
 6 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 7 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 8 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 9 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 12:04:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:35:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:36:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:38:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:38:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:38:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:40:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:41:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:41:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:41:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:41:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:41:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:41:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:46:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:17:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:47:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:47:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:47:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:17:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:17:31 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-27 12:17:31 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-27 12:17:31 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-27 12:17:31 --> Customer Count: Array
(
    [total_customers] => 57
)

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

INFO - 2025-01-27 06:47:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:51:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:21:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:54:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 06:54:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:02:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:02:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:02:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:02:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:06:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:06:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:08:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:38:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:38:50 --> Promoter ID: 6
DEBUG - 2025-01-27 12:38: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-27 12:38: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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 1
    [total_initial] => 4
)

INFO - 2025-01-27 07:10:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:10:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:11:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:41:00 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-27 12:41:00 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-27 12:41:00 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-27 12:41:00 --> Customer Count: Array
(
    [total_customers] => 57
)

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

INFO - 2025-01-27 12:41:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:11:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:41:29 --> Promoter ID: 6
DEBUG - 2025-01-27 12:41:29 --> 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-27 12:41:29 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 1
    [total_initial] => 4
)

INFO - 2025-01-27 07:11:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:11:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:11:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:11:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:41:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:12:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:42:54 --> Promoter ID: 6
DEBUG - 2025-01-27 12:42: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-27 12:42: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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 07:12:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:42:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:43:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:43:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:43:03 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-27 12:43:03 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-27 12:43:03 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-27 12:43:03 --> Customer Count: Array
(
    [total_customers] => 57
)

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

INFO - 2025-01-27 12:43:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:43:04 --> Promoter ID: 6
DEBUG - 2025-01-27 12:43:04 --> 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-27 12:43: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] => 6
    [role] => 1
    [role_name] => promoter
    [created_at] => 0000-00-00 00:00:00.000000
    [user_id] => 6
    [total_earnings] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 07:13:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:43:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:13:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:14:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:14:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:44:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:14:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:14:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:44:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:44:18 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-27 12:44:18 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-27 12:44:18 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-27 12:44:18 --> Customer Count: Array
(
    [total_customers] => 57
)

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

INFO - 2025-01-27 07:14:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:14:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:15:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:15:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:15:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:15:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:15:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:15:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:18:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:18:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:18:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:18:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:18:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:18:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:24:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:54:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 12:54:13 --> Promoter ID: 6
DEBUG - 2025-01-27 12:54: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-27 12:54: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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 07:25:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 12:55:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:43:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:43:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:13:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:18:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:48:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:48:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:48:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:18:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 13:18:50 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-27 13:18:50 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-27 13:18:50 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-27 13:18:50 --> Customer Count: Array
(
    [total_customers] => 57
)

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

INFO - 2025-01-27 07:48:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:48:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:49:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:19:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:19:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:49:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:19:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 13:19:21 --> Promoter ID: 6
DEBUG - 2025-01-27 13:19:21 --> 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-27 13:19:21 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 07:49:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:19:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 07:57:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:41:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:11:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:41:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 13:41:04 --> Promoter ID: 6
DEBUG - 2025-01-27 13:41:04 --> 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-27 13:41: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] => 6
    [role] => 1
    [role_name] => promoter
    [created_at] => 0000-00-00 00:00:00.000000
    [user_id] => 6
    [total_earnings] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 08:11:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:41:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:11:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:11:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:41:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:20:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:50:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:29:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:59:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:29:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:59:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:29:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:59:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 13:59:38 --> Promoter ID: 6
DEBUG - 2025-01-27 13:59: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-27 13:59:38 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 08:29:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:59:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:30:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:00:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:33:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:03:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:34:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:04:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:16:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:17:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:17:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:47:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:17:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 14:17:37 --> Promoter ID: 6
DEBUG - 2025-01-27 14:17: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-27 14:17: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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 14:17:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:19:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:21:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:51:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:21:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 14:21:14 --> Promoter ID: 6
DEBUG - 2025-01-27 14:21: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-27 14:21:14 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 08:51:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:21:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 14:21:17 --> Promoter ID: 6
DEBUG - 2025-01-27 14:21:17 --> 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-27 14:21:17 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 14:21:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:21:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 08:52:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 14:22:21 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-27 14:22:21 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-27 14:22:21 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-27 14:22:21 --> Customer Count: Array
(
    [total_customers] => 57
)

DEBUG - 2025-01-27 14:22:21 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-27 14:22:21 --> Amount Data: Array
(
    [total_amount] => 21000
)

INFO - 2025-01-27 14:22:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:41 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:22:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:26:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:51:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 14:52:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:08:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:09:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 09:43:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:15:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 09:45:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:15:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 15:15:28 --> Promoter ID: 6
DEBUG - 2025-01-27 15:15:28 --> 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-27 15:15:28 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 15:20:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:21:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 09:54:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:24:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 15:24:58 --> Promoter ID: 6
DEBUG - 2025-01-27 15:24: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-27 15:24:58 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 09:55:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:25:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 15:25:15 --> Promoter ID: 6
DEBUG - 2025-01-27 15:25:15 --> 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-27 15:25: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] => 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-27 15:25:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 09:55:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 09:55:28 --> ParseError: syntax error, unexpected single-quoted string ");
", expecting ")"
[Method: GET, Route: promoter-details]
in APPPATH/Controllers/Promoter.php on line 585.
 1 FCPATH/vendor/composer/ClassLoader.php(427): Composer\Autoload\{closure}('/home/injayblues/public_html/Green_Palace_Heritage/vendor/composer/../../app/Controllers/Promoter.php')
 2 [internal function]: Composer\Autoload\ClassLoader->loadClass('App\\Controllers\\Promoter')
 3 SYSTEMPATH/CodeIgniter.php(887): class_exists('\\App\\Controllers\\Promoter', true)
 4 SYSTEMPATH/CodeIgniter.php(496): CodeIgniter\CodeIgniter->startController()
 5 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 6 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 7 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 8 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 09:59:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:29:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:33:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:35:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 15:35:32 --> Error: Object of class stdClass could not be converted to string
[Method: POST, Route: withdraw-amount-request]
in SYSTEMPATH/Database/Query.php on line 337.
 1 SYSTEMPATH/Database/Query.php(337): strtr('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 2 SYSTEMPATH/Database/Query.php(312): CodeIgniter\Database\Query->matchNamedBinds('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 3 SYSTEMPATH/Database/Query.php(163): CodeIgniter\Database\Query->compileBinds()
 4 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\Query->getQuery()
 5 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...], false)
 6 APPPATH/Controllers/Promoter.php(594): CodeIgniter\Database\BaseBuilder->get()
 7 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request()
 8 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 9 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
10 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
12 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 15:37:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 15:37:30 --> Error: Object of class stdClass could not be converted to string
[Method: POST, Route: withdraw-amount-request]
in SYSTEMPATH/Database/Query.php on line 337.
 1 SYSTEMPATH/Database/Query.php(337): strtr('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 2 SYSTEMPATH/Database/Query.php(312): CodeIgniter\Database\Query->matchNamedBinds('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 3 SYSTEMPATH/Database/Query.php(163): CodeIgniter\Database\Query->compileBinds()
 4 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\Query->getQuery()
 5 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...], false)
 6 APPPATH/Controllers/Promoter.php(594): CodeIgniter\Database\BaseBuilder->get()
 7 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request()
 8 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 9 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
10 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
12 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 15:39:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 15:39:22 --> Error: Object of class stdClass could not be converted to string
[Method: POST, Route: withdraw-amount-request]
in SYSTEMPATH/Database/Query.php on line 337.
 1 SYSTEMPATH/Database/Query.php(337): strtr('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 2 SYSTEMPATH/Database/Query.php(312): CodeIgniter\Database\Query->matchNamedBinds('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 3 SYSTEMPATH/Database/Query.php(163): CodeIgniter\Database\Query->compileBinds()
 4 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\Query->getQuery()
 5 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...], false)
 6 APPPATH/Controllers/Promoter.php(594): CodeIgniter\Database\BaseBuilder->get()
 7 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request()
 8 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 9 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
10 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
12 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 10:10:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:40:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:41:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-27 15:41:31 --> Error: Object of class stdClass could not be converted to string
[Method: POST, Route: withdraw-amount-request]
in SYSTEMPATH/Database/Query.php on line 337.
 1 SYSTEMPATH/Database/Query.php(337): strtr('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 2 SYSTEMPATH/Database/Query.php(312): CodeIgniter\Database\Query->matchNamedBinds('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...])
 3 SYSTEMPATH/Database/Query.php(163): CodeIgniter\Database\Query->compileBinds()
 4 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\Query->getQuery()
 5 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT SUM(amount) as total_amount
FROM `promoter_payments`
WHERE `promoter_id` = :promoter_id:
AND `scheme` = :scheme:', [...], false)
 6 APPPATH/Controllers/Promoter.php(594): CodeIgniter\Database\BaseBuilder->get()
 7 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request()
 8 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 9 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
10 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
12 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-27 10:16:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:46:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-27 15:46:51 --> Promoter ID: 6
DEBUG - 2025-01-27 15:46: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-27 15:46:51 --> 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] => 18350
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 51
    [total_request] => 2
    [total_initial] => 4
)

INFO - 2025-01-27 15:51:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:52:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:53:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:53:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:54:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:54:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:54:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:54:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:54:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:55:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:55:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:55:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:55:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:55:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:58:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 15:58:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:00:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:02:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:02:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:03:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:03:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:04:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:06:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:06:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:06:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:07:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:07:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:07:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:07:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:08:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:08:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:09:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:09:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:09:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:09:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:09:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:10:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:10:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:11:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:11:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:11:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:11:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:13:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:13:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:13:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:14:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:14:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:17:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:19:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:19:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:20:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:20:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:27:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:28:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 16:29:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-27 13:54:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.