EVOLUTION-NINJA

Edit File: Exam_registration.php

<?php 
namespace App\Controllers\admin;
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\conferenceModel;
use App\Models\Online_Exam_AboutModel;
use App\Models\FacultyModel;
use App\Models\ExamProgramScheduleModel;

class Exam_registration extends  BaseController
{
    public function __construct()
	{
		require_once APPPATH.'ThirdParty/ssp.class.php';
        $this->db = db_connect();
	}
    
    
    public function index(){
     if(session()->get('name')){
        $org_id = session()->get('org_id');

$conference_id = $_GET['id'];

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

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

// print_r($org_id);die();
        $model2 = new Online_Exam_AboutModel();
        $model2->where('conference_id',$conference_id);
        $model2->select('title');
        $details4  = $model2->get()->getResultArray();

$model3 = new ExamProgramScheduleModel(); 
        $model3->where('conference_id',$conference_id);
        $model3->select('*'); 
        $details6  = $model3->get()->getResultArray();

$data['ps_ids'] = $details6;

$data['title_con'] = $details4;
        $data['conference_id'] = $conference_id;

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

public function con_registration_single(){

$ps = $this->request->getVar('ps');
       $amount = $this->request->getVar('amount');

$sum = 0;
        foreach($ps as $key=>$val){
            $sum += $amount[$key];
        }

$model1  = new ExamProgramScheduleModel();
        $val_id = $model1->where('ps_id',$ps[0])->first();

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

if($sum > 0 && $val['reg_fee'] != 0){
                return json_encode(array(
                     'result'    => 0,
                     'message'     => 'Registeration amount should not be ZERO'
                ));

}
        else{

foreach($ps as $key=>$val){
                $program_schedule = array(
                    'amount'=> $amount[$key]
                );

$model6 = new ExamProgramScheduleModel();  
                $model6->set($program_schedule);
                $model6->where('ps_id',$ps[$key]); 
                $updateID = $model6->update();
          
            } 
             if($updateID){ 
                return json_encode(array(   
                     
                     //'data' => $conferene_id,
                     'result'    => 1,
                     'message'     => 'Registration amount Updated successfully '
                ));
            }
            else{
                return json_encode(array(
                     'result'    => 0,
                     'message'     => 'Something went wrong.....'
                ));
            }
        }

}
    public function con_registration(){
        // print_r('hii');die()
     if(session()->get('name')){
        $org_id = session()->get('org_id');
        $role_id = session()->get('role_id');
        $name = session()->get('dr_id');

$conferene_id = $this->request->getVar('conferene_id');

$reg_fee_reg  = $this->request->getVar('reg_fee_reg');
        $reg_details_reg  = $this->request->getVar('reg_details_reg');
        
        $login_id = session()->get('id');
        $full_course=$this->request->getVar('full-course');
        if($full_course=='on'){
            $full_course=1;
        }else{
            $full_course=0;
        }

$productModel = new ExamProgramScheduleModel();
        $result = $productModel->where('conference_id',$conferene_id)->select('sum(amount) as sumQuantities')->first();
        $ps_amount = $result['sumQuantities'];

// echo $ps_amount;
        //echo $reg_fee_reg;
        if($ps_amount > 0 && $reg_fee_reg != 0){
                return json_encode(array(
                     'result'    => 0,
                     'message'     => 'Registeration amount should not be ZERO'
                ));
        }
        else{

// print_r($conferene_id);die();
            $registration_con = array(
                'org_id'=> $org_id,
                'role_id'=> $role_id, 
                'conference_id'=>$conferene_id,
                // 'conference_id'=>$conference_id,
                // 'title'=> $title_con,
                'reg_fee'=> $reg_fee_reg,
                'reg_details'=> $reg_details_reg,
                'created_by' =>$name ,
                'full_course'=>$full_course
                
            );

$model = new Online_Exam_AboutModel(); 
            $model->set($registration_con);
            $model->where('conference_id',$conferene_id);        
            $update = $model->update();

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

public function edit_registration(){
        if(session()->get('name')){
        $conference_id = $_GET['id'];
         
        // $conference_id = $this->request->getVar('conference_id');
         
        // $model  = new Online_Exam_AboutModel();
        // // $model->set($add_conference);
        // $data['values'] = $model->where('conference_id',$conference_id)

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

// $db = \Config\Database::connect();
        // $affected_rows = $db->affectedRows();

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

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

$model2 = new Online_Exam_AboutModel();
        $model2->where('conference_id',$conference_id);
        $model2->select('title');
        $details4  = $model2->get()->getResultArray();

$data['title_con'] = $details4;
        $data['conference_id'] = $conference_id;

$model3 = new ExamProgramScheduleModel(); 
        $model3->where('conference_id',$conference_id);
        $model3->select('*'); 
        $details6  = $model3->get()->getResultArray();

$data['ps_ids'] = $details6;

// print_r($data['values']);die();
        if($data['registr']){

return view('admin/online_prep/registrationedit', $data);
        }
        else{
            return 'Something went wrong...';
           
        }
    }
     else{
            return redirect()->to('Super-Admin'); 
        }
}

public function update_registration(){
        if(session()->get('name')){

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

// print_r($role_id);die();
        if($this->request->getMethod() == 'post'){

$conference_id  = $this->request->getVar('conference_id');

$reg_fee_reg  = $this->request->getVar('reg_fee_reg');
        $reg_details_reg  = $this->request->getVar('reg_details_reg');
        
        $login_id = session()->get('id');
        
        $full_course=$this->request->getVar('full-course');
        if($full_course=='on'){
            $full_course=1;
        }else{
            $full_course=0;
        }

$productModel = new ExamProgramScheduleModel();
        $result = $productModel->where('conference_id',$conference_id)->select('sum(amount) as sumQuantities')->first();
        $ps_amount = $result['sumQuantities'];

if($ps_amount > 0 && $reg_fee_reg == 0){

return json_encode(array(
                     'result'    => 0,
                     'message'     => 'Registeration amount should not be ZERO'
                ));

}
        else{
            $registration_con = array(
                'org_id'=> $org_id,
                'role_id'=> $role_id, 
                'conference_id'=>$conference_id,
                'reg_fee'=> $reg_fee_reg,
                'reg_details'=> $reg_details_reg,
                'created_by' =>$name  ,
                'full_course'=>$full_course

);
 
            
            
                $model = new Online_Exam_AboutModel(); 
                $model->set($registration_con);
                $model->where('conference_id',$conference_id);
                $update = $model->update();

if($update){
                    return json_encode(array(
                         'result'    => 1,
                         'message'   => 'Registration Updated successfully....',
                         'data'      => $conference_id
                    ));
               }
               else{
                    return json_encode(array(
                         'result'    => 0,
                         'message'     => 'Something went wrong.....'
                    ));
                }
            }
        }
         else{
            return redirect()->to('Super-Admin'); 
        }
    }

}

public function get_all_users(){
     if(session()->get('name')){
        $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 = "Online_Exam_AboutModel";
        $primaryKey = "conference_id";

$columns = array(
            array(
                'db'=>'conference_id',
                'dt'=>0,
                'field'=>'conference_id',
            ),
            array(
                'db'=>'reg_fee',
                'dt'=>1,
                'field' => 'reg_fee'
            ),
            array(
                'db'=>'reg_details',
                'dt'=>2,
                'field' => 'reg_details'
            ),
            
            array(
                'db'=>'id',
                'dt'=>3,
                '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)
        );
    }

}
}
?>