+ protected function applyFilter(Request $request, Builder $query) {
+ $validatedData = $request->validate([
+ 'phrase' => 'string|nullable',
+ 'ruleset' => 'array|nullable',
+ 'ruleset.competitive' => 'boolean',
+ 'ruleset.mg' => 'boolean',
+ 'ruleset.nl' => 'boolean',
+ 'ruleset.owg' => 'boolean',
+ 'type' => 'string|nullable',
+ ]);
+
+ if (!empty($validatedData['type'])) {
+ $query->where('type', '=', $validatedData['type']);
+ }
+
+ if (!empty($validatedData['phrase'])) {
+ $search = $validatedData['phrase'];
+ $query->where(function (Builder $query) use ($search) {
+ $query->where('title', 'LIKE', '%'.$search.'%')
+ ->orWhere('short', 'LIKE', '%'.$search.'%');
+ });
+ }
+
+ if (isset($validatedData['ruleset'])) {
+ $com = isset($validatedData['ruleset']['competitive']) && $validatedData['ruleset']['competitive'];
+ $owg = isset($validatedData['ruleset']['owg']) && $validatedData['ruleset']['owg'];
+ $mg = isset($validatedData['ruleset']['mg']) && $validatedData['ruleset']['mg'];
+ $nl = isset($validatedData['ruleset']['nl']) && $validatedData['ruleset']['nl'];
+ $any = $com || $owg || $mg || $nl;
+ $all = $com && $owg && $mg && $nl;
+ if ($any && !$all) {
+ $query->where(function(Builder $query) use ($com, $owg, $mg, $nl) {
+ $query->whereNull('rulesets');
+ if ($com) {
+ $query->orWhere('rulesets->competitive', '=', true);
+ }
+ if ($owg) {
+ $query->orWhere('rulesets->owg', '=', true);
+ }
+ if ($mg) {
+ $query->orWhere('rulesets->mg', '=', true);
+ }
+ if ($nl) {
+ $query->orWhere('rulesets->nl', '=', true);
+ }
+ });
+ }
+ }
+ }
+