Создание папок из фронтенда - страница 8 - Разработка расширений для Joomla

// Check we are handling the frontend edit form.
       if ($context != 'com_content.article')
       {
           return true;
       }

       // Check this is a new article.
       if (!$isNew)
       {
           return true;
       }

$query->leftJoin(
    $db->quoteName('#__chmos_compilations_articles', 'cc'). ' ON ' . $db->quoteName('cc.content_id'). ' = ' . $db->quoteName('a.id')
);
$query->leftJoin(
    $db->quoteName('#__chmos_compilations', 'b'). ' ON ' . $db->quoteName('b.id'). ' = ' . $db->quoteName('cc.compilation_id')
);

$query
	->select('a.id AS articleId, a.title AS articleTitle, a.alias AS articleAlias, a.catid AS articleCategory')
	->from($db->quoteName('#__content', 'a'))
	->where($db->quoteName('a.created_by'). ' = ' . (int) JFactory::getUser()->get('id'));

$query
	->select($db->quoteName('b.*'))
	->leftJoin(
		$db->quoteName('#__chmos_compilations_articles', 'cc'). ' ON ' . $db->quoteName('cc.content_id'). ' = ' . $db->quoteName('a.id')
	)
	->leftJoin(
		$db->quoteName('#__chmos_compilations', 'b'). ' ON ' . $db->quoteName('b.id'). ' = ' . $db->quoteName('cc.id')
	);

// Join over the users for the checked out user.
$query
	->select('uc.name AS editor')
	->leftJoin($db->quoteName('#__users'). ' AS uc ON uc.id = b.checked_out');

$query->order($db->quoteName('b.title'). ' ASC');

$db = $this->getDbo();
$query = $db->getQuery(true);

$db = $this->getDbo();
$query = $db->getQuery(true);

$db->quoteName('#__chmos_compilations', 'b'). ' ON ' . $db->quoteName('b.id'). ' = ' . $db->quoteName('cc.id')

$db->quoteName('#__chmos_compilations', 'b'). ' ON ' . $db->quoteName('b.id'). ' = ' . $db->quoteName('cc.compilation_id')

->select($db->quoteName('b.*'))

->select('b.*')

$canDelete  = $user->authorise('core.delete', 'com_chmos');

print_r($this->items);