@@ -, +, @@
---------
is not a text file.
-- a horrible lack of validation and spamminess ensues.
a) One containing valid barcodes on each line
-- this file should trigger no errors.
b) A copy of the first with an extra line of >20 characters
(e.g. The Quick Red Fox Jumped Over The Brown Fence^A^B^C)
-- this file should trigger the singular error message case.
^A^B^C are actually CTRL-A,CTRL-B,CTRL-C, and it is left
as an exercise to the reader to add them to the line.
c) A copy of the second with the last line duplicated
-- this file should trigger the plural error message case.
---
.../prog/en/modules/tools/inventory.tt | 4 +++
tools/inventory.pl | 26 ++++++++++++++++++++
2 files changed, 30 insertions(+)
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt
@@ -96,6 +96,10 @@ $(document).ready(function(){
Inventory/Stocktaking
[% IF (moddatecount) %][% moddatecount %] items modified : datelastseen set to [% date | $KohaDates %]
[% END %]
[% IF (errorfile) %][% errorfile %] can't be opened
[% END %]
+ [% IF (err_length && err_length==1) %]There was 1 barcode that was too long.
[% END %]
+ [% IF (err_length && err_length>1) %]There were [% err_length %] barcodes that were too long.
[% END %]
+ [% IF (err_data && err_data==1) %]There was 1 barcode that contained at least one unprintable character.
[% END %]
+ [% IF (err_data && err_data>1) %]There were [% err_data %] barcodes that contained at least one unprintable character.
[% END %]
[% FOREACH error IN errorloop %]
[% error.barcode %]
--- a/tools/inventory.pl
+++ a/tools/inventory.pl
@@ -160,9 +160,35 @@ if ( $uploadbarcodes && length($uploadbarcodes) > 0 ) {
my $count = 0;
+ my @barcodes;
+
+ my $sth = $dbh->column_info(undef,undef,"items","barcode");
+ my $barcode_def = $sth->fetchall_hashref('COLUMN_NAME');
+ my $barcode_size = $barcode_def->{barcode}->{COLUMN_SIZE};
+ my $err_length=0;
+ my $err_data=0;
while (my $barcode=<$uploadbarcodes>){
$barcode =~ s/\r?\n$//;
next unless $barcode;
+ if (length($barcode)>$barcode_size) {
+ $err_length += 1;
+ }
+ if ($barcode =~ /[^[:print:]]/) { # Only printable characters allowed.
+ $err_data += 1;
+ }
+ next if length($barcode)>$barcode_size;
+ next if ( $barcode =~ /[^[:print:]]/ );
+ push @barcodes,$barcode;
+ }
+ if (! @barcodes) {
+ push @errorloop, {'barcode'=>'No valid barcodes!'};
+ $op=''; # force the initial inventory screen again.
+ }
+ else {
+ $template->param( err_length => $err_length,
+ err_data => $err_data );
+ }
+ foreach my $barcode (@barcodes) {
if ( $qwithdrawn->execute($barcode) && $qwithdrawn->rows ) {
push @errorloop, { 'barcode' => $barcode, 'ERR_WTHDRAWN' => 1 };
} else {
--