From 6dc141f17f5d76d3ac74b705b7e1e27e2d28d2a7 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Tue, 18 Nov 2014 14:32:02 -0800 Subject: [PATCH] omit customers you don't have access to on the recent list --- httemplate/index.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/httemplate/index.html b/httemplate/index.html index 29a3d73a3..7c21e4505 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -23,7 +23,8 @@ % "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) % WHERE ( history_action = 'insert' OR history_action = 'replace_new' ) % AND history_user = ? -% ORDER BY history_date desc LIMIT 1000" # LIMIT 10 +% AND ". $curuser->agentnums_sql( table=>'cust_main' ). +% " ORDER BY history_date desc LIMIT 1000" # LIMIT 10 % ) or die dbh->errstr; % % $sth->execute( getotaker() ) or die $sth->errstr; -- 2.11.0