Bug 18928: (follow-up) Make DB update idempotent
[koha.git] / Koha / Ratings.pm
blobd449a85b005c701db9427038fc6f5fc6fa129da1
1 package Koha::Ratings;
3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it under the
6 # terms of the GNU General Public License as published by the Free Software
7 # Foundation; either version 3 of the License, or (at your option) any later
8 # version.
10 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
11 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
12 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
14 # You should have received a copy of the GNU General Public License along
15 # with Koha; if not, write to the Free Software Foundation, Inc.,
16 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
18 use Modern::Perl;
20 use Carp;
22 use Koha::Database;
24 use Koha::Rating;
26 use base qw(Koha::Objects);
28 =head1 NAME
30 Koha::Ratings - Koha Rating Object set class
32 =head1 API
34 =head2 Class Methods
36 =cut
38 =head3 get_avg_rating
40 =cut
42 sub get_avg_rating {
43 my ( $self ) = @_;
45 my $sum = $self->_resultset->get_column('rating_value')->sum();
46 my $total = $self->count();
48 my $avg = 0;
49 if ( $sum and $total ) {
50 eval { $avg = $sum / $total };
52 $avg = sprintf( "%.1f", $avg );
54 return $avg;
57 =head3 type
59 =cut
61 sub _type {
62 return 'Rating';
65 sub object_class {
66 return 'Koha::Rating';