# or new FS::pkg_svc ( { 'pkgpart' => $cust_pkg->pkgpart,
# 'svcpart' => $self->svcpart,
# 'quantity' => 0 } );
+ my $quantity = $pkg_svc ? $pkg_svc->quantity : 0;
my @cust_svc = qsearch('cust_svc', {
'pkgnum' => $self->pkgnum,
});
return "Already ". scalar(@cust_svc). " ". $part_svc->svc.
" services for pkgnum ". $self->pkgnum
- if scalar(@cust_svc) >= $pkg_svc->quantity;
+ if scalar(@cust_svc) >= $quantity;
}
''; #no error
FROM radacct
WHERE UserName = ?
AND $str2time AcctStartTime ) >= ?
+ AND $str2time AcctStartTime ) < ?
AND ( ? - $str2time AcctStartTime ) ) < 86400
AND ( $str2time AcctStopTime ) = 0
OR AcctStopTime IS NULL )";
$sth = $dbh->prepare($query) or die $dbh->errstr;
- $sth->execute($end, $username, $start, $end)
+ $sth->execute($end, $username, $start, $end, $end)
or die $sth->errstr. " executing query $query";
my $start_during = $sth->fetchrow_arrayref->[0];