Revision 28457822
Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 42 | 42 |
use SL::CVar; |
| 43 | 43 |
use SL::DBUtils; |
| 44 | 44 |
use SL::DB; |
| 45 |
use SL::Util qw(trim); |
|
| 45 | 46 |
use Text::ParseWords; |
| 46 | 47 |
|
| 47 | 48 |
use strict; |
| ... | ... | |
| 244 | 245 |
push @values, $form->{create_zugferd_invoices};
|
| 245 | 246 |
} |
| 246 | 247 |
|
| 248 |
if ($form->{all_phonenumbers}) {
|
|
| 249 |
$where .= qq| AND (ct.phone ILIKE ? OR |
|
| 250 |
ct.fax ILIKE ? OR |
|
| 251 |
ct.id IN |
|
| 252 |
(SELECT cp_cv_id FROM contacts |
|
| 253 |
WHERE cp_phone1 ILIKE ? OR |
|
| 254 |
cp_phone2 ILIKE ? OR |
|
| 255 |
cp_fax ILIKE ? OR |
|
| 256 |
cp_mobile1 ILIKE ? OR |
|
| 257 |
cp_mobile2 ILIKE ? OR |
|
| 258 |
cp_satphone ILIKE ? OR |
|
| 259 |
cp_satfax ILIKE ? OR |
|
| 260 |
cp_privatphone ILIKE ? |
|
| 261 |
) |
|
| 262 |
)|; |
|
| 263 |
push @values, (like(trim($form->{all_phonenumbers})))x10;
|
|
| 264 |
} |
|
| 265 |
|
|
| 247 | 266 |
my ($cvar_where, @cvar_values) = CVar->build_filter_query('module' => 'CT',
|
| 248 | 267 |
'trans_id_field' => 'ct.id', |
| 249 | 268 |
'filter' => $form); |
Auch abrufbar als: Unified diff
Kunden-/Lieferantensuche: Suche nach allen entsprechenden Telefonnummern
- alle Telefonnummer-Felder in entweder Kunden- oder
Lieferantenstammdaten
- alle Telefonnummer-Felder in Ansprechpersonen