EVOLUTION-NINJA

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

INFO - 2025-01-23 06:18:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
ERROR - 2025-01-23 11:48:05 --> mysqli_sql_exception: execute command denied to user 'injayblues_injayblues'@'localhost' for routine 'promoter_repayment_requests.DATE_FORMAT' in /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312
Stack trace:
#0 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT promoter...', 0)
#1 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT promoter...')
#2 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT promoter...')
#3 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT promoter...', Array, false)
#4 /home/injayblues/public_html/Green_Palace_Heritage/app/Controllers/Repayment.php(353): CodeIgniter\Database\BaseBuilder->get()
#5 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Repayment->get_repayment_report()
#6 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Repayment))
#7 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#8 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run()
#9 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#10 /home/injayblues/public_html/Green_Palace_Heritage/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#11 {main}
CRITICAL - 2025-01-23 11:48:05 --> CodeIgniter\Database\Exceptions\DatabaseException: execute command denied to user 'injayblues_injayblues'@'localhost' for routine 'promoter_repayment_requests.DATE_FORMAT'
[Method: POST, Route: get-repayment-report]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`', [], false)
 2 APPPATH/Controllers/Repayment.php(353): CodeIgniter\Database\BaseBuilder->get()
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Repayment->get_repayment_report()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Repayment))
 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))
CRITICAL - 2025-01-23 11:48:05 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: execute command denied to user 'injayblues_injayblues'@'localhost' for routine 'promoter_repayment_requests.DATE_FORMAT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 317.
 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`')
 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`', [], false)
 4 APPPATH/Controllers/Repayment.php(353): CodeIgniter\Database\BaseBuilder->get()
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Repayment->get_repayment_report()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Repayment))
 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-23 11:48:05 --> [Caused by] mysqli_sql_exception: execute command denied to user 'injayblues_injayblues'@'localhost' for routine 'promoter_repayment_requests.DATE_FORMAT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 312.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`')
 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT promoter_repayment_requests.DATE_FORMAT(created_at, \'%b - %Y\') as month_year, `promoter_repayment_requests`.`scheme`, promoter_repayment_requests.SUM(total_slots) as total_slots, `schemes`.`id`, `schemes`.`scheme` as `scheme_name`
FROM `promoter_repayment_requests`
JOIN `schemes` ON `promoter_repayment_requests`.`scheme`=`schemes`.`id`
GROUP BY DATE_FORMAT(created_at, \'%b %Y\'), `scheme`', [], false)
 5 APPPATH/Controllers/Repayment.php(353): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Repayment->get_repayment_report()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Repayment))
 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-23 06:20:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:21:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:22:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:22:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:23:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:23:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:23:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:26:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:26:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:28:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:28:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:28:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:28:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:28:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:28:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:41 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:29:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:30:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:30:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:31:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:31:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:31:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:31:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:32:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:39:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:41:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:43:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:44:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:44:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:44:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:14:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:44:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:46:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:46:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:46:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:46:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:46:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:47:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:47:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:47:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:47:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:47:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:48:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:48:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:48:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:48:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:48:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:49:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:49:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:49:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:49:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:50:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:50:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:51:41 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:51:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:21:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:51:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:52:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:52:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:22:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:52:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:52:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:22:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:23:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:24:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:24:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:25:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:26:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:56:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:26:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 12:26:14 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 12:26:14 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 12:26:14 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 12:26:14 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 06:56:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:58:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:58:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 06:59:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:01:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:01:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:31:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:01:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:01:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:01:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:31:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:32:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:03:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:03:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:33:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:03:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:03:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:03:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:03:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:09:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:09:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:39:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 12:39:11 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 12:39:11 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 12:39:11 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 12:39:11 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 07:09:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:34:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:36:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:38:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:39:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:40:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:41:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:42:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:42:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:43:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:43:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:43:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:44:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:44:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:44:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:45:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:50:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:50:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:50:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:50:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:52:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:52:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:53:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:53:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:53:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:53:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:54:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:54:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 07:54:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:03:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:03:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:03:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:04:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:09:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:09:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:10:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 13:58:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:28:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 13:58:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 13:58:41 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 13:58:41 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 13:58:41 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 13:58:41 --> Customer Count: Array
(
    [total_customers] => 24
)

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

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

DEBUG - 2025-01-23 13:59:43 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 13:59:43 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 13:59:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:05:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:35:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:05:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 14:05:03 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 14:05:03 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 14:05:03 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 14:05:03 --> Customer Count: Array
(
    [total_customers] => 24
)

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

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

DEBUG - 2025-01-23 14:11:23 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 14:11:23 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 08:41:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:41:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:41:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:42:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:12:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 14:12:09 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 14:12:09 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 14:12:09 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 14:12:09 --> Customer Count: Array
(
    [total_customers] => 24
)

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

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

DEBUG - 2025-01-23 14:12:45 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 14:12:45 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 14:13:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:13:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:13:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:43:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:13:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 14:13:49 --> Query: SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`email`, `Customers`.`city`, `Customers`.`mobile`, (SELECT SUM(amount) FROM payments WHERE Customers.id = payments.user_id) as total_payment, (SELECT COUNT(payment_date) FROM payments WHERE Customers.id = payments.user_id) as total_months
FROM `Customers`
LEFT JOIN `payments` ON `Customers`.`id` = `payments`.`user_id`
WHERE `Customers`.`id` = '32'
GROUP BY `Customers`.`id`
DEBUG - 2025-01-23 14:13:49 --> Data: Array
(
    [id] => 32
    [name] => KAVYA T
    [user_id] => UID7200-KAVYA T
    [email] => Kavya547@gmail.com
    [city] => H D KOTE
    [mobile] => 07349645690
    [total_payment] => 1000
    [total_months] => 1
)

INFO - 2025-01-23 14:13:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:44:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:14:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 14:14:39 --> Query: SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`email`, `Customers`.`city`, `Customers`.`mobile`, (SELECT SUM(amount) FROM payments WHERE Customers.id = payments.user_id) as total_payment, (SELECT COUNT(payment_date) FROM payments WHERE Customers.id = payments.user_id) as total_months
FROM `Customers`
LEFT JOIN `payments` ON `Customers`.`id` = `payments`.`user_id`
WHERE `Customers`.`id` = '32'
GROUP BY `Customers`.`id`
DEBUG - 2025-01-23 14:14:39 --> Data: Array
(
    [id] => 32
    [name] => KAVYA T
    [user_id] => UID7200-KAVYA T
    [email] => Kavya547@gmail.com
    [city] => H D KOTE
    [mobile] => 07349645690
    [total_payment] => 1000
    [total_months] => 1
)

INFO - 2025-01-23 14:14:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:17:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:18:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:48:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:18:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 14:18:06 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 14:18:06 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

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

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

INFO - 2025-01-23 08:48:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:49:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:49:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:49:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:49:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:20:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:50:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:51:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:21:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:26:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:56:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
CRITICAL - 2025-01-23 08:56:20 --> CodeIgniter\View\Exceptions\ViewException: Invalid file: "admin/Initial_pins_report.php"
[Method: GET, Route: Initial-pins-report]
in SYSTEMPATH/Exceptions/FrameworkException.php on line 41.
 1 SYSTEMPATH/View/View.php(222): CodeIgniter\Exceptions\FrameworkException::forInvalidFile('admin/Initial_pins_report.php')
 2 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('admin/Initial_pins_report', [], true)
 3 APPPATH/Controllers/Home.php(299): view('admin/Initial_pins_report')
 4 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Home->Initial_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-23 08:56:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:57:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:57:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:57:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:57:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:57:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:58:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:58:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:58:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:58:58 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 08:59:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 09:55:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 09:55:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:01:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:01:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:01:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:01:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:01:41 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:01:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 15:32:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:02:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 15:32:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 15:32:03 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 15:32:03 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 15:32:03 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 15:32:03 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 10:02:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:03:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:14:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:15:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:15:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:15:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 15:46:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:16:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 15:46:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 15:46:36 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 15:46:36 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 15:46:36 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 15:46:36 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 10:16:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
ERROR - 2025-01-23 15:46:46 --> mysqli_sql_exception: Unknown column 'promoter_payments.total_slots' in 'field list' in /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312
Stack trace:
#0 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT DATE_FOR...', 0)
#1 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT DATE_FOR...')
#2 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT DATE_FOR...')
#3 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT DATE_FOR...', Array, false)
#4 /home/injayblues/public_html/Green_Palace_Heritage/app/Controllers/Promoter.php(1034): CodeIgniter\Database\BaseBuilder->get()
#5 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->get_initialPins_report()
#6 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
#7 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#8 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run()
#9 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#10 /home/injayblues/public_html/Green_Palace_Heritage/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#11 {main}
CRITICAL - 2025-01-23 15:46:46 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'promoter_payments.total_slots' in 'field list'
[Method: POST, Route: get-initialPins-report]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`', [], false)
 2 APPPATH/Controllers/Promoter.php(1034): CodeIgniter\Database\BaseBuilder->get()
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->get_initialPins_report()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 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))
CRITICAL - 2025-01-23 15:46:46 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'promoter_payments.total_slots' in 'field list'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 317.
 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`')
 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`', [], false)
 4 APPPATH/Controllers/Promoter.php(1034): CodeIgniter\Database\BaseBuilder->get()
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->get_initialPins_report()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-23 15:46:46 --> [Caused by] mysqli_sql_exception: Unknown column 'promoter_payments.total_slots' in 'field list'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 312.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`')
 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\') as month_year, `schemes`.`scheme` as `scheme_name`, SUM(promoter_payments.total_slots) as total_slots
FROM `promoter_payments`
JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id`
GROUP BY DATE_FORMAT(promoter_payments.created_at, \'%b - %Y\'), `promoter_payments`.`scheme`', [], false)
 5 APPPATH/Controllers/Promoter.php(1034): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->get_initialPins_report()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter))
 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
INFO - 2025-01-23 10:18:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:23:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:23:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 15:53:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 15:53:29 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 15:53:29 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

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

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

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

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

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

INFO - 2025-01-23 10:29:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:31:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:01:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 16:01:51 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 16:01:51 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

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

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

INFO - 2025-01-23 10:32:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:02:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 16:02:36 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 16:02:36 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 16:02:36 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 16:02:36 --> Customer Count: Array
(
    [total_customers] => 24
)

DEBUG - 2025-01-23 16:02:36 --> Amount Query: SELECT SUM(amount) as total_amount
FROM `payments`
DEBUG - 2025-01-23 16:02:36 --> Amount Data: Array
(
    [total_amount] => 21000
)

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

DEBUG - 2025-01-23 16:03:24 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 16:03:24 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 10:33:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:46:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:48:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:56:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:56:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 10:59:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:00:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:01:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:02:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:04:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:04:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:04:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:04:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:05:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:05:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:05:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:08:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:38:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:39:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:09:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:10:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:10:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:10:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:10:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:11:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:11:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:41:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:41:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:11:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:41:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 16:41:44 --> Promoter ID: 6
DEBUG - 2025-01-23 16:41:44 --> 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-23 16:41:44 --> Data: Array
(
    [id] => 6
    [name] => KAVYA T
    [email] => Kvy547@gmail.com
    [valid_user] => 1
    [phone] => 7349645690
    [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO
    [promoter_id] => 6
    [role] => 1
    [role_name] => promoter
    [created_at] => 0000-00-00 00:00:00.000000
    [user_id] => 6
    [total_earnings] => 6200
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 18
    [total_request] => 1
    [total_initial] => 4
)

INFO - 2025-01-23 11:11:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:41:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:11:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:41:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:12:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:12:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:42:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:12:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:42:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:19:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:49:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:19:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:19:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:49:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:54:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:54:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:24:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 16:54:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 16:54:49 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email`
FROM `admin`
WHERE `admin`.`id` = '1'
DEBUG - 2025-01-23 16:54:49 --> Admin Data: Array
(
    [id] => 1
    [username] => kavya
    [role_name] => Super Admin
    [email] => kavyat7349@gmail.com
)

DEBUG - 2025-01-23 16:54:49 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 16:54:49 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 17:06:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:06:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:36:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:06:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 17:06:17 --> Promoter ID: 6
DEBUG - 2025-01-23 17:06: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-23 17:06: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] => 6200
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 18
    [total_request] => 1
    [total_initial] => 4
)

INFO - 2025-01-23 17:06:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:06:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:07:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:07:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:38:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:08:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:38:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:08:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:38:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 17:08:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2025-01-23 17:08:13 --> Promoter ID: 6
DEBUG - 2025-01-23 17:08: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-23 17:08:13 --> Data: Array
(
    [id] => 6
    [name] => KAVYA T
    [email] => Kvy547@gmail.com
    [valid_user] => 1
    [phone] => 7349645690
    [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO
    [promoter_id] => 6
    [role] => 1
    [role_name] => promoter
    [created_at] => 0000-00-00 00:00:00.000000
    [user_id] => 6
    [total_earnings] => 6200
    [total_amount] => 12000
    [city] => H D KOTE
    [total_customers] => 18
    [total_request] => 1
    [total_initial] => 4
)

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

DEBUG - 2025-01-23 17:10:28 --> Customer Query: SELECT COUNT(id) as total_pins
FROM `promoter_repayment_requests`
DEBUG - 2025-01-23 17:10:28 --> Customer Count: Array
(
    [total_customers] => 24
)

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

INFO - 2025-01-23 11:40:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:45:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:50:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:53:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 11:54:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 12:02:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 13:45:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:24:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2025-01-23 14:48:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.