From 2339b763230e33505b8a5302acd32269fbfd9f7e Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sat, 14 Nov 2009 00:08:21 +0000
Subject: add invoice terms to advanced customer report.  dogfood.

---
 FS/FS/cust_main.pm | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'FS')

diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm
index d9b052859..2baf3ac16 100644
--- a/FS/FS/cust_main.pm
+++ b/FS/FS/cust_main.pm
@@ -8279,6 +8279,22 @@ sub search_sql {
 ;
   }
 
+  ###
+  # invoice terms
+  ###
+
+  if ( $params->{'invoice_terms'} =~ /^([\w ]+)$/ ) {
+    my $terms = $1;
+    if ( $1 eq 'NULL' ) {
+      push @where,
+        "( cust_main.invoice_terms IS NULL OR cust_main.invoice_terms = '' )";
+    } else {
+      push @where,
+        "cust_main.invoice_terms IS NOT NULL",
+        "cust_main.invoice_terms = '$1'";
+    }
+  }
+
   ##
   # amounts
   ##
-- 
cgit v1.2.1