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