#=====================================================================
-# Lx-Office ERP
+# kivitendo ERP
# Copyright (c) 2004
#
# Author: Philip Reetz
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
-# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
+# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
+# MA 02110-1335, USA.
#======================================================================
#
# Datev export module
#
#======================================================================
-use SL::DATEV;
+use POSIX qw(strftime getcwd);
+use Archive::Zip qw(:ERROR_CODES :CONSTANTS);
+
+use SL::Common;
+use SL::DATEV qw(:CONSTANTS);
+use SL::Locale::String qw(t8);
+use SL::DB::Department;
+
+use strict;
1;
# end of main
-sub continue { &{ $form->{nextsub} } }
+require "bin/mozilla/common.pl";
+
+sub continue { call_sub($main::form->{"nextsub"}); }
sub export {
- $lxdebug->enter_sub();
-
- $form->{title} = $locale->text("DATEX - Export Assistent");
-
- DATEV->get_datev_stamm(\%myconfig, \%$form);
- $form->header;
-
- print qq|
-<body>
-
-<form method=post action=$form->{script}>
-
-
-<table width=100%>
- <tr>
- <th class=listtop>$form->{title}</th>
- </tr>
- <tr>
- <th align=left>| . $locale->text("DATEV Angaben") . qq|</th>
- </tr>
- <tr height="5"></tr>
- <tr valign=top>
- <td>
- <table>
- <tr>
- <td align=left nowrap>| . $locale->text("Beraternummer") . qq|</td>
- <td><input name=beraternr size=10 maxlength=7 value="$form->{beraternr}"></td>
-
- <td align=left nowrap>| . $locale->text("DFV-Kennzeichen") . qq|</td>
- <td><input name=dfvkz size=5 maxlength=2 value="$form->{dfvkz}"></td>
- </tr>
- <tr>
- <td align=left nowrap>| . $locale->text("Beratername") . qq|</td>
- <td><input name=beratername size=10 maxlength=9 value="$form->{beratername}"></td>
-
- <td align=left nowrap>| . $locale->text("Password") . qq|</td>
- <td><input name=passwort size=5 maxlength=4 value="$form->{passwort}"></td>
- </tr>
- <tr>
- <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><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>
- <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>
- <td></td>
-
- <td><input name=exporttype type=radio class=radio value=1> |
- . $locale->text("Export Stammdaten")
- . qq|</td>
- <td></td>
- </td>
- </table>
- </td>
- </tr>
- <tr>
- <td><hr size=3 noshade></td>
- </tr>
-</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|">
-</form>
-
-</body>
-</html>
-|;
- $lxdebug->leave_sub();
+ $::lxdebug->enter_sub;
+ $::auth->assert('datev_export');
+
+ my $stamm = SL::DATEV->new->get_datev_stamm;
+
+ setup_datev_export_action_bar();
+
+ $::form->header;
+ print $::form->parse_html_template('datev/export', $stamm);
+
+ $::lxdebug->leave_sub;
}
sub export2 {
- $lxdebug->enter_sub();
+ $::lxdebug->enter_sub;
+ $::auth->assert('datev_export');
- if ($form->{exporttype} == 0) {
- &export_bewegungsdaten();
- } else {
- &export_stammdaten();
- }
- $lxdebug->leave_sub();
+ export_bewegungsdaten();
+
+ $::lxdebug->leave_sub;
}
sub export_bewegungsdaten {
- $lxdebug->enter_sub();
-
- $form->{title} = $locale->text("DATEX - Export Assistent");
-
- $form->{allemonate} =
- qq|<option value=1>|
- . $locale->text('January')
- . qq|</option>
- <option value=2>|
- . $locale->text('February')
- . qq|</option>
- <option value=3>|
- . $locale->text('March')
- . qq|</option>
- <option value=4>|
- . $locale->text('April')
- . qq|</option>
- <option value=5>|
- . $locale->text('May')
- . qq|</option>
- <option value=6>|
- . $locale->text('June')
- . qq|</option>
- <option value=7>|
- . $locale->text('July')
- . qq|</option>
- <option value=8>|
- . $locale->text('August')
- . qq|</option>
- <option value=9>|
- . $locale->text('September')
- . qq|</option>
- <option value=10>|
- . $locale->text('October')
- . qq|</option>
- <option value=11>|
- . $locale->text('November')
- . qq|</option>
- <option value=12>|
- . $locale->text('December')
- . qq|</option>|;
-
- $form->{allequartale} =
- qq|<option selected value=1>|
- . $locale->text('I')
- . qq|</option>
- <option value=2>| . $locale->text('II') . qq|</option>
- <option value=3>|
- . $locale->text('III')
- . qq|</option>
- <option value=4>|
- . $locale->text('IV')
- . qq|</option>|;
- $form->header;
-
- print qq|
-<body>
-
-<form method=post action=$form->{script}>
-
-
-<table width=100%>
- <tr>
- <th class=listtop>$form->{title}</th>
- </tr>
- <tr>
- <th align=left>| . $locale->text("Zeitraum") . qq|</th>
- </tr>
- <tr height="5"></tr>
- <tr valign=top>
- <td>
- <table>
- <tr>
- <td align=left><input checked name=zeitraum class=radio type=radio value=monat> </td><td align=left>|
- . $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>
- <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>
- <td align=left>| . $locale->text('bis') . qq|</td>
- <td align=left><input name=transdateto size=8></td>
- </tr>
- </table>
- </td>
- </tr>
- <tr>
- <td><hr size=3 noshade></td>
- </tr>
-</table>
-
-<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=passwort value="$form->{passwort}">
-<input type=hidden name=mandantennr value="$form->{mandantennr}">
-<input type=hidden name=datentraegernr value="$form->{datentraegernr}">
-<input type=hidden name=kne value="$form->{kne}">
-<input type=hidden name=abrechnungsnr value="$form->{abrechnungsnr}">
-
-<input type=hidden name=exporttype value="$form->{exporttype}">
-
-<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|">
-</form>
-
-</body>
-</html>
-|;
-
- $lxdebug->leave_sub();
-}
+ $::lxdebug->enter_sub;
+ $::auth->assert('datev_export');
+
+ setup_datev_export2_action_bar();
+
+ $::form->header;
+ $::form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all_sorted;
+ $::form->{show_pk_option} = SL::DATEV->new->check_vcnumbers_are_valid_pk_numbers;
+
+ # check if we have mismatching number length domains
+ SL::DATEV->new->check_valid_length_of_accounts;
-sub export_stammdaten {
- $lxdebug->enter_sub();
-
- $form->{title} = $locale->text("DATEX - Export Assistent");
-
- $form->header;
-
- print qq|
-<body>
-
-<form method=post action=$form->{script}>
-<table width=100%>
- <tr>
- <th class=listtop>$form->{title}</th>
- </tr>
- <tr>
- <th align=left>| . $locale->text("Konten") . qq|</th>
- </tr>
- <tr height="5"></tr>
- <tr valign=top>
- <td>
- <table>
- <tr>
- <td align=left>| . $locale->text('Von Konto: ') . qq|</td>
- <td align=left><input name=accnofrom size=8 maxlength=8></td>
- </tr>
- <tr>
- <td align=left>| . $locale->text('Bis Konto: ') . qq|</td>
- <td align=left><input name=accnoto size=8 maxlength=8></td>
- </tr>
- </table>
- </td>
- </tr>
- <tr>
- <td><hr size=3 noshade></td>
- </tr>
-</table>
-<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=passwort value="$form->{passwort}">
-<input type=hidden name=mandantennr value="$form->{mandantennr}">
-<input type=hidden name=datentraegernr value="$form->{datentraegernr}">
-<input type=hidden name=kne value="$form->{kne}">
-<input type=hidden name=abrechnungsnr value="$form->{abrechnungsnr}">
-
-<input type=hidden name=exporttype value="$form->{exporttype}">
-
-<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|">
-</form>
-
-</body>
-</html>
-|;
-
- $lxdebug->leave_sub();
+ print $::form->parse_html_template('datev/export_bewegungsdaten');
+
+ $::lxdebug->leave_sub;
}
sub export3 {
- $lxdebug->enter_sub();
+ $::lxdebug->enter_sub;
+ $::auth->assert('datev_export');
- DATEV->save_datev_stamm(\%myconfig, \%$form);
+ my %data = (
+ exporttype => $::form->{exporttype} ? DATEV_ET_STAMM : DATEV_ET_BUCHUNGEN,
+ format => $::form->{exportformat} eq 'kne' ? DATEV_FORMAT_KNE : DATEV_FORMAT_CSV,
+ );
- if ($form->{kne}) {
- if (DATEV->kne_export(\%myconfig, \%$form)) {
- $form->redirect($locale->text('KNE Export erfolgreich!'));
- }
+ @data{qw(from to)} = _get_dates(
+ $::form->{zeitraum}, $::form->{monat}, $::form->{quartal},
+ $::form->{transdatefrom}, $::form->{transdateto},
+ );
+ $data{use_pk} = $::form->{use_pk};
+ $data{locked} = $::form->{locked};
+ $data{imported} = $::form->{imported};
+
+ my $datev = SL::DATEV->new(%data);
+
+ $datev->clean_temporary_directories;
+ $datev->save_datev_stamm($::form);
+
+ $datev->export;
+
+ if (!$datev->errors) {
+ setup_datev_export3_action_bar(download_token => $datev->download_token);
+
+ $::form->header;
+ print $::form->parse_html_template('datev/export3', { WARNINGS => $datev->warnings });
} else {
- if (DATEV->obe_export(\%myconfig, \%$form)) {
- $form->redirect($locale->text('OBE Export erfolgreich!'));
+ $::form->error("Export schlug fehl.\n" . join "\n", $datev->errors);
+ }
+
+ $::lxdebug->leave_sub;
+}
+
+sub download {
+ $main::lxdebug->enter_sub();
+
+ my $form = $main::form;
+ my $locale = $main::locale;
+
+ $::auth->assert('datev_export');
+
+ my $tmp_name = Common->tmpname();
+ my $zip_name = strftime("kivitendo-datev-export-%Y%m%d.zip", localtime(time()));
+
+ my $cwd = getcwd();
+
+ my $datev = SL::DATEV->new(download_token => $form->{download_token});
+
+ my $path = $datev->export_path;
+ if (!$path) {
+ $form->error($locale->text("Your download does not exist anymore. Please re-run the DATEV export assistant."));
+ }
+
+ chdir($path) || die("chdir $path");
+
+ my @filenames = glob "*";
+
+ if (!@filenames) {
+ chdir($cwd);
+ $form->error($locale->text("Your download does not exist anymore. Please re-run the DATEV export assistant."));
+ }
+
+ my $zip = Archive::Zip->new();
+ map { $zip->addFile($_); } @filenames;
+ $zip->writeToFileNamed($tmp_name);
+
+ chdir($cwd);
+
+ open(IN, $tmp_name) || die("open $tmp_name");
+ $::locale->with_raw_io(\*STDOUT, sub {
+ print("Content-Type: application/zip\n");
+ print("Content-Disposition: attachment; filename=\"${zip_name}\"\n\n");
+ while (<IN>) {
+ print($_);
}
+ });
+ close(IN);
+
+ unlink($tmp_name);
+
+ $main::lxdebug->leave_sub();
+}
+
+sub _get_dates {
+ $::lxdebug->enter_sub;
+
+ my ($mode, $month, $quarter, $transdatefrom, $transdateto) = @_;
+ my ($fromdate, $todate);
+
+ if ($mode eq "monat") {
+ $fromdate = DateTime->new(day => 1, month => $month, year => DateTime->today->year);
+ # december export is usually in january/february
+ $fromdate = $fromdate->subtract(years => 1) if ($month == 12);
+
+ $todate = $fromdate->clone->add(months => 1)->add(days => -1);
+ } elsif ($mode eq "quartal") {
+ die 'quarter out of of bounds' if $quarter < 1 || $quarter > 4;
+ $fromdate = DateTime->new(day => 1, month => (3 * $quarter - 2), year => DateTime->today->year);
+ $todate = $fromdate->clone->add(months => 3)->add(days => -1);
+ } elsif ($mode eq "zeit") {
+ $fromdate = DateTime->from_lxoffice($transdatefrom);
+ $todate = DateTime->from_lxoffice($transdateto);
+ die 'need from and to time' unless $fromdate && $todate;
+ } else {
+ die 'undefined interval mode';
+ }
+
+ $::lxdebug->leave_sub;
+
+ return ($fromdate, $todate);
+}
+
+sub setup_datev_export_action_bar {
+ my %params = @_;
+
+ for my $bar ($::request->layout->get('actionbar')) {
+ $bar->add(
+ action => [
+ t8('Continue'),
+ submit => [ '#form', { action => 'export2' } ],
+ accesskey => 'enter',
+ ],
+ );
+ }
+}
+
+sub setup_datev_export2_action_bar {
+ my %params = @_;
+
+ for my $bar ($::request->layout->get('actionbar')) {
+ $bar->add(
+ action => [
+ t8('Export'),
+ submit => [ '#form', { action => 'export3' } ],
+ accesskey => 'enter',
+ ],
+ action => [
+ t8('Back'),
+ call => [ 'kivi.history_back' ],
+ ],
+ );
+ }
+}
+
+sub setup_datev_export3_action_bar {
+ my %params = @_;
+
+ for my $bar ($::request->layout->get('actionbar')) {
+ $bar->add(
+ link => [
+ t8('Download'),
+ link => [ 'datev.pl?action=download&download_token=' . $::form->escape($params{download_token}) ],
+ ],
+ action => [
+ t8('Back'),
+ call => [ 'kivi.history_back' ],
+ ],
+ );
}
- $lxdebug->leave_sub();
}
projects / kivitendo-erp.git / blobdiff