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) ); } } ?>