. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Module; use Fisharebest\Webtrees\Carbon; use Fisharebest\Webtrees\GedcomRecord; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Services\UserService; use Fisharebest\Webtrees\Tree; use Illuminate\Database\Capsule\Manager as DB; use Illuminate\Database\Query\Expression; use Illuminate\Support\Collection; use Illuminate\Support\Str; use Psr\Http\Message\ServerRequestInterface; use stdClass; use function extract; use function view; use const EXTR_OVERWRITE; /** * Class RecentChangesModule */ class RecentChangesModule extends AbstractModule implements ModuleBlockInterface { use ModuleBlockTrait; private const DEFAULT_DAYS = '7'; private const DEFAULT_SHOW_USER = '1'; private const DEFAULT_SORT_STYLE = 'date_desc'; private const DEFAULT_INFO_STYLE = 'table'; private const MAX_DAYS = 90; // Pagination private const LIMIT_LOW = 10; private const LIMIT_HIGH = 20; /** @var UserService */ private $user_service; /** * RecentChangesModule constructor. * * @param UserService $user_service */ public function __construct(UserService $user_service) { $this->user_service = $user_service; } /** * How should this module be identified in the control panel, etc.? * * @return string */ public function title(): string { /* I18N: Name of a module */ return I18N::translate('Recent changes'); } /** * A sentence describing what this module does. * * @return string */ public function description(): string { /* I18N: Description of the “Recent changes” module */ return I18N::translate('A list of records that have been updated recently.'); } /** {@inheritdoc} */ public function getBlock(Tree $tree, int $block_id, string $context, array $config = []): string { $days = (int) $this->getBlockSetting($block_id, 'days', self::DEFAULT_DAYS); $infoStyle = $this->getBlockSetting($block_id, 'infoStyle', self::DEFAULT_INFO_STYLE); $sortStyle = $this->getBlockSetting($block_id, 'sortStyle', self::DEFAULT_SORT_STYLE); $show_user = (bool) $this->getBlockSetting($block_id, 'show_user', self::DEFAULT_SHOW_USER); extract($config, EXTR_OVERWRITE); $rows = $this->getRecentChanges($tree, $days); switch ($sortStyle) { case 'name': $rows = $rows->sort(static function (stdClass $x, stdClass $y): int { return GedcomRecord::nameComparator()($x->record, $y->record); }); $order = [[1, 'asc']]; break; case 'date_asc': $rows = $rows->sort(static function (stdClass $x, stdClass $y): int { return $x->time <=> $y->time; }); $order = [[2, 'asc']]; break; default: case 'date_desc': $rows = $rows->sort(static function (stdClass $x, stdClass $y): int { return $y->time <=> $x->time; }); $order = [[2, 'asc']]; break; } if ($rows->isEmpty()) { $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)); } elseif ($infoStyle === 'list') { $content = view('modules/recent_changes/changes-list', [ 'id' => $block_id, 'limit_low' => self::LIMIT_LOW, 'limit_high' => self::LIMIT_HIGH, 'rows' => $rows->values(), 'show_user' => $show_user, ]); } else { $content = view('modules/recent_changes/changes-table', [ 'limit_low' => self::LIMIT_LOW, 'limit_high' => self::LIMIT_HIGH, 'rows' => $rows, 'show_user' => $show_user, 'order' => $order, ]); } if ($context !== self::CONTEXT_EMBED) { return view('modules/block-template', [ 'block' => Str::kebab($this->name()), 'id' => $block_id, 'config_url' => $this->configUrl($tree, $context, $block_id), 'title' => I18N::plural('Changes in the last %s day', 'Changes in the last %s days', $days, I18N::number($days)), 'content' => $content, ]); } return $content; } /** * Should this block load asynchronously using AJAX? * * Simple blocks are faster in-line, more complex ones can be loaded later. * * @return bool */ public function loadAjax(): bool { return true; } /** * Can this block be shown on the user’s home page? * * @return bool */ public function isUserBlock(): bool { return true; } /** * Can this block be shown on the tree’s home page? * * @return bool */ public function isTreeBlock(): bool { return true; } /** * Update the configuration for a block. * * @param ServerRequestInterface $request * @param int $block_id * * @return void */ public function saveBlockConfiguration(ServerRequestInterface $request, int $block_id): void { $params = (array) $request->getParsedBody(); $this->setBlockSetting($block_id, 'days', $params['days']); $this->setBlockSetting($block_id, 'infoStyle', $params['infoStyle']); $this->setBlockSetting($block_id, 'sortStyle', $params['sortStyle']); $this->setBlockSetting($block_id, 'show_user', $params['show_user']); } /** * An HTML form to edit block settings * * @param Tree $tree * @param int $block_id * * @return string */ public function editBlockConfiguration(Tree $tree, int $block_id): string { $days = (int) $this->getBlockSetting($block_id, 'days', self::DEFAULT_DAYS); $infoStyle = $this->getBlockSetting($block_id, 'infoStyle', self::DEFAULT_INFO_STYLE); $sortStyle = $this->getBlockSetting($block_id, 'sortStyle', self::DEFAULT_SORT_STYLE); $show_user = $this->getBlockSetting($block_id, 'show_user', self::DEFAULT_SHOW_USER); $info_styles = [ /* I18N: An option in a list-box */ 'list' => I18N::translate('list'), /* I18N: An option in a list-box */ 'table' => I18N::translate('table'), ]; $sort_styles = [ /* I18N: An option in a list-box */ 'name' => I18N::translate('sort by name'), /* I18N: An option in a list-box */ 'date_asc' => I18N::translate('sort by date, oldest first'), /* I18N: An option in a list-box */ 'date_desc' => I18N::translate('sort by date, newest first'), ]; return view('modules/recent_changes/config', [ 'days' => $days, 'infoStyle' => $infoStyle, 'info_styles' => $info_styles, 'max_days' => self::MAX_DAYS, 'sortStyle' => $sortStyle, 'sort_styles' => $sort_styles, 'show_user' => $show_user, ]); } /** * Find records that have changed since a given julian day * * @param Tree $tree Changes for which tree * @param int $days Number of days * * @return Collection List of records with changes */ private function getRecentChanges(Tree $tree, int $days): Collection { $subquery = DB::table('change') ->where('gedcom_id', '=', $tree->id()) ->where('status', '=', 'accepted') ->where('new_gedcom', '<>', '') ->where('change_time', '>', Carbon::now()->subDays($days)) ->groupBy(['xref']) ->select(new Expression('MAX(change_id) AS recent_change_id')); $query = DB::table('change') ->joinSub($subquery, 'recent', 'recent_change_id', '=', 'change_id') ->select(['change.*']); return $query ->get() ->map(function (stdClass $row) use ($tree): stdClass { return (object) [ 'record' => GedcomRecord::getInstance($row->xref, $tree, $row->new_gedcom), 'time' => Carbon::create($row->change_time)->local(), 'user' => $this->user_service->find($row->user_id), ]; }) ->filter(static function (stdClass $row): bool { return $row->record instanceof GedcomRecord && $row->record->canShow(); }); } }