Attachment 125690 Details for Bug 27945 – Bug 27945: (follow-up) Clarify 'same day' behavior

[patch] Bug 27945: (follow-up) Clarify 'same day' behavior

Bug-27945-follow-up-Clarify-same-day-behavior.patch (text/plain), 993 bytes, created by Jonathan Druart on 2021-10-04 10:36:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-10-04 10:36:47 UTC

Size: 993 bytes

patch

obsolete

>From 7495e87c4977d095a9d3c0080d27858a40d2f67e Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 4 Oct 2021 12:35:44 +0200
>Subject: [PATCH] Bug 27945: (follow-up) Clarify 'same day' behavior
>
>Don't use MySQLism
>---
> Koha/Patron.pm | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/Koha/Patron.pm b/Koha/Patron.pm
>index f3b7d22afa3..de25e861052 100644
>--- a/Koha/Patron.pm
>+++ b/Koha/Patron.pm
>@@ -975,7 +975,7 @@ sub can_request_article {
> 
>     my $count = Koha::ArticleRequests->search(
>         [   { borrowernumber => $self->borrowernumber, status => [ 'REQUESTED', 'PENDING', 'PROCESSING' ] },
>-            { borrowernumber => $self->borrowernumber, status => 'COMPLETED', updated_on => { '>=' => \'DATE(NOW())' } },
>+            { borrowernumber => $self->borrowernumber, status => 'COMPLETED', updated_on => { '>=' => \'CAST(NOW() AS DATE)' } },
>         ]
>     )->count;
>     return $count < $limit ? 1 : 0;
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 27945: 123217 | 123218 | 123219 | 123220 | 123714 | 123715 | 123774 | 123775 | 123776 | 123777 | 123778 | 123820 | 124066 | 124067 | 124068 | 124069 | 124070 | 124071 | 124072 | 124073 | 124074 | 124075 | 124076 | 124077 | 124078 | 124079 | 124284 | 124285 | 124633 | 124673 | 124674 | 124675 | 124676 | 124677 | 124678 | 124679 | 124680 | 124681 | 124682 | 125140 | 125142 | 125143 | 125144 | 125145 | 125146 | 125147 | 125148 | 125149 | 125150 | 125151 | 125152 | 125178 | 125179 | 125569 | 125571 | 125638 | 125690 | 125702 | 125703 | 125704 | 125705 | 125706 | 125707 | 125726 | 125741 | 125761