blob: 1bc2aa1b7d500167cda76cb976d934c22c93e7f0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
package FS::part_event::Condition::balance_credit_limit;
use strict;
use FS::cust_main;
use base qw( FS::part_event::Condition );
sub description { 'Customer is over credit limit'; }
sub condition {
my($self, $object) = @_;
my $cust_main = $self->cust_main($object);
my $over = $cust_main->credit_limit;
return 0 if !length($over); # if credit limit is null, no limit
$cust_main->balance > $over;
}
sub condition_sql {
my( $class, $table ) = @_;
my $balance_sql = FS::cust_main->balance_sql;
"(cust_main.credit_limit IS NULL OR
$balance_sql - cust_main.credit_limit > 0 )";
}
1;
|