. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Services; use Fisharebest\Webtrees\Registry; use Fisharebest\Webtrees\Validator; use Illuminate\Database\Capsule\Manager as DB; use Illuminate\Database\Query\Builder; use Illuminate\Database\Query\Expression; use Psr\Http\Message\ServerRequestInterface; use function addcslashes; /** * Manage site logs */ class SiteLogsService { /** * Generate a query for filtering the changes log. * * @param ServerRequestInterface $request * * @return Builder */ public function logsQuery(ServerRequestInterface $request): Builder { $tree = Validator::queryParams($request)->string('tree'); $from = Validator::queryParams($request)->string('from'); $to = Validator::queryParams($request)->string('to'); $type = Validator::queryParams($request)->string('type'); $text = Validator::queryParams($request)->string('text'); $ip = Validator::queryParams($request)->string('ip'); $username = Validator::queryParams($request)->string('username'); $query = DB::table('log') ->leftJoin('user', 'user.user_id', '=', 'log.user_id') ->leftJoin('gedcom', 'gedcom.gedcom_id', '=', 'log.gedcom_id') ->select(['log.*', new Expression("COALESCE(user_name, '') AS user_name"), new Expression("COALESCE(gedcom_name, '') AS gedcom_name")]); if ($from !== '') { $query->where('log_time', '>=', Registry::timestampFactory()->fromString($from, 'Y-m-d')->toDateString()); } if ($to !== '') { // before end of the day $query->where('log_time', '<', Registry::timestampFactory()->fromString($to, 'Y-m-d')->addDays(1)->toDateString()); } if ($type !== '') { $query->where('log_type', '=', $type); } if ($text !== '') { $query->where('log_message', 'LIKE', '%' . addcslashes($text, '\\%_') . '%'); } if ($ip !== '') { $query->where('ip_address', 'LIKE', addcslashes($ip, '\\%_') . '%'); } if ($username !== '') { $query->where('user_name', '=', $username); } if ($tree !== '') { $query->where('gedcom_name', '=', $tree); } return $query; } }