From 1197640d0dca8791f5ca163695d27a8450b73328 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Tue, 18 Nov 2014 14:31:33 -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 ea8d7578e..6e846118f 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_usernum = ? OR 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; % % -- 2.11.0