Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 28457822

Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt

  • ID 2845782278a036e4df7bd7eebf3ad041aaa846ec
  • Vorgänger cf5dfd1e
  • Nachfolger fa0c3334

Kunden-/Lieferantensuche: Suche nach allen entsprechenden Telefonnummern

- alle Telefonnummer-Felder in entweder Kunden- oder
Lieferantenstammdaten
- alle Telefonnummer-Felder in Ansprechpersonen

Unterschiede anzeigen:

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