Attachment 115759 Details for Bug 24223 – Bug 24223: (follow-up) Add date to OpacNav news entries

[patch] Bug 24223: (follow-up) Add date to OpacNav news entries

Bug-24223-follow-up-Add-date-to-OpacNav-news-entri.patch (text/plain), 1.56 KB, created by Owen Leonard on 2021-01-25 12:27:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Owen Leonard

Created: 2021-01-25 12:27:33 UTC

Size: 1.56 KB

patch

obsolete

>From e218208ea48e8e5cefe8dd40ac855807974d8590 Mon Sep 17 00:00:00 2001
>From: Owen Leonard <oleonard@myacpl.org>
>Date: Mon, 28 Sep 2020 13:45:23 +0000
>Subject: [PATCH] Bug 24223: (follow-up) Add date to OpacNav news entries
>
>This follow-up modifies the atomic update so that it inserts today's
>date as the "Published on" date. Without that information the system
>considers the item unpublished and will not display the content.
>
>Signed-off-by: David Nind <david@davidnind.com>
>---
> installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl b/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl
>index 29a24a8747..72802aed77 100644
>--- a/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl
>+++ b/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl
>@@ -20,7 +20,7 @@ if( CheckVersion( $DBversion ) ) {
>         foreach my $lang ( @langs ) {
>             print "Inserting OpacNav contents into $lang news item...\n";
>             # If there is a value in the OpacNav preference, insert it into opac_news
>-            $dbh->do("INSERT INTO opac_news (branchcode, lang, title, content ) VALUES (NULL, ?, '', ?)", undef, "OpacNav_$lang", $opacnav);
>+            $dbh->do("INSERT INTO opac_news (branchcode, lang, title, content, published_on ) VALUES (NULL, ?, '', ?, CAST(NOW() AS date))", undef, "OpacNav_$lang", $opacnav);
>         }
>     }
>     # Remove the OpacNav system preference
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24223: 104362 | 104364 | 104453 | 109856 | 110843 | 110853 | 110897 | 110898 | 113130 | 113131 | 113132 | 115758 | 115759 | 115760 | 124935 | 124936 | 124937 | 124938 | 125300 | 125301 | 125302 | 125303 | 125304 | 125767 | 125768 | 125769 | 125770 | 125771 | 126089 | 126147 | 126484 | 126485 | 126486 | 126487 | 126488 | 126489 | 126490 | 126491 | 126492 | 127338 | 127343 | 127344 | 127345 | 127346