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 my $year = substr($form->datetonum($form->current_date(\%myconfig), \%myconfig),0,4);
88 <form method=post action=$form->{script}>
90 <input type=hidden name=title value="$form->{title}">
94 <th class=listtop>$form->{title}</th>
103 # Hier Aufruf von get_config aus bin/mozilla/fa.pl zum
104 # Einlesen der Finanzamtdaten
105 &get_config($userspath, 'finanzamt.ini');
107 # Hier Einlesen der user-config
108 # steuernummer entfernt für prerelease
109 my @a = qw(signature name company address businessnumber tel fax email
110 co_chief co_department co_custom1 co_custom2 co_custom3 co_custom4 co_custom5
112 co_street co_street1 co_zip co_city co_city1 co_country co_tel co_tel1 co_tel2
113 co_fax co_fax1 co_email co_email1 co_url co_url1 ustid duns
114 co_bankname co_bankname1 co_bankname2 co_bankname3 co_blz co_blz1
115 co_blz2 co_blz3 co_accountnr co_accountnr1 co_accountnr2 co_accountnr3);
117 map { $form->{$_} = $myconfig->{$_} } @a;
119 my $oeffnungszeiten = $form->{FA_Oeffnungszeiten};
120 $oeffnungszeiten =~ s/\\\\n/<br>/g;
123 <td width="50%" align="left" valign="top">
126 <b>| . $locale->text('Firma') . qq|</b>
129 if ($form->{company} ne '') {
130 print qq|<h3>$form->{company}</h3>\n|;
133 <a href=am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}>
134 | . $locale->text('Kein Firmenname hinterlegt!') . qq|</a><br>
138 # Anpassungen der Variablennamen auf pre 2.1.1 Namen
139 # klären, ob $form->{company_street|_address} gesetzt sind
142 if ($form->{address} ne '') {
143 my $temp = $form->{address};
144 $temp =~ s/\\n/<br \/>/;
145 ($form->{co_street}, $form->{co_city}) = split("<br \/>", $temp);
148 if ( $form->{co_street} ne ''
149 and ($form->{co_zip} ne ''
150 or $form->{co_city} ne '') ) {
152 $form->{co_street}<br>
153 $form->{co_street1}<br>
154 $form->{co_zip} $form->{co_city}|;
157 <a href=am.pl?path=$form->{path}&action=config&level=Programm--Preferences&login=$form->{login}&password=$form->{password}>
158 | . $locale->text('Keine Firmenadresse hinterlegt!') . qq|</a>\n|;
160 $form->{co_email}=$form->{email} unless $form->{co_email};
161 $form->{co_tel}=$form->{tel} unless $form->{co_tel};
162 $form->{co_fax}=$form->{fax} unless $form->{co_fax};
163 $form->{co_url}=$form->{urlx} unless $form->{co_url};
169 | . $locale->text('Tel.: ') . qq|
172 | . $locale->text('Fax.: ') . qq|
179 | . $locale->text('Steuernummer: ') . qq|
182 if ($form->{steuernummer} ne '') {
183 print qq|$form->{steuernummer}|;
186 <a href="ustva.pl?path=$form->{path}&action=edit&level=Programm--Finanzamteinstellungen&login=$form->{login}&password=$form->{password}">
187 Keine Steuernummer hinterlegt!</a><br>|;
191 | . $locale->text('ELSTER-Steuernummer: ') . qq|
192 $form->{elstersteuernummer}
199 if ($form->{FA_steuerberater_name} ne '') {
203 <input checked="checked" title="|
204 . $locale->text('Beraterdaten in UStVA übernehmen?')
205 . qq|" name="FA_steuerberater" id=steuerberater class=checkbox type=checkbox value="1">
206 <b>| . $locale->text('Steuerberater/-in') . qq|</b>
209 $form->{FA_steuerberater_name}<br>
210 $form->{FA_steuerberater_street}<br>
211 $form->{FA_steuerberater_city}<br>
212 Tel: $form->{FA_steuerberater_tel}<br>
220 <b>| . $locale->text('Voranmeldezeitraum') . qq|</b>
226 if (not defined $form->{all_years}) {
228 # accounting years if SQL-Ledger Version < 2.4.1
229 # $year = $form->{year} * 1;
230 @years = sort { $b <=> $a } (2003 .. ($year+1));
231 $form->{all_years} = \@years;
233 map { $form->{selectaccountingyear} .= qq|<option>$_\n| }
234 @{ $form->{all_years} };
236 <select name=year title="| . $locale->text('Year') . qq|">
239 foreach $key (@years) {
241 print qq|selected| if ($key eq $form->{year});
242 print qq| >$key</option>
246 my $voranmeld = $form->{FA_voranmeld};
247 print qq| </select>|;
249 $checked = "checked" if ($form->{kz10} eq '1');
251 <input name="FA_10" id=FA_10 class=checkbox type=checkbox value="1" $checked title = "|
253 'Ist dies eine berichtigte Anmeldung? (Nr. 10/Zeile 15 Steuererklärung)')
255 | . $locale->text('Berichtigte Anmeldung') . qq|
259 if ($voranmeld ne '') {
262 | . $locale->text($voranmeld) . qq|
264 print qq| mit Dauerfristverlängerung| if ($form->{FA_dauerfrist} eq '1');
270 if ($form->{method} ne '') {
271 print qq|| . $locale->text('Method') . qq|: |;
272 print qq|| . $locale->text('accrual') . qq||
273 if ($form->{method} eq 'accrual');
274 print qq|| . $locale->text('cash') . qq|| if ($form->{method} eq 'cash');
281 if ($form->{FA_Name} ne '') {
283 <td width="50%" valign="top">
286 <b>| . $locale->text('Finanzamt') . qq|</b>
288 <h3>$form->{FA_Name}</h2>
291 #if ($form->{FA_Ergaenzung_Name ne ''}){
293 # $form->{FA_Ergaenzung_Name} 
300 $form->{FA_PLZ} $form->{FA_Ort}
303 | . $locale->text('Tel. : ') . qq|
306 | . $locale->text('Fax. : ') . qq|
310 <a href="mailto:$form->{FA_Email}?subject=|
311 . CGI::escape("Steuer Nr: $form->{steuernummer}:")
314 "Sehr geehrte Damen und Herren,\n\n\nMit freundlichen Grüßen\n\n")
315 . CGI::escape($form->{signature}) . qq|">
319 <a href="$form->{FA_Internet}">
324 | . $locale->text('Öffnungszeiten') . qq|
331 ( $form->{FA_BLZ_1} ne ''
332 && $form->{FA_Kontonummer_1} ne ''
333 && $form->{FA_Bankbezeichnung_1} ne '');
335 ( $form->{FA_BLZ_2} ne ''
336 && $form->{FA_Kontonummer_2} ne ''
337 && $form->{FA_Bankbezeichnung_oertlich} ne '');
339 if ($FA_1 && $FA_2) {
342 | . $locale->text('Bankverbindungen') . qq|
346 $form->{FA_Bankbezeichnung_1}
348 | . $locale->text('Konto: ') . qq|
349 $form->{FA_Kontonummer_1}
351 | . $locale->text('BLZ: ') . qq|
355 $form->{FA_Bankbezeichnung_oertlich}
357 | . $locale->text('Konto: ') . qq|
358 $form->{FA_Kontonummer_2}
360 | . $locale->text('BLZ: ') . qq|
369 | . $locale->text('Bankverbindung') . qq|
372 $form->{FA_Bankbezeichnung_1}
374 | . $locale->text('Konto: ') . qq|
375 $form->{FA_Kontonummer_1}
377 | . $locale->text('BLZ: ') . qq|
378 $form->{FA_BLZ_1} <br>
383 | . $locale->text('Bankverbindung') . qq|
386 $form->{FA_Bankbezeichnung_oertlich}
388 | . $locale->text('Konto: ') . qq|
389 $form->{FA_Kontonummer_2}
391 | . $locale->text('BLZ: ') . qq|
401 <b>| . $locale->text('Ausgabeformat') . qq|</b>
411 # Stichtag der nächsten USTVA berechnen
413 # ($stichtag, $tage_bis, $ical) = FA->stichtag($today[dd.mm.yyyy],
414 # $FA_dauerfrist[1,0],
415 # $FA_voranmeld[month, quarter])
416 #$tmpdateform= $myconfig{dateformat};
417 # $myconfig{dateformat}= "dd.mm.yyyy";
418 # $form->{today} = $form->datetonum($form->current_date(\%myconfig), \%myconfig);
419 # ($stichtag, $description, $tage_bis, $ical) = FA::stichtag($form->{today}, $form->{FA_dauerfrist},$form->{FA_voranmeld});
420 # $form->{today} = $form->date($stichtag, \%myconfig );
421 #$myconfig{dateformat}= $tmpdateform;
428 # |.$locale->text('Anstehende Voranmeldungen').qq|
430 # <h2 class="confirm">$stichtag<h2>
431 # <h3>$description</h3>
432 # <h4>$form->{today}</h4>
438 <td width="50%" valign="bottom">
441 <b>| . $locale->text('Hinweise') . qq|</b>
443 <h2 class="confirm">Die Ausgabefunktionen sind wegen unzureichender Voreinstellungen deaktiviert.</h2>
446 <li> Wählen Sie im Administrationsmenü den momentanen Benutzer aus
447 (siehe Kopfzeile). Dort können Sie fehlende Firmenangaben bzw.
448 die Steuernummer ergänzen.</li>
453 $hide = q|disabled="disabled"|;
461 #}# end if report = ustva
468 <td><hr size="3" noshade></td>
473 <input type="hidden" name="address" value="$form->{address}">
474 <input type="hidden" name="reporttype" value="custom">
475 <input type="hidden" name="co_street" value="$form->{co_street}">
476 <input type="hidden" name="co_city" value="$form->{co_city}">
477 <input type="hidden" name="path" value="$form->{path}">
478 <input type="hidden" name="login" value="$form->{login}">
479 <input type="hidden" name="password" value="$form->{password}">
483 <input type=hidden name=nextsub value=generate_ustva>
484 <input $hide type=submit class=submit name=action value="|
485 . $locale->text('Show') . qq|">
490 <form action="doc/ustva.html" method="get">
492 <input type=submit class=submit name=action value="|
493 . $locale->text('Help') . qq|">
505 $lxdebug->leave_sub();
508 #############################
511 $lxdebug->enter_sub();
512 # parse help documents under doc
513 my $tmp = $form->{templates};
514 $form->{templates} = 'doc';
515 $form->{help} = 'ustva';
516 $form->{type} = 'help';
517 $form->{format} = 'html';
520 #$form->{templates} = $tmp;
521 $lxdebug->leave_sub();
525 $lxdebug->enter_sub();
528 $lxdebug->leave_sub();
529 &{ $form->{nextsub} };
533 sub ustva_vorauswahl {
534 $lxdebug->enter_sub();
535 #Aktuelles Datum zerlegen:
536 my $date = $form->datetonum($form->current_date(\%myconfig), \%myconfig);
538 #$locale->date($myconfig, $form->current_date($myconfig), 0)=~ /(\d\d).(\d\d).(\d\d\d\d)/;
539 $form->{day} = substr($date, 6, 2);
540 $form->{month} = substr($date, 4, 2);
541 $form->{year} = substr($date, 0, 4);
542 $lxdebug->message(LXDebug::DEBUG1, qq|
543 Actual date from Database: $date\n
544 Actual year from Database: $form->{year}\n
545 Actual day from Database: $form->{day}\n
546 Actual month from Database: $form->{month}\n|);
551 # Testdaten erzeugen:
553 #$form->{month}= '01';
554 #$form->{year}= 2004;
556 <input type=hidden name=day value=$form->{day}>
557 <input type=hidden name=month value=$form->{month}>
558 <input type=hidden name=yymmdd value=$yymmdd>
559 <input type=hidden name=sel value=$sel>
562 if ($form->{FA_voranmeld} eq 'month') {
564 # Vorauswahl bei monatlichem Voranmeldungszeitraum
566 <select name="duetyp" id=zeitraum title="|
567 . $locale->text('Hier den Berechnungszeitraum auswählen...') . qq|">
570 my %liste = ('01' => 'January',
585 my $yy = $form->{year} * 10000;
586 $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1;
591 # Offset für Dauerfristverlängerung
592 $dfv = '100' if ($form->{FA_dauerfrist} eq '1');
595 $yymmdd <= ($yy + 110 + $dfv) && do {
596 $form->{year} = $form->{year} - 1;
600 $yymmdd <= ($yy + 210 + $dfv) && do {
604 $yymmdd <= ($yy + 310 + $dfv) && do {
608 $yymmdd <= ($yy + 410 + $dfv) && do {
612 $yymmdd <= ($yy + 510 + $dfv) && do {
616 $yymmdd <= ($yy + 610 + $dfv) && do {
620 $yymmdd <= ($yy + 710 + $dfv) && do {
624 $yymmdd <= ($yy + 810 + $dfv) && do {
628 $yymmdd <= ($yy + 910 + $dfv) && do {
632 $yymmdd <= ($yy + 1010 + $dfv) && do {
636 $yymmdd <= ($yy + 1110 + $dfv) && do {
640 $yymmdd <= ($yy + 1210) && do {
644 $yymmdd <= ($yy + 1231) && do {
651 foreach $key (sort keys %liste) {
653 $selected = 'selected' if ($sel eq $key);
655 <option value="$key" $selected>|
656 . $locale->text("$liste{$key}")
663 } elsif ($form->{FA_voranmeld} eq 'quarter') {
665 # Vorauswahl bei quartalsweisem Voranmeldungszeitraum
666 my %liste = ( 'A' => $locale->text('1. Quarter'),
667 'B' => $locale->text('2. Quarter'),
668 'C' => $locale->text('3. Quarter'),
669 'D' => $locale->text('4. Quarter'),
670 '13' => $locale->text('Yearly'),
673 my $yy = $form->{year} * 10000;
674 $yymmdd = "$form->{year}$form->{month}$form->{day}" * 1;
676 my $dfv = ''; # Offset für Dauerfristverlängerung
677 $dfv = '100' if ($form->{FA_dauerfrist} eq '1');
680 $yymmdd <= ($yy + 110 + $dfv) && do {
681 $form->{year} = $form->{year} - 1;
685 $yymmdd <= ($yy + 410 + $dfv) && do {
689 $yymmdd <= ($yy + 710 + $dfv) && do {
693 $yymmdd <= ($yy + 1010 + $dfv) && do {
697 $yymmdd <= ($yy + 1231) && do {
702 print qq|<select id="zeitraum" name="duetyp" title="|
703 . $locale->text('Select a period') . qq|" >|;
705 foreach $key (sort keys %liste) {
707 $selected = 'selected' if ($sel eq $key);
709 <option value="$key" $selected>$liste{$key}</option>
717 # keine Vorauswahl bei Voranmeldungszeitraum
718 print qq|<select id="zeitraum" name="duetyp" title="|
719 . $locale->text('Select a period') . qq|" >|;
721 my %listea = ('A' => '1. Quarter',
724 'D' => '4. Quarter',);
726 my %listeb = ('01' => 'January',
741 foreach $key (sort keys %listea) {
743 <option value="$key">$listea{$key}</option>
747 foreach $key (sort keys %listeb) {
749 <option value="$key">| . $locale->text("$listeb{$key}") . qq|</option>
755 $lxdebug->leave_sub();
759 $lxdebug->enter_sub();
761 $lxdebug->leave_sub();
765 $lxdebug->enter_sub();
767 $lxdebug->leave_sub();
771 $lxdebug->enter_sub();
773 # $form->{PD}{$form->{type}} = "selected";
774 # $form->{DF}{$form->{format}} = "selected";
775 # $form->{OP}{$form->{media}} = "selected";
776 # $form->{SM}{$form->{sendmode}} = "selected";
777 my $type = qq| <input type=hidden name="type" value="ustva">|;
778 my $media = qq| <input type=hidden name="media" value="screen">|;
780 qq| <option value=html selected>|
781 . $locale->text('Vorschau')
785 qq| <option value=pdf>|
786 . $locale->text('UStVA als PDF-Dokument')
790 #my $disabled= qq|disabled="disabled"|;
791 #$disabled='' if ($form->{elster} eq '1' );
792 if ($form->{elster} eq '1') {
794 qq|<option value=elster>|
795 . $locale->text('ELSTER Export nach Winston')
799 #$format .= qq|<option value=elster>|.$locale->text('ELSTER Export nach Winston').qq|</option>|;
803 <select name=format title = "|
804 . $locale->text('Ausgabeformat auswählen...')
805 . qq|">$format</select>
807 $lxdebug->leave_sub();
811 $lxdebug->enter_sub();
813 # Aufruf von get_config aus bin/mozilla/ustva.pl zum
814 # Einlesen der Finanzamtdaten aus finanzamt.ini
816 get_config($userspath, 'finanzamt.ini');
818 # form vars initialisieren
819 my @anmeldungszeitraum =
820 qw('0401' '0402' '0403' '0404' '0405' '0405' '0406' '0407' '0408' '0409' '0410' '0411' '0412' '0441' '0442' '0443' '0444');
822 foreach $item (@anmeldungszeitraum) {
825 if ($form->{reporttype} eq "custom") {
827 #forgotten the year --> thisyear
828 if ($form->{year} !~ m/^\d\d\d\d$/) {
829 $form->{year} = substr($form->datetonum($form->current_date(\%myconfig), \%myconfig),0,4);
830 $lxdebug->message(LXDebug::DEBUG1, qq|Actual year from Database: $form->{year}\n|);
834 if ($form->{duetyp} eq "13") {
835 $form->{fromdate} = "$form->{year}0101";
836 $form->{todate} = "$form->{year}1231";
840 if ($form->{duetyp} eq "A") {
841 $form->{fromdate} = "$form->{year}0101";
842 $form->{todate} = "$form->{year}0331";
843 $form->{'0441'} = "X";
845 if ($form->{duetyp} eq "B") {
846 $form->{fromdate} = "$form->{year}0401";
847 $form->{todate} = "$form->{year}0630";
848 $form->{'0442'} = "X";
850 if ($form->{duetyp} eq "C") {
851 $form->{fromdate} = "$form->{year}0701";
852 $form->{todate} = "$form->{year}0930";
853 $form->{'0443'} = "X";
855 if ($form->{duetyp} eq "D") {
856 $form->{fromdate} = "$form->{year}1001";
857 $form->{todate} = "$form->{year}1231";
858 $form->{'0444'} = "X";
863 $form->{duetyp} eq "01" && do {
864 $form->{fromdate} = "$form->{year}0101";
865 $form->{todate} = "$form->{year}0131";
866 $form->{'0401'} = "X";
869 $form->{duetyp} eq "02" && do {
870 $form->{fromdate} = "$form->{year}0201";
872 #this works from 1901 to 2099, 1900 and 2100 fail.
873 my $leap = ($form->{year} % 4 == 0) ? "29" : "28";
874 $form->{todate} = "$form->{year}02$leap";
875 $form->{"0402"} = "X";
878 $form->{duetyp} eq "03" && do {
879 $form->{fromdate} = "$form->{year}0301";
880 $form->{todate} = "$form->{year}0331";
881 $form->{"0403"} = "X";
884 $form->{duetyp} eq "04" && do {
885 $form->{fromdate} = "$form->{year}0401";
886 $form->{todate} = "$form->{year}0430";
887 $form->{"0404"} = "X";
890 $form->{duetyp} eq "05" && do {
891 $form->{fromdate} = "$form->{year}0501";
892 $form->{todate} = "$form->{year}0531";
893 $form->{"0405"} = "X";
896 $form->{duetyp} eq "06" && do {
897 $form->{fromdate} = "$form->{year}0601";
898 $form->{todate} = "$form->{year}0630";
899 $form->{"0406"} = "X";
902 $form->{duetyp} eq "07" && do {
903 $form->{fromdate} = "$form->{year}0701";
904 $form->{todate} = "$form->{year}0731";
905 $form->{"0407"} = "X";
908 $form->{duetyp} eq "08" && do {
909 $form->{fromdate} = "$form->{year}0801";
910 $form->{todate} = "$form->{year}0831";
911 $form->{"0408"} = "X";
914 $form->{duetyp} eq "09" && do {
915 $form->{fromdate} = "$form->{year}0901";
916 $form->{todate} = "$form->{year}0930";
917 $form->{"0409"} = "X";
920 $form->{duetyp} eq "10" && do {
921 $form->{fromdate} = "$form->{year}1001";
922 $form->{todate} = "$form->{year}1031";
923 $form->{"0410"} = "X";
926 $form->{duetyp} eq "11" && do {
927 $form->{fromdate} = "$form->{year}1101";
928 $form->{todate} = "$form->{year}1130";
929 $form->{"0411"} = "X";
932 $form->{duetyp} eq "12" && do {
933 $form->{fromdate} = "$form->{year}1201";
934 $form->{todate} = "$form->{year}1231";
935 $form->{"0412"} = "X";
941 # using dates in ISO-8601 format: yyyymmmdd for Postgres...
942 USTVA->ustva(\%myconfig, \%$form);
944 # reformat Dates to dateformat
945 $form->{fromdate}= $locale->date(\%myconfig, $form->{fromdate}, 0, 0, 0);
947 $form->{todate} = $form->current_date($myconfig) unless $form->{todate};
948 $form->{todate}= $locale->date(\%myconfig, $form->{todate}, 0, 0, 0);
951 $locale->date(\%myconfig, $form->current_date(\%myconfig), 1, 0, 0);
954 # if there are any dates construct a where
955 if ($form->{fromdate} || $form->{todate}) {
957 unless ($form->{todate}) {
958 $form->{todate} = $form->current_date($myconfig);
961 my $longtodate = $locale->date($myconfig, $form->{todate}, 1, 0, 0);
962 my $shorttodate = $locale->date($myconfig, $form->{todate}, 0, 0, 0);
964 my $longfromdate = $locale->date($myconfig, $form->{fromdate}, 1, 0, 0);
965 my $shortfromdate = $locale->date($myconfig, $form->{fromdate}, 0, 0, 0);
967 $form->{this_period} = "$shortfromdate<br>\n$shorttodate";
969 $locale->text('for Period')
970 . qq|<br>\n$longfromdate |
971 . $locale->text('bis')
975 if ($form->{comparefromdate} || $form->{comparetodate}) {
976 my $longcomparefromdate =
977 $locale->date(\%myconfig, $form->{comparefromdate}, 1, 0, 0);
978 my $shortcomparefromdate =
979 $locale->date(\%myconfig, $form->{comparefromdate}, 0, 0, 0);
981 my $longcomparetodate =
982 $locale->date(\%myconfig, $form->{comparetodate}, 1, 0, 0);
983 my $shortcomparetodate =
984 $locale->date(\%myconfig, $form->{comparetodate}, 0, 0, 0);
986 $form->{last_period} = "$shortcomparefromdate<br>\n$shortcomparetodate";
988 "<br>\n$longcomparefromdate "
989 . $locale->text('bis')
990 . qq| $longcomparetodate|;
993 $form->{Datum_heute} =
994 $locale->date(\%myconfig, $form->current_date(\%myconfig), 0, 0, 0);
996 # setup variables for the form
997 # steuernummer für prerelease entfernt
998 my @a = qw(company businessnumber tel fax email
999 co_chief co_department co_custom1 co_custom2 co_custom3 co_custom4 co_custom5
1000 co_name1 co_name2 co_street co_street1 co_zip co_city co_city1 co_country co_tel co_tel1 co_tel2
1001 co_fax co_fax1 co_email co_email1 co_url co_url1 ustid duns
1002 co_bankname co_bankname1 co_bankname2 co_bankname3 co_blz co_blz1
1003 co_blz2 co_blz3 co_accountnr co_accountnr1 co_accountnr2 co_accountnr3);
1005 map { $form->{$_} = $myconfig{$_} } @a;
1007 if ($form->{address} ne '') {
1008 my $temp = $form->{address};
1009 $temp =~ s/\\n/<br \/>/;
1010 ($form->{co_street}, $form->{co_city}) = split("<br \/>", $temp);
1013 if ( $form->{format} eq 'pdf'
1014 or $form->{format} eq 'postscript') {
1015 $form->{padding} = "~~";
1016 $form->{bold} = "\textbf{";
1017 $form->{endbold} = "}";
1018 $form->{br} = '\\\\';
1021 my @numbers = qw(511 861 36 80 971 931 98 96 53 74
1022 85 65 66 61 62 Z67 63 64 59 69 39 83
1023 Z43 Z45 Z53 Z62 Z65);
1026 # Zahlenformatierung für Latex USTVA Formulare
1027 if ($myconfig{numberformat} eq '1.000,00' or
1028 $myconfig{numberformat} eq '1000,00') {
1029 foreach $number (@numbers) {
1030 $form->{$number} =~ s/,/~~/g;
1033 if ($myconfig{numberformat} eq '1000.00' or
1034 $myconfig{numberformat} eq '1,000.00') {
1035 foreach $number (@numbers) {
1036 $form->{$number} =~ s/\./~~/g;
1039 # Formatierungen für HTML Ausgabe
1040 } elsif ($form->{format} eq 'html') {
1041 $form->{padding} = " ";
1042 $form->{bold} = "<b>";
1043 $form->{endbold} = "</b>";
1044 $form->{br} = "<br>";
1045 $form->{address} =~ s/\\n/<br \/>/;
1049 if ($form->{format} eq 'elster') {
1050 if ($form->{duetyp} eq '13'){
1052 USTVA::info($locale->text('Impossible to create yearly Tax Report via Winston.<br \> Not yet implemented!'));
1057 $form->{templates} = $myconfig{templates};
1058 $form->{templates} = "doc" if ($form->{type} eq 'help');
1060 $form->{IN} = "$form->{type}";
1061 $form->{IN} = "$form->{help}" if ($form->{type} eq 'help');
1062 $form->{IN} = 'USTE' if ($form->{duetyp} eq '13' &&
1063 $form->{format} ne 'html');
1065 if ($form->{IN} eq 'USTE'){
1067 USTVA::info($locale->text('Impossible to create yearly Tax Report as PDF or PS.<br \> Not yet implemented!'));
1070 $form->{IN} .= "-$form->{year}"
1071 if ( $form->{format} eq 'pdf'
1072 or $form->{format} eq 'postscript');
1074 $form->{IN} .= '.tex'
1075 if ( $form->{format} eq 'pdf'
1076 or $form->{format} eq 'postscript');
1078 $form->{IN} .= '.html' if ($form->{format} eq 'html');
1081 #print qq|$myconfig<br>$path|;
1082 $form->parse_template($myconfig, $userspath);
1084 $lxdebug->leave_sub();
1088 $lxdebug->enter_sub();
1089 # edit all taxauthority prefs
1092 &get_config($userspath, 'finanzamt.ini');
1094 #&create_steuernummer;
1096 my $land = $form->{elsterland};
1097 my $amt = $form->{elsterFFFF};
1101 "$form->{cbscript}?action=edit&login=$form->{cblogin}&path=$form->{cbpath}&root=$form->{cbroot}&rpw=$form->{cbrpw}"
1102 if ($form->{cbscript} ne '' and $form->{cblogin} ne '');
1104 $form->{title} = $locale->text('Finanzamt - Einstellungen');
1107 <form name="verzeichnis" method=post action="$form->{script}">
1110 <th class="listtop">|
1111 . $locale->text('Finanzamt - Einstellungen')
1119 . $locale->text('Angaben zum Finanzamt')
1123 #print qq|$form->{terminal}|;
1125 USTVA::fa_auswahl($land, $amt, &elster_hash());
1131 $checked = "checked" if ($form->{method} eq 'accrual');
1134 <legend><b>| . $locale->text('Verfahren') . qq|</b>
1136 <input name=method id=accrual class=radio type=radio value="accrual" $checked>
1137 <label for="accrual">| . $locale->text('accrual') . qq|</label>
1141 $checked = "checked" if ($form->{method} eq 'cash');
1143 <input name=method id=cash class=radio type=radio value="cash" $checked>
1144 <label for="cash">| . $locale->text('cash') . qq|</label>
1148 <legend><b>| . $locale->text('Voranmeldungszeitraum') . qq|</b>
1152 $checked = "checked" if ($form->{FA_voranmeld} eq 'month');
1154 <input name=FA_voranmeld id=month class=radio type=radio value="month" $checked>
1155 <label for="month">| . $locale->text('month') . qq|</label>
1159 $checked = "checked" if ($form->{FA_voranmeld} eq 'quarter');
1161 <input name="FA_voranmeld" id=quarter class=radio type=radio value="quarter" $checked>
1162 <label for="quarter">| . $locale->text('quarter') . qq|</label>
1166 $checked = "checked" if ($form->{FA_dauerfrist} eq '1');
1168 <input name="FA_dauerfrist" id=FA_dauerfrist class=checkbox type=checkbox value="1" $checked>
1170 . $locale->text('Dauerfristverlängerung')
1176 <legend><b>| . $locale->text('Steuerberater/-in') . qq|</b>
1180 $checked = "checked" if ($form->{FA_71} eq 'X');
1182 <!-- <input name="FA_71" id=FA_71 class=checkbox type=checkbox value="X" $checked>
1183 <label for="FA_71">|
1184 . $locale->text('Verrechnung des Erstattungsbetrages erwünscht (Zeile 71)')
1191 | . $locale->text('Name') . qq|
1194 | . $locale->text('Straße') . qq|
1197 | . $locale->text('PLZ, Ort') . qq|
1200 | . $locale->text('Telefon') . qq|
1205 <input name="FA_steuerberater_name" id=steuerberater size=25 value="$form->{FA_steuerberater_name}">
1208 <input name="FA_steuerberater_street" id=steuerberater size=25 value="$form->{FA_steuerberater_street}">
1211 <input name="FA_steuerberater_city" id=steuerberater size=25 value="$form->{FA_steuerberater_city}">
1214 <input name="FA_steuerberater_tel" id=steuerberater size=25 value="$form->{FA_steuerberater_tel}">
1223 <!--<input type=submit class=submit name=action value="|
1224 . $locale->text('debug')
1228 <input type="button" name="Verweis" value="|
1229 . $locale->text('Back to user config...') . qq|"
1230 onClick="self.location.href='$callback'">| if ($callback ne '');
1233 <input type=submit class=submit name=action value="|
1234 . $locale->text('continue') . qq|">
1241 my @variables = qw( steuernummer elsterland elstersteuernummer elsterFFFF);
1243 foreach $variable (@variables) {
1245 <input name=$variable type=hidden value="$form->{$variable}">|;
1247 my $steuernummer_new = '';
1249 #<input type=hidden name="steuernummer_new" value="$form->{$steuernummer_new}">
1251 <input type=hidden name="callback" value="$callback">
1252 <input type=hidden name="nextsub" value="edit_form">
1253 <input type=hidden name="warnung" value="1">
1254 <input type=hidden name="saved" value="|
1255 . $locale->text('Bitte Angaben überprüfen') . qq|">
1256 <input type=hidden name="path" value=$form->{path}>
1257 <input type=hidden name="login" value=$form->{login}>
1258 <input type=hidden name="password" value=$form->{password}>
1259 <input type=hidden name="warnung" value="0">
1262 @variables = qw(FA_Name FA_Strasse FA_PLZ
1263 FA_Ort FA_Telefon FA_Fax FA_PLZ_Grosskunden FA_PLZ_Postfach FA_Postfach
1264 FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1 FA_BLZ_2
1265 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten
1266 FA_Email FA_Internet);
1268 foreach $variable (@variables) {
1270 <input name=$variable type=hidden value="$form->{$variable}">|;
1277 $lxdebug->leave_sub();
1281 $lxdebug->enter_sub();
1286 my $elsterland = '';
1287 my $elster_amt = '';
1288 my $elsterFFFF = '';
1289 my $elstersteuernummer = '';
1290 &get_config($userspath, 'finanzamt.ini')
1291 if ($form->{saved} eq $locale->text('saved'));
1293 # Auf Übergabefehler checken
1296 'Bitte das Bundesland UND die Stadt bzw. den Einzugsbereich Ihres zuständigen Finanzamts auswählen.'
1298 if ( $form->{elsterFFFF_new} eq 'Auswahl'
1299 || $form->{elsterland_new} eq 'Auswahl');
1302 'Es fehlen Angaben zur Versteuerung.
1303 Wenn Sie Ist Versteuert sind, wählen Sie die Einnahmen/Überschuß-Rechnung aus.
1304 Sind Sie Soll-Versteuert und Bilanzverpflichtet, dann wählen Sie Bilanz aus.'
1306 if ($form->{method} eq '');
1308 # Klären, ob Variablen bereits befüllt sind UND ob veräderungen auf
1309 # der vorherigen Maske stattfanden: $change = 1(in der edit sub,
1310 # mittels get_config)
1313 $form->{elsterland} eq $form->{elsterland_new}
1314 && $form->{elsterFFFF} eq $form->{elsterFFFF_new} ? '0' : '1';
1315 $change = '0' if ($form->{saved} eq $locale->text('saved'));
1316 my $elster_init = &elster_hash();
1318 #my %elster_init = ();
1319 my %elster_init = %$elster_init;
1321 if ($change eq '1') {
1324 $elsterland = $form->{elsterland_new};
1325 $elsterFFFF = $form->{elsterFFFF_new};
1326 $form->{elsterland} = $elsterland;
1327 $form->{elsterFFFF} = $elsterFFFF;
1328 $form->{steuernummer} = '';
1329 &create_steuernummer;
1331 # rebuild elster_amt
1333 foreach $amt (keys %{ $elster_init{ $form->{elsterland} } }) {
1335 if ($elster_init{ $form->{elsterland}{$amt} eq $form->{elsterFFFF} });
1338 # load the predefined hash data into the FA_* Vars
1339 my @variables = qw(FA_Name FA_Strasse FA_PLZ FA_Ort
1340 FA_Telefon FA_Fax FA_PLZ_Grosskunden FA_PLZ_Postfach
1342 FA_BLZ_1 FA_Kontonummer_1 FA_Bankbezeichnung_1
1343 FA_BLZ_2 FA_Kontonummer_2 FA_Bankbezeichnung_oertlich
1344 FA_Oeffnungszeiten FA_Email FA_Internet);
1346 for (my $i = 0; $i <= 20; $i++) {
1347 $form->{ $variables[$i] } =
1348 $elster_init->{$elsterland}->{$elsterFFFF}->[$i];
1353 $elsterland = $form->{elsterland};
1354 $elsterFFFF = $form->{elsterFFFF};
1357 my $stnr = $form->{steuernummer};
1359 my $patterncount = $form->{patterncount};
1360 my $elster_pattern = $form->{elster_pattern};
1361 my $delimiter = $form->{delimiter};
1362 my $steuernummer = '';
1363 $steuernummer = $form->{steuernummer} if ($steuernummer eq '');
1366 my $warnung = $form->{warnung};
1370 <form name="elsterform" method=post action="$form->{script}">
1371 <table width="100%">
1373 <th colspan="2" class="listtop">|
1374 . $locale->text('Finanzamt - Einstellungen')
1390 <font size="+1">| . $locale->text('Steuernummer') . qq|</font>
1395 USTVA::steuernummer_input($form->{elsterland}, $form->{elsterFFFF},
1396 $form->{steuernummer});
1408 <input type=hidden name=lastsub value="edit">
1410 print qq|<input type=submit class=submit name=action value="|
1411 . $locale->text('back') . qq|">|
1412 if ($form->{callback} eq '');
1415 <input type="button" name="Verweis" value="|
1416 . $locale->text('Back to user config...') . qq|"
1417 onClick="self.location.href='$form->{callback}'">|
1418 if ($form->{callback} ne '');
1420 if ($form->{warnung} eq "1") {
1422 <input type=hidden name=nextsub value="edit_form">
1423 <input type=submit class=submit name=action value="|
1424 . $locale->text('continue') . qq|">
1425 <input type=hidden name="saved" value="|
1426 . $locale->text('Bitte alle Angaben überprüfen') . qq|">
1430 <input type=hidden name="nextsub" value="save">
1431 <input type=hidden name="filename" value="finanzamt.ini">
1432 <input type=submit class=submit name=action value="|
1433 . $locale->text('save') . qq|">
1440 <H2 class=confirm>$form->{saved}</H2>
1446 my @variables = qw(FA_steuerberater_name FA_steuerberater_street
1447 FA_steuerberater_city FA_steuerberater_tel
1449 FA_dauerfrist FA_71 elster
1450 path login password type elster_init saved
1453 foreach $variable (@variables) {
1455 <input name="$variable" type="hidden" value="$form->{$variable}">|;
1458 <input type=hidden name="elsterland" value="$elsterland">
1459 <input type=hidden name="elsterFFFF" value="$elsterFFFF">
1460 <input type=hidden name="warnung" value="$warnung">
1461 <input type=hidden name="elstersteuernummer" value="$elstersteuernummer">
1462 <input type=hidden name="steuernummer" value="$stnr">
1463 <input type=hidden name="callback" value="$form->{callback}">
1466 $lxdebug->leave_sub();
1469 sub create_steuernummer {
1470 $lxdebug->enter_sub();
1471 my $part = $form->{part};
1472 my $patterncount = $form->{patterncount};
1473 my $delimiter = $form->{delimiter};
1474 my $elster_pattern = $form->{elster_pattern};
1476 # rebuild steuernummer and elstersteuernummer
1477 # es gibt eine gespeicherte steuernummer $form->{steuernummer}
1478 # und die parts und delimiter
1483 my $steuernummer_new = $part;
1484 my $elstersteuernummer_new = $form->{elster_FFFF};
1485 $elstersteuernummer_new .= '0';
1487 for ($h = 1; $h < $patterncount; $h++) {
1488 $steuernummer_new .= qq|$delimiter|;
1489 for (my $i = 1; $i <= length($elster_pattern); $i++) {
1490 $steuernummer_new .= $form->{"part_$h\_$i"};
1491 $elstersteuernummer_new .= $form->{"part_$h\_$i"};
1494 if ($form->{steuernummer} ne $steuernummer_new) {
1495 $form->{steuernummer} = $steuernummer_new;
1496 $form->{elstersteuernummer} = $elstersteuernummer_new;
1497 $form->{steuernummer_new} = $steuernummer_new;
1499 $form->{steuernummer_new} = '';
1500 $form->{elstersteuernummer_new} = '';
1502 $lxdebug->leave_sub();
1506 $lxdebug->enter_sub();
1508 my ($userpath, $filename) = @_;
1509 my ($key, $value) = '';
1510 open(FACONF, "$userpath/$form->{login}_$filename")
1511 or #falls Datei nicht vorhanden ist
1513 open(FANEW, ">$userpath/$form->{login}_$filename")
1514 or $form->error("$userpath/$filename : $!");
1516 open(FACONF, "$userpath/$form->{login}_$filename")
1517 or $form->error("$userpath/$form->{username}_$filename : $!");
1526 # remove any trailing whitespace
1527 s/^\s*(.*?)\s*$/$1/;
1528 ($key, $value) = split /=/, $_, 2;
1530 #if ($value eq ' '){
1531 # $form->{$key} = " " ;
1532 #} elsif ($value ne ' '){
1533 $form->{$key} = "$value";
1539 # Textboxen formatieren: Linebreaks entfernen
1541 #$form->{FA_Oeffnungszeiten} =~ s/\\\\n/<br>/g;
1542 $lxdebug->leave_sub();
1546 $lxdebug->enter_sub();
1547 my $filename = "$form->{login}_$form->{filename}";
1549 #zuerst die steuernummer aus den part, parts_X_Y und delimiter herstellen
1550 create_steuernummer;
1552 # Textboxen formatieren: Linebreaks entfernen
1554 $form->{FA_Oeffnungszeiten} =~ s/\r\n/\\n/g;
1556 #URL mit http:// davor?
1557 $form->{FA_Internet} =~ s/^http:\/\///;
1558 $form->{FA_Internet} = 'http://' . $form->{FA_Internet};
1560 my @config = qw(elster elsterland elstersteuernummer steuernummer
1561 elsteramt elsterFFFF FA_Name FA_Strasse
1562 FA_PLZ FA_Ort FA_Telefon FA_Fax FA_PLZ_Grosskunden
1563 FA_PLZ_Postfach FA_Postfach FA_BLZ_1 FA_Kontonummer_1
1564 FA_Bankbezeichnung_1 FA_BLZ_2 FA_Kontonummer_2
1565 FA_Bankbezeichnung_oertlich FA_Oeffnungszeiten
1566 FA_Email FA_Internet FA_voranmeld method FA_steuerberater_name
1567 FA_steuerberater_street FA_steuerberater_city FA_steuerberater_tel
1568 FA_71 FA_dauerfrist);
1570 # Hier kommt dann die Plausibilitätsprüfung der ELSTERSteuernummer
1571 if ($form->{elstersteuernummer} ne '000000000') {
1572 $form->{elster} = '1';
1573 open(CONF, ">$userspath/$filename") or $form->error("$filename : $!");
1575 # create the config file
1576 print CONF qq|# Configuration file for USTVA\n\n|;
1578 foreach $key (sort @config) {
1579 $form->{$key} =~ s/\\/\\\\/g;
1580 $form->{$key} =~ s/"/\\"/g;
1583 $form->{$key} =~ s/\r\n/\n/g;
1584 print CONF qq|$key=|;
1585 if ($form->{$key} ne 'Y') {
1586 print CONF qq|$form->{$key}\n|;
1588 if ($form->{$key} eq 'Y') {
1589 print CONF qq|checked \n|;
1592 print CONF qq|\n\n|;
1594 $form->{saved} = $locale->text('saved');
1598 $form->{saved} = $locale->text('Bitte eine Steuernummer angeben');
1602 $lxdebug->leave_sub();
1606 $lxdebug->enter_sub();
1608 my $oeffnungszeiten = $form->{FA_Oeffnungszeiten};
1609 $oeffnungszeiten =~ s/\\\\n/\n/g;
1614 . $locale->text('Finanzamt')
1615 . qq| $form->{FA_Name}</font>
1619 #print qq|\n<h4>$form->{FA_Ergaenzung_Name} </h4>
1620 # | if ( $form->{FA_Ergaenzung_Name} );
1622 <table width="100%" valign="top">
1628 <b>| . $locale->text('Address') . qq|</b>
1631 <table width="100%">
1634 | . $locale->text('Finanzamt') . qq|
1639 <input name="FA_Name" size="40" title="FA_Name" value="$form->{FA_Name}" $readonly>
1644 <input name="FA_Strasse" size="40" title="FA_Strasse" value="$form->{FA_Strasse}" $readonly>
1649 <input name="FA_PLZ" size="10" title="FA_PLZ" value="$form->{FA_PLZ}" $readonly>
1652 <input name="FA_Ort" size="20" title="FA_Ort" value="$form->{FA_Ort}" $readonly>
1660 <b>| . $locale->text('Kontakt') . qq|</b>
1662 | . $locale->text('Telefon') . qq|<br>
1663 <input name="FA_Telefon" size="40" title="FA_Telefon" value="$form->{FA_Telefon}" $readonly>
1666 | . $locale->text('Fax') . qq|<br>
1667 <input name="FA_Fax" size="40" title="FA_Fax" value="$form->{FA_Fax}" $readonly>
1670 | . $locale->text('Internet') . qq|<br>
1671 <input name="FA_Email" size="40" title="FA_Email" value="$form->{FA_Email}" $readonly>
1674 <input name="FA_Internet" size="40" title="" title="FA_Internet" value="$form->{FA_Internet}" $readonly>
1682 <b>| . $locale->text('Öffnungszeiten') . qq|</b>
1684 <textarea name="FA_Oeffnungszeiten" rows="4" cols="40" $readonly>$oeffnungszeiten</textarea>
1689 ( $form->{FA_BLZ_1} ne ''
1690 && $form->{FA_Kontonummer_1} ne ''
1691 && $form->{FA_Bankbezeichnung_1} ne '');
1693 ( $form->{FA_BLZ_2} ne ''
1694 && $form->{FA_Kontonummer_2} ne ''
1695 && $form->{FA_Bankbezeichnung_oertlich} ne '');
1697 if ($FA_1 && $FA_2) {
1702 . $locale->text('Bankverbindungen des Finanzamts') . qq|</b>
1707 | . $locale->text('Kreditinstitut') . qq|
1709 <input name="FA_Bankbezeichnung_1" size="30" value="$form->{FA_Bankbezeichnung_1}" $readonly>
1712 | . $locale->text('Kontonummer') . qq|
1714 <input name="FA_Kontonummer_1" size="15" value="$form->{FA_Kontonummer_1}" $readonly>
1717 | . $locale->text('Bankleitzahl') . qq|
1719 <input name="FA_BLZ_1" size="15" value="$form->{FA_BLZ_1}" $readonly>
1722 | . $locale->text('Kreditinstitut') . qq|
1724 <input name="FA_Bankbezeichnung_oertlich" size="30" value="$form->{FA_Bankbezeichnung_oertlich}" $readonly>
1727 | . $locale->text('Kontonummer') . qq|
1729 <input name="FA_Kontonummer_2" size="15" value="$form->{FA_Kontonummer_2}" $readonly>
1732 | . $locale->text('Bankleitzahl') . qq|
1734 <input name="FA_BLZ_2" size="15" value="$form->{FA_BLZ_2}" $readonly>
1745 . $locale->text('Bankverbindung des Finanzamts') . qq|</b>
1747 | . $locale->text('Kontonummer') . qq|
1749 <input name="FA_Kontonummer_1" size="30" value="$form->{FA_Kontonummer_1}" $readonly>
1752 | . $locale->text('Bankleitzahl (BLZ)') . qq|
1754 <input name="FA_BLZ_1" size="15" value="$form->{FA_BLZ_1}" $readonly>
1757 | . $locale->text('Kreditinstitut') . qq|
1759 <input name="FA_Bankbezeichnung_1" size="15" value="$form->{FA_Bankbezeichnung_1}" $readonly>
1768 . $locale->text('Bankverbindung des Finanzamts') . qq|</b>
1770 | . $locale->text('Kontonummer') . qq|
1772 <input name="FA_Kontonummer_2" size="30" value="$form->{FA_Kontonummer_2}" $readonly>
1775 | . $locale->text('Bankleitzahl (BLZ)') . qq|
1777 <input name="FA_BLZ_2" size="15" value="$form->{FA_BLZ_2}" $readonly>
1780 | . $locale->text('Kreditinstitut') . qq|
1782 <input name="FA_Bankbezeichnung_oertlich" size="15" value="$form->{FA_Bankbezeichnung_oertlich}" $readonly>
1792 $lxdebug->leave_sub();
1795 sub create_winston {
1796 $lxdebug->enter_sub();
1797 &get_config($userspath, 'finanzamt.ini');
1799 # There is no generic Linux GNU/GPL solution out for using ELSTER.
1800 # In lack of availability linux users may use windows pendants. I choose
1801 # WINSTON, because it's free of coast, it has an API and its tested under
1803 # The author of WINSTON developed some c-code to realize ELSTER under
1804 # WINDOWS and Linux (http://www.felfri.de/fa_xml/). Next year (2005) I start to
1805 # develop a server side solution for LX-Office ELSTER under Linux and
1806 # WINDOWS based on this c-code.
1808 # You need to download WINSTON from http://www.felfri.de/winston/
1809 # There (http://www.felfri.de/winston/download.htm) you'll find instructions
1810 # about WINSTON under Linux WINE
1811 # More infos about Winstons API: http://www.felfri.de/winston/schnittstellen.htm
1813 my $file = ''; # Filename for Winstonfile
1814 $file .= 'U'; # 1. char 'U' = USTVA
1817 { # 2. and 3. char 01-12= Month 41-44= Quarter (azr:Abrechnungszeitraum)
1818 $form->{duetyp} eq "01" && do {
1822 $form->{duetyp} eq "02" && do {
1826 $form->{duetyp} eq "03" && do {
1830 $form->{duetyp} eq "04" && do {
1834 $form->{duetyp} eq "05" && do {
1838 $form->{duetyp} eq "06" && do {
1842 $form->{duetyp} eq "07" && do {
1846 $form->{duetyp} eq "08" && do {
1850 $form->{duetyp} eq "09" && do {
1854 $form->{duetyp} eq "10" && do {
1858 $form->{duetyp} eq "11" && do {
1862 $form->{duetyp} eq "12" && do {
1866 $form->{duetyp} eq "A" && do {
1870 $form->{duetyp} eq "B" && do {
1874 $form->{duetyp} eq "C" && do {
1878 $form->{duetyp} eq "D" && do {
1884 "Ungültiger Anmeldezeitraum.\n
1885 Sie können für ELSTER nur einen monatlichen oder
1886 quartalsweisen Anmeldezeitraum auswählen."
1893 #4. and 5. char = year modulo 100
1894 $file .= sprintf("%02d", $form->{year} % 100);
1896 #6. to 18. char = Elstersteuernummer
1897 #Beispiel: Steuernummer in Bayern
1898 #111/222/33334 ergibt für UStVA Jan 2004: U01049111022233334
1900 $file .= $form->{elsterFFFF};
1901 $file .= $form->{elstersteuernummer};
1906 $form->{elsterfile} = $file;
1911 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"}))
1912 ; # Umsätze zu 16% USt
1914 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"}))
1915 ; # Umsätze zu 7% USt
1917 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"}))
1918 ; # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1920 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"}))
1921 ; # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
1923 sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"}))
1924 ; # neuer Fahrzeuge von Lieferern
1926 $form->parse_amount(\%myconfig, $form->{"66"}) *
1927 100; # Vorsteuer 7% plus 16%
1929 $form->parse_amount(\%myconfig, $form->{"67"}) * 100; # Umsätze zu 7% USt
1930 my $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100; #
1932 # Now build the xml content
1935 $form->{elster} = qq|<?xml version="1.0" encoding="ISO-8859-1" ?>
1936 <!-- Diese Datei ist mit Lx-Office $form->{version} generiert -->
1938 <Formular Typ="UST"></Formular>
1939 <Ordnungsnummer>$form->{elstersteuernummer}</Ordnungsnummer>
1940 <AnmeldeJahr>$form->{year}</AnmeldeJahr>
1941 <AnmeldeZeitraum>$azr</AnmeldeZeitraum>
1944 $form->{elster} .= qq|<Kennzahl Nr="51">$k51</Kennzahl>\n| if ($k51 ne '0');
1945 $form->{elster} .= qq|<Kennzahl Nr="86">$k86</Kennzahl>\n| if ($k86 ne '0');
1946 $form->{elster} .= qq|<Kennzahl Nr="97">$k97</Kennzahl>\n| if ($k97 ne '0');
1947 $form->{elster} .= qq|<Kennzahl Nr="93">$k93</Kennzahl>\n| if ($k93 ne '0');
1948 $form->{elster} .= qq|<Kennzahl Nr="94">$k94</Kennzahl>\n| if ($k94 ne '0');
1949 $form->{elster} .= qq|<Kennzahl Nr="96">$k96</Kennzahl>\n| if ($k96 ne '0');
1950 $form->{elster} .= qq|<Kennzahl Nr="66">$k66</Kennzahl>\n| if ($k66 ne '0');
1951 $form->{elster} .= qq|<Kennzahl Nr="83">$k83</Kennzahl>\n| if ($k83 ne '0');
1952 $form->{elster} .= qq|\n</WinstonAusgang>\n\n|;
1955 #print qq|$form->{elsterfile}|;
1956 #print qq|$form->{elster}|;
1957 $SIG{INT} = 'IGNORE';
1960 $lxdebug->leave_sub();
1964 $lxdebug->enter_sub();
1965 my $elster = $form->{elster};
1966 my $elsterfile = $form->{elsterfile};
1967 open(OUT, ">-") or $form->error("STDOUT : $!");
1968 print OUT qq|Content-Type: application/file;
1969 Content-Disposition: attachment; filename="$elsterfile"\n\n|;
1972 $lxdebug->leave_sub();
1976 $lxdebug->enter_sub();
1977 # allow Symbolic references just here:
1979 &{ $form->{nextsub} };
1981 $lxdebug->leave_sub();
1985 $lxdebug->enter_sub();
1986 &{ $form->{lastsub} };
1987 $lxdebug->leave_sub();
1991 $lxdebug->enter_sub();
1992 my $finanzamt = USTVA::query_finanzamt(\%myconfig, \%$form);
1993 $lxdebug->leave_sub();
1998 $lxdebug->enter_sub();
2000 # biegt nur den Testeintrag in Programm->Test auf eine Routine um
2004 $lxdebug->leave_sub();
2008 $lxdebug->enter_sub();
2011 my $elster_conf = &elster_conf();
2014 $form->{cwd} = cwd();
2015 $form->{tmpdir} = $form->{cwd} . '/' . $elster_conf->{'path'};
2016 $form->{tmpfile} = $elster_conf->{'err'};
2017 my $caller = $elster_conf->{'call'}[0];
2019 chdir("$form->{tmpdir}") or $form->error($form->cleanup . "chdir : $!");
2021 "faxmlsend $caller -config etc/faxmlsend.cnf -xml faxmlsend.xml -tt faxmlsend.tt -debug";
2023 system("$send > $form->{tmpfile}");
2024 $form->{tmpdir} .= "$elster_conf->{'path'}/";
2025 $form->{tmpfile} = "faxmlsend.err";
2026 $form->error($form->cleanup
2027 . "faxmlsend : OFD meldet: Error 404 \n Internetseite nicht vorhanden")
2029 $form->error($form->cleanup
2030 . "faxmlsend : No such File: faxmlsend.xml \n Fehlernummer: $? \n Problem beim öffnen der faxmlsend.xml"
2034 # foreach my $line (&elster_feedback("$elster_conf->{'path'}")){
2035 # print qq|$line\n|;
2039 #for (my $i=0; $i<= )
2041 print qq|\n ende\n|;
2042 $lxdebug->leave_sub();
2045 sub elster_readlog {
2046 $lxdebug->enter_sub();
2047 my $elster_conf = &elster_conf();
2048 open(LOG, "$elster_conf->{'logfile'}")
2049 or $form->error("$elster_conf->{'logfile'}: $!");
2050 print qq|<listing>|;
2061 #$_ =~ s/\015\012//mg;
2065 if ($_ =~ /^\d\d\d\d\d\d/g) {
2068 #} elsif ($_ =~ /(<([^\/]*?)>)/ ) {
2069 } elsif ($_ =~ /(<([^\/].*?)>(.*))/g) {
2071 #$xml .= qq|$2 = $3\n\n|;
2072 #$_ =~ s/\015\012//mg;
2085 # $var .= qq|$2 = $3\n\n|;
2089 print qq|</listing>|;
2092 # s{<(\w+)\b([^<>]*)>
2093 # ((?:.(?!</?\1\b))*.)
2095 # { print "markup=",$1," args=",$2," enclosed=",$3," final=",$4 ; "" }gsex;
2097 $lxdebug->leave_sub();
2100 sub elster_feedback {
2101 $lxdebug->enter_sub();
2104 print qq|feedback:<br>|;
2110 $lxdebug->leave_sub();
2115 $lxdebug->enter_sub();
2116 my $elster_conf = { 'path' => 'elster',
2117 'prg' => 'faxmlsend',
2118 'err' => 'faxmlsend.err',
2119 'ttfile' => 'faxmlsend.tt',
2120 'xmlfile' => 'faxmlsend.xml',
2121 'cline' => '-tt $ttfile -xml $xmlfile',
2122 'call' => ['send', 'protokoll', 'anmeldesteuern'],
2123 'logfile' => 'log/faxmlsend.log',
2124 'conffile' => 'faxmlsend.cnf',
2125 'debug' => '-debug' };
2126 $lxdebug->leave_sub();
2127 return $elster_conf;
2132 $lxdebug->enter_sub();
2133 my $elster_conf = &elster_conf();
2135 # $k51 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"51"})); # Umsätze zu 16% USt
2136 # $k86 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"86"})); # Umsätze zu 7% USt
2137 # $k97 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"97"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
2138 # $k93 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"93"})); # 16% Steuerpflichtige innergemeinsachftliche Erwerbe
2139 # $k94 = sprintf("%d", $form->parse_amount(\%myconfig, $form->{"94"})); # neuer Fahrzeuge von Lieferern
2140 # $k66 = $form->parse_amount(\%myconfig, $form->{"66"}) * 100;# Vorsteuer 7% plus 16%
2141 # $k83 = $form->parse_amount(\%myconfig, $form->{"67"}) * 100;# Umsätze zu 7% USt
2142 # $k96 = $form->parse_amount(\%myconfig, $form->{"96"}) * 100;#
2144 my $TransferHeader = qq|<?xml version="1.0" encoding="ISO-8859-1"?>
2145 <?xml-stylesheet type="text/xsl" href="..\\Stylesheet\\ustva.xsl"?>
2146 <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
2147 ..\\Schemata\\elster_UStA_200501_extern.xsd">
2148 <TransferHeader version="7">
2149 <Verfahren>ElsterAnmeldung</Verfahren>
2150 <DatenArt>UStVA</DatenArt>
2151 <Vorgang>send-NoSig</Vorgang>
2152 <Testmerker>700000004</Testmerker>
2153 <HerstellerID>74931</HerstellerID>
2154 <DatenLieferant>Helmut</DatenLieferant>
2156 <Verschluesselung>PKCS#7v1.5</Verschluesselung>
2157 <Kompression>GZIP</Kompression>
2158 <DatenGroesse>123456789012345678901234567890123456789012</DatenGroesse>
2159 <TransportSchluessel/>
2180 <NutzdatenHeader version="9">
2181 <NutzdatenTicket>234234234</NutzdatenTicket>
2182 <Empfaenger id="F">9198</Empfaenger>
2184 <ProduktName>ElsterAnmeldung</ProduktName>
2185 <ProduktVersion>V 1.4</ProduktVersion>
2187 <DatenLieferant>String, der Lieferanteninfo enthaelt</DatenLieferant>
2193 <!--die Version gibt Auskunft ueber das Jahr und die derzeit gueltige Versionsnummer-->
2194 <Anmeldungssteuern art="UStVA" version="200501">
2196 <Name>OFD Muenchen</Name>
2197 <Strasse>Meiserstr. 6</Strasse>
2201 <Erstellungsdatum>20041127</Erstellungsdatum>
2203 <Umsatzsteuervoranmeldung>
2205 <Zeitraum>01</Zeitraum>
2206 <Steuernummer>9198011310134</Steuernummer>
2207 <Kz09>74931*NameSteuerber.*Berufsbez.*089*59958327*Mandantenname</Kz09>
2208 </Umsatzsteuervoranmeldung>
2210 </Anmeldungssteuern>
2216 #$DatenTeil .= qq| <Kz51>$k51</Kz51>\n| if ($k51 ne '0');
2217 #$DatenTeil .= qq| <Kz86>$k86</Kz86>\n| if ($k86 ne '0');
2218 #$DatenTeil .= qq| <Kz97>$k97</Kz97>\n| if ($k97 ne '0');
2219 #$DatenTeil .= qq| <Kz93>$k93</Kz93>\n| if ($k93 ne '0');
2220 #$DatenTeil .= qq| <Kz94>$k94</Kz94>\n| if ($k94 ne '0');
2221 #$DatenTeil .= qq| <Kz96>$k96</Kz96>\n| if ($k96 ne '0');
2222 #$DatenTeil .= qq| <Kz66>$k66</Kz66>\n| if ($k66 ne '0');
2223 #$DatenTeil .= qq| <Kz83>$k83</Kz83>\n| if ($k83 ne '0');
2225 my $filename = "$elster_conf->{'path'}/$elster_conf->{'xmlfile'}";
2226 open(XML, ">$elster_conf->{'path'}/$elster_conf->{'xmlfile'}")
2227 or $form->error("$filename : $!");
2228 print XML qq|$TransferHeader $DatenTeil|;
2230 $lxdebug->leave_sub();