Attachment 3642 Details for Bug 5947 – Signed off patch

[patch] Signed off patch

0001-SIGNED-OFF-Bug-5947-Suggestions-add-date-to-the-sear.patch (text/plain), 1.43 KB, created by Katrin Fischer on 2011-04-04 15:18:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2011-04-04 15:18:03 UTC

Size: 1.43 KB

patch

obsolete

>From 0dbda02329f1a78af94da372b2d14015fcd35671 Mon Sep 17 00:00:00 2001
>From: Alex Arnaud <alex.arnaud@biblibre.com>
>Date: Mon, 7 Jun 2010 12:39:21 +0200
>Subject: [PATCH] [SIGNED-OFF] Bug 5947 Suggestions : add date to the search query
>Content-Type: text/plain; charset="utf-8"
>
>Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
>Fixes searching by dates, like 'Suggested on:'
>---
> C4/Suggestions.pm |   13 ++++++++++++-
> 1 files changed, 12 insertions(+), 1 deletions(-)
>
>diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm
>index 9cb2c18..48c1782 100644
>--- a/C4/Suggestions.pm
>+++ b/C4/Suggestions.pm
>@@ -25,7 +25,7 @@ use CGI;
> 
> use C4::Context;
> use C4::Output;
>-use C4::Dates qw(format_date);
>+use C4::Dates qw(format_date format_date_in_iso);
> use C4::SQLHelper qw(:all);
> use C4::Debug;
> use C4::Letters;
>@@ -147,6 +147,17 @@ sub SearchSuggestion  {
>         }
>     }
> 
>+    my $today = C4::Dates->today('iso');
>+
>+    foreach ( qw( suggesteddate manageddate accepteddate ) ) {
>+        my $from = $_ . "_from";
>+        my $to = $_ . "_to";
>+        if ($$suggestion{$from} || $$suggestion{$to}) {
>+            push @query, " AND suggestions.suggesteddate BETWEEN '" 
>+                . (format_date_in_iso($$suggestion{$from}) || 0000-00-00) . "' AND '" . (format_date_in_iso($$suggestion{$to}) || $today) . "'";
>+        } 
>+    }
>+
>     $debug && warn "@query";
>     my $sth=$dbh->prepare("@query");
>     $sth->execute(@sql_params);
>-- 
>1.7.1
>

Actions: View | Diff | Splinter Review

Attachments on bug 5947: 3424 | 3642