Displaying a list of materials in a list of categories

[eLig]

Hi! Can you tell me how to modify the file "/components/com_content/tmpl/categories/default_items.php" correctly to get a list of category materials? Preferably with an example.

[Webdongle]

What materials?

[eLig]

What materials?

Articles

[Webdongle]

The order Articles are displayed (Category list and Blog) is set in the menu item. If your Template does not honour the settings contact the authors of the Template

[AMurray]

And a cautionary comment: don't modify core files - use Layout overrides if need be. But in this case I think the question is answered in @webdongles advice.

[eLig]

Code: Select all

use Joomla\CMS\Factory;

$db = Factory::getContainer()->get('DatabaseDriver');
$query = $db->getQuery(true);

$id_cats = array_column($this->items[$this->parent->id], 'id');

$query->select($db->quoteName(['id', 'title', 'catid']));
$query->from($db->quoteName('#__content'));
$query->where($db->quoteName('catid') . ' in (' .implode(",", $id_cats). ')');
$query->where($db->quoteName('access') . ' = 1');
$query->where($db->quoteName('state') . ' = 1');
$query->order($db->quoteName('ordering') . ' ASC');
$db->setQuery($query);
$ResQU = $db->loadAssocList();

I did it like this