Attachment 45818 Details for Bug 14272 – Bug 14272: Show single news item (backend)

[patch] Bug 14272: Show single news item (backend)

Bug-14272-Show-single-news-item-backend.patch (text/plain), 1.23 KB, created by Martin Persson on 2015-12-18 12:49:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Persson

Created: 2015-12-18 12:49:58 UTC

Size: 1.23 KB

patch

obsolete

>From 4d8d2ccb0bfe4c16b199f1678b4610a703ab1755 Mon Sep 17 00:00:00 2001
>From: Martin Persson <xarragon@gmail.com>
>Date: Fri, 18 Dec 2015 11:16:08 +0100
>Subject: [PATCH] Bug 14272: Show single news item (backend)
>
>Sponsored-by: Halland County Library
>---
> C4/NewsChannels.pm | 7 ++++++-
> 1 file changed, 6 insertions(+), 1 deletion(-)
>
>diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm
>index 4dfde13..1338bb5 100644
>--- a/C4/NewsChannels.pm
>+++ b/C4/NewsChannels.pm
>@@ -126,9 +126,14 @@ 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);
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 14272: 45721 | 45740 | 45741 | 45818 | 45820 | 45845 | 45846 | 45935 | 45936 | 45937 | 47556 | 47557 | 47558 | 47665 | 47666 | 47667 | 47668 | 47669 | 47670 | 47671 | 47672 | 47673 | 50557 | 50558 | 50559 | 59483 | 70728 | 70729 | 70730 | 70731 | 72065 | 72548 | 72549 | 72550 | 72551 | 76015 | 76307 | 76580 | 76662 | 77546 | 77564 | 77565 | 77566 | 77567 | 77568 | 77569 | 78104 | 78206 | 78207 | 78208 | 78231 | 81643 | 82713 | 83425 | 83426 | 83427 | 83428 | 83429 | 83430 | 84868 | 84869 | 84870 | 84871 | 84872 | 84873 | 84874