<?

defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

class vxcModelCustomer extends JModel
{
	var $_id = 0;
	var $_item = null;
	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());
	}	

	function SetId($id)
	{
		$this->_id = (int)$id;
		$this->_item =null;
	}
	function getData()
	{
		if (empty($this->_item))
		{
			$sql = "SELECT c.id id,c.user user, 
						c.title title, c.localid localid, c.name name,
						c.middlename middlename, c.surname surname,c.address address,
						c.city city, c.province province, c.country country,c.pcode pcode,
						c.email email, c.telephone telephone, c.mobile mobile, c.fax fax,
						c.birthdate birthdate,
						c.receive_info receive_info,
						c.insurance_company insurance_company,
						c.ssn ssn,
						c.dni dni,
						c.deleted deleted,
						t.name titlename
					FROM #__vxc_customer c
					LEFT JOIN #__vxc_title t ON t.id = c.title
					WHERE c.id = ".$this->_id;			
			
			$this->_db->setQuery($sql);
			
			$row =& $this->_db->loadObject();
			
			if (!$row)
			{				
				$row = new stdClass();
				$row->id = 0;
				$row->localid = null;
				$row->user = null;			
				$row->name = null;
				$row->middlename = null;
				$row->surname = null;
				$row->address = null;
				$row->city = null;
				$row->email = null;
				$row->province = null;
				$row->country = null;
				$row->pcode = null;
				$row->telephone = null;
				$row->mobile = null;
                $row->dni = null;
				$row->fax = null;
				$row->receive_info = 0;
				$row->birthdate = null;
				$row->deleted = null;		
			}	
			$this->_item = $row;		
		}
		return $this->_item;
	
	
	}
	
	function store(&$post) {
		
		$row =& $this->getTable('customer');
		
		$row->reset();
		$id = (int)$post['id'];
		
		$row->load($id);
		if (!$row->bind($post))
			return false;
		
		if (!$row->check())
			return false;
		
		if (!$row->store(true))
			return false;		
		
		$this->SetId($row->id);		
		$post['id'] = $this->_id;
		return true;
	}

}

?>