"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;