app/Report/ReportParserGenerate.php

1913                 foreach ($attrs as $attr => $value) {
1914                     if (str_starts_with($attr, 'filter') && $value !== '') {
1918 …           $query->join('dates AS ' . $attr, static function (JoinClause $join) use ($attr): void {
1920                                     ->on($attr . '.d_gid', '=', 'i_id')
1921                                     ->on($attr . '.d_file', '=', 'i_file');
1924                             $query->where($attr . '.d_fact', '=', $match[1]);
1929 …                           $query->where($attr . '.d_julianday2', '<=', $date->maximumJulianDay());
1931 …                           $query->where($attr . '.d_julianday1', '>=', $date->minimumJulianDay());
1935                             unset($attrs[$attr]);
1937 …            $query->join('name AS ' . $attr, static function (JoinClause $join) use ($attr): void {
1939                                     ->on($attr . '.n_id', '=', 'i_id')
1940                                     ->on($attr . '.n_file', '=', 'i_file');
1945 …                  $query->where($attr . '.n_full', 'LIKE', '%' . addcslashes($name, '\\%_') . '%');
1949                             unset($attrs[$attr]);
1957                             unset($attrs[$attr]);
1961 …      ->join('placelinks AS ' . $attr . 'a', static function (JoinClause $join) use ($attr): void {
1963                                         ->on($attr . 'a.pl_file', '=', 'i_file')
1964                                         ->on($attr . 'a.pl_gid', '=', 'i_id');
1966 …          ->join('places AS ' . $attr . 'b', static function (JoinClause $join) use ($attr): void {
1968                                         ->on($attr . 'b.p_file', '=', $attr . 'a.pl_file')
1969                                         ->on($attr . 'b.p_id', '=', $attr . 'a.pl_p_id');
1971 …                  ->where($attr . 'b.p_place', 'LIKE', '%' . addcslashes($match[1], '\\%_') . '%');
1999                 foreach ($attrs as $attr => $value) {
2000                     if (str_starts_with($attr, 'filter') && $value !== '') {
2004 …           $query->join('dates AS ' . $attr, static function (JoinClause $join) use ($attr): void {
2006                                     ->on($attr . '.d_gid', '=', 'f_id')
2007                                     ->on($attr . '.d_file', '=', 'f_file');
2010                             $query->where($attr . '.d_fact', '=', $match[1]);
2015 …                           $query->where($attr . '.d_julianday2', '<=', $date->maximumJulianDay());
2017 …                           $query->where($attr . '.d_julianday1', '>=', $date->minimumJulianDay());
2021                             unset($attrs[$attr]);
2029                             unset($attrs[$attr]);
2032 …            $query->join('name AS ' . $attr, static function (JoinClause $join) use ($attr): void {
2034                                         ->on($attr . '.n_file', '=', 'f_file')
2045 …                  $query->where($attr . '.n_full', 'LIKE', '%' . addcslashes($name, '\\%_') . '%');
2051                             unset($attrs[$attr]);
2055 …      ->join('placelinks AS ' . $attr . 'a', static function (JoinClause $join) use ($attr): void {
2057                                         ->on($attr . 'a.pl_file', '=', 'f_file')
2058                                         ->on($attr . 'a.pl_gid', '=', 'f_id');
2060 …          ->join('places AS ' . $attr . 'b', static function (JoinClause $join) use ($attr): void {
2062                                         ->on($attr . 'b.p_file', '=', $attr . 'a.pl_file')
2063                                         ->on($attr . 'b.p_id', '=', $attr . 'a.pl_p_id');
2065 …                  ->where($attr . 'b.p_place', 'LIKE', '%' . addcslashes($match[1], '\\%_') . '%');