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, |
Auch abrufbar als: Unified diff
oe.pl: Schnellsuche analog zu all:substr:multi::ilike