X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fustva.pl;h=d7ef9caeb7a188d04a544ad2c65c0ddd4de9379b;hb=8c7e44938a661e035f62840e1e177353240ace5d;hp=5bb85b1336e7e948fb246e9e175cbd0252cc04a4;hpb=f575aa99b38c34c64deff0abfb87d820eca923dd;p=kivitendo-erp.git diff --git a/bin/mozilla/ustva.pl b/bin/mozilla/ustva.pl index 5bb85b133..d7ef9caeb 100644 --- a/bin/mozilla/ustva.pl +++ b/bin/mozilla/ustva.pl @@ -24,12 +24,12 @@ # German Tax authority Module and later ELSTER Interface #====================================================================== -require "$form->{path}/arap.pl"; +require "bin/mozilla/common.pl"; #use strict; #no strict 'refs'; #use diagnostics; -#use warnings FATAL=> 'all'; +#use warnings; # FATAL=> 'all'; #use vars qw($locale $form %myconfig); #our ($myconfig); #use CGI::Carp "fatalsToBrowser"; @@ -67,454 +67,166 @@ use SL::User; # $locale->text('Oct') # $locale->text('Nov') # $locale->text('Dec') + ############################# sub report { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + my $myconfig = \%myconfig; - use CGI; + $form->{title} = $locale->text('UStVA'); - $form->{kz10} = ''; #Berichtigte Anmeldung? Ja =1 + $form->{kz10} = ''; #Berichtigte Anmeldung? Ja =1 Nein=0 - # $accrual = ($eur) ? "" : "checked"; - # $cash = ($eur) ? "checked" : ""; - my $year = ''; - my $null = ''; - ($null, $null, $null, $null, $null, $year, $null, $null, $null) = - localtime(); - $year += 1900; + my $year = substr($form->datetonum($form->current_date(\%myconfig), \%myconfig ), + 0, 4); my $department = ''; local $hide = ''; $form->header; - print qq| - - -
{script}> - - - - - - - - - - - - - - -
$form->{title}
- - $department -|; - - # Hier Aufruf von get_config aus bin/mozilla/fa.pl zum # Einlesen der Finanzamtdaten - &get_config($userspath, 'finanzamt.ini'); - + USTVA->get_config($userspath, 'finanzamt.ini'); + # Hier Einlesen der user-config # steuernummer entfernt für prerelease - my @a = qw(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_tel2 - co_fax co_fax1 co_email co_email1 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_accountnr3); + my @a = qw( + 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_tel2 co_fax co_fax1 co_email co_email1 + 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_accountnr3 + ); map { $form->{$_} = $myconfig->{$_} } @a; - my $oeffnungszeiten = $form->{FA_Oeffnungszeiten}; - $oeffnungszeiten =~ s/\\\\n/
/g; - print qq| - - |; - - if ($form->{FA_Name} ne '') { - print qq| - - - |; + ]; + + # Which COA is in use? + + USTVA->get_coa($form, $myconfig); + + my $template_ref = { + openings => $openings, + company_given => $company_given, + address_given => $address_given, + taxnumber_given => $taxnumber_given, + taxnumber => $myconfig->{taxnumber}, + select_year => $select_year, + period_local => $period_local, + method_local => $method_local, + ustva_vorauswahl => $ustva_vorauswahl, + checkbox_kz_10 => $checkbox_kz_10, + tax_office_banks => $tax_office_banks_ref, + select_options => &show_options, + + }; + + print($form->parse_html_template('ustva/report', $template_ref)); - #}# end if report = ustva - - print qq| -
-
- - | . $locale->text('Firma') . qq| - - |; - if ($form->{company} ne '') { - print qq|

$form->{company}

\n|; - } else { - print qq| - {path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}> - | . $locale->text('Kein Firmenname hinterlegt!') . qq|
- |; - } - + my $openings = $form->{FA_Oeffnungszeiten}; + $openings =~ s/\\\\n/
/g; + + my $company_given = ($form->{company} ne '') + ? qq|

$form->{company}

\n| + : qq|| + . $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 - # - if ($form->{address} ne '') { my $temp = $form->{address}; $temp =~ s/\\n/
/; ($form->{co_street}, $form->{co_city}) = split("
", $temp); + $form->{co_city} =~ s/\\n//g; } - if ( $form->{co_street} ne '' - and ($form->{co_zip} ne '' - or $form->{co_city} ne '') ) { - print qq| - $form->{co_street}
- $form->{co_street1}
- $form->{co_zip} $form->{co_city}|; - } else { - print qq| - {path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}> - | . $locale->text('Keine Firmenadresse hinterlegt!') . qq|\n|; - } - $form->{co_email}=$form->{email} unless $form->{co_email}; - $form->{co_tel}=$form->{tel} unless $form->{co_tel}; - $form->{co_fax}=$form->{fax} unless $form->{co_fax}; - $form->{co_url}=$form->{urlx} unless $form->{co_url}; - - - print qq| -
-
- | . $locale->text('Tel.: ') . qq| - $form->{co_tel} -
- | . $locale->text('Fax.: ') . qq| - $form->{co_fax} -
-
- $form->{co_email} -
-
- | . $locale->text('Steuernummer: ') . qq| - |; - if ($form->{steuernummer} ne '') { - print qq|$form->{steuernummer}|; - } else { - print qq| - - Keine Steuernummer hinterlegt!
|; + my $address_given = + ($form->{co_street} ne '' + and ( + $form->{co_zip} ne '' + or $form->{co_city} ne '' + ) + ) + ? qq|$form->{co_street}
| + . qq|$form->{co_street1}
| + . qq|$form->{co_zip} $form->{co_city}| + : qq|| + . $locale->text('No Company Address given') + . qq|!\n|; + + $form->{co_email} = $form->{email} unless $form->{co_email}; + $form->{co_tel} = $form->{tel} unless $form->{co_tel}; + $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 $ustva_vorauswahl = &ustva_vorauswahl(); + + my @all_years = $form->all_years(\%myconfig); + + my $select_year = qq|  - | . $locale->text('Steuerberater/-in') . qq| - - - $form->{FA_steuerberater_name}
- $form->{FA_steuerberater_street}
- $form->{FA_steuerberater_city}
- Tel: $form->{FA_steuerberater_tel}
-
-
- |; - } - print qq| -
- - | . $locale->text('Voranmeldezeitraum') . qq| - - |; - &ustva_vorauswahl(); - - my @years = (); - if (not defined $form->{all_years}) { - - # accounting years if SQL-Ledger Version < 2.4.1 - # $year = $form->{year} * 1; - @years = sort { $b <=> $a } (2000 .. ($year+1)); - $form->{all_years} = \@years; - } - map { $form->{selectaccountingyear} .= qq|
- - 		-
- - | . $locale->text('Finanzamt') . qq| - -

$form->{FA_Name}

- |; - - #if ($form->{FA_Ergaenzung_Name ne ''}){ - # print qq| - # $form->{FA_Ergaenzung_Name}  - #
- # |; - #} - print qq| - $form->{FA_Strasse} -
- $form->{FA_PLZ}   $form->{FA_Ort} -
-
- | . $locale->text('Tel. : ') . qq| - $form->{FA_Telefon} -
- | . $locale->text('Fax. : ') . qq| - $form->{FA_Fax} -
-
- {steuernummer}:") - . qq|&body=| - . CGI::escape( - "Sehr geehrte Damen und Herren,\n\n\nMit freundlichen Grüßen\n\n") - . CGI::escape($form->{signature}) . qq|"> - $form->{FA_Email} - -
- - $form->{FA_Internet} - -
-
- | . $locale->text('Öffnungszeiten') . qq| -
- $oeffnungszeiten -
- |; - - my $FA_1 = - ( $form->{FA_BLZ_1} ne '' - && $form->{FA_Kontonummer_1} ne '' - && $form->{FA_Bankbezeichnung_1} ne ''); - my $FA_2 = - ( $form->{FA_BLZ_2} ne '' - && $form->{FA_Kontonummer_2} ne '' - && $form->{FA_Bankbezeichnung_oertlich} ne ''); - - if ($FA_1 && $FA_2) { - print qq| -
- | . $locale->text('Bankverbindungen') . qq| - - - - - -
- $form->{FA_Bankbezeichnung_1} -
- | . $locale->text('Konto: ') . qq| - $form->{FA_Kontonummer_1} -
- | . $locale->text('BLZ: ') . qq| - $form->{FA_BLZ_1} - 		- $form->{FA_Bankbezeichnung_oertlich} -
- | . $locale->text('Konto: ') . qq| - $form->{FA_Kontonummer_2} -
- | . $locale->text('BLZ: ') . qq| - $form->{FA_BLZ_2} -
-
|; - } elsif ($FA_1) { - print qq| -
- | . $locale->text('Bankverbindung') . qq| -
-
- $form->{FA_Bankbezeichnung_1} -
- | . $locale->text('Konto: ') . qq| - $form->{FA_Kontonummer_1} -
- | . $locale->text('BLZ: ') . qq| - $form->{FA_BLZ_1}
-
|; - } elsif ($FA_2) { - print qq| -
- | . $locale->text('Bankverbindung') . qq| -
-
- $form->{FA_Bankbezeichnung_oertlich} -
- | . $locale->text('Konto: ') . qq| - $form->{FA_Kontonummer_2} -
- | . $locale->text('BLZ: ') . qq| - $form->{FA_BLZ_2} - |; + $select_year .= qq||; + + my $_checked = ''; + $_checked = "checked" if ($form->{kz10} eq '1'); + my $checkbox_kz_10 = qq|| + . $locale->text('Amended Advance Turnover Tax Return'); + + my $method_local = ($form->{method} eq 'accrual') ? $locale->text('accrual') + : ($form->{method} eq 'cash') ? $locale->text('cash') + : ''; + + my $period_local = ( $form->{FA_voranmeld} eq 'month') ? $locale->text('month') + : ( $form->{FA_voranmeld} eq 'quarter') ? $locale->text('quarter') + : ''; + + my $tax_office_banks_ref = [ + { BLZ => $form->{FA_BLZ_1}, + Kontonummer => $form->{FA_Kontonummer_1}, + Bankbezeichnung => $form->{FA_Bankbezeichnung_1} + }, + { BLZ => $form->{FA_BLZ_2}, + Kontonummer => $form->{FA_Kontonummer_2}, + Bankbezeichnung => $form->{FA_Bankbezeichnung_oertlich} } - print qq| - -
-
-
- - | . $locale->text('Ausgabeformat') . qq| - - |; - - &show_options; - my $ausgabe = '1'; - print qq| -
- |; - - # Stichtag der nächsten USTVA berechnen - # - # ($stichtag, $tage_bis, $ical) = FA->stichtag($today[dd.mm.yyyy], - # $FA_dauerfrist[1,0], - # $FA_voranmeld[month, quarter]) - #$tmpdateform= $myconfig{dateformat}; - # $myconfig{dateformat}= "dd.mm.yyyy"; - # $form->{today} = $form->datetonum($form->current_date(\%myconfig), \%myconfig); - # ($stichtag, $description, $tage_bis, $ical) = FA::stichtag($form->{today}, $form->{FA_dauerfrist},$form->{FA_voranmeld}); - # $form->{today} = $form->date($stichtag, \%myconfig ); - #$myconfig{dateformat}= $tmpdateform; - - #print qq| - #
- #
- #
- # - #

$stichtag

- #

$description

- #

$form->{today}

- # - #
|; - - } else { - print qq| - 		-
- - | . $locale->text('Hinweise') . qq| - -

Die Ausgabefunktionen sind wegen unzureichender Voreinstellungen deaktiviert.

-

Hilfe:

-
    -
  • Wählen Sie im Administrationsmenü den momentanen Benutzer aus - (siehe Kopfzeile). Dort können Sie fehlende Firmenangaben bzw. - die Steuernummer ergänzen.
    • -
-
- |; - my $ausgabe = ''; - $hide = q|disabled="disabled"|; - } - - print qq| -
-
- -
- - - - - - - - - - - - -
- - - - - - - -
- |; - print qq| - - - |; $lxdebug->leave_sub(); } -############################# + sub help { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + # parse help documents under doc my $tmp = $form->{templates}; $form->{templates} = 'doc'; @@ -529,23 +241,36 @@ sub help { sub show { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + #&generate_ustva(); no strict 'refs'; $lxdebug->leave_sub(); - &{ $form->{nextsub} }; + call_sub($form->{"nextsub"}); use strict 'refs'; } sub ustva_vorauswahl { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + + my $select_vorauswahl; + #Aktuelles Datum zerlegen: - $locale->date(\%myconfig, $form->current_date(\%myconfig, '0', '0'), 0) =~ - /(\d\d).(\d\d).(\d\d\d\d)/; + my $date = $form->datetonum($form->current_date(\%myconfig), \%myconfig); #$locale->date($myconfig, $form->current_date($myconfig), 0)=~ /(\d\d).(\d\d).(\d\d\d\d)/; - $form->{day} = $1; - $form->{month} = $2; - $form->{year} = $3; + $form->{day} = substr($date, 6, 2); + $form->{month} = substr($date, 4, 2); + $form->{year} = substr($date, 0, 4); + $lxdebug->message(LXDebug::DEBUG1, qq| + Actual date from Database: $date\n + Actual year from Database: $form->{year}\n + Actual day from Database: $form->{day}\n + Actual month from Database: $form->{month}\n|); + my $sel = ''; my $yymmdd = ''; @@ -553,41 +278,39 @@ sub ustva_vorauswahl { #$form->{day}= '11'; #$form->{month}= '01'; #$form->{year}= 2004; - print qq| + $select_vorauswahl = qq| {day}> {month}> - |; + |; if ($form->{FA_voranmeld} eq 'month') { # Vorauswahl bei monatlichem Voranmeldungszeitraum - print qq| - |; + my $key = ''; foreach $key (sort keys %liste) { my $selected = ''; $selected = 'selected' if ($sel eq $key); - print qq| - - - |; + $select_vorauswahl .= qq| + + |; } - print qq||; + $select_vorauswahl .= qq||; } elsif ($form->{FA_voranmeld} eq 'quarter') { # Vorauswahl bei quartalsweisem Voranmeldungszeitraum - my %liste = ( 'A' => $locale->text('1. Quarter'), - 'B' => $locale->text('2. Quarter'), - 'C' => $locale->text('3. Quarter'), - 'D' => $locale->text('4. Quarter'), - '13' => $locale->text('Yearly'), - ); + my %liste = ('41' => $locale->text('1. Quarter'), + '42' => $locale->text('2. Quarter'), + '43' => $locale->text('3. Quarter'), + '44' => $locale->text('4. Quarter'), + '13' => $locale->text('Yearly'),); my $yy = $form->{year} * 10000; $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1; @@ -677,49 +399,49 @@ sub ustva_vorauswahl { SWITCH: { $yymmdd <= ($yy + 110 + $dfv) && do { $form->{year} = $form->{year} - 1; - $sel = 'D'; + $sel = '44'; last SWITCH; }; $yymmdd <= ($yy + 410 + $dfv) && do { - $sel = 'A'; + $sel = '41'; last SWITCH; }; $yymmdd <= ($yy + 710 + $dfv) && do { - $sel = 'B'; + $sel = '42'; last SWITCH; }; $yymmdd <= ($yy + 1010 + $dfv) && do { - $sel = 'C'; + $sel = '43'; last SWITCH; }; $yymmdd <= ($yy + 1231) && do { - $sel = 'D'; + $sel = '44'; }; } - print qq| + $select_vorauswahl .= qq|\n |; } else { # keine Vorauswahl bei Voranmeldungszeitraum - print qq||; + $select_vorauswahl .= qq||; } $lxdebug->leave_sub(); + + return $select_vorauswahl; } -sub config { - $lxdebug->enter_sub(); - edit(); - $lxdebug->leave_sub(); -} +#sub config { +# $lxdebug->enter_sub(); +# config_step1(); +# $lxdebug->leave_sub(); +#} sub debug { $lxdebug->enter_sub(); @@ -768,6 +492,8 @@ sub debug { sub show_options { $lxdebug->enter_sub(); + $auth->assert('advance_turnover_tax_return'); + # $form->{PD}{$form->{type}} = "selected"; # $form->{DF}{$form->{format}} = "selected"; # $form->{OP}{$form->{media}} = "selected"; @@ -776,12 +502,12 @@ sub show_options { my $media = qq| |; my $format = qq| |; - if ($latex) { + if ($latex_templates) { $format .= qq| |; } @@ -789,169 +515,189 @@ sub show_options { #$disabled='' if ($form->{elster} eq '1' ); if ($form->{elster} eq '1') { $format .= - qq||; + qq|| + . qq||; } #$format .= qq||; - print qq| + my $show_options = qq| $type $media + . $locale->text('Choose Outputformat') . qq|">$format |; $lxdebug->leave_sub(); + + return $show_options; } sub generate_ustva { $lxdebug->enter_sub(); - # Aufruf von get_config aus bin/mozilla/ustva.pl zum - # Einlesen der Finanzamtdaten aus finanzamt.ini + $auth->assert('advance_turnover_tax_return'); - get_config($userspath, 'finanzamt.ini'); + # Aufruf von get_config zum Einlesen der Finanzamtdaten aus finanzamt.ini - # form vars initialisieren + USTVA->get_config($userspath, 'finanzamt.ini'); + + # init some form vars my @anmeldungszeitraum = - qw('0401' '0402' '0403' '0404' '0405' '0405' '0406' '0407' '0408' '0409' '0410' '0411' '0412' '0441' '0442' '0443' '0444'); - my $item = ''; - foreach $item (@anmeldungszeitraum) { + qw('0401' '0402' '0403' + '0404' '0405' '0406' + '0407' '0408' '0409' + '0410' '0411' '0412' + '0441' '0442' '0443' '0444'); + + foreach my $item (@anmeldungszeitraum) { $form->{$item} = ""; } - if ($form->{reporttype} eq "custom") { #forgotten the year --> thisyear if ($form->{year} !~ m/^\d\d\d\d$/) { - $locale->date(\$myconfig, $form->current_date(\$myconfig), 0) =~ - /(\d\d\d\d)/; - $form->{year} = $1; + $form->{year} = substr( + $form->datetonum( + $form->current_date(\%myconfig), \%myconfig + ), + 0, 4); + $lxdebug->message(LXDebug::DEBUG1, + qq|Actual year from Database: $form->{year}\n|); } + # + # using dates in ISO-8601 format: yyyymmmdd for Postgres... + # + #yearly report - if ($form->{duetyp} eq "13") { - $form->{fromdate} = "1.1.$form->{year}"; - $form->{todate} = "31.12.$form->{year}"; + if ($form->{period} eq "13") { + $form->{fromdate} = "$form->{year}0101"; + $form->{todate} = "$form->{year}1231"; } #Quater reports - if ($form->{duetyp} eq "A") { - $form->{fromdate} = "1.1.$form->{year}"; - $form->{todate} = "31.3.$form->{year}"; + if ($form->{period} eq "41") { + $form->{fromdate} = "$form->{year}0101"; + $form->{todate} = "$form->{year}0331"; $form->{'0441'} = "X"; } - if ($form->{duetyp} eq "B") { - $form->{fromdate} = "1.4.$form->{year}"; - $form->{todate} = "30.6.$form->{year}"; + if ($form->{period} eq "42") { + $form->{fromdate} = "$form->{year}0401"; + $form->{todate} = "$form->{year}0630"; $form->{'0442'} = "X"; } - if ($form->{duetyp} eq "C") { - $form->{fromdate} = "1.7.$form->{year}"; - $form->{todate} = "30.9.$form->{year}"; + if ($form->{period} eq "43") { + $form->{fromdate} = "$form->{year}0701"; + $form->{todate} = "$form->{year}0930"; $form->{'0443'} = "X"; } - if ($form->{duetyp} eq "D") { - $form->{fromdate} = "1.10.$form->{year}"; - $form->{todate} = "31.12.$form->{year}"; + if ($form->{period} eq "44") { + $form->{fromdate} = "$form->{year}1001"; + $form->{todate} = "$form->{year}1231"; $form->{'0444'} = "X"; } #Monthly reports SWITCH: { - $form->{duetyp} eq "01" && do { - $form->{fromdate} = "1.1.$form->{year}"; - $form->{todate} = "31.1.$form->{year}"; + $form->{period} eq "01" && do { + $form->{fromdate} = "$form->{year}0101"; + $form->{todate} = "$form->{year}0131"; $form->{'0401'} = "X"; last SWITCH; }; - $form->{duetyp} eq "02" && do { - $form->{fromdate} = "1.2.$form->{year}"; + $form->{period} eq "02" && do { + $form->{fromdate} = "$form->{year}0201"; #this works from 1901 to 2099, 1900 and 2100 fail. my $leap = ($form->{year} % 4 == 0) ? "29" : "28"; - $form->{todate} = "$leap.2.$form->{year}"; + $form->{todate} = "$form->{year}02$leap"; $form->{"0402"} = "X"; last SWITCH; }; - $form->{duetyp} eq "03" && do { - $form->{fromdate} = "1.3.$form->{year}"; - $form->{todate} = "31.3.$form->{year}"; + $form->{period} eq "03" && do { + $form->{fromdate} = "$form->{year}0301"; + $form->{todate} = "$form->{year}0331"; $form->{"0403"} = "X"; last SWITCH; }; - $form->{duetyp} eq "04" && do { - $form->{fromdate} = "1.4.$form->{year}"; - $form->{todate} = "30.4.$form->{year}"; + $form->{period} eq "04" && do { + $form->{fromdate} = "$form->{year}0401"; + $form->{todate} = "$form->{year}0430"; $form->{"0404"} = "X"; last SWITCH; }; - $form->{duetyp} eq "05" && do { - $form->{fromdate} = "1.5.$form->{year}"; - $form->{todate} = "31.5.$form->{year}"; + $form->{period} eq "05" && do { + $form->{fromdate} = "$form->{year}0501"; + $form->{todate} = "$form->{year}0531"; $form->{"0405"} = "X"; last SWITCH; }; - $form->{duetyp} eq "06" && do { - $form->{fromdate} = "1.6.$form->{year}"; - $form->{todate} = "30.6.$form->{year}"; + $form->{period} eq "06" && do { + $form->{fromdate} = "$form->{year}0601"; + $form->{todate} = "$form->{year}0630"; $form->{"0406"} = "X"; last SWITCH; }; - $form->{duetyp} eq "07" && do { - $form->{fromdate} = "1.7.$form->{year}"; - $form->{todate} = "31.7.$form->{year}"; + $form->{period} eq "07" && do { + $form->{fromdate} = "$form->{year}0701"; + $form->{todate} = "$form->{year}0731"; $form->{"0407"} = "X"; last SWITCH; }; - $form->{duetyp} eq "08" && do { - $form->{fromdate} = "1.8.$form->{year}"; - $form->{todate} = "31.8.$form->{year}"; + $form->{period} eq "08" && do { + $form->{fromdate} = "$form->{year}0801"; + $form->{todate} = "$form->{year}0831"; $form->{"0408"} = "X"; last SWITCH; }; - $form->{duetyp} eq "09" && do { - $form->{fromdate} = "1.9.$form->{year}"; - $form->{todate} = "30.9.$form->{year}"; + $form->{period} eq "09" && do { + $form->{fromdate} = "$form->{year}0901"; + $form->{todate} = "$form->{year}0930"; $form->{"0409"} = "X"; last SWITCH; }; - $form->{duetyp} eq "10" && do { - $form->{fromdate} = "1.10.$form->{year}"; - $form->{todate} = "31.10.$form->{year}"; + $form->{period} eq "10" && do { + $form->{fromdate} = "$form->{year}1001"; + $form->{todate} = "$form->{year}1031"; $form->{"0410"} = "X"; last SWITCH; }; - $form->{duetyp} eq "11" && do { - $form->{fromdate} = "1.11.$form->{year}"; - $form->{todate} = "30.11.$form->{year}"; + $form->{period} eq "11" && do { + $form->{fromdate} = "$form->{year}1101"; + $form->{todate} = "$form->{year}1130"; $form->{"0411"} = "X"; last SWITCH; }; - $form->{duetyp} eq "12" && do { - $form->{fromdate} = "1.12.$form->{year}"; - $form->{todate} = "31.12.$form->{year}"; + $form->{period} eq "12" && do { + $form->{fromdate} = "$form->{year}1201"; + $form->{todate} = "$form->{year}1231"; $form->{"0412"} = "X"; last SWITCH; }; } - } - #$myconfig = \%myconfig; - RP->ustva(\%myconfig, \%$form); + # Kontrollvariable für die Templates + $form->{'year2007'} = ($form->{year} >= 2007 ) ? "1":"0"; + + + # Get the USTVA + USTVA->ustva(\%myconfig, \%$form); - #??($form->{department}) = split /--/, $form->{department}; + # reformat Dates to dateformat + $form->{fromdate} = $locale->date(\%myconfig, $form->{fromdate}, 0, 0, 0); - $form->{period} = + $form->{todate} = $form->current_date(\%myconfig) unless $form->{todate}; + $form->{todate} = $locale->date(\%myconfig, $form->{todate}, 0, 0, 0); + + $form->{longperiod} = $locale->date(\%myconfig, $form->current_date(\%myconfig), 1, 0, 0); - $form->{todate} = $form->current_date($myconfig) unless $form->{todate}; # if there are any dates construct a where if ($form->{fromdate} || $form->{todate}) { - unless ($form->{todate}) { - $form->{todate} = $form->current_date($myconfig); - } + $form->{todate} = $form->current_date($myconfig) unless ($form->{todate}); my $longtodate = $locale->date($myconfig, $form->{todate}, 1, 0, 0); my $shorttodate = $locale->date($myconfig, $form->{todate}, 0, 0, 0); @@ -960,10 +706,10 @@ sub generate_ustva { my $shortfromdate = $locale->date($myconfig, $form->{fromdate}, 0, 0, 0); $form->{this_period} = "$shortfromdate
\n$shorttodate"; - $form->{period} = + $form->{longperiod} = $locale->text('for Period') . qq|
\n$longfromdate | - . $locale->text('bis') + . $locale->text('to (date)') . qq| $longtodate|; } @@ -979,9 +725,9 @@ sub generate_ustva { $locale->date(\%myconfig, $form->{comparetodate}, 0, 0, 0); $form->{last_period} = "$shortcomparefromdate
\n$shortcomparetodate"; - $form->{period} .= + $form->{longperiod} .= "
\n$longcomparefromdate " - . $locale->text('bis') + . $locale->text('to (date)') . qq| $longcomparetodate|; } @@ -989,7 +735,6 @@ sub generate_ustva { $locale->date(\%myconfig, $form->current_date(\%myconfig), 0, 0, 0); # setup variables for the form - # steuernummer für prerelease entfernt my @a = qw(company 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_tel2 @@ -1003,312 +748,459 @@ sub generate_ustva { my $temp = $form->{address}; $temp =~ s/\\n/
/; ($form->{co_street}, $form->{co_city}) = split("
", $temp); + $form->{co_city} =~ s/\\n//g; } - if ( $form->{format} eq 'pdf' - or $form->{format} eq 'postscript') { - $form->{padding} = "~~"; - $form->{bold} = "\textbf{"; - $form->{endbold} = "}"; - $form->{br} = '\\\\'; + ################################ + # + # 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({ + myconfig => \%myconfig, + form => $form, + type => '', + attribute => 'position', + dec_places => '2', + }); - my @numbers = qw(51r 86r 97r 93r 96 43 45 - 66 62 67); - my $number = ''; - # Zahlenformatierung für Latex USTVA Formulare - if ($myconfig{numberformat} eq '1.000,00' or - $myconfig{numberformat} eq '1000,00') { - foreach $number (@numbers) { - $form->{$number} =~ s/,/~~/g; + push @category_cent, qw(83 Z43 Z45 Z53 Z62 Z65 Z67); + + my @category_euro = USTVA->report_variables({ + myconfig => \%myconfig, + form => $form, + type => '', + attribute => 'position', + dec_places => '0', + }); + + $form->{id} = []; + $form->{amount} = []; + + if ( $form->{format} eq 'pdf' or $form->{format} eq 'postscript') { + + $form->{IN} = "$form->{type}-$form->{year}.tex"; + $form->{padding} = "~~"; + $form->{bold} = "\textbf{"; + $form->{endbold} = "}"; + $form->{br} = '\\\\'; + + # Zahlenformatierung für Latex USTVA Formulare + + foreach my $number (@category_euro) { + $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '0', ''); } - } - if ($myconfig{numberformat} eq '1000.00' or - $myconfig{numberformat} eq '1,000.00') { - foreach $number (@numbers) { - $form->{$number} =~ s/\./~~/g; + + my ${decimal_comma} = ( $myconfig{numberformat} eq '1.000,00' + or $myconfig{numberformat} eq '1000,00' ) ? ',':'.'; + + foreach my $number (@category_cent) { + $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '2', ''); + $form->{$number} =~ s/${decimal_comma}/~~/g; } - } - # Formatierungen für HTML Ausgabe - } elsif ($form->{format} eq 'html') { - $form->{padding} = "  "; - $form->{bold} = ""; - $form->{endbold} = ""; - $form->{br} = "
"; - $form->{address} =~ s/\\n/
/; - } + } elsif ( $form->{format} eq 'html') { # Formatierungen für HTML Ausgabe + + $form->{IN} = $form->{type} . '.html'; + $form->{padding} = "  "; + $form->{bold} = ""; + $form->{endbold} = ""; + $form->{br} = "
"; + $form->{address} =~ s/\\n/\n/g; - if ($form->{format} eq 'elster') { - if ($form->{duetyp} eq '13'){ + 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'); + } + + } 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 + $file .= $form->{elsterFFFF}; + $file .= $form->{elstersteuernummer}; + #file suffix + $file .= '.xml'; + $file =~ s|.*/||; + $form->{tmpfile} = "$userspath/$file"; + + $form->{attachment_filename} = $file; + + # Zahlenformatierung für Winston + + my $temp_numberformat = $myconfig{numberformat}; + + # Numberformat must be '1000.00' for Winston + + $myconfig{numberformat} = '1000.00'; + + 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 %winston_id_for = ( + # No Winston remap?! + ); + + 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->{amount}}, $form->{$kennziffer}); + } + + } elsif ( $form->{format} eq 'elstertaxbird' ) { + + # Define serveral filenames + $form->{IN} = 'taxbird.txb'; + + $form->{attachment_filename} = "USTVA-" . $form->{period} + . sprintf("%02d", $form->{year} % 100) . ".txb"; + + $form->{attachment_filename} =~ s|.*/||; + $form->{tmpfile} = "$userspath/" . $form->{attachment_filename}; + + # TODO: set Output to UTF-8 or system Preference + #$form->{"iconv"} = Text::Iconv->new($myconfig{dbcharset}, "UTF-8"); + #my $iconv = $self->{"iconv"}; + #$iconv->convert($variable); + if ($form->{period} =~ /^[4]\d$/ ){ + my %periods = ( # Lx => taxbird + '41' => '12', + '42' => '13', + '43' => '14', + '44' => '15', + ); + + foreach my $quarter ( keys %periods ) { + $form->{taxbird_period} = $periods{$quarter} if ( $form->{period} eq $quarter); + } + } elsif ($form->{period} =~ /^\d+$/ ) { + $form->{period} =~ s/^0//g; + my $period = $form->{period}; + $period * 1; + $period--; + $form->{period} = $period; + } 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 ); + } + + $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 ?! + $myconfig{numberformat} = '1000,00'; + 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', + '931' => 'Kz93-calc', + '811' => 'Kz81-calc', + '891' => 'Kz89-calc', + 'Z45' => 'uebertrag', + 'Z53' => 'ust-sum', + 'Z62' => 'ust-minus-vost', + 'Z65' => 'ust-sum+69', + 'Z67' => 'ust-vz', + ); + + + for my $kennziffer (@category_cent, @category_euro) { + + next if ($kennziffer eq 'Z43'); + + if ($form->{$kennziffer} != 0){ + if (defined $taxbird_id_for{$kennziffer}) { + push(@{ $form->{id}}, $taxbird_id_for{$kennziffer}); + } else { + push(@{ $form->{id}}, "Kz$kennziffer"); + } + push(@{ $form->{amount}}, $form->{$kennziffer}); + } + } + + } elsif ( $form->{format} eq '' ){ # No format error. $form->header; - USTVA::info($locale->text('Impossible to create yearly Tax Report via Winston.
Not yet implemented!')); - } else { - &create_winston(); + USTVA::error( $locale->text('Application Error. No Format given' ) . "!"); + exit(0); + + } else { # All other Formats are wrong + $form->header; + USTVA::error( $locale->text('Application Error. Wrong Format') . ": " . $form->{format} ); + exit(0); } - } else { - $form->{templates} = $myconfig{templates}; - $form->{templates} = "doc" if ($form->{type} eq 'help'); - $form->{IN} = "$form->{type}"; - $form->{IN} = "$form->{help}" if ($form->{type} eq 'help'); - $form->{IN} = 'USTE' if ($form->{duetyp} eq '13' && - $form->{format} ne 'html'); - - if ($form->{IN} eq 'USTE'){ - $form->header; - USTVA::info($locale->text('Impossible to create yearly Tax Report as PDF or PS.
Not yet implemented!')); + + } else # Outputformat for generic output + { + + my @category_cent = USTVA->report_variables({ + myconfig => \%myconfig, + form => $form, + type => '', + attribute => 'position', + dec_places => '2', + }); + + my @category_euro = USTVA->report_variables({ + myconfig => \%myconfig, + form => $form, + type => '', + attribute => 'position', + dec_places => '0', + }); + + $form->{USTVA} = []; + + 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( + $locale->text( + 'Yearly taxreport not yet implemented') + . '!'); + } - $form->{IN} .= "-$form->{year}" - if ( $form->{format} eq 'pdf' - or $form->{format} eq 'postscript'); + $form->{templates} = $myconfig{templates}; + $form->{templates} = "doc" if ( $form->{type} eq 'help' ); + + if ($form->{format} eq 'generic'){ - $form->{IN} .= '.tex' - if ( $form->{format} eq 'pdf' - or $form->{format} eq 'postscript'); + $form->header(); + + $template_ref = { + taxnumber => $myconfig{taxnumber}, + }; - $form->{IN} .= '.html' if ($form->{format} eq 'html'); + print($form->parse_html_template('ustva/generic_taxreport', $template_ref)); + + } else + { + + $form->parse_template(\%myconfig, $userspath); - #$form->header; - #print qq|$myconfig
$path|; - $form->parse_template($myconfig, $userspath); } + $lxdebug->leave_sub(); } -sub edit { +sub config_step1 { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + # edit all taxauthority prefs $form->header; - &get_config($userspath, 'finanzamt.ini'); - - #&create_steuernummer; + USTVA->get_config($userspath, 'finanzamt.ini'); my $land = $form->{elsterland}; my $amt = $form->{elsterFFFF}; - my $callback = ''; - $callback = - "$form->{cbscript}?action=edit&login=$form->{cblogin}&path=$form->{cbpath}&root=$form->{cbroot}&rpw=$form->{cbrpw}" - if ($form->{cbscript} ne '' and $form->{cblogin} ne ''); - - $form->{title} = $locale->text('Finanzamt - Einstellungen'); - print qq| - - - - - - - - - -
| - . $locale->text('Finanzamt - Einstellungen') - . qq|
-
-
- | - . $locale->text('Angaben zum Finanzamt') - . qq| - |; - #print qq|$form->{terminal}|; + $form->{title} = $locale->text('Tax Office Preferences'); - USTVA::fa_auswahl($land, $amt, &elster_hash()); - print qq| -
-
- |; - my $checked = ''; - $checked = "checked" if ($form->{method} eq 'accrual'); - print qq| -
- | . $locale->text('Verfahren') . qq| - - - -
- |; - $checked = ''; - $checked = "checked" if ($form->{method} eq 'cash'); - print qq| - - -
-
-
- | . $locale->text('Voranmeldungszeitraum') . qq| - - |; - $checked = ''; - $checked = "checked" if ($form->{FA_voranmeld} eq 'month'); - print qq| - - -
- |; - $checked = ''; - $checked = "checked" if ($form->{FA_voranmeld} eq 'quarter'); - print qq| - - -
- |; - $checked = ''; - $checked = "checked" if ($form->{FA_dauerfrist} eq '1'); - print qq| - - - -
-
-
- | . $locale->text('Steuerberater/-in') . qq| - - |; - $checked = ''; - $checked = "checked" if ($form->{FA_71} eq 'X'); - print qq| - - - - - - - - - - - - - -
- | . $locale->text('Name') . qq| - - | . $locale->text('Straße') . qq| - - | . $locale->text('PLZ, Ort') . qq| - - | . $locale->text('Telefon') . qq| -
- - - - - - - -
- -
- -
-
-
- - |; - print qq| - | if ($callback ne ''); - print qq| -     - - -
- |; - my @variables = qw( steuernummer elsterland elstersteuernummer elsterFFFF); - my $variable = ''; - foreach $variable (@variables) { - print qq| - |; - } - my $steuernummer_new = ''; + my $select_tax_office = USTVA->fa_auswahl($land, $amt, &elster_hash()); + 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'); + my $checked_quarterly = "checked" if ($form->{FA_voranmeld} eq 'quarter'); + my $checked_dauerfristverlaengerung = "checked" if ($form->{FA_dauerfrist} eq '1'); + my $checked_kz_71 = "checked" if ($form->{FA_71} eq 'X'); - # - print qq| - - - - - {path}> - {login}> - {password}> - - |; + my $_hidden_variables_ref; - @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_BLZ_2 - FA_Kontonummer_2 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten - FA_Email FA_Internet); + 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 }, + { '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_BLZ_2 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich + FA_Oeffnungszeiten FA_Email FA_Internet + steuernummer elsterland elstersteuernummer + elsterFFFF + ); - foreach $variable (@variables) { - print qq| - |; + foreach my $variable (@_hidden_form_variables) { + push @{ $_hidden_variables_ref}, + { 'variable' => $variable, 'value' => $form->{$variable} }; } - print qq| -
- -|; +# Which COA is in use? + + USTVA->get_coa($form, \%myconfig); + + # hä? kann die weg? + my $steuernummer_new = ''; + + # Variablen für das Template zur Verfügung stellen + my $template_ref = { + select_tax_office => $select_tax_office, + checked_accrual => $checked_accrual, + checked_cash => $checked_cash, + checked_monthly => $checked_monthly, + 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)); + $lxdebug->leave_sub(); } -sub edit_form { +sub config_step2 { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + $form->header(); - print qq| - - |; + +# print qq| +# +# |; + my $elsterland = ''; my $elster_amt = ''; my $elsterFFFF = ''; my $elstersteuernummer = ''; - &get_config($userspath, 'finanzamt.ini') + USTVA->get_config($userspath, 'finanzamt.ini') if ($form->{saved} eq $locale->text('saved')); # Auf Übergabefehler checken - USTVA::info( - $locale->text( - 'Bitte das Bundesland UND die Stadt bzw. den Einzugsbereich Ihres zuständigen Finanzamts auswählen.' - )) + USTVA::info( $locale->text('Missing Tax Authoritys Preferences') . "\n" + . $locale->text('USTVA-Hint: Tax Authoritys')) if ( $form->{elsterFFFF_new} eq 'Auswahl' || $form->{elsterland_new} eq 'Auswahl'); - USTVA::info( - $locale->text( - 'Es fehlen Angaben zur Versteuerung. - Wenn Sie Ist Versteuert sind, wählen Sie die Einnahmen/Überschuß-Rechnung aus. - Sind Sie Soll-Versteuert und Bilanzverpflichtet, dann wählen Sie Bilanz aus.' - )) + USTVA::info( $locale->text('Missing Method!') . "\n" + . $locale->text('USTVA-Hint: Method')) if ($form->{method} eq ''); # 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} + 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 = (); my %elster_init = %$elster_init; if ($change eq '1') { @@ -1319,7 +1211,8 @@ sub edit_form { $form->{elsterland} = $elsterland; $form->{elsterFFFF} = $elsterFFFF; $form->{steuernummer} = ''; - &create_steuernummer; + + create_steuernummer(); # rebuild elster_amt my $amt = ''; @@ -1352,115 +1245,74 @@ sub edit_form { my $patterncount = $form->{patterncount}; my $elster_pattern = $form->{elster_pattern}; my $delimiter = $form->{delimiter}; - my $steuernummer = ''; - $steuernummer = $form->{steuernummer} if ($steuernummer eq ''); - - #Warnung - my $warnung = $form->{warnung}; - - #printout form - print qq| -
- - - - - - - - - - - - - - -
| - . $locale->text('Finanzamt - Einstellungen') - . qq|
-
- |; - &show_fa_daten; - print qq| -
-
-
- - | . $locale->text('Steuernummer') . qq| - -
- |; - $steuernummer = - USTVA::steuernummer_input($form->{elsterland}, $form->{elsterFFFF}, - $form->{steuernummer}); - print qq| -
-
-
-
-
-
- - - |; - print qq|| - if ($form->{callback} eq ''); - - print qq| - | - if ($form->{callback} ne ''); - - if ($form->{warnung} eq "1") { - print qq| - - - - |; - } else { - print qq| - - - - |; - } + my $steuernummer = $form->{steuernummer} if ($steuernummer eq ''); - print qq| - -

$form->{saved}

-
- |; + $form->{FA_Oeffnungszeiten} =~ s/\\\\n/\n/g; + + - my @variables = qw(FA_steuerberater_name FA_steuerberater_street - FA_steuerberater_city FA_steuerberater_tel - FA_voranmeld method - FA_dauerfrist FA_71 elster - path login password type elster_init saved + my $input_steuernummer = USTVA->steuernummer_input( + $form->{elsterland}, + $form->{elsterFFFF}, + $form->{steuernummer} ); - my $variable = ''; - foreach $variable (@variables) { - print qq| - |; + + $lxdebug->message(LXDebug::DEBUG1, qq|$input_steuernummer|); + + + my $_hidden_variables_ref; + + my %_hidden_local_variables = ( + 'elsterland' => $elsterland, + 'elsterFFFF' => $elsterFFFF, + 'warnung' => $warnung, + 'elstersteuernummer' => $elstersteuernummer, + 'steuernummer' => $stnr, + 'lastsub' => 'config_step1', + 'nextsub' => 'save', + + ); + + foreach my $variable (keys %_hidden_local_variables) { + push @{ $_hidden_variables_ref }, + { 'variable' => $variable, 'value' => $_hidden_local_variables{$variable} }; } - print qq| - - - - - - -
- |; + + my @_hidden_form_variables = qw( + FA_steuerberater_name FA_steuerberater_street + FA_steuerberater_city FA_steuerberater_tel + FA_voranmeld method + FA_dauerfrist FA_71 + elster + type elster_init + saved callback + ); + + foreach my $variable (@_hidden_form_variables) { + push @{ $_hidden_variables_ref}, + { 'variable' => $variable, 'value' => $form->{$variable} }; + } + + my $template_ref = { + tax_office_data => $tax_office_data, + input_steuernummer => $input_steuernummer, + readonly => '', #q|disabled="disabled"|, + callback => $callback, + hidden_variables => $_hidden_variables_ref, + }; + + # Ausgabe des Templates + print($form->parse_html_template('ustva/config_step2', $template_ref)); + + $lxdebug->leave_sub(); } sub create_steuernummer { $lxdebug->enter_sub(); + + $auth->assert('advance_turnover_tax_return'); + my $part = $form->{part}; my $patterncount = $form->{patterncount}; my $delimiter = $form->{delimiter}; @@ -1495,52 +1347,16 @@ sub create_steuernummer { $lxdebug->leave_sub(); } -sub get_config { +sub save { $lxdebug->enter_sub(); - my ($userpath, $filename) = @_; - my ($key, $value) = ''; - open(FACONF, "$userpath/$form->{login}_$filename") - or #falls Datei nicht vorhanden ist - sub { - open(FANEW, ">$userpath/$form->{login}_$filename") - or $form->error("$userpath/$filename : $!"); - close FANEW; - open(FACONF, "$userpath/$form->{login}_$filename") - or $form->error("$userpath/$form->{username}_$filename : $!"); - }; - while () { - last if /^\[/; - next if /^(#|\s)/; - - # remove comments - s/\s#.*//g; - - # remove any trailing whitespace - s/^\s*(.*?)\s*$/$1/; - ($key, $value) = split /=/, $_, 2; - - #if ($value eq ' '){ - # $form->{$key} = " " ; - #} elsif ($value ne ' '){ - $form->{$key} = "$value"; - - #} - } - close FACONF; - - # Textboxen formatieren: Linebreaks entfernen - # - #$form->{FA_Oeffnungszeiten} =~ s/\\\\n/
/g; - $lxdebug->leave_sub(); -} + $auth->assert('advance_turnover_tax_return'); -sub save { - $lxdebug->enter_sub(); my $filename = "$form->{login}_$form->{filename}"; + $filename =~ s|.*/||; #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen - create_steuernummer; + create_steuernummer(); # Textboxen formatieren: Linebreaks entfernen # @@ -1550,11 +1366,12 @@ sub save { $form->{FA_Internet} =~ s/^http:\/\///; $form->{FA_Internet} = 'http://' . $form->{FA_Internet}; - 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_Kontonummer_1 - FA_Bankbezeichnung_1 FA_BLZ_2 FA_Kontonummer_2 + 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_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 @@ -1562,664 +1379,65 @@ sub save { # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer if ($form->{elstersteuernummer} ne '000000000') { + $form->{elster} = '1'; - open(CONF, ">$userspath/$filename") or $form->error("$filename : $!"); + + open my $ustvaconfig, ">", "$userspath/$filename" or $form->error("$filename : $!"); # create the config file - print CONF qq|# Configuration file for USTVA\n\n|; + print {$ustvaconfig} qq|# Configuration file for USTVA\n\n|; my $key = ''; foreach $key (sort @config) { $form->{$key} =~ s/\\/\\\\/g; - $form->{$key} =~ s/"/\\"/g; - # strip M $form->{$key} =~ s/\r\n/\n/g; - print CONF qq|$key=|; + + print {$ustvaconfig} qq|$key=|; if ($form->{$key} ne 'Y') { - print CONF qq|$form->{$key}\n|; + print {$ustvaconfig} qq|$form->{$key}\n|; } if ($form->{$key} eq 'Y') { - print CONF qq|checked \n|; + print {$ustvaconfig} qq|checked \n|; } } - print CONF qq|\n\n|; - close CONF; + print {$ustvaconfig} qq|\n\n|; + close $ustvaconfig; $form->{saved} = $locale->text('saved'); } else { - $form->{saved} = $locale->text('Bitte eine Steuernummer angeben'); + $form->{saved} = $locale->text('Choose a Tax Number'); } - &edit_form; - $lxdebug->leave_sub(); -} - -sub show_fa_daten { - $lxdebug->enter_sub(); - my $readonly = $_; - my $oeffnungszeiten = $form->{FA_Oeffnungszeiten}; - $oeffnungszeiten =~ s/\\\\n/\n/g; - print qq|
-
- - | - . $locale->text('Finanzamt') - . qq| $form->{FA_Name} - - |; - - #print qq|\n

$form->{FA_Ergaenzung_Name} 

- # | if ( $form->{FA_Ergaenzung_Name} ); - print qq| - - - - - -
-
-
- - | . $locale->text('Address') . qq| - - - - - - - - - - - - - - - -
- | . $locale->text('Finanzamt') . qq| -
- - -
- -
- - - -
-
-
-
- - | . $locale->text('Kontakt') . qq| - - | . $locale->text('Telefon') . qq|
- -
-
- | . $locale->text('Fax') . qq|
- -
-
- | . $locale->text('Internet') . qq|
- -
-
- -
-
- 		-
-
- - | . $locale->text('Öffnungszeiten') . qq| - - -
-
- |; - my $FA_1 = - ( $form->{FA_BLZ_1} ne '' - && $form->{FA_Kontonummer_1} ne '' - && $form->{FA_Bankbezeichnung_1} ne ''); - my $FA_2 = - ( $form->{FA_BLZ_2} ne '' - && $form->{FA_Kontonummer_2} ne '' - && $form->{FA_Bankbezeichnung_oertlich} ne ''); - - if ($FA_1 && $FA_2) { - print qq| -
- - | - . $locale->text('Bankverbindungen des Finanzamts') . qq| - - - - - - -
- | . $locale->text('Kreditinstitut') . qq| -
- -
-
- | . $locale->text('Kontonummer') . qq| -
- -
-
- | . $locale->text('Bankleitzahl') . qq| -
- - 		- | . $locale->text('Kreditinstitut') . qq| -
- -
-
- | . $locale->text('Kontonummer') . qq| -
- -
-
- | . $locale->text('Bankleitzahl') . qq| -
- -
-
- |; - } elsif ($FA_1) { - print qq| -
- - | - . $locale->text('Bankverbindung des Finanzamts') . qq| - - | . $locale->text('Kontonummer') . qq| -
- -
-
- | . $locale->text('Bankleitzahl (BLZ)') . qq| -
- -
-
- | . $locale->text('Kreditinstitut') . qq| -
- -
-
- |; - } else { - print qq| -
- - | - . $locale->text('Bankverbindung des Finanzamts') . qq| - - | . $locale->text('Kontonummer') . qq| -
- -
-
- | . $locale->text('Bankleitzahl (BLZ)') . qq| -
- -
-
- | . $locale->text('Kreditinstitut') . qq| -
- -
- |; - } - print qq| -
-
- |; - $lxdebug->leave_sub(); -} - -sub create_winston { - $lxdebug->enter_sub(); - &get_config($userspath, 'finanzamt.ini'); - - # There is no generic Linux GNU/GPL solution out for using ELSTER. - # In lack of availability linux users may use windows pendants. I choose - # WINSTON, because it's free of coast, it has an API and its tested under - # Linux using WINE. - # The author of WINSTON developed some c-code to realize ELSTER under - # WINDOWS and Linux (http://www.felfri.de/fa_xml/). Next year (2005) I start to - # develop a server side solution for LX-Office ELSTER under Linux and - # WINDOWS based on this c-code. - # - # You need to download WINSTON from http://www.felfri.de/winston/ - # There (http://www.felfri.de/winston/download.htm) you'll find instructions - # about WINSTON under Linux WINE - # More infos about Winstons API: http://www.felfri.de/winston/schnittstellen.htm - my $azr = ''; - my $file = ''; # Filename for Winstonfile - $file .= 'U'; # 1. char 'U' = USTVA - -SWITCH: - { # 2. and 3. char 01-12= Month 41-44= Quarter (azr:Abrechnungszeitraum) - $form->{duetyp} eq "01" && do { - $azr = "01"; - last SWITCH; - }; - $form->{duetyp} eq "02" && do { - $azr = "02"; - last SWITCH; - }; - $form->{duetyp} eq "03" && do { - $azr = "03"; - last SWITCH; - }; - $form->{duetyp} eq "04" && do { - $azr = "04"; - last SWITCH; - }; - $form->{duetyp} eq "05" && do { - $azr = "05"; - last SWITCH; - }; - $form->{duetyp} eq "06" && do { - $azr = "06"; - last SWITCH; - }; - $form->{duetyp} eq "07" && do { - $azr = "07"; - last SWITCH; - }; - $form->{duetyp} eq "08" && do { - $azr = "08"; - last SWITCH; - }; - $form->{duetyp} eq "09" && do { - $azr = "09"; - last SWITCH; - }; - $form->{duetyp} eq "10" && do { - $azr = "10"; - last SWITCH; - }; - $form->{duetyp} eq "11" && do { - $azr = "11"; - last SWITCH; - }; - $form->{duetyp} eq "12" && do { - $azr = "12"; - last SWITCH; - }; - $form->{duetyp} eq "A" && do { - $azr = "41"; - last SWITCH; - }; - $form->{duetyp} eq "B" && do { - $azr = "42"; - last SWITCH; - }; - $form->{duetyp} eq "C" && do { - $azr = "43"; - last SWITCH; - }; - $form->{duetyp} eq "D" && do { - $azr = "44"; - last SWITCH; - }; - do { - $form->error( - "Ungültiger Anmeldezeitraum.\n - Sie können für ELSTER nur einen monatlichen oder - quartalsweisen Anmeldezeitraum auswählen." - ); - }; - } - - $file .= $azr; - - #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 - - $file .= $form->{elsterFFFF}; - $file .= $form->{elstersteuernummer}; - - #file suffix - - $file .= '.xml'; - $form->{elsterfile} = $file; - - #Calculations - - my $k51 = - sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"})) - ; # Umsätze zu 16% USt - my $k86 = - sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"})) - ; # Umsätze zu 7% USt - my $k97 = - sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"})) - ; # 16% Steuerpflichtige innergemeinsachftliche Erwerbe - my $k93 = - sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"})) - ; # 16% Steuerpflichtige innergemeinsachftliche Erwerbe - my $k94 = - sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"})) - ; # neuer Fahrzeuge von Lieferern - my $k66 = - $form->parse_amount(\%myconfig, $form->{"66"}) * - 100; # Vorsteuer 7% plus 16% - my $k83 = - $form->parse_amount(\%myconfig, $form->{"67"}) * 100; # Umsätze zu 7% USt - my $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100; # - # - # Now build the xml content - # - - $form->{elster} = qq| - - - - $form->{elstersteuernummer} - $form->{year} - $azr - |; - - $form->{elster} .= qq|$k51\n| if ($k51 ne '0'); - $form->{elster} .= qq|$k86\n| if ($k86 ne '0'); - $form->{elster} .= qq|$k97\n| if ($k97 ne '0'); - $form->{elster} .= qq|$k93\n| if ($k93 ne '0'); - $form->{elster} .= qq|$k94\n| if ($k94 ne '0'); - $form->{elster} .= qq|$k96\n| if ($k96 ne '0'); - $form->{elster} .= qq|$k66\n| if ($k66 ne '0'); - $form->{elster} .= qq|$k83\n| if ($k83 ne '0'); - $form->{elster} .= qq|\n\n\n|; - - #$form->header; - #print qq|$form->{elsterfile}|; - #print qq|$form->{elster}|; - $SIG{INT} = 'IGNORE'; - - &save_winston; + config_step2(); $lxdebug->leave_sub(); } -sub save_winston { - $lxdebug->enter_sub(); - my $elster = $form->{elster}; - my $elsterfile = $form->{elsterfile}; - open(OUT, ">-") or $form->error("STDOUT : $!"); - print OUT qq|Content-Type: application/file; -Content-Disposition: attachment; filename="$elsterfile"\n\n|; - print OUT $elster; - close(OUT); - $lxdebug->leave_sub(); -} sub continue { $lxdebug->enter_sub(); + # allow Symbolic references just here: no strict 'refs'; - &{ $form->{nextsub} }; + call_sub($form->{"nextsub"}); use strict 'refs'; $lxdebug->leave_sub(); } -sub back { +sub back { $lxdebug->enter_sub(); - &{ $form->{lastsub} }; + call_sub($form->{"lastsub"}); $lxdebug->leave_sub(); } sub elster_hash { $lxdebug->enter_sub(); - my $finanzamt = USTVA::query_finanzamt(\%myconfig, \%$form); - $lxdebug->leave_sub(); - return $finanzamt; -} - -sub test { - $lxdebug->enter_sub(); - # biegt nur den Testeintrag in Programm->Test auf eine Routine um + $auth->assert('advance_turnover_tax_return'); - $form->header; - &elster_send; + my $finanzamt = USTVA->query_finanzamt(\%myconfig, \%$form); $lxdebug->leave_sub(); + return $finanzamt; } -sub elster_send { - $lxdebug->enter_sub(); - - #read config - my $elster_conf = &elster_conf(); - &elster_xml(); - use Cwd; - $form->{cwd} = cwd(); - $form->{tmpdir} = $form->{cwd} . '/' . $elster_conf->{'path'}; - $form->{tmpfile} = $elster_conf->{'err'}; - my $caller = $elster_conf->{'call'}[0]; - - chdir("$form->{tmpdir}") or $form->error($form->cleanup . "chdir : $!"); - my $send = - "faxmlsend $caller -config etc/faxmlsend.cnf -xml faxmlsend.xml -tt faxmlsend.tt -debug"; - - system("$send > $form->{tmpfile}"); - $form->{tmpdir} .= "$elster_conf->{'path'}/"; - $form->{tmpfile} = "faxmlsend.err"; - $form->error($form->cleanup - . "faxmlsend : OFD meldet: Error 404 \n Internetseite nicht vorhanden") - if ($? eq '1024'); - $form->error($form->cleanup - . "faxmlsend : No such File: faxmlsend.xml \n Fehlernummer: $? \n Problem beim öffnen der faxmlsend.xml" - ) - if ($?); - - # foreach my $line (&elster_feedback("$elster_conf->{'path'}")){ - # print qq|$line\n|; - # } - print qq|Log:
|; - - #for (my $i=0; $i<= ) - &elster_readlog(); - print qq|\n ende\n|; - $lxdebug->leave_sub(); -} - -sub elster_readlog { - $lxdebug->enter_sub(); - my $elster_conf = &elster_conf(); - open(LOG, "$elster_conf->{'logfile'}") - or $form->error("$elster_conf->{'logfile'}: $!"); - print qq||; - my $log = ''; - my $xml = ''; - my $tmp = ''; - while () { - my $i = 0; - - #$_ =~ s//>\;/; - $_ =~ s/\s+//mg; - - #$_ =~ s/\015\012//mg; - $_ =~ s/|; - - #} elsif ($_ =~ /(<([^\/]*?)>)/ ) { - } elsif ($_ =~ /(<([^\/].*?)>(.*))/g) { - - #$xml .= qq|$2 = $3\n\n|; - #$_ =~ s/\015\012//mg; - $_ =~ s/\s+//; - $xml .= qq|$_\n|; - - } else { - $tmp .= qq|$_
|; - } - $i++; - } - - #second parse - #my $var=''; - #while (<$xml>){ - # $var .= qq|$2 = $3\n\n|; - #} - #print qq|$log|; - print qq|$xml|; - print qq||; - - # $_=$log; - # s{<(\w+)\b([^<>]*)> - # ((?:.(?!) } - # { print "markup=",$1," args=",$2," enclosed=",$3," final=",$4 ; "" }gsex; - close LOG; - $lxdebug->leave_sub(); -} - -sub elster_feedback { - $lxdebug->enter_sub(); - my ($file) = @_; - my @content = (); - print qq|feedback:
|; - if (-f "$file") { - open(FH, "$file"); - @content = ; - close(FH); - } - $lxdebug->leave_sub(); - return (@content); -} - -sub elster_conf { - $lxdebug->enter_sub(); - my $elster_conf = { 'path' => 'elster', - 'prg' => 'faxmlsend', - 'err' => 'faxmlsend.err', - 'ttfile' => 'faxmlsend.tt', - 'xmlfile' => 'faxmlsend.xml', - 'cline' => '-tt $ttfile -xml $xmlfile', - 'call' => ['send', 'protokoll', 'anmeldesteuern'], - 'logfile' => 'log/faxmlsend.log', - 'conffile' => 'faxmlsend.cnf', - 'debug' => '-debug' }; - $lxdebug->leave_sub(); - return $elster_conf; - -} - -sub elster_xml { - $lxdebug->enter_sub(); - my $elster_conf = &elster_conf(); - - # $k51 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"})); # Umsätze zu 16% USt - # $k86 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"})); # Umsätze zu 7% USt - # $k97 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe - # $k93 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe - # $k94 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"})); # neuer Fahrzeuge von Lieferern - # $k66 = $form->parse_amount(\%myconfig, $form->{"66"}) * 100;# Vorsteuer 7% plus 16% - # $k83 = $form->parse_amount(\%myconfig, $form->{"67"}) * 100;# Umsätze zu 7% USt - # $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100;# - - my $TransferHeader = qq| - - - - ElsterAnmeldung - UStVA - send-NoSig - 700000004 - 74931 - Helmut - - PKCS#7v1.5 - GZIP - 123456789012345678901234567890123456789012 - - - - - 0 - - - - 0 - - - - - - test - - |; - - my $DatenTeil = qq| - - - - 234234234 - 9198 - - ElsterAnmeldung - V 1.4 - - String, der Lieferanteninfo enthaelt - - .... - - - - - - - OFD Muenchen - Meiserstr. 6 - 80335 - München - - 20041127 - - - 2005 - 01 - 9198011310134 - 74931*NameSteuerber.*Berufsbez.*089*59958327*Mandantenname - - - - - - -\n|; - - #$DatenTeil .= qq| $k51\n| if ($k51 ne '0'); - #$DatenTeil .= qq| $k86\n| if ($k86 ne '0'); - #$DatenTeil .= qq| $k97\n| if ($k97 ne '0'); - #$DatenTeil .= qq| $k93\n| if ($k93 ne '0'); - #$DatenTeil .= qq| $k94\n| if ($k94 ne '0'); - #$DatenTeil .= qq| $k96\n| if ($k96 ne '0'); - #$DatenTeil .= qq| $k66\n| if ($k66 ne '0'); - #$DatenTeil .= qq| $k83\n| if ($k83 ne '0'); - - my $filename = "$elster_conf->{'path'}/$elster_conf->{'xmlfile'}"; - open(XML, ">$elster_conf->{'path'}/$elster_conf->{'xmlfile'}") - or $form->error("$filename : $!"); - print XML qq|$TransferHeader $DatenTeil|; - close XML; - $lxdebug->leave_sub(); -}