. */ use Fisharebest\Webtrees\Auth; use Fisharebest\Webtrees\Database; use Fisharebest\Webtrees\Filter; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Theme; /** * Class UserJournalModule */ class UserJournalModule extends AbstractModule implements ModuleBlockInterface { /** {@inheritdoc} */ public function __construct($directory) { parent::__construct($directory); // Create/update the database tables. Database::updateSchema('\Fisharebest\Webtrees\Module\FamilyTreeNews\Schema', 'NB_SCHEMA_VERSION', 3); } /** {@inheritdoc} */ public function getTitle() { return /* I18N: Name of a module */ I18N::translate('Journal'); } /** {@inheritdoc} */ public function getDescription() { return /* I18N: Description of the “Journal” module */ I18N::translate('A private area to record notes or keep a journal.'); } /** {@inheritdoc} */ public function getBlock($block_id, $template = true, $cfg = null) { global $ctype; switch (Filter::get('action')) { case 'deletenews': $news_id = Filter::getInteger('news_id'); if ($news_id) { Database::prepare("DELETE FROM `##news` WHERE news_id = ?")->execute(array($news_id)); } break; } $block = $this->getBlockSetting($block_id, 'block', '1'); if ($cfg) { foreach (array('block') as $name) { if (array_key_exists($name, $cfg)) { $$name = $cfg[$name]; } } } $usernews = Database::prepare( "SELECT SQL_CACHE news_id, user_id, gedcom_id, UNIX_TIMESTAMP(updated) AS updated, subject, body FROM `##news` WHERE user_id = ? ORDER BY updated DESC" )->execute(array(Auth::id()))->fetchAll(); $id = $this->getName() . $block_id; $class = $this->getName() . '_block'; $title = ''; $title .= $this->getTitle(); $content = ''; if (!$usernews) { $content .= I18N::translate('You have not created any journal items.'); } foreach ($usernews as $news) { $content .= '