X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fustva.pl;h=9df5a663c668b9a5b5561414f106fd149c1c35b4;hb=b02735f55360e5a4e02dca40458b48cf057ecd7b;hp=73434c253c88d9c57d9b87ca78cebd13431f27e5;hpb=4dbb09950c9f5596646537c12d991c99086fe7c1;p=kivitendo-erp.git diff --git a/bin/mozilla/ustva.pl b/bin/mozilla/ustva.pl index 73434c253..9df5a663c 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,17 +23,20 @@ # German Tax authority Module and later ELSTER Interface #====================================================================== -require "$form->{path}/arap.pl"; +use utf8; +require "bin/mozilla/common.pl"; -#use strict; +#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"; +use List::Util qw(first); + use SL::PE; use SL::RP; use SL::USTVA; @@ -68,1933 +70,1370 @@ use SL::User; # $locale->text('Oct') # $locale->text('Nov') # $locale->text('Dec') + ############################# sub report { - $lxdebug->enter_sub(); - my $myconfig = \%myconfig; - use CGI; + $::lxdebug->enter_sub(); + + my $form = $::form; + my $locale = $::locale; + my %myconfig = %::myconfig; + + $::auth->assert('advance_turnover_tax_return'); + $form->{title} = $locale->text('UStVA'); - $form->{kz10}='' ; #Berichtigte Anmeldung? Ja =1 -# $accrual = ($eur) ? "" : "checked"; -# $cash = ($eur) ? "checked" : ""; - my $year = ''; - my $null = ''; - ($null,$null,$null,$null,$null,$year,$null,$null,$null) = localtime(); - $year += 1900; - + $form->{kz10} = ''; #Berichtigte Anmeldung? Ja =1 Nein=0 + + my $year = substr($form->datetonum($form->current_date(\%myconfig), \%myconfig ), + 0, 4); + my $department = ''; - local $hide =''; + my $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'); - - my @a = qw(signature name company address businessnumber tel fax email - company_street company_city company_email); - map { $form->{$_} = $myconfig->{$_} } @a; - - my $oeffnungszeiten = $form->{FA_Oeffnungszeiten} ; - $oeffnungszeiten =~ s/\\\\n/
/g; - print qq| - - |; - - if ($form->{FA_Name} ne ''){ - print qq| - - - |; - #}# 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|
- |; - } - - #klären, ob $form->{company_street|_address} gesetzt sind - ### - if ( $form->{address} ne '' ) { - my $temp = $form->{address}; - $temp =~ s/\\n/
/; - print qq|$temp|; - ($form->{company_street}, $form->{company_city}) = split("
{address} eq '' and ($form->{company_street} ne '' and $form->{company_city} ne '' ) ) { - print qq|$form->{company_street}
\n| if ($form->{company_street} ne ''); - print qq|$form->{company_city}\n| if ($form->{company_city} ne ''); - } elsif ($form->{company_street} eq '' or $form->{company_city} eq '') { - print qq| - {path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}> - |.$locale->text('Keine Firmenadresse hinterlegt!').qq|\n|; - } - - print qq| -
-
- |.$locale->text('Tel.: ').qq| - $form->{tel} -
- |.$locale->text('Fax.: ').qq| - $form->{fax} -
-
- $form->{email} -
-
- |.$locale->text('Steuernummer: ').qq| - |; - - if ($form->{steuernummer} ne ''){ - print qq|$form->{steuernummer}|; - } else { - print qq| - - Keine Steuernummer hinterlegt!
|; - } - print qq| - -
- -
-
- |; - if ($form->{FA_steuerberater_name} ne ''){ - print 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)); - $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} - |; - } - 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 fehlender Daten deaktiviert.

-

Hilfe:

- -
- |; - my $ausgabe=''; - $hide = q|disabled="disabled"|; - } + 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|!\n|; - print qq| -
-
- -
- - - - - - - - - - - - -
- - - - - - - - -
- |; + $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| + 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||; + + 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} + } + ]; + + # 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, - $lxdebug->leave_sub(); + }; + + print($form->parse_html_template('ustva/report', $template_ref)); + + + + $::lxdebug->leave_sub(); } -############################# + sub help { - $lxdebug->enter_sub(); + $::lxdebug->enter_sub(); + + $::auth->assert('advance_turnover_tax_return'); + # parse help documents under doc - my $tmp = $form->{templates}; - $form->{templates} = 'doc'; - $form->{help} = 'ustva'; - $form->{type} = 'help'; - $form->{format} = 'html'; - &generate_ustva(); + my $tmp = $::form->{templates}; + $::form->{templates} = 'doc'; + $::form->{help} = 'ustva'; + $::form->{type} = 'help'; + $::form->{format} = 'html'; + generate_ustva(); + #$form->{templates} = $tmp; - $lxdebug->leave_sub(); + $::lxdebug->leave_sub(); } +sub show { + $::lxdebug->enter_sub(); -sub show { - $lxdebug->enter_sub(); -#&generate_ustva(); -no strict 'refs'; -&{$form->{nextsub}} ; -use strict 'refs'; - $lxdebug->leave_sub(); -}; + $::auth->assert('advance_turnover_tax_return'); + + #&generate_ustva(); + $::lxdebug->leave_sub(); + call_sub($::form->{"nextsub"}); +} sub ustva_vorauswahl { - $lxdebug->enter_sub(); - #Aktuelles Datum zerlegen: - $locale->date(\%myconfig, $form->current_date(\%myconfig,'0','0'), 0)=~ /(\d\d).(\d\d).(\d\d\d\d)/; - #$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; - my $sel=''; - my $yymmdd=''; - # Testdaten erzeugen: - #$form->{day}= '11'; - #$form->{month}= '01'; - #$form->{year}= 2004; - print qq| + $::lxdebug->enter_sub(); + + my $form = $::form; + my $locale = $::locale; + my %myconfig = %::myconfig; + + $::auth->assert('advance_turnover_tax_return'); + + my $select_vorauswahl; + + #Aktuelles Datum zerlegen: + 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} = 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 = ''; + + # Testdaten erzeugen: + #$form->{day}= '11'; + #$form->{month}= '01'; + #$form->{year}= 2004; + $select_vorauswahl = qq| {day}> {month}> - |; - - if ($form->{FA_voranmeld} eq 'month'){ - # Vorauswahl bei monatlichem Voranmeldungszeitraum - print qq| - |; - - } elsif ($form->{FA_voranmeld} eq 'quarter'){ - # Vorauswahl bei quartalsweisem Voranmeldungszeitraum - my %liste = ( 'A' => '1.', - 'B' => '2.', - 'C' => '3.', - 'D' => '4.', - ); - - my $yy = $form->{year}* 10000; - $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1; - $sel=''; - my $dfv = ''; # Offset für Dauerfristverlängerung - $dfv = '100' if ($form->{FA_dauerfrist} eq '1'); - - SWITCH: { - $yymmdd <= ($yy + 110 + $dfv) && do { - $form->{year} = $form->{year} - 1; - $sel='D'; - last SWITCH; - }; - $yymmdd <= ($yy + 410 + $dfv) && do { - $sel='A'; - last SWITCH; - }; - $yymmdd <= ($yy + 710 + $dfv) && do { - $sel='B'; - last SWITCH; - }; - $yymmdd <= ($yy + 1010 + $dfv) && do { - $sel='C'; - last SWITCH; - }; - $yymmdd <= ($yy + 1231) && do { - $sel='D'; - }; - }; - - print qq||; + + my $key = ''; + foreach $key (sort keys %liste) { + my $selected = ''; + $selected = 'selected' if ($sel eq $key); + $select_vorauswahl .= qq| + + |; + } + $select_vorauswahl .= qq||; + + } elsif ($form->{FA_voranmeld} eq 'quarter') { + + # Vorauswahl bei quartalsweisem Voranmeldungszeitraum + 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; + $sel = ''; + my $dfv = ''; # Offset für Dauerfristverlängerung + $dfv = '100' if ($form->{FA_dauerfrist} eq '1'); + + SWITCH: { + $yymmdd <= ($yy + 110 + $dfv) && do { + $form->{year} = $form->{year} - 1; + $sel = '44'; + last SWITCH; + }; + $yymmdd <= ($yy + 410 + $dfv) && do { + $sel = '41'; + last SWITCH; + }; + $yymmdd <= ($yy + 710 + $dfv) && do { + $sel = '42'; + last SWITCH; + }; + $yymmdd <= ($yy + 1010 + $dfv) && do { + $sel = '43'; + last SWITCH; + }; + $yymmdd <= ($yy + 1231) && do { + $sel = '44'; + }; + } + + $select_vorauswahl .= qq| + $select_vorauswahl .= qq|\n |; - } else { - - # keine Vorauswahl bei Voranmeldungszeitraum - print qq||; - } - $lxdebug->leave_sub(); -} + # keine Vorauswahl bei Voranmeldungszeitraum + $select_vorauswahl .= qq||; + } + $::lxdebug->leave_sub(); -sub config { - $lxdebug->enter_sub(); - edit(); - $lxdebug->leave_sub(); + return $select_vorauswahl; } - +#sub config { +# $::lxdebug->enter_sub(); +# config_step1(); +# $::lxdebug->leave_sub(); +#} sub debug { - $form->debug(); + $::lxdebug->enter_sub(); + $::form->debug(); + $::lxdebug->leave_sub(); } - + sub show_options { - $lxdebug->enter_sub(); -# $form->{PD}{$form->{type}} = "selected"; -# $form->{DF}{$form->{format}} = "selected"; -# $form->{OP}{$form->{media}} = "selected"; -# $form->{SM}{$form->{sendmode}} = "selected"; - my $type = qq| |; - my $media = qq| |; - my $format = qq| |; - if ($latex) { - $format .= qq| |; + $::lxdebug->enter_sub(); + + $::auth->assert('advance_turnover_tax_return'); + + # $form->{PD}{$form->{type}} = "selected"; + # $form->{DF}{$form->{format}} = "selected"; + # $form->{OP}{$form->{media}} = "selected"; + # $form->{SM}{$form->{sendmode}} = "selected"; + my $type = qq| |; + my $media = qq| |; + my $format = + qq| |; + if ($::lx_office_conf{print_templates}{latex}) { + $format .= + qq| |; } - - #my $disabled= qq|disabled="disabled"|; + + #my $disabled= qq|disabled="disabled"|; #$disabled='' if ($form->{elster} eq '1' ); - if ($form->{elster} eq '1'){ - $format .= qq||; + if ($::form->{elster} eq '1') { + $format .= + qq|| + . qq||; } + #$format .= qq||; - print qq| + my $show_options = qq| $type $media - + |; - $lxdebug->leave_sub(); + $::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 + $::lxdebug->enter_sub(); + + my $form = $::form; + my $locale = $::locale; + my %myconfig = %::myconfig; - get_config($userspath, 'finanzamt.ini'); + $::auth->assert('advance_turnover_tax_return'); - # form vars initialisieren - 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) { + # Aufruf von get_config zum Einlesen der Finanzamtdaten aus finanzamt.ini + + my $ustva = USTVA->new(); + $ustva->get_config($::lx_office_conf{paths}{userspath}, 'finanzamt.ini'); + + # init some form vars + my @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; + if ($form->{year} !~ m/^\d\d\d\d$/) { + $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}"; - $form->{'0441'} = "X"; + + #Quater reports + 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}"; - $form->{'0442'} = "X"; + 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}"; - $form->{'0443'} = "X"; + 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}"; - $form->{'0444'} = "X"; + 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->{'0401'} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "02" && do { - $form->{fromdate}="1.2.$form->{year}"; - #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->{"0402"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "03" && do { - $form->{fromdate}="1.3.$form->{year}"; - $form->{todate}="31.3.$form->{year}"; - $form->{"0403"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "04" && do { - $form->{fromdate}="1.4.$form->{year}"; - $form->{todate}="30.4.$form->{year}"; - $form->{"0404"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "05" && do { - $form->{fromdate}="1.5.$form->{year}"; - $form->{todate}="31.5.$form->{year}"; - $form->{"0405"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "06" && do { - $form->{fromdate}="1.6.$form->{year}"; - $form->{todate}="30.6.$form->{year}"; - $form->{"0406"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "07" && do { - $form->{fromdate}="1.7.$form->{year}"; - $form->{todate}="31.7.$form->{year}"; - $form->{"0407"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "08" && do { - $form->{fromdate}="1.8.$form->{year}"; - $form->{todate}="31.8.$form->{year}"; - $form->{"0408"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "09" && do { - $form->{fromdate}="1.9.$form->{year}"; - $form->{todate}="30.9.$form->{year}"; - $form->{"0409"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "10" && do { - $form->{fromdate}="1.10.$form->{year}"; - $form->{todate}="31.10.$form->{year}"; - $form->{"0410"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "11" && do { - $form->{fromdate}="1.11.$form->{year}"; - $form->{todate}="30.11.$form->{year}"; - $form->{"0411"} = "X"; - last SWITCH; - }; - $form->{duetyp} eq "12" && do { - $form->{fromdate}="1.12.$form->{year}"; - $form->{todate}="31.12.$form->{year}"; - $form->{"0412"} = "X"; - last SWITCH; - }; - } - } - #$myconfig = \%myconfig; - RP->ustva(\%myconfig, \%$form); + SWITCH: { + $form->{period} eq "01" && do { + $form->{fromdate} = "$form->{year}0101"; + $form->{todate} = "$form->{year}0131"; + $form->{'0401'} = "X"; + last SWITCH; + }; + $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} = "$form->{year}02$leap"; + $form->{"0402"} = "X"; + last SWITCH; + }; + $form->{period} eq "03" && do { + $form->{fromdate} = "$form->{year}0301"; + $form->{todate} = "$form->{year}0331"; + $form->{"0403"} = "X"; + last SWITCH; + }; + $form->{period} eq "04" && do { + $form->{fromdate} = "$form->{year}0401"; + $form->{todate} = "$form->{year}0430"; + $form->{"0404"} = "X"; + last SWITCH; + }; + $form->{period} eq "05" && do { + $form->{fromdate} = "$form->{year}0501"; + $form->{todate} = "$form->{year}0531"; + $form->{"0405"} = "X"; + last SWITCH; + }; + $form->{period} eq "06" && do { + $form->{fromdate} = "$form->{year}0601"; + $form->{todate} = "$form->{year}0630"; + $form->{"0406"} = "X"; + last SWITCH; + }; + $form->{period} eq "07" && do { + $form->{fromdate} = "$form->{year}0701"; + $form->{todate} = "$form->{year}0731"; + $form->{"0407"} = "X"; + last SWITCH; + }; + $form->{period} eq "08" && do { + $form->{fromdate} = "$form->{year}0801"; + $form->{todate} = "$form->{year}0831"; + $form->{"0408"} = "X"; + last SWITCH; + }; + $form->{period} eq "09" && do { + $form->{fromdate} = "$form->{year}0901"; + $form->{todate} = "$form->{year}0930"; + $form->{"0409"} = "X"; + last SWITCH; + }; + $form->{period} eq "10" && do { + $form->{fromdate} = "$form->{year}1001"; + $form->{todate} = "$form->{year}1031"; + $form->{"0410"} = "X"; + last SWITCH; + }; + $form->{period} eq "11" && do { + $form->{fromdate} = "$form->{year}1101"; + $form->{todate} = "$form->{year}1130"; + $form->{"0411"} = "X"; + last SWITCH; + }; + $form->{period} eq "12" && do { + $form->{fromdate} = "$form->{year}1201"; + $form->{todate} = "$form->{year}1231"; + $form->{"0412"} = "X"; + last SWITCH; + }; + } + + # Kontrollvariablen für die Templates + $form->{"year$_"} = ($form->{year} >= $_ ) ? "1":"0" for 2007..2107; - #??($form->{department}) = split /--/, $form->{department}; - - $form->{period} = $locale->date(\%myconfig, $form->current_date(\%myconfig), 1, 0, 0); - $form->{todate} = $form->current_date($myconfig) unless $form->{todate}; + # Get the USTVA + $ustva->ustva(\%myconfig, \%$form); + + # reformat Dates to dateformat + $form->{fromdate} = $locale->date(\%myconfig, $form->{fromdate}, 0, 0, 0); + + $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); # if there are any dates construct a where if ($form->{fromdate} || $form->{todate}) { - - unless ($form->{todate}) { - $form->{todate} = $form->current_date($myconfig); - } - my $longtodate = $locale->date($myconfig, $form->{todate}, 1, 0, 0); - my $shorttodate = $locale->date($myconfig, $form->{todate}, 0, 0, 0); - - my $longfromdate = $locale->date($myconfig, $form->{fromdate}, 1, 0, 0); - my $shortfromdate = $locale->date($myconfig, $form->{fromdate}, 0, 0, 0); - + $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); + + my $longfromdate = $locale->date(\%myconfig, $form->{fromdate}, 1, 0, 0); + my $shortfromdate = $locale->date(\%myconfig, $form->{fromdate}, 0, 0, 0); + $form->{this_period} = "$shortfromdate
\n$shorttodate"; - $form->{period} = $locale->text('for Period').qq|
\n$longfromdate |.$locale->text('bis').qq| $longtodate|; + $form->{longperiod} = + $locale->text('for Period') + . qq|
\n$longfromdate | + . $locale->text('to (date)') + . qq| $longtodate|; } if ($form->{comparefromdate} || $form->{comparetodate}) { - my $longcomparefromdate = $locale->date(\%myconfig, $form->{comparefromdate}, 1, 0, 0); - my $shortcomparefromdate = $locale->date(\%myconfig, $form->{comparefromdate}, 0, 0, 0); - - my $longcomparetodate = $locale->date(\%myconfig, $form->{comparetodate}, 1, 0, 0); - my $shortcomparetodate = $locale->date(\%myconfig, $form->{comparetodate}, 0, 0, 0); - + my $longcomparefromdate = + $locale->date(\%myconfig, $form->{comparefromdate}, 1, 0, 0); + my $shortcomparefromdate = + $locale->date(\%myconfig, $form->{comparefromdate}, 0, 0, 0); + + my $longcomparetodate = + $locale->date(\%myconfig, $form->{comparetodate}, 1, 0, 0); + my $shortcomparetodate = + $locale->date(\%myconfig, $form->{comparetodate}, 0, 0, 0); + $form->{last_period} = "$shortcomparefromdate
\n$shortcomparetodate"; - $form->{period} .= "
\n$longcomparefromdate ".$locale->text('bis').qq| $longcomparetodate|; + $form->{longperiod} .= + "
\n$longcomparefromdate " + . $locale->text('to (date)') + . qq| $longcomparetodate|; } - $form->{Datum_heute} = $locale->date(\%myconfig, $form->current_date(\%myconfig), 0, 0, 0); + $form->{Datum_heute} = + $locale->date(\%myconfig, $form->current_date(\%myconfig), 0, 0, 0); # setup variables for the form - my @a = (); - @a = qw(company businessnumber tel fax email company_email); + 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 + 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; - - if ( $form->{address} ne '' ) { - my $temp = $form->{address}; - $temp =~ s/\\n/
/; - ($form->{company_street}, $form->{company_city}) = split("
", $temp); + + 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->{format} eq 'pdf' - or $form->{format} eq 'postscript') { - $form->{padding} = "~~"; - $form->{bold} = "\textbf{"; - $form->{endbold} = "}"; - $form->{br} = '\\\\'; - - my @numbers = qw(51r 86r 97r 93r 96 43 45 - 66 62 67); - my $number = ''; - foreach $number ( @numbers){ - $form->{$number} =~ s/,/~~/g; + + ################################ + # + # 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', + }); + + 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', ''); + } + + 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; + } + + } 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; + + foreach my $number (@category_cent) { + $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '2', '0'); + } + + foreach my $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} = "$::lx_office_conf{paths}{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} = "$::lx_office_conf{paths}{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->{taxbird_period} = $period; + } else { + $form->header; + USTVA::error( $locale->text('Wrong Period' )); + ::end_of_request(); + } + + # heuristics for address splitting + # lx-office holds the entire address in a single field. + # taxbird expects it to be splitted into street, zipcode and city + if ($form->{co_street} =~ /\n/) { + my $new_co_street; + for (split /\n/, $form->{co_street}) { + if (/(\d{3,5})\s+(\w+)/) { + $form->{co_zip} = $1; + $form->{co_city} = $2; + } else { + $new_co_street .= $_; + } + } + $form->{co_street} = $new_co_street; + } else { + $form->{co_zip} = $form->{co_city}; + $form->{co_zip} =~ s/\D//g; + $form->{co_city} =~ s/\d//g; + $form->{co_city} =~ s/^\s//g; + } + + 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_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::error( $locale->text('Application Error. No Format given' ) . "!"); + ::end_of_request(); + + } else { # All other Formats are wrong + $form->header; + USTVA::error( $locale->text('Application Error. Wrong Format') . ": " . $form->{format} ); + ::end_of_request(); } - } - elsif ($form->{format} eq 'html') { - $form->{padding} = "  "; - $form->{bold} = ""; - $form->{endbold} = ""; - $form->{br} = "
"; - $form->{address} =~ s/\\n/
/; - - }; - - - if ($form->{format} eq 'elster'){ - &create_winston(); - } 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} .= "-$form->{year}" if ($form->{format} eq 'pdf' - or $form->{format} eq 'postscript'); - - $form->{IN} .= '.tex' if ($form->{format} eq 'pdf' - or $form->{format} eq 'postscript'); - - $form->{IN} .= '.html' if ($form->{format} eq 'html'); - #$form->header; - #print qq|$myconfig
$path|; - $form->parse_template($myconfig, $userspath); + + + } 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') + . '!'); } - $lxdebug->leave_sub(); + + $form->{templates} = $myconfig{templates}; + $form->{templates} = "doc" if ( $form->{type} eq 'help' ); + + if ($form->{format} eq 'generic'){ + + $form->header(); + + my $template_ref = { + taxnumber => $myconfig{taxnumber}, + }; + + print($form->parse_html_template('ustva/generic_taxreport', $template_ref)); + + } else + { + + $form->parse_template(\%myconfig, $::lx_office_conf{paths}{userspath}); + + } + + $::lxdebug->leave_sub(); } +sub config_step1 { + $::lxdebug->enter_sub(); -sub edit { - $lxdebug->enter_sub(); -# edit all taxauthority prefs + $::auth->assert('advance_turnover_tax_return'); - $form->header; - &get_config($userspath, 'finanzamt.ini'); - - #&create_steuernummer; - - my $land=$form->{elsterland}; - my $amt=$form->{elsterFFFF}; - - $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| -
- - - - - - - -
- -
- -
-
-
- - -
- |; - - my @variables = qw( steuernummer elsterland elstersteuernummer elsterFFFF); - my $variable = ''; - foreach $variable (@variables) { - print qq| - |; + # edit all taxauthority prefs + + $::form->header; + + my $ustva = USTVA->new(); + $ustva->get_config($::lx_office_conf{paths}{userspath}, 'finanzamt.ini'); + + my $land = $::form->{elsterland}; + my $amt = $::form->{elsterFFFF}; + + + $::form->{title} = $::locale->text('Tax Office Preferences'); + + + 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'); + 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'); + + my $_hidden_variables_ref; + + 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 $steuernummer_new = ''; - # - print qq| - - - - - {path}> - {login}> - {password}> - - |; - - @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); - - foreach $variable (@variables) { - print qq| - |; + + 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 my $variable (@_hidden_form_variables) { + push @{ $_hidden_variables_ref}, + { 'variable' => $variable, 'value' => $::form->{$variable} }; } - - print qq| -
- -|; - $lxdebug->leave_sub(); + +# 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 config_step2 { + $::lxdebug->enter_sub(); + + my $form = $::form; + my $locale = $::locale; + my %myconfig = %::myconfig; + + $::auth->assert('advance_turnover_tax_return'); -sub edit_form { - $lxdebug->enter_sub(); $form->header(); - print qq| - - |; - my $elsterland = ''; - my $elster_amt = ''; - my $elsterFFFF = ''; + +# print qq| +# +# |; + + my $elsterland = ''; + my $elster_amt = ''; + my $elsterFFFF = ''; my $elstersteuernummer = ''; - &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.')) 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.')) 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, + + my $ustva = USTVA->new(); + $ustva->get_config($::lx_office_conf{paths}{userspath}, 'finanzamt.ini') + if ($form->{saved} eq $locale->text('saved')); + + # Auf Übergabefehler checken + 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('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} && $form->{elsterFFFF} eq $form->{elsterFFFF_new} ? '0':'1'; + + 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 = $ustva->query_finanzamt(\%myconfig, $form); + my %elster_init = %$elster_init; - - if ( $change eq '1' ){ - # Daten ändern - $elsterland = $form->{elsterland_new}; - $elsterFFFF = $form->{elsterFFFF_new}; - $form->{elsterland} = $elsterland; - $form->{elsterFFFF} = $elsterFFFF; + + if ($change eq '1') { + + # Daten ändern + $elsterland = $form->{elsterland_new}; + $elsterFFFF = $form->{elsterFFFF_new}; + $form->{elsterland} = $elsterland; + $form->{elsterFFFF} = $elsterFFFF; $form->{steuernummer} = ''; - &create_steuernummer; + + create_steuernummer(); + # rebuild elster_amt my $amt = ''; - foreach $amt ( keys %{ $elster_init{$form->{elsterland}} } ) { - $elster_amt = $amt if ($elster_init{$form->{elsterland}{$amt} eq $form->{elsterFFFF}} ); - } - - # load the predefined hash data into the FA_* Vars - my @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); - + foreach $amt (keys %{ $elster_init{ $form->{elsterland} } }) { + $elster_amt = $amt + if ($elster_init{ $form->{elsterland}{$amt} eq $form->{elsterFFFF} }); + } + + # load the predefined hash data into the FA_* Vars + my @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); + for (my $i = 0; $i <= 20; $i++) { - $form->{$variables[$i]} = $elster_init->{$elsterland}->{$elsterFFFF}->[$i]; + $form->{ $variables[$i] } = + $elster_init->{$elsterland}->{$elsterFFFF}->[$i]; } } else { $elsterland = $form->{elsterland}; $elsterFFFF = $form->{elsterFFFF}; - - } + + } my $stnr = $form->{steuernummer}; $stnr =~ s/\D+//g; - my $patterncount = $form->{patterncount}; + 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| -
-
-
-
-
-
- - - - - - |; - if ( $form->{warnung} eq "1" ){ - print qq| - - - - |; - } else { - print qq| - - - - |; - } + my $delimiter = $form->{delimiter}; + my $steuernummer = $form->{steuernummer} if ($stnr 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 FA_Name elster - path login password type elster_init saved - ); - my $variable = ''; - foreach $variable (@variables) { - print qq| - |; - } - print qq| - - - - - -
- |; - $lxdebug->leave_sub(); -} + $ustva->get_coa($form, \%myconfig); -sub create_steuernummer { - $lxdebug->enter_sub(); - my $part=$form->{part}; - my $patterncount = $form->{patterncount}; - my $delimiter = $form->{delimiter}; - my $elster_pattern = $form->{elster_pattern}; - # rebuild steuernummer and elstersteuernummer - # es gibt eine gespeicherte steuernummer $form->{steuernummer} - # und die parts und delimiter - - my $h =0; - my $i =0; - - my $steuernummer_new = $part; - my $elstersteuernummer_new = $form->{elster_FFFF}; - $elstersteuernummer_new .= '0'; - - for ( $h = 1; $h < $patterncount; $h++) { - $steuernummer_new .= qq|$delimiter|; - for (my $i = 1; $i <= length($elster_pattern); $i++ ) { - $steuernummer_new .= $form->{"part_$h\_$i"}; - $elstersteuernummer_new .= $form->{"part_$h\_$i"}; - } - } - if ($form->{steuernummer} ne $steuernummer_new){ - $form->{steuernummer} = $steuernummer_new; - $form->{elstersteuernummer} = $elstersteuernummer_new; - $form->{steuernummer_new} = $steuernummer_new; - } else{ - $form->{steuernummer_new} = ''; - $form->{elstersteuernummer_new} = ''; - } - $lxdebug->leave_sub(); -} + my $input_steuernummer = $ustva->steuernummer_input( + $form->{elsterland}, + $form->{elsterFFFF}, + $form->{steuernummer} + ); + $::lxdebug->message(LXDebug->DEBUG1, qq|$input_steuernummer|); -sub get_config { - $lxdebug->enter_sub(); - - my ($userpath, $filename) = @_; - my ($key, $value) = ''; - open(FACONF, "$userpath/$filename") or $form->error("$userpath/$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(); -} + my $_hidden_variables_ref; + my %_hidden_local_variables = ( + 'elsterland' => $elsterland, + 'elsterFFFF' => $elsterFFFF, + 'warnung' => 0, + 'elstersteuernummer' => $elstersteuernummer, + 'steuernummer' => $stnr, + 'lastsub' => 'config_step1', + 'nextsub' => 'save', -sub save { - $lxdebug->enter_sub(); - my $filename = $form->{filename}; - #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen - create_steuernummer; - # Textboxen formatieren: Linebreaks entfernen - # - $form->{FA_Oeffnungszeiten} =~ s/\r\n/\\n/g; - #URL mit http:// davor? - $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 - 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 - if ( $form->{elstersteuernummer} ne '000000000' ) { - $form->{elster}='1'; - open(CONF, ">$userspath/$filename") or $form->error("$filename : $!"); - # create the config file - print CONF 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=|; - if ($form->{$key} ne 'Y') { - print CONF qq|$form->{$key}\n|; - } - if ($form->{$key} eq 'Y') { - print CONF qq|checked \n|; - } - } - print CONF qq|\n\n|; - close CONF; - $form->{saved} = $locale->text('saved'); - - } else { - - $form->{saved} = $locale->text('Bitte eine Steuernummer angeben'); - } + ); - &edit_form; - $lxdebug->leave_sub(); -} + foreach my $variable (keys %_hidden_local_variables) { + push @{ $_hidden_variables_ref }, + { 'variable' => $variable, 'value' => $_hidden_local_variables{$variable} }; + } -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('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| -
- -
- |; + 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} }; } - print qq| -
-
- |; - $lxdebug->leave_sub(); + + my $template_ref = { + input_steuernummer => $input_steuernummer, + readonly => '', #q|disabled="disabled"|, + callback => $form->{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'); -sub create_winston { - $lxdebug->enter_sub(); - &get_config($userspath, 'finanzamt.ini'); + my $part = $::form->{part}; + my $patterncount = $::form->{patterncount}; + my $delimiter = $::form->{delimiter}; + my $elster_pattern = $::form->{elster_pattern}; - # 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."); - }; - } + # rebuild steuernummer and elstersteuernummer + # es gibt eine gespeicherte steuernummer $form->{steuernummer} + # und die parts und delimiter - $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; - $lxdebug->leave_sub(); -} + my $h = 0; + my $i = 0; + my $steuernummer_new = $part; + my $elstersteuernummer_new = $::form->{elster_FFFF}; + $elstersteuernummer_new .= '0'; -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(); + for ($h = 1; $h < $patterncount; $h++) { + $steuernummer_new .= qq|$delimiter|; + for (my $i = 1; $i <= length($elster_pattern); $i++) { + $steuernummer_new .= $::form->{"part_$h\_$i"}; + $elstersteuernummer_new .= $::form->{"part_$h\_$i"}; + } + } + if ($::form->{steuernummer} ne $steuernummer_new) { + $::form->{steuernummer} = $steuernummer_new; + $::form->{elstersteuernummer} = $elstersteuernummer_new; + $::form->{steuernummer_new} = $steuernummer_new; + } else { + $::form->{steuernummer_new} = ''; + $::form->{elstersteuernummer_new} = ''; + } + $::lxdebug->leave_sub(); } -sub continue { - $lxdebug->enter_sub(); -# allow Symbolic references just here: -no strict 'refs'; -&{$form->{nextsub}}; -use strict 'refs'; - $lxdebug->leave_sub(); -} +sub save { + $::lxdebug->enter_sub(); -sub back { &{$form->{lastsub}} }; + $::auth->assert('advance_turnover_tax_return'); -sub elster_hash { - $lxdebug->enter_sub(); - my $finanzamt = USTVA::query_finanzamt(\%myconfig, \%$form); - $lxdebug->leave_sub(); - return $finanzamt -} + my $filename = "$::form->{login}_$::form->{filename}"; + $filename =~ s|.*/||; + + #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen + create_steuernummer(); -sub test { - $lxdebug->enter_sub(); -# biegt nur den Testeintrag in Programm->Test auf eine Routine um + # Textboxen formatieren: Linebreaks entfernen + # + $::form->{FA_Oeffnungszeiten} =~ s/\r\n/\\n/g; -$form->header; -&elster_send; - $lxdebug->leave_sub(); -} + #URL mit http:// davor? + $::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 + 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); -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(); -} + # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer + if ($::form->{elstersteuernummer} ne '000000000') { + + $::form->{elster} = '1'; + + open my $ustvaconfig, ">", "$::lx_office_conf{paths}{userspath}/$filename" or $::form->error("$filename : $!"); + # create the config file + print {$ustvaconfig} qq|# Configuration file for USTVA\n\n|; + my $key = ''; + foreach $key (sort @config) { + $::form->{$key} =~ s/\\/\\\\/g; + # strip M + $::form->{$key} =~ s/\r\n/\n/g; -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|$_
|; + print {$ustvaconfig} qq|$key=|; + if ($::form->{$key} ne 'Y') { + print {$ustvaconfig} qq|$::form->{$key}\n|; + } + if ($::form->{$key} eq 'Y') { + print {$ustvaconfig} qq|checked \n|; + } } - $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(); -} + print {$ustvaconfig} qq|\n\n|; + close $ustvaconfig; + $::form->{saved} = $::locale->text('saved'); + } else { -sub elster_feedback { - $lxdebug->enter_sub(); - my ($file) = @_; - my @content = (); - print qq|feedback:
|; - if (-f "$file") { - open(FH, "$file"); - @content = ; - close(FH); + $::form->{saved} = $::locale->text('Choose a Tax Number'); } - $lxdebug->leave_sub(); - return(@content); + + config_step2(); + $::lxdebug->leave_sub(); } -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(); +sub continue { + $::lxdebug->enter_sub(); - return $elster_conf; + # allow Symbolic references just here: + call_sub($::form->{"nextsub"}); + $::lxdebug->leave_sub(); } -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(); +sub back { + $::lxdebug->enter_sub(); + call_sub($::form->{"lastsub"}); + $::lxdebug->leave_sub(); }