EVOLUTION-NINJA

Edit File: Roles1.php

<?php

namespace App\Controllers;

class Roles extends BaseController{

public function __construct()  
    { 
        $this->db = \Config\Database::connect(); 
          
    }

public function add_roles(){
$role_name=$this->request->getpost('role_name');
$remarks=$this->request->getpost('remarks');
$created_at=date('y-m-d H-i-s');
// echo date('Y-m-d H:i:s');

$created_by = session()->get('username');

$data=[
    "role"=>$role_name,
    'remarks'=>$remarks,
    'created_at'=>$created_at,
   'created_by'=>$created_by,

];

try {
    $builder=$this->db->table('roles');
    if($builder->insert($data)){

return $this->response->setJSON(['result'=>1,'message'=>'Role Add successfully']);
    }else{

return $this->response->setJSON(['result'=>0,'message'=>'Failed Create Role']);
    }

}catch(\Exception $e){
    return $this->response->setJSON(['result' => 0, 'message' => $e->getMessage()]);
}

}

public function fetch_roles(){

$db = \Config\Database::connect();
    $builder = $db->table('roles'); 
    $builder->select('id ,role'); 
    $query = $builder->get();
    $role = $query->getResultArray();

if ($role) {
        return $this->response->setJSON($role);
    } else {
        return $this->response->setJSON(['result' => 0, 'message' => 'No headers found']);
    }
}

public function add_roles_creation(){

$role_name = $this->request->getPost('role');
    $admin = $this->request->getPost('admin');
    $apm = $this->request->getPost('apm');
    $supervisor = $this->request->getPost('supervisor');
    $remarks = $this->request->getPost('remarks');
    $created_at = date('Y-m-d H:i:s'); 
    $created_by = session()->get('username');
    
    $data = [
        'role' => $role_name,
        'created_at' => $created_at,
        'created_by' => $created_by,
    ];
    if (!empty($admin)) {
        $data['apm'] = $admin;
    }
    if (!empty($apm)) {
        $data['supervisor'] = $apm;
    }
    
    if (!empty($supervisor)) {
        $data['engineer'] = $supervisor;
    }
    
    if (!empty($remarks)) {
        $data['remarks'] = $remarks;
    }
    try {
        $builder=$this->db->table('create_roles');
        if($builder->insert($data)){
    
            return $this->response->setJSON(['result'=>1,'message'=>'Role Add successfully']);
        }else{
    
            return $this->response->setJSON(['result'=>0,'message'=>'Failed Create Role']);
        }
    
    }catch(\Exception $e){
        return $this->response->setJSON(['result' => 0, 'message' => $e->getMessage()]);
    }

}