Server : Apache System : Linux indy02.toastserver.com 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64 User : palandch ( 1163) PHP Version : 7.1.33 Disable Function : NONE Directory : /home/palandch/www/core/packages/getresources-1.6.1-pl/ |
<?php return array (
'a90c6a7ead495f4abc9142ae95e9ca33' =>
array (
'criteria' =>
array (
'name' => 'getResources',
),
'object' =>
array (
'id' => 9,
'source' => 0,
'property_preprocess' => 0,
'name' => 'getResources',
'description' => '<strong>1.5.1-pl</strong> A general purpose Resource listing and summarization snippet for MODx Revolution',
'editor_type' => 0,
'category' => 0,
'cache_type' => 0,
'snippet' => '/**
* getResources
*
* A general purpose Resource listing and summarization snippet for MODX 2.x.
*
* @author Jason Coward
* @copyright Copyright 2010-2012, Jason Coward
*
* 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
*
* context - (Opt) Comma-delimited list of context keys to limit results by; if empty, contexts for all specified
* parents will be used (all contexts if 0 is specified) [default=]
*
* 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.]
*
* tvFiltersAndDelimiter - (Opt) Custom delimiter for logical AND, default \',\', in case you want to
* match a literal comma in the tvFilters. E.g. &tvFiltersAndDelimiter=`&&`
* &tvFilters=`filter1==foo,bar&&filter2==baz` [default=,]
*
* tvFiltersOrDelimiter - (Opt) Custom delimiter for logical OR, default \'||\', in case you want to
* match a literal \'||\' in the tvFilters. E.g. &tvFiltersOrDelimiter=`|OR|`
* &tvFilters=`filter1==foo||bar|OR|filter2==baz` [default=||]
*
* 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]
* dbCacheFlag - (Opt) Controls caching of db queries; 0|false = do not cache result set; 1 = cache result set
* according to cache settings, any other integer value = number of seconds to cache result set [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]
* includeTVList - (Opt) Limits the TemplateVars that are included if includeTVs is true to those specified
* by name in a comma-delimited list [default=]
* prepareTVs - (Opt) Prepares media-source dependent TemplateVar values [default=1]
* prepareTVList - (Opt) Limits the TVs that are prepared to those specified by name in a comma-delimited
* list [default=]
* processTVs - (Opt) Indicates if TemplateVar values should be rendered as they would on the
* resource being summarized [default=0]
* processTVList - (opt) Limits the TemplateVars that are processed if included to those specified
* by name in a comma-delimited list [default=]
* 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;
$includeTVList = !empty($includeTVList) ? explode(\',\', $includeTVList) : array();
$processTVs = !empty($processTVs) ? true : false;
$processTVList = !empty($processTVList) ? explode(\',\', $processTVList) : array();
$prepareTVs = !empty($prepareTVs) ? true : false;
$prepareTVList = !empty($prepareTVList) ? explode(\',\', $prepareTVList) : array();
$tvPrefix = isset($tvPrefix) ? $tvPrefix : \'tv.\';
$parents = (!empty($parents) || $parents === \'0\') ? explode(\',\', $parents) : array($modx->resource->get(\'id\'));
array_walk($parents, \'trim\');
$parents = array_unique($parents);
$depth = isset($depth) ? (integer) $depth : 10;
$tvFiltersOrDelimiter = isset($tvFiltersOrDelimiter) ? $tvFiltersOrDelimiter : \'||\';
$tvFiltersAndDelimiter = isset($tvFiltersAndDelimiter) ? $tvFiltersAndDelimiter : \',\';
$tvFilters = !empty($tvFilters) ? explode($tvFiltersOrDelimiter, $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\';
$dbCacheFlag = !isset($dbCacheFlag) ? false : $dbCacheFlag;
if (is_string($dbCacheFlag) || is_numeric($dbCacheFlag)) {
if ($dbCacheFlag == \'0\') {
$dbCacheFlag = false;
} elseif ($dbCacheFlag == \'1\') {
$dbCacheFlag = true;
} else {
$dbCacheFlag = (integer) $dbCacheFlag;
}
}
/* multiple context support */
$contextArray = array();
$contextSpecified = false;
if (!empty($context)) {
$contextArray = explode(\',\',$context);
array_walk($contextArray, \'trim\');
$contexts = array();
foreach ($contextArray as $ctx) {
$contexts[] = $modx->quote($ctx);
}
$context = implode(\',\',$contexts);
$contextSpecified = true;
unset($contexts,$ctx);
} else {
$context = $modx->quote($modx->context->get(\'key\'));
}
$pcMap = array();
$pcQuery = $modx->newQuery(\'modResource\', array(\'id:IN\' => $parents), $dbCacheFlag);
$pcQuery->select(array(\'id\', \'context_key\'));
if ($pcQuery->prepare() && $pcQuery->stmt->execute()) {
foreach ($pcQuery->stmt->fetchAll(PDO::FETCH_ASSOC) as $pcRow) {
$pcMap[(integer) $pcRow[\'id\']] = $pcRow[\'context_key\'];
}
}
$children = array();
$parentArray = array();
foreach ($parents as $parent) {
$parent = (integer) $parent;
if ($parent === 0) {
$pchildren = array();
if ($contextSpecified) {
foreach ($contextArray as $pCtx) {
if (!in_array($pCtx, $contextArray)) {
continue;
}
$options = $pCtx !== $modx->context->get(\'key\') ? array(\'context\' => $pCtx) : array();
$pcchildren = $modx->getChildIds($parent, $depth, $options);
if (!empty($pcchildren)) $pchildren = array_merge($pchildren, $pcchildren);
}
} else {
$cQuery = $modx->newQuery(\'modContext\', array(\'key:!=\' => \'mgr\'));
$cQuery->select(array(\'key\'));
if ($cQuery->prepare() && $cQuery->stmt->execute()) {
foreach ($cQuery->stmt->fetchAll(PDO::FETCH_COLUMN) as $pCtx) {
$options = $pCtx !== $modx->context->get(\'key\') ? array(\'context\' => $pCtx) : array();
$pcchildren = $modx->getChildIds($parent, $depth, $options);
if (!empty($pcchildren)) $pchildren = array_merge($pchildren, $pcchildren);
}
}
}
$parentArray[] = $parent;
} else {
$pContext = array_key_exists($parent, $pcMap) ? $pcMap[$parent] : false;
if ($debug) $modx->log(modX::LOG_LEVEL_ERROR, "context for {$parent} is {$pContext}");
if ($pContext && $contextSpecified && !in_array($pContext, $contextArray, true)) {
$parent = next($parents);
continue;
}
$parentArray[] = $parent;
$options = !empty($pContext) && $pContext !== $modx->context->get(\'key\') ? array(\'context\' => $pContext) : array();
$pchildren = $modx->getChildIds($parent, $depth, $options);
}
if (!empty($pchildren)) $children = array_merge($children, $pchildren);
$parent = next($parents);
}
$parents = array_merge($parentArray, $children);
/* build query */
$criteria = array("modResource.parent IN (" . implode(\',\', $parents) . ")");
if ($contextSpecified) {
$contextResourceTbl = $modx->getTableName(\'modContextResource\');
$criteria[] = "(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[\'deleted\'] = \'0\';
}
if (empty($showUnpublished)) {
$criteria[\'published\'] = \'1\';
}
if (empty($showHidden)) {
$criteria[\'hidemenu\'] = \'0\';
}
if (!empty($hideContainers)) {
$criteria[\'isfolder\'] = \'0\';
}
$criteria = $modx->newQuery(\'modResource\', $criteria);
if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName(\'modTemplateVar\');
$tmplVarResourceTbl = $modx->getTableName(\'modTemplateVarResource\');
$conditions = array();
$operators = array(
\'<=>\' => \'<=>\',
\'===\' => \'=\',
\'!==\' => \'!=\',
\'<>\' => \'<>\',
\'==\' => \'LIKE\',
\'!=\' => \'NOT LIKE\',
\'<<\' => \'<\',
\'<=\' => \'<=\',
\'=<\' => \'=<\',
\'>>\' => \'>\',
\'>=\' => \'>=\',
\'=>\' => \'=>\'
);
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = array();
$filters = explode($tvFiltersAndDelimiter, $tvFilter);
$multiple = count($filters) > 0;
foreach ($filters as $filter) {
$operator = \'==\';
$sqlOperator = \'LIKE\';
foreach ($operators as $op => $opSymbol) {
if (strpos($filter, $op, 1) !== false) {
$operator = $op;
$sqlOperator = $opSymbol;
break;
}
}
$tvValueField = \'tvr.value\';
$tvDefaultField = \'tv.default_text\';
$f = explode($operator, $filter);
if (count($f) == 2) {
$tvName = $modx->quote($f[0]);
if (is_numeric($f[1]) && !in_array($sqlOperator, array(\'LIKE\', \'NOT LIKE\'))) {
$tvValue = $f[1];
if ($f[1] == (integer)$f[1]) {
$tvValueField = "CAST({$tvValueField} AS SIGNED INTEGER)";
$tvDefaultField = "CAST({$tvDefaultField} AS SIGNED INTEGER)";
} else {
$tvValueField = "CAST({$tvValueField} AS DECIMAL)";
$tvDefaultField = "CAST({$tvDefaultField} AS DECIMAL)";
}
} else {
$tvValue = $modx->quote($f[1]);
}
if ($multiple) {
$filterGroup[] =
"(EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.name = {$tvName} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) " .
"OR EXISTS (SELECT 1 FROM {$tmplVarTbl} tv WHERE tv.name = {$tvName} AND {$tvDefaultField} {$sqlOperator} {$tvValue} AND tv.id NOT IN (SELECT tmplvarid FROM {$tmplVarResourceTbl} WHERE contentid = modResource.id)) " .
")";
} else {
$filterGroup =
"(EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.name = {$tvName} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) " .
"OR EXISTS (SELECT 1 FROM {$tmplVarTbl} tv WHERE tv.name = {$tvName} AND {$tvDefaultField} {$sqlOperator} {$tvValue} AND tv.id NOT IN (SELECT tmplvarid FROM {$tmplVarResourceTbl} WHERE contentid = modResource.id)) " .
")";
}
} elseif (count($f) == 1) {
$tvValue = $modx->quote($f[0]);
if ($multiple) {
$filterGroup[] = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
} else {
$filterGroup = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
}
}
}
$conditions[] = $filterGroup;
}
if (!empty($conditions)) {
$firstGroup = true;
foreach ($conditions as $cGroup => $c) {
if (is_array($c)) {
$first = true;
foreach ($c as $cond) {
if ($first && !$firstGroup) {
$criteria->condition($criteria->query[\'where\'][0][1], $cond, xPDOQuery::SQL_OR, null, $cGroup);
} else {
$criteria->condition($criteria->query[\'where\'][0][1], $cond, xPDOQuery::SQL_AND, null, $cGroup);
}
$first = false;
}
} else {
$criteria->condition($criteria->query[\'where\'][0][1], $c, $firstGroup ? xPDOQuery::SQL_AND : xPDOQuery::SQL_OR, null, $cGroup);
}
$firstGroup = false;
}
}
}
/* include/exclude resources, via &resources=`123,-456` prop */
if (!empty($resources)) {
$resourceConditions = array();
$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->where(array(\'OR:modResource.id:IN\' => $include), xPDOQuery::SQL_OR);
}
if (!empty($exclude)) {
$criteria->where(array(\'modResource.id:NOT IN\' => $exclude), xPDOQuery::SQL_AND, null, 1);
}
}
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, $dbCacheFlag);
$idx = !empty($idx) && $idx !== \'0\' ? (integer) $idx : 1;
$first = empty($first) && $first !== \'0\' ? 1 : (integer) $first;
$last = empty($last) ? (count($collection) + $idx - 1) : (integer) $last;
/* include parseTpl */
include_once $modx->getOption(\'getresources.core_path\',null,$modx->getOption(\'core_path\').\'components/getresources/\').\'include.parsetpl.php\';
$templateVars = array();
if (!empty($includeTVs) && !empty($includeTVList)) {
$templateVars = $modx->getCollection(\'modTemplateVar\', array(\'name:IN\' => $includeTVList));
}
/** @var modResource $resource */
foreach ($collection as $resourceId => $resource) {
$tvs = array();
if (!empty($includeTVs)) {
if (empty($includeTVList)) {
$templateVars = $resource->getMany(\'TemplateVars\');
}
/** @var modTemplateVar $templateVar */
foreach ($templateVars as $tvId => $templateVar) {
if (!empty($includeTVList) && !in_array($templateVar->get(\'name\'), $includeTVList)) continue;
if ($processTVs && (empty($processTVList) || in_array($templateVar->get(\'name\'), $processTVList))) {
$tvs[$tvPrefix . $templateVar->get(\'name\')] = $templateVar->renderOutput($resource->get(\'id\'));
} else {
$value = $templateVar->getValue($resource->get(\'id\'));
if ($prepareTVs && method_exists($templateVar, \'prepareOutput\') && (empty($prepareTVList) || in_array($templateVar->get(\'name\'), $prepareTVList))) {
$value = $templateVar->prepareOutput($value);
}
$tvs[$tvPrefix . $templateVar->get(\'name\')] = $value;
}
}
}
$odd = ($idx & 1);
$properties = array_merge(
$scriptProperties
,array(
\'idx\' => $idx
,\'first\' => $first
,\'last\' => $last
,\'odd\' => $odd
)
,$includeContent ? $resource->toArray() : $resource->get($fields)
,$tvs
);
$resourceTpl = \'\';
if ($idx == $first && !empty($tplFirst)) {
$resourceTpl = parseTpl($tplFirst, $properties);
}
if ($idx == $last && empty($resourceTpl) && !empty($tplLast)) {
$resourceTpl = parseTpl($tplLast, $properties);
}
$tplidx = \'tpl_\' . $idx;
if (empty($resourceTpl) && !empty($$tplidx)) {
$resourceTpl = parseTpl($$tplidx, $properties);
}
if ($idx > 1 && empty($resourceTpl)) {
$divisors = getDivisors($idx);
if (!empty($divisors)) {
foreach ($divisors as $divisor) {
$tplnth = \'tpl_n\' . $divisor;
if (!empty($$tplnth)) {
$resourceTpl = parseTpl($$tplnth, $properties);
if (!empty($resourceTpl)) {
break;
}
}
}
}
}
if ($odd && empty($resourceTpl) && !empty($tplOdd)) {
$resourceTpl = parseTpl($tplOdd, $properties);
}
if (!empty($tplCondition) && !empty($conditionalTpls) && empty($resourceTpl)) {
$conTpls = $modx->fromJSON($conditionalTpls);
$subject = $properties[$tplCondition];
$tplOperator = !empty($tplOperator) ? $tplOperator : \'=\';
$tplOperator = strtolower($tplOperator);
$tplCon = \'\';
foreach ($conTpls as $operand => $conditionalTpl) {
switch ($tplOperator) {
case \'!=\':
case \'neq\':
case \'not\':
case \'isnot\':
case \'isnt\':
case \'unequal\':
case \'notequal\':
$tplCon = (($subject != $operand) ? $conditionalTpl : $tplCon);
break;
case \'<\':
case \'lt\':
case \'less\':
case \'lessthan\':
$tplCon = (($subject < $operand) ? $conditionalTpl : $tplCon);
break;
case \'>\':
case \'gt\':
case \'greater\':
case \'greaterthan\':
$tplCon = (($subject > $operand) ? $conditionalTpl : $tplCon);
break;
case \'<=\':
case \'lte\':
case \'lessthanequals\':
case \'lessthanorequalto\':
$tplCon = (($subject <= $operand) ? $conditionalTpl : $tplCon);
break;
case \'>=\':
case \'gte\':
case \'greaterthanequals\':
case \'greaterthanequalto\':
$tplCon = (($subject >= $operand) ? $conditionalTpl : $tplCon);
break;
case \'isempty\':
case \'empty\':
$tplCon = empty($subject) ? $conditionalTpl : $tplCon;
break;
case \'!empty\':
case \'notempty\':
case \'isnotempty\':
$tplCon = !empty($subject) && $subject != \'\' ? $conditionalTpl : $tplCon;
break;
case \'isnull\':
case \'null\':
$tplCon = $subject == null || strtolower($subject) == \'null\' ? $conditionalTpl : $tplCon;
break;
case \'inarray\':
case \'in_array\':
case \'ia\':
$operand = explode(\',\', $operand);
$tplCon = in_array($subject, $operand) ? $conditionalTpl : $tplCon;
break;
case \'between\':
case \'range\':
case \'>=<\':
case \'><\':
$operand = explode(\',\', $operand);
$tplCon = ($subject >= min($operand) && $subject <= max($operand)) ? $conditionalTpl : $tplCon;
break;
case \'==\':
case \'=\':
case \'eq\':
case \'is\':
case \'equal\':
case \'equals\':
case \'equalto\':
default:
$tplCon = (($subject == $operand) ? $conditionalTpl : $tplCon);
break;
}
}
if (!empty($tplCon)) {
$resourceTpl = parseTpl($tplCon, $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;',
'locked' => 0,
'properties' => 'a:42:{s:3:"tpl";a:7:{s:4:"name";s:3:"tpl";s:4:"desc";s:121:"Name of a chunk serving as a resource template. NOTE: if not provided, properties are dumped to output for each resource.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:6:"tplOdd";a:7:{s:4:"name";s:6:"tplOdd";s:4:"desc";s:100:"Name of a chunk serving as resource template for resources with an odd idx value (see idx property).";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:8:"tplFirst";a:7:{s:4:"name";s:8:"tplFirst";s:4:"desc";s:89:"Name of a chunk serving as resource template for the first resource (see first property).";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:7:"tplLast";a:7:{s:4:"name";s:7:"tplLast";s:4:"desc";s:87:"Name of a chunk serving as resource template for the last resource (see last property).";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:6:"sortby";a:7:{s:4:"name";s:6:"sortby";s:4:"desc";s:153:"A field name to sort by or JSON object of field names and sortdir for each field, e.g. {"publishedon":"ASC","createdon":"DESC"}. Defaults to publishedon.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:11:"publishedon";s:7:"lexicon";N;s:4:"area";s:0:"";}s:8:"sortbyTV";a:7:{s:4:"name";s:8:"sortbyTV";s:4:"desc";s:65:"Name of a Template Variable to sort by. Defaults to empty string.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:12:"sortbyTVType";a:7:{s:4:"name";s:12:"sortbyTVType";s:4:"desc";s:72:"An optional type to indicate how to sort on the Template Variable value.";s:4:"type";s:4:"list";s:7:"options";a:4:{i:0;a:2:{s:4:"text";s:6:"string";s:5:"value";s:6:"string";}i:1;a:2:{s:4:"text";s:7:"integer";s:5:"value";s:7:"integer";}i:2;a:2:{s:4:"text";s:7:"decimal";s:5:"value";s:7:"decimal";}i:3;a:2:{s:4:"text";s:8:"datetime";s:5:"value";s:8:"datetime";}}s:5:"value";s:6:"string";s:7:"lexicon";N;s:4:"area";s:0:"";}s:11:"sortbyAlias";a:7:{s:4:"name";s:11:"sortbyAlias";s:4:"desc";s:58:"Query alias for sortby field. Defaults to an empty string.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:13:"sortbyEscaped";a:7:{s:4:"name";s:13:"sortbyEscaped";s:4:"desc";s:82:"Determines if the field name specified in sortby should be escaped. Defaults to 0.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:1:"0";s:7:"lexicon";N;s:4:"area";s:0:"";}s:7:"sortdir";a:7:{s:4:"name";s:7:"sortdir";s:4:"desc";s:41:"Order which to sort by. Defaults to DESC.";s:4:"type";s:4:"list";s:7:"options";a:2:{i:0;a:2:{s:4:"text";s:3:"ASC";s:5:"value";s:3:"ASC";}i:1;a:2:{s:4:"text";s:4:"DESC";s:5:"value";s:4:"DESC";}}s:5:"value";s:4:"DESC";s:7:"lexicon";N;s:4:"area";s:0:"";}s:9:"sortdirTV";a:7:{s:4:"name";s:9:"sortdirTV";s:4:"desc";s:61:"Order which to sort a Template Variable by. Defaults to DESC.";s:4:"type";s:4:"list";s:7:"options";a:2:{i:0;a:2:{s:4:"text";s:3:"ASC";s:5:"value";s:3:"ASC";}i:1;a:2:{s:4:"text";s:4:"DESC";s:5:"value";s:4:"DESC";}}s:5:"value";s:4:"DESC";s:7:"lexicon";N;s:4:"area";s:0:"";}s:5:"limit";a:7:{s:4:"name";s:5:"limit";s:4:"desc";s:55:"Limits the number of resources returned. Defaults to 5.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:1:"5";s:7:"lexicon";N;s:4:"area";s:0:"";}s:6:"offset";a:7:{s:4:"name";s:6:"offset";s:4:"desc";s:56:"An offset of resources returned by the criteria to skip.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:1:"0";s:7:"lexicon";N;s:4:"area";s:0:"";}s:9:"tvFilters";a:7:{s:4:"name";s:9:"tvFilters";s:4:"desc";s:778:"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`. <br />NOTE: filtering by values uses a LIKE query and % is considered a wildcard. <br />ANOTHER 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.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:21:"tvFiltersAndDelimiter";a:7:{s:4:"name";s:21:"tvFiltersAndDelimiter";s:4:"desc";s:83:"The delimiter to use to separate logical AND expressions in tvFilters. Default is ,";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:1:",";s:7:"lexicon";N;s:4:"area";s:0:"";}s:20:"tvFiltersOrDelimiter";a:7:{s:4:"name";s:20:"tvFiltersOrDelimiter";s:4:"desc";s:83:"The delimiter to use to separate logical OR expressions in tvFilters. Default is ||";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:2:"||";s:7:"lexicon";N;s:4:"area";s:0:"";}s:5:"depth";a:7:{s:4:"name";s:5:"depth";s:4:"desc";s:88:"Integer value indicating depth to search for resources from each parent. Defaults to 10.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:2:"10";s:7:"lexicon";N;s:4:"area";s:0:"";}s:7:"parents";a:7:{s:4:"name";s:7:"parents";s:4:"desc";s:57:"Optional. Comma-delimited list of ids serving as parents.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:14:"includeContent";a:7:{s:4:"name";s:14:"includeContent";s:4:"desc";s:95:"Indicates if the content of each resource should be returned in the results. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:10:"includeTVs";a:7:{s:4:"name";s:10:"includeTVs";s:4:"desc";s:124:"Indicates if TemplateVar values should be included in the properties available to each resource template. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:13:"includeTVList";a:7:{s:4:"name";s:13:"includeTVList";s:4:"desc";s:96:"Limits included TVs to those specified as a comma-delimited list of TV names. Defaults to empty.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:10:"showHidden";a:7:{s:4:"name";s:10:"showHidden";s:4:"desc";s:85:"Indicates if Resources that are hidden from menus should be shown. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:15:"showUnpublished";a:7:{s:4:"name";s:15:"showUnpublished";s:4:"desc";s:79:"Indicates if Resources that are unpublished should be shown. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:11:"showDeleted";a:7:{s:4:"name";s:11:"showDeleted";s:4:"desc";s:75:"Indicates if Resources that are deleted should be shown. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:9:"resources";a:7:{s:4:"name";s:9:"resources";s:4:"desc";s:177:"A comma-separated list of resource IDs to exclude or include. IDs with a - in front mean to exclude. Ex: 123,-456 means to include Resource 123, but always exclude Resource 456.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:10:"processTVs";a:7:{s:4:"name";s:10:"processTVs";s:4:"desc";s:117:"Indicates if TemplateVar values should be rendered as they would on the resource being summarized. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:13:"processTVList";a:7:{s:4:"name";s:13:"processTVList";s:4:"desc";s:166:"Limits processed TVs to those specified as a comma-delimited list of TV names; note only includedTVs will be available for processing if specified. Defaults to empty.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:10:"prepareTVs";a:7:{s:4:"name";s:10:"prepareTVs";s:4:"desc";s:120:"Indicates if TemplateVar values that are not processed fully should be prepared before being returned. Defaults to true.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:1;s:7:"lexicon";N;s:4:"area";s:0:"";}s:13:"prepareTVList";a:7:{s:4:"name";s:13:"prepareTVList";s:4:"desc";s:164:"Limits prepared TVs to those specified as a comma-delimited list of TV names; note only includedTVs will be available for preparing if specified. Defaults to empty.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:8:"tvPrefix";a:7:{s:4:"name";s:8:"tvPrefix";s:4:"desc";s:55:"The prefix for TemplateVar properties. Defaults to: tv.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:3:"tv.";s:7:"lexicon";N;s:4:"area";s:0:"";}s:3:"idx";a:7:{s:4:"name";s:3:"idx";s:4:"desc";s:120:"You can define the starting idx of the resources, which is an property that is incremented as each resource is rendered.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:5:"first";a:7:{s:4:"name";s:5:"first";s:4:"desc";s:81:"Define the idx which represents the first resource (see tplFirst). Defaults to 1.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:4:"last";a:7:{s:4:"name";s:4:"last";s:4:"desc";s:129:"Define the idx which represents the last resource (see tplLast). Defaults to the number of resources being summarized + first - 1";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:13:"toPlaceholder";a:7:{s:4:"name";s:13:"toPlaceholder";s:4:"desc";s:85:"If set, will assign the result to this placeholder instead of outputting it directly.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:22:"toSeparatePlaceholders";a:7:{s:4:"name";s:22:"toSeparatePlaceholders";s:4:"desc";s:130:"If set, will assign EACH result to a separate placeholder named by this param suffixed with a sequential number (starting from 0).";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:5:"debug";a:7:{s:4:"name";s:5:"debug";s:4:"desc";s:68:"If true, will send the SQL query to the MODX log. Defaults to false.";s:4:"type";s:13:"combo-boolean";s:7:"options";s:0:"";s:5:"value";b:0;s:7:"lexicon";N;s:4:"area";s:0:"";}s:5:"where";a:7:{s:4:"name";s:5:"where";s:4:"desc";s:193:"A JSON expression of criteria to build any additional where clauses from, e.g. &where=`{{"alias:LIKE":"foo%", "OR:alias:LIKE":"%bar"},{"OR:pagetitle:=":"foobar", "AND:description:=":"raboof"}}`";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:11:"dbCacheFlag";a:7:{s:4:"name";s:11:"dbCacheFlag";s:4:"desc";s:218:"Determines how result sets are cached if cache_db is enabled in MODX. 0|false = do not cache result set; 1 = cache result set according to cache settings, any other integer value = number of seconds to cache result set";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:1:"0";s:7:"lexicon";N;s:4:"area";s:0:"";}s:7:"context";a:7:{s:4:"name";s:7:"context";s:4:"desc";s:116:"A comma-delimited list of context keys for limiting results. Default is empty, i.e. do not limit results by context.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:12:"tplCondition";a:7:{s:4:"name";s:12:"tplCondition";s:4:"desc";s:129:"A condition to compare against the conditionalTpls property to map Resources to different tpls based on custom conditional logic.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}s:11:"tplOperator";a:7:{s:4:"name";s:11:"tplOperator";s:4:"desc";s:125:"An optional operator to use for the tplCondition when comparing against the conditionalTpls operands. Default is == (equals).";s:4:"type";s:4:"list";s:7:"options";a:10:{i:0;a:2:{s:4:"text";s:11:"is equal to";s:5:"value";s:2:"==";}i:1;a:2:{s:4:"text";s:15:"is not equal to";s:5:"value";s:2:"!=";}i:2;a:2:{s:4:"text";s:9:"less than";s:5:"value";s:1:"<";}i:3;a:2:{s:4:"text";s:21:"less than or equal to";s:5:"value";s:2:"<=";}i:4;a:2:{s:4:"text";s:24:"greater than or equal to";s:5:"value";s:2:">=";}i:5;a:2:{s:4:"text";s:8:"is empty";s:5:"value";s:5:"empty";}i:6;a:2:{s:4:"text";s:12:"is not empty";s:5:"value";s:6:"!empty";}i:7;a:2:{s:4:"text";s:7:"is null";s:5:"value";s:4:"null";}i:8;a:2:{s:4:"text";s:11:"is in array";s:5:"value";s:7:"inarray";}i:9;a:2:{s:4:"text";s:10:"is between";s:5:"value";s:7:"between";}}s:5:"value";s:2:"==";s:7:"lexicon";N;s:4:"area";s:0:"";}s:15:"conditionalTpls";a:7:{s:4:"name";s:15:"conditionalTpls";s:4:"desc";s:121:"A JSON map of conditional operands and tpls to compare against the tplCondition property using the specified tplOperator.";s:4:"type";s:9:"textfield";s:7:"options";s:0:"";s:5:"value";s:0:"";s:7:"lexicon";N;s:4:"area";s:0:"";}}',
'moduleguid' => '',
'static' => 0,
'static_file' => '',
'content' => '/**
* getResources
*
* A general purpose Resource listing and summarization snippet for MODX 2.x.
*
* @author Jason Coward
* @copyright Copyright 2010-2012, Jason Coward
*
* 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
*
* context - (Opt) Comma-delimited list of context keys to limit results by; if empty, contexts for all specified
* parents will be used (all contexts if 0 is specified) [default=]
*
* 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.]
*
* tvFiltersAndDelimiter - (Opt) Custom delimiter for logical AND, default \',\', in case you want to
* match a literal comma in the tvFilters. E.g. &tvFiltersAndDelimiter=`&&`
* &tvFilters=`filter1==foo,bar&&filter2==baz` [default=,]
*
* tvFiltersOrDelimiter - (Opt) Custom delimiter for logical OR, default \'||\', in case you want to
* match a literal \'||\' in the tvFilters. E.g. &tvFiltersOrDelimiter=`|OR|`
* &tvFilters=`filter1==foo||bar|OR|filter2==baz` [default=||]
*
* 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]
* dbCacheFlag - (Opt) Controls caching of db queries; 0|false = do not cache result set; 1 = cache result set
* according to cache settings, any other integer value = number of seconds to cache result set [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]
* includeTVList - (Opt) Limits the TemplateVars that are included if includeTVs is true to those specified
* by name in a comma-delimited list [default=]
* prepareTVs - (Opt) Prepares media-source dependent TemplateVar values [default=1]
* prepareTVList - (Opt) Limits the TVs that are prepared to those specified by name in a comma-delimited
* list [default=]
* processTVs - (Opt) Indicates if TemplateVar values should be rendered as they would on the
* resource being summarized [default=0]
* processTVList - (opt) Limits the TemplateVars that are processed if included to those specified
* by name in a comma-delimited list [default=]
* 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;
$includeTVList = !empty($includeTVList) ? explode(\',\', $includeTVList) : array();
$processTVs = !empty($processTVs) ? true : false;
$processTVList = !empty($processTVList) ? explode(\',\', $processTVList) : array();
$prepareTVs = !empty($prepareTVs) ? true : false;
$prepareTVList = !empty($prepareTVList) ? explode(\',\', $prepareTVList) : array();
$tvPrefix = isset($tvPrefix) ? $tvPrefix : \'tv.\';
$parents = (!empty($parents) || $parents === \'0\') ? explode(\',\', $parents) : array($modx->resource->get(\'id\'));
array_walk($parents, \'trim\');
$parents = array_unique($parents);
$depth = isset($depth) ? (integer) $depth : 10;
$tvFiltersOrDelimiter = isset($tvFiltersOrDelimiter) ? $tvFiltersOrDelimiter : \'||\';
$tvFiltersAndDelimiter = isset($tvFiltersAndDelimiter) ? $tvFiltersAndDelimiter : \',\';
$tvFilters = !empty($tvFilters) ? explode($tvFiltersOrDelimiter, $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\';
$dbCacheFlag = !isset($dbCacheFlag) ? false : $dbCacheFlag;
if (is_string($dbCacheFlag) || is_numeric($dbCacheFlag)) {
if ($dbCacheFlag == \'0\') {
$dbCacheFlag = false;
} elseif ($dbCacheFlag == \'1\') {
$dbCacheFlag = true;
} else {
$dbCacheFlag = (integer) $dbCacheFlag;
}
}
/* multiple context support */
$contextArray = array();
$contextSpecified = false;
if (!empty($context)) {
$contextArray = explode(\',\',$context);
array_walk($contextArray, \'trim\');
$contexts = array();
foreach ($contextArray as $ctx) {
$contexts[] = $modx->quote($ctx);
}
$context = implode(\',\',$contexts);
$contextSpecified = true;
unset($contexts,$ctx);
} else {
$context = $modx->quote($modx->context->get(\'key\'));
}
$pcMap = array();
$pcQuery = $modx->newQuery(\'modResource\', array(\'id:IN\' => $parents), $dbCacheFlag);
$pcQuery->select(array(\'id\', \'context_key\'));
if ($pcQuery->prepare() && $pcQuery->stmt->execute()) {
foreach ($pcQuery->stmt->fetchAll(PDO::FETCH_ASSOC) as $pcRow) {
$pcMap[(integer) $pcRow[\'id\']] = $pcRow[\'context_key\'];
}
}
$children = array();
$parentArray = array();
foreach ($parents as $parent) {
$parent = (integer) $parent;
if ($parent === 0) {
$pchildren = array();
if ($contextSpecified) {
foreach ($contextArray as $pCtx) {
if (!in_array($pCtx, $contextArray)) {
continue;
}
$options = $pCtx !== $modx->context->get(\'key\') ? array(\'context\' => $pCtx) : array();
$pcchildren = $modx->getChildIds($parent, $depth, $options);
if (!empty($pcchildren)) $pchildren = array_merge($pchildren, $pcchildren);
}
} else {
$cQuery = $modx->newQuery(\'modContext\', array(\'key:!=\' => \'mgr\'));
$cQuery->select(array(\'key\'));
if ($cQuery->prepare() && $cQuery->stmt->execute()) {
foreach ($cQuery->stmt->fetchAll(PDO::FETCH_COLUMN) as $pCtx) {
$options = $pCtx !== $modx->context->get(\'key\') ? array(\'context\' => $pCtx) : array();
$pcchildren = $modx->getChildIds($parent, $depth, $options);
if (!empty($pcchildren)) $pchildren = array_merge($pchildren, $pcchildren);
}
}
}
$parentArray[] = $parent;
} else {
$pContext = array_key_exists($parent, $pcMap) ? $pcMap[$parent] : false;
if ($debug) $modx->log(modX::LOG_LEVEL_ERROR, "context for {$parent} is {$pContext}");
if ($pContext && $contextSpecified && !in_array($pContext, $contextArray, true)) {
$parent = next($parents);
continue;
}
$parentArray[] = $parent;
$options = !empty($pContext) && $pContext !== $modx->context->get(\'key\') ? array(\'context\' => $pContext) : array();
$pchildren = $modx->getChildIds($parent, $depth, $options);
}
if (!empty($pchildren)) $children = array_merge($children, $pchildren);
$parent = next($parents);
}
$parents = array_merge($parentArray, $children);
/* build query */
$criteria = array("modResource.parent IN (" . implode(\',\', $parents) . ")");
if ($contextSpecified) {
$contextResourceTbl = $modx->getTableName(\'modContextResource\');
$criteria[] = "(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[\'deleted\'] = \'0\';
}
if (empty($showUnpublished)) {
$criteria[\'published\'] = \'1\';
}
if (empty($showHidden)) {
$criteria[\'hidemenu\'] = \'0\';
}
if (!empty($hideContainers)) {
$criteria[\'isfolder\'] = \'0\';
}
$criteria = $modx->newQuery(\'modResource\', $criteria);
if (!empty($tvFilters)) {
$tmplVarTbl = $modx->getTableName(\'modTemplateVar\');
$tmplVarResourceTbl = $modx->getTableName(\'modTemplateVarResource\');
$conditions = array();
$operators = array(
\'<=>\' => \'<=>\',
\'===\' => \'=\',
\'!==\' => \'!=\',
\'<>\' => \'<>\',
\'==\' => \'LIKE\',
\'!=\' => \'NOT LIKE\',
\'<<\' => \'<\',
\'<=\' => \'<=\',
\'=<\' => \'=<\',
\'>>\' => \'>\',
\'>=\' => \'>=\',
\'=>\' => \'=>\'
);
foreach ($tvFilters as $fGroup => $tvFilter) {
$filterGroup = array();
$filters = explode($tvFiltersAndDelimiter, $tvFilter);
$multiple = count($filters) > 0;
foreach ($filters as $filter) {
$operator = \'==\';
$sqlOperator = \'LIKE\';
foreach ($operators as $op => $opSymbol) {
if (strpos($filter, $op, 1) !== false) {
$operator = $op;
$sqlOperator = $opSymbol;
break;
}
}
$tvValueField = \'tvr.value\';
$tvDefaultField = \'tv.default_text\';
$f = explode($operator, $filter);
if (count($f) == 2) {
$tvName = $modx->quote($f[0]);
if (is_numeric($f[1]) && !in_array($sqlOperator, array(\'LIKE\', \'NOT LIKE\'))) {
$tvValue = $f[1];
if ($f[1] == (integer)$f[1]) {
$tvValueField = "CAST({$tvValueField} AS SIGNED INTEGER)";
$tvDefaultField = "CAST({$tvDefaultField} AS SIGNED INTEGER)";
} else {
$tvValueField = "CAST({$tvValueField} AS DECIMAL)";
$tvDefaultField = "CAST({$tvDefaultField} AS DECIMAL)";
}
} else {
$tvValue = $modx->quote($f[1]);
}
if ($multiple) {
$filterGroup[] =
"(EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.name = {$tvName} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) " .
"OR EXISTS (SELECT 1 FROM {$tmplVarTbl} tv WHERE tv.name = {$tvName} AND {$tvDefaultField} {$sqlOperator} {$tvValue} AND tv.id NOT IN (SELECT tmplvarid FROM {$tmplVarResourceTbl} WHERE contentid = modResource.id)) " .
")";
} else {
$filterGroup =
"(EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.name = {$tvName} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) " .
"OR EXISTS (SELECT 1 FROM {$tmplVarTbl} tv WHERE tv.name = {$tvName} AND {$tvDefaultField} {$sqlOperator} {$tvValue} AND tv.id NOT IN (SELECT tmplvarid FROM {$tmplVarResourceTbl} WHERE contentid = modResource.id)) " .
")";
}
} elseif (count($f) == 1) {
$tvValue = $modx->quote($f[0]);
if ($multiple) {
$filterGroup[] = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
} else {
$filterGroup = "EXISTS (SELECT 1 FROM {$tmplVarResourceTbl} tvr JOIN {$tmplVarTbl} tv ON {$tvValueField} {$sqlOperator} {$tvValue} AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id)";
}
}
}
$conditions[] = $filterGroup;
}
if (!empty($conditions)) {
$firstGroup = true;
foreach ($conditions as $cGroup => $c) {
if (is_array($c)) {
$first = true;
foreach ($c as $cond) {
if ($first && !$firstGroup) {
$criteria->condition($criteria->query[\'where\'][0][1], $cond, xPDOQuery::SQL_OR, null, $cGroup);
} else {
$criteria->condition($criteria->query[\'where\'][0][1], $cond, xPDOQuery::SQL_AND, null, $cGroup);
}
$first = false;
}
} else {
$criteria->condition($criteria->query[\'where\'][0][1], $c, $firstGroup ? xPDOQuery::SQL_AND : xPDOQuery::SQL_OR, null, $cGroup);
}
$firstGroup = false;
}
}
}
/* include/exclude resources, via &resources=`123,-456` prop */
if (!empty($resources)) {
$resourceConditions = array();
$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->where(array(\'OR:modResource.id:IN\' => $include), xPDOQuery::SQL_OR);
}
if (!empty($exclude)) {
$criteria->where(array(\'modResource.id:NOT IN\' => $exclude), xPDOQuery::SQL_AND, null, 1);
}
}
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, $dbCacheFlag);
$idx = !empty($idx) && $idx !== \'0\' ? (integer) $idx : 1;
$first = empty($first) && $first !== \'0\' ? 1 : (integer) $first;
$last = empty($last) ? (count($collection) + $idx - 1) : (integer) $last;
/* include parseTpl */
include_once $modx->getOption(\'getresources.core_path\',null,$modx->getOption(\'core_path\').\'components/getresources/\').\'include.parsetpl.php\';
$templateVars = array();
if (!empty($includeTVs) && !empty($includeTVList)) {
$templateVars = $modx->getCollection(\'modTemplateVar\', array(\'name:IN\' => $includeTVList));
}
/** @var modResource $resource */
foreach ($collection as $resourceId => $resource) {
$tvs = array();
if (!empty($includeTVs)) {
if (empty($includeTVList)) {
$templateVars = $resource->getMany(\'TemplateVars\');
}
/** @var modTemplateVar $templateVar */
foreach ($templateVars as $tvId => $templateVar) {
if (!empty($includeTVList) && !in_array($templateVar->get(\'name\'), $includeTVList)) continue;
if ($processTVs && (empty($processTVList) || in_array($templateVar->get(\'name\'), $processTVList))) {
$tvs[$tvPrefix . $templateVar->get(\'name\')] = $templateVar->renderOutput($resource->get(\'id\'));
} else {
$value = $templateVar->getValue($resource->get(\'id\'));
if ($prepareTVs && method_exists($templateVar, \'prepareOutput\') && (empty($prepareTVList) || in_array($templateVar->get(\'name\'), $prepareTVList))) {
$value = $templateVar->prepareOutput($value);
}
$tvs[$tvPrefix . $templateVar->get(\'name\')] = $value;
}
}
}
$odd = ($idx & 1);
$properties = array_merge(
$scriptProperties
,array(
\'idx\' => $idx
,\'first\' => $first
,\'last\' => $last
,\'odd\' => $odd
)
,$includeContent ? $resource->toArray() : $resource->get($fields)
,$tvs
);
$resourceTpl = \'\';
if ($idx == $first && !empty($tplFirst)) {
$resourceTpl = parseTpl($tplFirst, $properties);
}
if ($idx == $last && empty($resourceTpl) && !empty($tplLast)) {
$resourceTpl = parseTpl($tplLast, $properties);
}
$tplidx = \'tpl_\' . $idx;
if (empty($resourceTpl) && !empty($$tplidx)) {
$resourceTpl = parseTpl($$tplidx, $properties);
}
if ($idx > 1 && empty($resourceTpl)) {
$divisors = getDivisors($idx);
if (!empty($divisors)) {
foreach ($divisors as $divisor) {
$tplnth = \'tpl_n\' . $divisor;
if (!empty($$tplnth)) {
$resourceTpl = parseTpl($$tplnth, $properties);
if (!empty($resourceTpl)) {
break;
}
}
}
}
}
if ($odd && empty($resourceTpl) && !empty($tplOdd)) {
$resourceTpl = parseTpl($tplOdd, $properties);
}
if (!empty($tplCondition) && !empty($conditionalTpls) && empty($resourceTpl)) {
$conTpls = $modx->fromJSON($conditionalTpls);
$subject = $properties[$tplCondition];
$tplOperator = !empty($tplOperator) ? $tplOperator : \'=\';
$tplOperator = strtolower($tplOperator);
$tplCon = \'\';
foreach ($conTpls as $operand => $conditionalTpl) {
switch ($tplOperator) {
case \'!=\':
case \'neq\':
case \'not\':
case \'isnot\':
case \'isnt\':
case \'unequal\':
case \'notequal\':
$tplCon = (($subject != $operand) ? $conditionalTpl : $tplCon);
break;
case \'<\':
case \'lt\':
case \'less\':
case \'lessthan\':
$tplCon = (($subject < $operand) ? $conditionalTpl : $tplCon);
break;
case \'>\':
case \'gt\':
case \'greater\':
case \'greaterthan\':
$tplCon = (($subject > $operand) ? $conditionalTpl : $tplCon);
break;
case \'<=\':
case \'lte\':
case \'lessthanequals\':
case \'lessthanorequalto\':
$tplCon = (($subject <= $operand) ? $conditionalTpl : $tplCon);
break;
case \'>=\':
case \'gte\':
case \'greaterthanequals\':
case \'greaterthanequalto\':
$tplCon = (($subject >= $operand) ? $conditionalTpl : $tplCon);
break;
case \'isempty\':
case \'empty\':
$tplCon = empty($subject) ? $conditionalTpl : $tplCon;
break;
case \'!empty\':
case \'notempty\':
case \'isnotempty\':
$tplCon = !empty($subject) && $subject != \'\' ? $conditionalTpl : $tplCon;
break;
case \'isnull\':
case \'null\':
$tplCon = $subject == null || strtolower($subject) == \'null\' ? $conditionalTpl : $tplCon;
break;
case \'inarray\':
case \'in_array\':
case \'ia\':
$operand = explode(\',\', $operand);
$tplCon = in_array($subject, $operand) ? $conditionalTpl : $tplCon;
break;
case \'between\':
case \'range\':
case \'>=<\':
case \'><\':
$operand = explode(\',\', $operand);
$tplCon = ($subject >= min($operand) && $subject <= max($operand)) ? $conditionalTpl : $tplCon;
break;
case \'==\':
case \'=\':
case \'eq\':
case \'is\':
case \'equal\':
case \'equals\':
case \'equalto\':
default:
$tplCon = (($subject == $operand) ? $conditionalTpl : $tplCon);
break;
}
}
if (!empty($tplCon)) {
$resourceTpl = parseTpl($tplCon, $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;',
),
),
);