Artifact 237cb6df6ae1052108e0a846770281b4aeaef645f83e5c9fc2e4186ea957f5a6:
- File src/include/lib/Garradin/Search.php — part of check-in [973cc37152] at 2022-04-03 17:54:07 on branch dev — Refactor saved searches (user: bohwaz, size: 456) [annotate] [blame] [check-ins using]
<?php namespace Garradin; use Garradin\Entities\Search as SE; use KD2\DB\EntityManager as EM; class Search { static public function list(int $id_user, string $target): array { return EM::getInstance(SE::class)->all('SELECT * FROM @TABLE WHERE (id_user IS NULL OR id_user = ?) AND target = ? ORDER BY label COLLATE U_NOCASE;', $id_user, $target); } static public function get(int $id): ?SE { return EM::findOneById(SE::class, $id); } }