2 # Copyright (C) 2007 LibLime
3 # Joshua Ferraro <jmf@liblime.com>
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA 02111-1307 USA
26 use HTTP
::Request
::Common
;
29 use vars
qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
37 &get_biblio_from_xisbn
43 C4::XISBN - Functions for retrieving XISBN content in Koha
47 This module provides facilities for retrieving ThingISBN and XISBN content in Koha
51 sub get_biblio_from_xisbn
{
53 my $dbh = C4
::Context
->dbh;
54 my $query = "SELECT biblionumber FROM biblioitems WHERE isbn=?";
55 my $sth = $dbh->prepare($query);
56 $sth->execute($xisbn);
57 my $xbib_data = $sth->fetchrow_hashref();
59 if ($xbib_data->{biblionumber
}) {
60 $xbiblio = GetBiblioData
($xbib_data->{biblionumber
});
61 $xbiblio->{items
} = GetItemsByBiblioitemnumber
($xbib_data->{biblionumber
});
66 =head1 get_xisbns($isbn);
68 =head2 $isbn is an ISBN string
74 my ($response,$thing_response,$xisbn_response,$gapines_response);
77 if ( C4
::Context
->preference('ThingISBN') ) {
78 my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
79 $thing_response = _get_url
($url,'thingisbn');
83 if ( C4
::Context
->preference('XISBN') ) {
84 my $affiliate_id=C4
::Context
->preference('OCLCAffiliateID');
85 my $limit = C4
::Context
->preference('XISBNDailyLimit') || 499;
86 my $reached_limit = _service_throttle
('xisbn',$limit);
87 my $url = "http://xisbn.worldcat.org/webservices/xid/isbn/".$isbn."?method=getEditions&format=xml&fl=form,year,lang,ed";
88 $url.="&ai=".$affiliate_id if $affiliate_id;
89 unless ($reached_limit) {
90 $xisbn_response = _get_url
($url,'xisbn');
94 # PINES ISBN (Experimental)
95 #if ( C4::Context->preference('PINESISBN') ) {
96 # my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
97 # $gapines_response = _get_url($url,'thingisbn');
99 $response->{isbn
} = [ @
{ $xisbn_response->{isbn
} or [] }, @
{ $thing_response->{isbn
} or [] }, @
{ $gapines_response->{isbn
} or [] } ];
101 my $unique_xisbns; # a hashref
103 # loop through each ISBN and scope to the local collection
104 for my $response_data( @
{ $response->{ isbn
} } ) {
105 next if $unique_xisbns->{ $response_data->{content
} };
106 $unique_xisbns->{ $response_data->{content
} }++;
107 my $xbiblio= get_biblio_from_xisbn
($response_data->{content
});
108 push @xisbns, $xbiblio if $xbiblio; #response_data->{xbiblio}; #->{biblionumber}; # if $xbiblionumber;
114 my ($url,$service_type) = @_;
115 my $ua = LWP
::UserAgent
->new(
119 my $response = $ua->get($url);
120 if ($response->is_success) {
121 warn "WARNING could not retrieve $service_type $url" unless $response;
123 my $xmlsimple = XML
::Simple
->new();
124 my $content = $xmlsimple->XMLin(
126 ForceArray
=> [ qw(isbn) ],
132 warn "WARNING: URL Request Failed " . $response->status_line . "\n";
138 # Throttle services to the specified amount
139 sub _service_throttle
{
140 my ($service_type,$daily_limit) = @_;
141 my $dbh = C4
::Context
->dbh;
142 my $sth = $dbh->prepare("SELECT service_count FROM services_throttle WHERE service_type=?");
143 $sth->execute($service_type);
146 while (my $counter = $sth->fetchrow_hashref()) {
147 $count = $counter->{service_count
} if $counter->{service_count
};
150 # we're over the limit
151 return 1 if $count >= $daily_limit;
155 $sth = $dbh->do("UPDATE services_throttle SET service_count=$count WHERE service_type='xisbn'");
166 Joshua Ferraro <jmf@liblime.com>