.-.-.-.-.-

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Course extends CI_Controller
{

function __construct()
    {
        parent::__construct();
        isLoggedIn();
        $this->load->model('course/Course_model');
    }

public function index()
    {
        if (hasPermission('course_create')) {

$page_data['page_title'] = 'Manage Course';
            $page_data['page_name'] = 'admin/course/list';

$this->load->view('admin/template', $page_data);
        } else {
            redirect(base_url('dashboard'));
        }
    }
    public function add()
    {
        if (hasPermission('course_create')) {

$college = $this->Course_model->getCollege()->result_array();

$page_data['page_title'] = 'Create Course';
            $page_data['page_name'] = 'admin/course/add';
            $page_data['college'] = $college;

$this->load->view('admin/template', $page_data);
        } else {
            redirect(base_url('dashboard'));
        }
    }

public function ajax_list()
    {

$CI = &get_instance();

$CI->load->model('course/Course_table');

$lists = $this->Course_table->get_datatables();

$start = $_POST['start'];

$data = array();

foreach ($lists as $list) {

$row = array();

$id = $list['course_id'];

$college_name = $list['college_name'];

$course_name = $list['course_name'];

$status = $list['status'];

$status_class = ($status == 1) ? "label label-primary" : "label label-danger";

$status_lable = ($status == 1) ? "Active" : "Inactive";

$status_title = ($status == 1) ? "Active" : "Inactive";

$status_padding = ($status == 1) ? "padding-left: 10px ;padding-right: 10px;" : "";

$btn_title_change = ($status == 1) ? "Deactivate" : "Activate";

$btn_color_change = ($status == 1) ? "btn btn-danger" : "btn btn-info";

$btn_padding = ($status == 0) ? "padding-right:18px;padding-left:18px" : "";

$data_status = ($status == 1) ? '0' : '1';

$active = '<center> <span class="' . $status_class . '" title="' . $status_title . '"style="' . $status_padding . '" >' . $status_lable . '</span> </center>';

$editUrl = base_url("course/edit/$id");

$delUrl = base_url("course/active");

$deleteUrl = base_url("course/delete");

$action = '<center>';

$action .= '<div class="col-md-6"> <div class="dropdown 	"><a class="dropdown-toggle" type="button" data-toggle="dropdown"><i class="glyphicon glyphicon-option-horizontal fs-24"></i></a>

<ul class="dropdown-menu dropdown-menu-right">';
            if (hasPermission('course_update')) {
                $action .= ' <li><a href="' . $editUrl . '">Edit   </a> </li>';
            }
            if (hasPermission('course_status')) {
                $action .= '<li><a href="javascript:void(0)" data-id="' . $id . '" data-msg="' . $course_name . '" class="active-course" data-status="' . $data_status . '" data-label="course name" data-url="' . $delUrl . '">  ' . $btn_title_change . ' </a></li>';
            }
            if (hasPermission('course_delete')) {

$action .= '<li><a href="javascript:void(0)" data-id="' . $id . '" data-msg="' . $course_name . '" class="delete-course" data-status="2" data-label="course name" data-url="' . $deleteUrl . '">  Delete</a></li>';
            }
            $action .= ' </ul></div>';

$action .= '</center>';

$row[] = $start + 1;

$row[] = $college_name;
            $row[] = $course_name;

$row[] = $active;

$row[] = $action;

$row['DT_RowId'] = $id;

$data[] = $row;

$start++;
        }

$output = array(

"draw" => $_POST['draw'],

"recordsTotal" => $CI->Course_table->count_all(),

"recordsFiltered" => $CI->Course_table->count_filtered(),

"data" => $data,

);

echo json_encode($output);
    }

public function course_exist()
    {

$college_id = $this->input->post('college_id');
        $course_id = $this->input->post('course_id');
        $course_name = $this->input->post('course_name');
        echo $this->Course_model->course_exist($college_id, $course_name, $course_id);
    }

public function insert()
    {

$error_type = '';
        $msg = '';
        $result = false;

$this->form_validation->set_rules('college_id', 'College name', 'trim|required');
        $this->form_validation->set_rules('course_name', 'Course name', 'trim|required');

$college_id = $this->input->post('college_id');
            $course_name = $this->input->post('course_name');

$created_by = $this->session->userdata('user_id');

$created_on = date("Y-m-d H:i:s");

$data = array(
                'college_id' => $college_id,
                'course_name' => $course_name,

'created_by' => $created_by,
                'created_on' => $created_on,
            );

$result = $this->Course_model->insert($data);
            set_alert('success', "Course information created successfully.");

$error_type = 'm';
            $msg = 'Course created successfully.';
            $result = true;

($result) ? logActivity('Course ' .$course_name.' is created ', LOG_COURSE) : '';
        }
        echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg));
    }
    public function update()
    {
 
        $error_type = '';
        $msg = '';
        $result = false;

$this->form_validation->set_rules('college_id', 'College name', 'trim|required');
        $this->form_validation->set_rules('course_name', 'Course name', 'trim|required');

if ($this->form_validation->run() == FALSE) {
            $error_type = 'v';
            $msg = validation_errors('<p class="error">', '</p>'); //validation_errors();
            $result = false;
        } else {
            $userId = $this->session->userdata('user_id');
            $course_id = $this->input->post('course_id');
            $new_course_name = $this->input->post('course_name');
            $result1 = $this->Course_model->get_Coursename($course_id)->row_array();
            $old_value = $result1['course_name'];
            
           
            $college_id = $this->input->post('college_id');

$updated_by = $this->session->userdata('user_id');

$updated_on = date("Y-m-d H:i:s");

$data = array(
                'college_id' => $college_id,
                'course_name' => $new_course_name,
                'updated_by' => $updated_by,
                'updated_on' => $updated_on,
            );

//print_r($data);exit;
            $result = $this->Course_model->update($course_id, $data);

set_alert('success', "Course information updated successfully.");

$error_type = 'm';
            // $msg = 'Course updated successfully.';
            $result = true;

($result) ? logActivity('Course is updated from '.$old_value.' to '.$new_course_name , LOG_COURSE) : '';
        }
        echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg));
    }

public function edit()
    {
        if (hasPermission('course_update')) {

$id = $this->uri->segment(3);

if ($id != '') {

$qry = $this->Course_model->get($id);

$college = $this->Course_model->getCollege()->result_array();

if ($qry->num_rows() > 0) {

$clg_data = $qry->row();
                    $data = array(

'page_title' => 'Update Course',
                        'page_name' => 'admin/course/edit',
                        'college_id' => $clg_data->college_id,
                        'course_name' => $clg_data->course_name,
                        'course_id' => $clg_data->course_id,
                        'college' => $college,

);

$this->load->view('admin/template', $data);
                } else {

redirect(base_url('academic'));
                }
            }
        } else {
            redirect(base_url('dashboard'));
        }
    }

public function getCourse() 
			
    {

$id = $this->input->post('id');

$res = $this->Course_model->getCourse($id);

echo $res;

}   
    public function delete()
    {

$id = $this->input->post('id');
        $result = $this->Course_model->get_Coursename($id)->row_array();
        $course_name = $result['course_name'];

$msg = $this->input->post('msg');

$status = $this->input->post('status');

$log = ($status == 2) ? 'Deleted' : 'Deleted';

$data = array();

$data['status'] = $status;

$result = $this->Course_model->active_update($id, $data);

//echo $this->db->last_query();

$result = ($result > 0) ? True : False;

($result) ? logActivity('Course ' . $course_name . " is " . $log, LOG_COURSE) : '';

echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
    }

public function active()
    {
        if (hasPermission('course_status')) {

$id = $this->input->post('id');
            $result = $this->Course_model->get_Coursename($id)->row_array();
            $c_name = $result['course_name'];
            $msg = $this->input->post('msg');

$status = $this->input->post('status');

$log = ($status == 1) ? 'Activated' : 'Deactivated';

$data = array();

$data['status'] = $status;

$result = $this->Course_model->active_update($id, $data);

//echo $this->db->last_query();

$result = ($result > 0) ? True : False;

($result) ? logActivity('Course ' . $c_name . " is " . $log, LOG_COURSE) : '';

echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));

//echo $result;

}
    }
}

/var/www/yapwebtv.com/../../www/krcollege.co/application/controllers/Course.php