1#@!#!123s

: / home / ksclnmuac / public_html / cas / application / models / admin /
Filename : TaskAndQuizManagement.php
back
<?php

/**
 * Model For Handling All DB Operations Related To Tasks, Assignments & Quizzes
 *
 * @author Softpro India Pvt. Ltd.
 */
defined('BASEPATH') OR exit('No direct script access allowed');

class TaskAndQuizManagement extends CI_Model {

    function createNewTopic(array $newTopicInfo) {
        $this->db->insert('subject_topics_mst', $newTopicInfo);
        return $this->db->insert_id();
    }

    function getAllSubjectTopics() {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('subject_topics_mst STM');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'STM.stm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'STM.stm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->order_by("STM.stm_updated_on", "desc");
        return $this->db->get();
    }

    function getTopicInfoBy($topic_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('subject_topics_mst STM');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'STM.stm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'STM.stm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("STM.stm_id", $topic_id);
        return $this->db->get();
    }

    function getTopicInfoByName($topic_name) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('subject_topics_mst STM');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'STM.stm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'STM.stm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("STM.stm_name", $topic_name);
        return $this->db->get();
    }

    function getAllNonDeletedActiveSubjectTopicsBy($sm_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('subject_topics_mst STM');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'STM.stm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'STM.stm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("STM.stm_active_status", "T");
        $this->db->where("STM.stm_delete_status", "F");
        $this->db->where("STM.sm_id", $sm_id);
        $this->db->order_by("STM.stm_updated_on", "desc");
        return $this->db->get();
    }

    function isTopicNameSafeUpdate($topic_id, $topic_name) {
        $this->db->select("*");
        $this->db->from('subject_topics_mst');
        $this->db->where('stm_name', $topic_name);
        $this->db->where('stm_id != ' . $topic_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return FALSE;
        } else {
            return TRUE;
        }
    }

    function updateTopicInfo(array $topicUpdatedInfo) {
        $this->db->where('stm_id', $topicUpdatedInfo['stm_id']);
        return $this->db->update('subject_topics_mst', $topicUpdatedInfo);
    }

    /* Functions For Group Questions */

    function createNewQuestionGroup(array $newQuestionGroup) {
        $this->db->insert('question_group', $newQuestionGroup);
        return $this->db->insert_id();
    }

    function getGroupQuestionInfoBy($qg_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('question_group QG');
        $this->db->join('question_bank QB', 'QG.qg_id = QB.qg_id');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'QG.qg_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'QG.qg_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("QG.qg_id", $qg_id);
        return $this->db->get();
    }

    function getAllGroupQuestionsOfUser($smember_id, $question_type, array $topic_ids = array(), $subject_id = '') {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('question_bank QB');
        $this->db->join('question_group QG', 'QB.qg_id = QG.qg_id');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'QG.qg_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'QG.qg_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("QB.qb_ques_type_flag", $question_type);
        $this->db->where("QG.qg_delete_status", "F");
        $this->db->where("QG.qg_added_by", $smember_id);
        if (sizeof($topic_ids)) {
            $this->db->where_in("QB.stm_id", $topic_ids);
        }
        if ($subject_id != '') {
            $this->db->where("SM.sm_id", $subject_id);
        }
        $this->db->where("QB.qg_id IS NOT NULL");
        $this->db->order_by("QG.qg_added_on", "desc");
        return $this->db->get();
    }

    function getAllGroupQuestionInfoBy($qg_id, $question_type) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('question_bank QB');
        $this->db->join('question_group QG', 'QB.qg_id = QG.qg_id');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'SQG.qg_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'SQG.qg_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("QB.qb_ques_type_flag", $question_type);
        $this->db->where("QG.qg_id", $qg_id);
        return $this->db->get();
    }

    function getModelExamPaperGroupQuestionsBy($mepm_id) {
        $this->db->select("*");
        $this->db->from('model_exam_paper_ques_map MEPQM');
        $this->db->join('question_bank QB', 'MEPQM.qb_id = QB.qb_id');
        $this->db->join('question_group QG', 'QB.qg_id = QG.qg_id');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->where("MEPQM.mepm_id", $mepm_id);
        $this->db->where("QB.qg_id IS NOT NULL");
        $this->db->order_by("QB.qg_id");
        return $this->db->get();
    }

    function updateGroupQuestionInfo(array $groupQuestionUpdatedInfo) {
        $this->db->where('qg_id', $groupQuestionUpdatedInfo['qg_id']);
        return $this->db->update('question_group', $groupQuestionUpdatedInfo);
    }

    /* Functions For General Questions */

    function createNewGeneralQuestion(array $newQuestionInfo) {
        $this->db->insert('question_bank', $newQuestionInfo);
        return $this->db->insert_id();
    }

    function createNewGeneralQuestionsMulti(array $newQuestionInfo) {
        $this->db->insert_batch('question_bank', $newQuestionInfo);
        return $this->db->insert_id();
    }

    function getAllGeneralQuestionsOfUser($smember_id, $question_type, array $topic_ids = array(), $subject_id = '') {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('question_bank QB');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'QB.qb_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'QB.qb_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("QB.qb_ques_type_flag", $question_type);
        $this->db->where("QB.qb_delete_status", "F");
        $this->db->where("QB.qb_added_by", $smember_id);
        if (sizeof($topic_ids)) {
            $this->db->where_in("QB.stm_id", $topic_ids);
        }
        if ($subject_id != '') {
            $this->db->where("SM.sm_id", $subject_id);
        }
        $this->db->where("(QB.qg_id IS NULL OR QB.qg_id = '')");
        $this->db->order_by("QB.qb_added_on", "desc");
        return $this->db->get();
    }

    function getGeneralQuestionInfoBy($qb_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('question_bank QB');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'QB.qb_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'QB.qb_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("QB.qb_id", $qb_id);
        return $this->db->get();
    }

    function getModelExamPaperGeneralQuestionsBy($mepm_id) {
        $this->db->select("*");
        $this->db->from('model_exam_paper_ques_map MEPQM');
        $this->db->join('question_bank QB', 'MEPQM.qb_id = QB.qb_id');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->where("MEPQM.mepm_id", $mepm_id);
        $this->db->where("(QB.qg_id IS NULL OR QB.qg_id = '')");
        return $this->db->get();
    }

    function deleteQuestionsBy($qg_id) {
        $this->db->where("qg_id", $qg_id);
        $this->db->delete("question_bank");
    }

    function updateGenralQuestionInfo(array $generalQuestionUpdatedInfo) {
        $this->db->where('qb_id', $generalQuestionUpdatedInfo['qb_id']);
        return $this->db->update('question_bank', $generalQuestionUpdatedInfo);
    }

    /* Functions For Model Papers & Related Stuffs */

    function createNewModelPaper(array $newModelPaperInfo) {
        $this->db->insert('model_exam_paper_mst', $newModelPaperInfo);
        return $this->db->insert_id();
    }

    function createNewModelPaperQuestionMappingMulti(array $newModelPaperQuestionMappingInfo) {
        $this->db->insert_batch('model_exam_paper_ques_map', $newModelPaperQuestionMappingInfo);
        return $this->db->insert_id();
    }

    function getModelExamPaperInfoBy($mepm_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_mst MEPM');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPM.mepm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPM.mepm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPM.mepm_id", $mepm_id);
        return $this->db->get();
    }

    function getAllModelExamPapersOfUser($smember_id, $model_paper_type) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_mst MEPM');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPM.mepm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPM.mepm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPM.mepm_type", $model_paper_type);
        $this->db->where("MEPM.mepm_delete_status", "F");
        $this->db->where("MEPM.mepm_added_by", $smember_id);
        $this->db->order_by("MEPM.mepm_added_on", "desc");
        return $this->db->get();
    }

    function getAllModelExamPapersOfUserBySubject($smember_id, $subject) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_mst MEPM');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPM.mepm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPM.mepm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("SM.sm_id", $subject);
        $this->db->where("MEPM.mepm_delete_status", "F");
        $this->db->where("MEPM.mepm_added_by", $smember_id);
        $this->db->order_by("MEPM.mepm_added_on", "desc");
        return $this->db->get();
    }

    function updateModelExamPaperInfo(array $modelPaperUpdatedInfo) {
        $this->db->where('mepm_id', $modelPaperUpdatedInfo['mepm_id']);
        return $this->db->update('model_exam_paper_mst', $modelPaperUpdatedInfo);
    }

    /* Functions For Model Paper Scheduling & Related Stuffs */

    function createNewModelPaperSchedule(array $newModelPaperScheduleInfo) {
        $this->db->insert('model_exam_paper_schedule', $newModelPaperScheduleInfo);
        return $this->db->insert_id();
    }

    function getAllSchedulesOfModelPaperBy($mepm_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_schedule MEPSCH');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPSCH.mepm_id = MEPM.mepm_id');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPSCH.mepsch_scheduled_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPSCH.mepsch_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPSCH.mepm_id", $mepm_id);
        $this->db->where("MEPSCH.mepsch_delete_status", "F");
        $this->db->order_by("MEPSCH.mepsch_schedule_on", "desc");
        return $this->db->get();
    }

    function getModelPaperScheduleInfoBy($mepsch_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_schedule MEPSCH');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPSCH.mepm_id = MEPM.mepm_id');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPSCH.mepsch_scheduled_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPSCH.mepsch_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPSCH.mepsch_id", $mepsch_id);
        $this->db->where("MEPSCH.mepsch_delete_status", "F");
        $this->db->order_by("MEPSCH.mepsch_schedule_on", "desc");
        return $this->db->get();
    }

    function updateModelExamPaperScheduleInfo(array $modelPaperScheduleUpdatedInfo) {
        $this->db->where('mepsch_id', $modelPaperScheduleUpdatedInfo['mepsch_id']);
        return $this->db->update('model_exam_paper_schedule', $modelPaperScheduleUpdatedInfo);
    }

    /* Functions For Student Model Papers & Related Stuffs */

    function createNewModelPaperStudentAllotmentMulti(array $newModelPaperStudentAllotInfo) {
        $this->db->insert_batch('model_exam_paper_student_allot', $newModelPaperStudentAllotInfo);
        return $this->db->insert_id();
    }

    function getAllottedModelPapersByStudent($tspi_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_student_allot MEPSA');
        $this->db->join('model_exam_paper_schedule MEPSCH', 'MEPSA.mepsch_id = MEPSCH.mepsch_id');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPSA.mepm_id = MEPM.mepm_id');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPSCH.mepsch_scheduled_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPSCH.mepsch_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPSCH.mepsch_active_status", "T");
        $this->db->where("MEPSCH.mepsch_delete_status", "F");
        $this->db->where("MEPSA.tspi_id", $tspi_id);
        $this->db->order_by("MEPSCH.mepsch_schedule_on", "desc");
        return $this->db->get();
    }

    function getAllottedModelPaperInfoBy($mepm_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_student_allot MEPSA');
        $this->db->join('model_exam_paper_schedule MEPSCH', 'MEPSA.mepsch_id = MEPSCH.mepsch_id');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPSA.mepm_id = MEPM.mepm_id');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPM.mepm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPM.mepm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPM.mepm_active_status", "T");
        $this->db->where("MEPM.mepm_delete_status", "F");
        $this->db->where("MEPSA.mepm_id", $mepm_id);
        $this->db->order_by("MEPSCH.mepsch_schedule_on", "desc");
        return $this->db->get();
    }

    function getAllottedModelPapersBySchedule($mepsch_id, $mepm_id = '', $tspi_id = '') {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('model_exam_paper_student_allot MEPSA');
        $this->db->join('model_exam_paper_schedule MEPSCH', 'MEPSA.mepsch_id = MEPSCH.mepsch_id');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPSA.mepm_id = MEPM.mepm_id');
        $this->db->join('subject_mst SM', 'MEPM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'MEPSCH.mepsch_scheduled_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'MEPSCH.mepsch_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("MEPSCH.mepsch_id", $mepsch_id);
        if (trim($mepm_id) != "") {
            $this->db->where("MEPSA.mepm_id", $mepm_id);
        }
        if (trim($tspi_id) != "") {
            $this->db->where("MEPSA.tspi_id", $tspi_id);
        }
        return $this->db->get();
    }

    function deleteModelExamPaperStudentAllotment($mepsch_id) {
        $this->db->where("mepsch_id", $mepsch_id);
        $this->db->delete("model_exam_paper_student_allot");
    }

    /* Functions For Student's Model Paper Attempts And Related Stuffs */

    function createNewStudentAttempt(array $newStudentModelPaperAttemptInfo) {
        $this->db->insert('model_exam_paper_student_attempt', $newStudentModelPaperAttemptInfo);
        return $this->db->insert_id();
    }

    function createNewStudentResponse(array $newStudentModelPaperResponseInfo) {
        $this->db->insert_batch('model_exam_paper_response_mst', $newStudentModelPaperResponseInfo);
        return $this->db->insert_id();
    }

    function getModelPaperAttemptByStudent($tspi_id, $mepm_id) {
        $this->db->select("*");
        $this->db->from('model_exam_paper_student_attempt MEPSAT');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPSAT.mepm_id = MEPM.mepm_id');
        $this->db->where("MEPSAT.tspi_id", $tspi_id);
        $this->db->where("MEPSAT.mepm_id", $mepm_id);
        return $this->db->get();
    }

    function getModelPaperAttemptResponseByStudent($tspi_id, $mepm_id) {
        $this->db->select("*");
        $this->db->from('model_exam_paper_response_mst MEPRM');
        $this->db->join('model_exam_paper_ques_map MEPQM', 'MEPRM.mepqm_id = MEPQM.mepqm_id');
        $this->db->join('model_exam_paper_mst MEPM', 'MEPRM.mepm_id = MEPM.mepm_id');
        $this->db->join('question_bank QB', 'MEPRM.qb_id = QB.qb_id');
        $this->db->join('question_group QG', 'QB.qg_id = QG.qg_id', 'left');
        $this->db->join('subject_topics_mst STM', 'QB.stm_id = STM.stm_id');
        $this->db->join('subject_mst SM', 'STM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->where("MEPRM.tspi_id", $tspi_id);
        $this->db->where("MEPRM.mepm_id", $mepm_id);
        return $this->db->get();
    }

    function updateNewStudentResponse(array $studentModelPaperResponse) {
        $this->db->where(array('tspi_id' => $studentModelPaperResponse['tspi_id'], 'qb_id' => $studentModelPaperResponse['qb_id'], 'mepm_id' => $studentModelPaperResponse['mepm_id']));
        return $this->db->update('model_exam_paper_response_mst', $studentModelPaperResponse);
    }

    function deleteModelPaperStudentAttempt($mepsch_id, $mepm_id, $tspi_id, $del_latest_only) {
        if ($del_latest_only) {
            $this->db->where("mepsat_id  = (select mepsat_id from (select max(mepsat_id) mepsat_id from model_exam_paper_student_attempt where tspi_id = " . $tspi_id . " and mepm_id = " . $mepm_id . " and mepsch_id = " . $mepsch_id . ") tt)");
            $this->db->delete("model_exam_paper_student_attempt");
        } else {
            $this->db->where("tspi_id", $tspi_id);
            $this->db->where("mepm_id", $mepm_id);
            $this->db->where("mepsch_id", $mepsch_id);
            $this->db->delete("model_exam_paper_student_attempt");
        }
    }

    function deleteModelPaperStudentResponse($mepsch_id, $mepm_id, $tspi_id) {
        $this->db->where("tspi_id", $tspi_id);
        $this->db->where("mepm_id", $mepm_id);
        $this->db->where("mepsch_id", $mepsch_id);
        $this->db->delete("model_exam_paper_response_mst");
    }

    /* Functions For E-Content Management */

    function createNewEContent(array $newEContentInfo) {
        $this->db->insert('econtent_mst', $newEContentInfo);
        return $this->db->insert_id();
    }

    function getEContentInfoBy($ecm_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('econtent_mst ECM');
        $this->db->join('tbl_session_master TSM', 'ECM.session_id = TSM.session_id');
        $this->db->join('subject_mst SM', 'ECM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'ECM.ecm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'ECM.ecm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("ECM.ecm_id", $ecm_id);
        return $this->db->get();
    }

    function getAllEContentsBy($smember_id = '', $deleteStatus = '', $titleOrDesc = '', $session = '', $subject = '', $startDate = '', $endDate = '', $rangeAppliedWith = '') {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('econtent_mst ECM');
        $this->db->join('tbl_session_master TSM', 'ECM.session_id = TSM.session_id');
        $this->db->join('subject_mst SM', 'ECM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'ECM.ecm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'ECM.ecm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("(ECM.ecm_title LIKE '%" . $titleOrDesc . "%' OR ECM.ecm_description LIKE '%" . $titleOrDesc . "%')");
        /* Staff Member Wise Filter */
        if ($smember_id != '') {
            $this->db->where("ECM.ecm_added_by", $smember_id);
        }
        /* Staff Member Wise Filter */
        /* Delete Status Wise Filter */
        if ($deleteStatus != '') {
            $this->db->where("ECM.ecm_delete_status", $deleteStatus);
        }
        /* Delete Status Wise Filter */
        /* Session Wise Filter */
        if ($session != "") {
            $this->db->where("TSM.session_id", $session);
        }
        /* Session Wise Filter */
        /* Subject Wise Filter */
        if ($subject != "") {
            $this->db->where("SM.sm_id", $subject);
        }
        /* Subject Wise Filter */
        /* Dates Combination */
        if ($startDate != '' && $endDate != '' && $rangeAppliedWith != '') {
            if ($rangeAppliedWith == "CD") {
                $this->db->where("ECM.ecm_added_on >= '" . $startDate . "' && ECM.ecm_added_on <= '" . $endDate . "'");
            } else {
                $this->db->where("ECM.ecm_updated_on >= '" . $startDate . "' && ECM.ecm_updated_on <= '" . $endDate . "'");
            }
        } else if ($startDate == '' && $endDate != '' && $rangeAppliedWith != '') {
            if ($rangeAppliedWith == "CD") {
                $this->db->where("ECM.ecm_added_on <= '" . $endDate . "'");
            } else {
                $this->db->where("ECM.ecm_updated_on <= '" . $endDate . "'");
            }
        } else if ($startDate != '' && $endDate == '' && $rangeAppliedWith != '') {
            if ($rangeAppliedWith == "CD") {
                $this->db->where("ECM.ecm_added_on >= '" . $startDate . "'");
            } else {
                $this->db->where("ECM.ecm_updated_on >= '" . $startDate . "'");
            }
        }
        /* Dates Combination */
        return $this->db->get();
    }

    function updateEContentInfo(array $eContentUpdatedInfo) {
        $this->db->where('ecm_id', $eContentUpdatedInfo['ecm_id']);
        return $this->db->update('econtent_mst', $eContentUpdatedInfo);
    }

    /* Functions For E-Content Schedules & Assignments Related Stuffs */

    function createNewEContentSchedule(array $newEContentScheduleInfo) {
        $this->db->insert('econtent_schedule_mst', $newEContentScheduleInfo);
        return $this->db->insert_id();
    }

    function createNewEContentAssignmentMulti(array $newEContentAssignmentInfo) {
        $this->db->insert_batch('econtent_student_assign', $newEContentAssignmentInfo);
        return $this->db->insert_id();
    }

    function getEContentScheduleInfoBy($ecsm_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('econtent_schedule_mst ECSM');
        $this->db->join('econtent_mst ECM', 'ECSM.ecm_id = ECM.ecm_id ');
        $this->db->join('tbl_session_master TSM', 'ECM.session_id = TSM.session_id');
        $this->db->join('subject_mst SM', 'ECM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'ECM.ecm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'ECM.ecm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("ECSM.ecsm_id", $ecsm_id);
        return $this->db->get();
    }

    function getAssignedEContentsBySchedule($ecsm_id, $ecm_id = '', $tspi_id = '') {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('econtent_student_assign ECSA');
        $this->db->join('econtent_schedule_mst ECSM', 'ECSA.ecsm_id = ECSM.ecsm_id ');
        $this->db->join('econtent_mst ECM', 'ECSM.ecm_id = ECM.ecm_id ');
        $this->db->join('tbl_session_master TSM', 'ECM.session_id = TSM.session_id');
        $this->db->join('subject_mst SM', 'ECM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'ECM.ecm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'ECM.ecm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("ECSM.ecsm_id", $ecsm_id);
        if (trim($ecm_id) != "") {
            $this->db->where("ECSM.ecm_id", $ecm_id);
        }
        if (trim($tspi_id) != "") {
            $this->db->where("ECSA.tspi_id", $tspi_id);
        }
        return $this->db->get();
    }

    function getAssignedEContentsByStudent($tspi_id) {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('econtent_student_assign ECSA');
        $this->db->join('econtent_schedule_mst ECSM', 'ECSA.ecsm_id = ECSM.ecsm_id ');
        $this->db->join('econtent_mst ECM', 'ECSM.ecm_id = ECM.ecm_id ');
        $this->db->join('tbl_session_master TSM', 'ECM.session_id = TSM.session_id');
        $this->db->join('subject_mst SM', 'ECM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'ECSM.ecsm_scheduled_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'ECSM.ecsm_scheduled_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("ECSM.ecsm_active_status", "T");
        $this->db->where("ECSM.ecsm_delete_status", "F");
        $this->db->where("ECM.ecm_active_status", "T");
        $this->db->where("ECM.ecm_delete_status", "F");
        $this->db->where("ECSA.tspi_id", $tspi_id);
        return $this->db->get();
    }

    function getAllEContentSchedulesBy($smember_id = '', $deleteStatus = '', $titleOrDesc = '', $session = '', $subject = '', $econtent = '', $startDate = '', $endDate = '') {
        $this->db->select("*,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('econtent_schedule_mst ECSM');
        $this->db->join('econtent_mst ECM', 'ECSM.ecm_id = ECM.ecm_id ');
        $this->db->join('tbl_session_master TSM', 'ECM.session_id = TSM.session_id');
        $this->db->join('subject_mst SM', 'ECM.sm_id = SM.sm_id');
        $this->db->join('tbl_course_master TCM', 'SM.course_id = TCM.course_id');
        $this->db->join('tbl_staff_members TSMA', 'ECM.ecm_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'ECM.ecm_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->where("(ECM.ecm_title LIKE '%" . $titleOrDesc . "%' OR ECM.ecm_description LIKE '%" . $titleOrDesc . "%')");
        /* Staff Member Wise Filter */
        if ($smember_id != '') {
            $this->db->where("ECM.ecm_added_by", $smember_id);
        }
        /* Staff Member Wise Filter */
        /* Schedule Delete Status Wise Filter */
        if ($deleteStatus != '') {
            $this->db->where("ECSM.ecsm_delete_status", $deleteStatus);
            $this->db->where("ECM.ecm_delete_status", $deleteStatus);
        }
        /* Schedule Delete Status Wise Filter */
        /* Session Wise Filter */
        if ($session != "") {
            $this->db->where("ECM.session_id", $session);
        }
        /* Session Wise Filter */
        /* Subject Wise Filter */
        if ($subject != "") {
            $this->db->where("ECM.sm_id", $subject);
        }
        /* Subject Wise Filter */
        /* E-Content Wise Filter */
        if ($econtent != '') {
            $this->db->where("ECSM.ecm_id", $econtent);
        }
        /* E-Content Wise Filter */
        /* Dates Combination */
        if ($startDate != '' && $endDate != '') {
            $this->db->where("ECSM.ecsm_start_date >= '" . $startDate . "' && ECSM.ecsm_end_date <= '" . $endDate . "'");
        } else if ($startDate == '' && $endDate != '') {
            $this->db->where("ECSM.ecsm_end_date <= '" . $endDate . "'");
        } else if ($startDate != '' && $endDate == '') {
            $this->db->where("ECSM.ecsm_start_date >= '" . $startDate . "'");
        }
        /* Dates Combination */
        return $this->db->get();
    }

    function updateEContentScheduleInfo(array $eContentScheduleUpdatedInfo) {
        $this->db->where('ecsm_id', $eContentScheduleUpdatedInfo['ecsm_id']);
        return $this->db->update('econtent_schedule_mst', $eContentScheduleUpdatedInfo);
    }

    function deleteEContentStudentAssignment($ecsm_id) {
        $this->db->where("ecsm_id", $ecsm_id);
        $this->db->delete("econtent_student_assign");
    }

}