1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
7 #=====================================================================
8 # SQL-Ledger Accounting
11 # Author: Dieter Simader
12 # Email: dsimader@sql-ledger.org
13 # Web: http://www.sql-ledger.org
16 # This program is free software; you can redistribute it and/or modify
17 # it under the terms of the GNU General Public License as published by
18 # the Free Software Foundation; either version 2 of the License, or
19 # (at your option) any later version.
21 # This program is distributed in the hope that it will be useful,
22 # but WITHOUT ANY WARRANTY; without even the implied warranty of
23 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 # GNU General Public License for more details.
25 # You should have received a copy of the GNU General Public License
26 # along with this program; if not, write to the Free Software
27 # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
28 #======================================================================
32 #======================================================================
42 require "bin/mozilla/arap.pl";
43 require "bin/mozilla/common.pl";
45 our ($form, %myconfig, $lxdebug, $locale, $auth);
52 $lxdebug->enter_sub();
54 $auth->assert('cash');
58 $form->{ARAP} = ($form->{type} eq 'receipt') ? "AR" : "AP";
59 $form->{arap} = lc $form->{ARAP};
61 # setup customer/vendor selection for open invoices
62 if ($form->{all_vc}) {
63 # Dieser Zweig funktioniert derzeit NIE. Ggf. ganz raus oder
64 # alle offenen Zahlungen wieder korrekt anzeigen. jb 12.10.2010
65 $form->all_vc(\%myconfig, $form->{vc}, $form->{ARAP});
67 CP->get_openvc(\%myconfig, \%$form);
70 $form->{"select$form->{vc}"} = "";
72 if ($form->{"all_$form->{vc}"}) {
74 $form->{"$form->{vc}_id"} = $form->{"all_$form->{vc}"}->[0]->{id};
75 map { $form->{"select$form->{vc}"} .= "<option>$_->{name}--$_->{id}\n" }
76 @{ $form->{"all_$form->{vc}"} };
79 CP->paymentaccounts(\%myconfig, \%$form);
81 # Standard Konto für Umlaufvermögen
82 my $accno_arap = IS->get_standard_accno_current_assets(\%myconfig, \%$form);
84 $form->{selectaccount} = "";
85 $form->{"select$form->{ARAP}"} = "";
87 map { $form->{selectaccount} .= "<option>$_->{accno}--$_->{description}\n";
88 $form->{account} = "$_->{accno}--$_->{description}" if ($_->{accno} eq $accno_arap) } @{ $form->{PR}{"$form->{ARAP}_paid"} };
90 # Braucht man das hier überhaupt? Erstmal auskommentieren .. jan 18.12.2010
92 # $form->{"select$form->{ARAP}"} .=
93 # "<option>$_->{accno}--$_->{description}\n"
94 # } @{ $form->{PR}{ $form->{ARAP} } };
95 # ENDE LOESCHMICH in 2012
98 # oldcurrency ist zwar noch hier als fragment enthalten, wird aber bei
99 # der aktualisierung der form auch nicht mitübernommen. das konzept
100 # old_$FOO habe ich auch noch nicht verstanden ...
101 # Ok. Wenn currency übernommen werden, dann in callback-string über-
102 # geben und hier reinparsen, oder besser multibox oder html auslagern?
103 # Antwort: form->currency wird mit oldcurrency oder curr[0] überschrieben
104 # Wofür macht das Sinn?
105 @curr = split(/:/, $form->{currencies});
107 $form->{defaultcurrency} = $form->{currency} = $form->{oldcurrency} =
110 $form->{selectcurrency} = "";
111 map { $form->{selectcurrency} .= "<option>$_\n" } @curr;
117 $lxdebug->leave_sub();
123 $auth->assert('cash');
125 my ($vc, $arap, $exchangerate);
128 if ($form->{ $form->{vc} } eq "") {
129 map { $form->{"addr$_"} = "" } (1 .. 4);
132 for my $item ($form->{vc}, "account", "currency", $form->{ARAP}) {
133 $form->{"select$item"} =~ s/ selected//;
134 $form->{"select$item"} =~ s/option>\Q$form->{$item}\E/option selected>$form->{$item}/;
138 ($form->{"select$form->{vc}"})
139 ? qq|<select name=$form->{vc}>$form->{"select$form->{vc}"}\n</select>|
140 : qq|<input name=$form->{vc} size=35 value="$form->{$form->{vc}}">|;
142 $form->{openinvoices} = $form->{all_vc} ? "" : 1;
144 # $locale->text('AR')
145 # $locale->text('AP')
149 $arap = lc $form->{ARAP};
150 $onload = qq|focus()|;
151 $onload .= qq|;setupDateFormat('|. $myconfig{dateformat} .qq|', '|. $locale->text("Falsches Datumsformat!") .qq|')|;
152 $onload .= qq|;setupPoints('|. $myconfig{numberformat} .qq|', '|. $locale->text("wrongformat") .qq|')|;
154 print $::form->parse_html_template('cp/form_header', {
155 is_customer => $form->{vc} eq 'customer',
156 is_receipt => $form->{type} eq 'receipt',
166 $::lxdebug->enter_sub;
167 $::auth->assert('cash');
169 my @columns = qw(amount due paid invnumber id transdate checked);
170 my (@invoices, %total);
171 for my $i (1 .. $::form->{rowcount}) {
172 push @invoices, +{ map { $_ => $::form->{"$_\_$i"} } @columns };
173 $total{$_} += $invoices[-1]{$_} = $::form->parse_amount(\%::myconfig, $invoices[-1]{$_}) for qw(amount due paid);
176 print $::form->parse_html_template('cp/invoices', {
177 invoices => \@invoices,
181 $::lxdebug->leave_sub;
185 $::lxdebug->enter_sub;
186 $::auth->assert('cash');
188 print $::form->parse_html_template('cp/form_footer');
190 $::lxdebug->leave_sub;
194 $lxdebug->enter_sub();
196 $auth->assert('cash');
198 my ($new_name_selected) = @_;
200 my ($buysell, $newvc, $updated, $exchangerate, $amount);
202 if ($form->{vc} eq 'customer') {
208 # if we switched to all_vc
209 # funktioniert derzeit nicht 12.10.2010 jb
210 if ($form->{all_vc} ne $form->{oldall_vc}) {
212 $form->{openinvoices} = ($form->{all_vc}) ? 0 : 1;
214 $form->{"select$form->{vc}"} = "";
216 if ($form->{all_vc}) {
217 $form->all_vc(\%myconfig, $form->{vc}, $form->{ARAP});
219 if ($form->{"all_$form->{vc}"}) {
221 $form->{"select$form->{vc}"} .=
222 "<option>$_->{name}--$_->{id}\n"
223 } @{ $form->{"all_$form->{vc}"} };
225 } else { # ab hier wieder ausgeführter code (s.o.):
226 CP->get_openvc(\%myconfig, \%$form);
228 if ($form->{"all_$form->{vc}"}) {
230 qq|$form->{"all_$form->{vc}"}[0]->{name}--$form->{"all_$form->{vc}"}[0]->{id}|;
232 $form->{"select$form->{vc}"} .=
233 "<option>$_->{name}--$_->{id}\n"
234 } @{ $form->{"all_$form->{vc}"} };
237 # if the name is not the same
238 if ($form->{"select$form->{vc}"} !~ /$form->{$form->{vc}}/) {
239 $form->{ $form->{vc} } = $newvc;
243 # Falls Suche über Rechnungsnummer und kein Kundenname vorhanden
244 if ($form->{invnumber} && !($form->{$form->{vc}})){
245 $form->{open} ='Y'; # nur die offenen rechnungen
246 if ($form->{ARAP} eq 'AR'){
247 AR->ar_transactions(\%myconfig, \%$form);
248 # den ersten treffen nehmen und mit dem namen überschreiben
249 $form->{$form->{vc}} = $form->{AR}[0]{name};
251 # s.o. nur für zahlungsausgang
252 AP->ap_transactions(\%myconfig, \%$form);
253 $form->{$form->{vc}} = $form->{AP}[0]{name};
256 # get customer and invoices
257 $updated = &check_name($form->{vc});
259 if ($new_name_selected || $updated) {
260 CP->get_openinvoices(\%myconfig, \%$form);
261 ($newvc) = split /--/, $form->{ $form->{vc} };
262 $form->{"old$form->{vc}"} = qq|$newvc--$form->{"$form->{vc}_id"}|;
266 if ($form->{currency} ne $form->{oldcurrency}) {
267 $form->{oldcurrency} = $form->{currency};
269 CP->get_openinvoices(\%myconfig, \%$form);
274 $form->{forex} = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{datepaid}, $buysell);
275 $form->{exchangerate} = $form->{forex} if $form->{forex};
277 $amount = $form->{amount} = $form->parse_amount(\%myconfig, $form->{amount});
280 $form->{rowcount} = 0;
282 $form->{queued} = "";
285 foreach my $ref (@{ $form->{PR} }) {
287 $form->{"id_$i"} = $ref->{id};
288 $form->{"invnumber_$i"} = $ref->{invnumber};
289 $form->{"transdate_$i"} = $ref->{transdate};
290 $ref->{exchangerate} = 1 unless $ref->{exchangerate};
291 $form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate};
293 ($ref->{amount} - $ref->{paid}) / $ref->{exchangerate};
294 $form->{"checked_$i"} = "";
295 $form->{"paid_$i"} = "";
300 $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
304 $form->{rowcount} = $i;
309 # Modified from $amount = $form->{amount} by J.Zach to update amount to total
310 # payment amount in Zahlungsausgang
312 for my $i (1 .. $form->{rowcount}) {
316 $form->parse_amount(\%myconfig, $form->{"${_}_$i"})
317 } qw(amount due paid);
319 if ($form->{"checked_$i"}) {
322 if (!$form->{"paid_$i"}) {
323 $form->{"paid_$i"} = $form->{"due_$i"};
326 # Modified by J.Zach, see abovev
327 $amount += $form->{"paid_$i"};
330 $form->{"paid_$i"} = "";
335 $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
336 } qw(amount due paid);
340 # Line added by J.Zach, see above
341 $form->{amount}=$amount;
347 $lxdebug->leave_sub();
351 $lxdebug->enter_sub();
353 $auth->assert('cash');
357 if ($form->{currency} ne $form->{defaultcurrency}) {
358 $form->error($locale->text('Exchangerate missing!'))
359 unless $form->{exchangerate};
362 # Beim Aktualisieren wird das Konto übernommen
363 # und jetzt auch Beleg und Datum
364 $form->{callback} = "cp.pl?action=payment&vc=$form->{vc}&type=$form->{type}&account=$form->{account}&$form->{currency}" .
365 "&datepaid=$form->{datepaid}&source=$form->{source}";
367 my $msg1 = $::form->{type} eq 'receipt' ? $::locale->text("Receipt posted!") : $::locale->text("Payment posted!");
368 my $msg2 = $::form->{type} eq 'receipt' ? $::locale->text("Cannot post Receipt!") : $::locale->text("Cannot post Payment!");
370 # Die Nachrichten (Receipt posted!) werden nicht angezeigt.
371 # Entweder wieder aktivieren oder komplett rausnehmen
372 $form->redirect($msg1) if (CP->process_payment(\%::myconfig, $::form));
375 $lxdebug->leave_sub();
379 $lxdebug->enter_sub();
381 $auth->assert('cash');
383 my ($closedto, $datepaid, $amount);
385 &check_name($form->{vc});
387 if ($form->{currency} ne $form->{oldcurrency}) {
391 $form->error($locale->text('Date missing!')) unless $form->{datepaid};
392 my $selected_check = 1;
393 for my $i (1 .. $form->{rowcount}) {
394 if ($form->{"checked_$i"}) {
395 if ($form->parse_amount(\%myconfig, $form->{"paid_$i"}, 2) <= 0) { # negativen Betrag eingegeben
396 $form->error($locale->text('Amount has to be greater then zero! Wrong row number: ') . $i);
398 undef($selected_check);
399 # last; # ich muss doch über alle buchungen laufen, da ich noch
400 # die freitext-eingabe der werte prüfen will
403 $form->error($locale->text('No transaction selected!')) if $selected_check;
405 $closedto = $form->datetonum($form->{closedto}, \%myconfig);
406 $datepaid = $form->datetonum($form->{datepaid}, \%myconfig);
408 $form->error($locale->text('Cannot process payment for a closed period!'))
409 if ($form->date_closed($form->{"datepaid"}, \%myconfig));
411 $amount = $form->parse_amount(\%myconfig, $form->{amount});
412 $form->{amount} = $amount;
414 for my $i (1 .. $form->{rowcount}) {
415 if ($form->parse_amount(\%myconfig, $form->{"paid_$i"})) {
416 $amount -= $form->parse_amount(\%myconfig, $form->{"paid_$i"});
418 push(@{ $form->{paid} }, $form->{"paid_$i"});
419 push(@{ $form->{due} }, $form->{"due_$i"});
420 push(@{ $form->{invnumber} }, $form->{"invnumber_$i"});
421 push(@{ $form->{invdate} }, $form->{"transdate_$i"});
425 if ($form->round_amount($amount, 2) != 0) {
426 push(@{ $form->{paid} }, $form->format_amount(\%myconfig, $amount, 2));
427 push(@{ $form->{due} }, $form->format_amount(\%myconfig, 0, "0"));
428 push(@{ $form->{invnumber} },
429 ($form->{ARAP} eq 'AR')
430 ? $locale->text('Deposit')
431 : $locale->text('Prepayment'));
432 push(@{ $form->{invdate} }, $form->{datepaid});
435 $lxdebug->leave_sub();