EVOLUTION-NINJA

Edit File: video.php

<?php
namespace App\Controllers\video ;
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 Video extends BaseController
{
        use ResponseTrait;
    public function __construct()
    {
        helper(['form','url']);
    }

public function index()
    {
    $dr_id = session()->get('dr_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');
            $model1 = new Online_Exam_AboutModel();
            $model1->where('org_id',$org_id);
            $model1->select('*');
            $data['con_upcoming']  = $model1->get()->getResultArray();

$data['dr_id'] =  $dr_id;
            return view('video/video_home',$data);
        }
        else{
            return view('login');
        }
    }

public function Exam_Prep_Main_Home()
    {
        $dr_id = session()->get('dr_id');
        $main = $_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');
            $model1 = new Online_Exam_AboutModel();
            $model1->where('org_id',$org_id);
            $model1->where('section',$main);
            //$model1->where('category',$sub);
            $model1->select('*');
            $data['con_upcoming']  = $model1->get()->getResultArray();

$data['dr_id'] =  $dr_id; 
            return view('course/course_home',$data);
        }
        else{
            return view('login');
        }
    }

public function Exam_Prep_Sub_Home()
    {
        $dr_id = session()->get('dr_id');
        $sub = $_GET['sub'];
        $main = $_GET['main'];

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');
            $model1 = new Online_Exam_AboutModel();
            $model1->where('active_status',1);
            $model1->where('org_id',$org_id);
            $model1->where('section',$main);
            $model1->where('category',$sub);
            $model1->select('*');
            $data['con_upcoming']  = $model1->get()->getResultArray();

$data['dr_id'] =  $dr_id; 
            return view('course/course_home',$data);
        }
        else{
            return view('login');
        }
    }
    public function course_list()
    {
    $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');

$model1 = new Online_Prep_SectionModel();
            $model1->select('*');
            //$model1->where('active_status','ACTIVE');
            $data['section']  = $model1->get()->getResultArray();

$data['dr_id'] =  $dr_id; 
            return view('course/course_list',$data);
        }
        else{
            return view('login');
        }
    }
    public function categories_show()
    {
    $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');

$model1 = new ExamCategoriesModel();
            $model1->select('*');
            $model1->where('field_names',$conference_id);
            $data['section']  = $model1->get()->getResultArray();

$data['dr_id'] =  $dr_id; 
            return view('course/category_list',$data);
        }
        else{
            return view('login');
        }
    }

public function exam_find_sub_categories(){
        $id = $this->request->getVar('id');

// print_r($id);die();
        $findsub = new ExamCategoriesModel();
        $details = $findsub->where('field_names',$id)->findAll(); 
    
        if(!empty($details)){
            return json_encode(array(
                'result'    => 1,
            ));
        }
        else{
            return json_encode(array(
                'result'    => 0,
                'message'     => 'No Sub Categories Found'                
           
            ));
        }

}

public function course_about()
    {
    $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');
            $model1 = new Online_Exam_AboutModel();

$model1->select('*');
            $data['val']  = $model1->where('conference_id',$conference_id)->first();

$data['dr_id'] =  $dr_id; 
            return view('course/course_about',$data);
        }
        else{
            return view('login');
        }
    }
    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);
            $model1->orderBy('date','ASC');
            $data['programs'] = $model1->get()->getResultArray();

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

$data['dr_id'] =  $dr_id; 
            return view('course/program_schedule',$data);
        }
        else{
            return view('login');
        }
    }
    public function faculty_details()
    {
        $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();

$model3 = new ExamProgramScheduleModel();
            $model3->groupBY('speaker'); 
            $model3->where('conference_id',$conference_id);
            $model3->select('*'); 
            $data['speaker'] = $model3->get()->getResultArray();

$model1 = new ExamFacultyModel();
            $model1->select('*');
            $model1->where('conference_id',$conference_id);
            $data['faculty'] =$model1->get()->getResultArray();
            $data['dr_id'] =  $dr_id; 
            return view('course/faculty_details',$data);
        }
        else{
            return view('login');
        }
    }
    public function registration_details()
    {
        $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();

$model3 = new ExamProgramScheduleModel(); 
            $model3->where('conference_id',$conference_id);
            //$model2->orderby('ps_id','ASC');
            $model3->select('*'); 
            $details6  = $model3->get()->getResultArray();

$data['ps_ids'] = $details6;

$model2 = new Course_paymentModel();
            $model2->select('*');
            $model2->where('conference_id',$conference_id);
            $model2->where('user_id',$dr_id);
            $model2->orderby('course_ps_id','ASC');
            $data['payment'] = $model2->get()->getResultArray();

$model4 = new Course_paymentModel();
            $model4->select('count(id) as paycount,course_ps_id as ps_id');
            $model4->where('conference_id',$conference_id);
            $model4->groupBY('course_ps_id');
            $data['payment_count'] = $model4->get()->getResultArray();

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

return view('course/course_registation',$data);
        }
        else{
            return view('login');
        }
    }

public function registration_details_api()
    {
        $dr_id = 1;
        $conference_id = $_GET['id'];
        //echo 'hello';
        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();

$data['ps_ids'] = $details6;

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

print_r($data);
        }
    }
    public function attend_course()
    {
        $dr_id = session()->get('dr_id');
        $conference_id = $_GET['id'];
        $name = session()->get('name');
        $gamer_id = session()->get('gamer_id');
        // print_r($name);die();

if($dr_id){
        
            $model = new Online_Exam_AboutModel();
            $model->select('*');
            $data['val']  = $model->where('conference_id',$conference_id)->first();

$data['amount']  = $data['val']['reg_fee'];

if($data['val']['reg_fee'] != 0){
                $model2 = new Course_paymentModel();
                $model2->select('*');
                $model2->where('conference_id',$conference_id);
                $model2->where('user_id',$dr_id);
                $model2->orderby('course_ps_id','ASC');
                $payment = $model2->get()->getResultArray();

$data['payments'] = $payment;
            
                if($payment){

$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');

$model1 = new ExamProgramScheduleModel();
                    $model1->select('*');
                    $model1->where('conference_id',$conference_id);
                    $model1->orderby('ps_id','ASC');
                    $data['attend_link'] =$model1->get()->getResultArray();

$data['dr_id'] =  $dr_id;

$procedure_date = '';

$db = \Config\Database::connect();

$builder = $db->table('course_attend_user');
                    $query = $builder->select("count(gamer_id) as gamer");
                    $query = $builder->where('conference_id',$conference_id);
                    $query = $builder->where('gamer_id',$gamer_id);
                    $query = $builder->get();
                    $record = $query->getResult();
                    foreach($record as $row) {
                        $procedure_date = $row->gamer;
                    }

$details = array(
                        'conference_id'=>$conference_id,
                        'org_id'=>$org_id,
                        'user_name'=>$name,
                        'gamer_id'=>$gamer_id,
                        'created_by'=>$name,
                        'dr_id'=>$dr_id
                    );
                     
                     
                    if($procedure_date == 0){
                        $attend_con = new Course_AttendUserModel();        
                        $attend_con->save($details);
                        $insertedID = $attend_con->insertID();
                    }

return view('course/attend_course',$data);
                }
                else{
                    return view('course/no_payment',$data);
                }
            }
            else{

$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');

$model1 = new ExamProgramScheduleModel();
                $model1->select('*');
                $model1->where('conference_id',$conference_id);
                $data['attend_link'] =$model1->get()->getResultArray();
                $data['dr_id'] =  $dr_id;

$procedure_date = '';

$db = \Config\Database::connect();

$builder = $db->table('course_attend_user');
                $query = $builder->select("count(gamer_id) as gamer");
                $query = $builder->where('conference_id',$conference_id);
                $query = $builder->where('gamer_id',$gamer_id);
                $query = $builder->get();
                $record = $query->getResult();
                foreach($record as $row) {
                    $procedure_date = $row->gamer;
                }

// print_r($procedure_date);die();

$details = array(
                    'conference_id'=>$conference_id,
                    'org_id'=>$org_id,
                    'user_name'=>$name,
                    'gamer_id'=>$gamer_id,
                    'created_by'=>$name,
                    'dr_id'=>$dr_id
                );

// print_r($details);die();

if($procedure_date == 0){
                    $attend_con = new Course_AttendUserModel();        
                    $attend_con->save($details);
                    $insertedID = $attend_con->insertID();
                }

return view('course/attend_course',$data);
            }
        }
        else{
            return view('login');
        }
    }

public function course_attend_user(){
        
        $dr_id = session()->get('dr_id');
        $org_id = session()->get('org_id');
        $name = session()->get('name');
        $gamer_id = session()->get('gamer_id');
        $conference_id = $_GET['id'];

// print_r($conference_id );die();

$procedure_date = '';

$db = \Config\Database::connect();

$builder = $db->table('course_attend_user');
        $query = $builder->select("count(gamer_id) as gamer");
        $query = $builder->where('conference_id',$conference_id);
        $query = $builder->where('gamer_id',$gamer_id);
        $query = $builder->get();
        $record = $query->getResult();
        foreach($record as $row) {
            $procedure_date = $row->gamer;
        }

// print_r($procedure_date);die();

$details = array(
            'conference_id'=>$conference_id,
            'org_id'=>$org_id,
            'user_name'=>$name,
            'gamer_id'=>$gamer_id,
            'created_by'=>$name,
            'dr_id'=>$dr_id
        );

// print_r($details);die();

if($procedure_date == 0){
            $attend_con = new Course_AttendUserModel();        
            $attend_con->save($details);
            $insertedID = $attend_con->insertID();
        }
    }

public function feedback()
    {
        $dr_id = session()->get('dr_id');
        $conference_id = $_GET['id'];
        
        if($dr_id){

$model = new Online_Exam_AboutModel();
                $model->select('*');
                $data['val']  = $model->where('conference_id',$conference_id)->first();

$data['amount']  = $data['val']['reg_fee'];

if($data['val']['reg_fee'] != 0){
                    $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');

$model2 = new Course_paymentModel();
                    $model2->select('*');
                    $model2->where('conference_id',$conference_id);
                    $model2->where('user_id',$dr_id);
                    $payment =$model2->get()->getResultArray();

$data['payments'] = $payment;
                
                    if($payment){
                        $model1 = new ExamProgramScheduleModel();
                        $model1->select('*');
                        $model1->where('conference_id',$conference_id);
                        $data['programs'] =$model1->get()->getResultArray();
                        $data['dr_id'] =  $dr_id;

$today = date('Y-m-d');
                        if(strtotime($data['val']['date_to']) > strtotime($today)){ 
                            return view('course/no_time',$data); 
                        }
                        else{
                            return view('course/feedback',$data);
                        } 
                    }
                    else{
                        return view('course/no_payment',$data);
                    }
                }
                else{
                    $model1 = new ExamProgramScheduleModel();
                    $model1->select('*');
                    $model1->where('conference_id',$conference_id);
                    $data['programs'] =$model1->get()->getResultArray();
                    $data['dr_id'] =  $dr_id; 
                    $today = date('Y-m-d'); 
                    if(strtotime($data['val']['date_to']) > strtotime($today)){ 
                        return view('course/no_time',$data); 
                    }
                    else{
                        return view('course/feedback',$data);
                    }
                }
        }
        else{
            return view('login');
        }
    }
     public function certificate()
    {

$dr_id = session()->get('dr_id');
        
        if($dr_id){
            $conference_id = $_GET['id'];

$model = new Online_Exam_AboutModel();
            $model->select('*');
            $data['val']  = $model->where('conference_id',$conference_id)->first();
            if($data['val']){ 
                $model1 = new CoursefeedbackModel();
                $model1->select('*');
                $model1->where('conference_id',$conference_id);
                $model1->where('created_by',$dr_id);
                $feedback = $model1->get()->getResultArray();
                if($feedback){
                        $model2 = new ExamCertificateModel();
                        $model2->select('*');
                        $data['certificate'] = $model2->where('conference_id',$conference_id)->first();

$model3 = new RegisterUserModel();
                        $model3->select('*');
                        $data['user_details'] = $model3->where('id',$dr_id)->first();

$data['name'] = session()->get('name');
                        $data['today'] = date("Y-m-d");

include ('public/assets/mpdf/vendor/autoload.php');
                        $mpdf = new \Mpdf\Mpdf(['mode' => 'utf-8', 'format' => 'A4-L']);

$email1 = session()->get('email');

$mpdf->SetDisplayMode('fullpage');

$mpdf->SetWatermarkText('');
                        $mpdf->watermark_font = 'DejaVuSansCondensed';
                        $mpdf->showWatermarkText = true;

$html = view('course/certificate_v_new',$data);

$mpdf->WriteHTML($html);

$date = date('d-M-y-H-i');
                        $file='public/uploads/certificates/'.$date.'certificate.pdf';
                        $pdf_path ='medusys'.$date.'certificate.pdf';

$mpdf->Output('public/uploads/certificates/'.$date.'certificate.pdf', 'F');

$content = ''; 
                        $email = \Config\Services::email();
                        $email->setFrom("healthcare@medusyspty.com", "Medusys");        
                        $email->setTo($email1);
                        $email->setSubject('Online Exam Prep');

$content = "Hello Dr. ".$data['name']." ";
 $content = $content."We would like to thank you for attending and providing feedback to Online Exam Prep."." ";
 $content = $content."Please find the attached certificate of participation."." ";
 $content = $content."Thank you again for your time and consideration. Looking forward to the great opportunities together. Should you have any questions, please write to us at contact@medusys.in
."." ";

$content = $content."Regards"." ";
 $content = $content."Medusys Team"." ";

$email->setMessage($content);
                        //$email->setMessage($content);
                        $email->attach($file); //Your path to pdf
                         if($email->send()){

}

return view('course/certificate_v',$data);
                    
                }
                else{
                    
                    return view('course/no_feedback',$data);
                }
                
            }
            else{
                return view('invalid_url');
            }

}
        else{
            return view('login');
        }
    }
    
    public function update_feedback()
    {
   //print_r($_POST);
  // die();
    $dr_id = session()->get('dr_id'); 
    $name = session()->get('name'); 
    $conference_id = $this->request->getvar('conference_id');
        if($dr_id){

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

$model1 = new ExamProgramScheduleModel();
        $model1->select('*');
        $model1->where('conference_id',$conference_id);
        $programs =$model1->get()->getResultArray();
        $review = $this->request->getvar('comment');

$model2 = new Course_paymentModel();
        $model2->select('*');
        $model2->where('conference_id',$conference_id);
        $model2->where('user_id',$dr_id);
        $payment =$model2->get()->getResultArray();

$i = 1;

foreach($programs as $key=>$val){

if($programs[$key]['amount'] != 0){
                foreach($payment as $key1=>$val1){
                    if($programs[$key]['ps_id'] == $payment[$key1]['course_ps_id']){
                        $radio = 'optradio'.$i;
                        $feedaback = $this->request->getvar($radio);

$feedbback = array(
                            'conference_id'=>$conference_id,
                            'ps_id'=> $programs[$key]['ps_id'],
                            'rating'=> $feedaback,
                            'review'=> $review,
                            'user_name' =>$name,
                            'created_by' =>$dr_id
                         );
                  //print_r($feedbback);
                      
                        $model = new CoursefeedbackModel(); 
                        $model->save($feedbback);
                        $insertedID = $model->insertID();
                        $i++;
                    }
                }
            }
            else{

$radio = 'optradio'.$i;
                 $feedaback = $this->request->getvar($radio);

$feedbback = array(
                    'conference_id'=>$conference_id,
                    'ps_id'=> $programs[$key]['ps_id'],
                    'rating'=> $feedaback,
                    'review'=> $review, 
                    'user_name' =>$name,
                    'created_by' =>$dr_id
                 );
                
                $model = new CoursefeedbackModel(); 
                $model->save($feedbback);
                $insertedID = $model->insertID();
                $i++;

}

}
        if($insertedID){
                    return json_encode(array(
                 
                    'data' => $faculty,
                    'result'    => 1,
                    'message'     => 'Feedback Inserted Succesfully..You can Download the certificate..'
                    ));
        
            }
            else{
                    return json_encode(array(
                        'result'    => 0,
                        'message'     => 'Something went wrong.....'
                    ));
            }

}
        else{
            return view('login');
        }
    }
    public function indivisual_facultly_details()
    {
    $dr_id = session()->get('dr_id');
    $fac_id = $this->request->getvar('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 ExamFacultyModel();
            $model1->select('*');
            $faculty = $model1->where('id',$fac_id)->first();
            if($faculty){
                return json_encode(array(

'data' => $faculty,
                'result'    => 1,
                'message'     => 'update Data'
                ));

}
            else{
                return json_encode(array(
                'result'    => 0,
                'message'     => 'Something went wrong.....'
                ));
            }

}
        else{
            return view('login');
        }
    }
}
?>