EVOLUTION-NINJA

Edit File: Syllabus_Model.php

<?php

namespace App\Models\Admin;

use CodeIgniter\Model;

class Syllabus_Model extends Model
{
    // Model
    protected $table = 'syllabus';
    protected $primaryKey = 'id';
    protected $allowedFields = [
        'sub_domain_id',
        'delete_status',
        'created_by',
        'user_type_id',
        'created_at',
    ];

public function get_where_row($chapter_table, $where)
    {
        $builder = $this->db->table($chapter_table);
        $builder->select('*');
        $builder->where($where);
        $query = $builder->get();

return $query->getRow(); // Assuming you want to return a single row
    }

public function get_where_result($table, $where)
    {
        return $this->db->table($table)
            ->select('*')
            ->where($where)
            ->get()
            ->getResult();
    }

public function getWhereRow($chapterTable, $where)
    {
        $builder = $this->db->table($chapterTable);
        $builder->select('*');
        $builder->where($where);
        $query = $builder->get();

return $query->getRow(); // Assuming you want to return a single row
    }

public function insert_data($table, $data)
    {
        $builder = $this->db->table($table);
        $builder->set($data); // Use the set method to specify the data
        $result = $builder->insert();

return [
            'affected_rows' => $this->db->affectedRows(),
            'insert_id' => $result, // Use the $result variable to get the insert ID
        ];
    }

// protected $table = 'syllabus';

public function get_syllabus_list()
    {
        $login_id = session()->get('login_id');
        $user_type_id = session()->get('user_type_id');

$builder = $this->db->table('syllabus A');
        $builder->select('*');
        $builder->join('syllabus_chapter B', 'A.sub_domain_id = B.sub_domain_id');
        $builder->join('sub_domains C', 'A.sub_domain_id = C.sub_domain_id');
        $builder->join('domains D', 'D.domain_id = C.domain_id');
        $builder->where('A.delete_status', 'ACTIVE');
        $builder->where('B.delete_status', 'ACTIVE');
        $builder->where('C.delete_status', 'ACTIVE');
        $builder->where('D.delete_status', 'ACTIVE');
        $builder->where('A.created_by', $login_id);
        $builder->where('A.user_type_id', $user_type_id);
        $builder->groupBy('A.sub_domain_id');

$query = $builder->get();
        return $query->getResult();
    }
}