EVOLUTION-NINJA

Edit File: Syllabus_Chapter.php

<?php

namespace App\Models\Admin;

use CodeIgniter\Model;

class Syllabus_Chapter extends Model
{
    protected $table = 'syllabus_chapter A';
   
    protected $primaryKey = 'chapter_id';
    protected $allowedFields = ['syllabus_id', 'sub_domain_id', 'chapter_name', 'delete_status', 'created_at', 'created_by', 'user_type_id', 'updated_at', 'updated_by'];

public function get_subject_wise_syllabus_list($sub_domain_id)
    {

$builder = $this->db->table($this->table);
        $builder->select('A.*, B.sub_domain, C.username');
        $builder->join('sub_domains B', 'A.sub_domain_id = B.sub_domain_id');
        $builder->join('login C', 'A.created_by = C.login_id');
        $builder->where('A.delete_status', 'ACTIVE');
        $builder->where('B.delete_status', 'ACTIVE');
        $builder->where('C.delete_status', 'ACTIVE');
        $builder->where('A.sub_domain_id', $sub_domain_id);

$query = $builder->get();
        $result = $query->getResultArray();

$syllabusArray = [];

foreach ($result as $val) {
            $updatedBy = $val['updated_by'];

if (($updatedBy !== 0) && ($updatedBy !== '')) {
                $editedByQuery = $this->db->table('login')->where(['delete_status' => 'ACTIVE', 'login_id' => $updatedBy])->get();
                $editedBy = $editedByQuery->getRow();

$data['updated_by'] = $editedBy->username;
            } else {
                $data['updated_by'] = '';
            }

$data['chapter_id'] = $val['chapter_id'];
            $data['chapter_names'] = $val['chapter_name'];
            $data['username'] = $val['username'];
            $data['created_at'] = date("d-m-Y H:i:s", strtotime($val['created_at']));
            $data['syllabus_id'] = $val['syllabus_id'];

array_push($syllabusArray, $data);
        }

return $syllabusArray;
    }
}