projekt kivitendo

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

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

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

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

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

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

  mtime                   => { type => 'timestamp' },

  netamount               => { type => 'numeric', precision => 15, scale => 5 },

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

  ordnumber               => { type => 'text', not_null => 1 },

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

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

    qq|  ct.${vc}number AS vcnumber, ct.country, ct.ustid, ct.business_id,  | .

    qq|  tz.description AS taxzone | .

    $periodic_invoices_columns .

    qq|FROM oe o | .

    qq|JOIN $vc ct ON (o.${vc}_id = ct.id) | .

    qq|LEFT JOIN employee e ON (o.employee_id = e.id) | .

    $query  .= qq| AND ${not} COALESCE(pcfg.active, 'f')|;

  }

  my $sortdir   = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';

  my $sortorder = join(', ', map { "${_} ${sortdir} " } ("o.id", $form->sort_columns("transdate", $ordnumber, "name")));

  my %allowed_sort_columns = (

         delivered = ?, proforma = ?, quotation = ?, department_id = ?, language_id = ?,

         taxzone_id = ?, shipto_id = ?, payment_id = ?, delivery_vendor_id = ?, delivery_customer_id = ?,delivery_term_id = ?,

         globalproject_id = ?, employee_id = ?, salesman_id = ?, cp_id = ?, transaction_description = ?, marge_total = ?, marge_percent = ?

       WHERE id = ?|;

  @values = ($form->{ordnumber} || '', $form->{quonumber},

             conv_i($form->{salesman_id}), conv_i($form->{cp_id}),

             $form->{transaction_description},

             $form->{marge_total} * 1, $form->{marge_percent} * 1,

             conv_i($form->{id}));

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

           d.description AS department, o.payment_id, o.language_id, o.taxzone_id,

           o.delivery_customer_id, o.delivery_vendor_id, o.proforma, o.shipto_id,

           o.globalproject_id, o.delivered, o.transaction_description, o.delivery_term_id

         FROM oe o

         JOIN ${vc} cv ON (o.${vc}_id = cv.id)

         LEFT JOIN employee e ON (o.employee_id = e.id)

     is_pur_ord      => scalar ($form->{type} =~ /purchase_order$/),

  );

  print $form->parse_html_template("oe/form_header", { %TMPL_VAR });

  $main::lxdebug->leave_sub();

  # constants and subs for template

  $form->{vc_keys}         = sub { "$_[0]->{name}--$_[0]->{id}" };

  $form->header();

  print $form->parse_html_template('oe/search', {

    "vcnumber",                "ustid",

    "country",                 "shippingpoint",

    "taxzone",

  );

  # only show checkboxes if gotten here via sales_order form.

  $form->{l_delivered}         = "Y"                     if ($form->{delivered} && $form->{notdelivered});

  $form->{l_periodic_invoices} = "Y"                     if ($form->{periodic_invoices_active} && $form->{periodic_invoices_inactive});

  my $attachment_basename;

  if ($form->{vc} eq 'vendor') {

    if ($form->{type} eq 'purchase_order') {

  push @hidden_variables, "l_subtotal", $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered ordnumber quonumber cusordnumber

                                                        transaction_description transdatefrom transdateto type vc employee_id salesman_id

                                                        reqdatefrom reqdateto projectnumber project_id periodic_invoices_active periodic_invoices_inactive

  my   @keys_for_url = grep { $form->{$_} } @hidden_variables;

  push @keys_for_url, 'taxzone_id' if $form->{taxzone_id} ne ''; # taxzone_id could be 0

    'periodic_invoices'       => { 'text' => $locale->text('Per. Inv.'), },

    'shippingpoint'           => { 'text' => $locale->text('Shipping Point'), },

    'taxzone'                 => { 'text' => $locale->text('Steuersatz'), },

  );

  foreach my $name (qw(id transdate reqdate quonumber ordnumber cusordnumber name employee salesman shipvia transaction_description shippingpoint taxzone)) {

    $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";

  }

  $form->{"l_type"} = "Y";

  map { $column_defs{$_}->{visible} = $form->{"l_${_}"} ? 1 : 0 } @columns;

    push @options, $locale->text('Steuersatz') . " : " . SL::DB::TaxZone->new(id => $form->{taxzone_id})->load->description;

  }

  $report->set_options('top_info_text'        => join("\n", @options),

                       'raw_top_info_text'    => $form->parse_html_template('oe/orders_top'),

                       'raw_bottom_info_text' => $form->parse_html_template('oe/orders_bottom', { 'SHOW_CONTINUE_BUTTON' => $allow_multiple_orders }),

  my $callback = $form->escape($href);

  my @subtotal_columns = qw(netamount amount marge_total marge_percent remaining_amount remaining_netamount);

  my %totals    = map { $_ => 0 } @subtotal_columns;

  my %subtotals = map { $_ => 0 } @subtotal_columns;

    $subtotals{marge_percent} = $subtotals{netamount} ? ($subtotals{marge_total} * 100 / $subtotals{netamount}) : 0;

    $totals{marge_percent}    = $totals{netamount}    ? ($totals{marge_total}    * 100 / $totals{netamount}   ) : 0;

    my $row = { };

  'Existing file on server'     => 'Auf dem Server existierende Datei',

  'Existing pending follow-ups for this item' => 'Noch nicht erledigte Wiedervorlagen für dieses Dokument',

  'Existing profiles'           => 'Existierende Profile',

  'Expected Tax'                => 'Erwartete Steuern',

  'Expense'                     => 'Aufwandskonto',

  'Expense Account'             => 'Aufwandskonto',

  'Expense/Asset'               => 'Aufwand/Anlagen',

  'Options'                     => 'Optionen',

  'Or download the whole Installation Documentation as PDF (350kB) for off-line study (currently in German Language): ' => 'Oder laden Sie die komplette Installationsbeschreibung als PDF (350kB) herunter: ',

  'Order'                       => 'Auftrag',

  'Order Date missing!'         => 'Auftragsdatum fehlt!',

  'Order Number missing!'       => 'Auftragsnummer fehlt!',

  'Order amount'                => 'Auftragswert',

  'Order deleted!'              => 'Auftrag gelöscht!',

  'Order/Item row name'         => 'Name der Auftrag-/Positions-Zeilen',

  'OrderItem'                   => 'Position',

  'Ordered'                     => 'Von Kunden bestellt',

  'Orders'                      => 'Aufträge',

  'Orders / Delivery Orders deleteable' => 'Aufträge / Lieferscheine löschbar',

                      [%- L.select_tag('globalproject_id', ALL_PROJECTS, title_key='projectnumber', default=globalproject_id, with_empty='1', onChange="document.getElementById('update_button').click();") %]

                    </td>

                  </tr>

                </table>

              </td>

            </tr>

       [% L.date_tag('reqdateto') %]

     </td>

    </tr>

    <tr>

     <th align="right">[% 'Include in Report' | $T8 %]</th>

     <td colspan="5">

         <label for="l_salesman">[% 'Salesman' | $T8 %]</label>

        </td>

       </tr>

       <tr>

        <td>

         <input name="l_remaining_amount" id="l_remaining_amount" class="checkbox" type="checkbox" value="Y">