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();
}

}