From 36340be1696eb64897c99b4bb5b941af668c6c6b Mon Sep 17 00:00:00 2001 From: Martin Persson Date: Fri, 18 Dec 2015 11:16:08 +0100 Subject: [PATCH] Bug 14272: Show single news item (backend) Updates: Date formatting added to get_opac_new() Sponsored-by: Halland County Library --- C4/NewsChannels.pm | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm index 4dfde13..d041caf 100644 --- a/C4/NewsChannels.pm +++ b/C4/NewsChannels.pm @@ -126,15 +126,21 @@ sub get_opac_new { my ($idnew) = @_; my $dbh = C4::Context->dbh; my $query = q{ - SELECT opac_news.*,branches.branchname + SELECT opac_news.*,branches.branchname, + timestamp AS newdate, + borrowers.title AS author_title, + borrowers.firstname AS author_firstname, + borrowers.surname AS author_surname FROM opac_news LEFT JOIN branches ON opac_news.branchcode=branches.branchcode + LEFT JOIN borrowers on borrowers.borrowernumber = opac_news.borrowernumber WHERE opac_news.idnew = ?; }; my $sth = $dbh->prepare($query); $sth->execute($idnew); my $data = $sth->fetchrow_hashref; $data->{$data->{'lang'}} = 1 if defined $data->{lang}; + $data->{newdate} = output_pref({ dt => dt_from_string( $data->{newdate} ), dateonly => 1 }); $data->{expirationdate} = output_pref({ dt => dt_from_string( $data->{expirationdate} ), dateonly => 1 }); $data->{timestamp} = output_pref({ dt => dt_from_string( $data->{timestamp} ), dateonly => 1 }) ; return $data; -- 2.1.4