Elep

<?php
/**
 * @copyright	Copyright (C) 2011 Simplify Your Web, Inc. All rights reserved.
 * @license		GNU General Public License version 3 or later; see LICENSE.txt
 */

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

use Joomla\CMS\Factory;
use Joomla\CMS\Access\Access;
use Joomla\CMS\Categories\Categories;
use Joomla\CMS\Component\ComponentHelper;
use Joomla\CMS\Language\Associations;
use Joomla\CMS\Language\Multilanguage;
use Joomla\CMS\Language\Text;
use Joomla\CMS\MVC\Model\BaseDatabaseModel;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\CMS\Router\Route;
use Joomla\CMS\Uri\Uri;
use Joomla\Registry\Registry;
use Joomla\CMS\Helper\TagsHelper;
use Joomla\CMS\HTML\HTMLHelper;

require_once (JPATH_SITE.'/components/com_content/helpers/route.php');
require_once (dirname(__FILE__).'/helper.php');

jimport('joomla.filesystem.folder');

jimport('syw.fields', JPATH_LIBRARIES);
jimport('syw.tags', JPATH_LIBRARIES);
jimport('syw.cache', JPATH_LIBRARIES);
jimport('syw.text', JPATH_LIBRARIES);
jimport('syw.utilities', JPATH_LIBRARIES);
jimport('syw.version', JPATH_LIBRARIES);

class modLatestNewsEnhancedExtendedHelperStandard
{
	/**
	 *
	 * @param unknown $params
	 * @param list of objects $items
	 * @throws Exception
	 * @return array of categories (id, description, article count)
	 */
	static function getCategoryList($params, $items)
	{
		$categories = array();

// get all categories and how many articles are in them
		foreach ($items as $item) {
			if (array_key_exists($item->catid, $categories)) {
				$categories[$item->catid]++;
			} else {
				$categories[$item->catid] = 1;
			}
		}

if ($params->get('show_cat_description', 0)) { // need description

$db = Factory::getDbo();

$query = $db->getQuery(true);

$query->select($db->quoteName('id'));
			$query->select($db->quoteName('description'));
			$query->from($db->quoteName('#__categories'));
			$query->where($db->quoteName('id') . ' IN (' . implode(',', array_keys($categories)) . ')');

$db->setQuery($query);

try {
				$categories_list = $db->loadObjectList('id');
			} catch (\DatabaseExceptionExecuting $e) {
			    Factory::getApplication()->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
				return null;
			}

foreach ($categories_list as $category) {
				$category->count = $categories[$category->id];
			}
		} else {
			$categories_list = array();

foreach ($categories as $key => $value) {
				$categories_list[$key] = (Object) array('id' => $key, 'count' => $value);
			}
		}

return $categories_list;
	}

static function getList($params, $module)
	{
	    $app = Factory::getApplication();

$db = Factory::getDbo();

$user = Factory::getUser();
		$groups = implode(',', $user->getAuthorisedViewLevels());

$nullDate = $db->quote($db->getNullDate());
		$nowDate = $db->quote(Factory::getDate()->toSql());

$jinput = $app->input;
		$option = $jinput->get('option');
		$view = $jinput->get('view');

if (!$params->get('show_on_item_page', 1)) {
			if ($option === 'com_content' && ($view === 'article' || $view === 'form')) {
				return null;
			}
		}

$item_on_page_id = '';
		$item_on_page_tagids = array();
		$item_on_page_keys = array();
		$item_on_page_user = '';

$related = (string) $params->get('related', '0'); // 0: no, 1: keywords, 2: tags articles only, 3: tags any content

if ($related == '1') { // related by keyword

if ($option === 'com_content' && $view === 'article') {
				$temp = $jinput->getString('id');
				$temp = explode(':', $temp);
				$item_on_page_id = $temp[0];
			}

if ($item_on_page_id) {
			    
			    $query = $db->getQuery(true);

$query->select($db->quoteName('metakey'));
				$query->from($db->quoteName('#__content'));
				$query->where($db->quoteName('id') . ' = ' . (int) $item_on_page_id);

$db->setQuery($query);

try {
					$result = $db->loadResult();
				} catch (\DatabaseExceptionExecuting $e) {
					$app->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
					return null;
				}

$result = trim($result);
				if (empty($result)) {
					return array(); // won't find a related article if no key is present
				}

$keys = explode(',', $result);

// assemble any non-blank word(s)
				foreach ($keys as $key) {
					$key = trim($key);
					if ($key) {
						$item_on_page_keys[] = $key;
					}
				}

if (empty($item_on_page_keys)) {
					return array();
				}
			} else {
				return null; // no result (was not on article page)
			}

} else if ($related == '2' || $related == '3') { // related by tag

$get_the_tags = false;
			if ($related == '2' && $option === 'com_content' && $view === 'article') {
				$get_the_tags = true;
			} else if ($related == '3') { // no restriction on the type of content
				$get_the_tags = true;

if ($option === 'com_trombinoscopeextended' && $view === 'contact') { // because tags are recorded with com_contact
					$option = 'com_contact';
				}
			}

if ($get_the_tags) {
				$temp = $jinput->getString('id');
				$temp = explode(':', $temp);
				$item_on_page_id = $temp[0];

if ($item_on_page_id) {
					$helper_tags = new TagsHelper();
					$tag_objects = $helper_tags->getItemTags($option.'.'.$view, $item_on_page_id); // array of tag objects
					foreach ($tag_objects as $tag_object) {
						$item_on_page_tagids[] = $tag_object->tag_id;
					}
				}

if (empty($item_on_page_tagids)) {
					return array(); // no result because no tag found for the object on the page
				}
			} else {
				return null; // no result (was not on article page)
			}

} else if ($related == 'contact') { // related to the contact (who needs to be linked to a user)

if (($option === 'com_contact' || $option === 'com_trombinoscopeextended') && $view === 'contact' && $jinput->get('id')) {

$query = $db->getQuery(true);

$query->select($db->quoteName('user_id'));
				$query->from($db->quoteName('#__contact_details'));
				$query->where($db->quoteName('id') . ' = ' . (int) $jinput->getInt('id'));

$db->setQuery($query);

try {
					$item_on_page_user = $db->loadResult();
				} catch (\DatabaseExceptionExecuting $e) {
					$item_on_page_user = '';
				}
			}
			
			if (empty($item_on_page_user)) {
				return null;
			}

} else if ($related == 'cb_user_profile') { // related to the Community Builder user

if ($option === 'com_comprofiler' && $view === 'userprofile') {

// match the module access to the profile view access level manually
				// CB does not provide a standard way to get com_comprofiler config params

if ($jinput->get('user')) {
					$item_on_page_user = (int) $jinput->getInt('user');
				} else {
					$item_on_page_user = (int) Factory::getUser()->get('id'); // necessary?
				}
			} else {
				return null;
			}
		}

// START OF DATABASE QUERY
		
		$query = $db->getQuery(true);

$fulltext_query = false;
		if (($params->get('link_to', 'item') == 'item' && $params->get('link_target', 'default') == 'inline') || ($params->get('search_fulltext', 0) && ($params->get('head_type', 'none') == 'image' || $params->get('head_type', 'none') == 'allimagesasc' || $params->get('head_type', 'none') == 'allimagesdesc'))) {
			$fulltext_query = true;
		}

$subquery1 = ' CASE WHEN ';
		$subquery1 .= $query->charLength('a.alias');
		$subquery1 .= ' THEN ';
		$a_id = $query->castAsChar('a.id');
		$subquery1 .= $query->concatenate(array($a_id, 'a.alias'), ':');
		$subquery1 .= ' ELSE ';
		$subquery1 .= $a_id.' END AS slug';

$subquery2 = ' CASE WHEN ';
		$subquery2 .= $query->charLength('c.alias');
		$subquery2 .= ' THEN ';
		$c_id = $query->castAsChar('c.id');
		$subquery2 .= $query->concatenate(array($c_id, 'c.alias'), ':');
		$subquery2 .= ' ELSE ';
		$subquery2 .= $c_id.' END AS cat_slug';

$query->select($db->quoteName(array('a.id', 'a.catid', 'a.title', 'a.alias', 'a.introtext', 'a.state', 'a.images', 'a.urls', 'a.attribs', 'a.metadata', 'a.metakey', 'a.metadesc', 'a.access', 'a.hits', 'a.featured', 'a.language')));
		if ($fulltext_query) {
		    $query->select($db->quoteName('a.fulltext'));
		}

$query->select('CASE WHEN ' . $db->quoteName('a.fulltext') . ' IS NULL OR ' . $db->quoteName('a.fulltext') . ' = ' . $db->quote('') . ' THEN 0 ELSE 1 END AS ' . $db->quoteName('fulltexthascontent'));

$query->select($db->quoteName(array('a.checked_out', 'a.checked_out_time', 'a.created', 'a.created_by', 'a.created_by_alias')));

// Use created if modified is 0
		$query->select('CASE WHEN ' . $db->quoteName('a.modified') . ' = ' . $nullDate . ' THEN ' . $db->quoteName('a.created') . ' ELSE ' . $db->quoteName('a.modified') . ' END AS ' . $db->quoteName('modified'));
		$query->select($db->quoteName(array('a.modified_by', 'uam.name'), array('modified_by', 'modified_by_name')));

// Use created if publish_up is 0
		$query->select('CASE WHEN ' . $db->quoteName('a.publish_up') . ' = ' . $nullDate . ' THEN ' . $db->quoteName('a.created') . ' ELSE ' . $db->quoteName('a.publish_up') . ' END AS  ' . $db->quoteName('publish_up'));
		$query->select($db->quoteName('a.publish_down'));

$query->select($subquery1);
		$query->select($subquery2);

$query->from($db->quoteName('#__content', 'a'));

// join over the categories
		$query->select($db->quoteName(array('c.title', 'c.path', 'c.access', 'c.alias'), array('category_title', 'category_route', 'category_access', 'category_alias')));
		$query->join('LEFT', $db->quoteName('#__categories', 'c') . ' ON ' . $db->quoteName('c.id') . ' = ' . $db->quoteName('a.catid'));

// join over the users for the author and modified_by names
		switch ($params->get('show_a', 'alias')) {
		    case 'full': $query->select($db->quoteName('ua.name', 'author')); break;
		    case 'user': $query->select($db->quoteName('ua.username', 'author')); break;
		    default: $query->select('CASE WHEN ' . $db->quoteName('a.created_by_alias') . ' > ' . $db->quote(' ') . ' THEN ' . $db->quoteName('a.created_by_alias') . ' ELSE ' . $db->quoteName('ua.name') . ' END AS ' . $db->quoteName('author'));
		}

$query->select($db->quoteName('ua.email', 'author_email'));

$query->join('LEFT', $db->quoteName('#__users', 'ua') . ' ON ' . $db->quoteName('ua.id') . ' = ' . $db->quoteName('a.created_by'));
		$query->join('LEFT', $db->quoteName('#__users', 'uam') . ' ON ' . $db->quoteName('uam.id') . ' = ' . $db->quoteName('a.modified_by'));

// join over the categories to get parent category titles
		$query->select($db->quoteName(array('parent.title', 'parent.id', 'parent.path', 'parent.alias'), array('parent_title', 'parent_id', 'parent_route', 'parent_alias')));
		$query->join('LEFT', $db->quoteName('#__categories', 'parent') . ' ON ' . $db->quoteName('parent.id') . ' = ' . $db->quoteName('c.parent_id'));

$query->where($db->quoteName('c.published') . ' = 1');

// join on voting table
		// keep it to allow users to add their information types for rating
        $query->select('ROUND(' . $db->quoteName('v.rating_sum') . ' / ' . $db->quoteName('v.rating_count') . ', 1) AS ' . $db->quoteName('rating'));
        $query->select($db->quoteName('v.rating_count', 'rating_count'));
        $query->join('LEFT', $db->quoteName('#__content_rating', 'v') . ' ON ' . $db->quoteName('a.id') . ' = ' . $db->quoteName('v.content_id'));

// access filter

$authorised = Access::getAuthorisedViewLevels(Factory::getUser()->get('id'));

$show_unauthorized_items = $params->get('show_unauthorized', 0);

if (!$show_unauthorized_items) { // show authorized items only
		    $query->where($db->quoteName('a.access') . ' IN (' . $groups . ')');
		    $query->where($db->quoteName('c.access') . ' IN (' . $groups . ')');
		}

// filter by start and end dates

$postdate = $params->get('post_d', 'published');

if (strpos($postdate, 'jfield:') !== false) {
			$cfield_array = explode(':', $postdate);
			$postdate = 'jfield';

$query->select('cf_v.value');
			$query->join('LEFT', '#__fields_values AS cf_v ON cf_v.item_id = a.id');
			$query->where($db->quoteName('cf_v.field_id').' = ' . $cfield_array[2]);
		}

if ($postdate == 'pending') {
			$query->where($db->quoteName('a.publish_up') . ' > ' . $nowDate);
		} else if ($postdate != 'fin_pen') {
		    $query->where('(' . $db->quoteName('a.publish_up') . ' = ' . $nullDate . ' OR ' . $db->quoteName('a.publish_up') . ' <= ' . $nowDate . ')');
		}

$query->where('(' . $db->quoteName('a.publish_down') . ' = ' . $nullDate . ' OR ' . $db->quoteName('a.publish_down') . ' >= ' . $nowDate . ')');

// filter by date range

switch ($postdate)
		{
			case 'created' : $dateField = 'a.created'; break;
			case 'modified' : $dateField = 'a.modified'; break;
			case 'finished' : case 'fin_pen' : /*case 'pending' :*/ $dateField = 'a.publish_down'; break;
			case 'jfield' : $dateField = 'cf_v.value'; break;
			default: $dateField = 'a.publish_up';
		}

$query->select($db->quoteName($dateField, 'date'));

switch ($params->get('use_range', 0))
		{
			case 1: // relative

// parameters are reversed (backward compatibility from early on version)

$range_from = $params->get('range_to', 'week'); // now, day, week, month, year options
			    $spread_from = $params->get('spread_to', 1);
			    $range_to = $params->get('range_from', 'now');
			    $spread_to = $params->get('spread_from', 1);

// test range 'from' and 'to' to see if it will be a future or a past range

$from = 0;
			    switch($range_from)
			    {
			        case 'day': $from += $spread_from; break;
			        case 'week': $from += $spread_from * 7; break;
			        case 'month': $from += $spread_from * 30; break; // arbitrary
			        case 'year': $from += $spread_from * 365; break; // arbitrary
			    }

$to = 0;
			    switch($range_to)
			    {
			        case 'day': $to += $spread_to; break;
			        case 'week': $to += $spread_to * 7; break;
			        case 'month': $to += $spread_to * 30; break; // arbitrary
			        case 'year': $to += $spread_to * 365; break; // arbitrary
			    }

if ($from < 0 && $to < 0 && $from <= $to) {
			    	// dates in the past (-3 to -2 months for instance)
		            $query->where($db->quoteName($dateField) . ' >= DATE_SUB(' . $nowDate . ', INTERVAL ' . abs($spread_from) . ' ' . $range_from . ')');
		            $query->where($db->quoteName($dateField) . ' <= DATE_SUB(' . $nowDate . ', INTERVAL ' . abs($spread_to) . ' ' . $range_to . ')');
			    }

if ($from < 0 && $to == 0) {
			    	// dates in the past (the last 2 months for instance)
		            $query->where($db->quoteName($dateField) . ' >= DATE_SUB(' . $nowDate . ', INTERVAL ' . abs($spread_from) . ' ' . $range_from . ')');
		            $query->where($db->quoteName($dateField) . ' <= ' . $nowDate);
			    }

if ($from < 0 && $to > 0) {
			    	// dates in the past and in the future (the last month to the next 2 months for instance)
		            $query->where($db->quoteName($dateField) . ' >= DATE_SUB(' . $nowDate . ', INTERVAL ' . abs($spread_from) . ' ' . $range_from . ')');
		            $query->where($db->quoteName($dateField) . ' <= DATE_ADD(' . $nowDate . ', INTERVAL ' . $spread_to . ' ' . $range_to . ')');
			    }

if ($from >= 0 && $to >= 0) {
			    	if ($from > $to) {
			    		// past dates
		        	    $query->where($db->quoteName($dateField) . ' >= DATE_SUB(' . $nowDate . ', INTERVAL ' . $spread_from . ' ' . $range_from . ')');
			    		if ($to == 0) {
		        		    $query->where($db->quoteName($dateField) . ' <= ' . $nowDate);
			    		} else {
		        		    $query->where($db->quoteName($dateField) . ' <= DATE_SUB(' . $nowDate . ', INTERVAL ' . $spread_to . ' ' . $range_to . ')');
			    		}
			    	} elseif ($from < $to) {
			    		// future dates
		        	    $query->where($db->quoteName($dateField) . ' <= DATE_ADD(' . $nowDate . ', INTERVAL ' . $spread_to . ' ' . $range_to . ')');
			    		if ($from == 0) {
		        		    $query->where($db->quoteName($dateField) . ' >= ' . $nowDate);
			    		} else {
		        		    $query->where($db->quoteName($dateField) . ' >= DATE_ADD(' . $nowDate . ', INTERVAL ' . $spread_from . ' ' . $range_from . ')');
			    		}
			    	} else {
			    		// $from and $to are equal
			    		if ($to == 0) {
		        		    $query->where($db->quoteName($dateField) . ' = ' . $nowDate);
			    		} else {
		        		    $query->where($db->quoteName($dateField) . ' = DATE_ADD(' . $nowDate . ', INTERVAL ' . $spread_from . ' ' . $range_from . ')');
			    		}
			    	}
			    }

break;

case 2: // range
				$startDateRange = $db->quote($params->get('start_date_range', $db->getNullDate()));
				$endDateRange = $db->quote($params->get('end_date_range', $db->getNullDate()));
				$query->where('(' . $db->quoteName($dateField) . ' >= ' . $startDateRange . ' AND ' . $db->quoteName($dateField) . ' <= ' . $endDateRange . ')');
			break;
		}

// category filter

$categories_array = $params->get('catid', array());

$array_of_category_values = array_count_values($categories_array);
		if (isset($array_of_category_values['all']) && $array_of_category_values['all'] > 0) { // 'all' was selected therefore no filtering
			// take everything, so no category selection
		} else {
			if (isset($array_of_category_values['auto']) && $array_of_category_values['auto'] > 0) { // 'auto' was selected

$categories_array = array();

if ($option === 'com_content') {
					switch($view)
					{
						case 'categories':
							$categories_array[] = $jinput->getInt('id'); // id is the top-level category (can be 0 if 'root' has been selected)
						break;
						case 'category':
							$categories_array[] = $jinput->getInt('id');
						break;
						case 'article':
							$article_id = $jinput->getInt('id');
							$catid = $jinput->getInt('catid');

if (!$catid) {
								// Get an instance of the generic article model
								$article = BaseDatabaseModel::getInstance('Article', 'ContentModel', array('ignore_request' => true));

$article->setState('params', $app->getParams());
								$article->setState('filter.published', 1);
								$article->setState('article.id', (int) $article_id);
								$item = $article->getItem();
								$categories_array[] = $item->catid;
							} else {
								$categories_array[] = $catid;
							}
						break;
					}
				}

if (empty($categories_array)) {
					return null; // no result if not in the category page
				}
			}

if (!empty($categories_array)) {

$categories_ids_array = array();
			    foreach ($categories_array as $category_id) {
			        $categories_ids_array[$category_id] = array($category_id);
			    }

// sub-category inclusion
				$get_sub_categories = $params->get('includesubcategories', 'no');
				if ($get_sub_categories != 'no') {

$levels = $params->get('levelsubcategories', 1);

if (!$show_unauthorized_items) {
						$categories_object = Categories::getInstance('Content');
					} else {
						$categories_object = Categories::getInstance('Content', array('access' => false));
					}
					foreach ($categories_array as $category_id) {
						$category_object = $categories_object->get($category_id); // if category unpublished, unset
						if (isset($category_object) && $category_object->hasChildren()) {

$sub_categories_array = $category_object->getChildren(true); // get all levels recursively
							foreach ($sub_categories_array as $subcategory_object) {
								$condition = ($get_sub_categories == 'all' || ($subcategory_object->level - $category_object->level) <= $levels);
								if ($condition) {
									//$categories_array[] = $subcategory_object->id;
								    $categories_ids_array[$category_id][] = $subcategory_object->id;
								}
							}
						}
					}

//$categories_array = array_unique($categories_array);
					$final_categories_array = array();
					foreach ($categories_array as $category_id) {
					    $final_categories_array = array_merge($final_categories_array, $categories_ids_array[$category_id]);
					}

$categories_array = array_unique($final_categories_array);
				}

// compatibility CW multicategories
				if (\JFolder::exists(JPATH_ADMINISTRATOR . '/components/com_multicats') && ComponentHelper::isEnabled('com_multicats')) {

// - item_id links to article ID
				    // - catid - comma separated list of catids assigned to article

$query->join('LEFT', $db->quoteName('#__multicats_content_catid', 'mc') . ' ON ' . $db->quoteName('mc.item_id') . ' = ' . $db->quoteName('a.id'));
				    //$query->where('FIND_IN_SET('.$categoryID.',mc.catid)');
				    // find_in_set('a', 'a,b,c,d') OR find_in_set('b', 'a,b,c,d') OR find_in_set('b', 'a,b,c,d')
				    $query->where('CONCAT(",", ' . $db->quoteName('mc.catid') . ', ",") REGEXP ",(' . implode('|', $categories_array) . '),"');

} else {
				    $test_type = $params->get('cat_inex', 1) ? 'IN' : 'NOT IN';
					$query->where($db->quoteName('a.catid') . ' ' . $test_type . ' (' . implode(',', $categories_array) . ')');
				}
			}
		}

// metakeys filter

$metakeys = array();
		$keys = array_filter(explode(',', trim($params->get('keys', ''), ' ,')));
		
		// assemble any non-blank word(s)
		foreach ($keys as $key) {
			$metakeys[] = trim($key);
		}

if (!empty($item_on_page_keys)) {
			if (!empty($metakeys)) { // if none of the tags we filter are in the content item on the page, return nothing

$keys_in_common = array_intersect($item_on_page_keys, $metakeys);
				if (empty($keys_in_common)) {
					return array();
				}

$metakeys = $keys_in_common;

} else {
				$metakeys = $item_on_page_keys;
			}
		}

if (!empty($metakeys)) {
			$concat_string = $query->concatenate(array('","', ' REPLACE(a.metakey, ", ", ",")', ' ","')); // remove single space after commas in keywords
			
			//$query->where('('.$concat_string.' LIKE "%'.implode('%" OR '.$concat_string.' LIKE "%', $metakeys).'%")');
			
			$query_meta_array = array();
			foreach ($metakeys as $key) {
			    $query_meta_array[] = $concat_string . ' LIKE ' . $db->quote('%' . $db->escape($key, true) . '%');
			}
			
			$query->where('(' . implode(' OR ', $query_meta_array) . ')');
		}

// tags filter

$tags = $params->get('tags', array());

if (!empty($tags)) {

// if all selected, get all available tags
			$array_of_tag_values = array_count_values($tags);
			if (isset($array_of_tag_values['all']) && $array_of_tag_values['all'] > 0) { // 'all' was selected
				$tags = array();
				$tag_objects = SYWTags::getTags('com_content.article');
				if ($tag_objects !== false) {
					foreach ($tag_objects as $tag_object) {
						$tags[] = $tag_object->id;
					}
				}

if (empty($tags) && $params->get('tags_inex', 1)) { // won't return any article if no article has been associated to any tag (when include tags only)
					return array();
				}
			} else if ($params->get('include_tag_children', 0)) { // get tag children

$tagTreeArray = array();
				$helper_tags = new TagsHelper();

foreach ($tags as $tag) {
					$helper_tags->getTagTreeArray($tag, $tagTreeArray);
				}

$tags = array_unique(array_merge($tags, $tagTreeArray));
			}
		}

if (!empty($item_on_page_tagids)) {
			if (!empty($tags)) { // if none of the tags we filter are in the content item on the page, return nothing

// take the tags common to the item on the page and the module selected tags
				$tags_in_common = array_intersect($item_on_page_tagids, $tags);
				if (empty($tags_in_common)) {
					return array();
				}

if ($params->get('tags_match', 'any') == 'all') {
					if (count($tags_in_common) != count($tags)) {
						return array();
					}
				}

$tags = $tags_in_common;

} else {
				$tags = $item_on_page_tagids;
			}

// Note: does not work if 'exclude' tags, which is normal
		}

if (!empty($tags)) {

$tags_to_match = implode(',', $tags);

$query->select('COUNT(' . $db->quoteName('tags.id') . ') AS tags_count');
			$query->join('INNER', $db->quoteName('#__contentitem_tag_map', 'm') . ' ON ' . $db->quoteName('m.content_item_id') . ' = ' . $db->quoteName('a.id') . ' AND ' . $db->quoteName('m.type_alias') . ' = ' . $db->quote('com_content.article'));
			$query->join('INNER', $db->quoteName('#__tags', 'tags') . ' ON ' . $db->quoteName('m.tag_id') . ' = ' . $db->quoteName('tags.id'));
			$query->where($db->quoteName('tags.access') . ' IN (' . $groups . ')');
			$query->where($db->quoteName('tags.published') . ' = 1');

// keep all items with tags to be handled outside the query (when exclude any X or exclude all)
			if (!$params->get('tags_inex', 1) && (($params->get('tags_match', 'any') == 'any' && ($params->get('any_count_min', 1) > 1 || ($params->get('any_count_min', 1) == 1 && trim($params->get('any_count_max', '')) != ''))) || ($params->get('tags_match', 'any') == 'all'))) {
				// keep all tags
			} else {
				$test_type = $params->get('tags_inex', 1) ? 'IN' : 'NOT IN';
				$query->where($db->quoteName('tags.id') . ' ' . $test_type . ' (' . $tags_to_match . ')');
			}

if (($params->get('tags_match', 'any') == 'any' && ($params->get('any_count_min', 1) > 1 || ($params->get('any_count_min', 1) == 1 && trim($params->get('any_count_max', '')) != '')))
				|| (!$params->get('tags_inex', 1) && $params->get('tags_match', 'any') == 'all')) {
				// handled outside the query
			} else {
				if (!$params->get('tags_inex', 1)) { // EXCLUDE TAGS
					$query->select('tags_per_items.tag_count_per_item');
				    
				    $subquery = $db->getQuery(true);

// subquery gets all the tags for all items
					$subquery->select($db->quoteName('mm.content_item_id', 'content_id'));
					$subquery->select('COUNT(' . $db->quoteName('tt.id') . ') AS tag_count_per_item');
					$subquery->from($db->quoteName('#__contentitem_tag_map', 'mm'));
					$subquery->join('INNER', $db->quoteName('#__tags', 'tt') . ' ON ' . $db->quoteName('mm.tag_id') . ' = ' . $db->quoteName('tt.id'));
					$subquery->where($db->quoteName('tt.access') . ' IN (' . $groups . ')');
					$subquery->where($db->quoteName('tt.published') . ' = 1');
					$subquery->where($db->quoteName('mm.type_alias') . ' = ' . $db->quote('com_content.article'));
					$subquery->group($db->quoteName('content_id'));

$query->join('INNER', '(' . (string) $subquery . ') AS tags_per_items ON ' . $db->quoteName('tags_per_items.content_id') . ' = ' . $db->quoteName('a.id'));

// we keep items that have the same amount of tags before and after removals
					$query->having('COUNT(' . $db->quoteName('tags.id') . ') = ' . $db->quoteName('tags_per_items.tag_count_per_item'));
				} else { // INCLUDE TAGS
					if ($params->get('tags_match', 'any') == 'all') {
						$query->having('COUNT(' . $db->quoteName('tags.id') . ') = ' . count($tags));
					}
				}
			}

$query->group($db->quoteName('a.id'));
		}

// custom field filters

$customfield_filters_arrays = array();

$customfield_filters = $params->get('customfieldsfilter'); // string (if default), array or object

if (!empty($customfield_filters) && !is_string($customfield_filters)) {

foreach ($customfield_filters as $customfield_filter) {

$customfield_filter = (array)$customfield_filter;

if ($customfield_filter['field'] !== 'none') {

$values = explode(',', $customfield_filter['values']);
		            foreach ($values as $key => $value) {
		                $value = trim($value);
		                if (empty($value)) {
		                    unset($values[$key]);
		                }
		            }

if (!empty($values)) {
		                $customfield_filters_arrays[] = array('id' => $customfield_filter['field'], 'values' => $values, 'inex' => $customfield_filter['inex']);
		            }
		        }
		    }
		}

if (!empty($customfield_filters_arrays)) {

$article_id_arrays_from_cfields = array();

foreach ($customfield_filters_arrays as $customfield_filter) {

$subQuery = $db->getQuery(true);

$subQuery->select('DISTINCT ' . $db->quoteName('cfv.item_id')); // no unique results when joining with categories
	            $subQuery->from($db->quoteName('#__fields_values', 'cfv'));
	            $subQuery->join('LEFT', $db->quoteName('#__fields', 'f') . ' ON ' . $db->quoteName('f.id') . ' = ' . $db->quoteName('cfv.field_id'));
	            $subQuery->where('(' . $db->quoteName('f.context') . ' IS NULL OR ' . $db->quoteName('f.context') . ' = ' . $db->quote('com_content.article') . ')');
	            $subQuery->where('(' . $db->quoteName('f.state') . ' IS NULL OR ' . $db->quoteName('f.state') . ' = 1)');
	            $subQuery->where('(' . $db->quoteName('f.access') . ' IS NULL OR ' . $db->quoteName('f.access') . ' IN (' . $groups . '))');
	            $subQuery->where($db->quoteName('cfv.field_id').' = ' . (int) $customfield_filter['id']);

if ($customfield_filter['inex']) {
	               $subQuery->where($db->quoteName('cfv.value') . " = '" . implode("' OR " . $db->quoteName('cfv.value') . " = '", $customfield_filter['values']) . "'");
	            } else {
	                $subQuery->where($db->quoteName('cfv.value') . " <> '" . implode("' AND " . $db->quoteName('cfv.value') . " <> '", $customfield_filter['values']) . "'");
	            }

if ($params->get('filter_lang', 1) && Multilanguage::isEnabled()) {
	                $subQuery->where('(' . $db->quoteName('f.language') . ' IS NULL OR ' . $db->quoteName('f.language') . ' IN (' . $db->quote(Factory::getLanguage()->getTag()) . ',' . $db->quote('*') . '))');
	            }

$db->setQuery($subQuery);

try {
	                $article_id_arrays_from_cfields[] = $db->loadColumn();
	            } catch (\DatabaseExceptionExecuting $e) {
	                Factory::getApplication()->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
	            }
		    }

if (!empty($article_id_arrays_from_cfields)) {

// keep only the ids found in all the arrays
	            if (count($article_id_arrays_from_cfields) > 1) {
	                $article_ids = call_user_func_array('array_intersect', $article_id_arrays_from_cfields);
	            } else {
	                $article_ids = $article_id_arrays_from_cfields[0];
	            }

if (!empty($article_ids)) {
	                $query->where($db->quoteName('a.id') . ' IN (' . implode(',', $article_ids) . ')'); // include all articles that have custom field value(s) that correspond to the custom field value
	            } else {
	                $query->where($db->quoteName('a.id') . ' = 0'); // no article having all values selected
	            }
	        }
		}

// user filter

$include = $params->get('author_inex', 1);
		$authors_array = $params->get('created_by', array());

// old parameter - backward compatibility
		$old_authors = $params->get('user_id', '');
		if ($old_authors) {
			switch ($old_authors)
			{
				case 'by_me': $include = true; $authors_array[] = 'auto'; break;
				case 'not_me': $include = false; $authors_array[] = 'auto'; break;
				case 'all': default: $authors_array[] = 'all';
			}
		}
		
		$where_state = 'a.state = 1';
		$where_createdby = '';

$array_of_authors_values = array_count_values($authors_array);
		if (isset($array_of_authors_values['all']) && $array_of_authors_values['all'] > 0) { // 'all' was selected

if ($item_on_page_user) {
			    $where_createdby = 'a.created_by = '.$item_on_page_user;
				if ($params->get('allow_edit', 0) && $item_on_page_user == $user->get('id')) {
				    $where_state = 'a.state IN (0, 1)';
				}
			} else {
			    $test_type = $include ? '>' : '<';
			    $where_createdby = 'a.created_by ' . $test_type . ' 0'; // necessary so that the OR match returns good results
			    if ($params->get('allow_edit', 0) && (int)$user->get('id') > 0) {
					if ($user->authorise('core.edit', 'com_content')) {
						// logged user can see everyone's unpublished articles
					    $where_state = 'a.state IN (0, 1)';
					} else {
						// logged user can see his own unpublished articles only
					    $where_state = '(a.state = 1) OR (a.state = 0 AND a.created_by = ' . (int) $user->get('id') . ')';
					}
				}
			}
		} else if (isset($array_of_authors_values['realauto']) && $array_of_authors_values['realauto'] > 0) { // 'realauto' was selected: check if author on page, if so, select it

$found = false;
			if ($option === 'com_content' && $view === 'article') {
				$temp = $jinput->getString('id');
				$temp = explode(':', $temp);
				if ($temp[0]) {
					
					$subquery = $db->getQuery(true);

$subquery->select($db->quoteName('created_by'));
					$subquery->from($db->quoteName('#__content'));
					$subquery->where($db->quoteName('id') . ' = ' . (int) $temp[0]);

$db->setQuery($subquery);
					
					try {
						$result = $db->loadResult();
						if ($result) {
							$found = true;
							$test_type = $include ? '=' : '<>';
							$where_createdby = 'a.created_by' . $test_type . $result;
							
							if ($include && $params->get('allow_edit', 0) && (int)$user->get('id') === $result) {
							    $where_state = 'a.state IN (0, 1)'; // show all articles for the logged author, published or not
							}
						}
					} catch (\DatabaseExceptionExecuting $e) {
						$app->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
						return null;
					}
				}
			}
			
			if (!$found) {
				return array();
			}

} else if (isset($array_of_authors_values['auto']) && $array_of_authors_values['auto'] > 0) { // 'auto' was selected: equivalent to check if the author is logged in

$logged_user = (int) $user->get('id');

if ($item_on_page_user) {
			    if (($include && $logged_user != $item_on_page_user) || (!$include && $logged_user == $item_on_page_user)) {
			        return null;
			    }
			    
			    $where_createdby = 'a.created_by = '.$item_on_page_user;

if ($params->get('allow_edit', 0) && $item_on_page_user == $user->get('id')) {
			        $where_state = 'a.state IN (0, 1)';
			    }
			} else {
				$test_type = $include ? '=' : '<>';
				$where_createdby = 'a.created_by ' .$test_type.' '.$logged_user;

if ($include && $params->get('allow_edit', 0) && $logged_user > 0) {
				    $where_state = 'a.state IN (0, 1)'; // show all articles for the logged author, published or not
				}
			}

} else {

if ($item_on_page_user) {
			    if (($include && !in_array($item_on_page_user, $authors_array)) || (!$include && in_array($item_on_page_user, $authors_array))) {
			        return null;
			    }
			    
			    $where_createdby = 'a.created_by = '.$item_on_page_user;
			    
			    if ($params->get('allow_edit', 0) && $item_on_page_user == $user->get('id')) {
			        $where_state = 'a.state IN (0, 1)';
			    }
			} else {
				$authors = implode(',', $authors_array);
				if ($authors) {
					$test_type = $include ? 'IN' : 'NOT IN';
					$where_createdby = 'a.created_by '.$test_type.' ('.$authors.')';
				}

if ($params->get('allow_edit', 0) && (int)$user->get('id') > 0) {
					if ($user->authorise('core.edit', 'com_content')) {
						// logged user can see everyone's unpublished articles
					    $where_state = 'a.state IN (0, 1)';
					} else {
					    if (($include && in_array($user->get('id'), $authors_array)) || (!$include && !in_array($user->get('id'), $authors_array))) {
							// logged user can see his own unpublished articles only
							$where_state = '(a.state = 1) OR (a.state = 0 AND a.created_by = ' . (int) $user->get('id') . ')';
						}
					}
				}
			}
		}

// author alias filter
		
		$include = $params->get('author_alias_inex', 1);
		$authors_array = $params->get('created_by_alias', array());
		$author_match = (int)$params->get('author_match', 0);

$where_createdbyalias = '';
		
		if ($author_match > 0 && count($authors_array) > 0) {
		
    		$array_of_authors_values = array_count_values($authors_array);
    		
    		if (isset($array_of_authors_values['all']) && $array_of_authors_values['all'] > 0) { // 'all' was selected
    		    
    		    if ($include) {
    		        $where_createdbyalias = 'a.created_by_alias != ' . $db->quote('');
    		    } else {
    		        $where_createdbyalias = 'a.created_by_alias = ' . $db->quote('');
    		    }
    		
    		} else if (isset($array_of_authors_values['auto']) && $array_of_authors_values['auto'] > 0) { // 'auto' was selected: check if author alias on page, if so, select it
    		
    		    $found = false;
    		    if ($option === 'com_content' && $view === 'article') {
    		        $temp = $jinput->getString('id');
    		        $temp = explode(':', $temp);
    		        if ($temp[0]) {
    		            
    		            $subquery = $db->getQuery(true);

$subquery->select($db->quoteName('created_by_alias'));
    		            $subquery->from($db->quoteName('#__content'));
    		            $subquery->where($db->quoteName('id') . ' = ' . (int) $temp[0]);
    		            
    		            $db->setQuery($subquery);
    		            
    		            try {
    		                $result = $db->loadResult();
    		                if ($result) {
    		                    $found = true;
    		                    $test_type = $include ? '=' : '!=';
    		                    $where_createdbyalias = 'a.created_by_alias' . $test_type . $db->quote($result);
    		                    if (!$include) {
    		                        $where_createdbyalias .= ' AND a.created_by_alias != ' . $db->quote('');
    		                    }
    		                }
    		            } catch (\DatabaseExceptionExecuting $e) {
    		                $app->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
    		                return null;
    		            }
    		        }
        		}
    		    
    		    if (!$found) {
    		        return array();
    		    }
    		
    		} else {
    		    $quoted_array = array();
    		    foreach ($authors_array as $author) {
    		        $quoted_array[] = $db->quote($author);
    		    }
    		    
    		    $authors = implode(',', $quoted_array);
    		    if ($authors) {
    		        $test_type = $include ? 'IN' : 'NOT IN';
    		        $where_createdbyalias = 'a.created_by_alias '.$test_type.' ('.$authors.')';
    		        if (!$include) {
    		            $where_createdbyalias .= ' AND a.created_by_alias != ' . $db->quote('');
    		        }
    		    }
    		}
		}

$query->where($where_state);

if ($author_match === 2 && !empty($where_createdby) && !empty($where_createdbyalias)) {
		    $query->where('(' . $where_createdby . ' OR ' . '(' . $where_createdbyalias . ')' . ')');
		} else {
		    if ($where_createdby) {
		        $query->where($where_createdby);
		    }
		    if ($where_createdbyalias) {
		        $query->where('(' . $where_createdbyalias . ')');
		    }
		}

// language filter

if ($params->get('filter_lang', 1) && Multilanguage::isEnabled()) {
		    $query->where($db->quoteName('a.language') . ' IN (' . $db->quote(Factory::getLanguage()->getTag()) . ',' . $db->quote('*') . ')');
		}

$ordering = array();

// author order

switch ($params->get('author_order', ''))
		{
		    case 'selec_asc': $ordering[] = $db->quoteName('author') . ' ASC'; break;
		    case 'selec_dsc': $ordering[] = $db->quoteName('author') . ' DESC'; break;
		}

// featured switch

$featured = false;
		$featured_only = false;
		switch ($params->get('show_f', 3))
		{
			case '1': // only
				$featured = true;
				$featured_only = true;
				$query->where($db->quoteName('a.featured') . ' = 1');
				if ($params->get('order') == 'o_asc' || $params->get('order') == 'o_dsc') {
				    $query->join('LEFT', $db->quoteName('#__content_frontpage', 'fp') . ' ON ' . $db->quoteName('fp.content_id') . ' = ' . $db->quoteName('a.id'));
				}
				break;
			case '0': // hide
			    $query->where($db->quoteName('a.featured') . ' = 0');
				break;
			case '2': // first the featured ones
				$featured = true;
				if ($params->get('order') == 'o_asc' || $params->get('order') == 'o_dsc') {
				    $query->join('LEFT', $db->quoteName('#__content_frontpage', 'fp') . ' ON ' . $db->quoteName('fp.content_id') . ' = ' . $db->quoteName('a.id'));
				}
				$ordering[] = $db->quoteName('a.featured') . ' DESC';
				break;
			default: // no discrimination between featured/unfeatured items
				$featured = true;
				if ($params->get('order') == 'o_asc' || $params->get('order') == 'o_dsc') {
				    $query->join('LEFT', $db->quoteName('#__content_frontpage', 'fp') . ' ON ' . $db->quoteName('fp.content_id') . ' = ' . $db->quoteName('a.id'));
				}
				break;
		}

// category order

if (!$featured_only) {
			switch ($params->get('cat_order', ''))
			{
			    case 'o_asc': $ordering[] = $db->quoteName('c.lft') . ' ASC'; break;
			    case 'o_dsc': $ordering[] = $db->quoteName('c.lft') . ' DESC'; break;
			    case 't_asc': $ordering[] = $db->quoteName('c.title') . ' ASC'; break;
			    case 't_dsc': $ordering[] = $db->quoteName('c.title') . ' DESC'; break;
			}
		}

// general ordering

switch ($params->get('order'))
		{
		    case 'o_asc': 
		        if ($featured) { 
		            $ordering[] = 'CASE WHEN ' . $db->quoteName('a.featured') . ' = 1 THEN ' . $db->quoteName('fp.ordering') . ' ELSE ' . $db->quoteName('a.ordering') . ' END ASC'; 
		        } else { 
		            $ordering[] = $db->quoteName('a.ordering') . ' ASC'; 
		        } 
		        break;
			case 'o_dsc': 
			    if ($featured) { 
			        $ordering[] = 'CASE WHEN ' . $db->quoteName('a.featured') . ' = 1 THEN ' . $db->quoteName('fp.ordering') . ' ELSE ' . $db->quoteName('a.ordering') . ' END DESC'; 
			    } else { 
			        $ordering[] = $db->quoteName('a.ordering') . ' DESC'; 
			    } 
			    break;
			case 'p_asc': $ordering[] = $db->quoteName('a.publish_up') . ' ASC'; break;
			case 'p_dsc': $ordering[] = $db->quoteName('a.publish_up') . ' DESC'; break;
			case 'f_asc': $ordering[] = 'CASE WHEN ' . $db->quoteName('a.publish_down') . ' = ' . $nullDate . ' THEN ' . $db->quoteName('a.publish_up') . ' ELSE ' . $db->quoteName('a.publish_down') . ' END ASC'; break;
			case 'f_dsc': $ordering[] = 'CASE WHEN ' . $db->quoteName('a.publish_down') . ' = ' . $nullDate . ' THEN ' . $db->quoteName('a.publish_up') . ' ELSE ' . $db->quoteName('a.publish_down') . ' END DESC'; break;
			case 'm_asc': $ordering[] = $db->quoteName('a.modified') . ' ASC'; $ordering[] = $db->quoteName('a.created') . ' ASC'; break;
			case 'm_dsc': $ordering[] = $db->quoteName('a.modified') . ' DESC'; $ordering[] = $db->quoteName('a.created') . ' DESC'; break;
			case 'c_asc': $ordering[] = $db->quoteName('a.created') . ' ASC'; break;
			case 'c_dsc': $ordering[] = $db->quoteName('a.created') . ' DESC'; break;
			case 'mc_asc': $ordering[] = 'CASE WHEN ' . $db->quoteName('a.modified') . ' = ' . $nullDate . ' THEN ' . $db->quoteName('a.created') . ' ELSE ' . $db->quoteName('a.modified') . ' END ASC'; break;
			case 'mc_dsc': $ordering[] = 'CASE WHEN ' . $db->quoteName('a.modified') . ' = ' . $nullDate . ' THEN ' . $db->quoteName('a.created') . ' ELSE ' . $db->quoteName('a.modified') . ' END DESC'; break;
			case 'random': $ordering[] = 'rand()'; break;
			case 'hit': $ordering[] = $db->quoteName('a.hits') . ' DESC'; break;
			case 'title_asc': $ordering[] = $db->quoteName('a.title') . ' ASC'; break;
			case 'title_dsc': $ordering[] = $db->quoteName('a.title') . ' DESC'; break;
			case 'cfield_asc': $ordering[] = ($postdate === 'jfield') ? $db->quoteName('cf_v.value') . ' ASC' : $db->quoteName('a.publish_up') . ' ASC'; break;
			case 'cfield_dsc': $ordering[] = ($postdate === 'jfield') ? $db->quoteName('cf_v.value') . ' DESC' : $db->quoteName('a.publish_up') . ' DESC'; break;
			case 'manual':
				$articles_to_include = array_filter(explode(',', trim($params->get('in', ''), ' ,')));
				if (!empty($articles_to_include)) {
				    $manual_ordering = 'CASE a.id';
					foreach ($articles_to_include as $key => $id) {
					    $manual_ordering .= ' WHEN ' . $id . ' THEN ' . $key;
					}
					$ordering[] = $manual_ordering . ' ELSE 999 END, a.id'; // 'FIELD(a.id, ' . $articles_to_include . ')' is MySQL specific
				}
		}

if (count($ordering) > 0) {
			$query->order($ordering);
		}

// include only

$articles_to_include = array_filter(explode(',', trim($params->get('in', ''), ' ,')));
		if (!empty($articles_to_include)) {
		    $query->where($db->quoteName('a.id') . ' IN (' . implode(',', $articles_to_include) . ')');
		}

// exclude

$articles_to_exclude = array_filter(explode(',', trim($params->get('ex', ''), ' ,')));

$item_on_page_id = '';
		if ($params->get('ex_current_item', 0) && $option === 'com_content' && $view === 'article') {
			$temp = $jinput->getString('id');
			$temp = explode(':', $temp);
			$item_on_page_id = $temp[0];
		}

if ($item_on_page_id) { // do not show the current article in the list
			$articles_to_exclude[] = $item_on_page_id;
		}

if (!empty($articles_to_exclude)) {
		    $query->where($db->quoteName('a.id') . ' NOT IN (' . implode(',', $articles_to_exclude) . ')');
		}

// launch query

$count = trim($params->get('count', ''));
		$startat = $params->get('startat', 1);
		if ($startat < 1) {
			$startat = 1;
		}

if (!empty($tags) && (($params->get('tags_match', 'any') == 'any' && ($params->get('any_count_min', 1) > 1 || ($params->get('any_count_min', 1) == 1 && trim($params->get('any_count_max', '')) != ''))) || (!$params->get('tags_inex', 1) && $params->get('tags_match', 'any') == 'all'))) {
			$db->setQuery($query);
		} else if (!empty($count) && $params->get('count_for', 'articles') == 'articles' && $params->get('tag_order', '') != 'match_dsc') {
			$db->setQuery($query, $startat - 1, intval($count));
		} else {
			$db->setQuery($query);
		}

try {
			$items = $db->loadObjectList();
		} catch (\DatabaseExceptionExecuting $e) {
			$app->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
			return null;
		}

// END OF DATABASE QUERY

if (empty($items)) {
			return array();
		}

// ITEM DATA MODIFICATIONS AND ADDITIONS

$still_need_to_slice_count = false;

// exclude all

if (!empty($tags) && !$params->get('tags_inex', 1) && $params->get('tags_match', 'any') == 'all') {

$total_tags = count($tags);

foreach ($items as $key => &$item) {

if (!isset($item->tags)) {
					$item->tags = self::getItemTags($item->id);
				}

if (self::getItemTagsCountIn($item->tags, $tags) == $total_tags) {
					unset($items[$key]);
				}
			}

$still_need_to_slice_count = true;
		}

// keep/remove items with at least X tags

if (!empty($tags) && $params->get('tags_match', 'any') == 'any' && ($params->get('any_count_min', 1) > 1 || ($params->get('any_count_min', 1) == 1 && trim($params->get('any_count_max', '')) != ''))) {

$any_max = trim($params->get('any_count_max', ''));

foreach ($items as $key => &$item) {

if (!isset($item->tags)) {
					$item->tags = self::getItemTags($item->id);
				}

$number_of_tags_for_item = self::getItemTagsCountIn($item->tags, $tags);
				if ($params->get('tags_inex', 1)) { // include - remove if does not have at least X tags to match or between X and Y tags to match
					if ($number_of_tags_for_item < $params->get('any_count_min', 1) || (!empty($any_max) && $number_of_tags_for_item > intval($any_max))) {
						unset($items[$key]);
					}
				} else { // exclude - remove if at least X tags match or if between X and Y tags match
					if ((empty($any_max) && $number_of_tags_for_item >= $params->get('any_count_min', 1))
						|| (!empty($any_max) && $number_of_tags_for_item >= $params->get('any_count_min', 1) && $number_of_tags_for_item <= intval($any_max))) {
						unset($items[$key]);
					}
				}
			}

$still_need_to_slice_count = true;
		}

// order by most to least matching tags

if ($params->get('count_for', 'articles') == 'articles' && $params->get('tag_order', '') == 'match_dsc') {

if ($params->get('tags_inex', 1)) { // only works for included tags

$grouped = array();
				$matching_tags_count = array();

foreach ($items as $key => &$item) {

if (!isset($item->tags)) {
						$item->tags = self::getItemTags($item->id);
					}

$count_tags_in_item = self::getItemTagsCountIn($item->tags, $tags);

if (!isset($grouped[$count_tags_in_item])) {
						$grouped[$count_tags_in_item] = array();
						$matching_tags_count[] = $count_tags_in_item;
					}

$grouped[$count_tags_in_item][$key] = $item;
				}

// order $matching_tags_count array from bigger to smaller count
				rsort($matching_tags_count, SORT_NUMERIC);

$items = array();
				foreach ($matching_tags_count as $matching_tag_count) {
					$items = array_merge($items, $grouped[$matching_tag_count]);
				}
			}

$still_need_to_slice_count = true;
		}

// restrict articles per author or category
		// drawback : forces grouping per author or category

$count_for = $params->get('count_for', 'articles');

if ($count_for == 'catid' || $count_for == 'author') {

$grouped = array();
			$pass = array();
			$ordered_items = array();

if ($count_for == 'catid' && isset($categories_ids_array) && count($categories_ids_array) > 1) {

$array_keys = array_keys($categories_ids_array);
			    $last_key = array_pop($array_keys);

foreach ($categories_ids_array as $category_id => $categories_id_array) {

$grouped[$category_id] = array();
			        $pass[$category_id] = array();

foreach ($items as $key => $item) {

if (in_array($item->catid, $categories_id_array)) {

if (count($pass[$category_id]) < ($startat - 1)) {
			                    $pass[$category_id][] = $item->id;
			                } else {
			                    if ($count) {
			                        if (count($grouped[$category_id]) < intval($count)) {
			                            $grouped[$category_id][] = $item->catid;
			                            $ordered_items[$key] = $item;
			                        } else {
			                            if ($category_id == $last_key) {
			                                break; // only break on the last category
			                            }
			                        }
			                    } else {
			                        $ordered_items[$key] = $item;
			                    }
			                }
			                unset($items[$key]);
			            }
			        }
			    }

ksort($ordered_items); // the ordre may have been lost

} else {

foreach ($items as $key => $item) {

if (!isset($grouped[$item->$count_for])) {
    					$grouped[$item->$count_for] = array();
    					$pass[$item->$count_for] = array();
    				}

if (count($pass[$item->$count_for]) < ($startat - 1)) {
    					$pass[$item->$count_for][] = $item->id;
    				} else {
    					if ($count) {
    						if (count($grouped[$item->$count_for]) < intval($count)) {
    							$grouped[$item->$count_for][] = $item->id;
    							$ordered_items[$key] = $item;
    						}
    					} else {
    						$ordered_items[$key] = $item;
    					}
    				}
    			}
			}

$items = $ordered_items;
		}

// limit to count

if ($still_need_to_slice_count) {
			if (!empty($count)) {
				$items = array_slice($items, $startat - 1, intval($count));
			} else {
				$items = array_slice($items, $startat - 1);
			}
		}

// parameters for all

$head_type = $params->get('head_type', 'none');

$head_width = $params->get('head_w', 64);
		$head_height = $params->get('head_h', 64);

$image_types = array('image', 'imageintro', 'imagefull', 'author', 'allimagesasc', 'allimagesdesc');

$show_image = false;

if (in_array($head_type, $image_types) || substr($head_type, 0, strlen('jfield:media')) === 'jfield:media' || substr($head_type, 0, strlen('jfieldusers:media')) === 'jfieldusers:media') {

$show_image = true;

$crop_picture = $params->get('crop_pic', 0);

$create_highres_images = $params->get('create_highres', false);
			$lazyload = $params->get('lazyload', false);

$allow_remote = $params->get('allow_remote', true);

$thumbnail_mime_type = $params->get('thumb_mime_type', '');

$maintain_height = $params->get('maintain_height', 0);

$border_width = $params->get('border_w', 0);

$head_width = $head_width - $border_width * 2;
			$head_height = $head_height - $border_width * 2;

$filter = $params->get('filter', 'none');

$quality_jpg = $params->get('quality_jpg', 75);
			$quality_png = $params->get('quality_png', 3);
			$quality_webp = $params->get('quality_webp', 80);
			$quality_avif = $params->get('quality_avif', 80);

if ($quality_jpg > 100) {
				$quality_jpg = 100;
			}
			if ($quality_jpg < 0) {
				$quality_jpg = 0;
			}

if ($quality_png > 9) {
				$quality_png = 9;
			}
			if ($quality_png < 0) {
				$quality_png = 0;
			}

if ($quality_webp > 100) {
				$quality_webp = 100;
			}
			if ($quality_webp < 0) {
				$quality_webp = 0;
			}

if ($quality_avif > 100) {
			    $quality_avif = 100;
			}
			if ($quality_avif < 0) {
			    $quality_avif = 0;
			}

$image_qualities = array('jpg' => $quality_jpg, 'png' => $quality_png, 'webp' => $quality_webp, 'avif' => $quality_avif);

$config_params = modLatestNewsEnhancedExtendedHelper::getConfig();

$clear_cache = modLatestNewsEnhancedExtendedHelper::IsClearPictureCache($params);

$subdirectory = 'thumbnails/lne';

$thumb_path = ($params->get('thumb_path', '') == '') ? $config_params->get('thumb_path_mod', 'images') : $params->get('thumb_path', '');

if ($thumb_path == 'cache') {
				$subdirectory = 'mod_latestnewsenhancedpro';
			}
			$tmp_path = SYWCache::getTmpPath($thumb_path, $subdirectory);

$default_picture = trim($params->get('default_pic', ''));

if ($clear_cache) {
				modLatestNewsEnhancedExtendedHelper::clearThumbnails($module->id, $tmp_path);

SYWVersion::refreshMediaVersion('mod_latestnewsenhanced_' . $module->id);
			}
		}

$title_type = $params->get('title_type', 'title');
		$text_type = $params->get('text', 'intro');
		$show_unauthorized_text = $params->get('s_unauthorized_text', 1);
		$unauthorized_text = trim($params->get('unauthorized_text', ''));
		$letter_count = trim($params->get('l_count', ''));
		$truncate_last_word = $params->get('trunc_l_w', 0);
		$keep_tags = trim($params->get('keep_tags', ''));
		$strip_tags = $params->get('strip_tags', 1);
		$always_show_readmore = $params->get('readmore_always_show', true);
		$trigger_OnContentPrepare = $params->get('trigger_events', false);
		$force_one_line = $params->get('force_one_line', false);
		$title_letter_count = trim($params->get('letter_count_title', ''));
		$title_truncate_last_word = $params->get('trunc_l_w_title', 0);
		//$show_date = $params->get('show_d', 'date');

$link_to = $params->get('link_to', 'item');
		$link_defaults_to_item = $params->get('link_to_default', 0);
		switch ($params->get('link_target', 'default')) {
			case 'same': $link_target = ''; break;
			case 'inline': $link_target = 4; break;
			case 'new': $link_target = 1; break;
			case 'modal': $link_target = 3; break;
			case 'popup': $link_target = 2; break;
			default: $link_target = 'default';
		}

$when_no_date = $params->get('when_no_date', 0);
		$items_with_no_date = array();

$cat_link_type = $params->get('link_cat_to', 'none');
		$cat_view = $params->get('cat_views', '');
		$cat_view_name = '';
		$cat_view_id = '';
		if ($cat_view) {
			$cat_view_array = explode(':', $cat_view);
			$cat_view_name = $cat_view_array[0];
			$cat_view_id = $cat_view_array[1];
		}

foreach ($items as $key => &$item) {

// title

if (substr($title_type, 0, strlen('jfield:text')) === 'jfield:text') {

$type_temp = explode(':', $title_type); // $title_type can be jfield:text:fieldid

$query->clear();

$query->select($db->quoteName('fv.value'));
				$query->select($db->quoteName('f.default_value'));
				$query->from($db->quoteName('#__fields_values', 'fv'));
				$query->where($db->quoteName('fv.field_id').' = '.$type_temp[2]);
				$query->where($db->quoteName('fv.item_id').' = '.$item->id);
				$query->join('LEFT', $db->quoteName('#__fields', 'f').' ON '.$db->quoteName('f.id').' = '.$db->quoteName('fv.field_id'));

$db->setQuery($query);

$newtitle = '';

try {
					$results = $db->loadObject();
					if (is_object($results)) {
						$newtitle = $results->value;
						if (empty($newtitle) && isset($results->default_value)) {
							$newtitle = $results->default_value;
						}
					}
				} catch (\DatabaseExceptionExecuting $e) {
					//Factory::getApplication()->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
				}

if ($newtitle) {
					$item->title = $newtitle;
				}
			}

// date

if ($item->date == $db->getNullDate() || $item->date == null) {

if ($when_no_date == 0) {
					unset($items[$key]);
					continue;
				}

$item->date = '';
			}

// category link

$item->catlink = '';

$link_temp = '';
			if ($cat_link_type == 'view' && $cat_view) {
				if ($cat_view == 'auto') {
					$link_temp = 'index.php?option=com_latestnewsenhancedpro&view=articles&category=' . $item->catid;
				} else {
					$link_temp = 'index.php?option=com_latestnewsenhancedpro&view=' . $cat_view_name . '&Itemid=' . $cat_view_id . '&category=' . $item->catid;
				}
			} else {
				$link_temp = ContentHelperRoute::getCategoryRoute($item->cat_slug, $item->language); // build even if 'none' is selected for B/C
			}

if (!$show_unauthorized_items || in_array($item->category_access, $authorised)) {
				$item->catlink = Route::_($link_temp);
				$item->category_authorized = true;
			} else {
				$catlink = new Uri(Route::_('index.php?option=com_users&view=login', false));

$category = Categories::getInstance('Content', array('access' => false))->get($item->catid);
				$catlink->setVar('return', base64_encode($link_temp));

$item->catlink = $catlink;
				$item->category_authorized = false;
			}

// item edit link

if ($params->get('allow_edit', 0)) {
				$edit = false;
				if ($user->authorise('core.edit', 'com_content.article.' . $item->id)) {
					$edit = true;
				} else if ($user->get('id') && $user->authorise('core.edit.own', 'com_content.article.' . $item->id)) {
					if ($user->get('id') == $item->created_by) {
						$edit = true;
					}
				}

if ($edit) {
					$item->link_edit = ContentHelperRoute::getArticleRoute($item->slug, $item->cat_slug, $item->language);
					$item->link_edit .= '&task=article.edit&a_id=' . $item->id . '&return=' . base64_encode(Uri::getInstance());
					$item->link_edit = Route::_($item->link_edit);
				}
			}

// item link

$item->link = '';

$item->authorized = true;
			$item->isinternal = false;

if ($link_to == 'item' && $link_target == 4) {
				$item->link = 'inline';
				$item->linktarget = 4;
				$item->linktitle = $item->title;
				$item->isinternal = true;
			} else if ($link_to == 'urla' || $link_to == 'urlb' || $link_to == 'urlc') { // links a, b and c

$urls = json_decode($item->urls);
				if ($urls) {
					switch ($link_to) {
						case 'urla' :
							if (!empty($urls->urla)) {
								$item->link = $urls->urla;

if ($link_target !== 'default') {
									$item->linktarget = $link_target;
									if ($item->linktarget == 4) {
										$item->linktarget = '';
									}
								} else {
									$item->linktarget = $urls->targeta;

if ($item->linktarget == '') {
										$globalparams = ComponentHelper::getParams('com_content');	// get the global parameters
										$item->linktarget = $globalparams->get('targeta');
									}
								}

$item->linktitle = !empty($urls->urlatext) ? $urls->urlatext : $item->title; // $item->link;
								$item->isinternal = Uri::isInternal($item->link); // considered as external link because will contain http...
							}
							break;
						case 'urlb' :
							if (!empty($urls->urlb)) {
								$item->link = $urls->urlb;

if ($link_target !== 'default') {
									$item->linktarget = $link_target;
									if ($item->linktarget == 4) {
										$item->linktarget = '';
									}
								} else {
									$item->linktarget = $urls->targetb;

if ($item->linktarget == '') {
										$globalparams = ComponentHelper::getParams('com_content');
										$item->linktarget = $globalparams->get('targetb');
									}
								}

$item->linktitle = !empty($urls->urlbtext) ? $urls->urlbtext : $item->title;
								$item->isinternal = Uri::isInternal($item->link);
							}
							break;
						case 'urlc' :
							if (!empty($urls->urlc)) {
								$item->link = $urls->urlc;

if ($link_target !== 'default') {
									$item->linktarget = $link_target;
									if ($item->linktarget == 4) {
										$item->linktarget = '';
									}
								} else {
									$item->linktarget = $urls->targetc;

if ($item->linktarget == '') {
										$globalparams = ComponentHelper::getParams('com_content');
										$item->linktarget = $globalparams->get('targetc');
									}
								}

$item->linktitle = !empty($urls->urlctext) ? $urls->urlctext : $item->title;
								$item->isinternal = Uri::isInternal($item->link);
							}
					}
				}
			} else if (substr($link_to, 0, strlen('jfield:url')) === 'jfield:url') {

$type_temp = explode(':', $link_to); // $link_to can be jfield:url:fieldid

$query->clear();

// not using GROUP_CONCAT to make sure compatible with all databases
				$query->select($db->quoteName(array('fv.value', 'f.label'), array('value', 'label')));
				$query->from($db->quoteName('#__fields_values', 'fv'));
				$query->where($db->quoteName('fv.field_id').'= '.$type_temp[2]);
				$query->where($db->quoteName('fv.item_id').'= '.$item->id);
				$query->where($db->quoteName('f.access').' IN ('.$groups.')'); // do not show the link if the user does not have the proper access rights
				$query->join('LEFT', $db->quoteName('#__fields', 'f').' ON '.$db->quoteName('f.id').' = '.$db->quoteName('fv.field_id'));

$db->setQuery($query);

try {
					$results = $db->loadAssocList();
				} catch (\DatabaseExceptionExecuting $e) {
					//Factory::getApplication()->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
					$results = array();
				}

if (count($results) > 0) {

foreach ($results as $result) {

switch (explode(":", $result['value'])[0])
					    {
					        case 'http': case 'https':
					            $item->link = $result['value'];
					            $item->linktarget = 1; // new window
					            if (Uri::isInternal($item->link)) {
					            	$item->isinternal = true;
					            	$item->linktarget = '';
					            }
					            break;
					        case 'ftp': case 'ftps': case 'file':
					            break;
					        case 'mailto':
					            $item->link = $result['value'];
					            $item->linktarget = 1; // new window
					            break;
					        default: // internal
					            $item->link = $result['value'];
					            if (strpos($item->link, Uri::base()) === false) {
					            	$item->link = Uri::base() . $result['value'];
					            }
					            $item->isinternal = true;
					            $item->linktarget = '';
					    }

if (empty($item->link)) {
					        continue;
					    }

if ($link_target !== 'default') {
							$item->linktarget = $link_target;
							if ($item->linktarget == 4) {
								$item->linktarget = '';
							}
						}

$item->linktitle = $result['label'];
						if (empty($item->linktitle)) {
							$item->linktitle = $item->title;
						}
					}
				}
			}

if ($item->state == 1) { // for published articles only

if ((empty($item->link) && $link_defaults_to_item) || $link_to == 'item') {

//$item->linktarget = '';
					$item->isinternal = true;

$item->linktitle = $item->title;

$link_string = ContentHelperRoute::getArticleRoute($item->slug, $item->cat_slug, $item->language);

$forced_itemid = intval($params->get('force_itemid', ''));
					if ($forced_itemid > 0) {

if (Multilanguage::isEnabled()) {
							$currentLanguage = Factory::getLanguage()->getTag();
							$langAssociations = Associations::getAssociations('com_menus', '#__menu', 'com_menus.item', $forced_itemid, 'id', '', '');
							foreach ($langAssociations as $langAssociation) {
								if ($langAssociation->language == $currentLanguage) {
									$forced_itemid = $langAssociation->id;
									break;
								}
							}
						}

if (strpos($link_string, 'Itemid') === false) {
							$link_string .= '&Itemid=' . $forced_itemid;
						} else {
							$link_string = preg_replace('#Itemid=([0-9]*)#', 'Itemid=' . $forced_itemid, $link_string);
						}
					}

if ($item->category_authorized && (!$show_unauthorized_items || in_array($item->access, $authorised))) {

if ($link_target !== 'default') {
							$item->linktarget = $link_target;
						} else {
							$item->linktarget = '';
						}

// strange: no Itemid search in ContentHelperRoute::getArticleRoute starting in Joomla 3.7

$item->link = Route::_($link_string);

} else {

$link = new Uri(Route::_('index.php?option=com_users&view=login', false));

//$link->setVar('return', base64_encode(JRoute::_(ContentHelperRoute::getArticleRoute($item->slug, $item->cat_slug, $item->language), false)));
						// returns /MyWork_3_4/index.php/latest-news/13-ipsum/9-phosfluorescently-engage-worldwide-methodologies-with-web-enabled-technology-5
						// does not work

if ($item->category_authorized) {
							$link->setVar('return', base64_encode($link_string));
						} else {

$link_string = self::getUnauthorizedArticleRoute($item->slug, $item->cat_slug, $item->language);

if ($forced_itemid > 0) {
								if (strpos($link_string, 'Itemid') === false) {
									$link_string .= '&Itemid=' . $forced_itemid;
								} else {
									$link_string = preg_replace('#Itemid=([0-9]*)#', 'Itemid=' . $forced_itemid, $link_string);
								}
							}

$link->setVar('return', base64_encode($link_string));
						}
						// works
						// returns 'index.php/latest-news/13-ipsum/9-phosfluorescently-engage-worldwide-methodologies-with-web-enabled-technology-5';

$item->link = $link;
						$item->linktarget = ''; // cannot open in modal window in this case - too many cases where it might fail bacause the login form	opens first
						$item->authorized = false;
					}
				}
			}

// rating (to avoid call to rating plugin, use $item->vote)

if (isset($item->rating)) {
				$item->vote = $item->rating; // to avoid calls to rating plugin
				$item->vote_count = $item->rating_count;
				unset($item->rating);
				unset($item->rating_count);
			} else {
				$item->vote = '';
				$item->vote_count = 0;
			}

// tags

if (!isset($item->tags)) {
				$item->tags = self::getItemTags($item->id);
			}

// thumbnail image creation

$item->imagetag = '';
			$item->error = array();

// icon

if (substr($head_type, 0, strlen('jfield:sywicon')) === 'jfield:sywicon') {
				$type_temp = explode(':', $head_type); // $head_type can be jfield:sywicon:fieldid

$item->icon = '';
				$results = SYWFields::getCustomFieldValues($type_temp[2], $item->id);
				if (!empty($results)) {
				    $item->icon = $results['value'];
				}

// last resort, use default icon if it exists
				if (empty($item->icon)) {
					if ($params->get('default_icon', '') != '') {
						$item->icon = $params->get('default_icon', '');
					} else {
					    $item->icon = '';
					}
				}
			}

// video

if (modLatestNewsEnhancedExtendedHelper::isHeadVideo($head_type) !== false) {

$type_temp = explode(':', $head_type); // $head_type can be jfield:acfyoutube:fieldid

$item->video = array();
			    $results = SYWFields::getCustomFieldValues($type_temp[2], $item->id);
			    if (!empty($results)) {
			        if (count($results) > 1) {
			            // case where videos are in separate fields
			            foreach ($results as $result) {
			                $item->video[] = $result['value'];
			            }
			        } else {
			            $item->video = explode(',', $results['value']); // case where several videos are all in the same string (HTML 5 for instance)
			        }
			    }

// last resort, use default video placeholder image
			    if (empty($item->video)) {
				    $item->video = '';
			        if ($params->get('default_videopic', '') != '') {
// 			            $item->imagetag = '<img alt="'.$item->title.'" width="' . $head_width . '" height="' . $head_height . '" src="'.$params->get('default_videopic', '').'" />';
			            $item->imagetag = HTMLHelper::_('image', $params->get('default_videopic', ''), $item->title, array('width' => $head_width, 'height' => $head_height));
			        }
			    } else {
			        // there is a video
			        
			        if ($type_temp[1] === 'url') {
			            // test the type of the video, so we can mix several video types (only works when mixing DailyMotion, YouTube and Vimeo videos in a URL custom field)
			            // dailymotion dai.ly, youtube, youtu.be, vimeo
			            
			            if (strpos($item->video[0], 'vimeo') !== false) {
			                $item->video_type = 'vimeo';
			            } else if (strpos($item->video[0], 'youtube') !== false || strpos($item->video[0], 'youtu.be') !== false) {
			                $item->video_type = 'youtube';
			            } else if (strpos($item->video[0], 'dailymotion') !== false || strpos($item->video[0], 'dai.ly') !== false) {
			                $item->video_type = 'dailymotion';
			            }
			        }
			        
			        // possible to get the poster, if any

$item->video_poster = '';
			        if ($params->get('video_poster', 'none') != 'none') {

if ($params->get('video_poster') == 'default') {
			                $item->video_poster = 'default';
			            } else {
			                $field_id = explode(':', $params->get('video_poster')); // $field_id is jfield:media:fieldid or jfield:url:fieldid

$results = SYWFields::getCustomFieldValues($field_id[2], $item->id);
			                if (!empty($results)) {
			                    if ($field_id[1] == 'media') {
			                        $item->video_poster = Uri::base().$results['value'];
			                    } else {
			                        $item->video_poster = $results['value'];
			                    }
			                }
			            }
			        }
			    }
			}

// thumbnail image creation

if ($show_image) {

// Convert the images field to an array
				$registry = new Registry();
				$registry->loadString($item->images);
				$images_array = $registry->toArray();

//$thumbnails_exist = false;
				$filename = '';
				$image_width = 0;
				$image_height = 0;

// note: original images are not cached, therefore looking thru article content will be inefficient

if (!$clear_cache && $params->get('create_thumb', 1)) {
				    $thumbnail_src = modLatestNewsEnhancedExtendedHelper::thumbnailExists($module->id, $item->id, $tmp_path, $create_highres_images);
				    if ($thumbnail_src !== false) {
						$filename = $thumbnail_src; // found a corresponding thumbnail
						//$thumbnails_exist = true;
					}
				}

if (empty($filename)) {
				//if (!$thumbnails_exist) {
					// thumbnail(s) do not exist

$imagesrc = '';

if ($head_type == 'imageintro') {

if ($images_array) {
							$imagesrc = trim($images_array['image_intro']);
						}

} else if ($head_type == 'imagefull') {

if ($images_array) {
							$imagesrc = trim($images_array['image_fulltext']);
						}

} else if ($head_type == 'image') {

if (isset($item->fulltext))	{
							$imagesrc = modLatestNewsEnhancedExtendedHelper::getImageSrcFromContent($item->introtext, $item->fulltext);
						} else {
							$imagesrc = modLatestNewsEnhancedExtendedHelper::getImageSrcFromContent($item->introtext);
						}

} else if ($head_type == 'author') {

$contact = self::getContactData($item->created_by);
						if ($contact && !empty($contact->image)) {
							$imagesrc = $contact->image;
							$item->author_image = $contact->image;
						}

// 						if (isset($item->author_image)) {
// 							$imagesrc = $item->author_image;
// 						}

} else if ($head_type == 'allimagesasc') {

// if images not found, look into intro and full article
						if (empty($imagesrc)) {

if ($images_array) {
								$imagesrc = trim($images_array['image_intro']);

if (empty($imagesrc)) {
									$imagesrc = trim($images_array['image_fulltext']);
								}
							}
						}

} else if ($head_type == 'allimagesdesc') {

// look into image intro and full first
						if ($images_array) {
							$imagesrc = trim($images_array['image_intro']);

if (empty($imagesrc)) {
								$imagesrc = trim($images_array['image_fulltext']);
							}
						}

// if image full article not found, look into the article
						if (empty($imagesrc)) {

if (isset($item->fulltext))	{
								$imagesrc = modLatestNewsEnhancedExtendedHelper::getImageSrcFromContent($item->introtext, $item->fulltext);
							} else {
								$imagesrc = modLatestNewsEnhancedExtendedHelper::getImageSrcFromContent($item->introtext);
							}
						}
					} else if (substr($head_type, 0, strlen('jfield:media')) === 'jfield:media') {

$type_temp = explode(':', $head_type); // $head_type can be jfield:media:fieldid

$results = SYWFields::getCustomFieldValues($type_temp[2], $item->id);
						if (!empty($results)) {
						    $imagesrc = $results['value'];
						}
					} else if (substr($head_type, 0, strlen('jfieldusers:media')) === 'jfieldusers:media') {

$type_temp = explode(':', $head_type); // $head_type can be jfieldusers:media:fieldid

$results = SYWFields::getCustomFieldValues($type_temp[2], $item->created_by);
						if (!empty($results)) {
							$imagesrc = $results['value'];
						}
					}

// last resort, use default image if it exists
					$used_default_image = false;
					if (empty($imagesrc)) {
						if ($default_picture) {
							$imagesrc = $default_picture;
							$used_default_image = true;
						} else {
						    $imagesrc = '';
						}
					}

if ($imagesrc) { // found an image
					    if (!$params->get('create_thumb', 1) || $head_width <= 0 || $head_height <= 0) { // no thumbnails are created, use the original image
					        $filename = $imagesrc;
					    } else {
					        $result_array = modLatestNewsEnhancedExtendedHelper::getImageFromSrc($module->id, $item->id, $imagesrc, $tmp_path, $head_width, $head_height, $crop_picture, $image_qualities, $filter, $create_highres_images, $allow_remote, $thumbnail_mime_type);

if (!empty($result_array[0])) {
    							$filename = $result_array[0];
    						}

if (!empty($result_array[1])) {

$item->error[] = $result_array[1];

// if error for the file found, try and use the default image instead
    							if (!$used_default_image && $default_picture) { // if the default image was the one chosen, no use to retry
    							    $result_array = modLatestNewsEnhancedExtendedHelper::getImageFromSrc($module->id, $item->id, $default_picture, $tmp_path, $head_width, $head_height, $crop_picture, $image_qualities, $filter, $create_highres_images, $allow_remote, $thumbnail_mime_type);

if (!empty($result_array[0])) {
    									$filename = $result_array[0];
    								}

if (!empty($result_array[1])) {
    									$item->error[] = $result_array[1];
    								}
    							}
    						}
					    }
					}

// 					if ($filename && empty($item->error)) {
// 						$thumbnails_exist = true;
// 					}
				}

if ($filename) {

$img_attributes = array();
					if ($crop_picture && $head_width > 0 && $head_height > 0) {
						$img_attributes = array('width' => $head_width, 'height' => $head_height);
					} else if ($image_width > 0 && $image_height > 0) {
					    $img_attributes = array('width' => $image_width, 'height' => $image_height);
					}

$extra_attributes = trim($params->get('image_attributes', ''));
					if ($extra_attributes) {
						$xml = new \SimpleXMLElement('<element ' . $extra_attributes . ' />');
						foreach ($xml->attributes() as $attribute_name => $attribute_value) {
							$img_attributes[$attribute_name] = $attribute_value;
						}
					}

$item->imagetag = SYWUtilities::getImageElement($filename, $item->title, $img_attributes, $lazyload, $create_highres_images, null, true, SYWVersion::getMediaVersion('mod_latestnewsenhanced_' . $module->id));
				}
			}

// ago

if ($item->date) {
				$details = modLatestNewsEnhancedExtendedHelper::date_to_counter($item->date);

$item->nbr_seconds = intval($details['secs']);
				$item->nbr_minutes = intval($details['mins']);
				$item->nbr_hours = intval($details['hours']);
				$item->nbr_days = intval($details['days']);
				$item->nbr_months = intval($details['months']);
				$item->nbr_years = intval($details['years']);
			}

// calendar shows a custom field of type 'calendar'

if ($head_type == 'calendar') {
				$item->calendar_date = $item->date;
			} else if (substr($head_type, 0, strlen('jfield:calendar')) === 'jfield:calendar') {

$item->calendar_date = null;

$type_temp = explode(':', $head_type); // $head_type can be jfield:calendar:fieldid

$results = SYWFields::getCustomFieldValues($type_temp[2], $item->id);
				if (!empty($results)) {
				    $item->calendar_date = $results['value'];
				}
			}

// title

if (!$force_one_line) {
				if (strlen($title_letter_count) > 0) {
					$item->title = SYWText::getText($item->title, 'txt', (int)$title_letter_count, true, '', true, $title_truncate_last_word);
				}
			}

// text

$item->inlinetext = '';

if ($link_to == 'item' && $link_target == 4) {
				if ($item->fulltext) {
					$item->text = $item->introtext.' '.$item->fulltext;
				} else {
					$item->text = $item->introtext;
				}
				//$item->inlinetext = JHTML::_('content.prepare', $item->inlinetext);
				PluginHelper::importPlugin('content');
				JEventDispatcher::getInstance()->trigger('onContentPrepare', array('com_content.article', &$item, &$item->params, 0)); // works on item->text

$item->inlinetext = $item->text;
			}

$item->text = '';

$number_of_letters = -1;
			if ($letter_count != '') {
				$number_of_letters = (int)($letter_count);
			}

$beacon = '';
			if (!$always_show_readmore) {
				$beacon = '^';
			}

if (!$item->authorized && !$show_unauthorized_text) {
			    $item->text = '';
			    if ($unauthorized_text) {
			    	$item->text = Text::_($unauthorized_text);
			    }
			} else {

if (substr($text_type, 0, strlen('jfield:textarea')) === 'jfield:textarea'
			        || substr($text_type, 0, strlen('jfield:editor')) === 'jfield:editor') {

$type_temp = explode(':', $text_type); // $text_type can be jfield:textarea:fieldid

$results = SYWFields::getCustomFieldValues($type_temp[2], $item->id);
		            if (!empty($results)) {
		                $item->text = $results['value'];
		            }

if (empty($item->text)) {
	                    $item->text = ''; // now unnecessary test
	                } else {
	                    $item->text = nl2br($item->text);
	                    if ($trigger_OnContentPrepare) {
	                    	//$item->text = JHTML::_('content.prepare', $item->text);
	                    	PluginHelper::importPlugin('content');
	                    	JEventDispatcher::getInstance()->trigger('onContentPrepare', array('com_content.article', &$item, &$item->params, 0));
	                    }
	                    $item->text = SYWText::getText($item->text.$beacon, 'html', $number_of_letters, $strip_tags, $keep_tags, true, $truncate_last_word);
	                }
                } else {

switch ($text_type)
                    {
                        case 'intrometa': $use_intro = (trim($item->introtext) != '') ? true : false; break;
                        case 'metaintro': $use_intro = (trim($item->metadesc) != '') ? false : true; break;
                        case 'meta': $use_intro = false; break;
                        default: case 'intro': $use_intro = true;
                    }

if ($use_intro) { // use intro text
    			        $item->text = $item->introtext;
    			        if ($item->text) {
    			            if ($trigger_OnContentPrepare) { // will trigger events from plugins
    			                //$item->text = JHtml::_('content.prepare', $item->text);
    			                PluginHelper::importPlugin('content');
    			                JEventDispatcher::getInstance()->trigger('onContentPrepare', array('com_content.article', &$item, &$item->params, 0));
    			            }
    			            $item->text = SYWText::getText($item->text.$beacon, 'html', $number_of_letters, $strip_tags, $keep_tags, true, $truncate_last_word);
    			        }
    			    } else { // use meta text
    			    	$item->text = SYWText::getText($item->metadesc.$beacon, 'txt', $number_of_letters, false, '', true, $truncate_last_word);
    			    }
                }
			}

// the text won't be cropped if the ^ character is still present after processing (hopefully no ^ at the end of the text)
			$item->cropped = true;
			if (!$always_show_readmore) {
				$text_length = strlen($item->text);
				$item->text = rtrim($item->text, "^");
				if (strlen($item->text) < $text_length && !$item->fulltexthascontent) {
					$item->cropped = false;
				}
			}

// re-order items with no dates
			if (empty($item->date) && ($when_no_date == 1 || $when_no_date == 2)) {
				$items_with_no_date[] = $item;
				unset($items[$key]);
			}
		}

if ($when_no_date == 1) {
			return array_merge($items_with_no_date, $items);
		} else if ($when_no_date == 2) {
			return array_merge($items, $items_with_no_date);
		}

return $items;
	}

// rewrite of article route in the case where the category is not authorized
	// Joomla should have handled the category node like in the category route code

protected static function getUnauthorizedArticleRoute($id, $catid = 0, $language = 0)
	{
		$needles = array(
				'article'  => array((int) $id)
		);

// Create the link
		$link = 'index.php?option=com_content&view=article&id=' . $id;

if ((int) $catid > 1)
		{
			$categories = Categories::getInstance('Content', array('access' => false)); // important!
			$category   = $categories->get((int) $catid);

if ($category)
			{
				$needles['category']   = array_reverse($category->getPath());
				$needles['categories'] = $needles['category'];
				$link .= '&catid=' . $catid;
			}
		}

if ($language && $language != "*" && Multilanguage::isEnabled())
		{
			$link .= '&lang=' . $language;
			$needles['language'] = $language;
		}

if ($item = self::_findItem($needles))
		{
			$link .= '&Itemid=' . $item;
		}

return $link;
	}

protected static $lookup = array();

protected static function _findItem($needles = null)
	{
		$app      = Factory::getApplication();
		$menus    = $app->getMenu('site');
		$language = isset($needles['language']) ? $needles['language'] : '*';

// Prepare the reverse lookup array.
		if (!isset(self::$lookup[$language]))
		{
			self::$lookup[$language] = array();

$component  = ComponentHelper::getComponent('com_content');

$attributes = array('component_id');
			$values     = array($component->id);

if ($language != '*')
			{
				$attributes[] = 'language';
				$values[]     = array($needles['language'], '*');
			}

$items = $menus->getItems($attributes, $values);

foreach ($items as $item)
			{
				if (isset($item->query) && isset($item->query['view']))
				{
					$view = $item->query['view'];

if (!isset(self::$lookup[$language][$view]))
					{
						self::$lookup[$language][$view] = array();
					}

if (isset($item->query['id']))
					{
						/**
						 * Here it will become a bit tricky
						 * language != * can override existing entries
						 * language == * cannot override existing entries
						 */
						if (!isset(self::$lookup[$language][$view][$item->query['id']]) || $item->language != '*')
						{
							self::$lookup[$language][$view][$item->query['id']] = $item->id;
						}
					}
				}
			}
		}

if ($needles)
		{
			foreach ($needles as $view => $ids)
			{
				if (isset(self::$lookup[$language][$view]))
				{
					foreach ($ids as $id)
					{
						if (isset(self::$lookup[$language][$view][(int) $id]))
						{
							return self::$lookup[$language][$view][(int) $id];
						}
					}
				}
			}
		}

// Check if the active menuitem matches the requested language
		$active = $menus->getActive();

if ($active
				&& $active->component == 'com_content'
				&& ($language == '*' || in_array($active->language, array('*', $language)) || !Multilanguage::isEnabled()))
		{
			return $active->id;
		}

// If not found, return language specific home link
		$default = $menus->getDefault($language);

return !empty($default->id) ? $default->id : null;
	}

protected static function getItemTags($id)
	{
		$helper_tags = new TagsHelper();

$tags_array = $helper_tags->getItemTags('com_content.article', $id); // array of tag objects
		if (count($tags_array) > 0) {
			return $tags_array;
		}

return array();
	}

protected static function getItemTagsCountIn($item_tags, $tags)
	{
		if (empty($item_tags)) {
			return 0;
		}

$count_tags_in_item = 0;

foreach ($item_tags as $tag) {
			if (in_array($tag->id, $tags)) {
				$count_tags_in_item++;
			}
		}

return $count_tags_in_item;
	}

protected static function getContactData($user_id)
	{
		static $contacts = array();

if (isset($contacts[$user_id])) {
			return $contacts[$user_id];
		}

$db = Factory::getDbo();

$query = $db->getQuery(true);

$query->select('MAX(' . $db->quoteName('contact.id') . ') AS id');
		$query->select($db->quoteName(array('contact.image', 'contact.sortname1', 'contact.sortname2', 'contact.sortname3')));
		$query->from($db->quoteName('#__contact_details', 'contact'));
		$query->where($db->quoteName('contact.published') . ' = 1');
		$query->where($db->quoteName('contact.user_id') . ' = ' . (int) $user_id);

if (Multilanguage::isEnabled()) {
		    $query->where('(' . $db->quoteName('contact.language') . ' IS NULL OR ' . $db->quoteName('contact.language') . ' IN (' . $db->quote(Factory::getLanguage()->getTag()) . ',' . $db->quote('*') . '))');
		}

$db->setQuery($query);

try {
			$contacts[$user_id] = $db->loadObject();
		} catch (\DatabaseExceptionExecuting $e) {
			return null;
		}

return $contacts[$user_id];
	}

}
?>