1#@!#!123s

: / home / ksclnmuac / public_html / admission / application / models / user /
Filename : StudentManagement.php
back
<?php

/**
 * Model Class For Handling All DB Operations Related To Students
 *
 * @author Softpro India Pvt. Ltd.
 */
class StudentManagement extends CI_Model {

    function getFeeDetails($tspi_id = '', $formno = '', $email = '', $mobile = '', $dob = '') {
        $this->db->select("*");
        $this->db->from('tbl_student_personal_info TSPI');
        $this->db->join("tbl_univ_course_session_mapping univ", "univ.ucs_map_id = TSPI.ucs_map_id");
        $this->db->join("tbl_course_sub_master sc", "sc.tcsm_id = univ.sub_course_id");
        $this->db->join("tbl_course_master c", "sc.course_id = c.course_id");
        $this->db->join('tbl_session_master TSM', 'univ.session_id = TSM.session_id');
        $this->db->join('transaction_mst t', 't.regno = TSPI.tspi_id');
        $this->db->join('adm_form_no AD', 'AD.regno = TSPI.tspi_id');

        if ($tspi_id != '') {
            $this->db->where("tspi.tspi_id", $tspi_id);
        }
        if ($formno != '') {
            $this->db->where("tspi.tspi_form_no", $formno);
        }
        if ($email != '') {
            $this->db->where("tspi.tspi_email", $email);
        }
        if ($mobile != '') {
            $this->db->where("tspi.tspi_mobile", $mobile);
        }
        if ($dob != '') {
            $this->db->where("tspi.tspi_dob", $dob);
        }
        $this->db->where("t.tran_details", "ADMISSION");
        $this->db->where("t.status", "T");
        return $this->db->get();
    }

    function getStudentPersonalInfoAndPhotoSignBy($tspi_id = '', $formno = '', $email = '', $mobile = '', $dob = '') {
        $this->db->select("*");
        $this->db->from('tbl_student_personal_info TSPI');
        $this->db->join("tbl_univ_course_session_mapping univ", "univ.ucs_map_id = TSPI.ucs_map_id");
        $this->db->join("tbl_course_sub_master sc", "sc.tcsm_id = univ.sub_course_id");
        $this->db->join("tbl_course_master c", "sc.course_id = c.course_id");
        $this->db->join('tbl_session_master TSM', 'univ.session_id = TSM.session_id');
        if ($tspi_id != '') {
            $this->db->where("TSPI.tspi_id", $tspi_id);
        }
        if ($formno != '') {
            $this->db->where("TSPI.tspi_form_no", $formno);
        }
        if ($email != '') {
            $this->db->where("TSPI.tspi_email", $email);
        }
        if ($mobile != '') {
            $this->db->where("TSPI.tspi_mobile", $mobile);
        }
        if ($dob != '') {
            $this->db->where("TSPI.tspi_dob", $dob);
        }
        return $this->db->get();
    }

    function getStudentContactInfoBy($tspi_id) {
        $this->db->select('TSCI.tsci_id,TSCI.tsci_perma_state,TSCI.tsci_perma_city,TSCI.tsci_perma_zipcode,TSCI.tsci_resid_state,TSCI.tsci_resid_city,TSCI.tsci_resid_zipcode,TSCI.tsci_parent_landline,'
                . 'TSCI.tsci_parent_mobile,TSCI.tsci_added_on,TSCI.tsci_added_by,TSCI.tsci_updated_on,TSCI.tsci_updated_by,TSCI.tsci_perma_address_line_one,TSCI.tsci_perma_address_line_two,TSCI.tsci_perma_address_line_three,TSCI.tsci_resid_address_line_one,'
                . 'TSCI.tsci_resid_address_line_two,TSCI.tsci_resid_address_line_three,pst.state_name as p_state_name,mst.state_name as m_state_name,pct.city_name as p_city_name,mct.city_name as m_city_name');
        $this->db->from('tbl_student_contact_info TSCI');
        $this->db->join('tbl_states_master pst', 'TSCI.tsci_perma_state=pst.state_id');
        $this->db->join('tbl_states_master mst', 'TSCI.tsci_resid_state=mst.state_id');
        $this->db->join('tbl_city_master pct', 'TSCI.tsci_perma_city=pct.city_id');
        $this->db->join('tbl_city_master mct', 'TSCI.tsci_resid_city=mct.city_id');
        $this->db->where("TSCI.tspi_id", $tspi_id);
        return $this->db->get();
    }

    function getStudentStudentEntranceExamProfExpAndExtraCurricularInfoBy($tspi_id) {
        $this->db->select('TSEVI.tsevi_id,TSEVI.tsevi_is_prof_exp,TSEVI.tsevi_no_of_years,TSEVI.tsevi_organization,'
                . 'TSEVI.tsevi_job_desc,TSEVI.tsevi_extra_activities,TSEVI.tsevi_how_know_sms,TSEVI.tsevi_entrance_through,'
                . 'TSEVI.tsevi_form_no,TSEVI.tsevi_composite_score,TSEVI.tsevi_percnt_obtained,TSEVI.tsevi_rank,'
                . 'TSEVI.tsevi_added_on,TSEVI.tsevi_updated_on,TSEVI.tsevi_added_by,'
                . 'TSEVI.tsevi_updated_by,TSEVI.tsevi_percntage');
        $this->db->from('tbl_student_entrance_info TSEVI');
        $this->db->where("TSEVI.tspi_id", $tspi_id);
        return $this->db->get();
    }

    function getStudentFamilyBackgroundInfoBy($tspi_id) {
        $this->db->select('TFBI.tfbi_id,TFBI.tfbi_relation,TFBI.tfbi_name,TFBI.tfbi_organization,'
                . 'TFBI.tfbi_designation,TFBI.tfbi_user_type_flag,TFBI.tfbi_mapping_id,TFBI.tfbi_added_on,'
                . 'TFBI.tfbi_updated_on,TFBI.tfbi_added_by,TFBI.tfbi_updated_by,rel.rel_title');
        $this->db->from('tbl_family_background_info TFBI');
        $this->db->join('tbl_relation_master rel', 'TFBI.tfbi_relation = rel.rel_id');
        $this->db->where("TFBI.tfbi_user_type_flag", "S");
        $this->db->where("TFBI.tfbi_designation != 'NA'");
        $this->db->where("TFBI.tfbi_organization != 'NA'");
        $this->db->where("TFBI.tfbi_mapping_id", $tspi_id);
        return $this->db->get();
    }

    function getStudentFatherInfoBy($tspi_id) {
        $this->db->select('TFBI.tfbi_id,TFBI.tfbi_relation,TFBI.tfbi_name,TFBI.tfbi_organization,'
                . 'TFBI.tfbi_designation,TFBI.tfbi_user_type_flag,TFBI.tfbi_mapping_id,TFBI.tfbi_added_on,'
                . 'TFBI.tfbi_updated_on,TFBI.tfbi_added_by,TFBI.tfbi_updated_by');
        $this->db->from('tbl_family_background_info TFBI');
        $this->db->join('tbl_relation_master TRM', 'TFBI.tfbi_relation = TRM.rel_id');
        $this->db->where("TFBI.tfbi_user_type_flag", "S");
        $this->db->where("TFBI.tfbi_designation", "NA");
        $this->db->where("TFBI.tfbi_organization", "NA");
        $this->db->where("TRM.rel_code", 2);
        $this->db->where("TFBI.tfbi_mapping_id", $tspi_id);
        return $this->db->get();
    }

    function getStudentHostelInfoBy($tspi_id) {
        $this->db->select('*');
        $this->db->from('tbl_student_hostel_resid_info TSHRI');
        $this->db->where("TSHRI.tspi_id", $tspi_id);
        return $this->db->get();
    }

    function getStudentFullAdmissionAndTransactionDetails($formno = '', $email = '', $mobile = '', $dob = '') {
        $this->db->select("*");
        $this->db->from('tbl_student_personal_info TSPI');
        $this->db->join("tbl_univ_course_session_mapping univ", "univ.ucs_map_id = TSPI.ucs_map_id");
        $this->db->join("tbl_course_sub_master sc", "sc.tcsm_id = univ.sub_course_id");
        $this->db->join("tbl_course_master c", "sc.course_id = c.course_id");
        $this->db->join('tbl_session_master TSM', 'univ.session_id = TSM.session_id');
        $this->db->join('transaction_mst t', 't.regno = TSPI.tspi_id');
        $this->db->join('adm_form_no AD', 'AD.regno = TSPI.tspi_id');
        if ($formno != '') {
            $this->db->where("tspi.tspi_form_no", $formno);
        }
        if ($email != '') {
            $this->db->where("tspi.tspi_email", $email);
        }
        if ($mobile != '') {
            $this->db->where("tspi.tspi_mobile", $mobile);
        }
        if ($dob != '') {
            $this->db->where("tspi.tspi_dob", $dob);
        }
        $this->db->where("t.tran_details", "ADMISSION");
        $this->db->where("t.status", "T");
        return $this->db->get();
    }

    function getPersonalDetailsByTSPIID($tspi_id) {
        $this->db->select("*");
        $this->db->from("tbl_student_personal_info");
        $this->db->where("tspi_id", $tspi_id);
        return $this->db->get();
    }

    function insertTransactionDetails(array $transactionArry) {
        $this->db->insert('transaction_mst', $transactionArry);
        return $this->db->insert_id();
    }

    function insertAdmissionForm(array $adminFormNoArry) {
        $this->db->insert('adm_form_no', $adminFormNoArry);
        return $this->db->insert_id();
    }

    function createNewStudentPersonalInfoEntry(array $newStudentPersonalInfo) {
        $this->db->insert('tbl_student_personal_info', $newStudentPersonalInfo);
        return $this->db->insert_id();
    }

    function createNewStudentContactInfoEntry(array $newStudentContactInfo) {
        $this->db->insert('tbl_student_contact_info', $newStudentContactInfo);
        return $this->db->insert_id();
    }

    function createNewStudentEntranceExamProfExpAndExtraCurricularInfoEntry(array $newStudentEntranceExamInfo) {
        $this->db->insert('tbl_student_entrance_info', $newStudentEntranceExamInfo);
        return $this->db->insert_id();
    }

    function createNewStudentHostelAndResidenceChoiceInfoEntry(array $newStudentHostelAndResidenceChoiceInfo) {
        $this->db->insert('tbl_student_hostel_resid_info', $newStudentHostelAndResidenceChoiceInfo);
        return $this->db->insert_id();
    }

    function createNewStudentEducationalQualificationInfoMulti(array $newStudentEducationalQualificationInfoBatch) {
        $this->db->insert_batch('tbl_student_edu_info', $newStudentEducationalQualificationInfoBatch);
        return $this->db->insert_id();
    }

    function createNewStudentFamilyBackgroundInfoMulti(array $newStudentEducationalFamilyBackroundInfoBatch) {
        $this->db->insert_batch('tbl_family_background_info', $newStudentEducationalFamilyBackroundInfoBatch);
        return $this->db->insert_id();
    }

    function getStudentPersonalInfoByFormNumber($formRefNumber, $strict_check) {
        $this->db->select('*');
        $this->db->from('tbl_student_personal_info TSPI');
        $this->db->join('tbl_univ_course_session_mapping TUCSM', 'TSPI.ucs_map_id = TUCSM.ucs_map_id');
        $this->db->join('tbl_session_master TSM', 'TUCSM.session_id = TSM.session_id');
        $this->db->join('tbl_course_sub_master TSCM', 'TUCSM.sub_course_id = TSCM.tcsm_id');
        $this->db->join('tbl_course_master TCM', 'TSCM.course_id = TCM.course_id');
        if ($strict_check) {
            $this->db->where('TSPI.tspi_form_no', $formRefNumber);
            $this->db->where('TSPI.tspi_reference_no', $formRefNumber);
        } else {
            $this->db->where("TSPI.tspi_form_no = '" . $formRefNumber . "' OR TSPI.tspi_reference_no = '" . $formRefNumber . "'");
        }

        return $this->db->get();
    }

    function getStudentEducationalQualificationInfo($tspi_id) {
        $this->db->select('TESI.tesi_id,TESI.tesi_exam,TESI.tesi_board,TESI.tesi_university,'
                . 'TESI.tesi_stream,TESI.tesi_passing_year,TESI.tesi_percnt,TESI.tesi_cgpa,'
                . 'TESI.tesi_division,TESI.tesi_added_on,TESI.tesi_updated_on,TESI.tesi_added_by,'
                . 'TESI.tesi_updated_by,TESI.tspi_id,TESI.tesi_max_marks_cgpa,TEM.exam_id,TEM.exam_name');
        $this->db->from('tbl_student_edu_info TESI');
        $this->db->join('tbl_exams_master TEM', 'TESI.tesi_exam = TEM.exam_id');
        $this->db->where("TESI.tspi_id", $tspi_id);
        return $this->db->get();
    }

    function getStudentMotherInfoBy($tspi_id) {
        $this->db->select('TFBI.tfbi_id,TFBI.tfbi_relation,TFBI.tfbi_name,TFBI.tfbi_organization,'
                . 'TFBI.tfbi_designation,TFBI.tfbi_user_type_flag,TFBI.tfbi_mapping_id,TFBI.tfbi_added_on,'
                . 'TFBI.tfbi_updated_on,TFBI.tfbi_added_by,TFBI.tfbi_updated_by');
        $this->db->from('tbl_family_background_info TFBI');
        $this->db->join('tbl_relation_master TRM', 'TFBI.tfbi_relation = TRM.rel_id');
        $this->db->where("TFBI.tfbi_user_type_flag", "S");
        $this->db->where("TFBI.tfbi_designation", "NA");
        $this->db->where("TFBI.tfbi_organization", "NA");
        $this->db->where("TRM.rel_code", 1);
        $this->db->where("TFBI.tfbi_mapping_id", $tspi_id);
        return $this->db->get();
    }

    /* Functions For Updating Infos */

    function updateStudentPersonalInfo(array $studentUpdatedPersonalInfo) {
        $this->db->where('tspi_id', $studentUpdatedPersonalInfo['tspi_id']);
        return $this->db->update('tbl_student_personal_info', $studentUpdatedPersonalInfo);
    }

    function updateStudentPersonalInfoMulti(array $studentUpdatedPersonalInfoBulk) {
        return $this->db->update_batch('tbl_student_personal_info', $studentUpdatedPersonalInfoBulk, 'tspi_id');
    }

    function updateStudentContactInfo(array $studentUpdatedContactInfo) {
        $this->db->where('tspi_id', $studentUpdatedContactInfo['tspi_id']);
        return $this->db->update('tbl_student_contact_info', $studentUpdatedContactInfo);
    }

    function updateStudentEntranceExamProfExpAndExtraCurricularInfo(array $studentUpdatedEntranceExamInfoInfo) {
        $this->db->where('tspi_id', $studentUpdatedEntranceExamInfoInfo['tspi_id']);
        return $this->db->update('tbl_student_entrance_info', $studentUpdatedEntranceExamInfoInfo);
    }

    function updateHostelAndResidenceInfo(array $studentUpdatedHostelAndResidenceInfo) {
        $this->db->where('tspi_id', $studentUpdatedHostelAndResidenceInfo['tspi_id']);
        return $this->db->update('tbl_student_hostel_resid_info', $studentUpdatedHostelAndResidenceInfo);
    }

    function updateFamilyBackgroundInfoMulti(array $studentFamilyBackgroundUpdateInfoBatch) {
        return $this->db->update_batch('tbl_family_background_info', $studentFamilyBackgroundUpdateInfoBatch, 'tfbi_id');
    }

    function updateStudentEducationalQualificationInfoMulti(array $studentEducationQualificationUpdateInfoBatch) {
        return $this->db->update_batch('tbl_student_edu_info', $studentEducationQualificationUpdateInfoBatch, 'tesi_id');
    }

    /* Functions For Permanent Deletion */

    function deleteStudentPersonalInfoEntry($tspi_id) {
        $this->db->where("tspi_id", $tspi_id);
        $this->db->delete("tbl_student_personal_info");
    }

    function deleteStudentContactInfoEntry($tspi_id) {
        $this->db->where("tspi_id", $tspi_id);
        $this->db->delete("tbl_student_contact_info");
    }

    function deleteStudentEntranceExamProfExpAndExtraCurricularInfoEntry($tspi_id) {
        $this->db->where("tspi_id", $tspi_id);
        $this->db->delete('tbl_student_entrance_info');
    }

    function deleteStudentHostelAndResidenceChoiceInfoEntry($tspi_id) {
        $this->db->where("tspi_id", $tspi_id);
        $this->db->delete('tbl_student_hostel_resid_info');
    }

    function deleteStudentIDProofInfoEntry($tipi_for) {
        $this->db->where("tipi_for", $tipi_for);
        $this->db->delete('tbl_id_proof_info');
    }

    function deleteStudentEducationalQualificationInfoEntry($tspi_id) {
        $this->db->where("tspi_id", $tspi_id);
        $this->db->delete('tbl_student_edu_info');
    }

    function deleteStudentEducationalQualificationInfoEntryBy($tesi_id) {
        $this->db->where("tesi_id", $tesi_id);
        $this->db->delete('tbl_student_edu_info');
    }

    function deleteStudentFamilyBackgroundInfoEntry($tfbi_mapping_id) {
        $this->db->where("tfbi_mapping_id", $tfbi_mapping_id);
        $this->db->delete('tbl_family_background_info');
        
    }

}