ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / sparklp6 / public_html / sparklerfilters-org / components / com_spsimpleportfolio / helpers

<?php

/**
* @package     SP Simple Portfolio
*
* @copyright   Copyright (C) 2010 - 2020 JoomShaper. All rights reserved.
* @license     GNU General Public License version 2 or later.
*/

defined('_JEXEC') or die();

class SpsimpleportfolioHelper {

public static function generateMeta($item = '') {
		return true;
	}

public static function getTags($ids) {
		
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		if(!is_array($ids)) {
			$ids = (array) json_decode($ids, true);
		}
		$ids = implode(',', $ids);
		$query->select($db->quoteName(array('id', 'title', 'alias')));
		$query->from($db->quoteName('#__spsimpleportfolio_tags'));
		$query->where($db->quoteName('id')." IN (" . $ids . ")");
		$query->order('id ASC');
		$db->setQuery($query);

return $db->loadObjectList();
	}

public static function getTagList($items) {
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		
		$tags = array();
		foreach ($items as $item) {
			$itemtags = json_decode( $item->tagids );
			foreach ($itemtags as $itemtag) {
				$tags[] = $itemtag;
			}
		}

$json = json_encode(array_unique($tags));
		$result = self::getTags( $json );

return $result;
	}

public static function getItemId($catid = 0)
	{
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select($db->quoteName(array('id', 'params')));
		$query->from($db->quoteName('#__menu'));
		$query->where($db->quoteName('link') . ' LIKE '. $db->quote('%option=com_spsimpleportfolio&view=items%'));
		$query->where($db->quoteName('client_id') . ' = '. $db->quote('0'));
		$query->where($db->quoteName('published') . ' = '. $db->quote('1'));
		$db->setQuery($query);
		$items = $db->loadObjectList();

$itemId = 0;
		if(!empty($items))
		{
			foreach($items as $item)
			{
				$params = json_decode($item->params);
				$itemId = $item->id;
				if($catid)
				{
					if( (isset($params->catid) && $params->catid) && $params->catid == $catid)
					{
						$itemId = $item->id;
						return '&Itemid=' . $itemId;
					}
				}
			}
		}

return '&Itemid=' . $itemId;
	}
}

[-] helper.php [edit]
[+] ..