<?php
/**
* model clientes
*/
class AdminModelClientes extends Model
{
	
	public function getClientes(){
		$query = $this->db->query
			("SELECT cliente_id,nombre,is_active
				FROM clientes
			");
		return $query;	
	}

	public function getCliente($cliente_id){
		$query = $this->db->query
			("SELECT cliente_id,nombre,introtext,content,imagen,weight,is_active
				FROM clientes
				WHERE cliente_id = ".$cliente_id."
			");
		return $query;	
	}

	public function addCliente($data){
		$query = $this->db->query
			("INSERT INTO clientes SET
				nombre		= '".$data['nombre']."',
				introtext	= '".$data['introtext']."',
				content		= '".$data['ck_content']."',
				imagen		= '".$data['imagen']."',
				weight		= '".$data['weight']."',
				is_active	= '".$data['is_active']."'
			");
		return $query;	
	}

	public function updateCliente($data){
		$query = $this->db->query
			("UPDATE clientes SET
				nombre		= '".$data['nombre']."',
				introtext	= '".$data['introtext']."',
				content		= '".$data['ck_content']."',
				imagen		= '".$data['imagen']."',
				weight		= '".$data['weight']."',
				is_active	= '".$data['is_active']."'
				WHERE cliente_id	= ".$data['cliente_id']."
			");
		return $query;	
	}

	public function getVarsCliente($datos = ''){
	
		if(!empty($datos) && $datos->num_rows > 0){
			$data = $datos->row;
		
			
		}else{
			$data['cliente_id'] 	= '';
			$data['nombre'] 		= '';
			$data['introtext']		= '';
			$data['content'] 		= '';
			$data['imagen'] 		= '';
			$data['weight'] 		= 0;
			$data['is_active'] 		= 1;
		}
			return $data;
	}
}