&tvFilters=`meta_tags**LIKE**%black%,visits**>**50||teaser**<>**''`
if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName('modTemplateVar');
$tmplVarResourceTbl = $modx->getTableName('modTemplateVarResource');
$conditions = array();
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = count($tvFilters) > 1 ? $fGroup + 1 : 0;
$filters = explode(',', $tvFilter);
foreach ($filters as $filter) {
$f = explode('==', $filter);
if (count($f) == 2) {
$tvName = $modx->quote($f[0]);
$tvValue = $modx->quote($f[1]);
$conditions[$filterGroup][] = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON tvr.value LIKE {$tvValue} AND tv.name = {$tvName} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
} elseif (count($f) == 1) {
$tvValue = $modx->quote($f[0]);
$conditions[$filterGroup][] = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON tvr.value LIKE {$tvValue} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
}
}
}
if (!empty($conditions)) {
foreach ($conditions as $cGroup => $c) {
if ($cGroup > 0) {
$criteria->orCondition($c, null, $cGroup);
} else {
$criteria->andCondition($c);
}
}
}
}if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName('modTemplateVar');
$tmplVarResourceTbl = $modx->getTableName('modTemplateVarResource');
$conditions = array();
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = count($tvFilters) > 1 ? $fGroup + 1 : 0;
$filters = explode(',', $tvFilter);
$cTV = '';
foreach ($filters as $filter) {
$f = explode('**', $filter);
if (count($f) == 3) {
$tvName = $modx->quote($f[0]);
$operator = $f[1];
$tvValue = is_numeric($f[2]) ? $f[2] : $modx->quote($f[2]);
$cTV = "AND tv.name = {$tvName} AND tvr.value {$operator} {$tvValue}";
$conditions[$filterGroup][] = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id {$cTV})";
}
}
}
if (!empty($conditions)) {
$i = 0;
foreach ($conditions as $cGroup => $c) {
// First element is always andCondition
$i == 0 ? $criteria->andCondition($c) : $criteria->orCondition($c);
$i++;
}
}
}
&tvFilters=`!pick**=**1`
if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName('modTemplateVar');
$tmplVarResourceTbl = $modx->getTableName('modTemplateVarResource');
$conditions = array();
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = count($tvFilters) > 1 ? $fGroup + 1 : 0;
$filters = explode(',', $tvFilter);
$cTV = '';
foreach ($filters as $filter) {
$f = explode('**', $filter);
if (count($f) == 3) {
$exists = 'EXISTS';
$tvName = trim($f[0]);
$operator = trim($f[1]);
$tvValue = is_numeric($f[2]) ? $f[2] : $modx->quote($f[2]);
if($tvName[0]=='!') {
$tvName = substr($tvName, 1);
$exists = 'NOT EXISTS';
}
$tvName = $modx->quote($tvName);
$cTV = "AND tv.name = {$tvName} AND tvr.value {$operator} {$tvValue}";
$conditions[$filterGroup][] = "{$exists} (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id {$cTV})";
}
}
}
if (!empty($conditions)) {
$i = 0;
foreach ($conditions as $cGroup => $c) {
// First element is always andCondition
$i == 0 ? $criteria->andCondition($c) : $criteria->orCondition($c);
$i++;
}
}
}
<?php
/**
* getResources
*
* A general purpose Resource listing and summarization snippet for MODX 2.x.
*
* @author Jason Coward
* @copyright Copyright 2010-2011, Jason Coward
* @version 1.3.1-beta
*
* TEMPLATES
*
* tpl - Name of a chunk serving as a resource template
* [NOTE: if not provided, properties are dumped to output for each resource]
*
* tplOdd - (Opt) Name of a chunk serving as resource template for resources with an odd idx value
* (see idx property)
* tplFirst - (Opt) Name of a chunk serving as resource template for the first resource (see first
* property)
* tplLast - (Opt) Name of a chunk serving as resource template for the last resource (see last
* property)
* tpl_{n} - (Opt) Name of a chunk serving as resource template for the nth resource
*
* SELECTION
*
* parents - Comma-delimited list of ids serving as parents
*
* depth - (Opt) Integer value indicating depth to search for resources from each parent [default=10]
*
* tvFilters - (Opt) Delimited-list of TemplateVar values to filter resources by. Supports two
* delimiters and two value search formats. THe first delimiter || represents a logical OR and the
* primary grouping mechanism. Within each group you can provide a comma-delimited list of values.
* These values can be either tied to a specific TemplateVar by name, e.g. myTV==value, or just the
* value, indicating you are searching for the value in any TemplateVar tied to the Resource. An
* example would be &tvFilters=`filter2==one,filter1==bar%||filter1==foo`
* [NOTE: filtering by values uses a LIKE query and % is considered a wildcard.]
* [NOTE: this only looks at the raw value set for specific Resource, i. e. there must be a value
* specifically set for the Resource and it is not evaluated.]
*
* where - (Opt) A JSON expression of criteria to build any additional where clauses from. An example would be
* &where=`{{"alias:LIKE":"foo%", "OR:alias:LIKE":"%bar"},{"OR:pagetitle:=":"foobar", "AND:description:=":"raboof"}}`
*
* sortby - (Opt) Field to sort by or a JSON array, e.g. {"publishedon":"ASC","createdon":"DESC"} [default=publishedon]
* sortbyTV - (opt) A Template Variable name to sort by (if supplied, this precedes the sortby value) [default=]
* sortbyTVType - (Opt) A data type to CAST a TV Value to in order to sort on it properly [default=string]
* sortbyAlias - (Opt) Query alias for sortby field [default=]
* sortbyEscaped - (Opt) Escapes the field name(s) specified in sortby [default=0]
* sortdir - (Opt) Order which to sort by [default=DESC]
* sortdirTV - (Opt) Order which to sort by a TV [default=DESC]
* limit - (Opt) Limits the number of resources returned [default=5]
* offset - (Opt) An offset of resources returned by the criteria to skip [default=0]
*
* OPTIONS
*
* includeContent - (Opt) Indicates if the content of each resource should be returned in the
* results [default=0]
* includeTVs - (Opt) Indicates if TemplateVar values should be included in the properties available
* to each resource template [default=0]
* processTVs - (Opt) Indicates if TemplateVar values should be rendered as they would on the
* resource being summarized [default=0]
* tvPrefix - (Opt) The prefix for TemplateVar properties [default=tv.]
* idx - (Opt) You can define the starting idx of the resources, which is an property that is
* incremented as each resource is rendered [default=1]
* first - (Opt) Define the idx which represents the first resource (see tplFirst) [default=1]
* last - (Opt) Define the idx which represents the last resource (see tplLast) [default=# of
* resources being summarized + first - 1]
* outputSeparator - (Opt) An optional string to separate each tpl instance [default="\n"]
*
*/
$output = array();
$outputSeparator = isset($outputSeparator) ? $outputSeparator : "\n";
/* set default properties */
$tpl = !empty($tpl) ? $tpl : '';
$includeContent = !empty($includeContent) ? true : false;
$includeTVs = !empty($includeTVs) ? true : false;
$processTVs = !empty($processTVs) ? true : false;
$tvPrefix = isset($tvPrefix) ? $tvPrefix : 'tv.';
$parents = (!empty($parents) || $parents === '0') ? explode(',', $parents) : array($modx->resource->get('id'));
$depth = isset($depth) ? (integer) $depth : 10;
$children = array();
foreach ($parents as $parent) {
$pchildren = $modx->getChildIds($parent, $depth);
if (!empty($pchildren)) $children = array_merge($children, $pchildren);
}
if (!empty($children)) $parents = array_merge($parents, $children);
$tvFilters = !empty($tvFilters) ? explode('||', $tvFilters) : array();
$where = !empty($where) ? $modx->fromJSON($where) : array();
$showUnpublished = !empty($showUnpublished) ? true : false;
$showDeleted = !empty($showDeleted) ? true : false;
$sortby = isset($sortby) ? $sortby : 'publishedon';
$sortbyTV = isset($sortbyTV) ? $sortbyTV : '';
$sortbyAlias = isset($sortbyAlias) ? $sortbyAlias : 'modResource';
$sortbyEscaped = !empty($sortbyEscaped) ? true : false;
$sortdir = isset($sortdir) ? $sortdir : 'DESC';
$sortdirTV = isset($sortdirTV) ? $sortdirTV : 'DESC';
$limit = isset($limit) ? (integer) $limit : 5;
$offset = isset($offset) ? (integer) $offset : 0;
$totalVar = !empty($totalVar) ? $totalVar : 'total';
/* build query */
$contextResourceTbl = $modx->getTableName('modContextResource');
/* multiple context support */
if (!empty($context)) {
$context = explode(',',$context);
$contexts = array();
foreach ($context as $ctx) {
$contexts[] = $modx->quote($ctx);
}
$context = implode(',',$contexts);
unset($contexts,$ctx);
} else {
$context = $modx->quote($modx->context->get('key'));
}
$criteria = $modx->newQuery('modResource', array(
"modResource.parent IN (" . implode(',', $parents) . ")"
,"(modResource.context_key IN ({$context}) OR EXISTS(SELECT 1 FROM {$contextResourceTbl} ctx WHERE ctx.resource = modResource.id AND ctx.context_key IN ({$context})))"
));
if (empty($showDeleted)) {
$criteria->andCondition(array('deleted' => '0'));
}
if (empty($showUnpublished)) {
$criteria->andCondition(array('published' => '1'));
}
if (empty($showHidden)) {
$criteria->andCondition(array('hidemenu' => '0'));
}
if (!empty($hideContainers)) {
$criteria->andCondition(array('isfolder' => '0'));
}
/* include/exclude resources, via &resources=`123,-456` prop */
if (!empty($resources)) {
$resources = explode(',',$resources);
$include = array();
$exclude = array();
foreach ($resources as $resource) {
$resource = (int)$resource;
if ($resource == 0) continue;
if ($resource < 0) {
$exclude[] = abs($resource);
} else {
$include[] = $resource;
}
}
if (!empty($include)) {
$criteria->orCondition(array('modResource.id:IN' => $include),null,10);
}
if (!empty($exclude)) {
$criteria->andCondition(array('modResource.id NOT IN ('.implode(',',$exclude).')'));
}
}
if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName('modTemplateVar');
$tmplVarResourceTbl = $modx->getTableName('modTemplateVarResource');
$conditions = array();
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = count($tvFilters) > 1 ? $fGroup + 1 : 0;
$filters = explode(',', $tvFilter);
// These are the operators we'll look at. Single characters must be done last, to avoid false positives.
$operators = array( '==', '!=', '<=', '>=', '<>', '>', '<', '=' );
foreach ($filters as $filter) {
// Find which operator we're working on
$foundOperator = '=='; // Default
foreach ($operators as $o) {
if ( strpos($filter, $o) !== false) {
$foundOperator = $o;
break;
}
}
$f = explode($foundOperator, $filter);
// If a TV name has ben specified, restrict the search to just that
$tvName = $modx->quote($f[0]);
if (count($f) == 2) {
$theTvSql = "AND tv.name = {$tvName}";
} elseif (count($f) == 1) {
$theTvSql = "";
}
// Build the conditions
switch ($foundOperator) {
case '!=':
case '<>':
$sqlOperator = 'NOT LIKE';
$quoteValue = true;
break;
case '==':
$sqlOperator = 'LIKE';
$quoteValue = true;
break;
default:
$sqlOperator = $foundOperator;
$quoteValue = false; // Assume a
break;
}
// Don't quote these values
if ( $quoteValue ) {
$tvValue = $modx->quote($f[1]);
} else {
$tvValue = $f[1];
}
$conditions[$filterGroup][] = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON tvr.value {$sqlOperator} {$tvValue} {$theTvSql} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
}
}
if (!empty($conditions)) {
foreach ($conditions as $cGroup => $c) {
if ($cGroup > 0) {
$criteria->orCondition($c, null, $cGroup);
} else {
$criteria->andCondition($c);
}
}
}
}
if (!empty($where)) {
$criteria->where($where);
}
$total = $modx->getCount('modResource', $criteria);
$modx->setPlaceholder($totalVar, $total);
$fields = array_keys($modx->getFields('modResource'));
if (empty($includeContent)) {
$fields = array_diff($fields, array('content'));
}
$columns = $includeContent ? $modx->getSelectColumns('modResource', 'modResource') : $modx->getSelectColumns('modResource', 'modResource', '', array('content'), true);
$criteria->select($columns);
if (!empty($sortbyTV)) {
$criteria->leftJoin('modTemplateVar', 'tvDefault', array(
"tvDefault.name" => $sortbyTV
));
$criteria->leftJoin('modTemplateVarResource', 'tvSort', array(
"tvSort.contentid = modResource.id",
"tvSort.tmplvarid = tvDefault.id"
));
if (empty($sortbyTVType)) $sortbyTVType = 'string';
if ($modx->getOption('dbtype') === 'mysql') {
switch ($sortbyTVType) {
case 'integer':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS SIGNED INTEGER) AS sortTV");
break;
case 'decimal':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
break;
case 'datetime':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DATETIME) AS sortTV");
break;
case 'string':
default:
$criteria->select("IFNULL(tvSort.value, tvDefault.default_text) AS sortTV");
break;
}
} elseif ($modx->getOption('dbtype') === 'sqlsrv') {
switch ($sortbyTVType) {
case 'integer':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS BIGINT) AS sortTV");
break;
case 'decimal':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
break;
case 'datetime':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS DATETIME) AS sortTV");
break;
case 'string':
default:
$criteria->select("ISNULL(tvSort.value, tvDefault.default_text) AS sortTV");
break;
}
}
$criteria->sortby("sortTV", $sortdirTV);
}
if (!empty($sortby)) {
if (strpos($sortby, '{') === 0) {
$sorts = $modx->fromJSON($sortby);
} else {
$sorts = array($sortby => $sortdir);
}
if (is_array($sorts)) {
while (list($sort, $dir) = each($sorts)) {
if ($sortbyEscaped) $sort = $modx->escape($sort);
if (!empty($sortbyAlias)) $sort = $modx->escape($sortbyAlias) . ".{$sort}";
$criteria->sortby($sort, $dir);
}
}
}
if (!empty($limit)) $criteria->limit($limit, $offset);
if (!empty($debug)) {
$criteria->prepare();
$modx->log(modX::LOG_LEVEL_ERROR, $criteria->toSQL());
}
$collection = $modx->getCollection('modResource', $criteria);
$idx = !empty($idx) ? intval($idx) : 1;
$first = empty($first) && $first !== '0' ? 1 : intval($first);
$last = empty($last) ? (count($collection) + $idx - 1) : intval($last);
/* include parseTpl */
include_once $modx->getOption('getresources.core_path',null,$modx->getOption('core_path').'components/getresources/').'include.parsetpl.php';
foreach ($collection as $resourceId => $resource) {
$tvs = array();
if (!empty($includeTVs)) {
$templateVars =& $resource->getMany('TemplateVars');
foreach ($templateVars as $tvId => $templateVar) {
$tvs[$tvPrefix . $templateVar->get('name')] = !empty($processTVs) ? $templateVar->renderOutput($resource->get('id')) : $templateVar->get('value');
}
}
$odd = ($idx & 1);
$properties = array_merge(
$scriptProperties
,array(
'idx' => $idx
,'first' => $first
,'last' => $last
)
,$includeContent ? $resource->toArray() : $resource->get($fields)
,$tvs
);
$resourceTpl = '';
$tplidx = 'tpl_' . $idx;
if (!empty($$tplidx)) $resourceTpl = parseTpl($$tplidx, $properties);
switch ($idx) {
case $first:
if (!empty($tplFirst)) $resourceTpl = parseTpl($tplFirst, $properties);
break;
case $last:
if (!empty($tplLast)) $resourceTpl = parseTpl($tplLast, $properties);
break;
}
if ($odd && empty($resourceTpl) && !empty($tplOdd)) $resourceTpl = parseTpl($tplOdd, $properties);
if (!empty($tpl) && empty($resourceTpl)) $resourceTpl = parseTpl($tpl, $properties);
if (empty($resourceTpl)) {
$chunk = $modx->newObject('modChunk');
$chunk->setCacheable(false);
$output[]= $chunk->process(array(), '<pre>' . print_r($properties, true) .'</pre>');
} else {
$output[]= $resourceTpl;
}
$idx++;
}
/* output */
$toSeparatePlaceholders = $modx->getOption('toSeparatePlaceholders',$scriptProperties,false);
if (!empty($toSeparatePlaceholders)) {
$modx->setPlaceholders($output,$toSeparatePlaceholders);
return '';
}
$output = implode($outputSeparator, $output);
$toPlaceholder = $modx->getOption('toPlaceholder',$scriptProperties,false);
if (!empty($toPlaceholder)) {
$modx->setPlaceholder($toPlaceholder,$output);
return '';
}
return $output;
Hi ncrossland
I’ve been working on an alternative solution to this problem, which retains backwards compatibility with the previous version. You can simply provide alternative operators, e.g.
tvname<10||anothertv>=200
It isn’t foolproof yet, and will benefit from more testing. It could do with a method of casting the data type to ensure correct quoting, and in the long run it would be better if this filtering were simply integrated into the WHERE parameter.
[[getResources? &parents=`4` &depth=`1` &tvFilters=`checkbox<>1` ]]
<?php
/**
* getResources
*
* A general purpose Resource listing and summarization snippet for MODX 2.x.
*
* @author Jason Coward
* @copyright Copyright 2010-2011, Jason Coward
* @version 1.3.0-pl - March 28, 2011
*
* TEMPLATES
*
* tpl - Name of a chunk serving as a resource template
* [NOTE: if not provided, properties are dumped to output for each resource]
*
* tplOdd - (Opt) Name of a chunk serving as resource template for resources with an odd idx value
* (see idx property)
* tplFirst - (Opt) Name of a chunk serving as resource template for the first resource (see first
* property)
* tplLast - (Opt) Name of a chunk serving as resource template for the last resource (see last
* property)
* tpl_{n} - (Opt) Name of a chunk serving as resource template for the nth resource
*
* SELECTION
*
* parents - Comma-delimited list of ids serving as parents
*
* depth - (Opt) Integer value indicating depth to search for resources from each parent [default=10]
*
* tvFilters - (Opt) Delimited-list of TemplateVar values to filter resources by. Supports two
* delimiters and two value search formats. THe first delimiter || represents a logical OR and the
* primary grouping mechanism. Within each group you can provide a comma-delimited list of values.
* These values can be either tied to a specific TemplateVar by name, e.g. myTV==value, or just the
* value, indicating you are searching for the value in any TemplateVar tied to the Resource. An
* example would be &tvFilters=`filter2==one,filter1==bar%||filter1==foo`
* [NOTE: filtering by values uses a LIKE query and % is considered a wildcard.]
* [NOTE: this only looks at the raw value set for specific Resource, i. e. there must be a value
* specifically set for the Resource and it is not evaluated.]
*
* where - (Opt) A JSON expression of criteria to build any additional where clauses from. An example would be
* &where=`{{"alias:LIKE":"foo%", "OR:alias:LIKE":"%bar"},{"OR:pagetitle:=":"foobar", "AND:description:=":"raboof"}}`
*
* sortby - (Opt) Field to sort by or a JSON array, e.g. {"publishedon":"ASC","createdon":"DESC"} [default=publishedon]
* sortbyTV - (opt) A Template Variable name to sort by (if supplied, this precedes the sortby value) [default=]
* sortbyTVType - (Opt) A data type to CAST a TV Value to in order to sort on it properly [default=string]
* sortbyAlias - (Opt) Query alias for sortby field [default=]
* sortbyEscaped - (Opt) Escapes the field name(s) specified in sortby [default=0]
* sortdir - (Opt) Order which to sort by [default=DESC]
* sortdirTV - (Opt) Order which to sort by a TV [default=DESC]
* limit - (Opt) Limits the number of resources returned [default=5]
* offset - (Opt) An offset of resources returned by the criteria to skip [default=0]
*
* OPTIONS
*
* includeContent - (Opt) Indicates if the content of each resource should be returned in the
* results [default=0]
* includeTVs - (Opt) Indicates if TemplateVar values should be included in the properties available
* to each resource template [default=0]
* processTVs - (Opt) Indicates if TemplateVar values should be rendered as they would on the
* resource being summarized [default=0]
* tvPrefix - (Opt) The prefix for TemplateVar properties [default=tv.]
* idx - (Opt) You can define the starting idx of the resources, which is an property that is
* incremented as each resource is rendered [default=1]
* first - (Opt) Define the idx which represents the first resource (see tplFirst) [default=1]
* last - (Opt) Define the idx which represents the last resource (see tplLast) [default=# of
* resources being summarized + first - 1]
* outputSeparator - (Opt) An optional string to separate each tpl instance [default="\n"]
*
*/
$output = array();
$outputSeparator = isset($outputSeparator) ? $outputSeparator : "\n";
/* set default properties */
$tpl = !empty($tpl) ? $tpl : '';
$includeContent = !empty($includeContent) ? true : false;
$includeTVs = !empty($includeTVs) ? true : false;
$processTVs = !empty($processTVs) ? true : false;
$tvPrefix = isset($tvPrefix) ? $tvPrefix : 'tv.';
$parents = (!empty($parents) || $parents === '0') ? explode(',', $parents) : array($modx->resource->get('id'));
$depth = isset($depth) ? (integer) $depth : 10;
$children = array();
foreach ($parents as $parent) {
$pchildren = $modx->getChildIds($parent, $depth);
if (!empty($pchildren)) $children = array_merge($children, $pchildren);
}
if (!empty($children)) $parents = array_merge($parents, $children);
$tvFilters = !empty($tvFilters) ? explode('||', $tvFilters) : array();
$where = !empty($where) ? $modx->fromJSON($where) : array();
$showUnpublished = !empty($showUnpublished) ? true : false;
$showDeleted = !empty($showDeleted) ? true : false;
$sortby = isset($sortby) ? $sortby : 'publishedon';
$sortbyTV = isset($sortbyTV) ? $sortbyTV : '';
$sortbyAlias = isset($sortbyAlias) ? $sortbyAlias : 'modResource';
$sortbyEscaped = !empty($sortbyEscaped) ? true : false;
$sortdir = isset($sortdir) ? $sortdir : 'DESC';
$sortdirTV = isset($sortdirTV) ? $sortdirTV : 'DESC';
$limit = isset($limit) ? (integer) $limit : 5;
$offset = isset($offset) ? (integer) $offset : 0;
$totalVar = !empty($totalVar) ? $totalVar : 'total';
/* build query */
$contextResourceTbl = $modx->getTableName('modContextResource');
/* multiple context support */
if (!empty($context)) {
$context = explode(',',$context);
$contexts = array();
foreach ($context as $ctx) {
$contexts[] = $modx->quote($ctx);
}
$context = implode(',',$contexts);
unset($contexts,$ctx);
} else {
$context = $modx->quote($modx->context->get('key'));
}
$criteria = $modx->newQuery('modResource', array(
"modResource.parent IN (" . implode(',', $parents) . ")"
,"(modResource.context_key IN ({$context}) OR EXISTS(SELECT 1 FROM {$contextResourceTbl} ctx WHERE ctx.resource = modResource.id AND ctx.context_key IN ({$context})))"
));
if (empty($showDeleted)) {
$criteria->andCondition(array('deleted' => '0'));
}
if (empty($showUnpublished)) {
$criteria->andCondition(array('published' => '1'));
}
if (empty($showHidden)) {
$criteria->andCondition(array('hidemenu' => '0'));
}
if (!empty($hideContainers)) {
$criteria->andCondition(array('isfolder' => '0'));
}
/* include/exclude resources, via &resources=`123,-456` prop */
if (!empty($resources)) {
$resources = explode(',',$resources);
$include = array();
$exclude = array();
foreach ($resources as $resource) {
$resource = (int)$resource;
if ($resource == 0) continue;
if ($resource < 0) {
$exclude[] = abs($resource);
} else {
$include[] = $resource;
}
}
if (!empty($include)) {
$criteria->orCondition(array('modResource.id:IN' => $include),null,10);
}
if (!empty($exclude)) {
$criteria->andCondition(array('modResource.id NOT IN ('.implode(',',$exclude).')'));
}
}
if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName('modTemplateVar');
$tmplVarResourceTbl = $modx->getTableName('modTemplateVarResource');
$conditions = array();
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = count($tvFilters) > 1 ? $fGroup + 1 : 0;
$filters = explode(',', $tvFilter);
// These are the operators we'll look at. Single characters must be done last, to avoid false positives.
$operators = array( '==', '!=', '<=', '>=', '<>', '>', '<', '=' );
foreach ($filters as $filter) {
// Find which operator we're working on
$foundOperator = '=='; // Default
foreach ($operators as $o) {
if ( strpos($filter, $o) !== false) {
$foundOperator = $o;
break;
}
}
$f = explode($foundOperator, $filter);
// If a TV name has ben specified, restrict the search to just that
$tvName = $modx->quote($f[0]);
if (count($f) == 2) {
$theTvSql = "AND tv.name = {$tvName}";
} elseif (count($f) == 1) {
$theTvSql = "";
}
// Build the conditions
switch ($foundOperator) {
case '!=':
case '<>':
$sqlOperator = 'NOT LIKE';
$quoteValue = true;
$exists = "NOT EXISTS";
break;
case '==':
$sqlOperator = 'LIKE';
$quoteValue = true;
$exists = "EXISTS";
break;
default:
$sqlOperator = $foundOperator;
$quoteValue = false; // Assume a numeric value if we're doing other comparisons
$exists = "EXISTS";
break;
}
// Don't quote these values
if ( $quoteValue ) {
$tvValue = $modx->quote($f[1]);
} else {
$tvValue = $f[1];
}
$conditions[$filterGroup][] = "{$exists} (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON tvr.value {$sqlOperator} {$tvValue} {$theTvSql} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
}
}
if (!empty($conditions)) {
foreach ($conditions as $cGroup => $c) {
if ($cGroup > 0) {
$criteria->orCondition($c, null, $cGroup);
} else {
$criteria->andCondition($c);
}
}
}
}
if (!empty($where)) {
$criteria->where($where);
}
$total = $modx->getCount('modResource', $criteria);
$modx->setPlaceholder($totalVar, $total);
$fields = array_keys($modx->getFields('modResource'));
if (empty($includeContent)) {
$fields = array_diff($fields, array('content'));
}
$columns = $includeContent ? $modx->getSelectColumns('modResource', 'modResource') : $modx->getSelectColumns('modResource', 'modResource', '', array('content'), true);
$criteria->select($columns);
if (!empty($sortbyTV)) {
$criteria->leftJoin('modTemplateVar', 'tvDefault', array(
"tvDefault.name" => $sortbyTV
));
$criteria->leftJoin('modTemplateVarResource', 'tvSort', array(
"tvSort.contentid = modResource.id",
"tvSort.tmplvarid = tvDefault.id"
));
if (empty($sortbyTVType)) $sortbyTVType = 'string';
if ($modx->getOption('dbtype') === 'mysql') {
switch ($sortbyTVType) {
case 'integer':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS SIGNED INTEGER) AS sortTV");
break;
case 'decimal':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
break;
case 'datetime':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DATETIME) AS sortTV");
break;
case 'string':
default:
$criteria->select("IFNULL(tvSort.value, tvDefault.default_text) AS sortTV");
break;
}
} elseif ($modx->getOption('dbtype') === 'sqlsrv') {
switch ($sortbyTVType) {
case 'integer':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS BIGINT) AS sortTV");
break;
case 'decimal':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
break;
case 'datetime':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS DATETIME) AS sortTV");
break;
case 'string':
default:
$criteria->select("ISNULL(tvSort.value, tvDefault.default_text) AS sortTV");
break;
}
}
$criteria->sortby("sortTV", $sortdirTV);
}
if (!empty($sortby)) {
if (strpos($sortby, '{') === 0) {
$sorts = $modx->fromJSON($sortby);
} else {
$sorts = array($sortby => $sortdir);
}
if (is_array($sorts)) {
while (list($sort, $dir) = each($sorts)) {
if ($sortbyEscaped) $sort = $modx->escape($sort);
if (!empty($sortbyAlias)) $sort = $modx->escape($sortbyAlias) . ".{$sort}";
$criteria->sortby($sort, $dir);
}
}
}
if (!empty($limit)) $criteria->limit($limit, $offset);
if (!empty($debug)) {
$criteria->prepare();
$modx->log(modX::LOG_LEVEL_ERROR, $criteria->toSQL());
}
$collection = $modx->getCollection('modResource', $criteria);
$idx = !empty($idx) ? intval($idx) : 1;
$first = empty($first) && $first !== '0' ? 1 : intval($first);
$last = empty($last) ? (count($collection) + $idx - 1) : intval($last);
/* include parseTpl */
include_once $modx->getOption('getresources.core_path',null,$modx->getOption('core_path').'components/getresources/').'include.parsetpl.php';
foreach ($collection as $resourceId => $resource) {
$tvs = array();
if (!empty($includeTVs)) {
$templateVars =& $resource->getMany('TemplateVars');
foreach ($templateVars as $tvId => $templateVar) {
$tvs[$tvPrefix . $templateVar->get('name')] = !empty($processTVs) ? $templateVar->renderOutput($resource->get('id')) : $templateVar->get('value');
}
}
$odd = ($idx & 1);
$properties = array_merge(
$scriptProperties
,array(
'idx' => $idx
,'first' => $first
,'last' => $last
)
,$includeContent ? $resource->toArray() : $resource->get($fields)
,$tvs
);
$resourceTpl = '';
$tplidx = 'tpl_' . $idx;
if (!empty($$tplidx)) $resourceTpl = parseTpl($$tplidx, $properties);
switch ($idx) {
case $first:
if (!empty($tplFirst)) $resourceTpl = parseTpl($tplFirst, $properties);
break;
case $last:
if (!empty($tplLast)) $resourceTpl = parseTpl($tplLast, $properties);
break;
}
if ($odd && empty($resourceTpl) && !empty($tplOdd)) $resourceTpl = parseTpl($tplOdd, $properties);
if (!empty($tpl) && empty($resourceTpl)) $resourceTpl = parseTpl($tpl, $properties);
if (empty($resourceTpl)) {
$chunk = $modx->newObject('modChunk');
$chunk->setCacheable(false);
$output[]= $chunk->process(array(), '<pre>' . print_r($properties, true) .'</pre>');
} else {
$output[]= $resourceTpl;
}
$idx++;
}
/* output */
$toSeparatePlaceholders = $modx->getOption('toSeparatePlaceholders',$scriptProperties,false);
if (!empty($toSeparatePlaceholders)) {
$modx->setPlaceholders($output,$toSeparatePlaceholders);
return '';
}
$output = implode($outputSeparator, $output);
$toPlaceholder = $modx->getOption('toPlaceholder',$scriptProperties,false);
if (!empty($toPlaceholder)) {
$modx->setPlaceholder($toPlaceholder,$output);
return '';
}
return $output;
Yes, works well with NOT DEFINED TV.
Borrowing your logic then presents something like this - does it work?
<?php
/**
* getResources
*
* A general purpose Resource listing and summarization snippet for MODX 2.x.
*
* @author Jason Coward
* @copyright Copyright 2010-2011, Jason Coward
* @version 1.3.2-beta - April 12, 2011
*
* TEMPLATES
*
* tpl - Name of a chunk serving as a resource template
* [NOTE: if not provided, properties are dumped to output for each resource]
*
* tplOdd - (Opt) Name of a chunk serving as resource template for resources with an odd idx value
* (see idx property)
* tplFirst - (Opt) Name of a chunk serving as resource template for the first resource (see first
* property)
* tplLast - (Opt) Name of a chunk serving as resource template for the last resource (see last
* property)
* tpl_{n} - (Opt) Name of a chunk serving as resource template for the nth resource
*
* SELECTION
*
* parents - Comma-delimited list of ids serving as parents
*
* depth - (Opt) Integer value indicating depth to search for resources from each parent [default=10]
*
* tvFilters - (Opt) Delimited-list of TemplateVar values to filter resources by. Supports two
* delimiters and two value search formats. THe first delimiter || represents a logical OR and the
* primary grouping mechanism. Within each group you can provide a comma-delimited list of values.
* These values can be either tied to a specific TemplateVar by name, e.g. myTV==value, or just the
* value, indicating you are searching for the value in any TemplateVar tied to the Resource. An
* example would be &tvFilters=`filter2==one,filter1==bar%||filter1==foo`
* [NOTE: filtering by values uses a LIKE query and % is considered a wildcard.]
* [NOTE: this only looks at the raw value set for specific Resource, i. e. there must be a value
* specifically set for the Resource and it is not evaluated.]
*
* where - (Opt) A JSON expression of criteria to build any additional where clauses from. An example would be
* &where=`{{"alias:LIKE":"foo%", "OR:alias:LIKE":"%bar"},{"OR:pagetitle:=":"foobar", "AND:description:=":"raboof"}}`
*
* sortby - (Opt) Field to sort by or a JSON array, e.g. {"publishedon":"ASC","createdon":"DESC"} [default=publishedon]
* sortbyTV - (opt) A Template Variable name to sort by (if supplied, this precedes the sortby value) [default=]
* sortbyTVType - (Opt) A data type to CAST a TV Value to in order to sort on it properly [default=string]
* sortbyAlias - (Opt) Query alias for sortby field [default=]
* sortbyEscaped - (Opt) Escapes the field name(s) specified in sortby [default=0]
* sortdir - (Opt) Order which to sort by [default=DESC]
* sortdirTV - (Opt) Order which to sort by a TV [default=DESC]
* limit - (Opt) Limits the number of resources returned [default=5]
* offset - (Opt) An offset of resources returned by the criteria to skip [default=0]
*
* OPTIONS
*
* includeContent - (Opt) Indicates if the content of each resource should be returned in the
* results [default=0]
* includeTVs - (Opt) Indicates if TemplateVar values should be included in the properties available
* to each resource template [default=0]
* processTVs - (Opt) Indicates if TemplateVar values should be rendered as they would on the
* resource being summarized [default=0]
* tvPrefix - (Opt) The prefix for TemplateVar properties [default=tv.]
* idx - (Opt) You can define the starting idx of the resources, which is an property that is
* incremented as each resource is rendered [default=1]
* first - (Opt) Define the idx which represents the first resource (see tplFirst) [default=1]
* last - (Opt) Define the idx which represents the last resource (see tplLast) [default=# of
* resources being summarized + first - 1]
* outputSeparator - (Opt) An optional string to separate each tpl instance [default="\n"]
*
*/
$output = array();
$outputSeparator = isset($outputSeparator) ? $outputSeparator : "\n";
/* set default properties */
$tpl = !empty($tpl) ? $tpl : '';
$includeContent = !empty($includeContent) ? true : false;
$includeTVs = !empty($includeTVs) ? true : false;
$processTVs = !empty($processTVs) ? true : false;
$tvPrefix = isset($tvPrefix) ? $tvPrefix : 'tv.';
$parents = (!empty($parents) || $parents === '0') ? explode(',', $parents) : array($modx->resource->get('id'));
$depth = isset($depth) ? (integer) $depth : 10;
$children = array();
foreach ($parents as $parent) {
$pchildren = $modx->getChildIds($parent, $depth);
if (!empty($pchildren)) $children = array_merge($children, $pchildren);
}
if (!empty($children)) $parents = array_merge($parents, $children);
$tvFilters = !empty($tvFilters) ? explode('||', $tvFilters) : array();
$where = !empty($where) ? $modx->fromJSON($where) : array();
$showUnpublished = !empty($showUnpublished) ? true : false;
$showDeleted = !empty($showDeleted) ? true : false;
$sortby = isset($sortby) ? $sortby : 'publishedon';
$sortbyTV = isset($sortbyTV) ? $sortbyTV : '';
$sortbyAlias = isset($sortbyAlias) ? $sortbyAlias : 'modResource';
$sortbyEscaped = !empty($sortbyEscaped) ? true : false;
$sortdir = isset($sortdir) ? $sortdir : 'DESC';
$sortdirTV = isset($sortdirTV) ? $sortdirTV : 'DESC';
$limit = isset($limit) ? (integer) $limit : 5;
$offset = isset($offset) ? (integer) $offset : 0;
$totalVar = !empty($totalVar) ? $totalVar : 'total';
/* build query */
$contextResourceTbl = $modx->getTableName('modContextResource');
/* multiple context support */
if (!empty($context)) {
$context = explode(',',$context);
$contexts = array();
foreach ($context as $ctx) {
$contexts[] = $modx->quote($ctx);
}
$context = implode(',',$contexts);
unset($contexts,$ctx);
} else {
$context = $modx->quote($modx->context->get('key'));
}
$criteria = $modx->newQuery('modResource', array(
"modResource.parent IN (" . implode(',', $parents) . ")"
,"(modResource.context_key IN ({$context}) OR EXISTS(SELECT 1 FROM {$contextResourceTbl} ctx WHERE ctx.resource = modResource.id AND ctx.context_key IN ({$context})))"
));
if (empty($showDeleted)) {
$criteria->andCondition(array('deleted' => '0'));
}
if (empty($showUnpublished)) {
$criteria->andCondition(array('published' => '1'));
}
if (empty($showHidden)) {
$criteria->andCondition(array('hidemenu' => '0'));
}
if (!empty($hideContainers)) {
$criteria->andCondition(array('isfolder' => '0'));
}
/* include/exclude resources, via &resources=`123,-456` prop */
if (!empty($resources)) {
$resources = explode(',',$resources);
$include = array();
$exclude = array();
foreach ($resources as $resource) {
$resource = (int)$resource;
if ($resource == 0) continue;
if ($resource < 0) {
$exclude[] = abs($resource);
} else {
$include[] = $resource;
}
}
if (!empty($include)) {
$criteria->orCondition(array('modResource.id:IN' => $include),null,10);
}
if (!empty($exclude)) {
$criteria->andCondition(array('modResource.id NOT IN ('.implode(',',$exclude).')'));
}
}
// Parse TV filters
if (!empty($tvFilters)) {
$conditions = array();
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = count($tvFilters) > 1 ? $fGroup + 1 : 0;
$filters = explode(',', $tvFilter);
// These are the operators we'll look at. Single characters must be done last, to avoid false positives.
$operators = array( '==', '!=', '<=', '>=', '<>', '>', '<', '=' );
foreach ($filters as $filter) {
// Find which operator we're working on
$foundOperator = '=='; // Default
foreach ($operators as $o) {
if ( strpos($filter, $o) !== false) {
$foundOperator = $o;
break;
}
}
// Split the operator from the values
$f = explode($foundOperator, $filter);
// And split into TV name and value
if (count($f) > 2) {// In case the operator was also found in the value, put those bits back together again to reinstate the value
$tvName = array_shift($f);
$tvValue = implode($foundOperator, $f);
} else if (count($f) == 2) {
$tvName = $f[0];
$tvValue = $f[1];
} else {
$tvName = '';
$tvValue = $f[0];
}
// Put these into an array
$conditions[$filterGroup][] = array( 'tvName' => $tvName, 'tvValue' => $tvValue, 'operator' => $foundOperator);
}
}
} else {
$conditions = array();
}
if (!empty($where)) {
$criteria->where($where);
}
$fields = array_keys($modx->getFields('modResource'));
if (empty($includeContent)) {
$fields = array_diff($fields, array('content'));
}
$columns = $includeContent ? $modx->getSelectColumns('modResource', 'modResource') : $modx->getSelectColumns('modResource', 'modResource', '', array('content'), true);
$criteria->select($columns);
if (!empty($sortbyTV)) {
$criteria->leftJoin('modTemplateVar', 'tvDefault', array(
"tvDefault.name" => $sortbyTV
));
$criteria->leftJoin('modTemplateVarResource', 'tvSort', array(
"tvSort.contentid = modResource.id",
"tvSort.tmplvarid = tvDefault.id"
));
if (empty($sortbyTVType)) $sortbyTVType = 'string';
if ($modx->getOption('dbtype') === 'mysql') {
switch ($sortbyTVType) {
case 'integer':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS SIGNED INTEGER) AS sortTV");
break;
case 'decimal':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
break;
case 'datetime':
$criteria->select("CAST(IFNULL(tvSort.value, tvDefault.default_text) AS DATETIME) AS sortTV");
break;
case 'string':
default:
$criteria->select("IFNULL(tvSort.value, tvDefault.default_text) AS sortTV");
break;
}
} elseif ($modx->getOption('dbtype') === 'sqlsrv') {
switch ($sortbyTVType) {
case 'integer':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS BIGINT) AS sortTV");
break;
case 'decimal':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS DECIMAL) AS sortTV");
break;
case 'datetime':
$criteria->select("CAST(ISNULL(tvSort.value, tvDefault.default_text) AS DATETIME) AS sortTV");
break;
case 'string':
default:
$criteria->select("ISNULL(tvSort.value, tvDefault.default_text) AS sortTV");
break;
}
}
$criteria->sortby("sortTV", $sortdirTV);
}
if (!empty($sortby)) {
if (strpos($sortby, '{') === 0) {
$sorts = $modx->fromJSON($sortby);
} else {
$sorts = array($sortby => $sortdir);
}
if (is_array($sorts)) {
while (list($sort, $dir) = each($sorts)) {
if ($sortbyEscaped) $sort = $modx->escape($sort);
if (!empty($sortbyAlias)) $sort = $modx->escape($sortbyAlias) . ".{$sort}";
$criteria->sortby($sort, $dir);
}
}
}
if (!empty($debug)) {
$criteria->prepare();
$modx->log(modX::LOG_LEVEL_ERROR, $criteria->toSQL());
}
$collection = $modx->getCollection('modResource', $criteria);
// Now we have a basic set of results, are we retrieving or filtering on TVs?
if (!empty($includeTVs) || !empty($conditions)) {
$tv_cache = array();
// Go through each resource which has been found, and populate it with TV values. Do this once.
foreach ($collection as $resourceId => $resource) {
// Get the TVs for this resource
$templateVars =& $resource->getMany('TemplateVars');
$id = $resource->get('id');
foreach ($templateVars as $tvId => $templateVar) {
// Get TV info
$tvName = $templateVar->get('name');
$tvType = $templateVar->get('type');
$tvValue = !empty($processTVs) ? $templateVar->renderOutput($id) : $templateVar->get('value');
// If a date, convert to PHP date format if possible
if ($tvType == 'date') {
$tvValueParsed = (strtotime($tvValue)) ? strtotime($tvValue) : $tvValue;
} else {
$tvValueParsed = $tvValue;
}
// Store these values in the cache
$tv_cache['resource'.$id][$tvName] = array(
'value'=> $tvValue,
'valueParsed'=> $tvValueParsed,
'type' => $tvType
);
}
// Are we including this resource?
if (!empty($conditions)) {
$keep_group = false;
foreach ($conditions as $cGroup => $c) {
$keep = false;
foreach ($c as $thisCriteria) {
// If it's a wildcard, keep and check the next criteria
if ($thisCriteria['tvValue'] == '%') {
$keep = true;
continue;
}
// Define some functions to abstract the comparisons from PHP syntax for future flexibility
if (!function_exists('equals')) {
function equals($a,$b) {
// Is there a wildcard (not escaped)?
if (strpos($b, '%' !== false) && strpos($b, '\%' === false)) {
// Make the search term regexp friendly
$b_processed = str_replace('%', '.*', $b); // Wildcard
$b_processed = str_replace( array('[','\\', '^','$','.','|','*','+','(',')'), array('\[','\\\\', '\^','\$','\.','\|','\*','\+','\(','\)'), $b_processed); // Special regexp characters
return preg_match( $b_processed, $a);
} else {
return ($a == $b);
}
}
}
if (!function_exists('notequals')) { function notequals($a,$b) { return !equals($a, $b); } }
if (!function_exists('lteq')) { function lteq($a,$b) { return ($a <= $b); } }
if (!function_exists('gteq')) { function gteq($a,$b) { return ($a >= $b); } }
if (!function_exists('lt')) { function lt($a,$b) { return ($a < $b); } }
if (!function_exists('gt')) { function gt($a,$b) { return ($a > $b); } }
// Which operator to use?
switch ($thisCriteria['operator']) {
case '==':
case '=':
$comparison_function = 'equals';
break;
case '!=':
case '<>':
$comparison_function = 'notequals';
break;
case '<=':
$comparison_function = 'lteq';
break;
case '>=':
$comparison_function = 'gteq';
break;
case '<':
$comparison_function = 'lt';
break;
case '>':
$comparison_function = 'gt';
break;
}
// If there is no specific TV name, search all TVs
if ($thisCriteria["tvName"] == '') {
foreach($tv_cache['resource'.$id] as $thisTvName => $thisTV) {
// If the TV is a date, convert the criteria value to a PHP date
if ($thisTV['type'] == 'date') {
$thisCriteria['tvValue'] = (strtotime($thisCriteria['tvValue'])) ? strtotime($thisCriteria['tvValue']) : $thisCriteria['tvValue'];
}
// Check if the value matches
if ( call_user_func($comparison_function, $thisTV['valueParsed'], $thisCriteria['tvValue']) ) {
$keep = true;
break;
} else {
$keep = false;
break;
}
}
// If there is a specific TV name, check that one
} else if ($thisCriteria["tvName"] != '') {
// The TV value
$tvValue = $tv_cache['resource'.$id][$thisCriteria["tvName"]]['valueParsed'];
// If the TV is a date, convert the criteria value to a PHP date
if ($tv_cache['resource'.$id][$thisCriteria["tvName"]]['type'] == 'date') {
$thisCriteria['tvValue'] = (strtotime($thisCriteria['tvValue'])) ? strtotime($thisCriteria['tvValue']) : $thisCriteria['tvValue'];
}
// Check if the value matches
if ( call_user_func($comparison_function, $tvValue, $thisCriteria['tvValue']) ) {
$keep = true;
} else {
$keep = false;
break;
}
// Else remove this resource
} else {
$keep = false;
break;
}
}
// If this group has proven to be true, since groups are OR, we don't need to evaluate any further
if ($keep) {
$keep_group = true;
break;
} else {
}
}
// If we're not keeping, remove from the collections array
if (!$keep_group) {
unset($collection[$resourceId]);
}
}
}
}
// Set a placeholder to record the total number of results found
$total = count($collection);
$modx->setPlaceholder($totalVar, $total);
// If a limit has been set, slice the array
if (!empty($limit)) {
$collection = array_slice($collection, $offset, $limit);
}
$idx = !empty($idx) ? intval($idx) : 1;
$first = empty($first) && $first !== '0' ? 1 : intval($first);
$last = empty($last) ? (count($collection) + $idx - 1) : intval($last);
/* include parseTpl */
include_once $modx->getOption('getresources.core_path',null,$modx->getOption('core_path').'components/getresources/').'include.parsetpl.php';
foreach ($collection as $resourceId => $resource) {
$tvs = array();
$id = $resource->get('id');
if (!empty($includeTVs)) {
foreach ($tv_cache['resource'.$id] as $tvId => $templateVal) {
$tvs[$tvPrefix . $tvId] = $templateVal['value'];
}
}
$odd = ($idx & 1);
$properties = array_merge(
$scriptProperties
,array(
'idx' => $idx
,'first' => $first
,'last' => $last
)
,$includeContent ? $resource->toArray() : $resource->get($fields)
,$tvs
);
$resourceTpl = '';
$tplidx = 'tpl_' . $idx;
if (!empty($$tplidx)) $resourceTpl = parseTpl($$tplidx, $properties);
switch ($idx) {
case $first:
if (!empty($tplFirst)) $resourceTpl = parseTpl($tplFirst, $properties);
break;
case $last:
if (!empty($tplLast)) $resourceTpl = parseTpl($tplLast, $properties);
break;
}
if ($odd && empty($resourceTpl) && !empty($tplOdd)) $resourceTpl = parseTpl($tplOdd, $properties);
if (!empty($tpl) && empty($resourceTpl)) $resourceTpl = parseTpl($tpl, $properties);
if (empty($resourceTpl)) {
$chunk = $modx->newObject('modChunk');
$chunk->setCacheable(false);
$output[]= $chunk->process(array(), '<pre>' . print_r($properties, true) .'</pre>');
} else {
$output[]= $resourceTpl;
}
$idx++;
}
/* output */
$toSeparatePlaceholders = $modx->getOption('toSeparatePlaceholders',$scriptProperties,false);
if (!empty($toSeparatePlaceholders)) {
$modx->setPlaceholders($output,$toSeparatePlaceholders);
return '';
}
$output = implode($outputSeparator, $output);
$toPlaceholder = $modx->getOption('toPlaceholder',$scriptProperties,false);
if (!empty($toPlaceholder)) {
$modx->setPlaceholder($toPlaceholder,$output);
return '';
}
return $output;