#
#======================================================================
+use POSIX qw(strftime getcwd);
+use Archive::Zip qw(:ERROR_CODES :CONSTANTS);
+
+use SL::Common;
use SL::DATEV;
1;
# end of main
-sub continue { &{ $form->{nextsub} } }
+require "bin/mozilla/common.pl";
+
+sub continue { call_sub($form->{"nextsub"}); }
sub export {
$lxdebug->enter_sub();
+ $auth->assert('datev_export');
+
$form->{title} = $locale->text("DATEX - Export Assistent");
DATEV->get_datev_stamm(\%myconfig, \%$form);
<td align=left nowrap>| . $locale->text("Mandantennummer") . qq|</td>
<td><input name=mandantennr size=10 maxlength=5 value="$form->{mandantennr}"></td>
- <td align=left nowrap>| . $locale->text("Datenträgernummer") . qq|</td>
+ <td align=left nowrap>| . $locale->text("Medium Number") . qq|</td>
<td><input name=datentraegernr size=5 maxlength=3 value="$form->{datentraegernr}"></td>
</tr>
<tr>
- <td><input checked name=kne type=checkbox class=checkbox value=1> |
- . $locale->text("Kontonummernerweiterung (KNE)")
- . qq|</td>
+ | . # OBE-Export noch nicht implementiert! <td><input checked name=kne type=checkbox class=checkbox value=1> | . $locale->text("Kontonummernerweiterung (KNE)") . qq|</td>
+ qq|<td><input type="hidden" name="kne" value="1"></td>
<td></td>
<td align=left nowrap>| . $locale->text("Abrechnungsnummer") . qq|</td>
<td><input name=abrechnungsnr size=5 maxlength=3 value="$form->{abrechnungsnr}"></td>
</tr>
+
<tr>
<td><input name=exporttype type=radio class=radio value=0 checked> |
- . $locale->text("Export Buchungsdaten")
- . qq|</td>
+ . $locale->text("Export Buchungsdaten") . qq|</td>
<td></td>
<td><input name=exporttype type=radio class=radio value=1> |
- . $locale->text("Export Stammdaten")
- . qq|</td>
+ . $locale->text("Export Stammdaten") . qq|</td>
<td></td>
</td>
</table>
<input type=hidden name=nextsub value=export2>
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
-
<br>
<input type=submit class=submit name=action value="|
. $locale->text('Continue') . qq|">
sub export2 {
$lxdebug->enter_sub();
+ $auth->assert('datev_export');
+
if ($form->{exporttype} == 0) {
&export_bewegungsdaten();
} else {
sub export_bewegungsdaten {
$lxdebug->enter_sub();
+ $auth->assert('datev_export');
+
$form->{title} = $locale->text("DATEX - Export Assistent");
$form->{allemonate} =
. $locale->text('January')
. qq|</option>
<option value=2>|
- . $locale->text('February')
- . qq|</option>
+ . $locale->text('February') . qq|</option>
<option value=3>|
- . $locale->text('March')
- . qq|</option>
+ . $locale->text('March') . qq|</option>
<option value=4>|
- . $locale->text('April')
- . qq|</option>
+ . $locale->text('April') . qq|</option>
<option value=5>|
- . $locale->text('May')
- . qq|</option>
+ . $locale->text('May') . qq|</option>
<option value=6>|
- . $locale->text('June')
- . qq|</option>
+ . $locale->text('June') . qq|</option>
<option value=7>|
- . $locale->text('July')
- . qq|</option>
+ . $locale->text('July') . qq|</option>
<option value=8>|
- . $locale->text('August')
- . qq|</option>
+ . $locale->text('August') . qq|</option>
<option value=9>|
- . $locale->text('September')
- . qq|</option>
+ . $locale->text('September') . qq|</option>
<option value=10>|
- . $locale->text('October')
- . qq|</option>
+ . $locale->text('October') . qq|</option>
<option value=11>|
- . $locale->text('November')
- . qq|</option>
+ . $locale->text('November') . qq|</option>
<option value=12>|
- . $locale->text('December')
- . qq|</option>|;
+ . $locale->text('December') . qq|</option>|;
$form->{allequartale} =
qq|<option selected value=1>|
. qq|</option>
<option value=2>| . $locale->text('II') . qq|</option>
<option value=3>|
- . $locale->text('III')
- . qq|</option>
+ . $locale->text('III') . qq|</option>
<option value=4>|
- . $locale->text('IV')
- . qq|</option>|;
+ . $locale->text('IV') . qq|</option>|;
+ $form->{"jsscript"} = 1;
$form->header;
print qq|
<table>
<tr>
<td align=left><input checked name=zeitraum class=radio type=radio value=monat> </td><td align=left>|
- . $locale->text('Monat')
- . qq|</td>
+ . $locale->text('Monat') . qq|</td>
<td align=left></td>
<td align=left></td>
<td align=left><select name=monat>$form->{allemonate}</select></td>
</tr>
<tr>
<td align=left><input name=zeitraum class=radio type=radio value=quartal> </td><td align=left>|
- . $locale->text('Quartal')
- . qq|</td>
+ . $locale->text('Quartal') . qq|</td>
<td align=left></td>
<td align=left></td>
<td align=left><select name=quartal>$form->{allequartale}</select></td>
</tr>
<tr>
<td align=left><input name=zeitraum class=radio type=radio value=zeit> </td><td align=left>|
- . $locale->text('Datum von')
- . qq|</td>
- <td align=left><input name=transdatefrom size=8></td>
+ . $locale->text('Datum von') . qq|</td>
+ <td align=left><input id=transdatefrom name=transdatefrom size=10>
+ <input type="button" name="transdatefrom" id="trigger_transdatefrom" value="?"></td>
<td align=left>| . $locale->text('bis') . qq|</td>
- <td align=left><input name=transdateto size=8></td>
+ <td align=left><input id=transdateto name=transdateto size=10>
+ <input type="button" name="transdateto" id="trigger_transdateto" value="?"></td>
</tr>
</table>
</td>
</tr>
</table>
+| . $form->write_trigger(\%myconfig, 2,
+ "transdatefrom", "BL", "trigger_transdatefrom",
+ "transdateto", "BL", "trigger_transdateto") . qq|
+
<input type=hidden name=beraternr value="$form->{beraternr}">
<input type=hidden name=dfvkz value="$form->{dfvkz}">
<input type=hidden name=beratername value="$form->{beratername}">
<input type=hidden name=nextsub value=export3>
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
-
<br>
<input type=submit class=submit name=action value="|
. $locale->text('Continue') . qq|">
sub export_stammdaten {
$lxdebug->enter_sub();
+ $auth->assert('datev_export');
+
$form->{title} = $locale->text("DATEX - Export Assistent");
$form->header;
<input type=hidden name=nextsub value=export3>
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
-
<br>
<input type=submit class=submit name=action value="|
. $locale->text('Continue') . qq|">
sub export3 {
$lxdebug->enter_sub();
+ $auth->assert('datev_export');
+
DATEV->save_datev_stamm(\%myconfig, \%$form);
+ my $link = "datev.pl?action=download";
+
if ($form->{kne}) {
- if (DATEV->kne_export(\%myconfig, \%$form)) {
- $form->redirect($locale->text('KNE Export erfolgreich!'));
+ my @filenames = DATEV->kne_export(\%myconfig, \%$form);
+ if (@filenames) {
+ print(qq|<br><b>| . $locale->text('KNE-Export erfolgreich!') . qq|</b><br>|);
+ $link .= "&filenames=" . $form->escape(join(":", @filenames));
+ print(qq|<br><a href="$link">Download</a>|);
+ } else {
+ $form->error("KNE-Export schlug fehl.");
}
} else {
- if (DATEV->obe_export(\%myconfig, \%$form)) {
- $form->redirect($locale->text('OBE Export erfolgreich!'));
+ my @filenames = DATEV->obe_export(\%myconfig, \%$form);
+ if (@filenames) {
+ print(qq|<br><b>| . $locale->text('OBE-Export erfolgreich!') . qq|</b><br>|);
+ $link .= "&filenames=" . $form->escape(join(":", @filenames));
+ print(qq|<br><a href="$link">Download</a>|);
+ } else {
+ $form->error("OBE-Export schlug fehl.");
}
}
+
+ print("</body></html>");
+
+ $lxdebug->leave_sub();
+}
+
+sub download {
+ $lxdebug->enter_sub();
+
+ $auth->assert('datev_export');
+
+ my $tmp_name = Common->tmpname();
+ my $zip_name = strftime("lx-office-datev-export-%Y%m%d.zip",
+ localtime(time()));
+
+ my $cwd = getcwd();
+ chdir("users") || die("chdir users");
+
+ my @filenames = split(/:/, $form->{"filenames"});
+ map({ s|.*/||; $form->error("Eine der KNE-Exportdateien wurde nicht " .
+ "gefunden. Wurde der Export bereits " .
+ "durchgeführt?") unless (-f $_); }
+ @filenames);
+
+ my $zip = Archive::Zip->new();
+ map({ $zip->addFile($_); } @filenames);
+ $zip->writeToFileNamed($tmp_name);
+ chdir($cwd);
+
+ open(IN, $tmp_name) || die("open $tmp_name");
+ print("Content-Type: application/zip\n");
+ print("Content-Disposition: attachment; filename=\"${zip_name}\"\n\n");
+ while (<IN>) {
+ print($_);
+ }
+ close(IN);
+
+ unlink($tmp_name);
+
$lxdebug->leave_sub();
}