use XML::Simple;
#use LWP::Simple;
use C4::Biblio;
+use C4::Items;
use LWP::UserAgent;
use HTTP::Request::Common;
use strict;
-require Exporter;
-
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
-$VERSION = 3.0;
+BEGIN {
+ require Exporter;
+ $VERSION = 3.01;
+ @ISA = qw(Exporter);
+ @EXPORT_OK = qw(
+ &get_xisbns
+ &get_biblio_from_xisbn
+ &get_biblionumber_from_isbn
+ );
+}
+
+sub get_biblionumber_from_isbn {
+ my $isbn = shift;
+ if ($isbn =~ /(\d{9,}[X]*)/) {
+ $isbn = $1.'%';
+ }
+ my @biblionumbers;
+ my $dbh=C4::Context->dbh;
+ my $query = "SELECT biblionumber FROM biblioitems WHERE isbn LIKE ? LIMIT 10";
+ my $sth = $dbh->prepare($query);
+ $sth->execute($isbn);
+ return $sth->fetchall_arrayref({});
+}
=head1 NAME
C4::XISBN - Functions for retrieving XISBN content in Koha
=head1 FUNCTIONS
-This module provides facilities for retrieving XISBN, ThingISBN and XISBN content in Koha
+This module provides facilities for retrieving ThingISBN and XISBN content in Koha
=cut
-@ISA = qw(Exporter);
-@EXPORT_OK = qw(
- &get_xisbns
- &get_biblio_from_xisbn
-);
-
sub get_biblio_from_xisbn {
- my $xisbn = shift;
- my $dbh = C4::Context->dbh;
- my $query = "SELECT biblionumber FROM biblioitems WHERE isbn=?";
- my $sth = $dbh->prepare($query);
- $sth->execute($xisbn);
- my $xbib_data = $sth->fetchrow_hashref();
- my $xbiblio;
- if ($xbib_data->{biblionumber}) {
- $xbiblio = GetBiblioData($xbib_data->{biblionumber});
- $xbiblio->{items} = GetItemsByBiblioitemnumber($xbib_data->{biblionumber});
- }
- return ($xbiblio);
-
+ my $xisbn = shift;
+ $xisbn .='%' if ($xisbn =~ /(\d{9,}[X]*)/);
+ my $dbh = C4::Context->dbh;
+ my $query = "SELECT biblionumber FROM biblioitems WHERE isbn LIKE ?";
+ my $sth = $dbh->prepare($query);
+ $sth->execute($xisbn);
+ my $xbib_data = $sth->fetchrow_hashref();
+ my $xbiblio;
+ if ($xbib_data->{biblionumber}) {
+ $xbiblio = GetBiblioData($xbib_data->{biblionumber});
+ $xbiblio->{isbn} =~ /(\d{9,}[X]*)/;
+ $xbiblio->{amazonisbn} = $1;
+ $xbiblio->{items} = GetItemsByBiblioitemnumber($xbib_data->{biblionumber});
+ }
+ return ($xbiblio);
}
+
=head1 get_xisbns($isbn);
=head2 $isbn is an ISBN string
sub get_xisbns {
my ( $isbn ) = @_;
-
my ($response,$thing_response,$xisbn_response,$gapines_response);
+ $isbn =~ /(\d{9,}[X]*)/;
+ $isbn = $1;
# THINGISBN
if ( C4::Context->preference('ThingISBN') ) {
my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
# XISBN
if ( C4::Context->preference('XISBN') ) {
my $affiliate_id=C4::Context->preference('OCLCAffiliateID');
- my $limit = C4::Context->preference('XISBNDailyLimit') || 499;
+ my $limit = C4::Context->preference('XISBNDailyLimit') || 499;
my $reached_limit = _service_throttle('xisbn',$limit);
my $url = "http://xisbn.worldcat.org/webservices/xid/isbn/".$isbn."?method=getEditions&format=xml&fl=form,year,lang,ed";
- $url.="&ai=".$affiliate_id if $affiliate_id;
- unless ($reached_limit) {
- $xisbn_response = _get_url($url,'xisbn');
- }
+ $url.="&ai=".$affiliate_id if $affiliate_id;
+ unless ($reached_limit) {
+ $xisbn_response = _get_url($url,'xisbn');
+ }
}
- # PINES ISBN
- if ( C4::Context->preference('PINESISBN') ) {
- my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
- $gapines_response = _get_url($url,'thingisbn');
+ # PINES ISBN (Experimental)
+ #if ( C4::Context->preference('PINESISBN') ) {
+ # my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
+ # $gapines_response = _get_url($url,'thingisbn');
+ #}
+ $response->{isbn} = [ @{ $xisbn_response->{isbn} or [] }, @{ $thing_response->{isbn} or [] }, @{ $gapines_response->{isbn} or [] } ];
+ my @xisbns;
+ my $unique_xisbns; # a hashref
+
+ # loop through each ISBN and scope to the local collection
+ for my $response_data( @{ $response->{ isbn } } ) {
+ next if $response_data->{'content'} eq $isbn;
+ next if $isbn eq $response_data;
+ next if $unique_xisbns->{ $response_data->{content} };
+ $unique_xisbns->{ $response_data->{content} }++;
+ my $xbiblio= get_biblio_from_xisbn($response_data->{content});
+ push @xisbns, $xbiblio if $xbiblio; #response_data->{xbiblio}; #->{biblionumber}; # if $xbiblionumber;
}
- $response->{isbn} = [ @{ $xisbn_response->{isbn} or [] }, @{ $thing_response->{isbn} or [] }, @{ $gapines_response->{isbn} or [] } ];
- my @xisbns;
- my $unique_xisbns; # a hashref
- # loop through each ISBN and scope to the local collection
- for my $response_data( @{ $response->{ isbn } } ) {
- next if $unique_xisbns->{ $response_data->{content} };
- $unique_xisbns->{ $response_data->{content} }++;
- my $xbiblio= get_biblio_from_xisbn($response_data->{content});
- push @xisbns, $xbiblio if $xbiblio; #response_data->{xbiblio}; #->{biblionumber}; # if $xbiblionumber;
-
- }
- return \@xisbns;
-
+ return \@xisbns;
}
sub _get_url {
my ($url,$service_type) = @_;
- my $ua = LWP::UserAgent->new(
- timeout => 2
- );
-
- my $response = $ua->get($url);
- if ($response->is_success) {
- warn "WARNING could not retrieve $service_type $url" unless $response;
- if ($response) {
- my $xmlsimple = XML::Simple->new();
- my $content = $xmlsimple->XMLin(
+ my $ua = LWP::UserAgent->new(
+ timeout => 2
+ );
+
+ my $response = $ua->get($url);
+ if ($response->is_success) {
+ warn "WARNING could not retrieve $service_type $url" unless $response;
+ if ($response) {
+ my $xmlsimple = XML::Simple->new();
+ my $content = $xmlsimple->XMLin(
$response->content,
ForceArray => [ qw(isbn) ],
ForceContent => 1,
);
- return $content;
- }
- } else {
+ return $content;
+ }
+ } else {
warn "WARNING: URL Request Failed " . $response->status_line . "\n";
}
# Throttle services to the specified amount
sub _service_throttle {
my ($service_type,$daily_limit) = @_;
- my $dbh = C4::Context->dbh;
+ my $dbh = C4::Context->dbh;
my $sth = $dbh->prepare("SELECT service_count FROM services_throttle WHERE service_type=?");
$sth->execute($service_type);
my $count = 1;
return undef;
}
+1;
+__END__
+
=head1 NOTES
=head1 AUTHOR
Joshua Ferraro <jmf@liblime.com>
+
=cut
+