3 # $Id: barcode.pl,v 1.1.2.2 2006/09/20 02:24:42 kados Exp $
5 # Copyright 2000-2002 Katipo Communications
7 # This file is part of Koha.
9 # Koha is free software; you can redistribute it and/or modify it under the
10 # terms of the GNU General Public License as published by the Free Software
11 # Foundation; either version 2 of the License, or (at your option) any later
14 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License along with
19 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
20 # Suite 330, Boston, MA 02111-1307 USA
29 plugin_parameters : other parameters added when the plugin is called by the dopop function
32 sub plugin_parameters {
33 my ($dbh,$record,$tagslib,$i,$tabloop) = @_;
39 plugin_javascript : the javascript function called when the user enters the subfield.
40 contain 3 javascript functions :
41 * one called when the field is entered (OnFocus). Named FocusXXX
42 * one called when the field is leaved (onBlur). Named BlurXXX
43 * one called when the ... link is clicked (<a href="javascript:function">) named ClicXXX
47 * a variable containing the 3 scripts.
48 the 3 scripts are inserted after the <input> in the html code
51 sub plugin_javascript {
52 my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_;
53 my $function_name= "barcode".(int(rand(100000))+1);
56 my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) =
60 if (length($mon)==1) {
63 if (length($mday)==1) {
66 if (length($hour)==1) {
69 if (length($min)==1) {
72 if (length($sec)==1) {
78 my ($tag,$subfield) = GetMarcFromKohaField("items.barcode");
79 my ($loctag,$locsubfield) = GetMarcFromKohaField("items.homebranch");
84 my $autoBarcodeType = C4::Context->preference("autoBarcode");
85 warn "Barcode type = $autoBarcodeType" if $DEBUG;
86 unless ($autoBarcodeType eq 'OFF' or !$autoBarcodeType) {
88 if ($autoBarcodeType eq 'annual') {
89 $query = "select max(cast( substring_index(barcode, '-',-1) as signed)) from items where barcode like ?";
90 my $sth=$dbh->prepare($query);
91 $sth->execute("$year%");
92 while (my ($count)= $sth->fetchrow_array) {
93 warn "Examining Record: $count" if $DEBUG;
94 $nextnum = $count if $count;
97 $nextnum = sprintf("%0*d", "4",$nextnum);
98 $nextnum = "$year-$nextnum";
100 for (i=0 ; i<document.f.field_value.length ; i++) {
101 if (document.f.tag[i].value == '$tag' && document.f.subfield[i].value == '$subfield') {
102 if (document.f.field_value[i].value == '') {
103 document.f.field_value[i].value = '$nextnum';
108 elsif ($autoBarcodeType eq 'incremental') {
109 # not the best, two catalogers could add the same barcode easily this way :/
110 $query = "select max(abs(barcode)) from items";
111 my $sth=$dbh->prepare($query);
113 while (my ($count)= $sth->fetchrow_array) {
118 for (i=0 ; i<document.f.field_value.length ; i++) {
119 if (document.f.tag[i].value == '$tag' && document.f.subfield[i].value == '$subfield') {
120 if (document.f.field_value[i].value == '') {
121 document.f.field_value[i].value = '$nextnum';
126 elsif ($autoBarcodeType eq 'hbyymmincr') { # Generates a barcode where hb = home branch Code, yymm = year/month catalogued, incr = incremental number, reset yearly -fbcit
127 $year = substr($year, -2);
128 $query = "SELECT MAX(CAST(SUBSTRING(barcode,7,4) AS signed)) FROM items WHERE barcode REGEXP ?";
129 my $sth=$dbh->prepare($query);
130 $sth->execute("^[a-zA-Z]{1,}$year");
131 while (my ($count)= $sth->fetchrow_array) {
132 $nextnum = $count if $count;
133 warn "Existing incremental number = $nextnum" if $DEBUG;
136 $nextnum = sprintf("%0*d", "4",$nextnum);
137 $nextnum = $year . $mon . $nextnum;
138 warn "New Barcode = $nextnum" if $DEBUG;
140 for (i=0 ; i<document.f.field_value.length ; i++) {
141 if (document.f.tag[i].value == '$loctag' && document.f.subfield[i].value == '$locsubfield') {
145 for (i=0 ; i<document.f.field_value.length ; i++) {
146 if (document.f.tag[i].value == '$tag' && document.f.subfield[i].value == '$subfield') {
147 if (document.f.field_value[i].value == '') {
148 document.f.field_value[i].value = document.f.field_value[fnum].value + '$nextnum';
156 <script type=\"text/javascript\">
159 //function Blur$function_name(index) {
163 function Focus$function_name(subfield_managed) {";
170 function Clic$function_name(subfield_managed) {";
179 # don't return a value unless we have the appropriate syspref set
180 return ($function_name,$res);
183 return ($function_name,"<script type=\"text/javascript\">function Focus$function_name() { return 0;}</script>");
189 plugin : the true value_builded. The screen that is open in the popup window.