Lines Matching refs:query

171         $query = DB::table('families')
175             $query->whereBetween('f_id', [$params['start'], $params['end']]);
178         return $query;
202         $query = DB::table('individuals')
206             $query->whereBetween('i_id', [$params['start'], $params['end']]);
209         return $query;
233         $query = DB::table('other')
238             $query->whereBetween('o_id', [$params['start'], $params['end']]);
241         return $query;
265         $query = DB::table('media')
269             $query->whereBetween('m_id', [$params['start'], $params['end']]);
272         return $query;
296         $query = DB::table('other')
301             $query->whereBetween('o_id', [$params['start'], $params['end']]);
304         return $query;
328         $query = DB::table('other')
333             $query->whereBetween('o_id', [$params['start'], $params['end']]);
336         return $query;
360         $query = DB::table('sources')
364             $query->whereBetween('s_id', [$params['start'], $params['end']]);
367         return $query;
391         $query = DB::table('other')
396             $query->whereBetween('o_id', [$params['start'], $params['end']]);
399         return $query;
416             ->where(static function (Builder $query) use ($type): void {
417                 $query