Bug 23289: Quote new 'rows' MariaDB reserved word
[koha.git] / C4 / XISBN.pm
blob1b3a3bbbd6081ae33f55d07369863ab17a4d5b09
1 package C4::XISBN;
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
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
20 use XML::Simple;
21 #use LWP::Simple;
22 use C4::Biblio;
23 use C4::Koha;
24 use C4::Search;
25 use C4::External::Syndetics qw(get_syndetics_editions);
26 use LWP::UserAgent;
27 use HTTP::Request::Common;
29 use Koha::Biblios;
30 use Koha::SearchEngine;
31 use Koha::SearchEngine::Search;
33 use strict;
34 #use warnings; FIXME - Bug 2505
35 use vars qw(@ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
37 BEGIN {
38 require Exporter;
39 @ISA = qw(Exporter);
40 @EXPORT_OK = qw(
41 &get_xisbns
45 =head1 NAME
47 C4::XISBN - Functions for retrieving XISBN content in Koha
49 =head1 FUNCTIONS
51 This module provides facilities for retrieving ThingISBN and XISBN content in Koha
53 =cut
55 sub _get_biblio_from_xisbn {
56 my $xisbn = shift;
57 my $dbh = C4::Context->dbh;
59 my $searcher = Koha::SearchEngine::Search->new({index => $Koha::SearchEngine::BIBLIOS_INDEX});
60 my ( $errors, $results, $total_hits ) = $searcher->simple_search_compat( "nb=$xisbn", 0, 1 );
61 return unless ( !$errors && scalar @$results );
63 my $record = C4::Search::new_record_from_zebra( 'biblioserver', $results->[0] );
64 my $biblionumber = C4::Biblio::TransformMarcToKohaOneField( 'biblio.biblionumber', $record );
65 return unless $biblionumber;
67 my $biblio = Koha::Biblios->find( $biblionumber );
68 return unless $biblio;
69 my $isbn = $biblio->biblioitem->isbn;
70 $biblio = $biblio->unblessed;
71 $biblio->{normalized_isbn} = GetNormalizedISBN($isbn);
72 return $biblio;
75 =head1 get_xisbns($isbn, $biblionumber);
77 =head2 $isbn is an ISBN string
79 =cut
81 sub get_xisbns {
82 my ( $isbn, $biblionumber ) = @_;
83 my ($response,$thing_response,$syndetics_response,$errors);
84 # THINGISBN
85 if ( C4::Context->preference('ThingISBN') ) {
86 my $url = "http://www.librarything.com/api/thingISBN/".$isbn;
87 $thing_response = _get_url($url,'thingisbn');
90 if ( C4::Context->preference("SyndeticsEnabled") && C4::Context->preference("SyndeticsEditions") ) {
91 my $syndetics_preresponse = &get_syndetics_editions($isbn);
92 my @syndetics_response;
93 for my $response (@$syndetics_preresponse) {
94 push @syndetics_response, {content => $response->{a}};
96 $syndetics_response = {isbn => \@syndetics_response};
99 $response->{isbn} = [ @{ $syndetics_response->{isbn} or [] }, @{ $thing_response->{isbn} or [] } ];
100 my @xisbns;
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 $response_data->{'content'} eq $isbn;
106 next if $isbn eq $response_data;
107 next if $unique_xisbns->{ $response_data->{content} };
108 $unique_xisbns->{ $response_data->{content} }++;
109 my $xbiblio= _get_biblio_from_xisbn($response_data->{content});
110 push @xisbns, $xbiblio if $xbiblio && $xbiblio->{biblionumber} ne $biblionumber;
112 if ( wantarray ) {
113 return (\@xisbns, $errors);
115 else {
116 return \@xisbns;
120 sub _get_url {
121 my ($url,$service_type) = @_;
122 my $ua = LWP::UserAgent->new(
123 timeout => 2
126 my $response = $ua->get($url);
127 if ($response->is_success) {
128 warn "WARNING could not retrieve $service_type $url" unless $response;
129 if ($response) {
130 my $xmlsimple = XML::Simple->new();
131 my $content = $xmlsimple->XMLin(
132 $response->content,
133 ForceArray => [ qw(isbn) ],
134 ForceContent => 1,
136 return $content;
138 } else {
139 warn "WARNING: URL Request Failed " . $response->status_line . "\n";
145 __END__
147 =head1 NOTES
149 =cut
151 =head1 AUTHOR
153 Joshua Ferraro <jmf@liblime.com>
155 =cut