From: ivan <ivan>
Date: Sat, 13 Feb 2010 02:17:06 +0000 (+0000)
Subject: fix inventory item search w/customer classes
X-Git-Tag: root_of_svc_elec_features~468
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=a1ead42e90dd1f98a5cfd07fcbda7bdab23063f7

fix inventory item search w/customer classes
---

diff --git a/httemplate/search/inventory_item.html b/httemplate/search/inventory_item.html
index 06b084745..3f0288b6c 100644
--- a/httemplate/search/inventory_item.html
+++ b/httemplate/search/inventory_item.html
@@ -79,7 +79,7 @@ die "access denied"
 my $classnum = $cgi->param('classnum');
 $classnum =~ /^(\d+)$/ or errorpage("illegal classnum $classnum");
 $classnum = $1;
-my $extra_sql = 'inventory_item.classnum = $classnum ';
+my $extra_sql = "WHERE inventory_item.classnum = $classnum ";
 
 my $inventory_class = qsearchs( {
   'table'     => 'inventory_class',
@@ -98,7 +98,7 @@ if ( $cgi->param('avail') ) {
 }
 
 my $count_query =
-  "SELECT COUNT(*) FROM inventory_item WHERE $extra_sql";
+  "SELECT COUNT(*) FROM inventory_item $extra_sql";
 
 my $link = sub {
   my $inventory_item = shift;