Host_model.php 1.16 KB
<?php 
class Host_model extends CI_Model {
	public function _consruct(){
		parent::_construct();
 	}

 	public function getHostCategories($host_id='',$view=''){
 		$cond  = (!empty($view))?" status IN ($view) ":" status != '2' ";
 		$cond .= (!empty($host_id))?" AND host_cat_id='$host_id' ":"";

 		$hostData = $this->db->query("SELECT * FROM host_categories WHERE $cond");

 		if(!empty($hostData)){
 			return (empty($host_id))?$hostData->result():$hostData->row();
 		}
 		return 0;
 	}

 	public function createHostCategory($hostData = array()){
 		if(empty($hostData)){
 			return 0;
 		}
 		$status = $this->db->insert('host_categories',$hostData);
 		return $status;
 	}

 	public function updateHostCategory($host_id = '', $hostData = array()){
 		if(empty($host_id) || empty($hostData)){
 			return 0;
 		}
 		$status = $this->db->update('host_categories',$hostData,array('host_cat_id'=>$host_id));
 		return $status;
 	}

 	public function changeStatus($host_id = '', $status = '0'){
 		if(empty($host_id)){
 			return 0;
 		}
 		$status = $this->db->update('host_categories',array('status'=>$status),
 													  array('host_cat_id'=>$host_id));
 		return $status;
 	}
}
?>