.-.-.-.-.-

<?php

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

class Scholarship extends CI_Controller
{

function __construct()
    {
        parent::__construct();
        isLoggedIn();
        $this->load->model('scholarship/Scholarship_model');
        $this->load->model('admission/Admission_model');
    }

public function index()
    {
        if (hasPermission('scholarship_apply')) {
            $year = $this->uri->segment(3);

$year = (trim($year) == 2) ? 2 : 1;

$academic = $this->session->userdata('academic_id');
            $course = $this->session->userdata('course_id');
            $academic_year = $this->Admission_model->get_academicyear($academic)->row_array();
            $getStudent   = $this->Scholarship_model->getStudent()->result_array();
            $course_detail = $this->Admission_model->getcourse_detail($course)->row_array();

$page_data['page_title'] = 'Manage Scholarship';
            $page_data['page_name'] = 'admin/scholarship/scholarship';
            $page_data['academic_year'] = $academic_year['academic_from_year'] . '-' . $academic_year['academic_to_year'];
            $page_data['getStudent'] = $getStudent;
            $page_data['year'] = $year;
            $page_data['detail'] = $course_detail['course_name'];

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

// }

public function insert()
    {
        if (hasPermission('scholarship_apply')) {
            $error_type = '';
            $msg = '';
            $result = false;

$userId = $this->session->userdata('user_id');
            $academic_year_id = $this->session->userdata('academic_year_id');
            $course_id = $this->session->userdata('course_id');
            $academic_year_id = $this->session->userdata('academic_id');
            $course = $this->session->userdata('course_id');
            $college = $this->session->userdata('college_id');

$course_of_year = $this->input->post('course_of_year');
            $admission_id = $this->input->post('admission_id');
            $already = $this->Scholarship_model->getDetail($admission_id);
            //   print_r($already);
            $amount = $this->input->post('amount');
            $admisssion_detail = $this->Scholarship_model->getAdmissionDetail($admission_id)->row_array();
            $admission_name = $admisssion_detail['student_name_english'];
            $course_name = $admisssion_detail['course_name'];
            $get_ac_year = $admisssion_detail['academic_from_year'] . '-' . $admisssion_detail['academic_to_year'];

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

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

$data = array(
                'course_id' => $course_id,
                'academic_year_id' => $academic_year_id,
                'admission_id' => $admission_id,

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

$col = $course_of_year == 1 ? 'first_yr_sanction_amt' : 'sec_yr_sanction_amt';
            $colStatus = $course_of_year == 1 ? 'first_status' : 'sec_status';

$data[$col] = $amount;
            $data[$colStatus] = 1;

$result = $this->Scholarship_model->insert($already, $admission_id, $data);
            //   print_r($result);
            set_alert('success', "Scholarship information created successfully.");

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

($result) ? logActivity('Scholarship applied to ' . $admission_name . ' ' . 'Rs' . '-' . $amount . ' ' . '(' . $course_name . ' & ' . $get_ac_year . ')', LOG_SCHOLARSHIP) : '';

echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg));
        } else {
            redirect(base_url('dashboard'));
        }
    }

public function ajax_list()
    {

$CI = &get_instance();

$CI->load->model('scholarship/Scholarship_table');

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

$start = $_POST['start'];

$data = array();

foreach ($lists as $list) {

$row = array();

$id = $list['admission_id'];
            $student_name_english = strtoupper($list['student_name_english']);

$date_birth = date('d-m-Y', strtotime($list['date_birth']));

$community = $list['community_name'];

$row[] = $start + 1;
            $row[] = $student_name_english;
            $row[] = $date_birth;
            $row[] = $community;
            $row['DT_RowId'] = $id;

$data[] = $row;

$start++;
        }

$output = array(

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

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

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

"data" => $data,

);

echo json_encode($output);
    }

public function sanction()
    {
        if (hasPermission('scholarship_sanction')) {

$admisssion_detail = $this->Scholarship_model->getAdmissionDetail($id)->row_array();
            $admission_name = $admisssion_detail['student_name_english'];
            $course_name = $admisssion_detail['course_name'];
            $get_ac_year = $admisssion_detail['academic_from_year'] . '-' . $admisssion_detail['academic_to_year'];

$year_val = $year == 1 ? 'first_status' : 'sec_status';

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

$data = array();
            $data[$year_val] = 2;

$result = $this->Scholarship_model->update_san($id, $data);

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

set_alert('success', "Scholarship sanctioned successfully.");

$error_type = 'm';
            $msg = 'Scholarship sanctioned successfully.';
            $result = true;

$get_scholor_det = $this->Scholarship_model->getDetailscholor($id);

if($year == 1){
                $amount = $get_scholor_det['first_yr_sanction_amt'];

}
            else{
                $amount = $get_scholor_det['sec_yr_sanction_amt'];

}

($result) ? logActivity('Scholarship sanctioned to ' . $admission_name . ' ' . 'Rs' . '-' . $amount . ' ' . '(' . $course_name . ' & ' . $get_ac_year . ')', LOG_SCHOLARSHIP) : '';
            // ($result) ? logActivity('Scholarship sanctioned to ' . $admission_name . ' (' . $course_name . ' & ' . $get_ac_year . ')', LOG_SCHOLARSHIP) : '';
            echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
        } else {
            redirect(base_url('dashboard'));
        }
    }

public function cancel()
    {
        if (hasPermission('scholarship_cancel')) {

$userId = $this->session->userdata('user_id');
            $id = $this->input->post('id');
            $msg = $this->input->post('msg');
            $status = $this->input->post('status');
            $year = $this->input->post('year');
            $admisssion_detail = $this->Scholarship_model->getAdmissionDetail($id)->row_array();
            $admission_name = $admisssion_detail['student_name_english'];
            $course_name = $admisssion_detail['course_name'];
            $get_ac_year = $admisssion_detail['academic_from_year'] . '-' . $admisssion_detail['academic_to_year'];

$year_val = $year == 1 ? 'first_status' : 'sec_status';

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

$data = array();
            $data[$year_val] = 3;

$result = $this->Scholarship_model->update_can($id, $data);

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

set_alert('success', "Scholarship cancelled successfully.");

$error_type = 'm';
            $msg = 'Scholarship cancelled successfully.';
            $result = true;

$get_scholor_det = $this->Scholarship_model->getDetailscholor($id);

if($year == 1){
                $amount = $get_scholor_det['first_yr_sanction_amt'];

}
            else{
                $amount = $get_scholor_det['sec_yr_sanction_amt'];

}

($result) ? logActivity('Scholarship cancelled to ' . $admission_name . ' ' . 'Rs' . '-' . $amount . ' ' . '(' . $course_name . ' & ' . $get_ac_year . ')', LOG_SCHOLARSHIP) : '';
            // ($result) ? logActivity('Scholarship cancelled for ' . $admission_name . ' (' . $course_name . ' & ' . $get_ac_year . ')', LOG_SCHOLARSHIP) : '';
            echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
        } else {
            redirect(base_url('dashboard'));
        }
    }
}

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