X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/0e4da157188830a45e606285bca5d0ea668bbcf5..d93709bdf3f56b275ae120d8a0205e666bc62b9c:/SL/DO.pm diff --git a/SL/DO.pm b/SL/DO.pm index eb74e26c7..e764ac6c3 100644 --- a/SL/DO.pm +++ b/SL/DO.pm @@ -67,7 +67,8 @@ sub transactions { my $query = qq|SELECT dord.id, dord.donumber, dord.ordnumber, dord.cusordnumber, dord.transdate, dord.reqdate, - ct.${vc}number, ct.name, dord.${vc}_id, dord.globalproject_id, + ct.${vc}number, ct.name, ct.business_id, + dord.${vc}_id, dord.globalproject_id, dord.closed, dord.delivered, dord.shippingpoint, dord.shipvia, dord.transaction_description, dord.itime::DATE AS insertdate, pr.projectnumber AS globalprojectnumber, @@ -98,6 +99,11 @@ sub transactions { push @values, conv_i($form->{project_id}), conv_i($form->{project_id}); } + if ($form->{"business_id"}) { + push @where, qq|ct.business_id = ?|; + push @values, conv_i($form->{"business_id"}); + } + if ($form->{"${vc}_id"}) { push @where, qq|dord.${vc}_id = ?|; push @values, $form->{"${vc}_id"};