<?php
class Home_model extends CI_Model
{
    function __construct() 
    {
        parent::__construct();
		$this->load->database();
    }    

	function get_events()
	{		  
		$this->db->select('*');
		$this->db->from('events');    
		$this->db->order_by('id ASC');
		//$this->db->limit(10);
		$result = $this->db->get()->result(); 		 
		return $result;
	}
	function get_journals()
	{		  
		$this->db->select('*');
		$this->db->from('journal_index_links');    
		$this->db->order_by('id DESC');
		//$this->db->limit(3);
		$result = $this->db->get()->result(); 		 
		return $result;
	}
	function get_links()
	{		  
		$this->db->select('*');
		$this->db->from('journal_useful_links');    
		$this->db->order_by('id DESC');
		//$this->db->limit(3);
		$result = $this->db->get()->result(); 		 
		return $result;
	}
    function get_all_journals()
	{		  
		$this->db->select('*');
		$this->db->from('journal');    
		$this->db->order_by('id ASC');
		$result = $this->db->get()->result(); 		 
		return $result;
	}
	
	function get_recommended_journals()
	{		  
		$this->db->select('*');
		$this->db->from('recommended_journals');    
		$this->db->order_by('id ASC');
		$result = $this->db->get()->result(); 		 
		return $result;
	}
	 
	function get_articles()
	{		  
		 $this->db->distinct();
		 $this->db->select('*,li_articals.modified_date as m_date,li_current_issue.current_issue_title');
		 $this->db->from('li_articals');
		 $this->db->join('li_current_issue', 'li_current_issue.current_issue_id=li_articals.current_issue');
		 $this->db->where(array('li_articals.is_archive='=>'yes'));
		 $this->db->order_by('articles_id');
		 $query = $this->db->get();
		 return $query->result_array();
	}   
	
}
?>