<?php  
   class Specialissue extends CI_Model  
   {  
      function __construct()  
      {  
         parent::__construct();  
      }  
	  public function get_year_special()  
      {  
	 	 $this->db->select("year");
		 $this->db->from('specialissue_conference'); 
		 $this->db->distinct();
		 $this->db->order_by("year","desc");
		 //$query= $this->db->get();
		 //echo $query = $this->db->last_query();
		 $query = $this->db->get()->result(); 
		 $i=0;
         foreach($query as $specialyear){
		 //print_r($year->year);
		 $query[$i]->sub = $this->getspecial_year_second($specialyear->year);
            $i++;
        } return $query; 
     	}  
	  
	   public function getspecial_year_second($yearvalue)  
      {  
	 	 $this->db->select('*');
		 $this->db->from('specialissue_conference'); 
		 $this->db->distinct();
		 $this->db->where('year',$yearvalue);
		 $this->db->order_by("year","desc");
		 $this->db->order_by("sp_id","desc");
		 /*
		 $query= $this->db->get();
		 echo $query = $this->db->last_query(); exit;
		 */
		 $query = $this->db->get()->result(); 
		 return $query;
		 
		  $i=0;
        foreach($query as $year){
		 //print_r($year->year);
		 $query[$i]->sub = $this->getspecial_year_second($year->year);
            $i++;
        } return $query; 
      
	 }   
	  public function specialissue_part()  
      {  
	     $cid = $this->uri->segment(3);
		 $this->db->select("department_name,department,shortform,part as shortpart,department_short,conference_name");
         $this->db->from('specialissue_conference');
		 $this->db->join('specialissue_article','specialissue_conference.sp_id = specialissue_article.sc_id','inner');
		 $this->db->join('article_department','specialissue_article.department = article_department.dp_id','inner');
		 $this->db->distinct();
		 $this->db->where('sp_id',$cid);
		 $this->db->order_by('department_name','asc');
		 $this->db->order_by('partno','asc');		 
		 /* $query = $this->db->get();
		 echo $sql = $this->db->last_query();
		 exit;  */
		 $query = $this->db->get()->result(); 
		 return $query;
      }  
	  public function specialissues_paperlist_title_model()  
      {  
	 	  $deptid_part = $this->uri->segment(3);
		  $s = explode('-',$deptid_part);
		  $departmentid = $s['0'];
		  $parts =$s['1'];
		  $conferenceid = $s['2'];
		  
		 $this->db->select("*");
         $this->db->from('specialissue_article');
		 $this->db->join('specialissue_conference','specialissue_article.sc_id=specialissue_conference.sp_id');
		 $this->db->where('department=',$departmentid);
		 $this->db->where('part',$parts);
		 $this->db->where('sc_id',$conferenceid);
		 //$this->db->order_by('specialissue_article.sa_id','asc');
		 //$query = $this->db->get();
		 //echo $sql = $this->db->last_query(); exit;
		 $query = $this->db->get()->result();
		 return $query;  
	  }    
	  public function specialissues_paperlist_model()  
      {  
	 	  $deptid_part = $this->uri->segment(3);
		  $s = explode('-',$deptid_part);
		  $departmentid = $s['0'];
		  $parts =$s['1'];
		  $conferenceid = $s['2'];
		  
		 $this->db->select("*");
         $this->db->from('specialissue_article');
		 $this->db->where('department=',$departmentid);
		 $this->db->where('part',$parts);
		 $this->db->where('sc_id',$conferenceid);
		 $this->db->order_by('partno','asc');
		// $query = $this->db->get();
		 $query = $this->db->get()->result();
		 return $query;  
	  }    
	  
}  
?>