package C4::Suggestions;
# Copyright 2000-2002 Katipo Communications
+# Parts Copyright Biblibre 2011
#
# This file is part of Koha.
#
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;
ModSuggestion
NewSuggestion
SearchSuggestion
+ DelSuggestionsOlderThan
>;
-
=head1 NAME
C4::Suggestions - Some useful functions for dealings with aqorders.
if ($userenv) {
if (($userenv->{flags} % 2) != 1 && !$suggestion->{branchcode}){
push @sql_params,$$userenv{branch};
- push @query,q{ and (branchcode = ? or branchcode ='')};
+ push @query,q{ and (suggestions.branchcode = ? or suggestions.branchcode ='')};
}
}
}
}
}
+ 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);
}
}
+=head2 DelSuggestionsOlderThan
+ &DelSuggestionsOlderThan($days)
+
+ Delete all suggestions older than TODAY-$days , that have be accepted or rejected.
+
+=cut
+sub DelSuggestionsOlderThan {
+ my ($days) = @_;
+ return if not $days;
+ my $dbh = C4::Context->dbh;
+
+ my $sth = $dbh->prepare("
+ DELETE FROM suggestions WHERE STATUS <> 'ASKED' AND date < ADDDATE(NOW(), ?);
+ ");
+ $sth->execute("-$days");
+}
+
1;
__END__