<?php
//--No direct access
defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

class vxcModelUserPrefabModel extends JModel
{

	var $_id = 0;
	var $_item = null;
	/**
	 * Constructor
	 *
	 * @access	public
	 * @return	void
	 */
	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());	
	}//function
				
	function SetId($id)
	{		
		$this->_id = (int)$id;
		$this->_item = null;
	}
	
	
	function store(&$data)
	{
		
		$table =& $this->getTable('userprefabmodel');				
		$db =& $this->_db;		
		
		$table->reset();
		$id = (int)$data['id'];
		
		$table->load($id);
		if (!$table->bind($data))
			return false;
		
		if (!$table->check())
			return false;
		
		if (!$table->store(true))
			return false;		
		
		$this->SetId($table->id);		
		$data['id'] = $this->_id;	
		
		return true;	
	}
	
	function deleteByData(&$data)
	{
		$userId = (int)$data['userid'];
		$modelId = (int) $data['prefabmodel'];
		
		
		if ($userId && $modelId)
		{
			$sql = "DELETE FROM #__vxc_userprefabmodel WHERE userid = $userId AND prefabmodel = $modelId ";
			
			$this->_db->Execute($sql);
		
		}
	
	}
	
	function getModelsByUser($userId)
	{
		$userId = (int)$userId;
		if (!$userId) return array();
		
				
		$db =& $this->_db;
		
		$sql = "SELECT pm.id id, pm.name
				FROM #__vxc_userprefabmodel upm
				LEFT JOIN #__vxc_prefabmodel pm ON pm.id = upm.prefabmodel
				WHERE upm.userid = ". $userId;
		$db->setQuery($sql);
		
		return $db->loadObjectList();
	}
	
	
	
	
}// class