Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision aa4fda0e

Von Sven Schöling vor fast 9 Jahren hinzugefügt

  • ID aa4fda0ec21c0715f1d8af27efdd900af3dd4915
  • Vorgänger d88c278c
  • Nachfolger 23c5a950

oe.pl: Schnellsuche analog zu all:substr:multi::ilike

Unterschiede anzeigen:

SL/OE.pm
50 50
use SL::HTML::Restrict;
51 51
use SL::IC;
52 52
use SL::TransNumber;
53
use Text::ParseWords;
53 54

  
54 55
use strict;
55 56

  
......
285 286
    push @values, conv_date($form->{expected_billing_date_to});
286 287
  }
287 288

  
289
  if ($form->{all}) {
290
    my @tokens = parse_line('\s+', 0, $form->{all});
291
    # ordnumber quonumber customer.name vendor.name transaction_description
292
    $query .= qq| AND (
293
      o.ordnumber ILIKE ? OR
294
      o.quonumber ILIKE ? OR
295
      ct.name     ILIKE ? OR
296
      o.transaction_description ILIKE ?
297
    )| for @tokens;
298
    push @values, ("%$_%")x4 for @tokens;
299
  }
300

  
288 301
  my ($cvar_where, @cvar_values) = CVar->build_filter_query('module'         => 'CT',
289 302
                                                            'trans_id_field' => 'ct.id',
290 303
                                                            'filter'         => $form,
bin/mozilla/oe.pl
984 984
  push @options, $locale->text('Customer Order Number')   . " : $form->{cusordnumber}"                    if $form->{cusordnumber};
985 985
  push @options, $locale->text('Notes')                   . " : $form->{notes}"                           if $form->{notes};
986 986
  push @options, $locale->text('Transaction description') . " : $form->{transaction_description}"         if $form->{transaction_description};
987
  push @options, $locale->text('Quick Search')            . " : $form->{all}"                             if $form->{all};
987 988
  push @options, $locale->text('Shipping Point')          . " : $form->{shippingpoint}"                   if $form->{shippingpoint};
988 989
  if ( $form->{transdatefrom} or $form->{transdateto} ) {
989 990
    push @options, $locale->text('Order Date');
locale/de/all
2187 2187
  'Quarterly'                   => 'quartalsweise',
2188 2188
  'Query Type'                  => 'Art der Abfrage',
2189 2189
  'Queue'                       => 'Warteschlange',
2190
  'Quick Search'                => 'Schnellsuche',
2190 2191
  'Quick Searches that will be shown in the header in this client' => 'Schnellsuchen, die in der Kopfzeile in diesem Mandanten gezeigt werden sollen',
2191 2192
  'Quotation'                   => 'Angebot',
2192 2193
  'Quotation Date'              => 'Angebotsdatum',

Auch abrufbar als: Unified diff