X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Findex.html;h=342d88c773deff44020da5f34bc20750855078ab;hb=aa27998a04d946f9e4ae1b4985448208b3f2762d;hp=71926aa4ea5d8a47118f8ff690b0e259336ef406;hpb=a10c9fb8cece00fc3b996f56c61b6841e93c1551;p=freeside.git diff --git a/httemplate/index.html b/httemplate/index.html index 71926aa4e..342d88c77 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -17,11 +17,13 @@ % #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) % "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) % WHERE ( history_action = 'insert' OR history_action = 'replace_new' ) -% AND history_user = ? +% AND ( history_usernum = ? OR history_user = ? ) % ORDER BY history_date desc" # LIMIT 10 % ) or die dbh->errstr; % -% $sth->execute( getotaker() ) or die $sth->errstr; +% my $curuser = $FS::CurrentUser::CurrentUser; +% +% $sth->execute( $curuser->usernum, $curuser->username ) or die $sth->errstr; % % my %saw = (); % my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref }; @@ -46,7 +48,7 @@ % next unless $cust_main; - <% $cust_main->display_custnum %>: <% $cust_main->name %> + <% $cust_main->display_custnum %>: <% $cust_main->name |h %> % if ( $bgcolor eq $bgcolor1 ) {