golden hour
/home/phakp/public_html/bkp_full/old_site_bkp/application/models
⬆️ Go Up
Upload
File/Folder
Size
Actions
Ets_fetch1_model.php
34.24 KB
Del
OK
index.html
131 B
Del
OK
Edit: Ets_fetch1_model.php
<?php class Ets_fetch1_model extends CI_Model { function __construct() { parent::__construct(); } // -------------------------------------------------------------------- /** * function SaveForm() * * insert form data * @param $form_data - array * @return Bool - TRUE or FALSE */ public function sar_max($student_id,$ins_id,$session_year) { $this->db->select_max('SAR'); $q = $this->db->get('ets_student_academic_record'); $this->db->where('STUDENT_ID',$student_id); $this->db->where('INS_ID',$ins_id); $this->db->where('SESSION_YEAR',$session_year); $data = $q->row(); return $data; } public function about(){ $query=$this->db->select('*'); $this->db->from('about_us'); //$this->db->order_by('mm_id', 'DESC'); $query = $this->db->get(); return $query->result(); } public function services(){ $query=$this->db->select('*'); $this->db->from('services'); //$this->db->order_by('mm_id', 'DESC'); $query = $this->db->get(); return $query->result(); } public function show_product(){ /*$query=$this->db->select('*'); $this->db->from('product_info'); //$this->db->order_by('mm_id', 'DESC'); $query = $this->db->get();*/ //return $query->result(); //echo $this->db->last_query(); //exit; //return $sqlsss->result(); } //////////////////////////////////////////////insertion /////////////////////////////////////////////////// function SaveForm($form_data) { $this->db->insert('ets_student_academic_record', $form_data); if ($this->db->affected_rows() == '1') { return TRUE; } return FALSE; } //////////////////////////////////update choice/////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////// function SaveChoice_update($form_data,$id) { $this->db->where('STD_CHOICE_NO',$id); $i = $this->db->update('ets_student_choices', $form_data); return $i; } ///////////////////////////////////////////updation////////////////////////////////////////////////////////////// function update_academics($form_data,$id) { $this->db->where('SAR', $id); $i = $this->db->update('ets_student_academic_record', $form_data); return $i; } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// function update_academics_subject($form_data,$sub,$id,$sar) { $this->db->where('SUB_ID',$sub); $this->db->where('SAR_ID',$sar); $this->db->where('S_NO',$id); $i = $this->db->update('ets_student_academic_subjects_details',$form_data); return $i; } ////////////////////////////////////////display all fields////////////////////////////////// public function getAll(){ $this->db->order_by('LOGIN_ID','desc'); $query=$this->db->get('ets_login_forms'); //$query =$this->db->query("select * from events"); //$query=$this->db->get('message',$per_pg,$offset); return $query->result(); } /////////////////////////pagination///////////////////////////// public function count_all() { return $this->db->count_all('ets_login_forms'); } /////////////////////////////get specific record/////////////////////// public function admission_id($INS,$ELI){ /*SELECT ep.`PRE_ID`,ep.`PRE_NAME` FROM `ets_previous_eligibility` as ep WHERE ep.`INS_ID`= and ep.`ELIGIBILITY_ID`=*/ //$query= $this->query("select * from ets_apply_forms where LOGIN_ID1='$login_id'"); $this->db->from('ets_previous_eligibility'); //$this->db->join('ets_previous_eligibility as e1','e1.INS_ID = ets_apply_forms.INS_ID'); //$this->db->join('ets_previous_eligibility as e2','e3.ELIGIBILITY_ID = ets_apply_forms.ELIGIBILITY_ID'); $this->db->where('INS_ID',$INS); $this->db->where('ELIGIBILITY_ID',$ELI); $query = $this->db->get(); return $query->result(); } /////////////////////////////get specific record from ets_category_subjects/////////////////////// public function subject($INS){ $this->db->from('ets_category'); $this->db->where('INS_ID',$INS); /*$this->db->group_by('ets_category.CAT_ID'); */ //$this->db->group_by(array('INS_ID','CAT_ID')); $query = $this->db->get(); return $query->result(); } /////////////////////////////get specific record from ets_category/////////////////////// public function category($INS){ $this->db->from('ets_category'); $this->db->where('INS_ID',$INS); /*$this->db->group_by('ets_category.CAT_ID'); */ //$this->db->group_by(array('INS_ID','CAT_ID')); $query = $this->db->get(); return $query->first_row('array'); //return $query->result(); } /////////////////////////////get specific record from ets_category/////////////////////// public function category1(){ $this->db->from('ets_category'); //$this->db->where('INS_ID',$INS); /*$this->db->group_by('ets_category.CAT_ID'); */ //$this->db->group_by(array('INS_ID','CAT_ID')); $query = $this->db->get(); //return $query->first_row('array'); return $query->result(); } //////////////////////////////////////////subjects/////////////////////////////////////////////////// public function subjects($INS){ $this->db->from('ets_category_subjects'); //$this->db->join('ets_category','ets_category.CAT_ID = ets_category_subjects.CAT_ID'); $this->db->where('ets_category_subjects.INS_ID',$INS); //$this->db->group_by('ets_category.CAT_ID'); $query = $this->db->get(); return $query->result(); } ////////////////////////////////////////marks////////////////////////////////////////////////////////////////// public function marks($INS){ $this->db->from('ets_student_academic_subjects_details'); $this->db->where('INS_ID',$INS); $query = $this->db->get(); return $query->result(); } /////////////////////////////get Board/////////////////////// public function board(){ $this->db->from('prm_board_university'); $query = $this->db->get(); return $query->result(); } public function certificat(){ $this->db->from('ets_certificate_degree'); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////addmission form////////////////////////////// public function student($login_id){ $this->db->select('*'); $this->db->select('ets_apply_forms.STUDENT_NAME AS sname'); $this->db->from('ets_apply_forms'); $this->db->join('prm_district','ets_apply_forms.DOMICILE_ID = prm_district.DIS_ID'); $this->db->join('ets_login_forms','ets_login_forms.LOGIN_ID = ets_apply_forms.LOGIN_ID'); $this->db->join('prm_institute','ets_apply_forms.INS_ID = prm_institute.INS_ID'); $this->db->join('ets_category','ets_apply_forms.CAT_ID = ets_category.CAT_ID'); $this->db->where('ets_login_forms.LOGIN_ID',$login_id); $query = $this->db->get(); return $query->result(); } ///////////////////////////////display login/////////////////////////////////////////////////////////// public function student_login($login_id){ $this->db->select('*'); //$this->db->select('ets_login_forms'); $this->db->from('ets_login_forms'); $this->db->where('LOGIN_ID',$login_id); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////addmission form////////////////////////////// public function student3($login_id){ $this->db->select('*'); $this->db->from('ets_apply_forms'); $this->db->join('ets_login_forms','ets_login_forms.LOGIN_ID = ets_apply_forms.LOGIN_ID'); $this->db->where('ets_login_forms.LOGIN_ID',$login_id); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////academic record form////////////////////////////// public function student1($student_id){ $this->db->select('*'); $this->db->from('ets_student_academic_record'); $this->db->join('ets_certificate_degree','ets_student_academic_record.CD_ID = ets_certificate_degree.CD_ID'); $this->db->join('prm_board_university','ets_student_academic_record.BU_ID = prm_board_university.BU_ID'); $this->db->join('prm_institute','ets_student_academic_record.INS_ID = prm_institute.INS_ID'); $this->db->where('STUDENT_ID',$student_id); $this->db->order_by("ets_student_academic_record.BU_ID", "desc"); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////academic record form for update////////////////////////////// public function student2($student_id,$ins){ $query=$this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); $this->db->join('ets_category','ets_student_academic_subjects_details.CAT_ID = ets_category.CAT_ID'); $this->db->where('ets_student_academic_subjects_details.STUDENT_ID',$student_id); $this->db->where('ets_student_academic_subjects_details.INS_ID',$ins); //$this->db->where('CAT_ID',$cat); $query =$this->db->get(); //return $query->result(); //return $query->row(); return $query->first_row('array'); ///////////////////////////////////////////////////////////////// /*$this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); $this->db->join('ets_category','ets_student_academic_subjects_details.CAT_ID = ets_category.CAT_ID'); $this->db->join('prm_institute','ets_student_academic_subjects_details.INS_ID = prm_institute.INS_ID'); $this->db->where('ets_student_academic_subjects_details.STUDENT_ID',$student_id); $this->db->where('ets_student_academic_subjects_details.INS_ID',$ins); $query = $this->db->get(); return $query->result();*/ //return $query->first_row('array'); } //////////////////////////////////////////////get marks//////////////////////////////////////////////////////// ///////////////////////////////////////////academic record form for update////////////////////////////// public function student_count($student_id,$ins){ $this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); //$this->db->join('ets_category','ets_student_academic_subjects_details.CAT_ID = ets_category.CAT_ID'); //$this->db->join('prm_institute','ets_student_academic_subjects_details.INS_ID = prm_institute.INS_ID'); $this->db->where('STUDENT_ID',$student_id); $this->db->where('INS_ID',$ins); $query = $this->db->get(); //return $query->result(); return $query->num_rows(); } ///////////////////////////////////////////academic record form////////////////////////////// public function student_academics($student_id,$ins_id){ $this->db->select('*'); $this->db->from('ets_student_academic_record'); $this->db->join('ets_certificate_degree','ets_student_academic_record.CD_ID = ets_certificate_degree.CD_ID'); $this->db->join('prm_board_university','ets_student_academic_record.BU_ID = prm_board_university.BU_ID'); $this->db->join('prm_institute','ets_student_academic_record.INS_ID = prm_institute.INS_ID'); $this->db->where('ets_student_academic_record.STUDENT_ID',$student_id); $this->db->where('ets_student_academic_record.INS_ID',$ins_id); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////academic record form////////////////////////////// public function check_academics($student_id,$ins_id){ $this->db->select('*'); $this->db->from('ets_student_academic_record'); $this->db->join('ets_certificate_degree','ets_student_academic_record.CD_ID = ets_certificate_degree.CD_ID'); $this->db->join('prm_board_university','ets_student_academic_record.BU_ID = prm_board_university.BU_ID'); $this->db->join('prm_institute','ets_student_academic_record.INS_ID = prm_institute.INS_ID'); $this->db->where('ets_student_academic_record.STUDENT_ID',$student_id); $this->db->where('ets_student_academic_record.INS_ID',$ins_id); $query = $this->db->get(); return $query->num_rows(); } //////////////////////////////////////////////////////////////////////////////// function update($data,$id) { $this->db->where('LOGIN_ID', $id); $i = $this->db->update('ets_login_forms', $data); return $i; } ////////////////////////////////////////delete record////////////////////////// function delete($id) { $this->db->where('LOGIN_ID', $id); $i = $this->db->delete('ets_login_forms'); return $i; } ////////////////////////////////////////delete record////////////////////////// function check_user($STUDENT_NAME,$PASSWORD) { if(filter_var($STUDENT_NAME, FILTER_VALIDATE_EMAIL)){ $this->db->select('*'); $this->db->from('ets_login_forms'); $this->db->where('EMAIL',$STUDENT_NAME); //$this->db->or_where('EMAIL',$EMAIL); //$this -> db -> where('password', MD5($password)); $this->db->where('PASSWORD',$PASSWORD); $this->db->limit(1); $query =$this->db->get(); return $query->first_row('array'); }else{ $this->db->select('*'); $this->db->from('ets_login_forms'); $this->db->where('STUDENT_NAME',$STUDENT_NAME); //$this->db->or_where('EMAIL',$EMAIL); //$this -> db -> where('password', MD5($password)); $this->db->where('PASSWORD',$PASSWORD); $this->db->limit(1); $query =$this->db->get(); return $query->first_row('array'); } //$this->db->from('ets_login_forms',$data); //$i = $this->db->update('ets_login_forms', $data); //return $i; //$this->db->where('STUDENT_NAME', $id); //return $query->result(); } /////////////////////////////////////////////////////addmission_view3//////////////////////////////////////// public function sar_max1($student_id,$ins_id,$session_year) { $this->db->select_max('SAR_ID'); $q = $this->db->get('ets_student_academic_subjects_details'); $this->db->where('STUDENT_ID',$student_id); $this->db->where('INS_ID',$ins_id); $this->db->where('SESSION_YEAR',$session_year); $data = $q->row(); return $data; } /////////////////////////////////////////Save_subjects///////////////////////////////////////////// function Save_subjects($form_data) { $this->db->insert('ets_student_academic_subjects_details', $form_data); if ($this->db->affected_rows() == '1') { return TRUE; } return FALSE; } ///////////////////////////////////////////////////////subject_marks///////////////////////////// public function subjects_marks($cat,$ins){ //echo "kifayat"; /*$query="select * from ets_category_subjects where INS_ID= '$ins' and CAT_ID='$cat'" ; $sle=mysql_query($query); $ro=mysql_fetch_array($sle);*/ $query=$this->db->select('*'); $this->db->from('ets_category_subjects'); $this->db->where('INS_ID',$ins); $this->db->where('CAT_ID',$cat); $query = $this->db->get(); return $query->result(); //return $query->first_row('array'); } ///////////////////////////////////////////////////////view subject_marks update///////////////////////////// public function subjects_marks_update1($cont,$cat,$ins,$s_year,$student){ /*echo "cont is".$cont; echo "cat is".$cat; echo "ins is".$ins; echo "syear is".$s_year; echo "student is".$student;*/ //exit; $query=$this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); $this->db->join('ets_category_subjects','ets_student_academic_subjects_details.SUB_ID = ets_category_subjects.SUB_ID'); $this->db->where('ets_student_academic_subjects_details.INS_ID',$ins); $this->db->where('ets_student_academic_subjects_details.CAT_ID',$cat); $this->db->where('ets_student_academic_subjects_details.SAR_ID',$cont); $this->db->where('ets_student_academic_subjects_details.STUDENT_ID',$student); $this->db->where('ets_student_academic_subjects_details.SESSION_YEAR',$s_year); $query = $this->db->get(); //exit; return $query->result(); //return $query->first_row('array'); } /////////////////////////////////////////Save_subjects///////////////////////////////////////////// ///////////////////////////////////////////////////////subject_marks///////////////////////////// public function cat_discipline($cat,$ins){ //echo "kifayat"; /*$query="select * from ets_category_subjects where INS_ID= '$ins' and CAT_ID='$cat'" ; $sle=mysql_query($query); $ro=mysql_fetch_array($sle);*/ $query=$this->db->select('*'); $this->db->from('ets_disciplines'); $this->db->where('INS_ID',$ins); $this->db->where('CAT_ID',$cat); $query = $this->db->get(); return $query->result(); //return $query->first_row('array'); } ///////////////////////////////////////////////////////subject_marks///////////////////////////// public function cat_academic($student){ //echo "kifayat"; /*$query="select * from ets_category_subjects where INS_ID= '$ins' and CAT_ID='$cat'" ; $sle=mysql_query($query); $ro=mysql_fetch_array($sle);*/ $query=$this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); $this->db->join('ets_category','ets_student_academic_subjects_details.CAT_ID = ets_category.CAT_ID'); $this->db->where('ets_student_academic_subjects_details.STUDENT_ID',$student); //$this->db->where('CAT_ID',$cat); $query =$this->db->get(); //return $query->result(); //return $query->row(); return $query->first_row('array'); } //////////////////////////////////////////////get Marks for update form/////////////////////////////////////////////////// public function get_markss($student,$session_year,$ins){ $query=$this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); $this->db->join('ets_category_subjects','ets_student_academic_subjects_details.SUB_ID = ets_category_subjects.SUB_ID'); $this->db->where('ets_student_academic_subjects_details.STUDENT_ID',$student); $this->db->where('ets_student_academic_subjects_details.INS_ID',$ins); $this->db->where('ets_student_academic_subjects_details.session_year',$session_year); $query =$this->db->get(); return $query->result(); } /////////////////////////////////////////////////////////////max id for choices public function choice_max($student_id,$ins_id,$session_year) { $this->db->select_max('STD_CHOICE_NO'); $q = $this->db->get('ets_student_choices'); $this->db->where('STUDENT_ID',$student_id); $this->db->where('INS_ID',$ins_id); $this->db->where('SESSION_YEAR',$session_year); $data = $q->row(); return $data; } /////////////////////////////////////////////////////////////////////saving function for choices/////////// function SaveChoice($form_data) { $this->db->insert('ets_student_choices', $form_data); if ($this->db->affected_rows() == '1') { return TRUE; } return FALSE; } /////////////////////////////////////////////////////////////////////view choices////////////////// public function view_choices_profile($cat,$ins,$student){ $query=$this->db->select('*'); $this->db->from('ets_student_choices'); $this->db->join('ets_disciplines','ets_student_choices.DISCIPLINE_ID = ets_disciplines.DISCIPLINE_ID'); $this->db->where('ets_student_choices.INS_ID',$ins); $this->db->where('ets_student_choices.CAT_ID',$cat); $this->db->where('ets_student_choices.STUDENT_ID',$student); $this->db->order_by('ets_student_choices.CHOICE_NO','ASC'); $query = $this->db->get(); return $query->result(); //return $query->first_row('array'); } ///////////////////////////////////////////////////////////////////////////////////////////////////// public function get_marks_subjects($cat,$ins,$student){ $query=$this->db->select('*'); $this->db->from('ets_student_academic_subjects_details'); $this->db->join('ets_category_subjects','ets_student_academic_subjects_details.SUB_ID = ets_category_subjects.SUB_ID'); $this->db->where('ets_student_academic_subjects_details.INS_ID',$ins); $this->db->where('ets_student_academic_subjects_details.CAT_ID',$cat); $this->db->where('ets_student_academic_subjects_details.STUDENT_ID',$student); //$this->db->order_by('ets_student_choices.CHOICE_NO','ASC'); $query = $this->db->get(); return $query->result(); //return $query->first_row('array'); } //////////////////////////////////////////////////////////////////////rows count//////////// public function view_choices_count($cat,$ins,$student){ //echo "kifayat"; /*$query="select * from ets_category_subjects where INS_ID= '$ins' and CAT_ID='$cat'" ; $sle=mysql_query($query); $ro=mysql_fetch_array($sle);*/ $query=$this->db->select('*'); $this->db->from('ets_student_choices'); $this->db->join('ets_disciplines','ets_student_choices.DISCIPLINE_ID = ets_disciplines.DISCIPLINE_ID'); $this->db->where('ets_student_choices.INS_ID',$ins); $this->db->where('ets_student_choices.CAT_ID',$cat); $this->db->where('ets_student_choices.STUDENT_ID',$student); $query = $this->db->get(); return $query->num_rows(); //return $query->result(); //return $query->first_row('array'); } ///////////////////////////////////////////////////////subject_marks///////////////////////////// public function check_subjects($cat,$ins){ //echo "kifayat"; /*$query="select * from ets_category_subjects where INS_ID= '$ins' and CAT_ID='$cat'" ; $sle=mysql_query($query); $ro=mysql_fetch_array($sle);*/ $query=$this->db->select('*'); $this->db->from('ets_category_subjects'); $this->db->where('INS_ID',$ins); $this->db->where('CAT_ID',$cat); $query = $this->db->get(); //return $query->result(); return $query->num_rows(); //return $query->result(); //return $query->first_row('array'); } //////////////////////////////////////////////////////displya data on webpages/////////////////////////////////////////////////////////////// public function view_tender(){ $query=$this->db->select('*'); $this->db->from('web_tender'); $this->db->order_by('tender_id', 'DESC'); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////////////////////////////////////////////////////////////// public function view_resources(){ $query=$this->db->select('*'); $this->db->from('web_resources'); $this->db->where('status',1); $this->db->order_by('resource_id', 'DESC'); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////////////////////////////////////////////////////////////// public function view_news(){ $query=$this->db->select('*'); $this->db->from('web_news'); $this->db->order_by('news_id', 'DESC'); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////////////////////////////////////////////////////////////// public function view_press(){ $query=$this->db->select('*'); $this->db->where('status',1); $this->db->from('web_press'); $this->db->order_by('press_id', 'DESC'); $query = $this->db->get(); return $query->result(); } //////////message/////////////////////////////////////////////////////////////////////////////////////////// public function view_message(){ $query=$this->db->select('*'); $this->db->from('web_message'); //$this->db->order_by('order_by', 'ASC'); $this->db->where('status',1); $this->db->where('order_by',1); $query = $this->db->get(); return $query->result(); } //////////////////////////chairman message///////////////////////// public function view_message_chairman(){ $query=$this->db->select('*'); $this->db->from('web_message'); //$this->db->order_by('order_by', 'ASC'); $this->db->where('status',1); $this->db->where('order_by',2); $query = $this->db->get(); return $query->result(); } /////////////////////md message////////////////////////////// public function view_message_md(){ $query=$this->db->select('*'); $this->db->from('web_message'); //$this->db->order_by('order_by', 'ASC'); $this->db->where('status',1); $this->db->where('order_by',3); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////tender/////////////////////////////// // public function display_tender(){ //$query=$this->db->select('*'); //$this->db->from('web_tender'); public function count_tender() { return $this->db->count_all('web_tender'); } ///////////////////////////////////////////////////////////// public function select_tender_source($limit,$offset) { $this->db->select('*'); $this->db->from('web_tender'); $this->db->limit($limit,$offset); $this->db->order_by('tender_id', 'DESC'); $query = $this->db->get(); return $result = $query->result(); } //$this->db->order_by('tender_id', 'DESC'); //$query = $this->db->get(); //return $query->result(); //} /////////////////////////////////////////////////////////////////// public function view_message_by_id($id){ $query=$this->db->select('*'); $this->db->from('web_message'); //$this->db->order_by('order_by', 'ASC'); $this->db->where('status',1); $this->db->where('message_id',$id); $query = $this->db->get(); return $query->result(); } /////////////////////////////////////////////////////////////////// public function view_resource_by_id($id){ $query=$this->db->select('*'); $this->db->from('web_resources'); $this->db->where('resource_id',$id); $query = $this->db->get(); return $query->result(); } /////////////////////////////////////////////////////////////////// public function view_press_by_id($id){ $query=$this->db->select('*'); $this->db->from('web_press'); $this->db->where('press_id',$id); $query = $this->db->get(); return $query->result(); } /////////////////////////////////////////////////////////////////// public function view_news_by_id($id){ $query=$this->db->select('*'); $this->db->from('web_news'); $this->db->where('news_id',$id); $query = $this->db->get(); return $query->result(); } /////////////////////////////display web pages////////////////////////////////////// public function view_pages($id){ $query=$this->db->select('*'); $this->db->from('web_page_all'); $this->db->where('MENU_ID',$id); $query = $this->db->get(); return $query->result(); } ////////////////////////////////////////////display contatcs /////////////// public function count_contacts() { return $this->db->count_all('web_contact_us'); } /////////////////////////////////////////////////////////////// public function view_contacts($limit,$offset){ $query=$this->db->select('*'); $this->db->from('web_contact_us'); //$this->db->where('INS_TYPE_ID',5); $this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } /////////////////////////pagination///////////////////////////// public function count_ins() { return $this->db->count_all('prm_institute_type'); } ////////////////////////////////////////////display institute/////////////// public function view_ins($limit,$offset){ $query=$this->db->select('*'); $this->db->from('prm_institute_type'); $this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } public function display_inst_detail($id){ $query=$this->db->select('*'); $this->db->from('prm_institute'); //$this->db->get_where('prm_institute',array('INS_TYPE_ID' => $id)); //arjunphp.com/prevent-sql-injection-codeigniter/#sthash.k5V6OoY5.dpuf $this->db->where(array('INS_TYPE_ID' => $id)); //$this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } ///////////////////////////////////////////display institute/////////////// public function view_ins_degree_new($id){ $query=$this->db->select('*'); $this->db->from('cur_degrees'); //$this->db->join('prm_institute','cur_degrees.INS_ID = prm_institute.INS_ID'); $this->db->where('INS_ID',$id); //$this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } //////////////////////////////get ins name/////////////// public function get_ins_name($INS){ $query=$this->db->select('INS_NAME'); $this->db->from('prm_institute'); $this->db->where('INS_ID',$INS); /*$this->db->group_by('ets_category.CAT_ID'); */ //$this->db->group_by(array('INS_ID','CAT_ID')); $query = $this->db->get(); return $query->result(); } ////////////////////////////////////////////////////////////////////////////////// public function view_ins_courses_new($ins,$degrees){ $query=$this->db->select('*'); $this->db->from('cur_courses'); //$this->db->join('prm_institute','cur_degrees.INS_ID = prm_institute.INS_ID'); $this->db->where('INS_ID',$ins); $this->db->where('DEGREE_ID',$degrees); //$this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } public function view_minutes(){ $query=$this->db->select('*'); $this->db->from('web_meeting_minutes'); $this->db->order_by('mm_id', 'DESC'); $query = $this->db->get(); return $query->result(); } //////////student_gallery/////////////////////////////////////////////////////////////////////////////////////////// public function count_gallery_photo() { return $this->db->count_all('web_photo_gallary'); } //////////student_gallery/////////////////////////////////////////////////////////////////////////////////////////// public function student_gallery($limit,$offset){ $query=$this->db->select('*'); $this->db->from('web_photo_gallary'); $this->db->order_by('PG_ID', 'DESC'); $this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } public function student_gallery_new(){ $query=$this->db->select('*'); $this->db->from('web_photo_gallary'); $this->db->order_by('PG_ID', 'DESC'); //$this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } ////////////////////////////////videos gallary//////////////////////////////////////////////////////////////// public function count_gallery_video() { return $this->db->count_all('web_vedio_gallery'); } //////////////////////////////////////////////////////////////// public function student_gallery_video($limit,$offset){ $query=$this->db->select('*'); $this->db->from('web_vedio_gallery'); $this->db->order_by('VG_ID', 'DESC'); $this->db->limit($limit,$offset); $query = $this->db->get(); return $query->result(); } ////////////////////////////////////////documents///////////////////////////////////////////////////// public function count_documents() { return $this->db->count_all('web_documents'); } /////////////////////////////////////////////////////////////////////////////////// public function select_documents_source($limit,$offset) { $this->db->select('*'); $this->db->from('web_documents'); $this->db->limit($limit,$offset); $this->db->order_by('document_id', 'DESC'); $query = $this->db->get(); return $result = $query->result(); } ///////////////////////////////////////jobs portion///////////////////////////////////////////////////// public function count_jobs() { return $this->db->count_all('web_job'); } public function display_jobs($limit,$offset) { $this->db->select('*'); $this->db->from('web_job'); $this->db->join('web_job_designation','web_job.job_designation = web_job_designation.designation_id'); $this->db->limit($limit,$offset); $this->db->order_by('job_id', 'DESC'); $query = $this->db->get(); return $result = $query->result(); } /////////////////////////////////////////////////////////////////////////// public function display_jobs_specific($id) { $this->db->select('*'); $this->db->from('web_job'); $this->db->join('web_job_designation','web_job.job_designation = web_job_designation.designation_id'); $this->db->where('job_id',$id); $this->db->order_by('job_id', 'DESC'); $query = $this->db->get(); return $result = $query->result(); } public function display_jobs_eligibility($id) { $this->db->select('*'); $this->db->from('web_job_eligibility'); $this->db->where('job_id',$id); $this->db->order_by('eligibility_title', 'ASC'); $query = $this->db->get(); return $result = $query->result(); } ////////////////////////////////////////documents///////////////////////////////////////////////////// public function count_forms() { return $this->db->count_all('web_forms'); } /////////////////////////////////////////////////////////////////////////////////// public function select_forms_source($limit,$offset) { $this->db->select('*'); $this->db->from('web_forms'); $this->db->limit($limit,$offset); $this->db->order_by('form_id', 'DESC'); $query = $this->db->get(); return $result = $query->result(); } public function count_minutes() { return $this->db->count_all('web_meeting_minutes'); } /////////////////////////////////////////////////////////////////////////////////// public function select_minutes_source($limit,$offset) { $this->db->select('*'); $this->db->from('web_meeting_minutes'); $this->db->limit($limit,$offset); $this->db->order_by('mm_id', 'DESC'); $query = $this->db->get(); return $result = $query->result(); } /////////////////////mm message////////////////////////////// public function view_message_mm(){ $query=$this->db->select('*'); $this->db->from('web_main_message'); //echo $this->db->last_query(); $query = $this->db->get(); return $query->result(); } ///////////////////////////organo gram//////////////////////////////////////// public function view_organogram(){ $query=$this->db->select('*'); $this->db->from('web_organograms'); $this->db->limit(1); $this->db->order_by('organogram_id', 'DESC'); $query = $this->db->get(); return $query->result(); } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public function fetch_parent_navi() { $abc="SELECT * FROM usr_menu_web WHERE PARENT_ID =0 and is_web=1 ORDER BY SORT_ORDER ASC"; $query = $this->db->query($abc); //echo $this->db->last_query(); return $query->result(); } public function fetch_child_navi() { $xyz="SELECT * FROM usr_menu_web WHERE PARENT_ID !=0 and is_web=1 ORDER BY SORT_ORDER ASC"; $query = $this->db->query($xyz); // echo $this->db->last_query(); return $query->result(); } ///////////////////////////////////////////////////////////////////////////////////////////////////////// } ?>
Save