projekt kivitendo

  my $dbh = $form->dbconnect($myconfig);

  $query =

    qq|SELECT DISTINCT(cp_title) | .

      qq|cp_project = ?, | .

      qq|cp_privatphone = ?, | .

      qq|cp_privatemail = ?, | .

      qq|WHERE cp_id = ?|;

    @values = (

      $form->{cp_greeting},

      $form->{cp_privatphone},

      $form->{cp_privatemail},

      $form->{cp_birthday},

      $form->{cp_id}

      );

  } elsif ( $form->{cp_name} || $form->{cp_givenname} ) {

      qq|INSERT INTO contacts ( cp_cv_id, cp_greeting, cp_title, cp_givenname,  | .

      qq|  cp_name, cp_email, cp_phone1, cp_phone2, cp_abteilung, cp_fax, cp_mobile1, | .

      qq|  cp_mobile2, cp_satphone, cp_satfax, cp_project, cp_privatphone, cp_privatemail, | .

    @values = (

      $form->{id},

      $form->{cp_greeting},

      $form->{cp_project},

      $form->{cp_privatphone},

      $form->{cp_privatemail},

      );

  }

  do_query( $form, $dbh, $query, @values ) if ($query);

      qq|cp_privatphone = ?, | .

      qq|cp_privatemail = ?, | .

      qq|cp_birthday = ? | .

      qq|WHERE cp_id = ?|;

    @values = (

      $form->{cp_greeting},

      $form->{cp_privatphone},

      $form->{cp_privatemail},

      $form->{cp_birthday},

      $form->{cp_id}

      );

  } elsif ( $form->{cp_name} || $form->{cp_givenname} ) {

      qq|INSERT INTO contacts ( cp_cv_id, cp_greeting, cp_title, cp_givenname,  | .

      qq|  cp_name, cp_email, cp_phone1, cp_phone2, cp_abteilung, cp_fax, cp_mobile1, | .

      qq|  cp_mobile2, cp_satphone, cp_satfax, cp_project, cp_privatphone, cp_privatemail, | .

    @values = (

      $form->{id},

      $form->{cp_greeting},

    push(@queries, qq|SELECT

                        c.id, c.name, 0 AS customer_is_vendor,

                        c.street, c.zipcode, c.city,

                      FROM customer c

                      LEFT JOIN contacts ct ON (c.id = ct.cp_cv_id)

                      $c_filter|);

    push(@queries, qq|SELECT

                        v.id, v.name, 1 AS customer_is_vendor,

                        v.street, v.zipcode, v.city,

                      FROM vendor v

                      LEFT JOIN contacts ct ON (v.id = ct.cp_cv_id)

                      $v_filter|);

        while (<IN>) {

          print OUT $_;

        }

        close(OUT);

use SL::Common;

use SL::DBUtils;

use SL::DO;

use SL::MoreCommon;

use List::Util qw(min);

                                                    'trans_id' => $form->{vendor_id});

  map { $form->{"vc_cvar_$_->{name}"} = $_->{value} } @{ $custom_variables };

  $dbh->disconnect();

  $main::lxdebug->leave_sub();

use SL::Common;

use SL::DBUtils;

use SL::DO;

use SL::MoreCommon;

use SL::IC;

use Data::Dumper;

  # connect to database

  my $dbh = $form->dbconnect($myconfig);

  # get contact id, set it if nessessary

  $form->{cp_id} *= 1;

                                                    'trans_id' => $form->{customer_id});

  map { $form->{"vc_cvar_$_->{name}"} = $_->{value} } @{ $custom_variables };

  $dbh->disconnect;

  $main::lxdebug->leave_sub();

    $cov->{address} =~ s{^,}{}x;

    $cov->{address} =~ s{\ +}{\ }gx;

    $cov->{contact} =~ s{\ +}{\ }gx;

  }

  CT->get_contact(\%myconfig, \%$form);

  print $form->ajax_response_header(), join '__pjx__', map $form->{"cp_$_"},

  $lxdebug->leave_sub();

}

  'December'                    => 'Dezember',

  'Decimalplaces'               => 'Dezimalstellen',

  'Decrease'                    => 'Verringern',

  'Default Accounts'            => 'Standardkonten',

  'Default output medium'       => 'Standardausgabekanal',

  'Default printer'             => 'Standarddrucker',

  'Edit and delete a group'     => 'Gruppen bearbeiten und löschen',

  'Edit custom variable'        => 'Benutzerdefinierte Variable bearbeiten',

  'Edit file'                   => 'Datei bearbeiten',

  'Edit group '                 => 'Gruppe bearbeiten',

  'Edit group membership'       => 'Gruppenmitgliedschaften bearbeiten',

  'Edit groups'                 => 'Gruppen bearbeiten',

  'Full access to all functions' => 'Vollzugriff auf alle Funktionen',

  'GL Transaction'              => 'Dialogbuchung',

  'Gegenkonto'                  => 'Gegenkonto',

  'General Ledger'              => 'Finanzbuchhaltung',

  'General Ledger Corrections'  => 'Korrekturen im Hauptbuch',

  'General Ledger Transaction'  => 'Dialogbuchung',

  'German'                      => 'Deutsch',

  'Given Name'                  => 'Vorname',

  'Greeting'                    => 'Anrede',

  'Group'                       => 'Warengruppe',

  'Group Invoices'              => 'Rechnungen zusammenfassen',

  'Group Items'                 => 'Waren gruppieren',

  'The following users have been migrated into the authentication database:' => 'Die folgenden Benutzer wurden in die Authentifizierungsdatenbank migriert:',

  'The following warnings occured during an upgrade to the document templates:' => 'Die folgenden Warnungen traten während einer Aktualisierung der Dokumentenvorlagen auf:',

  'The formula needs the following syntax:<br>For regular article:<br>Variablename= Variable Unit;<br>Variablename2= Variable2 Unit2;<br>...<br>###<br>Variable + ( Variable2 / Variable )<br><b>Please be beware of the spaces in the formula</b><br>' => 'Die Formeln m&uuml;ssen in der folgenden Syntax eingegeben werden:<br>Bei normalen Artikeln:<br>Variablenname = Variable Einheit;<br>Variablenname2 = Variable2 Einheit2;<br>...<br>###<br>Variable + Variable2 * ( Variable - Variable2 )<br>Variablennamen und Einheiten d?rfen nur aus alphanumerischen Zeichen bestehen.<br>Es muss jeweils die Gesamte Zeile eingegeben werden',

  'The group has been added.'   => 'Die Gruppe wurde erfasst.',

  'The group has been deleted.' => 'Die Gruppe wurde gelöscht.',

  'The group has been saved.'   => 'Die Gruppe wurde gespeichert.',

  'eMail?'                      => 'eMail?',

  'ea'                          => 'St.',

  'emailed to'                  => 'gemailt an',

  'follow_up_list'              => 'wiedervorlageliste',

  'for'                         => 'für',

  'for Period'                  => 'f?r den Zeitraum',

  'list_of_receipts'            => 'zahlungseingaenge',

  'list_of_transactions'        => 'buchungsliste',

  'logout'                      => 'abmelden',

  'mark as paid'                => 'als bezahlt markieren',

  'master'                      => 'de',

  'missing'                     => 'Fehlbestand',

  'General Ledger'              => 'Finanzbuchhaltung',

  'General Ledger Corrections'  => 'Korrekturen im Hauptbuch',

  'General ledger and cash'     => 'Finanzbuchhaltung und Zahlungsverkehr',

  'Groups'                      => 'Warengruppen',

  'HTML Templates'              => 'HTML-Vorlagen',

  'History Search Engine'       => 'Historien Suchmaschine',

  'General Ledger'              => 'Finanzbuchhaltung',

  'General Ledger Corrections'  => 'Korrekturen im Hauptbuch',

  'General ledger and cash'     => 'Finanzbuchhaltung und Zahlungsverkehr',

  'Groups'                      => 'Warengruppen',

  'HTML Templates'              => 'HTML-Vorlagen',

  'History Search Engine'       => 'Historien Suchmaschine',

module=am.pl

action=list_language

[System--Printer]

module=menu.pl

action=acc_menu

             name       = 'shipto_id',

             id         = 'shipto_id',

             DATA       = SHIPTO,

             id_key     = 'shipto_id',

             label_sub  = 'shipto_label',

             label_key  = 'shipto_label',

             name       = 'cp_id',

             id         = 'cp_id',

             DATA       = CONTACTS,

             id_key     = 'cp_id',

             label_sub  = 'contacts_label',

       -%]

      </td>

     </tr>

     <tr>

      <th align="left" nowrap>Titel</th>

   [%- END %]

  </div>

             name       = 'shipto_id',

             id         = 'shipto_id',

             DATA       = SHIPTO,

             id_key     = 'shipto_id',

             label_sub  = 'shipto_label',

             label_key  = 'shipto_label',

             name       = 'cp_id',

             id         = 'cp_id',

             DATA       = CONTACTS,

             id_key     = 'cp_id',

             label_sub  = 'contacts_label',

       -%]

      </td>

     </tr>

     <tr>

      <th align="left" nowrap><translate>Title</translate></th>

   [%- END %]

  </div>