Revision aa4fda0e
Von Sven Schöling vor fast 9 Jahren hinzugefügt
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
oe.pl: Schnellsuche analog zu all:substr:multi::ilike