From 556349f6f15bb7017fa4f3dc24a4f84fad777090 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] Bug 5947 Suggestions : add date to the search query
---
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