Lines Matching refs:query

100         $query = DB::table('name')
115                 $query->where('i_sex', '=', $sex);
120                 $query->where('i_sex', '<>', 'U');
124         $rows = $query
451         $query = DB::table('name')
456             $query
462             $query->whereIn('n_givn', $params);
465         $count = $query->count('n_givn');
479         $query = DB::table('name')
484             $query->distinct()
488             $query->whereIn('n_surn', $params);
491         $count = $query->count('n_surn');
684         $query = DB::table('dates')
692             $query->whereBetween('d_year', [$year1, $year2]);
695         return $query;
742         $query = DB::table('dates')
750             $query->whereBetween('d_year', [$year1, $year2]);
753         return $query;
802         $query = $this->birthAndDeathQuery($sex);
805             $query
810                 $query->whereBetween('birth.d_year', [$year1, $year2]);
812                 $query->whereBetween('death.d_year', [$year1, $year2]);
816         return $query
1122         $query = DB::table('dates')
1136             $query->where('i_sex', '=', $sex);
1139         return $query
1368         $query = DB::table('individuals')
1372             $query->where('i_gedcom', 'NOT LIKE', "%\n1 " . $death_event . '%');
1375         return $query->count();
1387             ->where(static function (Builder $query): void {
1389                     $query->orWhere('i_gedcom', 'LIKE', "%\n1 " . $death_event . '%');
1936         $query = DB::table('individuals')
1954             $query->where('i_sex', '=', $sex);
1957         return $query;