.-.-.-.-.-

<?php

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

class Manage_extra_fees extends CI_Controller {

function __construct() 
	{
        parent::__construct();
        isLoggedIn();
        $this->load->model('manage_extra_fees/Manage_extra_fees_model');
        $this->load->model('admission/Admission_model');

}

public function index() 
	{
    
        $course = $this->session->userdata('course_id');
        $academic = $this->session->userdata('academic_id');

$fee_types = $this->Manage_extra_fees_model->getfeetype($course,$academic)->result_array();
        $student_name = $this->Manage_extra_fees_model->getstudent($course,$academic)->result_array();
        $course_study = $this->Admission_model->getcourse_study($course)->row_array();

$academic_year = $this->Admission_model->get_academicyear($academic)->row_array();
        $page_data['page_title'] = 'Manage Extra Fees';
        $page_data['page_name'] = 'admin/manage_extra_fees/manage_extra_fees';
        $page_data['fee_types'] = $fee_types;
        $page_data['student_name'] = $student_name;
        $page_data['academic_year'] = $academic_year['academic_from_year'] . '-' . $academic_year['academic_to_year'];
        $page_data['study'] = $course_study['course_name'];
     
       $this->load->view('admin/template', $page_data);
  
	
}

public function ajax_list() {

$CI = & get_instance();

$CI->load->model('manage_extra_fees/Manage_extra_fees_table');

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

$start = $_POST['start'];

$data = array();

foreach ($lists as $list) {

$row = array();

$id = $list['admission_id'];

$admission_no = $list['admission_no'];

$student_name_english= $list['student_name_english'];

$date_birth= $list['date_birth'];

$getAmtDetail = $this->Manage_extra_fees_model->getAmtDetail($id)->row_array();
    if(!empty($getAmtDetail)){
    $amount= $getAmtDetail['amt'];
    $paid_amount= $getAmtDetail['pamt'];
    $balance_amount= $getAmtDetail['bamt'];
    }else{
    $amount= '';
    $paid_amount= '';
    $balance_amount= '';
    }

$check ='<input type="checkbox" class="check_manage" value="'.$id.'" id="check_manage" name="check_manage[]">';
           
    $feesurl = base_url("manage_extra_fees/fees_details/$id");

$action = '<center>';
    
    $action .='<div class="col-md-6"><button type="button" class="btn btn-primary mb-3 assign_extra_fee" data-id="' . $id . '" data-target="#myModal" data-toggle="modal" >Update Fees</button></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">';

$action .= '<li><a href="' . $feesurl . '">View Fees Details   </a> </li>';
     
          
        $action .= '</ul></div></div>';
  
    $action .= '</center>';

$row[] = $start + 1;
     
        
            $row[] = $admission_no;

$row[] = $student_name_english;
                                      
        
            
            $row[] = $date_birth;

$row[] = $amount;
            $row[] = $paid_amount;
            $row[] = $balance_amount;
            $row[] = "";

$row[] = $action;

$row['DT_RowId'] = $id;

$data[] = $row;

$start++;

}

$output = array(

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

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

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

"data" => $data,

);

echo json_encode($output);

}

public function insert() {

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

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

$admission_id = $this->input->post('ad_id');
        $type_name = $this->input->post('type_name[]');
        $amount = $this->input->post('amount[]');
        $reasion_fee = $this->input->post('reasion_fee[]');

$getFeesStructureId = $this->Manage_extra_fees_model->getFeesStructureId($admission_id)->row_array();

$feesStructureId = $getFeesStructureId['admission_fee_structure_id'];
$userId = $this->session->userdata('user_id');
$updated_by= $this->session->userdata('user_id');
$updated_on=date("Y-m-d H:i:s");
$fee_year = 1;
        
$cer_rec_data =[];
 if (!empty($type_name)) {

for ($i = 0; $i < count($type_name); $i++) {

$cer_rec_data[$i]['admission_fee_structure_id'] = $feesStructureId;
        $cer_rec_data[$i]['fee_year'] = $fee_year;
        $cer_rec_data[$i]['fee_type_id'] = $type_name[$i];
        $cer_rec_data[$i]['amount'] = $amount[$i];
        $cer_rec_data[$i]['paid_amt'] = '';
        $cer_rec_data[$i]['balance_amt'] = $amount[$i];
        $cer_rec_data[$i]['fees_type'] = 2;
        $cer_rec_data[$i]['extra_fee_reason'] = $reasion_fee[$i];
        $cer_rec_data[$i]['created_on'] = $updated_on;
        $cer_rec_data[$i]['created_by'] = $updated_by;
      
  
    
           }

}

$this->Manage_extra_fees_model->insertExtraFee($cer_rec_data);    
             
             
             
             set_alert('success', "Extra fees  information Created successfully.");

$error_type = 'm';
                $msg = 'Extra Fees Created successfully.';
                $result = true;
            
              ($result) ? logActivity('Extra Fees created [#' . $userId .']',LOG_MANAGEEXTRAFEES) : '';
            
        
    }
    
    //  $certificate_history_id
     echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg ));
}

public function insertall() {

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

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

$admission_id = $this->input->post('student_check_all_st[]');
        $type_name = $this->input->post('feestype[]');
        $amount = $this->input->post('feestamt[]');
        $feestreason = $this->input->post('feestreason[]');
        $type_name =implode(",",$type_name);
        $amount = implode(",",$amount);
        $feestreason = implode(",",$feestreason);
        $type_name =explode(",",$type_name);
        $amount = explode(",",$amount);
        $feestreason = explode(",",$feestreason);

$getFeesStructureId = $this->Manage_extra_fees_model->getFeesStructureIdAll($admission_id)->result_array();

$userId = $this->session->userdata('user_id');
$updated_by= $this->session->userdata('user_id');
$updated_on=date("Y-m-d H:i:s");
$fee_year = 1;
      
       
$cer_rec_data =[];
 if (!empty($getFeesStructureId)) {
    for ($j = 0; $j < count($type_name); $j++) {

for ($i = 0; $i < count($getFeesStructureId); $i++) {
        
        $ad_id = $getFeesStructureId[$i]['admission_fee_structure_id'];
     
        $cer_rec_data[$i]['admission_fee_structure_id'] = $ad_id;
        $cer_rec_data[$i]['fee_year'] = $fee_year;
        $cer_rec_data[$i]['fee_type_id'] = $type_name[$j];
        $cer_rec_data[$i]['amount'] = $amount[$j];
        $cer_rec_data[$i]['paid_amt'] = '';
        $cer_rec_data[$i]['balance_amt'] = $amount[$j];
        $cer_rec_data[$i]['fees_type'] = 2;
        $cer_rec_data[$i]['extra_fee_reason'] = $feestreason[$j];
        $cer_rec_data[$i]['created_on'] = $updated_on;
        $cer_rec_data[$i]['created_by'] = $updated_by;
      
  
    
           }
           $this->Manage_extra_fees_model->insertExtraFee($cer_rec_data);

}
     }

set_alert('success', "Extra fees  information Created successfully.");

$error_type = 'm';
                $msg = 'Extra fees Created successfully.';
                $result = true;
            
              ($result) ? logActivity('Extra Fees created [#' . $userId .']',LOG_MANAGEEXTRAFEES) : '';
            
        
    }
    
    //  $certificate_history_id
     echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg ));
}

public function fees_details()
{

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

if ($id != '') {

$course = $this->session->userdata('course_id');
        $academic = $this->session->userdata('academic_id');

$qry = $this->Manage_extra_fees_model->getStudData($id);

$clg_data = $qry->row();

$course_id = $clg_data->course_id;
            $academic_year_id = $clg_data->academic_year_id;
            $id = $clg_data->admission_id;
            $student_name_english = $clg_data->student_name_english;
            $date_birth = $clg_data->date_birth;
         
           
            $course_study = $this->Admission_model->getcourse_study($course_id)->row_array();
            $academic_year = $this->Admission_model->get_academicyear($academic_year_id)->row_array();
            $getExtraOthers = $this->Manage_extra_fees_model->getExtraOthers($id)->result_array();

if($course_id == $course || $academic_year_id == $academic){

$data = array(
                'page_title' => 'View Fees Details',
                'page_name' => 'admin/manage_extra_fees/fees_details',
                'academic_year' => $academic_year['academic_from_year'] . '-' . $academic_year['academic_to_year'], 
           
                'study' => $course_study['course_name'],
                           
                'getExtraOthers' => $getExtraOthers,
                'student_name_english' => $student_name_english,
                'date_birth' => $date_birth,

);

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

}
        else{

redirect(base_url('manage_extra_fees'));
        }

}else{

redirect(base_url('manage_extra_fees'));
    }
    
}

}
?>

/var/www/krbed.in/../html/./../krcollege.co/system/../application/controller