X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fustva.pl;h=db6995f89bf6d1a17a697faa5c1c2d6e67996f78;hb=abfa9bbd64d6cdd3c98f49ef6c8f4c16421707a8;hp=212c3815c2962a86ce8da339b1d2a05d25626d3d;hpb=963c504890e01b787eba0a81038092e7e0f3db03;p=kivitendo-erp.git diff --git a/bin/mozilla/ustva.pl b/bin/mozilla/ustva.pl index 212c3815c..db6995f89 100644 --- a/bin/mozilla/ustva.pl +++ b/bin/mozilla/ustva.pl @@ -1,4 +1,3 @@ -#!/bin/perl #===================================================================== # Lx-Office ERP # Copyright (c) 2004 by Udo Spallek, Aachen @@ -24,6 +23,8 @@ # German Tax authority Module and later ELSTER Interface #====================================================================== +use utf8; + require "bin/mozilla/common.pl"; #use strict; @@ -34,6 +35,8 @@ require "bin/mozilla/common.pl"; #our ($myconfig); #use CGI::Carp "fatalsToBrowser"; +use List::Util qw(first); + use SL::PE; use SL::RP; use SL::USTVA; @@ -88,20 +91,21 @@ sub report { $form->header; # Einlesen der Finanzamtdaten - USTVA->get_config($userspath, 'finanzamt.ini'); + my $ustva = USTVA->new(); + $ustva->get_config($userspath, 'finanzamt.ini'); # Hier Einlesen der user-config - # steuernummer entfernt für prerelease + # steuernummer entfernt für prerelease my @a = qw( - signature name company address businessnumber - tel fax email co_chief co_department + signature name company address businessnumber + tel fax email co_chief co_department co_custom1 co_custom2 co_custom3 co_custom4 co_custom5 - co_name1 co_name2 co_street co_street1 co_zip - co_city co_city1 co_country co_tel co_tel1 + co_name1 co_name2 co_street co_street1 co_zip + co_city co_city1 co_country co_tel co_tel1 co_tel2 co_fax co_fax1 co_email co_email1 - co_url co_url1 ustid duns co_bankname + co_url co_url1 ustid duns co_bankname co_bankname1 co_bankname2 co_bankname3 co_blz co_blz1 - co_blz2 co_blz3 co_accountnr co_accountnr1 co_accountnr2 + co_blz2 co_blz3 co_accountnr co_accountnr1 co_accountnr2 co_accountnr3 ); @@ -110,15 +114,15 @@ sub report { my $openings = $form->{FA_Oeffnungszeiten}; $openings =~ s/\\\\n/
/g; - my $company_given = ($form->{company} ne '') + my $company_given = ($form->{company} ne '') ? qq|

$form->{company}

\n| : qq|| + . qq|&level=Programm--Preferences">| . $locale->text('No Company Name given') . qq|!
|; # Anpassungen der Variablennamen auf pre 2.1.1 Namen - # klären, ob $form->{company_street|_address} gesetzt sind + # klären, ob $form->{company_street|_address} gesetzt sind if ($form->{address} ne '') { my $temp = $form->{address}; $temp =~ s/\n/
/; @@ -127,14 +131,14 @@ sub report { } - my $address_given = - ($form->{co_street} && ($form->{co_zip} || $form->{co_city})) + my $address_given = + ($form->{co_street} && ($form->{co_zip} || $form->{co_city})) ? qq|$form->{co_street}
| . qq|$form->{co_street1}
| . qq|$form->{co_zip} $form->{co_city}| : qq|| - . $locale->text('No Company Address given') + . qq|&level=Programm--Preferences">| + . $locale->text('No Company Address given') . qq|!\n|; $form->{co_email} = $form->{email} unless $form->{co_email}; @@ -142,17 +146,13 @@ sub report { $form->{co_fax} = $form->{fax} unless $form->{co_fax}; $form->{co_url} = $form->{urlx} unless $form->{co_url}; - my $taxnumber_given = ($form->{steuernummer} ne '') - ? qq|$form->{steuernummer}| - : qq|Keine Steuernummer hinterlegt!| - . qq|
|; + my $taxnumber_given = ($form->{steuernummer} ne '') ? $form->{steuernummer} : qq|Keine Steuernummer hinterlegt!
|; my $ustva_vorauswahl = &ustva_vorauswahl(); my @all_years = $form->all_years(\%myconfig); - my $select_year = qq||; } $lxdebug->leave_sub(); - + return $select_vorauswahl; } @@ -515,7 +515,7 @@ sub show_options { . qq|| . qq||; + . qq||; } #$format .= qq||; @@ -526,7 +526,7 @@ sub show_options { . $locale->text('Choose Outputformat') . qq|">$format |; $lxdebug->leave_sub(); - + return $show_options; } @@ -537,14 +537,15 @@ sub generate_ustva { # Aufruf von get_config zum Einlesen der Finanzamtdaten aus finanzamt.ini - USTVA->get_config($userspath, 'finanzamt.ini'); + my $ustva = USTVA->new(); + $ustva->get_config($userspath, 'finanzamt.ini'); # init some form vars my @anmeldungszeitraum = - qw('0401' '0402' '0403' - '0404' '0405' '0406' - '0407' '0408' '0409' - '0410' '0411' '0412' + qw('0401' '0402' '0403' + '0404' '0405' '0406' + '0407' '0408' '0409' + '0410' '0411' '0412' '0441' '0442' '0443' '0444'); foreach my $item (@anmeldungszeitraum) { @@ -565,7 +566,7 @@ sub generate_ustva { # # using dates in ISO-8601 format: yyyymmmdd for Postgres... # - + #yearly report if ($form->{period} eq "13") { $form->{fromdate} = "$form->{year}0101"; @@ -673,12 +674,12 @@ sub generate_ustva { }; } - # Kontrollvariable für die Templates + # Kontrollvariable für die Templates $form->{'year2007'} = ($form->{year} >= 2007 ) ? "1":"0"; # Get the USTVA - USTVA->ustva(\%myconfig, \%$form); + $ustva->ustva(\%myconfig, \%$form); # reformat Dates to dateformat $form->{fromdate} = $locale->date(\%myconfig, $form->{fromdate}, 0, 0, 0); @@ -751,26 +752,26 @@ sub generate_ustva { # Nation specific customisations # ################################ - + # Germany - + if ( $form->{coa} eq 'Germany-DATEV-SKR03EU' or $form->{coa} eq 'Germany-DATEV-SKR04EU') { - + # # Outputformat specific customisation's # - my @category_cent = USTVA->report_variables({ + my @category_cent = $ustva->report_variables({ myconfig => \%myconfig, form => $form, type => '', attribute => 'position', dec_places => '2', }); - + push @category_cent, qw(83 Z43 Z45 Z53 Z62 Z65 Z67); - my @category_euro = USTVA->report_variables({ + my @category_euro = $ustva->report_variables({ myconfig => \%myconfig, form => $form, type => '', @@ -789,7 +790,7 @@ sub generate_ustva { $form->{endbold} = "}"; $form->{br} = '\\\\'; - # Zahlenformatierung für Latex USTVA Formulare + # Zahlenformatierung für Latex USTVA Formulare foreach my $number (@category_euro) { $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '0', ''); @@ -803,7 +804,7 @@ sub generate_ustva { $form->{$number} =~ s/${decimal_comma}/~~/g; } - } elsif ( $form->{format} eq 'html') { # Formatierungen für HTML Ausgabe + } elsif ( $form->{format} eq 'html') { # Formatierungen für HTML Ausgabe $form->{IN} = $form->{type} . '.html'; $form->{padding} = "  "; @@ -815,7 +816,7 @@ sub generate_ustva { foreach $number (@category_cent) { $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '2', '0'); } - + foreach $number (@category_euro) { $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '0', '0'); } @@ -823,18 +824,18 @@ sub generate_ustva { } elsif ( $form->{format} eq 'elsterwinston' ) { $form->{IN} = 'winston.xml'; - + # # Build Winston filename # - + my $file = 'U'; # 1. char 'U' = USTVA $file .= $form->{period}; #4. and 5. char = year modulo 100 $file .= sprintf("%02d", $form->{year} % 100); #6. to 18. char = Elstersteuernummer #Beispiel: Steuernummer in Bayern - #111/222/33334 ergibt für UStVA Jan 2004: U01049111022233334 + #111/222/33334 ergibt für UStVA Jan 2004: U01049111022233334 $file .= $form->{elsterFFFF}; $file .= $form->{elstersteuernummer}; #file suffix @@ -843,8 +844,8 @@ sub generate_ustva { $form->{tmpfile} = "$userspath/$file"; $form->{attachment_filename} = $file; - - # Zahlenformatierung für Winston + + # Zahlenformatierung für Winston my $temp_numberformat = $myconfig{numberformat}; @@ -855,7 +856,7 @@ sub generate_ustva { foreach my $number (@category_cent) { $form->{$number} = ( $form->{$number} !=0 ) ? $form->format_amount(\%myconfig, $form->{$number}, '2', '') : ''; } - + foreach my $number (@category_euro) { $form->{$number} = ( $form->{$number} !=0 ) ? $form->format_amount(\%myconfig, $form->{$number}, '0', '') : ''; } @@ -869,26 +870,26 @@ sub generate_ustva { ); foreach my $kennziffer (@category_cent, @category_euro) { - + next if ( $kennziffer =~ m/Z\d\d/); next if ( $form->{$kennziffer} == 0 ); - + if (defined $winston_id_for{$kennziffer} ) { push(@{ $form->{id}}, $winston_id_for{$kennziffer}); } else { - push(@{ $form->{id}}, "Kz$kennziffer"); + push(@{ $form->{id}}, "Kz$kennziffer"); } push(@{ $form->{amount}}, $form->{$kennziffer}); - } + } } elsif ( $form->{format} eq 'elstertaxbird' ) { # Define serveral filenames $form->{IN} = 'taxbird.txb'; - $form->{attachment_filename} = "USTVA-" . $form->{period} + $form->{attachment_filename} = "USTVA-" . $form->{period} . sprintf("%02d", $form->{year} % 100) . ".txb"; - + $form->{attachment_filename} =~ s|.*/||; $form->{tmpfile} = "$userspath/" . $form->{attachment_filename}; @@ -903,7 +904,7 @@ sub generate_ustva { '43' => '14', '44' => '15', ); - + foreach my $quarter ( keys %periods ) { $form->{taxbird_period} = $periods{$quarter} if ( $form->{period} eq $quarter); } @@ -916,44 +917,25 @@ sub generate_ustva { } else { $form->header; USTVA::error( $locale->text('Wrong Period' )); - exit(0); - } - - my %lands = ( # Lx => taxbird # TODO: besser als array... - 'Baden Würtemberg' => '0', - 'Bayern' => '1', - 'Berlin' => '2', - 'Brandenburg' => '3', - 'Bremen' => '4', - 'Hamburg' => '5', - 'Hessen' => '6', - 'Mecklenburg Vorpommern' => '7', - 'Niedersachsen' => '8', - 'Nordrhein Westfalen' => '9', - 'Rheinland Pfalz' => '10', - 'Saarland' => '11', - 'Sachsen' => '12', - 'Sachsen Anhalt' => '13', - 'Schleswig Holstein' => '14', - 'Thüringen' => '15', - ); - foreach my $land ( keys %lands ){ - $form->{taxbird_land_nr} = $lands{$land} if ($form->{elsterland} eq $land ); + ::end_of_request(); } - + + my $tax_office = first { $_->{name} eq $form->{elsterland} } @{ $ustva->{tax_office_information} }; + $form->{taxbird_land_nr} = $tax_office->{taxbird_nr} if $tax_office; + $form->{co_zip} = $form->{co_city}; $form->{co_zip} =~ s/\D//g; $form->{co_city} =~ s/\d//g; $form->{co_city} =~ s/^\s//g; - + ($form->{co_phone_prefix}, $form->{co_phone}) = split("-", $form->{tel}); $form->{co_phone_prefix} =~ s/\s//g; $form->{co_phone} =~ s/\s//g; - + $form->{taxbird_steuernummer} = $form->{steuernummer}; # $form->{taxbird_steuernummer} =~ s/\D//g; $form->{taxbird_steuernummer} =~ s/\///; # ersten Querstrich ersetzen - + # Numberformatting for Taxbird my $temp_numberformat = $myconfig{numberformat}; # Numberformat must be '1000,00' for Taxbird ?! @@ -961,17 +943,17 @@ sub generate_ustva { foreach my $number (@category_cent) { $form->{$number} = ( $form->{$number} !=0 ) ? $form->format_amount(\%myconfig, $form->{$number}, '2', '') : ''; } - + foreach my $number (@category_euro) { $form->{$number} = ( $form->{$number} !=0 ) ? $form->format_amount(\%myconfig, $form->{$number}, '0', '') : ''; } # Re-set Numberformat $myconfig{numberformat} = $temp_numberformat; - + # push Kennziffern to <%foreach Array fo easyer # output in xml format. Thx to Moritz. my %taxbird_id_for = ( - + '511' => 'Kz51-calc', '861' => 'Kz86-calc', '971' => 'Kz97-calc', @@ -984,8 +966,8 @@ sub generate_ustva { 'Z65' => 'ust-sum+69', 'Z67' => 'ust-vz', ); - - + + for my $kennziffer (@category_cent, @category_euro) { next if ($kennziffer eq 'Z43'); @@ -994,28 +976,28 @@ sub generate_ustva { if (defined $taxbird_id_for{$kennziffer}) { push(@{ $form->{id}}, $taxbird_id_for{$kennziffer}); } else { - push(@{ $form->{id}}, "Kz$kennziffer"); + push(@{ $form->{id}}, "Kz$kennziffer"); } push(@{ $form->{amount}}, $form->{$kennziffer}); } - } - + } + } elsif ( $form->{format} eq '' ){ # No format error. $form->header; USTVA::error( $locale->text('Application Error. No Format given' ) . "!"); - exit(0); - + ::end_of_request(); + } else { # All other Formats are wrong $form->header; USTVA::error( $locale->text('Application Error. Wrong Format') . ": " . $form->{format} ); - exit(0); + ::end_of_request(); } - + } else # Outputformat for generic output { - my @category_cent = USTVA->report_variables({ + my @category_cent = $ustva->report_variables({ myconfig => \%myconfig, form => $form, type => '', @@ -1023,7 +1005,7 @@ sub generate_ustva { dec_places => '2', }); - my @category_euro = USTVA->report_variables({ + my @category_euro = $ustva->report_variables({ myconfig => \%myconfig, form => $form, type => '', @@ -1033,23 +1015,23 @@ sub generate_ustva { $form->{USTVA} = []; - if ( $form->{format} eq 'generic') { # Formatierungen für HTML Ausgabe - + if ( $form->{format} eq 'generic') { # Formatierungen für HTML Ausgabe + my $rec_ref = {}; for my $kennziffer (@category_cent, @category_euro) { $rec_ref = {}; $rec_ref->{id} = $kennziffer; $rec_ref->{amount} = $form->format_amount(\%myconfig, $form->{$kennziffer}, 2, '0'); - + $lxdebug->message($LXDebug::DEBUG, "Kennziffer $kennziffer: '$form->{$kennziffer}'" ); $lxdebug->dump($LXDebug::DEBUG, $rec_ref ); push @ { $form->{USTVA} }, $rec_ref; } - + } } - + if ( $form->{period} eq '13' and $form->{format} ne 'html') { $form->header; USTVA::info( @@ -1057,7 +1039,7 @@ sub generate_ustva { 'Yearly taxreport not yet implemented') . '!'); } - + $form->{templates} = $myconfig{templates}; $form->{templates} = "doc" if ( $form->{type} eq 'help' ); @@ -1072,7 +1054,7 @@ sub generate_ustva { print($form->parse_html_template('ustva/generic_taxreport', $template_ref)); } else - { + { $form->parse_template(\%myconfig, $userspath); @@ -1086,10 +1068,14 @@ sub config_step1 { $auth->assert('advance_turnover_tax_return'); +$form->{title} = $locale->text('Tax Office Preferences'); + # edit all taxauthority prefs $form->header; - USTVA->get_config($userspath, 'finanzamt.ini'); + + my $ustva = USTVA->new(); + $ustva->get_config($userspath, 'finanzamt.ini'); my $land = $form->{elsterland}; my $amt = $form->{elsterFFFF}; @@ -1098,7 +1084,7 @@ sub config_step1 { $form->{title} = $locale->text('Tax Office Preferences'); - my $select_tax_office = USTVA->fa_auswahl($land, $amt, &elster_hash()); + my $select_tax_office = $ustva->fa_auswahl($land, $amt, $ustva->query_finanzamt(\%myconfig, $form)); my $checked_accrual = q|checked="checked"| if ($form->{method} eq 'accrual'); my $checked_cash = q|checked="checked"| if ($form->{method} eq 'cash'); my $checked_monthly = "checked" if ($form->{FA_voranmeld} eq 'month'); @@ -1108,22 +1094,22 @@ sub config_step1 { my $_hidden_variables_ref; - my %_hidden_local_variables = ( + my %_hidden_local_variables = ( 'saved' => $locale->text('Check Details'), 'nextsub' => 'config_step2', 'warnung' => '0', ); foreach my $variable (keys %_hidden_local_variables) { - push @{ $_hidden_variables_ref }, + push @{ $_hidden_variables_ref }, { 'variable' => $variable, 'value' => $_hidden_local_variables{$variable} }; } my @_hidden_form_variables = qw( - FA_Name FA_Strasse FA_PLZ - FA_Ort FA_Telefon FA_Fax - FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach - FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1 + FA_Name FA_Strasse FA_PLZ + FA_Ort FA_Telefon FA_Fax + FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach + FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1 FA_BLZ_2 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten FA_Email FA_Internet steuernummer elsterland elstersteuernummer @@ -1131,18 +1117,18 @@ sub config_step1 { ); foreach my $variable (@_hidden_form_variables) { - push @{ $_hidden_variables_ref}, + push @{ $_hidden_variables_ref}, { 'variable' => $variable, 'value' => $form->{$variable} }; } -# Which COA is in use? - - USTVA->get_coa($form, \%myconfig); +# Which COA is in use? + + $ustva->get_coa($form, \%myconfig); - # hä? kann die weg? + # hä? kann die weg? my $steuernummer_new = ''; - # Variablen für das Template zur Verfügung stellen + # Variablen für das Template zur Verfügung stellen my $template_ref = { select_tax_office => $select_tax_office, checked_accrual => $checked_accrual, @@ -1151,9 +1137,9 @@ sub config_step1 { checked_quarterly => $checked_quarterly, checked_dauerfristverlaengerung => $checked_dauerfristverlaengerung, hidden_variables => $_hidden_variables_ref, - + }; - + # Ausgabe des Templates print($form->parse_html_template('ustva/config_step1', $template_ref)); @@ -1175,10 +1161,12 @@ sub config_step2 { my $elster_amt = ''; my $elsterFFFF = ''; my $elstersteuernummer = ''; - USTVA->get_config($userspath, 'finanzamt.ini') + + my $ustva = USTVA->new(); + $ustva->get_config($userspath, 'finanzamt.ini') if ($form->{saved} eq $locale->text('saved')); - # Auf Übergabefehler checken + # Auf Übergabefehler checken USTVA::info( $locale->text('Missing Tax Authoritys Preferences') . "\n" . $locale->text('USTVA-Hint: Tax Authoritys')) if ( $form->{elsterFFFF_new} eq 'Auswahl' @@ -1187,26 +1175,26 @@ sub config_step2 { . $locale->text('USTVA-Hint: Method')) if ($form->{method} eq ''); - # Klären, ob Variablen bereits befüllt sind UND ob veräderungen auf + # Klären, ob Variablen bereits befüllt sind UND ob veräderungen auf # der vorherigen Maske stattfanden: $change = 1(in der edit sub, # mittels get_config) my $change = $form->{elsterland} eq $form->{elsterland_new} && $form->{elsterFFFF} eq $form->{elsterFFFF_new} ? '0' : '1'; $change = '0' if ($form->{saved} eq $locale->text('saved')); - my $elster_init = &elster_hash(); + my $elster_init = $ustva->query_finanzamt(\%myconfig, $form); my %elster_init = %$elster_init; if ($change eq '1') { - # Daten ändern + # Daten ändern $elsterland = $form->{elsterland_new}; $elsterFFFF = $form->{elsterFFFF_new}; $form->{elsterland} = $elsterland; $form->{elsterFFFF} = $elsterFFFF; $form->{steuernummer} = ''; - + create_steuernummer(); # rebuild elster_amt @@ -1243,17 +1231,18 @@ sub config_step2 { my $steuernummer = $form->{steuernummer} if ($steuernummer eq ''); $form->{FA_Oeffnungszeiten} =~ s/\\\\n/\n/g; - - - my $input_steuernummer = USTVA->steuernummer_input( - $form->{elsterland}, + + $ustva->get_coa($form, \%myconfig); + + my $input_steuernummer = $ustva->steuernummer_input( + $form->{elsterland}, $form->{elsterFFFF}, $form->{steuernummer} ); $lxdebug->message(LXDebug::DEBUG1, qq|$input_steuernummer|); - + my $_hidden_variables_ref; @@ -1265,26 +1254,26 @@ sub config_step2 { 'steuernummer' => $stnr, 'lastsub' => 'config_step1', 'nextsub' => 'save', - + ); - + foreach my $variable (keys %_hidden_local_variables) { - push @{ $_hidden_variables_ref }, + push @{ $_hidden_variables_ref }, { 'variable' => $variable, 'value' => $_hidden_local_variables{$variable} }; } - + my @_hidden_form_variables = qw( - FA_steuerberater_name FA_steuerberater_street + FA_steuerberater_name FA_steuerberater_street FA_steuerberater_city FA_steuerberater_tel FA_voranmeld method - FA_dauerfrist FA_71 - elster - type elster_init + FA_dauerfrist FA_71 + elster + type elster_init saved callback ); foreach my $variable (@_hidden_form_variables) { - push @{ $_hidden_variables_ref}, + push @{ $_hidden_variables_ref}, { 'variable' => $variable, 'value' => $form->{$variable} }; } @@ -1295,7 +1284,7 @@ sub config_step2 { callback => $callback, hidden_variables => $_hidden_variables_ref, }; - + # Ausgabe des Templates print($form->parse_html_template('ustva/config_step2', $template_ref)); @@ -1364,19 +1353,19 @@ sub save { my @config = qw( elster elsterland elstersteuernummer steuernummer elsteramt elsterFFFF FA_Name FA_Strasse - FA_PLZ FA_Ort FA_Telefon FA_Fax - FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach FA_BLZ_1 + FA_PLZ FA_Ort FA_Telefon FA_Fax + FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1 FA_BLZ_2 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten FA_Email FA_Internet FA_voranmeld method FA_steuerberater_name FA_steuerberater_street FA_steuerberater_city FA_steuerberater_tel FA_71 FA_dauerfrist); - # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer + # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer if ($form->{elstersteuernummer} ne '000000000') { - + $form->{elster} = '1'; - + open my $ustvaconfig, ">", "$userspath/$filename" or $form->error("$filename : $!"); # create the config file @@ -1425,14 +1414,3 @@ sub back { $lxdebug->leave_sub(); } -sub elster_hash { - $lxdebug->enter_sub(); - - $auth->assert('advance_turnover_tax_return'); - - my $finanzamt = USTVA->query_finanzamt(\%myconfig, \%$form); - $lxdebug->leave_sub(); - return $finanzamt; -} - -