"Fossies" - the Fresh Open Source Software Archive 
Member "koha-19.11.15/C4/Barcodes/ValueBuilder.pm" (23 Feb 2021, 3746 Bytes) of package /linux/misc/koha-19.11.15.tar.gz:
As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) Perl source code syntax highlighting (style:
standard) with prefixed line numbers and
code folding option.
Alternatively you can here
view or
download the uninterpreted source code file.
For more information about "ValueBuilder.pm" see the
Fossies "Dox" file reference documentation and the last
Fossies "Diffs" side-by-side code changes report:
20.05.05_vs_20.05.06.
1 #!/usr/bin/perl
2 #
3 # Copyright 2008-2010 Foundations Bible College
4 # Parts copyright 2012 C & P Bibliography Services
5 #
6 # This file is part of Koha.
7 #
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.
12 #
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.
17 #
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>.
20
21 package C4::Barcodes::ValueBuilder::incremental;
22 use C4::Context;
23 my $DEBUG = 0;
24
25 sub get_barcode {
26 my ($args) = @_;
27 my $nextnum;
28 # not the best, two catalogers could add the same barcode easily this way :/
29 my $query = "select max(abs(barcode)) from items";
30 my $sth = C4::Context->dbh->prepare($query);
31 $sth->execute();
32 while (my ($count)= $sth->fetchrow_array) {
33 $nextnum = $count;
34 }
35 $nextnum++;
36 return $nextnum;
37 }
38
39 1;
40
41 package C4::Barcodes::ValueBuilder::hbyymmincr;
42 use C4::Context;
43 my $DEBUG = 0;
44
45 sub get_barcode {
46 my ($args) = @_;
47 my $nextnum = 0;
48 my $year = substr($args->{year}, -2);
49 my $month = $args->{mon};
50 my $query = "SELECT MAX(CAST(SUBSTRING(barcode,-4) AS signed)) AS number FROM items WHERE barcode REGEXP ?";
51 my $sth = C4::Context->dbh->prepare($query);
52 $sth->execute("^[-a-zA-Z]{1,}$year$month");
53 while (my ($count)= $sth->fetchrow_array) {
54 $nextnum = $count if $count;
55 $nextnum = 0 if $nextnum == 9999; # this sequence only allows for cataloging 9999 items per month
56 warn "Existing incremental number = $nextnum" if $DEBUG;
57 }
58 $nextnum++;
59 $nextnum = sprintf("%0*d", "4",$nextnum);
60 $nextnum = $year . $month . $nextnum;
61 warn "New hbyymmincr Barcode = $nextnum" if $DEBUG;
62 my $scr = "
63 var form = document.getElementById('f');
64 if ( !form ) {
65 form = document.getElementById('serials_edit');
66 }
67 if ( !form ) {
68 form = document.getElementById('Aform');
69 }
70 for (i=0 ; i<form.field_value.length ; i++) {
71 if (form.tag[i].value == '$args->{loctag}' && form.subfield[i].value == '$args->{locsubfield}') {
72 fnum = i;
73 }
74 }
75 if (\$('#' + id).val() == '') {
76 \$('#' + id).val(form.field_value[fnum].value + '$nextnum');
77 }
78 ";
79 return $nextnum, $scr;
80 }
81
82
83 package C4::Barcodes::ValueBuilder::annual;
84 use C4::Context;
85 my $DEBUG = 0;
86
87 sub get_barcode {
88 my ($args) = @_;
89 my $nextnum;
90 my $query = "select max(cast( substring_index(barcode, '-',-1) as signed)) from items where barcode like ?";
91 my $sth=C4::Context->dbh->prepare($query);
92 $sth->execute($args->{year} . '-%');
93 while (my ($count)= $sth->fetchrow_array) {
94 warn "Examining Record: $count" if $DEBUG;
95 $nextnum = $count if $count;
96 }
97 $nextnum++;
98 $nextnum = sprintf("%0*d", "4",$nextnum);
99 $nextnum = "$args->{year}-$nextnum";
100 return $nextnum;
101 }
102
103 1;
104
105
106 =head1 Barcodes::ValueBuilder
107
108 This module is intended as a shim to ease the eventual transition from
109 having all barcode-related code in the value builder plugin .pl file
110 to using C4::Barcodes. Since the shift will require a rather significant
111 amount of refactoring, this module will return value builder-formatted
112 results, at first by merely running the code that was formerly in the
113 barcodes.pl value builder, but later by using C4::Barcodes.
114
115 =cut
116
117 1;