EVOLUTION-NINJA

Edit File: log-2025-05-20.log

ERROR - 2025-05-20 10:54:28 --> mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `depa' at line 37 in /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312
Stack trace:
#0 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0)
#1 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...')
#2 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...')
#3 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false)
#4 /home/mnknirman/public_html/app/Controllers/Report.php(500): CodeIgniter\Database\BaseBuilder->get()
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Report->get_report()
#6 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
#7 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#8 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run()
#9 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#10 /home/mnknirman/public_html/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#11 {main}
CRITICAL - 2025-05-20 10:54:28 --> CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `depa' at line 37
[Method: POST, Route: get_report]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC', [], false)
 2 APPPATH/Controllers/Report.php(500): CodeIgniter\Database\BaseBuilder->get()
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_report()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 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-05-20 10:54:28 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `depa' at line 37
in SYSTEMPATH/Database/MySQLi/Connection.php on line 317.
 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC')
 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC', [], false)
 4 APPPATH/Controllers/Report.php(500): CodeIgniter\Database\BaseBuilder->get()
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_report()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 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-05-20 10:54:28 --> [Caused by] mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `depa' at line 37
in SYSTEMPATH/Database/MySQLi/Connection.php on line 312.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC')
 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency`
LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency`
LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm`
LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer`
LEFT JOIN `status_master` ON `status_master`.`status` = `create_project`.`status`
LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id`
LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                    FROM released_amounts 
                      WHERE released_date < \'2025-04-01\'
                      GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2025-04-01\' AND \'2026-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
WHERE 
(
    create_project.status != 3
)

)
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC, `create_project`.`id` ASC', [], false)
 5 APPPATH/Controllers/Report.php(500): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_report()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 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))