Revision 797ad4c5
Von Moritz Bunkus vor etwa 16 Jahren hinzugefügt
SL/Form.pm | ||
---|---|---|
sub _get_taxcharts {
|
||
$main::lxdebug->enter_sub();
|
||
|
||
my ($self, $dbh, $key) = @_;
|
||
my ($self, $dbh, $params) = @_;
|
||
|
||
my $key = "all_taxcharts";
|
||
my @where;
|
||
|
||
if (ref $params eq 'HASH') {
|
||
$key = $params->{key} if ($params->{key});
|
||
if ($params->{module} eq 'AR') {
|
||
push @where, 'taxkey NOT IN (8, 9, 18, 19)';
|
||
|
||
} elsif ($params->{module} eq 'AP') {
|
||
push @where, 'taxkey NOT IN (1, 2, 3, 12, 13)';
|
||
}
|
||
|
||
} elsif ($params) {
|
||
$key = $params;
|
||
}
|
||
|
||
$key = "all_taxcharts" unless ($key);
|
||
my $where = ' WHERE ' . join(' AND ', map { "($_)" } @where) if (@where);
|
||
|
||
my $query = qq|SELECT * FROM tax ORDER BY taxkey|;
|
||
my $query = qq|SELECT * FROM tax $where ORDER BY taxkey|;
|
||
|
||
$self->{$key} = selectall_hashref_query($self, $dbh, $query);
|
||
|
bin/mozilla/ap.pl | ||
---|---|---|
map({ push(@old_project_ids, $form->{"project_id_$_"})
|
||
if ($form->{"project_id_$_"}); } (1..$form->{"rowcount"}));
|
||
|
||
$form->get_lists("projects" => { "key" => "ALL_PROJECTS",
|
||
"all" => 0,
|
||
"old_id" => \@old_project_ids },
|
||
"charts" => { "key" => "ALL_CHARTS",
|
||
"transdate" => $form->{transdate} },
|
||
"taxcharts" => "ALL_TAXCHARTS");
|
||
$form->get_lists("projects" => { "key" => "ALL_PROJECTS",
|
||
"all" => 0,
|
||
"old_id" => \@old_project_ids },
|
||
"charts" => { "key" => "ALL_CHARTS",
|
||
"transdate" => $form->{transdate} },
|
||
"taxcharts" => { "key" => "ALL_TAXCHARTS",
|
||
"module" => "AP" },);
|
||
|
||
map({ $_->{link_split} = [ split(/:/, $_->{link}) ]; }
|
||
@{ $form->{ALL_CHARTS} });
|
bin/mozilla/ar.pl | ||
---|---|---|
map({ push(@old_project_ids, $form->{"project_id_$_"})
|
||
if ($form->{"project_id_$_"}); } (1..$form->{"rowcount"}));
|
||
|
||
$form->get_lists("projects" => { "key" => "ALL_PROJECTS",
|
||
"all" => 0,
|
||
"old_id" => \@old_project_ids },
|
||
"charts" => { "key" => "ALL_CHARTS",
|
||
"transdate" => $form->{transdate} },
|
||
"taxcharts" => "ALL_TAXCHARTS");
|
||
$form->get_lists("projects" => { "key" => "ALL_PROJECTS",
|
||
"all" => 0,
|
||
"old_id" => \@old_project_ids },
|
||
"charts" => { "key" => "ALL_CHARTS",
|
||
"transdate" => $form->{transdate} },
|
||
"taxcharts" => { "key" => "ALL_TAXCHARTS",
|
||
"module" => "AR" },);
|
||
|
||
map({ $_->{link_split} = [ split(/:/, $_->{link}) ]; }
|
||
@{ $form->{ALL_CHARTS} });
|
Auch abrufbar als: Unified diff
Bei Kreditorenbuchungen die Umsatzsteuer-Steuerschlüssel und bei Debitorenbuchungen die Vorsteuer-Steuerschlüssel nicht anzeigen.