✏️ Editing: Approve_leave.php

<?php

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

class approve_leave extends Admin_Controller {

function __construct() {
        parent::__construct();
        $this->sch_setting_detail = $this->setting_model->getSetting();
    }

function unauthorized() {
        $data = array();
        $this->load->view('layout/header', $data);
        $this->load->view('unauthorized', $data);
        $this->load->view('layout/footer', $data);
    }
 
    function index() {

if (!$this->rbac->hasPrivilege('approve_leave', 'can_view')) {
            access_denied();
        }
        $this->session->set_userdata('top_menu', 'Attendance');
        $this->session->set_userdata('sub_menu', 'Attendance/approve_leave');
        $class = $this->class_model->get();
        $data['classlist'] = $class;
        $data['class_id'] = $class_id = '';
        $data['section_id'] = $section_id = '';
        $data['sch_setting']     = $this->setting_model->getSetting();
        $data['results'] = array();
        $listaudit = $this->apply_leave_model->get(null, null, null);
        if (isset($_POST['class_id']) && $_POST['class_id'] != '') {
            $data['class_id'] = $class_id = $_POST['class_id'];
        }

if (isset($_POST['section_id']) && $_POST['section_id'] != '') {
            $data['section_id'] = $section_id = $_POST['section_id'];
        }
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|required|xss_clean');
        if ($this->form_validation->run() == FALSE) {
            
        } else {
            $listaudit = $this->apply_leave_model->get(null, $class_id, $section_id);
        }

$data['results'] = $listaudit;
       
        $this->load->view('layout/header');
        $this->load->view('admin/approve_leave/index', $data);
        $this->load->view('layout/footer');
    }

public function get_details() {
        $userdata = $this->customlib->getUserData();
        $role_id = $userdata["role_id"];
        $can_edit = 1;

if (isset($role_id) && ($userdata["role_id"] == 2) && ($userdata["class_teacher"] == "yes")) {
            $myclasssubjects = $this->apply_leave_model->canApproveLeave($userdata["id"], $this->input->post('class_id'), $this->input->post('section_id'));
            $can_edit = $myclasssubjects;
        }

if ($can_edit == 0) {

$data = array('status' => 0, 'error' => $this->lang->line('not_authoried'));
        } else {
            $data = $this->apply_leave_model->get($_POST['id'], null, null);
            $data['status'] = 1;
            $data['from_date'] = date($this->customlib->getSchoolDateFormat(), strtotime($data['from_date']));
            $data['to_date'] = date($this->customlib->getSchoolDateFormat(), strtotime($data['to_date']));
            $data['apply_date'] = date($this->customlib->getSchoolDateFormat(), strtotime($data['apply_date']));
        }
        echo json_encode($data);
    }

public function add() {

$student_id = '';
        $this->form_validation->set_rules('class', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section', $this->lang->line('section'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('apply_date', $this->lang->line('apply') . " " . $this->lang->line('date'), 'trim|required|xss_clean');
		
        $this->form_validation->set_rules('from_date', $this->lang->line('from') . " " . $this->lang->line('date'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('to_date', $this->lang->line('to') . " " . $this->lang->line('date'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('student', $this->lang->line('student'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('userfile', $this->lang->line('file'), 'callback_handle_upload[userfile]');
        if ($this->form_validation->run() == FALSE) {

$msg = array(
				'class' => form_error('class'),
				'section' => form_error('section'),
                'apply_date' => form_error('apply_date'),
                'from_date' => form_error('from_date'),
                'to_date' => form_error('to_date'),
                'student' => form_error('student'),
                'userfile' => form_error('userfile')
                
            );

$array = array('status' => 'fail', 'error' => $msg, 'message' => '');
        } else {

$student_session_id = $this->apply_leave_model->get_studentsessionId($_POST['class'], $_POST['section'], $_POST['student']);

$data = array(
    'apply_date' =>  date('Y-m-d', $this->customlib->datetostrtotime($this->input->post('apply_date'))),
    'from_date' =>  date('Y-m-d', $this->customlib->datetostrtotime($this->input->post('from_date'))),
    'to_date' => date('Y-m-d', $this->customlib->datetostrtotime($this->input->post('to_date'))),
                'student_session_id' => $student_session_id['id'],
                'reason' => $this->input->post('message'),
                'request_type' => '1'
            );

if ($this->input->post('leave_id') == '') {

$leave_id = $this->apply_leave_model->add($data);
                $data['id'] = $leave_id;
            } else {
                $data['id'] = $this->input->post('leave_id');
                $this->apply_leave_model->add($data);
            }

if (isset($_FILES["userfile"]) && !empty($_FILES['userfile']['name'])) {
                $fileInfo = pathinfo($_FILES["userfile"]["name"]);
                $img_name = $data['id'] . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["userfile"]["tmp_name"], "./uploads/student_leavedocuments/" . $img_name);
                $data = array('id' => $data['id'], 'docs' => $img_name);
                $this->apply_leave_model->add($data);
            }

$array = array('status' => 'success', 'error' => '', 'message' => $this->lang->line('success_message'));
        }

echo json_encode($array);
    }

public function searchByClassSection($class_id, $student_id) {

$section_id = $_REQUEST['section_id'];
        $resultlist = $this->student_model->searchByClassSection($class_id, $section_id);

$data['resultlist'] = $resultlist;
        $data['select_id'] = $student_id;
        $data['sch_setting'] = $this->sch_setting_detail;

$this->load->view('admin/approve_leave/_student_list', $data);
    }

public function status() {
        $userdata = $this->customlib->getUserData();
        $role_id = $userdata["role_id"];
        $can_edit = 1;

if ($can_edit == 0) {
            $msg = array('leave' => $this->lang->line('not_authoried'));
            $array = array('status' => 0, 'error' => $this->lang->line('not_authoried'));
        } else {
            if ($_POST['status'] == 1) {
                $data['approve_by'] = $this->customlib->getStaffID();
            } else {
                $data['approve_by'] = 0;
            }

$data['status'] = $_POST['status'];
            $this->db->where('id', $_POST['id']);
            $this->db->update('student_applyleave', $data);
            $msg = array('leave' => $this->lang->line('success_message'));
            $array = array('status' => 1, 'success' => $this->lang->line('success_message'));
        }
        echo json_encode($array);
    }

public function remove_leave() {
        $userdata = $this->customlib->getUserData();
        $role_id = $userdata["role_id"];
        $can_edit = 1;

if ($can_edit == 0) {

$array = array('status' => 0, 'error' => $this->lang->line('not_authoried'));
        } else {
            $this->apply_leave_model->remove_leave($_POST['id']);
            $array = array('status' => 1, 'success' => $this->lang->line('success_message'));
        }
        echo json_encode($array);
    }

public function download($doc) {

$this->load->helper('download');
        $filepath = "./uploads/student_leavedocuments/" . $doc;
        $data = file_get_contents($filepath);
        $name = $doc;

force_download($name, $data);
    }

public function handle_upload($str,$var)
    {

$image_validate = $this->config->item('file_validate');
        $result = $this->filetype_model->get();
        if (isset($_FILES[$var]) && !empty($_FILES[$var]['name'])) {

$file_type         = $_FILES[$var]['type'];
            $file_size         = $_FILES[$var]["size"];
            $file_name         = $_FILES[$var]["name"];

$allowed_extension = array_map('trim', array_map('strtolower', explode(',', $result->file_extension)));
            $allowed_mime_type = array_map('trim', array_map('strtolower', explode(',', $result->file_mime)));
            $ext               = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));

if ($files = filesize($_FILES[$var]['tmp_name'])) {

if (!in_array($file_type, $allowed_mime_type)) {
                    $this->form_validation->set_message('handle_upload', 'File Type Not Allowed');
                    return false;
                }

if (!in_array($ext, $allowed_extension) || !in_array($file_type, $allowed_mime_type)) {
                    $this->form_validation->set_message('handle_upload', 'Extension Not Allowed');
                    return false;
                }
                
                if ($file_size > $result->file_size) {
                    $this->form_validation->set_message('handle_upload', $this->lang->line('file_size_shoud_be_less_than') . number_format($image_validate['upload_size'] / 1048576, 2) . " MB");
                    return false;
                }

} else {
                $this->form_validation->set_message('handle_upload', "File Type / Extension Error Uploading ");
                return false;
            }

return true;
        }
        return true;

}

Advanced Web Server Manager