EVOLUTION-NINJA

Edit File: Master_Model.php

<?php

namespace App\Models\Admin;

use CodeIgniter\Model;

class Master_Model extends Model
{
    protected $table = 'sub_domains';
    protected $primaryKey = 'id'; // Assuming 'id' is the primary key column name

protected $allowedFields = [
        'domain_id',
        'sub_domain',
        'delete_status',
        // Add other fields here if needed
    ];

// You can define validation rules if necessary
    protected $validationRules = [
        'domain_id' => 'required',
        'sub_domain' => 'required',
        'delete_status' => 'required'
        // Define validation rules for other fields if needed
    ];

// You can define custom validation error messages if necessary
    protected $validationMessages = [
        'domain_id' => [
            'required' => 'The domain ID field is required.'
        ],
        'sub_domain' => [
            'required' => 'The subdomain field is required.'
        ],
        'delete_status' => [
            'required' => 'The delete status field is required.'
        ]
        // Define custom validation messages for other fields if needed
    ];

public function getSubdomains($domainId)
    {
        // Query the database to get subdomains based on the domain_id
        return $this->where('domain_id', $domainId)
            ->where('delete_status', 'ACTIVE')
            ->findAll();
    }

public function getWhereResultOrderBy($table, $where, $order_by)
{
    $builder = $this->db->table($table);
    $builder->select('*');
    $builder->where($where);
    $builder->orderBy($order_by, 'DESC');
    
    $query = $builder->get();
    
    return $query->getResult();
}

public function getSubCategoriesList()
{
    try {
        $login_id = session('login_id');
        $user_type_id = session('user_type_id');

$builder = $this->db->table('sub_domains A');
        $builder->select('*');
        $builder->join('domains B', 'B.domain_id = A.domain_id');
        $builder->where('A.delete_status', 'ACTIVE');
        $builder->where('B.delete_status', 'ACTIVE');
        $builder->orderBy('B.domain_name', 'ASC');
        $builder->whereIn('A.user_type_id', ['1', '2']);
        
        $query = $builder->get();
        
        if ($query->getResult()) {
            return $query->getResult();
        } else {
            // Log the query or any error message here
            log_message('error', 'No results found in getSubCategoriesList()');
            return false;
        }
    } catch (Exception $e) { // Catch the generic Exception
        // Log the exception here
        log_message('error', 'Error in getSubCategoriesList(): ' . $e->getMessage());
        return false;
    }
}
    public function getSubDomainById($sub_domain_id)
    {
        return $this->find($sub_domain_id);
    }

public function getSubDomainBySubDomain($sub_domain)
    {
        return $this->where('sub_domain', $sub_domain)
            ->where('delete_status', 'ACTIVE')
            ->first();
    }

public function updateSubDomain($sub_domain_id, $domain_id, $sub_domain, $updated_by, $updated_at)
    {
        $data = [
            'domain_id' => $domain_id,
            'sub_domain' => $sub_domain,
            'updated_by' => $updated_by,
            'updated_at' => $updated_at,
        ];

return $this->update($sub_domain_id, $data);
    }

public function deleteSubDomain($sub_domain_id)
    {
        $data = ['delete_status' => 'INACTIVE'];

return $this->update($sub_domain_id, $data);
    }

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

//     return $builder->getRow();
// }

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

return $query->getRow();
}

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

return $builder->getResult();
}

public function updateRecord($where, $data)
{
    // Ensure that $where and $data are properly sanitized and validated
    $this->update($where, $data);
    return $this->affectedRows(); // Return the number of affected rows
}

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')
        ->select('A.*')
        ->join('syllabus_chapter B', 'A.sub_domain_id = B.sub_domain_id')
        ->join('sub_domains C', 'A.sub_domain_id = C.sub_domain_id')
        ->join('domains D', 'D.domain_id = C.domain_id')
        ->where('A.delete_status', 'ACTIVE')
        ->where('B.delete_status', 'ACTIVE')
        ->where('C.delete_status', 'ACTIVE')
        ->where('D.delete_status', 'ACTIVE')
        ->where('A.created_by', $login_id)
        ->where('A.user_type_id', $user_type_id)
        ->groupBy('A.sub_domain_id');

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

// public function insertData($table, $data, $returnID = false)
// {
//     $this->db->table($table)->insert($data);

//     if ($returnID) {
//         return $this->db->insertID();
//     }

//     return true; // Successfully inserted
// }

public function insertData($table, $data, $returnID = false)
{
    $builder = $this->db->table($table);
    $builder->insertBatch($data);

if ($returnID) {
        return $this->db->insertID();
    }

return true; // Successfully inserted
}

public function insertData1($table, $data, $createdBy, $returnID = false)
{
    // Set the 'created_by' field in the data array.
    $data['created_by'] = $createdBy;

$builder = $this->db->table($table);
    $builder->insertBatch($data);

if ($returnID) {
        return $this->db->insertID();
    }

return true; // Successfully inserted
}

public function getSyllabusDetails($chapter_id)
    {
        $login_id = session()->get('login_id');

$builder = $this->db->table('syllabus A')
            ->select('A.*, B.*')
            ->join('syllabus_chapter B', 'A.syllabus_id = B.syllabus_id')
            ->where('A.delete_status', 'ACTIVE')
            ->where('B.chapter_id', $chapter_id)
            ->where('A.created_by', $login_id);

$query = $builder->get();
        $row = $query->getRow();
        $result = $query->getResult();

$data['syllabus'] = $row;
        $data['syllabus_chapter'] = $result;

return $data;
    }

public function deleteRecord($table, $where)
    {
        return $this->db->table($table)->where($where)->delete();
    }

public function get_Where_Result_OrderByAsc($domainTable, $whereDomain, $orderBy)
    {
        $builder = $this->db->table($domainTable);
        $builder->select('*');
        $builder->where($whereDomain);
        $builder->orderBy($orderBy, 'ASC');
        $query = $builder->get();
        
        return $query->getResult(); // Assuming you want to return multiple rows as an array
    }

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

return $query->getResult();
    }

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

public function update_new($where, $table, $data)
{
    $builder = $this->db->table($table); // Create a Query Builder instance for the specified table.
    $builder->where($where); // Set the WHERE condition.
    $builder->update($data); // Perform the update.
}
public function getWhere_Roww($table, $whereSubdomain)
    {
        $builder = $this->db->table($table);
        $builder->select('*');
        $builder->where($whereSubdomain);
        $query = $builder->get();
        
        return $query->getRow(); // Assuming you want to return a single row
    }

public function update_Data($where,$table, $data)
    {
        return $this->db->table($table)
        ->where($where)->set($data)->update();
        
    }
    public function getWhere_Row($table, $whereDomain)
    {
        $builder = $this->db->table($table);
        $builder->select('*');
        $builder->where($whereDomain);
        $query = $builder->get();
        
        return $query->getRow(); // Assuming you want to return a single row
    }

// public function updateData($where, $table, $data)
    // {
    //     return $this->db->table($table)
    //         ->where($where)
    //         ->update($data);
    // }

public function updateData1($whereSubject, $subjectTable, $data)
    {
        $builder = $this->db->table($subjectTable);
        $builder->where($whereSubject);
        return $builder->update($data);
    }

public function updateData2($whereTimings, $timingsTable, $timingData)
    {
        $builder = $this->db->table($timingsTable);
        $builder->where($whereTimings);
        return $builder->update($timingData);
    }

public function updateData3($where, $table, $passwordData)
    {
        $builder = $this->db->table($table);
        $builder->where($where);
        return $builder->update($passwordData);
    }

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

// public function getTopicsChapters($sub_domain_id)
    // {
    //     return $this->db->table('syllabus_chapter')
    //                  ->where('delete_status', 'ACTIVE')
    //                 ->where('sub_domain_id', $sub_domain_id)
    //                 ->findAll();
    // }

//     public function getTopicsChapters($sub_domain_id)
// {
//     return $this->db->table('syllabus_chapter')
//         ->where('delete_status', 'ACTIVE')
//         ->where('sub_domain_id', $sub_domain_id)
//         ->get()
//         ->getResult();
// }

// public function getTopicsChapters($sub_domain_id, $login_id)
// {
//     return $this->select('*')
//                 ->from('syllabus_chapter')
//                 ->where('delete_status', 'ACTIVE')
//                 ->where('sub_domain_id', $sub_domain_id)
//                 ->findAll();
// }

public function getTopicsChapters($sub_domain_id, $login_id)
{
    return $this->db->table('syllabus_chapter')
        ->where('delete_status', 'ACTIVE')
        ->where('sub_domain_id', $sub_domain_id)
        ->get()
        ->getResult();
}

public function getTopicsListAdmin($login_id)
    {
        $builder = $this->db->table('topics A');
        $builder->select('A.*, B.sub_domain, C.domain_name, D.chapter_name');
        $builder->join('sub_domains B', 'B.sub_domain_id = A.sub_domain_id');
        $builder->join('domains C', 'C.domain_id = A.domain_id');
        $builder->join('syllabus_chapter D', 'D.chapter_id = A.chapter_id');
        $builder->where('A.created_by', $login_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->groupBy('A.chapter_id');
        
        return $builder->get()->getResult();
    }
    // public function approvedSubjects($subDomainIds)
    // {
    //     return $this->whereIn('sub_domain_id', $subDomainIds)
    //         ->where('delete_status', 'ACTIVE')
    //         ->findAll();
    // }

public function UpdateData($table, $data, $where)
    {
        $builder = $this->db->table($table);
        $builder->where($where);
        $result = $builder->update($data);
        return $result;
    }

public function approvedSubjects($subDomainId)
    {
        $builder = $this->db->table('sub_domains A');
        $builder->select('*');
        $builder->whereIn('A.sub_domain_id', $subDomainId);
        $builder->where('A.delete_status', 'ACTIVE');
        $query = $builder->get();

return $query->getResult();
    }
}