X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FHttp%2FControllers%2FTechniqueController.php;h=8694c046de5e1dd1520158c883e55ef8486a52bd;hb=2c5535946aa15278c6e969c9a9b24d32a45e5b12;hp=cce39cea34f5e628218393d6d5ab04a01b853490;hpb=7e8555cfc96dcd364ca4fe9895e51af1bb04b546;p=alttp.git diff --git a/app/Http/Controllers/TechniqueController.php b/app/Http/Controllers/TechniqueController.php index cce39ce..8694c04 100644 --- a/app/Http/Controllers/TechniqueController.php +++ b/app/Http/Controllers/TechniqueController.php @@ -3,14 +3,69 @@ namespace App\Http\Controllers; use App\Models\Technique; +use Illuminate\Database\Eloquent\Builder; use Illuminate\Http\Request; class TechniqueController extends Controller { + public function search(Request $request) { + $validatedData = $request->validate([ + 'phrase' => 'string|nullable', + 'ruleset' => 'array|nullable', + 'ruleset.competitive' => 'boolean', + 'ruleset.mg' => 'boolean', + 'ruleset.nl' => 'boolean', + 'ruleset.owg' => 'boolean', + 'type' => 'string|nullable', + ]); + + $techs = Technique::where('index', '=', 1); + + if (!empty($validatedData['type'])) { + $techs = $techs->where('type', '=', $validatedData['type']); + } + + if (!empty($validatedData['phrase'])) { + $search = $validatedData['phrase']; + $techs = $techs->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) { + $techs->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); + } + }); + } + } + + return $techs->get()->toJson(); + } + public function single(Request $request, Technique $tech) { $this->authorize('view', $tech); - $tech->load('chapters'); + $tech->load(['chapters', 'relations']); return $tech->toJson(); }