2 #=====================================================================
4 # Copyright (c) 2004 by Udo Spallek, Aachen
8 # Web: http://www.lx-office.org
11 # This program is free software; you can redistribute it and/or modify
12 # it under the terms of the GNU General Public License as published by
13 # the Free Software Foundation; either version 2 of the License, or
14 # (at your option) any later version.
16 # This program is distributed in the hope that it will be useful,
17 # but WITHOUT ANY WARRANTY; without even the implied warranty of
18 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 # GNU General Public License for more details.
20 # You should have received a copy of the GNU General Public License
21 # along with this program; if not, write to the Free Software
22 # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
23 #======================================================================
24 # German Tax authority Module and later ELSTER Interface
25 #======================================================================
27 require "$form->{path}/arap.pl";
33 #use warnings FATAL=> 'all';
34 #use vars qw($locale $form %myconfig);
36 #use CGI::Carp "fatalsToBrowser";
44 # this is for our long dates
45 # $locale->text('January')
46 # $locale->text('February')
47 # $locale->text('March')
48 # $locale->text('April')
49 # $locale->text('May ')
50 # $locale->text('June')
51 # $locale->text('July')
52 # $locale->text('August')
53 # $locale->text('September')
54 # $locale->text('October')
55 # $locale->text('November')
56 # $locale->text('December')
58 # this is for our short month
59 # $locale->text('Jan')
60 # $locale->text('Feb')
61 # $locale->text('Mar')
62 # $locale->text('Apr')
63 # $locale->text('May')
64 # $locale->text('Jun')
65 # $locale->text('Jul')
66 # $locale->text('Aug')
67 # $locale->text('Sep')
68 # $locale->text('Oct')
69 # $locale->text('Nov')
70 # $locale->text('Dec')
71 #############################
74 $lxdebug->enter_sub();
75 my $myconfig = \%myconfig;
77 $form->{title} = $locale->text('UStVA');
78 $form->{kz10}='' ; #Berichtigte Anmeldung? Ja =1
79 # $accrual = ($eur) ? "" : "checked";
80 # $cash = ($eur) ? "checked" : "";
83 ($null,$null,$null,$null,$null,$year,$null,$null,$null) = localtime();
93 <form method=post action=$form->{script}>
95 <input type=hidden name=title value="$form->{title}">
99 <th class=listtop>$form->{title}</th>
107 # Hier Aufruf von get_config aus bin/mozilla/fa.pl zum
108 # Einlesen der Finanzamtdaten
109 &get_config($userspath, 'finanzamt.ini');
111 my @a = qw(signature name company address businessnumber tel fax email
112 company_street company_city company_email);
113 map { $form->{$_} = $myconfig->{$_} } @a;
115 my $oeffnungszeiten = $form->{FA_Oeffnungszeiten} ;
116 $oeffnungszeiten =~ s/\\\\n/<br>/g;
119 <td width="50%" align="left" valign="top">
122 <b>|.$locale->text('Firma').qq|</b>
125 if ( $form->{company} ne '' ){
126 print qq|<h3>$form->{company}</h3>\n|;
130 <a href=am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}>
131 |.$locale->text('Kein Firmenname hinterlegt!').qq|</a><br>
135 #klären, ob $form->{company_street|_address} gesetzt sind
137 if ( $form->{address} ne '' ) {
138 my $temp = $form->{address};
139 $temp =~ s/\\n/<br \/>/;
141 ($form->{company_street}, $form->{company_city}) = split("<br \/", $temp);
142 } elsif ($form->{address} eq '' and ($form->{company_street} ne '' and $form->{company_city} ne '' ) ) {
143 print qq|$form->{company_street}<br>\n| if ($form->{company_street} ne '');
144 print qq|$form->{company_city}\n| if ($form->{company_city} ne '');
145 } elsif ($form->{company_street} eq '' or $form->{company_city} eq '') {
147 <a href=am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}>
148 |.$locale->text('Keine Firmenadresse hinterlegt!').qq|</a>\n|;
154 |.$locale->text('Tel.: ').qq|
157 |.$locale->text('Fax.: ').qq|
164 |.$locale->text('Steuernummer: ').qq|
167 if ($form->{steuernummer} ne ''){
168 print qq|$form->{steuernummer}|;
171 <a href="ustva.pl?path=$form->{path}&action=edit&level=Programm--Finanzamteinstellungen&login=$form->{login}&password=$form->{password}">
172 Keine Steuernummer hinterlegt!</a><br>|;
176 |.$locale->text('ELSTER-Steuernummer: ').qq|
177 $form->{elstersteuernummer}
184 if ($form->{FA_steuerberater_name} ne ''){
188 <input checked="checked" title="|.$locale->text('Beraterdaten in UStVA übernehmen?').qq|" name="FA_steuerberater" id=steuerberater class=checkbox type=checkbox value="1">
189 <b>|.$locale->text('Steuerberater/-in').qq|</b>
192 $form->{FA_steuerberater_name}<br>
193 $form->{FA_steuerberater_street}<br>
194 $form->{FA_steuerberater_city}<br>
195 Tel: $form->{FA_steuerberater_tel}<br>
203 <b>|.$locale->text('Voranmeldezeitraum').qq|</b>
209 if ( not defined $form->{all_years} ) {
210 # accounting years if SQL-Ledger Version < 2.4.1
211 # $year = $form->{year} * 1;
212 @years = sort {$b <=> $a} (2000..($year));
213 $form->{all_years} = \@years;
215 map { $form->{selectaccountingyear} .= qq|<option>$_\n| } @{ $form->{all_years} };
217 <select name=year title="|.$locale->text('Year').qq|">
220 foreach $key ( @years ){
222 print qq|selected| if ($key eq $form->{year});
223 print qq| >$key</option>
228 my $voranmeld = $form->{FA_voranmeld};
229 print qq| </select>|;
231 $checked = "checked" if ( $form->{kz10} eq '1' );
233 <input name="FA_10" id=FA_10 class=checkbox type=checkbox value="1" $checked title = "|.$locale->text('Ist dies eine berichtigte Anmeldung? (Nr. 10/Zeile 15 Steuererklärung)').qq|">
234 |.$locale->text('Berichtigte Anmeldung').qq|
237 if ($voranmeld ne ''){
240 |.$locale->text($voranmeld).qq|
242 print qq| mit Dauerfristverlängerung| if ( $form->{FA_dauerfrist} eq '1');
248 if ($form->{method} ne '' ){
249 print qq||.$locale->text('Method').qq|: |;
250 print qq||.$locale->text('accrual').qq|| if ($form->{method} eq 'accrual');
251 print qq||.$locale->text('cash').qq|| if ($form->{method} eq 'cash');
258 if ($form->{FA_Name} ne ''){
260 <td width="50%" valign="top">
263 <b>|.$locale->text('Finanzamt').qq|</b>
265 <h3>$form->{FA_Name}</h2>
268 #if ($form->{FA_Ergaenzung_Name ne ''}){
270 # $form->{FA_Ergaenzung_Name} 
277 $form->{FA_PLZ} $form->{FA_Ort}
280 |.$locale->text('Tel. : ').qq|
283 |.$locale->text('Fax. : ').qq|
287 <a href="mailto:$form->{FA_Email}?subject=|.CGI::escape("Steuer Nr: $form->{steuernummer}:").qq|&body=|.CGI::escape("Sehr geehrte Damen und Herren,\n\n\nMit freundlichen Grüßen\n\n").CGI::escape($form->{signature}).qq|">
291 <a href="$form->{FA_Internet}">
296 |.$locale->text('Öffnungszeiten').qq|
302 my $FA_1= ($form->{FA_BLZ_1} ne '' &&
303 $form->{FA_Kontonummer_1} ne '' &&
304 $form->{FA_Bankbezeichnung_1} ne '');
305 my $FA_2= ($form->{FA_BLZ_2} ne '' &&
306 $form->{FA_Kontonummer_2} ne '' &&
307 $form->{FA_Bankbezeichnung_oertlich} ne '');
309 if ( $FA_1 && $FA_2){
312 |.$locale->text('Bankverbindungen').qq|
316 $form->{FA_Bankbezeichnung_1}
318 |.$locale->text('Konto: ').qq|
319 $form->{FA_Kontonummer_1}
321 |.$locale->text('BLZ: ').qq|
325 $form->{FA_Bankbezeichnung_oertlich}
327 |.$locale->text('Konto: ').qq|
328 $form->{FA_Kontonummer_2}
330 |.$locale->text('BLZ: ').qq|
339 |.$locale->text('Bankverbindung').qq|
342 $form->{FA_Bankbezeichnung_1}
344 |.$locale->text('Konto: ').qq|
345 $form->{FA_Kontonummer_1}
347 |.$locale->text('BLZ: ').qq|
348 $form->{FA_BLZ_1} <br>
353 |.$locale->text('Bankverbindung').qq|
356 $form->{FA_Bankbezeichnung_oertlich}
358 |.$locale->text('Konto: ').qq|
359 $form->{FA_Kontonummer_2}
361 |.$locale->text('BLZ: ').qq|
371 <b>|.$locale->text('Ausgabeformat').qq|</b>
383 # Stichtag der nächsten USTVA berechnen
385 # ($stichtag, $tage_bis, $ical) = FA->stichtag($today[dd.mm.yyyy],
386 # $FA_dauerfrist[1,0],
387 # $FA_voranmeld[month, quarter])
388 #$tmpdateform= $myconfig{dateformat};
389 # $myconfig{dateformat}= "dd.mm.yyyy";
390 # $form->{today} = $form->datetonum($form->current_date(\%myconfig), \%myconfig);
391 # ($stichtag, $description, $tage_bis, $ical) = FA::stichtag($form->{today}, $form->{FA_dauerfrist},$form->{FA_voranmeld});
392 # $form->{today} = $form->date($stichtag, \%myconfig );
393 #$myconfig{dateformat}= $tmpdateform;
401 # |.$locale->text('Anstehende Voranmeldungen').qq|
403 # <h2 class="confirm">$stichtag<h2>
404 # <h3>$description</h3>
405 # <h4>$form->{today}</h4>
411 <td width="50%" valign="bottom">
414 <b>|.$locale->text('Hinweise').qq|</b>
416 <h2 class="confirm">Die Ausgabefunktionen sind wegen fehlender Daten deaktiviert.</h2>
419 <li><a href="ustva.pl?path=$form->{path}&action=edit&level=Programm--Finanzamteinstellungen&login=$form->{login}&password=$form->{password}">
420 Bitte 'Einstellungen' wählen um die Erweiterten UStVa Funktionen nutzen zu können.</a></li>
422 <li><a href="am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}">
423 Firmendaten können bei den Benutzereinstellungen verändert werden.</a></li>
428 $hide = q|disabled="disabled"|;
437 #}# end if report = ustva
446 <td><hr size="3" noshade></td>
451 <input type="hidden" name="address" value="$form->{address}">
452 <input type="hidden" name="reporttype" value="custom">
453 <input type="hidden" name="company_street" value="$form->{company_street}">
454 <input type="hidden" name="company_city" value="$form->{company_city}">
455 <input type="hidden" name="path" value="$form->{path}">
456 <input type="hidden" name="login" value="$form->{login}">
457 <input type="hidden" name="password" value="$form->{password}">
461 <input type=hidden name=nextsub value=generate_ustva>
462 <input $hide type=submit class=submit name=action value="|.$locale->text('Show').qq|">
463 <input type=submit class=submit name=action value="|.$locale->text('Config').qq|">
468 <form action="doc/ustva.html" method="get">
470 <input type=submit class=submit name=action value="|.$locale->text('Help').qq|">
483 $lxdebug->leave_sub();
486 #############################
489 $lxdebug->enter_sub();
490 # parse help documents under doc
491 my $tmp = $form->{templates};
492 $form->{templates} = 'doc';
493 $form->{help} = 'ustva';
494 $form->{type} = 'help';
495 $form->{format} = 'html';
497 #$form->{templates} = $tmp;
498 $lxdebug->leave_sub();
503 $lxdebug->enter_sub();
506 &{$form->{nextsub}} ;
508 $lxdebug->leave_sub();
511 sub ustva_vorauswahl {
512 $lxdebug->enter_sub();
513 #Aktuelles Datum zerlegen:
514 $locale->date(\%myconfig, $form->current_date(\%myconfig,'0','0'), 0)=~ /(\d\d).(\d\d).(\d\d\d\d)/;
515 #$locale->date($myconfig, $form->current_date($myconfig), 0)=~ /(\d\d).(\d\d).(\d\d\d\d)/;
521 # Testdaten erzeugen:
523 #$form->{month}= '01';
524 #$form->{year}= 2004;
526 <input type=hidden name=day value=$form->{day}>
527 <input type=hidden name=month value=$form->{month}>
528 <input type=hidden name=yymmdd value=$yymmdd>
529 <input type=hidden name=sel value=$sel>
532 if ($form->{FA_voranmeld} eq 'month'){
533 # Vorauswahl bei monatlichem Voranmeldungszeitraum
535 <select name="duetyp" id=zeitraum title="|.$locale->text('Hier den Berechnungszeitraum auswählen...').qq|">
538 my %liste = ('01' => 'January',
551 my $yy = $form->{year}* 10000;
552 $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1;
554 my $dfv = '0'; # Offset für Dauerfristverlängerung
555 #$dfv = '100' if ($form->{FA_dauerfrist} eq '1');
558 $yymmdd <= ($yy + 110 + $dfv) && do {
559 $form->{year} = $form->{year} - 1;
563 $yymmdd <= ($yy + 210 + $dfv) && do {
567 $yymmdd <= ($yy + 310 + $dfv) && do {
571 $yymmdd <= ($yy + 410 + $dfv) && do {
575 $yymmdd <= ($yy + 510 + $dfv) && do {
579 $yymmdd <= ($yy + 610 + $dfv) && do {
583 $yymmdd <= ($yy + 710 + $dfv) && do {
587 $yymmdd <= ($yy + 810 + $dfv) && do {
591 $yymmdd <= ($yy + 910 + $dfv) && do {
595 $yymmdd <= ($yy + 1010 + $dfv) && do {
599 $yymmdd <= ($yy + 1110 + $dfv) && do {
603 $yymmdd <= ($yy + 1210) && do {
607 $yymmdd <= ($yy + 1231) && do {
614 foreach $key ( sort keys %liste ){
616 $selected = 'selected' if ( $sel eq $key );
618 <option value="$key" $selected>|.$locale->text("$liste{$key}").qq|</option>
624 } elsif ($form->{FA_voranmeld} eq 'quarter'){
625 # Vorauswahl bei quartalsweisem Voranmeldungszeitraum
626 my %liste = ( 'A' => '1.',
632 my $yy = $form->{year}* 10000;
633 $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1;
635 my $dfv = ''; # Offset für Dauerfristverlängerung
636 $dfv = '100' if ($form->{FA_dauerfrist} eq '1');
639 $yymmdd <= ($yy + 110 + $dfv) && do {
640 $form->{year} = $form->{year} - 1;
644 $yymmdd <= ($yy + 410 + $dfv) && do {
648 $yymmdd <= ($yy + 710 + $dfv) && do {
652 $yymmdd <= ($yy + 1010 + $dfv) && do {
656 $yymmdd <= ($yy + 1231) && do {
661 print qq|<select id="zeitraum" name="duetyp" title="|.$locale->text('Select a period').qq|" >|;
663 foreach $key ( sort keys %liste ){
665 $selected = 'selected' if ( $sel eq $key );
667 <option value="$key" $selected>$liste{$key} |.$locale->text('Quarter').qq|</option>
675 # keine Vorauswahl bei Voranmeldungszeitraum
676 print qq|<select id="zeitraum" name="duetyp" title="|.$locale->text('Select a period').qq|" >|;
678 my %listea = ( 'A' => '1.',
684 my %listeb = ( '01' => 'January',
698 foreach $key ( sort keys %listea ){
700 <option value="$key">$listea{$key} |.$locale->text('Quarter').qq|</option>
705 foreach $key ( sort keys %listeb ){
707 <option value="$key">|.$locale->text("$listeb{$key}").qq|</option>
713 $lxdebug->leave_sub();
718 $lxdebug->enter_sub();
720 $lxdebug->leave_sub();
730 $lxdebug->enter_sub();
731 # $form->{PD}{$form->{type}} = "selected";
732 # $form->{DF}{$form->{format}} = "selected";
733 # $form->{OP}{$form->{media}} = "selected";
734 # $form->{SM}{$form->{sendmode}} = "selected";
735 my $type = qq| <input type=hidden name="type" value="ustva">|;
736 my $media = qq| <input type=hidden name="media" value="screen">|;
737 my $format = qq| <option value=html selected>|.$locale->text('Vorschau').qq|</option>|;
739 $format .= qq| <option value=pdf>|.$locale->text('UStVA als PDF-Dokument').qq|</option>|;
742 #my $disabled= qq|disabled="disabled"|;
743 #$disabled='' if ($form->{elster} eq '1' );
744 if ($form->{elster} eq '1'){
745 $format .= qq|<option value=elster>|.$locale->text('ELSTER Export nach Winston').qq|</option>|;
747 #$format .= qq|<option value=elster>|.$locale->text('ELSTER Export nach Winston').qq|</option>|;
751 <select name=format title = "|.$locale->text('Ausgabeformat auswählen...').qq|">$format</select>
753 $lxdebug->leave_sub();
757 $lxdebug->enter_sub();
758 # Aufruf von get_config aus bin/mozilla/ustva.pl zum
759 # Einlesen der Finanzamtdaten aus finanzamt.ini
761 get_config($userspath, 'finanzamt.ini');
763 # form vars initialisieren
764 my @anmeldungszeitraum = qw('0401' '0402' '0403' '0404' '0405' '0405' '0406' '0407' '0408' '0409' '0410' '0411' '0412' '0441' '0442' '0443' '0444');
766 foreach $item (@anmeldungszeitraum) {
769 if ($form->{reporttype} eq "custom"){
770 #forgotten the year --> thisyear
771 if ($form->{year} !~ m/^\d\d\d\d$/ ) {
772 $locale->date(\$myconfig, $form->current_date(\$myconfig), 0)=~ /(\d\d\d\d)/;
776 if ($form->{duetyp} eq "13" ){
777 $form->{fromdate}="1.1.$form->{year}";
778 $form->{todate}="31.12.$form->{year}";
781 if ($form->{duetyp} eq "A" ){
782 $form->{fromdate}="1.1.$form->{year}";
783 $form->{todate}="31.3.$form->{year}";
784 $form->{'0441'} = "X";
786 if ($form->{duetyp} eq "B" ){
787 $form->{fromdate}="1.4.$form->{year}";
788 $form->{todate}="30.6.$form->{year}";
789 $form->{'0442'} = "X";
791 if ($form->{duetyp} eq "C" ){
792 $form->{fromdate}="1.7.$form->{year}";
793 $form->{todate}="30.9.$form->{year}";
794 $form->{'0443'} = "X";
796 if ($form->{duetyp} eq "D" ){
797 $form->{fromdate}="1.10.$form->{year}";
798 $form->{todate}="31.12.$form->{year}";
799 $form->{'0444'} = "X";
804 $form->{duetyp} eq "01" && do {
805 $form->{fromdate}="1.1.$form->{year}";
806 $form->{todate}="31.1.$form->{year}";
807 $form->{'0401'} = "X";
810 $form->{duetyp} eq "02" && do {
811 $form->{fromdate}="1.2.$form->{year}";
812 #this works from 1901 to 2099, 1900 and 2100 fail.
813 my $leap=($form->{year} % 4 == 0) ? "29" : "28";
814 $form->{todate}="$leap.2.$form->{year}";
815 $form->{"0402"} = "X";
818 $form->{duetyp} eq "03" && do {
819 $form->{fromdate}="1.3.$form->{year}";
820 $form->{todate}="31.3.$form->{year}";
821 $form->{"0403"} = "X";
824 $form->{duetyp} eq "04" && do {
825 $form->{fromdate}="1.4.$form->{year}";
826 $form->{todate}="30.4.$form->{year}";
827 $form->{"0404"} = "X";
830 $form->{duetyp} eq "05" && do {
831 $form->{fromdate}="1.5.$form->{year}";
832 $form->{todate}="31.5.$form->{year}";
833 $form->{"0405"} = "X";
836 $form->{duetyp} eq "06" && do {
837 $form->{fromdate}="1.6.$form->{year}";
838 $form->{todate}="30.6.$form->{year}";
839 $form->{"0406"} = "X";
842 $form->{duetyp} eq "07" && do {
843 $form->{fromdate}="1.7.$form->{year}";
844 $form->{todate}="31.7.$form->{year}";
845 $form->{"0407"} = "X";
848 $form->{duetyp} eq "08" && do {
849 $form->{fromdate}="1.8.$form->{year}";
850 $form->{todate}="31.8.$form->{year}";
851 $form->{"0408"} = "X";
854 $form->{duetyp} eq "09" && do {
855 $form->{fromdate}="1.9.$form->{year}";
856 $form->{todate}="30.9.$form->{year}";
857 $form->{"0409"} = "X";
860 $form->{duetyp} eq "10" && do {
861 $form->{fromdate}="1.10.$form->{year}";
862 $form->{todate}="31.10.$form->{year}";
863 $form->{"0410"} = "X";
866 $form->{duetyp} eq "11" && do {
867 $form->{fromdate}="1.11.$form->{year}";
868 $form->{todate}="30.11.$form->{year}";
869 $form->{"0411"} = "X";
872 $form->{duetyp} eq "12" && do {
873 $form->{fromdate}="1.12.$form->{year}";
874 $form->{todate}="31.12.$form->{year}";
875 $form->{"0412"} = "X";
880 #$myconfig = \%myconfig;
881 RP->ustva(\%myconfig, \%$form);
883 #??($form->{department}) = split /--/, $form->{department};
885 $form->{period} = $locale->date(\%myconfig, $form->current_date(\%myconfig), 1, 0, 0);
886 $form->{todate} = $form->current_date($myconfig) unless $form->{todate};
888 # if there are any dates construct a where
889 if ($form->{fromdate} || $form->{todate}) {
891 unless ($form->{todate}) {
892 $form->{todate} = $form->current_date($myconfig);
895 my $longtodate = $locale->date($myconfig, $form->{todate}, 1, 0, 0);
896 my $shorttodate = $locale->date($myconfig, $form->{todate}, 0, 0, 0);
898 my $longfromdate = $locale->date($myconfig, $form->{fromdate}, 1, 0, 0);
899 my $shortfromdate = $locale->date($myconfig, $form->{fromdate}, 0, 0, 0);
901 $form->{this_period} = "$shortfromdate<br>\n$shorttodate";
902 $form->{period} = $locale->text('for Period').qq|<br>\n$longfromdate |.$locale->text('bis').qq| $longtodate|;
905 if ($form->{comparefromdate} || $form->{comparetodate}) {
906 my $longcomparefromdate = $locale->date(\%myconfig, $form->{comparefromdate}, 1, 0, 0);
907 my $shortcomparefromdate = $locale->date(\%myconfig, $form->{comparefromdate}, 0, 0, 0);
909 my $longcomparetodate = $locale->date(\%myconfig, $form->{comparetodate}, 1, 0, 0);
910 my $shortcomparetodate = $locale->date(\%myconfig, $form->{comparetodate}, 0, 0, 0);
912 $form->{last_period} = "$shortcomparefromdate<br>\n$shortcomparetodate";
913 $form->{period} .= "<br>\n$longcomparefromdate ".$locale->text('bis').qq| $longcomparetodate|;
916 $form->{Datum_heute} = $locale->date(\%myconfig, $form->current_date(\%myconfig), 0, 0, 0);
918 # setup variables for the form
920 @a = qw(company businessnumber tel fax email company_email);
921 map { $form->{$_} = $myconfig{$_} } @a;
923 if ( $form->{address} ne '' ) {
924 my $temp = $form->{address};
925 $temp =~ s/\\n/<br \/>/;
926 ($form->{company_street}, $form->{company_city}) = split("<br \/>", $temp);
929 if ($form->{format} eq 'pdf'
930 or $form->{format} eq 'postscript') {
931 $form->{padding} = "~~";
932 $form->{bold} = "\textbf{";
933 $form->{endbold} = "}";
934 $form->{br} = '\\\\';
936 my @numbers = qw(51r 86r 97r 93r 96 43 45
939 foreach $number ( @numbers){
940 $form->{$number} =~ s/,/~~/g;
943 elsif ($form->{format} eq 'html') {
944 $form->{padding} = " ";
945 $form->{bold} = "<b>";
946 $form->{endbold} = "</b>";
947 $form->{br} = "<br>";
948 $form->{address} =~ s/\\n/<br \/>/;
953 if ($form->{format} eq 'elster'){
956 $form->{templates} = $myconfig{templates};
957 $form->{templates} = "doc" if ($form->{type} eq 'help');
959 $form->{IN} = "$form->{type}";
960 $form->{IN} = "$form->{help}" if ($form->{type} eq 'help');
961 $form->{IN} .= "-$form->{year}" if ($form->{format} eq 'pdf'
962 or $form->{format} eq 'postscript');
964 $form->{IN} .= '.tex' if ($form->{format} eq 'pdf'
965 or $form->{format} eq 'postscript');
967 $form->{IN} .= '.html' if ($form->{format} eq 'html');
969 #print qq|$myconfig<br>$path|;
970 $form->parse_template($myconfig, $userspath);
972 $lxdebug->leave_sub();
977 $lxdebug->enter_sub();
978 # edit all taxauthority prefs
981 &get_config($userspath, 'finanzamt.ini');
983 #&create_steuernummer;
985 my $land=$form->{elsterland};
986 my $amt=$form->{elsterFFFF};
988 $form->{title} = $locale->text('Finanzamt - Einstellungen');
991 <form name="verzeichnis" method=post action="$form->{script}">
994 <th class="listtop">|.$locale->text('Finanzamt - Einstellungen').qq|</th>
1000 <legend><b>|.$locale->text('Angaben zum Finanzamt').qq|</b></legend>
1002 #print qq|$form->{terminal}|;
1004 USTVA::fa_auswahl($land, $amt, &elster_hash());
1010 $checked ="checked" if ( $form->{method} eq 'accrual' );
1013 <legend><b>|.$locale->text('Verfahren').qq|</b>
1015 <input name=method id=accrual class=radio type=radio value="accrual" $checked>
1016 <label for="accrual">|.$locale->text('accrual').qq|</label>
1020 $checked ="checked" if ( $form->{method} eq 'cash' );
1022 <input name=method id=cash class=radio type=radio value="cash" $checked>
1023 <label for="cash">|.$locale->text('cash').qq|</label>
1027 <legend><b>|.$locale->text('Voranmeldungszeitraum').qq|</b>
1031 $checked ="checked" if ( $form->{FA_voranmeld} eq 'month' );
1033 <input name=FA_voranmeld id=month class=radio type=radio value="month" $checked>
1034 <label for="month">|.$locale->text('month').qq|</label>
1038 $checked ="checked" if ( $form->{FA_voranmeld} eq 'quarter' );
1040 <input name="FA_voranmeld" id=quarter class=radio type=radio value="quarter" $checked>
1041 <label for="quarter">|.$locale->text('quarter').qq|</label>
1045 $checked ="checked" if ( $form->{FA_dauerfrist} eq '1' );
1047 <input name="FA_dauerfrist" id=FA_dauerfrist class=checkbox type=checkbox value="1" $checked>
1048 <label for="">|.$locale->text('Dauerfristverlängerung').qq|</label>
1053 <legend><b>|.$locale->text('Steuerberater/-in').qq|</b>
1057 $checked ="checked" if ( $form->{FA_71} eq 'X' );
1059 <!-- <input name="FA_71" id=FA_71 class=checkbox type=checkbox value="X" $checked>
1060 <label for="FA_71">|.$locale->text('Verrechnung des Erstattungsbetrages erwünscht (Zeile 71)').qq|</label>
1066 |.$locale->text('Name').qq|
1069 |.$locale->text('Straße').qq|
1072 |.$locale->text('PLZ, Ort').qq|
1075 |.$locale->text('Telefon').qq|
1080 <input name="FA_steuerberater_name" id=steuerberater size=25 value="$form->{FA_steuerberater_name}">
1083 <input name="FA_steuerberater_street" id=steuerberater size=25 value="$form->{FA_steuerberater_street}">
1086 <input name="FA_steuerberater_city" id=steuerberater size=25 value="$form->{FA_steuerberater_city}">
1089 <input name="FA_steuerberater_tel" id=steuerberater size=25 value="$form->{FA_steuerberater_tel}">
1098 <!--<input type=submit class=submit name=action value="|.$locale->text('debug').qq|">-->
1099 <input type=submit class=submit name=action value="|.$locale->text('continue').qq|">
1105 my @variables = qw( steuernummer elsterland elstersteuernummer elsterFFFF);
1107 foreach $variable (@variables) {
1109 <input name=$variable type=hidden value="$form->{$variable}">|;
1111 my $steuernummer_new = '';
1112 #<input type=hidden name="steuernummer_new" value="$form->{$steuernummer_new}">
1115 <input type=hidden name="nextsub" value="edit_form">
1116 <input type=hidden name="warnung" value="1">
1117 <input type=hidden name="saved" value="|.$locale->text('Bitte Angaben überprüfen').qq|">
1118 <input type=hidden name="path" value=$form->{path}>
1119 <input type=hidden name="login" value=$form->{login}>
1120 <input type=hidden name="password" value=$form->{password}>
1121 <input type=hidden name="warnung" value="0">
1124 @variables = qw(FA_Name FA_Strasse FA_PLZ
1125 FA_Ort FA_Telefon FA_Fax FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach
1126 FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1 FA_BLZ_2
1127 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten
1128 FA_Email FA_Internet);
1130 foreach $variable (@variables) {
1132 <input name=$variable type=hidden value="$form->{$variable}">|;
1139 $lxdebug->leave_sub();
1144 $lxdebug->enter_sub();
1149 my $elsterland = '';
1150 my $elster_amt = '';
1151 my $elsterFFFF = '';
1152 my $elstersteuernummer = '';
1153 &get_config($userspath, 'finanzamt.ini') if ($form->{saved} eq $locale->text('saved'));
1155 # Auf Übergabefehler checken
1156 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');
1157 USTVA::info($locale->text('Es fehlen Angaben zur Versteuerung.
1158 Wenn Sie Ist Versteuert sind, wählen Sie die Einnahmen/Überschuß-Rechnung aus.
1159 Sind Sie Soll-Versteuert und Bilanzverpflichtet, dann wählen Sie Bilanz aus.')) if ( $form->{method} eq '' );
1160 # Klären, ob Variablen bereits befüllt sind UND ob veräderungen auf
1161 # der vorherigen Maske stattfanden: $change = 1(in der edit sub,
1162 # mittels get_config)
1164 my $change = $form->{elsterland} eq $form->{elsterland_new} && $form->{elsterFFFF} eq $form->{elsterFFFF_new} ? '0':'1';
1165 $change = '0' if ($form->{saved} eq $locale->text('saved'));
1166 my $elster_init = &elster_hash();
1167 #my %elster_init = ();
1168 my %elster_init = %$elster_init;
1170 if ( $change eq '1' ){
1172 $elsterland = $form->{elsterland_new};
1173 $elsterFFFF = $form->{elsterFFFF_new};
1174 $form->{elsterland} = $elsterland;
1175 $form->{elsterFFFF} = $elsterFFFF;
1176 $form->{steuernummer} = '';
1177 &create_steuernummer;
1178 # rebuild elster_amt
1180 foreach $amt ( keys %{ $elster_init{$form->{elsterland}} } ) {
1181 $elster_amt = $amt if ($elster_init{$form->{elsterland}{$amt} eq $form->{elsterFFFF}} );
1184 # load the predefined hash data into the FA_* Vars
1185 my @variables = qw(FA_Name FA_Strasse FA_PLZ FA_Ort
1186 FA_Telefon FA_Fax FA_PLZ_Grosskunden FA_PLZ_Postfach
1188 FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1
1189 FA_BLZ_2 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich
1190 FA_Oeffnungszeiten FA_Email FA_Internet);
1192 for (my $i = 0; $i <= 20; $i++) {
1193 $form->{$variables[$i]} = $elster_init->{$elsterland}->{$elsterFFFF}->[$i];
1198 $elsterland = $form->{elsterland};
1199 $elsterFFFF = $form->{elsterFFFF};
1202 my $stnr = $form->{steuernummer};
1204 my $patterncount = $form->{patterncount};
1205 my $elster_pattern = $form->{elster_pattern};
1206 my $delimiter = $form->{delimiter};
1207 my $steuernummer = '';
1208 $steuernummer = $form->{steuernummer} if ($steuernummer eq '');
1211 my $warnung = $form->{warnung};
1214 <form name="elsterform" method=post action="$form->{script}">
1215 <table width="100%">
1217 <th colspan="2" class="listtop">|.$locale->text('Finanzamt - Einstellungen').qq|</th>
1232 <font size="+1">|.$locale->text('Steuernummer').qq|</font>
1236 $steuernummer = USTVA::steuernummer_input($form->{elsterland},
1237 $form->{elsterFFFF}, $form->{steuernummer} );
1250 <!--<input type=hidden name=nextsub value="debug">
1251 <input type=submit class=submit name=action value="|.$locale->text('debug').qq|">
1252 <input type=hidden name=nextsub value="test">
1253 <input type=submit class=submit name=action value="|.$locale->text('test').qq|">-->
1254 <input type=hidden name=lastsub value="edit">
1255 <input type=submit class=submit name=action value="|.$locale->text('back').qq|">
1257 if ( $form->{warnung} eq "1" ){
1259 <input type=hidden name=nextsub value="edit_form">
1260 <input type=submit class=submit name=action value="|.$locale->text('continue').qq|">
1261 <input type=hidden name="saved" value="|.$locale->text('Bitte alle Angaben überprüfen').qq|">
1265 <input type=hidden name="nextsub" value="save">
1266 <input type=hidden name="filename" value="finanzamt.ini">
1267 <input type=submit class=submit name=action value="|.$locale->text('save').qq|">
1274 <H2 class=confirm>$form->{saved}</H2>
1280 my @variables = qw(FA_steuerberater_name FA_steuerberater_street
1281 FA_steuerberater_city FA_steuerberater_tel
1283 FA_dauerfrist FA_71 FA_Name elster
1284 path login password type elster_init saved
1287 foreach $variable (@variables) {
1289 <input name="$variable" type="hidden" value="$form->{$variable}">|;
1292 <input type=hidden name="elsterland" value="$elsterland">
1293 <input type=hidden name="elsterFFFF" value="$elsterFFFF">
1294 <input type=hidden name="warnung" value="$warnung">
1295 <input type=hidden name="elstersteuernummer" value="$elstersteuernummer">
1296 <input type=hidden name="steuernummer" value="$stnr">
1299 $lxdebug->leave_sub();
1303 sub create_steuernummer {
1304 $lxdebug->enter_sub();
1305 my $part=$form->{part};
1306 my $patterncount = $form->{patterncount};
1307 my $delimiter = $form->{delimiter};
1308 my $elster_pattern = $form->{elster_pattern};
1309 # rebuild steuernummer and elstersteuernummer
1310 # es gibt eine gespeicherte steuernummer $form->{steuernummer}
1311 # und die parts und delimiter
1316 my $steuernummer_new = $part;
1317 my $elstersteuernummer_new = $form->{elster_FFFF};
1318 $elstersteuernummer_new .= '0';
1320 for ( $h = 1; $h < $patterncount; $h++) {
1321 $steuernummer_new .= qq|$delimiter|;
1322 for (my $i = 1; $i <= length($elster_pattern); $i++ ) {
1323 $steuernummer_new .= $form->{"part_$h\_$i"};
1324 $elstersteuernummer_new .= $form->{"part_$h\_$i"};
1327 if ($form->{steuernummer} ne $steuernummer_new){
1328 $form->{steuernummer} = $steuernummer_new;
1329 $form->{elstersteuernummer} = $elstersteuernummer_new;
1330 $form->{steuernummer_new} = $steuernummer_new;
1332 $form->{steuernummer_new} = '';
1333 $form->{elstersteuernummer_new} = '';
1335 $lxdebug->leave_sub();
1340 $lxdebug->enter_sub();
1342 my ($userpath, $filename) = @_;
1343 my ($key, $value) = '';
1344 open(FACONF, "$userpath/$filename") or $form->error("$userpath/$filename : $!");
1350 # remove any trailing whitespace
1351 s/^\s*(.*?)\s*$/$1/;
1352 ($key, $value) = split /=/, $_, 2;
1353 #if ($value eq ' '){
1354 # $form->{$key} = " " ;
1355 #} elsif ($value ne ' '){
1356 $form->{$key} = "$value";
1360 # Textboxen formatieren: Linebreaks entfernen
1362 #$form->{FA_Oeffnungszeiten} =~ s/\\\\n/<br>/g;
1363 $lxdebug->leave_sub();
1369 $lxdebug->enter_sub();
1370 my $filename = $form->{filename};
1371 #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen
1372 create_steuernummer;
1373 # Textboxen formatieren: Linebreaks entfernen
1375 $form->{FA_Oeffnungszeiten} =~ s/\r\n/\\n/g;
1376 #URL mit http:// davor?
1377 $form->{FA_Internet} =~ s/^http:\/\///;
1378 $form->{FA_Internet} = 'http://'. $form->{FA_Internet};
1380 my @config = qw(elster elsterland elstersteuernummer steuernummer
1381 elsteramt elsterFFFF FA_Name FA_Strasse
1382 FA_PLZ FA_Ort FA_Telefon FA_Fax FA_PLZ_Grosskunden
1383 FA_PLZ_Postfach FA_Postfach FA_BLZ_1 FA_Kontonummer_1
1384 FA_Bankbezeichnung_1 FA_BLZ_2 FA_Kontonummer_2
1385 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten
1386 FA_Email FA_Internet FA_voranmeld method FA_steuerberater_name
1387 FA_steuerberater_street FA_steuerberater_city FA_steuerberater_tel
1388 FA_71 FA_dauerfrist);
1389 # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer
1390 if ( $form->{elstersteuernummer} ne '000000000' ) {
1391 $form->{elster}='1';
1392 open(CONF, ">$userspath/$filename") or $form->error("$filename : $!");
1393 # create the config file
1394 print CONF qq|# Configuration file for USTVA\n\n|;
1396 foreach $key (sort @config) {
1397 $form->{$key} =~ s/\\/\\\\/g;
1398 $form->{$key} =~ s/"/\\"/g;
1400 $form->{$key} =~ s/\r\n/\n/g;
1401 print CONF qq|$key=|;
1402 if ($form->{$key} ne 'Y') {
1403 print CONF qq|$form->{$key}\n|;
1405 if ($form->{$key} eq 'Y') {
1406 print CONF qq|checked \n|;
1409 print CONF qq|\n\n|;
1411 $form->{saved} = $locale->text('saved');
1415 $form->{saved} = $locale->text('Bitte eine Steuernummer angeben');
1419 $lxdebug->leave_sub();
1423 $lxdebug->enter_sub();
1425 my $oeffnungszeiten = $form->{FA_Oeffnungszeiten} ;
1426 $oeffnungszeiten =~ s/\\\\n/\n/g;
1430 <font size="+1">|. $locale->text('Finanzamt').qq| $form->{FA_Name}</font>
1433 #print qq|\n<h4>$form->{FA_Ergaenzung_Name} </h4>
1434 # | if ( $form->{FA_Ergaenzung_Name} );
1436 <table width="100%" valign="top">
1442 <b>|.$locale->text('Address').qq|</b>
1445 <table width="100%">
1448 <input name="FA_Strasse" size="40" title="FA_Strasse" value="$form->{FA_Strasse}" $readonly>
1453 <input name="FA_PLZ" size="10" title="FA_PLZ" value="$form->{FA_PLZ}" $readonly>
1456 <input name="FA_Ort" size="20" title="FA_Ort" value="$form->{FA_Ort}" $readonly>
1464 <b>|.$locale->text('Kontakt').qq|</b>
1466 |.$locale->text('Telefon').qq|<br>
1467 <input name="FA_Telefon" size="40" title="FA_Telefon" value="$form->{FA_Telefon}" $readonly>
1470 |.$locale->text('Fax').qq|<br>
1471 <input name="FA_Fax" size="40" title="FA_Fax" value="$form->{FA_Fax}" $readonly>
1474 |.$locale->text('Internet').qq|<br>
1475 <input name="FA_Email" size="40" title="FA_Email" value="$form->{FA_Email}" $readonly>
1478 <input name="FA_Internet" size="40" title="" title="FA_Internet" value="$form->{FA_Internet}" $readonly>
1486 <b>|.$locale->text('Öffnungszeiten').qq|</b>
1488 <textarea name="FA_Oeffnungszeiten" rows="4" cols="40" $readonly>$oeffnungszeiten</textarea>
1492 my $FA_1= ($form->{FA_BLZ_1} ne '' &&
1493 $form->{FA_Kontonummer_1} ne '' &&
1494 $form->{FA_Bankbezeichnung_1} ne '');
1495 my $FA_2= ($form->{FA_BLZ_2} ne '' &&
1496 $form->{FA_Kontonummer_2} ne '' &&
1497 $form->{FA_Bankbezeichnung_oertlich} ne '');
1498 if ( $FA_1 && $FA_2){
1502 <b>|.$locale->text('Bankverbindungen des Finanzamts').qq|</b>
1507 |.$locale->text('Kreditinstitut').qq|
1509 <input name="FA_Bankbezeichnung_1" size="30" value="$form->{FA_Bankbezeichnung_1}" $readonly>
1512 |.$locale->text('Kontonummer').qq|
1514 <input name="FA_Kontonummer_1" size="15" value="$form->{FA_Kontonummer_1}" $readonly>
1517 |.$locale->text('Bankleitzahl').qq|
1519 <input name="FA_BLZ_1" size="15" value="$form->{FA_BLZ_1}" $readonly>
1522 |.$locale->text('Kreditinstitut').qq|
1524 <input name="FA_Bankbezeichnung_oertlich" size="30" value="$form->{FA_Bankbezeichnung_oertlich}" $readonly>
1527 |.$locale->text('Kontonummer').qq|
1529 <input name="FA_Kontonummer_2" size="15" value="$form->{FA_Kontonummer_2}" $readonly>
1532 |.$locale->text('Bankleitzahl').qq|
1534 <input name="FA_BLZ_2" size="15" value="$form->{FA_BLZ_2}" $readonly>
1544 <b>|.$locale->text('Bankverbindung des Finanzamts').qq|</b>
1546 |.$locale->text('Kontonummer').qq|
1548 <input name="FA_Kontonummer_1" size="30" value="$form->{FA_Kontonummer_1}" $readonly>
1551 |.$locale->text('Bankleitzahl (BLZ)').qq|
1553 <input name="FA_BLZ_1" size="15" value="$form->{FA_BLZ_1}" $readonly>
1556 |.$locale->text('Kreditinstitut').qq|
1558 <input name="FA_Bankbezeichnung_1" size="15" value="$form->{FA_Bankbezeichnung_1}" $readonly>
1566 <b>|.$locale->text('Bankverbindung des Finanzamts').qq|</b>
1568 |.$locale->text('Kontonummer').qq|
1570 <input name="FA_Kontonummer_2" size="30" value="$form->{FA_Kontonummer_2}" $readonly>
1573 |.$locale->text('Bankleitzahl (BLZ)').qq|
1575 <input name="FA_BLZ_2" size="15" value="$form->{FA_BLZ_2}" $readonly>
1578 |.$locale->text('Kreditinstitut').qq|
1580 <input name="FA_Bankbezeichnung_oertlich" size="15" value="$form->{FA_Bankbezeichnung_oertlich}" $readonly>
1590 $lxdebug->leave_sub();
1595 sub create_winston {
1596 $lxdebug->enter_sub();
1597 &get_config($userspath, 'finanzamt.ini');
1599 # There is no generic Linux GNU/GPL solution out for using ELSTER.
1600 # In lack of availability linux users may use windows pendants. I choose
1601 # WINSTON, because it's free of coast, it has an API and its tested under
1603 # The author of WINSTON developed some c-code to realize ELSTER under
1604 # WINDOWS and Linux (http://www.felfri.de/fa_xml/). Next year (2005) I start to
1605 # develop a server side solution for LX-Office ELSTER under Linux and
1606 # WINDOWS based on this c-code.
1608 # You need to download WINSTON from http://www.felfri.de/winston/
1609 # There (http://www.felfri.de/winston/download.htm) you'll find instructions
1610 # about WINSTON under Linux WINE
1611 # More infos about Winstons API: http://www.felfri.de/winston/schnittstellen.htm
1613 my $file = ''; # Filename for Winstonfile
1614 $file .= 'U'; # 1. char 'U' = USTVA
1616 SWITCH: { # 2. and 3. char 01-12= Month 41-44= Quarter (azr:Abrechnungszeitraum)
1617 $form->{duetyp} eq "01" && do {
1621 $form->{duetyp} eq "02" && do {
1625 $form->{duetyp} eq "03" && do {
1629 $form->{duetyp} eq "04" && do {
1633 $form->{duetyp} eq "05" && do {
1637 $form->{duetyp} eq "06" && do {
1641 $form->{duetyp} eq "07" && do {
1645 $form->{duetyp} eq "08" && do {
1649 $form->{duetyp} eq "09" && do {
1653 $form->{duetyp} eq "10" && do {
1657 $form->{duetyp} eq "11" && do {
1661 $form->{duetyp} eq "12" && do {
1665 $form->{duetyp} eq "A" && do {
1669 $form->{duetyp} eq "B" && do {
1673 $form->{duetyp} eq "C" && do {
1677 $form->{duetyp} eq "D" && do {
1682 $form->error("Ungültiger Anmeldezeitraum.\n
1683 Sie können für ELSTER nur einen monatlichen oder
1684 quartalsweisen Anmeldezeitraum auswählen.");
1689 #4. and 5. char = year modulo 100
1690 $file .= sprintf("%02d", $form->{year}%100);
1692 #6. to 18. char = Elstersteuernummer
1693 #Beispiel: Steuernummer in Bayern
1694 #111/222/33334 ergibt für UStVA Jan 2004: U01049111022233334
1696 $file .= $form->{elsterFFFF};
1697 $file .= $form->{elstersteuernummer};
1702 $form->{elsterfile} = $file;
1706 my $k51 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"})); # Umsätze zu 16% USt
1707 my $k86 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"})); # Umsätze zu 7% USt
1708 my $k97 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1709 my $k93 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1710 my $k94 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"})); # neuer Fahrzeuge von Lieferern
1711 my $k66 = $form->parse_amount(\%myconfig, $form->{"66"}) * 100;# Vorsteuer 7% plus 16%
1712 my $k83 = $form->parse_amount(\%myconfig, $form->{"67"}) * 100;# Umsätze zu 7% USt
1713 my $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100;#
1715 # Now build the xml content
1718 $form->{elster}= qq|<?xml version="1.0" encoding="ISO-8859-1" ?>
1719 <!-- Diese Datei ist mit Lx-Office $form->{version} generiert -->
1721 <Formular Typ="UST"></Formular>
1722 <Ordnungsnummer>$form->{elstersteuernummer}</Ordnungsnummer>
1723 <AnmeldeJahr>$form->{year}</AnmeldeJahr>
1724 <AnmeldeZeitraum>$azr</AnmeldeZeitraum>
1727 $form->{elster} .= qq|<Kennzahl Nr="51">$k51</Kennzahl>\n| if ($k51 ne '0');
1728 $form->{elster} .= qq|<Kennzahl Nr="86">$k86</Kennzahl>\n| if ($k86 ne '0');
1729 $form->{elster} .= qq|<Kennzahl Nr="97">$k97</Kennzahl>\n| if ($k97 ne '0');
1730 $form->{elster} .= qq|<Kennzahl Nr="93">$k93</Kennzahl>\n| if ($k93 ne '0');
1731 $form->{elster} .= qq|<Kennzahl Nr="94">$k94</Kennzahl>\n| if ($k94 ne '0');
1732 $form->{elster} .= qq|<Kennzahl Nr="96">$k96</Kennzahl>\n| if ($k96 ne '0');
1733 $form->{elster} .= qq|<Kennzahl Nr="66">$k66</Kennzahl>\n| if ($k66 ne '0');
1734 $form->{elster} .= qq|<Kennzahl Nr="83">$k83</Kennzahl>\n| if ($k83 ne '0');
1735 $form->{elster} .= qq|\n</WinstonAusgang>\n\n|;
1738 #print qq|$form->{elsterfile}|;
1739 #print qq|$form->{elster}|;
1740 $SIG{INT} = 'IGNORE';
1743 $lxdebug->leave_sub();
1748 $lxdebug->enter_sub();
1749 my $elster = $form->{elster};
1750 my $elsterfile = $form->{elsterfile};
1751 open(OUT, ">-") or $form->error("STDOUT : $!");
1752 print OUT qq|Content-Type: application/file;
1753 Content-Disposition: attachment; filename="$elsterfile"\n\n|;
1756 $lxdebug->leave_sub();
1760 $lxdebug->enter_sub();
1761 # allow Symbolic references just here:
1763 &{$form->{nextsub}};
1765 $lxdebug->leave_sub();
1768 sub back { &{$form->{lastsub}} };
1771 $lxdebug->enter_sub();
1772 my $finanzamt = USTVA::query_finanzamt(\%myconfig, \%$form);
1773 $lxdebug->leave_sub();
1778 $lxdebug->enter_sub();
1779 # biegt nur den Testeintrag in Programm->Test auf eine Routine um
1783 $lxdebug->leave_sub();
1788 $lxdebug->enter_sub();
1790 my $elster_conf = &elster_conf();
1793 $form->{cwd} = cwd();
1794 $form->{tmpdir} = $form->{cwd} . '/' . $elster_conf->{'path'};
1795 $form->{tmpfile} = $elster_conf->{'err'};
1796 my $caller = $elster_conf->{'call'}[0];
1798 chdir("$form->{tmpdir}") or $form->error($form->cleanup."chdir : $!");
1799 my $send= "faxmlsend $caller -config etc/faxmlsend.cnf -xml faxmlsend.xml -tt faxmlsend.tt -debug";
1801 system("$send > $form->{tmpfile}");
1802 $form->{tmpdir} .= "$elster_conf->{'path'}/";
1803 $form->{tmpfile} = "faxmlsend.err";
1804 $form->error($form->cleanup."faxmlsend : OFD meldet: Error 404 \n Internetseite nicht vorhanden") if ($? eq '1024');
1805 $form->error($form->cleanup."faxmlsend : No such File: faxmlsend.xml \n Fehlernummer: $? \n Problem beim öffnen der faxmlsend.xml") if ($?);
1806 # foreach my $line (&elster_feedback("$elster_conf->{'path'}")){
1807 # print qq|$line\n|;
1810 #for (my $i=0; $i<= )
1812 print qq|\n ende\n|;
1813 $lxdebug->leave_sub();
1817 sub elster_readlog {
1818 $lxdebug->enter_sub();
1819 my $elster_conf = &elster_conf();
1820 open(LOG, "$elster_conf->{'logfile'}") or $form->error("$elster_conf->{'logfile'}: $!");
1821 print qq|<listing>|;
1830 #$_ =~ s/\015\012//mg;
1833 if ($_ =~ /^\d\d\d\d\d\d/g){
1835 #} elsif ($_ =~ /(<([^\/]*?)>)/ ) {
1836 } elsif ($_ =~ /(<([^\/].*?)>(.*))/g ) {
1837 #$xml .= qq|$2 = $3\n\n|;
1838 #$_ =~ s/\015\012//mg;
1850 # $var .= qq|$2 = $3\n\n|;
1854 print qq|</listing>|;
1856 # s{<(\w+)\b([^<>]*)>
1857 # ((?:.(?!</?\1\b))*.)
1859 # { print "markup=",$1," args=",$2," enclosed=",$3," final=",$4 ; "" }gsex;
1861 $lxdebug->leave_sub();
1865 sub elster_feedback {
1866 $lxdebug->enter_sub();
1869 print qq|feedback:<br>|;
1875 $lxdebug->leave_sub();
1881 $lxdebug->enter_sub();
1884 'prg' => 'faxmlsend',
1885 'err' => 'faxmlsend.err',
1886 'ttfile' => 'faxmlsend.tt',
1887 'xmlfile' => 'faxmlsend.xml',
1888 'cline' => '-tt $ttfile -xml $xmlfile',
1889 'call' => ['send', 'protokoll', 'anmeldesteuern'],
1890 'logfile' => 'log/faxmlsend.log',
1891 'conffile' => 'faxmlsend.cnf',
1895 $lxdebug->leave_sub();
1897 return $elster_conf;
1901 $lxdebug->enter_sub();
1903 my $elster_conf = &elster_conf();
1904 # $k51 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"})); # Umsätze zu 16% USt
1905 # $k86 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"})); # Umsätze zu 7% USt
1906 # $k97 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1907 # $k93 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1908 # $k94 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"})); # neuer Fahrzeuge von Lieferern
1909 # $k66 = $form->parse_amount(\%myconfig, $form->{"66"}) * 100;# Vorsteuer 7% plus 16%
1910 # $k83 = $form->parse_amount(\%myconfig, $form->{"67"}) * 100;# Umsätze zu 7% USt
1911 # $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100;#
1913 my $TransferHeader = qq|<?xml version="1.0" encoding="ISO-8859-1"?>
1914 <?xml-stylesheet type="text/xsl" href="..\\Stylesheet\\ustva.xsl"?>
1915 <Elster xmlns="http://www.elster.de/2002/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.elster.de/2002/XMLSchema
1916 ..\\Schemata\\elster_UStA_200501_extern.xsd">
1917 <TransferHeader version="7">
1918 <Verfahren>ElsterAnmeldung</Verfahren>
1919 <DatenArt>UStVA</DatenArt>
1920 <Vorgang>send-NoSig</Vorgang>
1921 <Testmerker>700000004</Testmerker>
1922 <HerstellerID>74931</HerstellerID>
1923 <DatenLieferant>Helmut</DatenLieferant>
1925 <Verschluesselung>PKCS#7v1.5</Verschluesselung>
1926 <Kompression>GZIP</Kompression>
1927 <DatenGroesse>123456789012345678901234567890123456789012</DatenGroesse>
1928 <TransportSchluessel/>
1949 <NutzdatenHeader version="9">
1950 <NutzdatenTicket>234234234</NutzdatenTicket>
1951 <Empfaenger id="F">9198</Empfaenger>
1953 <ProduktName>ElsterAnmeldung</ProduktName>
1954 <ProduktVersion>V 1.4</ProduktVersion>
1956 <DatenLieferant>String, der Lieferanteninfo enthaelt</DatenLieferant>
1962 <!--die Version gibt Auskunft ueber das Jahr und die derzeit gueltige Versionsnummer-->
1963 <Anmeldungssteuern art="UStVA" version="200501">
1965 <Name>OFD Muenchen</Name>
1966 <Strasse>Meiserstr. 6</Strasse>
1970 <Erstellungsdatum>20041127</Erstellungsdatum>
1972 <Umsatzsteuervoranmeldung>
1974 <Zeitraum>01</Zeitraum>
1975 <Steuernummer>9198011310134</Steuernummer>
1976 <Kz09>74931*NameSteuerber.*Berufsbez.*089*59958327*Mandantenname</Kz09>
1977 </Umsatzsteuervoranmeldung>
1979 </Anmeldungssteuern>
1985 #$DatenTeil .= qq| <Kz51>$k51</Kz51>\n| if ($k51 ne '0');
1986 #$DatenTeil .= qq| <Kz86>$k86</Kz86>\n| if ($k86 ne '0');
1987 #$DatenTeil .= qq| <Kz97>$k97</Kz97>\n| if ($k97 ne '0');
1988 #$DatenTeil .= qq| <Kz93>$k93</Kz93>\n| if ($k93 ne '0');
1989 #$DatenTeil .= qq| <Kz94>$k94</Kz94>\n| if ($k94 ne '0');
1990 #$DatenTeil .= qq| <Kz96>$k96</Kz96>\n| if ($k96 ne '0');
1991 #$DatenTeil .= qq| <Kz66>$k66</Kz66>\n| if ($k66 ne '0');
1992 #$DatenTeil .= qq| <Kz83>$k83</Kz83>\n| if ($k83 ne '0');
1994 my $filename = "$elster_conf->{'path'}/$elster_conf->{'xmlfile'}";
1995 open(XML, ">$elster_conf->{'path'}/$elster_conf->{'xmlfile'}") or $form->error("$filename : $!");
1996 print XML qq|$TransferHeader $DatenTeil|;
1998 $lxdebug->leave_sub();