From e75070ffcf15e537036e4685d2aabb0415eec6d3 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 23 Jul 2006 14:07:33 +0000 Subject: more work towards adding an "inactive" status - add it to the A/R report --- FS/FS/cust_main.pm | 21 ++++++++++++--------- 1 file changed, 12 insertions(+), 9 deletions(-) (limited to 'FS') diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index cbcf6cc51..2b9564442 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -3670,18 +3670,17 @@ Returns a hex triplet color string for this customer's status. =cut +use vars qw(%statuscolor); +%statuscolor = ( + 'prospect' => '7e0079', #'000000', #black? naw, purple + 'active' => '00CC00', #green + 'inactive' => '0000CC', #blue + 'suspended' => 'FF9900', #yellow + 'cancelled' => 'FF0000', #red +); sub statuscolor { my $self = shift; - - my %statuscolor = ( - 'prospect' => '7e0079', #'000000', #black? naw, purple - 'active' => '00CC00', #green - 'inactive' => '0000CC', #blue - 'suspended' => 'FF9900', #yellow - 'cancelled' => 'FF0000', #red - ); - $statuscolor{$self->status}; } @@ -3703,6 +3702,10 @@ $select_count_pkgs = "SELECT COUNT(*) FROM cust_pkg WHERE cust_pkg.custnum = cust_main.custnum"; +sub select_count_pkgs_sql { + $select_count_pkgs; +} + sub prospect_sql { " 0 = ( $select_count_pkgs ) "; } -- cgit v1.2.1