projekt kivitendo

  'From this version on a new feature is available.' => 'Ab dieser Version ist ein neues Feature verfügbar.',

  'If you have not chosen for example the category revenue for a tax and you choose an revenue account to create a transfer in the general ledger, this tax will not be displayed in the tax dropdown.' => 'Wenn Sie z.B. die Kategory Erlös für eine Steuer nicht gewählt haben und ein Erlöskonto beim Erstellen einer Dialogbuchung wählen, wird diese Steuer auch nicht im Dropdown-Menü für die Steuern angezeigt.',

  'New filter for tax accounts' => 'Neue Filter für Steuerkonten',

  'Please choose for which categories the taxes should be displayed:' => 'Bitte wählen Sie für welche Kontoarten die Steuer angezeigt werden soll:',

  'Tax rate'                    => 'Steuersatz',

  'This feature especially prevents mistakes by mixing up prior tax and sales tax.' => 'Dieses Feature vermeidet insbesondere Verwechslungen von Umsatz- und Vorsteuer.',

  'You can choose account categories for taxes. Depending on these categories taxes will be displayed for transfers in the general ledger or not.' => 'Sie können Kontoarten für Steuern auswählen. Abhängig von diesen Kontoarten werden dann Steuern bei Dialogbuchungen angezeigt oder nicht.',

# @tag: steuerfilterung

# @description: Steuern in Dialogbuchungen filtern.

# @depends: release_3_0_0

package SL::DBUpgrade2::steuerfilterung;

use strict;

use utf8;

use parent qw(SL::DBUpgrade2::Base);

sub run {

  my ($self) = @_;

  if ( $::form->{'continued'} ) {

    my $update_query = qq|ALTER TABLE tax ADD chart_categories TEXT|;

    $self->db_query($update_query);

    my $categories;

    my $tax_id;

    foreach my $i (1 .. $::form->{rowcount}) {

      $tax_id = $::form->{"tax_id_$i"};

      $categories = '';

      $categories .= 'A' if $::form->{"asset_$i"};

      $categories .= 'L' if $::form->{"liability_$i"};

      $categories .= 'Q' if $::form->{"equity_$i"};

      $categories .= 'C' if $::form->{"costs_$i"};

      $categories .= 'I' if $::form->{"revenue_$i"};

      $categories .= 'E' if $::form->{"expense_$i"};

      $update_query = qq|UPDATE tax SET chart_categories = '$categories' WHERE id=$tax_id|;

      $self->db_query($update_query);

    }

    $update_query = qq|ALTER TABLE tax ALTER COLUMN chart_categories SET NOT NULL|;

    $self->db_query($update_query);

    $self->dbh->commit();

    return 1;

  }

  my $query = qq|SELECT taxkey, taxdescription, rate, id AS tax_id FROM tax order by taxkey, rate|;

  my $sth = $self->dbh->prepare($query);

  $sth->execute || $::form->dberror($query);

  $::form->{PARTS} = [];

  while (my $ref = $sth->fetchrow_hashref("NAME_lc")) {

    $ref->{rate} = $::form->format_amount(\%::myconfig, $::form->round_amount($ref->{rate} * 100));

    push @{ $::form->{PARTS} }, $ref;

  }

  &print_message;

  return 2;

} # end run

sub print_message {

  print $::form->parse_html_template("dbupgrade/steuerfilterung");

}

1;

[% USE T8 %]

[% USE HTML %]

[% USE L %]

<div class="listtop">[% 'New filter for tax accounts' | $T8 %]</div>

<form name="Form" method="post" action="login.pl">

<input type="hidden" name="action" value="login">

<input type="hidden" name="continued" value="1">

<p>[% 'From this version on a new feature is available.' | $T8 %]</p>

<p>[% 'You can choose account categories for taxes. Depending on these categories taxes will be displayed for transfers in the general ledger or not.' | $T8 %]</p>

<p>[% 'If you have not chosen for example the category revenue for a tax and you choose an revenue account to create a transfer in the general ledger, this tax will not be displayed in the tax dropdown.' | $T8 %]</p>

<p>[% 'This feature especially prevents mistakes by mixing up prior tax and sales tax.' | $T8 %]</p>

<p>[% 'Please choose for which categories the taxes should be displayed:' | $T8 %]</p>

<table>

  <tr>

    <th class="listheading">[% 'Taxkey' | $T8 %]</th>

    <th class="listheading">[% 'Description' | $T8 %]</th>

    <th class="listheading">[% 'Tax rate' | $T8 %]</th>

    <th class="listheading">[% 'Asset' | $T8 %] (A)</th>

    <th class="listheading">[% 'Liability' | $T8 %] (L)</th>

    <th class="listheading">[% 'Equity' | $T8 %] (Q)</th>

    <th class="listheading">[% 'Costs' | $T8 %] (C)</th>

    <th class="listheading">[% 'Revenue' | $T8 %] (I)</th>

    <th class="listheading">[% 'Expense' | $T8 %] (E)</th>

  </tr>

  [% SET row_odd = '1' %][% FOREACH row = PARTS %]

  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">

    <td align="right">[% HTML.escape(row.taxkey) %]</td>

    <td align="left"> [% HTML.escape(row.taxdescription) %]</a></td>

    <td align="right">[% HTML.escape(row.rate) %] %</td>

    <td align="center">[% IF row.taxkey == 0 or row.taxkey == 1 %]

                     [% L.checkbox_tag('asset_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]

                     [% ELSE %]

                     [% L.checkbox_tag('asset_' _ loop.count, value => 1, checked => 0, class => 'checkbox') %]

                     [% END %]</td>

    <td align="center">[% IF row.taxkey == 0 or row.taxkey == 1 %]

                     [% L.checkbox_tag('liability_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]

                     [% ELSE %]

                     [% L.checkbox_tag('liability_' _ loop.count, value => 1, checked => 0, class => 'checkbox') %]

                     [% END %]</td>

    <td align="center">[% IF row.taxkey == 0 or row.taxkey == 1 %]

                     [% L.checkbox_tag('equity_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]

                     [% ELSE %]

                     [% L.checkbox_tag('equity_' _ loop.count, value => 1, checked => 0, class => 'checkbox') %]

                     [% END %]</td>

    <td align="center">[% IF row.taxkey == 0 or row.taxkey == 1 %]

                     [% L.checkbox_tag('costs_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]

                     [% ELSE %]

                     [% L.checkbox_tag('costs_' _ loop.count, value => 1, checked => 0, class => 'checkbox') %]

                     [% END %]</td>

    <td align="center">[% IF row.taxkey == 8 or row.taxkey == 9 or row.taxkey == 18 or row.taxkey == 19%]

                     [% L.checkbox_tag('revenue_' _ loop.count, value => 1, checked => 0, class => 'checkbox') %]

                     [% ELSE %]

                     [% L.checkbox_tag('revenue_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]

                     [% END %]</td>

    <td align="center">[% IF row.taxkey == 2 or row.taxkey == 3 or row.taxkey == 10 or row.taxkey == 11 or row.taxkey == 12 or row.taxkey == 13 %]

                     [% L.checkbox_tag('expense_' _ loop.count, value => 1, checked => 0, class => 'checkbox') %]

                     [% ELSE %]

                     [% L.checkbox_tag('expense_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]

                     [% END %]</td>

  </tr>

  <input type="hidden" name="tax_id_[% loop.count %]" value="[% row.tax_id %]">

  [% SET rowcount = loop.count %]

  [% END %]

  <input type="hidden" name="rowcount" value="[% rowcount %]">

</table>

<input type="submit" value="[% 'Continue' | $T8 %]">

</form>