<?
// REVISADA 

//--No direct access
defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

class vxcModelAgencies extends JModel
{
	var $_data = null;

	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());
	}
	
	function _buildQuery()
	{	
		$userId = LegacyHelper::getUserId();
		
		$sql = "SELECT  a.id id,
						a.name name,
						fa.description description,
						fa.price price
					FROM #__vxc_agency a
					LEFT JOIN #__vxc_userfranchise uf ON uf.userid = ".$userId."
					LEFT JOIN #__vxc_franchiseagency fa ON fa.agency = a.id 
					LEFT JOIN #__vxc_useragencyexceptions ex ON ex.userid = ".$userId." AND ex.agency = a.id
					WHERE fa.franchise = uf.franchise AND NOT( fa.default_off XOR ex.userid IS NOT NULL )
					ORDER BY a.sorting ";
		
		
		$this->_query = $sql;			
			
		return $this->_query;	
	}	

	
	function getData() 
	{	
		if (!$this->_data)
		{
			$sql = $this->_buildQuery();		
			$this->_db->setQuery($sql);			
			$this->_data =& $this->_db->loadObjectList();	
		}
		
		return $this->_data;		
	}	
	
}
?>