CoreFiles by mySites.guru
AuthorField.php86 lines, 1,703 bytes, from Joomla_4.1.3-Stable-Full_Package.zip
Raw History Compare with 4.1.2
md5
0e13d01946a4c9ce1230ab641197d782
sha1
428bdad7a5f1a8276a7473f7d9339d1809e48627
sha256
2ae2f852bb13f12c4a855bc601ad064f0468a7afefcdf84eedcea8f6c90a9d4f
<?php
/**
 * Joomla! Content Management System
 *
 * @copyright  (C) 2013 Open Source Matters, Inc. <https://www.joomla.org>
 * @license    GNU General Public License version 2 or later; see LICENSE.txt
 */

namespace Joomla\CMS\Form\Field;

\defined('JPATH_PLATFORM') or die;

use Joomla\CMS\Factory;

/**
 * Form Field to load a list of content authors
 *
 * @since  3.2
 */
class AuthorField extends ListField
{
	/**
	 * The form field type.
	 *
	 * @var    string
	 * @since  3.2
	 */
	public $type = 'Author';

	/**
	 * Cached array of the category items.
	 *
	 * @var    array
	 * @since  3.2
	 */
	protected static $options = array();

	/**
	 * Method to get the options to populate list
	 *
	 * @return  array  The field option objects.
	 *
	 * @since   3.2
	 */
	protected function getOptions()
	{
		// Accepted modifiers
		$hash = md5($this->element);

		if (!isset(static::$options[$hash]))
		{
			static::$options[$hash] = parent::getOptions();

			$db = Factory::getDbo();

			// Construct the query
			$query = $db->getQuery(true)
				->select(
					[
						$db->quoteName('u.id', 'value'),
						$db->quoteName('u.name', 'text'),
					]
				)
				->from($db->quoteName('#__users', 'u'))
				->join('INNER', $db->quoteName('#__content', 'c'), $db->quoteName('c.created_by') . ' = ' . $db->quoteName('u.id'))
				->group(
					[
						$db->quoteName('u.id'),
						$db->quoteName('u.name'),
					]
				)
				->order($db->quoteName('u.name'));

			// Setup the query
			$db->setQuery($query);

			// Return the result
			if ($options = $db->loadObjectList())
			{
				static::$options[$hash] = array_merge(static::$options[$hash], $options);
			}
		}

		return static::$options[$hash];
	}
}

The same content is in 45 releases, Joomla 4.0.0-beta6 to 4.2.0-alpha2. See them all, or every version of this file.