<?
//--No direct access
defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

class vxcModelResourceTemplate extends JModel
{	
	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());	
	}
		
	function getResourceFromTemplate($template)
	{
		$sql = "SELECT r.id
				FROM #__vxc_resourcetemplate rt		
				LEFT JOIN #__vxc_resource r ON r.name = rt.resource_name
				WHERE rt.template_name = ". $this->_db->Quote($template) ;
		$this->_db->setQuery($sql);
		return $this->_db->loadResult();	
	
	}
		
	function getDataByResId($resId)
	{
		$sql = "SELECT rt.language language, rt.value value
				FROM #__vxc_resourcetranslation rt
				WHERE rt.resource = ". $this->_db->Quote($resId);
				
		$this->_db->setQuery($sql);
		return $this->_db->loadObjectList();	
	}	
	function getTranslation($resid)
	{
		$curLang =& JFactory::getLanguage();
		
		$sql = "SELECT rt.value  value
				FROM #__vxc_resourcetranslation rt
				LEFT JOIN #__languages l ON l.id = rt.language
				WHERE rt.resource = ". $this->_db->Quote($resid) . "
				 AND l.code = ". $this->_db->Quote($curLang->_lang);
		$this->_db->setQuery($sql);
		return $this->_db->loadResult();
	
	}
	
	function setTranslation($resid, $language, $translation)
	{
		if (!(int)$language || !$resid) return;
		$sql = "DELETE FROM #__vxc_resourcetranslation
				 WHERE resource = " . $this->_db->Quote($resid). 
				" AND language = ". $language;
				
		$this->_db->Execute($sql);

		$translation = trim($translation);
		if (!$translation) return;
		
		$sql = "INSERT INTO #__vxc_resourcetranslation(resource,language,value)
			VALUES (". $this->_db->Quote($resid).",$language,". $this->_db->Quote($translation).")";
				
		$this->_db->Execute($sql);
	
	
	}
	
}
?>