Files
HolgerHatGarKeineNode f93190f029 Add whereLike and orWhereLike macros for driver-agnostic case-insensitive searches
- 🔄 Replace `ilike`/`like` conditions with `whereLike` in API controllers and search tools for consistency.
- 🚀 Enhance query usability by ensuring cross-database compatibility (PostgreSQL and SQLite).
2026-06-14 01:32:03 +02:00

53 lines
1.6 KiB
PHP

<?php
namespace App\Mcp\Tools\Search;
use App\Models\Country;
use Illuminate\Contracts\JsonSchema\JsonSchema;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\JsonSchema\Types\Type;
use Laravel\Mcp\Request;
use Laravel\Mcp\Response;
use Laravel\Mcp\Server\Attributes\Description;
use Laravel\Mcp\Server\Tool;
use Laravel\Mcp\Server\Tools\Annotations\IsReadOnly;
#[IsReadOnly]
#[Description('Listet Länder (öffentlich) und liefert id, name und code (Ländercode), alphabetisch sortiert, begrenzt auf 10 Einträge. Jedes Land enthält zusätzlich eine flag (SVG-URL). Dient zum Auflösen von country_id.')]
class ListCountriesTool extends Tool
{
public function handle(Request $request): Response
{
$search = $request->get('search');
$countries = Country::query()
->select('id', 'name', 'code')
->orderBy('name')
->when(
$search,
fn (Builder $query) => $query
->whereLike('name', "%{$search}%")
->orWhereLike('code', "%{$search}%"),
)
->limit(10)
->get()
->map(function (Country $country) {
$country->flag = asset('vendor/blade-flags/country-'.$country->code.'.svg');
return $country;
});
return Response::json($countries->values());
}
/**
* @return array<string, Type>
*/
public function schema(JsonSchema $schema): array
{
return [
'search' => $schema->string()->description('Suche in Name oder Code (Ländercode).'),
];
}
}