1#@!#!123s

: / home / ksclnmuac / public_html / cas / application / controllers / admin /
Filename : Events.php
back
<?php

/**
 * Controller class for handling all requests related to events.
 *
 * @author Softpro India Pvt. Ltd.
 */
defined('BASEPATH') OR exit('No direct script access allowed');

class Events extends CI_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('admin/EventManagement');
        $this->load->model('admin/CourseManagement');
        $this->load->model('admin/DepartmentManagement');
        $this->load->model('admin/SubDepartmentManagement');
        $this->load->model('admin/SessionManagement');
        $this->load->model('admin/AchievementManagement');
    }

    public function index() {
        if ($this->sessionvalidator->isLoggedIn() && $this->sessionvalidator->isAccessGranted()) {
            $eventFilteredRecords = array();
            $events = array();
            if (isset($_POST['filterSubmitBtn'])) {
                $selectedSession = trim($this->input->post("session"));
                $selectedEventType = trim($this->input->post("eventType"));
                $selectedStartDate = (trim($this->input->post("startDate")) == "") ? "" : date("Y-m-d 00:00:00", strtotime(str_replace('/', '-', trim($this->input->post("startDate")))));
                $selectedEndDate = (trim($this->input->post("endDate")) == "") ? "" : date("Y-m-d 23:59:59", strtotime(str_replace('/', '-', trim($this->input->post("endDate")))));
                $selectedRangeAppliedWith = trim($this->input->post("dateRangeAppliedWith"));
                $selectedCoures = trim($this->input->post("course"));
                $selectedDept = trim($this->input->post("department"));
                $selectedSubDept = trim($this->input->post("subDepartment"));
                $eventFilteredRecords = $this->EventManagement->getEventReport($selectedSession, $selectedEventType, $selectedCoures, $selectedDept, $selectedSubDept, $selectedStartDate, $selectedEndDate, $selectedRangeAppliedWith)->result();
            } else {
                $eventFilteredRecords = array();
            }
            if (sizeof($eventFilteredRecords)) {
                for ($i = 0; $i < sizeof($eventFilteredRecords); $i++) {
                    $record = $eventFilteredRecords[$i];
                    $sub_depts = explode(",", $record->iem_sub_depts);
                    $sub_dept_info = array();
                    $depts = explode(",", $record->iem_depts);
                    $dept_info = array();
                    $courses = explode(",", $record->iem_courses);
                    $course_info = array();
                    foreach ($sub_depts as $sub_dept) {
                        array_push($sub_dept_info, stripslashes($this->SubDepartmentManagement->getSubDepartmentInfoBy($sub_dept)->result()[0]->sub_dept_name));
                    }
                    foreach ($depts as $dept) {
                        array_push($dept_info, stripslashes($this->DepartmentManagement->getDepartmentInfoBy($dept)->result()[0]->dept_name));
                    }
                    foreach ($courses as $course) {
                        array_push($course_info, stripslashes($this->CourseManagement->getCoursesBy($course)->result()[0]->sub_dept_name));
                    }
                    array_push($events, array(
                        'iem_id' => $record->iem_id,
                        'iem_title' => stripslashes($record->iem_title),
                        'iem_description' => stripslashes($record->iem_description),
                        'iem_sub_depts' => implode(',', $sub_dept_info),
                        'iem_depts' => implode(',', $dept_info),
                        'iem_courses' => implode(',', $course_info),
                        'iem_file' => ($record->iem_file == "" || $record->iem_file == NULL) ? "-" : "<a href='" . base_url($record->iem_file) . "' target='_blank' title='Click To View/Download'><i class='fa fa-file'></i></a>",
                        'iem_file_path' => ($record->iem_file == "" || $record->iem_file == NULL) ? "-" : base_url($record->iem_file),
                        'tsam_short_title' => stripslashes($record->tsam_short_title),
                        'session_name' => stripslashes($record->session_name),
                        'iem_start_date' => date("d-m-Y", strtotime($record->iem_start_date)),
                        'iem_end_date' => date("d-m-Y", strtotime($record->iem_end_date)),
                        'iem_active_status' => $record->iem_active_status,
                        'iem_delete_status' => $record->iem_delete_status,
                        'iem_added_by' => stripslashes($record->addedByAdmin),
                        'iem_added_on' => date("d-m-Y h:i:s A", strtotime($record->iem_added_on)),
                        'iem_updated_by' => stripslashes($record->updatedByAdmin),
                        'iem_updated_on' => date("d-m-Y h:i:s A", strtotime($record->iem_updated_on))
                    ));
                }
            }
            $viewData['allEvents'] = $events;
            $viewData['achievementHeads'] = $this->AchievementManagement->getNonDeletedActiveAchievementHeads()->result();
            $viewData['sessions'] = $this->SessionManagement->getNonDeletedActiveSessions()->result();
            $viewData['courses'] = $this->CourseManagement->getActiveAndNonDeletedCourses()->result();
            $viewData['departments'] = $this->DepartmentManagement->getActiveNonDeletedDepartments()->result();
            $viewData['subDepartments'] = $this->SubDepartmentManagement->getActiveNonDeletedSubDepartments()->result();
            $this->load->view('admin/establishment/events', $viewData);
        } else {
            redirect("admin/");
        }
    }

    public function createEvent() {
        if ($this->sessionvalidator->isLoggedIn() && $this->sessionvalidator->isAccessGranted()) {
            $viewData['achievementHeads'] = $this->AchievementManagement->getNonDeletedActiveAchievementHeads()->result();
            $viewData['sessions'] = $this->SessionManagement->getNonDeletedActiveSessions()->result();
            $viewData['courses'] = $this->CourseManagement->getActiveAndNonDeletedCourses()->result();
            $viewData['departments'] = $this->DepartmentManagement->getActiveNonDeletedDepartments()->result();
            $viewData['subDepartments'] = $this->SubDepartmentManagement->getActiveNonDeletedSubDepartments()->result();
            $this->load->view('admin/establishment/createEvent', $viewData);
        } else {
            redirect("admin/");
        }
    }

    public function saveNewEvent() {
        if ($this->sessionvalidator->isLoggedIn()) {
            $this->form_validation->set_rules('eventTitle', 'Event Title', 'trim|required', array('required' => 'Event Title Can Not Be Blank.'));
            $this->form_validation->set_rules('eventType', 'Event Type', 'trim|required', array('required' => 'Please Select Event Type.'));
            $this->form_validation->set_rules('eventSession', 'Session', 'trim|required', array('required' => 'Please Select Any Session.'));
            $this->form_validation->set_rules('eventFrom', 'Event Start Date', 'trim|required', array('required' => 'Please Enter Event Start Date.'));
            $this->form_validation->set_rules('eventTo', 'Event End Date', 'trim|required', array('required' => 'Pleaes Enter Event End Date.'));
            $this->form_validation->set_rules('eventDescription', 'Description', 'trim|required', array('required' => 'Please Enter Event Description.'));
            if ($this->form_validation->run() == FALSE) {
                $this->createEvent();
            } else if (!sizeof($this->input->post('eventCourses'))) {
                $this->session->set_flashdata('errorMessage', "Please Select At Least One Course.");
                $this->createEvent();
            } else if (!sizeof($this->input->post('eventDepts'))) {
                $this->session->set_flashdata('errorMessage', "Please Select At Least One Department.");
                $this->createEvent();
            } else if (!sizeof($this->input->post('eventSubDepts'))) {
                $this->session->set_flashdata('errorMessage', "Please Select At Least One Sub-Department.");
                $this->createEvent();
            } else {
                if (!empty($_FILES['eventFile']['name'])) {
                    $eventFileNameWithPath = "";
                    $configEventFile['upload_path'] = './assets/admin/uploads/events/';
                    $configEventFile['allowed_types'] = 'pdf|doc|docx|ppt|pptx|xls|xlsx|jpg|jpeg|png';
                    $configEventFile['max_size'] = '5120';
                    $configEventFile['file_ext_tolower'] = TRUE;
                    $configEventFile['encrypt_name'] = TRUE;
                    $this->load->library('upload', $configEventFile);
                    if (!$this->upload->do_upload('eventFile')) {
                        $this->session->set_flashdata('errorMessage', "Event File Can Not Be Uploaded As It Do Not Match With Event File Criteria. File Size 5 MB Max. & Allowed Extension: Only *.pdf,*.doc,*.docx,*.ppt,*.pptx,*.xls,*.xlsx,*.jpg,*.jpeg,*.png.");
                        $this->createEvent();
                    } else {
                        $eventFileNameWithPath = "/assets/admin/uploads/events/" . $this->upload->data()['file_name'];
                        $newEventInfo = array(
                            'iem_title' => addslashes(trim($this->input->post('eventTitle'))),
                            'iem_description' => addslashes(trim($this->input->post('eventDescription'))),
                            'iem_sub_depts' => implode(',', $this->input->post('eventSubDepts')),
                            'iem_depts' => implode(',', $this->input->post('eventDepts')),
                            'iem_courses' => implode(',', $this->input->post('eventCourses')),
                            'tsam_id' => trim($this->input->post('eventType')),
                            'session_id' => trim($this->input->post('eventSession')),
                            'iem_start_date' => date("Y-m-d 00:00:00", strtotime(str_replace('/', '-', trim($this->input->post("eventFrom"))))),
                            'iem_end_date' => date("Y-m-d 23:59:59", strtotime(str_replace('/', '-', trim($this->input->post("eventTo"))))),
                            'iem_file' => $eventFileNameWithPath,
                            'iem_added_on' => date("Y-m-d H:i:s"),
                            'iem_added_by' => $this->session->userdata("adminData")["smember_id"],
                            'iem_updated_on' => date("Y-m-d H:i:s"),
                            'iem_updated_by' => $this->session->userdata("adminData")["smember_id"]
                        );
                        if ($this->EventManagement->createNewEvent($newEventInfo)) {
                            $this->session->set_flashdata('successMessage', 'Event Created Successfully.');
                            redirect(current_url());
                        } else {
                            $this->session->set_flashdata('errorMessage', 'An Error Occured While Creating Event. Try Later.');
                            redirect(current_url());
                        }
                    }
                } else {
                    $newEventInfo = array(
                        'iem_title' => addslashes(trim($this->input->post('eventTitle'))),
                        'iem_description' => addslashes(trim($this->input->post('eventDescription'))),
                        'iem_sub_depts' => implode(',', $this->input->post('eventSubDepts')),
                        'iem_depts' => implode(',', $this->input->post('eventDepts')),
                        'iem_courses' => implode(',', $this->input->post('eventCourses')),
                        'tsam_id' => trim($this->input->post('eventType')),
                        'session_id' => trim($this->input->post('eventSession')),
                        'iem_start_date' => date("Y-m-d 00:00:00", strtotime(str_replace('/', '-', trim($this->input->post("eventFrom"))))),
                        'iem_end_date' => date("Y-m-d 23:59:59", strtotime(str_replace('/', '-', trim($this->input->post("eventTo"))))),
                        'iem_added_on' => date("Y-m-d H:i:s"),
                        'iem_added_by' => $this->session->userdata("adminData")["smember_id"],
                        'iem_updated_on' => date("Y-m-d H:i:s"),
                        'iem_updated_by' => $this->session->userdata("adminData")["smember_id"]
                    );
                    if ($this->EventManagement->createNewEvent($newEventInfo)) {
                        $this->session->set_flashdata('successMessage', 'Event Created Successfully.');
                        redirect(current_url());
                    } else {
                        $this->session->set_flashdata('errorMessage', 'An Error Occured While Creating Event. Try Later.');
                        redirect(current_url());
                    }
                }
            }
        } else {
            redirect("admin/");
        }
    }

    public function editEvent($iem_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $viewData['achievementHeads'] = $this->AchievementManagement->getNonDeletedActiveAchievementHeads()->result();
            $viewData['sessions'] = $this->SessionManagement->getNonDeletedActiveSessions()->result();
            $viewData['courses'] = $this->CourseManagement->getActiveAndNonDeletedCourses()->result();
            $viewData['departments'] = $this->DepartmentManagement->getActiveNonDeletedDepartments()->result();
            $viewData['subDepartments'] = $this->SubDepartmentManagement->getActiveNonDeletedSubDepartments()->result();
            $viewData['eventInfo'] = $this->EventManagement->getEventInfoBy($iem_id)->result()[0];
            $this->load->view('admin/establishment/editEvent', $viewData);
        } else {
            redirect("admin/");
        }
    }

    public function updateExam() {
        if ($this->sessionvalidator->isLoggedIn()) {
            $iem_id = $this->input->post('event_id');
            $this->form_validation->set_rules('eventTitle', 'Event Title', 'trim|required', array('required' => 'Event Title Can Not Be Blank.'));
            $this->form_validation->set_rules('eventType', 'Event Type', 'trim|required', array('required' => 'Please Select Event Type.'));
            $this->form_validation->set_rules('eventSession', 'Session', 'trim|required', array('required' => 'Please Select Any Session.'));
            $this->form_validation->set_rules('eventFrom', 'Event Start Date', 'trim|required', array('required' => 'Please Enter Event Start Date.'));
            $this->form_validation->set_rules('eventTo', 'Event End Date', 'trim|required', array('required' => 'Pleaes Enter Event End Date.'));
            $this->form_validation->set_rules('eventDescription', 'Description', 'trim|required', array('required' => 'Please Enter Event Description.'));
            $eventCurrentFileName = substr($this->input->post('current_event_file_path'), strripos($this->input->post('current_event_file_path'), "/") + 1);
            if ($this->form_validation->run() == FALSE) {
                $this->editEvent($iem_id);
            } else if (!sizeof($this->input->post('eventCourses'))) {
                $this->session->set_flashdata('errorMessage', "Please Select At Least One Course.");
                $this->editEvent($iem_id);
            } else if (!sizeof($this->input->post('eventDepts'))) {
                $this->session->set_flashdata('errorMessage', "Please Select At Least One Department.");
                $this->editEvent($iem_id);
            } else if (!sizeof($this->input->post('eventSubDepts'))) {
                $this->session->set_flashdata('errorMessage', "Please Select At Least One Sub-Department.");
                $this->editEvent($iem_id);
            } else {
                if (!empty($_FILES['eventFile']['name'])) {
                    $eventFileNameWithPath = "";
                    $configEventFile['upload_path'] = './assets/admin/uploads/events/';
                    $configEventFile['allowed_types'] = 'pdf|doc|docx|ppt|pptx|xls|xlsx|jpg|jpeg|png';
                    $configEventFile['max_size'] = '5120';
                    $configEventFile['file_ext_tolower'] = TRUE;
                    $configEventFile['encrypt_name'] = TRUE;
                    $this->load->library('upload', $configEventFile);
                    if (!$this->upload->do_upload('eventFile')) {
                        $this->session->set_flashdata('errorMessage', "Event File Can Not Be Uploaded As It Do Not Match With Event File Criteria. File Size 5 MB Max. & Allowed Extension: Only *.pdf,*.doc,*.docx,*.ppt,*.pptx,*.xls,*.xlsx,*.jpg,*.jpeg,*.png.");
                        $this->editEvent($iem_id);
                    } else {
                        $eventFileNameWithPath = "/assets/admin/uploads/events/" . $this->upload->data()['file_name'];
                        $eventInfo = array(
                            'iem_id' => $iem_id,
                            'iem_title' => addslashes(trim($this->input->post('eventTitle'))),
                            'iem_description' => addslashes(trim($this->input->post('eventDescription'))),
                            'iem_sub_depts' => implode(',', $this->input->post('eventSubDepts')),
                            'iem_depts' => implode(',', $this->input->post('eventDepts')),
                            'iem_courses' => implode(',', $this->input->post('eventCourses')),
                            'tsam_id' => trim($this->input->post('eventType')),
                            'session_id' => trim($this->input->post('eventSession')),
                            'iem_start_date' => date("Y-m-d 00:00:00", strtotime(str_replace('/', '-', trim($this->input->post("eventFrom"))))),
                            'iem_end_date' => date("Y-m-d 23:59:59", strtotime(str_replace('/', '-', trim($this->input->post("eventTo"))))),
                            'iem_file' => $eventFileNameWithPath,
                            'iem_added_on' => date("Y-m-d H:i:s"),
                            'iem_added_by' => $this->session->userdata("adminData")["smember_id"],
                            'iem_updated_on' => date("Y-m-d H:i:s"),
                            'iem_updated_by' => $this->session->userdata("adminData")["smember_id"]
                        );
                        if ($this->EventManagement->updateEventInfo($eventInfo)) {
                            if (file_exists("./assets/admin/uploads/events/" . $eventCurrentFileName)) {
                                unlink("./assets/admin/uploads/events/" . $eventCurrentFileName);
                            }
                            $this->session->set_flashdata('successMessage', 'Event Updated Successfully.');
                            redirect("admin/Events");
                        } else {
                            $this->session->set_flashdata('errorMessage', 'An Error Occured While Updating Event. Try Later.');
                            redirect(current_url());
                        }
                    }
                } else {
                    $eventInfo = array(
                        'iem_id' => $iem_id,
                        'iem_title' => addslashes(trim($this->input->post('eventTitle'))),
                        'iem_description' => addslashes(trim($this->input->post('eventDescription'))),
                        'iem_sub_depts' => implode(',', $this->input->post('eventSubDepts')),
                        'iem_depts' => implode(',', $this->input->post('eventDepts')),
                        'iem_courses' => implode(',', $this->input->post('eventCourses')),
                        'tsam_id' => trim($this->input->post('eventType')),
                        'session_id' => trim($this->input->post('eventSession')),
                        'iem_start_date' => date("Y-m-d 00:00:00", strtotime(str_replace('/', '-', trim($this->input->post("eventFrom"))))),
                        'iem_end_date' => date("Y-m-d 23:59:59", strtotime(str_replace('/', '-', trim($this->input->post("eventTo"))))),
                        'iem_added_on' => date("Y-m-d H:i:s"),
                        'iem_added_by' => $this->session->userdata("adminData")["smember_id"],
                        'iem_updated_on' => date("Y-m-d H:i:s"),
                        'iem_updated_by' => $this->session->userdata("adminData")["smember_id"]
                    );
                    if ($this->EventManagement->updateEventInfo($eventInfo)) {
                        $this->session->set_flashdata('successMessage', 'Event Updated Successfully.');
                        redirect("admin/Events");
                    } else {
                        $this->session->set_flashdata('errorMessage', 'An Error Occured While Updating Event. Try Later.');
                        redirect(current_url());
                    }
                }
            }
        } else {
            redirect("admin/");
        }
    }

    public function toggleEventStatus($iem_id, $toUpdateStatus) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $eventUpdateData = array(
                'iem_id' => $iem_id,
                'iem_updated_on' => date("Y-m-d H:i:s"),
                'iem_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'iem_active_status' => $toUpdateStatus
            );
            if ($this->EventManagement->updateEventInfo($eventUpdateData)) {
                $this->session->set_flashdata('successMessage', 'Event Status Updated Successfully.');
                redirect("admin/Events");
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Updating Event Status. Try Later.');
                redirect(current_url());
            }
        } else {
            redirect("admin/");
        }
    }

    public function deleteEvent($iem_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $eventUpdateData = array(
                'iem_id' => $iem_id,
                'iem_updated_on' => date("Y-m-d H:i:s"),
                'iem_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'iem_delete_status' => 'T'
            );
            if ($this->EventManagement->updateEventInfo($eventUpdateData)) {
                $this->session->set_flashdata('successMessage', 'Event Deleted Successfully.');
                redirect("admin/Events");
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Deleting Event. Try Later.');
                redirect(current_url());
            }
        } else {
            redirect("admin/");
        }
    }

    public function undoDeleteEvent($iem_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $eventUpdateData = array(
                'iem_id' => $iem_id,
                'iem_updated_on' => date("Y-m-d H:i:s"),
                'iem_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'iem_delete_status' => 'F'
            );
            if ($this->EventManagement->updateEventInfo($eventUpdateData)) {
                $this->session->set_flashdata('successMessage', 'Event Recovered Successfully.');
                redirect("admin/Events");
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Recovering Event. Try Later.');
                redirect(current_url());
            }
        } else {
            redirect("admin/");
        }
    }

}