projekt kivitendo

  my @apoe_filters         = qw(transdate);

  my @like_filters         = (@simple_filters, @invoice_oi_filters);

  my @all_columns          = (@simple_filters, @makemodel_filters, @apoe_filters, @project_filters, qw(serialnumber));

  my @oe_flags             = qw(bought sold onorder ordered rfq quoted);

  my @qsooqr_flags         = qw(invnumber ordnumber quonumber trans_id name module qty);

  my @deliverydate_flags   = qw(deliverydate);

    push @bind_vars, $form->{"partsgroup_id"};

  }

  foreach (@like_filters) {

    next unless $form->{$_};

    $form->{"l_$_"} = '1'; # show the column

  my $token_builder = $make_token_builder->(\%joins_needed);

     $form->{sort} = 'id' unless grep { $form->{"l_$_"} } grep { $form->{sort} eq $_ } @sort_cols; # sort by id if unknown or invisible column

  my $sort_order   = ($form->{revers} ? ' DESC' : ' ASC');

  my $order_clause = " ORDER BY " . $token_builder->($form->{sort}) . ($form->{revers} ? ' DESC' : ' ASC');