X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fdo.pl;h=e95aaf82c634dda5b3c86a8187505319bc35cfda;hb=c781fb44ddffd751ae494781cbd239c44c844e15;hp=7f83bf399b7398b0083096116fd3ae7819e96863;hpb=c97830b0ecb981867997d0aa98b5b3cc63c20051;p=kivitendo-erp.git diff --git a/bin/mozilla/do.pl b/bin/mozilla/do.pl index 7f83bf399..e95aaf82c 100644 --- a/bin/mozilla/do.pl +++ b/bin/mozilla/do.pl @@ -1,4 +1,4 @@ -# #===================================================================== +#===================================================================== # LX-Office ERP # Copyright (C) 2004 # Based on SQL-Ledger Version 2.1.9 @@ -34,6 +34,7 @@ use List::Util qw(max sum); use POSIX qw(strftime); use YAML; +use SL::DB::DeliveryOrder; use SL::DO; use SL::IR; use SL::IS; @@ -46,21 +47,26 @@ require "bin/mozilla/invoice_io.pl"; require "bin/mozilla/io.pl"; require "bin/mozilla/reportgenerator.pl"; +use strict; + 1; # end of main sub check_do_access { - $auth->assert($form->{type} . '_edit'); + $main::auth->assert($main::form->{type} . '_edit'); } sub set_headings { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); my ($action) = @_; + my $form = $main::form; + my $locale = $main::locale; + if ($form->{type} eq 'purchase_delivery_order') { $form->{vc} = 'vendor'; $form->{title} = $action eq "edit" ? $locale->text('Edit Purchase Delivery Order') : $locale->text('Add Purchase Delivery Order'); @@ -71,14 +77,16 @@ sub set_headings { $form->{heading} = $locale->text('Delivery Order'); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub add { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + set_headings("add"); $form->{callback} = build_std_url('action=add', 'type', 'vc') unless ($form->{callback}); @@ -87,14 +95,16 @@ sub add { prepare_order(); display_form(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub edit { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + # show history button $form->{javascript} = qq||; #/show hhistory button @@ -111,15 +121,16 @@ sub edit { # reset rowcount undef $form->{rowcount}; add(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); return; # } } elsif (!$form->{id}) { add(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); return; } + my ($language_id, $printer_id); if ($form->{print_and_save}) { $form->{action} = "dispatcher"; $form->{action_print} = "1"; @@ -140,19 +151,22 @@ sub edit { display_form(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub order_links { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + # get customer/vendor $form->all_vc(\%myconfig, $form->{vc}, ($form->{vc} eq 'customer') ? "AR" : "AP"); # retrieve order/quotation - $form->{webdav} = $webdav; + $form->{webdav} = $::lx_office_conf{features}->{webdav}; $form->{jsscript} = 1; my $editing = $form->{id}; @@ -166,8 +180,10 @@ sub order_links { # get customer / vendor if ($form->{vc} eq 'vendor') { IR->get_vendor(\%myconfig, \%$form); + $form->{discount} = $form->{vendor_discount}; } else { IS->get_customer(\%myconfig, \%$form); + $form->{discount} = $form->{customer_discount}; } $form->restore_vars(qw(payment_id language_id taxzone_id intnotes cp_id)); @@ -185,18 +201,21 @@ sub order_links { $form->{employee} = "$form->{employee}--$form->{employee_id}"; - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub prepare_order { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + $form->{formname} = $form->{type} unless $form->{formname}; my $i = 0; - foreach $ref (@{ $form->{form_details} }) { + foreach my $ref (@{ $form->{form_details} }) { $form->{rowcount} = ++$i; map { $form->{"${_}_$i"} = $ref->{$_} } keys %{$ref}; @@ -207,28 +226,32 @@ sub prepare_order { } else { $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"}); } - ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); + my ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; - $decimalplaces = ($dec > 2) ? $dec : 2; + my $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); + $form->{"lastcost_$i"} = $form->format_amount(\%myconfig, $form->{"lastcost_$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); } - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub form_header { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + $form->{employee_id} = $form->{old_employee_id} if $form->{old_employee_id}; $form->{salesman_id} = $form->{old_salesman_id} if $form->{old_salesman_id}; @@ -236,7 +259,7 @@ sub form_header { $form->{jsscript} = 1; #write Trigger - $jsscript = Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", "reqdate", "BL", "trigger2"); + my $jsscript = Form->write_trigger(\%myconfig, "2", "transdate", "BL", "trigger1", "reqdate", "BL", "trigger2"); my @old_project_ids = ($form->{"globalproject_id"}); map({ push(@old_project_ids, $form->{"project_id_$_"}) @@ -282,38 +305,56 @@ sub form_header { print $form->parse_html_template('do/form_header'); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub form_footer { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + $form->{PRINT_OPTIONS} = print_options('inline' => 1); print $form->parse_html_template('do/form_footer'); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub update_delivery_order { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + set_headings($form->{"id"} ? "edit" : "add"); $form->{update} = 1; + my $payment_id; $payment_id = $form->{payment_id} if $form->{payment_id}; check_name($form->{vc}); - + $form->{discount} = $form->{"$form->{vc}_discount"} if defined $form->{"$form->{vc}_discount"}; + # Problem: Wenn man ohne Erneuern einen Kunden/Lieferanten + # wechselt, wird der entsprechende Kunden/ Lieferantenrabatt + # nicht übernommen. Grundproblem: In Commit 82574e78 + # hab ich aus discount customer_discount und vendor_discount + # gemacht und entsprechend an den Oberflächen richtig hin- + # geschoben. Die damals bessere Lösung wäre gewesen: + # In den Templates nur die hidden für form-discount wieder ein- + # setzen dann wäre die Verrenkung jetzt nicht notwendig. + # TODO: Ggf. Bugfix 1284, 1575 und 817 wieder zusammenführen + # Testfälle: Kunden mit Rabatt 0 -> Rabatt 20 i.O. + # Kunde mit Rabatt 20 -> Rabatt 0 i.O. + # Kunde mit Rabatt 20 -> Rabatt 5,5 i.O. $form->{payment_id} = $payment_id if $form->{payment_id} eq ""; # for pricegroups - $i = $form->{rowcount}; + my $i = $form->{rowcount}; if ( ($form->{"partnumber_$i"} eq "") && ($form->{"description_$i"} eq "") @@ -332,12 +373,12 @@ sub update_delivery_order { my $rows = scalar @{ $form->{item_list} }; if ($rows) { - $form->{"qty_$i"} = 1 unless ($form->{"qty_$i"}); + $form->{"qty_$i"} = 1 unless $form->parse_amount(\%myconfig, $form->{"qty_$i"}); if ($rows > 1) { select_item(); - exit; + ::end_of_request(); } else { @@ -345,6 +386,7 @@ sub update_delivery_order { $form->{"marge_price_factor_$i"} = $form->{item_list}->[0]->{price_factor}; $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}); + $form->{"lastcost_$i"} = $form->format_amount(\%myconfig, $form->{"lastcost_$i"}); $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}); } @@ -360,6 +402,7 @@ sub update_delivery_order { && ($form->{"description_$i"} eq "")) { $form->{rowcount}--; $form->{"discount_$i"} = ""; + $form->{"not_discountable_$i"} = ""; display_form(); } else { @@ -369,14 +412,18 @@ sub update_delivery_order { } } - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub search { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; + $form->{vc} = $form->{type} eq 'purchase_delivery_order' ? 'vendor' : 'customer'; $form->get_lists("projects" => { "key" => "ALL_PROJECTS", @@ -393,15 +440,20 @@ sub search { print $form->parse_html_template('do/search'); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub orders { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); - ($form->{ $form->{vc} }, $form->{"${form->{vc}}_id"}) = split(/--/, $form->{ $form->{vc} }); + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; + my $cgi = $main::cgi; + + ($form->{ $form->{vc} }, $form->{"$form->{vc}_id"}) = split(/--/, $form->{ $form->{vc} }); report_generator_set_default_sort('transdate', 1); @@ -430,7 +482,7 @@ sub orders { my @hidden_variables = map { "l_${_}" } @columns; push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber - transaction_description transdatefrom transdateto type vc employee_id salesman_id); + transaction_description transdatefrom transdateto type vc employee_id salesman_id project_id); my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables); @@ -441,7 +493,7 @@ sub orders { 'donumber' => { 'text' => $locale->text('Delivery Order'), }, 'ordnumber' => { 'text' => $locale->text('Order'), }, 'name' => { 'text' => $form->{vc} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), }, - 'employee' => { 'text' => $locale->text('Salesperson'), }, + 'employee' => { 'text' => $locale->text('Employee'), }, 'shipvia' => { 'text' => $locale->text('Ship via'), }, 'globalprojectnumber' => { 'text' => $locale->text('Project Number'), }, 'transaction_description' => { 'text' => $locale->text('Transaction description'), }, @@ -474,7 +526,7 @@ sub orders { push @options, $locale->text('Vendor') . " : $form->{vendor}"; } if ($form->{department}) { - ($department) = split /--/, $form->{department}; + my ($department) = split /--/, $form->{department}; push @options, $locale->text('Department') . " : $department"; } if ($form->{donumber}) { @@ -513,19 +565,20 @@ sub orders { 'attachment_basename' => $attachment_basename . strftime('_%Y%m%d', localtime time), ); $report->set_options_from_form(); + $locale->set_numberformat_wo_thousands_separator(\%myconfig) if lc($report->{options}->{output_format}) eq 'csv'; # add sort and escape callback, this one we use for the add sub $form->{callback} = $href .= "&sort=$form->{sort}"; # escape callback for href - $callback = $form->escape($href); + my $callback = $form->escape($href); my $edit_url = build_std_url('action=edit', 'type', 'vc'); my $edit_order_url = build_std_url('script=oe.pl', 'type=' . ($form->{type} eq 'sales_delivery_order' ? 'sales_order' : 'purchase_order'), 'action=edit'); my $idx = 1; - foreach $dord (@{ $form->{DO} }) { + foreach my $dord (@{ $form->{DO} }) { $dord->{open} = $dord->{closed} ? $locale->text('No') : $locale->text('Yes'); $dord->{delivered} = $dord->{delivered} ? $locale->text('Yes') : $locale->text('No'); @@ -548,14 +601,20 @@ sub orders { $report->generate_with_headers(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub save { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my (%params) = @_; check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; + $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); $form->isblank("transdate", $locale->text('Delivery Order Date missing!')); @@ -563,46 +622,59 @@ sub save { $form->{donumber} =~ s/^\s*//g; $form->{donumber} =~ s/\s*$//g; - $msg = ucfirst $form->{vc}; + my $msg = ucfirst $form->{vc}; $form->isblank($form->{vc}, $locale->text($msg . " missing!")); # $locale->text('Customer missing!'); # $locale->text('Vendor missing!'); + remove_emptied_rows(); validate_items(); # if the name changed get new values if (check_name($form->{vc})) { update(); - exit; + ::end_of_request(); } $form->{id} = 0 if $form->{saveasnew}; - + # best case fix für bug 1079. Einkaufsrabatt wird nicht richtig + # aus Lieferantenauftrag -> Lieferschein -> Rechnung übernommen + # Tritt nur auf, wenn man direkt über Lieferschein -> speichern -> + # Workflow Rechnung geht (beim Aufruf über edit() i.O.) + # Gut. DO-save() speichert den Discount im DB-Format 0.12 für + # 12%, die Konvertierung wird leider in $form gemacht und daher + # wird die Maske mit dem falschen Rabatt wieder aufgebaut. + # Wie immer: backup_vars verwenden um nichts anderes kaputt zu + # machen. jan 03.03.2010 + # nicht mehr notwendig da für bug 1284 der backend aufruf entsprechend + # geändert wurde DO->save(); - # saving the history if(!exists $form->{addition}) { $form->{snumbers} = qq|donumber_| . $form->{donumber}; - $form->{addition} = "SAVED"; - $form->save_history($form->dbconnect(\%myconfig)); + $form->{addition} = "SAVED"; + $form->save_history; } # /saving the history $form->{simple_save} = 1; - if(!$form->{print_and_save}) { + if (!$params{no_redirect} && !$form->{print_and_save}) { set_headings("edit"); update(); - exit; + ::end_of_request(); } - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub delete { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my $locale = $main::locale; + map { delete $form->{$_} } qw(action header login password); my @variables = map { { 'key' => $_, 'value' => $form->{$_} } } grep { '' eq ref $form->{$_} } keys %{ $form }; @@ -611,37 +683,45 @@ sub delete { print $form->parse_html_template('do/delete', { 'VARIABLES' => \@variables }); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub delete_delivery_order { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; + if (DO->delete()) { # saving the history if(!exists $form->{addition}) { $form->{snumbers} = qq|donumber_| . $form->{donumber}; - $form->{addition} = "DELETED"; - $form->save_history($form->dbconnect(\%myconfig)); + $form->{addition} = "DELETED"; + $form->save_history; } # /saving the history $form->info($locale->text('Delivery Order deleted!')); - exit(); + ::end_of_request(); } $form->error($locale->text('Cannot delete delivery order!')); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub invoice { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; check_do_access(); - $auth->assert($form->{type} eq 'purchase_delivery_order' ? 'vendor_invoice_edit' : 'invoice_edit'); + $main::auth->assert($form->{type} eq 'purchase_delivery_order' ? 'vendor_invoice_edit' : 'invoice_edit'); $form->{convert_from_do_ids} = $form->{id}; $form->{deliverydate} = $form->{transdate}; @@ -653,6 +733,7 @@ sub invoice { delete @{$form}{qw(id closed delivered)}; + my ($script, $buysell); if ($form->{type} eq 'purchase_delivery_order') { $form->{title} = $locale->text('Add Vendor Invoice'); $form->{script} = 'ir.pl'; @@ -666,20 +747,39 @@ sub invoice { $buysell = 'buy'; } - for $i (1 .. $form->{rowcount}) { - map { $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if $form->{"${_}_${i}"} } qw(ship qty sellprice listprice basefactor); + for my $i (1 .. $form->{rowcount}) { + # für bug 1284 + unless ($form->{"ordnumber"}) { + if ($form->{discount}) { # Falls wir einen Lieferanten-/Kundenrabatt haben + # und rabattfähig sind, dann + unless ($form->{"not_discountable_$i"}) { + $form->{"discount_$i"} = $form->{discount}*100; # ... nehmen wir diesen Rabatt + } + } + } + map { $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if $form->{"${_}_${i}"} } qw(ship qty sellprice listprice lastcost basefactor); } $form->{type} = "invoice"; # locale messages - $locale = new Locale "$myconfig{countrycode}", "$script"; + $main::locale = new Locale "$myconfig{countrycode}", "$script"; + $locale = $main::locale; require "bin/mozilla/$form->{script}"; my $currency = $form->{currency}; invoice_links(); + if ($form->{ordnumber}) { + require SL::DB::Order; + if (my $order = SL::DB::Manager::Order->find_by(ordnumber => $form->{ordnumber})) { + $order->load; + $form->{orddate} = $order->transdate_as_date; + $form->{$_} = $order->$_ for qw(payment_id salesman_id taxzone_id quonumber); + } + } + $form->{currency} = $currency; $form->{exchangerate} = ""; $form->{forex} = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{invdate}, $buysell); @@ -688,21 +788,26 @@ sub invoice { prepare_invoice(); # format amounts - for $i (1 .. $form->{rowcount}) { + for my $i (1 .. $form->{rowcount}) { $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"}); - ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); + my ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; - $decimalplaces = ($dec > 2) ? $dec : 2; + my $decimalplaces = ($dec > 2) ? $dec : 2; # copy delivery date from reqdate for order -> invoice conversion $form->{"deliverydate_$i"} = $form->{"reqdate_$i"} unless $form->{"deliverydate_$i"}; + $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); + $form->{"lastcost_$i"} = + $form->format_amount(\%myconfig, $form->{"lastcost_$i"}, + $decimalplaces); + (my $dec_qty) = ($form->{"qty_$i"} =~ /\.(\d+)/); $dec_qty = length $dec_qty; $form->{"qty_$i"} = @@ -712,14 +817,18 @@ sub invoice { display_form(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub invoice_multi { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; check_do_access(); - $auth->assert($form->{type} eq 'sales_delivery_order' ? 'invoice_edit' : 'vendor_invoice_edit'); + $main::auth->assert($form->{type} eq 'sales_delivery_order' ? 'invoice_edit' : 'vendor_invoice_edit'); my @do_ids = map { $form->{"trans_id_$_"} } grep { $form->{"multi_id_$_"} } (1..$form->{rowcount}); @@ -742,7 +851,7 @@ sub invoice_multi { # zwischenspeichern (DO.pm) und als ' '-separierte Liste wieder zurueckschreiben # Hinweis: delete gibt den wert zurueck und loescht danach das element (nett und einfach) # $shell: perldoc perlunc; /delete EXPR - $form->{donumber} = delete $form->{donumber_array}; + $form->{donumber} = delete $form->{donumber_array}; $form->{deliverydate} = $form->{transdate}; $form->{transdate} = $form->current_date(\%myconfig); $form->{duedate} = $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1); @@ -750,7 +859,7 @@ sub invoice_multi { $form->{closed} = 0; $form->{defaultcurrency} = $form->get_default_currency(\%myconfig); - my $buysell; + my ($script, $buysell); if ($source_type eq 'purchase_delivery_order') { $form->{title} = $locale->text('Add Vendor Invoice'); $form->{script} = 'ir.pl'; @@ -766,15 +875,35 @@ sub invoice_multi { map { delete $form->{$_} } qw(id subject message cc bcc printed emailed queued); + # get vendor or customer discount + my $vc_discount; + my $saved_form = save_form(); + if ($form->{vc} eq 'vendor') { + IR->get_vendor(\%myconfig, \%$form); + $vc_discount = $form->{vendor_discount}; + } else { + IS->get_customer(\%myconfig, \%$form); + $vc_discount = $form->{customer_discount}; + } + restore_form($saved_form); + $form->{rowcount} = 0; foreach my $ref (@{ $form->{form_details} }) { $form->{rowcount}++; $ref->{reqdate} ||= $ref->{dord_transdate}; # copy transdates into each invoice row map { $form->{"${_}_$form->{rowcount}"} = $ref->{$_} } keys %{ $ref }; - map { $form->{"${_}_$form->{rowcount}"} = $form->format_amount(\%myconfig, $ref->{$_}) } qw(qty sellprice discount lastcost); - $form->{"discount_$form->{rowcount}"} = $form->{"discount_$form->{rowcount}"} * 100; #s.a. Bug 1151 - # Anm.: Eine Änderung des discounts in der SL/DO.pm->retrieve (select (doi.discount * 100) as discount) ergibt in psql einen - # Wert von 10.0000001490116. Ferner ist der Rabatt in der Rechnung dann bei 1.0 (?). Deswegen lasse ich das hier. jb 10.10.09 + map { $form->{"${_}_$form->{rowcount}"} = $form->format_amount(\%myconfig, $ref->{$_}) } qw(qty sellprice lastcost); + + if ($vc_discount){ # falls wir einen Lieferanten/Kundenrabatt haben + # und keinen anderen discount wert an $i ... + $form->{"discount_$form->{rowcount}"} ||= $vc_discount; # ... nehmen wir diesen Rabatt + } + + $form->{"discount_$form->{rowcount}"} = $form->{"discount_$form->{rowcount}"} * 100; #s.a. Bug 1151 + # Anm.: Eine Änderung des discounts in der SL/DO.pm->retrieve (select (doi.discount * 100) as discount) ergibt in psql einen + # Wert von 10.0000001490116. Ferner ist der Rabatt in der Rechnung dann bei 1.0 (?). Deswegen lasse ich das hier. jb 10.10.09 + + $form->{"discount_$form->{rowcount}"} = $form->format_amount(\%myconfig, $form->{"discount_$form->{rowcount}"}); } delete $form->{form_details}; @@ -786,18 +915,21 @@ sub invoice_multi { prepare_invoice(); display_form(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub save_as_new { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); + my $form = $main::form; + $form->{saveasnew} = 1; $form->{closed} = 0; $form->{delivered} = 0; map { delete $form->{$_} } qw(printed emailed queued); + delete @{ $form }{ grep { m/^stock_(?:in|out)_\d+/ } keys %{ $form } }; # Let Lx-Office assign a new order number if the user hasn't changed the # previous one. If it has been changed manually then use it as-is. @@ -809,17 +941,17 @@ sub save_as_new { save(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub e_mail { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); check_do_access(); - $form->{print_and_save} = 1; + my $form = $main::form; - $print_post = 1; + $form->{print_and_save} = 1; my $saved_form = save_form(); @@ -829,20 +961,22 @@ sub e_mail { edit_e_mail(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub calculate_stock_in_out { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; my $i = shift; if (!$form->{"id_${i}"}) { - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); return ''; } - AM->retrieve_all_units(); + my $all_units = AM->retrieve_all_units(); my $in_out = $form->{type} =~ /^sales/ ? 'out' : 'in'; my $sinfo = DO->unpack_stock_information('packed' => $form->{"stock_${in_out}_${i}"}); @@ -854,18 +988,20 @@ sub calculate_stock_in_out { 'amount_unit' => $all_units->{$form->{"partunit_$i"}}->{base_unit}, 'conv_units' => 'convertible_not_smaller', 'max_places' => 2); - $content .= qq| |; + $content = qq|${content} |; - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); return $content; } sub get_basic_bin_wh_info { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); my $stock_info = shift; + my $form = $main::form; + foreach my $sinfo (@{ $stock_info }) { next unless ($sinfo->{bin_id}); @@ -873,11 +1009,13 @@ sub get_basic_bin_wh_info { map { $sinfo->{"${_}_description"} = $sinfo->{"${_}description"} = $bin_info->{"${_}_description"} } qw(bin warehouse); } - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub stock_in_out_form { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; if ($form->{in_out} eq 'out') { stock_out_form(); @@ -885,14 +1023,16 @@ sub stock_in_out_form { stock_in_form(); } - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub redo_stock_info { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); my %params = @_; + my $form = $main::form; + my @non_empty = grep { $_->{qty} } @{ $params{stock_info} }; if ($params{add_empty_row}) { @@ -904,45 +1044,57 @@ sub redo_stock_info { @{ $params{stock_info} } = @non_empty; - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub update_stock_in { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; my $stock_info = []; foreach my $i (1..$form->{rowcount}) { $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"}); - push @{ $stock_info }, { map { $_ => $form->{"${_}_${i}"} } qw(warehouse_id bin_id chargenumber qty unit) }; + push @{ $stock_info }, { map { $_ => $form->{"${_}_${i}"} } qw(warehouse_id bin_id chargenumber bestbefore qty unit) }; } display_stock_in_form($stock_info); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub stock_in_form { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; my $stock_info = DO->unpack_stock_information('packed' => $form->{stock}); display_stock_in_form($stock_info); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub display_stock_in_form { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); my $stock_info = shift; + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; + + $form->{jsscript} = 1; + $form->{title} = $locale->text('Stock'); my $part_info = IC->get_basic_part_info('id' => $form->{parts_id}); my $units = AM->retrieve_units(\%myconfig, $form); - my $units_data = AM->unit_select_data($units, undef, undef, $part_info->{unit}); + # der zweite Parameter von unit_select_data gibt den default-Namen (selected) vor + my $units_data = AM->unit_select_data($units, $form->{do_unit}, undef, $part_info->{unit}); $form->get_lists('warehouses' => { 'key' => 'WAREHOUSES', 'bins' => 'BINS' }); @@ -956,11 +1108,26 @@ sub display_stock_in_form { 'STOCK_INFO' => $stock_info, 'PART_INFO' => $part_info, }); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); +} + +sub _stock_in_out_set_qty_display { + my $stock_info = shift; + my $form = $::form; + my $all_units = AM->retrieve_all_units(); + my $sum = AM->sum_with_unit(map { $_->{qty}, $_->{unit} } @{ $stock_info }); + $form->{qty_display} = $form->format_amount_units(amount => $sum * 1, + part_unit => $form->{partunit}, + amount_unit => $all_units->{ $form->{partunit} }->{base_unit}, + conv_units => 'convertible_not_smaller', + max_places => 2); } sub set_stock_in { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; my $stock_info = []; @@ -969,19 +1136,25 @@ sub set_stock_in { next if ($form->{"qty_$i"} <= 0); - push @{ $stock_info }, { map { $_ => $form->{"${_}_${i}"} } qw(warehouse_id bin_id chargenumber qty unit) }; + push @{ $stock_info }, { map { $_ => $form->{"${_}_${i}"} } qw(warehouse_id bin_id chargenumber bestbefore qty unit) }; } $form->{stock} = YAML::Dump($stock_info); + _stock_in_out_set_qty_display($stock_info); + $form->header(); print $form->parse_html_template('do/set_stock_in_out'); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub stock_out_form { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; $form->{title} = $locale->text('Release From Stock'); @@ -1004,7 +1177,8 @@ sub stock_out_form { foreach my $sinfo (@{ $stock_info }) { next if (($row->{bin_id} != $sinfo->{bin_id}) || ($row->{warehouse_id} != $sinfo->{warehouse_id}) || - ($row->{chargenumber} ne $sinfo->{chargenumber})); + ($row->{chargenumber} ne $sinfo->{chargenumber}) || + ($row->{bestbefore} ne $sinfo->{bestbefore})); map { $row->{"stock_$_"} = $sinfo->{$_} } qw(qty unit error); } @@ -1023,11 +1197,15 @@ sub stock_out_form { 'WHCONTENTS' => $form->{delivered} ? $stock_info : \@contents, 'PART_INFO' => $part_info, }); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub set_stock_out { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; my $stock_info = []; @@ -1040,6 +1218,7 @@ sub set_stock_out { 'warehouse_id' => $form->{"warehouse_id_$i"}, 'bin_id' => $form->{"bin_id_$i"}, 'chargenumber' => $form->{"chargenumber_$i"}, + 'bestbefore' => $form->{"bestbefore_$i"}, 'qty' => $form->{"qty_$i"}, 'unit' => $form->{"unit_$i"}, 'row' => $i, @@ -1057,20 +1236,28 @@ sub set_stock_out { stock_in_out_form(); } else { + _stock_in_out_set_qty_display($stock_info); + $form->header(); print $form->parse_html_template('do/set_stock_in_out'); } - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub transfer_in { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; - if (DO->is_marked_as_delivered('id' => $form->{id})) { + if ($form->{id} && DO->is_marked_as_delivered(id => $form->{id})) { $form->show_generic_error($locale->text('The parts for this delivery order have already been transferred in.'), 'back_button' => 1); } + save(no_redirect => 1); + my @part_ids = map { $form->{"id_${_}"} } grep { $form->{"id_${_}"} && $form->{"stock_in_${_}"} } (1 .. $form->{rowcount}); my @all_requests; @@ -1098,39 +1285,47 @@ sub transfer_in { my $do_base_qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}) * $units->{$form->{"unit_$i"}}->{factor} / $base_unit_factor; - if ($do_base_qty != $row_sum_base_qty) { - push @{ $form->{ERRORS} }, $locale->text('Error in position #1: You must either assign no stock at all or the full quantity of #2 #3.', - $i, $form->{"qty_$i"}, $form->{"unit_$i"}); - } +# if ($do_base_qty != $row_sum_base_qty) { +# push @{ $form->{ERRORS} }, $locale->text('Error in position #1: You must either assign no stock at all or the full quantity of #2 #3.', +# $i, $form->{"qty_$i"}, $form->{"unit_$i"}); +# } } if (@{ $form->{ERRORS} }) { push @{ $form->{ERRORS} }, $locale->text('The delivery order has not been marked as delivered. The warehouse contents have not changed.'); + set_headings('edit'); update(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); - exit 0; + ::end_of_request(); } } DO->transfer_in_out('direction' => 'in', 'requests' => \@all_requests); - $form->{delivered} = 1; + SL::DB::DeliveryOrder->new(id => $form->{id})->load->update_attributes(delivered => 1); - save(); + $form->{callback} = 'do.pl?action=edit&type=purchase_delivery_order&id=' . $form->escape($form->{id}); + $form->redirect; - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub transfer_out { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; + my %myconfig = %main::myconfig; + my $locale = $main::locale; - if (DO->is_marked_as_delivered('id' => $form->{id})) { + if ($form->{id} && DO->is_marked_as_delivered(id => $form->{id})) { $form->show_generic_error($locale->text('The parts for this delivery order have already been transferred out.'), 'back_button' => 1); } + save(no_redirect => 1); + my @part_ids = map { $form->{"id_${_}"} } grep { $form->{"id_${_}"} && $form->{"stock_out_${_}"} } (1 .. $form->{rowcount}); my @all_requests; @@ -1150,8 +1345,9 @@ sub transfer_out { foreach my $request (@{ DO->unpack_stock_information('packed' => $form->{"stock_out_$i"}) }) { $request->{parts_id} = $form->{"id_$i"}; $request->{base_qty} = $request->{qty} * $units->{$request->{unit}}->{factor} / $base_unit_factor; + $request->{project_id} = $form->{"project_id_$i"} ? $form->{"project_id_$i"} : $form->{globalproject_id}; - my $map_key = join '--', ($form->{"id_$i"}, @{$request}{qw(warehouse_id bin_id chargenumber)}); + my $map_key = join '--', ($form->{"id_$i"}, @{$request}{qw(warehouse_id bin_id chargenumber bestbefore)}); $request_map{$map_key} ||= $request; $request_map{$map_key}->{sum_base_qty} ||= 0; @@ -1163,12 +1359,12 @@ sub transfer_out { next if (0 == $row_sum_base_qty); - my $do_base_qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}) * $units->{$form->{"unit_$i"}}->{factor} / $base_unit_factor; + my $do_base_qty = $form->{"qty_$i"} * $units->{$form->{"unit_$i"}}->{factor} / $base_unit_factor; - if ($do_base_qty != $row_sum_base_qty) { - push @{ $form->{ERRORS} }, $locale->text('Error in position #1: You must either assign no transfer at all or the full quantity of #2 #3.', - $i, $form->{"qty_$i"}, $form->{"unit_$i"}); - } +# if ($do_base_qty != $row_sum_base_qty) { +# push @{ $form->{ERRORS} }, $locale->text('Error in position #1: You must either assign no transfer at all or the full quantity of #2 #3.', +# $i, $form->{"qty_$i"}, $form->{"unit_$i"}); +# } } if (%request_map) { @@ -1177,7 +1373,7 @@ sub transfer_out { my @contents = DO->get_item_availability('parts_id' => \@part_ids); foreach my $inv (@contents) { - my $map_key = join '--', @{$inv}{qw(parts_id warehouse_id bin_id chargenumber)}; + my $map_key = join '--', @{$inv}{qw(parts_id warehouse_id bin_id chargenumber bestbefore)}; next unless ($request_map{$map_key}); @@ -1185,43 +1381,60 @@ sub transfer_out { $request->{ok} = $request->{sum_base_qty} <= $inv->{qty}; } - foreach $request (values %request_map) { + foreach my $request (values %request_map) { next if ($request->{ok}); my $pinfo = $part_info_map{$request->{parts_id}}; my $binfo = $bin_info_map{$request->{bin_id}}; - push @{ $form->{ERRORS} }, $locale->text("There is not enough available of '#1' at warehouse '#2', bin '#3', #4, for the transfer of #5.", - $pinfo->{description}, $binfo->{warehouse_description}, $binfo->{bin_description}, - $request->{chargenumber} ? $locale->text('chargenumber #1', $request->{chargenumber}) : $locale->text('no chargenumber'), - $form->format_amount_units('amount' => $request->{sum_base_qty}, - 'part_unit' => $pinfo->{unit}, - 'conv_units' => 'convertible_not_smaller')); + if ($::lx_office_conf{features}->{show_best_before}) { + push @{ $form->{ERRORS} }, $locale->text("There is not enough available of '#1' at warehouse '#2', bin '#3', #4, #5, for the transfer of #6.", + $pinfo->{description}, + $binfo->{warehouse_description}, + $binfo->{bin_description}, + $request->{chargenumber} ? $locale->text('chargenumber #1', $request->{chargenumber}) : $locale->text('no chargenumber'), + $request->{bestbefore} ? $locale->text('bestbefore #1', $request->{bestbefore}) : $locale->text('no bestbefore'), + $form->format_amount_units('amount' => $request->{sum_base_qty}, + 'part_unit' => $pinfo->{unit}, + 'conv_units' => 'convertible_not_smaller')); + } else { + push @{ $form->{ERRORS} }, $locale->text("There is not enough available of '#1' at warehouse '#2', bin '#3', #4, for the transfer of #5.", + $pinfo->{description}, + $binfo->{warehouse_description}, + $binfo->{bin_description}, + $request->{chargenumber} ? $locale->text('chargenumber #1', $request->{chargenumber}) : $locale->text('no chargenumber'), + $form->format_amount_units('amount' => $request->{sum_base_qty}, + 'part_unit' => $pinfo->{unit}, + 'conv_units' => 'convertible_not_smaller')); + } } } if (@{ $form->{ERRORS} }) { push @{ $form->{ERRORS} }, $locale->text('The delivery order has not been marked as delivered. The warehouse contents have not changed.'); + set_headings('edit'); update(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); - exit 0; + ::end_of_request(); } } - DO->transfer_in_out('direction' => 'out', 'requests' => \@all_requests); - $form->{delivered} = 1; + SL::DB::DeliveryOrder->new(id => $form->{id})->load->update_attributes(delivered => 1); - save(); + $form->{callback} = 'do.pl?action=edit&type=sales_delivery_order&id=' . $form->escape($form->{id}); + $form->redirect; - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub mark_closed { - $lxdebug->enter_sub(); + $main::lxdebug->enter_sub(); + + my $form = $main::form; DO->close_orders('ids' => [ $form->{id} ]); @@ -1229,23 +1442,26 @@ sub mark_closed { update(); - $lxdebug->leave_sub(); + $main::lxdebug->leave_sub(); } sub yes { - call_sub($form->{yes_nextsub}); + call_sub($main::form->{yes_nextsub}); } sub no { - call_sub($form->{no_nextsub}); + call_sub($main::form->{no_nextsub}); } sub update { - call_sub($form->{update_nextsub} || $form->{nextsub} || 'update_delivery_order'); + call_sub($main::form->{update_nextsub} || $main::form->{nextsub} || 'update_delivery_order'); } sub dispatcher { + my $form = $main::form; + my $locale = $main::locale; + foreach my $action (qw(update ship_to print e_mail save transfer_out transfer_in mark_closed save_as_new invoice delete)) { if ($form->{"action_${action}"}) { call_sub($action);