Bugzilla – Attachment 58796 Details for
Bug 17778
Make "Earliest Registered Date" in OAI-PMH dynamic
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17778 - Make "Earliest Registered Date" in OAI dynamic
Bug-17778---Make-Earliest-Registered-Date-in-OAI-d.patch (text/plain), 2.01 KB, created by
Jonathan Druart
on 2017-01-11 08:22:18 UTC
(
hide
)
Description:
Bug 17778 - Make "Earliest Registered Date" in OAI dynamic
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2017-01-11 08:22:18 UTC
Size:
2.01 KB
patch
obsolete
>From 1e7909fcffbec3e17943c28099d067a3a47de42e Mon Sep 17 00:00:00 2001 >From: Magnus Enger <magnus@libriotech.no> >Date: Fri, 6 Jan 2017 15:27:04 +0100 >Subject: [PATCH] Bug 17778 - Make "Earliest Registered Date" in OAI dynamic > >This was hardcoded to 0001-01-01. > >To test: >- Make sure you have a couple of records, with different timestamps >- Enable OAI-PMH >- Check http://localhost:2201/cgi-bin/koha/oai.pl?verb=Identify > and verify that "Earliest Registered Date" is 0001-01-01 >- Apply the patch >- Re-check the "Earliest Registered Date" and verify that it is now > the lowest timestamp in your biblio table >- Manipulate the timestamps and verify that "Earliest Registered Date" > changes accordingly >- Sign off! > >Signed-off-by: Owen Leonard <oleonard@myacpl.org> > >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >--- > Koha/OAI/Server/Identify.pm | 16 +++++++++++++++- > 1 file changed, 15 insertions(+), 1 deletion(-) > >diff --git a/Koha/OAI/Server/Identify.pm b/Koha/OAI/Server/Identify.pm >index 3ab2188..bddfc29 100644 >--- a/Koha/OAI/Server/Identify.pm >+++ b/Koha/OAI/Server/Identify.pm >@@ -34,7 +34,7 @@ sub new { > adminEmail => C4::Context->preference("KohaAdminEmailAddress"), > MaxCount => C4::Context->preference("OAI-PMH:MaxCount"), > granularity => 'YYYY-MM-DD', >- earliestDatestamp => '0001-01-01', >+ earliestDatestamp => _get_earliest_datestamp() || '0001-01-01', > deletedRecord => C4::Context->preference("OAI-PMH:DeletedRecord") || 'no', > ); > >@@ -49,4 +49,18 @@ sub new { > return $self; > } > >+# Find the earliest timestamp in the biblio table. If this table is empty, undef >+# will be returned and we will report the fallback 0001-01-01. >+sub _get_earliest_datestamp { >+ >+ my $dbh = C4::Context->dbh; >+ >+ my $order_sth = $dbh->prepare( "SELECT DATE(MIN(timestamp)) AS earliest FROM biblio" ); >+ $order_sth->execute(); >+ my $res = $order_sth->fetchrow_hashref(); >+ >+ return $res->{'earliest'}; >+ >+} >+ > 1; >-- >2.1.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 17778
:
58647
|
58648
|
58758
| 58796 |
58797