EVOLUTION-NINJA

Edit File: Add_Prep_Access.php

<?php 
namespace App\Controllers\admin;
use App\Controllers\BaseController;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;
use App\Models\AccessControlModel;
use App\Models\Online_Prep_SectionModel;
use App\Models\OrganisationModel; 
use App\Models\ExamCategoriesModel;

class Add_Prep_Access extends BaseController{

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

public function index(){

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

if($org_id){
            $addaccess=['a,b,c'];
            $data['add_library'] = $addaccess;

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

return view('admin/online_prep/access', $data); 
        }
        else{
            return view('admin/super-admin-login');
        }
        
    }

public function add_online_section(){

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

$name  = $this->request->getVar('section_name');

$newlibrary = array(
            'master_name'=>$name,
            'org_id'=>$org_id,
            'active_status'=>'INACTIVE'
        );

$e_library = new Online_Prep_SectionModel();
        // $e_library->where('org_id',$org_id);
        $e_library->save($newlibrary);
        $insert_section = $e_library->insertID();
 
        // print_r($insert_section);die();

if($insert_section){
            return json_encode(array(
                 'result'    => 1,
                 'message'     => 'Added Successfully.....'                 
                 ));
        }
        else{
            return json_encode(array(
                 'result'    => 0,
                 'message'     => 'Something went wrong.....'
                 ));
        }
        
    }

public function delete_prep_section(){
        $org_id = session()->get('org_id');
        $id  = $this->request->getVar('id');
        
        // print_r($id);die();
        $delete = new Online_Prep_SectionModel();        
        $delete->where('id',$id); 
        $delete->where('org_id',$org_id);
        $deleteID = $delete->delete();
        
        if($deleteID){
            return json_encode(array(
                'result'    => 1,
                'message'   => 'Prep Section Deleted Successfully'
            ));
        }
        else{
            return json_encode(array(
                'result'    => 0,
                'message'   => 'Error'
            ));
        }

}

public function edit_prep_section(){
        $org_id = session()->get('org_id');
        $id  = $this->request->getVar('id');
        // print_r($id);die();
        $model  = new Online_Prep_SectionModel();
        $model->where('org_id',$org_id);
        $data = $model->where('id',$id)->first();

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

public function find_sub_prep_category(){

$org_id = session()->get('org_id');
        $id = $this->request->getVar('id');
        $dr_id = session()->get('dr_id');
        $role_id = session()->get('role_id');

$find_sub_cate = new ExamCategoriesModel();
        $details = $find_sub_cate->where('field_names',$id)->where('org_id',$org_id)->findAll();
        // $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->findAll();

if($details){
            return json_encode(array(
                'result'    => 1,
                'message'  =>$details
            ));
        }
        else{
            return json_encode(array(
                'result'    => 0, 
                'message'     => 'No Sub Categories Found....'                
           
            ));
        }

}

public function update_prep_section(){
        $org_id = session()->get('org_id');
        $id  = $this->request->getVar('get_id');
        $name  = $this->request->getVar('section_name_edit');
        date_default_timezone_set('Asia/Kolkata');
        $updated_at = date('d-m-Y H:i:s', time());
        
        $newData = array(
            'master_name'=>$name,
            'updated_at'=>$updated_at
        );

$model = new Online_Prep_SectionModel();
        $model->set($newData);
        $model->where('id',$id);
        $model->where('org_id',$org_id);
        $update = $model->update();

if($update){
            return json_encode(array(
                 'result'    => 1,
                 'message'   => 'Prep is Updated successfully....'
            ));
        }
        else{
            return json_encode(array(
                 'result'    => 0,
                 'message'     => 'Something went wrong.....'
            ));
        }

}

public function get_all_users(){
        $org_id = session()->get('org_id');

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

$columns = array(
            array(
                'db'=>'id',
                'dt'=>0,
                'field' => 'id'
            ),
            array(
                'db'=>'master_name',
                'dt'=>1,
                'field' => 'names'
            ),
            array(
                'db'=>'created_at',
                'dt'=>2,
                'field' => 'created_at'
            ),
            // array(
            //     'db'=>'`uf`.`files`',
            //     'dt'=>3,
            //     'field' => 'files'
            // ),
            array(
                'db'=>'id',
                'dt'=>3,
                'formatter'=>function($d, $row){
                    return "<div class='btn-group'>
                                <button class='btn btn-sm btn-primary' data-id='".$row['id']."' id='updateCountryBtn'>Rename</button>
                                <button class='btn btn-sm btn-danger' data-id='".$row['id']."' id='deleteCountryBtn'>Delete</button>                                  
                            </div>";
                }
            ),
        );
       
        // $joinQuery = "FROM `{$table}` AS `c` LEFT JOIN `upload_files` AS `uf` ON (`uf`.`categories_id` = `c`.`id`)";
        echo json_encode(
            \SSP::simple($_GET, $dbDetails, $table, $primaryKey, $columns, null, "org_id='$org_id'")
        );
    }

}
?>