. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Module; use Fisharebest\Webtrees\Auth; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Tree; use Illuminate\Database\Capsule\Manager as DB; use Symfony\Component\HttpFoundation\RedirectResponse; use Symfony\Component\HttpFoundation\Request; use Symfony\Component\HttpFoundation\Response; use Symfony\Component\HttpKernel\Exception\AccessDeniedHttpException; /** * Class FamilyTreeNewsModule */ class FamilyTreeNewsModule extends AbstractModule implements ModuleInterface, ModuleBlockInterface { use ModuleBlockTrait; /** * How should this module be labelled on tabs, menus, etc.? * * @return string */ public function title(): string { /* I18N: Name of a module */ return I18N::translate('News'); } /** * A sentence describing what this module does. * * @return string */ public function description(): string { /* I18N: Description of the “News” module */ return I18N::translate('Family news and site announcements.'); } /** * Generate the HTML content of this block. * * @param Tree $tree * @param int $block_id * @param string $ctype * @param string[] $cfg * * @return string */ public function getBlock(Tree $tree, int $block_id, string $ctype = '', array $cfg = []): string { $articles = DB::table('news') ->where('gedcom_id', '=', $tree->id()) ->orderByDesc('updated') ->select(['news_id', 'user_id', 'gedcom_id', DB::raw('UNIX_TIMESTAMP(updated) AS updated'), 'subject', 'body']) ->get(); $content = view('modules/gedcom_news/list', [ 'articles' => $articles, 'block_id' => $block_id, 'limit' => 5, ]); if ($ctype !== '') { return view('modules/block-template', [ 'block' => str_replace('_', '-', $this->getName()), 'id' => $block_id, 'config_url' => '', 'title' => $this->title(), 'content' => $content, ]); } return $content; } /** {@inheritdoc} */ public function loadAjax(): bool { return false; } /** {@inheritdoc} */ public function isUserBlock(): bool { return false; } /** {@inheritdoc} */ public function isGedcomBlock(): bool { return true; } /** * Update the configuration for a block. * * @param Request $request * @param int $block_id * * @return void */ public function saveBlockConfiguration(Request $request, int $block_id) { } /** * An HTML form to edit block settings * * @param Tree $tree * @param int $block_id * * @return void */ public function editBlockConfiguration(Tree $tree, int $block_id) { } /** * @param Request $request * @param Tree $tree * * @return Response */ public function getEditNewsAction(Request $request, Tree $tree): Response { if (!Auth::isManager($tree)) { throw new AccessDeniedHttpException(); } $news_id = $request->get('news_id'); if ($news_id > 0) { $row = DB::table('news') ->where('news_id', '=', $news_id) ->where('gedcom_id', '=', $tree->id()) ->first(); } else { $row = (object) [ 'body' => '', 'subject' => '', ]; } $title = I18N::translate('Add/edit a journal/news entry'); return $this->viewResponse('modules/gedcom_news/edit', [ 'body' => $row->body, 'news_id' => $news_id, 'subject' => $row->subject, 'title' => $title, ]); } /** * @param Request $request * @param Tree $tree * * @return RedirectResponse */ public function postEditNewsAction(Request $request, Tree $tree): RedirectResponse { if (!Auth::isManager($tree)) { throw new AccessDeniedHttpException(); } $news_id = $request->get('news_id'); $subject = $request->get('subject'); $body = $request->get('body'); if ($news_id > 0) { DB::table('news') ->where('news_id', '=', $news_id) ->where('gedcom_id', '=', $tree->id()) ->update([ 'body' => $body, 'subject' => $subject, ]); } else { DB::table('news')->insert([ 'body' => $body, 'subject' => $subject, 'gedcom_id' => $tree->id(), ]); } $url = route('tree-page', [ 'ged' => $tree->name(), ]); return new RedirectResponse($url); } /** * @param Request $request * @param Tree $tree * * @return RedirectResponse */ public function postDeleteNewsAction(Request $request, Tree $tree): RedirectResponse { $news_id = $request->get('news_id'); if (!Auth::isManager($tree)) { throw new AccessDeniedHttpException(); } DB::table('news') ->where('news_id', '=', $news_id) ->where('gedcom_id', '=', $tree->id()) ->delete(); $url = route('tree-page', [ 'ged' => $tree->name(), ]); return new RedirectResponse($url); } }