X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/4e953c795c21e894ffa9e72840d663bc05e01179..f3d92ecc96f4cca27c79b1d60fbbccde1ce8d7c0:/SL/CT.pm diff --git a/SL/CT.pm b/SL/CT.pm index 606c46a49..a8ea84e36 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -44,7 +44,6 @@ use SL::CVar; use SL::DBUtils; use SL::FU; use SL::Notes; -use List::MoreUtils qw(true); sub get_tuple { $main::lxdebug->enter_sub(); @@ -705,7 +704,7 @@ sub search { $form->{sort} = $sortorder; my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC'; - if ($sortorder ne 'id' && 1 >= true { $form->{$_} } qw(l_ordnumber l_quonumber l_invnumber)) { + if ($sortorder ne 'id' && 1 >= scalar grep { $form->{$_} } qw(l_ordnumber l_quonumber l_invnumber)) { $sortorder = "lower($sortorder) ${sortdir}"; } else { $sortorder .= " ${sortdir}"; @@ -919,6 +918,7 @@ sub get_delivery { my $arap = $form->{db} eq "vendor" ? "ap" : "ar"; my $db = $form->{db} eq "customer" ? "customer" : "vendor"; + my $qty_sign = $form->{db} eq 'vendor' ? ' * -1 AS qty' : ''; my $where = " WHERE 1=1 "; my @values; @@ -940,7 +940,7 @@ sub get_delivery { push(@values, conv_date($form->{to})); } my $query = - qq|SELECT s.shiptoname, i.qty, | . + qq|SELECT s.shiptoname, i.qty $qty_sign, | . qq| ${arap}.id, ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | . qq| i.description, i.unit, i.sellprice, | . qq| oe.id AS oe_id | .