Lines Matching refs:query
492 protected function whereFamily(bool $fams, Builder $query): void argument
495 $query->join('link', static function (JoinClause $join): void {
507 protected function whereMarriedName(bool $marnm, Builder $query): void argument
510 $query->where('n_type', '<>', '_MARNM');
532 $query = DB::table('name')
535 $this->whereFamily($fams, $query);
536 $this->whereMarriedName($marnm, $query);
539 $query->whereIn('n_surn', $surns);
542 $query
546 foreach ($query->get() as $row) {
568 $query = DB::table('name')
578 $this->whereFamily($fams, $query);
579 $this->whereMarriedName($marnm, $query);
581 $query->groupBy([
586 return $query
694 $query = DB::table('individuals')
703 $this->whereFamily($fams, $query);
704 $this->whereMarriedName($marnm, $query);
707 $query->whereNotIn('n_surn', ['', '@N.N.']);
709 $query->whereIn(DB::binaryColumn('n_surn'), $surns_to_show);
714 foreach ($query->get() as $row) {