From: ivan <ivan>
Date: Wed, 14 Feb 2007 01:43:19 +0000 (+0000)
Subject: fix up svc_www searching
X-Git-Tag: TRIXBOX_2_6~643
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=a5d36cfea18a4cdb756a9270587c15946a6fd1e5

fix up svc_www searching
---

diff --git a/httemplate/search/svc_www.cgi b/httemplate/search/svc_www.cgi
index d3b0549c4..d9332e95d 100755
--- a/httemplate/search/svc_www.cgi
+++ b/httemplate/search/svc_www.cgi
@@ -84,7 +84,7 @@ my $extra_sql =
     : '';
 
 
-my $count_query = 'SELECT COUNT(*) FROM svc_www';
+my $count_query = "SELECT COUNT(*) FROM svc_www $addl_from $extra_sql";
 my $sql_query = {
   'table'     => 'svc_www',
   'hashref'   => {},
@@ -94,7 +94,7 @@ my $sql_query = {
                    'cust_main.custnum',
                    FS::UI::Web::cust_sql_fields(),
                  ),
-  'extra_sql' => $orderby,
+  'extra_sql' => "$extra_sql $orderby",
   'addl_from' => $addl_from,
 };