# 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 XML::Simple;
#use LWP::Simple;
use C4::Biblio;
-use C4::Items;
-
+use C4::Koha;
+use C4::Search;
+use C4::External::Syndetics qw(get_syndetics_editions);
use LWP::UserAgent;
use HTTP::Request::Common;
use strict;
+#use warnings; FIXME - Bug 2505
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
BEGIN {
require Exporter;
- $VERSION = 3.01;
+ $VERSION = 3.07.00.049;
@ISA = qw(Exporter);
@EXPORT_OK = qw(
&get_xisbns
- &get_biblio_from_xisbn
&get_biblionumber_from_isbn
);
}
sub get_biblionumber_from_isbn {
my $isbn = shift;
- $isbn =~ /(\d*[X]*)/;
- $isbn = $1.'%' if $isbn;
+ $isbn.='%';
my @biblionumbers;
my $dbh=C4::Context->dbh;
- my $query = "SELECT biblionumber FROM biblioitems WHERE isbn LIKE ?";
+ my $query = "SELECT biblionumber FROM biblioitems WHERE isbn LIKE ? LIMIT 10";
my $sth = $dbh->prepare($query);
$sth->execute($isbn);
- while ( my $biblionumber = $sth->fetchrow_hashref() ) {
- push (@biblionumbers, $biblionumber);
- }
- return \@biblionumbers;
+ return $sth->fetchall_arrayref({});
}
=head1 NAME
=cut
-sub get_biblio_from_xisbn {
+sub _get_biblio_from_xisbn {
my $xisbn = shift;
- $xisbn .='%' if ($xisbn =~ /(\d*[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*[X]*)/;
- $xbiblio->{amazonisbn} = $1;
- $xbiblio->{items} = GetItemsByBiblioitemnumber($xbib_data->{biblionumber});
- }
- return ($xbiblio);
+
+ my ( $errors, $results, $total_hits ) = C4::Search::SimpleSearch( "nb=$xisbn", 0, 1 );
+ return unless ( !$errors && scalar @$results );
+
+ my $record = MARC::Record::new_from_usmarc( $results->[0] );
+ my $biblionumber = C4::Biblio::get_koha_field_from_marc('biblio', 'biblionumber', $record, '');
+ return unless $biblionumber;
+
+ my $xbiblio = GetBiblioData($biblionumber);
+ return unless $xbiblio;
+ $xbiblio->{normalized_isbn} = GetNormalizedISBN($xbiblio->{isbn});
+ return $xbiblio;
}
=head1 get_xisbns($isbn);
sub get_xisbns {
my ( $isbn ) = @_;
- my ($response,$thing_response,$xisbn_response,$gapines_response);
- $isbn =~ /(\d*[X]*)/;
- $isbn = $1;
+ my ($response,$thing_response,$xisbn_response,$syndetics_response);
# THINGISBN
if ( C4::Context->preference('ThingISBN') ) {
my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
$thing_response = _get_url($url,'thingisbn');
}
+ if ( C4::Context->preference("SyndeticsEnabled") && C4::Context->preference("SyndeticsEditions") ) {
+ my $syndetics_preresponse = &get_syndetics_editions($isbn);
+ my @syndetics_response;
+ for my $response (@$syndetics_preresponse) {
+ push @syndetics_response, {content => $response->{a}};
+ }
+ $syndetics_response = {isbn => \@syndetics_response};
+ }
+
# 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') || 999;
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;
}
}
- # 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 [] } ];
+ $response->{isbn} = [ @{ $xisbn_response->{isbn} or [] }, @{ $syndetics_response->{isbn} or [] }, @{ $thing_response->{isbn} or [] } ];
my @xisbns;
my $unique_xisbns; # a hashref
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;
+ my $xbiblio= _get_biblio_from_xisbn($response_data->{content});
+ push @xisbns, $xbiblio if $xbiblio;
}
return \@xisbns;
}
sub _service_throttle {
my ($service_type,$daily_limit) = @_;
my $dbh = C4::Context->dbh;
- my $sth = $dbh->prepare("SELECT service_count FROM services_throttle WHERE service_type=?");
+ my $sth = $dbh->prepare(q{ SELECT service_count FROM services_throttle WHERE service_type=? });
$sth->execute($service_type);
- my $count = 1;
+ my $count = 0;
- while (my $counter = $sth->fetchrow_hashref()) {
- $count = $counter->{service_count} if $counter->{service_count};
+ if ($sth->rows == 0) {
+ # initialize services throttle
+ my $sth2 = $dbh->prepare(q{ INSERT INTO services_throttle (service_type, service_count) VALUES (?, ?) });
+ $sth2->execute($service_type, $count);
+ } else {
+ $count = $sth->fetchrow_array;
}
# we're over the limit
# not over the limit
$count++;
- $sth = $dbh->do("UPDATE services_throttle SET service_count=$count WHERE service_type='xisbn'");
+ my $sth3 = $dbh->prepare(q{ UPDATE services_throttle SET service_count=? WHERE service_type=? });
+ $sth3->execute($count, $service_type);
+
return undef;
}
=head1 NOTES
+=cut
+
=head1 AUTHOR
Joshua Ferraro <jmf@liblime.com>