403WebShell

403Webshell
Server IP : 43.205.77.33 / Your IP : 216.73.216.84
Web Server : Apache
System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els13.x86_64 #1 SMP Fri Nov 22 06:29:45 UTC 2024 x86_64
User : dbcollege ( 1086)
PHP Version : 8.0.30
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON
Directory : /home/dbcollege/www/cas/application/controllers/admin/
Upload File :
[ Back ]
Current File : /home/dbcollege/www/cas/application/controllers/admin/Sessions.php
<?php

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

class Sessions extends CI_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('admin/SessionManagement');
        $this->load->model('admin/CourseManagement');
        $this->load->model('admin/UCSMappingManagement');
        $this->load->model('admin/UniversityManagement');
        $this->load->model('admin/BranchManagement');
    }

    public function index() {
        if ($this->sessionvalidator->isLoggedIn() && $this->sessionvalidator->isAccessGranted()) {
            $viewData['allSessions'] = $this->SessionManagement->getAllSessions()->result();
            $this->load->view('admin/sessions', $viewData);
        } else {
            redirect("admin/");
        }
    }

    public function createSession() {
        if ($this->sessionvalidator->isLoggedIn()) {
            $allCourseInfo = array();
            $courseInfo = $this->CourseManagement->getNonDeletedCoursesWithFullInfo()->result();
            for ($i = 0; $i < sizeof($courseInfo); $i++) {
                $subCourseInfo = $this->CourseManagement->getAllSubCoursesBy($courseInfo[$i]->course_id)->result();
                $isLateralAllowed = false;
                $subCourseIdLat = "";
                $subCourseIdReg = "";
                for ($j = 0; $j < sizeof($subCourseInfo); $j++) {
                    if ($subCourseInfo[$j]->tcsm_course_type == "Lateral Entry" && $subCourseInfo[$j]->tcsm_active_status == "T") {
                        $subCourseIdLat = $subCourseInfo[$j]->tcsm_id;
                        $isLateralAllowed = true;
                    } else if ($subCourseInfo[$j]->tcsm_course_type == "Lateral Entry" && $subCourseInfo[$j]->tcsm_active_status == "F") {
                        $subCourseIdLat = $subCourseInfo[$j]->tcsm_id;
                        $isLateralAllowed = false;
                    } else {
                        $subCourseIdReg = $subCourseInfo[$j]->tcsm_id;
                        $isLateralAllowed = false;
                    }
                }
                $thisCourseInfo = array(
                    'course_id' => $courseInfo[$i]->course_id,
                    'course_duration' => $courseInfo[$i]->course_duration,
                    'course_alias' => stripslashes($courseInfo[$i]->course_name),
                    'course_lat_allowed' => $isLateralAllowed,
                    'sub_course_lat' => $subCourseIdLat,
                    'sub_course_reg' => $subCourseIdReg
                );
                array_push($allCourseInfo, $thisCourseInfo);
            }
            $viewData['allCourses'] = $allCourseInfo;
            $viewData['allUniversities'] = $this->UniversityManagement->getAllNonDeletedUniversities()->result();
            $viewData['allBranches'] = $this->BranchManagement->getAllNonDeletedBrances()->result();
            $this->load->view('admin/createSession', $viewData);
        } else {
            redirect("admin/");
        }
    }

    public function saveNewSession() {
        if ($this->sessionvalidator->isLoggedIn()) {
            $this->form_validation->set_rules('sessionName', 'Session Name', 'trim|required', array('required' => 'Session Name Can Not Be Blank.'));
            $this->form_validation->set_rules('sessionStatus', 'Session Status', 'trim|required', array('required' => 'Please Select Any Session Status.'));
            $sessionName = $this->input->post("sessionName");
            $courseSelection = $this->input->post('courses');
            $isChecked = 0;
            $isNoEntryTypeChecked = 0;
            $ucsMapArray = array();
            if (sizeof($courseSelection)) {
                foreach ($courseSelection as $selectedCoursesId) {
                    $isChecked++;
                    $latSubCourseId = $this->input->post("subCourseLatId[$selectedCoursesId]");
                    $regSubCourseId = $this->input->post("subCourseRegId[$selectedCoursesId]");
                    $selectedLatEntryType = $this->input->post("isLatAllowed[$selectedCoursesId]");
                    $selectedRegEntryType = $this->input->post("isRegAllowed[$selectedCoursesId]");
                    $courseDuration = $this->input->post("courseDuration[$selectedCoursesId]");
                    if ($selectedLatEntryType != "" || $selectedRegEntryType != "") {
                        $regAllowed = ($selectedRegEntryType == "T") ? "T" : "F";
                        $latAllowed = ($selectedLatEntryType == "T") ? "T" : "F";
                        /* For Regular */
                        array_push($ucsMapArray, array(
                            'reg_or_lat' => 'reg',
                            'ucs_rg_le_active_status' => $regAllowed,
                            'sub_course_id' => $regSubCourseId,
                            'univ_id' => $this->input->post("univApprovalBody[$selectedCoursesId]"),
                            'course_duration' => $courseDuration,
                            'session_id' => '',
                            'branch_id' => $this->input->post("branch[$selectedCoursesId]"),
                            'ucs_form_fee' => (trim($this->input->post("formFee[$selectedCoursesId]")) == "") ? "0.0" : trim($this->input->post("formFee[$selectedCoursesId]")),
                            'ucs_map_added_on' => date("Y-m-d H:i:s"),
                            'ucs_map_updated_on' => date("Y-m-d H:i:s"),
                            'ucs_map_added_by' => $this->session->userdata("adminData")["smember_id"],
                            'ucs_map_updated_by' => $this->session->userdata("adminData")["smember_id"],
                            'session_end_year' => ''
                        ));
                        /* For Lateral */
                        array_push($ucsMapArray, array(
                            'reg_or_lat' => 'lat',
                            'ucs_rg_le_active_status' => $latAllowed,
                            'sub_course_id' => $latSubCourseId,
                            'univ_id' => $this->input->post("univApprovalBody[$selectedCoursesId]"),
                            'course_duration' => $courseDuration,
                            'session_id' => '',
                            'branch_id' => $this->input->post("branch[$selectedCoursesId]"),
                            'ucs_form_fee' => (trim($this->input->post("formFee[$selectedCoursesId]")) == "") ? "0.0" : trim($this->input->post("formFee[$selectedCoursesId]")),
                            'ucs_map_added_on' => date("Y-m-d H:i:s"),
                            'ucs_map_updated_on' => date("Y-m-d H:i:s"),
                            'ucs_map_added_by' => $this->session->userdata("adminData")["smember_id"],
                            'ucs_map_updated_by' => $this->session->userdata("adminData")["smember_id"],
                            'session_end_year' => ''
                        ));
                    } else {
                        $isNoEntryTypeChecked++;
                    }
                }
            }
            $sessionQueryByName = $this->SessionManagement->getSessionInfoByName($sessionName);
            $sessionInfoByName = $sessionQueryByName->result();
            if ($this->form_validation->run() == FALSE) {
                $this->createSession();
            }
//            } else if (!$isChecked) {
//                $this->session->set_flashdata('errorMessage', "At Least One Course Should Be Selected While Creating A Session.");
//                $this->createSession();
//            } else if ($isNoEntryTypeChecked) {
//                $this->session->set_flashdata('errorMessage', "Either Of Regular Or Lateral Entry Type Should Be Selected For The Selected Course.");
//                $this->createSession();
            else if (stripos($sessionName, "-") === FALSE) {
                $this->session->set_flashdata('errorMessage', "Invalid Session Name. Please Specify Session Start & Ending Year Separated By '-'");
                $this->createSession();
            } else if (stripos($sessionName, "-") === 0) {
                $this->session->set_flashdata('errorMessage', "Invalid Session Name. Please Specify Session Start Year Before '-'");
                $this->createSession();
            } else if ((strlen(explode('-', $sessionName)[0]) != 4) || (strlen(explode('-', $sessionName)[1]) != 4) || !is_numeric(explode('-', $sessionName)[0]) || !is_numeric(explode('-', $sessionName)[1])) {
                $this->session->set_flashdata('errorMessage', "Invalid Session Name. Session Should Always Contain A Valid Numeric 4 Digit Start & End Years");
                $this->createSession();
            } else if (sizeof($sessionInfoByName)) {
                $this->session->set_flashdata('errorMessage', "Can Not Create Session. This Session Already Exits!");
                $this->createSession();
            } else {
                $newSession = array(
                    'session_name' => $sessionName,
                    'session_status' => trim($this->input->post("sessionStatus")),
                    'session_desc' => addslashes(trim($this->input->post("sessionDesc"))),
                    'session_added_by' => $this->session->userdata("adminData")["smember_id"],
                    'session_updated_by' => $this->session->userdata("adminData")["smember_id"],
                    'session_added_on' => date("Y-m-d H:i:s"),
                    'session_updated_on' => date("Y-m-d H:i:s")
                );
                $this->db->trans_start();
                if (trim($this->input->post("sessionStatus")) == "C") {
                    $allSessionUpdateData = array(
                        'session_status' => "O"
                    );
                    $this->SessionManagement->updateSessionInfo($allSessionUpdateData, true);
                }
                $session_id = $this->SessionManagement->createNewSession($newSession);
                $newMapArray = array();
                for ($i = 0; $i < sizeof($ucsMapArray); $i++) {
                    $thisMapping = $ucsMapArray[$i];
                    $thisMapping['session_id'] = $session_id;
                    if ($thisMapping['reg_or_lat'] == 'reg') {
                        $thisMapping['session_end_year'] = explode('-', $sessionName)[0] + $thisMapping['course_duration'];
                    } else {
                        $thisMapping['session_end_year'] = explode('-', $sessionName)[0] + ($thisMapping['course_duration'] - 1);
                    }
                    unset($thisMapping['reg_or_lat']);
                    unset($thisMapping['course_duration']);
                    array_push($newMapArray, $thisMapping);
                }
                if (sizeof($newMapArray)) {
                    if ($this->UCSMappingManagement->createNewUCSMappingMulti($newMapArray)) {
                        $this->db->trans_complete();
                        $this->session->set_flashdata('successMessage', 'Session Created Successfully.');
                        redirect("admin/Sessions");
                    } else {
                        $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Creating Session. Try Later.');
                        redirect("admin/Sessions");
                    }
                } else {
                    $this->db->trans_complete();
                    $this->session->set_flashdata('successMessage', 'Session Created Successfully.');
                    redirect("admin/Sessions");
                }
            }
        } else {
            redirect("admin/");
        }
    }

    public function editSession($session_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $allCourseInfo = array();
            $courseInfo = $this->CourseManagement->getNonDeletedCoursesWithFullInfo()->result();
            for ($i = 0; $i < sizeof($courseInfo); $i++) {
                $subCourseInfo = $this->CourseManagement->getAllSubCoursesBy($courseInfo[$i]->course_id)->result();
                $isLateralAllowed = false;
                $subCourseIdLat = "";
                $subCourseIdReg = "";
                $ucsMapIdLat = "";
                $ucsMapIdReg = "";
                $isLatChecked = false;
                $isRegChecked = false;
                $branch_id = "";
                $univ_id = "";
                $form_fee = "";
                $isCourseAvailable = false;
                for ($j = 0; $j < sizeof($subCourseInfo); $j++) {
                    $uscMapInfo = $this->UCSMappingManagement->getAllUCSMappingBySessionAndSubCourse($session_id, $subCourseInfo[$j]->tcsm_id)->result();
                    if ($subCourseInfo[$j]->tcsm_course_type == "Lateral Entry" && $subCourseInfo[$j]->tcsm_active_status == "T") {
                        $subCourseIdLat = $subCourseInfo[$j]->tcsm_id;
                        $isLateralAllowed = true;
                        if (sizeof($uscMapInfo)) {
                            $ucsMapIdLat = $uscMapInfo[0]->ucs_map_id;
                            $isLatChecked = ($uscMapInfo[0]->ucs_rg_le_active_status == "T") ? true : false;
                            $branch_id = $uscMapInfo[0]->branch_id;
                            $univ_id = $uscMapInfo[0]->univ_id;
                            $isCourseAvailable = ($uscMapInfo[0]->ucs_map_delete_status == "F") ? true : false;
                            $form_fee = $uscMapInfo[0]->ucs_form_fee;
                        }
                    } else if ($subCourseInfo[$j]->tcsm_course_type == "Lateral Entry" && $subCourseInfo[$j]->tcsm_active_status == "F") {
                        $subCourseIdLat = $subCourseInfo[$j]->tcsm_id;
                        $isLateralAllowed = false;
                        if (sizeof($uscMapInfo)) {
                            $ucsMapIdLat = $uscMapInfo[0]->ucs_map_id;
                            $isLatChecked = ($uscMapInfo[0]->ucs_rg_le_active_status == "T") ? true : false;
                            $branch_id = $uscMapInfo[0]->branch_id;
                            $univ_id = $uscMapInfo[0]->univ_id;
                            $isCourseAvailable = ($uscMapInfo[0]->ucs_map_delete_status == "F") ? true : false;
                            $form_fee = $uscMapInfo[0]->ucs_form_fee;
                        }
                    } else {
                        $subCourseIdReg = $subCourseInfo[$j]->tcsm_id;
                        $isLateralAllowed = false;
                        if (sizeof($uscMapInfo)) {
                            $ucsMapIdReg = $uscMapInfo[0]->ucs_map_id;
                            $isRegChecked = ($uscMapInfo[0]->ucs_rg_le_active_status == "T") ? true : false;
                            $branch_id = $uscMapInfo[0]->branch_id;
                            $univ_id = $uscMapInfo[0]->univ_id;
                            $isCourseAvailable = ($uscMapInfo[0]->ucs_map_delete_status == "F") ? true : false;
                            $form_fee = $uscMapInfo[0]->ucs_form_fee;
                        }
                    }
                }
                $thisCourseInfo = array(
                    'session_id' => $session_id,
                    'course_id' => $courseInfo[$i]->course_id,
                    'course_duration' => $courseInfo[$i]->course_duration,
                    'course_alias' => stripslashes($courseInfo[$i]->course_name),
                    'course_lat_allowed' => $isLateralAllowed,
                    'sub_course_lat' => $subCourseIdLat,
                    'sub_course_reg' => $subCourseIdReg,
                    'ucs_map_id_lat' => $ucsMapIdLat,
                    'ucs_map_id_reg' => $ucsMapIdReg,
                    'is_lat_checked' => $isLatChecked,
                    'is_reg_checked' => $isRegChecked,
                    'branch_id' => $branch_id,
                    'univ_id' => $univ_id,
                    'is_course_available' => $isCourseAvailable,
                    'form_fee' => $form_fee
                );
                array_push($allCourseInfo, $thisCourseInfo);
            }
            $viewData['allCourses'] = $allCourseInfo;
            $viewData['allUniversities'] = $this->UniversityManagement->getAllNonDeletedUniversities()->result();
            $viewData['allBranches'] = $this->BranchManagement->getAllNonDeletedBrances()->result();
            $viewData['sessionInfo'] = $this->SessionManagement->getSessionInfoBy($session_id)->result()[0];
            $this->load->view('admin/editSession', $viewData);
        } else {
            redirect("admin/");
        }
    }

    public function updateSession() {
        if ($this->sessionvalidator->isLoggedIn()) {
            $this->form_validation->set_rules('sessionName', 'Session Name', 'trim|required', array('required' => 'Session Name Can Not Be Blank.'));
            $this->form_validation->set_rules('sessionStatus', 'Session Status', 'trim|required', array('required' => 'Please Select Any Session Status.'));
            $sessionId = $this->input->post("sessionId");
            $sessionName = $this->input->post("sessionName");
            $courseSelection = $this->input->post('courses');
            $isChecked = 0;
            $isNoEntryTypeChecked = 0;
            $ucsMapArrayUpdate = array();
            $ucsMapArrayInsert = array();
            if (sizeof($courseSelection)) {
                foreach ($courseSelection as $selectedCoursesId) {
                    $isChecked++;
                    $latSubCourseId = $this->input->post("subCourseLatId[$selectedCoursesId]");
                    $regSubCourseId = $this->input->post("subCourseRegId[$selectedCoursesId]");
                    $selectedLatEntryType = $this->input->post("isLatAllowed[$selectedCoursesId]");
                    $selectedRegEntryType = $this->input->post("isRegAllowed[$selectedCoursesId]");
                    $selectedLatUCSMapId = $this->input->post("ucsMapIdLat[$selectedCoursesId]");
                    $selectedRegUCSMapId = $this->input->post("ucsMapIdReg[$selectedCoursesId]");
                    $courseDuration = $this->input->post("courseDuration[$selectedCoursesId]");
                    if ($selectedLatEntryType != "" || $selectedRegEntryType != "") {
                        $regAllowed = ($selectedRegEntryType == "T") ? "T" : "F";
                        $latAllowed = ($selectedLatEntryType == "T") ? "T" : "F";
                        if ($selectedRegUCSMapId && $selectedLatUCSMapId) { /* When Some Modification Is Being Done With Already Existing Course */
                            /* For Regular */
                            array_push($ucsMapArrayUpdate, array(
                                'ucs_map_id' => $selectedRegUCSMapId,
                                'ucs_map_delete_status' => 'F',
                                'reg_or_lat' => 'reg',
                                'ucs_rg_le_active_status' => $regAllowed,
                                'sub_course_id' => $regSubCourseId,
                                'univ_id' => $this->input->post("univApprovalBody[$selectedCoursesId]"),
                                'course_duration' => $courseDuration,
                                'session_id' => $sessionId,
                                'branch_id' => $this->input->post("branch[$selectedCoursesId]"),
                                'ucs_form_fee' => (trim($this->input->post("formFee[$selectedCoursesId]")) == "") ? "0.0" : trim($this->input->post("formFee[$selectedCoursesId]")),
                                'ucs_map_updated_on' => date("Y-m-d H:i:s"),
                                'ucs_map_updated_by' => $this->session->userdata("adminData")["smember_id"],
                                'session_end_year' => ''
                            ));

                            /* For Lateral */
                            array_push($ucsMapArrayUpdate, array(
                                'ucs_map_id' => $selectedLatUCSMapId,
                                'ucs_map_delete_status' => 'F',
                                'reg_or_lat' => 'lat',
                                'ucs_rg_le_active_status' => $latAllowed,
                                'sub_course_id' => $latSubCourseId,
                                'univ_id' => $this->input->post("univApprovalBody[$selectedCoursesId]"),
                                'course_duration' => $courseDuration,
                                'session_id' => $sessionId,
                                'branch_id' => $this->input->post("branch[$selectedCoursesId]"),
                                'ucs_form_fee' => (trim($this->input->post("formFee[$selectedCoursesId]")) == "") ? "0.0" : trim($this->input->post("formFee[$selectedCoursesId]")),
                                'ucs_map_updated_on' => date("Y-m-d H:i:s"),
                                'ucs_map_updated_by' => $this->session->userdata("adminData")["smember_id"],
                                'session_end_year' => ''
                            ));
                        } else { /* When New Course Is Selected */
                            /* For Regular */
                            array_push($ucsMapArrayInsert, array(
                                'reg_or_lat' => 'reg',
                                'ucs_rg_le_active_status' => $regAllowed,
                                'sub_course_id' => $regSubCourseId,
                                'univ_id' => $this->input->post("univApprovalBody[$selectedCoursesId]"),
                                'course_duration' => $courseDuration,
                                'session_id' => $sessionId,
                                'branch_id' => $this->input->post("branch[$selectedCoursesId]"),
                                'ucs_form_fee' => (trim($this->input->post("formFee[$selectedCoursesId]")) == "") ? "0.0" : trim($this->input->post("formFee[$selectedCoursesId]")),
                                'ucs_map_added_on' => date("Y-m-d H:i:s"),
                                'ucs_map_updated_on' => date("Y-m-d H:i:s"),
                                'ucs_map_added_by' => $this->session->userdata("adminData")["smember_id"],
                                'ucs_map_updated_by' => $this->session->userdata("adminData")["smember_id"],
                                'session_end_year' => ''
                            ));

                            /* For Lateral */
                            array_push($ucsMapArrayInsert, array(
                                'reg_or_lat' => 'lat',
                                'ucs_rg_le_active_status' => $latAllowed,
                                'sub_course_id' => $latSubCourseId,
                                'univ_id' => $this->input->post("univApprovalBody[$selectedCoursesId]"),
                                'course_duration' => $courseDuration,
                                'session_id' => $sessionId,
                                'branch_id' => $this->input->post("branch[$selectedCoursesId]"),
                                'ucs_form_fee' => (trim($this->input->post("formFee[$selectedCoursesId]")) == "") ? "0.0" : trim($this->input->post("formFee[$selectedCoursesId]")),
                                'ucs_map_added_on' => date("Y-m-d H:i:s"),
                                'ucs_map_updated_on' => date("Y-m-d H:i:s"),
                                'ucs_map_added_by' => $this->session->userdata("adminData")["smember_id"],
                                'ucs_map_updated_by' => $this->session->userdata("adminData")["smember_id"],
                                'session_end_year' => ''
                            ));
                        }
                    } else {
                        $isNoEntryTypeChecked++;
                    }
                }
            }
            if ($this->form_validation->run() == FALSE) {
                $this->editSession($sessionId);
            }
//            } else if (!$isChecked) {
//                $this->session->set_flashdata('errorMessage', "At Least One Course Should Be Selected While Creating A Session.");
//                $this->editSession($sessionId);
//            } else if ($isNoEntryTypeChecked) {
//                $this->session->set_flashdata('errorMessage', "Either Of Regular Or Lateral Entry Type Should Be Selected For The Selected Course.");
//                $this->editSession($sessionId);
            else if (stripos($sessionName, "-") === FALSE) {
                $this->session->set_flashdata('errorMessage', "Invalid Session Name. Please Specify Session Start & Ending Year Separated By '-'");
                $this->editSession($sessionId);
            } else if (stripos($sessionName, "-") === 0) {
                $this->session->set_flashdata('errorMessage', "Invalid Session Name. Please Specify Session Start Year Before '-'");
                $this->editSession($sessionId);
            } else if ((strlen(explode('-', $sessionName)[0]) != 4) || (strlen(explode('-', $sessionName)[1]) != 4) || !is_numeric(explode('-', $sessionName)[0]) || !is_numeric(explode('-', $sessionName)[1])) {
                $this->session->set_flashdata('errorMessage', "Invalid Session Name. Session Should Always Contain A Valid Numeric 4 Digit Start & End Years");
                $this->editSession($sessionId);
            } else if (!$this->SessionManagement->isSessionNameSafeUpdate($sessionId, trim($sessionName))) {
                $this->session->set_flashdata('errorMessage', "This Session (" . $sessionName . ") Already Exits! Please Try With Different Name.");
                $this->editSession($sessionId);
            } else {
                $sessionUpdateInfo = array(
                    'session_id' => $sessionId,
                    'session_name' => $sessionName,
                    'session_status' => trim($this->input->post("sessionStatus")),
                    'session_desc' => $this->input->post("sessionDesc"),
                    'session_updated_by' => $this->session->userdata("adminData")["smember_id"],
                    'session_updated_on' => date("Y-m-d H:i:s")
                );
                $this->db->trans_start();
                if (trim($this->input->post("sessionStatus")) == "C") {
                    $allSessionUpdateData = array(
                        'session_status' => "O"
                    );
                    $this->SessionManagement->updateSessionInfo($allSessionUpdateData, true);
                }
                if ($this->SessionManagement->updateSessionInfo($sessionUpdateInfo, false)) {
                    /* Setting All UCS Map Entry To Deleted At Once */
                    $allUCSMapUpdateData = array(
                        'session_id' => $sessionId,
                        'ucs_map_delete_status' => "T"
                    );
                    $this->UCSMappingManagement->updateUCSMappingEntry($allUCSMapUpdateData, true);
                    /* Setting All UCS Map Entry To Deleted At Once */
                    /* Creating Update Array For Old Courses */
                    $oldMapUpdateArray = array();
                    for ($i = 0; $i < sizeof($ucsMapArrayUpdate); $i++) {
                        $thisMapping = $ucsMapArrayUpdate[$i];
                        if ($thisMapping['reg_or_lat'] == 'reg') {
                            $thisMapping['session_end_year'] = explode('-', $sessionName)[0] + $thisMapping['course_duration'];
                        } else {
                            $thisMapping['session_end_year'] = explode('-', $sessionName)[0] + ($thisMapping['course_duration'] - 1);
                        }
                        unset($thisMapping['reg_or_lat']);
                        unset($thisMapping['course_duration']);
                        array_push($oldMapUpdateArray, $thisMapping);
                    }
                    /* Creating Update Array For Old Courses */
                    /* Creating Insert Array For Newly Selected Courses */
                    $newMapInsertArray = array();
                    for ($i = 0; $i < sizeof($ucsMapArrayInsert); $i++) {
                        $thisMapping = $ucsMapArrayInsert[$i];
                        if ($thisMapping['reg_or_lat'] == 'reg') {
                            $thisMapping['session_end_year'] = explode('-', $sessionName)[0] + $thisMapping['course_duration'];
                        } else {
                            $thisMapping['session_end_year'] = explode('-', $sessionName)[0] + ($thisMapping['course_duration'] - 1);
                        }
                        unset($thisMapping['reg_or_lat']);
                        unset($thisMapping['course_duration']);
                        array_push($newMapInsertArray, $thisMapping);
                    }
                    /* Creating Insert Array For Newly Selected Courses */
                    if (sizeof($newMapInsertArray) || sizeof($oldMapUpdateArray)) {
                        if (sizeof($newMapInsertArray)) {
                            if ($this->UCSMappingManagement->createNewUCSMappingMulti($newMapInsertArray)) {
                                $this->db->trans_complete();
                                $this->session->set_flashdata('successMessage', 'Sessions Updated Successfully.');
                                redirect("admin/Sessions");
                            } else {
                                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Updating Session. Try Later.');
                                redirect(current_url());
                            }
                        }
                        if (sizeof($oldMapUpdateArray)) {
                            if ($this->UCSMappingManagement->updateUCSMappingMulti($oldMapUpdateArray)) {
                                $this->db->trans_complete();
                                $this->session->set_flashdata('successMessage', 'Sessions Updated Successfully.');
                                redirect("admin/Sessions");
                            } else {
                                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Updating Session. Try Later.');
                                redirect(current_url());
                            }
                        }
                    } else {
                        $this->db->trans_complete();
                        $this->session->set_flashdata('successMessage', 'Sessions Updated Successfully.');
                        redirect("admin/Sessions");
                    }
                } else {
                    $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Updating Session. Try Later.');
                    redirect(current_url());
                }
            }
        } else {
            redirect("admin/");
        }
    }

    public function toggleSessionStatus($session_id, $toUpdateStatus) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $sessionUpdateData = array(
                'session_id' => $session_id,
                'session_updated_on' => date("Y-m-d H:i:s"),
                'session_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'session_active_status' => $toUpdateStatus
            );
            if ($this->SessionManagement->updateSessionInfo($sessionUpdateData)) {
                $this->session->set_flashdata('successMessage', 'Sessions Status Updated Successfully.');
                redirect("admin/Sessions");
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Updating Sessions Status. Try Later.');
                redirect("admin/Sessions");
            }
        } else {
            redirect("admin/");
        }
    }

    public function markAsCurrentSession($session_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $allSessionUpdateData = array(
                'session_status' => "O"
            );
            $thisSessionUpdateData = array(
                'session_id' => $session_id,
                'session_updated_on' => date("Y-m-d H:i:s"),
                'session_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'session_status' => "C"
            );
            $this->db->trans_start();
            if ($this->SessionManagement->updateSessionInfo($allSessionUpdateData, true)) {
                if ($this->SessionManagement->updateSessionInfo($thisSessionUpdateData, false)) {
                    $this->db->trans_complete();
                    $this->session->set_flashdata('successMessage', 'Sessions Set As Current Successfully.');
                    redirect("admin/Sessions");
                } else {
                    $this->session->set_flashdata('successMessage', 'Some Error Occurred While Setting Sessions As Current. Try Later.');
                    redirect("admin/Sessions");
                }
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Setting Sessions As Current. Try Later.');
                redirect("admin/Sessions");
            }
        } else {
            redirect("admin/");
        }
    }

    public function deleteSession($session_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $sessionUpdateData = array(
                'session_id' => $session_id,
                'session_updated_on' => date("Y-m-d H:i:s"),
                'session_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'session_delete_status' => 'T'
            );
            if ($this->SessionManagement->updateSessionInfo($sessionUpdateData)) {
                $this->session->set_flashdata('successMessage', 'Session Deleted Successfully.');
                redirect("admin/Sessions");
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Deleting Session. Try Later.');
                redirect("admin/Sessions");
            }
        } else {
            redirect("admin/");
        }
    }

    public function undoDeleteSession($session_id) {
        if ($this->sessionvalidator->isLoggedIn()) {
            $sessionUpdateData = array(
                'session_id' => $session_id,
                'session_updated_on' => date("Y-m-d H:i:s"),
                'session_updated_by' => $this->session->userdata("adminData")["smember_id"],
                'session_delete_status' => 'F'
            );
            if ($this->SessionManagement->updateSessionInfo($sessionUpdateData)) {
                $this->session->set_flashdata('successMessage', 'Session Recovered Successfully.');
                redirect("admin/Sessions");
            } else {
                $this->session->set_flashdata('errorMessage', 'Some Error Occurred While Recovering Session. Try Later.');
                redirect("admin/Sessions");
            }
        } else {
            redirect("admin/");
        }
    }

    public function getSessionByCourseAndBranch() {
        $branch_id = $_POST['branch_id'];
        $course_id = $_POST['course_id'];
        $query = $this->UCSMappingManagement->getAllSessionsByCourseAndBranch($branch_id, $course_id);
        $allSessionsList = $query->result();
        if (sizeof($allSessionsList)) {
            $options = "<option value=''>Select Session</option>";
            for ($i = 0; $i < (sizeof($allSessionsList)); $i++) {
                $options .= "<option value=" . $allSessionsList[$i]->session_id . ">" . stripslashes($allSessionsList[$i]->session_name) . "</option>";
            }
            $responseData = array(
                'csrfName' => $this->security->get_csrf_token_name(),
                'csrfHash' => $this->security->get_csrf_hash(),
                'session_List' => $options
            );
        } else {
            $options = "<option value=''>No Sessions Available In This Course</option>";
            $responseData = array(
                'csrfName' => $this->security->get_csrf_token_name(),
                'csrfHash' => $this->security->get_csrf_hash(),
                'session_List' => $options
            );
        }
        echo json_encode($responseData);
    }

    public function getSessionByCourseAndBranchSelected() {
        $session_id = $_POST['session_id'];
        $branch_id = $_POST['branch_id'];
        $course_id = $_POST['course_id'];
        $query = $this->UCSMappingManagement->getAllSessionsByCourseAndBranch($branch_id, $course_id);
        $allSessionsList = $query->result();
        if (sizeof($allSessionsList)) {
            $options = "<option value=''>Select Session</option>";
            for ($i = 0; $i < (sizeof($allSessionsList)); $i++) {
                $selected = ($session_id == $allSessionsList[$i]->session_id) ? "selected" : "";
                $options .= "<option value=" . $allSessionsList[$i]->session_id . " " . $selected . ">" . stripslashes($allSessionsList[$i]->session_name) . "</option>";
            }
            $responseData = array(
                'csrfName' => $this->security->get_csrf_token_name(),
                'csrfHash' => $this->security->get_csrf_hash(),
                'session_List' => $options
            );
        } else {
            $options = "<option value=''>No Sessions Available In This Course</option>";
            $responseData = array(
                'csrfName' => $this->security->get_csrf_token_name(),
                'csrfHash' => $this->security->get_csrf_hash(),
                'session_List' => $options
            );
        }
        echo json_encode($responseData);
    }

}
Youez - 2016 - github.com/yon3zu
LinuXploit