projekt kivitendo

    $where .= " AND a.taxzone_id = ?";

    push(@values, $form->{taxzone_id});

  }

  if ($form->{transaction_description}) {

    $where .= " AND a.transaction_description ILIKE ?";

    push(@values, like($form->{transaction_description}));

    $where .= " AND a.taxzone_id = ?";

    push(@values, $form->{taxzone_id});

  }

  foreach my $column (qw(invnumber ordnumber cusordnumber notes transaction_description shipvia shippingpoint)) {

    if ($form->{$column}) {

      $where .= " AND a.$column ILIKE ?";

  $::form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all_sorted;

  $::form->{ALL_TAXZONES}    = SL::DB::Manager::TaxZone   ->get_all_sorted;

  # constants and subs for template

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

  my @hidden_variables = map { "l_${_}" } @columns;

  push @hidden_variables, "l_subtotal", qw(open closed vendor invnumber ordnumber transaction_description notes project_id

                                           transdatefrom transdateto duedatefrom duedateto datepaidfrom datepaidto

  my $href = build_std_url('action=ap_transactions', grep { $form->{$_} } @hidden_variables);

  push @options, $locale->text('Date Paid') . " " . $locale->text('to')   . " " . $locale->date(\%myconfig, $form->{datepaidto},   1)     if ($form->{datepaidto});

  push @options, $locale->text('Open')                                                                   if ($form->{open});

  push @options, $locale->text('Closed')                                                                 if ($form->{closed});

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

                       'output_format'        => 'HTML',

  $form->{ALL_DEPARTMENTS}    = SL::DB::Manager::Department->get_all_sorted;

  $form->{ALL_BUSINESS_TYPES} = SL::DB::Manager::Business  ->get_all_sorted;

  $form->{ALL_TAXZONES}       = SL::DB::Manager::TaxZone   ->get_all_sorted;

  $form->{CT_CUSTOM_VARIABLES}                  = CVar->get_configs('module' => 'CT');

  ($form->{CT_CUSTOM_VARIABLES_FILTER_CODE},

  push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id

                                           transdatefrom transdateto duedatefrom duedateto datepaidfrom datepaidto

                                           employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed show_not_mailed

  push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;

  $href =  $params{want_binary_pdf} ? '' : build_std_url('action=ar_transactions', grep { $form->{$_} } @hidden_variables);

  if ($form->{transaction_description}) {

    push @options, $locale->text('Transaction description') . " : $form->{transaction_description}";

  }

  if ($form->{parts_partnumber}) {

    push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}";

  }

  'Payment / Delivery Options'  => 'Zahlungs- und Lieferoptionen',

  'Payment Date'                => 'Leistungsdatum',

  'Payment Reminder'            => 'Zahlungserinnerung',

  'Payment Terms'               => 'Zahlungsbedingungen',

  'Payment Terms missing in row ' => 'Zahlungsfrist fehlt in Zeile ',

  'Payment bookings disallowed. After the booking this record may be suggested with the amount of \'#1\' or otherwise has to be choosen manually. No automatic payment booking will be done to chart \'#2\'.' => 'Zahlungsbuchungen nicht erlaubt. Nach der Verbuchung kann dieser Beleg in der Vorschlagsliste mit dem Zahlungs-Betrag von \'#1\' erscheinen, ansonsten muss dieser manuell verknüpft werden. Es wird nicht automatisch eine Zahlungsbuchung auf das Konto \'#2\' durchgeführt.',

      <th>[% 'Steuersatz' | $T8 %]</th>

      <td>[% L.select_tag('taxzone_id', ALL_TAXZONES, with_empty=1, title_key='description', class="wi-normal") %]</td>

    </tr>

  </tbody>

</table>

          <th>[% 'Transaction description' | $T8 %]</th>

          <td>[% L.input_tag("transaction_description", "") %]</td>

        </tr>

        <tr>

          <th>[% 'Notes' | $T8 %]</th>

          <td>[% L.input_tag("notes", "") %]</td>

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

      <td>[% L.select_tag('taxzone_id', ALL_TAXZONES, with_empty=1, title_key='description', style=style) %]</td>

     </tr>

     <tr>

      <th align="right" nowrap>[% 'Transaction description' | $T8 %]</th>

      <td>[% L.input_tag("transaction_description", "", style=style) %]</td>

      <th align="right">[% 'Ship via' | $T8 %]</th>

      <td>[% L.input_tag("shipvia", "", style=style) %]</td>

     </tr>

     <tr>

      <th align="right">[% 'Project Number' | $T8 %]</th>

      <td>[% P.project.picker("project_id", project_id, active="both", valid="both", style=style) %]</td>