From 534923577f3f96d9486ac5e4c6a6132219f1da23 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 26 May 2023 08:19:36 +0000 Subject: [PATCH] Bug 33843: Use filter_by_last_update in Koha::Notice::Util Resolve FIXME in sub _get_domain_count by using new logic from bug 33837. Test plan: Run t/db_dependent/Koha/Notice_Util.t. This triggers the _get_domain_count call using the filter. Signed-off-by: Marcel de Rooy Signed-off-by: David Nind Signed-off-by: Jonathan Druart --- Koha/Notice/Util.pm | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/Koha/Notice/Util.pm b/Koha/Notice/Util.pm index 98f6182cf51..60ffa3dbdbe 100644 --- a/Koha/Notice/Util.pm +++ b/Koha/Notice/Util.pm @@ -116,15 +116,15 @@ sub _get_domain_count { } keys %$limits; my $sum = 0; - my $dt_parser = Koha::Database->new->schema->storage->datetime_parser; my $start_dt = _convert_unit( undef, $limits->{$group}->{unit} ); foreach my $domain ( @domains ) { - $sum += Koha::Notice::Messages->search({ - message_transport_type => 'email', - status => 'sent', - to_address => { 'LIKE', '%'.$domain }, - updated_on => { '>=', $dt_parser->format_datetime($start_dt) }, # FIXME Would be nice if possible via filter_by_last_update - })->count; + $sum += Koha::Notice::Messages->search( + { + message_transport_type => 'email', + status => 'sent', + to_address => { 'LIKE', '%' . $domain }, + } + )->filter_by_last_update( { timestamp_column_name => 'updated_on', from => $start_dt } )->count; } $limits->{$group}->{count} = $sum; } -- 2.25.1