<?php
/**
* equipo model
* version 1.0.0
* 20180322
*/
class AdminModelEquipo extends Model
{
	
	public function getIntegrantes(){
		$query = $this->db->query
				("SELECT person_id,firstname,position,menuindex,status
					FROM aboutlist
				");
		return $query;		
	}

	public function getIntegrante($person_id){
		$query = $this->db->query
				("SELECT person_id,firstname,lastname,alias,image,position,email,social_links,resume,menuindex,
					status
					FROM aboutlist
					WHERE person_id = ".$person_id."
				");
		return $query;		
	}

	public function addIntegrante($data){
		$query = $this->db->query
			("INSERT INTO aboutlist SET
				firstname	= '".$data['firstname']."',
				lastname	= '".$data['lastname']."',
				alias		= '".$data['alias']."',
				image		= '".$data['image']."',
				position	= '".$data['position']."',
				email		= '".$data['email']."',
				social_links= '".$data['social_links']."',
				resume		= '".$data['resume']."',
				menuindex	= '".$data['menuindex']."',
				status		= '".$data['status']."'
			");
		return $query;	
	}

	public function updateIntegrante($data){
		$query = $this->db->query
			("UPDATE aboutlist SET
				firstname	= '".$data['firstname']."',
				lastname	= '".$data['lastname']."',
				alias		= '".$data['alias']."',
				image		= '".$data['image']."',
				position	= '".$data['position']."',
				email		= '".$data['email']."',
				social_links= '".$data['social_links']."',
				resume		= '".$data['resume']."',
				menuindex	= '".$data['menuindex']."',
				status		= '".$data['status']."'
				WHERE person_id	= ".$data['person_id']."
			");
		return $query;	
	}

	public function getVarsIntegrante($datos = ''){
	
		if(!empty($datos) && $datos->num_rows > 0){
			$data = $datos->row;
		
			
		}else{
			$data['person_id'] 		= '';
			$data['firstname']		= '';
			$data['lastname'] 		= '';
			$data['alias'] 			= '';
			$data['image'] 			= '';
			$data['position'] 		= '';
			$data['email'] 			= '';
			$data['social_links']	= '';
			$data['resume'] 		= '';
			$data['menuindex']		= 1;
			$data['status'] 		= 1;
		}
			return $data;
	}

}