<?php
/* @var $modx modX */
$c = $modx->newQuery('modResource');
$c->where(array(
'hidemenu' => 0,
'published' => 1,
));
$sortBy = isset($scriptProperties['sortBy'])? $scriptProperties['sortBy'] : 'menuindex';
$sortDir = isset($scriptProperties['sortDir'])? $scriptProperties['sortDir'] : 'ASC';
$c->sortby($sortBy, $sortDir);
$output = '';
$children = $modx->resource->getMany('Children', $c);
$i = 0;
foreach($children as $child) {
/* @var $child modResource */
$fields = $child->toArray();
$fields['imgSource'] = $child->getTVValue('ProductImage');
$output .= $modx->getChunk('navListTpl', $fields);
}
return $output;Is there some reason why you don't want to use getResources or pdoResources?
[[!MySnippet? $docId=`12`]]
$resource = $modx->getObject('modResource', $scriptProperties['docId']);
/* ... */
$children = $resource->getMany('Children');
/* @var $modx modX */
$resource = $modx->getObject('modResource', $scriptProperties['docId']);
$resource->where(array(
'hidemenu' => 0,
'published' => 1,
));
$sortBy = isset($scriptProperties['sortBy'])? $scriptProperties['sortBy'] : 'menuindex';
$sortDir = isset($scriptProperties['sortDir'])? $scriptProperties['sortDir'] : 'ASC';
$resource ->sortby($sortBy, $sortDir);
$output = '';
$children = $resource->getMany('Children');
$i = 0;
foreach($children as $child) {
/* @var $child modResource */
$fields = $child->toArray();
$fields['imgSource'] = $child->getTVValue('ProductImage');
$output .= $modx->getChunk('navListTpl', $fields);
}
return $output;$c = $modx->newQuery('modResource');
$c->where(
'hidemenu' => 0,
'published' => 1,
);
/* ... */
$children = $resource->getMany('Children', $c);