EVOLUTION-NINJA
Edit File: OnlineUserViewed.php
<?php namespace App\Controllers\admin\online_prep; use App\Controllers\BaseController; use CodeIgniter\RESTful\ResourceController; use CodeIgniter\API\ResponseTrait; use App\Models\CategoriesModel; use App\Models\FileUploadModel; 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 OnlineUserViewed extends BaseController{ use ResponseTrait; public function __construct() { helper(['form']); // helper(['url']); } public function index(){ $org_id = session()->get('org_id'); $conference_id = $_GET['id']; $data['conf_id'] = $conference_id; $e_library=['z,x,y']; $data['conferencelist'] = $e_library; $model = new OrganisationModel(); $details = $model->get()->getResultArray(); $data['org'] = $details; $model1 = new Online_Exam_AboutModel(); $model1->select('title'); $details3 = $model1->where('conference_id',$conference_id)->first(); // $model1->get()->getResultArray(); $data['title1'] = $details3; // print_r($details3);die(); return view('admin/online_prep/user_viewed_v',$data); } public function programs() { $dr_id = session()->get('dr_id'); $conference_id = $_GET['id']; if($dr_id){ $e_library=['z,x,y']; $data['conference'] = $e_library; $model = new OrganisationModel(); $details = $model->get()->getResultArray(); $data['org'] = $details; $org_id = session()->get('org_id'); $model = new Online_Exam_AboutModel(); $model->select('*'); $data['val'] = $model->where('conference_id',$conference_id)->first(); $model1 = new ExamProgramScheduleModel(); $model1->select('*'); $model1->where('conference_id',$conference_id); $data['programs'] = $model1->get()->getResultArray(); // print_r($data['programs']);die(); $data['dr_id'] = $dr_id; return view('admin/online_prep/program_list_user',$data); } else{ return view('login'); } } public function see_user_viewed_data(){ $conf_id = $this->request->getVar('id'); $model1 = new ExamProgramScheduleModel(); $model1->select('conference_id'); $details1 = $model1->where('ps_id',$conf_id)->first(); $course_id = $details1['conference_id']; $model1 = new Online_Exam_AboutModel(); $model1->select('reg_fee'); $details3 = $model1->where('conference_id',$course_id)->first(); //print_r($details3['reg_fee']);die(); if($details3['reg_fee'] > 0){ $model = new Course_paymentModel(); $model->select('course_payment.*,register_user.f_name,register_user.l_name,register_user.mobile,register_user.email,register_user.gamer_id'); $model->join('register_user','course_payment.user_id = register_user.id','LEFT'); $model->where('course_payment.course_ps_id',$conf_id); $model->orderBy('course_payment.user_name','ASC'); $data = $model->get()->getResultArray(); // print_r($data);print_r('<br>');die(); } else{ $model = new Course_AttendUserModel(); $model->select('course_attend_user.*,register_user.f_name,register_user.l_name,register_user.mobile,register_user.email'); $model->join('register_user','course_attend_user.dr_id = register_user.id','LEFT'); $model->where('course_attend_user.conference_id',$course_id); $model->orderBy('course_attend_user.user_name','ASC'); $data = $model->get()->getResultArray(); } // print_r($data);die(); return $this->respondCreated($data); } } ?>