EVOLUTION-NINJA

Edit File: Internship.php

<?php

namespace App\Controllers;

class Internship extends BaseController
{

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

public function add_internship(){

$builder=$this->db->table('internship');

$name=$this->request->getPost('name');
        $start_date=$this->request->getPost('start_date');
        $end_date=$this->request->getPost('end_date');
        $project=$this->request->getPost('project');

$data=[
            "name"=>$name,
            "start_date"=>$start_date,
            "end_date"=>$end_date,
            'project'=>$project,
            "created_at"=>date('y-m-d H:i:s'),
            "created_by"=>session()->get('username'),
            
        ];

if( $builder->insert($data)){
            return $this->response->setJSON(['result'=>1,'message'=>'add internship  successfully ']);
        }

else{
            return $this->response->setJSON(['result'=>0,'message'=>'Failed to add']);
        }
   
    }

public function internship_list(){
        $builder=$this->db->table('internship');
        $data=$builder->get()->getResultArray();
     
        if($data){
            return $this->response->setJSON($data);
        }else{
            return $this->response->setJSON(['result'=>0,'message'=>'Failed to load data']);
        }

}

public function delete_internship()
{
    $id=$this->request->getVar('id');
    // echo $id;die();
   
    $builder=$this->db->table('internship');
    $builder->where('id',$id);
    $delete=$builder->delete();
    if($delete){
        return $this->response->setJSON(['result'=>1]);
    }else{
        return $this->response->setJSON(['result'=>0]);
    }
}

public function edit_Internship($id){

if($id){

$builder = $this->db->table('internship');
        $builder->where('id',$id);
        $data = $builder->get()->getResultArray();  
     return $this->response->setJSON(['result' => 1, 'data' =>$data]);  
    }
    else{

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

}

public function update_intern(){
 
    $id=$this->request->getPost('intern');
    $name=$this->request->getPost('name_model');
    $start_date=$this->request->getPost('start_date_model');
    $end_date=$this->request->getPost('end_date_model');
    $project=$this->request->getPost('project_model');
    
    $builder = $this->db->table('internship');
    $builder->where('id', $id);
    $data=[
        'name'=>$name,
        'start_date'=>$start_date,
        'end_date'=>$end_date,
        'project'=>$project,
    ];
    $update=$builder->update($data);
    if($update){
        
        return $this->response->setJSON(['result' => 1, 'message' =>' updated successfully']);   
    }
    else{
        
            return $this->response->setJSON(['result' => 0, 'message' =>'Failed to update']);  
    }
    }

public function autocomplete_intern_name()
{
    if ($this->request->isAJAX()) {
        $query = $this->request->getVar('term'); // Use getVar for both GET and POST

$db = \Config\Database::connect();
        $builder = $db->table('internship');

$data = $builder->select('name') // Only fetch 'name' since autocomplete needs text
                        ->like('name', $query)
                        ->limit(10)
                        ->get()
                        ->getResultArray();

// Format data for jQuery UI Autocomplete
        $response = [];
        foreach ($data as $row) {
            $response[] = $row['name']; // Send only names
        }

return $this->response->setJSON($response);
    }
}

public function get_internship_data() {
    $name = $this->request->getGet('name');

$builder = $this->db->table('internship');
    $builder->select('*');
    $builder->where('name', $name);
    
    $data = $builder->get()->getRow();

// print_r($data);die();
    return view('certificate/internship_page', ['data' => $data]);

}

}
?>