. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Services; use Fisharebest\Webtrees\Carbon; use Illuminate\Database\Capsule\Manager as DB; use Illuminate\Database\Query\Builder; use Illuminate\Database\Query\Expression; use function addcslashes; /** * Manage site logs */ class SiteLogsService { /** * Generate a query for filtering the changes log. * * @param array $params * * @return Builder */ public function logsQuery(array $params): Builder { $tree = $params['tree']; $from = $params['from']; $to = $params['to']; $type = $params['type']; $text = $params['text']; $ip = $params['ip']; $username = $params['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', '>=', $from); } if ($to !== '') { // before end of the day $query->where('log_time', '<', Carbon::make($to)->addDay()); } 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; } }