From a0dee868651cf16f600a63294d54fcd3ec3cf05a Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Sat, 4 Jan 2014 19:18:28 -0800 Subject: [PATCH] fix recent customer list for 4.x-style history_usernum --- httemplate/index.html | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/httemplate/index.html b/httemplate/index.html index d563fa0b2..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( $FS::CurrentUser::CurrentUser->username ) 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 }; -- 2.11.0