X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/c2715187a71c1ed09e14e71677b261e98e1e9fad..aaf1cc99f5da2a694b5cbbf2eeb13e8e29dbc334:/SL/AR.pm diff --git a/SL/AR.pm b/SL/AR.pm index 5fc6032a9..0aa4ff372 100644 --- a/SL/AR.pm +++ b/SL/AR.pm @@ -416,10 +416,12 @@ sub ar_transactions { qq| a.transaction_description, | . qq| pr.projectnumber AS globalprojectnumber, | . qq| c.name, | . - qq| e.name AS employee | . + qq| e.name AS employee, | . + qq| e2.name AS salesman | . qq|FROM ar a | . qq|JOIN customer c ON (a.customer_id = c.id) | . qq|LEFT JOIN employee e ON (a.employee_id = e.id) | . + qq|LEFT JOIN employee e2 ON (a.salesman_id = e2.id) | . qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id)|; my $where = "1 = 1";