1 package FS::part_event::Condition::balance_under;
6 use base qw( FS::part_event::Condition );
8 sub description { 'Customer balance (under)'; }
12 'balance' => { 'label' => 'Balance under (or equal to)',
14 'value' => '0.00', #default
20 my($self, $object) = @_;
22 my $cust_main = $self->cust_main($object);
24 my $under = $self->option('balance');
25 $under = 0 unless length($under);
27 $cust_main->balance <= $under;
31 my( $class, $table ) = @_;
33 my $under = $class->condition_sql_option('balance');
35 my $balance_sql = FS::cust_main->balance_sql;
37 "$balance_sql <= CAST( $under AS DECIMAL(10,2) )";