| /webtrees/app/Services/ |
| H A D | MapDataService.php | 217 $prefix = DB::prefix();
220 $prefix . 'p1.place IS NOT NULL AND ' . $prefix . 'p1.latitude IS NULL OR ' .
221 $prefix . 'p2.place IS NOT NULL AND ' . $prefix . 'p2.latitude IS NULL OR ' .
222 $prefix . 'p3.place IS NOT NULL AND ' . $prefix . 'p3.latitude IS NULL OR ' .
223 $prefix . 'p4.place IS NOT NULL AND ' . $prefix . 'p4.latitude IS NULL OR ' .
224 $prefix . 'p5.place IS NOT NULL AND ' . $prefix . 'p5.latitude IS NULL OR ' .
225 $prefix . 'p6.place IS NOT NULL AND ' . $prefix . 'p6.latitude IS NULL OR ' .
226 $prefix . 'p7.place IS NOT NULL AND ' . $prefix . 'p7.latitude IS NULL OR ' .
227 $prefix . 'p8.place IS NOT NULL AND ' . $prefix . 'p8.latitude IS NULL OR ' .
228 $prefix . 'p9.place IS NOT NULL AND ' . $prefix . 'p9.latitude IS NULL';
[all …]
|
| H A D | SearchService.php | 129 $prefix = DB::prefix();
130 …$field = new Expression('COALESCE(' . $prefix . "husb_name.n_full, '') || COALESCE(" . $prefix . …
|
| /webtrees/app/Statistics/Repository/ |
| H A D | FamilyRepository.php | 330 …o AS ch1', 'link2.l_to AS ch2', new Expression(DB::prefix('child2.d_julianday2') . ' - ' . DB::pre…
833 … ->where('childbirth.d_julianday2', '>', new Expression(DB::prefix('birth.d_julianday1')))
834 …t(['parentfamily.l_to AS id', new Expression(DB::prefix('childbirth.d_julianday2') . ' - ' . DB::p…
1031 …ct(['f_id AS family', new Expression('MIN(' . DB::prefix('husbdeath.d_julianday2') . ' - ' . DB::p…
1052 …ct(['f_id AS family', new Expression('MIN(' . DB::prefix('wifedeath.d_julianday2') . ' - ' . DB::p…
1073 …ct(['f_id AS family', new Expression('MIN(' . DB::prefix('divorced.d_julianday2') . ' - ' . DB::pr…
1285 …->orderBy(new Expression('MIN(' . DB::prefix('wife.d_julianday1') . ') - MIN(' . DB::prefix('husb.…
1289 …->orderBy(new Expression('MIN(' . DB::prefix('husb.d_julianday1') . ') - MIN(' . DB::prefix('wife.…
1410 …>select(['f_id', 'birth.d_gid', new Expression(DB::prefix('married.d_julianday2') . ' - ' . DB::pr…
1480 ->where('married.d_julianday2', '>', new Expression(DB::prefix('birth.d_julianday1')))
[all …]
|
| H A D | IndividualRepository.php | 817 …->select([new Expression(DB::prefix('death.d_julianday2') . ' - ' . DB::prefix('birth.d_julianday1…
845 …->select(['individuals.*', new Expression(DB::prefix('death.d_julianday2') . ' - ' . DB::prefix('b…
997 …elect(['individuals.*', new Expression('MAX(' . DB::prefix('death.d_julianday2') . ' - ' . DB::pre…
1285 …->select([new Expression('AVG(' . DB::prefix('death.d_julianday2') . ' - ' . DB::prefix('birth.d_j…
|
| /webtrees/app/Statistics/Google/ |
| H A D | ChartMarriageAge.php | 61 …new Expression('AVG(' . DB::prefix('married.d_julianday2') . ' - ' . DB::prefix('birth.d_julianday…
62 … new Expression('ROUND((' . DB::prefix('married.d_year') . ' + 49) / 100, 0) AS century'),
76 ->where('married.d_julianday1', '>', new Expression(DB::prefix('birth.d_julianday1')))
84 …new Expression('ROUND(AVG(' . DB::prefix('married.d_julianday2') . ' - ' . DB::prefix('birth.d_jul…
85 … new Expression('ROUND((' . DB::prefix('married.d_year') . ' + 49) / 100, 0) AS century'),
99 ->where('married.d_julianday1', '>', new Expression(DB::prefix('birth.d_julianday1')))
|
| H A D | ChartAge.php | 61 …new Expression('AVG(' . DB::prefix('death.d_julianday2') . ' - ' . DB::prefix('birth.d_julianday1'…
62 … new Expression('ROUND((' . DB::prefix('death.d_year') . ' + 49) / 100, 0) AS century'),
|
| /webtrees/resources/views/edit/ |
| H A D | edit-gedcom-fields.phtml | 58 <input type="hidden" name="<?= e($prefix) ?>levels[]" value="<?= $levels[$key] ?>">
59 <input type="hidden" name="<?= e($prefix) ?>tags[]" value="<?= e($tags[$key]) ?>">
60 <input type="hidden" name="<?= e($prefix) ?>values[]" value="">
74 <input type="hidden" name="<?= e($prefix) ?>levels[]" value="<?= $levels[$key] ?>">
75 <input type="hidden" name="<?= e($prefix) ?>tags[]" value="<?= e($tags[$key]) ?>">
76 …<?= $elements[$key]->edit($ids[$key], $prefix . 'values[]', strtr($values[$key], ["\r" => "\n"]), …
|
| H A D | new-individual.phtml | 22 <?php foreach ($facts ?? [] as $prefix => $prefix_facts) : ?>
26 …="collapse" data-bs-target="#fact-<?= $prefix ?>-<?= $n ?>" aria-expanded="false" aria-controls="f…
32 <div class="card-body pb-1 collapse" id="fact-<?= $prefix ?>-<?= $n ?>">
33 …erarchy' => explode(':', $fact->tag()), 'tree' => $fact->record()->tree(), 'prefix' => $prefix]) ?>
|
| H A D | link-spouse-to-individual.phtml | 32 <?php foreach ($facts ?? [] as $prefix => $prefix_facts) : ?>
39 …erarchy' => explode(':', $fact->tag()), 'tree' => $fact->record()->tree(), 'prefix' => $prefix]) ?>
|
| /webtrees/app/Factories/ |
| H A D | XrefFactory.php | 44 * @param string $prefix
49 protected function generate(string $prefix, string $suffix): string argument
66 $xref = $prefix . $num . $suffix;
|
| H A D | IdFactory.php | 55 * @param string $prefix
59 public function id(string $prefix = 'id-'): string argument
61 return $prefix . $this->uuid();
|
| /webtrees/app/Http/RequestHandlers/ |
| H A D | FixLevel0MediaData.php | 83 $prefix = DB::prefix();
104 …->where('i_gedcom', 'LIKE', new Expression("('%\n1 OBJE @' || " . $prefix . "media.m_id || '@%')"))
|
| H A D | TreePrivacyPage.php | 121 … foreach (['', Family::RECORD_TYPE . ':', Individual::RECORD_TYPE . ':'] as $prefix) {
122 $element = Registry::elementFactory()->make($prefix . $row->tag_type);
|
| H A D | SetupWizard.php | 454 prefix: $data['tblpfx'],
471 prefix: $data['tblpfx'],
|
| /webtrees/app/ |
| H A D | DB.php | 83 string $prefix, argument
118 'prefix' => $prefix,
165 public static function prefix(string $identifier = ''): string function in Fisharebest\\Webtrees\\DB
|
| /webtrees/app/Schema/ |
| H A D | Migration0.php | 86 $key = DB::prefix($table->getTable() . '_primary');
335 $key0 = DB::prefix($table->getTable() . '_primary');
336 $key1 = DB::prefix($table->getTable() . '_ix1');
380 $key = DB::prefix($table->getTable() . '_primary');
|
| H A D | SeedGedcomTable.php | 39 DB::exec('SET IDENTITY_INSERT [' . DB::prefix() . 'gedcom] ON');
49 DB::exec('SET IDENTITY_INSERT [' . DB::prefix() . 'gedcom] OFF');
|
| H A D | SeedUserTable.php | 39 DB::exec('SET IDENTITY_INSERT [' . DB::prefix() . 'user] ON');
52 DB::exec('SET IDENTITY_INSERT [' . DB::prefix() . 'user] OFF');
|
| H A D | Migration42.php | 64 $key1 = DB::prefix($table->getTable() . '_ix1');
65 $key2 = DB::prefix($table->getTable() . '_ix2');
|
| /webtrees/app/Contracts/ |
| H A D | IdFactoryInterface.php | 35 * @param string $prefix
39 public function id(string $prefix = 'id-'): string; argument
|
| /webtrees/app/Module/ |
| H A D | LanguageEnglishUnitedStates.php | 142 $great = static fn (int $n, string $prefix, string $suffix): array => $genitive(
143 $prefix . ($n > 3 ? 'great ×' . $n . ' ' : str_repeat('great-', $n)) . $suffix
|
| /webtrees/app/Cli/ |
| H A D | Console.php | 71 prefix: $config['tblpfx'],
|
| /webtrees/app/Http/Middleware/ |
| H A D | UseDatabase.php | 53 prefix: Validator::attributes($request)->string('tblpfx'),
|
| /webtrees/tests/ |
| H A D | TestCase.php | 75 prefix: 'wt_',
|
| /webtrees/ |
| H A D | README.md | 95 …base might not sort names according to local rules. **webtrees** uses a prefix for its table name…
|