From 432bba3dee1d9be25b9626ac45115929a6422961 Mon Sep 17 00:00:00 2001 From: Jonathan Tschanter Date: Fri, 21 Jan 2022 15:13:35 +0100 Subject: Add layout based on list entries --- src/Controller/Home.php | 6 +++++- src/Model/Artwork.php | 6 +++--- 2 files changed, 8 insertions(+), 4 deletions(-) (limited to 'src') diff --git a/src/Controller/Home.php b/src/Controller/Home.php index 7eda5ee..36879e0 100644 --- a/src/Controller/Home.php +++ b/src/Controller/Home.php @@ -30,7 +30,11 @@ class Home public static function dashboard() { - return Template::render('dashboard.twig', []); + $cards = DB::$entityManager->getRepository(Card::class)->findAll(); + $cardOfTheDay = $cards[array_rand($cards)]; + return Template::render('dashboard.twig', [ + 'cardOfTheDay' => $cardOfTheDay, + ]); } } diff --git a/src/Model/Artwork.php b/src/Model/Artwork.php index 25f6ee5..6380f62 100644 --- a/src/Model/Artwork.php +++ b/src/Model/Artwork.php @@ -88,9 +88,9 @@ class Artwork { $result = DB::$entityManager ->createQuery( - 'SELECT sum(v.value) as total - FROM Elements\Model\VoteArtwork v - WHERE v.artwork = :artwork' + 'SELECT sum(v.value) as total + FROM Elements\Model\VoteArtwork v + WHERE v.artwork = :artwork' ) ->setParameter('artwork', $this) ->getOneOrNullResult(); -- cgit v1.2.3