projekt kivitendo

  }

  my $pg_select = $form->{l_pricegroup} ? qq|, pg.pricegroup as pricegroup | : '';

  my $query =

    qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .

    qq|  pt.description as payment | .

  $form->{CONTACTS} = selectall_hashref_query($form, $dbh, $query, $vc_id);

  # Only show default pricegroup for customer, not vendor, which is why this is outside the main query

  $dbh->disconnect();

                                 { name => 'greeting',          description => $::locale->text('Greeting')                        },

                                 { name => 'homepage',          description => $::locale->text('Homepage')                        },

                                 { name => 'iban',              description => $::locale->text('IBAN')                            },

                                 { name => 'language_id',       description => $::locale->text('Language (database ID)')          },

                                 { name => 'language',          description => $::locale->text('Language (name)')                 },

                                 { name => 'name',              description => $::locale->text('Name')                            },

  iban                      => { type => 'text' },

  id                        => { type => 'integer', not_null => 1, sequence => 'id' },

  itime                     => { type => 'timestamp', default => 'now()' },

  language                  => { type => 'text' },

  language_id               => { type => 'integer' },

  mandate_date_of_signature => { type => 'date' },

  obsolete                  => { type => 'boolean', default => 'false' },

  payment_id                => { type => 'integer' },

  phone                     => { type => 'text' },

  salesman_id               => { type => 'integer' },

  street                    => { type => 'text' },

  taxincluded               => { type => 'boolean' },

    key_columns => { payment_id => 'id' },

  },

  taxzone => {

    class       => 'SL::DB::TaxZone',

    key_columns => { taxzone_id => 'id' },

  my $i = 1;

  foreach my $pg (@{ $pricegroups }) {

    $form->{"pricegroup_id_$i"} = "$pg->{id}";

    $form->{"pricegroup_$i"}    = "$pg->{pricegroup}";

    $i++;

         c.id AS customer_id, c.name AS customer, c.discount as customer_discount, c.creditlimit,

         c.email, c.cc, c.bcc, c.language_id, c.payment_id, c.delivery_term_id,

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

         c.taxincluded_checked, c.direct_debit,

         b.discount AS tradediscount, b.description AS business

       FROM customer c

  my @prices    = $self->available_prices;

  my $customer  = $self->record->customer;

  return $best_price || ();

}

  # business

  $TMPL_VAR{business_label} = ($form->{vc} eq "customer" ? $locale->text('Customer type') : $locale->text('Vendor type'));

  my $credittext = $locale->text('Credit Limit exceeded!!!');

* In der Rechte-Tabelle auth.master_rights wurden alle Positionswerte mit 100

  multipliziert, um Lücken für neue Rechte zu schaffen.

* Es wird jetzt Postgres 9.1 vorausgesetzt um GIN Indizes zu verwenden. Wenn

  das auf dem Zielsystem absolut nicht möglich ist, muss das Upgradescript

  sql/Pg-Upgrade2/trigram_indices.sql deaktiviert oder entfernt werden.

  'Preferences saved!'          => 'Einstellungen gespeichert!',

  'Prefix for the new bins\' names' => 'Namenspräfix für die neuen Lagerplätze',

  'Preis'                       => 'Preis',

  'Prepare bank collection via SEPA XML' => 'Einzug via SEPA XML vorbereiten',

  'Prepare bank transfer via SEPA XML' => 'Überweisung via SEPA XML vorbereiten',

  'Prepayment'                  => 'Vorauszahlung',

  'Preferences saved!'          => '',

  'Prefix for the new bins\' names' => '',

  'Preis'                       => '',

  'Prepare bank collection via SEPA XML' => '',

  'Prepare bank transfer via SEPA XML' => '',

  'Prepayment'                  => '',

        <th align="right">[% 'Price group' | $T8 %]</th>

        <td>

        </td>

      [% END  %]

  <input type="hidden" name="closed" value="[% HTML.escape(closed) %]">

  <input type="hidden" name="convert_from_oe_ids" value="[% HTML.escape(convert_from_oe_ids) %]">

  <input type="hidden" name="currency" value="[% HTML.escape(currency) %]">

  <input type="hidden" name="discount" value="[% HTML.escape(discount) %]">

  <input type="hidden" name="dunning_amount" value="[% HTML.escape(dunning_amount) %]">

  <input type="hidden" name="email" value="[% HTML.escape(email) %]">

                 onChange      = "document.getElementById('update_button').click();" -%]

            <input type="button" value="[% 'Details (one letter abbreviation)' | $T8 %]" onclick="show_vc_details('[% vc | html %]')">

          </td>

          <input type="hidden" name="vendor_id" value="[% HTML.escape(vendor_id) %]">

          <input type="hidden" name="oldvendor" value="[% HTML.escape(oldvendor) %]">

          <input type="hidden" name="selectvendor" value="[% HTML.escape(selectvendor) %]">

                 allow_textbox = 1,

                 onChange      = "document.getElementById('update_button').click();" -%]

            <input type="button" value="[% 'Details (one letter abbreviation)' | $T8 %]" onclick="show_vc_details('[% HTML.escape(vc) %]')">

          <input type="hidden" name="customer_id" value="[% HTML.escape(customer_id) %]">

          <input type="hidden" name="oldcustomer" value="[% HTML.escape(oldcustomer) %]">

          <input type="hidden" name="selectcustomer" value="[% HTML.escape(selectcustomer) %]">