diff options
author | Mark Wells <mark@freeside.biz> | 2015-02-23 19:13:33 -0800 |
---|---|---|
committer | Mark Wells <mark@freeside.biz> | 2015-02-23 19:13:33 -0800 |
commit | 8549f708d6eda70fbc7463db5dc24e00467e5547 (patch) | |
tree | ed4cbb2c3c23adc0af3ffff8139d9da540199c12 /FS | |
parent | 4363c9a6aac6d4d3918e355be80d9e86f8c8b641 (diff) |
silence a warning
Diffstat (limited to 'FS')
-rw-r--r-- | FS/FS/cust_bill_pkg.pm | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/FS/FS/cust_bill_pkg.pm b/FS/FS/cust_bill_pkg.pm index 2aa2a6fab..298e234ec 100644 --- a/FS/FS/cust_bill_pkg.pm +++ b/FS/FS/cust_bill_pkg.pm @@ -1014,10 +1014,12 @@ sub usage { my $sql = 'SELECT SUM(COALESCE(amount,0)) FROM cust_bill_pkg_detail '. ' WHERE billpkgnum = '. $self->billpkgnum; - if ($classnum =~ /^(\d+)$/) { - $sql .= " AND classnum = $1"; - } elsif (defined($classnum) and $classnum eq '') { - $sql .= " AND classnum IS NULL"; + if (defined $classnum) { + if ($classnum =~ /^(\d+)$/) { + $sql .= " AND classnum = $1"; + } elsif (defined($classnum) and $classnum eq '') { + $sql .= " AND classnum IS NULL"; + } } my $sth = dbh->prepare($sql) or die dbh->errstr; |