EVOLUTION-NINJA

Edit File: Add_Syllabus.php

<?php 
 
namespace App\Controllers; 
 
use CodeIgniter\Controller; 
 
 
class Add_Syllabus extends Controller 
{ 
    
 
    public function __construct()  
    { 
        $this->db = \Config\Database::connect(); 
    } 
 
    public function get_headers() 
    { 
        $builder = $this->db->table('header'); 
        $query = $builder->get(); 
        return $this->response->setJSON($query->getResult()); 
    } 
 
public function get_courses($header_id) 
{ 
    $builder = $this->db->table('header_value'); 
    $builder->where('header_id', $header_id); 
    $query = $builder->get(); 
    return $this->response->setJSON($query->getResult()); 
} 
 
  
    public function add_syllabus_form() 
    { 
        
        $header_id = $this->request->getPost('header_id'); 
        $course_id = $this->request->getPost('course_id'); 
        $syllabus_name = $this->request->getPost('syllabus_name'); 
 
        if (is_null($header_id) || is_null($course_id) ) { 
            return $this->response->setJSON(['result' => 0, 'message' => 'Invalid input data']); 
        } 
     
        $data = [ 
            'header_id' => $header_id, 
            'course_id' => $course_id, 
            'syllabus_name' => $syllabus_name, 
           
        ]; 
     
        try { 
            $builder = $this->db->table('syllabus'); 
            if ($builder->insert($data)) { 
                return $this->response->setJSON(['result' => 1, 'message' => 'syllabus added successfully']); 
            } else { 
                return $this->response->setJSON(['result' => 0, 'message' => 'Failed to add chapter']); 
            } 
        } catch (\Exception $e) { 
            return $this->response->setJSON(['result' => 0, 'message' => $e->getMessage()]); 
        } 
    } 
 
    public function get_syllabus_list() 
{ 
    $draw = intval($this->request->getGet('draw')); 
    $start = intval($this->request->getGet('start')); 
    $length = intval($this->request->getGet('length')); 
    $search = $this->request->getGet('search')['value']; 
     
    $order = $this->request->getGet('order'); 
    $columns = $this->request->getGet('columns'); 
     
    $limit = $length; 
    $offset = $start; 
     
    $builder = $this->db->table('syllabus'); 
    $builder->select('syllabus.*, header.header_name, header_value.value_name AS course_name'); 
    $builder->join('header', 'header.id = syllabus.header_id'); 
    $builder->join('header_value', 'header_value.id = syllabus.course_id'); 
     
    if (!empty($search)) { 
        $builder->groupStart(); 
        $builder->like('syllabus.syllabus_name', $search) 
                ->orLike('header.header_name', $search) 
                ->orLike('header_value.value_name', $search); 
        $builder->groupEnd(); 
    } 
   
    if (!empty($order)) { 
        foreach ($order as $ord) { 
            $columnIndex = $ord['column']; 
            $columnName = $columns[$columnIndex]['data']; 
            $dir = $ord['dir']; 
            $builder->orderBy($columnName, $dir); 
        } 
    } 
     
    $totalRecords = $builder->countAllResults(false); 
     
    $builder->limit($limit, $offset); 
    $query = $builder->get()->getResult(); 
     
    $response = [ 
        'draw' => $draw, 
        'recordsTotal' => $totalRecords, 
        'recordsFiltered' => $totalRecords,  
        'data' => $query, 
    ]; 
     
    return $this->response->setJSON($response); 
} 
 
public function delete_syllabus($syllabus_id) 
{ 
    try { 
        $builder = $this->db->table('syllabus'); 
        $builder->where('id', $syllabus_id); 
        if ($builder->delete()) { 
            return $this->response->setJSON(['result' => 1, 'message' => 'Syllabus deleted successfully']); 
        } else { 
            return $this->response->setJSON(['result' => 0, 'message' => 'Failed to delete syllabus']); 
        } 
    } catch (\Exception $e) { 
        return $this->response->setJSON(['result' => 0, 'message' => $e->getMessage()]); 
    } 
} 
 
public function get_syllabus($syllabus_id) 
{ 
    $builder = $this->db->table('syllabus'); 
    $builder->select('syllabus.*, header.header_name, header_value.value_name AS course_name'); 
    $builder->join('header', 'header.id = syllabus.header_id'); 
    $builder->join('header_value', 'header_value.id = syllabus.course_id'); 
    $builder->where('syllabus.id', $syllabus_id); 
    $query = $builder->get()->getRow(); 
     
    return $this->response->setJSON(['result' => 1, 'data' => $query]); 
} 
 
public function edit_syllabus_form() 
{ 
    $syllabus_id = $this->request->getPost('syllabus_id'); 
    $header_name = $this->request->getPost('header_name'); 
    $course_name = $this->request->getPost('course_name'); 
    $syllabus_name = $this->request->getPost('syllabus_name'); 
 
    if (is_null($syllabus_id) || is_null($header_name)  || is_null($course_name) || is_null($syllabus_name)) { 
        return $this->response->setJSON(['result' => 0, 'message' => 'Invalid input data']); 
    } 
 
    $header_id = $this->db->table('header')->select('id')->where('header_name', $header_name)->get()->getRow()->id; 
    $course_id = $this->db->table('header_value')->select('id')->where('value_name', $course_name)->get()->getRow()->id; 
 
    $data = [ 
        'header_id' => $header_id, 
        'course_id' => $course_id, 
        'syllabus_name' => $syllabus_name, 
    ]; 
 
    try { 
        $builder = $this->db->table('syllabus'); 
        $builder->where('id', $syllabus_id); 
        if ($builder->update($data)) { 
            return $this->response->setJSON(['result' => 1, 'message' => 'Syllabus updated successfully']); 
        } else { 
            return $this->response->setJSON(['result' => 0, 'message' => 'Failed to update syllabus']); 
        } 
    } catch (\Exception $e) { 
        return $this->response->setJSON(['result' => 0, 'message' => $e->getMessage()]); 
    } 
} 
 
 public function get_headers1()
    {
        $builder = $this->db->table('header');
        $query = $builder->get()->getResult();
        return $this->response->setJSON(['result' => 1, 'data' => $query]);
    }
    
public function get_courses1($header_id)
    {
        $builder = $this->db->table('header_value');
        $builder->where('header_id', $header_id);
        $query = $builder->get()->getResult();
        return $this->response->setJSON(['result' => 1, 'data' => $query]);
    }
public function get_syllabus1($header_id, $course_id)
    {
        $builder = $this->db->table('syllabus');
        $builder->where('header_id', $header_id);
        $builder->where('course_id', $course_id);
        $query = $builder->get()->getResult();
        return $this->response->setJSON(['result' => 1, 'data' => $query]);
    }
   public function update_syllabus()
    {
        $header_id = $this->request->getPost('header_id');
        $course_id = $this->request->getPost('course_id');
        $syllabus_id = $this->request->getPost('syllabus_id');
        $syllabus_name = $this->request->getPost('syllabus_name');

if (!$header_id || !$course_id || !$syllabus_id || !$syllabus_name) {
            return $this->response->setJSON(['result' => 0, 'message' => 'All fields are required']);
        }

$data = [
            'header_id' => $header_id,
            'course_id' => $course_id,
            'syllabus_name' => $syllabus_name,
        ];

$builder = $this->db->table('syllabus');
        $builder->where('id', $syllabus_id);
        $update = $builder->update($data);

if ($update) {
            return $this->response->setJSON(['result' => 1, 'message' => 'Syllabus updated successfully']);
        } else {
            return $this->response->setJSON(['result' => 0, 'message' => 'Failed to update syllabus']);
        }
    }

}