X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fagent.pm;h=fc1d1a93e414fcc41f17f7a5cfee3635f9d3e2e9;hp=3d8e67739f04d864e6fb6747fca71e763497f57e;hb=b5fbaadb1cb2893660e460a1d4a3cabe02774de7;hpb=55a68e4aabe10db4d9c3ab1bb8befd2f9f4b9008 diff --git a/FS/FS/agent.pm b/FS/FS/agent.pm index 3d8e67739..fc1d1a93e 100644 --- a/FS/FS/agent.pm +++ b/FS/FS/agent.pm @@ -274,6 +274,7 @@ generated codes, or a scalar error message. =cut +#false laziness w/prepay_credit::generate sub generate_reg_codes { my( $self, $num, $pkgparts ) = @_; @@ -325,6 +326,22 @@ sub num_reg_code { $sth->fetchrow_arrayref->[0]; } +=item num_prepay_credit + +Returns the number of unused prepaid cards for this agent. + +=cut + +sub num_prepay_credit { + my $self = shift; + my $sth = dbh->prepare( + "SELECT COUNT(*) FROM prepay_credit WHERE agentnum = ?" + ) or die dbh->errstr; + $sth->execute($self->agentnum) or die $sth->errstr; + $sth->fetchrow_arrayref->[0]; +} + + =back =head1 BUGS