kivitendo/bin/mozilla/cp.pl @ 4a03aa4d
| d319704a | Moritz Bunkus | #=====================================================================
|
||
# LX-Office ERP
|
||||
# Copyright (C) 2004
|
||||
# Based on SQL-Ledger Version 2.1.9
|
||||
# Web http://www.lx-office.org
|
||||
#
|
||||
#=====================================================================
|
||||
# SQL-Ledger Accounting
|
||||
# Copyright (c) 2002
|
||||
#
|
||||
# Author: Dieter Simader
|
||||
# Email: dsimader@sql-ledger.org
|
||||
# Web: http://www.sql-ledger.org
|
||||
#
|
||||
#
|
||||
# This program is free software; you can redistribute it and/or modify
|
||||
# it under the terms of the GNU General Public License as published by
|
||||
# the Free Software Foundation; either version 2 of the License, or
|
||||
# (at your option) any later version.
|
||||
#
|
||||
# This program is distributed in the hope that it will be useful,
|
||||
# but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||||
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||||
# 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
|
||||
| f7b15d43 | Christian Wittmer | # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
|
||
# MA 02110-1335, USA.
|
||||
| d319704a | Moritz Bunkus | #======================================================================
|
||
#
|
||||
# Payment module
|
||||
#
|
||||
#======================================================================
|
||||
use SL::CP;
|
||||
use SL::IS;
|
||||
use SL::IR;
|
||||
| 52609551 | Jan Büren | use SL::AR;
|
||
use SL::AP;
|
||||
| cd98d068 | Niclas Zimmermann | use Data::Dumper;
|
||
| 07ccbf8d | Sven Schöling | use strict;
|
||
| 4d86fbb2 | Sven Schöling | #use warnings;
|
||
| 40782548 | Moritz Bunkus | require "bin/mozilla/common.pl";
|
||
| d319704a | Moritz Bunkus | |||
| 8c7e4493 | Moritz Bunkus | our ($form, %myconfig, $lxdebug, $locale, $auth);
|
||
| 4d86fbb2 | Sven Schöling | |||
| d319704a | Moritz Bunkus | 1;
|
||
# end of main
|
||||
sub payment {
|
||||
$lxdebug->enter_sub();
|
||||
| 6354fe29 | Jan Büren | |||
| 8c7e4493 | Moritz Bunkus | $auth->assert('cash');
|
||
| 4d86fbb2 | Sven Schöling | my (@curr);
|
||
| d319704a | Moritz Bunkus | $form->{ARAP} = ($form->{type} eq 'receipt') ? "AR" : "AP";
|
||
$form->{arap} = lc $form->{ARAP};
|
||||
CP->paymentaccounts(\%myconfig, \%$form);
|
||||
| 6354fe29 | Jan Büren | |||
| 0e0ff150 | Jan Büren | # Standard Konto für Umlaufvermögen
|
||
my $accno_arap = IS->get_standard_accno_current_assets(\%myconfig, \%$form);
|
||||
| f7f03503 | Sven Schöling | # Entsprechend präventiv die Auswahlliste für Kontonummer
|
||
| 6c27e6e4 | Jan Büren | # auch mit value= zusammenbauen (s.a. oben bugfix 1771)
|
||
# Wichtig: Auch das Template anpassen, damit hidden input korrekt die "
|
||||
# escaped.
|
||||
| d319704a | Moritz Bunkus | $form->{selectaccount} = "";
|
||
$form->{"select$form->{ARAP}"} = "";
|
||||
| 6c27e6e4 | Jan Büren | map { $form->{selectaccount} .= "<option value=\"$_->{accno}--$_->{description}\">$_->{accno}--$_->{description}</option>\n";
|
||
| 0e0ff150 | Jan Büren | $form->{account} = "$_->{accno}--$_->{description}" if ($_->{accno} eq $accno_arap) } @{ $form->{PR}{"$form->{ARAP}_paid"} };
|
||
| d319704a | Moritz Bunkus | # currencies
|
||
| 5769da0e | Jan Büren | # oldcurrency ist zwar noch hier als fragment enthalten, wird aber bei
|
||
# der aktualisierung der form auch nicht mitübernommen. das konzept
|
||||
# old_$FOO habe ich auch noch nicht verstanden ...
|
||||
# Ok. Wenn currency übernommen werden, dann in callback-string über-
|
||||
# geben und hier reinparsen, oder besser multibox oder html auslagern?
|
||||
| ce19982e | Jan Büren | # Antwort: form->currency wird mit oldcurrency oder curr[0] überschrieben
|
||
# Wofür macht das Sinn?
|
||||
| d331a3d7 | Niclas Zimmermann | @curr = $form->get_all_currencies();
|
||
| d319704a | Moritz Bunkus | $form->{defaultcurrency} = $form->{currency} = $form->{oldcurrency} =
|
||
| d331a3d7 | Niclas Zimmermann | $form->get_default_currency(\%myconfig);
|
||
| d319704a | Moritz Bunkus | |||
| f7f03503 | Sven Schöling | # Entsprechend präventiv die Auswahlliste für Währungen
|
||
| 6c27e6e4 | Jan Büren | # auch mit value= zusammenbauen (s.a. oben bugfix 1771)
|
||
| d319704a | Moritz Bunkus | $form->{selectcurrency} = "";
|
||
| 6c27e6e4 | Jan Büren | map { $form->{selectcurrency} .= "<option value=\"$_\">$_</option>\n" } @curr;
|
||
| d319704a | Moritz Bunkus | |||
&form_header;
|
||||
&form_footer;
|
||||
$lxdebug->leave_sub();
|
||||
}
|
||||
sub form_header {
|
||||
| 07ccbf8d | Sven Schöling | $lxdebug->enter_sub;
|
||
| d319704a | Moritz Bunkus | |||
| 8c7e4493 | Moritz Bunkus | $auth->assert('cash');
|
||
| 02b31f92 | Moritz Bunkus | $::request->layout->add_javascripts("autocomplete_customer.js");
|
||
my ($arap, $exchangerate);
|
||||
| d319704a | Moritz Bunkus | |||
| 02b31f92 | Moritz Bunkus | if (!$form->{ $form->{vc} . '_id' }) {
|
||
| d319704a | Moritz Bunkus | map { $form->{"addr$_"} = "" } (1 .. 4);
|
||
}
|
||||
| cd98d068 | Niclas Zimmermann | |||
| 6c27e6e4 | Jan Büren | # bugfix 1771
|
||
# geändert von <option>asdf--2929
|
||||
# nach:
|
||||
# <option value="asdf--2929">asdf--2929</option>
|
||||
# offen: $form->{ARAP} kann raus?
|
||||
| 02b31f92 | Moritz Bunkus | for my $item ("account", "currency", $form->{ARAP}) {
|
||
| 80525533 | Waldemar Toews | $form->{$item} = H($form->{$item});
|
||
| d319704a | Moritz Bunkus | $form->{"select$item"} =~ s/ selected//;
|
||
| 6c27e6e4 | Jan Büren | $form->{"select$item"} =~ s/option value="\Q$form->{$item}\E">\Q$form->{$item}\E/option selected value="$form->{$item}">$form->{$item}/;
|
||
| d319704a | Moritz Bunkus | }
|
||
| 02b31f92 | Moritz Bunkus | $form->{openinvoices} = 1;
|
||
| d319704a | Moritz Bunkus | |||
# $locale->text('AR')
|
||||
# $locale->text('AP')
|
||||
$form->header;
|
||||
$arap = lc $form->{ARAP};
|
||||
| 26456e6e | Moritz Bunkus | |||
| 07ccbf8d | Sven Schöling | print $::form->parse_html_template('cp/form_header', {
|
||
is_customer => $form->{vc} eq 'customer',
|
||||
is_receipt => $form->{type} eq 'receipt',
|
||||
arap => $arap,
|
||||
});
|
||||
$lxdebug->leave_sub;
|
||||
| d319704a | Moritz Bunkus | }
|
||
sub list_invoices {
|
||||
| 07ccbf8d | Sven Schöling | $::lxdebug->enter_sub;
|
||
$::auth->assert('cash');
|
||||
my @columns = qw(amount due paid invnumber id transdate checked);
|
||||
my (@invoices, %total);
|
||||
for my $i (1 .. $::form->{rowcount}) {
|
||||
push @invoices, +{ map { $_ => $::form->{"$_\_$i"} } @columns };
|
||||
$total{$_} += $invoices[-1]{$_} = $::form->parse_amount(\%::myconfig, $invoices[-1]{$_}) for qw(amount due paid);
|
||||
| d319704a | Moritz Bunkus | }
|
||
| 07ccbf8d | Sven Schöling | print $::form->parse_html_template('cp/invoices', {
|
||
invoices => \@invoices,
|
||||
totals => \%total,
|
||||
});
|
||||
| d319704a | Moritz Bunkus | |||
| 07ccbf8d | Sven Schöling | $::lxdebug->leave_sub;
|
||
| d319704a | Moritz Bunkus | }
|
||
sub form_footer {
|
||||
| 07ccbf8d | Sven Schöling | $::lxdebug->enter_sub;
|
||
$::auth->assert('cash');
|
||||
| d319704a | Moritz Bunkus | |||
| 07ccbf8d | Sven Schöling | print $::form->parse_html_template('cp/form_footer');
|
||
| d319704a | Moritz Bunkus | |||
| 07ccbf8d | Sven Schöling | $::lxdebug->leave_sub;
|
||
| d319704a | Moritz Bunkus | }
|
||
sub update {
|
||||
$lxdebug->enter_sub();
|
||||
| 8c7e4493 | Moritz Bunkus | $auth->assert('cash');
|
||
| 02b31f92 | Moritz Bunkus | my ($buysell, $updated, $exchangerate, $amount);
|
||
| 4d86fbb2 | Sven Schöling | |||
| d319704a | Moritz Bunkus | if ($form->{vc} eq 'customer') {
|
||
$buysell = "buy";
|
||||
} else {
|
||||
$buysell = "sell";
|
||||
}
|
||||
| f7f03503 | Sven Schöling | # search by invoicenumber,
|
||
if ($form->{invnumber}) {
|
||||
| cd98d068 | Niclas Zimmermann | $form->{open} ='Y'; # only open invoices
|
||
| 004ecc3f | Geoffrey Richardson | if ($form->{ARAP} eq 'AR'){
|
||
# ar_transactions automatically searches by $form->{customer_id} or else
|
||||
# $form->{customer} if available, and these variables will always be set
|
||||
| cd98d068 | Niclas Zimmermann | # so we have to empty these values first
|
||
| 004ecc3f | Geoffrey Richardson | $form->{customer_id} = '';
|
||
$form->{customer} = '';
|
||||
AR->ar_transactions(\%myconfig, \%$form);
|
||||
# if you search for invoice '11' ar_transactions will also match invoices
|
||||
# 112, 211, ... due to the LIKE
|
||||
# so there is now an extra loop that tries to match the invoice number
|
||||
# exactly among all returned results, and then passes the customer_id instead of the name
|
||||
# because the name may not be unique
|
||||
my $found_exact_invnumber_match = 0;
|
||||
foreach my $i ( @{ $form->{AR} } ) {
|
||||
next unless $i->{invnumber} eq $form->{invnumber};
|
||||
# found exactly matching invnumber
|
||||
$form->{customer_id} = $i->{customer_id};
|
||||
$found_exact_invnumber_match = 1;
|
||||
};
|
||||
unless ( $found_exact_invnumber_match ) {
|
||||
# use first returned entry, may not be the correct one if invnumber doesn't
|
||||
# match uniquely
|
||||
$form->{customer_id} = $form->{AR}[0]{customer_id};
|
||||
};
|
||||
} else {
|
||||
# s.o. nur für zahlungsausgang
|
||||
AP->ap_transactions(\%myconfig, \%$form);
|
||||
| 02b31f92 | Moritz Bunkus | $form->{vendor_id} = $form->{AP}[0]{vendor_id};
|
||
| 52609551 | Jan Büren | }
|
||
}
|
||||
| 5f0c4f2d | Geoffrey Richardson | |||
| 004ecc3f | Geoffrey Richardson | # determine customer/vendor
|
||
| 02b31f92 | Moritz Bunkus | my $vc = $form->{vc};
|
||
if (($form->{"previous_${vc}_id"} || $form->{"${vc}_id"}) != $form->{"${vc}_id"}) {
|
||||
| 5f0c4f2d | Geoffrey Richardson | IS->get_customer(\%myconfig, \%$form);
|
||
| b13baada | Jan Büren | }
|
||
| d319704a | Moritz Bunkus | |||
| 02b31f92 | Moritz Bunkus | $form->{oldcurrency} = $form->{currency};
|
||
# get open invoices from ar/ap using a.${vc}_id, i.e. customer_id
|
||||
CP->get_openinvoices(\%myconfig, \%$form) if $form->{"${vc}_id"};
|
||||
| d319704a | Moritz Bunkus | |||
| 3b9aee06 | Niclas Zimmermann | if (!$form->{forex}) { # read exchangerate from input field (not hidden)
|
||
$form->{exchangerate} = $form->parse_amount(\%myconfig, $form->{exchangerate});
|
||||
}
|
||||
| a53233e5 | Sven Schöling | $form->{forex} = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{datepaid}, $buysell);
|
||
$form->{exchangerate} = $form->{forex} if $form->{forex};
|
||||
| d319704a | Moritz Bunkus | |||
$amount = $form->{amount} = $form->parse_amount(\%myconfig, $form->{amount});
|
||||
| 02b31f92 | Moritz Bunkus | if ($form->{"${vc}_id"}) {
|
||
| d319704a | Moritz Bunkus | $form->{rowcount} = 0;
|
||
$form->{queued} = "";
|
||||
| 4d86fbb2 | Sven Schöling | my $i = 0;
|
||
foreach my $ref (@{ $form->{PR} }) {
|
||||
| d319704a | Moritz Bunkus | $i++;
|
||
$form->{"id_$i"} = $ref->{id};
|
||||
$form->{"invnumber_$i"} = $ref->{invnumber};
|
||||
$form->{"transdate_$i"} = $ref->{transdate};
|
||||
$ref->{exchangerate} = 1 unless $ref->{exchangerate};
|
||||
$form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate};
|
||||
$form->{"due_$i"} =
|
||||
($ref->{amount} - $ref->{paid}) / $ref->{exchangerate};
|
||||
$form->{"checked_$i"} = "";
|
||||
$form->{"paid_$i"} = "";
|
||||
# need to format
|
||||
map {
|
||||
$form->{"${_}_$i"} =
|
||||
$form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
|
||||
} qw(amount due);
|
||||
}
|
||||
$form->{rowcount} = $i;
|
||||
}
|
||||
# recalculate
|
||||
| bb99760f | Moritz Bunkus | |||
# Modified from $amount = $form->{amount} by J.Zach to update amount to total
|
||||
# payment amount in Zahlungsausgang
|
||||
$amount = 0;
|
||||
| 4d86fbb2 | Sven Schöling | for my $i (1 .. $form->{rowcount}) {
|
||
| d319704a | Moritz Bunkus | |||
map {
|
||||
| 081a4f97 | Moritz Bunkus | $form->{"${_}_$i"} =
|
||
$form->parse_amount(\%myconfig, $form->{"${_}_$i"})
|
||||
| d319704a | Moritz Bunkus | } qw(amount due paid);
|
||
if ($form->{"checked_$i"}) {
|
||||
# calculate paid_$i
|
||||
if (!$form->{"paid_$i"}) {
|
||||
$form->{"paid_$i"} = $form->{"due_$i"};
|
||||
}
|
||||
| bb99760f | Moritz Bunkus | # Modified by J.Zach, see abovev
|
||
| 2165adf6 | Sven Schöling | $amount += $form->{"paid_$i"};
|
||
| bb99760f | Moritz Bunkus | |||
| d319704a | Moritz Bunkus | } else {
|
||
$form->{"paid_$i"} = "";
|
||||
}
|
||||
map {
|
||||
$form->{"${_}_$i"} =
|
||||
$form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
|
||||
} qw(amount due paid);
|
||||
}
|
||||
| bb99760f | Moritz Bunkus | # Line added by J.Zach, see above
|
||
| 2165adf6 | Sven Schöling | $form->{amount}=$amount;
|
||
| bb99760f | Moritz Bunkus | |||
| d319704a | Moritz Bunkus | &form_header;
|
||
| 02b31f92 | Moritz Bunkus | list_invoices() if $form->{"${vc}_id"};
|
||
| d319704a | Moritz Bunkus | &form_footer;
|
||
$lxdebug->leave_sub();
|
||||
}
|
||||
sub post {
|
||||
$lxdebug->enter_sub();
|
||||
| 8c7e4493 | Moritz Bunkus | $auth->assert('cash');
|
||
| d319704a | Moritz Bunkus | &check_form;
|
||
if ($form->{currency} ne $form->{defaultcurrency}) {
|
||||
$form->error($locale->text('Exchangerate missing!'))
|
||||
unless $form->{exchangerate};
|
||||
}
|
||||
| 5769da0e | Jan Büren | # Beim Aktualisieren wird das Konto übernommen
|
||
| 1885c630 | Jan Büren | # und jetzt auch Beleg und Datum
|
||
| 07ccbf8d | Sven Schöling | $form->{callback} = "cp.pl?action=payment&vc=$form->{vc}&type=$form->{type}&account=$form->{account}&$form->{currency}" .
|
||
| 1885c630 | Jan Büren | "&datepaid=$form->{datepaid}&source=$form->{source}";
|
||
| 545d8542 | Jan Büren | |||
| 07ccbf8d | Sven Schöling | my $msg1 = $::form->{type} eq 'receipt' ? $::locale->text("Receipt posted!") : $::locale->text("Payment posted!");
|
||
my $msg2 = $::form->{type} eq 'receipt' ? $::locale->text("Cannot post Receipt!") : $::locale->text("Cannot post Payment!");
|
||||
| d319704a | Moritz Bunkus | |||
| 5769da0e | Jan Büren | # Die Nachrichten (Receipt posted!) werden nicht angezeigt.
|
||
# Entweder wieder aktivieren oder komplett rausnehmen
|
||||
| 07ccbf8d | Sven Schöling | $form->redirect($msg1) if (CP->process_payment(\%::myconfig, $::form));
|
||
$form->error($msg2);
|
||||
| d319704a | Moritz Bunkus | |||
$lxdebug->leave_sub();
|
||||
}
|
||||
sub check_form {
|
||||
$lxdebug->enter_sub();
|
||||
| 8c7e4493 | Moritz Bunkus | $auth->assert('cash');
|
||
| 4d86fbb2 | Sven Schöling | my ($closedto, $datepaid, $amount);
|
||
| 02b31f92 | Moritz Bunkus | my $vc = $form->{vc};
|
||
if (($form->{"previous_${vc}_id"} || $form->{"${vc}_id"}) != $form->{"${vc}_id"}) {
|
||||
IS->get_customer(\%myconfig, $form) if $vc eq 'customer';
|
||||
IR->get_vendor(\%myconfig, $form) if $vc eq 'vendor';
|
||||
}
|
||||
| d319704a | Moritz Bunkus | |||
if ($form->{currency} ne $form->{oldcurrency}) {
|
||||
&update;
|
||||
| 09479f02 | Moritz Bunkus | $::dispatcher->end_request;
|
||
| d319704a | Moritz Bunkus | }
|
||
$form->error($locale->text('Date missing!')) unless $form->{datepaid};
|
||||
| 07ccbf8d | Sven Schöling | my $selected_check = 1;
|
||
| f147b6eb | Jan Büren | for my $i (1 .. $form->{rowcount}) {
|
||
| e21a1c12 | Moritz Bunkus | next unless $form->{"checked_$i"};
|
||
if (abs($form->parse_amount(\%myconfig, $form->{"paid_$i"}, 2)) < 0.01) {
|
||||
$form->error($locale->text('Row #1: amount has to be different from zero.', $i));
|
||||
| f147b6eb | Jan Büren | }
|
||
| e21a1c12 | Moritz Bunkus | undef $selected_check;
|
||
| f147b6eb | Jan Büren | }
|
||
$form->error($locale->text('No transaction selected!')) if $selected_check;
|
||||
| d319704a | Moritz Bunkus | |||
$closedto = $form->datetonum($form->{closedto}, \%myconfig);
|
||||
$datepaid = $form->datetonum($form->{datepaid}, \%myconfig);
|
||||
$form->error($locale->text('Cannot process payment for a closed period!'))
|
||||
| 57eb1337 | Philip Reetz | if ($form->date_closed($form->{"datepaid"}, \%myconfig));
|
||
| d319704a | Moritz Bunkus | |||
$amount = $form->parse_amount(\%myconfig, $form->{amount});
|
||||
$form->{amount} = $amount;
|
||||
| 4d86fbb2 | Sven Schöling | for my $i (1 .. $form->{rowcount}) {
|
||
| 04a2f2e7 | Moritz Bunkus | if ($form->parse_amount(\%myconfig, $form->{"paid_$i"})) {
|
||
| 4d86fbb2 | Sven Schöling | $amount -= $form->parse_amount(\%myconfig, $form->{"paid_$i"});
|
||
| d319704a | Moritz Bunkus | |||
| c87ba417 | Sven Schöling | push(@{ $form->{paid} ||= [] }, $form->{"paid_$i"});
|
||
push(@{ $form->{due} ||= [] }, $form->{"due_$i"});
|
||||
push(@{ $form->{invnumber} ||= [] }, $form->{"invnumber_$i"});
|
||||
push(@{ $form->{invdate} ||= [] }, $form->{"transdate_$i"});
|
||||
| d319704a | Moritz Bunkus | }
|
||
}
|
||||
if ($form->round_amount($amount, 2) != 0) {
|
||||
push(@{ $form->{paid} }, $form->format_amount(\%myconfig, $amount, 2));
|
||||
push(@{ $form->{due} }, $form->format_amount(\%myconfig, 0, "0"));
|
||||
push(@{ $form->{invnumber} },
|
||||
($form->{ARAP} eq 'AR')
|
||||
? $locale->text('Deposit')
|
||||
: $locale->text('Prepayment'));
|
||||
push(@{ $form->{invdate} }, $form->{datepaid});
|
||||
}
|
||||
$lxdebug->leave_sub();
|
||||
}
|