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";
32 #use warnings FATAL=> 'all';
33 #use vars qw($locale $form %myconfig);
35 #use CGI::Carp "fatalsToBrowser";
43 # this is for our long dates
44 # $locale->text('January')
45 # $locale->text('February')
46 # $locale->text('March')
47 # $locale->text('April')
48 # $locale->text('May ')
49 # $locale->text('June')
50 # $locale->text('July')
51 # $locale->text('August')
52 # $locale->text('September')
53 # $locale->text('October')
54 # $locale->text('November')
55 # $locale->text('December')
57 # this is for our short month
58 # $locale->text('Jan')
59 # $locale->text('Feb')
60 # $locale->text('Mar')
61 # $locale->text('Apr')
62 # $locale->text('May')
63 # $locale->text('Jun')
64 # $locale->text('Jul')
65 # $locale->text('Aug')
66 # $locale->text('Sep')
67 # $locale->text('Oct')
68 # $locale->text('Nov')
69 # $locale->text('Dec')
70 #############################
73 $lxdebug->enter_sub();
74 my $myconfig = \%myconfig;
76 $form->{title} = $locale->text('UStVA');
77 $form->{kz10} = ''; #Berichtigte Anmeldung? Ja =1
79 # $accrual = ($eur) ? "" : "checked";
80 # $cash = ($eur) ? "checked" : "";
83 ($null, $null, $null, $null, $null, $year, $null, $null, $null) =
94 <form method=post action=$form->{script}>
96 <input type=hidden name=title value="$form->{title}">
100 <th class=listtop>$form->{title}</th>
109 # Hier Aufruf von get_config aus bin/mozilla/fa.pl zum
110 # Einlesen der Finanzamtdaten
111 &get_config($userspath, 'finanzamt.ini');
113 my @a = qw(signature name company address businessnumber tel fax email
114 company_street company_city company_email);
115 map { $form->{$_} = $myconfig->{$_} } @a;
117 my $oeffnungszeiten = $form->{FA_Oeffnungszeiten};
118 $oeffnungszeiten =~ s/\\\\n/<br>/g;
121 <td width="50%" align="left" valign="top">
124 <b>| . $locale->text('Firma') . qq|</b>
127 if ($form->{company} ne '') {
128 print qq|<h3>$form->{company}</h3>\n|;
131 <a href=am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}>
132 | . $locale->text('Kein Firmenname hinterlegt!') . qq|</a><br>
136 #klären, ob $form->{company_street|_address} gesetzt sind
138 if ($form->{address} ne '') {
139 my $temp = $form->{address};
140 $temp =~ s/\\n/<br \/>/;
142 ($form->{company_street}, $form->{company_city}) = split("<br \/", $temp);
143 } elsif ($form->{address} eq ''
144 and ($form->{company_street} ne '' and $form->{company_city} ne '')) {
145 print qq|$form->{company_street}<br>\n| if ($form->{company_street} ne '');
146 print qq|$form->{company_city}\n| if ($form->{company_city} ne '');
147 } elsif ($form->{company_street} eq '' or $form->{company_city} eq '') {
149 <a href=am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}>
150 | . $locale->text('Keine Firmenadresse hinterlegt!') . qq|</a>\n|;
156 | . $locale->text('Tel.: ') . qq|
159 | . $locale->text('Fax.: ') . qq|
166 | . $locale->text('Steuernummer: ') . qq|
169 if ($form->{steuernummer} ne '') {
170 print qq|$form->{steuernummer}|;
173 <a href="ustva.pl?path=$form->{path}&action=edit&level=Programm--Finanzamteinstellungen&login=$form->{login}&password=$form->{password}">
174 Keine Steuernummer hinterlegt!</a><br>|;
178 | . $locale->text('ELSTER-Steuernummer: ') . qq|
179 $form->{elstersteuernummer}
186 if ($form->{FA_steuerberater_name} ne '') {
190 <input checked="checked" title="|
191 . $locale->text('Beraterdaten in UStVA übernehmen?')
192 . qq|" name="FA_steuerberater" id=steuerberater class=checkbox type=checkbox value="1">
193 <b>| . $locale->text('Steuerberater/-in') . qq|</b>
196 $form->{FA_steuerberater_name}<br>
197 $form->{FA_steuerberater_street}<br>
198 $form->{FA_steuerberater_city}<br>
199 Tel: $form->{FA_steuerberater_tel}<br>
207 <b>| . $locale->text('Voranmeldezeitraum') . qq|</b>
213 if (not defined $form->{all_years}) {
215 # accounting years if SQL-Ledger Version < 2.4.1
216 # $year = $form->{year} * 1;
217 @years = sort { $b <=> $a } (2000 .. ($year));
218 $form->{all_years} = \@years;
220 map { $form->{selectaccountingyear} .= qq|<option>$_\n| }
221 @{ $form->{all_years} };
223 <select name=year title="| . $locale->text('Year') . qq|">
226 foreach $key (@years) {
228 print qq|selected| if ($key eq $form->{year});
229 print qq| >$key</option>
233 my $voranmeld = $form->{FA_voranmeld};
234 print qq| </select>|;
236 $checked = "checked" if ($form->{kz10} eq '1');
238 <input name="FA_10" id=FA_10 class=checkbox type=checkbox value="1" $checked title = "|
239 . $locale->text('Ist dies eine berichtigte Anmeldung? (Nr. 10/Zeile 15 Steuererklärung)')
241 | . $locale->text('Berichtigte Anmeldung') . qq|
245 if ($voranmeld ne '') {
248 | . $locale->text($voranmeld) . qq|
250 print qq| mit Dauerfristverlängerung| if ($form->{FA_dauerfrist} eq '1');
256 if ($form->{method} ne '') {
257 print qq|| . $locale->text('Method') . qq|: |;
258 print qq|| . $locale->text('accrual') . qq||
259 if ($form->{method} eq 'accrual');
260 print qq|| . $locale->text('cash') . qq|| if ($form->{method} eq 'cash');
267 if ($form->{FA_Name} ne '') {
269 <td width="50%" valign="top">
272 <b>| . $locale->text('Finanzamt') . qq|</b>
274 <h3>$form->{FA_Name}</h2>
277 #if ($form->{FA_Ergaenzung_Name ne ''}){
279 # $form->{FA_Ergaenzung_Name} 
286 $form->{FA_PLZ} $form->{FA_Ort}
289 | . $locale->text('Tel. : ') . qq|
292 | . $locale->text('Fax. : ') . qq|
296 <a href="mailto:$form->{FA_Email}?subject=|
297 . CGI::escape("Steuer Nr: $form->{steuernummer}:")
300 "Sehr geehrte Damen und Herren,\n\n\nMit freundlichen Grüßen\n\n")
301 . CGI::escape($form->{signature}) . qq|">
305 <a href="$form->{FA_Internet}">
310 | . $locale->text('Öffnungszeiten') . qq|
317 ( $form->{FA_BLZ_1} ne ''
318 && $form->{FA_Kontonummer_1} ne ''
319 && $form->{FA_Bankbezeichnung_1} ne '');
321 ( $form->{FA_BLZ_2} ne ''
322 && $form->{FA_Kontonummer_2} ne ''
323 && $form->{FA_Bankbezeichnung_oertlich} ne '');
325 if ($FA_1 && $FA_2) {
328 | . $locale->text('Bankverbindungen') . qq|
332 $form->{FA_Bankbezeichnung_1}
334 | . $locale->text('Konto: ') . qq|
335 $form->{FA_Kontonummer_1}
337 | . $locale->text('BLZ: ') . qq|
341 $form->{FA_Bankbezeichnung_oertlich}
343 | . $locale->text('Konto: ') . qq|
344 $form->{FA_Kontonummer_2}
346 | . $locale->text('BLZ: ') . qq|
355 | . $locale->text('Bankverbindung') . qq|
358 $form->{FA_Bankbezeichnung_1}
360 | . $locale->text('Konto: ') . qq|
361 $form->{FA_Kontonummer_1}
363 | . $locale->text('BLZ: ') . qq|
364 $form->{FA_BLZ_1} <br>
369 | . $locale->text('Bankverbindung') . qq|
372 $form->{FA_Bankbezeichnung_oertlich}
374 | . $locale->text('Konto: ') . qq|
375 $form->{FA_Kontonummer_2}
377 | . $locale->text('BLZ: ') . qq|
387 <b>| . $locale->text('Ausgabeformat') . qq|</b>
397 # Stichtag der nächsten USTVA berechnen
399 # ($stichtag, $tage_bis, $ical) = FA->stichtag($today[dd.mm.yyyy],
400 # $FA_dauerfrist[1,0],
401 # $FA_voranmeld[month, quarter])
402 #$tmpdateform= $myconfig{dateformat};
403 # $myconfig{dateformat}= "dd.mm.yyyy";
404 # $form->{today} = $form->datetonum($form->current_date(\%myconfig), \%myconfig);
405 # ($stichtag, $description, $tage_bis, $ical) = FA::stichtag($form->{today}, $form->{FA_dauerfrist},$form->{FA_voranmeld});
406 # $form->{today} = $form->date($stichtag, \%myconfig );
407 #$myconfig{dateformat}= $tmpdateform;
414 # |.$locale->text('Anstehende Voranmeldungen').qq|
416 # <h2 class="confirm">$stichtag<h2>
417 # <h3>$description</h3>
418 # <h4>$form->{today}</h4>
424 <td width="50%" valign="bottom">
427 <b>| . $locale->text('Hinweise') . qq|</b>
429 <h2 class="confirm">Die Ausgabefunktionen sind wegen fehlender Daten deaktiviert.</h2>
432 <li><a href="ustva.pl?path=$form->{path}&action=edit&level=Programm--Finanzamteinstellungen&login=$form->{login}&password=$form->{password}">
433 Bitte 'Einstellungen' wählen um die Erweiterten UStVa Funktionen nutzen zu können.</a></li>
435 <li><a href="am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}">
436 Firmendaten können bei den Benutzereinstellungen verändert werden.</a></li>
441 $hide = q|disabled="disabled"|;
449 #}# end if report = ustva
456 <td><hr size="3" noshade></td>
461 <input type="hidden" name="address" value="$form->{address}">
462 <input type="hidden" name="reporttype" value="custom">
463 <input type="hidden" name="company_street" value="$form->{company_street}">
464 <input type="hidden" name="company_city" value="$form->{company_city}">
465 <input type="hidden" name="path" value="$form->{path}">
466 <input type="hidden" name="login" value="$form->{login}">
467 <input type="hidden" name="password" value="$form->{password}">
471 <input type=hidden name=nextsub value=generate_ustva>
472 <input $hide type=submit class=submit name=action value="|
473 . $locale->text('Show') . qq|">
474 <input type=submit class=submit name=action value="|
475 . $locale->text('Config') . qq|">
480 <form action="doc/ustva.html" method="get">
482 <input type=submit class=submit name=action value="|
483 . $locale->text('Help') . qq|">
496 $lxdebug->leave_sub();
499 #############################
502 $lxdebug->enter_sub();
504 # parse help documents under doc
505 my $tmp = $form->{templates};
506 $form->{templates} = 'doc';
507 $form->{help} = 'ustva';
508 $form->{type} = 'help';
509 $form->{format} = 'html';
512 #$form->{templates} = $tmp;
513 $lxdebug->leave_sub();
517 $lxdebug->enter_sub();
521 &{ $form->{nextsub} };
523 $lxdebug->leave_sub();
526 sub ustva_vorauswahl {
527 $lxdebug->enter_sub();
529 #Aktuelles Datum zerlegen:
530 $locale->date(\%myconfig, $form->current_date(\%myconfig, '0', '0'), 0) =~
531 /(\d\d).(\d\d).(\d\d\d\d)/;
533 #$locale->date($myconfig, $form->current_date($myconfig), 0)=~ /(\d\d).(\d\d).(\d\d\d\d)/;
540 # Testdaten erzeugen:
542 #$form->{month}= '01';
543 #$form->{year}= 2004;
545 <input type=hidden name=day value=$form->{day}>
546 <input type=hidden name=month value=$form->{month}>
547 <input type=hidden name=yymmdd value=$yymmdd>
548 <input type=hidden name=sel value=$sel>
551 if ($form->{FA_voranmeld} eq 'month') {
553 # Vorauswahl bei monatlichem Voranmeldungszeitraum
555 <select name="duetyp" id=zeitraum title="|
556 . $locale->text('Hier den Berechnungszeitraum auswählen...') . qq|">
559 my %liste = ('01' => 'January',
572 my $yy = $form->{year} * 10000;
573 $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1;
575 my $dfv = '0'; # Offset für Dauerfristverlängerung
576 #$dfv = '100' if ($form->{FA_dauerfrist} eq '1');
579 $yymmdd <= ($yy + 110 + $dfv) && do {
580 $form->{year} = $form->{year} - 1;
584 $yymmdd <= ($yy + 210 + $dfv) && do {
588 $yymmdd <= ($yy + 310 + $dfv) && do {
592 $yymmdd <= ($yy + 410 + $dfv) && do {
596 $yymmdd <= ($yy + 510 + $dfv) && do {
600 $yymmdd <= ($yy + 610 + $dfv) && do {
604 $yymmdd <= ($yy + 710 + $dfv) && do {
608 $yymmdd <= ($yy + 810 + $dfv) && do {
612 $yymmdd <= ($yy + 910 + $dfv) && do {
616 $yymmdd <= ($yy + 1010 + $dfv) && do {
620 $yymmdd <= ($yy + 1110 + $dfv) && do {
624 $yymmdd <= ($yy + 1210) && do {
628 $yymmdd <= ($yy + 1231) && do {
635 foreach $key (sort keys %liste) {
637 $selected = 'selected' if ($sel eq $key);
639 <option value="$key" $selected>|
640 . $locale->text("$liste{$key}")
647 } elsif ($form->{FA_voranmeld} eq 'quarter') {
649 # Vorauswahl bei quartalsweisem Voranmeldungszeitraum
650 my %liste = ('A' => '1.',
655 my $yy = $form->{year} * 10000;
656 $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1;
658 my $dfv = ''; # Offset für Dauerfristverlängerung
659 $dfv = '100' if ($form->{FA_dauerfrist} eq '1');
662 $yymmdd <= ($yy + 110 + $dfv) && do {
663 $form->{year} = $form->{year} - 1;
667 $yymmdd <= ($yy + 410 + $dfv) && do {
671 $yymmdd <= ($yy + 710 + $dfv) && do {
675 $yymmdd <= ($yy + 1010 + $dfv) && do {
679 $yymmdd <= ($yy + 1231) && do {
684 print qq|<select id="zeitraum" name="duetyp" title="|
685 . $locale->text('Select a period') . qq|" >|;
687 foreach $key (sort keys %liste) {
689 $selected = 'selected' if ($sel eq $key);
691 <option value="$key" $selected>$liste{$key} |
692 . $locale->text('Quarter')
701 # keine Vorauswahl bei Voranmeldungszeitraum
702 print qq|<select id="zeitraum" name="duetyp" title="|
703 . $locale->text('Select a period') . qq|" >|;
705 my %listea = ('A' => '1.',
710 my %listeb = ('01' => 'January',
721 '12' => 'December',);
723 foreach $key (sort keys %listea) {
725 <option value="$key">$listea{$key} |
726 . $locale->text('Quarter')
732 foreach $key (sort keys %listeb) {
734 <option value="$key">| . $locale->text("$listeb{$key}") . qq|</option>
740 $lxdebug->leave_sub();
744 $lxdebug->enter_sub();
746 $lxdebug->leave_sub();
754 $lxdebug->enter_sub();
756 # $form->{PD}{$form->{type}} = "selected";
757 # $form->{DF}{$form->{format}} = "selected";
758 # $form->{OP}{$form->{media}} = "selected";
759 # $form->{SM}{$form->{sendmode}} = "selected";
760 my $type = qq| <input type=hidden name="type" value="ustva">|;
761 my $media = qq| <input type=hidden name="media" value="screen">|;
763 qq| <option value=html selected>|
764 . $locale->text('Vorschau')
768 qq| <option value=pdf>|
769 . $locale->text('UStVA als PDF-Dokument')
773 #my $disabled= qq|disabled="disabled"|;
774 #$disabled='' if ($form->{elster} eq '1' );
775 if ($form->{elster} eq '1') {
777 qq|<option value=elster>|
778 . $locale->text('ELSTER Export nach Winston')
782 #$format .= qq|<option value=elster>|.$locale->text('ELSTER Export nach Winston').qq|</option>|;
786 <select name=format title = "|
787 . $locale->text('Ausgabeformat auswählen...')
788 . qq|">$format</select>
790 $lxdebug->leave_sub();
794 $lxdebug->enter_sub();
796 # Aufruf von get_config aus bin/mozilla/ustva.pl zum
797 # Einlesen der Finanzamtdaten aus finanzamt.ini
799 get_config($userspath, 'finanzamt.ini');
801 # form vars initialisieren
802 my @anmeldungszeitraum =
803 qw('0401' '0402' '0403' '0404' '0405' '0405' '0406' '0407' '0408' '0409' '0410' '0411' '0412' '0441' '0442' '0443' '0444');
805 foreach $item (@anmeldungszeitraum) {
808 if ($form->{reporttype} eq "custom") {
810 #forgotten the year --> thisyear
811 if ($form->{year} !~ m/^\d\d\d\d$/) {
812 $locale->date(\$myconfig, $form->current_date(\$myconfig), 0) =~
818 if ($form->{duetyp} eq "13") {
819 $form->{fromdate} = "1.1.$form->{year}";
820 $form->{todate} = "31.12.$form->{year}";
824 if ($form->{duetyp} eq "A") {
825 $form->{fromdate} = "1.1.$form->{year}";
826 $form->{todate} = "31.3.$form->{year}";
827 $form->{'0441'} = "X";
829 if ($form->{duetyp} eq "B") {
830 $form->{fromdate} = "1.4.$form->{year}";
831 $form->{todate} = "30.6.$form->{year}";
832 $form->{'0442'} = "X";
834 if ($form->{duetyp} eq "C") {
835 $form->{fromdate} = "1.7.$form->{year}";
836 $form->{todate} = "30.9.$form->{year}";
837 $form->{'0443'} = "X";
839 if ($form->{duetyp} eq "D") {
840 $form->{fromdate} = "1.10.$form->{year}";
841 $form->{todate} = "31.12.$form->{year}";
842 $form->{'0444'} = "X";
847 $form->{duetyp} eq "01" && do {
848 $form->{fromdate} = "1.1.$form->{year}";
849 $form->{todate} = "31.1.$form->{year}";
850 $form->{'0401'} = "X";
853 $form->{duetyp} eq "02" && do {
854 $form->{fromdate} = "1.2.$form->{year}";
856 #this works from 1901 to 2099, 1900 and 2100 fail.
857 my $leap = ($form->{year} % 4 == 0) ? "29" : "28";
858 $form->{todate} = "$leap.2.$form->{year}";
859 $form->{"0402"} = "X";
862 $form->{duetyp} eq "03" && do {
863 $form->{fromdate} = "1.3.$form->{year}";
864 $form->{todate} = "31.3.$form->{year}";
865 $form->{"0403"} = "X";
868 $form->{duetyp} eq "04" && do {
869 $form->{fromdate} = "1.4.$form->{year}";
870 $form->{todate} = "30.4.$form->{year}";
871 $form->{"0404"} = "X";
874 $form->{duetyp} eq "05" && do {
875 $form->{fromdate} = "1.5.$form->{year}";
876 $form->{todate} = "31.5.$form->{year}";
877 $form->{"0405"} = "X";
880 $form->{duetyp} eq "06" && do {
881 $form->{fromdate} = "1.6.$form->{year}";
882 $form->{todate} = "30.6.$form->{year}";
883 $form->{"0406"} = "X";
886 $form->{duetyp} eq "07" && do {
887 $form->{fromdate} = "1.7.$form->{year}";
888 $form->{todate} = "31.7.$form->{year}";
889 $form->{"0407"} = "X";
892 $form->{duetyp} eq "08" && do {
893 $form->{fromdate} = "1.8.$form->{year}";
894 $form->{todate} = "31.8.$form->{year}";
895 $form->{"0408"} = "X";
898 $form->{duetyp} eq "09" && do {
899 $form->{fromdate} = "1.9.$form->{year}";
900 $form->{todate} = "30.9.$form->{year}";
901 $form->{"0409"} = "X";
904 $form->{duetyp} eq "10" && do {
905 $form->{fromdate} = "1.10.$form->{year}";
906 $form->{todate} = "31.10.$form->{year}";
907 $form->{"0410"} = "X";
910 $form->{duetyp} eq "11" && do {
911 $form->{fromdate} = "1.11.$form->{year}";
912 $form->{todate} = "30.11.$form->{year}";
913 $form->{"0411"} = "X";
916 $form->{duetyp} eq "12" && do {
917 $form->{fromdate} = "1.12.$form->{year}";
918 $form->{todate} = "31.12.$form->{year}";
919 $form->{"0412"} = "X";
925 #$myconfig = \%myconfig;
926 RP->ustva(\%myconfig, \%$form);
928 #??($form->{department}) = split /--/, $form->{department};
931 $locale->date(\%myconfig, $form->current_date(\%myconfig), 1, 0, 0);
932 $form->{todate} = $form->current_date($myconfig) unless $form->{todate};
934 # if there are any dates construct a where
935 if ($form->{fromdate} || $form->{todate}) {
937 unless ($form->{todate}) {
938 $form->{todate} = $form->current_date($myconfig);
941 my $longtodate = $locale->date($myconfig, $form->{todate}, 1, 0, 0);
942 my $shorttodate = $locale->date($myconfig, $form->{todate}, 0, 0, 0);
944 my $longfromdate = $locale->date($myconfig, $form->{fromdate}, 1, 0, 0);
945 my $shortfromdate = $locale->date($myconfig, $form->{fromdate}, 0, 0, 0);
947 $form->{this_period} = "$shortfromdate<br>\n$shorttodate";
949 $locale->text('for Period')
950 . qq|<br>\n$longfromdate |
951 . $locale->text('bis')
955 if ($form->{comparefromdate} || $form->{comparetodate}) {
956 my $longcomparefromdate =
957 $locale->date(\%myconfig, $form->{comparefromdate}, 1, 0, 0);
958 my $shortcomparefromdate =
959 $locale->date(\%myconfig, $form->{comparefromdate}, 0, 0, 0);
961 my $longcomparetodate =
962 $locale->date(\%myconfig, $form->{comparetodate}, 1, 0, 0);
963 my $shortcomparetodate =
964 $locale->date(\%myconfig, $form->{comparetodate}, 0, 0, 0);
966 $form->{last_period} = "$shortcomparefromdate<br>\n$shortcomparetodate";
968 "<br>\n$longcomparefromdate "
969 . $locale->text('bis')
970 . qq| $longcomparetodate|;
973 $form->{Datum_heute} =
974 $locale->date(\%myconfig, $form->current_date(\%myconfig), 0, 0, 0);
976 # setup variables for the form
978 @a = qw(company businessnumber tel fax email company_email);
979 map { $form->{$_} = $myconfig{$_} } @a;
981 if ($form->{address} ne '') {
982 my $temp = $form->{address};
983 $temp =~ s/\\n/<br \/>/;
984 ($form->{company_street}, $form->{company_city}) = split("<br \/>", $temp);
987 if ( $form->{format} eq 'pdf'
988 or $form->{format} eq 'postscript') {
989 $form->{padding} = "~~";
990 $form->{bold} = "\textbf{";
991 $form->{endbold} = "}";
992 $form->{br} = '\\\\';
994 my @numbers = qw(51r 86r 97r 93r 96 43 45
997 foreach $number (@numbers) {
998 $form->{$number} =~ s/,/~~/g;
1000 } elsif ($form->{format} eq 'html') {
1001 $form->{padding} = " ";
1002 $form->{bold} = "<b>";
1003 $form->{endbold} = "</b>";
1004 $form->{br} = "<br>";
1005 $form->{address} =~ s/\\n/<br \/>/;
1009 if ($form->{format} eq 'elster') {
1012 $form->{templates} = $myconfig{templates};
1013 $form->{templates} = "doc" if ($form->{type} eq 'help');
1015 $form->{IN} = "$form->{type}";
1016 $form->{IN} = "$form->{help}" if ($form->{type} eq 'help');
1017 $form->{IN} .= "-$form->{year}"
1018 if ( $form->{format} eq 'pdf'
1019 or $form->{format} eq 'postscript');
1021 $form->{IN} .= '.tex'
1022 if ( $form->{format} eq 'pdf'
1023 or $form->{format} eq 'postscript');
1025 $form->{IN} .= '.html' if ($form->{format} eq 'html');
1028 #print qq|$myconfig<br>$path|;
1029 $form->parse_template($myconfig, $userspath);
1031 $lxdebug->leave_sub();
1035 $lxdebug->enter_sub();
1037 # edit all taxauthority prefs
1040 &get_config($userspath, 'finanzamt.ini');
1042 #&create_steuernummer;
1044 my $land = $form->{elsterland};
1045 my $amt = $form->{elsterFFFF};
1047 $form->{title} = $locale->text('Finanzamt - Einstellungen');
1050 <form name="verzeichnis" method=post action="$form->{script}">
1053 <th class="listtop">|
1054 . $locale->text('Finanzamt - Einstellungen')
1062 . $locale->text('Angaben zum Finanzamt')
1066 #print qq|$form->{terminal}|;
1068 USTVA::fa_auswahl($land, $amt, &elster_hash());
1074 $checked = "checked" if ($form->{method} eq 'accrual');
1077 <legend><b>| . $locale->text('Verfahren') . qq|</b>
1079 <input name=method id=accrual class=radio type=radio value="accrual" $checked>
1080 <label for="accrual">| . $locale->text('accrual') . qq|</label>
1084 $checked = "checked" if ($form->{method} eq 'cash');
1086 <input name=method id=cash class=radio type=radio value="cash" $checked>
1087 <label for="cash">| . $locale->text('cash') . qq|</label>
1091 <legend><b>| . $locale->text('Voranmeldungszeitraum') . qq|</b>
1095 $checked = "checked" if ($form->{FA_voranmeld} eq 'month');
1097 <input name=FA_voranmeld id=month class=radio type=radio value="month" $checked>
1098 <label for="month">| . $locale->text('month') . qq|</label>
1102 $checked = "checked" if ($form->{FA_voranmeld} eq 'quarter');
1104 <input name="FA_voranmeld" id=quarter class=radio type=radio value="quarter" $checked>
1105 <label for="quarter">| . $locale->text('quarter') . qq|</label>
1109 $checked = "checked" if ($form->{FA_dauerfrist} eq '1');
1111 <input name="FA_dauerfrist" id=FA_dauerfrist class=checkbox type=checkbox value="1" $checked>
1113 . $locale->text('Dauerfristverlängerung')
1119 <legend><b>| . $locale->text('Steuerberater/-in') . qq|</b>
1123 $checked = "checked" if ($form->{FA_71} eq 'X');
1125 <!-- <input name="FA_71" id=FA_71 class=checkbox type=checkbox value="X" $checked>
1126 <label for="FA_71">|
1127 . $locale->text('Verrechnung des Erstattungsbetrages erwünscht (Zeile 71)')
1134 | . $locale->text('Name') . qq|
1137 | . $locale->text('Straße') . qq|
1140 | . $locale->text('PLZ, Ort') . qq|
1143 | . $locale->text('Telefon') . qq|
1148 <input name="FA_steuerberater_name" id=steuerberater size=25 value="$form->{FA_steuerberater_name}">
1151 <input name="FA_steuerberater_street" id=steuerberater size=25 value="$form->{FA_steuerberater_street}">
1154 <input name="FA_steuerberater_city" id=steuerberater size=25 value="$form->{FA_steuerberater_city}">
1157 <input name="FA_steuerberater_tel" id=steuerberater size=25 value="$form->{FA_steuerberater_tel}">
1166 <!--<input type=submit class=submit name=action value="|
1167 . $locale->text('debug')
1169 <input type=submit class=submit name=action value="|
1170 . $locale->text('continue') . qq|">
1176 my @variables = qw( steuernummer elsterland elstersteuernummer elsterFFFF);
1178 foreach $variable (@variables) {
1180 <input name=$variable type=hidden value="$form->{$variable}">|;
1182 my $steuernummer_new = '';
1184 #<input type=hidden name="steuernummer_new" value="$form->{$steuernummer_new}">
1187 <input type=hidden name="nextsub" value="edit_form">
1188 <input type=hidden name="warnung" value="1">
1189 <input type=hidden name="saved" value="|
1190 . $locale->text('Bitte Angaben überprüfen') . qq|">
1191 <input type=hidden name="path" value=$form->{path}>
1192 <input type=hidden name="login" value=$form->{login}>
1193 <input type=hidden name="password" value=$form->{password}>
1194 <input type=hidden name="warnung" value="0">
1197 @variables = qw(FA_Name FA_Strasse FA_PLZ
1198 FA_Ort FA_Telefon FA_Fax FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach
1199 FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1 FA_BLZ_2
1200 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten
1201 FA_Email FA_Internet);
1203 foreach $variable (@variables) {
1205 <input name=$variable type=hidden value="$form->{$variable}">|;
1212 $lxdebug->leave_sub();
1216 $lxdebug->enter_sub();
1221 my $elsterland = '';
1222 my $elster_amt = '';
1223 my $elsterFFFF = '';
1224 my $elstersteuernummer = '';
1225 &get_config($userspath, 'finanzamt.ini')
1226 if ($form->{saved} eq $locale->text('saved'));
1228 # Auf Übergabefehler checken
1230 $locale->text('Bitte das Bundesland UND die Stadt bzw. den Einzugsbereich Ihres zuständigen Finanzamts auswählen.'))
1231 if ( $form->{elsterFFFF_new} eq 'Auswahl'
1232 || $form->{elsterland_new} eq 'Auswahl');
1235 'Es fehlen Angaben zur Versteuerung.
1236 Wenn Sie Ist Versteuert sind, wählen Sie die Einnahmen/Überschuß-Rechnung aus.
1237 Sind Sie Soll-Versteuert und Bilanzverpflichtet, dann wählen Sie Bilanz aus.'
1239 if ($form->{method} eq '');
1241 # Klären, ob Variablen bereits befüllt sind UND ob veräderungen auf
1242 # der vorherigen Maske stattfanden: $change = 1(in der edit sub,
1243 # mittels get_config)
1246 $form->{elsterland} eq $form->{elsterland_new}
1247 && $form->{elsterFFFF} eq $form->{elsterFFFF_new} ? '0' : '1';
1248 $change = '0' if ($form->{saved} eq $locale->text('saved'));
1249 my $elster_init = &elster_hash();
1251 #my %elster_init = ();
1252 my %elster_init = %$elster_init;
1254 if ($change eq '1') {
1257 $elsterland = $form->{elsterland_new};
1258 $elsterFFFF = $form->{elsterFFFF_new};
1259 $form->{elsterland} = $elsterland;
1260 $form->{elsterFFFF} = $elsterFFFF;
1261 $form->{steuernummer} = '';
1262 &create_steuernummer;
1264 # rebuild elster_amt
1266 foreach $amt (keys %{ $elster_init{ $form->{elsterland} } }) {
1268 if ($elster_init{ $form->{elsterland}{$amt} eq $form->{elsterFFFF} });
1271 # load the predefined hash data into the FA_* Vars
1272 my @variables = qw(FA_Name FA_Strasse FA_PLZ FA_Ort
1273 FA_Telefon FA_Fax FA_PLZ_Grosskunden FA_PLZ_Postfach
1275 FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1
1276 FA_BLZ_2 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich
1277 FA_Oeffnungszeiten FA_Email FA_Internet);
1279 for (my $i = 0; $i <= 20; $i++) {
1280 $form->{ $variables[$i] } =
1281 $elster_init->{$elsterland}->{$elsterFFFF}->[$i];
1286 $elsterland = $form->{elsterland};
1287 $elsterFFFF = $form->{elsterFFFF};
1290 my $stnr = $form->{steuernummer};
1292 my $patterncount = $form->{patterncount};
1293 my $elster_pattern = $form->{elster_pattern};
1294 my $delimiter = $form->{delimiter};
1295 my $steuernummer = '';
1296 $steuernummer = $form->{steuernummer} if ($steuernummer eq '');
1299 my $warnung = $form->{warnung};
1303 <form name="elsterform" method=post action="$form->{script}">
1304 <table width="100%">
1306 <th colspan="2" class="listtop">|
1307 . $locale->text('Finanzamt - Einstellungen')
1323 <font size="+1">| . $locale->text('Steuernummer') . qq|</font>
1328 USTVA::steuernummer_input($form->{elsterland}, $form->{elsterFFFF},
1329 $form->{steuernummer});
1342 <!--<input type=hidden name=nextsub value="debug">
1343 <input type=submit class=submit name=action value="|
1344 . $locale->text('debug') . qq|">
1345 <input type=hidden name=nextsub value="test">
1346 <input type=submit class=submit name=action value="|
1347 . $locale->text('test')
1349 <input type=hidden name=lastsub value="edit">
1350 <input type=submit class=submit name=action value="|
1351 . $locale->text('back') . qq|">
1354 if ($form->{warnung} eq "1") {
1356 <input type=hidden name=nextsub value="edit_form">
1357 <input type=submit class=submit name=action value="|
1358 . $locale->text('continue') . qq|">
1359 <input type=hidden name="saved" value="|
1360 . $locale->text('Bitte alle Angaben überprüfen') . qq|">
1364 <input type=hidden name="nextsub" value="save">
1365 <input type=hidden name="filename" value="finanzamt.ini">
1366 <input type=submit class=submit name=action value="|
1367 . $locale->text('save') . qq|">
1374 <H2 class=confirm>$form->{saved}</H2>
1380 my @variables = qw(FA_steuerberater_name FA_steuerberater_street
1381 FA_steuerberater_city FA_steuerberater_tel
1383 FA_dauerfrist FA_71 FA_Name elster
1384 path login password type elster_init saved
1387 foreach $variable (@variables) {
1389 <input name="$variable" type="hidden" value="$form->{$variable}">|;
1392 <input type=hidden name="elsterland" value="$elsterland">
1393 <input type=hidden name="elsterFFFF" value="$elsterFFFF">
1394 <input type=hidden name="warnung" value="$warnung">
1395 <input type=hidden name="elstersteuernummer" value="$elstersteuernummer">
1396 <input type=hidden name="steuernummer" value="$stnr">
1399 $lxdebug->leave_sub();
1402 sub create_steuernummer {
1403 $lxdebug->enter_sub();
1404 my $part = $form->{part};
1405 my $patterncount = $form->{patterncount};
1406 my $delimiter = $form->{delimiter};
1407 my $elster_pattern = $form->{elster_pattern};
1409 # rebuild steuernummer and elstersteuernummer
1410 # es gibt eine gespeicherte steuernummer $form->{steuernummer}
1411 # und die parts und delimiter
1416 my $steuernummer_new = $part;
1417 my $elstersteuernummer_new = $form->{elster_FFFF};
1418 $elstersteuernummer_new .= '0';
1420 for ($h = 1; $h < $patterncount; $h++) {
1421 $steuernummer_new .= qq|$delimiter|;
1422 for (my $i = 1; $i <= length($elster_pattern); $i++) {
1423 $steuernummer_new .= $form->{"part_$h\_$i"};
1424 $elstersteuernummer_new .= $form->{"part_$h\_$i"};
1427 if ($form->{steuernummer} ne $steuernummer_new) {
1428 $form->{steuernummer} = $steuernummer_new;
1429 $form->{elstersteuernummer} = $elstersteuernummer_new;
1430 $form->{steuernummer_new} = $steuernummer_new;
1432 $form->{steuernummer_new} = '';
1433 $form->{elstersteuernummer_new} = '';
1435 $lxdebug->leave_sub();
1439 $lxdebug->enter_sub();
1441 my ($userpath, $filename) = @_;
1442 my ($key, $value) = '';
1443 open(FACONF, "$userpath/$filename")
1444 or $form->error("$userpath/$filename : $!");
1452 # remove any trailing whitespace
1453 s/^\s*(.*?)\s*$/$1/;
1454 ($key, $value) = split /=/, $_, 2;
1456 #if ($value eq ' '){
1457 # $form->{$key} = " " ;
1458 #} elsif ($value ne ' '){
1459 $form->{$key} = "$value";
1465 # Textboxen formatieren: Linebreaks entfernen
1467 #$form->{FA_Oeffnungszeiten} =~ s/\\\\n/<br>/g;
1468 $lxdebug->leave_sub();
1472 $lxdebug->enter_sub();
1473 my $filename = $form->{filename};
1475 #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen
1476 create_steuernummer;
1478 # Textboxen formatieren: Linebreaks entfernen
1480 $form->{FA_Oeffnungszeiten} =~ s/\r\n/\\n/g;
1482 #URL mit http:// davor?
1483 $form->{FA_Internet} =~ s/^http:\/\///;
1484 $form->{FA_Internet} = 'http://' . $form->{FA_Internet};
1486 my @config = qw(elster elsterland elstersteuernummer steuernummer
1487 elsteramt elsterFFFF FA_Name FA_Strasse
1488 FA_PLZ FA_Ort FA_Telefon FA_Fax FA_PLZ_Grosskunden
1489 FA_PLZ_Postfach FA_Postfach FA_BLZ_1 FA_Kontonummer_1
1490 FA_Bankbezeichnung_1 FA_BLZ_2 FA_Kontonummer_2
1491 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten
1492 FA_Email FA_Internet FA_voranmeld method FA_steuerberater_name
1493 FA_steuerberater_street FA_steuerberater_city FA_steuerberater_tel
1494 FA_71 FA_dauerfrist);
1496 # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer
1497 if ($form->{elstersteuernummer} ne '000000000') {
1498 $form->{elster} = '1';
1499 open(CONF, ">$userspath/$filename") or $form->error("$filename : $!");
1501 # create the config file
1502 print CONF qq|# Configuration file for USTVA\n\n|;
1504 foreach $key (sort @config) {
1505 $form->{$key} =~ s/\\/\\\\/g;
1506 $form->{$key} =~ s/"/\\"/g;
1509 $form->{$key} =~ s/\r\n/\n/g;
1510 print CONF qq|$key=|;
1511 if ($form->{$key} ne 'Y') {
1512 print CONF qq|$form->{$key}\n|;
1514 if ($form->{$key} eq 'Y') {
1515 print CONF qq|checked \n|;
1518 print CONF qq|\n\n|;
1520 $form->{saved} = $locale->text('saved');
1524 $form->{saved} = $locale->text('Bitte eine Steuernummer angeben');
1528 $lxdebug->leave_sub();
1532 $lxdebug->enter_sub();
1534 my $oeffnungszeiten = $form->{FA_Oeffnungszeiten};
1535 $oeffnungszeiten =~ s/\\\\n/\n/g;
1540 . $locale->text('Finanzamt')
1541 . qq| $form->{FA_Name}</font>
1545 #print qq|\n<h4>$form->{FA_Ergaenzung_Name} </h4>
1546 # | if ( $form->{FA_Ergaenzung_Name} );
1548 <table width="100%" valign="top">
1554 <b>| . $locale->text('Address') . qq|</b>
1557 <table width="100%">
1560 <input name="FA_Strasse" size="40" title="FA_Strasse" value="$form->{FA_Strasse}" $readonly>
1565 <input name="FA_PLZ" size="10" title="FA_PLZ" value="$form->{FA_PLZ}" $readonly>
1568 <input name="FA_Ort" size="20" title="FA_Ort" value="$form->{FA_Ort}" $readonly>
1576 <b>| . $locale->text('Kontakt') . qq|</b>
1578 | . $locale->text('Telefon') . qq|<br>
1579 <input name="FA_Telefon" size="40" title="FA_Telefon" value="$form->{FA_Telefon}" $readonly>
1582 | . $locale->text('Fax') . qq|<br>
1583 <input name="FA_Fax" size="40" title="FA_Fax" value="$form->{FA_Fax}" $readonly>
1586 | . $locale->text('Internet') . qq|<br>
1587 <input name="FA_Email" size="40" title="FA_Email" value="$form->{FA_Email}" $readonly>
1590 <input name="FA_Internet" size="40" title="" title="FA_Internet" value="$form->{FA_Internet}" $readonly>
1598 <b>| . $locale->text('Öffnungszeiten') . qq|</b>
1600 <textarea name="FA_Oeffnungszeiten" rows="4" cols="40" $readonly>$oeffnungszeiten</textarea>
1605 ( $form->{FA_BLZ_1} ne ''
1606 && $form->{FA_Kontonummer_1} ne ''
1607 && $form->{FA_Bankbezeichnung_1} ne '');
1609 ( $form->{FA_BLZ_2} ne ''
1610 && $form->{FA_Kontonummer_2} ne ''
1611 && $form->{FA_Bankbezeichnung_oertlich} ne '');
1613 if ($FA_1 && $FA_2) {
1618 . $locale->text('Bankverbindungen des Finanzamts') . qq|</b>
1623 | . $locale->text('Kreditinstitut') . qq|
1625 <input name="FA_Bankbezeichnung_1" size="30" value="$form->{FA_Bankbezeichnung_1}" $readonly>
1628 | . $locale->text('Kontonummer') . qq|
1630 <input name="FA_Kontonummer_1" size="15" value="$form->{FA_Kontonummer_1}" $readonly>
1633 | . $locale->text('Bankleitzahl') . qq|
1635 <input name="FA_BLZ_1" size="15" value="$form->{FA_BLZ_1}" $readonly>
1638 | . $locale->text('Kreditinstitut') . qq|
1640 <input name="FA_Bankbezeichnung_oertlich" size="30" value="$form->{FA_Bankbezeichnung_oertlich}" $readonly>
1643 | . $locale->text('Kontonummer') . qq|
1645 <input name="FA_Kontonummer_2" size="15" value="$form->{FA_Kontonummer_2}" $readonly>
1648 | . $locale->text('Bankleitzahl') . qq|
1650 <input name="FA_BLZ_2" size="15" value="$form->{FA_BLZ_2}" $readonly>
1661 . $locale->text('Bankverbindung des Finanzamts') . qq|</b>
1663 | . $locale->text('Kontonummer') . qq|
1665 <input name="FA_Kontonummer_1" size="30" value="$form->{FA_Kontonummer_1}" $readonly>
1668 | . $locale->text('Bankleitzahl (BLZ)') . qq|
1670 <input name="FA_BLZ_1" size="15" value="$form->{FA_BLZ_1}" $readonly>
1673 | . $locale->text('Kreditinstitut') . qq|
1675 <input name="FA_Bankbezeichnung_1" size="15" value="$form->{FA_Bankbezeichnung_1}" $readonly>
1684 . $locale->text('Bankverbindung des Finanzamts') . qq|</b>
1686 | . $locale->text('Kontonummer') . qq|
1688 <input name="FA_Kontonummer_2" size="30" value="$form->{FA_Kontonummer_2}" $readonly>
1691 | . $locale->text('Bankleitzahl (BLZ)') . qq|
1693 <input name="FA_BLZ_2" size="15" value="$form->{FA_BLZ_2}" $readonly>
1696 | . $locale->text('Kreditinstitut') . qq|
1698 <input name="FA_Bankbezeichnung_oertlich" size="15" value="$form->{FA_Bankbezeichnung_oertlich}" $readonly>
1708 $lxdebug->leave_sub();
1711 sub create_winston {
1712 $lxdebug->enter_sub();
1713 &get_config($userspath, 'finanzamt.ini');
1715 # There is no generic Linux GNU/GPL solution out for using ELSTER.
1716 # In lack of availability linux users may use windows pendants. I choose
1717 # WINSTON, because it's free of coast, it has an API and its tested under
1719 # The author of WINSTON developed some c-code to realize ELSTER under
1720 # WINDOWS and Linux (http://www.felfri.de/fa_xml/). Next year (2005) I start to
1721 # develop a server side solution for LX-Office ELSTER under Linux and
1722 # WINDOWS based on this c-code.
1724 # You need to download WINSTON from http://www.felfri.de/winston/
1725 # There (http://www.felfri.de/winston/download.htm) you'll find instructions
1726 # about WINSTON under Linux WINE
1727 # More infos about Winstons API: http://www.felfri.de/winston/schnittstellen.htm
1729 my $file = ''; # Filename for Winstonfile
1730 $file .= 'U'; # 1. char 'U' = USTVA
1733 { # 2. and 3. char 01-12= Month 41-44= Quarter (azr:Abrechnungszeitraum)
1734 $form->{duetyp} eq "01" && do {
1738 $form->{duetyp} eq "02" && do {
1742 $form->{duetyp} eq "03" && do {
1746 $form->{duetyp} eq "04" && do {
1750 $form->{duetyp} eq "05" && do {
1754 $form->{duetyp} eq "06" && do {
1758 $form->{duetyp} eq "07" && do {
1762 $form->{duetyp} eq "08" && do {
1766 $form->{duetyp} eq "09" && do {
1770 $form->{duetyp} eq "10" && do {
1774 $form->{duetyp} eq "11" && do {
1778 $form->{duetyp} eq "12" && do {
1782 $form->{duetyp} eq "A" && do {
1786 $form->{duetyp} eq "B" && do {
1790 $form->{duetyp} eq "C" && do {
1794 $form->{duetyp} eq "D" && do {
1800 "Ungültiger Anmeldezeitraum.\n
1801 Sie können für ELSTER nur einen monatlichen oder
1802 quartalsweisen Anmeldezeitraum auswählen."
1809 #4. and 5. char = year modulo 100
1810 $file .= sprintf("%02d", $form->{year} % 100);
1812 #6. to 18. char = Elstersteuernummer
1813 #Beispiel: Steuernummer in Bayern
1814 #111/222/33334 ergibt für UStVA Jan 2004: U01049111022233334
1816 $file .= $form->{elsterFFFF};
1817 $file .= $form->{elstersteuernummer};
1822 $form->{elsterfile} = $file;
1827 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"}))
1828 ; # Umsätze zu 16% USt
1830 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"}))
1831 ; # Umsätze zu 7% USt
1833 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"}))
1834 ; # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1836 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"}))
1837 ; # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1839 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"}))
1840 ; # neuer Fahrzeuge von Lieferern
1842 $form->parse_amount(\%myconfig, $form->{"66"}) *
1843 100; # Vorsteuer 7% plus 16%
1845 $form->parse_amount(\%myconfig, $form->{"67"}) * 100; # Umsätze zu 7% USt
1846 my $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100; #
1848 # Now build the xml content
1851 $form->{elster} = qq|<?xml version="1.0" encoding="ISO-8859-1" ?>
1852 <!-- Diese Datei ist mit Lx-Office $form->{version} generiert -->
1854 <Formular Typ="UST"></Formular>
1855 <Ordnungsnummer>$form->{elstersteuernummer}</Ordnungsnummer>
1856 <AnmeldeJahr>$form->{year}</AnmeldeJahr>
1857 <AnmeldeZeitraum>$azr</AnmeldeZeitraum>
1860 $form->{elster} .= qq|<Kennzahl Nr="51">$k51</Kennzahl>\n| if ($k51 ne '0');
1861 $form->{elster} .= qq|<Kennzahl Nr="86">$k86</Kennzahl>\n| if ($k86 ne '0');
1862 $form->{elster} .= qq|<Kennzahl Nr="97">$k97</Kennzahl>\n| if ($k97 ne '0');
1863 $form->{elster} .= qq|<Kennzahl Nr="93">$k93</Kennzahl>\n| if ($k93 ne '0');
1864 $form->{elster} .= qq|<Kennzahl Nr="94">$k94</Kennzahl>\n| if ($k94 ne '0');
1865 $form->{elster} .= qq|<Kennzahl Nr="96">$k96</Kennzahl>\n| if ($k96 ne '0');
1866 $form->{elster} .= qq|<Kennzahl Nr="66">$k66</Kennzahl>\n| if ($k66 ne '0');
1867 $form->{elster} .= qq|<Kennzahl Nr="83">$k83</Kennzahl>\n| if ($k83 ne '0');
1868 $form->{elster} .= qq|\n</WinstonAusgang>\n\n|;
1871 #print qq|$form->{elsterfile}|;
1872 #print qq|$form->{elster}|;
1873 $SIG{INT} = 'IGNORE';
1876 $lxdebug->leave_sub();
1880 $lxdebug->enter_sub();
1881 my $elster = $form->{elster};
1882 my $elsterfile = $form->{elsterfile};
1883 open(OUT, ">-") or $form->error("STDOUT : $!");
1884 print OUT qq|Content-Type: application/file;
1885 Content-Disposition: attachment; filename="$elsterfile"\n\n|;
1888 $lxdebug->leave_sub();
1892 $lxdebug->enter_sub();
1894 # allow Symbolic references just here:
1896 &{ $form->{nextsub} };
1898 $lxdebug->leave_sub();
1901 sub back { &{ $form->{lastsub} } }
1904 $lxdebug->enter_sub();
1905 my $finanzamt = USTVA::query_finanzamt(\%myconfig, \%$form);
1906 $lxdebug->leave_sub();
1911 $lxdebug->enter_sub();
1913 # biegt nur den Testeintrag in Programm->Test auf eine Routine um
1917 $lxdebug->leave_sub();
1921 $lxdebug->enter_sub();
1924 my $elster_conf = &elster_conf();
1927 $form->{cwd} = cwd();
1928 $form->{tmpdir} = $form->{cwd} . '/' . $elster_conf->{'path'};
1929 $form->{tmpfile} = $elster_conf->{'err'};
1930 my $caller = $elster_conf->{'call'}[0];
1932 chdir("$form->{tmpdir}") or $form->error($form->cleanup . "chdir : $!");
1934 "faxmlsend $caller -config etc/faxmlsend.cnf -xml faxmlsend.xml -tt faxmlsend.tt -debug";
1936 system("$send > $form->{tmpfile}");
1937 $form->{tmpdir} .= "$elster_conf->{'path'}/";
1938 $form->{tmpfile} = "faxmlsend.err";
1939 $form->error($form->cleanup
1940 . "faxmlsend : OFD meldet: Error 404 \n Internetseite nicht vorhanden")
1942 $form->error($form->cleanup
1943 . "faxmlsend : No such File: faxmlsend.xml \n Fehlernummer: $? \n Problem beim öffnen der faxmlsend.xml"
1947 # foreach my $line (&elster_feedback("$elster_conf->{'path'}")){
1948 # print qq|$line\n|;
1952 #for (my $i=0; $i<= )
1954 print qq|\n ende\n|;
1955 $lxdebug->leave_sub();
1958 sub elster_readlog {
1959 $lxdebug->enter_sub();
1960 my $elster_conf = &elster_conf();
1961 open(LOG, "$elster_conf->{'logfile'}")
1962 or $form->error("$elster_conf->{'logfile'}: $!");
1963 print qq|<listing>|;
1974 #$_ =~ s/\015\012//mg;
1978 if ($_ =~ /^\d\d\d\d\d\d/g) {
1981 #} elsif ($_ =~ /(<([^\/]*?)>)/ ) {
1982 } elsif ($_ =~ /(<([^\/].*?)>(.*))/g) {
1984 #$xml .= qq|$2 = $3\n\n|;
1985 #$_ =~ s/\015\012//mg;
1998 # $var .= qq|$2 = $3\n\n|;
2002 print qq|</listing>|;
2005 # s{<(\w+)\b([^<>]*)>
2006 # ((?:.(?!</?\1\b))*.)
2008 # { print "markup=",$1," args=",$2," enclosed=",$3," final=",$4 ; "" }gsex;
2010 $lxdebug->leave_sub();
2013 sub elster_feedback {
2014 $lxdebug->enter_sub();
2017 print qq|feedback:<br>|;
2023 $lxdebug->leave_sub();
2028 $lxdebug->enter_sub();
2029 my $elster_conf = { 'path' => 'elster',
2030 'prg' => 'faxmlsend',
2031 'err' => 'faxmlsend.err',
2032 'ttfile' => 'faxmlsend.tt',
2033 'xmlfile' => 'faxmlsend.xml',
2034 'cline' => '-tt $ttfile -xml $xmlfile',
2035 'call' => ['send', 'protokoll', 'anmeldesteuern'],
2036 'logfile' => 'log/faxmlsend.log',
2037 'conffile' => 'faxmlsend.cnf',
2038 'debug' => '-debug' };
2040 $lxdebug->leave_sub();
2042 return $elster_conf;
2046 $lxdebug->enter_sub();
2048 my $elster_conf = &elster_conf();
2050 # $k51 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"})); # Umsätze zu 16% USt
2051 # $k86 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"})); # Umsätze zu 7% USt
2052 # $k97 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
2053 # $k93 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
2054 # $k94 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"})); # neuer Fahrzeuge von Lieferern
2055 # $k66 = $form->parse_amount(\%myconfig, $form->{"66"}) * 100;# Vorsteuer 7% plus 16%
2056 # $k83 = $form->parse_amount(\%myconfig, $form->{"67"}) * 100;# Umsätze zu 7% USt
2057 # $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100;#
2059 my $TransferHeader = qq|<?xml version="1.0" encoding="ISO-8859-1"?>
2060 <?xml-stylesheet type="text/xsl" href="..\\Stylesheet\\ustva.xsl"?>
2061 <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
2062 ..\\Schemata\\elster_UStA_200501_extern.xsd">
2063 <TransferHeader version="7">
2064 <Verfahren>ElsterAnmeldung</Verfahren>
2065 <DatenArt>UStVA</DatenArt>
2066 <Vorgang>send-NoSig</Vorgang>
2067 <Testmerker>700000004</Testmerker>
2068 <HerstellerID>74931</HerstellerID>
2069 <DatenLieferant>Helmut</DatenLieferant>
2071 <Verschluesselung>PKCS#7v1.5</Verschluesselung>
2072 <Kompression>GZIP</Kompression>
2073 <DatenGroesse>123456789012345678901234567890123456789012</DatenGroesse>
2074 <TransportSchluessel/>
2095 <NutzdatenHeader version="9">
2096 <NutzdatenTicket>234234234</NutzdatenTicket>
2097 <Empfaenger id="F">9198</Empfaenger>
2099 <ProduktName>ElsterAnmeldung</ProduktName>
2100 <ProduktVersion>V 1.4</ProduktVersion>
2102 <DatenLieferant>String, der Lieferanteninfo enthaelt</DatenLieferant>
2108 <!--die Version gibt Auskunft ueber das Jahr und die derzeit gueltige Versionsnummer-->
2109 <Anmeldungssteuern art="UStVA" version="200501">
2111 <Name>OFD Muenchen</Name>
2112 <Strasse>Meiserstr. 6</Strasse>
2116 <Erstellungsdatum>20041127</Erstellungsdatum>
2118 <Umsatzsteuervoranmeldung>
2120 <Zeitraum>01</Zeitraum>
2121 <Steuernummer>9198011310134</Steuernummer>
2122 <Kz09>74931*NameSteuerber.*Berufsbez.*089*59958327*Mandantenname</Kz09>
2123 </Umsatzsteuervoranmeldung>
2125 </Anmeldungssteuern>
2131 #$DatenTeil .= qq| <Kz51>$k51</Kz51>\n| if ($k51 ne '0');
2132 #$DatenTeil .= qq| <Kz86>$k86</Kz86>\n| if ($k86 ne '0');
2133 #$DatenTeil .= qq| <Kz97>$k97</Kz97>\n| if ($k97 ne '0');
2134 #$DatenTeil .= qq| <Kz93>$k93</Kz93>\n| if ($k93 ne '0');
2135 #$DatenTeil .= qq| <Kz94>$k94</Kz94>\n| if ($k94 ne '0');
2136 #$DatenTeil .= qq| <Kz96>$k96</Kz96>\n| if ($k96 ne '0');
2137 #$DatenTeil .= qq| <Kz66>$k66</Kz66>\n| if ($k66 ne '0');
2138 #$DatenTeil .= qq| <Kz83>$k83</Kz83>\n| if ($k83 ne '0');
2140 my $filename = "$elster_conf->{'path'}/$elster_conf->{'xmlfile'}";
2141 open(XML, ">$elster_conf->{'path'}/$elster_conf->{'xmlfile'}")
2142 or $form->error("$filename : $!");
2143 print XML qq|$TransferHeader $DatenTeil|;
2145 $lxdebug->leave_sub();