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

PATH: home / sparklp6 / public_html / sparklerfilters-org / libraries / fof30 / Model / DataModel / Behaviour

<?php
/**
 * @package   FOF
 * @copyright Copyright (c)2010-2020 Nicholas K. Dionysopoulos / Akeeba Ltd
 * @license   GNU General Public License version 2, or later
 */

namespace FOF30\Model\DataModel\Behaviour;

defined('_JEXEC') || die;

use FOF30\Event\Observer;
use FOF30\Model\DataModel;
use JDatabaseQuery;
use Joomla\Registry\Registry;

class RelationFilters extends Observer
{
	/**
	 * This event runs after we have built the query used to fetch a record list in a model. It is used to apply
	 * automatic query filters based on model relations.
	 *
	 * @param   DataModel  &          $model  The model which calls this event
	 * @param   JDatabaseQuery      & $query  The query we are manipulating
	 *
	 * @return  void
	 */
	public function onAfterBuildQuery(&$model, &$query)
	{
		$relationFilters = $model->getRelationFilters();

foreach ($relationFilters as $filterState)
		{
			$relationName = $filterState['relation'];

$tableAlias = $model->getBehaviorParam('tableAlias', null);
			$subQuery   = $model->getRelations()->getCountSubquery($relationName, $tableAlias);

// Callback method needs different handling
			if (isset($filterState['method']) && ($filterState['method'] == 'callback'))
			{
				call_user_func_array($filterState['value'], [&$subQuery]);
				$filterState['method']   = 'search';
				$filterState['operator'] = '>=';
				$filterState['value']    = '1';
			}

$options = class_exists('JRegistry') ? new Registry($filterState) : new Registry($filterState);

$filter  = new DataModel\Filter\Relation($model->getDbo(), $relationName, $subQuery);
			$methods = $filter->getSearchMethods();
			$method  = $options->get('method', $filter->getDefaultSearchMethod());

if (!in_array($method, $methods))
			{
				$method = 'exact';
			}

switch ($method)
			{
				case 'between':
				case 'outside':
					$sql = $filter->$method($options->get('from', null), $options->get('to'));
					break;

case 'interval':
					$sql = $filter->$method($options->get('value', null), $options->get('interval'));
					break;

case 'search':
					$sql = $filter->$method($options->get('value', null), $options->get('operator', '='));
					break;

default:
					$sql = $filter->$method($options->get('value', null));
					break;
			}

if ($sql)
			{
				$query->where($sql);
			}
		}
	}
}

[-] Own.php [edit]
[-] RelationFilters.php [edit]
[-] Enabled.php [edit]
[-] Access.php [edit]
[-] Filters.php [edit]
[-] PageParametersToState.php [edit]
[-] Modified.php [edit]
[-] Created.php [edit]
[-] EmptyNonZero.php [edit]
[-] Assets.php [edit]
[-] ContentHistory.php [edit]
[-] Tags.php [edit]
[+] ..
[-] Language.php [edit]