-package C4::Catalogue; #asummes C4/Acquisitions.pm
+package C4::Catalogue;
# Continue working on updateItem!!!!!!
#
# functions
#
# Trying to track down $dbh's that aren't disconnected....
-#
+# Copyright 2000-2002 Katipo Communications
+#
+# This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it under the
+# terms of the GNU General Public License as published by the Free Software
+# Foundation; either version 2 of the License, or (at your option) any later
+# version.
+#
+# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
+# 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
+
use strict;
require Exporter;
-use C4::Database;
+use C4::Context;
+use MARC::Record;
+use C4::Biblio;
-use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
+use vars qw($VERSION @ISA @EXPORT);
# set the version for version checking
$VERSION = 0.01;
+=head1 NAME
+
+C4::Catalogue - Koha functions for dealing with orders and acquisitions
+
+=head1 SYNOPSIS
+
+ use C4::Catalogue;
+
+=head1 DESCRIPTION
+
+The functions in this module deal with acquisitions, managing book
+orders, converting money to different currencies, and so forth.
+
+=head1 FUNCTIONS
+
+=over 2
+
+=cut
+
@ISA = qw(Exporter);
-@EXPORT = qw(&newBiblio &newBiblioItem &newItem &updateBiblio &updateBiblioItem
- &updateItem &changeSubfield);
-%EXPORT_TAGS = ( ); # eg: TAG => [ qw!name1 name2! ],
-
-# your exported package globals go here,
-# as well as any optionally exported functions
-
-@EXPORT_OK = qw($Var1 %Hashit);
-
-
-# non-exported package globals go here
-use vars qw(@more $stuff);
-
-# initalize package globals, first exported ones
-
-my $Var1 = '';
-my %Hashit = ();
-
-
-# then the others (which are still accessible as $Some::Module::stuff)
-my $stuff = '';
-my @more = ();
-
-# all file-scoped lexicals must be created before
-# the functions below that use them.
-
-# file-private lexicals go here
-my $priv_var = '';
-my %secret_hash = ();
-
-# here's a file-private function as a closure,
-# callable as &$priv_func; it cannot be prototyped.
-my $priv_func = sub {
- # stuff goes here.
- };
-
-# make all your functions, whether exported or not;
-
-
-
-sub newBiblio {
-# This subroutine makes no modifications to the MARC tables. MARC records are
-# only created when new biblioitems are added.
- my ($env, $biblio) = @_;
- my $dbh=&C4Connect;
- my $subject=$biblio->{'subject'};
- my $additionalauthors=$biblio->{'additionalauthors'};
-
-# Why am I doing this? This is a potential race condition. At the very least,
-# this needs code to ensure that two inserts didn't use the same
-# biblionumber...
-
- # Get next biblio number
- my $sth=$dbh->prepare("select max(biblionumber) from biblio");
- $sth->execute;
- my ($biblionumber) = $sth->fetchrow;
- $biblionumber++;
-
- $sth=$dbh->prepare("insert into biblio
- (biblionumber,title,author,
- unititle,copyrightdate,
- serial,seriestitle,notes)
- values (?, ?, ?, ?, ?, ?, ?, ?)");
- $sth->execute($biblionumber, $biblio->{'title'}, $biblio->{'author'},
- $biblio->{'unititle'}, $biblio->{'copyrightdate'},
- $biblio->{'serial'}, $biblio->{'seriestitle'}, $biblio->{'notes'} );
- $sth=$dbh->prepare("insert into bibliosubtitle
- (biblionumber,subtitle)
- values (?,?)");
- $sth->execute($biblionumber, $biblio->{'subtitle'} );
-
- my $sth=$dbh->prepare("insert into bibliosubject
- (biblionumber,subject)
- values (?,?) ");
- foreach $_ (@$subject) {
- $sth->execute($biblionumber,$_);
- }
- my $sth=$dbh->prepare("insert into additionalauthors
- (biblionumber,author)
- values (?, ?)");
- foreach $_ (@$additionalauthors) {
- $sth->execute($biblionumber, $_ );
- }
-}
+@EXPORT = qw(
+ &basket &newbasket
+ &getorders &getallorders &getrecorders
+ &getorder &neworder &delorder
+ &ordersearch
+ &modorder &getsingleorder &invoice &receiveorder
+ &updaterecorder &newordernum
-sub changeSubfield {
-# Subroutine changes a subfield value given a subfieldid.
- my ( $subfieldid, $subfieldvalue )=@_;
+ &bookfunds &bookfundbreakdown &updatecost
+ &curconvert &getcurrencies &updatecurrencies &getcurrency
- my $firstdigit="?";
+ &findall &needsmod &branches &updatesup &insertsup
+ &bookseller &breakdown &checkitems
+ &websitesearch &addwebsite &updatewebsite &deletewebsite
+);
- my $dbh=&c4connect;
- my $sth=$dbh->prepare("update marc_$firstdigit\XX_subfield_table set subfieldvalue=? where subfieldid=?");
- $sth->execute($subfieldvalue, $subfieldid);
+#
+#
+#
+# BASKETS
+#
+#
+#
+=item basket
+
+ ($count, @orders) = &basket($basketnumber, $booksellerID);
+
+Looks up the pending (non-cancelled) orders with the given basket
+number. If C<$booksellerID> is non-empty, only orders from that seller
+are returned.
+
+C<&basket> returns a two-element array. C<@orders> is an array of
+references-to-hash, whose keys are the fields from the aqorders,
+biblio, and biblioitems tables in the Koha database. C<$count> is the
+number of elements in C<@orders>.
+
+=cut
+#'
+sub basket {
+ my ($basketno,$supplier)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select *,biblio.title from aqorders,biblio,biblioitems
+ where basketno=?
+ and biblio.biblionumber=aqorders.biblionumber and biblioitems.biblioitemnumber
+ =aqorders.biblioitemnumber
+ and (datecancellationprinted is NULL or datecancellationprinted =
+ '0000-00-00')"
+ .(($supplier ne '')?" and aqorders.booksellerid=?":"")
+ ." group by aqorders.ordernumber");
+ if ($supplier ne '') {
+ $sth->execute($basketno,$supplier);
+ } else {
+ $sth->execute($basketno);
+ }
+ $query.=" order by biblioitems.publishercode";
+ my $sth=$dbh->prepare($query);
+ $sth->execute;
+ my @results;
+# print $query;
+ my $i=0;
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),@results);
+}
- $dbh->disconnect;
- return($Subfield_ID, $Subfield_Key);
+=item newbasket
+
+ $basket = &newbasket();
+
+Finds the next unused basket number in the aqorders table of the Koha
+database, and returns it.
+
+=cut
+#'
+# FIXME - There's a race condition here:
+# A calls &newbasket
+# B calls &newbasket (gets the same number as A)
+# A updates the basket
+# B updates the basket, and clobbers A's result.
+# A better approach might be to create a dummy order (with, say,
+# requisitionedby == "Dummy-$$" or notes == "dummy <time> <pid>"), and
+# see which basket number it gets. Then have a cron job periodically
+# remove out-of-date dummy orders.
+sub newbasket {
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select max(basketno) from aqorders");
+ $sth->execute;
+ my $data=$sth->fetchrow_arrayref;
+ my $basket=$$data[0];
+ $basket++;
+ $sth->finish;
+ return($basket);
}
+=item neworder
+
+ &neworder($biblionumber, $title, $ordnum, $basket, $quantity, $listprice,
+ $booksellerid, $who, $notes, $bookfund, $biblioitemnumber, $rrp,
+ $ecost, $gst, $budget, $unitprice, $subscription,
+ $booksellerinvoicenumber);
+
+Adds a new order to the database. Any argument that isn't described
+below is the new value of the field with the same name in the aqorders
+table of the Koha database.
+
+C<$ordnum> is a "minimum order number." After adding the new entry to
+the aqorders table, C<&neworder> finds the first entry in aqorders
+with order number greater than or equal to C<$ordnum>, and adds an
+entry to the aqorderbreakdown table, with the order number just found,
+and the book fund ID of the newly-added order.
+
+C<$budget> is effectively ignored.
+
+C<$subscription> may be either "yes", or anything else for "no".
+
+=cut
+#'
+sub neworder {
+ my ($bibnum,$title,$ordnum,$basket,$quantity,$listprice,$supplier,$who,$notes,$bookfund,$bibitemnum,$rrp,$ecost,$gst,$budget,$cost,$sub,$invoice)=@_;
+ if ($budget eq 'now'){
+ $budget="now()";
+ } else {
+ $budget="'2001-07-01'";
+ }
+ if ($sub eq 'yes'){
+ $sub=1;
+ } else {
+ $sub=0;
+ }
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("insert into aqorders (biblionumber,title,basketno,
+ quantity,listprice,booksellerid,entrydate,requisitionedby,authorisedby,notes,
+ biblioitemnumber,rrp,ecost,gst,unitprice,subscription,booksellerinvoicenumber)
+ values (?,?,?,?,?,?,now(),?,?,?,?,?,?,?,?,?,?)");
+ $sth->execute($bibnum,$title,$basket,$quantity,$listprice,$supplier,
+ $who,$who,$notes,$bibitemnum,$rrp,$ecost,$gst,$cost,
+ $sub,$invoice);
+ $sth->finish;
+ $sth=$dbh->prepare("select * from aqorders where
+ biblionumber=? and basketno=? and ordernumber >=?");
+ $sth->execute($bibnum,$basket,$ordnum);
+ my $data=$sth->fetchrow_hashref;
+ $sth->finish;
+ $ordnum=$data->{'ordernumber'};
+ $sth=$dbh->prepare("insert into aqorderbreakdown (ordernumber,bookfundid) values
+ (?,?)");
+# print $query;
+ $sth->execute($ordnum,$bookfund);
+ $sth->finish;
+}
-sub addSubfield {
-# Add a new subfield to a tag.
- my $bibid=shift;
- my $tagid=shift;
- my $subfieldcode=shift;
- my $subfieldvalue=shift;
- my $subfieldorder=shift;
- my $firstdigit="?";
-
- my $dbh=&c4connect;
- unless ($subfieldorder) {
- my $sth=$dbh->prepare("select max(subfieldorder) from marc_$firstdigit\XX_subfield_table where tagid=$tagid");
- $sth->execute;
- if ($sth->rows) {
- ($subfieldorder) = $sth->fetchrow;
- $subfieldorder++;
- } else {
- $subfieldorder=1;
- }
- }
- my $sth=$dbh->prepare("insert into marc_$firstdigit\XX_subfield_table (tagid,bibid,subfieldorder,subfieldcode,subfieldvalue) values (?,?,?,?,?)");
- $sth->execute($tagid,$bibid,$subfieldorder,$subfieldcode,$subfieldvalue);
+=item delorder
+
+ &delorder($biblionumber, $ordernumber);
+
+Cancel the order with the given order and biblio numbers. It does not
+delete any entries in the aqorders table, it merely marks them as
+cancelled.
+
+If there are no items remaining with the given biblionumber,
+C<&delorder> also deletes them from the marc_subfield_table and
+marc_biblio tables of the Koha database.
+
+=cut
+#'
+sub delorder {
+ my ($bibnum,$ordnum)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("update aqorders set datecancellationprinted=now()
+ where biblionumber=? and ordernumber=?");
+ $sth->execute($bibnum,$ordnum);
+ $sth->finish;
+ my $count=itemcount($bibnum);
+ if ($count == 0){
+ delbiblio($bibnum);
+ }
+}
+
+=item modorder
+
+ &modorder($title, $ordernumber, $quantity, $listprice,
+ $biblionumber, $basketno, $supplier, $who, $notes,
+ $bookfundid, $bibitemnum, $rrp, $ecost, $gst, $budget,
+ $unitprice, $booksellerinvoicenumber);
+
+Modifies an existing order. Updates the order with order number
+C<$ordernumber> and biblionumber C<$biblionumber>. All other arguments
+update the fields with the same name in the aqorders table of the Koha
+database.
+
+Entries with order number C<$ordernumber> in the aqorderbreakdown
+table are also updated to the new book fund ID.
+
+=cut
+#'
+sub modorder {
+ my ($title,$ordnum,$quantity,$listprice,$bibnum,$basketno,$supplier,$who,$notes,$bookfund,$bibitemnum,$rrp,$ecost,$gst,$budget,$cost,$invoice)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("update aqorders set title=?,
+ quantity=?,listprice=?,basketno=?,
+ rrp=?,ecost=?,unitprice=?,
+ booksellerinvoicenumber=?
+ where
+ ordernumber=? and biblionumber=?");
+ $sth->execute($title,$quantity,$listprice,$basketno,$rrp,$ecost,$cost,$invoice,$ordnum,$bibnum);
+ $sth->finish;
+ $sth=$dbh->prepare("update aqorderbreakdown set bookfundid=? where
+ ordernumber=?");
+ $sth->execute($bookfund,$ordnum);
+ $sth->finish;
}
+=item newordernum
+
+ $order = &newordernum();
+
+Finds the next unused order number in the aqorders table of the Koha
+database, and returns it.
+
+=cut
+#'
+# FIXME - Race condition
+sub newordernum {
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select max(ordernumber) from aqorders");
+ $sth->execute;
+ my $data=$sth->fetchrow_arrayref;
+ my $ordnum=$$data[0];
+ $ordnum++;
+ $sth->finish;
+ return($ordnum);
+}
+
+=item receiveorder
+
+ &receiveorder($biblionumber, $ordernumber, $quantityreceived, $user,
+ $unitprice, $booksellerinvoicenumber, $biblioitemnumber,
+ $freight, $bookfund, $rrp);
+
+Updates an order, to reflect the fact that it was received, at least
+in part. All arguments not mentioned below update the fields with the
+same name in the aqorders table of the Koha database.
+
+Updates the order with bibilionumber C<$biblionumber> and ordernumber
+C<$ordernumber>.
+
+Also updates the book fund ID in the aqorderbreakdown table.
+
+=cut
+#'
+sub receiveorder {
+ my ($biblio,$ordnum,$quantrec,$user,$cost,$invoiceno,$bibitemno,$freight,$bookfund,$rrp)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("update aqorders set quantityreceived=?,datereceived=now(),booksellerinvoicenumber=?,
+ biblioitemnumber=?,unitprice=?,freight=?,rrp=?
+ where biblionumber=? and ordernumber=?");
+ $sth->execute($quantrec,$invoiceno,$bibitemno,$cost,$freight,$rrp,$biblio,$ordnum);
+ $sth->finish;
+ $sth=$dbh->prepare("update aqorderbreakdown set bookfundid=? where
+ ordernumber=?");
+ $sth->execute($bookfund,$ordnum);
+ $sth->finish;
+}
+
+=item updaterecorder
+
+ &updaterecorder($biblionumber, $ordernumber, $user, $unitprice,
+ $bookfundid, $rrp);
+
+Updates the order with biblionumber C<$biblionumber> and order number
+C<$ordernumber>. C<$bookfundid> is the new value for the book fund ID
+in the aqorderbreakdown table of the Koha database. All other
+arguments update the fields with the same name in the aqorders table.
+
+C<$user> is ignored.
+
+=cut
+#'
+sub updaterecorder{
+ my($biblio,$ordnum,$user,$cost,$bookfund,$rrp)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("update aqorders set
+ unitprice=?, rrp=?
+ where biblionumber=? and ordernumber=?
+ ");
+ $sth->execute($cost,$rrp,$biblio,$ordnum);
+ $sth->finish;
+ $sth=$dbh->prepare("update aqorderbreakdown set bookfundid=? where ordernumber=?");
+ $sth->execute($bookfund,$ordnum);
+ $sth->finish;
+}
-sub updateBiblio {
-# Update the biblio with biblionumber $biblio->{'biblionumber'}
-# I guess this routine should search through all marc records for a record that
-# has the same biblionumber stored in it, and modify the MARC record as well as
-# the biblio table.
#
-# Also, this subroutine should search through the $biblio object and compare it
-# to the existing record and _LOG ALL CHANGES MADE_ in some way. I'd like for
-# this logging feature to be usable to undo changes easily.
-
- my ($env, $biblio) = @_;
- my $Record_ID;
- my $biblionumber=$biblio->{'biblionumber'};
- my $dbh=&C4Connect;
- my $sth=$dbh->prepare("select * from biblio where biblionumber=$biblionumber");
- $sth->execute;
- my $origbiblio=$sth->fetchrow_hashref;
- $sth=$dbh->prepare("select subtitle from bibliosubtitle where biblionumber=$biblionumber");
- $sth->execute;
- my ($subtitle)=$sth->fetchrow;
- $origbiblio->{'subtitle'}=$subtitle;
- $sth=$dbh->prepare("select author from additionalauthors where biblionumber=$biblionumber");
- $sth->execute;
- my $origadditionalauthors;
- while (my ($author) = $sth->fetchrow) {
- push (@{$origbiblio->{'additionalauthors'}}, $author);
- $origadditionalauthors->{$author}=1;
- }
- $sth=$dbh->prepare("select subject from bibliosubject where biblionumber=$biblionumber");
- $sth->execute;
- my $origsubjects;
- while (my ($subject) = $sth->fetchrow) {
- push (@{$origbiblio->{'subjects'}}, $subject);
- $origsubjects->{$subject}=1;
- }
+#
+# ORDERS
+#
+#
-
-# Obtain a list of MARC Record_ID's that are tied to this biblio
- $sth=$dbh->prepare("select T.bibid from marc_0XX_tag_table T, marc_0XX_subfield_table S where T.tagid=S.tagid and T.tagnumber='090' and S.subfieldvalue=$biblionumber and S.subfieldcode='c'");
- $sth->execute;
- my @marcrecords;
- while (my ($bibid) = $sth->fetchrow) {
- push(@marcrecords, $bibid);
- }
+=item getorders
+ ($count, $orders) = &getorders($booksellerid);
+Finds pending orders from the bookseller with the given ID. Ignores
+completed and cancelled orders.
- my $bibid='';
- if ($biblio->{'author'} ne $origbiblio->{'author'}) {
- my $q_author=$dbh->quote($biblio->{'author'});
- logchange('kohadb', 'change', 'biblio', 'author', $origbiblio->{'author'}, $biblio->{'author'});
- my $sti=$dbh->prepare("update biblio set author=$q_author where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- foreach $bibid (@marcrecords) {
- logchange('marc', 'change', $bibid, '100', 'a', $origbiblio->{'author'}, $biblio->{'author'});
- changeSubfield($bibid, '100', 'a', $origbiblio->{'author'}, $biblio->{'author'});
- }
- }
- if ($biblio->{'title'} ne $origbiblio->{'title'}) {
- my $q_title=$dbh->quote($biblio->{'title'});
- logchange('kohadb', 'change', 'biblio', 'title', $origbiblio->{'title'}, $biblio->{'title'});
- my $sti=$dbh->prepare("update biblio set title=$q_title where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- foreach $Record_ID (@marcrecords) {
- logchange('marc', 'change', $Record_ID, '245', 'a', $origbiblio->{'title'}, $biblio->{'title'});
- changeSubfield($Record_ID, '245', 'a', $origbiblio->{'title'}, $biblio->{'title'});
- }
- }
- if ($biblio->{'subtitle'} ne $origbiblio->{'subtitle'}) {
- my $q_subtitle=$dbh->quote($biblio->{'subtitle'});
- logchange('kohadb', 'change', 'biblio', 'subtitle', $origbiblio->{'subtitle'}, $biblio->{'subtitle'});
- my $sti=$dbh->prepare("update bibliosubtitle set subtitle=$q_subtitle where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- foreach $Record_ID (@marcrecords) {
- logchange('marc', 'change', $Record_ID, '245', 'b', $origbiblio->{'subtitle'}, $biblio->{'subtitle'});
- changeSubfield($Record_ID, '245', 'b', $origbiblio->{'subtitle'}, $biblio->{'subtitle'});
- }
- }
- if ($biblio->{'unititle'} ne $origbiblio->{'unititle'}) {
- my $q_unititle=$dbh->quote($biblio->{'unititle'});
- logchange('kohadb', 'change', 'biblio', 'unititle', $origbiblio->{'unititle'}, $biblio->{'unititle'});
- my $sti=$dbh->prepare("update biblio set unititle=$q_unititle where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- }
- if ($biblio->{'notes'} ne $origbiblio->{'notes'}) {
- my $q_notes=$dbh->quote($biblio->{'notes'});
- logchange('kohadb', 'change', 'biblio', 'notes', $origbiblio->{'notes'}, $biblio->{'notes'});
- my $sti=$dbh->prepare("update biblio set notes=$q_notes where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- foreach $Record_ID (@marcrecords) {
- logchange('marc', 'change', $Record_ID, '500', 'a', $origbiblio->{'notes'}, $biblio->{'notes'});
- changeSubfield($Record_ID, '500', 'a', $origbiblio->{'notes'}, $biblio->{'notes'});
- }
- }
- if ($biblio->{'serial'} ne $origbiblio->{'serial'}) {
- my $q_serial=$dbh->quote($biblio->{'serial'});
- logchange('kohadb', 'change', 'biblio', 'serial', $origbiblio->{'serial'}, $biblio->{'serial'});
- my $sti=$dbh->prepare("update biblio set serial=$q_serial where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- }
- if ($biblio->{'seriestitle'} ne $origbiblio->{'seriestitle'}) {
- my $q_seriestitle=$dbh->quote($biblio->{'seriestitle'});
- logchange('kohadb', 'change', 'biblio', 'seriestitle', $origbiblio->{'seriestitle'}, $biblio->{'seriestitle'});
- my $sti=$dbh->prepare("update biblio set seriestitle=$q_seriestitle where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- foreach $Record_ID (@marcrecords) {
- logchange('marc', 'change', $Record_ID, '440', 'a', $origbiblio->{'seriestitle'}, $biblio->{'seriestitle'});
- changeSubfield($Record_ID, '440', 'a', $origbiblio->{'seriestitle'}, $biblio->{'seriestitle'});
- }
- }
- if ($biblio->{'copyrightdate'} ne $origbiblio->{'copyrightdate'}) {
- my $q_copyrightdate=$dbh->quote($biblio->{'copyrightdate'});
- logchange('kohadb', 'change', 'biblio', 'copyrightdate', $origbiblio->{'copyrightdate'}, $biblio->{'copyrightdate'});
- my $sti=$dbh->prepare("update biblio set copyrightdate=$q_copyrightdate where biblionumber=$biblio->{'biblionumber'}");
- $sti->execute;
- foreach $Record_ID (@marcrecords) {
- logchange('marc', 'change', $Record_ID, '260', 'c', "c$origbiblio->{'notes'}", "c$biblio->{'notes'}");
- changeSubfield($Record_ID, '260', 'c', "c$origbiblio->{'notes'}", "c$biblio->{'notes'}");
- }
- }
+C<$count> is the number of elements in C<@{$orders}>.
-# Check for subject heading changes
-
- my $newsubject='';
- my $subjects;
- foreach $newsubject (@{$biblio->{'subject'}}) {
- $subjects->{$newsubject}=1;
- if ($origsubjects->{$newsubject}) {
- $subjects->{$newsubject}=2;
- } else {
- my $q_newsubject=$dbh->quote($newsubject);
- my $sth=$dbh->prepare("insert into bibliosubject (subject,biblionumber) values ($q_newsubject, $biblionumber)");
- $sth->execute;
- logchange('kohadb', 'add', 'biblio', 'subject', $newsubject);
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$newsubject;
- my $tag='650';
- my $Record_ID;
- foreach $Record_ID (@marcrecords) {
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- logchange('marc', 'add', $Record_ID, '650', 'a', $newsubject);
- }
- }
- }
- my $origsubject;
- foreach $origsubject (keys %$origsubjects) {
- if ($subjects->{$origsubject} == 1) {
- my $q_origsubject=$dbh->quote($origsubject);
- logchange('kohadb', 'delete', 'biblio', '$biblionumber', 'subject', $origsubject);
- my $sth=$dbh->prepare("delete from bibliosubject where biblionumber=$biblionumber and subject=$q_origsubject");
- $sth->execute;
- }
- }
+C<$orders> is a reference-to-array; each element is a
+reference-to-hash with the following fields:
-sub skip {
-# At the moment this is just a straight copy of the subject code. Needs heavy
-# modification to work for additional authors, obviously.
-# Check for additional author changes
-
- my $newadditionalauthor='';
- my $additionalauthors;
- foreach $newadditionalauthor (@{$biblio->{'additionalauthor'}}) {
- $additionalauthors->{$newadditionalauthor}=1;
- if ($origadditionalauthors->{$newadditionalauthor}) {
- $additionalauthors->{$newadditionalauthor}=2;
- } else {
- my $q_newadditionalauthor=$dbh->quote($newadditionalauthor);
- my $sth=$dbh->prepare("insert into biblioadditionalauthors (additionalauthor,biblionumber) values ($q_newadditionalauthor, $biblionumber)");
- $sth->execute;
- logchange('kohadb', 'add', 'biblio', 'additionalauthor', $newadditionalauthor);
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$newadditionalauthor;
- my $tag='650';
- my $Record_ID;
- foreach $Record_ID (@marcrecords) {
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- logchange('marc', 'add', $Record_ID, '650', 'a', $newadditionalauthor);
- }
- }
- }
- my $origadditionalauthor;
- foreach $origadditionalauthor (keys %$origadditionalauthors) {
- if ($additionalauthors->{$origadditionalauthor} == 1) {
- my $q_origadditionalauthor=$dbh->quote($origadditionalauthor);
- logchange('kohadb', 'delete', 'biblio', '$biblionumber', 'additionalauthor', $origadditionalauthor);
- my $sth=$dbh->prepare("delete from biblioadditionalauthors where biblionumber=$biblionumber and additionalauthor=$q_origadditionalauthor");
- $sth->execute;
- }
- }
+=over 4
+
+=item C<count(*)>
+
+Gives the number of orders in with this basket number.
+
+=item C<authorizedby>
+
+=item C<entrydate>
+
+=item C<basketno>
+
+These give the value of the corresponding field in the aqorders table
+of the Koha database.
+
+=back
+
+Results are ordered from most to least recent.
+=cut
+#'
+sub getorders {
+ my ($supplierid)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select count(*),authorisedby,entrydate,basketno from aqorders where
+ booksellerid=? and (quantity > quantityreceived or
+ quantityreceived is NULL)
+ and (datecancellationprinted is NULL or datecancellationprinted = '0000-00-00')
+ group by basketno order by entrydate desc");
+ $sth->execute($supplierid);
+ my @results = ();
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return (scalar(@results),\@results);
}
- $dbh->disconnect;
+
+=item getorder
+
+ ($order, $ordernumber) = &getorder($biblioitemnumber, $biblionumber);
+
+Looks up the order with the given biblionumber and biblioitemnumber.
+
+Returns a two-element array. C<$ordernumber> is the order number.
+C<$order> is a reference-to-hash describing the order; its keys are
+fields from the biblio, biblioitems, aqorders, and aqorderbreakdown
+tables of the Koha database.
+
+=cut
+#'
+# FIXME - This is effectively identical to &C4::Biblio::getorder.
+# Pick one and stick with it.
+sub getorder{
+ my ($bi,$bib)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select ordernumber from aqorders where biblionumber=? and biblioitemnumber=?");
+ $sth->execute($bib,$bi);
+ # FIXME - Use fetchrow_array(), since we're only interested in the one
+ # value.
+ my $ordnum=$sth->fetchrow_hashref;
+ $sth->finish;
+ my $order=getsingleorder($ordnum->{'ordernumber'});
+ return ($order,$ordnum->{'ordernumber'});
}
-sub logchange {
-# Subroutine to log changes to databases
- my $database=shift;
- if ($database eq 'kohadb') {
- my $type=shift;
- my $section=shift;
- my $item=shift;
- my $original=shift;
- my $new=shift;
- print STDERR "KOHA: $type $section $item $original $new\n";
- } elsif ($database eq 'marc') {
- my $type=shift;
- my $Record_ID=shift;
- my $tag=shift;
- my $mark=shift;
- my $subfield_ID=shift;
- my $original=shift;
- my $new=shift;
- print STDERR "MARC: $type $Record_ID $tag $mark $subfield_ID $original $new\n";
- }
+=item getsingleorder
+
+ $order = &getsingleorder($ordernumber);
+
+Looks up an order by order number.
+
+Returns a reference-to-hash describing the order. The keys of
+C<$order> are fields from the biblio, biblioitems, aqorders, and
+aqorderbreakdown tables of the Koha database.
+
+=cut
+#'
+# FIXME - This is effectively identical to
+# &C4::Biblio::getsingleorder.
+# Pick one and stick with it.
+sub getsingleorder {
+ my ($ordnum)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from biblio,biblioitems,aqorders,aqorderbreakdown
+ where aqorders.ordernumber=?
+ and biblio.biblionumber=aqorders.biblionumber and
+ biblioitems.biblioitemnumber=aqorders.biblioitemnumber and
+ aqorders.ordernumber=aqorderbreakdown.ordernumber");
+ $sth->execute($ordnum);
+ my $data=$sth->fetchrow_hashref;
+ $sth->finish;
+ return($data);
+}
+
+=item getallorders
+
+ ($count, @results) = &getallorders($booksellerid);
+
+Looks up all of the pending orders from the supplier with the given
+bookseller ID. Ignores cancelled and completed orders.
+
+C<$count> is the number of elements in C<@results>. C<@results> is an
+array of references-to-hash. The keys of each element are fields from
+the aqorders, biblio, and biblioitems tables of the Koha database.
+
+C<@results> is sorted alphabetically by book title.
+
+=cut
+#'
+sub getallorders {
+ #gets all orders from a certain supplier, orders them alphabetically
+ my ($supid)=@_;
+ my $dbh = C4::Context->dbh;
+ my @results = ();
+ my $sth=$dbh->prepare("Select * from aqorders,biblio,biblioitems where booksellerid=?
+ and (cancelledby is NULL or cancelledby = '')
+ and (quantityreceived < quantity or quantityreceived is NULL)
+ and biblio.biblionumber=aqorders.biblionumber and biblioitems.biblioitemnumber=
+ aqorders.biblioitemnumber
+ group by aqorders.biblioitemnumber
+ order by
+ biblio.title");
+ $sth->execute($supid);
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),@results);
+}
+
+# FIXME - Never used
+sub getrecorders {
+ #gets all orders from a certain supplier, orders them alphabetically
+ my ($supid)=@_;
+ my $dbh = C4::Context->dbh;
+ my @results= ();
+ my $sth=$dbh->prepare("Select * from aqorders,biblio,biblioitems where booksellerid=?
+ and (cancelledby is NULL or cancelledby = '')
+ and biblio.biblionumber=aqorders.biblionumber and biblioitems.biblioitemnumber=
+ aqorders.biblioitemnumber and
+ aqorders.quantityreceived>0
+ and aqorders.datereceived >=now()
+ group by aqorders.biblioitemnumber
+ order by
+ biblio.title");
+ $sth->execute($supid);
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),@results);
}
-sub addTag {
-# Subroutine to add a tag to an existing MARC Record. If a new linkage id is
-# desired, set $env->{'linkage'} to 1. If an existing linkage id should be
-# set, set $env->{'linkid'} to the link number.
- my ($env, $Record_ID, $tag, $Indicator1, $Indicator2, $subfields) = @_;
- my $dbh=&C4Connect;
- ($Indicator1) || ($Indicator1=' ');
- ($Indicator2) || ($Indicator2=' ');
- my $firstdigit=substr($tag,0,1);
- my $Subfield_ID;
- foreach (sort keys %$subfields) {
- my $Subfield_Mark=$subfields->{$_}->{'Subfield_Mark'};
- my $Subfield_Value=$subfields->{$_}->{'Subfield_Value'};
- my $q_Subfield_Value=$dbh->quote($Subfield_Value);
- if ($Subfield_ID) {
- my $sth=$dbh->prepare("insert into $firstdigit\XX_Subfield_Table (Subfield_ID, Subfield_Mark, Subfield_Value) values ($Subfield_ID, '$Subfield_Mark', $q_Subfield_Value)");
- $sth->execute;
- } else {
- my $sth=$dbh->prepare("insert into $firstdigit\XX_Subfield_Table (Subfield_Mark, Subfield_Value) values ('$Subfield_Mark', $q_Subfield_Value)");
- $sth->execute;
- my $Subfield_Key=$dbh->{'mysql_insertid'};
- $Subfield_ID=$Subfield_Key;
- $sth=$dbh->prepare("update $firstdigit\XX_Subfield_Table set Subfield_ID=$Subfield_ID where Subfield_Key=$Subfield_Key");
- $sth->execute;
+=item ordersearch
+
+ ($count, @results) = &ordersearch($search, $biblionumber, $complete);
+
+Searches for orders.
+
+C<$search> may take one of several forms: if it is an ISBN,
+C<&ordersearch> returns orders with that ISBN. If C<$search> is an
+order number, C<&ordersearch> returns orders with that order number
+and biblionumber C<$biblionumber>. Otherwise, C<$search> is considered
+to be a space-separated list of search terms; in this case, all of the
+terms must appear in the title (matching the beginning of title
+words).
+
+If C<$complete> is C<yes>, the results will include only completed
+orders. In any case, C<&ordersearch> ignores cancelled orders.
+
+C<&ordersearch> returns an array. C<$count> is the number of elements
+in C<@results>. C<@results> is an array of references-to-hash with the
+following keys:
+
+=over 4
+
+=item C<author>
+
+=item C<seriestitle>
+
+=item C<branchcode>
+
+=item C<bookfundid>
+
+=back
+
+=cut
+#'
+sub ordersearch {
+ my ($search,$id,$biblio,$catview) = @_;
+ my $dbh = C4::Context->dbh;
+ my @data = split(' ',$search);
+ my @searchterms = ($id);
+ map { push(@searchterms,"$_%","% $_%") } @data;
+ push(@searchterms,$search,$search,$biblio);
+ my $sth=$dbh->prepare("Select *,biblio.title from aqorders,biblioitems,biblio
+ where aqorders.biblioitemnumber = biblioitems.biblioitemnumber
+ and aqorders.booksellerid = ?
+ and biblio.biblionumber=aqorders.biblionumber
+ and ((datecancellationprinted is NULL)
+ or (datecancellationprinted = '0000-00-00'))
+ and (("
+ .(join(" and ",map { "(biblio.title like ? or biblio.title like ?)" } @data))
+ .") or biblioitems.isbn=? or (aqorders.ordernumber=? and aqorders.biblionumber=?)) "
+ .(($catview ne 'yes')?" and (quantityreceived < quantity or quantityreceived is NULL)":"")
+ ." group by aqorders.ordernumber");
+ $sth->execute(@searchterms);
+ my @results = ();
+ my $sth2=$dbh->prepare("Select * from biblio where biblionumber=?");
+ my $sth3=$dbh->prepare("Select * from aqorderbreakdown where ordernumber=?");
+ while (my $data=$sth->fetchrow_hashref){
+ $sth2->execute($data->{'biblionumber'});
+ my $data2=$sth2->fetchrow_hashref;
+ $data->{'author'}=$data2->{'author'};
+ $data->{'seriestitle'}=$data2->{'seriestitle'};
+ $sth3->execute($data->{'ordernumber'});
+ my $data3=$sth3->fetchrow_hashref;
+ $data->{'branchcode'}=$data3->{'branchcode'};
+ $data->{'bookfundid'}=$data3->{'bookfundid'};
+ push(@results,$data);
}
- }
- if (my $linkid=$env->{'linkid'}) {
- $env->{'linkage'}=0;
- my $sth=$dbh->prepare("insert into $firstdigit\XX_Subfield_Table (Subfield_ID, Subfield_Mark, Subfield_Value) values ($Subfield_ID, '8', '$linkid')");
- $sth->execute;
- }
- my $sth=$dbh->prepare("insert into $firstdigit\XX_Tag_Table (Indicator1, Indicator2, Tag, Subfield_ID) values ('$Indicator1', '$Indicator2', '$tag', $Subfield_ID)");
- $sth->execute;
- my $Tag_Key=$dbh->{'mysql_insertid'};
- my $Tag_ID=$Tag_Key;
- $sth=$dbh->prepare("update $firstdigit\XX_Tag_Table set Tag_ID=$Tag_ID where Tag_Key=$Tag_Key");
- $sth->execute;
- $sth=$dbh->prepare("insert into Bib_Table (Record_ID, Tag_$firstdigit\XX_ID) values ($Record_ID, $Tag_ID)");
- $sth->execute;
- if ($env->{'linkage'}) {
- my $sth=$dbh->prepare("insert into $firstdigit\XX_Subfield_Table (Subfield_ID, Subfield_Mark, Subfield_Value) values ($Subfield_ID, '8', '$Tag_ID')");
- $sth->execute;
-
- }
- $sth->finish;
- $dbh->disconnect;
- return ($env, $Tag_ID);
+ $sth->finish;
+ $sth2->finish;
+ $sth3->finish;
+ return(scalar(@results),@results);
}
-sub newBiblioItem {
- my ($env, $biblioitem) = @_;
- my $dbh=&C4Connect;
- my $biblionumber=$biblioitem->{'biblionumber'};
- my $biblioitemnumber=$biblioitem->{'biblioitemnumber'};
- my $volume=$biblioitem->{'volume'};
- my $q_volume=$dbh->quote($volume);
- my $number=$biblioitem->{'number'};
- my $q_number=$dbh->quote($number);
- my $classification=$biblioitem->{'classification'};
- my $q_classification=$dbh->quote($classification);
- my $itemtype=$biblioitem->{'itemtype'};
- my $q_itemtype=$dbh->quote($itemtype);
- my $isbn=$biblioitem->{'isbn'};
- my $q_isbn=$dbh->quote($isbn);
- my $issn=$biblioitem->{'issn'};
- my $q_issn=$dbh->quote($issn);
- my $dewey=$biblioitem->{'dewey'};
- $dewey=~s/\.*0*$//;
- ($dewey == 0) && ($dewey='');
- my $subclass=$biblioitem->{'subclass'};
- my $q_subclass=$dbh->quote($subclass);
- my $publicationyear=$biblioitem->{'publicationyear'};
- my $publishercode=$biblioitem->{'publishercode'};
- my $q_publishercode=$dbh->quote($publishercode);
- my $volumedate=$biblioitem->{'volumedate'};
- my $q_volumedate=$dbh->quote($volumedate);
- my $illus=$biblioitem->{'illus'};
- my $q_illus=$dbh->quote($illus);
- my $pages=$biblioitem->{'pages'};
- my $q_pages=$dbh->quote($pages);
- my $notes=$biblioitem->{'notes'};
- my $q_notes=$dbh->quote($notes);
- my $size=$biblioitem->{'size'};
- my $q_size=$dbh->quote($size);
- my $place=$biblioitem->{'place'};
- my $q_place=$dbh->quote($place);
- my $lccn=$biblioitem->{'lccn'};
- my $q_lccn=$dbh->quote($lccn);
-
-
-# Unless the $env->{'marconly'} flag is set, update the biblioitems table with
-# the new data
-
- unless ($env->{'marconly'}) {
- #my $sth=$dbh->prepare("lock tables biblioitems write");
- #$sth->execute;
- my $sth=$dbh->prepare("select max(biblioitemnumber) from biblioitems");
- $sth->execute;
- my ($biblioitemnumber) =$sth->fetchrow;
- $biblioitemnumber++;
- $sth=$dbh->prepare("insert into biblioitems (biblionumber,biblioitemnumber,volume,number,classification,itemtype,isbn,issn,dewey,subclass,publicationyear,publishercode,volumedate,illus,pages,notes,size,place,lccn) values ($biblionumber, $biblioitemnumber, $q_volume, $q_number, $q_classification, $q_itemtype, $q_isbn, $q_issn, $dewey, $q_subclass, $publicationyear, $q_publishercode, $q_volumedate, $q_illus, $q_pages,$q_notes, $q_size, $q_place, $q_lccn)");
- $sth->execute;
- #my $sth=$dbh->prepare("unlock tables");
- #$sth->execute;
- }
+#
+#
+# MONEY
+#
+#
+=item invoice
+
+ ($count, @results) = &invoice($booksellerinvoicenumber);
+
+Looks up orders by invoice number.
+
+Returns an array. C<$count> is the number of elements in C<@results>.
+C<@results> is an array of references-to-hash; the keys of each
+elements are fields from the aqorders, biblio, and biblioitems tables
+of the Koha database.
+
+=cut
+#'
+sub invoice {
+ my ($invoice)=@_;
+ my $dbh = C4::Context->dbh;
+ my @results = ();
+ my $sth=$dbh->prepare("Select * from aqorders,biblio,biblioitems where
+ booksellerinvoicenumber=?
+ and biblio.biblionumber=aqorders.biblionumber and biblioitems.biblioitemnumber=
+ aqorders.biblioitemnumber group by aqorders.ordernumber,aqorders.biblioitemnumber");
+ $sth->execute($invoice);
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),@results);
+}
+=item bookfunds
+
+ ($count, @results) = &bookfunds();
+
+Returns a list of all book funds.
+
+C<$count> is the number of elements in C<@results>. C<@results> is an
+array of references-to-hash, whose keys are fields from the aqbookfund
+and aqbudget tables of the Koha database. Results are ordered
+alphabetically by book fund name.
+
+=cut
+#'
+sub bookfunds {
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from aqbookfund,aqbudget where aqbookfund.bookfundid
+ =aqbudget.bookfundid
+ group by aqbookfund.bookfundid order by bookfundname");
+ $sth->execute;
+ my @results = ();
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),@results);
+}
-# Should we check if there is already a biblioitem/marc with the
-# same isbn/lccn/issn?
-
- my $sth=$dbh->prepare("select title,unititle,seriestitle,copyrightdate,notes,author from biblio where biblionumber=$biblionumber");
- $sth->execute;
- my ($title, $unititle,$seriestitle,$copyrightdate,$biblionotes,$author) = $sth->fetchrow;
- $sth=$dbh->prepare("select subtitle from bibliosubtitle where biblionumber=$biblionumber");
- $sth->execute;
- my ($subtitle) = $sth->fetchrow;
- $sth=$dbh->prepare("select author from additionalauthors where biblionumber=$biblionumber");
- $sth->execute;
- my @additionalauthors;
- while (my ($additionalauthor) = $sth->fetchrow) {
- push (@additionalauthors, $additionalauthor);
- }
- $sth=$dbh->prepare("select subject from bibliosubject where biblionumber=$biblionumber");
- $sth->execute;
- my @subjects;
- while (my ($subject) = $sth->fetchrow) {
- push (@subjects, $subject);
- }
+# FIXME - POD. I can't figure out what this function is doing. Then
+# again, I don't think it's being used (anymore).
+sub bookfundbreakdown {
+ my ($id)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select quantity,datereceived,freight,unitprice,listprice,ecost,quantityreceived,subscription
+ from aqorders,aqorderbreakdown where bookfundid=? and
+ aqorders.ordernumber=aqorderbreakdown.ordernumber
+ and (datecancellationprinted is NULL or
+ datecancellationprinted='0000-00-00')");
+ $sth->execute($id);
+ my $comtd=0;
+ my $spent=0;
+ while (my $data=$sth->fetchrow_hashref){
+ if ($data->{'subscription'} == 1){
+ $spent+=$data->{'quantity'}*$data->{'unitprice'};
+ } else {
+ my $leftover=$data->{'quantity'}-$data->{'quantityreceived'};
+ $comtd+=($data->{'ecost'})*$leftover;
+ $spent+=($data->{'unitprice'})*$data->{'quantityreceived'};
+ }
+ }
+ $sth->finish;
+ return($spent,$comtd);
+}
-# MARC SECTION
-
- $sth=$dbh->prepare("insert into Resource_Table (Record_ID) values (0)");
- $sth->execute;
- my $Resource_ID=$dbh->{'mysql_insertid'};
- my $Record_ID=$Resource_ID;
- $sth=$dbh->prepare("update Resource_Table set Record_ID=$Record_ID where Resource_ID=$Resource_ID");
- $sth->execute;
-
-# Title
- {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$title;
- if ($subtitle) {
- $subfields->{2}->{'Subfield_Mark'}='b';
- $subfields->{2}->{'Subfield_Value'}=$subtitle;
- }
- my $tag='245';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
+=item curconvert
+
+ $foreignprice = &curconvert($currency, $localprice);
+
+Converts the price C<$localprice> to foreign currency C<$currency> by
+dividing by the exchange rate, and returns the result.
+
+If no exchange rate is found, C<&curconvert> assumes the rate is one
+to one.
+
+=cut
+#'
+sub curconvert {
+ my ($currency,$price)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select rate from currency where currency=?");
+ $sth->execute($currency);
+ my $cur=($sth->fetchrow_array())[0];
+ $sth->finish;
+ if ($cur==0){
+ $cur=1;
+ }
+ return($price / $cur);
+}
-# author
- {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$author;
- my $tag='100';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Series Title
- if ($seriestitle) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$seriestitle;
- my $tag='440';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Biblio Note
- if ($biblionotes) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$biblionotes;
- $subfields->{2}->{'Subfield_Mark'}='3';
- $subfields->{2}->{'Subfield_Value'}='biblio';
- my $tag='500';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Additional Authors
- foreach (@additionalauthors) {
- my $author=$_;
- (next) unless ($author);
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$author;
- $subfields->{2}->{'Subfield_Mark'}='e';
- $subfields->{2}->{'Subfield_Value'}='author';
- my $tag='700';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Illustrator
- if ($illus) {
- (next) unless ($illus);
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$illus;
- $subfields->{2}->{'Subfield_Mark'}='e';
- $subfields->{2}->{'Subfield_Value'}='illustrator';
- my $tag='700';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Subjects
- foreach (@subjects) {
- my $subject=$_;
- (next) unless ($subject);
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$subject;
- my $tag='650';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
+=item getcurrencies
+ ($count, $currencies) = &getcurrencies();
-# ISBN
- if ($isbn) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$isbn;
- my $tag='020';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# LCCN
- if ($lccn) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$lccn;
- my $tag='010';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# ISSN
- if ($issn) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$issn;
- my $tag='022';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# DEWEY
- if ($dewey) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$dewey;
- my $tag='082';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# DEWEY subclass and itemtype
- {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$itemtype;
- $subfields->{2}->{'Subfield_Mark'}='b';
- $subfields->{2}->{'Subfield_Value'}=$subclass;
- $subfields->{3}->{'Subfield_Mark'}='c';
- $subfields->{3}->{'Subfield_Value'}=$biblionumber;
- $subfields->{4}->{'Subfield_Mark'}='d';
- $subfields->{4}->{'Subfield_Value'}=$biblioitemnumber;
- my $tag='090';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# PUBLISHER
- {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$place;
- $subfields->{2}->{'Subfield_Mark'}='b';
- $subfields->{2}->{'Subfield_Value'}=$publishercode;
- $subfields->{3}->{'Subfield_Mark'}='c';
- $subfields->{3}->{'Subfield_Value'}=$publicationyear;
- if ($copyrightdate) {
- $subfields->{4}->{'Subfield_Mark'}='c';
- $subfields->{4}->{'Subfield_Value'}="c$copyrightdate";
- }
- my $tag='260';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# PHYSICAL
- if ($pages || $size) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$pages;
- $subfields->{2}->{'Subfield_Mark'}='c';
- $subfields->{2}->{'Subfield_Value'}=$size;
- my $tag='300';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Volume/Number
- if ($volume || $number) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='v';
- $subfields->{1}->{'Subfield_Value'}=$volume;
- $subfields->{2}->{'Subfield_Mark'}='n';
- $subfields->{2}->{'Subfield_Value'}=$number;
- my $tag='440';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
-# Biblioitem Note
- if ($notes) {
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='a';
- $subfields->{1}->{'Subfield_Value'}=$notes;
- $subfields->{2}->{'Subfield_Mark'}='3';
- $subfields->{2}->{'Subfield_Value'}='biblioitem';
- my $tag='500';
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- }
- $sth->finish;
- $dbh->disconnect;
- return ($env, $Record_ID);
-}
+Returns the list of all known currencies.
-sub updateBiblioItem {
-# Update the biblioitem with biblioitemnumber $biblioitem->{'biblioitemnumber'}
-#
-# This routine should also check to see which fields are actually being
-# modified, and log all changes.
-
- my ($env, $biblioitem) = @_;
- my $dbh=&C4Connect;
-
- my $biblioitemnumber=$biblioitem->{'biblioitemnumber'};
- my $sth=$dbh->prepare("select * from biblioitems where biblioitemnumber=$biblioitemnumber");
-# obi = original biblioitem
- my $obi=$sth->fetchrow_hashref;
- $sth=$dbh->prepare("select B.Record_ID from Bib_Table B, 0XX_Tag_Table T, 0XX_Subfield_Table S where B.Tag_0XX_ID=T.Tag_ID and T.Subfield_ID=S.Subfield_ID and T.Tag='090' and S.Subfield_Mark='c' and S.Subfield_Value=$biblioitemnumber");
- $sth->execute;
- my ($Record_ID) = $sth->fetchrow;
- if ($biblioitem->{'biblionumber'} ne $obi->{'biblionumber'}) {
- logchange('kohadb', 'change', 'biblioitems', 'biblionumber', $obi->{'biblionumber'}, $biblioitem->{'biblionumber'});
- my $sth=$dbh->prepare("update biblioitems set biblionumber=$biblioitem->{'biblionumber'} where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '090', 'c', $obi->{'biblionumber'}, $biblioitem->{'biblionumber'});
- changeSubfield($Record_ID, '090', 'c', $obi->{'biblionumber'}, $biblioitem->{'biblionumber'});
- }
- if ($biblioitem->{'volume'} ne $obi->{'volume'}) {
- logchange('kohadb', 'change', 'biblioitems', 'volume', $obi->{'volume'}, $biblioitem->{'volume'});
- my $q_volume=$dbh->quote($biblioitem->{'volume'});
- my $sth=$dbh->prepare("update biblioitems set volume=$q_volume where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '440', 'v', $obi->{'volume'}, $biblioitem->{'volume'});
- changeSubfield($Record_ID, '440', 'v', $obi->{'volume'}, $biblioitem->{'volume'});
- }
- if ($biblioitem->{'number'} ne $obi->{'number'}) {
- logchange('kohadb', 'change', 'biblioitems', 'number', $obi->{'number'}, $biblioitem->{'number'});
- my $q_number=$dbh->quote($biblioitem->{'number'});
- my $sth=$dbh->prepare("update biblioitems set number=$q_number where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '440', 'v', $obi->{'number'}, $biblioitem->{'number'});
- changeSubfield($Record_ID, '440', 'v', $obi->{'number'}, $biblioitem->{'number'});
- }
- if ($biblioitem->{'itemtype'} ne $obi->{'itemtype'}) {
- logchange('kohadb', 'change', 'biblioitems', 'itemtype', $obi->{'itemtype'}, $biblioitem->{'itemtype'});
- my $q_itemtype=$dbh->quote($biblioitem->{'itemtype'});
- my $sth=$dbh->prepare("update biblioitems set itemtype=$q_itemtype where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '090', 'a', $obi->{'itemtype'}, $biblioitem->{'itemtype'});
- changeSubfield($Record_ID, '090', 'a', $obi->{'itemtype'}, $biblioitem->{'itemtype'});
- }
- if ($biblioitem->{'isbn'} ne $obi->{'isbn'}) {
- logchange('kohadb', 'change', 'biblioitems', 'isbn', $obi->{'isbn'}, $biblioitem->{'isbn'});
- my $q_isbn=$dbh->quote($biblioitem->{'isbn'});
- my $sth=$dbh->prepare("update biblioitems set isbn=$q_isbn where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '020', 'a', $obi->{'isbn'}, $biblioitem->{'isbn'});
- changeSubfield($Record_ID, '020', 'a', $obi->{'isbn'}, $biblioitem->{'isbn'});
- }
- if ($biblioitem->{'issn'} ne $obi->{'issn'}) {
- logchange('kohadb', 'change', 'biblioitems', 'issn', $obi->{'issn'}, $biblioitem->{'issn'});
- my $q_issn=$dbh->quote($biblioitem->{'issn'});
- my $sth=$dbh->prepare("update biblioitems set issn=$q_issn where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '022', 'a', $obi->{'issn'}, $biblioitem->{'issn'});
- changeSubfield($Record_ID, '022', 'a', $obi->{'issn'}, $biblioitem->{'issn'});
- }
- if ($biblioitem->{'dewey'} ne $obi->{'dewey'}) {
- logchange('kohadb', 'change', 'biblioitems', 'dewey', $obi->{'dewey'}, $biblioitem->{'dewey'});
- my $sth=$dbh->prepare("update biblioitems set dewey=$biblioitem->{'dewey'} where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '082', 'a', $obi->{'dewey'}, $biblioitem->{'dewey'});
- changeSubfield($Record_ID, '082', 'a', $obi->{'dewey'}, $biblioitem->{'dewey'});
- }
- if ($biblioitem->{'subclass'} ne $obi->{'subclass'}) {
- logchange('kohadb', 'change', 'biblioitems', 'subclass', $obi->{'subclass'}, $biblioitem->{'subclass'});
- my $q_subclass=$dbh->quote($biblioitem->{'subclass'});
- my $sth=$dbh->prepare("update biblioitems set subclass=$q_subclass where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '090', 'b', $obi->{'subclass'}, $biblioitem->{'subclass'});
- changeSubfield($Record_ID, '090', 'b', $obi->{'subclass'}, $biblioitem->{'subclass'});
- }
- if ($biblioitem->{'place'} ne $obi->{'place'}) {
- logchange('kohadb', 'change', 'biblioitems', 'place', $obi->{'place'}, $biblioitem->{'place'});
- my $q_place=$dbh->quote($biblioitem->{'place'});
- my $sth=$dbh->prepare("update biblioitems set place=$q_place where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '260', 'a', $obi->{'place'}, $biblioitem->{'place'});
- changeSubfield($Record_ID, '260', 'a', $obi->{'place'}, $biblioitem->{'place'});
- }
- if ($biblioitem->{'publishercode'} ne $obi->{'publishercode'}) {
- logchange('kohadb', 'change', 'biblioitems', 'publishercode', $obi->{'publishercode'}, $biblioitem->{'publishercode'});
- my $q_publishercode=$dbh->quote($biblioitem->{'publishercode'});
- my $sth=$dbh->prepare("update biblioitems set publishercode=$q_publishercode where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '260', 'b', $obi->{'publishercode'}, $biblioitem->{'publishercode'});
- changeSubfield($Record_ID, '260', 'b', $obi->{'publishercode'}, $biblioitem->{'publishercode'});
- }
- if ($biblioitem->{'publicationyear'} ne $obi->{'publicationyear'}) {
- logchange('kohadb', 'change', 'biblioitems', 'publicationyear', $obi->{'publicationyear'}, $biblioitem->{'publicationyear'});
- my $q_publicationyear=$dbh->quote($biblioitem->{'publicationyear'});
- my $sth=$dbh->prepare("update biblioitems set publicationyear=$q_publicationyear where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '260', 'c', $obi->{'publicationyear'}, $biblioitem->{'publicationyear'});
- changeSubfield($Record_ID, '260', 'c', $obi->{'publicationyear'}, $biblioitem->{'publicationyear'});
- }
- if ($biblioitem->{'illus'} ne $obi->{'illus'}) {
- logchange('kohadb', 'change', 'biblioitems', 'illus', $obi->{'illus'}, $biblioitem->{'illus'});
- my $q_illus=$dbh->quote($biblioitem->{'illus'});
- my $sth=$dbh->prepare("update biblioitems set illus=$q_illus where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '700', 'a', $obi->{'illus'}, $biblioitem->{'illus'});
- changeSubfield($Record_ID, '700', 'a', $obi->{'illus'}, $biblioitem->{'illus'});
- }
- if ($biblioitem->{'pages'} ne $obi->{'pages'}) {
- logchange('kohadb', 'change', 'biblioitems', 'pages', $obi->{'pages'}, $biblioitem->{'pages'});
- my $q_pages=$dbh->quote($biblioitem->{'pages'});
- my $sth=$dbh->prepare("update biblioitems set pages=$q_pages where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '300', 'a', $obi->{'pages'}, $biblioitem->{'pages'});
- changeSubfield($Record_ID, '300', 'a', $obi->{'pages'}, $biblioitem->{'pages'});
- }
- if ($biblioitem->{'size'} ne $obi->{'size'}) {
- logchange('kohadb', 'change', 'biblioitems', 'size', $obi->{'size'}, $biblioitem->{'size'});
- my $q_size=$dbh->quote($biblioitem->{'size'});
- my $sth=$dbh->prepare("update biblioitems set size=$q_size where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '300', 'c', $obi->{'size'}, $biblioitem->{'size'});
- changeSubfield($Record_ID, '300', 'c', $obi->{'size'}, $biblioitem->{'size'});
- }
- if ($biblioitem->{'notes'} ne $obi->{'notes'}) {
- logchange('kohadb', 'change', 'biblioitems', 'notes', $obi->{'notes'}, $biblioitem->{'notes'});
- my $q_notes=$dbh->quote($biblioitem->{'notes'});
- my $sth=$dbh->prepare("update biblioitems set notes=$q_notes where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '500', 'a', $obi->{'notes'}, $biblioitem->{'notes'});
- changeSubfield($Record_ID, '500', 'a', $obi->{'notes'}, $biblioitem->{'notes'});
- }
- if ($biblioitem->{'lccn'} ne $obi->{'lccn'}) {
- logchange('kohadb', 'change', 'biblioitems', 'lccn', $obi->{'lccn'}, $biblioitem->{'lccn'});
- my $q_lccn=$dbh->quote($biblioitem->{'lccn'});
- my $sth=$dbh->prepare("update biblioitems set lccn=$q_lccn where biblioitemnumber=$biblioitemnumber");
- logchange('marc', 'change', $Record_ID, '010', 'a', $obi->{'lccn'}, $biblioitem->{'lccn'});
- changeSubfield($Record_ID, '010', 'a', $obi->{'lccn'}, $biblioitem->{'lccn'});
- }
- $sth->finish;
- $dbh->disconnect;
+C<$count> is the number of elements in C<$currencies>. C<$currencies>
+is a reference-to-array; its elements are references-to-hash, whose
+keys are the fields from the currency table in the Koha database.
+=cut
+#'
+sub getcurrencies {
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from currency");
+ $sth->execute;
+ my @results = ();
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),\@results);
}
+=item updatecurrencies
-sub newItem {
- my ($env, $Record_ID, $item) = @_;
- my $dbh=&C4Connect;
- my $barcode=$item->{'barcode'};
- my $q_barcode=$dbh->quote($barcode);
- my $biblionumber=$item->{'biblionumber'};
- my $biblioitemnumber=$item->{'biblioitemnumber'};
- my $dateaccessioned=$item->{'dateaccessioned'};
- my $booksellerid=$item->{'booksellerid'};
- my $q_booksellerid=$dbh->quote($booksellerid);
- my $homebranch=$item->{'homebranch'};
- my $q_homebranch=$dbh->quote($homebranch);
- my $holdingbranch=$item->{'holdingbranch'};
- my $price=$item->{'price'};
- my $replacementprice=$item->{'replacementprice'};
- my $replacementpricedate=$item->{'replacementpricedate'};
- my $q_replacementpricedate=$dbh->quote($replacementpricedate);
- my $notforloan=$item->{'notforloan'};
- my $itemlost=$item->{'itemlost'};
- my $wthdrawn=$item->{'wthdrawn'};
- my $restricted=$item->{'restricted'};
- my $itemnotes=$item->{'itemnotes'};
- my $q_itemnotes=$dbh->quote($itemnotes);
- my $itemtype=$item->{'itemtype'};
- my $subclass=$item->{'subclass'};
-
-# KOHADB Section
-
- unless ($env->{'marconly'}) {
- my $sth=$dbh->prepare("select max(itemnumber) from items");
- $sth->execute;
- my ($itemnumber) =$sth->fetchrow;
- $itemnumber++;
- $sth=$dbh->prepare("insert into items (itemnumber,biblionumber,biblioitemnumber,barcode,dateaccessioned,booksellerid,homebranch,price,replacementprice,replacementpricedate,notforloan,itemlost,wthdrawn,restricted,itemnotes) values ($itemnumber,$biblionumber,$biblioitemnumber,$q_barcode,$dateaccessioned,$q_booksellerid,$q_homebranch,$price,$q_replacementpricedate,$notforloan,$itemlost,$wthdrawn,$restricted,$q_itemnotes)");
- $sth->execute;
- }
+ &updatecurrencies($currency, $newrate);
+Sets the exchange rate for C<$currency> to be C<$newrate>.
-# MARC SECTION
- my $subfields;
- $subfields->{1}->{'Subfield_Mark'}='p';
- $subfields->{1}->{'Subfield_Value'}=$barcode;
- $subfields->{2}->{'Subfield_Mark'}='d';
- $subfields->{2}->{'Subfield_Value'}=$dateaccessioned;
- $subfields->{3}->{'Subfield_Mark'}='e';
- $subfields->{3}->{'Subfield_Value'}=$booksellerid;
- $subfields->{4}->{'Subfield_Mark'}='b';
- $subfields->{4}->{'Subfield_Value'}=$homebranch;
- $subfields->{5}->{'Subfield_Mark'}='l';
- $subfields->{5}->{'Subfield_Value'}=$holdingbranch;
- $subfields->{6}->{'Subfield_Mark'}='c';
- $subfields->{6}->{'Subfield_Value'}=$price;
- $subfields->{7}->{'Subfield_Mark'}='c';
- $subfields->{7}->{'Subfield_Value'}=$replacementprice;
- $subfields->{8}->{'Subfield_Mark'}='d';
- $subfields->{8}->{'Subfield_Value'}=$replacementpricedate;
- if ($notforloan) {
- $subfields->{9}->{'Subfield_Mark'}='h';
- $subfields->{9}->{'Subfield_Value'}='Not for loan';
- }
- if ($notforloan) {
- $subfields->{10}->{'Subfield_Mark'}='j';
- $subfields->{10}->{'Subfield_Value'}='Item lost';
- }
- if ($notforloan) {
- $subfields->{11}->{'Subfield_Mark'}='j';
- $subfields->{11}->{'Subfield_Value'}='Item withdrawn';
- }
- if ($notforloan) {
- $subfields->{12}->{'Subfield_Mark'}='z';
- $subfields->{12}->{'Subfield_Value'}=$itemnotes;
- }
- my $tag='876';
- my $Tag_ID;
- $env->{'linkage'}=1;
- ($env, $Tag_ID) = addTag($env, $Record_ID, $tag, ' ', ' ', $subfields);
- $env->{'linkage'}=0;
- $env->{'linkid'}=$Tag_ID;
- $tag='852';
- my $subfields2;
- $subfields2->{1}->{'Subfield_Mark'}='a';
- $subfields2->{1}->{'Subfield_Value'}='Coast Mountains School District';
- $subfields2->{1}->{'Subfield_Mark'}='b';
- $subfields2->{1}->{'Subfield_Value'}=$homebranch;
- $subfields2->{1}->{'Subfield_Mark'}='c';
- $subfields2->{1}->{'Subfield_Value'}=$itemtype;
- $subfields2->{2}->{'Subfield_Mark'}='m';
- $subfields2->{2}->{'Subfield_Value'}=$subclass;
- addTag($env, $Record_ID, $tag, ' ', ' ', $subfields2);
- $env->{'linkid'}='';
+=cut
+#'
+sub updatecurrencies {
+ my ($currency,$rate)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("update currency set rate=? where currency=?");
+ $sth->execute($rate,$currency);
+ $sth->finish;
+}
+
+# FIXME - This is never used
+sub updatecost{
+ my($price,$rrp,$itemnum)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("update items set price=?,replacementprice=? where itemnumber=?");
+ $sth->execute($price,$rrp,$itemnum);
+ $sth->finish;
}
-sub updateItem {
-# Update the item with itemnumber $item->{'itemnumber'}
-# This routine should also modify the corresponding MARC record data. (852 and
-# 876 tags with 876p tag the same as $item->{'barcode'}
#
-# This routine should also check to see which fields are actually being
-# modified, and log all changes.
-
- my ($env, $item) = @_;
- my $dbh=&C4Connect;
- my $itemnumber=$item->{'itemnumber'};
- my $biblionumber=$item->{'biblionumber'};
- my $biblioitemnumber=$item->{'biblioitemnumber'};
- my $barcode=$item->{'barcode'};
- my $dateaccessioned=$item->{'dateaccessioned'};
- my $booksellerid=$item->{'booksellerid'};
- my $homebranch=$item->{'homebranch'};
- my $price=$item->{'price'};
- my $replacementprice=$item->{'replacementprice'};
- my $replacementpricedate=$item->{'replacementpricedate'};
- my $multivolume=$item->{'multivolume'};
- my $stack=$item->{'stack'};
- my $notforloan=$item->{'notforloan'};
- my $itemlost=$item->{'itemlost'};
- my $wthdrawn=$item->{'wthdrawn'};
- my $bulk=$item->{'bulk'};
- my $restricted=$item->{'restricted'};
- my $binding=$item->{'binding'};
- my $itemnotes=$item->{'itemnotes'};
- my $holdingbranch=$item->{'holdingbranch'};
- my $interim=$item->{'interim'};
- my $sth=$dbh->prepare("select * from items where itemnumber=$itemnumber");
- $sth->execute;
- my $olditem=$sth->fetchrow_hashref;
- my $q_barcode=$dbh->quote($olditem->{'barcode'});
- $sth=$dbh->prepare("select S.Subfield_ID, B.Record_ID from 8XX_Subfield_Table S, 8XX_Tag_Table T, Bib_Table B where B.Tag_8XX_ID=T.Tag_ID and T.Subfield_ID=S.Subfield_ID and Subfield_Mark='p' and Subfield_Value=$q_barcode");
- $sth->execute;
- my ($Subfield876_ID, $Record_ID) = $sth->fetchrow;
- $sth=$dbh->prepare("select Subfield_Value from 8XX_Subfield_Table where Subfield_Mark=8 and Subfield_ID=$Subfield876_ID");
- $sth->execute;
- my ($link) = $sth->fetchrow;
- $sth=$dbh->prepare("select Subfield_ID from 8XX_Subfield_Table where Subfield_Mark=8 and Subfield_Value=$link and !(Subfield_ID=$Subfield876_ID)");
- $sth->execute;
- my ($Subfield852_ID) = $sth->fetchrow;
-
- if ($item->{'barcode'} ne $olditem->{'barcode'}) {
- logchange('kohadb', 'change', 'items', 'barcode', $olditem->{'barcode'}, $item->{'barcode'});
- my $q_barcode=$dbh->quote($item->{'barcode'});
- my $sth=$dbh->prepare("update items set barcode=$q_barcode where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'p', $olditem->{'barcode'}, $item->{'barcode'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'p', $Subfield_Key, $olditem->{'barcode'}, $item->{'barcode'});
- }
- if ($item->{'booksellerid'} ne $olditem->{'booksellerid'}) {
- logchange('kohadb', 'change', 'items', 'booksellerid', $olditem->{'booksellerid'}, $item->{'booksellerid'});
- my $q_booksellerid=$dbh->quote($item->{'booksellerid'});
- my $sth=$dbh->prepare("update items set booksellerid=$q_booksellerid where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'e', $olditem->{'booksellerid'}, $item->{'booksellerid'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'e', $Subfield_Key, $olditem->{'booksellerid'}, $item->{'booksellerid'});
- }
- if ($item->{'dateaccessioned'} ne $olditem->{'dateaccessioned'}) {
- logchange('kohadb', 'change', 'items', 'dateaccessioned', $olditem->{'dateaccessioned'}, $item->{'dateaccessioned'});
- my $q_dateaccessioned=$dbh->quote($item->{'dateaccessioned'});
- my $sth=$dbh->prepare("update items set dateaccessioned=$q_dateaccessioned where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'd', $olditem->{'dateaccessioned'}, $item->{'dateaccessioned'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'd', $Subfield_Key, $olditem->{'dateaccessioned'}, $item->{'dateaccessioned'});
- }
- if ($item->{'homebranch'} ne $olditem->{'homebranch'}) {
- logchange('kohadb', 'change', 'items', 'homebranch', $olditem->{'homebranch'}, $item->{'homebranch'});
- my $q_homebranch=$dbh->quote($item->{'homebranch'});
- my $sth=$dbh->prepare("update items set homebranch=$q_homebranch where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'b', $olditem->{'homebranch'}, $item->{'homebranch'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'b', $Subfield_Key, $olditem->{'homebranch'}, $item->{'homebranch'});
- }
- if ($item->{'holdingbranch'} ne $olditem->{'holdingbranch'}) {
- logchange('kohadb', 'change', 'items', 'holdingbranch', $olditem->{'holdingbranch'}, $item->{'holdingbranch'});
- my $q_holdingbranch=$dbh->quote($item->{'holdingbranch'});
- my $sth=$dbh->prepare("update items set holdingbranch=$q_holdingbranch where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'l', $olditem->{'holdingbranch'}, $item->{'holdingbranch'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'l', $Subfield_Key, $olditem->{'holdingbranch'}, $item->{'holdingbranch'});
- }
- if ($item->{'price'} ne $olditem->{'price'}) {
- logchange('kohadb', 'change', 'items', 'price', $olditem->{'price'}, $item->{'price'});
- my $q_price=$dbh->quote($item->{'price'});
- my $sth=$dbh->prepare("update items set price=$q_price where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'c', $olditem->{'price'}, $item->{'price'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'c', $Subfield_Key, $olditem->{'price'}, $item->{'price'});
- }
- if ($item->{'itemnotes'} ne $olditem->{'itemnotes'}) {
- logchange('kohadb', 'change', 'items', 'itemnotes', $olditem->{'itemnotes'}, $item->{'itemnotes'});
- my $q_itemnotes=$dbh->quote($item->{'itemnotes'});
- my $sth=$dbh->prepare("update items set itemnotes=$q_itemnotes where itemnumber=$itemnumber");
- $sth->execute;
- my ($Subfield_ID, $Subfield_Key) = changeSubfield($Record_ID, '876', 'c', $olditem->{'itemnotes'}, $item->{'itemnotes'}, $Subfield876_ID);
- logchange('marc', 'change', $Record_ID, '876', 'c', $Subfield_Key, $olditem->{'itemnotes'}, $item->{'itemnotes'});
- }
- if ($item->{'notforloan'} ne $olditem->{'notforloan'}) {
- logchange('kohadb', 'change', 'items', 'notforloan', $olditem->{'notforloan'}, $item->{'notforloan'});
- my $sth=$dbh->prepare("update items set notforloan=$notforloan where itemnumber=$itemnumber");
- $sth->execute;
- if ($item->{'notforloan'}) {
- my ($Subfield_ID, $Subfield_Key) = addSubfield($Record_ID, '876', 'h', 'Not for loan', $Subfield876_ID);
- logchange('marc', 'add', $Record_ID, '876', 'h', $Subfield_Key, 'Not for loan');
- } else {
- my ($Subfield_ID, $Subfield_Key) = deleteSubfield($Record_ID, '876', 'h', 'Not for loan', $Subfield876_ID);
- logchange('marc', 'delete', $Record_ID, '876', 'h', $Subfield_Key, 'Not for loan');
- }
- }
- if ($item->{'itemlost'} ne $olditem->{'itemlost'}) {
- logchange('kohadb', 'change', 'items', 'itemlost', $olditem->{'itemlost'}, $item->{'itemlost'});
- my $sth=$dbh->prepare("update items set itemlost=$itemlost where itemnumber=$itemnumber");
- $sth->execute;
- if ($item->{'itemlost'}) {
- my ($Subfield_ID, $Subfield_Key) = addSubfield($Record_ID, '876', 'h', 'Item lost', $Subfield876_ID);
- logchange('marc', 'add', $Record_ID, '876', 'h', $Subfield_Key, 'Item lost');
- } else {
- my ($Subfield_ID, $Subfield_Key) = deleteSubfield($Record_ID, '876', 'h', 'Item lost', $Subfield876_ID);
- logchange('marc', 'delete', $Record_ID, '876', 'h', $Subfield_Key, 'Item lost');
- }
- }
- if ($item->{'wthdrawn'} ne $olditem->{'wthdrawn'}) {
- logchange('kohadb', 'change', 'items', 'wthdrawn', $olditem->{'wthdrawn'}, $item->{'wthdrawn'});
- my $sth=$dbh->prepare("update items set wthdrawn=$wthdrawn where itemnumber=$itemnumber");
- $sth->execute;
- if ($item->{'wthdrawn'}) {
- my ($Subfield_ID, $Subfield_Key) = addSubfield($Record_ID, '876', 'h', 'Withdrawn', $Subfield876_ID);
- logchange('marc', 'add', $Record_ID, '876', 'h', $Subfield_Key, 'Withdrawn');
- } else {
- my ($Subfield_ID, $Subfield_Key) = deleteSubfield($Record_ID, '876', 'h', 'Withdrawn', $Subfield876_ID);
- logchange('marc', 'delete', $Record_ID, '876', 'h', $Subfield_Key, 'Withdrawn');
- }
- }
- if ($item->{'restricted'} ne $olditem->{'restricted'}) {
- logchange('kohadb', 'change', 'items', 'restricted', $olditem->{'restricted'}, $item->{'restricted'});
- my $sth=$dbh->prepare("update items set restricted=$restricted where itemnumber=$itemnumber");
- $sth->execute;
- if ($item->{'restricted'}) {
- my ($Subfield_ID, $Subfield_Key) = addSubfield($Record_ID, '876', 'h', 'Restricted', $Subfield876_ID);
- logchange('marc', 'add', $Record_ID, '876', 'h', $Subfield_Key, 'Restricted');
- } else {
- my ($Subfield_ID, $Subfield_Key) = deleteSubfield($Record_ID, '876', 'h', 'Restricted', $Subfield876_ID);
- logchange('marc', 'delete', $Record_ID, '876', 'h', $Subfield_Key, 'Restricted');
- }
- }
+#
+# OTHERS
+#
+#
+
+=item bookseller
+
+ ($count, @results) = &bookseller($searchstring);
+
+Looks up a book seller. C<$searchstring> may be either a book seller
+ID, or a string to look for in the book seller's name.
+
+C<$count> is the number of elements in C<@results>. C<@results> is an
+array of references-to-hash, whose keys are the fields of of the
+aqbooksellers table in the Koha database.
+
+=cut
+#'
+sub bookseller {
+ my ($searchstring)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from aqbooksellers where name like ? or id = ?");
+ $sth->execute("$searchstring%",$searchstring);
+ my @results;
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),@results);
+}
+
+=item breakdown
+
+ ($count, $results) = &breakdown($ordernumber);
+
+Looks up an order by order ID, and returns its breakdown.
+
+C<$count> is the number of elements in C<$results>. C<$results> is a
+reference-to-array; its elements are references-to-hash, whose keys
+are the fields of the aqorderbreakdown table in the Koha database.
+
+=cut
+#'
+sub breakdown {
+ my ($id)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from aqorderbreakdown where ordernumber=?");
+ $sth->execute($id);
+ my @results = ();
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(scalar(@results),\@results);
+}
+
+=item branches
+
+ ($count, @results) = &branches();
+
+Returns a list of all library branches.
+
+C<$count> is the number of elements in C<@results>. C<@results> is an
+array of references-to-hash, whose keys are the fields of the branches
+table of the Koha database.
+
+=cut
+#'
+sub branches {
+ my $dbh = C4::Context->dbh;
+ my $sth = $dbh->prepare("Select * from branches order by branchname");
+ my @results = ();
+
+ $sth->execute();
+ while (my $data = $sth->fetchrow_hashref) {
+ push(@results,$data);
+ } # while
+
$sth->finish;
- $dbh->disconnect;
+ return(scalar(@results), @results);
+} # sub branches
+
+# FIXME - Never used
+sub findall {
+ my ($biblionumber)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from biblioitems,items,itemtypes where
+ biblioitems.biblionumber=?
+ and biblioitems.biblioitemnumber=items.biblioitemnumber and
+ itemtypes.itemtype=biblioitems.itemtype
+ order by items.biblioitemnumber");
+ $sth->execute($biblionumber);
+ my @results;
+ while (my $data=$sth->fetchrow_hashref){
+ push(@results,$data);
+ }
+ $sth->finish;
+ return(@results);
+}
+
+# FIXME - Never used
+sub needsmod{
+ my ($bibitemnum,$itemtype)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select * from biblioitems where biblioitemnumber=?
+ and itemtype=?");
+ $sth->execute($bibitemnum,$itemtype);
+ my $result=0;
+ if (my $data=$sth->fetchrow_hashref){
+ $result=1;
+ }
+ $sth->finish;
+ return($result);
+}
+
+=item updatesup
+
+ &updatesup($bookseller);
+
+Updates the information for a given bookseller. C<$bookseller> is a
+reference-to-hash whose keys are the fields of the aqbooksellers table
+in the Koha database. It must contain entries for all of the fields.
+The entry to modify is determined by C<$bookseller-E<gt>{id}>.
+
+The easiest way to get all of the necessary fields is to look up a
+book seller with C<&booksellers>, modify what's necessary, then call
+C<&updatesup> with the result.
+
+=cut
+#'
+sub updatesup {
+ my ($data)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Update aqbooksellers set
+ name=?,address1=?,address2=?,address3=?,address4=?,postal=?,
+ phone=?,fax=?,url=?,contact=?,contpos=?,contphone=?,contfax=?,contaltphone=?,
+ contemail=?,contnotes=?,active=?,
+ listprice=?, invoiceprice=?,gstreg=?, listincgst=?,
+ invoiceincgst=?, specialty=?,discount=?,invoicedisc=?,
+ nocalc=?
+ where id=?");
+ $sth->execute($data->{'name'},$data->{'address1'},$data->{'address2'},
+ $data->{'address3'},$data->{'address4'},$data->{'postal'},$data->{'phone'},
+ $data->{'fax'},$data->{'url'},$data->{'contact'},$data->{'contpos'},
+ $data->{'contphone'},$data->{'contfax'},$data->{'contaltphone'},
+ $data->{'contemail'},
+ $data->{'contnote'},$data->{'active'},$data->{'listprice'},
+ $data->{'invoiceprice'},$data->{'gstreg'},$data->{'listincgst'},
+ $data->{'invoiceincgst'},$data->{'specialty'},$data->{'discount'},
+ $data->{'invoicedisc'},$data->{'nocalc'},$data->{'id'});
+ $sth->finish;
+# print $query;
}
+=item insertsup
+
+ $id = &insertsup($bookseller);
+
+Creates a new bookseller. C<$bookseller> is a reference-to-hash whose
+keys are the fields of the aqbooksellers table in the Koha database.
+All fields must be present.
+
+Returns the ID of the newly-created bookseller.
+
+=cut
+#'
+sub insertsup {
+ my ($data)=@_;
+ my $dbh = C4::Context->dbh;
+ my $sth=$dbh->prepare("Select max(id) from aqbooksellers");
+ $sth->execute;
+ my $data2=$sth->fetchrow_hashref;
+ $sth->finish;
+ $data2->{'max(id)'}++;
+ $sth=$dbh->prepare("Insert into aqbooksellers (id) values (?)");
+ $sth->execute($data2->{'max(id)'});
+ $sth->finish;
+ $data->{'id'}=$data2->{'max(id)'};
+ updatesup($data);
+ return($data->{'id'});
+}
+
+=item websitesearch
+
+ ($count, @results) = &websitesearch($keywordlist);
+
+Looks up biblioitems by URL.
+
+C<$keywordlist> is a space-separated list of search terms.
+C<&websitesearch> returns those biblioitems whose URL contains at
+least one of the search terms.
+
+C<$count> is the number of elements in C<@results>. C<@results> is an
+array of references-to-hash, whose keys are the fields of the biblio
+and biblioitems tables in the Koha database.
+
+=cut
+#'
+sub websitesearch {
+ my ($keywordlist) = @_;
+ my $dbh = C4::Context->dbh;
+ my $sth;
+ my @results = ();
+ my @keywords = split(/ +/, $keywordlist);
+
+ $sth = $dbh->prepare("Select distinct biblio.* from biblio, biblioitems where
+ biblio.biblionumber = biblioitems.biblionumber and ("
+ .(join(") or (",map { "url like ?" } @keywords)).")");
+ $sth->execute(map { s/([%_])/\\\1/g; "%$_%" } @keywords);
+
+ while (my $data = $sth->fetchrow_hashref) {
+ push(@results,$data);
+ } # while
+
+ $sth->finish;
+ return(scalar(@results), @results);
+} # sub websitesearch
+
+=item addwebsite
+
+ &addwebsite($website);
+
+Adds a new web site. C<$website> is a reference-to-hash, with the keys
+C<biblionumber>, C<title>, C<description>, and C<url>. All of these
+are mandatory.
+
+=cut
+#'
+sub addwebsite {
+ my ($website) = @_;
+ my $dbh = C4::Context->dbh;
+ my $query;
+
+ # FIXME -
+ # for (qw( biblionumber title description url )) # and any others
+ # {
+ # $website->{$_} = $dbh->quote($_);
+ # }
+ # Perhaps extend this to building the query as well. This might allow
+ # some of the fields to be optional.
+ $website->{'biblionumber'} = $dbh->quote($website->{'biblionumber'});
+ $website->{'title'} = $dbh->quote($website->{'title'});
+ $website->{'description'} = $dbh->quote($website->{'description'});
+ $website->{'url'} = $dbh->quote($website->{'url'});
+
+ $query = "Insert into websites set
+biblionumber = $website->{'biblionumber'},
+title = $website->{'title'},
+description = $website->{'description'},
+url = $website->{'url'}";
+
+ $dbh->do($query);
+} # sub website
+
+=item updatewebsite
+
+ &updatewebsite($website);
+
+Updates an existing web site. C<$website> is a reference-to-hash with
+the keys C<websitenumber>, C<title>, C<description>, and C<url>. All
+of these are mandatory. C<$website-E<gt>{websitenumber}> identifies
+the entry to update.
+
+=cut
+#'
+sub updatewebsite {
+ my ($website) = @_;
+ my $dbh = C4::Context->dbh;
+ my $query;
+
+ $website->{'title'} = $dbh->quote($website->{'title'});
+ $website->{'description'} = $dbh->quote($website->{'description'});
+ $website->{'url'} = $dbh->quote($website->{'url'});
+
+ $query = "Update websites set
+title = $website->{'title'},
+description = $website->{'description'},
+url = $website->{'url'}
+where websitenumber = $website->{'websitenumber'}";
+
+ $dbh->do($query);
+} # sub updatewebsite
+
+=item deletewebsite
+
+ &deletewebsite($websitenumber);
+
+Deletes the web site with number C<$websitenumber>.
+
+=cut
+#'
+sub deletewebsite {
+ my ($websitenumber) = @_;
+ my $dbh = C4::Context->dbh;
+ # FIXME - $query is unneeded
+ my $query = "Delete from websites where websitenumber = $websitenumber";
+
+ $dbh->do($query);
+} # sub deletewebsite
+
END { } # module clean-up code here (global destructor)
+
+1;
+__END__
+
+=back
+
+=head1 AUTHOR
+
+Koha Developement team <info@koha.org>
+
+=cut