1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
<?php
namespace JsonApi\Routes\Resources;
use JsonApi\Schemas\ResourceSchema;
use JsonApi\Errors\BadRequestException;
use JsonApi\JsonApiController;
use Psr\Http\Message\{
RequestInterface as Request,
ResponseInterface as Response
};
final class ResourceIndex extends JsonApiController
{
protected $allowedFilteringParameters = ['level', 'class'];
protected $allowedIncludePaths = [ResourceSchema::REL_CATEGORY];
protected $allowedPagingParameters = ['offset', 'limit'];
public function __invoke(Request $request, Response $response, array $args): Response
{
[$offset, $limit] = $this->getOffsetAndLimit();
[$condition, $parameters] = $this->getConditionAndParameters(
$this->getFilters()
);
$total = \Resource::countBySql($condition, $parameters);
$resources = \Resource::findBySQL(
"{$condition} LIMIT {$offset}, {$limit}",
$parameters
);
return $this->getPaginatedContentResponse($resources, $total);
}
private function getFilters()
{
$filters = [];
$filtering = $this->getQueryParameters()->getFilteringParameters() ?? [];
if (array_key_exists('level', $filtering)) {
if (!ctype_digit($filtering['level'])) {
throw new BadRequestException('Level filter must be an int.');
}
$filters['level'] = (int) $filtering['level'];
}
if (array_key_exists('class', $filtering)) {
if (empty($filtering['class'])) {
throw new BadRequestException('Class filter must be not be empty.');
}
$filters['class'] = $filtering['class'];
}
return $filters;
}
private function getConditionAndParameters(array $filters): array
{
$joins = [];
$conditions = [];
$parameters = [];
if (array_key_exists('level', $filters)) {
$conditions[] = '`resources`.`level` = :level';
$parameters[':level'] = $filters['level'];
}
if (array_key_exists('class', $filters)) {
$joins[] = 'JOIN `resource_categories`
ON `resources`.`category_id` = `resource_categories`.`id`';
$conditions[] = '`resource_categories`.`class_name` = :class';
$parameters[':class'] = $filters['class'];
}
// Build condition
$condition = implode(' ', $joins);
if ($condition) {
$condition .= ' WHERE ';
}
if (count($conditions) === 0) {
$conditions[] = '1';
}
$condition .= implode(' AND ', array_map(
function ($condition): string {
return "({$condition})";
},
$conditions
));
return [
$condition,
$parameters,
];
}
}
|
