* @param list > $projection * @param list ,operator:string,value:mixed}> $filters * @param list ,direction:string}> $sort * @return list > */
(int $datasetId, array $projection, array $filters, array $sort, bool $aggregate, int $limit, int $offset)
| 234 | * @return list<array<string,mixed>> |
| 235 | */ |
| 236 | public function query(int $datasetId, array $projection, array $filters, array $sort, bool $aggregate, int $limit, int $offset): array { |
| 237 | $this->parameterCounter = 0; |
| 238 | $sql = $this->db->getQueryBuilder(); |
| 239 | $sql->from(self::RECORD_TABLE, 'r') |
| 240 | ->where($sql->expr()->eq('r.dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))); |
| 241 | |
| 242 | $required = []; |
| 243 | foreach ($projection as $item) { |
| 244 | $required[(int)$item['column']['id']] = $item['column']; |
| 245 | } |
| 246 | foreach ($filters as $filter) { |
| 247 | $required[(int)$filter['column']['id']] = $filter['column']; |
| 248 | } |
| 249 | foreach ($sort as $item) { |
| 250 | $required[(int)$item['column']['id']] = $item['column']; |
| 251 | } |
| 252 | foreach ($required as $column) { |
| 253 | $alias = $this->valueAlias($column); |
| 254 | $sql->leftJoin('r', self::VALUE_TABLE, $alias, $sql->expr()->andX( |
| 255 | $sql->expr()->eq($alias . '.dataset_id', 'r.dataset_id'), |
| 256 | $sql->expr()->eq($alias . '.record_id', 'r.id'), |
| 257 | $sql->expr()->eq($alias . '.column_id', $sql->createNamedParameter((int)$column['id'], IQueryBuilder::PARAM_INT)) |
| 258 | )); |
| 259 | } |
| 260 | |
| 261 | if (!$aggregate) { |
| 262 | $sql->selectAlias('r.id', 'record_id'); |
| 263 | } |
| 264 | $dimensionSort = []; |
| 265 | foreach ($projection as $item) { |
| 266 | $column = $item['column']; |
| 267 | $field = $this->valueAlias($column) . '.' . FlexibleColumnResolver::valueField($column); |
| 268 | $outputAlias = 'c_' . (int)$column['id']; |
| 269 | if ($aggregate && $column['role'] === 'measure') { |
| 270 | $aggregation = $item['aggregation']; |
| 271 | $expression = match ($aggregation) { |
| 272 | 'sum' => $sql->func()->sum($field), |
| 273 | 'min' => $sql->func()->min($field), |
| 274 | 'max' => $sql->func()->max($field), |
| 275 | 'count' => $sql->func()->count($field), |
| 276 | 'avg' => $sql->createFunction('AVG(' . $field . ')'), |
| 277 | 'count_distinct' => $sql->createFunction('COUNT(DISTINCT ' . $field . ')'), |
| 278 | default => throw new \InvalidArgumentException('Unsupported aggregation'), |
| 279 | }; |
| 280 | $sql->selectAlias($expression, $outputAlias); |
| 281 | } else { |
| 282 | $sql->selectAlias($field, $outputAlias); |
| 283 | if ($aggregate) { |
| 284 | $sql->addGroupBy($field); |
| 285 | $dimensionSort[] = $outputAlias; |
| 286 | } |
| 287 | } |
| 288 | } |
| 289 | |
| 290 | $this->applyFilters($sql, $filters); |
| 291 | foreach ($sort as $item) { |
| 292 | $column = $item['column']; |
| 293 | $outputAlias = 'c_' . (int)$column['id']; |
nothing calls this directly
no test coverage detected