EVOLUTION-NINJA

Edit File: Enrolled_Model.php

<?php

namespace App\Models\Admin;

use CodeIgniter\Model;

class Enrolled_Model extends Model
{
    protected $table = 'user_course_mapping'; // Adjust the table name as needed

public function getWhereEnrolledUsersSubdomains($user_id)
    {
        $builder = $this->db->table('user_course_mapping A');
        $builder->select('A.*, B.course_id, B.domain_id, B.sub_domain_id, B.course_title, C.login_id, D.domain_name');
        $builder->join('courses B', 'A.course_id = B.course_id');
        $builder->join('user_registrations C', 'A.user_id = C.login_id');
        $builder->join('domains D', 'D.domain_id = B.domain_id');
        $builder->where('A.delete_status', 'ACTIVE');
        $builder->where('A.payment_status', 'PAID');
        $builder->where('C.user_id', $user_id);
        $builder->where('B.delete_status', 'ACTIVE');
        $query = $builder->get();

$result = $query->getResultArray();
        $res_array = [];

foreach ($result as $value) {
            $data['created_at'] = date("d-m-Y h:i:s", strtotime($value['created_at']));
            $data['course_title'] = $value['course_title'];
            $data['course_price'] = $value['course_price'];
            $data['domain'] = $value['domain_name'];
            $course_type = json_decode($value['session_type']);

$ct_array = [];
            foreach ($course_type as $ct) {
                array_push($ct_array, ucfirst($ct));
            }

$data['course_type'] = implode(', ', $ct_array);

$ids = json_decode($value['sub_domain_id']);
            $new_array = [];

foreach ($ids as $id) {
                $sub_domain = $this->getSubDomain($id);
                if ($sub_domain) {
                    array_push($new_array, $sub_domain);
                }
            }

$data['sub_domains'] = implode(', ', $new_array);
            array_push($res_array, $data);
        }

return $res_array;
    }

public function getEnrolledUsersDetails()
    {
        $query = $this->db->table('user_registrations A')
            ->join('login B', 'B.login_id = A.login_id')
            ->where('A.delete_status', 'ACTIVE')
            ->where('B.user_type_id', '3')
            ->where('B.delete_status', 'ACTIVE')
            ->where('B.verified_status', 'VERIFIED')
            ->where('B.approval_status', 'APPROVED')
            ->where('B.institution_id', '0')
            ->get();

$results = $query->getResult();

$array = [];

foreach ($results as $value) {
            $query2 = $this->db->table('user_course_mapping A')
                ->where('A.delete_status', 'ACTIVE')
                ->where('A.user_id', $value->login_id)
                ->get();

$results2 = $query2->getResult();

if ($results2) {
                $paymentArray = [];

foreach ($results2 as $val) {
                    array_push($paymentArray, $val->payment_status);
                }

if (in_array('PAID', $paymentArray)) {
                    $data = [
                        'login_id'      => $value->login_id,
                        'user_id'       => $value->user_id,
                        'full_name'     => $value->full_name,
                        'phone_number'  => $value->phone_number,
                        'qualification' => $value->qualification,
                        'email'         => $value->email,
                    ];

array_push($array, $data);
                }
            }
        }

return $array;
    }

public function getWhereEnrolledUsersDetails($user_id)
    {
        $builder = $this->db->table('user_course_mapping A');
        $builder->select('*');
        $builder->join('user_registrations B', 'A.user_id = B.login_id');
        $builder->join('login C', 'C.login_id = B.login_id');
        $builder->where('A.delete_status', 'ACTIVE');
        $builder->where('A.payment_status', 'PAID');
        $builder->where('B.user_id', $user_id);
        $builder->where('B.delete_status', 'ACTIVE');
        // $builder->where('C.delete_status', 'ACTIVE');

$query = $builder->get();

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

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

return $query->getRow();
    }

}