cataloguing/value_builder/stocknumber.pl

   1 #!/usr/bin/perl
   2
   3 # Converted to new plugin style (Bug 13437)
   4
   5 # Copyright 2000-2002 Katipo Communications
   6 #
   7 # This file is part of Koha.
   8 #
   9 # Koha is free software; you can redistribute it and/or modify it
  10 # under the terms of the GNU General Public License as published by
  11 # the Free Software Foundation; either version 3 of the License, or
  12 # (at your option) any later version.
  13 #
  14 # Koha is distributed in the hope that it will be useful, but
  15 # WITHOUT ANY WARRANTY; without even the implied warranty of
  16 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17 # GNU General Public License for more details.
  18 #
  19 # You should have received a copy of the GNU General Public License
  20 # along with Koha; if not, see <http://www.gnu.org/licenses>.
  21
  22 use Modern::Perl;
  23 use C4::Context;
  24
  25 my $builder = sub {
  26     my ( $params ) = @_;
  27     my $function_name = $params->{id};
  28     my $dbh = $params->{dbh};
  29
  30         my $branchcode = C4::Context->userenv->{'branch'};
  31
  32         my $query = "SELECT MAX(CAST(SUBSTRING_INDEX(stocknumber,'_',-1) AS SIGNED))+1 FROM items WHERE homebranch = ? AND stocknumber LIKE ?";
  33         my $sth=$dbh->prepare($query);
  34
  35         $sth->execute($branchcode,$branchcode."_%");
  36         my ($nextnum) = $sth->fetchrow;
  37         $nextnum = $branchcode.'_'.$nextnum;
  38
  39     my $js  = <<END_OF_JS;
  40 <script type="text/javascript">
  41 //<![CDATA[
  42
  43 function Focus$function_name(id, force) {
  44     if (\$('#' + id).val() == '' || force) {
  45         \$('#' + id).val('$nextnum');
  46     }
  47 }
  48
  49 function Click$function_name(event) {
  50     Focus$function_name(event.data.id, 1);
  51     return false;
  52 }
  53 //]]>
  54 </script>
  55 END_OF_JS
  56     return $js;
  57 };
  58
  59 return { builder => $builder };