Парни, не знаете, как вывести всех производителей определенной категории по ID?
<?php
$parent = $modx->getOption('parent', $scriptProperties, $modx->resource->id);
$arRes = [];
$resources = $modx->getIterator('modResource', ['parent' => $parent, 'class_key' => 'msProduct']);
if(is_object($resources)){
foreach($resources as $resource){
$arRes[] = $resource->get('id');
}
}
$q = $modx->newQuery('msVendor');
$q->innerJoin('msProductData', 'msProductData', 'msProductData.vendor = msVendor.id');
$q->innerJoin('msProduct', 'msProduct', array(
'msProductData.id = msProduct.id',
'msProduct.deleted' => 0,
'msProduct.published' => 1
));
if(isset($arRes)){
$q->where(['msProductData.id:IN' => $arRes]);
}
$q->groupby('msVendor.id');
$q->sortby('name','ASC');
$output = [];
if ($q->prepare() && $q->stmt->execute()) {
while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
$output[] = $row;
}
}
//$modx->log(1, print_r($scriptProperties, 1), '', 'listVendors.php');
return $output;
$pdoTools = $modx->getService('pdoTools');
return $pdoTools->getChunk($scriptProperties['tpl'], ['vendors' => $output]);