1<?php 2 3/** 4 * webtrees: online genealogy 5 * Copyright (C) 2021 webtrees development team 6 * This program is free software: you can redistribute it and/or modify 7 * it under the terms of the GNU General Public License as published by 8 * the Free Software Foundation, either version 3 of the License, or 9 * (at your option) any later version. 10 * This program is distributed in the hope that it will be useful, 11 * but WITHOUT ANY WARRANTY; without even the implied warranty of 12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 * GNU General Public License for more details. 14 * You should have received a copy of the GNU General Public License 15 * along with this program. If not, see <https://www.gnu.org/licenses/>. 16 */ 17 18declare(strict_types=1); 19 20namespace Fisharebest\Webtrees; 21 22use Fisharebest\Webtrees\Http\RequestHandlers\SubmissionPage; 23use Illuminate\Database\Capsule\Manager as DB; 24 25/** 26 * A GEDCOM submission (SUBN) object. 27 * These records are only used when transferring data between two obsolete systems. 28 * There is no need to create them - but we may encounter them in imported GEDCOM files. 29 */ 30class Submission extends GedcomRecord 31{ 32 public const RECORD_TYPE = 'SUBN'; 33 34 protected const ROUTE_NAME = SubmissionPage::class; 35 36 /** 37 * Fetch data from the database 38 * 39 * @param string $xref 40 * @param int $tree_id 41 * 42 * @return string|null 43 */ 44 protected static function fetchGedcomRecord(string $xref, int $tree_id): ?string 45 { 46 return DB::table('other') 47 ->where('o_id', '=', $xref) 48 ->where('o_file', '=', $tree_id) 49 ->where('o_type', '=', static::RECORD_TYPE) 50 ->value('o_gedcom'); 51 } 52 53 /** 54 * Extract names from the GEDCOM record. 55 * 56 * @return void 57 */ 58 public function extractNames(): void 59 { 60 $this->getAllNames[] = [ 61 'type' => static::RECORD_TYPE, 62 'sort' => I18N::translate('Submission'), 63 'full' => I18N::translate('Submission'), 64 'fullNN' => I18N::translate('Submission'), 65 ]; 66 } 67} 68