EVOLUTION-NINJA

Edit File: Excel.php

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

use App\Models\SpinalModel;

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

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

public function index(){

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

if($org_id){
            $edituser=['z,x,y'];
            $data['user_management'] = $edituser;          
    
            if($org_id == 1 ){ //super admin
                $model = new OrganisationModel();
                // $model->where('id',$temple_id);
                $details  = $model->get()->getResultArray();
                $data['org'] = $details;
            }
            else{
                $model = new OrganisationModel();
                // $model->where('id',$org_id);
                $details  = $model->get()->getResultArray();
                $data['org'] = $details;
            }  
    
            // $model = new AdminModel();
            // $user_details  = $model->get()->getResultArray();
            // $data['details'] = $user_details;
    
            return view('admin/excel', $data);
        }else{
            return view('admin/super-admin-login');
        }
      
    }
     
    public function show_all_user_data(){

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

$model = new SpinalModel();
        $model->orderBy('id','ASC');

$data  = $model->get()->getResultArray();

$details = array();
        foreach($data as $val){
                $la_lignocaine = explode(",",$val['la_lignocaine']);
                $la_ropivacaine = explode(",",$val['la_ropivacaine']);

$la_bupivacaine = explode(",",$val['la_bupivacaine']);

$la_prilocaine = explode(",",$val['la_prilocaine']);

$la_2_chloroprocaine = explode(",",$val['la_2_chloroprocaine']);

$la_otheraine = explode(",",$val['la_otheraine']);

$det = array('patient_id'=>$val['patient_id'],
                        'lignocaine'=>$la_lignocaine[0],
                        'lignocaine_per'=>$la_lignocaine[1],
                        'lignocaine_ml'=>$la_lignocaine[2],
                        'lignocaine_mg'=>$la_lignocaine[3],

'ropivacaine'=>$la_ropivacaine[0],
                        'ropivacaine_per'=>$la_ropivacaine[1],
                        'ropivacaine_ml'=>$la_ropivacaine[2],
                        'ropivacaine_mg'=>$la_ropivacaine[3],

'bupivacaine'=>$la_bupivacaine[0],
                        'bupivacaine_per'=>$la_bupivacaine[1],
                        'bupivacaine_ml'=>$la_bupivacaine[2],
                        'bupivacaine_mg'=>$la_bupivacaine[3],

'prilocaine'=>$la_prilocaine[0],
                        'prilocaine_per'=>$la_prilocaine[1],
                        'prilocaine_ml'=>$la_prilocaine[2],
                        'prilocaine_mg'=>$la_prilocaine[3],

'chloroprocaine'=>$la_2_chloroprocaine[0],
                        'chloroprocaine_per'=>$la_2_chloroprocaine[1],
                        'chloroprocaine_ml'=>$la_2_chloroprocaine[2],
                        'chloroprocaine_mg'=>$la_2_chloroprocaine[3],

'other'=>$la_otheraine[0],
                        'other_name'=>$la_otheraine[1],
                        'other_per'=>$la_otheraine[2],
                        'other_ml'=>$la_otheraine[3],
                        'other_mg'=>$la_otheraine[4]);

array_push($details,$det);

}
       
        return $this->respondCreated($details);
    
    }

public function show_all_video_list(){

$org_id = session()->get('org_id');
        $dr_id = session()->get('dr_id');
        $role_id = session()->get('role_id');
        $model = new VideoModel();
        if($role_id==3 || $role_id==4){
            $model->where('org_id',$org_id);
            $model->where('status',1);
            $model->where('dr_id',$dr_id);
        }else{
            $model->where('org_id',$org_id);
            $model->where('status',1);
        }
        $model->orderBy('id','DESC');

$data  = $model->get()->getResultArray();

// print_r($data);die();
       
        return $this->respondCreated($data);
    
    }

public function show_row_details(){
        $id = $_GET['id']; 
        $org_id = session()->get('org_id');

$search = new RegisterUserModel();
        $search->where('id',$id)->where('org_id',$org_id);
        $data1 = $search->get()->getResultArray();
        // print_r($data1);die();

return $this->respondCreated($data1);

}

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

$id  = $this->request->getVar('id');
        // print_r($id);die();
        $model = new RegisterUserModel();
        $model->where('org_id',$org_id);
        $data = $model->where('id',$id)->first();            
      
        // print_r($data);die();
        if($data){
            return json_encode(array(
                'result'    => 1,
                'message'   => $data
            ));
        }
        else{
            return json_encode(array(
                'result'    => 0,
                'message'   => 'Something went wrong...'
            ));
        }

}

public function edit_change_action(){

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

$model = new RegisterUserModel();
        $model->set($newData);
        // $model->where('role_id',$section_name);
        $model->where('id',$id);
        $updatez = $model->update();

// print_r($update);die();

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

public function delete_video_action(){

$org_id = session()->get('org_id');
        $id  = $this->request->getVar('id');        
        
        $newData = array(
            'status'=>'0'          
        );

$model = new VideoModel();
        $model->set($newData);
        // $model->where('role_id',$section_name);
        $model->where('id',$id);
        $updatez = $model->update();

// print_r($update);die();