use strict;
require Exporter;
+use C4::Context;
use vars qw($VERSION @ISA @EXPORT);
# set the version for version checking
$VERSION = 0.01;
+=head1 NAME
+
+C4::Input - Miscellaneous sanity checks
+
+=head1 SYNOPSIS
+
+ use C4::Input;
+
+=head1 DESCRIPTION
+
+This module provides functions to see whether a given library card
+number or ISBN is valid.
+
+=head1 FUNCTIONS
+
+=over 2
+
+=cut
+
@ISA = qw(Exporter);
@EXPORT = qw(
- &checkflds &checkdigit &checkvalidisbn
+ &checkdigit &checkvalidisbn
+ &buildCGIsort
);
-
-sub checkflds {
- my ($env,$reqflds,$data) = @_;
- my $numrflds = @$reqflds;
- my @probarr;
- my $i = 0;
- while ($i < $numrflds) {
- if ($data->{@$reqflds[$i]} eq "") {
- push(@probarr, @$reqflds[$i]);
- }
- $i++
- }
- return (\@probarr);
-}
+# FIXME - This is never used.
+#sub checkflds {
+# my ($env,$reqflds,$data) = @_;
+# my $numrflds = @$reqflds;
+# my @probarr;
+# my $i = 0;
+# while ($i < $numrflds) {
+# if ($data->{@$reqflds[$i]} eq "") {
+# push(@probarr, @$reqflds[$i]);
+# }
+# $i++
+# }
+# return (\@probarr);
+#}
+
+=item checkdigit
+
+ $valid = &checkdigit($env, $cardnumber $nounique);
+
+Takes a card number, computes its check digit, and compares it to the
+checkdigit at the end of C<$cardnumber>. Returns a true value iff
+C<$cardnumber> has a valid check digit.
+
+C<$env> is ignored.
+
+=cut
+#'
sub checkdigit {
- my ($env,$infl) = @_;
- $infl = uc $infl;
- my @weightings = (8,4,6,3,5,2,1);
- my $sum;
- my $i = 1;
- my $valid = 0;
- # print $infl."<br>";
- while ($i <8) {
- my $temp1 = $weightings[$i-1];
- my $temp2 = substr($infl,$i,1);
- $sum = $sum + ($temp1*$temp2);
-# print "$sum $temp1 $temp2<br>";
- $i++;
- }
- my $rem = ($sum%11);
- if ($rem == 10) {
- $rem = "X";
- }
- #print $rem."<br>";
- if ($rem eq substr($infl,8,1)) {
- $valid = 1;
- }
- return $valid;
+
+ my ($env,$infl, $nounique) = @_;
+ $infl = uc $infl;
+
+
+ #Check to make sure the cardnumber is unique
+
+ #FIXME: We should make the error for a nonunique cardnumber
+ #different from the one where the checkdigit on the number is
+ #not correct
+
+ unless ( $nounique )
+ {
+ my $dbh=C4::Context->dbh;
+ my $query=qq{SELECT * FROM borrowers WHERE cardnumber=?};
+ my $sth=$dbh->prepare($query);
+ $sth->execute($infl);
+ my %results = $sth->fetchrow_hashref();
+ if ( $sth->rows != 0 )
+ {
+ return 0;
+ }
+ }
+ if (C4::Context->preference("checkdigit") eq "none") {
+ return 1;
+ }
+
+ my @weightings = (8,4,6,3,5,2,1);
+ my $sum;
+ my $i = 1;
+ my $valid = 0;
+
+ foreach $i (1..7) {
+ my $temp1 = $weightings[$i-1];
+ my $temp2 = substr($infl,$i,1);
+ $sum += $temp1 * $temp2;
+ }
+ my $rem = ($sum%11);
+ if ($rem == 10) {
+ $rem = "X";
+ }
+ if ($rem eq substr($infl,8,1)) {
+ $valid = 1;
+ }
+ return $valid;
} # sub checkdigit
+=item checkvalidisbn
+
+ $valid = &checkvalidisbn($isbn);
+
+Returns a true value iff C<$isbn> is a valid ISBN: it must be ten
+digits long (counting "X" as a digit), and must have a valid check
+digit at the end.
+
+=cut
+#'
#--------------------------------------
# Determine if a number is a valid ISBN number, according to length
# of 10 digits and valid checksum
sub checkvalidisbn {
- use strict;
- my ($q)=@_ ; # Input: ISBN number
-
- my $isbngood = 0; # Return: true or false
-
- $q=~s/x$/X/g; # upshift lower case X
- $q=~s/[^X\d]//g;
- $q=~s/X.//g;
- if (length($q)==10) {
- my $checksum=substr($q,9,1);
- my $isbn=substr($q,0,9);
- my $i;
- my $c=0;
- for ($i=0; $i<9; $i++) {
- my $digit=substr($q,$i,1);
- $c+=$digit*(10-$i);
- }
- $c=$c%11; # % is the modulus function
- ($c==10) && ($c='X');
- if ($c eq $checksum) {
- $isbngood=1;
- } else {
- $isbngood=0;
- }
- } else {
- $isbngood=0;
- } # if length good
-
- return $isbngood;
+ use strict;
+ my ($q)=@_ ; # Input: ISBN number
+
+ my $isbngood = 0; # Return: true or false
+
+ $q=~s/x$/X/g; # upshift lower case X
+ $q=~s/[^X\d]//g;
+ $q=~s/X.//g;
+
+ #return 0 if $q is not ten digits long
+ if (length($q)!=10) {
+ return 0;
+ }
+
+ #If we get to here, length($q) must be 10
+ my $checksum=substr($q,9,1);
+ my $isbn=substr($q,0,9);
+ my $i;
+ my $c=0;
+ for ($i=0; $i<9; $i++) {
+ my $digit=substr($q,$i,1);
+ $c+=$digit*(10-$i);
+ }
+ $c %= 11;
+ ($c==10) && ($c='X');
+ $isbngood = $c eq $checksum;
+ return $isbngood;
} # sub checkvalidisbn
-
+=item buildCGISort
+
+ $CGIScrollingList = &BuildCGISort($name string, $input_name string);
+
+Returns the scrolling list with name $input_name, built on authorised Values named $name.
+Returns NULL if no authorised values found
+
+=cut
+sub buildCGIsort {
+ use strict;
+ my ($name,$input_name,$data) = @_;
+ my $dbh=C4::Context->dbh;
+ my $query=qq{SELECT * FROM authorised_values WHERE category=? order by lib};
+ my $sth=$dbh->prepare($query);
+ $sth->execute($name);
+ my $CGISort;
+ if ($sth->rows>0){
+ my @values;
+ my %labels;
+ for (my $i =0;$i<=$sth->rows;$i++){
+ my $results = $sth->fetchrow_hashref;
+ push @values, $results->{authorised_value};
+ $labels{$results->{authorised_value}}=$results->{lib};
+ }
+ $CGISort= CGI::scrolling_list(
+ -name => $input_name,
+ -values => \@values,
+ -labels => \%labels,
+ -default=> $data,
+ -size => 1,
+ -multiple => 0);
+ }
+ $sth->finish;
+ return $CGISort;
+}
END { } # module clean-up code here (global destructor)
+
+1;
+__END__
+
+=back
+
+=head1 AUTHOR
+
+Koha Developement team <info@koha.org>
+
+=cut