X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FBP.pm;h=266679575cdf3f0e6a52f18437a9b3cad314dab5;hb=7ab5a4f6d5d38a7e24f314bccbccb8f9beb95843;hp=e776954260e9d83aad493a0093abf390225a616b;hpb=54e4131e091831e00a861fe2c4f53e344b87ddca;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);