EVOLUTION-NINJA

Edit File: Exam_Category.php

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

class Exam_Category 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){

$create_library=['a,b,c'];
            $data['create_library'] = $create_library;

$section = new Online_Prep_SectionModel();
            $section-> where('org_id',$org_id);
            $details = $section->findAll();
            $data['section'] = $details;

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

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

}else{
            return view('admin/super-admin-login');
        }
        
    }

public function save_category(){
        $org_id = session()->get('org_id');
        $dr_id = session()->get('dr_id');   
        $field_name = $this->request->getVar('field_name');
        $fields = $this->request->getVar('fields');
        $category = $this->request->getVar('category');
        
        $categoryData = array(
            'field_names'=> $field_name,
            'fields'=> $fields,
            'category_name'=> $category,
            'org_id'=> $org_id,
            'uploaded_by'=>$dr_id
        );
        $model = new ExamCategoriesModel(); 
        $model->save($categoryData);
        $insertedID = $model->insertID();

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

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

$id  = $this->request->getVar('id');
        // $file = $this->request->getVar('file_name');
   
        $delete = new ExamCategoriesModel();        
        $delete->where('id',$id); 
        $delete->where('org_id',$org_id);
        // $delete->select('category_name, files, categories.id as id, fields, field_names');
        // $delete->join('upload_files', 'categories.id = upload_files.categories_id', 'left');
        // $delete->where('categories_id',$id)->where('upload_files.files',$file);
        $deleteID = $delete->delete();
        // print_r($deleteID);die();

if($deleteID){
            return json_encode(array(
                'result'    => 1,
                'message'   => 'Deleted Successfully'
            ));
        }
        else{
            return json_encode(array(
                'result'    => 0,
                'message'   => 'Error'
            ));
        }
    }

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

$user_id = $this->request->getVar('id');
        //$file_name = $this->request->getVar('file_name');
        $model  = new ExamCategoriesModel();
        $model->where('org_id',$org_id);
        $data = $model->where('id',$user_id)->first();

// $models  = new FileUploadModel();
        // $data1 = $models->where('files',$file_name)->first();
        // if(!$data1){
        //   $data1 = ['files'=>''];
        // }
        
        if($data){
            return json_encode(array(
                  'result'    => 1,
                  'message'   => $data
                ));
        }
        else{
            return json_encode(array(
                  'result'    => 0,
                  'message'   => 'Something went wrong...'
            ));
        }
    }

public function update_prep_category_data(){

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

if($this->request->getMethod() == 'post'){
            $id = $this->request->getVar('cid');
            $field_names = $this->request->getVar('field_names');
            $fields = $this->request->getVar('fields');
            $category = $this->request->getVar('category');
            // $uploadFile = $this->request->getFile('file_up');

// $model1 = new FileUploadModel(); 
            // $details = $model1->where('categories_id',$id)->first();
            // $old_file_name = $details['files'];

// if($uploadFile->isValid() && !$uploadFile->hasMoved()){
            //     if(file_exists("uploads/".$old_file_name)){
            //         unlink("uploads/".$old_file_name);
            //     }
            //     $newName = $uploadFile->getName();
            //     $uploadFile->move('uploads/', $newName);
            // }
            // else{
            //     $newName = $old_file_name;
            // }

$newData = array(
                'field_names'=> $field_names,
                'fields'=> $fields, 
                'category_name'=> $category
            );

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

// $fileData = array(
            //     'files'=> $newName
            // );

// $model2 = new FileUploadModel();
            // $model2->set($fileData);
            // $model2->where('categories_id',$id);
            // $update2 = $model2->update();

if($update1){
                return json_encode(array(
                     'result'    => 1,
                     'message'   => 'Category Details were Updated successfully....'
                ));
           }
           else{
                return json_encode(array(
                     'result'    => 0,
                     'message'     => 'Something went wrong.....'
                ));
            }
        }
    }

public function get_all_users(){

$org_id = session()->get('org_id');
        $cat = $this->request->getVar('cat');
        // 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 = "exam_categories"; 
        $primaryKey = "id";

$columns = array(
            array(
                "db"=>"id",
                "dt"=>0,
            ),
            // array(
            //     "db"=>"field_names",
            //     "dt"=>1,
            // ),
            array(
                "db"=>"fields",
                "dt"=>1,
            ),
            array(
                "db"=>"category_name",
                "dt"=>2,
            ),
            array(
                "db"=>"id",
                "dt"=>3,
                "formatter"=>function($d, $row){
                    return "<div class='btn-group'>
                                  <button type='button' class='btn btn-sm btn-primary' data-id='".$row['id']."' id='updateCountryBtn'>Rename</button>
                                  <button type='button' class='btn btn-sm btn-danger' data-id='".$row['id']."' id='deleteCountryBtn'>Delete</button>
                             </div>";
                }
            ),
        );
        
        echo json_encode(
            \SSP::simple($_GET, $dbDetails, $table, $primaryKey, $columns, null, "field_names='$cat' AND org_id='$org_id'")
        );
    }
}
?>