From: Ivan Kohler Date: Tue, 18 Nov 2014 22:31:33 +0000 (-0800) Subject: omit customers you don't have access to on the recent list X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=1197640d0dca8791f5ca163695d27a8450b73328 omit customers you don't have access to on the recent list --- 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; % %