<?

defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

define('NUM_RESOURCE_FOLDERS',255);

include_once(JPATH_BASE."/components/com_vxc/helpers/legacy.php");

class vxcModelResource extends JModel
{
	var $_id =null;
	var $_item;

	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());	
	}
	function SetId($id)
	{
		$this->_id = $id;
		$this->_item =null;
	}
	
	
	function store(&$data)
	{
	
		$db =& $this->_db;
		if ($data['id'])
		{
		
			$name= $db->Quote($data['name']);
			$sql = "UPDATE #__vxc_resource SET name = $name WHERE id = ".$data['id'];
			$db->Execute($sql);
			$this->SetId($data['id']);
		}
		else
		{
			$type = $data['type'];
			$user = $data['user'];
			$father= $data['father'];
			$name = $db->Quote($data['name']);
			$sql = "INSERT INTO #__vxc_resource(type,user,father, name)
						VALUES ($type,$user,$father,$name);";

			$db->Execute($sql);
			$this->SetId($db->insertid());
		}
			
	
	}

    function getTemplateFromName($resName)
    {
        $sql = "SELECT r.id id
				FROM #__vxc_resource r
				WHERE r.father = -2 AND r.name = ". $this->_db->Quote($resName) ;
        $this->_db->setQuery($sql);
        return $this->_db->loadResult();
    }

	function getResources()
	{
		$db =& $this->_db;				

		$userid = LegacyHelper::getUserId();
		$langObj =& JFactory::getLanguage();
		
		$coreDb =& JFactory::getDBO();
		
				
		$sql = "SELECT id	
				FROM #__languages
				WHERE code = ".$coreDb->Quote($langObj->_lang);
		$coreDb->setQuery($sql);		
		$languageId = $coreDb->loadResult();
		if (!$languageId) $languageId = 0;
		if (!$userid) $userid = 0;		
		$sql = "SELECT 
					r.id id, r.user user , r.father father, r.name name,
					ty.name tyname ,dt.name dtname,rt.value translation
				FROM #__vxc_resource r 				
				LEFT JOIN #__vxc_attributetype ty ON ty.id = r.type
				LEFT JOIN #__vxc_datatype dt ON dt.id = ty.datatype				
				LEFT JOIN #__vxc_resourcetranslation rt ON rt.resource = CONCAT('r',CAST(r.id AS CHAR)) AND rt.language = $languageId
				WHERE r.user IS NULL OR r.user = $userid ";
		
		$db->setQuery($sql);		
		$rows =& $db->loadObjectList();		
		return $rows;	
	}
	
	function getData()
	{		
		if (!$this->_id)
			$this->_id =0;
		
		if (empty($this->_item))
		{	
			$db =& $this->_db;
			$sql = "SELECT 
					r.id id, 
					r.user user , r.father father, 
					ty.name tyname ,dt.name dtname
				FROM #__vxc_resource r 				
				LEFT JOIN #__vxc_attributetype ty ON ty.id = r.type
				LEFT JOIN #__vxc_datatype dt ON dt.id = ty.datatype
				WHERE r.id = ".$this->_id;
			$db->setQuery($sql);
			$this->_item = $db->loadObject();
		
		}
		return $this->_item;
		
		
	
	}
	
	function Delete($id) {
		if (!$id) return;

		$db =&$this->_db;
		$sql = "DELETE FROM #__vxc_resource WHERE id = $id";
		$db->Execute($sql);	
	}
	
	static function GetFolder($resId)
	{
		$folder = ((int)$resId)%NUM_RESOURCE_FOLDERS;
        $dir = LegacyHelper::getResourceDir().'/'.$folder;
		@mkdir($dir,0777,true);		
		return $dir;
	}

    static function GetRFolder($resId)
    {
        $folder = ((int)$resId)%NUM_RESOURCE_FOLDERS;
        $dir = LegacyHelper::getResourceRDir().'/'.$folder;
        return $dir;
    }
	
	static function GetFilenames($resId,&$fileLeft,&$fileRight,&$fileExtra)	{
		$folder = vxcModelResource::GetFolder($resId);

        $fileLeft  = $folder.'/'.$resId.'_L';
        $fileRight = $folder.'/'.$resId.'_R';
        $fileExtra = $folder.'/'.$resId.'extra';
	}


    static function GetRFilenames($resId,&$fileLeft,&$fileRight,&$fileExtra)	{
        $folder = vxcModelResource::GetRFolder($resId);

        $fileLeft  = $folder.'/'.$resId.'_L';
        $fileRight = $folder.'/'.$resId.'_R';
        $fileExtra = $folder.'/'.$resId.'extra';
    }
	
	

}

?>