<?php  
   class Upcoming_conferencelist extends CI_Model  
   {  
      function __construct()  
      {  
         parent::__construct();  
      }  
	
	   public function conferencelist()  
      {  
	  	 //$this->db->select("*,DATE_FORMAT(conferencedate, '%d/%m/%Y') AS conferencedate");
	  	 $this->db->select("*");
         $this->db->from('upcoming_conference'); 
		 $this->db->where("Status='C'");
		 $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc"); 
		 
		 //select * from upcoming_conference order by STR_TO_DATE(conferencedate,'%d/%m/%Y') desc
		 /*
		 $this->db->get();
		 echo $sql = $this->db->last_query();
		 exit;  */
		 $query = $this->db->get()->result(); 
		 return $query;  
      }  
	  
	    public function uc_list_numrows()  
      {  
	      $this->db->select("*");
         $this->db->from('upcoming_conference'); 
		 $this->db->where("Status='C'");
		 $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc");
		 $query = $this->db->get(); 
		 $query= $query->num_rows(); 
		 return $query;  
	 }  
	 public function get_year()  
      {  
	 	 $this->db->select("YEAR(STR_TO_DATE(conferencedate,'%d/%m/%Y')) as getyear");
		 $this->db->from('upcoming_conference'); 
		 $this->db->distinct();
		 $this->db->where("Status='D'");
		$this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc");
		 $query = $this->db->get()->result(); 
		 $i=0;
         foreach($query as $year){
		 //print_r($year->year);
		 $query[$i]->sub = $this->getconference_year_second($year->getyear);
            $i++;
        } return $query; 
     	}  
	  
	   public function getconference_year_second($yearvalue)  
      {  
	 	 $this->db->select('*');
		 $this->db->from('upcoming_conference'); 
		 $this->db->distinct();
		 $this->db->where('YEAR(STR_TO_DATE(conferencedate,"%d/%m/%Y"))',$yearvalue);
		 $this->db->where('Status','D');
		 $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc"); 
		 
		 $query = $this->db->get()->result(); 
		 //$query = $this->db->get();
	   	 //echo $query = $this->db->last_query();  echo ";";
     	 return $query;
		 
		  $i=0;
        foreach($query as $year){
		 //print_r($year->year);
		 $query[$i]->sub = $this->getconference_year_second($year->getyear);
            $i++;
        } return $query; 
      
	 }   
	 
	    public function conference_details()  
      {  
	     $id = $this->uri->segment(3);
		 $this->db->select("*");
         $this->db->from('upcoming_conference'); 
		 $this->db->where('conference_id',$id);
		 $query = $this->db->get()->result(); 
		 //echo $str = $this->db->last_query();
		 //exit;
		 return $query;  
      }  
	   public function conference_committee_details()  
      {  
	     $id = $this->uri->segment(3);
		 $this->db->select("*");
         $this->db->from('committee_member'); 
		 $this->db->where('conferenceid',$id);
		 $query = $this->db->get()->result(); 
		 //echo $str = $this->db->last_query();
		 //exit;
		 return $query;  
      }  
	  
	  
	  
  }  
?>