# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
use strict;
+#use warnings; FIXME - Bug 2505
use C4::Context;
require Exporter;
=cut
@ISA = qw(Exporter);
-@EXPORT = qw(&listsubjects &updatesub &shiftgroup &deletedbib &undeletebib
-&updatetype);
+@EXPORT = qw(&listsubjects &shiftgroup &deletedbib &undeletebib
+&updatetype &logaction);
=item listsubjects
return($i,\@results);
}
-=item updatesub
-
- &updatesub($newsubject, $oldsubject);
-
-Renames a subject from C<$oldsubject> to C<$newsubject> in the
-bibliosubject table of the Koha database.
-
-=cut
-#'
-sub updatesub{
- my ($sub,$oldsub)=@_;
- my $dbh = C4::Context->dbh;
- my $sth=$dbh->prepare("update bibliosubject set subject=? where subject=?");
- $sth->execute($sub,$oldsub);
- $sth->finish;
-}
-
=item shiftgroup
&shiftgroup($biblionumber, $biblioitemnumber);
=cut
#'
sub shiftgroup{
- my ($bib,$bi)=@_;
+ my ($biblionumber,$bi)=@_;
my $dbh = C4::Context->dbh;
my $sth=$dbh->prepare("update biblioitems set biblionumber=? where biblioitemnumber=?");
- $sth->execute($bib,$bi);
+ $sth->execute($biblionumber,$bi);
$sth->finish;
$sth=$dbh->prepare("update items set biblionumber=? where biblioitemnumber=?");
- $sth->execute($bib,$bi);
+ $sth->execute($biblionumber,$bi);
$sth->finish;
}
=cut
#'
sub undeletebib{
- my ($bib)=@_;
+ my ($biblionumber)=@_;
my $dbh = C4::Context->dbh;
my $sth=$dbh->prepare("select * from deletedbiblio where biblionumber=?");
- $sth->execute($bib);
+ $sth->execute($biblionumber);
if (my @data=$sth->fetchrow_array){
$sth->finish;
# FIXME - Doesn't this keep the same biblionumber? Isn't this
# forbidden by the definition of 'biblio'? Or doesn't it matter?
- my $query="Insert into biblio values (";
- $query .= ("?," x $#data);
+ my $query="INSERT INTO biblio VALUES (";
+ my $count = @data;
+ $query .= ("?," x $count);
$query=~ s/\,$/\)/;
# print $query;
$sth=$dbh->prepare($query);
$sth->execute(@data);
$sth->finish;
}
- $sth=$dbh->prepare("Delete from deletedbiblio where biblionumber=?");
- $sth->execute($bib);
+ $sth=$dbh->prepare("DELETE FROM deletedbiblio WHERE biblionumber=?");
+ $sth->execute($biblionumber);
$sth->finish;
}
=head1 AUTHOR
-Koha Developement team <info@koha.org>
+Koha Development Team <info@koha.org>
=cut