X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=C4%2FMaintainance.pm;h=8726ef91f1da39c8b0e556c4f27430261d3a0d91;hb=9c5e40e4923179bf0b2b630d3e09797dc4c1fdb0;hp=43d0434a1eb603f7130d5007e0e44353a1a21e47;hpb=998cc6bc2be3c3ced4d2663830368673796f644b;p=koha.git diff --git a/C4/Maintainance.pm b/C4/Maintainance.pm index 43d0434a1e..8726ef91f1 100644 --- a/C4/Maintainance.pm +++ b/C4/Maintainance.pm @@ -16,11 +16,12 @@ package C4::Maintainance; #assumes C4/Maintainance # 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; @@ -28,7 +29,7 @@ require Exporter; use vars qw($VERSION @ISA @EXPORT); # set the version for version checking -$VERSION = 0.01; +$VERSION = 3.07.00.049; =head1 NAME @@ -46,15 +47,13 @@ miscategorized items, etc. =head1 FUNCTIONS -=over 2 - =cut @ISA = qw(Exporter); -@EXPORT = qw(&listsubjects &updatesub &shiftgroup &deletedbib &undeletebib -&updatetype); +@EXPORT = qw(&listsubjects &shiftgroup &deletedbib &undeletebib +&updatetype &logaction); -=item listsubjects +=head2 listsubjects ($count, $results) = &listsubjects($subject, $n, $offset); @@ -73,6 +72,7 @@ C<&listsubject> returns up to C<$n> items, starting at C<$offset>. If C<$n> is 0, it will return all matching subjects. =cut + #' # FIXME - This API is bogus. The way it's currently used, it should # just return a list of strings. @@ -100,24 +100,7 @@ sub 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 +=head2 shiftgroup &shiftgroup($biblionumber, $biblioitemnumber); @@ -126,19 +109,20 @@ C<$biblioitemnumber> is the number of the biblioitem to change. C<$biblionumber> is the biblionumber to associate it with. =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; } -=item deletedbib +=head2 deletedbib ($count, $results) = &deletedbib($title); @@ -150,6 +134,7 @@ the fields of the deletedbiblio table in the Koha database. C<$count> is the number of elements in C<$results>. =cut + #' sub deletedbib{ my ($title)=@_; @@ -166,7 +151,7 @@ sub deletedbib{ return($i,\@results); } -=item undeletebib +=head2 undeletebib &undeletebib($biblionumber); @@ -175,30 +160,32 @@ biblionumber in the deletedbiblio table of the Koha database, and moves its entry to the biblio table. =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; } -=item updatetype +=head2 updatetype &updatetype($biblioitemnumber, $itemtype); @@ -206,6 +193,7 @@ Changes the type of the item with the given biblioitemnumber to be C<$itemtype>. =cut + #' sub updatetype{ my ($bi,$type)=@_; @@ -220,10 +208,8 @@ END { } # module clean-up code here (global destructor) 1; __END__ -=back - =head1 AUTHOR -Koha Developement team +Koha Development Team =cut