diff options
author | Ivan Kohler <ivan@freeside.biz> | 2014-11-18 14:32:02 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2014-11-18 14:32:02 -0800 |
commit | 6dc141f17f5d76d3ac74b705b7e1e27e2d28d2a7 (patch) | |
tree | 24313daf62dc08c7c80b8344ead0bf08b6bbafd5 | |
parent | dd553650db589f8155022da1a5c1fd647863c888 (diff) |
omit customers you don't have access to on the recent list
-rw-r--r-- | httemplate/index.html | 3 |
1 files changed, 2 insertions, 1 deletions
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; |