X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=bin%2Fmozilla%2Fio.pl;h=b71ca90b71b5adf0ad2f9611d85b82d53e3be2b7;hb=bb99760f9239bca52db6f4496bdb7aaa9055fbf7;hp=8cbe24456b01ed759d01cfd565466397b70ee880;hpb=07d71c33315605fcfc450d3b9abf0fd10e92bed5;p=kivitendo-erp.git
diff --git a/bin/mozilla/io.pl b/bin/mozilla/io.pl
index 8cbe24456..b71ca90b7 100644
--- a/bin/mozilla/io.pl
+++ b/bin/mozilla/io.pl
@@ -74,6 +74,7 @@ if (-f "$form->{path}/$form->{login}_io.pl") {
# $locale->text('Dec')
use SL::IS;
use SL::PE;
+use SL::AM;
use Data::Dumper;
########################################
# Eintrag fuer Version 2.2.0 geaendert #
@@ -82,7 +83,6 @@ use Data::Dumper;
sub display_row {
$lxdebug->enter_sub();
my $numrows = shift;
-print STDERR "io.pl-display_row\n";
if ($lizenzen && $form->{vc} eq "customer") {
if ($form->{type} =~ /sales_order/) {
@column_index = (runningnumber, partnumber, description, ship, qty);
@@ -101,10 +101,17 @@ print STDERR "io.pl-display_row\n";
}
############## ENDE Neueintrag ##################
+ my $dimension_units = AM->retrieve_units(\%myconfig, $form, "dimension");
+ my $service_units = AM->retrieve_units(\%myconfig, $form, "service");
+ my $all_units = AM->retrieve_units(\%myconfig, $form);
+
push @column_index, qw(unit);
#for pricegroups column
- if ($form->{type} =~ (/sales_quotation/) or (($form->{level} =~ /Sales/) and ($form->{type} =~ /invoice/)) or (($form->{level} eq undef) and ($form->{type} =~ /invoice/)) or ($form->{type} =~ /sales_order/)) {
+ if ( $form->{type} =~ (/sales_quotation/)
+ or (($form->{level} =~ /Sales/) and ($form->{type} =~ /invoice/))
+ or (($form->{level} eq undef) and ($form->{type} =~ /invoice/))
+ or ($form->{type} =~ /sales_order/)) {
push @column_index, qw(sellprice_drag);
}
@@ -200,6 +207,7 @@ print STDERR "io.pl-display_row\n";
$serialnumber = $locale->text('Serial No.');
$projectnumber = $locale->text('Project');
$partsgroup = $locale->text('Group');
+ $reqdate = $locale->text('Reqdate');
$delvar = 'deliverydate';
@@ -214,8 +222,42 @@ print STDERR "io.pl-display_row\n";
map {
$form->{"${_}_$i"} =
$form->parse_amount(\%myconfig, $form->{"${_}_$i"})
- } qw(qty ship discount sellprice price_new price_old);
+ } qw(qty ship discount sellprice price_new price_old) unless ($form->{simple_save});
+
+ if (!$form->{"unit_old_$i"}) {
+ # Neue Ware aus der Datenbank. In diesem Fall ist unit_$i die
+ # Einheit, wie sie in den Stammdaten hinterlegt wurde.
+ # Es sollte also angenommen werden, dass diese ausgewaehlt war.
+ $form->{"unit_old_$i"} = $form->{"unit_$i"};
+ }
+
+
+ # Die zuletzt ausgewaehlte mit der aktuell ausgewaehlten Einheit
+ # vergleichen und bei Unterschied den Preis entsprechend umrechnen.
+ $form->{"selected_unit_$i"} = $form->{"unit_$i"} unless ($form->{"selected_unit_$i"});
+
+ my $check_units = $form->{"inventory_accno_$i"} ? $dimension_units : $service_units;
+ if (!$check_units->{$form->{"selected_unit_$i"}} ||
+ ($check_units->{$form->{"selected_unit_$i"}}->{"base_unit"} ne
+ $all_units->{$form->{"unit_old_$i"}}->{"base_unit"})) {
+ # Die ausgewaehlte Einheit ist fuer diesen Artikel nicht gueltig
+ # (z.B. Dimensionseinheit war ausgewaehlt, es handelt sich aber
+ # um eine Dienstleistung). Dann keinerlei Umrechnung vornehmen.
+ $form->{"unit_old_$i"} = $form->{"selected_unit_$i"} = $form->{"unit_$i"};
+ }
+ if ((!$form->{"prices_$i"}) || ($form->{"new_pricegroup_$i"} == $form->{"old_pricegroup_$i"})) {
+ if ($form->{"unit_old_$i"} ne $form->{"selected_unit_$i"}) {
+ my $basefactor = 1;
+ if (defined($all_units->{$form->{"unit_old_$i"}}->{"factor"}) &&
+ $all_units->{$form->{"unit_old_$i"}}->{"factor"}) {
+ $basefactor = $all_units->{$form->{"selected_unit_$i"}}->{"factor"} /
+ $all_units->{$form->{"unit_old_$i"}}->{"factor"};
+ }
+ $form->{"sellprice_$i"} *= $basefactor;
+ $form->{"unit_old_$i"} = $form->{"selected_unit_$i"};
+ }
+ }
($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/);
$dec = length $dec;
$decimalplaces = ($dec > 2) ? $dec : 2;
@@ -231,7 +273,7 @@ print STDERR "io.pl-display_row\n";
# convert " to "
map { $form->{"${_}_$i"} =~ s/\"/"/g }
- qw(partnumber description unit);
+ qw(partnumber description unit unit_old);
########################################
# Eintrag fuer Version 2.2.0 geaendert #
@@ -246,64 +288,89 @@ print STDERR "io.pl-display_row\n";
if (($rows = $form->numtextrows($form->{"description_$i"}, 30, 6)) > 1) {
$column_data{description} =
- qq|
| |;
+ qq| | |;
} else {
$column_data{description} =
- qq| | |;
+ qq| | |;
}
+ (my $qty_dec) = ($form->{"qty_$i"} =~ /\.(\d+)/);
+ $qty_dec = length $qty_dec;
+
$column_data{qty} =
- qq|format_amount(\%myconfig, $form->{"qty_$i"},0).qq|> | |;
+ qq|format_amount(\%myconfig, $form->{"qty_$i"}, $qty_dec) .qq|>|;
+ if ($form->{formel}) {
+ $column_data{qty} .= qq|
+ | |;
+ }
$column_data{ship} =
qq|format_amount(\%myconfig, $form->{"ship_$i"})
. qq|> | |;
- $column_data{unit} =
- qq| | |;
+ my $is_part = $form->{"inventory_accno_$i"};
+ my $is_assigned = $form->{"id_$i"};
+ my $this_unit = $form->{"unit_$i"};
+ if ($form->{"selected_unit_$i"} && $this_unit &&
+ $all_units->{$form->{"selected_unit_$i"}} && $all_units->{$this_unit} &&
+ ($all_units->{$form->{"selected_unit_$i"}}->{"base_unit"} eq $all_units->{$this_unit}->{"base_unit"})) {
+ $this_unit = $form->{"selected_unit_$i"};
+ } elsif (!$is_assigned ||
+ ($is_part && !$this_unit && ($all_units->{$this_unit} && ($all_units->{$this_unit}->{"base_unit"} eq $all_units->{"kg"}->{"base_unit"})))) {
+ $this_unit = "kg";
+ }
+ $column_data{"unit"} = "" .
+ ($qty_readonly ? " " :
+ AM->unit_select_html($is_part ? $dimension_units :
+ $is_assigned ? $service_units : $all_units,
+ "unit_$i", $this_unit,
+ $is_assigned ? $form->{"unit_$i"} : undef))
+ . " | ";
- #print (STDERR "io.pl---111-i-$i", Dumper($form->{PRICES}));
# build in dragdrop for pricesgroups
if ($form->{"prices_$i"}) {
- print STDERR " YES prices\n";
- $price_tmp = $form->format_amount(\%myconfig, $form->{"price_new_$i"}, 2);
+ if ($form->{"new_pricegroup_$i"} != $form->{"old_pricegroup_$i"}) {
+ $price_tmp = $form->format_amount(\%myconfig, $form->{"price_new_$i"}, $decimalplaces);
+ } else {
+ $price_tmp = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces);
+ }
$column_data{sellprice_drag} =
qq| | |;
$column_data{sellprice} =
- qq| | |;
+ qq| | |;
} else {
- print STDERR " NO prices\n";
+
# for last row and report
# set pricegroup dragdrop from report menu
if ($form->{"sellprice_$i"} != 0) {
-print STDERR " HIER NOCH FÜR RECHNUNGSAUFRUFE\n";
-print (STDERR "sellprice_$i ", Dumper($form->{"sellprice_$i"}), " pricegroup_id_$i ", Dumper($form->{"pricegroup_id_$i"}));
$prices =
- qq|\n|;
+ qq|\n|;
$form->{"pricegroup_old_$i"} = $form->{"pricegroup_id_$i"};
$column_data{sellprice_drag} =
qq| | |;
- }else {
- # for last row
- $column_data{sellprice_drag} =
- qq|format_amount(\%myconfig, $form->{"prices_$i"},
- $decimalplaces)
- . qq|> | |;
- }
+ } else {
+
+ # for last row
+ $column_data{sellprice_drag} =
+ qq|format_amount(\%myconfig, $form->{"prices_$i"},
+ $decimalplaces)
+ . qq|> | |;
+ }
+ print(STDERR "Sellprice vor Ausgabe: ",$form->{"sellprice_$i"},"\n");
$column_data{sellprice} =
- qq|format_amount(\%myconfig, $form->{"sellprice_$i"},
$decimalplaces)
. qq|> | |;
}
-#print (STDERR "io.pl---555-i-$i", Dumper($form->{"price_old_$i"}));
$column_data{discount} =
qq|format_amount(\%myconfig, $form->{"discount_$i"})
@@ -328,9 +395,10 @@ print (STDERR "sellprice_$i ", Dumper($form->{"sellprice_$i"}), " pricegroup_i
#
# $column_data{projectnr} = qq| | | |;
############## ENDE Neueintrag ##################
-
+ my $j = $i % 2;
print qq|
- |;
+
+
|;
map { print "\n$column_data{$_}" } @column_index;
@@ -342,7 +410,9 @@ print (STDERR "sellprice_$i ", Dumper($form->{"sellprice_$i"}), " pricegroup_i
{"pricegroup_old_$i"}>
{"price_old_$i"}>
-format_amount(\%myconfig,$form->{"price_new_$i"}).qq|>
+
+format_amount(\%myconfig, $form->{"price_new_$i"}) . qq|>
{"id_$i"}>
{"inventory_accno_$i"}>
@@ -354,6 +424,12 @@ print (STDERR "sellprice_$i ", Dumper($form->{"sellprice_$i"}), " pricegroup_i
+
+
+
+
+
+
|;
@@ -363,7 +439,7 @@ print (STDERR "sellprice_$i ", Dumper($form->{"sellprice_$i"}), " pricegroup_i
########################################
# print second row
print qq|
-
+
|;
if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") {
@@ -390,6 +466,19 @@ print (STDERR "sellprice_$i ", Dumper($form->{"sellprice_$i"}), " pricegroup_i
$projectnumber
+|;
+ if ($form->{type} eq 'invoice' or $form->{type} =~ /order/) {
+ my $reqdate_term =
+ ($form->{type} eq 'invoice')
+ ? 'deliverydate'
+ : 'reqdate'; # invoice uses a different term for the same thing.
+ print qq|
+ ${$reqdate_term}
+|;
+ }
+ my $subtotalchecked = ($form->{"subtotal_$i"}) ? "checked" : "";
+ print qq|
+ |.$locale->text('Subtotal').qq|
|
@@ -419,33 +508,40 @@ sub set_pricegroup {
my $rowcount = shift;
$lxdebug->enter_sub();
for $j (1 .. $rowcount) {
-
my $pricegroup_old = $form->{"pricegroup_old_$i"};
- if ($form->{PRICES}{ $j }) {
+ if ($form->{PRICES}{$j}) {
$len = 0;
$prices = '';
- $price = 0;
- foreach $item (@{ $form->{PRICES}{ $j } }) {
-# print STDERR "-VOR PREIS--$item->{price}--PREISGRUOP-$item->{pricegroup_id}\n";
- $price = $form->round_amount($myconfig, $item->{price},5);
- $price = $form->format_amount($myconfig, $item->{price},2);
+ $price = 0;
+ foreach $item (@{ $form->{PRICES}{$j} }) {
+
+ #$price = $form->round_amount($myconfig, $item->{price}, 5);
+ #$price = $form->format_amount($myconfig, $item->{price}, 2);
$price = $item->{price};
-# print STDERR "-NACH PREIS--$price--PREISGRUOP-$item->{pricegroup_id}\n";
$pricegroup_id = $item->{pricegroup_id};
$pricegroup = $item->{pricegroup};
+
# build dragdrop for pricegroups
$prices .=
- qq|\n|;
+ qq|\n|;
$len += 1;
-# print STDERR "prices---$prices\n";
+
+ # map {
+ # $form->{"${_}_$j"} =
+ # $form->format_amount(\%myconfig, $form->{"${_}_$j"})
+ # } qw(sellprice price_new price_old);
+
# set new selectedpricegroup_id and prices for "Preis"
- if ($item->{selected}) {
+ if ($item->{selected} && ($pricegroup_id != 0)) {
$form->{"pricegroup_old_$j"} = $pricegroup_id;
- $form->{"price_new_$j"} = $price;
- $form->{"sellprice_$j"} = $price;
+ $form->{"price_new_$j"} = $price;
+ $form->{"sellprice_$j"} = $price;
+ }
+ if ($pricegroup_id == 0) {
+ $form->{"price_new_$j"} = $form->{"sellprice_$j"};
}
- if ($len >= 1) {
+ if ($len > 1) {
$form->{"prices_$j"} = $prices;
}
}
@@ -456,7 +552,6 @@ sub set_pricegroup {
sub select_item {
$lxdebug->enter_sub();
-print STDERR "io.pl-select_item\n";
@column_index = qw(ndx partnumber description onhand sellprice);
$column_data{ndx} = qq| | |;
@@ -508,11 +603,10 @@ print STDERR "io.pl-select_item\n";
}
map { $ref->{$_} =~ s/\"/"/g } qw(partnumber description unit);
-#sk tradediscount
-print STDERR "TRADEDISCOUNT $ref->{sellprice}\n";
+
+ #sk tradediscount
$ref->{sellprice} =
$form->round_amount($ref->{sellprice} * (1 - $form->{tradediscount}), 2);
-print STDERR "TRADEDISCOUNT $ref->{sellprice}\n";
$column_data{ndx} =
qq| | |;
$column_data{partnumber} =
@@ -548,6 +642,12 @@ print STDERR "TRADEDISCOUNT $ref->{sellprice}\n";
+
+
+
+
+
+
{id}>
@@ -594,7 +694,7 @@ print STDERR "TRADEDISCOUNT $ref->{sellprice}\n";
sub item_selected {
$lxdebug->enter_sub();
-print STDERR "io.pl-item_selected\n";
+
# replace the last row with the checked row
$i = $form->{rowcount};
$i = $form->{assembly_rows} if ($form->{item} eq 'assembly');
@@ -610,7 +710,10 @@ print STDERR "io.pl-item_selected\n";
$sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"});
map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} }
- qw(id partnumber description sellprice listprice inventory_accno income_accno expense_accno bin unit weight assembly taxaccounts partsgroup);
+ qw(id partnumber description sellprice listprice inventory_accno income_accno expense_accno bin unit weight assembly taxaccounts partsgroup formel alu longdescription not_discountable adr_description);
+ if ($form->{"part_payment_id_$i"} ne "") {
+ $form->{payment_id} = $form->{"part_payment_id_$i"};
+ }
if ($lizenzen) {
map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} } qw(lizenzen);
@@ -637,6 +740,10 @@ print STDERR "io.pl-item_selected\n";
$form->{sellprice} += ($form->{"sellprice_$i"} * $form->{"qty_$i"});
$form->{weight} += ($form->{"weight_$i"} * $form->{"qty_$i"});
+
+ if ($form->{"not_discountable_$i"}) {
+ $form->{"discount_$i"} = 0;
+ }
$amount =
$form->{"sellprice_$i"} * (1 - $form->{"discount_$i"} / 100) *
@@ -669,7 +776,7 @@ print STDERR "io.pl-item_selected\n";
IS->get_pricegroups_for_parts(\%myconfig, \%$form);
# build up html code for prices_$i
- set_pricegroup();
+ set_pricegroup($form->{rowcount});
&display_form;
@@ -746,50 +853,54 @@ sub new_item {
sub display_form {
$lxdebug->enter_sub();
+ $form->language_payment(\%myconfig);
# if we have a display_form
if ($form->{display_form}) {
&{"$form->{display_form}"};
exit;
}
- if ( $form->{print_and_post}
- && $form->{second_run}
- && ($form->{action} eq "display_form")) {
- for (keys %$form) { $old_form->{$_} = $form->{$_} }
- $old_form->{rowcount}++;
-
- #$form->{rowcount}--;
- #$form->{rowcount}--;
-
- $form->{print_and_post} = 0;
-
- &print_form($old_form);
- exit;
- }
-
- $form->{action} = "";
- $form->{resubmit} = 0;
- if ($form->{print_and_post} && !$form->{second_run}) {
- $form->{second_run} = 1;
- $form->{action} = "display_form";
- $form->{rowcount}--;
- my $rowcount = $form->{rowcount};
- # get pricegroups for parts
- IS->get_pricegroups_for_parts(\%myconfig, \%$form, "new");
- # build up html code for prices_$i
- set_pricegroup($rowcount);
-
-
- $form->{resubmit} = 1;
-
- }
+ # if ( $form->{print_and_post}
+ # && $form->{second_run}
+ # && ($form->{action} eq "display_form")) {
+ # for (keys %$form) { $old_form->{$_} = $form->{$_} }
+ # $old_form->{rowcount}++;
+ #
+ # #$form->{rowcount}--;
+ # #$form->{rowcount}--;
+ #
+ # $form->{print_and_post} = 0;
+ #
+ # &print_form($old_form);
+ # exit;
+ # }
+ #
+ # $form->{action} = "";
+ # $form->{resubmit} = 0;
+ #
+ # if ($form->{print_and_post} && !$form->{second_run}) {
+ # $form->{second_run} = 1;
+ # $form->{action} = "display_form";
+ # $form->{rowcount}--;
+ # my $rowcount = $form->{rowcount};
+ #
+ # # get pricegroups for parts
+ # IS->get_pricegroups_for_parts(\%myconfig, \%$form);
+ #
+ # # build up html code for prices_$i
+ # set_pricegroup($rowcount);
+ #
+ # $form->{resubmit} = 1;
+ #
+ # }
&form_header;
$numrows = ++$form->{rowcount};
$subroutine = "display_row";
if ($form->{item} eq 'part') {
+
#set preisgruppenanzahl
$numrows = $form->{price_rows};
$subroutine = "price_row";
@@ -800,7 +911,7 @@ sub display_form {
$subroutine = "makemodel_row";
}
if ($form->{item} eq 'assembly') {
- $numrows = ++$form->{price_rows};
+ $numrows = $form->{price_rows};
$subroutine = "price_row";
&{$subroutine}($numrows);
@@ -815,7 +926,7 @@ sub display_form {
$subroutine = "assembly_row";
}
if ($form->{item} eq 'service') {
- $numrows = ++$form->{price_rows};
+ $numrows = $form->{price_rows};
$subroutine = "price_row";
&{$subroutine}($numrows);
@@ -833,13 +944,13 @@ sub display_form {
sub check_form {
$lxdebug->enter_sub();
-print STDERR "io.pl-check_form\n";
my @a = ();
my $count = 0;
my @flds = (
- qw(id partnumber description qty ship sellprice unit discount inventory_accno income_accno expense_accno listprice taxaccounts bin assembly weight projectnumber project_id oldprojectnumber runningnumber serialnumber partsgroup)
+ qw(id partnumber description qty ship sellprice unit discount inventory_accno income_accno expense_accno listprice taxaccounts bin assembly weight projectnumber project_id oldprojectnumber runningnumber serialnumber partsgroup payment_id not_discountable shop ve gv buchungsgruppen_id adr_id language_values)
);
+
# remove any makes or model rows
if ($form->{item} eq 'part') {
map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) }
@@ -936,17 +1047,20 @@ print STDERR "io.pl-check_form\n";
}
}
-
- #sk
+
+ #sk
# if pricegroups
- if ($form->{type} =~ (/sales_quotation/) or (($form->{level} =~ /Sales/) and ($form->{type} =~ /invoice/)) or (($form->{level} eq undef) and ($form->{type} =~ /invoice/)) or ($form->{type} =~ /sales_order/)) {
-
- # get pricegroups for parts
- IS->get_pricegroups_for_parts(\%myconfig, \%$form);
+ if ( $form->{type} =~ (/sales_quotation/)
+ or (($form->{level} =~ /Sales/) and ($form->{type} =~ /invoice/))
+ or (($form->{level} eq undef) and ($form->{type} =~ /invoice/))
+ or ($form->{type} =~ /sales_order/)) {
+
+ # get pricegroups for parts
+ IS->get_pricegroups_for_parts(\%myconfig, \%$form);
+
+ # build up html code for prices_$i
+ set_pricegroup($form->{rowcount});
- # build up html code for prices_$i
- set_pricegroup();
-
}
&display_form;
@@ -994,7 +1108,7 @@ sub invoicetotal {
sub validate_items {
$lxdebug->enter_sub();
-print STDERR "io.pl-validate_items\n";
+
# check if items are valid
if ($form->{rowcount} == 1) {
&update;
@@ -1017,7 +1131,6 @@ sub order {
$form->{ordnumber} = $form->{invnumber};
map { delete $form->{$_} } qw(id printed emailed queued);
-
if ($form->{script} eq 'ir.pl' || $form->{type} eq 'request_quotation') {
$form->{title} = $locale->text('Add Purchase Order');
$form->{vc} = 'vendor';
@@ -1036,7 +1149,6 @@ sub order {
$form->{rowcount}--;
- ($null, $form->{cp_id}) = split /--/, $form->{contact};
$form->{cp_id} *= 1;
require "$form->{path}/$form->{script}";
@@ -1084,7 +1196,6 @@ sub quotation {
$buysell = 'buy';
}
- ($null, $form->{cp_id}) = split /--/, $form->{contact};
$form->{cp_id} *= 1;
$form->{script} = 'oe.pl';
@@ -1122,7 +1233,7 @@ sub e_mail {
$lxdebug->enter_sub();
if ($form->{second_run}) {
$form->{print_and_post} = 0;
- $form->{resubmit} = 0;
+ $form->{resubmit} = 0;
}
if ($myconfig{role} eq 'admin') {
$bcc = qq|
@@ -1235,12 +1346,11 @@ sub send_email {
sub print_options {
$lxdebug->enter_sub();
-print STDERR "io.pl-print_options\n";
$form->{sendmode} = "attachment";
$form->{copies} = 3 unless $form->{copies};
$form->{PD}{ $form->{formname} } = "selected";
- $form->{DF}{ $form->{format} } = "";
+ $form->{DF}{ $form->{format} } = "selected";
$form->{OP}{ $form->{media} } = "selected";
$form->{SM}{ $form->{sendmode} } = "selected";
@@ -1252,26 +1362,57 @@ print STDERR "io.pl-print_options\n";
. $locale->text('Bin List');
}
+ if ($form->{type} eq 'credit_note') {
+ $type = qq|