X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Foe.pl;h=c7d289f119dc4632dc9bff4fff5cb357a40be47b;hb=59d350af569acf4d081454c32bf724872aa48307;hp=5cc5418d6e4b74d3ed5fb7247fed470748190a47;hpb=52983c089cf1b4f1a4451e57ffa76f846c4791ba;p=kivitendo-erp.git diff --git a/bin/mozilla/oe.pl b/bin/mozilla/oe.pl index 5cc5418d6..c7d289f11 100644 --- a/bin/mozilla/oe.pl +++ b/bin/mozilla/oe.pl @@ -1,4 +1,4 @@ -# #===================================================================== +#===================================================================== # LX-Office ERP # Copyright (C) 2004 # Based on SQL-Ledger Version 2.1.9 @@ -38,7 +38,7 @@ use SL::IR; use SL::IS; use SL::PE; use SL::ReportGenerator; -use List::Util qw(max); +use List::Util qw(max reduce); require "bin/mozilla/io.pl"; require "bin/mozilla/arap.pl"; @@ -162,8 +162,7 @@ sub edit { sub order_links { $lxdebug->enter_sub(); # get customer/vendor - $form->all_vc(\%myconfig, $form->{vc}, - ($form->{vc} eq 'customer') ? "AR" : "AP"); + $form->all_vc(\%myconfig, $form->{vc}, ($form->{vc} eq 'customer') ? "AR" : "AP"); # retrieve order/quotation $form->{webdav} = $webdav; @@ -245,8 +244,7 @@ sub order_links { } $form->{intnotes} = $intnotes if $intnotes; ($form->{ $form->{vc} }) = split /--/, $form->{ $form->{vc} }; - $form->{"old$form->{vc}"} = - qq|$form->{$form->{vc}}--$form->{"$form->{vc}_id"}|; + $form->{"old$form->{vc}"} = qq|$form->{$form->{vc}}--$form->{"$form->{vc}_id"}|; # build the popup menus if (@{ $form->{"all_$form->{vc}"} }) { @@ -265,9 +263,8 @@ sub order_links { $form->{department} = "$form->{department}--$form->{department_id}"; map { - $form->{selectdepartment} .= - "\n" - } (@{ $form->{all_departments} }); + $form->{selectdepartment} .= "\n" + } @{ $form->{all_departments} }; } $form->{employee} = "$form->{employee}--$form->{employee_id}"; @@ -287,36 +284,14 @@ sub prepare_order { my $i = 0; foreach $ref (@{ $form->{form_details} }) { $form->{rowcount} = ++$i; - map { $form->{"${_}_$i"} = $ref->{$_} } keys %{$ref}; } for my $i (1 .. $form->{rowcount}) { - if ($form->{id}) { - $form->{"discount_$i"} = - $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100); - } else { - $form->{"discount_$i"} = - $form->format_amount(\%myconfig, $form->{"discount_$i"}); - } - ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); - $dec = length $dec; - $decimalplaces = ($dec > 2) ? $dec : 2; - - # copy reqdate from deliverydate for invoice -> order conversion - $form->{"reqdate_$i"} = $form->{"deliverydate_$i"} - unless $form->{"reqdate_$i"}; - - $form->{"sellprice_$i"} = - $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, - $decimalplaces); - - (my $dec_qty) = ($form->{"qty_$i"} =~ /\.(\d+)/); - $dec_qty = length $dec_qty; - $form->{"qty_$i"} = - $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty); - - map { $form->{"${_}_$i"} =~ s/\"/"/g } - qw(partnumber description unit); + $form->{"reqdate_$i"} = $form->{"deliverydate_$i"} unless $form->{"reqdate_$i"}; + $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * ($form->{id} ? 100 : 1)); + $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}); + $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}); + map { $form->{"${_}_$i"} =~ s/\"/"/g } qw(partnumber description unit); } $lxdebug->leave_sub(); @@ -324,9 +299,10 @@ sub prepare_order { sub form_header { $lxdebug->enter_sub(); + my @custom_hiddens; - my $checkedclosed = $form->{"closed"} ? "checked" : ""; - my $checkeddelivered = $form->{"delivered"} ? "checked" : ""; + # Container for template variables. Unfortunately this has to be visible in form_footer too, so not my. + our %TMPL_VAR = (); $form->{employee_id} = $form->{old_employee_id} if $form->{old_employee_id}; $form->{salesman_id} = $form->{old_salesman_id} if $form->{old_salesman_id}; @@ -336,51 +312,34 @@ sub form_header { $form->{employee_id} = $form->{old_employee_id} if $form->{old_employee_id}; $form->{salesman_id} = $form->{old_salesman_id} if $form->{old_salesman_id}; - map { $form->{$_} =~ s/\"/"/g } - qw(ordnumber quonumber shippingpoint shipvia notes intnotes shiptoname + map { $form->{$_} = H($form->{$_}) } + qw(shippingpoint shipvia notes intnotes shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptodepartment_1 shiptodepartment_2); - + # use JavaScript Calendar or not $form->{jsscript} = 1; - $jsscript = ""; - - $button1 = qq| - - text('button') . qq|> + $TMPL_VAR{button1} = qq| + + text('button') . qq|> |; - $button2 = qq| - - text('button') . qq|> + $TMPL_VAR{button2} = qq| + + text('button') . qq|> |; - #write Trigger - $jsscript = Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", "reqdate", "BL", "trigger2"); + $TMPL_VAR{jsscript} = Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", "reqdate", "BL", "trigger2"); + # openclosed checkboxes my @tmp; - - if (($form->{"type"} eq "sales_order") || - ($form->{"type"} eq "purchase_order")) { - push(@tmp, qq| - |); - } - - if ($form->{id}) { - push(@tmp, qq| - |); - } - - if (@tmp) { - $openclosed .= qq| - | . join("\n", @tmp) . qq| - - \n|; - } + push @tmp, sprintf qq||, + $form->{"delivered"} ? "checked" : "", $locale->text('Delivered') if $form->{"type"} =~ /_order$/; + push @tmp, sprintf qq||, + $form->{"closed"} ? "checked" : "", $locale->text('Closed') if $form->{id}; + $TMPL_VAR{openclosed} = sprintf qq|%s\n|, 2 * scalar @tmp, join "\n", @tmp if @tmp; # set option selected - foreach $item ($form->{vc}, currency, department, ($form->{vc} eq "customer" ? customer : vendor)) { + foreach $item ($form->{vc}, 'currency', 'department', ($form->{vc} eq "customer" ? 'customer' : 'vendor')) { $form->{"select$item"} =~ s/ selected//; $form->{"select$item"} =~ s/option>\Q$form->{$item}\E/option selected>$form->{$item}/; } @@ -391,306 +350,55 @@ sub form_header { #substitute \n and \r to \s (bug 543) $form->{"select$form->{vc}"} =~ s/[\n\r]/ /g; - my @old_project_ids = ($form->{"globalproject_id"}); - map({ push(@old_project_ids, $form->{"project_id_$_"}) - if ($form->{"project_id_$_"}); } (1..$form->{"rowcount"})); + my @old_project_ids = ($form->{"globalproject_id"}, grep { $_ } map { $form->{"project_id_$_"} } 1..$form->{"rowcount"}); my $vc = $form->{vc} eq "customer" ? "customers" : "vendors"; - $form->get_lists("contacts" => "ALL_CONTACTS", - "shipto" => "ALL_SHIPTO", - "projects" => { - "key" => "ALL_PROJECTS", - "all" => 0, - "old_id" => \@old_project_ids - }, - "employees" => "ALL_EMPLOYEES", - "salesmen" => "ALL_SALESMEN", - "taxzones" => "ALL_TAXZONES", - "payments" => "ALL_PAYMENTS", - "currencies" => "ALL_CURRENCIES", - $vc => "ALL_" . uc($vc)); - - my %labels; - my @values = (undef); - foreach my $item (@{ $form->{"ALL_CONTACTS"} }) { - push(@values, $item->{"cp_id"}); - $labels{$item->{"cp_id"}} = $item->{"cp_name"} . ($item->{"cp_abteilung"} ? " ($item->{cp_abteilung})" : ""); - } - - my $contact; - if (scalar @values > 1) { - $contact = qq| - - | . $locale->text('Contact Person') . qq| - | . - NTI($cgi->popup_menu('-name' => 'cp_id', '-values' => \@values, '-style' => 'width: 250px', - '-labels' => \%labels, '-default' => $form->{"cp_id"})) - . qq| - - |; - } - - %labels = (); - @values = (); - - foreach my $item (@{ $form->{($form->{vc} eq "customer" ? "ALL_CUSTOMERS" : "ALL_VENDORS")}}) { - push(@values, $item->{"name"}.qq|--|.$item->{"id"}); - $labels{$item->{"name"}.qq|--|.$item->{"id"}} = $item->{name}; - } - - $vc = qq| - {vc}_id"}) . qq|"> - {vc}"}) . qq|"> - | . $locale->text(ucfirst($form->{vc})) . qq| - | . - (($myconfig{vclimit} <= scalar(@values)) - ? qq|{vc}"} =~ /^(.*)\-\-.*$/)) . qq|" name="$form->{vc}">| - : (NTI($cgi->popup_menu('-name' => "$form->{vc}", '-default' => $form->{"old$form->{vc}"}, - '-onChange' => 'document.getElementById(\'update_button\').click();', - '-values' => \@values, '-labels' => \%labels, '-style' => 'width: 250px')))) . qq| - - {vc}"}) . qq|">|; - - %labels = (); - @values = (""); - foreach my $item (@{ $form->{"ALL_PAYMENTS"} }) { - push(@values, $item->{"id"}); - $labels{$item->{"id"}} = $item->{"description"}; - } - - $payments = qq| - | . $locale->text('Payment Terms') . qq| - | . - NTI($cgi->popup_menu('-name' => 'payment_id', '-values' => \@values, '-style' => 'width: 250px', - '-labels' => \%labels, '-default' => $form->{payment_id})) - . qq||; - - %labels = (); - @values = (""); - foreach my $item (@{ $form->{"ALL_SHIPTO"} }) { - push(@values, $item->{"shipto_id"}); - $labels{$item->{"shipto_id"}} = join "; ", grep { $_ } map { $item->{"shipto${_}" } } qw(name department_1 street city); - } - - my $shipto; - if (scalar @values > 1) { - $shipto = qq| - - | . $locale->text('Shipping Address') . qq| - | . - NTI($cgi->popup_menu('-name' => 'shipto_id', '-values' => \@values, '-style' => 'width: 250px', - '-labels' => \%labels, '-default' => $form->{"shipto_id"})) - . qq||; - } - - %labels = (); - @values = (""); - foreach my $item (@{ $form->{"ALL_PROJECTS"} }) { - push(@values, $item->{"id"}); - $labels{$item->{"id"}} = $item->{"projectnumber"}; - } - my $globalprojectnumber = NTI($cgi->popup_menu('-name' => 'globalproject_id', '-values' => \@values, - '-labels' => \%labels, - '-default' => $form->{"globalproject_id"})); - - my $salesmen = ""; - %labels = (); - @values = (); - if ($form->{type} =~ /^sales_/) { - foreach my $item (@{ $form->{"ALL_SALESMEN"} }) { - push(@values, $item->{"id"}); - $labels{$item->{"id"}} = ($item->{"name"} ne "" ? $item->{"name"} : $item->{"login"}); - } - $salesmen = - qq| - | . $locale->text('Salesman') . qq| - | . - NTI($cgi->popup_menu('-name' => 'salesman_id', '-default' => $form->{"salesman_id"} ? $form->{"salesman_id"} : $form->{"employee_id"}, - '-values' => \@values, '-labels' => \%labels)) - . qq| - |; - } - - %labels = (); - @values = (); - foreach my $item (@{ $form->{"ALL_EMPLOYEES"} }) { - push(@values, $item->{"id"}); - $labels{$item->{"id"}} = $item->{"name"} ne "" ? $item->{"name"} : $item->{"login"}; - } - - my $employee = qq| - - | . $locale->text('Employee') . qq| - | . - NTI($cgi->popup_menu('-name' => 'employee_id', '-default' => $form->{"employee_id"}, - '-values' => \@values, '-labels' => \%labels)) . qq| - - |; - - %labels = (); - @values = (); - foreach my $item (@{ $form->{"ALL_TAXZONES"} }) { - push(@values, $item->{"id"}); - $labels{$item->{"id"}} = $item->{"description"}; - } - - $taxzone = qq| - - | . $locale->text('Steuersatz') . qq| - | . - NTI($cgi->popup_menu('-name' => 'taxzone_id', '-default' => $form->{"taxzone_id"}, - '-values' => \@values, '-labels' => \%labels, '-style' => 'width: 250px')) . qq| - - |; - - %labels = (); - @values = (); - my $i = 0; - foreach my $item (@{ $form->{"ALL_CURRENCIES"} }) { - push(@values, $item); - $labels{$item} = $item; - } - - $form->{currency} = $form->{defaultcurrency} unless $form->{currency}; - my $currencies; - if (scalar @values) { - $currencies = qq| - - | . $locale->text('Currency') . qq| - | . - NTI($cgi->popup_menu('-name' => 'currency', '-default' => $form->{"currency"}, - '-values' => \@values, '-labels' => \%labels)) . qq| - - |; - } - - $form->{exchangerate} = $form->format_amount(\%myconfig, $form->{exchangerate}); - $form->{exchangerate} = "" unless $form->{exchangerate}; - + $form->get_lists("contacts" => "ALL_CONTACTS", + "shipto" => "ALL_SHIPTO", + "projects" => { "key" => "ALL_PROJECTS", + "all" => 0, + "old_id" => \@old_project_ids }, + "employees" => "ALL_EMPLOYEES", + "salesmen" => "ALL_SALESMEN", + "taxzones" => "ALL_TAXZONES", + "payments" => "ALL_PAYMENTS", + "currencies" => "ALL_CURRENCIES", + $vc => { key => "ALL_" . uc($vc), + limit => $myconfig{vclimit} + 1 }, + "price_factors" => "ALL_PRICE_FACTORS"); + + # label subs + $TMPL_VAR{sales_employee_labels} = sub { $_[0]->{name} || $_[0]->{login} }; + $TMPL_VAR{shipto_labels} = sub { join "; ", grep { $_ } map { $_[0]->{"shipto${_}" } } qw(name department_1 street city) }; + $TMPL_VAR{contact_labels} = sub { $_[0]->{"cp_name"} . ($_[0]->{cp_abteilung} ? " ($_[0]->{cp_abteilung})" : "") }; + + # vendor/customer + $TMPL_VAR{vc_keys} = sub { "$_[0]->{name}--$_[0]->{id}" }; + $TMPL_VAR{vclimit} = $myconfig{vclimit}; + $TMPL_VAR{vc_select} = "customer_or_vendor_selection_window('$form->{vc}', '', @{[ $form->{vc} eq 'vendor' ? 1 : 0 ]}, 0)"; + push @custom_hiddens, "$form->{vc}_id"; + push @custom_hiddens, "old$form->{vc}"; + push @custom_hiddens, "select$form->{vc}"; + + # currencies and exchangerate + @values = map { $_ } @{ $form->{ALL_CURRENCIES} }; + %labels = map { $_ => $_ } @{ $form->{ALL_CURRENCIES} }; + $form->{currency} = $form->{defaultcurrency} unless $form->{currency}; + $TMPL_VAR{show_exchangerate} = $form->{currency} ne $form->{defaultcurrency} && $form->{exchangerate}; + $TMPL_VAR{currencies} = NTI($cgi->popup_menu('-name' => 'currency', '-default' => $form->{"currency"}, + '-values' => \@values, '-labels' => \%labels)) if scalar @values; + push @custom_hiddens, "forex"; + push @custom_hiddens, "exchangerate" if $form->{forex}; + + # credit remaining $creditwarning = (($form->{creditlimit} != 0) && ($form->{creditremaining} < 0) && !$form->{update}) ? 1 : 0; + $TMPL_VAR{is_credit_remaining_negativ} = ($form->{creditremaining} =~ /-/) ? "0" : "1"; + + # business + $TMPL_VAR{business_label} = ($form->{vc} eq "customer" ? $locale->text('Customer type') : $locale->text('Vendor type')); - $form->{creditlimit} = $form->format_amount(\%myconfig, $form->{creditlimit}, 0, "0"); - $form->{creditremaining} = $form->format_amount(\%myconfig, $form->{creditremaining}, 0, "0"); - - $exchangerate = qq|\n{forex}>\n|; - - if ($form->{currency} ne $form->{defaultcurrency}) { - if ($form->{forex}) { - $exchangerate .= - qq|| . $locale->text('Exchangerate') - . qq|$form->{exchangerate} - {exchangerate}> -|; - } else { - $exchangerate .= - qq|| . $locale->text('Exchangerate') - . qq|{exchangerate}>|; - } - } - - if ($form->{business}) { - $business = qq| - - | . ($form->{vc} eq "customer" ? $locale->text('Customer type') : $locale->text('Vendor type')) . qq| - $form->{business}; | . $locale->text('Trade Discount') . qq| | - . $form->format_amount(\%myconfig, $form->{tradediscount} * 100) - . qq| % - -|; - } - - if ($form->{max_dunning_level}) { - $dunning = qq| - - | . $locale->text('Max. Dunning Level') . qq|: - - $form->{max_dunning_level}; - | . $locale->text('Dunning Amount') . qq|: | - . $form->format_amount(\%myconfig, $form->{dunning_amount},2) - . qq| - - -|; - } - - if ($form->{type} !~ /_quotation$/) { - $ordnumber = qq| - - | . $locale->text('Order Number') . qq| - - - - | - . $locale->text('Quotation Number') . qq| - - - - | - . $locale->text('Customer Order Number') . qq| - - - - | . $locale->text('Order Date') . qq| - $button1 - - - - | . $locale->text('Required by') . qq| - $button2 - -|; - - $n = ($form->{creditremaining} =~ /-/) ? "0" : "1"; - - $creditremaining = qq| - $shipto - - | . $locale->text('Credit Limit') . qq| - $form->{creditlimit}; | . $locale->text('Remaining') . qq| $form->{creditremaining} - - -|; - } else { - $reqlabel = ($form->{type} eq 'sales_quotation') ? $locale->text('Valid until') : $locale->text('Required by'); - if ($form->{type} eq 'sales_quotation') { - $ordnumber = qq| - - | - . $locale->text('Quotation Number') . qq| - - - -|; - } else { - $ordnumber = qq| - - | . $locale->text('RFQ Number') . qq| - - - -|; - - } - - $ordnumber .= qq| | . $locale->text('Quotation Date') . qq| $button1 - $reqlabel $button2 \n|; - $creditremaining = qq| $shipto |; - } - - $department = qq| - - | . $locale->text('Department') . qq| - - - - | if $form->{selectdepartment}; - - if ($form->{type} eq 'sales_order') { - $employee .= qq|\n| if $form->{selectemployee}; - } else { - $employee .= qq|\n|; - } + push @custom_hiddens, "ordnumber" if $form->{type} =~ /_quotation$/; + push @custom_hiddens, "customer_klass" if $form->{vc} eq 'customer'; $credittext = $locale->text('Credit Limit exceeded!!!'); @@ -701,6 +409,7 @@ sub form_header { $onload .= qq|;setupDateFormat('|. $myconfig{dateformat} .qq|', '|. $locale->text("Falsches Datumsformat!") .qq|')|; $onload .= qq|;setupPoints('|. $myconfig{numberformat} .qq|', '|. $locale->text("wrongformat") .qq|')|; + $TMPL_VAR{onload} = $onload; $form->{javascript} .= qq||; $form->{javascript} .= qq||; @@ -708,103 +417,27 @@ sub form_header { $form->header; - print qq| - - -
{script}> - - - - - -|; - - $form->hide_form(qw(id action type vc formname media format proforma queued printed emailed - title discount creditlimit creditremaining tradediscount business - max_dunning_level dunning_amount shiptoname shiptostreet shiptozipcode - shiptocity shiptocountry shiptocontact shiptophone shiptofax - shiptodepartment_1 shiptodepartment_2 shiptoemail - message email subject cc bcc taxpart taxservice taxaccounts), - map { $_.'_rate', $_.'_description' } split / /, $form->{taxaccounts} ); - print qq| - - - - - - - - - - -$jsscript + $TMPL_VAR{HIDDENS} = [ map { name => $_, value => $form->{$_} }, + qw(id action type vc formname media format proforma queued printed emailed + title creditlimit creditremaining tradediscount business + max_dunning_level dunning_amount shiptoname shiptostreet shiptozipcode + shiptocity shiptocountry shiptocontact shiptophone shiptofax + shiptodepartment_1 shiptodepartment_2 shiptoemail + message email subject cc bcc taxpart taxservice taxaccounts), + @custom_hiddens, + map { $_.'_rate', $_.'_description' } split / /, $form->{taxaccounts} ]; # deleted: discount + + %TMPL_VAR = ( + %TMPL_VAR, + is_sales => scalar ($form->{type} =~ /^sales_/), # these vars are exported, so that the template + is_order => scalar ($form->{type} =~ /_order$/), # may determine what to show + is_sales_quo => scalar ($form->{type} =~ /sales_quotation$/), + is_req_quo => scalar ($form->{type} =~ /request_quotation$/), + is_sales_ord => scalar ($form->{type} =~ /sales_order$/), + is_pur_ord => scalar ($form->{type} =~ /purchase_order$/), + ); -|; + print $form->parse_html_template("oe/orders_header", { %TMPL_VAR }); $lxdebug->leave_sub(); } @@ -814,298 +447,72 @@ sub form_footer { $form->{invtotal} = $form->{invsubtotal}; - if (($rows = $form->numtextrows($form->{notes}, 25, 8)) < 2) { - $rows = 2; - } - if (($introws = $form->numtextrows($form->{intnotes}, 35, 8)) < 2) { - $introws = 2; - } - $rows = ($rows > $introws) ? $rows : $introws; - $notes = - qq||; - $intnotes = - qq||; - - $form->{taxincluded} = ($form->{taxincluded}) ? "checked" : ""; + $rows = max 2, $form->numtextrows($form->{notes}, 25, 8); + $introws = max 2, $form->numtextrows($form->{intnotes}, 35, 8); + $rows = max $rows, $introws; - $taxincluded = ""; - if ($form->{taxaccounts}) { - $taxincluded = qq| - {taxincluded}> | - . $locale->text('Tax Included') . qq|

-|; - } + $TMPL_VAR{notes} = qq||; + $TMPL_VAR{intnotes} = qq||; if (!$form->{taxincluded}) { foreach $item (split / /, $form->{taxaccounts}) { if ($form->{"${item}_base"}) { - $form->{invtotal} += $form->{"${item}_total"} = - $form->round_amount( - $form->{"${item}_base"} * $form->{"${item}_rate"}, - 2); - $form->{"${item}_total"} = - $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); - - $tax .= qq| + $form->{invtotal} += $form->{"${item}_total"} = $form->round_amount( $form->{"${item}_base"} * $form->{"${item}_rate"}, 2); + $form->{"${item}_total"} = $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); + + $TMPL_VAR{tax} .= qq| - + - -|; + |; } } - $form->{invsubtotal} = - $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); + $form->{invsubtotal} = $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); - $subtotal = qq| - - - - -|; - - } - - if ($form->{taxincluded}) { + } else { foreach $item (split / /, $form->{taxaccounts}) { if ($form->{"${item}_base"}) { - $form->{"${item}_total"} = - $form->round_amount( - ($form->{"${item}_base"} * $form->{"${item}_rate"} / - (1 + $form->{"${item}_rate"}) - ), - 2); - $form->{"${item}_netto"} = - $form->round_amount( - ($form->{"${item}_base"} - $form->{"${item}_total"}), - 2); - $form->{"${item}_total"} = - $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); - $form->{"${item}_netto"} = - $form->format_amount(\%myconfig, $form->{"${item}_netto"}, 2); - - $tax .= qq| + $form->{"${item}_total"} = $form->round_amount( ($form->{"${item}_base"} * $form->{"${item}_rate"} / (1 + $form->{"${item}_rate"})), 2); + $form->{"${item}_netto"} = $form->round_amount( ($form->{"${item}_base"} - $form->{"${item}_total"}), 2); + $form->{"${item}_total"} = $form->format_amount(\%myconfig, $form->{"${item}_total"}, 2); + $form->{"${item}_netto"} = $form->format_amount(\%myconfig, $form->{"${item}_netto"}, 2); + + $TMPL_VAR{tax} .= qq| - + - -|; + |; } } - } $form->{oldinvtotal} = $form->{invtotal}; - $form->{invtotal} = - $form->format_amount(\%myconfig, $form->{invtotal}, 2, 0); - - print qq| - - - -{oldinvtotal}> - - - - -|; - - if ($webdav) { - $webdav_list = qq| - - - - -
$form->{title}
- - - - - -
- - - $vc - $contact - $creditremaining - $business - $dunning - $taxzone - $department - - $currencies - $exchangerate - - - - - - - - - - - - - |; -# -# -# -print qq|
| . $locale->text('Shipping Point') . qq|
| . $locale->text('Ship via') . qq|
| . $locale->text('Transaction description') . qq|
-# -# -# -# -# -# -# -# -# -#
-# -# -#
-# -# -#
-#
-
- - $openclosed - $employee - $salesmen - $ordnumber - - - - -
| . $locale->text('Project Number') . qq|$globalprojectnumber
-
-
$form->{"${item}_description"} | - . $form->{"${item}_rate"} * 100 .qq|%$form->{"${item}_description"} | . $form->{"${item}_rate"} * 100 .qq|% $form->{"${item}_total"}
| . $locale->text('Subtotal') . qq|$form->{invsubtotal}
Enthaltene $form->{"${item}_description"} | - . $form->{"${item}_rate"} * 100 .qq|%Enthaltene $form->{"${item}_description"} | . $form->{"${item}_rate"} * 100 .qq|% $form->{"${item}_total"}
Nettobetrag $form->{"${item}_netto"}
- - - - - - -
- - - - - - - - - - - $payments - -
| . $locale->text('Notes') . qq|| . $locale->text('Internal Notes') . qq|
$notes$intnotes
-
- -|; - - if ($form->{type} =~ /^sales_/) { - print qq| - - - - - - - - -|; - } - - print qq| - - -
| . $locale->text('Ertrag') . qq|| . $form->format_amount(\%myconfig, $form->{marge_total}, 2, 0) . qq|
| . $locale->text('Ertrag prozentual') . qq|| . $form->format_amount(\%myconfig, $form->{marge_percent}, 2, 0) . qq| %
-
- $taxincluded - - $subtotal - $tax - - - - -
| . $locale->text('Total') . qq|$form->{invtotal}
-
-

Dokumente im Webdav-Repository
- - -|; - foreach $file (@{ $form->{WEBDAV} }) { - $webdav_list .= qq| - - - - -|; - } - $webdav_list .= qq| -
DateinameWebdavlink
$file->{name}$file->{type}
- - -
- -|; - - print $webdav_list; - } - - print qq| - - -|; - print_options(); - - print qq| - - - - -| . $locale->text("Edit the $form->{type}") . qq|
- - - - - - -|; - - if (($form->{id})) { - print qq| - - -
| . $locale->text("Workflow $form->{type}") . qq|
- -|; - if (($form->{type} =~ /sales_quotation$/)) { - print qq| -|; - } - if ($form->{type} =~ /request_quotation$/) { - print qq| -|; - } - print qq| - -|; - - if ($form->{type} =~ /sales_order$/) { - print qq| -
$form->{heading} als neue Vorlage verwenden für
- - -|; - - } elsif ($form->{type} =~ /purchase_order$/) { - print qq| -
$form->{heading} als neue Vorlage verwenden für
- - -|; - - } else { - print qq| -
$form->{heading} als neue Vorlage verwenden für
- -|; - } - } - - $form->hide_form("saved_xyznumber"); - - print qq| - -{rowcount}> - + print $form->parse_html_template("oe/orders_footer", { + %TMPL_VAR, + webdav => $webdav, + print_options => print_options(inline => 1), + label_edit => $locale->text("Edit the $form->{type}"), + label_workflow => $locale->text("Workflow $form->{type}"), + }); -{login}> -{password}> - -
- - - -|; $lxdebug->leave_sub(); } sub update { $lxdebug->enter_sub(); + + my ($recursive_call) = shift; set_headings($form->{"id"} ? "edit" : "add"); - map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); + map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining) unless $recursive_call; $form->{update} = 1; $payment_id = $form->{payment_id} if $form->{payment_id}; @@ -1119,11 +526,11 @@ sub update { $form->{exchangerate} = $exchangerate if $form->{forex} = $exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{transdate}, $buysell); - # for pricegroups - $i = $form->{rowcount}; - $exchangerate = $form->{exchangerate} || 1; +##################### process items ###################################### + # for pricegroups + $i = $form->{rowcount}; if ( ($form->{"partnumber_$i"} eq "") && ($form->{"description_$i"} eq "") && ($form->{"partsgroup_$i"} eq "")) { @@ -1133,13 +540,10 @@ sub update { } else { - if ( $form->{type} eq 'purchase_order' - || $form->{type} eq 'request_quotation') { - IR->retrieve_item(\%myconfig, \%$form); - } - if ( $form->{type} eq 'sales_order' - || $form->{type} eq 'sales_quotation') { + if ($form->{type} =~ /^sales/) { IS->retrieve_item(\%myconfig, \%$form); + } else { + IR->retrieve_item(\%myconfig, \%$form); } my $rows = scalar @{ $form->{item_list} }; @@ -1162,6 +566,8 @@ sub update { map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] }; $form->{payment_id} = $form->{"part_payment_id_$i"} if $form->{"part_payment_id_$i"} ne ""; + $form->{"marge_price_factor_$i"} = $form->{item_list}->[0]->{price_factor}; + ($sellprice || $form->{"sellprice_$i"}) =~ /\.(\d+)/; $decimalplaces = max 2, length $1; @@ -1189,8 +595,7 @@ sub update { &set_pricegroup($i); } - &display_form; - + display_form(); } else { # ok, so this is a new part @@ -1201,14 +606,16 @@ sub update { && ($form->{"description_$i"} eq "")) { $form->{rowcount}--; $form->{"discount_$i"} = ""; - display_form(); + display_form(); } else { $form->{"id_$i"} = 0; new_item(); } } } +##################### process items ###################################### + $lxdebug->leave_sub(); } @@ -1304,10 +711,12 @@ sub search { my $vc = $form->{vc} eq "customer" ? "customers" : "vendors"; - $form->get_lists("projects" => { "key" => "ALL_PROJECTS", - "all" => 1 }, + $form->get_lists("projects" => { "key" => "ALL_PROJECTS", + "all" => 1 }, "employees" => "ALL_EMPLOYEES", - $vc => "ALL_" . uc($vc)); + "salesmen" => "ALL_SALESMEN", + $vc => "ALL_" . uc($vc) + ); my %labels = (); my @values = (""); @@ -1326,14 +735,26 @@ sub search { push(@values, $item->{"id"}); $labels{$item->{"id"}} = $item->{"name"} ne "" ? $item->{"name"} : $item->{"login"}; } + + #salesmen + my %labels_salesmen = (); + my @values_salesmen = (''); + foreach my $item (@{ $form->{"ALL_SALESMEN"} }) { + push(@values_salesmen, $item->{"id"}); + $labels_salesmen{$item->{"id"}} = $item->{"name"} ne "" ? $item->{"name"} : $item->{"login"}; + } my $employee_block = qq| | . $locale->text('Employee') . qq| + | . NTI($cgi->popup_menu('-name' => 'employee_id', '-values' => \@values, '-labels' => \%labels)) . qq| + + + | . $locale->text('Salesman') . qq| | . - NTI($cgi->popup_menu('-name' => 'employee_id', - '-values' => \@values, - '-labels' => \%labels)) . qq| + NTI($cgi->popup_menu('-name' => 'salesman_id', + '-values' => \@values_salesmen, + '-labels' => \%labels_salesmen)) . qq| |; @@ -1373,12 +794,12 @@ sub search { $vc_label $vc - $department +$department $ordlabel - $employee_block +$employee_block | . $locale->text('Transaction description') . qq| @@ -1388,10 +809,8 @@ sub search { $projectnumber - | . $locale->text('From') . qq| - $button1 - | . $locale->text('Bis') . qq| - $button2 + | . $locale->text('From') . qq| $button1 + | . $locale->text('Bis') . qq| $button2 @@ -1399,50 +818,38 @@ sub search { - - + + $delivered - + - - + + - + + - - - + + + - - + + - - + + - + +
- -
- | . $locale->text('ID') . qq| | . $locale->text('ID') . qq| $ordlabel | - . $locale->text('Date') . qq| | - . $locale->text('Required by') . qq| | . $locale->text('Date') . qq| | . $locale->text('Required by') . qq|
$vc_label $employee | - . $locale->text('Ship via') . qq| | . $locale->text('Ship via') . qq|
| - . $locale->text('Amount') . qq| | - . $locale->text('Tax') . qq| | - . $locale->text('Total') . qq| | . $locale->text('Amount') . qq| | . $locale->text('Tax') . qq| | . $locale->text('Total') . qq|
| - . $locale->text('Ertrag') . qq| | - . $locale->text('Ertrag prozentual') . qq| | . $locale->text('Ertrag') . qq| | . $locale->text('Ertrag prozentual') . qq|
| - . $locale->text('Project Number') . qq| | - . $locale->text('Transaction description') . qq| | . $locale->text('Project Number') . qq| | . $locale->text('Transaction description') . qq|
| - . $locale->text('Subtotal') . qq| | . $locale->text('Subtotal') . qq| | . $locale->text('Salesman') . qq|
@@ -1510,6 +917,7 @@ sub orders { "name", "netamount", "tax", "amount", "curr", "employee", + "salesman", "shipvia", "globalprojectnumber", "transaction_description", "open", "delivered", "marge_total", "marge_percent" @@ -1548,7 +956,7 @@ sub orders { my @hidden_variables = map { "l_${_}" } @columns; push @hidden_variables, "l_subtotal", $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered ordnumber quonumber - transaction_description transdatefrom transdateto type vc employee_id); + transaction_description transdatefrom transdateto type vc employee_id salesman_id); my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables); @@ -1564,7 +972,8 @@ sub orders { 'tax' => { 'text' => $locale->text('Tax'), }, 'amount' => { 'text' => $locale->text('Total'), }, 'curr' => { 'text' => $locale->text('Curr'), }, - 'employee' => { 'text' => $locale->text('Salesperson'), }, + 'employee' => { 'text' => $locale->text('Employee'), }, + 'salesman' => { 'text' => $locale->text('Salesman'), }, 'shipvia' => { 'text' => $locale->text('Ship via'), }, 'globalprojectnumber' => { 'text' => $locale->text('Project Number'), }, 'transaction_description' => { 'text' => $locale->text('Transaction description'), }, @@ -1574,7 +983,7 @@ sub orders { 'marge_percent' => { 'text' => $locale->text('Ertrag prozentual'), } ); - foreach my $name (qw(id transdate reqdate quonumber ordnumber name employee shipvia)) { + foreach my $name (qw(id transdate reqdate quonumber ordnumber name employee salesman shipvia)) { $column_defs{$name}->{link} = $href . "&sort=$name"; } @@ -2509,3 +1918,38 @@ sub yes { sub no { call_sub($form->{no_nextsub}); } + +###################################################################################################### +# IO ENTKOPPLUNG +# ############################################################################################### +sub display_form { + $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 .. $form->{"rowcount"}) { + IC->retrieve_accounts(\%myconfig, $form, $form->{"id_$i"}, $i, 1) if $form->{"id_$i"}; + } + + $form->{rowcount}++; + $form->{"project_id_$form->{rowcount}"} = $form->{globalproject_id}; + + $form->language_payment(\%myconfig); + + Common::webdav_folder($form) if ($webdav); + + &form_header; + + # create rows + display_row($form->{rowcount}) if $form->{rowcount}; + + &form_footer; + + $lxdebug->leave_sub(); +} +