Home
last modified time | relevance | path

Searched refs:table (Results 1 – 25 of 261) sorted by relevance

1234567891011

/webtrees/app/Schema/
H A DMigration0.php32 DB::schema()->create('gedcom', static function (Blueprint $table): void {
33 $table->integer('gedcom_id', true);
34 $table->string('gedcom_name', 255);
35 $table->integer('sort_order')->default(0);
37 $table->unique('gedcom_name');
38 $table->index('sort_order');
41 DB::schema()->create('site_setting', static function (Blueprint $table): void {
42 $table->string('setting_name', 32);
43 $table->string('setting_value', 2000);
45 $table->primary('setting_name');
[all …]
H A DMigration37.php41 DB::schema()->create('media_file', static function (Blueprint $table): void {
42 $table->integer('id', true);
43 $table->string('m_id', 20);
44 $table->integer('m_file');
45 $table->string('multimedia_file_refn', 248); // GEDCOM only allows 30 characters
46 $table->string('multimedia_format', 4);
47 $table->string('source_media_type', 15);
48 $table->string('descriptive_title', 248);
50 $table->index(['m_id', 'm_file']);
51 $table->index(['m_file', 'm_id']);
[all …]
H A DMigration44.php37 DB::schema()->create('place_location', static function (Blueprint $table): void {
38 $table->integer('id', true);
39 $table->integer('parent_id')->nullable();
40 $table->string('place', 120);
41 $table->double('latitude')->nullable();
42 $table->double('longitude')->nullable();
44 $table->unique(['parent_id', 'place']);
45 $table->unique(['place', 'parent_id']);
47 $table->index(['latitude']);
48 $table->index(['longitude']);
[all …]
H A DMigration42.php52 $data = DB::table('module_privacy')->get();
56 DB::schema()->create('module_privacy', static function (Blueprint $table): void {
57 $table->increments('id');
58 $table->string('module_name', 32);
59 $table->integer('gedcom_id');
60 $table->string('interface');
61 $table->tinyInteger('access_level');
64 $key1 = DB::prefix($table->getTable() . '_ix1');
65 $key2 = DB::prefix($table->getTable() . '_ix2');
67 $table->unique(['gedcom_id', 'module_name', 'interface'], $key1);
[all …]
H A DMigration39.php36 DB::schema()->create('favorite', static function (Blueprint $table): void {
37 $table->integer('favorite_id', true);
38 $table->integer('user_id')->nullable();
39 $table->integer('gedcom_id');
40 $table->string('xref', 20)->nullable();
41 … $table->enum('favorite_type', ['INDI', 'FAM', 'SOUR', 'REPO', 'OBJE', 'NOTE', 'URL']);
42 $table->string('url', 255)->nullable();
43 $table->string('title', 255)->nullable();
44 $table->string('note', 1000)->nullable();
46 $table->index('user_id');
[all …]
H A DMigration40.php36 DB::schema()->create('news', static function (Blueprint $table): void {
37 $table->integer('news_id', true);
38 $table->integer('user_id')->nullable();
39 $table->integer('gedcom_id')->nullable();
40 $table->string('subject', 255);
41 $table->text('body');
42 $table->timestamp('updated')->useCurrent();
44 $table->index(['user_id', 'updated']);
45 $table->index(['gedcom_id', 'updated']);
47 $table->foreign('user_id')->references('user_id')->on('user')->onDelete('cascade');
[all …]
/webtrees/app/Http/RequestHandlers/
H A DRenumberTreeAction.php78 DB::table('individuals')
86 DB::table('families')
94 DB::table('families')
104 DB::table('families')
120 DB::table('individuals')
134 DB::table('placelinks')
141 DB::table('dates')
148 DB::table('user_gedcom_setting')
158 DB::table('families')
168 DB::table('individuals')
[all …]
H A DGedcomLoad.php79 $import_offset = DB::table('gedcom_chunk')
84 $import_total = DB::table('gedcom_chunk')
103 'individuals' => DB::table('individuals')->where('i_file', '=', $tree->id()),
104 'families' => DB::table('families')->where('f_file', '=', $tree->id()),
105 'sources' => DB::table('sources')->where('s_file', '=', $tree->id()),
106 'other' => DB::table('other')->where('o_file', '=', $tree->id()),
107 'places' => DB::table('places')->where('p_file', '=', $tree->id()),
108 'placelinks' => DB::table('placelinks')->where('pl_file', '=', $tree->id()),
109 'name' => DB::table('name')->where('n_file', '=', $tree->id()),
110 'dates' => DB::table('dates')->where('d_file', '=', $tree->id()),
[all …]
/webtrees/app/Services/
H A DTreeService.php81 $query = DB::table('gedcom')
176 DB::table('gedcom')->insert([
250 DB::table('gedcom_chunk')->where('gedcom_id', '=', $tree->id())->delete();
262 DB::table('gedcom_chunk')->insert([
271 DB::table('gedcom_chunk')->insert([
289 DB::table('gedcom_chunk')->where('gedcom_id', '=', $tree->id())->delete();
290 DB::table('individuals')->where('i_file', '=', $tree->id())->delete();
291 DB::table('families')->where('f_file', '=', $tree->id())->delete();
292 DB::table('sources')->where('s_file', '=', $tree->id())->delete();
293 DB::table('other')->where('o_file', '=', $tree->id())->delete();
[all …]
H A DAdminService.php65 $subquery1 = DB::table('individuals')
68 ->union(DB::table('families')
71 ->union(DB::table('sources')
74 ->union(DB::table('media')
77 ->union(DB::table('other')
82 $subquery2 = DB::table('change')
85 ->union(DB::table('individuals')
88 ->union(DB::table('families')
91 ->union(DB::table('sources')
94 ->union(DB::table('media')
[all …]
H A DUserService.php51 ->remember('user-' . $user_id, static fn (): User|null => DB::table('user')
63 return DB::table('user')
75 return DB::table('user')
92 return DB::table('user')
107 return DB::table('user')
125 return DB::table('user')
173 return DB::table('user')
187 return DB::table('user')
205 return DB::table('user')
224 return DB::table('user')
[all …]
H A DGedcomImportService.php288 $old_linked_media = DB::table('link')
295 DB::table('link')
323 DB::table('individuals')->insert([
353 DB::table('families')->insert([
376 DB::table('sources')->insert([
389 DB::table('other')->insert([
404 DB::table('other')->insert([
415 DB::table('media')->insert([
422 DB::table('media_file')->insert([
434 DB::table('other')->insert([
[all …]
H A DHomePageService.php63 $block = DB::table('block')
92 $block = DB::table('block')
121 $module_name = DB::table('block')
175 $rows = DB::table('block')
191 $has_blocks = DB::table('block')
202 DB::table('block')->insert([
225 $rows = DB::table('block')
241 $has_blocks = DB::table('block')
252 DB::table('block')->insert([
275 $existing_block_ids = DB::table('block')
[all …]
H A DSearchService.php90 $query = DB::table('families');
115 $query = DB::table('families')
150 return DB::table('families')
173 $query = DB::table('individuals');
198 $query = DB::table('individuals')
220 return DB::table('individuals')
247 $query = DB::table('other')
268 $query = DB::table('media');
288 $query = DB::table('other')
309 $query = DB::table('other')
[all …]
H A DPendingChangesService.php74 return DB::table('change')
92 $rows = DB::table('change')
145 $changes = DB::table('change')
162 DB::table('change')
175 $changes = DB::table('change')
192 DB::table('change')
206 $changes = DB::table('change')
223 DB::table('change')
236 DB::table('change')
250 DB::table('change')
[all …]
H A DMapDataService.php58 $row = DB::table('place_location')
84 $rows = DB::table('places')
106 $all_places = DB::table('places AS p0')
129 $all_locations = DB::table('place_location AS p0')
167 DB::table('place_location')
181 $location_query = DB::table('place_location')
184 $location_query = DB::table('place_location')
189 $places = DB::table('places')
197 DB::table('place_location')
232 $query = DB::table('place_location AS p0')
[all …]
H A DLinkedRecordService.php56 $union = DB::table('change')
70 $xrefs = DB::table('link')
90 $query = DB::table('families')
121 $query = DB::table('individuals')
151 return DB::table('other')
176 return DB::table('media')
200 return DB::table('other')
225 return DB::table('other')
250 return DB::table('sources')
274 return DB::table('other')
/webtrees/resources/css/
H A D_chart-interactive.css51 .tv_in table.tv_tree,
52 .tv_in table.tv_tree tbody,
53 .tv_in table.tv_tree tr,
54 .tv_in table.tv_tree td {
61 .tv_in table.tv_tree {
69 /* Border (also have class table.tv_tree) */
70 table#tvTreeBorder td#tv_tree_topleft {
73 table#tvTreeBorder td#tv_tree_top {
76 table#tvTreeBorder td#tv_tree_top div{
80 table#tvTreeBorder td#tv_tree_topright {
[all …]
/webtrees/app/Module/
H A DFrequentlyAskedQuestionsModule.php135 $min_block_order = (int) DB::table('block')
144 $max_block_order = (int) DB::table('block')
190 DB::table('block_setting')->where('block_id', '=', $block_id)->delete();
192 DB::table('block')->where('block_id', '=', $block_id)->delete();
211 $block_order = DB::table('block')
215 $swap_block = DB::table('block')
222 DB::table('block')
228 DB::table('block')
247 $block_order = DB::table('block')
251 $swap_block = DB::table('block')
[all …]
H A DSiteMapModule.php199 $count_families = DB::table('families')
205 $count_individuals = DB::table('individuals')
211 $count_media = DB::table('media')
217 $count_notes = DB::table('other')
224 $count_repositories = DB::table('other')
231 $count_sources = DB::table('sources')
237 $count_submitters = DB::table('other')
245 DB::table('module_setting')
360 return DB::table('families')
378 return DB::table('individuals')
[all …]
/webtrees/public/ckeditor-4.15.1-custom/plugins/table/dialogs/
H A Dtable.js5 …,a.document)},r=a.editable(),q=a.plugins.dialogadvtab;return{title:a.lang.table.title,minWidth:310…
6 …ame()?null:(d=(d=d.getSelection())&&d.getRanges()[0])?d._getTableElement({table:1}):null},onLoad:f… property
11 …R.POSITION_AFTER_START);c.select()},0)},contents:[{id:"info",label:a.lang.table.title,elements:[{t…
12 …table.rows,required:!0,controlStyle:"width:5em",validate:t(a.lang.table.invalidRows),setup:functio…
13 …bel:a.lang.table.headers,items:[[a.lang.table.headersNone,""],[a.lang.table.headersRow,"row"],[a.l…
14 …ble[border]")?1:0,label:a.lang.table.border,controlStyle:"width:3em",validate:CKEDITOR.dialog.vali…
18 …table.cellSpace,"default":a.filter.check("table[cellspacing]")?1:0,validate:CKEDITOR.dialog.valida…
19 …table.invalidCellPadding),setup:function(a){this.setValue(a.getAttribute("cellPadding")||"")},comm…
21 …xt",id:"txtSummary",bidi:!0,requiredContent:"table[summary]",label:a.lang.table.summary,setup:func…
/webtrees/public/css/
H A Dvendor.min.css6 …table{border-collapse:collapse;caption-side:bottom}caption{color:#212529bf;color:var(--bs-secondar… selector
11 …table.table.dataTable{border-spacing:0;max-width:none}[dir] table.table.dataTable{clear:both;margi…
/webtrees/app/Statistics/Repository/
H A DFamilyRepository.php83 $row = DB::table('families')
150 return DB::table('families')
226 return DB::table('families')
251 $families = DB::table('families')
306 return DB::table('link AS link1')
559 $query = DB::table('families')
597 $total = (int) DB::table('families')
611 $average = (float) DB::table('families')
627 return DB::table('families')
701 $first_child_subquery = DB::table('link')
[all …]
/webtrees/app/Factories/
H A DXrefFactory.php52 $num = (int) DB::table('site_setting')
70 DB::table('individuals')->where('i_id', '=', $xref)->exists() ||
71 DB::table('families')->where('f_id', '=', $xref)->exists() ||
72 DB::table('sources')->where('s_id', '=', $xref)->exists() ||
73 DB::table('media')->where('m_id', '=', $xref)->exists() ||
74 DB::table('other')->where('o_id', '=', $xref)->exists() ||
75 DB::table('change')->where('xref', '=', $xref)->exists();
/webtrees/app/
H A DPlaceLocation.php88 $location_id = DB::table('place_location')
93 $location_id = DB::table('place_location')
99 $location_id ??= DB::table('place_location')->insertGetId([
120 $parent_id = DB::table('place_location')
125 $parent_id = DB::table('place_location')
153 $row = DB::table('place_location')
206 $latitudes = DB::table('place_location')
217 $longitudes = DB::table('place_location')

1234567891011