# You should have received a copy of the GNU General Public License
# along with Koha; if not, see <http://www.gnu.org/licenses>.
-use strict;
-use warnings;
+use Modern::Perl;
use CGI qw ( -utf8 );
use C4::Auth;
use C4::Review;
use C4::Members;
use C4::Biblio;
+use Koha::Reviews;
my $query = new CGI;
my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
my $op = $query->param('op') || '';
my $status = $query->param('status') || 0;
my $reviewid = $query->param('reviewid');
-my $offset = $query->param('offset') || 0;
+my $page = $query->param('page') || 1;
my $count = C4::Context->preference('numSearchResults') || 20;
-my $total = numberofreviews($status);
+my $total = Koha::Reviews->search({ approved => $status })->count;
if ( $op eq 'approve' ) {
- approvereview($reviewid);
+ my $review = Koha::Reviews->find( $reviewid );
+ $review->approve if $review;
}
elsif ( $op eq 'unapprove' ) {
- unapprovereview($reviewid);
+ my $review = Koha::Reviews->find( $reviewid );
+ $review->unapprove if $review;
}
elsif ( $op eq 'delete' ) {
- deletereview($reviewid);
+ my $review = Koha::Reviews->find( $reviewid );
+ $review->delete if $review;
}
-my $reviews = getallreviews($status,$offset,$count);
+my $reviews = Koha::Reviews->search(
+ { approved => $status },
+ {
+ rows => $count,
+ page => $page,
+ order_by => { -desc => 'datereviewed' },
+ }
+)->unblessed;
foreach ( @$reviews ) {
my $borrowernumber = $_->{borrowernumber};
$template->param(
status => $status,
reviews => $reviews,
- pagination_bar => pagination_bar( $url, ( int( $total / $count ) ) + ( ( $total % $count ) > 0 ? 1 : 0 ), $offset, "offset" )
+ pagination_bar => pagination_bar( $url, ( int( $total / $count ) ) + ( ( $total % $count ) > 0 ? 1 : 0 ), $page, "page" )
);
output_html_with_http_headers $query, $cookie, $template->output;