X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/028a47070f1c96c07828b9c8e802be253224df4f..614534b99bf5ae2d63e5e2af5f15c1aca84f68d5:/SL/OE.pm diff --git a/SL/OE.pm b/SL/OE.pm index dad8e7540..dc29ffaa1 100644 --- a/SL/OE.pm +++ b/SL/OE.pm @@ -125,7 +125,7 @@ sub transactions { my $sortorder = join ', ', ("o.id", $form->sort_columns(transdate, $ordnumber, name)); - $sortorder = $form->{sort} unless $sortorder; + $sortorder = $form->{sort} if $form->{sort}; $query .= " AND lower($ordnumber) LIKE '$number'" if $form->{$ordnumber}; $query .= " AND o.transdate >= '$form->{transdatefrom}'" @@ -586,7 +586,7 @@ sub retrieve { my $query, @ids; # translate the ids (given by id_# and trans_id_#) into one array of ids, so we can join them later - map { push @ids, $form->{"trans_id_$_"} if ($form->{"id_$_"}) } (1 .. $form->{"rowcount"}); + map { push @ids, $form->{"trans_id_$_"} if ($form->{"id_$_"} and $form->{"trans_id_$_"}) } (1 .. $form->{"rowcount"}); # if called in multi id mode, and still only got one id, switch back to single id if ($form->{"rowcount"} and $#ids == 0) { @@ -662,9 +662,9 @@ sub retrieve { $ref = $sth->fetchrow_hashref(NAME_lc); map { $form->{$_} = $ref->{$_} } keys %$ref; - # destroy all entries for multiple ids that yield different information + # set all entries for multiple ids blank that yield different information while ($ref = $sth->fetchrow_hashref(NAME_lc)) { - map { undef $form->{$_} if ($ref->{$_} ne $form->{$_}) } keys %$ref; + map { $form->{$_} = '' if ($ref->{$_} ne $form->{$_}) } keys %$ref; } # if not given, fill transdate with current_date