skiv86

public function getRemainsValues(array $fields, array $ids) {
		$filters = array();
		$q = $this->modx->newQuery('modResource');
		$q->leftJoin('msprRemains', 'Remains', ['modResource.id = Remains.product_id']);
$q->select($this->modx->getSelectColumns('msprRemains', 'Remains'));
 

		 $q->where(array('modResource.id:IN' => $ids));
	 	 $q->select('modResource.id,' . implode(',', $fields));
		$tstart = microtime(true);
		if ($q->prepare() && $q->stmt->execute()) {
			$this->modx->queryTime += microtime(true) - $tstart;
			$this->modx->executedQueries++;
			while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
				foreach ($row as $k => $v) {
					$v = str_replace('"', '"', trim($v));
					if ($k == 'id') {
						continue;
					}
					elseif (isset($filters[$k][$v])) {
						$filters[$k][$v][$row['id']] = $row['id'];
					}
					else {
						$filters[$k][$v] = array($row['id'] => $row['id']);
					}
				}
			}
		}
		else {
			$this->modx->log(modX::LOG_LEVEL_ERROR, "[mSearch2] Error on get filter params.\nQuery: " . $q->toSQL() .
				"\nResponse: " . print_r($q->stmt->errorInfo(), 1)
			);
		}

		return $filters;
	}