EVOLUTION-NINJA

Edit File: Programschedule.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\RegisterUserModel;
use App\Models\ExamCategoriesModel;

use App\Models\Online_Exam_AboutModel;
use App\Models\ExamProgramScheduleModel;

use App\Models\NotificationModel;

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

use ResponseTrait;
    public function __construct()
    {
        helper(['form','url']);
    }

// public function index(){

// }

public function edit_programschedule(){ 
        if(session()->get('name')){ 
        $conference_id = $_GET['id'];
         // print_r($conference_id);die();
        
        $model  = new ExamProgramScheduleModel();
        $model->where('conference_id',$conference_id);
        $details11  = $model->get()->getResultArray();
        $data['programs'] = $details11;

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

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

$model5 = new RegisterUserModel();
        $model5->select('f_name')->orderBy('id','DESC');
        $model5->select('l_name')->orderBy('id','DESC');
        $model5->where('valid_user',1);
        $details4  = $model5->get()->getResultArray();
        $data['dr_name'] = $details4;

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

$data['title_con_e'] = $details2;
        $data['conference_id'] = $conference_id;

if($data['programs']){

return view('admin/online_prep/program-scheduleedit-new', $data);
        }
        else{
            return view('admin/online_prep/program-scheduleedit-new', $data);
           
        }
    }
     else{
            return redirect()->to('Super-Admin'); 
        }
}

public function update_programschedule(){
    if(session()->get('name')){
        // print_r($_POST);die();
        $org_id = session()->get('org_id');
        $role_id = session()->get('role_id');
        $id = session()->get('dr_id');
        
        if($this->request->getMethod() == 'post'){

$ps_id = $this->request->getVar('ps_id[]');

$start_time  = $this->request->getVar('start_time_e');
            $end_time  = $this->request->getVar('end_time_e');
            //for date format
            $dates  = $this->request->getVar('datename_e'); 
            $createdate = date('Y-m-d');

$topic  = $this->request->getVar('topic_e');
            $max_user = $this->request->getVar('max_user_e');
            $moderator  = $this->request->getVar('moderator_con_sub_e');
            $speaker  = $this->request->getVar('speaker_con_sub_e');
            $upload_file  = $this->request->getVar('upload_file_e');
            // $delete_status = $this->request->getVar('delete_status');

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

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

$file_up = $this->request->getFileMultiple('upload_data_e');

//$file_up1 = $this->request->getVar('upload_data_e');

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

if($file_up[$key]->getName() != ''){

$newName = $file_up[$key]->getName();
                    $path =  'public/uploads/conference_files';
                    $file_up[$key]->move($path, $newName);
                    $z[$key] = $file_up[$key]->getClientName();

$program_schedule = array(
                
                        'start_time'=> $start_time[$key],
                        'end_time'=> $end_time[$key],
                        'date'=> date('Y-m-d',strtotime($dates[$key])),
                        'topic'=> $topic[$key],
                        'max_user' =>$max_user[$key],
                        'moderator'=> $moderator[$key],
                        'speaker'=> $speaker[$key],
                        'upload_file'=>$upload_file[$key],
                        'conference_id'=>$conferene_id,
                        'ps_id'=>$ps_id[$key],
                        'updated_by' =>$id,
                        'upload_data_files'=>$z[$key]
                    );

}

else{
                    $program_schedule = array(
                        'start_time'=> $start_time[$key],
                        'end_time'=> $end_time[$key],
                        'date'=> date('Y-m-d',strtotime($dates[$key])),
                        'topic'=> $topic[$key],
                        'max_user' =>$max_user[$key],
                        'moderator'=> $moderator[$key],
                        'speaker'=> $speaker[$key],
                        'upload_file'=>$upload_file[$key],
                        'conference_id'=>$conferene_id,
                        'ps_id'=>$ps_id[$key],
                        'updated_by' =>$id,
                    );
                }

// print_r($program_schedule);
                
                if($ps_id[$key] === "new"){

$model6 = new ExamProgramScheduleModel();  
                    $model6->save($program_schedule);
                    $updateID = $model6->insertID();

}
                else{ 
                    $model6 = new ExamProgramScheduleModel();  
                    $model6->set($program_schedule);
                    $model6->where('ps_id',$ps_id[$key]);
                    $updateID = $model6->update();
                }
        
            }

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

$title1 = $val['title'];
            $category_id = $val['category'];

$model1 = new ExamCategoriesModel();
            $det = $model1->where('id',$category_id)->first();

$field_names = $det['field_names'];
            $section =  $det['fields'];
            $category =  $det['category_name'];

$title = "Updates to following Course in MeLs CME, Exam Prep Module";

$message = "Program schedule Section Is Updated in ".$title1." Course Of  Exam Prep Module";

$date = date("Y-m-d");

date_default_timezone_set("Asia/Calcutta");   //India time (GMT+5:30)
            $time  = date('H:i:s');

$details = array(
                //'user_id'=>$user_id,
                'type'=>$title,
                'message'=>$message,
                'sending_to'=>"All",
                'status'=>'active',
                'created_at'=>$date,
                'time'=> $time 
            );
            $add_note = new NotificationModel();        
            $add_note->save($details);
            $insertedID = $add_note->insertID();
         
            // die();

if($updateID){

return json_encode(array(
                     'result'    => 1,
                     'message'   => 'updated successfully....',
                     'data'=>    $conferene_id
                ));
           }
           else{
                return json_encode(array(
                     'result'    => 0,
                     'message'     => 'Something went wrong with ADD.....'
                ));
            }
        }
         else{
            return redirect()->to('Super-Admin'); 
        }
    }

}

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

$org_id = session()->get('org_id');
        $role_id = session()->get('role_id');
        $id = session()->get('dr_id');
        
        if($this->request->getMethod() == 'post'){

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

// print_r($con_id);die();
            
            
            $model = new ExamProgramScheduleModel(); 
            // $model->set($program_schedule);
            $model->where('ps_id',$ps_id);
            $delete = $model->delete();

if($delete){

return json_encode(array(
                     'result'    => 1,
                     'message'   => 'Deleted successfully....',
                     'data'=>    $conferene_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')){
    //     $ps_id = session()->get('ps_id');

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

//     $columns = array(
    //         array(
    //             'db'=>'ps_id',
    //             'dt'=>0,
    //             'field'=>'ps_id'
    //             ),
    //         array(
    //             'db'=>'conference_id',
    //             'dt'=>1,
    //             'field' => 'conference_id'
    //         ),
    //         array(
    //             'db'=>'start_time',
    //             'dt'=>2,
    //             'field' => 'start_time'
    //         ),
    //         array(
    //             'db'=>'end_time',
    //             'dt'=>3,
    //             'field' => 'end_time'
    //         ),
    //          array(
    //             'db'=>'date',
    //             'dt'=>4,
    //             'field' => 'date'
    //         ),
    //         array(
    //             'db'=>'topic',
    //             'dt'=>5,
    //             'field' => 'topic'
    //         ),
    //         array(
    //             'db'=>'moderator',
    //             'dt'=>6,
    //             'field' => 'moderator'
    //         ),
    //         array(
    //             'db'=>'speaker',
    //             'dt'=>7,
    //             'field' => 'speaker'
    //         ),
    //         array(
    //             'db'=>'upload_file',
    //             'dt'=>8,
    //             'field'=> 'upload_file' 
    //         ),
    //         array(
    //             'db'=>'id',
    //             'dt'=>9,
    //             'formatter'=>function($d, $row){
    //                 return "<div class='btn-group'>
    //                             <button class='btn btn-sm btn-primary' data-id='".$row['ps_id']."' id='updateCountryBtn'>Update</button>
                                                               
    //                         </div>";
    //             }
    //         ),
    //     );
        
    //     echo json_encode(
    //         \SSP::simple($_GET, $dbDetails, $table, $primaryKey, $columns)
    //     );
    // }

// }
}