X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fio.pl;h=6987c713661540f6c504791cd5e4cbabe14366f9;hb=a1e47d425a58b8342992daab4907591506949f07;hp=c6b6df21de7cd2c7aba20c82aa06401f79f85272;hpb=4dbb09950c9f5596646537c12d991c99086fe7c1;p=kivitendo-erp.git diff --git a/bin/mozilla/io.pl b/bin/mozilla/io.pl index c6b6df21d..6987c7136 100644 --- a/bin/mozilla/io.pl +++ b/bin/mozilla/io.pl @@ -33,6 +33,13 @@ # ####################################################################### +use SL::CT; +use SL::IC; +use CGI::Ajax; +use CGI; + +require "$form->{path}/common.pl"; + # any custom scripts for this one if (-f "$form->{path}/custom_io.pl") { eval { require "$form->{path}/custom_io.pl"; }; @@ -41,10 +48,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 +79,9 @@ if (-f "$form->{path}/$form->{login}_io.pl") { # $locale->text('Oct') # $locale->text('Nov') # $locale->text('Dec') +use SL::IS; +use SL::PE; +use SL::AM; use Data::Dumper; ######################################## # Eintrag fuer Version 2.2.0 geaendert # @@ -82,64 +91,134 @@ 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); + 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 sellprice); + 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/)) { + push @column_index, qw(sellprice_pg); + } + + 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||; + if ($form->{"type"} eq "purchase_order") { + $column_data{ship} = + qq|| + . $locale->text('Ship rcvd') + . qq||; + } else { + $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_pg} = + 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 ################## + $myconfig{"show_form_details"} = 1 + unless (defined($myconfig{"show_form_details"})); + $form->{"show_details"} = $myconfig{"show_form_details"} + unless (defined($form->{"show_details"})); + $form->{"show_details"} = $form->{"show_details"} ? 1 : 0; + my $show_details_new = 1 - $form->{"show_details"}; + my $show_details_checked = $form->{"show_details"} ? "checked" : ""; + print qq| + + +
|; @@ -149,115 +228,250 @@ 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'); + $reqdate = $locale->text('Reqdate'); $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) 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; + $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 unit_old); ######################################## -# 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||; - $column_data{ship} = qq||; - $column_data{unit} = qq||; - $column_data{sellprice} = qq||; - $column_data{discount} = qq||; - $column_data{linetotal} = qq||; - $column_data{bin} = qq||; + (my $qty_dec) = ($form->{"qty_$i"} =~ /\.(\d+)/); + $qty_dec = length $qty_dec; + $column_data{qty} = + qq||; + } + $column_data{ship} = + 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"} = ""; + + # build in drop down list for pricesgroups + if ($form->{"prices_$i"}) { + 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_pg} = + qq||; + $column_data{sellprice} = + qq||; + } else { + + # for last row and report + # set pricegroup drop down list from report menu + if ($form->{"sellprice_$i"} != 0) { + $prices = + qq|\n|; + + $form->{"pricegroup_old_$i"} = $form->{"pricegroup_id_$i"}; + + $column_data{sellprice_pg} = + qq||; + + } else { + + # for last row + $column_data{sellprice_pg} = qq||; + } + + $column_data{sellprice} = + qq||; + } + $column_data{discount} = + qq||; + $column_data{linetotal} = + qq||; + $column_data{bin} = 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||; + # 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 ################## - - + my $j = $i % 2; 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"}> - +{"income_accno_$i"}> {"expense_accno_$i"}> + + + + + |; ######################################## -# Eintrag fuer Version 2.2.0 geaendert # -# neue Optik im Rechnungsformular # -######################################## + # Eintrag fuer Version 2.2.0 geaendert # + # neue Optik im Rechnungsformular # +######################################## + + my $row_style_attr = + 'style="display:none;"' if (!$form->{"show_details"}); + # print second row print qq| - + @@ -283,9 +510,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 +525,73 @@ else { $lxdebug->leave_sub(); } +################################################## +# build html-code for pricegroups in variable $form->{prices_$j} -sub select_item { +sub set_pricegroup { $lxdebug->enter_sub(); - - @column_index = qw(ndx partnumber description onhand sellprice); + my $rowcount = shift; + 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 drop down list for pricegroups + $prices .= + qq|\n|; + + $len += 1; + + # 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} && ($pricegroup_id != 0)) { + $form->{"pricegroup_old_$j"} = $pricegroup_id; + $form->{"price_new_$j"} = $price; + $form->{"sellprice_$j"} = $price; + } + if ($pricegroup_id == 0) { + $form->{"price_new_$j"} = $form->{"sellprice_$j"}; + } + } + $form->{"prices_$j"} = $prices; + } + } + $lxdebug->leave_sub(); +} - $column_data{ndx} = qq||; - $column_data{partnumber} = qq||; - $column_data{description} = qq||; - $column_data{sellprice} = qq||; - $column_data{onhand} = qq||; - - +sub select_item { + $lxdebug->enter_sub(); + @column_index = qw(ndx partnumber description onhand unit sellprice); + + $column_data{ndx} = qq||; + $column_data{partnumber} = + qq||; + $column_data{description} = + qq||; + $column_data{sellprice} = + qq||; + $column_data{onhand} = + qq||; + $column_data{unit} = + 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 +606,48 @@ 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||; - $column_data{description} = qq||; - $column_data{sellprice} = qq||; - $column_data{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||; + $column_data{description} = + qq||; + $column_data{sellprice} = + qq||; + $column_data{onhand} = + qq||; + $column_data{unit} = + qq||; + $j++; + $j %= 2; print qq| |; @@ -380,18 +666,23 @@ sub select_item { + + + + +{id}> |; - if ($lizenzen) { - print qq| + if ($lizenzen) { + print qq| |; - } + } } - + print qq|
format_amount(\%myconfig, $form->{"qty_$i"}).qq|>format_amount(\%myconfig, $form->{"ship_$i"}).qq|>format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces).qq|>format_amount(\%myconfig, $form->{"discount_$i"}).qq|>|.$form->format_amount(\%myconfig, $linetotal, 2).qq|$form->{"bin_$i"}format_amount(\%myconfig, $form->{"qty_$i"}, $qty_dec) .qq|>|; + if ($form->{"formel_$i"}) { + $column_data{qty} .= qq| + format_amount(\%myconfig, $form->{"ship_$i"}) + . qq|>" . + ($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)) + . " format_amount(\%myconfig, $form->{"sellprice_$i"}, + $decimalplaces) + . qq|>format_amount(\%myconfig, $form->{"discount_$i"}) + . qq|>| + . $form->format_amount(\%myconfig, $linetotal, 2) + . qq|$form->{"bin_$i"}
|; - 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| @@ -276,6 +490,19 @@ else { $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| 
 |.$locale->text('Number').qq||.$locale->text('Part Description').qq||.$locale->text('Price').qq||.$locale->text('Qty').qq| | . $locale->text('Number') . qq|| . $locale->text('Part Description') . qq|| . $locale->text('Price') . qq|| . $locale->text('Qty') . qq|| . $locale->text('Unit') . qq|
$ref->{partnumber}$ref->{description}{sellprice}>|.$form->format_amount(\%myconfig, $ref->{sellprice}, 2, " ").qq|{onhand}>|.$form->format_amount(\%myconfig, $ref->{onhand}, '', " ").qq|$ref->{partnumber}$ref->{description}{sellprice}>| + . $form->format_amount(\%myconfig, $ref->{sellprice}, 2, " ") + . qq|{onhand}>| + . $form->format_amount(\%myconfig, $ref->{onhand}, '', " ") + . qq|$ref->{unit}

@@ -402,7 +693,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 +704,8 @@ sub select_item {
- + @@ -423,8 +715,6 @@ sub select_item { $lxdebug->leave_sub(); } - - sub item_selected { $lxdebug->enter_sub(); @@ -435,70 +725,102 @@ 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 formel longdescription not_discountable partnotes); + 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); + 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"}); + + if ($form->{"not_discountable_$i"}) { + $form->{"discount_$i"} = 0; + } - $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 +836,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 +865,8 @@ sub new_item {

- +

@@ -552,69 +876,122 @@ sub new_item { $lxdebug->leave_sub(); } - - sub display_form { $lxdebug->enter_sub(); + relink_accounts(); + + $form->language_payment(\%myconfig); + # 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 payment_id not_discountable shop ve gv buchungsgruppen_id language_values sellprice_pg pricegroup_old price_old price_new unit_old ordnumber transdate longdescription basefactor) + ); + # 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 +1001,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_$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->{"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,189 +1053,240 @@ 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 + ))); + + for $i (1 .. $form->{rowcount}) { + map({ $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, + $form->{"${_}_${i}"}) + if ($form->{"${_}_${i}"}) } + qw(ship qty sellprice listprice basefactor)); + } + &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 + ))); + + for $i (1 .. $form->{rowcount}) { + map({ $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, + $form->{"${_}_${i}"}) + if ($form->{"${_}_${i}"}) } + qw(ship qty sellprice listprice basefactor)); + } + &prepare_order; &display_form; $lxdebug->leave_sub(); } - +sub request_for_quotation { + quotation(); +} 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,51 +1294,117 @@ sub e_mail { $form->{email} = $form->{shiptoemail} if $form->{shiptoemail}; } - $name = $form->{$form->{vc}}; + if ($form->{"cp_id"} && !$form->{"email"}) { + CT->get_contact(\%myconfig, $form); + $form->{"email"} = $form->{"cp_email"}; + } + + $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"; + + my %formname_translations = + ( + "bin_list" => $locale->text('Bin List'), + "credit_note" => $locale->text('Credit Note'), + "invoice" => $locale->text('Invoice'), + "packing_list" => $locale->text('Packing List'), + "pick_list" => $locale->text('Pick List'), + "proforma" => $locale->text('Proforma Invoice'), + "purchase_order" => $locale->text('Purchase Order'), + "request_quotation" => $locale->text('RFQ'), + "sales_order" => $locale->text('Confirmation'), + "sales_quotation" => $locale->text('Quotation'), + "storno_invoice" => $locale->text('Storno Invoice'), + "storno_packing_list" => $locale->text('Storno Packing List'), + ); + + my $attachment_filename = $formname_translations{$form->{"formname"}}; + my $prefix; + + if ($form->{"type"} =~ /invoice/) { + $prefix = "inv"; + } elsif ($form->{"type"} =~ /_quotation$/) { + $prefix = "quo"; + } else { + $prefix = "ord"; + } + + if ($attachment_filename && $form->{"${prefix}number"}) { + $attachment_filename .= "_" . $form->{"${prefix}number"} . + ($form->{"format"} =~ /pdf/i ? ".pdf" : + $form->{"format"} =~ /postscript/i ? ".ps" : + $form->{"format"} =~ /opendocument/i ? ".odt" : + $form->{"format"} =~ /html/i ? ".html" : ""); + $attachment_filename =~ s/ /_/g; + my %umlaute = + ( + "ä" => "ae", "ö" => "oe", "ü" => "ue", + "Ä" => "Ae", "Ö" => "Oe", "Ü" => "Ue", + "ß" => "ss" + ); + map({ $attachment_filename =~ s/$_/$umlaute{$_}/g; } keys(%umlaute)); + } else { + $attachment_filename = ""; + } + + if ($form->{"email"}) { + $form->{"fokus"} = "Form.subject"; + } else { + $form->{"fokus"} = "Form.email"; + } $form->header; print qq| - + -
{script}> + - - - +
$title
+ + @@ -915,27 +1413,29 @@ 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; - print qq|\n|; + print qq|\n|; } print qq| - +
$title
- - - - - - - - - - - $bcc - +
|.$locale->text('To').qq||.$locale->text('Cc').qq|
|.$locale->text('Subject').qq|
+ + + + + + + + + $bcc + + + + + + +
| . $locale->text('To') . qq|
| . $locale->text('Cc') . qq|
| . $locale->text('Subject') . qq|
| . $locale->text('Attachment name') . + qq|
- - - - - - - +
|.$locale->text('Message').qq|
+ + + + + +
| . $locale->text('Message') . qq|


- +
- +
@@ -945,122 +1445,210 @@ 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->{"format"} = + $form->{"format"} ? $form->{"format"} : + $myconfig{"template_format"} ? $myconfig{"template_format"} : + "pdf"; + + $form->{"copies"} = + $form->{"copies"} ? $form->{"copies"} : + $myconfig{"copies"} ? $myconfig{"copies"} : + 3; + + $form->{"media"} = + $form->{"media"} ? $form->{"media"} : + $myconfig{"default_media"} ? $myconfig{"default_media"} : + "screen"; + + $form->{"printer_id"} = + defined($form->{"printer_id"}) ? $form->{"printer_id"} : + $myconfig{"default_printer_id"} ? $myconfig{"default_printer_id"} : + ""; + + $form->{PD}{ $form->{formname} } = "selected"; + $form->{DF}{ $form->{format} } = "selected"; + $form->{OP}{ $form->{media} } = "selected"; + $form->{SM}{ $form->{sendmode} } = "selected"; + if ($form->{type} eq 'purchase_order') { $type = qq| + |; } - - $language = qq||; + + if (scalar(keys (%{ $form->{languages} })) !=0) { + $language_select = qq| + |; + foreach $item (@{ $form->{printers} }) { + $selected = $item->{"id"} == $form->{"printer_id"} ? "selected" : ""; + $printer_select .= qq||; } } + + print qq| + |; } - + if ($form->{emailed} =~ /$form->{formname}/) { print qq| - + |; } - + if ($form->{queued} =~ /$form->{formname}/) { print qq| - + |; } - + print qq|
- - |; + if (scalar(keys (%{ $form->{languages} })) !=0) { + print qq| + |; + } + print qq| - + |; + if (scalar(keys (%{ $form->{printers} })) !=0) { + print qq| + |; + } - if ($myconfig{printer} && $latex && $form->{media} ne 'email') { + if (scalar(keys (%{ $form->{printers} })) !=0 && $latex_templates && $form->{media} ne 'email') { print qq| - |; } @@ -1068,7 +1656,7 @@ sub print_options { $form->{groupitems} = "checked" if $form->{groupitems}; print qq| - +
$type$language + $type${language_select}$format$media$media$printer_select|.$locale->text('Copies').qq| + | . $locale->text('Copies') . qq| {copies}>|.$locale->text('Group Items').qq|| . $locale->text('Group Items') . qq| {groupitems}>
@@ -1080,22 +1668,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,124 +1692,182 @@ sub print_options { |; - $lxdebug->leave_sub(); } - - sub print { $lxdebug->enter_sub(); # 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; } + if (!$form->{id} || (($form->{formname} eq "proforma") && !$form->{proforma} && (($form->{type} =~ /_order$/) || ($form->{type} =~ /_quotation$/)))) { + if ($form->{formname} eq "proforma") { + $form->{proforma} = 1; + } + $form->{print_and_save} = 1; + my $formname = $form->{formname}; + &save(); + $form->{formname} = $formname; + &edit(); + exit; + } + &print_form($old_form); $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->{type} eq 'invoice') && ($form->{formname} eq 'proforma') ) { + $inv = "inv"; + $due = "due"; + $form->{"${inv}date"} = $form->{transdate}; + $form->{"invdate"} = $form->{transdate}; + $form->{label} = $locale->text('Proforma Invoice'); + $numberfld = "sonumber"; + $order = 0; + } + + if (($form->{type} eq 'sales_order') && ($form->{formname} eq 'proforma') ) { + $inv = "inv"; + $due = "due"; + $form->{"${inv}date"} = $form->{transdate}; + $form->{"invdate"} = $form->{transdate}; + $form->{invnumber} = $form->{ordnumber}; + $form->{label} = $locale->text('Proforma Invoice'); + $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"; $form->{invdate} = $form->{"${inv}date"} = $form->{transdate}; $form->{label} = $locale->text('Packing List'); $order = 1; + # set invnumber for template packing_list + $form->{invnumber} = $form->{ordnumber}; } 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"; + + if (($form->{type} eq 'sales_quotation') && ($form->{formname} eq 'proforma') ) { + $inv = "quo"; + $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{label} = $locale->text('Quotation'); - $numberfld = "rfqnumber"; - $order = 1; + $form->{"invdate"} = $form->{transdate}; + $form->{label} = $locale->text('Proforma Invoice'); + $numberfld = "sqnumber"; + $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!') - + if ($form->{formname} eq 'request_quotation') { + $inv = "quo"; + $due = "req"; + $form->{"${inv}date"} = $form->{transdate}; + $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}) + . ": " + . $locale->text(' 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 +1875,49 @@ 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"}); - - $language = $form->{language}; - &{ "$form->{vc}_details" }; - $form->{language} = $language; - + my ($saved_email, $saved_cc, $saved_bcc) = + ($form->{"email"}, $form->{"cc"}, $form->{"bcc"}); + + $language_saved = $form->{language_id}; + $payment_id_saved = $form->{payment_id}; + + &{"$form->{vc}_details"}(); + + $form->{language_id} = $language_saved; + $form->{payment_id} = $payment_id_saved; + $form->{"email"} = $saved_email if ($saved_email); - $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"); - } - map { push @a, "${_}_description" } split / /, $form->{taxaccounts}; + $form->{"cc"} = $saved_cc if ($saved_cc); + $form->{"bcc"} = $saved_bcc if ($saved_bcc); - $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"; + my ($language_tc, $output_numberformat, $output_dateformat, $output_longdates); + if ($form->{"language_id"}) { + ($language_tc, $output_numberformat, $output_dateformat, $output_longdates) = + AM->get_language_details(\%myconfig, $form, $form->{language_id}); + } else { + $output_dateformat = $myconfig{"dateformat"}; + $output_numberformat = $myconfig{"numberformat"}; + $output_longdates = 1; } - - $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"); - - + + if ($form->{shipto_id}) { + $form->get_shipto(\%myconfig); + } + @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,9 +1927,10 @@ sub print_form { } if ($shipto) { - if ($form->{formname} eq 'purchase_order' || $form->{formname} eq 'request_quotation') { - $form->{shiptoname} = $myconfig{company}; - $form->{shiptostreet} = $myconfig{address}; + 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; } @@ -1291,52 +1938,94 @@ 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, ("${inv}date", "${due}date", email, cc, bcc); - - $form->format_string(@a); + $form->{templates} = "$myconfig{templates}"; + $form->{language} = $form->get_template_language(\%myconfig); + $form->{printer_code} = $form->get_printer_code(\%myconfig); - $form->{templates} = "$myconfig{templates}"; if ($form->{language} ne "") { - $form->{language} = "_".$form->{language}; - } - - $form->{IN} = "$form->{formname}$form->{language}.html"; + map({ $form->{"unit"}->[$_] = + AM->translate_units($form, $form->{"language"}, + $form->{"unit"}->[$_], $form->{"qty"}->[$_]); } + (0..scalar(@{$form->{"unit"}}) - 1)); + $form->{language} = "_" . $form->{language}; + } + + # Format dates. + format_dates($output_dateformat, $output_longdates, + qw(invdate orddate quodate pldate duedate reqdate transdate + shippingdate deliverydate validitydate paymentdate + datepaid transdate_oe deliverydate_oe + employee_startdate employee_enddate + ), + grep({ /^datepaid_\d+$/ || + /^transdate_oe_\d+$/ || + /^deliverydate_oe_\d+$/ || + /^reqdate_\d+$/ || + /^deliverydate_\d+$/ || + /^transdate_\d+$/ + } keys(%{$form}))); + + reformat_numbers($output_numberformat, 2, + qw(invtotal ordtotal quototal subtotal linetotal + listprice sellprice netprice discount + tax taxbase), + grep({ /^linetotal_\d+$/ || + /^listprice_\d+$/ || + /^sellprice_\d+$/ || + /^netprice_\d+$/ || + /^taxbase_\d+$/ || + /^discount_\d+$/ || + /^tax_\d+$/ + } keys(%{$form}))); + + reformat_numbers($output_numberformat, undef, + qw(qty), + grep({ /^qty_\d+$/ + } keys(%{$form}))); + + if ($form->{printer_code} ne "") { + $form->{printer_code} = "_" . $form->{printer_code}; + } + + $form->{IN} = "$form->{formname}$form->{language}$form->{printer_code}.html"; if ($form->{format} eq 'postscript') { $form->{postscript} = 1; $form->{IN} =~ s/html$/tex/; - } - if ($form->{format} eq 'pdf') { + } elsif ($form->{"format"} =~ /pdf/) { $form->{pdf} = 1; - $form->{IN} =~ s/html$/tex/; + if ($form->{"format"} =~ /opendocument/) { + $form->{IN} =~ s/html$/odt/; + } else { + $form->{IN} =~ s/html$/tex/; + } + } elsif ($form->{"format"} =~ /opendocument/) { + $form->{"opendocument"} = 1; + $form->{"IN"} =~ s/html$/odt/; } if ($form->{media} eq 'printer') { - $form->{OUT} = "| $myconfig{printer}"; + $form->{OUT} = "| $form->{printer_command} &>/dev/null"; $form->{printed} .= " $form->{formname}"; $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 +2034,9 @@ sub print_form { $filename .= $$; } - $filename .= ($form->{postscript}) ? '.ps' : '.pdf'; $form->{OUT} = ">$spool/$filename"; - + # add type $form->{queued} .= " $form->{formname} $filename"; @@ -1356,7 +2044,6 @@ sub print_form { } $queued = $form->{queued}; - $form->parse_template(\%myconfig, $userspath); $form->{callback} = ""; @@ -1365,84 +2052,113 @@ 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|); } + if ($form->{printing}) { + &{"$display_form"}; + exit; + } $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(); - IR->vendor_details(\%myconfig, \%$form); + IR->vendor_details(\%myconfig, \%$form, @_); $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); + + my @shipto_vars = + qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry + shiptocontact shiptophone shiptofax shiptoemail + shiptodepartment_1 shiptodepartment_2); + + my @addr_vars = + (qw(name department_1 department_2 street zipcode city country + contact email phone fax)); # get details for name - &{ "$form->{vc}_details" }; + &{"$form->{vc}_details"}(@addr_vars); - $number = ($form->{vc} eq 'customer') ? $locale->text('Customer Number') : $locale->text('Vendor Number'); + $number = + ($form->{vc} eq 'customer') + ? $locale->text('Customer Number') + : $locale->text('Vendor Number'); + + # get pricegroups for parts + IS->get_pricegroups_for_parts(\%myconfig, \%$form); + + # build up html code for prices_$i + set_pricegroup($form->{rowcount}); $nextsub = ($form->{display_form}) ? $form->{display_form} : "display_form"; @@ -1460,8 +2176,10 @@ sub ship_to { - - + + @@ -1469,47 +2187,57 @@ sub ship_to { - + - + + + + + + + + + + + - + - + - + - + - - + + - - + + - + @@ -1522,9 +2250,9 @@ sub ship_to { |; # delete shipto - map { delete $form->{$_} } qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail header); + map({ delete $form->{$_} } (@shipto_vars, qw(header))); $form->{title} = $title; - + foreach $key (keys %$form) { $form->{$key} =~ s/\"/"/g; print qq|\n|; @@ -1535,7 +2263,8 @@ sub ship_to {

- + @@ -1545,24 +2274,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 +2301,47 @@ 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(); } +sub relink_accounts { + $lxdebug->enter_sub(); + + $form->{"taxaccounts"} =~ s/\s*$//; + $form->{"taxaccounts"} =~ s/^\s*//; + foreach my $accno (split(/\s*/, $form->{"taxaccounts"})) { + map({ delete($form->{"${accno}_${_}"}); } qw(rate description taxnumber)); + } + $form->{"taxaccounts"} = ""; + + for (my $i = 1; $i <= $form->{"rowcount"}; $i++) { + if ($form->{"id_$i"}) { + IC->retrieve_accounts(\%myconfig, $form, $form->{"id_$i"}, $i, 1); + } + } + + $lxdebug->leave_sub(); +} + + +sub set_duedate { + $lxdebug->enter_sub(); + + $form->get_duedate(\%myconfig); + my $q = new CGI; + $result = "$form->{duedate}"; + print $q->header(); + print $result; + $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('Department') . qq|$form->{department_1}
 $form->{department_2}
| . $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|$form->{"$form->{vc}phone"}| . $locale->text('Phone') . qq|$form->{phone}
|.$locale->text('Fax').qq|$form->{"$form->{vc}fax"}| . $locale->text('Fax') . qq|$form->{fax}
|.$locale->text('E-mail').qq|| . $locale->text('E-mail') . qq| $form->{email}