Oh, my apologies — I misread it. All the categories were indeed there, just listed flat in a single level, while I was expecting a more hierarchical display with indentation for subcategories.Would it be possible to show them indented by depth?Something like the following could work — it uses a single SQL query in the listener and a recursive PHP function to build the tree structure:
Code:
public static function getCategoryList($includeRoot = true)
{
$db = Factory::getDbo();
$query = $db->getQuery(true)
->select(['id', 'title', 'parent_id'])
->from('#__phocacart_categories')
->where('published = 1')
->order('title ASC');
$db->setQuery($query);
$rows = $db->loadObjectList();
// Group categories by parent_id
$grouped = [];
foreach ($rows as $row) {
$grouped[(int)$row->parent_id][] = $row;
}
$output = [];
if ($includeRoot) {
$output[] = (object)['id' => 10000000, 'title' => 'Root'];
}
self::buildCategoryTree($grouped, 0, 0, $output);
return $output;
}
protected static function buildCategoryTree($grouped, $parentId, $depth, &$output)
{
if (isset($grouped[$parentId])) {
foreach ($grouped[$parentId] as $category) {
$prefix = str_repeat('– ', $depth);
$category->title = $prefix . $category->title;
$output[] = $category;
self::buildCategoryTree($grouped, $category->id, $depth + 1, $output);
}
}
}
Alternatively, instead of short indentation, a breadcrumb-style format could also be used — although for deeply nested trees this might become harder to scan visually, especially if category names themselves already contain hyphens.
Code:
protected static function buildCategoryTreeBreadcrumbLike($grouped, $parentId, $depth, &$output, $prefixPath = '')
{
if (isset($grouped[$parentId])) {
foreach ($grouped[$parentId] as $category) {
$fullPath = $prefixPath === '' ? $category->title : $prefixPath . ' – ' . $category->title;
$catCopy = clone $category;
$catCopy->title = $fullPath;
$output[] = $catCopy;
self::buildCategoryTreeBreadcrumbLike($grouped, $category->id, $depth + 1, $output, $fullPath);
}
}
}
Away
