X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_main%2FSearch.pm;fp=FS%2FFS%2Fcust_main%2FSearch.pm;h=d8f620f9045102d0363b28380e808a0b1903c81b;hb=eaf1b3660fc8ce4436dae0b2e50545c563c6a8b5;hp=f799b519e4d096402c7c13e36be98ffffd9f3956;hpb=06e353b743e7be88afa8fce50ea10f27ebb7adef;p=freeside.git

diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm
index f799b519e..d8f620f90 100644
--- a/FS/FS/cust_main/Search.pm
+++ b/FS/FS/cust_main/Search.pm
@@ -646,6 +646,16 @@ sub search {
     if $params->{'with_email'};
 
   ##
+  # "with postal mail invoices" checkbox
+  ##
+
+  push @where,
+    "EXISTS ( SELECT 1 FROM cust_main_invoice
+                WHERE cust_main_invoice.custnum = cust_main.custnum
+                  AND dest = 'POST' )"
+    if $params->{'POST'};
+
+  ##
   # "without postal mail invoices" checkbox
   ##