X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fgl.pl;h=0a2ab4c7ac62885b304ff28efde8851a0ed8cabb;hb=919007c2bfb65ec08728d3f647446465860bb7f9;hp=253b97ee4de6acd3fed910cb92cc0c28e9936e9c;hpb=ee4b3441e94a1e1481ec84554987ed1b079eb52e;p=kivitendo-erp.git diff --git a/bin/mozilla/gl.pl b/bin/mozilla/gl.pl index 253b97ee4..0a2ab4c7a 100644 --- a/bin/mozilla/gl.pl +++ b/bin/mozilla/gl.pl @@ -31,11 +31,17 @@ # #====================================================================== +use POSIX qw(strftime); +use List::Util qw(sum); + +use SL::FU; use SL::GL; +use SL::IS; use SL::PE; +use SL::ReportGenerator; -require "$form->{path}/arap.pl"; require "bin/mozilla/common.pl"; +require "bin/mozilla/reportgenerator.pl"; 1; @@ -72,11 +78,11 @@ require "bin/mozilla/common.pl"; sub add { $lxdebug->enter_sub(); + $auth->assert('general_ledger'); + $form->{title} = "Add"; - $form->{callback} = - "$form->{script}?action=add&path=$form->{path}&login=$form->{login}&password=$form->{password}" - unless $form->{callback}; + $form->{callback} = "gl.pl?action=add" unless $form->{callback}; # we use this only to set a default date GL->transaction(\%myconfig, \%$form); @@ -104,14 +110,18 @@ sub add { } (@{ $form->{all_departments} }); } + $form->{show_details} = $myconfig{show_form_details} unless defined $form->{show_details}; + &display_form(1); $lxdebug->leave_sub(); } -sub edit { +sub prepare_transaction { $lxdebug->enter_sub(); + $auth->assert('general_ledger'); + GL->transaction(\%myconfig, \%$form); map { @@ -178,19 +188,34 @@ sub edit { ($form->datetonum($form->{transdate}, \%myconfig) <= $form->datetonum($form->{closedto}, \%myconfig)); + $lxdebug->leave_sub(); +} + +sub edit { + $lxdebug->enter_sub(); + + $auth->assert('general_ledger'); + + prepare_transaction(); + $form->{title} = "Edit"; - &form_header; - &display_rows; - &form_footer; - $lxdebug->leave_sub(); + $form->{show_details} = $myconfig{show_form_details} unless defined $form->{show_details}; + form_header(); + display_rows(); + form_footer(); + + $lxdebug->leave_sub(); } + sub search { $lxdebug->enter_sub(); - $form->{title} = $locale->text('Buchungsjournal'); + $auth->assert('general_ledger'); + + $form->{title} = $locale->text('Journal'); $form->all_departments(\%myconfig); @@ -227,18 +252,18 @@ sub search { '-labels' => \%project_labels)); # use JavaScript Calendar or not - $form->{jsscript} = $jscalendar; + $form->{jsscript} = 1; $jsscript = ""; if ($form->{jsscript}) { # with JavaScript Calendar $button1 = qq| - + text('button') . qq|> |; $button2 = qq| - + text('button') . qq|> |; @@ -251,17 +276,19 @@ sub search { # without JavaScript Calendar $button1 = - qq||; + qq||; $button2 = - qq||; + qq||; } - + $form->{javascript} .= qq||; $form->header; - + $onload = qq|focus()|; + $onload .= qq|;setupDateFormat('|. $myconfig{dateformat} .qq|', '|. $locale->text("Falsches Datumsformat!") .qq|')|; + $onload .= qq|;setupPoints('|. $myconfig{numberformat} .qq|', '|. $locale->text("wrongformat") .qq|')|; print qq| - + -
{script}> + @@ -339,8 +366,6 @@ sub search { | . $locale->text('Source') . qq| | . $locale->text('Account') . qq| - - | . $locale->text('GIFI') . qq| @@ -364,10 +389,6 @@ $jsscript -{path}> -{login}> -{password}> -
@@ -379,566 +400,253 @@ $jsscript $lxdebug->leave_sub(); } -sub generate_report { +sub create_subtotal_row { $lxdebug->enter_sub(); - $form->{sort} = "transdate" unless $form->{sort}; + my ($totals, $columns, $column_alignment, $subtotal_columns, $class) = @_; - GL->all_transactions(\%myconfig, \%$form); + my $row = { map { $_ => { 'data' => '', 'class' => $class, 'align' => $column_alignment->{$_}, } } @{ $columns } }; + + map { $row->{$_}->{data} = $form->format_amount(\%myconfig, $totals->{$_}, 2) } @{ $subtotal_columns }; + + map { $totals->{$_} = 0 } @{ $subtotal_columns }; + + $lxdebug->leave_sub(); + + return $row; +} - $callback = - "$form->{script}?action=generate_report&path=$form->{path}&login=$form->{login}&password=$form->{password}"; +sub generate_report { + $lxdebug->enter_sub(); - $href = $callback; + $auth->assert('general_ledger'); - %acctype = ('A' => $locale->text('Asset'), - 'C' => $locale->text('Contra'), - 'L' => $locale->text('Liability'), - 'Q' => $locale->text('Equity'), - 'I' => $locale->text('Revenue'), - 'E' => $locale->text('Expense'),); + $form->{sort} ||= "transdate"; - $form->{title} = $locale->text('General Ledger'); + GL->all_transactions(\%myconfig, \%$form); - $ml = ($form->{ml} =~ /(A|E|Q)/) ? -1 : 1; + my %acctype = ('A' => $locale->text('Asset'), + 'C' => $locale->text('Contra'), + 'L' => $locale->text('Liability'), + 'Q' => $locale->text('Equity'), + 'I' => $locale->text('Revenue'), + 'E' => $locale->text('Expense'),); - unless ($form->{category} eq 'X') { + $form->{title} = $locale->text('Journal'); + if ($form->{category} ne 'X') { $form->{title} .= " : " . $locale->text($acctype{ $form->{category} }); } + + $form->{landscape} = 1; + + my $ml = ($form->{ml} =~ /(A|E|Q)/) ? -1 : 1; + + my @columns = qw( + transdate id reference description + notes source debit debit_accno + credit credit_accno debit_tax debit_tax_accno + credit_tax credit_tax_accno projectnumbers balance + ); + + my @hidden_variables = qw(accno source reference department description notes project_id datefrom dateto category l_subtotal); + push @hidden_variables, map { "l_${_}" } @columns; + + my (@options, $date_option); if ($form->{accno}) { - $href .= "&accno=" . $form->escape($form->{accno}); - $callback .= "&accno=" . $form->escape($form->{accno}, 1); - $option = - $locale->text('Account') - . " : $form->{accno} $form->{account_description}"; - } - if ($form->{gifi_accno}) { - $href .= "&gifi_accno=" . $form->escape($form->{gifi_accno}); - $callback .= "&gifi_accno=" . $form->escape($form->{gifi_accno}, 1); - $option .= "\n
" if $option; - $option .= - $locale->text('GIFI') - . " : $form->{gifi_accno} $form->{gifi_account_description}"; + push @options, $locale->text('Account') . " : $form->{accno} $form->{account_description}"; } if ($form->{source}) { - $href .= "&source=" . $form->escape($form->{source}); - $callback .= "&source=" . $form->escape($form->{source}, 1); - $option .= "\n
" if $option; - $option .= $locale->text('Source') . " : $form->{source}"; + push @options, $locale->text('Source') . " : $form->{source}"; } if ($form->{reference}) { - $href .= "&reference=" . $form->escape($form->{reference}); - $callback .= "&reference=" . $form->escape($form->{reference}, 1); - $option .= "\n
" if $option; - $option .= $locale->text('Reference') . " : $form->{reference}"; + push @options, $locale->text('Reference') . " : $form->{reference}"; } if ($form->{department}) { - $href .= "&department=" . $form->escape($form->{department}); - $callback .= "&department=" . $form->escape($form->{department}, 1); - ($department) = split /--/, $form->{department}; - $option .= "\n
" if $option; - $option .= $locale->text('Department') . " : $department"; + my ($department) = split /--/, $form->{department}; + push @options, $locale->text('Department') . " : $department"; } - if ($form->{description}) { - $href .= "&description=" . $form->escape($form->{description}); - $callback .= "&description=" . $form->escape($form->{description}, 1); - $option .= "\n
" if $option; - $option .= $locale->text('Description') . " : $form->{description}"; + push @options, $locale->text('Description') . " : $form->{description}"; } if ($form->{notes}) { - $href .= "¬es=" . $form->escape($form->{notes}); - $callback .= "¬es=" . $form->escape($form->{notes}, 1); - $option .= "\n
" if $option; - $option .= $locale->text('Notes') . " : $form->{notes}"; + push @options, $locale->text('Notes') . " : $form->{notes}"; } - if ($form->{project_id}) { - $href .= "&project_id=" . $form->escape($form->{project_id}); - $callback .= "&project_id=" . $form->escape($form->{project_id}); - } - if ($form->{datefrom}) { - $href .= "&datefrom=$form->{datefrom}"; - $callback .= "&datefrom=$form->{datefrom}"; - $option .= "\n
" if $option; - $option .= - $locale->text('From') . " " - . $locale->date(\%myconfig, $form->{datefrom}, 1); + $date_option = $locale->text('From') . " " . $locale->date(\%myconfig, $form->{datefrom}, 1); } if ($form->{dateto}) { - $href .= "&dateto=$form->{dateto}"; - $callback .= "&dateto=$form->{dateto}"; if ($form->{datefrom}) { - $option .= " "; - } else { - $option .= "\n
" if $option; + $date_option .= " "; } - $option .= - $locale->text('Bis') . " " - . $locale->date(\%myconfig, $form->{dateto}, 1); + $date_option .= $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{dateto}, 1); } - - @columns = $form->sort_columns( qw( - transdate id reference description - notes source debit debit_accno - credit credit_accno debit_tax debit_tax_accno - credit_tax credit_tax_accno accno gifi_accno - projectnumbers - ) + push @options, $date_option if $date_option; + + my $callback = build_std_url('action=generate_report', @hidden_variables); + + $form->{l_credit_accno} = 'Y'; + $form->{l_debit_accno} = 'Y'; + $form->{l_credit_tax} = 'Y'; + $form->{l_debit_tax} = 'Y'; + $form->{l_credit_tax_accno} = 'Y'; + $form->{l_debit_tax_accno} = 'Y'; + $form->{l_balance} = $form->{accno} ? 'Y' : ''; + + my %column_defs = ( + 'id' => { 'text' => $locale->text('ID'), }, + 'transdate' => { 'text' => $locale->text('Date'), }, + 'reference' => { 'text' => $locale->text('Reference'), }, + 'source' => { 'text' => $locale->text('Source'), }, + 'description' => { 'text' => $locale->text('Description'), }, + 'notes' => { 'text' => $locale->text('Notes'), }, + 'debit' => { 'text' => $locale->text('Debit'), }, + 'debit_accno' => { 'text' => $locale->text('Debit Account'), }, + 'credit' => { 'text' => $locale->text('Credit'), }, + 'credit_accno' => { 'text' => $locale->text('Credit Account'), }, + 'debit_tax' => { 'text' => $locale->text('Debit Tax'), }, + 'debit_tax_accno' => { 'text' => $locale->text('Debit Tax Account'), }, + 'credit_tax' => { 'text' => $locale->text('Credit Tax'), }, + 'credit_tax_accno' => { 'text' => $locale->text('Credit Tax Account'), }, + 'balance' => { 'text' => $locale->text('Balance'), }, + 'projectnumbers' => { 'text' => $locale->text('Project Numbers'), }, ); - if ($form->{accno} || $form->{gifi_accno}) { - @columns = grep !/(accno|gifi_accno)/, @columns; - push @columns, "balance"; - $form->{l_balance} = "Y"; - - } - - $form->{l_credit_accno} = "Y"; - $form->{l_debit_accno} = "Y"; - $form->{l_credit_tax} = "Y"; - $form->{l_debit_tax} = "Y"; - $form->{l_credit_tax_accno} = "Y"; - $form->{l_debit_tax_accno} = "Y"; - $form->{l_accno} = "N"; - foreach $item (@columns) { - if ($form->{"l_$item"} eq "Y") { - push @column_index, $item; - - # add column to href and callback - $callback .= "&l_$item=Y"; - $href .= "&l_$item=Y"; - } - } - - if ($form->{l_subtotal} eq 'Y') { - $callback .= "&l_subtotal=Y"; - $href .= "&l_subtotal=Y"; - } - - $callback .= "&category=$form->{category}"; - $href .= "&category=$form->{category}"; - - $column_header{id} = - "" - . $locale->text('ID') - . ""; - $column_header{transdate} = - "" - . $locale->text('Date') - . ""; - $column_header{reference} = - "" - . $locale->text('Reference') - . ""; - $column_header{source} = - "" - . $locale->text('Source') - . ""; - $column_header{description} = - "" - . $locale->text('Description') - . ""; - $column_header{notes} = - "" . $locale->text('Notes') . ""; - $column_header{debit} = - "" . $locale->text('Debit') . ""; - $column_header{debit_accno} = - "" - . $locale->text('Debit Account') - . ""; - $column_header{credit} = - "" . $locale->text('Credit') . ""; - $column_header{credit_accno} = - "" - . $locale->text('Credit Account') - . ""; - $column_header{debit_tax} = - "" - . $locale->text('Debit Tax') - . ""; - $column_header{debit_tax_accno} = - "" - . $locale->text('Debit Tax Account') - . ""; - $column_header{credit_tax} = - "" - . $locale->text('Credit Tax') - . ""; - $column_header{credit_tax_accno} = - "" - . $locale->text('Credit Tax Account') - . ""; - $column_header{gifi_accno} = - "" - . $locale->text('GIFI') - . ""; - $column_header{balance} = "" . $locale->text('Balance') . ""; - $column_header{projectnumbers} = - "" . $locale->text('Project Numbers') . ""; + map { $column_defs{$_}->{link} = $callback . "&sort=${_}" } qw(id transdate reference source description); + map { $column_defs{$_}->{link} = $callback . "&sort=accno" } qw(debit_accno credit_accno debit_tax_accno credit_tax_accno debit_tax credit_tax); + map { $column_defs{$_}->{visible} = $form->{"l_${_}"} ? 1 : 0 } @columns; + map { $column_defs{$_}->{visible} = 0 } qw(debit_accno credit_accno debit_tax_accno credit_tax_accno) if $form->{accno}; - $form->{landscape} = 1; + my %column_alignment; + map { $column_alignment{$_} = 'right' } qw(balance id debit credit debit_tax credit_tax); + map { $column_alignment{$_} = 'center' } qw(transdate reference description source notes debit_accno credit_accno debit_tax_accno credit_tax_accno); - $form->header; + my $report = SL::ReportGenerator->new(\%myconfig, $form); - print qq| - + $report->set_columns(%column_defs); + $report->set_column_order(@columns); - - - - - - - - - - - - - - -
$form->{title}
$option
- - - -|; + $report->set_export_options('generate_report', @hidden_variables); - map { print "$column_header{$_}\n" } @column_index; + $report->set_sort_indicator($form->{sort}, 1); - print " - - - - -"; + $report->set_options('top_info_text' => join("\n", @options), + 'output_format' => 'HTML', + 'title' => $form->{title}, + 'attachment_basename' => $locale->text('general_ledger_list') . strftime('_%Y%m%d', localtime time), + ); + $report->set_options_from_form(); # add sort to callback - $form->{callback} = "$callback&sort=$form->{sort}"; - $callback = $form->escape($form->{callback}); + $form->{callback} = "$callback&sort=" . E($form->{sort}); - # initial item for subtotals - if (@{ $form->{GL} }) { - $sameitem = $form->{GL}->[0]->{ $form->{sort} }; - } + $form->{balance} *= $ml; - if (($form->{accno} || $form->{gifi_accno}) && $form->{balance}) { + if ($form->{accno} && $form->{balance}) { + my $row = { + 'balance' => { + 'data' => $form->format_amount(\%myconfig, $form->{balance}, 2), + 'align' => 'right', + }, + }; - map { $column_data{$_} = "" } @column_index; - $column_data{balance} = - ""; + $report->add_data($row); + } - $i++; - $i %= 2; - print qq| - -|; - map { print "$column_data{$_}\n" } @column_index; + my @totals_columns = qw(debit credit debit_tax credit_tax); + my %subtotals = map { $_ => 0 } @totals_columns; + my %totals = map { $_ => 0 } @totals_columns; + my $idx = 0; - print qq| - -|; - } - $form->{balance} *= $ml; foreach $ref (@{ $form->{GL} }) { $form->{balance} *= $ml; - # if item ne sort print subtotal - if ($form->{l_subtotal} eq 'Y') { - if ($sameitem ne $ref->{ $form->{sort} }) { - &gl_subtotal; - } - } - - #foreach $key (sort keys(%{ $ref->{amount} })) { - # $form->{balance} += $ref->{amount}{$key}; - #} - - $debit = ""; - foreach $key (sort keys(%{ $ref->{debit} })) { - $subtotaldebit += $ref->{debit}{$key}; - $totaldebit += $ref->{debit}{$key}; - if ($key == 0) { - $debit = $form->format_amount(\%myconfig, $ref->{debit}{$key}, 2, 0); - } else { - $debit .= - "
" . $form->format_amount(\%myconfig, $ref->{debit}{$key}, 2, 0); - } - $form->{balance} = abs($form->{balance}) - abs($ref->{debit}{$key}); - } + my %rows; - $credit = ""; - foreach $key (sort keys(%{ $ref->{credit} })) { - $subtotalcredit += $ref->{credit}{$key}; - $totalcredit += $ref->{credit}{$key}; - if ($key == 0) { - $credit = $form->format_amount(\%myconfig, $ref->{credit}{$key}, 2, 0); - } else { - $credit .= "
" - . $form->format_amount(\%myconfig, $ref->{credit}{$key}, 2, 0); + foreach my $key (qw(debit credit debit_tax credit_tax)) { + $rows{$key} = []; + foreach my $idx (sort keys(%{ $ref->{$key} })) { + my $value = $ref->{$key}->{$idx}; + $subtotals{$key} += $value; + $totals{$key} += $value; + $form->{balance} = abs($form->{balance}) - abs($value); + push @{ $rows{$key} }, $form->format_amount(\%myconfig, $value, 2); } - $form->{balance} = abs($form->{balance}) - abs($ref->{credit}{$key}); } - $debittax = ""; - foreach $key (sort keys(%{ $ref->{debit_tax} })) { - $subtotaldebittax += $ref->{debit_tax}{$key}; - $totaldebittax += $ref->{debit_tax}{$key}; - if ($key == 0) { - $debittax = - $form->format_amount(\%myconfig, $ref->{debit_tax}{$key}, 2, 0); - } else { - $debittax .= "
" - . $form->format_amount(\%myconfig, $ref->{debit_tax}{$key}, 2, 0); - } - $form->{balance} = abs($form->{balance}) - abs($ref->{debit_tax}{$key}); + foreach my $key (qw(debit_accno credit_accno debit_tax_accno credit_tax_accno ac_transdate)) { + my $col = $key eq 'ac_transdate' ? 'transdate' : $key; + $rows{$col} = [ map { $ref->{$key}->{$_} } sort keys(%{ $ref->{$key} }) ]; } - $credittax = ""; - foreach $key (sort keys(%{ $ref->{credit_tax} })) { - $subtotalcredittax += $ref->{credit_tax}{$key}; - $totalcredittax += $ref->{credit_tax}{$key}; - if ($key == 0) { - $credittax = - $form->format_amount(\%myconfig, $ref->{credit_tax}{$key}, 2, 0); - } else { - $credittax .= "
" - . $form->format_amount(\%myconfig, $ref->{credit_tax}{$key}, 2, 0); - } - $form->{balance} = abs($form->{balance}) - abs($ref->{credit_tax}{$key}); - } + my $row = { }; + map { $row->{$_} = { 'data' => '', 'align' => $column_alignment{$_} } } @columns; - $debitaccno = ""; - $debittaxkey = ""; - $taxaccno = ""; - foreach $key (sort keys(%{ $ref->{debit_accno} })) { - if ($key == 0) { - $debitaccno = - "{debit_accno}{$key}&callback=$callback>$ref->{debit_accno}{$key}"; - } else { - $debitaccno .= - "
{debit_accno}{$key}&callback=$callback>$ref->{debit_accno}{$key}"; - } + $row->{balance}->{data} = $form->format_amount(\%myconfig, $form->{balance}, 2); + $row->{projectnumbers}->{data} = join ", ", sort { lc($a) cmp lc($b) } keys %{ $ref->{projectnumbers} }; - # if ($ref->{debit_taxkey}{$key} eq $debittaxkey) { - # $ref->{debit_tax_accno}{$key} = $taxaccno; - # } - $taxaccno = $ref->{debit_tax_accno}{$key}; - $debittaxkey = $ref->{debit_taxkey}{$key}; - } + map { $row->{$_}->{data} = $ref->{$_} } qw(id reference description source notes); - $creditaccno = ""; - $credittaxkey = ""; - $taxaccno = ""; - foreach $key (sort keys(%{ $ref->{credit_accno} })) { - if ($key == 0) { - $creditaccno = - "{credit_accno}{$key}&callback=$callback>$ref->{credit_accno}{$key}"; - } else { - $creditaccno .= - "
{credit_accno}{$key}&callback=$callback>$ref->{credit_accno}{$key}"; - } + map { $row->{$_}->{data} = \@{ $rows{$_} }; } qw(transdate debit credit debit_accno credit_accno debit_tax_accno credit_tax_accno); - # if ($ref->{credit_taxkey}{$key} eq $credittaxkey) { - # $ref->{credit_tax_accno}{$key} = $taxaccno; - # } - $taxaccno = $ref->{credit_tax_accno}{$key}; - $credittaxkey = $ref->{credit_taxkey}{$key}; + foreach my $col (qw(debit_accno credit_accno debit_tax_accno credit_tax_accno)) { + $row->{$col}->{link} = [ map { "${callback}&accno=" . E($_) } @{ $rows{$col} } ]; } - $debittaxaccno = ""; - foreach $key (sort keys(%{ $ref->{debit_tax_accno} })) { - if ($key == 0) { - $debittaxaccno = - "{debit_tax_accno}{$key}&callback=$callback>$ref->{debit_tax_accno}{$key}"; - } else { - $debittaxaccno .= - "
{debit_tax_accno}{$key}&callback=$callback>$ref->{debit_tax_accno}{$key}"; - } - } + map { $row->{$_}->{data} = \@{ $rows{$_} } if ($ref->{"${_}_accno"} ne "") } qw(debit_tax credit_tax); - $credittaxaccno = ""; - foreach $key (sort keys(%{ $ref->{credit_tax_accno} })) { - if ($key == 0) { - $credittaxaccno = - "{credit_tax_accno}{$key}&callback=$callback>$ref->{credit_tax_accno}{$key}"; - } else { - $credittaxaccno .= - "
{credit_tax_accno}{$key}&callback=$callback>$ref->{credit_tax_accno}{$key}"; - } - } + $row->{reference}->{link} = build_std_url("script=$ref->{module}.pl", 'action=edit', 'id=' . E($ref->{id}), 'callback'); - $transdate = ""; - foreach $key (sort keys(%{ $ref->{transdate} })) { - if ($key == 0) { - $transdate = "$ref->{transdate}{$key}"; - } else { - $transdate .= "
$ref->{transdate}{$key}"; - } + my $row_set = [ $row ]; + + if (($form->{l_subtotal} eq 'Y') + && (($idx == (scalar @{ $form->{GL} } - 1)) + || ($ref->{ $form->{sort} } ne $form->{GL}->[$idx + 1]->{ $form->{sort} }))) { + push @{ $row_set }, create_subtotal_row(\%subtotals, \@columns, \%column_alignment, [ qw(debit credit) ], 'listsubtotal'); } - # $ref->{debit} = $form->format_amount(\%myconfig, $ref->{debit}, 2, " "); - # $ref->{credit} = $form->format_amount(\%myconfig, $ref->{credit}, 2, " "); - - $column_data{id} = ""; - $column_data{transdate} = ""; - $column_data{reference} = - ""; - $column_data{description} = ""; - $column_data{source} = ""; - $column_data{notes} = ""; - $column_data{debit} = ""; - $column_data{debit_accno} = ""; - $column_data{credit} = ""; - $column_data{credit_accno} = ""; - $column_data{debit_tax} = - ($ref->{debit_tax_accno} ne "") - ? "" - : ""; - $column_data{debit_tax_accno} = ""; - $column_data{gifi_accno} = - ""; - $column_data{credit_tax} = - ($ref->{credit_tax_accno} ne "") - ? "" - : ""; - $column_data{credit_tax_accno} = ""; - $column_data{gifi_accno} = - ""; - $column_data{balance} = - ""; - $column_data{projectnumbers} = - ""; - - $i++; - $i %= 2; - print " - "; - map { print "$column_data{$_}\n" } @column_index; - print ""; + $report->add_data($row_set); + $idx++; } - &gl_subtotal if ($form->{l_subtotal} eq 'Y'); - - map { $column_data{$_} = "" } @column_index; - - my $balanced_ledger = $totaldebit - + $totaldebittax - - $totalcredit - - $totalcredittax; - # = 0 for balanced ledger - - $column_data{debit} = - ""; - $column_data{credit} = - ""; - $column_data{debit_tax} = - ""; - $column_data{credit_tax} = - ""; - $column_data{balance} = - ""; + $report->add_separator(); - print qq| - -|; - - map { print "$column_data{$_}\n" } @column_index; - - print qq| - - |; - - - if ( abs($balanced_ledger) > 0.001 ) { + # = 0 for balanced ledger + my $balanced_ledger = $totals{debit} + $totals{debit_tax} - $totals{credit} - $totals{credit_tax}; - print qq| - - -
 " - . $form->format_amount(\%myconfig, $form->{balance} * $ml, 2, 0) - . "
 $ref->{id} $transdate{module}.pl?action=edit&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{reference}$ref->{description} $ref->{source} $ref->{notes} $debit$debitaccno$credit$creditaccno$debittax$debittaxaccno{gifi_accno}&callback=$callback>$ref->{gifi_accno} $credittax$credittaxaccno{gifi_accno}&callback=$callback>$ref->{gifi_accno} " - . $form->format_amount(\%myconfig, $form->{balance}, 2, 0) . "" . join(", ", sort({ lc($a) cmp lc($b) } keys(%{ $ref->{projectnumbers} }))) . "
 " - . $form->format_amount(\%myconfig, $totaldebit, 2, " ") . "" - . $form->format_amount(\%myconfig, $totalcredit, 2, " ") . "" - . $form->format_amount(\%myconfig, $totaldebittax, 2, " ") . "" - . $form->format_amount(\%myconfig, $totalcredittax, 2, " ") . "" - . $form->format_amount(\%myconfig, $form->{balance} * $ml, 2, 0) . "
| - . $locale->text('Unbalanced Ledger') - . ": " - . $form->format_amount(\%myconfig, $balanced_ledger, 3, " ") - - } elsif ( abs($balanced_ledger) <= 0.001 ) { + my $row = create_subtotal_row(\%totals, \@columns, \%column_alignment, [ qw(debit credit debit_tax credit_tax) ], 'listtotal'); + $row->{balance} = { + 'data' => $form->format_amount(\%myconfig, $form->{balance} * $ml, 2), + 'align' => 'right', + 'class' => 'listtotal', + }; + $report->add_data($row); - print qq|| - . $locale->text('Balanced Ledger') + my $raw_bottom_info_text; + if (!$form->{accno} && (abs($balanced_ledger) > 0.001)) { + $raw_bottom_info_text .= + '

' + . $locale->text('Unbalanced Ledger') + . ': ' + . $form->format_amount(\%myconfig, $balanced_ledger, 3) + . '

'; } - - print qq| -
-

- -
- -{script}> - - - -{path}> -{login}> -{password}> - - - - - - - -
- - - -|; - $lxdebug->leave_sub(); - -} - -sub gl_subtotal { - $lxdebug->enter_sub(); - - $subtotaldebit = - $form->format_amount(\%myconfig, $subtotaldebit, 2, " "); - $subtotalcredit = - $form->format_amount(\%myconfig, $subtotalcredit, 2, " "); - - map { $column_data{$_} = " " } - qw(transdate id reference source description accno); - $column_data{debit} = "$subtotaldebit"; - $column_data{credit} = "$subtotalcredit"; + $raw_bottom_info_text .= $form->parse_html_template('gl/generate_report_bottom'); - print ""; - map { print "$column_data{$_}\n" } @column_index; - print ""; + $report->set_options('raw_bottom_info_text' => $raw_bottom_info_text); - $subtotaldebit = 0; - $subtotalcredit = 0; + $report->generate_with_headers(); - $sameitem = $ref->{ $form->{sort} }; $lxdebug->leave_sub(); - } sub update { $lxdebug->enter_sub(); + $auth->assert('general_ledger'); + $form->{oldtransdate} = $form->{transdate}; my @a = (); @@ -1045,6 +753,8 @@ sub display_form { my ($init) = @_; $lxdebug->enter_sub(); + $auth->assert('general_ledger'); + &form_header($init); # for $i (1 .. $form->{rowcount}) { @@ -1063,6 +773,9 @@ sub display_rows { my ($init) = @_; $lxdebug->enter_sub(); + $auth->assert('general_ledger'); + + $form->{debit_1} = 0 if !$form->{"debit_1"}; $form->{totaldebit} = 0; $form->{totalcredit} = 0; @@ -1127,7 +840,6 @@ sub display_rows { if ($previous_accno && ($previous_accno eq $selected_accno) && ($previous_tax_id ne $selected_tax_id)) { - $lxdebug->message(0, "yeah"); my $item = $taxcharts{$selected_tax_id}; $selected_taxchart = "$item->{id}--$item->{rate}"; } @@ -1157,7 +869,7 @@ sub display_rows { if ($init) { $korrektur = - qq||; + qq||; if ($form->{transfer}) { $fx_transaction = qq| @@ -1223,20 +935,27 @@ sub display_rows { '-labels' => \%project_labels, '-default' => $form->{"project_id_$i"} )); + my $copy2credit = 'onkeyup="copy_debit_to_credit()"' if $i == 1; + print qq| $accno $fx_transaction - + $korrektur - $tax + $tax|; + + if ($form->{show_details}) { + print qq| $source $memo $projectnumber +|; + } + print qq| - - |; +|; } $form->hide_form(qw(rowcount selectaccno)); @@ -1248,15 +967,21 @@ sub display_rows { sub form_header { my ($init) = @_; $lxdebug->enter_sub(); + + $auth->assert('general_ledger'); + $title = $form->{title}; $form->{title} = $locale->text("$title General Ledger Transaction"); $readonly = ($form->{id}) ? "readonly" : ""; + $show_details_checked = "checked" if $form->{show_details}; + # $locale->text('Add General Ledger Transaction') # $locale->text('Edit General Ledger Transaction') map { $form->{$_} =~ s/\"/"/g } qw(reference description chart taxchart); + $form->{javascript} = qq||; + $form->{javascript} .= qq||; $form->{selectdepartment} =~ s/ selected//; $form->{selectdepartment} =~ @@ -1309,13 +1041,13 @@ sub form_header { } # use JavaScript Calendar or not - $form->{jsscript} = $jscalendar; + $form->{jsscript} = 1; $jsscript = ""; if ($form->{jsscript}) { # with JavaScript Calendar $button1 = qq| - + text('button') . qq|> |; @@ -1327,22 +1059,32 @@ sub form_header { # without JavaScript Calendar $button1 = - qq||; + qq||; } + $form->{previous_id} ||= "--"; + $form->{previous_gldate} ||= "--"; + $form->header; print qq| -
{script}> + + -{id}> + +|; + + $form->hide_form(qw(id closedto locked storno storno_id previous_id previous_gldate)); -{closedto}> -{locked}> + print qq| + + + + @@ -1352,8 +1094,16 @@ sub form_header {
+ + + - + @@ -1384,7 +1134,7 @@ sub form_header { if ($form->{id}) { print qq| - + @@ -1418,6 +1168,12 @@ sub form_header { |; } + + print qq| + + + |; + print qq| - + . $locale->text('Taxkey') . qq||; + + if ($form->{show_details}) { + print qq| + - + +|; + } + + print qq| $jsscript @@ -1450,14 +1211,26 @@ $jsscript sub form_footer { $lxdebug->enter_sub(); + + $auth->assert('general_ledger'); + + my $follow_ups_block; + if ($form->{id}) { + my $follow_ups = FU->follow_ups('trans_id' => $form->{id}); + + if (@{ $follow_ups} ) { + my $num_due = sum map { $_->{due} * 1 } @{ $follow_ups }; + $follow_ups_block = qq|

| . $locale->text("There are #1 unfinished follow-ups of which #2 are due.", scalar @{ $follow_ups }, $num_due) . qq|

|; + } + } + ($dec) = ($form->{totaldebit} =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; $radieren = ($form->current_date(\%myconfig) eq $form->{gldate}) ? 1 : 0; map { - $form->{$_} = - $form->format_amount(\%myconfig, $form->{$_}, 2, " ") + $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}, 2, " ") } qw(totaldebit totalcredit); print qq| @@ -1472,12 +1245,10 @@ sub form_footer {
| + . $locale->text("Previous transnumber text") + . " $form->{previous_id} " + . $locale->text("Previous transdate text") + . " $form->{previous_gldate}" + . qq|
| . $locale->text('Reference') . qq|| . $locale->text('Reference') . qq| @@ -1373,7 +1123,7 @@ sub form_header {
- +
| . $locale->text('Buchungsdatum') . qq|{gldate} $readonly>{gldate} $readonly onBlur=\"check_right_date_format(this)\">
| . $locale->text('Description') . qq|| . $locale->text('Description') . qq| $description @@ -1398,7 +1148,7 @@ sub form_header {
- +
| . $locale->text('Mitarbeiter') . qq|{employee} $readonly>
| . $locale->text('Show details') . qq|
@@ -1434,12 +1190,17 @@ sub form_header { | . $locale->text('Korrektur') . qq| | - . $locale->text('Taxkey') . qq|| - . $locale->text('Source') . qq|| . $locale->text('Source') . qq| | . $locale->text('Memo') . qq|| - . $locale->text('Project Number') . qq|| . $locale->text('Project Number') . qq|
-{path}> -{login}> -{password}> - +$follow_ups_block +
|; @@ -1486,29 +1257,27 @@ sub form_footer { if ($form->{id}) { - print qq||; + if (!$form->{storno}) { + print qq||; + } # Löschen und Ändern von Buchungen nicht mehr möglich (GoB) nur am selben Tag möglich - if (!$form->{locked} && $radieren) { print qq| - - |; + + |; } - # if ($transdate > $closedto) { - # print qq| - # |; - # } + print qq| + |; + } else { if ($transdate > $closedto) { - print qq| - |; + print qq| + + |; } } @@ -1530,7 +1299,7 @@ sub delete { print qq| -{script}> + |; map { $form->{$_} =~ s/\"/"/g } qw(reference description); @@ -1538,6 +1307,7 @@ sub delete { delete $form->{header}; foreach $key (keys %$form) { + next if (($key eq 'login') || ($key eq 'password') || ('' ne ref $form->{$key})); print qq|\n|; } @@ -1561,6 +1331,7 @@ sub yes { if (GL->delete_transaction(\%myconfig, \%$form)){ # saving the history if(!exists $form->{addition} && $form->{id} ne "") { + $form->{snumbers} = qq|ordnumber_| . $form->{ordnumber}; $form->{addition} = "DELETED"; $form->save_history($form->dbconnect(\%myconfig)); } @@ -1572,7 +1343,7 @@ sub yes { } -sub post { +sub post_transaction { $lxdebug->enter_sub(); # check if there is something in reference and date @@ -1592,104 +1363,87 @@ sub post { $creditlock = 0; $debitlock = 0; - my @flds = - qw(accno debit credit projectnumber fx_transaction source memo tax taxchart); - if ($form->{storno}) { - for my $i (1 .. $form->{rowcount}) { - unless (($form->{"debit_$i"} eq "") && ($form->{"credit_$i"} eq "")) { - if ($form->{"debit_$i"} ne "") { - $form->{"credit_$i"} = $form->{"debit_$i"}; - $form->{"debit_$i"} = ""; - } elsif ($form->{"credit_$i"} ne "") { - $form->{"debit_$i"} = $form->{"credit_$i"}; - $form->{"credit_$i"} = ""; - } - } - } - } + my @flds = qw(accno debit credit projectnumber fx_transaction source memo tax taxchart); for my $i (1 .. $form->{rowcount}) { + next if $form->{"debit_$i"} eq "" && $form->{"credit_$i"} eq ""; - unless (($form->{"debit_$i"} eq "") && ($form->{"credit_$i"} eq "")) { - for (qw(debit credit tax)) { - $form->{"${_}_$i"} = - $form->parse_amount(\%myconfig, $form->{"${_}_$i"}); - } + for (qw(debit credit tax)) { + $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}); + } - push @a, {}; - $debitcredit = ($form->{"debit_$i"} == 0) ? "0" : "1"; + push @a, {}; + $debitcredit = ($form->{"debit_$i"} == 0) ? "0" : "1"; - if ($debitcredit) { - $debitcount++; - } else { - $creditcount++; - } + if ($debitcredit) { + $debitcount++; + } else { + $creditcount++; + } - if (($debitcount >= 2) && ($creditcount == 2)) { - $form->{"credit_$i"} = 0; - $form->{"tax_$i"} = 0; - $creditcount--; - $creditlock = 1; - } - if (($creditcount >= 2) && ($debitcount == 2)) { - $form->{"debit_$i"} = 0; - $form->{"tax_$i"} = 0; - $debitcount--; - $debitlock = 1; - } - if (($creditcount == 1) && ($debitcount == 2)) { - $creditlock = 1; - } - if (($creditcount == 2) && ($debitcount == 1)) { - $debitlock = 1; - } - if ($debitcredit && $credittax) { - $form->{"taxchart_$i"} = "0--0.00"; - } - if (!$debitcredit && $debittax) { - $form->{"taxchart_$i"} = "0--0.00"; - } - $amount = - ($form->{"debit_$i"} == 0) - ? $form->{"credit_$i"} - : $form->{"debit_$i"}; - $j = $#a; - if (($debitcredit && $credittax) || (!$debitcredit && $debittax)) { - $form->{"taxchart_$i"} = "0--0.00"; - $form->{"tax_$i"} = 0; - } - if (!$form->{"korrektur_$i"}) { - ($taxkey, $rate) = split(/--/, $form->{"taxchart_$i"}); - if ($taxkey > 1) { + if (($debitcount >= 2) && ($creditcount == 2)) { + $form->{"credit_$i"} = 0; + $form->{"tax_$i"} = 0; + $creditcount--; + $creditlock = 1; + } + if (($creditcount >= 2) && ($debitcount == 2)) { + $form->{"debit_$i"} = 0; + $form->{"tax_$i"} = 0; + $debitcount--; + $debitlock = 1; + } + if (($creditcount == 1) && ($debitcount == 2)) { + $creditlock = 1; + } + if (($creditcount == 2) && ($debitcount == 1)) { + $debitlock = 1; + } + if ($debitcredit && $credittax) { + $form->{"taxchart_$i"} = "0--0.00"; + } + if (!$debitcredit && $debittax) { + $form->{"taxchart_$i"} = "0--0.00"; + } + $amount = ($form->{"debit_$i"} == 0) + ? $form->{"credit_$i"} + : $form->{"debit_$i"}; + $j = $#a; + if (($debitcredit && $credittax) || (!$debitcredit && $debittax)) { + $form->{"taxchart_$i"} = "0--0.00"; + $form->{"tax_$i"} = 0; + } + if (!$form->{"korrektur_$i"}) { + ($taxkey, $rate) = split(/--/, $form->{"taxchart_$i"}); + if ($taxkey > 1) { + if ($debitcredit) { + $debittax = 1; + } else { + $credittax = 1; + } + if ($form->{taxincluded}) { + $form->{"tax_$i"} = $amount / ($rate + 1) * $rate; if ($debitcredit) { - $debittax = 1; - } else { - $credittax = 1; - } - if ($form->{taxincluded}) { - $form->{"tax_$i"} = $amount / ($rate + 1) * $rate; - if ($debitcredit) { - $form->{"debit_$i"} = $form->{"debit_$i"} - $form->{"tax_$i"}; - } else { - $form->{"credit_$i"} = $form->{"credit_$i"} - $form->{"tax_$i"}; - } + $form->{"debit_$i"} = $form->{"debit_$i"} - $form->{"tax_$i"}; } else { - $form->{"tax_$i"} = $amount * $rate; + $form->{"credit_$i"} = $form->{"credit_$i"} - $form->{"tax_$i"}; } } else { - $form->{"tax_$i"} = 0; - } - } elsif ($form->{taxincluded}) { - if ($debitcredit) { - $form->{"debit_$i"} = $form->{"debit_$i"} - $form->{"tax_$i"}; - } else { - $form->{"credit_$i"} = $form->{"credit_$i"} - $form->{"tax_$i"}; + $form->{"tax_$i"} = $amount * $rate; } + } else { + $form->{"tax_$i"} = 0; + } + } elsif ($form->{taxincluded}) { + if ($debitcredit) { + $form->{"debit_$i"} = $form->{"debit_$i"} - $form->{"tax_$i"}; + } else { + $form->{"credit_$i"} = $form->{"credit_$i"} - $form->{"tax_$i"}; } - - for (@flds) { $a[$j]->{$_} = $form->{"${_}_$i"} } - $count++; } + + for (@flds) { $a[$j]->{$_} = $form->{"${_}_$i"} } + $count++; } for $i (1 .. $count) { @@ -1706,31 +1460,14 @@ sub post { $cr = $form->{"credit_$i"}; $tax = $form->{"tax_$i"}; if ($dr && $cr) { - $form->error( - $locale->text( - 'Cannot post transaction with a debit and credit entry for the same account!' - )); - } - if ($form->{taxincluded}) { - if ($dr) { - $debit += $dr + $tax; - } - if ($cr) { - $credit += $cr + $tax; - } - $taxtotal += $tax; - } else { - if ($dr) { - $debit += $dr + $tax; - } - if ($cr) { - $credit += $cr + $tax; - } + $form->error($locale->text('Cannot post transaction with a debit and credit entry for the same account!')); } + $debit += $dr + $tax if $dr; + $credit += $cr + $tax if $cr; + $taxtotal += $tax if $form->{taxincluded} } - if (!$taxtotal) { - $form->{taxincluded} = 0; - } + + $form->{taxincluded} = 0 if !$taxtotal; # this is just for the wise guys $form->error($locale->text('Cannot post transaction for a closed period!')) @@ -1754,19 +1491,37 @@ sub post { undef($form->{callback}); # saving the history if(!exists $form->{addition} && $form->{id} ne "") { - $form->{addition} = "SAVED"; - $form->{what_done} = $locale->text("Buchungsnummer") . " = " . $form->{id}; - $form->save_history($form->dbconnect(\%myconfig)); + $form->{snumbers} = qq|ordnumber_| . $form->{ordnumber}; + $form->{addition} = "SAVED"; + $form->{what_done} = $locale->text("Buchungsnummer") . " = " . $form->{id}; + $form->save_history($form->dbconnect(\%myconfig)); } # /saving the history - $form->redirect("Buchung gespeichert. Buchungsnummer = " . $form->{id}); + $lxdebug->leave_sub(); +} + +sub post { + $lxdebug->enter_sub(); + + $auth->assert('general_ledger'); + + $form->{title} = $locale->text("$form->{title} General Ledger Transaction"); + $form->{storno} = 0; + + post_transaction(); + + $form->{callback} = build_std_url("action=add", "show_details"); + $form->redirect($form->{callback}); + $lxdebug->leave_sub(); } sub post_as_new { $lxdebug->enter_sub(); + $auth->assert('general_ledger'); + $form->{id} = 0; &add; $lxdebug->leave_sub(); @@ -1776,16 +1531,29 @@ sub post_as_new { sub storno { $lxdebug->enter_sub(); - $form->{id} = 0; - $form->{storno} = 1; + $auth->assert('general_ledger'); + + # don't cancel cancelled transactions + if (IS->has_storno(\%myconfig, $form, 'gl')) { + $form->{title} = $locale->text("Cancel Accounts Receivables Transaction"); + $form->error($locale->text("Transaction has already been cancelled!")); + } + + GL->storno($form, \%myconfig, $form->{id}); + # saving the history if(!exists $form->{addition} && $form->{id} ne "") { - $form->{addition} = "STORNO"; - $form->save_history($form->dbconnect(\%myconfig)); + $form->{snumbers} = "ordnumber_$form->{ordnumber}"; + $form->{addition} = "STORNO"; + $form->save_history($form->dbconnect(\%myconfig)); } # /saving the history - &post; - $lxdebug->leave_sub(); + $form->redirect(sprintf $locale->text("Transaction %d cancelled."), $form->{storno_id}); + + $lxdebug->leave_sub(); } +sub continue { + call_sub($form->{nextsub}); +}