EVOLUTION-NINJA
Edit File: NewExpenditureModel.php
<?php namespace App\Models; use CodeIgniter\Model; class NewExpenditureModel extends Model { protected $table = 'expenditure_new'; protected $primaryKey = 'id'; // Add allowed fields if you insert/update protected $allowedFields = [ 'project_id', 'expenditure_amount', 'expenditure_date' ]; public function getExpendituresWithCosts($projectId) { $sql = " SELECT p.id AS project_id, p.estimated_cost AS total_estimated_amount, ex.total_payment, COALESCE(rel.total_released_amount, 0) AS total_released_amount FROM create_project p LEFT JOIN ( SELECT project_id, SUM(expenditure_amount) AS total_payment FROM expenditure_new GROUP BY project_id ) ex ON ex.project_id = p.id LEFT JOIN ( SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id ) rel ON rel.project_id = p.id WHERE p.id = ? "; return $this->db->query($sql, [$projectId])->getResult(); } }