CoreFiles by mySites.guru
sql.php48 lines, 1,097 bytes, from Joomla_6.2.0-Stable-Full_Package.zip
Raw History Compare with 6.1.4
md5
9d0000bfda7bc5e70f4da2bcc89602cf
sha1
3dc1de64d3a0c54079561f92dd1387a54c3f230d
sha256
6b3ca4a8d0ae042a3046f438018640f891e1c6eb0e3192736ddf1b5de8e86b2e
<?php

/**
 * @package     Joomla.Plugin
 * @subpackage  Fields.Sql
 *
 * @copyright   (C) 2017 Open Source Matters, Inc. <https://www.joomla.org>
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

\defined('_JEXEC') or die;

use Joomla\Database\ParameterType;

$value = $field->value;

if ($value == '') {
    return;
}

$db    = $this->getDatabase();
$value = (array) $value;
$query = $db->createQuery();
$sql   = $fieldParams->get('query', '');

$bindNames = $query->bindArray($value, ParameterType::STRING);

// Run the query with a having condition because it supports aliases
$query->setQuery($sql . ' HAVING ' . $db->quoteName('value') . ' IN (' . implode(',', $bindNames) . ')');

try {
    $db->setQuery($query);
    $items = $db->loadObjectList();
} catch (Exception $e) {
    // If the query failed, we fetch all elements
    $db->setQuery($sql);
    $items = $db->loadObjectList();
}

$texts = [];

foreach ($items as $item) {
    if (in_array($item->value, $value)) {
        $texts[] = $item->text;
    }
}

echo htmlentities(implode(', ', $texts));

The same content is in 8 releases, Joomla 6.2.0-alpha2 to 6.2.0. See them all, or every version of this file.