3 # Copyright 2000-2002 Katipo Communications
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 use vars qw($VERSION @ISA @EXPORT);
28 # set the version for version checking
29 $VERSION = 3.07.00.049;
32 @EXPORT = qw(getreview savereview updatereview numberofreviews numberofreviewsbybiblionumber
33 getreviews getallreviews approvereview unapprovereview deletereview);
38 C4::Review - Perl Module containing routines for dealing with reviews of items
44 my $review=getreview($biblionumber,$borrowernumber);
45 savereview($biblionumber,$borrowernumber,$review);
46 updatereview($biblionumber,$borrowernumber,$review);
47 my $count=numberofreviews($status);
48 my $count=numberofreviewsbybiblionumber($biblionumber);
49 my $reviews=getreviews($biblionumber, $status);
50 my $reviews=getallreviews($status, [$offset], [$row_count]);
54 Review.pm provides many routines for manipulating reviews.
60 $review = getreview($biblionumber,$borrowernumber);
62 Takes a borrowernumber and a biblionumber and returns the review of that biblio
67 my ( $biblionumber, $borrowernumber ) = @_;
68 my $dbh = C4::Context->dbh;
70 "SELECT * FROM reviews WHERE biblionumber=? and borrowernumber=?";
71 my $sth = $dbh->prepare($query);
72 $sth->execute( $biblionumber, $borrowernumber );
73 return $sth->fetchrow_hashref();
78 savereview($biblionumber,$borrowernumber, $review);
80 Save a review in the 'reviews' database
85 my ( $biblionumber, $borrowernumber, $review ) = @_;
86 my $dbh = C4::Context->dbh;
87 my $query = "INSERT INTO reviews (borrowernumber,biblionumber,
88 review,approved,datereviewed) VALUES
90 my $sth = $dbh->prepare($query);
91 $sth->execute( $borrowernumber, $biblionumber, $review);
96 updateview($biblionumber,$borrowernumber, $review);
98 Update the review description in the 'reviews' database
103 my ( $biblionumber, $borrowernumber, $review ) = @_;
104 my $dbh = C4::Context->dbh;
105 my $query = "UPDATE reviews SET review=?,datereviewed=now(),approved=0 WHERE borrowernumber=? and biblionumber=?";
106 my $sth = $dbh->prepare($query);
107 $sth->execute( $review, $borrowernumber, $biblionumber );
110 =head2 numberofreviews
112 my $count=numberofreviews( [$status] );
114 Return the number of reviews where in the 'reviews' database : 'approved' = $status
115 (By default $status = 1)
119 sub numberofreviews {
121 my $status = (defined($param) ? $param : 1);
122 my $dbh = C4::Context->dbh;
124 "SELECT count(*) FROM reviews WHERE approved=?";
125 my $sth = $dbh->prepare($query);
126 $sth->execute( $status );
127 return $sth->fetchrow;
130 =head2 numberofreviewsbybiblionumber
132 my $count=numberofreviewsbybiblionumber($biblionumber);
134 Return the number of reviews approved for a given biblionumber
138 sub numberofreviewsbybiblionumber {
139 my ($biblionumber) = @_;
140 my $dbh = C4::Context->dbh;
142 "SELECT count(*) FROM reviews WHERE biblionumber=? and approved=?";
143 my $sth = $dbh->prepare($query);
144 $sth->execute( $biblionumber, 1 );
145 return $sth->fetchrow;
150 my $reviews=getreviews($biblionumber, $status);
152 Return all reviews where in the 'reviews' database :
153 'biblionumber' = $biblionumber and 'approved' = $status
158 my ( $biblionumber, $approved ) = @_;
159 my $dbh = C4::Context->dbh;
161 "SELECT * FROM reviews WHERE biblionumber=? and approved=? order by datereviewed desc";
162 my $sth = $dbh->prepare($query);
163 $sth->execute( $biblionumber, $approved );
164 return $sth->fetchall_arrayref({});
169 my $reviews=getallreviews($status, [$offset], [$row_count]);
171 Return all reviews where in the 'reviews' database : 'approved' = $status
173 If offset and row_count are fiven, it's return all reviews between the
174 $offset position and the ($offset + $row_count) position.
175 (By default : $offset = 0 and $row_count = 20)
180 my ($status, $offset, $row_count) = @_;
181 my @params = ($status,($offset ? $offset : 0),($row_count ? $row_count : 20));
182 my $dbh = C4::Context->dbh;
184 "SELECT * FROM reviews WHERE approved=? order by datereviewed desc LIMIT ?, ?";
185 my $sth = $dbh->prepare($query);
186 $sth->execute(@params);
187 return $sth->fetchall_arrayref({});
192 approvereview($reviewid);
194 Takes a reviewid and marks that review approved
200 my $dbh = C4::Context->dbh();
201 my $query = "UPDATE reviews
204 my $sth = $dbh->prepare($query);
205 $sth->execute( 1, $reviewid );
208 =head2 unapprovereview
210 unapprovereview($reviewid);
212 Takes a reviewid and marks that review as not approved
216 sub unapprovereview {
218 my $dbh = C4::Context->dbh();
219 my $query = "UPDATE reviews
222 my $sth = $dbh->prepare($query);
223 $sth->execute( 0, $reviewid );
228 deletereview($reviewid);
230 Takes a reviewid and deletes it
236 my $dbh = C4::Context->dbh();
237 my $query = "DELETE FROM reviews
239 my $sth = $dbh->prepare($query);
240 $sth->execute($reviewid);