.-.-.-.-.-

<?php

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

class Certificate extends CI_Controller {

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

public function index() {
        // $admission_id =$this->session->userdata('certificate');
        // if($admission_id == 1){
        // $certificate =  $this->Certificate_model->get_roles()->result_array();
        $page_data['page_title'] = 'Manage Certificate';
        $page_data['page_name'] = 'admin/certificate/list';
       
        $this->load->view('admin/template', $page_data);
   
   
        
    }

public function give_add() {
        $session_college_id = $this->session->userdata('college_id');
        $session_academic_id = $this->session->userdata('academic_id'); 
        $session_course_id = $this->session->userdata('course_id');

if(hasPermission('certificate_create')){
            $student_name = $this->Certificate_model->getStudentname($session_college_id,$session_academic_id,$session_course_id)->result_array();
   
        $page_data['page_title'] = 'Create Certificate';
        $page_data['page_name'] = 'admin/certificate/giving_certificate';
        $page_data['student_name'] = $student_name;

$this->load->view('admin/template', $page_data);
        }
   
    }
    public function getCertificate() {

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

$callsHtmal = $this->Certificate_model->getCertificate($id);

echo  json_encode(array('res' => $callsHtmal));

}
    public function getReceive() {

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

$callsHtmal = $this->Certificate_model->getReceive($id);

echo  json_encode(array('rest' => $callsHtmal));

}

public function recive_add() {
        $session_college_id = $this->session->userdata('college_id');
        $session_academic_id = $this->session->userdata('academic_id'); 
        $session_course_id = $this->session->userdata('course_id');

//  if(hasPermission('certificate_create')){
            $student_name = $this->Certificate_model->getStudentname($session_college_id,$session_academic_id,$session_course_id)->result_array();
            //    print_r($college_name);
   
        $page_data['page_title'] = 'Create Certificate';
        $page_data['page_name'] = 'admin/certificate/receiving_certificate';
        $page_data['student_name'] = $student_name;

$this->load->view('admin/template', $page_data);
     //   }
   
    }

public function insert() {

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

$this->form_validation->set_rules('student_name', 'Student Name ', 'trim|required');
       
        
        if ($this->form_validation->run() == FALSE) {
            $error_type = 'v';
            $msg = validation_errors('<p class="error">', '</p>'); //validation_errors();
            $result = false;
        } else {

$certificate_name = $this->input->post('certificate_name[]');

$no_of_certificate = $this->input->post('no_of_certificate[]');
           
     
            
            $certificate_no = $this->input->post('certificate_no[]');
            $is_submitted = $this->input->post('is_submitted[]');
            $admission_certificate_entry_id = $this->input->post('admission_certificate_entry_id[]');
            $quantity = $this->input->post('admission_certificate_entry_id[]');
          
           
           
            $c_data =[];
            if (!empty($is_submitted)) {
                for ($i = 0; $i < count($is_submitted); $i++) {

$cer_id = $admission_certificate_entry_id[$i];
                   
                    $c_data['is_submitted'] = 0;
                    
                    
                    $result = $this->Certificate_model->update($cer_id,$c_data);
 }
            }

$userId = $this->session->userdata('user_id');
             
            $certificate_status = $this->input->post('certificate_status');
            // $date_of_status = $this->input->post('date_of_status');
            $given_by = $this->input->post('given_by');
            $received_by = $this->input->post('received_by');
            $admission_id = $this->input->post('student_name');
            $student_name_english = $this->input->post('student_name_english');
            $date_of_status=date("d-m-Y ");

$data = array(
                'certificate_status' => 1,
                'date_of_status' => $date_of_status,
                'given_by' => 1,
                'received_by' => $student_name_english,
                'admission_id' => $admission_id,
             
             
            
                
                
          
            );    
                   
            $result = $this->Certificate_model->insert($data);
    set_alert('success', "Certificate information updated successfully.");

$error_type = 'm';
                    $msg = 'Certificate updated successfully.';
                    $result = true;
				
		      	($result) ? logActivity('Certificate created [#' . $admission_certificate_entry_id[$i] .']',LOG_CERTIFICATE) : '';
                
            
                
        
        echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg));
            
        }
    }

public function view() {
    
                $id = $this->uri->segment(3);
  
                    if ($id != '') {
        
                        $qry = $this->Certificate_model->get($id);
                        if($qry->num_rows() > 0) {

$cer_data = $qry->row();
                            // $certificate_history_id = $cer_data->certificate_history_id;
                            // $final=$this->Certificate_model->getTotal($certificate_history_id)->result_array();
                            $data = array(
        
                                'page_title' => 'Update Certificate',
                                'page_name' => 'admin/certificate/view',
                                // 'final' => $final,

'certificate_history_id' => $cer_data->certificate_history_id,
                               
                                 'admission_id' => $cer_data->admission_id,

//         'certificate_list_id'=> $cer_data->certificate_list_id,
                        //         'admission_certificate_entry_id'=> $cer_data->admission_certificate_entry_id,

'certificate_status' => $cer_data->certificate_status,
                                'date_of_status' => $cer_data->date_of_status,
                                'giver' => $cer_data->giver,
                                'receiver' => $cer_data->receiver,
                                // 'student_name_english' => $cer_data->received_by,
                                'certificate_no' => $cer_data->certificate_no,
                                'certificate_name' => $cer_data->certificate_name,
                                'student_name_english'=>$cer_data->student_name_english,
                                'no_of_certificate'=>$cer_data->no_of_certificate,
                                // 'no_of_certificate'=>$cer_data->no_of_certificate,

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

public function ajax_list() {

$admission_id = $this->session->userdata('admission_id');
                $course_id = $this->session->userdata('course_id');
            
               
                
                $CI = & get_instance();
        
        
                $CI->load->model('certificate/Certificate_table');
        
                $lists = $this->Certificate_table->get_datatables();
        
                $start = $_POST['start'];
        
        
        
                $data = array();
        
        
        
                foreach ($lists as $list) {
        
        
        
                    $row = array();
        
        
        
                    $id = $list['certificate_history_id'];
        
                    $admission_id = $list['admission_id'];

$student_name_english = $list['student_name_english'];

$date_birth = $list['date_birth'];
                   // $course_id = $list['course_id'];
                   $course_name = $list['course_name'];
                   
                  
                  
                  
                 
                    // $certificate_status= $list['certificate_status'];
                    $certificate_status = $list['certificate_status'];

$certificate_status_class = ($certificate_status == 1) ? "label label-primary" : "label label-danger";
        
                    $certificate_status_lable = ($certificate_status == 1) ? "Given" : "Received";
        
                    $certificate_status_title = ($certificate_status == 1) ? "Given" : "Received";
        
                    $certificate_status_padding = ($certificate_status == 1) ? "padding-left: 10px ;padding-right: 10px;" : "";
        
        
        
                    $btn_title_change = ($certificate_status == 2) ? "Deactivate" : "Activate";
        
                    $btn_color_change = ($certificate_status == 2) ? "btn btn-danger" : "btn btn-info";
        
                    $btn_padding = ($certificate_status == 1) ? "padding-right:18px;padding-left:18px" : "";
        
                    $data_status = ($certificate_status == 1) ? '1' : '2';
        
        
        
                    $active = '<center> <span class="' . $certificate_status_class . '" title="' . $certificate_status_title . '"style="' . $certificate_status_padding . '" >' . $certificate_status_lable . '</span> </center>';
        
        
                    
                    // $status = $list['status'];
        
                
                   
          
                    
                    $date_of_status = $list['date_of_status'];
                    
                    $given_by = $list['giver'];
                    $received_by = $list['receiver'];

$certificate_status = $list['certificate_status'];
                    $student_name_english=$list['student_name_english'];
                    $no_of_certificate=$list['no_of_certificate'];

$delUrl = base_url("certificate/active");
                    // $deleteUrl = base_url("certificate/delete");
                    
                    $action = '<center>';
        
                   $viewUrl=base_url("certificate/view/$id");
        
        
        
                    $action = '<center>';
        
                    $action="";
                    // $action ='<div class="col-md-6"><a href="'. $viewUrl .'"><button type="button" class="btn btn-primary btn-sm">print </button>  </a> </div>';
                    $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"><li><a href="' . $viewUrl . '">View   </a> </li>';
                   
                 
        
                    $row[] = $start + 1;
        
                    $row[] = $student_name_english." "."-"." ".$date_birth." "."-"." ".$course_name;
                    
                  
                    $row[] = $active;
                    
                    
            
                        
                    $row[] = $date_of_status;
                    $row[] = $given_by;
                    $row[] = $received_by;
        
        
        
                    $row[] = $action;
        
        
                    $row['DT_RowId'] = $id;
        
                    $data[] = $row;
        
                    $start++;
        
                }
        
        
        
        
        
        
        
                $output = array(
        
                    "draw" => $_POST['draw'],
        
                    "recordsTotal" => $CI->Certificate_table->count_all(),
        
                    "recordsFiltered" => $CI->Certificate_table->count_filtered(),
        
                    "data" => $data,
        
                );
        
                echo json_encode($output);
        
            }

public function delete() {

$id = $this->input->post('id');
        
                $msg = $this->input->post('msg');
        
                $certificate_status = $this->input->post('certificate_status');
        
                
        
                $log =($certificate_status == 2 ) ? 'Deleted' : 'Deleted' ;
        
                   $data = array();
        
                $data['certificate_status'] = $certificate_status;
        
                
        
        
        
                $result = $this->Certificate_model->update($id,$data);
        
                //echo $this->db->last_query();
        
                $result = ($result > 0) ? True : False;
        
        
        
                ($result) ? logActivity('Certificate[' . $msg .'-'.$log. ']',LOG_CERTIFICATE) : '';
        
                echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
            
        
            }
        
            public function active() {
        
                $id = $this->input->post('id');
        
                $msg = $this->input->post('msg');
        
                $certificate_status = $this->input->post('certificate_status');
        
                
        
                $log =($certificate_status == 1 ) ? 'Activated' : 'Deactivated' ;
        
        
        
                $data = array();
        
                $data['certificate_status'] = $certificate_status;
        
        
        
                $result = $this->Certificate_model->update($id, $data);
        
                //echo $this->db->last_query();
        
                $result = ($result > 0) ? True : False;
        
        
        
                ($result) ? logActivity('Certificate [' . $msg .'-'.$log. ']',LOG_CERTIFICATE) : '';
        
                echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
        
                //echo $result;
        
            }

}

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