projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
250b4e9
)
fix inventory item search w/customer classes
author
ivan
<ivan>
Sat, 13 Feb 2010 02:17:06 +0000
(
02:17
+0000)
committer
ivan
<ivan>
Sat, 13 Feb 2010 02:17:06 +0000
(
02:17
+0000)
httemplate/search/inventory_item.html
patch
|
blob
|
history
diff --git
a/httemplate/search/inventory_item.html
b/httemplate/search/inventory_item.html
index
06b0847
..
3f0288b
100644
(file)
--- 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 $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',
my $inventory_class = qsearchs( {
'table' => 'inventory_class',
@@
-98,7
+98,7
@@
if ( $cgi->param('avail') ) {
}
my $count_query =
}
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;
my $link = sub {
my $inventory_item = shift;