KOKINIO - MANAGER

Edit File: WorkflowstageField.php

<?php
/**
 * Joomla! Content Management System
 *
 * @copyright  (C) 2018 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('_JEXEC') or die;

use Joomla\CMS\Factory;
use Joomla\CMS\HTML\HTMLHelper;
use Joomla\CMS\Language\Text;

/**
 * Workflow Stages field.
 *
 * @since  4.0.0
 */
class WorkflowstageField extends GroupedlistField
{
	/**
	 * The form field type.
	 *
	 * @var     string
	 * @since  4.0.0
	 */
	protected $type = 'Workflowstage';

/**
	 * The component and section separated by ".".
	 *
	 * @var    string
	 * @since  4.0.0
	 */
	protected $extension = '';

/**
	 * Show only the stages which has an item attached
	 *
	 * @var     boolean
	 * @since  4.0.0
	 */
	protected $activeonly = false;

/**
	 * Method to attach a Form object to the field.
	 *
	 * @param   \SimpleXMLElement  $element  The SimpleXMLElement object representing the `<field>` tag for the form field object.
	 * @param   mixed              $value    The form field value to validate.
	 * @param   string             $group    The field name group control value. This acts as as an array container for the field.
	 *                                       For example if the field has name="foo" and the group value is set to "bar" then the
	 *                                       full field name would end up being "bar[foo]".
	 *
	 * @return  boolean  True on success.
	 *
	 * @since  4.0.0
	 */
	public function setup(\SimpleXMLElement $element, $value, $group = null)
	{
		$result = parent::setup($element, $value, $group);

if ($result)
		{
			if (\strlen($element['extension']))
			{
				$this->extension = (string) $element['extension'];
			}
			else
			{
				$this->extension = Factory::getApplication()->input->getCmd('extension');
			}

if ((string) $element['activeonly'] === '1' || (string) $element['activeonly'] === 'true')
			{
				$this->activeonly = true;
			}
		}

return $result;
	}

/**
	 * Method to get the field option groups.
	 *
	 * @return  array  The field option objects as a nested array in groups.
	 *
	 * @since  4.0.0
	 * @throws  \UnexpectedValueException
	 */
	protected function getGroups()
	{
		$db    = Factory::getDbo();
		$query = $db->getQuery(true);

// Select distinct stages for existing articles
		$query
			->select(
				[
					'DISTINCT ' . $db->quoteName('ws.id', 'workflow_stage_id'),
					$db->quoteName('ws.title', 'workflow_stage_title'),
					$db->quoteName('w.title', 'workflow_title'),
					$db->quoteName('w.id', 'workflow_id'),
					$db->quoteName('w.ordering', 'ordering'),
					$db->quoteName('ws.ordering', 'workflow_stage_ordering'),
				]
			)
			->from($db->quoteName('#__workflow_stages', 'ws'))
			->from($db->quoteName('#__workflows', 'w'))
			->where(
				[
					$db->quoteName('ws.workflow_id') . ' = ' . $db->quoteName('w.id'),
					$db->quoteName('w.extension') . ' = :extension',
				]
			)
			->bind(':extension', $this->extension)
			->order(
				[
					$db->quoteName('w.ordering'),
					$db->quoteName('ws.ordering'),
				]
			);

if ($this->activeonly)
		{
			$query
				->from($db->quoteName('#__workflow_associations', 'wa'))
				->where(
					[
						$db->quoteName('wa.stage_id') . ' = ' . $db->quoteName('ws.id'),
						$db->quoteName('wa.extension') . ' = :associationExtension',
					]
				)
				->bind(':associationExtension', $this->extension);
		}

$stages = $db->setQuery($query)->loadObjectList();

$workflowStages = array();

// Grouping the stages by workflow
		foreach ($stages as $stage)
		{
			// Using workflow ID to differentiate workflows having same title
			$workflowStageKey = Text::_($stage->workflow_title) . ' (' . $stage->workflow_id . ')';

if (!\array_key_exists($workflowStageKey, $workflowStages))
			{
				$workflowStages[$workflowStageKey] = array();
			}

$workflowStages[$workflowStageKey][] = HTMLHelper::_('select.option', $stage->workflow_stage_id, Text::_($stage->workflow_stage_title));
		}

// Merge any additional options in the XML definition.
		return array_merge(parent::getGroups(), $workflowStages);
	}
}