X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FBP.pm;h=266679575cdf3f0e6a52f18437a9b3cad314dab5;hb=8e2065873b0e00dde437383bb22c57be508e331f;hp=e776954260e9d83aad493a0093abf390225a616b;hpb=4c996a3d4df205f272f6c6cb86c1cdfec1ade49d;p=kivitendo-erp.git diff --git a/SL/BP.pm b/SL/BP.pm index e77695426..266679575 100644 --- a/SL/BP.pm +++ b/SL/BP.pm @@ -180,8 +180,10 @@ sub get_spoolfiles { $query .= " AND lower(a.quonumber) LIKE '$quonumber'"; } - # $query .= " AND a.transdate >= '$form->{transdatefrom}'" if $form->{transdatefrom}; - # $query .= " AND a.transdate <= '$form->{transdateto}'" if $form->{transdateto}; + if ($form->{type} =~ /(invoice|sales_order|sales_quotation|packing_list|puchase_order|request_quotation)$/) { + $query .= " AND a.transdate >= '$form->{transdatefrom}'" if $form->{transdatefrom}; + $query .= " AND a.transdate <= '$form->{transdateto}'" if $form->{transdateto}; + } my @a = (transdate, $invnumber, name); my $sortorder = join ', ', $form->sort_columns(@a);