Bug 13948: DBRev 3.21.00.016
[koha.git] / cataloguing / value_builder / unimarc_field_010.pl
blobb913ab4cb0db9db5ae5c62bfea00dbb728cc1b57
1 #!/usr/bin/perl
4 # Copyright 2008 Biblibre SARL
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
21 use strict;
22 use warnings;
23 use C4::Auth;
24 use CGI qw ( -utf8 );
25 use C4::Context;
28 sub plugin_javascript {
29 my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_;
30 my $res="
31 <script type='text/javascript'>
32 function Blur$field_number() {
33 var isbn = document.getElementById('$field_number');
34 var url = '../cataloguing/plugin_launcher.pl?plugin_name=unimarc_field_010.pl&isbn=' + isbn.value;
35 var req = \$.get(url);
36 req.done(function(resp){
37 var elems = document.getElementsByTagName('input');
38 for( i = 0 ; elems[i] ; i++ )
40 if(elems[i].id.match(/^tag_210_subfield_c/)) {
41 elems[i].value = resp;
42 return 1;
45 });
46 return 1;
49 </script>
52 return ($field_number,$res);
55 sub plugin {
56 my ($input) = @_;
57 my $isbn = $input->param('isbn');
59 my ($template, $loggedinuser, $cookie)
60 = get_template_and_user({template_name => "cataloguing/value_builder/ajax.tt",
61 query => $input,
62 type => "intranet",
63 authnotrequired => 0,
64 flagsrequired => {editcatalogue => '*'},
65 debug => 1,
66 });
69 my $dbh = C4::Context->dbh;
70 my $len = 0;
71 my $sth = $dbh->prepare('SELECT publishercode FROM biblioitems WHERE REPLACE(isbn, "-", "") LIKE ? OR isbn LIKE ? LIMIT 1');
73 $isbn =~ s/-//g;
74 if (length ($isbn) == 13){
75 $isbn = substr($isbn, 3, length($isbn)-3);
78 if(length($isbn) <= 10){
80 $len = 5;
81 if ( substr( $isbn, 0, 1 ) <= 7 ){
82 $len = 1;
83 }elsif ( substr( $isbn, 0, 2 ) <= 94 ){
84 $len = 2;
85 }elsif ( substr( $isbn, 0, 3 ) <= 995 ){
86 $len = 3;
87 }elsif ( substr( $isbn, 0, 4 ) <= 9989 ){
88 $len = 4 ;
91 my $x = substr( $isbn, $len );
92 my $seg2 = "";
94 if ( substr( $x, 0, 2 ) <= 19 ) {
95 $seg2 = substr( $x, 0, 2 );
97 elsif ( substr( $x, 0, 3 ) <= 699 ) {
98 $seg2 = substr( $x, 0, 3 );
100 elsif ( substr( $x, 0, 4 ) <= 8399 ) {
101 $seg2 = substr( $x, 0, 4 );
103 elsif ( substr( $x, 0, 5 ) <= 89999 ) {
104 $seg2 = substr( $x, 0, 5 );
106 elsif ( substr( $x, 0, 6 ) <= 9499999 ) {
107 $seg2 = substr( $x, 0, 6 );
109 else {
110 $seg2 = substr( $x, 0, 7 );
113 while($len--){
114 $seg2 = "_".$seg2;
117 $len = 10 -length($seg2);
119 while($len--){
120 $seg2 .= "_";
123 $sth->execute($seg2, "978$seg2");
126 if( (my $publishercode) = $sth->fetchrow )
128 $template->param(return => $publishercode);
130 output_html_with_http_headers $input, $cookie, $template->output;