golden hour

/home/phakp/public_html/bkp_full/old_site_bkp/application/models

File/Folder	Size	Actions
Ets_fetch1_model.php	34.24 KB
index.html	131 B

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 ///////////////////////////////////////////////////

$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();
        
    }
///////////////////////////////////////////////////////////////////////////////////////////////////////// 	
   							
}
?>