Revision cf5fe23a
Von Sven Schöling vor mehr als 12 Jahren hinzugefügt
| bin/mozilla/ar.pl | ||
|---|---|---|
| 32 | 32 |
#====================================================================== |
| 33 | 33 |
|
| 34 | 34 |
use POSIX qw(strftime); |
| 35 |
use List::Util qw(sum first); |
|
| 35 |
use List::Util qw(sum first max);
|
|
| 36 | 36 |
|
| 37 | 37 |
use SL::AR; |
| 38 | 38 |
use SL::FU; |
| ... | ... | |
| 218 | 218 |
my $cgi = $::request->{cgi};
|
| 219 | 219 |
|
| 220 | 220 |
my ($title, $readonly, $exchangerate, $rows); |
| 221 |
my ($taxincluded, $notes, $department, $customer, $employee, $amount, $project); |
|
| 222 |
my ($jsscript, $button1, $button2, $onload); |
|
| 223 |
my ($selectAR_amount, $selectAR_paid, $ARselected, $tax); |
|
| 224 |
my (@column_index, %column_data); |
|
| 221 |
my ($notes, $department, $customer, $employee, $amount, $project); |
|
| 222 |
my ($onload); |
|
| 223 |
my ($ARselected); |
|
| 225 | 224 |
|
| 226 | 225 |
|
| 227 | 226 |
$title = $form->{title};
|
| 228 |
$form->{title} = $locale->text("$title Accounts Receivables Transaction");
|
|
| 229 |
|
|
| 230 |
$form->{taxincluded} = ($form->{taxincluded}) ? "checked" : "";
|
|
| 231 |
|
|
| 232 | 227 |
# $locale->text('Add Accounts Receivables Transaction')
|
| 233 | 228 |
# $locale->text('Edit Accounts Receivables Transaction')
|
| 229 |
$form->{title} = $locale->text("$title Accounts Receivables Transaction");
|
|
| 230 |
|
|
| 234 | 231 |
$form->{javascript} = qq|<script type="text/javascript">
|
| 235 | 232 |
<!-- |
| 236 | 233 |
function setTaxkey(accno, row) {
|
| ... | ... | |
| 253 | 250 |
# show history button js |
| 254 | 251 |
$form->{javascript} .= qq|<script type="text/javascript" src="js/show_history.js"></script>|;
|
| 255 | 252 |
#/show history button js |
| 256 |
$form->{javascript} .= qq|<script type="text/javascript" src="js/common.js"></script>|;
|
|
| 257 | 253 |
$readonly = ($form->{id}) ? "readonly" : "";
|
| 258 | 254 |
|
| 259 |
$form->{radier} =
|
|
| 260 |
($form->current_date(\%myconfig) eq $form->{gldate}) ? 1 : 0;
|
|
| 255 |
$form->{radier} = ($form->current_date(\%myconfig) eq $form->{gldate}) ? 1 : 0;
|
|
| 261 | 256 |
$readonly = ($form->{radier}) ? "" : $readonly;
|
| 262 | 257 |
|
| 263 | 258 |
# set option selected |
| 264 | 259 |
foreach my $item (qw(customer currency department employee)) {
|
| 265 | 260 |
$form->{"select$item"} =~ s/ selected//;
|
| 266 |
$form->{"select$item"} =~
|
|
| 267 |
s/option>\Q$form->{$item}\E/option selected>$form->{$item}/;
|
|
| 261 |
$form->{"select$item"} =~ s/option>\Q$form->{$item}\E/option selected>$form->{$item}/;
|
|
| 268 | 262 |
} |
| 269 | 263 |
|
| 270 | 264 |
$form->{forex} = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{transdate}, 'buy');
|
| 271 | 265 |
$form->{exchangerate} = $form->{forex} if $form->{forex};
|
| 272 | 266 |
|
| 273 |
# format amounts |
|
| 274 |
$form->{exchangerate} = $form->{exchangerate} ? $form->format_amount(\%myconfig, $form->{exchangerate}) : '';
|
|
| 275 |
$form->{creditlimit} = $form->format_amount(\%myconfig, $form->{creditlimit}, 0, "0");
|
|
| 276 |
$form->{creditremaining} = $form->format_amount(\%myconfig, $form->{creditremaining}, 0, "0");
|
|
| 277 |
|
|
| 278 |
$exchangerate = qq| |
|
| 279 |
<input type=hidden name=forex value=$form->{forex}>
|
|
| 280 |
|; |
|
| 281 |
if ($form->{defaultcurrency} && ($form->{currency} ne $form->{defaultcurrency})) {
|
|
| 282 |
if ($form->{forex}) {
|
|
| 283 |
$exchangerate .= qq| |
|
| 284 |
<th align=right>| . $locale->text('Exchangerate') . qq|</th>
|
|
| 285 |
<td><input type=hidden name=exchangerate value=$form->{exchangerate}>$form->{exchangerate}</td>
|
|
| 286 |
|; |
|
| 287 |
} else {
|
|
| 288 |
$exchangerate .= qq| |
|
| 289 |
<th align=right>| . $locale->text('Exchangerate') . qq|</th>
|
|
| 290 |
<td><input name=exchangerate size=10 value=$form->{exchangerate}></td>
|
|
| 291 |
|; |
|
| 292 |
} |
|
| 293 |
} |
|
| 294 |
|
|
| 295 |
$taxincluded = qq| |
|
| 296 |
<tr> |
|
| 297 |
<td align=right><input name=taxincluded class=checkbox type=checkbox value=1 $form->{taxincluded}></td>
|
|
| 298 |
<th align=left nowrap>| . $locale->text('Tax Included') . qq|</th>
|
|
| 299 |
</tr> |
|
| 300 |
|; |
|
| 301 |
|
|
| 302 |
if (($rows = $form->numtextrows($form->{notes}, 50)) < 2) {
|
|
| 303 |
$rows = 2; |
|
| 304 |
} |
|
| 305 |
$notes = |
|
| 306 |
qq|<textarea name=notes rows=$rows cols=50 wrap=soft>$form->{notes}</textarea>|;
|
|
| 307 |
|
|
| 308 |
$department = qq| |
|
| 309 |
<tr> |
|
| 310 |
<th align="right" nowrap>| . $locale->text('Department') . qq|</th>
|
|
| 311 |
<td colspan=3><select name=department>$form->{selectdepartment}</select>
|
|
| 312 |
<input type=hidden name=selectdepartment value="$form->{selectdepartment}">
|
|
| 313 |
</td> |
|
| 314 |
</tr> |
|
| 315 |
| if $form->{selectdepartment};
|
|
| 316 |
|
|
| 317 |
my $n = ($form->{creditremaining} =~ /-/) ? "0" : "1";
|
|
| 318 |
|
|
| 319 |
$customer = ($form->{selectcustomer})
|
|
| 320 |
? qq|<select name="customer" onchange="document.getElementById('update_button').click();">$form->{selectcustomer}</select>|
|
|
| 321 |
: qq|<input name=customer value="$form->{customer}" size=35>|;
|
|
| 322 |
|
|
| 323 |
$employee = qq| |
|
| 324 |
<input type=hidden name=employee value="$form->{employee}">
|
|
| 325 |
|; |
|
| 326 |
|
|
| 327 |
if ($form->{selectemployee}) {
|
|
| 328 |
$employee = qq| |
|
| 329 |
<tr> |
|
| 330 |
<th align=right nowrap>| . $locale->text('Salesperson') . qq|</th>
|
|
| 331 |
<td colspan=2><select name=employee>$form->{selectemployee}</select></td>
|
|
| 332 |
<input type=hidden name=selectemployee value="$form->{selectemployee}">
|
|
| 333 |
</tr> |
|
| 334 |
|; |
|
| 335 |
} |
|
| 267 |
$rows = max 2, $form->numtextrows($form->{notes}, 50);
|
|
| 336 | 268 |
|
| 337 |
my @old_project_ids = (); |
|
| 338 |
map({ push(@old_project_ids, $form->{"project_id_$_"})
|
|
| 339 |
if ($form->{"project_id_$_"}); } (1..$form->{"rowcount"}));
|
|
| 269 |
my @old_project_ids = grep { $_ } map { $form->{"project_id_$_"} } 1..$form->{rowcount};
|
|
| 340 | 270 |
|
| 341 | 271 |
$form->get_lists("projects" => { "key" => "ALL_PROJECTS",
|
| 342 | 272 |
"all" => 0, |
| ... | ... | |
| 346 | 276 |
"taxcharts" => { "key" => "ALL_TAXCHARTS",
|
| 347 | 277 |
"module" => "AR" },); |
| 348 | 278 |
|
| 349 |
map({ $_->{link_split} = [ split(/:/, $_->{link}) ]; }
|
|
| 350 |
@{ $form->{ALL_CHARTS} });
|
|
| 279 |
$_->{link_split} = { map { $_ => 1 } split/:/, $_->{link} } for @{ $form->{ALL_CHARTS} };
|
|
| 351 | 280 |
|
| 352 |
my %project_labels = (); |
|
| 353 |
my @project_values = ("");
|
|
| 354 |
foreach my $item (@{ $form->{"ALL_PROJECTS"} }) {
|
|
| 355 |
push(@project_values, $item->{"id"});
|
|
| 356 |
$project_labels{$item->{"id"}} = $item->{"projectnumber"};
|
|
| 357 |
} |
|
| 281 |
my %project_labels = map { $_->{id} => $_->{projectnumber} } @{ $form->{"ALL_PROJECTS"} };
|
|
| 358 | 282 |
|
| 359 |
my (%AR_amount_labels, @AR_amount_values); |
|
| 360 |
my (%AR_labels, @AR_values); |
|
| 361 |
my (%AR_paid_labels, @AR_paid_values); |
|
| 283 |
my (@AR_amount_values); |
|
| 284 |
my (@AR_values); |
|
| 285 |
my (@AR_paid_values); |
|
| 286 |
my %chart_labels; |
|
| 362 | 287 |
my %charts; |
| 363 | 288 |
my $taxchart_init; |
| 364 | 289 |
|
| 365 | 290 |
foreach my $item (@{ $form->{ALL_CHARTS} }) {
|
| 366 |
if (grep({ $_ eq "AR_amount" } @{ $item->{link_split} })) {
|
|
| 291 |
if ($item->{link_split}{AR_amount}) {
|
|
| 367 | 292 |
$taxchart_init = $item->{tax_id} if ($taxchart_init eq "");
|
| 368 | 293 |
my $key = "$item->{accno}--$item->{tax_id}";
|
| 369 | 294 |
push(@AR_amount_values, $key); |
| 370 |
$AR_amount_labels{$key} =
|
|
| 371 |
"$item->{accno}--$item->{description}";
|
|
| 372 |
|
|
| 373 |
} elsif (grep({ $_ eq "AR" } @{ $item->{link_split} })) {
|
|
| 295 |
} elsif ($item->{link_split}{AR}) {
|
|
| 374 | 296 |
push(@AR_values, $item->{accno});
|
| 375 |
$AR_labels{$item->{accno}} = "$item->{accno}--$item->{description}";
|
|
| 376 |
|
|
| 377 |
} elsif (grep({ $_ eq "AR_paid" } @{ $item->{link_split} })) {
|
|
| 297 |
} elsif ($item->{link_split}{AR_paid}) {
|
|
| 378 | 298 |
push(@AR_paid_values, $item->{accno});
|
| 379 |
$AR_paid_labels{$item->{accno}} =
|
|
| 380 |
"$item->{accno}--$item->{description}";
|
|
| 381 | 299 |
} |
| 382 | 300 |
|
| 301 |
# weirdness for AR_amount |
|
| 302 |
$chart_labels{$item->{accno}} = "$item->{accno}--$item->{description}";
|
|
| 303 |
$chart_labels{"$item->{accno}--$item->{tax_id}"} = "$item->{accno}--$item->{description}";
|
|
| 304 |
|
|
| 383 | 305 |
$charts{$item->{accno}} = $item;
|
| 384 | 306 |
} |
| 385 | 307 |
|
| ... | ... | |
| 390 | 312 |
my $key = "$item->{id}--$item->{rate}";
|
| 391 | 313 |
$taxchart_init = $key if ($taxchart_init eq $item->{id});
|
| 392 | 314 |
push(@taxchart_values, $key); |
| 393 |
$taxchart_labels{$key} =
|
|
| 394 |
"$item->{taxdescription} " . ($item->{rate} * 100) . ' %';
|
|
| 315 |
$taxchart_labels{$key} = "$item->{taxdescription} " . ($item->{rate} * 100) . ' %';
|
|
| 395 | 316 |
$taxcharts{$item->{id}} = $item;
|
| 396 | 317 |
} |
| 397 | 318 |
|
| 398 | 319 |
$form->{fokus} = "arledger.customer";
|
| 399 | 320 |
|
| 400 |
# use JavaScript Calendar or not |
|
| 401 |
$form->{jsscript} = 1;
|
|
| 402 |
$jsscript = ""; |
|
| 403 |
if ($form->{jsscript}) {
|
|
| 404 |
|
|
| 405 |
# with JavaScript Calendar |
|
| 406 |
$button1 = qq| |
|
| 407 |
<td><input name=transdate id=transdate size=11 title="$myconfig{dateformat}" value="$form->{transdate}" onBlur=\"check_right_date_format(this)\"></td>
|
|
| 408 |
<td><input type=button name=transdate id="trigger1" value=| |
|
| 409 |
. $locale->text('button') . qq|></td>
|
|
| 410 |
|; |
|
| 411 |
$button2 = qq| |
|
| 412 |
<td><input name=duedate id=duedate size=11 title="$myconfig{dateformat}" value="$form->{duedate}" onBlur=\"check_right_date_format(this)\"></td>
|
|
| 413 |
<td><input type=button name=duedate id="trigger2" value=| |
|
| 414 |
. $locale->text('button') . qq|></td></td>
|
|
| 415 |
|; |
|
| 416 |
|
|
| 417 |
#write Trigger |
|
| 418 |
$jsscript = |
|
| 419 |
Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", |
|
| 420 |
"duedate", "BL", "trigger2"); |
|
| 421 |
} else {
|
|
| 422 |
|
|
| 423 |
# without JavaScript Calendar |
|
| 424 |
$button1 = |
|
| 425 |
qq|<td><input name=transdate id=transdate size=11 title="$myconfig{dateformat}" value="$form->{transdate}" onBlur=\"check_right_date_format(this)\"></td>|;
|
|
| 426 |
$button2 = |
|
| 427 |
qq|<td><input name=duedate id=duedate size=11 title="$myconfig{dateformat}" value="$form->{duedate}" onBlur=\"check_right_date_format(this)\"></td>|;
|
|
| 428 |
} |
|
| 429 |
|
|
| 430 | 321 |
my $follow_up_vc = $form->{customer};
|
| 431 | 322 |
$follow_up_vc =~ s/--.*?//; |
| 432 | 323 |
my $follow_up_trans_info = "$form->{invnumber} ($follow_up_vc)";
|
| 433 | 324 |
|
| 434 | 325 |
$form->{javascript} .=
|
| 435 |
qq|<script type="text/javascript" src="js/common.js"></script>| . |
|
| 436 | 326 |
qq|<script type="text/javascript" src="js/show_vc_details.js"></script>| . |
| 437 | 327 |
qq|<script type="text/javascript" src="js/follow_up.js"></script>|; |
| 438 | 328 |
|
| 439 |
my $globalprojectnumber = |
|
| 440 |
NTI($cgi->popup_menu('-name' => "globalproject_id",
|
|
| 441 |
'-values' => \@project_values, |
|
| 442 |
'-labels' => \%project_labels, |
|
| 443 |
'-default' => $form->{"globalproject_id"} ));
|
|
| 444 |
|
|
| 445 |
$form->header; |
|
| 446 | 329 |
$onload = qq|focus()|; |
| 447 |
$onload .= qq|;setupDateFormat('|. $myconfig{dateformat} .qq|', '|. $locale->text("Falsches Datumsformat!") .qq|')|;
|
|
| 448 | 330 |
$onload .= qq|;setupPoints('|. $myconfig{numberformat} .qq|', '|. $locale->text("wrongformat") .qq|')|;
|
| 449 |
print qq| |
|
| 450 |
<body onLoad="$onload"> |
|
| 451 |
|
|
| 452 |
<form method=post name="arledger" action=$form->{script}>
|
|
| 453 |
|
|
| 454 |
<input type=hidden name=id value=$form->{id}>
|
|
| 455 |
<input type=hidden name=sort value=$form->{sort}>
|
|
| 456 |
<input type=hidden name=closedto value=$form->{closedto}>
|
|
| 457 |
<input type=hidden name=locked value=$form->{locked}>
|
|
| 458 |
<input type=hidden name=title value="$title"> |
|
| 459 |
<input type="hidden" name="follow_up_trans_id_1" value="| . H($form->{id}) . qq|">
|
|
| 460 |
<input type="hidden" name="follow_up_trans_type_1" value="ar_transaction"> |
|
| 461 |
<input type="hidden" name="follow_up_trans_info_1" value="| . H($follow_up_trans_info) . qq|"> |
|
| 462 |
<input type="hidden" name="follow_up_rowcount" value="1"> |
|
| 463 |
|
|
| 464 |
| . ($form->{saved_message} ? qq|<p>$form->{saved_message}</p>| : "") . qq|
|
|
| 465 |
|
|
| 466 |
<table width=100%> |
|
| 467 |
<tr class=listtop> |
|
| 468 |
<th class=listtop>$form->{title}</th>
|
|
| 469 |
</tr> |
|
| 470 |
<tr height="5"></tr> |
|
| 471 |
<tr valign=top> |
|
| 472 |
<td> |
|
| 473 |
<table width=100%> |
|
| 474 |
<tr valign=top> |
|
| 475 |
<td> |
|
| 476 |
<table> |
|
| 477 |
<tr> |
|
| 478 |
<th align="right" nowrap>| . $locale->text('Customer') . qq|</th>
|
|
| 479 |
<td colspan=3>$customer <input type="button" value="| . $locale->text('Details (one letter abbreviation)') . qq|" onclick="show_vc_details('customer')"></td>
|
|
| 480 |
<input type=hidden name=selectcustomer value="$form->{selectcustomer}">
|
|
| 481 |
<input type=hidden name=oldcustomer value="$form->{oldcustomer}">
|
|
| 482 |
<input type=hidden name=customer_id value="$form->{customer_id}">
|
|
| 483 |
<input type=hidden name=terms value=$form->{terms}>
|
|
| 484 |
</tr> |
|
| 485 |
<tr> |
|
| 486 |
<td></td> |
|
| 487 |
<td colspan=3> |
|
| 488 |
<table width=100%> |
|
| 489 |
<tr> |
|
| 490 |
<th align=left nowrap>| . $locale->text('Credit Limit') . qq|</th>
|
|
| 491 |
<td>$form->{creditlimit}</td>
|
|
| 492 |
<th align=left nowrap>| . $locale->text('Remaining') . qq|</th>
|
|
| 493 |
<td class="plus$n">$form->{creditremaining}</td>
|
|
| 494 |
<input type=hidden name=creditlimit value=$form->{creditlimit}>
|
|
| 495 |
<input type=hidden name=creditremaining value=$form->{creditremaining}>
|
|
| 496 |
</tr> |
|
| 497 |
</table> |
|
| 498 |
</td> |
|
| 499 |
</tr> |
|
| 500 |
<tr> |
|
| 501 |
<th align=right>| . $locale->text('Currency') . qq|</th>
|
|
| 502 |
<td><select name=currency>$form->{selectcurrency}</select></td>
|
|
| 503 |
<input type=hidden name=selectcurrency value="$form->{selectcurrency}">
|
|
| 504 |
<input type=hidden name=defaultcurrency value=$form->{defaultcurrency}>
|
|
| 505 |
<input type=hidden name=fxgain_accno value=$form->{fxgain_accno}>
|
|
| 506 |
<input type=hidden name=fxloss_accno value=$form->{fxloss_accno}>
|
|
| 507 |
$exchangerate |
|
| 508 |
</tr> |
|
| 509 |
$department |
|
| 510 |
$taxincluded |
|
| 511 |
</table> |
|
| 512 |
</td> |
|
| 513 |
<td align=right> |
|
| 514 |
<table> |
|
| 515 |
$employee |
|
| 516 |
<tr> |
|
| 517 |
<th align=right nowrap>| . $locale->text('Invoice Number') . qq|</th>
|
|
| 518 |
<td><input name=invnumber size=11 value="$form->{invnumber}"></td>
|
|
| 519 |
</tr> |
|
| 520 |
<tr> |
|
| 521 |
<th align=right nowrap>| . $locale->text('Order Number') . qq|</th>
|
|
| 522 |
<td><input name=ordnumber size=11 value="$form->{ordnumber}"></td>
|
|
| 523 |
</tr> |
|
| 524 |
<tr> |
|
| 525 |
<th align=right nowrap>| . $locale->text('Invoice Date') . qq|</th>
|
|
| 526 |
$button1 |
|
| 527 |
</tr> |
|
| 528 |
<tr> |
|
| 529 |
<th align=right nowrap>| . $locale->text('Due Date') . qq|</th>
|
|
| 530 |
$button2 |
|
| 531 |
</tr> |
|
| 532 |
<tr> |
|
| 533 |
<th align=right nowrap>| . $locale->text('Project Number') . qq|</th>
|
|
| 534 |
<td>$globalprojectnumber</td> |
|
| 535 |
</tr> |
|
| 536 |
</table> |
|
| 537 |
</td> |
|
| 538 |
</tr> |
|
| 539 |
</table> |
|
| 540 |
</td> |
|
| 541 |
</tr> |
|
| 542 |
|
|
| 543 |
$jsscript |
|
| 544 |
<input type=hidden name=rowcount value=$form->{rowcount}>
|
|
| 545 |
<tr> |
|
| 546 |
<td> |
|
| 547 |
<table width=100%> |
|
| 548 |
<tr class=listheading> |
|
| 549 |
<th class=listheading style="width:15%">| |
|
| 550 |
. $locale->text('Account') . qq|</th>
|
|
| 551 |
<th class=listheading style="width:10%">| |
|
| 552 |
. $locale->text('Amount') . qq|</th>
|
|
| 553 |
<th class=listheading style="width:10%">| |
|
| 554 |
. $locale->text('Tax') . qq|</th>
|
|
| 555 |
<th class=listheading style="width:5%">| |
|
| 556 |
. $locale->text('Taxkey') . qq|</th>
|
|
| 557 |
<th class=listheading style="width:10%">| |
|
| 558 |
. $locale->text('Project') . qq|</th>
|
|
| 559 |
</tr> |
|
| 560 |
|; |
|
| 561 | 331 |
|
| 562 |
$amount = $locale->text('Amount');
|
|
| 563 |
$project = $locale->text('Project');
|
|
| 332 |
# $amount = $locale->text('Amount');
|
|
| 333 |
# $project = $locale->text('Project');
|
|
| 564 | 334 |
|
| 335 |
my @transactions; |
|
| 565 | 336 |
for my $i (1 .. $form->{rowcount}) {
|
| 566 |
|
|
| 567 |
# format amounts
|
|
| 568 |
$form->{"amount_$i"} =
|
|
| 569 |
$form->format_amount(\%myconfig, $form->{"amount_$i"}, 2);
|
|
| 570 |
$form->{"tax_$i"} = $form->format_amount(\%myconfig, $form->{"tax_$i"}, 2);
|
|
| 337 |
my $transaction = {
|
|
| 338 |
amount => $form->{"amount_$i"},
|
|
| 339 |
tax => $form->{"tax$i"},
|
|
| 340 |
project_id => $form->{"project_id_$i"},
|
|
| 341 |
};
|
|
| 571 | 342 |
|
| 572 | 343 |
my $selected_accno_full; |
| 573 | 344 |
my ($accno_row) = split(/--/, $form->{"AR_amount_$i"});
|
| ... | ... | |
| 593 | 364 |
} |
| 594 | 365 |
} |
| 595 | 366 |
|
| 596 |
$selectAR_amount =
|
|
| 367 |
$transaction->{selectAR_amount} =
|
|
| 597 | 368 |
NTI($cgi->popup_menu('-name' => "AR_amount_$i",
|
| 598 | 369 |
'-id' => "AR_amount_$i", |
| 599 | 370 |
'-style' => 'width:400px', |
| 600 | 371 |
'-onChange' => "setTaxkey(this, $i)", |
| 601 | 372 |
'-values' => \@AR_amount_values, |
| 602 |
'-labels' => \%AR_amount_labels,
|
|
| 373 |
'-labels' => \%chart_labels,
|
|
| 603 | 374 |
'-default' => $selected_accno_full)) |
| 604 | 375 |
. $cgi->hidden('-name' => "previous_AR_amount_$i",
|
| 605 | 376 |
'-default' => $selected_accno_full); |
| 606 | 377 |
|
| 607 |
$tax = qq|<td>| .
|
|
| 378 |
$transaction->{tax} =
|
|
| 608 | 379 |
NTI($cgi->popup_menu('-name' => "taxchart_$i",
|
| 609 | 380 |
'-id' => "taxchart_$i", |
| 610 | 381 |
'-style' => 'width:200px', |
| 611 | 382 |
'-values' => \@taxchart_values, |
| 612 | 383 |
'-labels' => \%taxchart_labels, |
| 613 |
'-default' => $selected_taxchart)) |
|
| 614 |
. qq|</td>|; |
|
| 384 |
'-default' => $selected_taxchart)); |
|
| 615 | 385 |
|
| 616 |
my $projectnumber = |
|
| 617 |
NTI($cgi->popup_menu('-name' => "project_id_$i",
|
|
| 618 |
'-values' => \@project_values, |
|
| 619 |
'-labels' => \%project_labels, |
|
| 620 |
'-default' => $form->{"project_id_$i"} ));
|
|
| 621 |
|
|
| 622 |
print qq| |
|
| 623 |
<tr> |
|
| 624 |
<td>$selectAR_amount</td> |
|
| 625 |
<td><input name="amount_$i" size=10 value=$form->{"amount_$i"}></td>
|
|
| 626 |
<td><input type="hidden" name="tax_$i" value="$form->{"tax_$i"}">$form->{"tax_$i"}</td>
|
|
| 627 |
$tax |
|
| 628 |
<td>$projectnumber</td> |
|
| 629 |
</tr> |
|
| 630 |
|; |
|
| 631 |
$amount = ""; |
|
| 632 |
$project = ""; |
|
| 386 |
push @transactions, $transaction; |
|
| 633 | 387 |
} |
| 634 | 388 |
|
| 635 | 389 |
$form->{invtotal_unformatted} = $form->{invtotal};
|
| 636 |
$form->{invtotal} = $form->format_amount(\%myconfig, $form->{invtotal}, 2);
|
|
| 637 | 390 |
|
| 638 | 391 |
$ARselected = |
| 639 | 392 |
NTI($cgi->popup_menu('-name' => "ARselected", '-id' => "ARselected",
|
| 640 | 393 |
'-style' => 'width:400px', |
| 641 |
'-values' => \@AR_values, '-labels' => \%AR_labels,
|
|
| 394 |
'-values' => \@AR_values, '-labels' => \%chart_labels,
|
|
| 642 | 395 |
'-default' => $form->{ARselected}));
|
| 643 | 396 |
|
| 644 |
print qq| |
|
| 645 |
<tr> |
|
| 646 |
<td colspan=6> |
|
| 647 |
<hr noshade> |
|
| 648 |
</td> |
|
| 649 |
</tr> |
|
| 650 |
<tr> |
|
| 651 |
<td>${ARselected}</td>
|
|
| 652 |
<th align=left>$form->{invtotal}</th>
|
|
| 653 |
|
|
| 654 |
<input type=hidden name=oldinvtotal value=$form->{oldinvtotal}>
|
|
| 655 |
<input type=hidden name=oldtotalpaid value=$form->{oldtotalpaid}>
|
|
| 656 |
|
|
| 657 |
<input type=hidden name=taxaccounts value="$form->{taxaccounts}">
|
|
| 658 |
|
|
| 659 |
<td colspan=4></td> |
|
| 660 |
|
|
| 661 |
|
|
| 662 |
</tr> |
|
| 663 |
</table> |
|
| 664 |
</td> |
|
| 665 |
</tr> |
|
| 666 |
<tr> |
|
| 667 |
<td> |
|
| 668 |
<table width=100%> |
|
| 669 |
<tr> |
|
| 670 |
<th align=left width=1%>| . $locale->text('Notes') . qq|</th>
|
|
| 671 |
<td align=left>$notes</td> |
|
| 672 |
</tr> |
|
| 673 |
</table> |
|
| 674 |
</td> |
|
| 675 |
</tr> |
|
| 676 |
<tr> |
|
| 677 |
<td> |
|
| 678 |
<table width=100%> |
|
| 679 |
<tr class=listheading> |
|
| 680 |
<th colspan=7 class=listheading>| |
|
| 681 |
. $locale->text('Incoming Payments') . qq|</th>
|
|
| 682 |
</tr> |
|
| 683 |
|; |
|
| 684 | 397 |
|
| 685 |
if ($form->{defaultcurrency} && ($form->{currency} eq $form->{defaultcurrency})) {
|
|
| 686 |
@column_index = qw(datepaid source memo paid AR_paid paid_project_id); |
|
| 687 |
} else {
|
|
| 688 |
@column_index = qw(datepaid source memo paid exchangerate AR_paid paid_project_id); |
|
| 689 |
} |
|
| 690 |
|
|
| 691 |
$column_data{datepaid} = "<th>" . $locale->text('Date') . "</th>";
|
|
| 692 |
$column_data{paid} = "<th>" . $locale->text('Amount') . "</th>";
|
|
| 693 |
$column_data{exchangerate} = "<th>" . $locale->text('Exch') . "</th>";
|
|
| 694 |
$column_data{AR_paid} = "<th>" . $locale->text('Account') . "</th>";
|
|
| 695 |
$column_data{source} = "<th>" . $locale->text('Source') . "</th>";
|
|
| 696 |
$column_data{memo} = "<th>" . $locale->text('Memo') . "</th>";
|
|
| 697 |
$column_data{paid_project_id} = "<th>" . $locale->text('Project Number') . "</th>";
|
|
| 698 |
|
|
| 699 |
print " |
|
| 700 |
<tr> |
|
| 701 |
"; |
|
| 702 |
map { print "$column_data{$_}\n" } @column_index;
|
|
| 703 |
print " |
|
| 704 |
</tr> |
|
| 705 |
"; |
|
| 398 |
$form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"});
|
|
| 706 | 399 |
|
| 707 |
my @triggers = (); |
|
| 708 |
$form->{totalpaid} = 0;
|
|
| 400 |
my $now = $form->current_date(\%myconfig); |
|
| 709 | 401 |
|
| 710 |
$form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"});
|
|
| 402 |
my @payments;
|
|
| 711 | 403 |
for my $i (1 .. $form->{paidaccounts}) {
|
| 712 |
print " |
|
| 713 |
<tr> |
|
| 714 |
"; |
|
| 715 |
|
|
| 716 |
$selectAR_paid = |
|
| 404 |
my $payment = {
|
|
| 405 |
paid => $form->{"paid_$i"},
|
|
| 406 |
exchangerate => $form->{"exchangerate_$i"} || '',
|
|
| 407 |
gldate => $form->{"gldate_$i"},
|
|
| 408 |
acc_trans_id => $form->{"acc_trans_id_$i"},
|
|
| 409 |
source => $form->{"source_$i"},
|
|
| 410 |
memo => $form->{"memo_$i"},
|
|
| 411 |
AR_paid => $form->{"AR_paid_$i"},
|
|
| 412 |
forex => $form->{"forex_$i"},
|
|
| 413 |
datepaid => $form->{"datepaid_$i"},
|
|
| 414 |
paid_project_id => $form->{"paid_project_id_$i"},
|
|
| 415 |
gldate => $form->{"gldate_$i"},
|
|
| 416 |
}; |
|
| 417 |
|
|
| 418 |
$payment->{selectAR_paid} =
|
|
| 717 | 419 |
NTI($cgi->popup_menu('-name' => "AR_paid_$i",
|
| 718 | 420 |
'-id' => "AR_paid_$i", |
| 719 | 421 |
'-values' => \@AR_paid_values, |
| 720 |
'-labels' => \%AR_paid_labels,
|
|
| 721 |
'-default' => $form->{"AR_paid_$i"}));
|
|
| 422 |
'-labels' => \%chart_labels,
|
|
| 423 |
'-default' => $payment->{AR_paid}));
|
|
| 722 | 424 |
|
| 723 |
$form->{totalpaid} += $form->{"paid_$i"};
|
|
| 724 | 425 |
|
| 725 |
# format amounts |
|
| 726 |
if ($form->{"paid_$i"}) {
|
|
| 727 |
$form->{"paid_$i"} =
|
|
| 728 |
$form->format_amount(\%myconfig, $form->{"paid_$i"}, 2);
|
|
| 729 |
} |
|
| 730 |
if ($form->{"exchangerate_$i"} == 0) {
|
|
| 731 |
$form->{"exchangerate_$i"} = "";
|
|
| 732 |
} else {
|
|
| 733 |
$form->{"exchangerate_$i"} =
|
|
| 734 |
$form->format_amount(\%myconfig, $form->{"exchangerate_$i"});
|
|
| 735 |
} |
|
| 736 | 426 |
|
| 737 |
print qq|<input type=hidden name="acc_trans_id_$i" value=$form->{"acc_trans_id_$i"}>\n|;
|
|
| 738 |
print qq|<input type=hidden name="gldate_$i" value=$form->{"gldate_$i"}>\n|;
|
|
| 739 |
my $changeable = 1; |
|
| 740 |
if ($::lx_office_conf{features}->{payments_changeable} == 0) {
|
|
| 741 |
# never |
|
| 742 |
$changeable = ($form->{"acc_trans_id_$i"})? 0 : 1;
|
|
| 743 |
} |
|
| 744 |
if ($::lx_office_conf{features}->{payments_changeable} == 2) {
|
|
| 745 |
# on the same day |
|
| 746 |
$changeable = (($form->{"gldate_$i"} eq '') || $form->current_date(\%myconfig) eq $form->{"gldate_$i"});
|
|
| 747 |
} |
|
| 748 |
|
|
| 749 |
$exchangerate = qq| |; |
|
| 750 |
if ($form->{defaultcurrency} && ($form->{currency} ne $form->{defaultcurrency})) {
|
|
| 751 |
if ($form->{"forex_$i"}) {
|
|
| 752 |
$exchangerate = |
|
| 753 |
qq|<input type=hidden name="exchangerate_$i" value=$form->{"exchangerate_$i"}>$form->{"exchangerate_$i"}|;
|
|
| 754 |
} else {
|
|
| 755 |
if ($changeable) {
|
|
| 756 |
$exchangerate = |
|
| 757 |
qq|<input name="exchangerate_$i" size=10 value=$form->{"exchangerate_$i"}>|;
|
|
| 758 |
} else {
|
|
| 759 |
$exchangerate = |
|
| 760 |
qq|<input type=hidden name="exchangerate_$i" value=$form->{"exchangerate_$i"}>$form->{"exchangerate_$i"}|;
|
|
| 761 |
} |
|
| 762 |
} |
|
| 763 |
} |
|
| 427 |
$payment->{changeable} =
|
|
| 428 |
$::lx_office_conf{features}->{payments_changeable} == 0 ? !$payment->{acc_trans_id} # never
|
|
| 429 |
: $::lx_office_conf{features}->{payments_changeable} == 2 ? $payment->{gldate} eq '' || $payment->{gldate} eq $now
|
|
| 430 |
: 1; |
|
| 764 | 431 |
|
| 765 |
$exchangerate .= qq| |
|
| 766 |
<input type=hidden name="forex_$i" value=$form->{"forex_$i"}>
|
|
| 767 |
|; |
|
| 768 |
|
|
| 769 |
my $datepaid; |
|
| 770 |
if ($changeable) {
|
|
| 771 |
$datepaid = qq|<td align=center><input name="datepaid_$i" id="datepaid_$i" size=11 value="$form->{"datepaid_$i"}" onBlur=\"check_right_date_format(this)\">
|
|
| 772 |
<input type="button" name="datepaid_$i" id="trigger_datepaid_$i" value="?"></td>|; |
|
| 773 |
} else {
|
|
| 774 |
$datepaid = qq|<td align=center>$form->{"datepaid_$i"}</td>|.
|
|
| 775 |
qq|<input type=hidden name="datepaid_$i" value=$form->{"datepaid_$i"}>|;
|
|
| 776 |
} |
|
| 777 |
|
|
| 778 |
my $paid; |
|
| 779 |
if ($changeable) {
|
|
| 780 |
$paid = qq|<td align=center><input name="paid_$i" size=11 value="$form->{"paid_$i"}" onBlur=\"check_right_number_format(this)\"></td>|;
|
|
| 781 |
} else {
|
|
| 782 |
$paid = qq|<td align=center>$form->{"paid_$i"}</td>|.
|
|
| 783 |
qq|<input type=hidden name="paid_$i" value=$form->{"paid_$i"}>|;
|
|
| 784 |
} |
|
| 785 |
|
|
| 786 |
my $source; |
|
| 787 |
if ($changeable) {
|
|
| 788 |
$source = qq|<td align=center><input name="source_$i" size=11 value="$form->{"source_$i"}"></td>|;
|
|
| 789 |
} else {
|
|
| 790 |
$source = qq|<td align=center>$form->{"source_$i"}</td>|.
|
|
| 791 |
qq|<input type=hidden name="source_$i" value=$form->{"source_$i"}>|;
|
|
| 792 |
} |
|
| 793 |
|
|
| 794 |
my $memo; |
|
| 795 |
if ($changeable) {
|
|
| 796 |
$memo = qq|<td align=center><input name="memo_$i" size=11 value="$form->{"memo_$i"}"></td>|;
|
|
| 797 |
} else {
|
|
| 798 |
$memo = qq|<td align=center>$form->{"memo_$i"}</td>|.
|
|
| 799 |
qq|<input type=hidden name="memo_$i" value=$form->{"memo_$i"}>|;
|
|
| 800 |
} |
|
| 801 |
|
|
| 802 |
my $AR_paid; |
|
| 803 |
if ($changeable) {
|
|
| 804 |
$AR_paid = qq|<td align=center>${selectAR_paid}</td>|;
|
|
| 805 |
} else {
|
|
| 806 |
$AR_paid = qq|<td align=center>$form->{"AR_paid_$i"}</td>|.
|
|
| 807 |
qq|<input type=hidden name="AR_paid_$i" value=$form->{"AR_paid_$i"}>|;
|
|
| 808 |
} |
|
| 809 |
|
|
| 810 |
my $paid_project_id; |
|
| 811 |
if ($changeable) {
|
|
| 812 |
$paid_project_id = |
|
| 813 |
qq|<td>| |
|
| 814 |
. NTI($cgi->popup_menu('-name' => "paid_project_id_$i",
|
|
| 815 |
'-values' => \@project_values, |
|
| 816 |
'-labels' => \%project_labels, |
|
| 817 |
'-default' => $form->{"paid_project_id_$i"} ))
|
|
| 818 |
. qq|</td>|; |
|
| 819 |
} else {
|
|
| 820 |
my $projectnumber = $project_labels{$form->{"paid_project_id_$i"}};
|
|
| 821 |
$paid_project_id = qq|<td>$projectnumber</td>|. |
|
| 822 |
qq|<input type=hidden name="paid_project_id_$i" value=$form->{"paid_project_id_$i"}>|;
|
|
| 823 |
} |
|
| 824 |
|
|
| 825 |
$column_data{paid} = $paid;
|
|
| 826 |
$column_data{AR_paid} = $AR_paid;
|
|
| 827 |
$column_data{exchangerate} = qq|<td align=center>$exchangerate</td>|;
|
|
| 828 |
$column_data{datepaid} = $datepaid;
|
|
| 829 |
$column_data{source} = $source;
|
|
| 830 |
$column_data{memo} = $memo;
|
|
| 831 |
$column_data{paid_project_id} = $paid_project_id;
|
|
| 832 |
|
|
| 833 |
map { print qq|$column_data{$_}\n| } @column_index;
|
|
| 834 |
|
|
| 835 |
print " |
|
| 836 |
</tr> |
|
| 837 |
"; |
|
| 838 |
if ($changeable) {
|
|
| 839 |
push(@triggers, "datepaid_$i", "BL", "trigger_datepaid_$i"); |
|
| 840 |
} |
|
| 432 |
push @payments, $payment; |
|
| 841 | 433 |
} |
| 842 | 434 |
|
| 843 |
my $paid_missing = $form->{invtotal_unformatted} - $form->{totalpaid};
|
|
| 435 |
$form->{totalpaid} = sum map { $_->{paid} } @payments;
|
|
| 844 | 436 |
|
| 845 |
print qq| |
|
| 846 |
<tr> |
|
| 847 |
<td></td> |
|
| 848 |
<td></td> |
|
| 849 |
<td align="center">| . $locale->text('Total') . qq|</td>
|
|
| 850 |
<td align="center">| . H($form->format_amount(\%myconfig, $form->{totalpaid}, 2)) . qq|</td>
|
|
| 851 |
</tr> |
|
| 852 |
<tr> |
|
| 853 |
<td></td> |
|
| 854 |
<td></td> |
|
| 855 |
<td align="center">| . $locale->text('Missing amount') . qq|</td>
|
|
| 856 |
<td align="center">| . H($form->format_amount(\%myconfig, $paid_missing, 2)) . qq|</td> |
|
| 857 |
</tr> |
|
| 858 |
| . $form->write_trigger(\%myconfig, scalar(@triggers) / 3, @triggers) . |
|
| 859 |
qq| |
|
| 860 |
<input type=hidden name=paidaccounts value=$form->{paidaccounts}>
|
|
| 861 |
|
|
| 862 |
</table> |
|
| 863 |
</td> |
|
| 864 |
</tr> |
|
| 865 |
<tr> |
|
| 866 |
<td><hr size=3 noshade></td> |
|
| 867 |
</tr> |
|
| 868 |
</table> |
|
| 869 |
|; |
|
| 437 |
$form->header; |
|
| 438 |
print $::form->parse_html_template('ar/form_header', {
|
|
| 439 |
paid_missing => $::form->{invtotal} - $::form->{totalpaid},
|
|
| 440 |
show_exch => ($::form->{defaultcurrency} && ($::form->{currency} ne $::form->{defaultcurrency})),
|
|
| 441 |
payments => \@payments, |
|
| 442 |
transactions => \@transactions, |
|
| 443 |
project_labels => \%project_labels, |
|
| 444 |
rows => $rows, |
|
| 445 |
ARselected => $ARselected, |
|
| 446 |
onload => $onload, |
|
| 447 |
title_str => $title, |
|
| 448 |
follow_up_trans_info => $follow_up_trans_info, |
|
| 449 |
}); |
|
| 870 | 450 |
|
| 871 | 451 |
$main::lxdebug->leave_sub(); |
| 872 | 452 |
} |
Auch abrufbar als: Unified diff
ar form_header nach template ausgelagert