.-.-.-.-.-

<?php

// No direct access
defined( '_JEXEC' ) or die;

/**
 * Class Module Helper
 * @author kirdinyuri
 */
class modZoocontractorsHelper
{

/**
	 * getData method
	 * @param $params
	 * @return array
	 */
	static function getData( $params )
	{
		$count='';
		$jinput = JFactory::getApplication()->input;
		
		jimport('imagecache.imagecache');
		$ImageCache = new ImageCache();
		
		jimport('zoolib.zoolib');
		$ZooLib = new ZooLib();
		
		
		$sql_cats=array();
		$cats=$ZooLib->get_cat_and_subcat($params->get('category',0));
		foreach ($cats as $item) $sql_cats[]='ci.category_id = "'.$item.'"';
		if ($sql_cats) $sql_cats=' and ('.implode(' or ',$sql_cats).')'; else $sql_cats='';
		
		$m=array();
		//$params->get('cost_alias_ru')
		$db = JFactory::getDbo();
		$sql="	SELECT 	i.id as id, 
						i.elements as elements 
				FROM 	jos_zoo_category_item ci, 
						jos_zoo_item i
				where 	ci.item_id=i.id {$sql_cats} and 
						i.state=1
				order by i.priority desc
				limit {$params->get('count',4)}";
		$db->setQuery($sql, 0, $count);
		$rows = $db->loadObjectList();
		
		if ($jinput->get( "sql", 0, 'INT' )==1) echo $sql;
		
		if (count($rows)<>0)
		foreach ($rows as $row)
		{
			$a=json_decode($row->elements, TRUE);
			if ($a['5be57ac5-7291-4859-8f60-f2ee8aa74e68']['file']<>'')
					{$imagepath=$ImageCache->ImageCacheJPG($a['5be57ac5-7291-4859-8f60-f2ee8aa74e68']['file'],'mod_zoocontractors',85,50,70);}
			$m[]='<div class="item-image"><a href="'.JRoute::_('/index.php?option=com_zoo&item_id='.$row->id.'&Itemid='.$params->get('menu').'&view=item').'">
					<img src="'.JRoute::_($imagepath).'"/>
				</a></div>';
		}
		
		
		return implode("\r\n",$m);
	}

}

/var/www/iplanru/data/./mod-tmp/../www/./../www/i-plan.ru/modules/mod_zoocontractors/helper.php