$val) {
if (preg_match('/sort|page|min_|max_|filter_/i', $key)) {
$props[$key] = $val;
if (preg_match('/filter_/i', $key) && gettype($val) == 'string') {
$props[$key] = explode(',', $val);
}
}
}
array_multisort($props); // для кэша
$cache_name = "msp_{$modx->resource->id}_" . md5(json_encode($props));
$cache = $modx->cacheManager->get($cache_name, [\xPDO::OPT_CACHE_KEY => 'resource']);
if ($cache) {
$cache['debug']['cache'] = $cache_name;
return $cache;
}
foreach ($props as $key => $val) {
if ($key == 'sort') {
$s = explode('_', $val);
if (isset($s[0])) {
$sortby = $s[0];
if (in_array($s[0], ['price'])) {
$sortby = "Data.{$s[0]}";
}
if (isset($s[1]) && $s[1] == 'desc') {
$sortdir = 'DESC';
}
}
}
if (preg_match('/min_|max_/i', $key)) {
$keys = explode('_', $key);
$c = $keys[0] == 'min' ? '>=' : '<=';
if ($keys[1] == 'price') {
$where[] = "Data.price {$c} " . (int)$val;
} else {
$leftJoin[$keys[1]] = [
'class' => 'msProductOption',
'alias' => $keys[1],
'on' => "`{$keys[1]}`.product_id = Data.id AND `{$keys[1]}`.key = '{$keys[1]}'"
];
$where[] = "(`{$keys[1]}`.value * 1) {$c} $val";
if ($keys[0] == 'max') {
$where[] = "`{$keys[1]}`.value != ''";
}
}
}
if (preg_match('/filter_/i', $key)) {
$key = str_replace('filter_', '', $key);
$optionFilters["{$key}:IN"] = $val;
}
}
$params = array_merge([
'element' => 'msProducts',
'limit' => 12,
'pageLimit' => 7,
'return' => 'JSON',
'setMeta' => 0, // без этого долго загружается
'sortby' => $sortby,
'sortdir' => $sortdir,
'tvPrefix'=>'',
'leftJoin' => !empty($leftJoin) ? $leftJoin : '',
'optionFilters' => !empty($optionFilters) ? json_encode($optionFilters) : '',
'where' => count($where) ? '["' . implode(' AND ', $where) . '"]' : '',
'tplPage'=>'@INLINE {$pageNo}',
'tplPageActive'=>'@INLINE ',
'tplPageSkip' => '@INLINE ',
'tplPageWrapper'=>'@INLINE ',
], $scriptProperties);
$response = $modx->runSnippet('pdoPage', $params);
$out['debug'] = [
'params' => $params,
'props' => $props,
];
$out['page'] = (int)$modx->placeholders['page'];
$out['pages'] = (int)$modx->placeholders['pageCount'];
$out['pagination'] = $modx->placeholders['page.nav'];
$out['items'] = json_decode($response, true);
$modx->cacheManager->set($cache_name, $out, 0, [\xPDO::OPT_CACHE_KEY => 'resource']);
return $out;