	/**
	 * Admin view table names
	 *
	 * @var    array
	 * @since 3.2.0
	 */
	protected array $name;

	/**
	 * The Config Class.
	 *
	 * @var   Config
	 * @since 3.2.0
	 */
	protected Config $config;

	/**
	 * The GetAsLookup Class.
	 *
	 * @var   GetAsLookup
	 * @since 3.2.0
	 */
	protected GetAsLookup $getaslookup;

	/**
	 * The SiteFields Class.
	 *
	 * @var   SiteFields
	 * @since 3.2.0
	 */
	protected SiteFields $sitefields;

	/**
	 * Database object to query local DB
	 *
	 * @since 3.2.0
	 **/
	protected $db;

	/**
	 * Constructor.
	 *
	 * @param Config                 $config        The Config Class.
	 * @param GetAsLookup            $getaslookup   The GetAsLookup Class.
	 * @param SiteFields             $sitefields    The SiteFields Class.
	 *
	 * @since 3.2.0
	 */
	public function __construct(Config $config, GetAsLookup $getaslookup, SiteFields $sitefields)
	{
		$this->config = $config;
		$this->getaslookup = $getaslookup;
		$this->sitefields = $sitefields;
		$this->db = Factory::getDbo();
	}

	/**
	 * Get Data Selection of the dynamic get
	 *
	 * @param   string    $methodKey   The method unique key
	 * @param   string    $viewCode    The code name of the view
	 * @param   string    $string      The data string
	 * @param   string    $asset       The asset in question
	 * @param   string    $as          The as string
	 * @param   string    $type        The target type (db||view)
	 * @param   int|null  $rowType     The row type
	 *
	 * @return  array|null the select query
	 * @since 3.2.0
	 */
	public function get(string $methodKey, string $viewCode,
		string $string, string $asset, string $as, string $type, ?int $rowType = null): ?array
	{
		if (StringHelper::check($string))
		{
			if ('db' === $type)
			{
				$table     = '#__' . $asset;
				$queryName = $asset;
				$view      = '';
			}
			elseif ('view' === $type)
			{
				$view      = $this->name($asset);
				$table     = '#__' . $this->config->component_code_name . '_' . $view;
				$queryName = $view;
			}
			else
			{
				return null;
			}

			// just get all values from table if * is found
			if ($string === '*' || strpos($string, '*') !== false)
			{
				if ($type == 'view')
				{
					// TODO move getViewTableColumns to its own class
					$_string = Helper::_('getViewTableColumns',
						[$asset, $as, $rowType]
					);
				}
				else
				{
					// TODO move getDbTableColumns to its own class
					$_string = Helper::_('getDbTableColumns',
						[$asset, $as, $rowType]
					);
				}

				// get only selected values
				$lines = explode(PHP_EOL, (string) $_string);

				// make sure to set the string to *
				$string = '*';
			}
			else
			{
				// get only selected values
				$lines = explode(PHP_EOL, $string);
			}

			// only continue if lines are available
			if (ArrayHelper::check($lines))
			{
				$gets = [];
				$keys = [];

				// first load all options
				foreach ($lines as $line)
				{
					if (strpos($line, 'AS') !== false)
					{
						$lineArray = explode("AS", $line);
					}
					elseif (strpos($line, 'as') !== false)
					{
						$lineArray = explode("as", $line);
					}
					else
					{
						$lineArray = array($line, null);
					}

					// set the get and key
					$get = trim($lineArray[0]);
					$key = trim($lineArray[1]);

					// only add the view (we must adapt this)
					if ($this->getaslookup->exists($methodKey . '.' . $get)
						&& 'a' != $as
						&& is_numeric($rowType) && 1 == $rowType
						&& 'view' === $type
						&& strpos('#' . $key, '#' . $view . '_') === false)
					{
						// this is a problem (TODO) since we may want to not add the view name.
						$key = $view . '_' . trim($key);
					}

					// continue only if we have get
					if (StringHelper::check($get))
					{
						$gets[] = $this->db->quote($get);
						if (StringHelper::check($key))
						{
							$this->getaslookup->set($methodKey . '.' . $get, $key);
						}
						else
						{
							$key = str_replace(
								$as . '.', '', $get
							);

							$this->getaslookup->set($methodKey . '.' . $get, $key);
						}

						// set the keys
						$keys[] = $this->db->quote(
							$key
						);

						// make sure we have the view name
						if (StringHelper::check($view))
						{
							// prep the field name
							$field = str_replace($as . '.', '', $get);
							// load to the site fields memory bucket
							$this->sitefields->set($view . '.' . $field . '.' . $methodKey . '___' . $as,
								['site' => $viewCode, 'get' => $get, 'as'   => $as, 'key' => $key]
							);
						}
					}
				}

				if (ArrayHelper::check($gets)
					&& ArrayHelper::check($keys))
				{
					// single joined selection needs the prefix to the values to avoid conflict in the names
					// so we must still add then AS
					if ($string == '*' && (is_null($rowType) || 1 != $rowType))
					{
						$querySelect = "\$query->select('" . $as . ".*');";
					}
					else
					{
						$querySelect = '$query->select($db->quoteName('
							. PHP_EOL . Indent::_(3) . 'array(' . implode(
								',', $gets
							) . '),' . PHP_EOL . Indent::_(3) . 'array('
							. implode(',', $keys) . ')));';
					}
					$queryFrom = '$db->quoteName(' . $this->db->quote($table)
						. ', ' . $this->db->quote($as) . ')';

					// return the select query
					return [
						'select'      => $querySelect,
						'from'        => $queryFrom,
						'name'        => $queryName,
						'table'       => $table,
						'type'        => $type,
						'select_gets' => $gets,
						'select_keys' => $keys
						];
				}
			}
		}

		return null;
	}

	/**
	 * Get the Admin view table name
	 *
	 * @param   int        $id  The item id to add
	 *
	 * @return string   the admin view code name
	 * @since 3.2.0
	 */
	protected function name(int $id): string
	{
		// get name if not set
		if (!isset($this->name[$id]))
		{
			$this->name[$id] = StringHelper::safe(
				GetHelper::var('admin_view', $id, 'id', 'name_single')
			);
		}

		return $this->name[$id] ?? 'error';
	}