Method getAssociations

/**
 * Get the associations.
 *
 * @param   string   $extension   The name of the component.
 * @param   string   $tablename   The name of the table.
 * @param   string   $context     The context
 * @param   integer  $id          The primary key value.
 * @param   string   $pk          The name of the primary key in the given $table.
 * @param   string   $aliasField  If the table has an alias field set it here. Null to not use it
 * @param   string   $catField    If the table has a catid field set it here. Null to not use it
 * @param   array    $advClause   Additional advanced 'where' clause; use c as parent column key, c2 as associations column key
 *
 * @return  array  The associated items
 *
 * @since   3.1
 *
 * @throws  \Exception
 */
public static function getAssociations($extension, $tablename, $context, $id, $pk = 'id', $aliasField = 'alias', $catField = 'catid', $advClause = array())
{
    // To avoid doing duplicate database queries.
    static $multilanguageAssociations = array();
    // Cast before creating cache key.
    $id = (int) $id;
    // Multilanguage association array key. If the key is already in the array we don't need to run the query again, just return it.
    $queryKey = md5(serialize(array_merge(array($extension, $tablename, $context, $id), $advClause)));
    if (!isset($multilanguageAssociations[$queryKey])) {
        $multilanguageAssociations[$queryKey] = array();
        $db = Factory::getDbo();
        $query = $db->getQuery(true);
        $categoriesExtraSql = '';
        if ($tablename === '#__categories') {
            $categoriesExtraSql = ' AND c2.extension = :extension1';
            $query->bind(':extension1', $extension);
        }
        $query->select($db->quoteName('c2.language'))->from($db->quoteName($tablename, 'c'))->join('INNER', $db->quoteName('#__associations', 'a'), $db->quoteName('a.id') . ' = ' . $db->quoteName('c.' . $pk) . ' AND ' . $db->quoteName('a.context') . ' = :context')->bind(':context', $context)->join('INNER', $db->quoteName('#__associations', 'a2'), $db->quoteName('a.key') . ' = ' . $db->quoteName('a2.key'))->join('INNER', $db->quoteName($tablename, 'c2'), $db->quoteName('a2.id') . ' = ' . $db->quoteName('c2.' . $pk) . $categoriesExtraSql);
        // Use alias field ?
        if (!empty($aliasField)) {
            $query->select($query->concatenate([$db->quoteName('c2.' . $pk), $db->quoteName('c2.' . $aliasField)], ':') . ' AS ' . $db->quoteName($pk));
        } else {
            $query->select($db->quoteName('c2.' . $pk));
        }
        // Use catid field ?
        if (!empty($catField)) {
            $query->join('INNER', $db->quoteName('#__categories', 'ca'), $db->quoteName('c2.' . $catField) . ' = ' . $db->quoteName('ca.id') . ' AND ' . $db->quoteName('ca.extension') . ' = :extension2')->bind(':extension2', $extension)->select($query->concatenate([$db->quoteName('ca.id'), $db->quoteName('ca.alias')], ':') . ' AS ' . $db->quoteName($catField));
        }
        $query->where($db->quoteName('c.' . $pk) . ' = :id')->bind(':id', $id, ParameterType::INTEGER);
        if ($tablename === '#__categories') {
            $query->where($db->quoteName('c.extension') . ' = :extension3')->bind(':extension3', $extension);
        }
        // Advanced where clause
        if (!empty($advClause)) {
            foreach ($advClause as $clause) {
                $query->where($clause);
            }
        }
        $db->setQuery($query);
        try {
            $items = $db->loadObjectList('language');
        } catch (\RuntimeException $e) {
            throw new \Exception($e->getMessage(), 500, $e);
        }
        if ($items) {
            foreach ($items as $tag => $item) {
                // Do not return itself as result
                if ((int) $item->{$pk} !== $id) {
                    $multilanguageAssociations[$queryKey][$tag] = $item;
                }
            }
        }
    }
    return $multilanguageAssociations[$queryKey];
}