unless ! $self->referral_custnum
|| qsearchs( 'cust_main', { 'custnum' => $self->referral_custnum } );
unless ! $self->referral_custnum
|| qsearchs( 'cust_main', { 'custnum' => $self->referral_custnum } );
sub bill {
my( $self, %options ) = @_;
return '' if $self->payby eq 'COMP';
sub bill {
my( $self, %options ) = @_;
return '' if $self->payby eq 'COMP';
#? to avoid use of uninitialized value errors... ?
$cust_pkg->setfield('bill', '')
#? to avoid use of uninitialized value errors... ?
$cust_pkg->setfield('bill', '')
AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
AND ( cust_pkg.susp IS NULL OR cust_pkg.susp = 0 )
)
AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
AND ( cust_pkg.susp IS NULL OR cust_pkg.susp = 0 )
)
AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
)
AND 0 = ( SELECT COUNT(*) FROM cust_pkg
WHERE cust_pkg.custnum = cust_main.custnum
AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
)
AND 0 = ( SELECT COUNT(*) FROM cust_pkg
WHERE cust_pkg.custnum = cust_main.custnum
AND ( cust_pkg.susp IS NULL OR cust_pkg.susp = 0 )
AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
)
AND ( cust_pkg.susp IS NULL OR cust_pkg.susp = 0 )
AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
)