1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
<?php
/**
* webtrees: online genealogy
* Copyright (C) 2025 webtrees development team
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*/
declare(strict_types=1);
namespace Fisharebest\Webtrees\Factories;
use Fisharebest\Webtrees\Contracts\XrefFactoryInterface;
use Fisharebest\Webtrees\DB;
use Fisharebest\Webtrees\Site;
/**
* Make an XREF.
*/
class XrefFactory implements XrefFactoryInterface
{
/**
* Create a new XREF.
*
* @param string $record_type
*
* @return string
*/
public function make(string $record_type): string
{
return $this->generate('X', '');
}
/**
* @param string $prefix
* @param string $suffix
*
* @return string
*/
protected function generate(string $prefix, string $suffix): string
{
// Lock the row, so that only one new XREF may be generated at a time.
$num = (int) DB::table('site_setting')
->where('setting_name', '=', 'next_xref')
->lockForUpdate()
->value('setting_value');
$increment = 1.0;
do {
$num += (int) $increment;
// This exponential increment allows us to scan over large blocks of
// existing data in a reasonable time.
$increment *= 1.01;
$xref = $prefix . $num . $suffix;
// Records may already exist with this sequence number.
$already_used =
DB::table('individuals')->where('i_id', '=', $xref)->exists() ||
DB::table('families')->where('f_id', '=', $xref)->exists() ||
DB::table('sources')->where('s_id', '=', $xref)->exists() ||
DB::table('media')->where('m_id', '=', $xref)->exists() ||
DB::table('other')->where('o_id', '=', $xref)->exists() ||
DB::table('change')->where('xref', '=', $xref)->exists();
} while ($already_used);
Site::setPreference('next_xref', (string) $num);
return $xref;
}
}
|
