EVOLUTION-NINJA

Edit File: course_list_edit.php

<?php 
namespace App\Controllers\admin;
use App\Controllers\BaseController;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;

use App\Models\OrganisationModel;
use App\Models\Online_Exam_AboutModel;
use App\Models\ExamProgramScheduleModel;
use App\Models\RegisterUserModel;
use App\Models\ExamFacultyModel;
use App\Models\ExamCertificateModel;
use App\Models\Online_Prep_SectionModel;
use App\Models\ExamCategoriesModel;
use App\Models\CoursefeedbackModel;
use App\Models\Course_paymentModel;
use App\Models\Course_AttendUserModel;

class course_list_edit extends BaseController
{
    public function __construct()
    {
        require_once APPPATH.'ThirdParty/ssp.class.php';
        $this->db = db_connect();
    }

// public function index(){

// }
    public function show_list(){

$org_id = session()->get('org_id');

// $conference_id = $_GET['id'];

$e_library=['z,x,y'];
        $data['conferencelist'] = $e_library;

$model = new OrganisationModel();
        $details  = $model->get()->getResultArray();
        $data['org'] = $details;

$model1 = new Online_Prep_SectionModel();
        $model1->select('*');
        $model1->where('org_id',$org_id);
        $details2  = $model1->get()->getResultArray();

// print_r($details2);die();

$data['master_name'] = $details2;
        // $data['dates_con_from'] = $details2;
        // $data['dates_con_to'] = $details2;
        // $data['conference_id'] = $conference_id;

// print_r($data['date_from']);die();

return view('admin/online_prep/courselist', $data);
    }

public function show_course_list(){
        $org_id = session()->get('org_id');
        $dr_id = session()->get('dr_id');
        $role_id = session()->get('role_id');

$id = $_GET['id'];

$model = new OrganisationModel();
        $details  = $model->get()->getResultArray();
        $data['org'] = $details;

$model = new ExamCategoriesModel();
        if ($role_id == 3 || $role_id == 4) {
            $model->where('field_names', $id)
                  ->where('org_id', $org_id)
                  ->groupStart()
                    ->where('uploaded_by', $dr_id)
                    ->orWhere('uploaded_by', 0)
                  ->groupEnd();
        }else{
            $model->where('field_names', $id)->where('org_id', $org_id);
        }
        $details = $model->get()->getResultArray();

$data['details'] = $details;

// print_r($details[0]['fields']);die();

return view('admin/online_prep/courselist-details', $data);
    }

public function show_course_category(){

$org_id = session()->get('org_id');

$id = $_GET['id'];

// print_r($id);die();

$org_id = session()->get('org_id');

$model = new OrganisationModel();
        $details  = $model->get()->getResultArray();
        $data['org'] = $details;      
      
      
        $model1 = new Online_Exam_AboutModel();
        $model1->select('*');
        $model1->where('category',$id);
        $model1->where('org_id',$org_id);
        $details2  = $model1->get()->getResultArray();

$model2 = new ExamCategoriesModel();
        $model2->where('id',$id);
        $model2->where('org_id',$org_id);
        $details3  = $model2->get()->getResultArray();

$data['category_name'] = $details3;
        // print_r($details3[0]['category_name']);die();

$data['title_con'] = $details2;
        $data['dates_con_from'] = $details2;
        $data['dates_con_to'] = $details2;
        $data['conference_id'] = $conference_id;

// print_r($data['title_con']);die();

return view('admin/online_prep/courselist-category-details', $data);

}

public function conference_list(){
        //$db = \Config\Database::connect();
        $org_id = session()->get('org_id');
        $role_id = session()->get('role_id');
        $name = session()->get('name');
        
        $conference_id = $this->request->getVar('conference_id');

$login_id = session()->get('id');

$conference_list = array( 
                'conference_id'=>$conferene_id,
                'created_by' =>$name
             );

$model = new Conf_About(); 
            $model->set($conference_list);
            $model->where('conference_id',$conference_id);
            $update = $model->update();

if($update){
            return json_encode(array(
                 
                'data' => $conference_id,
                 'result'    => 1,
                 'message'     => 'data inserted successfully '
            ));
        
        }else{
            return json_encode(array(
                 'result'    => 0,
                 'message'     => 'Something went wrong.....'
            ));
        }
    }

public function get_all_users(){
        
        $conference_id = session()->get('conference_id');

// print_r($org_id);die();

$dbDetails = array(
            "host"=>$this->db->hostname,
            "user"=>$this->db->username,
            "pass"=>$this->db->password,
            "db"=>$this->db->database,
            "port"=>$this->db->port
        );
        
        $table = "conf_about";
        $primaryKey = "conference_id";

$columns = array(
            array(
                'db'=>'conference_id',
                'dt'=>0,
                'field' => 'conference_id'
            ),
            array(
                'db'=>'title',
                'dt'=>1,
                'field' => 'title'
            ),
            array(
                'db'=>'date_from',
                'dt'=>2,
                'field' => 'date_from'
            ),
            array(
                'db'=>'date_to',
                'dt'=>3,
                'field' => 'date_to'
            ),
            array(
                'db'=>'theme',
                'dt'=>4,
                'field' => 'theme'
            ),
            array(
                'db'=>'intro',
                'dt'=>5,
                'field' => 'intro'
            ),
            array(
                'db'=>'org_msg',
                'dt'=>6,
                'field' => 'org_msg'
            ),
            array(
                'db'=>'date_to',
                'dt'=>7,
                'field' => 'date_to'
            ),
            array(
                'db'=>'id',
                'dt'=>8,
                'formatter'=>function($d, $row){
                    return "<div class='btn-group'>
                                <button class='btn btn-sm btn-primary' data-id='".$row['conference_id']."' id='updateCountryBtn'>Update</button>
                                                               
                            </div>";
                }
            ),
        );
        
        echo json_encode(
            \SSP::simple($_GET, $dbDetails, $table, $primaryKey, $columns)
        );
    }

}
?>