. */ namespace Fisharebest\Webtrees\Module; use Fisharebest\Webtrees\Auth; use Fisharebest\Webtrees\Database; use Fisharebest\Webtrees\Filter; use Fisharebest\Webtrees\Functions\FunctionsDate; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Theme; /** * Class FamilyTreeNewsModule */ class FamilyTreeNewsModule extends AbstractModule implements ModuleBlockInterface { // How to update the database schema for this module const SCHEMA_TARGET_VERSION = 3; const SCHEMA_SETTING_NAME = 'NB_SCHEMA_VERSION'; const SCHEMA_MIGRATION_PREFIX = '\Fisharebest\Webtrees\Module\FamilyTreeNews\Schema'; /** * Create a new module. * * @param string $directory Where is this module installed */ public function __construct($directory) { parent::__construct($directory); // Create/update the database tables. // NOTE: if we want to set any module-settings, we'll need to move this. Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); } /** * How should this module be labelled on tabs, menus, etc.? * * @return string */ public function getTitle() { return /* I18N: Name of a module */ I18N::translate('News'); } /** * A sentence describing what this module does. * * @return string */ public function getDescription() { return /* I18N: Description of the “News” module */ I18N::translate('Family news and site announcements.'); } /** * Generate the HTML content of this block. * * @param int $block_id * @param bool $template * @param string[] $cfg * * @return string */ public function getBlock($block_id, $template = true, $cfg = array()) { global $ctype, $WT_TREE; switch (Filter::get('action')) { case 'deletenews': $news_id = Filter::get('news_id'); if ($news_id) { Database::prepare("DELETE FROM `##news` WHERE news_id = ?")->execute(array($news_id)); } break; } $more_news = Filter::getInteger('more_news'); $limit = 5 * (1 + $more_news); $articles = Database::prepare( "SELECT SQL_CACHE news_id, user_id, gedcom_id, UNIX_TIMESTAMP(updated) + :offset AS updated, subject, body FROM `##news` WHERE gedcom_id = :tree_id ORDER BY updated DESC LIMIT :limit" )->execute(array( 'offset' => WT_TIMESTAMP_OFFSET, 'tree_id' => $WT_TREE->getTreeId(), 'limit' => $limit, ))->fetchAll(); $count = Database::prepare( "SELECT SQL_CACHE COUNT(*) FROM `##news` WHERE gedcom_id = :tree_id" )->execute(array( 'tree_id' => $WT_TREE->getTreeId(), ))->fetchOne(); $id = $this->getName() . $block_id; $class = $this->getName() . '_block'; $title = $this->getTitle(); $content = ''; if (empty($articles)) { $content .= I18N::translate('No news articles have been submitted.'); } foreach ($articles as $article) { $content .= '

'; $content .= '

' . Filter::escapeHtml($article->subject) . '

'; $content .= '

' . FunctionsDate::formatTimestamp($article->updated) . '

'; if ($article->body == strip_tags($article->body)) { $article->body = nl2br($article->body, false); } $content .= $article->body; if (Auth::isManager($WT_TREE)) { $content .= '

'; $content .= '' . I18N::translate('Edit') . ''; $content .= ' | '; $content .= '" . I18N::translate('Delete') . '
'; } $content .= '

'; } if (Auth::isManager($WT_TREE)) { $content .= '' . I18N::translate('Add a news article') . ''; } if ($count > $limit) { if (Auth::isManager($WT_TREE)) { $content .= ' | '; } $content .= '' . I18N::translate('More news articles') . ""; } if ($template) { return Theme::theme()->formatBlock($id, $title, $class, $content); } else { return $content; } } /** {@inheritdoc} */ public function loadAjax() { return false; } /** {@inheritdoc} */ public function isUserBlock() { return false; } /** {@inheritdoc} */ public function isGedcomBlock() { return true; } /** * An HTML form to edit block settings * * @param int $block_id */ public function configureBlock($block_id) { } }