|
Server IP : 172.26.0.195 / Your IP : 3.139.108.48 Web Server : Apache System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : jnclnmuac ( 1026) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/jnclnmuac/public_html/web/../grievance/application/controllers/../models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* Model Class For Handling All DB Operations Related To Courses
*
* @author Softpro India Pvt. Ltd.
*/
defined('BASEPATH') OR exit('No direct script access allowed');
class CourseManagement extends CI_Model {
function __construct() {
parent::__construct();
$this->load->database();
}
function getTotalNonDeletedCoursesOfInstitute($clg_id) {
$this->db->select("count(*) totalCourses");
$this->db->from('course_mst');
$this->db->where('clg_id', $clg_id);
$this->db->where('course_delete_status', 'F');
return $this->db->get();
}
function getNonDeletedCoursesOfInstitute($clg_id) {
$this->db->select("CM.course_id,CM.course_name,CM.course_active_status,CM.course_delete_status,CM.course_full_name,"
. "CM.course_no_of_years,CM.course_no_of_sems,CM.course_populate_flag,CM.course_added_on,CM.course_updated_on,"
. "CAUA.cau_first_name addedByCA,CAUM.cau_first_name updatedByCA");
$this->db->from('course_mst CM');
$this->db->join('college_admins_and_users CAUA', 'CM.course_added_by = CAUA.cau_id');
$this->db->join('college_admins_and_users CAUM', 'CM.course_updated_by = CAUM.cau_id');
$this->db->where('CM.clg_id', $clg_id);
$this->db->where('CM.course_delete_status', 'F');
$this->db->order_by('CM.course_added_on desc');
return $this->db->get();
}
function getNonDeletedActiveCoursesOfInstitute($clg_id){
$this->db->select("CM.course_id,CM.course_name,CM.course_active_status,CM.course_delete_status,CM.course_full_name,"
. "CM.course_no_of_years,CM.course_no_of_sems,CM.course_populate_flag,CM.course_added_on,CM.course_updated_on,"
. "CAUA.cau_first_name addedByCA,CAUM.cau_first_name updatedByCA");
$this->db->from('course_mst CM');
$this->db->join('college_admins_and_users CAUA', 'CM.course_added_by = CAUA.cau_id');
$this->db->join('college_admins_and_users CAUM', 'CM.course_updated_by = CAUM.cau_id');
$this->db->where('CM.clg_id', $clg_id);
$this->db->where('CM.course_active_status', 'T');
$this->db->where('CM.course_delete_status', 'F');
$this->db->order_by('CM.course_added_on desc');
return $this->db->get();
}
function createNewCourse(array $newCourseInfo) {
$this->db->insert('course_mst', $newCourseInfo);
return $this->db->insert_id();
}
function updateCourseInfo(array $courseUpdatedInfo) {
$this->db->where('course_id', $courseUpdatedInfo['course_id']);
return $this->db->update('course_mst', $courseUpdatedInfo);
}
function getCourseInfoById($courseId) {
$this->db->select("*");
$this->db->from('course_mst');
$this->db->where('course_id', $courseId);
return $this->db->get();
}
}