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); |
bin/mozilla/ct.pl | ||
---|---|---|
151 | 151 |
push @options, $locale->text('Contact') . " : $form->{contact}" if $form->{contact}; |
152 | 152 |
push @options, $locale->text('Number') . qq| : $form->{"$form->{db}number"}| if $form->{"$form->{db}number"}; |
153 | 153 |
push @options, $locale->text('E-mail') . " : $form->{email}" if $form->{email}; |
154 |
push @options, $locale->text('All phone numbers') . " : $form->{all_phonenumbers}" if $form->{all_phonenumbers}; |
|
154 | 155 |
push @options, $locale->text('Contact person (surname)') . " : $form->{cp_name}" if $form->{cp_name}; |
155 | 156 |
push @options, $locale->text('Billing/shipping address (city)') . " : $form->{addr_city}" if $form->{addr_city}; |
156 | 157 |
push @options, $locale->text('Billing/shipping address (zipcode)') . " : $form->{addr_zipcode}" if $form->{addr_zipcode}; |
... | ... | |
237 | 238 |
my @hidden_variables = ( qw( |
238 | 239 |
db status obsolete name contact email cp_name addr_street addr_zipcode |
239 | 240 |
addr_city addr_country addr_gln business_id salesman_id insertdateto insertdatefrom all |
241 |
all_phonenumbers |
|
240 | 242 |
), "$form->{db}number", |
241 | 243 |
map({ "cvar_$_->{name}" } @searchable_custom_variables), |
242 | 244 |
map({'cvar_'. $_->{name} .'_from'} grep({$_->{type} eq 'date'} @searchable_custom_variables)), |
locale/de/all | ||
---|---|---|
287 | 287 |
'All pay postings successfully imported.' => 'Alle Lohnbuchungen erfolgreich importiert.', |
288 | 288 |
'All payments have already been posted.' => 'Es wurden bereits alle Zahlungen verbucht.', |
289 | 289 |
'All payments must be posted before the payment list can be downloaded.' => 'Alle Zahlungen müssen verbucht werden, bevor die Zahlungsliste heruntergeladen werden kann.', |
290 |
'All phone numbers' => 'Alle Telefonnummern', |
|
290 | 291 |
'All price sources' => 'Alle Preisquellen', |
291 | 292 |
'All reports' => 'Alle Berichte (Kontenübersicht, Summen- u. Saldenliste, Erfolgsrechnung, GuV, BWA, Bilanz, Projektbuchungen)', |
292 | 293 |
'All the other clients will start with an empty set of WebDAV folders.' => 'Alle anderen Mandanten werden mit einem leeren Satz von Dokumenten-Ordnern ausgestattet.', |
locale/en/all | ||
---|---|---|
287 | 287 |
'All pay postings successfully imported.' => '', |
288 | 288 |
'All payments have already been posted.' => '', |
289 | 289 |
'All payments must be posted before the payment list can be downloaded.' => '', |
290 |
'All phone numbers' => '', |
|
290 | 291 |
'All price sources' => '', |
291 | 292 |
'All reports' => '', |
292 | 293 |
'All the other clients will start with an empty set of WebDAV folders.' => '', |
templates/webpages/ct/search.html | ||
---|---|---|
27 | 27 |
<th align="right" nowrap>[% 'E-mail' | $T8 %]</th> |
28 | 28 |
<td><input name="email" size="35"></td> |
29 | 29 |
</tr> |
30 |
<tr> |
|
31 |
<th align="right" nowrap>[% 'All phone numbers' | $T8 %]</th> |
|
32 |
<td><input name="all_phonenumbers" size="35"></td> |
|
33 |
</tr> |
|
30 | 34 |
<tr> |
31 | 35 |
<th align="right" nowrap>[% 'Contact person (surname)' | $T8 %]</th> |
32 | 36 |
<td><input name="cp_name" size="35"></td> |
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