X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fio.pl;h=0fe78fd2a0e542287804aa79973daaaf7574283b;hb=342c174c0207e8d5d0ea0bd9b5eb7dc17c87d7b2;hp=c6b6df21de7cd2c7aba20c82aa06401f79f85272;hpb=4dbb09950c9f5596646537c12d991c99086fe7c1;p=kivitendo-erp.git diff --git a/bin/mozilla/io.pl b/bin/mozilla/io.pl index c6b6df21d..0fe78fd2a 100644 --- a/bin/mozilla/io.pl +++ b/bin/mozilla/io.pl @@ -41,10 +41,9 @@ if (-f "$form->{path}/$form->{login}_io.pl") { eval { require "$form->{path}/$form->{login}_io.pl"; }; } - 1; -# end of main +# end of main # this is for our long dates # $locale->text('January') @@ -73,6 +72,8 @@ if (-f "$form->{path}/$form->{login}_io.pl") { # $locale->text('Oct') # $locale->text('Nov') # $locale->text('Dec') +use SL::IS; +use SL::PE; use Data::Dumper; ######################################## # Eintrag fuer Version 2.2.0 geaendert # @@ -81,60 +82,107 @@ use Data::Dumper; sub display_row { $lxdebug->enter_sub(); my $numrows = shift; + if ($lizenzen && $form->{vc} eq "customer") { + if ($form->{type} =~ /sales_order/) { + @column_index = (runningnumber, partnumber, description, ship, qty); + } elsif ($form->{type} =~ /sales_quotation/) { + @column_index = (runningnumber, partnumber, description, qty); + } else { + @column_index = (runningnumber, partnumber, description, qty); + } + } else { + if ( ($form->{type} =~ /purchase_order/) + || ($form->{type} =~ /sales_order/)) { + @column_index = (runningnumber, partnumber, description, ship, qty); + } else { + @column_index = (runningnumber, partnumber, description, qty); + } + } +############## ENDE Neueintrag ################## + push @column_index, qw(unit); -if ($lizenzen && $form->{vc} eq "customer") { - if ($form->{type} =~ /sales_order/) { - @column_index = (runningnumber, partnumber, description, ship, qty); - } - elsif ($form->{type} =~ /sales_quotation/){ - @column_index = (runningnumber, partnumber, description, qty); - } - else { - @column_index = (runningnumber, partnumber, description, qty); - } -} -else { - if (($form->{type} =~ /purchase_order/) || ($form->{type} =~ /sales_order/)) { - @column_index = (runningnumber, partnumber, description, ship, qty); - } - else { - @column_index = (runningnumber, partnumber, description, qty); + #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/)) { + push @column_index, qw(sellprice_drag); } -} -############## ENDE Neueintrag ################## - push @column_index, qw(unit sellprice); + push @column_index, qw(sellprice); if ($form->{vc} eq 'customer') { push @column_index, qw(discount); } - + push @column_index, "linetotal"; my $colspan = $#column_index + 1; - $form->{invsubtotal} = 0; map { $form->{"${_}_base"} = 0 } (split / /, $form->{taxaccounts}); ######################################## -# Eintrag fuer Version 2.2.0 geaendert # -# neue Optik im Rechnungsformular # + # Eintrag fuer Version 2.2.0 geaendert # + # neue Optik im Rechnungsformular # ######################################## - $column_data{runningnumber} = qq||.$locale->text('No.').qq||; - $column_data{partnumber} = qq||.$locale->text('Number').qq||; - $column_data{description} = qq||.$locale->text('Part Description').qq||; - $column_data{ship} = qq||.$locale->text('Ship').qq||; - $column_data{qty} = qq||.$locale->text('Qty').qq||; - $column_data{unit} = qq||.$locale->text('Unit').qq||; - $column_data{license} = qq||.$locale->text('License').qq||; - $column_data{serialnr} = qq||.$locale->text('Serial No.').qq||; - $column_data{projectnr} = qq||.$locale->text('Project').qq||; - $column_data{sellprice} = qq||.$locale->text('Price').qq||; - $column_data{discount} = qq||.$locale->text('Discount').qq||; - $column_data{linetotal} = qq||.$locale->text('Extended').qq||; - $column_data{bin} = qq||.$locale->text('Bin').qq||; + $column_data{runningnumber} = + qq|| + . $locale->text('No.') + . qq||; + $column_data{partnumber} = + qq|| + . $locale->text('Number') + . qq||; + $column_data{description} = + qq|| + . $locale->text('Part Description') + . qq||; + $column_data{ship} = + qq|| + . $locale->text('Ship') + . qq||; + $column_data{qty} = + qq|| + . $locale->text('Qty') + . qq||; + $column_data{unit} = + qq|| + . $locale->text('Unit') + . qq||; + $column_data{license} = + qq|| + . $locale->text('License') + . qq||; + $column_data{serialnr} = + qq|| + . $locale->text('Serial No.') + . qq||; + $column_data{projectnr} = + qq|| + . $locale->text('Project') + . qq||; + $column_data{sellprice} = + qq|| + . $locale->text('Price') + . qq||; + $column_data{sellprice_drag} = + qq|| + . $locale->text('Pricegroup') + . qq||; + $column_data{discount} = + qq|| + . $locale->text('Discount') + . qq||; + $column_data{linetotal} = + qq|| + . $locale->text('Extended') + . qq||; + $column_data{bin} = + qq|| + . $locale->text('Bin') + . qq||; ############## ENDE Neueintrag ################## print qq| @@ -149,88 +197,153 @@ else { |; - $runningnumber = $locale->text('No.'); - $deliverydate = $locale->text('Delivery Date'); - $serialnumber = $locale->text('Serial No.'); + $deliverydate = $locale->text('Delivery Date'); + $serialnumber = $locale->text('Serial No.'); $projectnumber = $locale->text('Project'); - $partsgroup = $locale->text('Group'); + $partsgroup = $locale->text('Group'); $delvar = 'deliverydate'; - + if ($form->{type} =~ /_order$/ || $form->{type} =~ /_quotation$/) { $deliverydate = $locale->text('Required by'); - $delvar = 'reqdate'; + $delvar = 'reqdate'; } - for $i (1 .. $numrows) { + # undo formatting - map { $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) } qw(qty ship discount sellprice); - + map { + $form->{"${_}_$i"} = + $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) + } qw(qty ship discount sellprice price_new price_old); ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); - $dec = length $dec; + $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; - - $discount = $form->round_amount($form->{"sellprice_$i"} * $form->{"discount_$i"}/100, $decimalplaces); - $linetotal = $form->round_amount($form->{"sellprice_$i"} - $discount, $decimalplaces); + + $discount = + $form->round_amount( + $form->{"sellprice_$i"} * $form->{"discount_$i"} / 100, + $decimalplaces); + + $linetotal = + $form->round_amount($form->{"sellprice_$i"} - $discount, $decimalplaces); $linetotal = $form->round_amount($linetotal * $form->{"qty_$i"}, 2); # convert " to " - map { $form->{"${_}_$i"} =~ s/\"/"/g } qw(partnumber description unit); + map { $form->{"${_}_$i"} =~ s/\"/"/g } + qw(partnumber description unit); ######################################## -# Eintrag fuer Version 2.2.0 geaendert # -# neue Optik im Rechnungsformular # + # Eintrag fuer Version 2.2.0 geaendert # + # neue Optik im Rechnungsformular # ######################################## - $column_data{runningnumber} = qq||; # HuT + $column_data{runningnumber} = + qq||; # HuT ############## ENDE Neueintrag ################## - - $column_data{partnumber} = qq||; + + $column_data{partnumber} = + qq||; if (($rows = $form->numtextrows($form->{"description_$i"}, 30, 6)) > 1) { - $column_data{description} = qq||; + $column_data{description} = + qq||; } else { - $column_data{description} = qq||; + $column_data{description} = + qq||; } - $column_data{qty} = qq|format_amount(\%myconfig, $form->{"qty_$i"}).qq|>|; - $column_data{ship} = qq|format_amount(\%myconfig, $form->{"ship_$i"}).qq|>|; - $column_data{unit} = qq||; - $column_data{sellprice} = qq|format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces).qq|>|; - $column_data{discount} = qq|format_amount(\%myconfig, $form->{"discount_$i"}).qq|>|; - $column_data{linetotal} = qq||.$form->format_amount(\%myconfig, $linetotal, 2).qq||; - $column_data{bin} = qq|$form->{"bin_$i"}|; + $column_data{qty} = + qq|format_amount(\%myconfig, $form->{"qty_$i"}, 0) + . qq|>|; + $column_data{ship} = + qq|format_amount(\%myconfig, $form->{"ship_$i"}) + . qq|>|; + $column_data{unit} = + qq||; + + # build in dragdrop for pricesgroups + if ($form->{"prices_$i"}) { + $price_tmp = + $form->format_amount(\%myconfig, $form->{"price_new_$i"}, 2); + + $column_data{sellprice_drag} = + qq||; + $column_data{sellprice} = + qq||; + } else { + + # for last row and report + # set pricegroup dragdrop from report menu + if ($form->{"sellprice_$i"} != 0) { + $prices = + 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|>|; + } + + $column_data{sellprice} = + qq|format_amount(\%myconfig, $form->{"sellprice_$i"}, + $decimalplaces) + . qq|>|; + } + $column_data{discount} = + qq|format_amount(\%myconfig, $form->{"discount_$i"}) + . qq|>|; + $column_data{linetotal} = + qq|| + . $form->format_amount(\%myconfig, $linetotal, 2) + . qq||; + $column_data{bin} = qq|$form->{"bin_$i"}|; ######################################## -# Eintrag fuer Version 2.2.0 geaendert # -# neue Optik im Rechnungsformular # -######################################## -# if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") { -# $column_data{license} = qq||; -# } -# -# if ($form->{type} !~ /_quotation/) { -# $column_data{serialnr} = qq||; -# } -# -# $column_data{projectnr} = qq||; + # Eintrag fuer Version 2.2.0 geaendert # + # neue Optik im Rechnungsformular # +######################################## + # if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") { + # $column_data{license} = qq||; + # } + # + # if ($form->{type} !~ /_quotation/) { + # $column_data{serialnr} = qq||; + # } + # + # $column_data{projectnr} = qq||; ############## ENDE Neueintrag ################## - print qq| |; map { print "\n$column_data{$_}" } @column_index; - + print qq| {"orderitems_id_$i"}> {"bo_$i"}> +{"pricegroup_old_$i"}> +{"price_old_$i"}> +format_amount(\%myconfig, $form->{"price_new_$i"}) . qq|> + {"id_$i"}> {"inventory_accno_$i"}> @@ -245,19 +358,20 @@ else { |; ######################################## -# Eintrag fuer Version 2.2.0 geaendert # -# neue Optik im Rechnungsformular # -######################################## + # Eintrag fuer Version 2.2.0 geaendert # + # neue Optik im Rechnungsformular # +######################################## # print second row print qq| |; - if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") { + if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") { my $selected = $form->{"licensenumber_$i"}; my $lizenzen_quoted; $form->{"lizenzen_$i"} =~ s/ selected//g; - $form->{"lizenzen_$i"} =~ s/value="${selected}"\>/value="${selected}" selected\>/; + $form->{"lizenzen_$i"} =~ + s/value="${selected}"\>/value="${selected}" selected\>/; $lizenzen_quoted = $form->{"lizenzen_$i"}; $lizenzen_quoted =~ s/\"/"/g; print qq| @@ -283,9 +397,9 @@ else { ############## ENDE Neueintrag ################## + map { $form->{"${_}_base"} += $linetotal } + (split / /, $form->{"taxaccounts_$i"}); - map { $form->{"${_}_base"} += $linetotal } (split / /, $form->{"taxaccounts_$i"}); - $form->{invsubtotal} += $linetotal; } @@ -298,26 +412,68 @@ else { $lxdebug->leave_sub(); } +################################################## +# build html-code for pricegroups in variable $form->{prices_$j} + +sub set_pricegroup { + my $rowcount = shift; + $lxdebug->enter_sub(); + for $j (1 .. $rowcount) { + + my $pricegroup_old = $form->{"pricegroup_old_$i"}; + if ($form->{PRICES}{$j}) { + $len = 0; + $prices = ''; + $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}; + $pricegroup_id = $item->{pricegroup_id}; + $pricegroup = $item->{pricegroup}; + + # build dragdrop for pricegroups + $prices .= + qq|\n|; + + $len += 1; + + # set new selectedpricegroup_id and prices for "Preis" + if ($item->{selected}) { + $form->{"pricegroup_old_$j"} = $pricegroup_id; + $form->{"price_new_$j"} = $price; + $form->{"sellprice_$j"} = $price; + } + if ($len >= 1) { + $form->{"prices_$j"} = $prices; + } + } + } + } + + #print (STDERR "HIER", Dumper($prices) ); + $lxdebug->leave_sub(); +} sub select_item { $lxdebug->enter_sub(); - @column_index = qw(ndx partnumber description onhand sellprice); - $column_data{ndx} = qq| |; - $column_data{partnumber} = qq||.$locale->text('Number').qq||; - $column_data{description} = qq||.$locale->text('Part Description').qq||; - $column_data{sellprice} = qq||.$locale->text('Price').qq||; - $column_data{onhand} = qq||.$locale->text('Qty').qq||; - - + $column_data{ndx} = qq| |; + $column_data{partnumber} = + qq|| . $locale->text('Number') . qq||; + $column_data{description} = + qq|| . $locale->text('Part Description') . qq||; + $column_data{sellprice} = + qq|| . $locale->text('Price') . qq||; + $column_data{onhand} = + qq|| . $locale->text('Qty') . qq||; + # list items with radio button on a form $form->header; - $title = $locale->text('Select from one of the items below'); + $title = $locale->text('Select from one of the items below'); $colspan = $#column_index + 1; - - print qq| @@ -332,36 +488,47 @@ sub select_item { |; map { print "\n$column_data{$_}" } @column_index; - + print qq||; my $i = 0; foreach $ref (@{ $form->{item_list} }) { $checked = ($i++) ? "" : "checked"; - + if ($lizenzen) { - if ($ref->{inventory_accno} > 0) { - $ref->{"lizenzen"} = qq||; - foreach $item (@{ $form->{LIZENZEN}{$ref->{"id"}}}) { - $ref->{"lizenzen"} .= qq||; - } - $ref->{"lizenzen"} .= qq||; - $ref->{"lizenzen"} =~ s/\"/"/g; + if ($ref->{inventory_accno} > 0) { + $ref->{"lizenzen"} = qq||; + foreach $item (@{ $form->{LIZENZEN}{ $ref->{"id"} } }) { + $ref->{"lizenzen"} .= + qq||; } + $ref->{"lizenzen"} .= qq||; + $ref->{"lizenzen"} =~ s/\"/"/g; + } } - map { $ref->{$_} =~ s/\"/"/g } qw(partnumber description unit); - $ref->{sellprice} = $form->round_amount($ref->{sellprice} * (1 - $form->{tradediscount}), 2); - - $column_data{ndx} = qq||; - $column_data{partnumber} = qq|$ref->{partnumber}|; - $column_data{description} = qq|$ref->{description}|; - $column_data{sellprice} = qq|{sellprice}>|.$form->format_amount(\%myconfig, $ref->{sellprice}, 2, " ").qq||; - $column_data{onhand} = qq|{onhand}>|.$form->format_amount(\%myconfig, $ref->{onhand}, '', " ").qq||; - - $j++; $j %= 2; + #sk tradediscount + $ref->{sellprice} = + $form->round_amount($ref->{sellprice} * (1 - $form->{tradediscount}), 2); + $column_data{ndx} = + qq||; + $column_data{partnumber} = + qq|$ref->{partnumber}|; + $column_data{description} = + qq|$ref->{description}|; + $column_data{sellprice} = + qq|{sellprice}>| + . $form->format_amount(\%myconfig, $ref->{sellprice}, 2, " ") + . qq||; + $column_data{onhand} = + qq|{onhand}>| + . $form->format_amount(\%myconfig, $ref->{onhand}, '', " ") + . qq||; + + $j++; + $j %= 2; print qq| |; @@ -384,14 +551,14 @@ sub select_item { {id}> |; - if ($lizenzen) { - print qq| + if ($lizenzen) { + print qq| |; - } + } } - + print qq|
@@ -402,7 +569,7 @@ sub select_item { # delete action variable map { delete $form->{$_} } qw(action item_list header); - + # save all other form variables foreach $key (keys %${form}) { $form->{$key} =~ s/\"/"/g; @@ -413,7 +580,8 @@ sub select_item {
- + @@ -423,8 +591,6 @@ sub select_item { $lxdebug->leave_sub(); } - - sub item_selected { $lxdebug->enter_sub(); @@ -435,70 +601,93 @@ sub item_selected { # index for new item $j = $form->{ndx}; + #sk + #($form->{"sellprice_$i"},$form->{"$pricegroup_old_$i"}) = split /--/, $form->{"sellprice_$i"}; + #$form->{"sellprice_$i"} = $form->{"sellprice_$i"}; + # if there was a price entered, override it $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); - + + map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} } + qw(id partnumber description sellprice listprice inventory_accno income_accno expense_accno bin unit weight assembly taxaccounts partsgroup); + if ($lizenzen) { - map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} } qw(lizenzen); + map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} } qw(lizenzen); } ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); - $dec = length $dec; + $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; if ($sellprice) { $form->{"sellprice_$i"} = $sellprice; } else { + # if there is an exchange rate adjust sellprice if (($form->{exchangerate} * 1) != 0) { $form->{"sellprice_$i"} /= $form->{exchangerate}; - $form->{"sellprice_$i"} = $form->round_amount($form->{"sellprice_$i"}, $decimalplaces); + $form->{"sellprice_$i"} = + $form->round_amount($form->{"sellprice_$i"}, $decimalplaces); } } - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(sellprice listprice weight); + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + qw(sellprice listprice weight); $form->{sellprice} += ($form->{"sellprice_$i"} * $form->{"qty_$i"}); - $form->{weight} += ($form->{"weight_$i"} * $form->{"qty_$i"}); + $form->{weight} += ($form->{"weight_$i"} * $form->{"qty_$i"}); - $amount = $form->{"sellprice_$i"} * (1 - $form->{"discount_$i"} / 100) * $form->{"qty_$i"}; - map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"}); - map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{"taxaccounts_$i"} if !$form->{taxincluded}; + $amount = + $form->{"sellprice_$i"} * (1 - $form->{"discount_$i"} / 100) * + $form->{"qty_$i"}; + map { $form->{"${_}_base"} += $amount } + (split / /, $form->{"taxaccounts_$i"}); + map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, + $form->{"taxaccounts_$i"} + if !$form->{taxincluded}; $form->{creditremaining} -= $amount; $form->{"runningnumber_$i"} = $i; - + # delete all the new_ variables for $i (1 .. $form->{lastndx}) { - map { delete $form->{"new_${_}_$i"} } qw(partnumber description sellprice bin listprice inventory_accno income_accno expense_accno unit assembly taxaccounts id); + map { delete $form->{"new_${_}_$i"} } + qw(partnumber description sellprice bin listprice inventory_accno income_accno expense_accno unit assembly taxaccounts id); } - + map { delete $form->{$_} } qw(ndx lastndx nextsub); # format amounts - map { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}, $decimalplaces) } qw(sellprice listprice) if $form->{item} ne 'assembly'; + map { + $form->{"${_}_$i"} = + $form->format_amount(\%myconfig, $form->{"${_}_$i"}, $decimalplaces) + } qw(sellprice listprice) if $form->{item} ne 'assembly'; + + # get pricegroups for parts + IS->get_pricegroups_for_parts(\%myconfig, \%$form); + + # build up html code for prices_$i + set_pricegroup($form->{rowcount}); &display_form; - + $lxdebug->leave_sub(); } - sub new_item { $lxdebug->enter_sub(); # change callback - $form->{old_callback} = $form->escape($form->{callback},1); - $form->{callback} = $form->escape("$form->{script}?action=display_form",1); + $form->{old_callback} = $form->escape($form->{callback}, 1); + $form->{callback} = $form->escape("$form->{script}?action=display_form", 1); # delete action delete $form->{action}; # save all other form variables in a previousform variable foreach $key (keys %$form) { + # escape ampersands $form->{$key} =~ s/&/%26/g; $previousform .= qq|$key=$form->{$key}&|; @@ -514,20 +703,21 @@ sub new_item { print qq| -

|.$locale->text('Item not on file!').qq| +

| . $locale->text('Item not on file!') . qq|

-|.$locale->text('What type of item is this?').qq|

+| . $locale->text('What type of item is this?') . qq|

-  |.$locale->text('Part') -.qq|
-  |.$locale->text('Service') +  | + . $locale->text('Part') . qq|
+  | + . $locale->text('Service') -.qq| + . qq| @@ -542,7 +732,8 @@ sub new_item {

- +

@@ -552,69 +743,116 @@ sub new_item { $lxdebug->leave_sub(); } - - sub display_form { $lxdebug->enter_sub(); # if we have a display_form if ($form->{display_form}) { - &{ "$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); + + # build up html code for prices_$i + set_pricegroup($rowcount); + + $form->{resubmit} = 1; + + } &form_header; - $numrows = ++$form->{rowcount}; + $numrows = ++$form->{rowcount}; $subroutine = "display_row"; if ($form->{item} eq 'part') { - $numrows = ++$form->{makemodel_rows}; + + #set preisgruppenanzahl + $numrows = $form->{price_rows}; + $subroutine = "price_row"; + + &{$subroutine}($numrows); + + $numrows = ++$form->{makemodel_rows}; $subroutine = "makemodel_row"; } if ($form->{item} eq 'assembly') { - $numrows = ++$form->{makemodel_rows}; + $numrows = ++$form->{price_rows}; + $subroutine = "price_row"; + + &{$subroutine}($numrows); + + $numrows = ++$form->{makemodel_rows}; $subroutine = "makemodel_row"; - + # create makemodel rows - &{ $subroutine }($numrows); + &{$subroutine}($numrows); - $numrows = ++$form->{assembly_rows}; + $numrows = ++$form->{assembly_rows}; $subroutine = "assembly_row"; } if ($form->{item} eq 'service') { + $numrows = ++$form->{price_rows}; + $subroutine = "price_row"; + + &{$subroutine}($numrows); + $numrows = 0; } # create rows - &{ $subroutine }($numrows) if $numrows; + &{$subroutine}($numrows) if $numrows; &form_footer; $lxdebug->leave_sub(); } - - sub check_form { $lxdebug->enter_sub(); - - my @a = (); + 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)); + 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) + ); # remove any makes or model rows if ($form->{item} eq 'part') { - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(listprice sellprice lastcost weight rop); - + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + qw(listprice sellprice lastcost weight rop); + @flds = (make, model); for my $i (1 .. ($form->{makemodel_rows})) { if (($form->{"make_$i"} ne "") || ($form->{"model_$i"} ne "")) { - push @a, {}; - my $j = $#a; + push @a, {}; + my $j = $#a; - map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; - $count++; + map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; + $count++; } } @@ -624,42 +862,46 @@ sub check_form { } elsif ($form->{item} eq 'assembly') { $form->{sellprice} = 0; - $form->{weight} = 0; - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(listprice rop stock); + $form->{weight} = 0; + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + qw(listprice rop stock); + + @flds = + qw(id qty unit bom partnumber description sellprice weight runningnumber partsgroup); - @flds = qw(id qty unit bom partnumber description sellprice weight runningnumber partsgroup); - for my $i (1 .. ($form->{assembly_rows} - 1)) { if ($form->{"qty_$i"}) { - push @a, {}; - my $j = $#a; + push @a, {}; + my $j = $#a; $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"}); - map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; + map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; - $form->{sellprice} += ($form->{"qty_$i"} * $form->{"sellprice_$i"}); - $form->{weight} += ($form->{"qty_$i"} * $form->{"weight_$i"}); - $count++; + #($form->{"sellprice_$i"},$form->{"$pricegroup_old_$i"}) = split /--/, $form->{"sellprice_$i"}; + + $form->{sellprice} += ($form->{"qty_$i"} * $form->{"sellprice_$i"}); + $form->{weight} += ($form->{"qty_$i"} * $form->{"weight_$i"}); + $count++; } } $form->{sellprice} = $form->round_amount($form->{sellprice}, 2); - + $form->redo_rows(\@flds, \@a, $count, $form->{assembly_rows}); $form->{assembly_rows} = $count; - + $count = 0; - @flds = qw(make model); - @a = (); - + @flds = qw(make model); + @a = (); + for my $i (1 .. ($form->{makemodel_rows})) { if (($form->{"make_$i"} ne "") || ($form->{"model_$i"} ne "")) { - push @a, {}; - my $j = $#a; + push @a, {}; + my $j = $#a; - map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; - $count++; + map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; + $count++; } } @@ -672,188 +914,221 @@ sub check_form { # remove any empty numbers if ($form->{rowcount}) { for my $i (1 .. $form->{rowcount} - 1) { - if ($form->{"partnumber_$i"}) { - push @a, {}; - my $j = $#a; - - map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; - $count++; - if ($lizenzen) { - if ($form->{"licensenumber_$i"} == -1) { - &new_license($i); - exit; - } - } - } + if ($form->{"partnumber_$i"}) { + push @a, {}; + my $j = $#a; + + map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; + $count++; + if ($lizenzen) { + if ($form->{"licensenumber_$i"} == -1) { + &new_license($i); + exit; + } + } + } } - + $form->redo_rows(\@flds, \@a, $count, $form->{rowcount}); $form->{rowcount} = $count; $form->{creditremaining} -= &invoicetotal; - + } } + #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); + + # build up html code for prices_$i + set_pricegroup($form->{rowcount}); + + } + &display_form; $lxdebug->leave_sub(); } - sub invoicetotal { $lxdebug->enter_sub(); $form->{oldinvtotal} = 0; + # add all parts and deduct paid map { $form->{"${_}_base"} = 0 } split / /, $form->{taxaccounts}; my ($amount, $sellprice, $discount, $qty); - + for my $i (1 .. $form->{rowcount}) { $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); - $discount = $form->parse_amount(\%myconfig, $form->{"discount_$i"}); - $qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}); + $discount = $form->parse_amount(\%myconfig, $form->{"discount_$i"}); + $qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}); + + #($form->{"sellprice_$i"}, $form->{"$pricegroup_old_$i"}) = split /--/, $form->{"sellprice_$i"}; $amount = $sellprice * (1 - $discount / 100) * $qty; - map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"}); + map { $form->{"${_}_base"} += $amount } + (split / /, $form->{"taxaccounts_$i"}); $form->{oldinvtotal} += $amount; } - map { $form->{oldinvtotal} += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{taxaccounts} if !$form->{taxincluded}; - + map { $form->{oldinvtotal} += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } + split / /, $form->{taxaccounts} + if !$form->{taxincluded}; + $form->{oldtotalpaid} = 0; for $i (1 .. $form->{paidaccounts}) { $form->{oldtotalpaid} += $form->{"paid_$i"}; } - + $lxdebug->leave_sub(); # return total return ($form->{oldinvtotal} - $form->{oldtotalpaid}); } - sub validate_items { $lxdebug->enter_sub(); - + # check if items are valid if ($form->{rowcount} == 1) { &update; exit; } - + for $i (1 .. $form->{rowcount} - 1) { - $form->isblank("partnumber_$i", $locale->text('Number missing in Row') . " $i"); + $form->isblank("partnumber_$i", + $locale->text('Number missing in Row') . " $i"); } $lxdebug->leave_sub(); } - sub order { $lxdebug->enter_sub(); - + if ($form->{second_run}) { + $form->{print_and_post} = 0; + } $form->{ordnumber} = $form->{invnumber}; - - map { delete $form->{$_} } qw(id printed emailed queued); - + 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'; - $form->{type} = 'purchase_order'; - $buysell = 'sell'; + $form->{vc} = 'vendor'; + $form->{type} = 'purchase_order'; + $buysell = 'sell'; } if ($form->{script} eq 'is.pl' || $form->{type} eq 'sales_quotation') { $form->{title} = $locale->text('Add Sales Order'); - $form->{vc} = 'customer'; - $form->{type} = 'sales_order'; - $buysell = 'buy'; + $form->{vc} = 'customer'; + $form->{type} = 'sales_order'; + $buysell = 'buy'; } $form->{script} = 'oe.pl'; $form->{shipto} = 1; - + $form->{rowcount}--; - + ($null, $form->{cp_id}) = split /--/, $form->{contact}; $form->{cp_id} *= 1; - + require "$form->{path}/$form->{script}"; map { $form->{"select$_"} = "" } ($form->{vc}, currency); - + $currency = $form->{currency}; &order_links; - $form->{currency} = $currency; + $form->{currency} = $currency; $form->{exchangerate} = ""; - $form->{forex} = ""; - $form->{exchangerate} = $exchangerate if ($form->{forex} = ($exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{transdate}, $buysell))); - + $form->{forex} = ""; + $form->{exchangerate} = $exchangerate + if ( + $form->{forex} = ( + $exchangerate = + $form->check_exchangerate( + \%myconfig, $form->{currency}, $form->{transdate}, $buysell + ))); + &prepare_order; &display_form; $lxdebug->leave_sub(); } - sub quotation { $lxdebug->enter_sub(); - + if ($form->{second_run}) { + $form->{print_and_post} = 0; + } map { delete $form->{$_} } qw(id printed emailed queued); - + if ($form->{script} eq 'ir.pl' || $form->{type} eq 'purchase_order') { $form->{title} = $locale->text('Add Request for Quotation'); - $form->{vc} = 'vendor'; - $form->{type} = 'request_quotation'; - $buysell = 'sell'; + $form->{vc} = 'vendor'; + $form->{type} = 'request_quotation'; + $buysell = 'sell'; } if ($form->{script} eq 'is.pl' || $form->{type} eq 'sales_order') { $form->{title} = $locale->text('Add Quotation'); - $form->{vc} = 'customer'; - $form->{type} = 'sales_quotation'; - $buysell = 'buy'; + $form->{vc} = 'customer'; + $form->{type} = 'sales_quotation'; + $buysell = 'buy'; } - + ($null, $form->{cp_id}) = split /--/, $form->{contact}; $form->{cp_id} *= 1; - + $form->{script} = 'oe.pl'; $form->{shipto} = 1; - + $form->{rowcount}--; require "$form->{path}/$form->{script}"; map { $form->{"select$_"} = "" } ($form->{vc}, currency); - + $currency = $form->{currency}; - + &order_links; - $form->{currency} = $currency; + $form->{currency} = $currency; $form->{exchangerate} = ""; - $form->{forex} = ""; - $form->{exchangerate} = $exchangerate if ($form->{forex} = ($exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{transdate}, $buysell))); - + $form->{forex} = ""; + $form->{exchangerate} = $exchangerate + if ( + $form->{forex} = ( + $exchangerate = + $form->check_exchangerate( + \%myconfig, $form->{currency}, $form->{transdate}, $buysell + ))); + &prepare_order; &display_form; $lxdebug->leave_sub(); } - - sub e_mail { $lxdebug->enter_sub(); - + if ($form->{second_run}) { + $form->{print_and_post} = 0; + $form->{resubmit} = 0; + } if ($myconfig{role} eq 'admin') { $bcc = qq| - |.$locale->text('Bcc').qq| + | . $locale->text('Bcc') . qq| |; } @@ -862,13 +1137,13 @@ sub e_mail { $form->{email} = $form->{shiptoemail} if $form->{shiptoemail}; } - $name = $form->{$form->{vc}}; + $name = $form->{ $form->{vc} }; $name =~ s/--.*//g; - $title = $locale->text('E-mail')." $name"; - + $title = $locale->text('E-mail') . " $name"; + $form->{oldmedia} = $form->{media}; - $form->{media} = "email"; - + $form->{media} = "email"; + $form->header; print qq| @@ -885,13 +1160,13 @@ sub e_mail { - + - + - + $bcc @@ -902,7 +1177,7 @@ sub e_mail { + |; } - + if ($form->{emailed} =~ /$form->{formname}/) { print qq| - + |; } - + if ($form->{queued} =~ /$form->{formname}/) { print qq| - + |; } - + print qq|
|.$locale->text('To').qq|| . $locale->text('To') . qq| |.$locale->text('Cc').qq|| . $locale->text('Cc') . qq|
|.$locale->text('Subject').qq|| . $locale->text('Subject') . qq|
- + @@ -915,9 +1190,10 @@ sub e_mail { |; &print_options; - - map { delete $form->{$_} } qw(action email cc bcc subject message formname sendmode format header override); - + + map { delete $form->{$_} } + qw(action email cc bcc subject message formname sendmode format header override); + # save all other variables foreach $key (keys %$form) { $form->{$key} =~ s/\"/"/g; @@ -935,7 +1211,8 @@ sub e_mail {
- + @@ -945,83 +1222,89 @@ sub e_mail { $lxdebug->leave_sub(); } - sub send_email { $lxdebug->enter_sub(); $old_form = new Form; - + map { $old_form->{$_} = $form->{$_} } keys %$form; $old_form->{media} = $form->{oldmedia}; - + &print_form($old_form); - + $lxdebug->leave_sub(); } - - sub print_options { $lxdebug->enter_sub(); - $form->{sendmode} = "attachment"; - $form->{copies} = 3 unless $form->{copies}; - - $form->{PD}{$form->{formname}} = "selected"; - $form->{DF}{$form->{format}} = ""; - $form->{OP}{$form->{media}} = "selected"; - $form->{SM}{$form->{sendmode}} = "selected"; - - + $form->{copies} = 3 unless $form->{copies}; + + $form->{PD}{ $form->{formname} } = "selected"; + $form->{DF}{ $form->{format} } = ""; + $form->{OP}{ $form->{media} } = "selected"; + $form->{SM}{ $form->{sendmode} } = "selected"; + if ($form->{type} eq 'purchase_order') { $type = qq| - |; - %lang = (de=>"deutsch", en=>"englisch", fr=>"französisch"); + %lang = (de => "deutsch", en => "englisch", fr => "französisch"); foreach $item (keys %lang) { if ($form->{language} eq $item) { $language .= qq||; @@ -1060,7 +1344,7 @@ sub print_options { if ($myconfig{printer} && $latex && $form->{media} ne 'email') { print qq| - |; } @@ -1068,7 +1352,7 @@ sub print_options { $form->{groupitems} = "checked" if $form->{groupitems}; print qq| - +
|.$locale->text('Message').qq|| . $locale->text('Message') . qq|
|.$locale->text('Copies').qq| + | . $locale->text('Copies') . qq| {copies}>|.$locale->text('Group Items').qq|| . $locale->text('Group Items') . qq| {groupitems}>
@@ -1080,22 +1364,22 @@ sub print_options { if ($form->{printed} =~ /$form->{formname}/) { print qq| -
\||.$locale->text('Printed').qq|\|\|| . $locale->text('Printed') . qq|\|\||.$locale->text('E-mailed').qq|\|\|| . $locale->text('E-mailed') . qq|\|\||.$locale->text('Queued').qq|\|\|| . $locale->text('Queued') . qq|\|
@@ -1104,18 +1388,19 @@ sub print_options { |; - $lxdebug->leave_sub(); } - - sub print { $lxdebug->enter_sub(); + if ($form->{second_run}) { + $form->{print_and_post} = 0; + } # if this goes to the printer pass through if ($form->{media} eq 'printer' || $form->{media} eq 'queue') { - $form->error($locale->text('Select postscript or PDF!')) if ($form->{format} !~ /(postscript|pdf)/); + $form->error($locale->text('Select postscript or PDF!')) + if ($form->{format} !~ /(postscript|pdf)/); $old_form = new Form; map { $old_form->{$_} = $form->{$_} } keys %$form; @@ -1126,37 +1411,38 @@ sub print { $lxdebug->leave_sub(); } - sub print_form { $lxdebug->enter_sub(); my ($old_form) = @_; - - $inv = "inv"; - $due = "due"; - + + $inv = "inv"; + $due = "due"; $numberfld = "invnumber"; - $display_form = ($form->{display_form}) ? $form->{display_form} : "display_form"; + $display_form = + ($form->{display_form}) ? $form->{display_form} : "display_form"; # $form->{"notes"} will be overridden by the customer's/vendor's "notes" field. So save it here. - $form->{$form->{"formname"} . "notes"} = $form->{"notes"}; + $form->{ $form->{"formname"} . "notes" } = $form->{"notes"}; if ($form->{formname} eq "invoice") { $form->{label} = $locale->text('Invoice'); } if ($form->{formname} eq "packing_list") { + # this is from an invoice $form->{label} = $locale->text('Packing List'); } if ($form->{formname} eq 'sales_order') { - $inv = "ord"; - $due = "req"; + $inv = "ord"; + $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{label} = $locale->text('Sales Order'); - $numberfld = "sonumber"; - $order = 1; + $form->{label} = $locale->text('Sales Order'); + $numberfld = "sonumber"; + $order = 1; } if ($form->{formname} eq 'packing_list' && $form->{type} ne 'invoice') { + # we use the same packing list as from an invoice $inv = "ord"; $due = "req"; @@ -1165,63 +1451,73 @@ sub print_form { $order = 1; } if ($form->{formname} eq 'pick_list') { - $inv = "ord"; - $due = "req"; - $form->{"${inv}date"} = ($form->{transdate}) ? $form->{transdate} : $form->{invdate}; + $inv = "ord"; + $due = "req"; + $form->{"${inv}date"} = + ($form->{transdate}) ? $form->{transdate} : $form->{invdate}; $form->{label} = $locale->text('Pick List'); $order = 1 unless $form->{type} eq 'invoice'; } if ($form->{formname} eq 'purchase_order') { - $inv = "ord"; - $due = "req"; + $inv = "ord"; + $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{label} = $locale->text('Purchase Order'); - $numberfld = "ponumber"; - $order = 1; + $form->{label} = $locale->text('Purchase Order'); + $numberfld = "ponumber"; + $order = 1; } if ($form->{formname} eq 'bin_list') { - $inv = "ord"; - $due = "req"; + $inv = "ord"; + $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{label} = $locale->text('Bin List'); - $order = 1; + $form->{label} = $locale->text('Bin List'); + $order = 1; } if ($form->{formname} eq 'sales_quotation') { - $inv = "quo"; - $due = "req"; + $inv = "quo"; + $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{label} = $locale->text('Quotation'); - $numberfld = "sqnumber"; - $order = 1; + $form->{label} = $locale->text('Quotation'); + $numberfld = "sqnumber"; + $order = 1; } if ($form->{formname} eq 'request_quotation') { - $inv = "quo"; - $due = "req"; + $inv = "quo"; + $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{label} = $locale->text('Quotation'); - $numberfld = "rfqnumber"; - $order = 1; + $form->{label} = $locale->text('Quotation'); + $numberfld = "rfqnumber"; + $order = 1; } - $form->isblank("email", $locale->text('E-mail address missing!')) if ($form->{media} eq 'email'); - $form->isblank("${inv}date", $locale->text($form->{label} .' Date missing!')); - -# $locale->text('Invoice Number missing!') -# $locale->text('Invoice Date missing!') -# $locale->text('Packing List Number missing!') -# $locale->text('Packing List Date missing!') -# $locale->text('Order Number missing!') -# $locale->text('Order Date missing!') -# $locale->text('Quotation Number missing!') -# $locale->text('Quotation Date missing!') + $form->isblank("email", $locale->text('E-mail address missing!')) + if ($form->{media} eq 'email'); + $form->isblank("${inv}date", + $locale->text($form->{label} . ' Date missing!')); + # $locale->text('Invoice Number missing!') + # $locale->text('Invoice Date missing!') + # $locale->text('Packing List Number missing!') + # $locale->text('Packing List Date missing!') + # $locale->text('Order Number missing!') + # $locale->text('Order Date missing!') + # $locale->text('Quotation Number missing!') + # $locale->text('Quotation Date missing!') # assign number - if (! $form->{"${inv}number"}) { + if (!$form->{"${inv}number"} && !$form->{preview}) { $form->{"${inv}number"} = $form->update_defaults(\%myconfig, $numberfld); if ($form->{media} ne 'email') { + + # get pricegroups for parts + IS->get_pricegroups_for_parts(\%myconfig, \%$form); + + # build up html code for prices_$i + set_pricegroup($form->{rowcount}); + $form->{rowcount}--; - &{ "$display_form" }; + + &{"$display_form"}; exit; } } @@ -1229,49 +1525,54 @@ sub print_form { &validate_items; # Save the email address given in the form because it should override the setting saved for the customer/vendor. - my ($saved_email, $saved_cc, $saved_bcc) = ($form->{"email"}, $form->{"cc"}, $form->{"bcc"}); - + my ($saved_email, $saved_cc, $saved_bcc) = + ($form->{"email"}, $form->{"cc"}, $form->{"bcc"}); + $language = $form->{language}; - &{ "$form->{vc}_details" }; + &{"$form->{vc}_details"}; $form->{language} = $language; - + $form->{"email"} = $saved_email if ($saved_email); - $form->{"cc"} = $saved_cc if ($saved_cc); - $form->{"bcc"} = $saved_bcc if ($saved_bcc); - + $form->{"cc"} = $saved_cc if ($saved_cc); + $form->{"bcc"} = $saved_bcc if ($saved_bcc); + @a = (); foreach $i (1 .. $form->{rowcount}) { - push @a, ("partnumber_$i", "description_$i", "partsgroup_$i", "serialnumber_$i", "bin_$i", "unit_$i"); + push @a, + ("partnumber_$i", "description_$i", + "partsgroup_$i", "serialnumber_$i", + "bin_$i", "unit_$i"); } map { push @a, "${_}_description" } split / /, $form->{taxaccounts}; $ARAP = ($form->{vc} eq 'customer') ? "AR" : "AP"; push @a, $ARAP; - + # format payment dates for $i (1 .. $form->{paidaccounts} - 1) { $form->{"datepaid_$i"} = $locale->date(\%myconfig, $form->{"datepaid_$i"}); push @a, "${ARAP}_paid_$i", "source_$i", "memo_$i"; } - + $form->format_string(@a); - + ($form->{employee}) = split /--/, $form->{employee}; ($form->{warehouse}, $form->{warehouse_id}) = split /--/, $form->{warehouse}; - + # create the form variables if ($order) { OE->order_details(\%myconfig, \%$form); } else { IS->invoice_details(\%myconfig, \%$form, $locale); } - - map { $form->{$_} = $locale->date(\%myconfig, $form->{$_}, 1) } ("${inv}date", "${due}date", "shippingdate"); - - + + map { $form->{$_} = $locale->date(\%myconfig, $form->{$_}, 1) } + ("${inv}date", "${due}date", "shippingdate"); + @a = qw(name street zipcode city country); - + $shipto = 1; + # if there is no shipto fill it in from billto foreach $item (@a) { if ($form->{"shipto$item"}) { @@ -1281,10 +1582,11 @@ sub print_form { } if ($shipto) { - if ($form->{formname} eq 'purchase_order' || $form->{formname} eq 'request_quotation') { - $form->{shiptoname} = $myconfig{company}; - $form->{shiptostreet} = $myconfig{address}; - } else { + if ( $form->{formname} eq 'purchase_order' + || $form->{formname} eq 'request_quotation') { + $form->{shiptoname} = $myconfig{company}; + $form->{shiptostreet} = $myconfig{address}; + } else { map { $form->{"shipto$_"} = $form->{$_} } @a; } } @@ -1292,19 +1594,18 @@ sub print_form { $form->{notes} =~ s/^\s+//g; # some of the stuff could have umlauts so we translate them - push @a, qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptoemail shippingpoint shipvia company address signature employee contact); - + push @a, + qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptoemail shippingpoint shipvia company address signature employee contact); push @a, ("${inv}date", "${due}date", email, cc, bcc); $form->format_string(@a); - $form->{templates} = "$myconfig{templates}"; if ($form->{language} ne "") { - $form->{language} = "_".$form->{language}; + $form->{language} = "_" . $form->{language}; } - + $form->{IN} = "$form->{formname}$form->{language}.html"; if ($form->{format} eq 'postscript') { $form->{postscript} = 1; @@ -1321,22 +1622,22 @@ sub print_form { $form->{printed} =~ s/^ //; } $printed = $form->{printed}; - + if ($form->{media} eq 'email') { - $form->{subject} = qq|$form->{label} $form->{"${inv}number"}| unless $form->{subject}; - + $form->{subject} = qq|$form->{label} $form->{"${inv}number"}| + unless $form->{subject}; + $form->{OUT} = "$sendmail"; - + $form->{emailed} .= " $form->{formname}"; $form->{emailed} =~ s/^ //; } $emailed = $form->{emailed}; - if ($form->{media} eq 'queue') { %queued = split / /, $form->{queued}; - - if ($filename = $queued{$form->{formname}}) { + + if ($filename = $queued{ $form->{formname} }) { $form->{queued} =~ s/$form->{formname} $filename//; unlink "$spool/$filename"; $filename =~ s/\..*$//g; @@ -1345,10 +1646,9 @@ sub print_form { $filename .= $$; } - $filename .= ($form->{postscript}) ? '.ps' : '.pdf'; $form->{OUT} = ">$spool/$filename"; - + # add type $form->{queued} .= " $form->{formname} $filename"; @@ -1356,7 +1656,6 @@ sub print_form { } $queued = $form->{queued}; - $form->parse_template(\%myconfig, $userspath); $form->{callback} = ""; @@ -1365,51 +1664,58 @@ sub print_form { $form->{message} = $locale->text('sent') unless $form->{message}; } $message = $form->{message}; - + # if we got back here restore the previous form if ($form->{media} =~ /(printer|email|queue)/) { - $form->update_status(\%myconfig) if ($form->{media} eq 'queue' && $form->{id}); - + $form->update_status(\%myconfig) + if ($form->{media} eq 'queue' && $form->{id}); + if ($old_form) { - + $old_form->{"${inv}number"} = $form->{"${inv}number"}; - + # restore and display form map { $form->{$_} = $old_form->{$_} } keys %$old_form; - - $form->{queued} = $queued; + + $form->{queued} = $queued; $form->{printed} = $printed; $form->{emailed} = $emailed; $form->{message} = $message; $form->{rowcount}--; - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); - + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + qw(exchangerate creditlimit creditremaining); + for $i (1 .. $form->{paidaccounts}) { - map { $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) } qw(paid exchangerate); + map { + $form->{"${_}_$i"} = + $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) + } qw(paid exchangerate); } - - &{ "$display_form" }; + + &{"$display_form"}; exit; } - $msg = ($form->{media} eq 'printer') ? $locale->text('sent to printer') : $locale->text('emailed to')." $form->{email}"; + $msg = + ($form->{media} eq 'printer') + ? $locale->text('sent to printer') + : $locale->text('emailed to') . " $form->{email}"; $form->redirect(qq|$form->{label} $form->{"${inv}number"} $msg|); + } else { + &{"$display_form"}; } $lxdebug->leave_sub(); } - sub customer_details { $lxdebug->enter_sub(); - - IS->customer_details(\%myconfig, \%$form); + IS->customer_details(\%myconfig, \%$form); $lxdebug->leave_sub(); } - sub vendor_details { $lxdebug->enter_sub(); @@ -1418,31 +1724,42 @@ sub vendor_details { $lxdebug->leave_sub(); } - sub post_as_new { $lxdebug->enter_sub(); $form->{postasnew} = 1; map { delete $form->{$_} } qw(printed emailed queued); - + &post; $lxdebug->leave_sub(); } - sub ship_to { $lxdebug->enter_sub(); + if ($form->{second_run}) { + $form->{print_and_post} = 0; + } $title = $form->{title}; $form->{title} = $locale->text('Ship to'); - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + qw(exchangerate creditlimit creditremaining); # get details for name - &{ "$form->{vc}_details" }; + &{"$form->{vc}_details"}; + + $number = + ($form->{vc} eq 'customer') + ? $locale->text('Customer Number') + : $locale->text('Vendor Number'); + + # get pricegroups for parts + IS->get_pricegroups_for_parts(\%myconfig, \%$form); - $number = ($form->{vc} eq 'customer') ? $locale->text('Customer Number') : $locale->text('Vendor Number'); + # build up html code for prices_$i + set_pricegroup($form->{rowcount}); $nextsub = ($form->{display_form}) ? $form->{display_form} : "display_form"; @@ -1460,8 +1777,10 @@ sub ship_to { - - + + @@ -1469,47 +1788,47 @@ sub ship_to { - + - + - + - + - + - + - + - + - + @@ -1522,9 +1841,10 @@ sub ship_to { |; # delete shipto - map { delete $form->{$_} } qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail header); + map { delete $form->{$_} } + qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail header); $form->{title} = $title; - + foreach $key (keys %$form) { $form->{$key} =~ s/\"/"/g; print qq|\n|; @@ -1535,7 +1855,8 @@ sub ship_to {

- + @@ -1545,24 +1866,25 @@ sub ship_to { $lxdebug->leave_sub(); } - sub new_license { $lxdebug->enter_sub(); - + my $row = shift; # change callback - $form->{old_callback} = $form->escape($form->{callback},1); - $form->{callback} = $form->escape("$form->{script}?action=display_form",1); - $form->{old_callback} = $form->escape($form->{old_callback},1); + $form->{old_callback} = $form->escape($form->{callback}, 1); + $form->{callback} = $form->escape("$form->{script}?action=display_form", 1); + $form->{old_callback} = $form->escape($form->{old_callback}, 1); + # delete action delete $form->{action}; $customer = $form->{customer}; - map { $form->{"old_$_"} = $form->{"${_}_$row"} } qw(partnumber description); + map { $form->{"old_$_"} = $form->{"${_}_$row"} } qw(partnumber description); # save all other form variables in a previousform variable $form->{row} = $row; foreach $key (keys %$form) { + # escape ampersands $form->{$key} =~ s/&/%26/g; $previousform .= qq|$key=$form->{$key}&|; @@ -1571,16 +1893,14 @@ sub new_license { $previousform = $form->escape($previousform, 1); $form->{script} = "licenses.pl"; - - - map { $form->{$_} = $form->{"old_$_"} } qw(partnumber description); - map { $form->{$_} = $form->escape($form->{$_},1) } qw(partnumber description); - $form->{callback} = qq|$form->{script}?login=$form->{login}&path=$form->{path}&password=$form->{password}&action=add&vc=$form->{db}&$form->{db}_id=$form->{id}&$form->{db}=$name&type=$form->{type}&customer=$customer&partnumber=$form->{partnumber}&description=$form->{description}&previousform="$previousform"&initial=1|; + map { $form->{$_} = $form->{"old_$_"} } qw(partnumber description); + map { $form->{$_} = $form->escape($form->{$_}, 1) } + qw(partnumber description); + $form->{callback} = + qq|$form->{script}?login=$form->{login}&path=$form->{path}&password=$form->{password}&action=add&vc=$form->{db}&$form->{db}_id=$form->{id}&$form->{db}=$name&type=$form->{type}&customer=$customer&partnumber=$form->{partnumber}&description=$form->{description}&previousform="$previousform"&initial=1|; $form->redirect; $lxdebug->leave_sub(); } - -
|.$locale->text('Billing Address').qq||.$locale->text('Shipping Address').qq|| + . $locale->text('Billing Address') . qq|| + . $locale->text('Shipping Address') . qq|
$form->{"$form->{vc}number"}
|.$locale->text('Company Name').qq|| . $locale->text('Company Name') . qq| $form->{name}
|.$locale->text('Street').qq|| . $locale->text('Street') . qq| $form->{street}
|.$locale->text('Zipcode').qq|| . $locale->text('Zipcode') . qq| $form->{zipcode}
|.$locale->text('City').qq|| . $locale->text('City') . qq| $form->{city}
|.$locale->text('Country').qq|| . $locale->text('Country') . qq| $form->{country}
|.$locale->text('Contact').qq|| . $locale->text('Contact') . qq| $form->{contact}
|.$locale->text('Phone').qq|| . $locale->text('Phone') . qq| $form->{"$form->{vc}phone"}
|.$locale->text('Fax').qq|| . $locale->text('Fax') . qq| $form->{"$form->{vc}fax"}
|.$locale->text('E-mail').qq|| . $locale->text('E-mail') . qq| $form->{email}