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
83
84
85
86
87
88
89
90
91
92
93
94
|
<?php
// Class file for a Shared Note (NOTE) object
//
// webtrees: Web based Family History software
// Copyright (C) 2013 webtrees development team.
//
// Derived from PhpGedView
// Copyright (C) 2009 PGV Development Team. All rights reserved.
//
// 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 2 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, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
//
// $Id$
if (!defined('WT_WEBTREES')) {
header('HTTP/1.0 403 Forbidden');
exit;
}
class WT_Note extends WT_GedcomRecord {
const RECORD_TYPE = 'NOTE';
const SQL_FETCH = "SELECT o_gedcom FROM `##other` WHERE o_id=? AND o_file=?";
const URL_PREFIX = 'note.php?nid=';
// Get the text contents of the note
public function getNote() {
if (preg_match('/^0 @' . WT_REGEX_TAG . '@ NOTE ?(.*(?:\n1 CONT .*)*)/', $this->gedcom, $match)) {
return str_replace("\n1 CONT ", "\n", $match[1]);
} else {
return null;
}
}
// Implement note-specific privacy logic
protected function _canShowByType($access_level) {
// Hide notes if they are attached to private records
$linked_ids=WT_DB::prepare(
"SELECT l_from FROM `##link` WHERE l_to=? AND l_file=?"
)->execute(array($this->xref, $this->gedcom_id))->fetchOneColumn();
foreach ($linked_ids as $linked_id) {
$linked_record=WT_GedcomRecord::getInstance($linked_id);
if ($linked_record && !$linked_record->canShow($access_level)) {
return false;
}
}
// Apply default behaviour
return parent::_canShowByType($access_level);
}
// Generate a private version of this record
protected function createPrivateGedcomRecord($access_level) {
return '0 @' . $this->xref . '@ NOTE ' . WT_I18N::translate('Private');
}
// Fetch the record from the database
protected static function fetchGedcomRecord($xref, $gedcom_id) {
static $statement=null;
if ($statement===null) {
$statement=WT_DB::prepare("SELECT o_gedcom FROM `##other` WHERE o_id=? AND o_file=? AND o_type='NOTE'");
}
return $statement->execute(array($xref, $gedcom_id))->fetchOne();
}
// The 'name' of a note record is the first line. This can be
// somewhat unwieldy if lots of CONC records are used. Limit to 100 chars
protected function _addName($type, $value, $gedrec) {
if (utf8_strlen($value)<100) {
parent::_addName($type, $value, $gedrec);
} else {
parent::_addName($type, utf8_substr($value, 0, 100).WT_I18N::translate('…'), $gedrec);
}
}
// Get an array of structures containing all the names in the record
public function getAllNames() {
// Uniquely, the NOTE objects have data in their level 0 record.
// Hence the REGEX passed in the second parameter
return parent::_getAllNames('NOTE', '0 @'.WT_REGEX_XREF.'@');
}
}
|