|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/celkcksm/ecampus.ncriptech.com/../ecampus.ncriptech.com/application/models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php defined('BASEPATH') OR exit('No direct script access allowed');
/**
*
*/
class Hostel_model extends BaseModel
{
function __constuct(){
parent::__construct();
}
public function store_hostel($data,$return_query=FALSE){
$this->table='institute_hostels';
return $this->store($data,FALSE,$return_query);
}
public function update_hostel($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_hostels';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hostel($param,$return_query=FALSE){
$this->table='institute_hostels';
return $this->remove($param,0,$return_query);
}
public function get_hostel($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_hostels';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function _get_hostels($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_hostels.*');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('hostel_inst_id',$param['inst_id']);
}
if(isset($param['column_search'])){
foreach ($param['column_search'] as $item)
{
if(isset($post['search']['value']) && $post['search']['value'])
{
if($i===0)
{
$this->_db->group_start();
$this->_db->like($item, $post['search']['value']);
}
else
{
$this->_db->or_like($item, $post['search']['value']);
}
if(count($param['column_search']) - 1 == $i)
$this->_db->group_end();
}
$i++;
}
}
if(isset($post['order']))
{
$column_order=$param['column_order'];
$this->_db->order_by($column_order[$post['order']['0']['column']], $post['order']['0']['dir']);
}
else if(isset($param['order']))
{
$order = $param['order'];
$this->_db->order_by(key($order), $order[key($order)]);
}
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_hostels');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($count==TRUE){
$query = $this->_db->get('institute_hostels');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
/*---------------Hostel fees(07-04-2022) ----------------*/
public function store_hostel_fees($data,$return_query=FALSE){
$this->table='institute_hostel_fees';
return $this->store($data,FALSE,$return_query);
}
public function update_hostel_fees($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_hostel_fees';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hostel_fees($param,$return_query=FALSE){
$this->table='institute_hostel_fees';
return $this->remove($param,0,$return_query);
}
public function get_hostel_fees($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_hostel_fees';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function __get_hostel_fees($param,$single_row=TRUE,$return_query=FALSE){
$this->_db->select('institute_hostel_fees.*,institute_hostels.hostel_name,institute_sessions.session_start_year,institute_sessions.session_end_year');
$this->_db->join('institute_hostels','institute_hostel_fees.fees_hostel_id=institute_hostels.hostel_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_hostel_fees.fees_session_id','LEFT');
$query = $this->_db->get('institute_hostel_fees');
if($return_query==FALSE){
return $query->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function store_hostel_admission_fees($data,$return_query=FALSE){
$this->table='institute_hostel_admission_fees';
return $this->store($data,FALSE,$return_query);
}
public function update_hostel_admission_fees($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_hostel_admission_fees';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hostel_admission_fees($param,$return_query=FALSE){
$this->table='institute_hostel_admission_fees';
return $this->remove($param,0,$return_query);
}
public function get_hostel_admission_fees($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_hostel_admission_fees';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function _get_hostel_fees($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_hostel_fees.*,institute_hostels.hostel_name,institute_courses.course_id,institute_courses.course_code,institute_courses.course_name,institute_sessions.session_id,institute_sessions.session_start_year,institute_sessions.session_end_year');
$this->_db->join('institute_hostels','institute_hostel_fees.fees_hostel_id=institute_hostels.hostel_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_hostel_fees.fees_course_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_hostel_fees.fees_session_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('fees_inst_id',$param['inst_id']);
}
if(isset($param['column_search'])){
foreach ($param['column_search'] as $item)
{
if(isset($post['search']['value']) && $post['search']['value'])
{
if($i===0)
{
$this->_db->group_start();
$this->_db->like($item, $post['search']['value']);
}
else
{
$this->_db->or_like($item, $post['search']['value']);
}
if(count($param['column_search']) - 1 == $i)
$this->_db->group_end();
}
$i++;
}
}
if(isset($post['order']))
{
$column_order=$param['column_order'];
$this->_db->order_by($column_order[$post['order']['0']['column']], $post['order']['0']['dir']);
}
else if(isset($param['order']))
{
$order = $param['order'];
$this->_db->order_by(key($order), $order[key($order)]);
}
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_hostel_fees');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($count==TRUE){
$query = $this->_db->get('institute_hostel_fees');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function _get_hostel_admission_fees($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_hostel_admission_fees.*,institute_hostels.hostel_name,institute_courses.course_id,institute_courses.course_name,institute_courses.course_code,institute_sessions.session_start_year,institute_sessions.session_id,institute_sessions.session_end_year,institute_sessions_years.year_id,institute_sessions_years.year_value');
$this->_db->join('institute_hostels','institute_hostel_admission_fees.admission_hostel_id=institute_hostels.hostel_id','LEFT');
$this->_db->join('institute_courses','institute_hostel_admission_fees.admission_course_id=institute_courses.course_id','LEFT');
$this->_db->join('institute_sessions','institute_hostel_admission_fees.admission_sess_id=institute_sessions.session_id','LEFT');
$this->_db->join('institute_sessions_years','institute_hostel_admission_fees.admission_academic_year_id=institute_sessions_years.year_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('admission_inst_id',$param['inst_id']);
}
if(isset($param['column_search'])){
foreach ($param['column_search'] as $item)
{
if(isset($post['search']['value']) && $post['search']['value'])
{
if($i===0)
{
$this->_db->group_start();
$this->_db->like($item, $post['search']['value']);
}
else
{
$this->_db->or_like($item, $post['search']['value']);
}
if(count($param['column_search']) - 1 == $i)
$this->_db->group_end();
}
$i++;
}
}
if(isset($post['order']))
{
$column_order=$param['column_order'];
$this->_db->order_by($column_order[$post['order']['0']['column']], $post['order']['0']['dir']);
}
else if(isset($param['order']))
{
$order = $param['order'];
$this->_db->order_by(key($order), $order[key($order)]);
}
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_hostel_admission_fees');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($count==TRUE){
$query = $this->_db->get('institute_hostel_admission_fees');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function store_hostel_assign_data($data,$batch=FALSE,$return_query=FALSE){
$this->table='hostels_assigned';
return $this->store($data,$batch,$return_query);
}
public function update_hostel_assign_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='hostels_assigned';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hostel_assign_data($param,$return_query=FALSE){
$this->table='hostels_assigned';
return $this->remove($param,0,$return_query);
}
public function get_hostel_assign_data($param,$single_row=TRUE,$return_query=FALSE){
$this->table='hostels_assigned';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function store_hostel_admission_fees_assign_data($data,$return_query=FALSE){
$this->table='institute_hostel_admission_fees_assigned';
return $this->store($data,FALSE,$return_query);
}
public function update_hostel_admission_fees_assign_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_hostel_admission_fees_assigned';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hostel_admission_fees_assign_data($param,$return_query=FALSE){
$this->table='institute_hostel_admission_fees_assigned';
return $this->remove($param,0,$return_query);
}
public function get_hostel_admission_fees_assign_data($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_hostel_admission_fees_assigned';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function __get_hostel_admission_fees_assign_data($param,$return_query=FALSE){
$this->_db->select('institute_hostel_admission_fees_assigned.*,institute_hostels.hostel_name,institute_hostel_admission_fees.admission_fees_value,institute_hostel_admission_fees.admission_caution_fees_value,institute_students.stu_user_code,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_email,institute_students.stu_ph_no,institute_students.stu_whatsapp_no,institute_courses.course_name,institute_subjects.subject_name,institute_sessions.session_start_year,institute_sessions.session_end_year');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_hostel_admission_fees_assigned.assign_stu_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_hostel_admission_fees_assigned.assign_course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_hostel_admission_fees_assigned.assign_course_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_hostel_admission_fees_assigned.assign_sess_id','LEFT');
$this->_db->join('institute_hostels','institute_hostels.hostel_id=institute_hostel_admission_fees_assigned.assign_hostel_id','LEFT');
$this->_db->join('institute_hostel_admission_fees','institute_hostel_admission_fees.admission_fees_id=institute_hostel_admission_fees_assigned.assign_hostel_admission_fees_id','LEFT');
$this->_db->where($param);
$result=$this->_db->get('institute_hostel_admission_fees_assigned');
if($return_query==FALSE){
return $result->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function _get_hostel_admission_fees_assign_data($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_hostel_admission_fees_assigned.*,institute_hostels.hostel_name,institute_hostel_admission_fees.admission_fees_value,institute_hostel_admission_fees.admission_caution_fees_value,institute_students.stu_user_code,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_courses.course_name,institute_subjects.subject_name,institute_sessions.session_start_year,institute_sessions.session_end_year');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_hostel_admission_fees_assigned.assign_stu_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_hostel_admission_fees_assigned.assign_course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_hostel_admission_fees_assigned.assign_course_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_hostel_admission_fees_assigned.assign_sess_id','LEFT');
$this->_db->join('institute_hostels','institute_hostels.hostel_id=institute_hostel_admission_fees_assigned.assign_hostel_id','LEFT');
$this->_db->join('institute_hostel_admission_fees','institute_hostel_admission_fees.admission_fees_id=institute_hostel_admission_fees_assigned.assign_hostel_admission_fees_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('assign_hostel_inst_id',$param['inst_id']);
}
if(isset($post['course_id']) && $post['course_id']!=0){
$this->_db->where('assign_course_id',$post['course_id']);
}
if(isset($post['subject_id']) && $post['subject_id']!=0){
$this->_db->where('assign_subject_id',$post['subject_id']);
}
if(isset($post['session_id']) && $post['session_id']!=0){
$this->_db->where('assign_sess_id',$post['session_id']);
}
if(isset($param['column_search'])){
foreach ($param['column_search'] as $item)
{
if(isset($post['search']['value']) && $post['search']['value'])
{
if($i===0)
{
$this->_db->group_start();
$this->_db->like($item, $post['search']['value']);
}
else
{
$this->_db->or_like($item, $post['search']['value']);
}
if(count($param['column_search']) - 1 == $i)
$this->_db->group_end();
}
$i++;
}
}
if(isset($post['order']))
{
$column_order=$param['column_order'];
$this->_db->order_by($column_order[$post['order']['0']['column']], $post['order']['0']['dir']);
}
else if(isset($param['order']))
{
$order = $param['order'];
$this->_db->order_by(key($order), $order[key($order)]);
}
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_hostel_admission_fees_assigned');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($count==TRUE){
$query = $this->_db->get('institute_hostel_admission_fees_assigned');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
}