X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fustva.pl;h=50108bd083652c11bf4cc9c41a0b964c324b24bf;hb=2da8f5ca6e9f7a164585d180eef47169298f12c5;hp=99210941cc879ed23e202e57bcaec1acd25625e5;hpb=02cef2f254b420003c079c8e2fb3f9a9c4edf776;p=kivitendo-erp.git diff --git a/bin/mozilla/ustva.pl b/bin/mozilla/ustva.pl index 99210941c..50108bd08 100644 --- a/bin/mozilla/ustva.pl +++ b/bin/mozilla/ustva.pl @@ -1,6 +1,5 @@ -#!/bin/perl #===================================================================== -# Lx-Office ERP +# kivitendo ERP # Copyright (c) 2004 by Udo Spallek, Aachen # # Author: Udo Spallek @@ -19,12 +18,17 @@ # GNU General Public License for more details. # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software -# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. +# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, +# MA 02110-1335, USA. #====================================================================== # German Tax authority Module and later ELSTER Interface +# 08.01.14 ELSTER Interface software (taxbird/winston) removed #====================================================================== -require "$form->{path}/arap.pl"; +use strict; +use utf8; + +require "bin/mozilla/common.pl"; #use strict; #no strict 'refs'; @@ -34,7 +38,9 @@ require "$form->{path}/arap.pl"; #our ($myconfig); #use CGI::Carp "fatalsToBrowser"; -use SL::PE; +use List::Util qw(first); + +use SL::DB::Default; use SL::RP; use SL::USTVA; use SL::User; @@ -67,453 +73,221 @@ 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'); + + my $defaults = SL::DB::Default->get; $form->{title} = $locale->text('UStVA'); - $form->{kz10} = ''; #Berichtigte Anmeldung? Ja =1 + $form->{kz10} = ''; #Berichtigte Anmeldung? Ja =1 Nein=0 - my $year = substr( - $form->datetonum($form->current_date(\%myconfig), - \%myconfig - ), - 0, 4); + my $year = substr($form->datetonum($form->current_date(\%myconfig), \%myconfig ), + 0, 4); my $department = ''; - local $hide = ''; + my $hide = ''; $form->header; - print qq| - + # Einlesen der Finanzamtdaten + my $ustva = USTVA->new(); + $ustva->get_config(); + $ustva->get_finanzamt(); -
{script}> + my $geierlein_enabled = 0; + my $geierlein_path = $::lx_office_conf{paths}{geierlein_path}; - + if ( $geierlein_path && length($geierlein_path) > 0 ) {$geierlein_enabled=1;} - - - - - - - - - - - -
$form->{title}
- - $department -|; +# $::lxdebug->message(LXDebug->DEBUG2,"geierlein_enabled=".$geierlein_enabled." path=".$geierlein_path); + # Hier Einlesen der user-config + # steuernummer entfernt für prerelease + my @a = qw( + signature name + 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 co_bankname + co_bankname1 co_bankname2 co_bankname3 co_blz co_blz1 + co_blz2 co_blz3 co_accountnr co_accountnr1 co_accountnr2 + co_accountnr3 + ); - # Hier Aufruf von get_config aus bin/mozilla/fa.pl zum - # Einlesen der Finanzamtdaten - &get_config($userspath, 'finanzamt.ini'); + $form->{$_} = $myconfig{$_} for @a; - # 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 $openings = $form->{fa_oeffnungszeiten}; + $openings =~ s/\\\\n/
/g; - 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|
- |; - } + 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 - # + # 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/
/; + $temp =~ s/\n/
/; ($form->{co_street}, $form->{co_city}) = split("
", $temp); - $form->{co_city} =~ s/\\n//g; + $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|; - } + + 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|; + $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!
|; - } - print qq| -
- | . $locale->text('ELSTER-Steuernummer: ') . qq| - $form->{elstersteuernummer} -
-
- -
-
- |; - 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 } (2003 .. ($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'); + + $_checked = "checked" if ($form->{kz22} eq '1'); + my $checkbox_kz_22 = qq|| + . $locale->text('Receipts attached/extra'); + + $_checked = "checked" if ($form->{kz29} eq '1'); + my $checkbox_kz_29 = qq|| + . $locale->text('Accounting desired'); + + $_checked = "checked" if ($form->{kz26} eq '1'); + my $checkbox_kz_26 = qq|| + . $locale->text('Direct debit revoked'); + + my $method_local = ($form->{accounting_method} eq 'accrual') ? $locale->text('accrual') + : ($form->{accounting_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_2} } - print qq| - -
-
-
- - | . $locale->text('Ausgabeformat') . qq| - - |; + ); - &show_options; - my $ausgabe = '1'; - print qq| -
- |; + $ustva->get_coa($form); # fetches coa and modifies some form variables - } else { - print qq| - 		-
- - | . $locale->text('Hinweise') . qq| - -

| - . $locale->text('Missing Preferences: Outputroutine disabled') - . qq|

-

| . $locale->text('Help:') . qq|

-
    -
  • | . $locale->text('Hint-Missing-Preferences') . qq|
    • -
-
- |; - my $ausgabe = ''; - $hide = q|disabled="disabled"|; - } + my $template_ref = { + openings => $openings, + company_given => $company_given, + address_given => $address_given, + taxnumber_given => $taxnumber_given, + fa_name_given => $fa_name_given, + taxnumber => $defaults->taxnumber, + select_year => $select_year, + period_local => $period_local, + method_local => $method_local, + ustva_vorauswahl => $ustva_vorauswahl, + checkbox_kz_10 => $checkbox_kz_10, + checkbox_kz_22 => $checkbox_kz_22, + checkbox_kz_29 => $checkbox_kz_29, + checkbox_kz_26 => $checkbox_kz_26, + tax_office_banks => \@tax_office_banks_ref, + geierlein_enabled => $geierlein_enabled, + geierlein_path => $geierlein_path, + select_options => &show_options, - print qq| -
-
- -
- - - - - - - - - - - - -
- - - - - - - -
- |; + print($form->parse_html_template('ustva/report', $template_ref)); - print qq| - - - |; - $lxdebug->leave_sub(); + + $::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(); - - #$form->{templates} = $tmp; - $lxdebug->leave_sub(); + $::form->{templates} = 'doc'; + $::form->{help} = 'ustva'; + $::form->{type} = 'help'; + $::form->{format} = 'html'; + generate_ustva(); + + $::lxdebug->leave_sub(); } sub show { - $lxdebug->enter_sub(); + $::lxdebug->enter_sub(); - #&generate_ustva(); - no strict 'refs'; - $lxdebug->leave_sub(); - &{ $form->{nextsub} }; - use strict 'refs'; + $::auth->assert('advance_turnover_tax_return'); + + #generate_ustva(); + $::lxdebug->leave_sub(); + call_sub($::form->{"nextsub"}); } sub ustva_vorauswahl { - $lxdebug->enter_sub(); + $::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); @@ -522,8 +296,8 @@ sub ustva_vorauswahl { $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 + $::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|); @@ -535,43 +309,39 @@ sub ustva_vorauswahl { #$form->{day}= '11'; #$form->{month}= '01'; #$form->{year}= 2004; - print qq| - {day}> - {month}> - - - |; + $select_vorauswahl = qq| + + + + + |; - if ($form->{FA_voranmeld} eq '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') { + } 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'), + 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'); + 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'; + $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(); -} + $::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 { - $lxdebug->enter_sub(); - $form->debug(); - $lxdebug->leave_sub(); + $::lxdebug->enter_sub(); + $::form->debug(); + $::lxdebug->leave_sub(); } sub show_options { - $lxdebug->enter_sub(); + $::lxdebug->enter_sub(); + + $::auth->assert('advance_turnover_tax_return'); # $form->{PD}{$form->{type}} = "selected"; # $form->{DF}{$form->{format}} = "selected"; @@ -758,200 +533,80 @@ sub show_options { my $media = qq| |; my $format = qq| |; - if ($latex_templates) { - $format .= - qq| |; - } #my $disabled= qq|disabled="disabled"|; #$disabled='' if ($form->{elster} eq '1' ); - if ($form->{elster} eq '1') { + #if ($::form->{elster} eq '1') { + if ( 1 ) { $format .= - qq||; } - #$format .= qq||; - print qq| + my $show_options = qq| $type $media + . $::locale->text('Choose Outputformat') . qq|">$format |; - $lxdebug->leave_sub(); + $::lxdebug->leave_sub(); + + return $show_options; } sub generate_ustva { - $lxdebug->enter_sub(); + $::lxdebug->enter_sub(); - # Aufruf von get_config aus bin/mozilla/ustva.pl zum - # Einlesen der Finanzamtdaten aus finanzamt.ini + 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) { - $form->{$item} = ""; - } - if ($form->{reporttype} eq "custom") { - - #forgotten the year --> thisyear - 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|); - } + my $defaults = SL::DB::Default->get; + $form->error($::locale->text('No print templates have been created for this client yet. Please do so in the client configuration.')) if !$defaults->templates; + $form->{templates} = $defaults->templates; - #yearly report - if ($form->{duetyp} eq "13") { - $form->{fromdate} = "$form->{year}0101"; - $form->{todate} = "$form->{year}1231"; - } - #Quater reports - if ($form->{duetyp} eq "A") { - $form->{fromdate} = "$form->{year}0101"; - $form->{todate} = "$form->{year}0331"; - $form->{'0441'} = "X"; - } - if ($form->{duetyp} eq "B") { - $form->{fromdate} = "$form->{year}0401"; - $form->{todate} = "$form->{year}0630"; - $form->{'0442'} = "X"; - } - if ($form->{duetyp} eq "C") { - $form->{fromdate} = "$form->{year}0701"; - $form->{todate} = "$form->{year}0930"; - $form->{'0443'} = "X"; - } - if ($form->{duetyp} eq "D") { - $form->{fromdate} = "$form->{year}1001"; - $form->{todate} = "$form->{year}1231"; - $form->{'0444'} = "X"; - } + my $ustva = USTVA->new(); + $ustva->get_config(); + $ustva->get_finanzamt(); - #Monthly reports - SWITCH: { - $form->{duetyp} 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} = "$form->{year}0201"; + # Setze Anmeldungszeitraum - #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->{duetyp} 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} = "$form->{year}0401"; - $form->{todate} = "$form->{year}0430"; - $form->{"0404"} = "X"; - last SWITCH; - }; - $form->{duetyp} 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} = "$form->{year}0601"; - $form->{todate} = "$form->{year}0630"; - $form->{"0406"} = "X"; - last SWITCH; - }; - $form->{duetyp} 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} = "$form->{year}0801"; - $form->{todate} = "$form->{year}0831"; - $form->{"0408"} = "X"; - last SWITCH; - }; - $form->{duetyp} 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} = "$form->{year}1001"; - $form->{todate} = "$form->{year}1031"; - $form->{"0410"} = "X"; - last SWITCH; - }; - $form->{duetyp} 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} = "$form->{year}1201"; - $form->{todate} = "$form->{year}1231"; - $form->{"0412"} = "X"; - last SWITCH; - }; - } - } + $ustva->set_FromTo(\%$form); - # using dates in ISO-8601 format: yyyymmmdd for Postgres... - USTVA->ustva(\%myconfig, \%$form); + # 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} = $form->current_date(\%myconfig) unless $form->{todate}; $form->{todate} = $locale->date(\%myconfig, $form->{todate}, 0, 0, 0); - $form->{period} = + $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); - } + $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 $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); + 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} = + $form->{longperiod} = $locale->text('for Period') . qq|
\n$longfromdate | - . $locale->text('bis') + . $locale->text('to (date)') . qq| $longtodate|; } @@ -967,9 +622,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|; } @@ -977,1237 +632,425 @@ 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 + my @a = qw(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_fax co_fax1 co_email co_email1 co_url co_url1 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; + $form->{$_} = $myconfig{$_} for @a; + $form->{$_} = $defaults->$_ for qw(company address co_ustid duns); if ($form->{address} ne '') { my $temp = $form->{address}; - $temp =~ s/\\n/
/; - ($form->{co_street}, $form->{co_city}) = split("
", $temp); + $temp =~ s/\n/
/; + ($form->{co_street}, $form->{co_city}) = split("
", $temp,2); $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') { - my @numbers = qw(511 861 36 80 971 931 98 96 53 74 - 85 65 66 61 62 Z67 63 64 59 69 39 83 - Z43 Z45 Z53 Z62 Z65); + $form->{id} = []; + $form->{amount} = []; - my $number = ''; + if ( $form->{format} eq 'pdf' or $form->{format} eq 'postscript') { - # 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; + $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 (@{$::form->{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 (@{$::form->{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/
/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 (@{$::form->{category_cent}}) { + $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '2', '0'); + } + + foreach my $number (@{$::form->{category_euro}}) { + $form->{$number} = $form->format_amount(\%myconfig, $form->{$number}, '0', '0'); + } + } elsif ( $form->{format} eq '' ){ # No format error. + + $form->header; + USTVA::error( $locale->text('Application Error. No Format given' ) . "!"); + $::dispatcher->end_request; - if ($form->{format} eq 'elster') { - if ($form->{duetyp} eq '13') { + } else { # All other Formats are wrong $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. Wrong Format') . ": " . $form->{format} ); + $::dispatcher->end_request; } - } 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 + { + + $form->{USTVA} = []; + + if ( $form->{format} eq 'generic') { # Formatierungen für HTML Ausgabe + + my $rec_ref = {}; + for my $kennziffer (@{$::form->{category_cent}}, @{$::form->{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; + } + } - $form->{IN} .= "-$form->{year}" - if ( $form->{format} eq 'pdf' - or $form->{format} eq 'postscript'); + } + + if ( $form->{period} eq '13' and $form->{format} ne 'html') { + $form->header; + USTVA::info( + $locale->text( + 'Yearly taxreport not yet implemented') + . '!'); + } + + $form->{templates} = "doc" if ( $form->{type} eq 'help' ); - $form->{IN} .= '.tex' - if ( $form->{format} eq 'pdf' - or $form->{format} eq 'postscript'); + if ($form->{format} eq 'generic'){ + + $form->header(); + + my $template_ref = { + taxnumber => $defaults->taxnumber, + }; + + print($form->parse_html_template('ustva/generic_taxreport', $template_ref)); + + } elsif ( $form->{format} eq 'elstertaxbird' ) { + $form->parse_template(\%myconfig); + } else + { + # add a prefix for ustva pos numbers, i.e.: 81 -> post_ustva_81 + $form->{"pos_ustva_$_"} = $form->{$_} for grep { m{^\d+} } keys %{ $form }; + $form->{title} = $locale->text('Advance turnover tax return'); + + $form->header; + print $form->parse_html_template('ustva/ustva'); - $form->{IN} .= '.html' if ($form->{format} eq 'html'); - #$form->header; - #print qq|$myconfig
$path|; - $form->parse_template($myconfig, $userspath); } - $lxdebug->leave_sub(); + + $::lxdebug->leave_sub(); } -sub edit { - $lxdebug->enter_sub(); +sub config_step1 { + $::lxdebug->enter_sub(); + + $::auth->assert('advance_turnover_tax_return'); + +$::form->{title} = $::locale->text('Tax Office Preferences'); # edit all taxauthority prefs - $form->header; - &get_config($userspath, 'finanzamt.ini'); - - #&create_steuernummer; - - 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| - |; + $::form->header; - #print qq|$form->{terminal}|; + my $ustva = USTVA->new(); + $ustva->get_config(); + $ustva->get_finanzamt(); - 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 $land = $::form->{fa_land_nr}; + my $amt = $::form->{fa_bufa_nr}; - my @variables = qw( steuernummer elsterland elstersteuernummer elsterFFFF); - my $variable = ''; - foreach $variable (@variables) { - print qq| - |; + + $::form->{title} = $::locale->text('Tax Office Preferences'); + + + my $select_tax_office = $ustva->fa_auswahl($land, $amt, $ustva->query_finanzamt(\%::myconfig, $::form)); + my $method_local = ($::form->{accounting_method} eq 'accrual') ? $::locale->text('accrual') + : ($::form->{accounting_method} eq 'cash') ? $::locale->text('cash') + : ''; + + my $checked_monthly = $::form->{fa_voranmeld} eq 'month' ? "checked" : ''; + my $checked_quarterly = $::form->{fa_voranmeld} eq 'quarter' ? "checked" : ''; + my $checked_dauerfristverlaengerung = $::form->{da_dauerfrist} eq '1' ? "checked" : ''; + + 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); + my @_hidden_form_variables = $ustva->get_fiamt_vars(); + push @_hidden_form_variables ,qw(fa_bufa_nr taxnumber accounting_method coa); - foreach $variable (@variables) { - print qq| - |; + foreach my $variable (@_hidden_form_variables) { + push @{ $_hidden_variables_ref}, + { 'variable' => $variable, 'value' => $::form->{$variable} }; } - print qq| -
- -|; - $lxdebug->leave_sub(); + $ustva->get_coa($::form); # fetches coa and modifies some form variables + + # Variablen für das Template zur Verfügung stellen + my $template_ref = { + select_tax_office => $select_tax_office, + method_local => $method_local, + 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 { - $lxdebug->enter_sub(); +sub config_step2 { + $::lxdebug->enter_sub(); + + my $form = $::form; + my $locale = $::locale; + my %myconfig = %::myconfig; + + $::auth->assert('advance_turnover_tax_return'); + $form->header(); - 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 + + my $fa_land_nr = ''; + my $fa_bufa_nr = ''; + + my $ustva = USTVA->new(); + $ustva->get_config() if ($form->{saved} eq $locale->text('saved')); + my $coa = $::form->{coa}; + $form->{"COA_$coa"} = '1'; + $form->{COA_Germany} = '1' if ($coa =~ m/^germany/i); + $ustva->get_finanzamt(); + + + # 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'); + if ( $form->{fa_bufa_nr_new} eq 'Auswahl' + || $form->{fa_land_nr_new} eq 'Auswahl'); USTVA::info( $locale->text('Missing Method!') . "\n" . $locale->text('USTVA-Hint: Method')) - if ($form->{method} eq ''); + if ($form->{accounting_method} eq ''); - # Klären, ob Variablen bereits befüllt sind UND ob veräderungen auf + # Klären, ob Variablen bereits befüllt sind UND ob veränderungen 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'; +# $::lxdebug->message(LXDebug->DEBUG2,"land old=".$form->{fa_land_nr}." new=".$form->{fa_land_nr_new}); +# $::lxdebug->message(LXDebug->DEBUG2,"bufa old=".$form->{fa_bufa_nr}." new=".$form->{fa_bufa_nr_new}); + my $change = $form->{fa_land_nr} eq $form->{fa_land_nr_new} + && $form->{fa_bufa_nr} eq $form->{fa_bufa_nr_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') { - # Daten ändern - $elsterland = $form->{elsterland_new}; - $elsterFFFF = $form->{elsterFFFF_new}; - $form->{elsterland} = $elsterland; - $form->{elsterFFFF} = $elsterFFFF; - $form->{steuernummer} = ''; - &create_steuernummer; + # Daten ändern + $fa_land_nr = $form->{fa_land_nr_new}; + $fa_bufa_nr = $form->{fa_bufa_nr_new}; + $form->{fa_land_nr} = $fa_land_nr; + $form->{fa_bufa_nr} = $fa_bufa_nr; + $form->{taxnumber} = ''; - # rebuild elster_amt - my $amt = ''; - foreach $amt (keys %{ $elster_init{ $form->{elsterland} } }) { - $elster_amt = $amt - if ($elster_init{ $form->{elsterland}{$amt} eq $form->{elsterFFFF} }); - } + create_steuernummer(); - # 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]; - } + # rebuild elster_amt + $ustva->get_finanzamt(); } else { - $elsterland = $form->{elsterland}; - $elsterFFFF = $form->{elsterFFFF}; + $fa_land_nr = $form->{fa_land_nr}; + $fa_bufa_nr = $form->{fa_bufa_nr}; } - my $stnr = $form->{steuernummer}; +# $::lxdebug->message(LXDebug->DEBUG2, "form stnr=".$form->{taxnumber}." fa_bufa_nr=".$fa_bufa_nr. +# " pattern=".$form->{elster_pattern}." fa_land_nr=".$fa_land_nr); + my $stnr = $form->{taxnumber}; $stnr =~ s/\D+//g; - 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 $taxnumber = $stnr eq '' ? $form->{taxnumber} : ''; + + $form->{fa_oeffnungszeiten} =~ s/\\\\n/\n/g; - print qq| - -

$form->{saved}

-
- |; - 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 + $ustva->get_coa($form); # fetches coa and modifies some form variables + + my $input_steuernummer = $ustva->steuernummer_input( + $fa_land_nr, + $fa_bufa_nr, + $form->{taxnumber} ); - my $variable = ''; - foreach $variable (@variables) { - print qq| - |; + +# $::lxdebug->message(LXDebug->DEBUG2, qq|$input_steuernummer|); + + + my $_hidden_variables_ref; + + my %_hidden_local_variables = ( + 'fa_land_nr' => $fa_land_nr, + 'fa_bufa_nr' => $fa_bufa_nr, + 'warnung' => 0, + 'taxnumber' => $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| - - - - - - -
- |; - $lxdebug->leave_sub(); + + my @_hidden_form_variables = qw( + fa_dauerfrist fa_steuerberater_city fa_steuerberater_name + fa_steuerberater_street fa_steuerberater_tel + fa_voranmeld fa_dauerfrist + accounting_method + type + saved callback + ); + + foreach my $variable (@_hidden_form_variables) { + push @{ $_hidden_variables_ref}, + { 'variable' => $variable, 'value' => $form->{$variable} }; + } + + my $template_ref = { + input_steuernummer => $input_steuernummer, + readonly => '', #q|disabled="disabled"|, + callback => $form->{callback}, + COA_Germany => $form->{COA_Germany}, + 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(); - 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} + $::lxdebug->enter_sub(); + + $::auth->assert('advance_turnover_tax_return'); + + my $part = $::form->{part}; + my $patterncount = $::form->{patterncount}; + my $delimiter = $::form->{delimiter1}; + my $elster_pattern = $::form->{elster_pattern}; + + # rebuild taxnumber + # es gibt eine gespeicherte steuernummer $form->{taxnumber} # und die parts und delimiter my $h = 0; my $i = 0; - my $steuernummer_new = $part; - my $elstersteuernummer_new = $form->{elster_FFFF}; - $elstersteuernummer_new .= '0'; + my $taxnumber_new = $part; for ($h = 1; $h < $patterncount; $h++) { - $steuernummer_new .= qq|$delimiter|; + $delimiter = $::form->{delimiter2} if $h > 1; + $taxnumber_new .= qq|$delimiter|; for (my $i = 1; $i <= length($elster_pattern); $i++) { - $steuernummer_new .= $form->{"part_$h\_$i"}; - $elstersteuernummer_new .= $form->{"part_$h\_$i"}; + $taxnumber_new .= $::form->{"part_$h\_$i"}; } } - if ($form->{steuernummer} ne $steuernummer_new) { - $form->{steuernummer} = $steuernummer_new; - $form->{elstersteuernummer} = $elstersteuernummer_new; - $form->{steuernummer_new} = $steuernummer_new; +# $::lxdebug->message(LXDebug->DEBUG2, "oldstnr=".$::form->{taxnumber}." newstnr=".$taxnumber_new); + if ($::form->{taxnumber} ne $taxnumber_new) { + $::form->{taxnumber} = $taxnumber_new; + $::form->{taxnumber_new} = $taxnumber_new; } else { - $form->{steuernummer_new} = ''; - $form->{elstersteuernummer_new} = ''; + $::form->{taxnumber_new} = ''; } - $lxdebug->leave_sub(); -} - -sub get_config { - $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(); + $::lxdebug->leave_sub(); } sub save { - $lxdebug->enter_sub(); - my $filename = "$form->{login}_$form->{filename}"; + $::lxdebug->enter_sub(); + + $::auth->assert('advance_turnover_tax_return'); #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen - create_steuernummer; + create_steuernummer(); # Textboxen formatieren: Linebreaks entfernen # - $form->{FA_Oeffnungszeiten} =~ s/\r\n/\\n/g; + $::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'); + $::form->{fa_internet} =~ s/^http:\/\///; + $::form->{fa_internet} = 'http://' . $::form->{fa_internet}; - } else { + # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer TODO ?? + if (1) { + my $ustva = USTVA->new(); + $ustva->save_config(); - $form->{saved} = $locale->text('Bitte eine Steuernummer angeben'); - } + #$::form->{elster} = '1'; + $::form->{saved} = $::locale->text('saved'); - &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." - ); - }; + $::form->{saved} = $::locale->text('Choose a Tax Number'); } - $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->{"83"}) * 100 ; # Endbetrag - my $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100; # - # - # Now build the xml content - # - - $form->{elster} = qq| - - - - $form->{elsterFFFF}$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(); + 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(); + $::lxdebug->enter_sub(); # allow Symbolic references just here: - no strict 'refs'; - &{ $form->{nextsub} }; - use strict 'refs'; - $lxdebug->leave_sub(); + call_sub($::form->{"nextsub"}); + $::lxdebug->leave_sub(); } sub back { - $lxdebug->enter_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 - - $form->header; - &elster_send; - $lxdebug->leave_sub(); -} - -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(); + $::lxdebug->enter_sub(); + call_sub($::form->{"lastsub"}); + $::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(); -} -