How to output the number of identical product brand names in a category?

Question

MODX

Here is such a thing.

The brand name is given in the tv field.

Answer 1

1. Display all brands using pdoResources
2. In the chunk for each brand, call a custom snippet, passing as a parameter the name of the brand (if it is just text set in TV), which counts the number, something like this:

<p><span><a href="">[  ]</a></span></p>

Custom snippet:

<?php
$c = $modx->newQuery('modTemplateVarResource');
$c->leftJoin('modResource', 'Resource', array(
    'Resource.id = modTemplateVarResource.contentid'
));
$c->where(array(
    'modTemplateVarResource.tmplvarid' => XX, //XX - ID вашего TV
    'modTemplateVarResource.value' => $value
));
return $modx->getCount('modTemplateVarResource', $c);
return $total;

Answer 2

I got rid of the repetition of brands through js.