X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fio.pl;h=7643f14f145928290a17b597959e3aa26e206ae8;hb=52352135ee322387c8eba0fcbbb09dd50abbdf09;hp=22acf9710aa8d3f1feba7119649e7cea25252cbe;hpb=9f0d85c2b00a0d3b7a92b63115801b2452846470;p=kivitendo-erp.git diff --git a/bin/mozilla/io.pl b/bin/mozilla/io.pl index 22acf9710..039509269 100644 --- a/bin/mozilla/io.pl +++ b/bin/mozilla/io.pl @@ -33,12 +33,22 @@ # ####################################################################### +use CGI; +use CGI::Ajax; +use List::Util qw(max); + +use SL::Common; +use SL::CT; +use SL::IC; + +require "bin/mozilla/common.pl"; + # any custom scripts for this one -if (-f "$form->{path}/custom_io.pl") { - eval { require "$form->{path}/custom_io.pl"; }; +if (-f "bin/mozilla/custom_io.pl") { + eval { require "bin/mozilla/custom_io.pl"; }; } -if (-f "$form->{path}/$form->{login}_io.pl") { - eval { require "$form->{path}/$form->{login}_io.pl"; }; +if (-f "bin/mozilla/$form->{login}_io.pl") { + eval { require "bin/mozilla/$form->{login}_io.pl"; }; } 1; @@ -74,6 +84,7 @@ if (-f "$form->{path}/$form->{login}_io.pl") { # $locale->text('Dec') use SL::IS; use SL::PE; +use SL::AM; use Data::Dumper; ######################################## # Eintrag fuer Version 2.2.0 geaendert # @@ -82,6 +93,12 @@ use Data::Dumper; sub display_row { $lxdebug->enter_sub(); my $numrows = shift; + + my $is_sales = + (substr($form->{type}, 0, 6) eq "sales_") + || (($form->{type} eq "invoice") && ($form->{script} eq "is.pl")) + || ($form->{type} eq 'credit_note'); + if ($lizenzen && $form->{vc} eq "customer") { if ($form->{type} =~ /sales_order/) { @column_index = (runningnumber, partnumber, description, ship, qty); @@ -100,6 +117,12 @@ sub display_row { } ############## ENDE Neueintrag ################## + my $dimension_units = AM->retrieve_units(\%myconfig, $form, "dimension"); + my $service_units = AM->retrieve_units(\%myconfig, $form, "service"); + my $all_units = AM->retrieve_units(\%myconfig, $form); + + my %price_factors = map { $_->{id} => $_->{factor} } @{ $form->{ALL_PRICE_FACTORS} }; + push @column_index, qw(unit); #for pricegroups column @@ -107,7 +130,7 @@ sub display_row { 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); + push @column_index, qw(sellprice_pg); } push @column_index, qw(sellprice); @@ -121,75 +144,92 @@ sub display_row { my $colspan = $#column_index + 1; $form->{invsubtotal} = 0; - map { $form->{"${_}_base"} = 0 } (split / /, $form->{taxaccounts}); + map { $form->{"${_}_base"} = 0 } (split(/ /, $form->{taxaccounts})); ######################################## # Eintrag fuer Version 2.2.0 geaendert # # neue Optik im Rechnungsformular # ######################################## $column_data{runningnumber} = - qq|| + qq|| . $locale->text('No.') . qq||; $column_data{partnumber} = - qq|| + qq|| . $locale->text('Number') . qq||; $column_data{description} = - qq|| + qq|| . $locale->text('Part Description') . qq||; - $column_data{ship} = - qq|| - . $locale->text('Ship') - . 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|| + qq|| . $locale->text('Qty') . qq||; $column_data{unit} = - qq|| + qq|| . $locale->text('Unit') . qq||; $column_data{license} = - qq|| + qq|| . $locale->text('License') . qq||; $column_data{serialnr} = - qq|| + qq|| . $locale->text('Serial No.') . qq||; $column_data{projectnr} = - qq|| + qq|| . $locale->text('Project') . qq||; $column_data{sellprice} = - qq|| + qq|| . $locale->text('Price') . qq||; - $column_data{sellprice_drag} = - qq|| + $column_data{sellprice_pg} = + qq|| . $locale->text('Pricegroup') . qq||; $column_data{discount} = - qq|| + qq|| . $locale->text('Discount') . qq||; $column_data{linetotal} = - qq|| + qq|| . $locale->text('Extended') . qq||; $column_data{bin} = - qq|| + 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| - - - |; + - -|; - } - if ($form->{formname} =~ /(pick|packing|bin)_list/) { - $form->{email} = $form->{shiptoemail} if $form->{shiptoemail}; + $form->{email} = $form->{shiptoemail} if $form->{shiptoemail} && $form->{formname} =~ /(pick|packing|bin)_list/; + + 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') . " " . $form->get_formname_translation(); $form->{oldmedia} = $form->{media}; $form->{media} = "email"; - $form->header; - - print qq| - - -{script}> - -
| . $cgi->hidden("-name" => "show_details", "-value" => $form->{show_details}) . qq| + +
+ + |; map { print "\n$column_data{$_}" } @column_index; @@ -202,6 +242,7 @@ sub display_row { $serialnumber = $locale->text('Serial No.'); $projectnumber = $locale->text('Project'); $partsgroup = $locale->text('Group'); + $reqdate = $locale->text('Reqdate'); $delvar = 'deliverydate'; @@ -210,37 +251,106 @@ sub display_row { $delvar = 'reqdate'; } + $form->{marge_total} = 0; + $form->{sellprice_total} = 0; + $form->{lastcost_total} = 0; + my %projectnumber_labels = (); + my @projectnumber_values = (""); + foreach my $item (@{ $form->{"ALL_PROJECTS"} }) { + push(@projectnumber_values, $item->{"id"}); + $projectnumber_labels{$item->{"id"}} = $item->{"projectnumber"}; + } + for $i (1 .. $numrows) { # undo formatting map { $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) - } qw(qty ship discount sellprice price_new price_old); + } qw(qty ship discount sellprice price_new price_old) unless ($form->{simple_save}); + + if (!$form->{"unit_old_$i"}) { + # Neue Ware aus der Datenbank. In diesem Fall ist unit_$i die + # Einheit, wie sie in den Stammdaten hinterlegt wurde. + # Es sollte also angenommen werden, dass diese ausgewaehlt war. + $form->{"unit_old_$i"} = $form->{"unit_$i"}; + } + + # Die zuletzt ausgewaehlte mit der aktuell ausgewaehlten Einheit + # vergleichen und bei Unterschied den Preis entsprechend umrechnen. + $form->{"selected_unit_$i"} = $form->{"unit_$i"} unless ($form->{"selected_unit_$i"}); + + my $check_units = $form->{"inventory_accno_$i"} ? $dimension_units : $service_units; + if (!$check_units->{$form->{"selected_unit_$i"}} || + ($check_units->{$form->{"selected_unit_$i"}}->{"base_unit"} ne + $all_units->{$form->{"unit_old_$i"}}->{"base_unit"})) { + # Die ausgewaehlte Einheit ist fuer diesen Artikel nicht gueltig + # (z.B. Dimensionseinheit war ausgewaehlt, es handelt sich aber + # um eine Dienstleistung). Dann keinerlei Umrechnung vornehmen. + $form->{"unit_old_$i"} = $form->{"selected_unit_$i"} = $form->{"unit_$i"}; + } + if ((!$form->{"prices_$i"}) || ($form->{"new_pricegroup_$i"} == $form->{"old_pricegroup_$i"})) { + if ($form->{"unit_old_$i"} ne $form->{"selected_unit_$i"}) { + my $basefactor = 1; + if (defined($all_units->{$form->{"unit_old_$i"}}->{"factor"}) && + $all_units->{$form->{"unit_old_$i"}}->{"factor"}) { + $basefactor = $all_units->{$form->{"selected_unit_$i"}}->{"factor"} / + $all_units->{$form->{"unit_old_$i"}}->{"factor"}; + } + $form->{"sellprice_$i"} *= $basefactor; + $form->{"unit_old_$i"} = $form->{"selected_unit_$i"}; + } + } ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); - $dec = length $dec; - $decimalplaces = ($dec > 2) ? $dec : 2; + $decimalplaces = max length($dec), 2; + + $price_factor = $price_factors{$form->{"price_factor_id_$i"}} || 1; + $discount = (100 - $form->{"discount_$i"} * 1) / 100; + + $linetotal = $form->round_amount($form->{"sellprice_$i"} * $form->{"qty_$i"} * $discount / $price_factor, $decimalplaces); + + my $real_sellprice = $form->{"sellprice_$i"} * $discount / $price_factor; + + # marge calculations + my ($marge_font_start, $marge_font_end); + + $form->{"lastcost_$i"} *= 1; + + $marge_price_factor = $form->{"marge_price_factor_$i"} * 1 || 1; + + if ($real_sellprice && ($form->{"qty_$i"} * 1)) { + $form->{"marge_percent_$i"} = ($real_sellprice - $form->{"lastcost_$i"} / $marge_price_factor) * 100 / $real_sellprice; + $myconfig{"marge_percent_warn"} = 15 unless (defined($myconfig{"marge_percent_warn"})); + + if ($form->{"id_$i"} && + ($form->{"marge_percent_$i"} < (1 * $myconfig{"marge_percent_warn"}))) { + $marge_font_start = ""; + $marge_font_end = ""; + } - $discount = - $form->round_amount( - $form->{"sellprice_$i"} * $form->{"discount_$i"} / 100, - $decimalplaces); + } else { + $form->{"marge_percent_$i"} = 0; + } - $linetotal = - $form->round_amount($form->{"sellprice_$i"} - $discount, $decimalplaces); - $linetotal = $form->round_amount($linetotal * $form->{"qty_$i"}, 2); + my $marge_adjust_credit_note = $form->{type} eq 'credit_note' ? -1 : 1; + $form->{"marge_total_$i"} = ($real_sellprice - $form->{"lastcost_$i"} / $marge_price_factor) * $form->{"qty_$i"} * $marge_adjust_credit_note; + $form->{"marge_total"} += $form->{"marge_total_$i"}; + $form->{"lastcost_total"} += $form->{"lastcost_$i"} * $form->{"qty_$i"} / $marge_price_factor; + $form->{"sellprice_total"} += $real_sellprice * $form->{"qty_$i"}; + + map { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2) } qw(marge_total marge_percent); # convert " to " map { $form->{"${_}_$i"} =~ s/\"/"/g } - qw(partnumber description unit); + qw(partnumber description unit unit_old); ######################################## # Eintrag fuer Version 2.2.0 geaendert # # neue Optik im Rechnungsformular # ######################################## $column_data{runningnumber} = - qq||; # HuT + qq||; # HuT ############## ENDE Neueintrag ################## $column_data{partnumber} = @@ -248,70 +358,106 @@ sub display_row { if (($rows = $form->numtextrows($form->{"description_$i"}, 30, 6)) > 1) { $column_data{description} = - qq||; + qq||; } else { $column_data{description} = - qq||; + qq||; } (my $qty_dec) = ($form->{"qty_$i"} =~ /\.(\d+)/); $qty_dec = length $qty_dec; $column_data{qty} = - qq||; + qq||; $column_data{ship} = - qq||; - $column_data{unit} = - qq||; + . qq|">|; + + my $is_part = $form->{"inventory_accno_$i"}; + my $is_assembly = $form->{"assembly_$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"; + } + + my $price_factor_select; + if (0 < scalar @{ $form->{ALL_PRICE_FACTORS} }) { + my @values = ('', map { $_->{id} } @{ $form->{ALL_PRICE_FACTORS} }); + my %labels = map { $_->{id} => $_->{description} } @{ $form->{ALL_PRICE_FACTORS} }; + + $price_factor_select = + NTI($cgi->popup_menu('-name' => "price_factor_id_$i", + '-default' => $form->{"price_factor_id_$i"}, + '-values' => \@values, + '-labels' => \%labels, + '-style' => 'width:90px')) + . ' '; + } + + $column_data{"unit"} = ""; - # build in dragdrop for pricesgroups + # build in drop down list for pricesgroups if ($form->{"prices_$i"}) { - $price_tmp = - $form->format_amount(\%myconfig, $form->{"price_new_$i"}, 2); + if ($form->{"new_pricegroup_$i"} != $form->{"old_pricegroup_$i"}) { + $price_tmp = $form->format_amount(\%myconfig, $form->{"price_new_$i"}, $decimalplaces); + } else { + $price_tmp = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); + } - $column_data{sellprice_drag} = - qq||; + $column_data{sellprice_pg} = + qq||; $column_data{sellprice} = - qq||; + qq||; } else { # for last row and report - # set pricegroup dragdrop from report menu + # 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_drag} = - qq||; + $column_data{sellprice_pg} = + qq||; } else { # for last row - $column_data{sellprice_drag} = - qq||; - } - + $column_data{sellprice_pg} = qq||; + } + $column_data{sellprice} = - qq||; + . qq|">|; } $column_data{discount} = - qq||; + . qq|">|; $column_data{linetotal} = - qq||; $column_data{bin} = qq||; @@ -330,47 +476,40 @@ sub display_row { # # $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"}> - - - - - - + map { print "\n$column_data{$_}" } @column_index; -|; + print("\n" . + $cgi->hidden("-name" => "unit_old_$i", + "-value" => $form->{"selected_unit_$i"}) + . "\n" . + $cgi->hidden("-name" => "price_new_$i", + "-value" => $form->format_amount(\%myconfig, $form->{"price_new_$i"})) + . "\n"); + map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_}) . "\n"); } + ("orderitems_id_$i", "bo_$i", "pricegroup_old_$i", "price_old_$i", + "id_$i", "inventory_accno_$i", "bin_$i", "partsgroup_$i", "partnotes_$i", + "income_accno_$i", "expense_accno_$i", "listprice_$i", "assembly_$i", + "taxaccounts_$i", "ordnumber_$i", "transdate_$i", "cusordnumber_$i", + "longdescription_$i", "basefactor_$i", "marge_total_$i", "marge_percent_$i", "lastcost_$i", + "marge_price_factor_$i")); ######################################## # 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| - - + - |; ############## ENDE Neueintrag ################## map { $form->{"${_}_base"} += $linetotal } - (split / /, $form->{"taxaccounts_$i"}); + (split(/ /, $form->{"taxaccounts_$i"})); $form->{invsubtotal} += $linetotal; } @@ -415,6 +585,10 @@ sub display_row { |; + if (0 != ($form->{sellprice_total} * 1)) { + $form->{marge_percent} = ($form->{sellprice_total} - $form->{lastcost_total}) / $form->{sellprice_total} * 100; + } + $lxdebug->leave_sub(); } @@ -422,30 +596,32 @@ sub display_row { # build html-code for pricegroups in variable $form->{prices_$j} sub set_pricegroup { - my $rowcount = shift; $lxdebug->enter_sub(); + my $rowcount = shift; for $j (1 .. $rowcount) { my $pricegroup_old = $form->{"pricegroup_old_$i"}; if ($form->{PRICES}{$j}) { $len = 0; - $prices = ''; + $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}; + $price = $item->{price}; $pricegroup_id = $item->{pricegroup_id}; $pricegroup = $item->{pricegroup}; - # build dragdrop for pricegroups + # 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); + + # 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)) { @@ -456,10 +632,8 @@ sub set_pricegroup { if ($pricegroup_id == 0) { $form->{"price_new_$j"} = $form->{"sellprice_$j"}; } - if ($len > 1) { - $form->{"prices_$j"} = $prices; - } } + $form->{"prices_$j"} = $prices; } } $lxdebug->leave_sub(); @@ -467,18 +641,19 @@ sub set_pricegroup { sub select_item { $lxdebug->enter_sub(); - @column_index = qw(ndx partnumber description onhand sellprice); + @column_index = qw(ndx partnumber description onhand unit sellprice); $column_data{ndx} = qq||; $column_data{partnumber} = - qq||; + qq||; $column_data{description} = - qq||; + qq||; $column_data{sellprice} = - qq||; + qq||; $column_data{onhand} = - qq||; - + qq||; + $column_data{unit} = + qq||; # list items with radio button on a form $form->header; @@ -486,16 +661,16 @@ sub select_item { $colspan = $#column_index + 1; print qq| - + -{script}> + -
format_amount(\%myconfig, $form->{"qty_$i"}, $qty_dec) - . qq|>|; + if ($form->{"formel_$i"}) { + $column_data{qty} .= qq|| + . $cgi->hidden("-name" => "formel_$i", "-value" => $form->{"formel_$i"}) . $cgi->hidden("-name" => "alu_$i", "-value" => $form->{"alu_$i"}); + } + $column_data{qty} .= qq|" . + $price_factor_select . + AM->unit_select_html($is_part || $is_assembly ? $dimension_units : + $is_assigned ? $service_units : $all_units, + "unit_$i", $this_unit, + $is_assigned ? $form->{"unit_$i"} : undef) + . "format_amount(\%myconfig, $form->{"prices_$i"}, - $decimalplaces) - . qq|> | + qq|| . $form->format_amount(\%myconfig, $linetotal, 2) . qq|$form->{"bin_$i"}
+
|; if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") { my $selected = $form->{"licensenumber_$i"}; @@ -381,30 +520,61 @@ sub display_row { $lizenzen_quoted = $form->{"lizenzen_$i"}; $lizenzen_quoted =~ s/\"/"/g; print qq| - Lizenz\#  $form->{"lizenzen_$i"} - + |; } if ($form->{type} !~ /_quotation/) { print qq| - $serialnumber |; + $serialnumber |; + } + + print qq|$projectnumber | . + NTI($cgi->popup_menu('-name' => "project_id_$i", + '-values' => \@projectnumber_values, + '-labels' => \%projectnumber_labels, + '-default' => $form->{"project_id_$i"})); + + 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|  +|; + + if ($form->{"id_$i"} && $is_sales) { + my $marge_price_factor; + + $form->{"marge_price_factor_$i"} *= 1; + + if ($form->{"marge_price_factor_$i"} && (1 != $form->{"marge_price_factor_$i"})) { + $marge_price_factor = '/' . $form->format_amount(\%myconfig, $form->{"marge_price_factor_$i"}); + } + + print qq| + ${marge_font_start}| . $locale->text('Ertrag') . qq| $form->{"marge_total_$i"} $form->{"marge_percent_$i"} % ${marge_font_end} +  | . $locale->text('LP') . qq| | . $form->format_amount(\%myconfig, $form->{"listprice_$i"}, 2) . qq| +  | . $locale->text('EK') . qq| | . $form->format_amount(\%myconfig, $form->{"lastcost_$i"}, 2) . $marge_price_factor; } print qq| - $projectnumber  - -
 | . $locale->text('Number') . qq|| . $locale->text('Number') . qq|| . $locale->text('Part Description') . qq|| . $locale->text('Part Description') . qq|| . $locale->text('Price') . qq|| . $locale->text('Price') . qq|| . $locale->text('Qty') . qq|| . $locale->text('Qty') . qq|| . $locale->text('Unit') . qq|
+
- + - |; + |; map { print "\n$column_data{$_}" } @column_index; @@ -512,31 +687,33 @@ sub select_item { $ref->{"lizenzen"} .= qq||; } - $ref->{"lizenzen"} .= qq||; + $ref->{"lizenzen"} .= qq||; $ref->{"lizenzen"} =~ s/\"/"/g; } } map { $ref->{$_} =~ s/\"/"/g } qw(partnumber description unit); - #sk tradediscount - $ref->{sellprice} = - $form->round_amount($ref->{sellprice} * (1 - $form->{tradediscount}), 2); + my $display_sellprice = $ref->{sellprice} * (1 - $form->{tradediscount}); + $display_sellprice /= $ref->{price_factor} if ($ref->{price_factor}); + $display_sellprice = $form->format_amount(\%myconfig, $display_sellprice, 2); + $column_data{ndx} = - qq||; + qq||; $column_data{partnumber} = - qq||; + qq||; $column_data{description} = - qq||; + qq||; $column_data{sellprice} = - qq||; $column_data{onhand} = - qq||; - + $column_data{unit} = + qq||; $j++; $j %= 2; print qq| @@ -544,36 +721,23 @@ sub select_item { map { print "\n$column_data{$_}" } @column_index; - print qq| - - - -{listprice}> -{inventory_accno}> -{income_accno}> -{expense_accno}> - - - - - + print("\n"); -{id}> - -|; - if ($lizenzen) { - print qq| - -|; - } + my @new_fields = + qw(bin listprice inventory_accno income_accno expense_accno unit weight + assembly taxaccounts partsgroup formel longdescription not_discountable + part_payment_id partnotes id lastcost price_factor_id price_factor); + push(@new_fields, "lizenzen") if ($lizenzen); + print join "\n", map { $cgi->hidden("-name" => "new_${_}_$i", "-value" => $ref->{$_}) } @new_fields; + print "\n"; } print qq| - +
$title$title
$ref->{partnumber}$ref->{partnumber}$ref->{description}$ref->{description}{sellprice}>| - . $form->format_amount(\%myconfig, $ref->{sellprice}, 2, " ") + qq|| + . $display_sellprice . qq|{onhand}>| + qq|| . $form->format_amount(\%myconfig, $ref->{onhand}, '', " ") . qq|$ref->{unit}


- + |; @@ -583,14 +747,14 @@ sub select_item { # save all other form variables foreach $key (keys %${form}) { $form->{$key} =~ s/\"/"/g; - print qq|\n|; + print qq|\n|; } print qq| - +
- @@ -618,8 +782,19 @@ sub item_selected { # 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); + my @new_fields = + qw(id partnumber description sellprice listprice inventory_accno + income_accno expense_accno bin unit weight assembly taxaccounts + partsgroup formel longdescription not_discountable partnotes lastcost + price_factor_id price_factor); + + map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} } @new_fields; + + $form->{"marge_price_factor_$i"} = $form->{"new_price_factor_$j"}; + + 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); @@ -646,6 +821,10 @@ sub item_selected { $form->{sellprice} += ($form->{"sellprice_$i"} * $form->{"qty_$i"}); $form->{weight} += ($form->{"weight_$i"} * $form->{"qty_$i"}); + + if ($form->{"not_discountable_$i"}) { + $form->{"discount_$i"} = 0; + } $amount = $form->{"sellprice_$i"} * (1 - $form->{"discount_$i"} / 100) * @@ -662,8 +841,7 @@ sub item_selected { # 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"} } @new_fields; } map { delete $form->{$_} } qw(ndx lastndx nextsub); @@ -713,36 +891,30 @@ 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('Part') . qq|
-  | - . $locale->text('Service') - - . qq| - - - -{rowcount}> -{taxaccounts}> -{vc}> +  | + . $locale->text('Service'); -{path}> -{login}> -{password}> + print $cgi->hidden("-name" => "previousform", "-value" => $previousform); + map { print $cgi->hidden("-name" => $_, "-value" => $form->{$_}); } qw(rowcount vc login password); + map { print $cgi->hidden("-name" => $_, "-value" => $form->{"${_}_$i"}); } qw(partnumber description unit sellprice price_factor_id); + print $cgi->hidden("-name" => "taxaccount2", "-value" => $form->{taxaccounts}); - +print qq| +

-

@@ -756,44 +928,54 @@ sub new_item { sub display_form { $lxdebug->enter_sub(); - # if we have a display_form - if ($form->{display_form}) { - &{"$form->{display_form}"}; - exit; - } - if ( $form->{print_and_post} - && $form->{second_run} - && ($form->{action} eq "display_form")) { - for (keys %$form) { $old_form->{$_} = $form->{$_} } - $old_form->{rowcount}++; + relink_accounts(); - #$form->{rowcount}--; - #$form->{rowcount}--; + my $new_rowcount = $form->{"rowcount"} * 1 + 1; + $form->{"project_id_${new_rowcount}"} = $form->{"globalproject_id"}; - $form->{print_and_post} = 0; + $form->language_payment(\%myconfig); - &print_form($old_form); + # if we have a display_form + if ($form->{display_form}) { + call_sub($form->{"display_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; - - } + Common::webdav_folder($form) if ($webdav); + + # 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}; @@ -811,7 +993,7 @@ sub display_form { $subroutine = "makemodel_row"; } if ($form->{item} eq 'assembly') { - $numrows = ++$form->{price_rows}; + $numrows = $form->{price_rows}; $subroutine = "price_row"; &{$subroutine}($numrows); @@ -826,7 +1008,7 @@ sub display_form { $subroutine = "assembly_row"; } if ($form->{item} eq 'service') { - $numrows = ++$form->{price_rows}; + $numrows = $form->{price_rows}; $subroutine = "price_row"; &{$subroutine}($numrows); @@ -846,9 +1028,7 @@ sub check_form { $lxdebug->enter_sub(); 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 marge_total marge_percent marge_price_factor lastcost price_factor_id)); # remove any makes or model rows if ($form->{item} eq 'part') { @@ -918,6 +1098,9 @@ sub check_form { $form->redo_rows(\@flds, \@a, $count, $form->{makemodel_rows}); $form->{makemodel_rows} = $count; + } elsif ($form->{item} eq 'service') { + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(listprice sellprice lastcost); + } else { # this section applies to invoices and orders @@ -986,12 +1169,12 @@ sub invoicetotal { $amount = $sellprice * (1 - $discount / 100) * $qty; map { $form->{"${_}_base"} += $amount } - (split / /, $form->{"taxaccounts_$i"}); + (split (/ /, $form->{"taxaccounts_$i"})); $form->{oldinvtotal} += $amount; } map { $form->{oldinvtotal} += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } - split / /, $form->{taxaccounts} + split(/ /, $form->{taxaccounts}) if !$form->{taxincluded}; $form->{oldtotalpaid} = 0; @@ -1029,6 +1212,9 @@ sub order { } $form->{ordnumber} = $form->{invnumber}; + $form->{old_employee_id} = $form->{employee_id}; + $form->{old_salesman_id} = $form->{salesman_id}; + 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'); @@ -1048,10 +1234,13 @@ sub order { $form->{rowcount}--; - ($null, $form->{cp_id}) = split /--/, $form->{contact}; $form->{cp_id} *= 1; - require "$form->{path}/$form->{script}"; + require "bin/mozilla/$form->{script}"; + my $script = $form->{"script"}; + $script =~ s|.*/||; + $script =~ s|.pl$||; + $locale = new Locale($language, $script); map { $form->{"select$_"} = "" } ($form->{vc}, currency); @@ -1070,6 +1259,13 @@ sub order { \%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; @@ -1096,7 +1292,6 @@ sub quotation { $buysell = 'buy'; } - ($null, $form->{cp_id}) = split /--/, $form->{contact}; $form->{cp_id} *= 1; $form->{script} = 'oe.pl'; @@ -1105,7 +1300,7 @@ sub quotation { $form->{rowcount}--; - require "$form->{path}/$form->{script}"; + require "bin/mozilla/$form->{script}"; map { $form->{"select$_"} = "" } ($form->{vc}, currency); @@ -1124,110 +1319,58 @@ sub quotation { \%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 e_mail { +sub request_for_quotation { + quotation(); +} + +sub edit_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|
- - - - - - - - - - - - - - - - -
$title
- - - - - - - - - - - $bcc - -
| . $locale->text('To') . qq|| . $locale->text('Cc') . qq|
| . $locale->text('Subject') . qq|
-
- - - - - - - -
| . $locale->text('Message') . qq|
-
-|; - - &print_options; - - 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|; - } + my $attachment_filename = $form->generate_attachment_filename(); - print qq| -

- - + $form->{"fokus"} = $form->{"email"} ? "Form.subject" : "Form.email"; + $form->header; -
- - + my (@dont_hide_key_list, %dont_hide_key, @hidden_keys); + @dont_hide_key_list = qw(action email cc bcc subject message formname sendmode format header override); + @dont_hide_key{@dont_hide_key_list} = (1) x @dont_hide_key_list; + @hidden_keys = grep { !$dont_hide_key{$_} } grep { !ref $form->{$_} } keys %$form; - - -|; + print $form->parse_html_template('generic/edit_email', + { title => $title, + a_filename => $attachment_filename, + _print_options_ => print_options({ 'inline' => 1 }), + HIDDEN => [ map +{ name => $_, value => $form->{$_} }, @hidden_keys ], + SHOW_BCC => $myconfig{role} eq 'admin' }); $lxdebug->leave_sub(); } @@ -1235,176 +1378,142 @@ sub e_mail { sub send_email { $lxdebug->enter_sub(); - $old_form = new Form; + my $callback = $form->{script} . "?action=edit"; + map({ $callback .= "\&${_}=" . E($form->{$_}); } + qw(login password type id)); - map { $old_form->{$_} = $form->{$_} } keys %$form; - $old_form->{media} = $form->{oldmedia}; + print_form("return"); - &print_form($old_form); + Common->save_email_status(\%myconfig, $form); + + $form->{callback} = $callback; + $form->redirect(); $lxdebug->leave_sub(); } +# generate the printing options displayed at the bottom of oe and is forms. +# this function will attempt to guess what type of form is displayed, and will generate according options +# +# about the coding: +# this version builds the arrays of options pretty directly. if you have trouble understanding how, +# the opthash function builds hashrefs which are then pieced together for the template arrays. +# unneeded options are "undef"ed out, and then grepped out. +# +# the inline options is untested, but intended to be used later in metatemplating 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"; - - if ($form->{type} eq 'purchase_order') { - $type = qq| -