xref: /webtrees/app/Module/RecentChangesModule.php (revision 16d0b7f74e80c16cb445079b0322702930031dc7) 
1<?php
2/**
3 * webtrees: online genealogy
4 * Copyright (C) 2017 webtrees development team
5 * This program is free software: you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation, either version 3 of the License, or
8 * (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 * You should have received a copy of the GNU General Public License
14 * along with this program. If not, see <http://www.gnu.org/licenses/>.
15 */
16namespace Fisharebest\Webtrees\Module;
17
18use Fisharebest\Webtrees\Auth;
19use Fisharebest\Webtrees\Bootstrap4;
20use Fisharebest\Webtrees\Database;
21use Fisharebest\Webtrees\Filter;
22use Fisharebest\Webtrees\FontAwesome;
23use Fisharebest\Webtrees\Functions\FunctionsEdit;
24use Fisharebest\Webtrees\GedcomRecord;
25use Fisharebest\Webtrees\GedcomTag;
26use Fisharebest\Webtrees\Html;
27use Fisharebest\Webtrees\I18N;
28use Fisharebest\Webtrees\Individual;
29use Fisharebest\Webtrees\Tree;
30use Fisharebest\Webtrees\View;
31use Ramsey\Uuid\Uuid;
32
33/**
34 * Class RecentChangesModule
35 */
36class RecentChangesModule extends AbstractModule implements ModuleBlockInterface {
37	const DEFAULT_BLOCK      = '1';
38	const DEFAULT_DAYS       = 7;
39	const DEFAULT_HIDE_EMPTY = '0';
40	const DEFAULT_SHOW_USER  = '1';
41	const DEFAULT_SORT_STYLE = 'date_desc';
42	const DEFAULT_INFO_STYLE = 'table';
43	const MAX_DAYS           = 90;
44
45	/** {@inheritdoc} */
46	public function getTitle() {
47		return /* I18N: Name of a module */ I18N::translate('Recent changes');
48	}
49
50	/** {@inheritdoc} */
51	public function getDescription() {
52		return /* I18N: Description of the “Recent changes” module */ I18N::translate('A list of records that have been updated recently.');
53	}
54
55	/** {@inheritdoc} */
56	public function getBlock($block_id, $template = true, $cfg = []) {
57		global $ctype, $WT_TREE;
58
59		$days       = $this->getBlockSetting($block_id, 'days', self::DEFAULT_DAYS);
60		$infoStyle  = $this->getBlockSetting($block_id, 'infoStyle', self::DEFAULT_INFO_STYLE);
61		$sortStyle  = $this->getBlockSetting($block_id, 'sortStyle', self::DEFAULT_SORT_STYLE);
62		$show_user  = $this->getBlockSetting($block_id, 'show_user', self::DEFAULT_SHOW_USER);
63
64		foreach (['days', 'infoStyle', 'sortStyle', 'show_user'] as $name) {
65			if (array_key_exists($name, $cfg)) {
66				$$name = $cfg[$name];
67			}
68		}
69
70		$records = $this->getRecentChanges($WT_TREE, $days);
71
72		$content = '';
73		// Print block content
74		if (empty($records)) {
75			$content .= I18N::plural('There have been no changes within the last %s day.', 'There have been no changes within the last %s days.', $days, I18N::number($days));
76		} else {
77			switch ($infoStyle) {
78			case 'list':
79				$content .= $this->changesList($records, $sortStyle, $show_user);
80				break;
81			case 'table':
82				$content .= $this->changesTable($records, $sortStyle, $show_user);
83				break;
84			}
85		}
86
87		if ($template) {
88			if ($ctype === 'gedcom' && Auth::isManager($WT_TREE) || $ctype === 'user' && Auth::check()) {
89				$config_url = Html::url('block_edit.php', ['block_id' => $block_id, 'ged' => $WT_TREE->getName()]);
90			} else {
91				$config_url = '';
92			}
93
94			return View::make('blocks/template', [
95				'block'      => str_replace('_', '-', $this->getName()),
96				'id'         => $block_id,
97				'config_url' => $config_url,
98				'title'      => I18N::plural('Changes in the last %s day', 'Changes in the last %s days', $days, I18N::number($days)),
99				'content'    => $content,
100			]);
101		} else {
102			return $content;
103		}
104	}
105
106	/** {@inheritdoc} */
107	public function loadAjax() {
108		return true;
109	}
110
111	/** {@inheritdoc} */
112	public function isUserBlock() {
113		return true;
114	}
115
116	/** {@inheritdoc} */
117	public function isGedcomBlock() {
118		return true;
119	}
120
121	/** {@inheritdoc} */
122	public function configureBlock($block_id) {
123		if (Filter::postBool('save') && Filter::checkCsrf()) {
124			$this->setBlockSetting($block_id, 'days', Filter::postInteger('days', 1, self::MAX_DAYS));
125			$this->setBlockSetting($block_id, 'infoStyle', Filter::post('infoStyle', 'list|table'));
126			$this->setBlockSetting($block_id, 'sortStyle', Filter::post('sortStyle', 'name|date_asc|date_desc'));
127			$this->setBlockSetting($block_id, 'show_user', Filter::postBool('show_user'));
128		}
129
130		$days       = $this->getBlockSetting($block_id, 'days', self::DEFAULT_DAYS);
131		$infoStyle  = $this->getBlockSetting($block_id, 'infoStyle', self::DEFAULT_INFO_STYLE);
132		$sortStyle  = $this->getBlockSetting($block_id, 'sortStyle', self::DEFAULT_SORT_STYLE);
133		$show_user  = $this->getBlockSetting($block_id, 'show_user', self::DEFAULT_SHOW_USER);
134
135		echo '<div class="form-group row"><label class="col-sm-3 col-form-label" for="days">';
136		echo I18N::translate('Number of days to show');
137		echo '</div><div class="col-sm-9">';
138		echo '<input type="text" name="days" size="2" value="', $days, '">';
139		echo ' ' . I18N::plural('maximum %s day', 'maximum %s days', I18N::number(self::MAX_DAYS), I18N::number(self::MAX_DAYS));
140		echo '</div></div>';
141
142		echo '<div class="form-group row"><label class="col-sm-3 col-form-label" for="infoStyle">';
143		echo I18N::translate('Presentation style');
144		echo '</div><div class="col-sm-9">';
145		echo Bootstrap4::select(['list' => I18N::translate('list'), 'table' => I18N::translate('table')], $infoStyle, ['id' => 'infoStyle', 'name' => 'infoStyle']);
146		echo '</div></div>';
147
148		echo '<div class="form-group row"><label class="col-sm-3 col-form-label" for="sortStyle">';
149		echo I18N::translate('Sort order');
150		echo '</div><div class="col-sm-9">';
151		echo Bootstrap4::select([
152			'name'      => /* I18N: An option in a list-box */ I18N::translate('sort by name'),
153			'date_asc'  => /* I18N: An option in a list-box */ I18N::translate('sort by date, oldest first'),
154			'date_desc' => /* I18N: An option in a list-box */ I18N::translate('sort by date, newest first'),
155		], $sortStyle, ['id' => 'sortStyle', 'name' => 'sortStyle']);
156		echo '</div></div>';
157
158		echo '<div class="form-group row"><label class="col-sm-3 col-form-label" for="show_usere">';
159		echo /* I18N: label for a yes/no option */ I18N::translate('Show the user who made the change');
160		echo '</div><div class="col-sm-9">';
161		echo Bootstrap4::radioButtons('show_user', FunctionsEdit::optionsNoYes(), $show_user, true);
162		echo '</div></div>';
163	}
164
165	/**
166	 * Find records that have changed since a given julian day
167	 *
168	 * @param Tree $tree Changes for which tree
169	 * @param int  $days Number of days
170	 *
171	 * @return GedcomRecord[] List of records with changes
172	 */
173	private function getRecentChanges(Tree $tree, $days) {
174		$sql =
175			"SELECT xref FROM `##change`" .
176			" WHERE new_gedcom != '' AND change_time > DATE_SUB(NOW(), INTERVAL :days DAY) AND gedcom_id = :tree_id" .
177			" GROUP BY xref" .
178			" ORDER BY MAX(change_id) DESC";
179
180		$vars = [
181			'days'    => $days,
182			'tree_id' => $tree->getTreeId(),
183		];
184
185		$xrefs = Database::prepare($sql)->execute($vars)->fetchOneColumn();
186
187		$records = [];
188		foreach ($xrefs as $xref) {
189			$record = GedcomRecord::getInstance($xref, $tree);
190			if ($record && $record->canShow()) {
191				$records[] = $record;
192			}
193		}
194
195		return $records;
196	}
197
198	/**
199	 * Format a table of events
200	 *
201	 * @param GedcomRecord[] $records
202	 * @param string         $sort
203	 * @param bool           $show_user
204	 *
205	 * @return string
206	 */
207	private function changesList(array $records, $sort, $show_user) {
208		switch ($sort) {
209		case 'name':
210			uasort($records, ['self', 'sortByNameAndChangeDate']);
211			break;
212		case 'date_asc':
213			uasort($records, ['self', 'sortByChangeDateAndName']);
214			$records = array_reverse($records);
215			break;
216		case 'date_desc':
217			uasort($records, ['self', 'sortByChangeDateAndName']);
218		}
219
220		$html = '';
221		foreach ($records as $record) {
222			$html .= '<a href="' . $record->getHtmlUrl() . '" class="list_item name2">' . $record->getFullName() . '</a>';
223			$html .= '<div class="indent" style="margin-bottom: 5px;">';
224			if ($record instanceof Individual) {
225				if ($record->getAddName()) {
226					$html .= '<a href="' . $record->getHtmlUrl() . '" class="list_item">' . $record->getAddName() . '</a>';
227				}
228			}
229
230			// The timestamp may be missing or private.
231			$timestamp = $record->lastChangeTimestamp();
232			if ($timestamp !== '') {
233				if ($show_user) {
234					$html .= /* I18N: [a record was] Changed on <date/time> by <user> */
235						I18N::translate('Changed on %1$s by %2$s', $timestamp, Html::escape($record->lastChangeUser()));
236				} else {
237					$html .= /* I18N: [a record was] Changed on <date/time> */
238						I18N::translate('Changed on %1$s', $timestamp);
239				}
240			}
241			$html .= '</div>';
242		}
243
244		return $html;
245	}
246
247	/**
248	 * Format a table of events
249	 *
250	 * @param GedcomRecord[] $records
251	 * @param string         $sort
252	 * @param bool           $show_user
253	 *
254	 * @return string
255	 */
256	private function changesTable($records, $sort, $show_user) {
257		global $controller;
258
259		$table_id = 'table-chan-' . Uuid::uuid4(); // lists requires a unique ID in case there are multiple lists per page
260
261		switch ($sort) {
262		case 'name':
263		default:
264			$aaSorting = "[1,'asc'], [2,'desc']";
265			break;
266		case 'date_asc':
267			$aaSorting = "[2,'asc'], [1,'asc']";
268			break;
269		case 'date_desc':
270			$aaSorting = "[2,'desc'], [1,'asc']";
271			break;
272		}
273
274		$html = '';
275		$controller
276			->addInlineJavascript('
277				$("#' . $table_id . '").dataTable({
278					dom: \'t\',
279					paging: false,
280					autoWidth:false,
281					lengthChange: false,
282					filter: false,
283					' . I18N::datatablesI18N() . ',
284					sorting: [' . $aaSorting . '],
285					columns: [
286						{ sortable: false, class: "center" },
287						null,
288						null,
289						{ visible: ' . ($show_user ? 'true' : 'false') . ' }
290					]
291				});
292			');
293
294		$html .= '<table id="' . $table_id . '" class="width100">';
295		$html .= '<thead><tr>';
296		$html .= '<th></th>';
297		$html .= '<th>' . I18N::translate('Record') . '</th>';
298		$html .= '<th>' . I18N::translate('Last change') . '</th>';
299		$html .= '<th>' . GedcomTag::getLabel('_WT_USER') . '</th>';
300		$html .= '</tr></thead><tbody>';
301
302		foreach ($records as $record) {
303			$html .= '<tr><td>';
304			switch ($record::RECORD_TYPE) {
305			case 'INDI':
306				$html .= FontAwesome::semanticIcon('individual', I18N::translate('Individual'));
307				break;
308			case 'FAM':
309				$html .= FontAwesome::semanticicon('family', I18N::translate('Family'));
310				break;
311			case 'OBJE':
312				$html .= FontAwesome::semanticIcon('media', I18N::translate('Media'));
313				break;
314			case 'NOTE':
315				$html .= FontAwesome::semanticIcon('note', I18N::translate('Note'));
316				break;
317			case 'SOUR':
318				$html .= FontAwesome::semanticIcon('source', I18N::translate('Source'));
319				break;
320			case 'SUBM':
321				$html .= FontAwesome::semanticIcon('submitter', I18N::translate('Submitter'));
322				break;
323			case 'REPO':
324				$html .= FontAwesome::semanticIcon('repository', I18N::translate('Repository'));
325				break;
326			}
327			$html .= '</td>';
328			$html .= '<td data-sort="' . Html::escape($record->getSortName()) . '">';
329			$html .= '<a href="' . $record->getHtmlUrl() . '">' . $record->getFullName() . '</a>';
330			$addname = $record->getAddName();
331			if ($addname) {
332				$html .= '<div class="indent"><a href="' . $record->getHtmlUrl() . '">' . $addname . '</a></div>';
333			}
334			$html .= '</td>';
335			$html .= '<td data-sort="' . $record->lastChangeTimestamp(true) . '">' . $record->lastChangeTimestamp() . '</td>';
336			$html .= '<td>' . Html::escape($record->lastChangeUser()) . '</td>';
337			$html .= '</tr>';
338		}
339
340		$html .= '</tbody></table>';
341
342		return $html;
343	}
344
345	/**
346	 * Sort the records by (1) last change date and (2) name
347	 *
348	 * @param GedcomRecord $a
349	 * @param GedcomRecord $b
350	 *
351	 * @return int
352	 */
353	private static function sortByChangeDateAndName(GedcomRecord $a, GedcomRecord $b) {
354		return $b->lastChangeTimestamp(true) - $a->lastChangeTimestamp(true) ?: GedcomRecord::compare($a, $b);
355	}
356
357	/**
358	 * Sort the records by (1) name and (2) last change date
359	 *
360	 * @param GedcomRecord $a
361	 * @param GedcomRecord $b
362	 *
363	 * @return int
364	 */
365	private static function sortByNameAndChangeDate(GedcomRecord $a, GedcomRecord $b) {
366		return GedcomRecord::compare($a, $b) ?: $b->lastChangeTimestamp(true) - $a->lastChangeTimestamp(true);
367	}
368}
369