<?php
/**
* equipo model
* version 1.0.0
* 20180322
*/
class AdminModelSpeakers extends Model
{
	
	public function getSpeakers(){
		$query = $this->db->query
				("SELECT id,nombre,is_active
					FROM speakers
				");
		return $query;		
	}

	public function getSpeaker($id){
		$query = $this->db->query
				("SELECT id,id_empresa,id_pais,nombre,puesto,image,email,social_links,resume,menuindex,
					is_active
					FROM speakers
					WHERE id = ".$id."
				");
		return $query;		
	}

	public function addSpeaker($data){
		$query = $this->db->query
			("INSERT INTO speakers SET
				id_empresa	= ".$data['id_empresa'].",
				id_pais		= ".$data['id_pais'].",
				nombre		= '".$data['nombre']."',
				puesto		= '".$data['puesto']."',
				image		= '".$data['image']."',
				email		= '".$data['email']."',
				social_links= '".$data['social_links']."',
				resume		= '".$data['ck_resume']."',
				menuindex	= '".$data['menuindex']."',
				is_active	= ".$data['is_active']."
			");
		return $query;	
	}

	public function updateSpeaker($data){
		$query = $this->db->query
			("UPDATE speakers SET
				
				
				nombre		= '".$data['nombre']."',
				puesto		= '".$data['puesto']."',
				image		= '".$data['image']."',
				email		= '".$data['email']."',
				social_links= '".$data['social_links']."',
				resume		= '".$data['ck_resume']."',
				menuindex	= '".$data['menuindex']."',
				is_active	= ".$data['is_active']."
				WHERE id	= ".$data['id']."
			");
		return $query;	
	}

	public function getVarsSpeaker($datos = ''){
	
		if(!empty($datos) && $datos->num_rows > 0){
			$data = $datos->row;
		
			
		}else{
			$data['id'] 			= '';
			$data['id_empresa'] 	= 1;
			$data['id_pais'] 		= 1;
			$data['nombre']			= '';
			$data['puesto']			= '';
			$data['image'] 			= '';
			$data['email'] 			= '';
			$data['social_links']	= '';
			$data['resume'] 		= '';
			$data['menuindex']		= 1;
			$data['is_active'] 		= 1;
		}
			return $data;
	}

}