1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
7 #=====================================================================
8 # SQL-Ledger, Accounting
9 # Copyright (c) 1998-2003
11 # Author: Dieter Simader
12 # Email: dsimader@sql-ledger.org
13 # Web: http://www.sql-ledger.org
16 # This program is free software; you can redistribute it and/or modify
17 # it under the terms of the GNU General Public License as published by
18 # the Free Software Foundation; either version 2 of the License, or
19 # (at your option) any later version.
21 # This program is distributed in the hope that it will be useful,
22 # but WITHOUT ANY WARRANTY; without even the implied warranty of
23 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 # GNU General Public License for more details.
25 # You should have received a copy of the GNU General Public License
26 # along with this program; if not, write to the Free Software
27 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
29 #======================================================================
32 #======================================================================
35 use List::MoreUtils qw(uniq);
36 use List::Util qw(max sum);
37 use POSIX qw(strftime);
40 use SL::DB::DeliveryOrder;
44 use SL::MoreCommon qw(ary_diff restore_form save_form);
45 use SL::ReportGenerator;
47 use Sort::Naturally ();
48 require "bin/mozilla/common.pl";
49 require "bin/mozilla/io.pl";
50 require "bin/mozilla/reportgenerator.pl";
59 $main::auth->assert($main::form->{type} . '_edit');
63 $main::lxdebug->enter_sub();
69 my $form = $main::form;
70 my $locale = $main::locale;
72 if ($form->{type} eq 'purchase_delivery_order') {
73 $form->{vc} = 'vendor';
74 $form->{title} = $action eq "edit" ? $locale->text('Edit Purchase Delivery Order') : $locale->text('Add Purchase Delivery Order');
76 $form->{vc} = 'customer';
77 $form->{title} = $action eq "edit" ? $locale->text('Edit Sales Delivery Order') : $locale->text('Add Sales Delivery Order');
80 $form->{heading} = $locale->text('Delivery Order');
82 $main::lxdebug->leave_sub();
86 $main::lxdebug->enter_sub();
90 if (($::form->{type} =~ /purchase/) && !$::instance_conf->get_allow_new_purchase_invoice) {
91 $::form->show_generic_error($::locale->text("You do not have the permissions to access this function."));
94 my $form = $main::form;
98 $form->{show_details} = $::myconfig{show_form_details};
99 $form->{callback} = build_std_url('action=add', 'type', 'vc') unless ($form->{callback});
105 $main::lxdebug->leave_sub();
109 $main::lxdebug->enter_sub();
113 my $form = $main::form;
115 $form->{show_details} = $::myconfig{show_form_details};
117 # show history button
118 $form->{javascript} = qq|<script type="text/javascript" src="js/show_history.js"></script>|;
119 #/show hhistory button
121 $form->{simple_save} = 0;
123 set_headings("edit");
125 # editing without stuff to edit? try adding it first
126 if ($form->{rowcount} && !$form->{print_and_save}) {
127 # map { $id++ if $form->{"multi_id_$_"} } (1 .. $form->{rowcount});
131 undef $form->{rowcount};
133 $main::lxdebug->leave_sub();
136 } elsif (!$form->{id}) {
138 $main::lxdebug->leave_sub();
142 my ($language_id, $printer_id);
143 if ($form->{print_and_save}) {
144 $form->{action} = "dispatcher";
145 $form->{action_print} = "1";
146 $form->{resubmit} = 1;
147 $language_id = $form->{language_id};
148 $printer_id = $form->{printer_id};
151 set_headings("edit");
156 if ($form->{print_and_save}) {
157 $form->{language_id} = $language_id;
158 $form->{printer_id} = $printer_id;
163 $main::lxdebug->leave_sub();
167 $main::lxdebug->enter_sub();
171 my $form = $main::form;
172 my %myconfig = %main::myconfig;
174 # retrieve order/quotation
175 my $editing = $form->{id};
177 DO->retrieve('vc' => $form->{vc},
178 'ids' => $form->{id});
180 $form->backup_vars(qw(payment_id language_id taxzone_id salesman_id taxincluded cp_id intnotes delivery_term_id currency));
182 # get customer / vendor
183 if ($form->{vc} eq 'vendor') {
184 IR->get_vendor(\%myconfig, \%$form);
185 $form->{discount} = $form->{vendor_discount};
187 IS->get_customer(\%myconfig, \%$form);
188 $form->{discount} = $form->{customer_discount};
191 $form->restore_vars(qw(payment_id language_id taxzone_id intnotes cp_id delivery_term_id));
192 $form->restore_vars(qw(currency)) if ($form->{id} || $form->{convert_from_oe_ids});
193 $form->restore_vars(qw(taxincluded)) if $form->{id};
194 $form->restore_vars(qw(salesman_id)) if $editing;
196 $main::lxdebug->leave_sub();
200 $main::lxdebug->enter_sub();
204 my $form = $main::form;
205 my %myconfig = %main::myconfig;
207 $form->{formname} = $form->{type} unless $form->{formname};
210 foreach my $ref (@{ $form->{form_details} }) {
211 $form->{rowcount} = ++$i;
213 map { $form->{"${_}_$i"} = $ref->{$_} } keys %{$ref};
215 for my $i (1 .. $form->{rowcount}) {
217 $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100);
219 $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"});
221 my ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/);
223 my $decimalplaces = ($dec > 2) ? $dec : 2;
225 # copy reqdate from deliverydate for invoice -> order conversion
226 $form->{"reqdate_$i"} = $form->{"deliverydate_$i"} unless $form->{"reqdate_$i"};
228 $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces);
229 $form->{"lastcost_$i"} = $form->format_amount(\%myconfig, $form->{"lastcost_$i"}, $decimalplaces);
231 (my $dec_qty) = ($form->{"qty_$i"} =~ /\.(\d+)/);
232 $dec_qty = length $dec_qty;
233 $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty);
236 $main::lxdebug->leave_sub();
240 $main::lxdebug->enter_sub();
244 my $form = $main::form;
245 my %myconfig = %main::myconfig;
247 my $class = "SL::DB::" . ($form->{vc} eq 'customer' ? 'Customer' : 'Vendor');
248 $form->{VC_OBJ} = $class->load_cached($form->{ $form->{vc} . '_id' });
250 $form->{employee_id} = $form->{old_employee_id} if $form->{old_employee_id};
251 $form->{salesman_id} = $form->{old_salesman_id} if $form->{old_salesman_id};
253 my $vc = $form->{vc} eq "customer" ? "customers" : "vendors";
254 $form->get_lists("price_factors" => "ALL_PRICE_FACTORS",
255 "business_types" => "ALL_BUSINESS_TYPES",
257 $form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all;
260 my @old_project_ids = uniq grep { $_ } map { $_ * 1 } ($form->{"globalproject_id"}, map { $form->{"project_id_$_"} } 1..$form->{"rowcount"});
261 my @old_ids_cond = @old_project_ids ? (id => \@old_project_ids) : ();
263 if (($vc eq 'customers') && $::instance_conf->get_customer_projects_only_in_sales) {
266 customer_id => $::form->{customer_id},
267 billable_customer_id => $::form->{customer_id},
272 and => [ active => 1, @customer_cond ],
276 $::form->{ALL_PROJECTS} = SL::DB::Manager::Project->get_all_sorted(query => \@conditions);
277 $::form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{employee_id}, deleted => 0 ] ]);
278 $::form->{ALL_SALESMEN} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{salesman_id}, deleted => 0 ] ]);
279 $::form->{ALL_SHIPTO} = SL::DB::Manager::Shipto->get_all_sorted(query => [
280 or => [ trans_id => $::form->{"$::form->{vc}_id"} * 1, and => [ shipto_id => $::form->{shipto_id} * 1, trans_id => undef ] ]
282 $::form->{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
284 cp_cv_id => $::form->{"$::form->{vc}_id"} * 1,
287 cp_id => $::form->{cp_id} * 1
292 my $dispatch_to_popup = '';
293 if ($form->{resubmit} && ($form->{format} eq "html")) {
294 $dispatch_to_popup = "window.open('about:blank','Beleg'); document.do.target = 'Beleg';";
295 $dispatch_to_popup .= "document.do.submit();";
296 } elsif ($form->{resubmit}) {
297 # emulate click for resubmitting actions
298 $dispatch_to_popup = "document.do.${_}.click(); " for grep { /^action_/ } keys %$form;
300 $::request->{layout}->add_javascripts_inline("\$(function(){$dispatch_to_popup});");
303 $form->{follow_up_trans_info} = $form->{donumber} .'('. $form->{VC_OBJ}->name .')';
305 $::request->{layout}->use_javascript(map { "${_}.js" } qw(kivi.File kivi.MassDeliveryOrderPrint kivi.SalesPurchase ckeditor/ckeditor ckeditor/adapters/jquery kivi.io autocomplete_customer autocomplete_part));
308 push @custom_hidden, map { "shiptocvar_" . $_->name } @{ SL::DB::Manager::CustomVariableConfig->get_all(where => [ module => 'ShipTo' ]) };
310 $::form->{HIDDENS} = [ map { +{ name => $_, value => $::form->{$_} } } (@custom_hidden) ];
313 # Fix für Bug 1082 Erwartet wird: 'abteilungsNAME--abteilungsID'
314 # und Erweiterung für Bug 1760:
315 # Das war leider nur ein Teil-Fix, da das Verhalten den 'Erneuern'-Knopf
316 # nicht überlebt. Konsequent jetzt auf L umgestellt
317 # $ perldoc SL::Template::Plugin::L
318 # Daher entsprechend nur die Anpassung in form_header
319 # und in DO.pm gemacht. 4 Testfälle:
320 # department_id speichern | i.O.
321 # department_id lesen | i.O.
322 # department leer überlebt erneuern | i.O.
323 # department nicht leer überlebt erneuern | i.O.
324 # $main::lxdebug->message(0, 'ABTEILUNGS ID in form?' . $form->{department_id});
325 print $form->parse_html_template('do/form_header');
327 $main::lxdebug->leave_sub();
331 $main::lxdebug->enter_sub();
335 my $form = $main::form;
337 $form->{PRINT_OPTIONS} = print_options('inline' => 1);
338 $form->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
340 print $form->parse_html_template('do/form_footer',
341 {transfer_default => ($::instance_conf->get_transfer_default)});
343 $main::lxdebug->leave_sub();
346 sub update_delivery_order {
347 $main::lxdebug->enter_sub();
351 my $form = $main::form;
352 my %myconfig = %main::myconfig;
354 set_headings($form->{"id"} ? "edit" : "add");
356 $form->{insertdate} = SL::DB::DeliveryOrder->new(id => $form->{id})->load->itime_as_date if $form->{id};
361 $payment_id = $form->{payment_id} if $form->{payment_id};
363 my $vc = $form->{vc};
364 if (($form->{"previous_${vc}_id"} || $form->{"${vc}_id"}) != $form->{"${vc}_id"}) {
365 $::form->{salesman_id} = SL::DB::Manager::Employee->current->id if exists $::form->{salesman_id};
367 IS->get_customer(\%myconfig, $form) if $vc eq 'customer';
368 IR->get_vendor(\%myconfig, $form) if $vc eq 'vendor';
371 $form->{discount} = $form->{"$form->{vc}_discount"} if defined $form->{"$form->{vc}_discount"};
372 # Problem: Wenn man ohne Erneuern einen Kunden/Lieferanten
373 # wechselt, wird der entsprechende Kunden/ Lieferantenrabatt
374 # nicht übernommen. Grundproblem: In Commit 82574e78
375 # hab ich aus discount customer_discount und vendor_discount
376 # gemacht und entsprechend an den Oberflächen richtig hin-
377 # geschoben. Die damals bessere Lösung wäre gewesen:
378 # In den Templates nur die hidden für form-discount wieder ein-
379 # setzen dann wäre die Verrenkung jetzt nicht notwendig.
380 # TODO: Ggf. Bugfix 1284, 1575 und 817 wieder zusammenführen
381 # Testfälle: Kunden mit Rabatt 0 -> Rabatt 20 i.O.
382 # Kunde mit Rabatt 20 -> Rabatt 0 i.O.
383 # Kunde mit Rabatt 20 -> Rabatt 5,5 i.O.
384 $form->{payment_id} = $payment_id if $form->{payment_id} eq "";
386 my $i = $form->{rowcount};
388 if ( ($form->{"partnumber_$i"} eq "")
389 && ($form->{"description_$i"} eq "")
390 && ($form->{"partsgroup_$i"} eq "")) {
397 if ($form->{type} eq 'purchase_delivery_order') {
398 IR->retrieve_item(\%myconfig, $form);
401 IS->retrieve_item(\%myconfig, $form);
405 my $rows = scalar @{ $form->{item_list} };
408 $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"});
409 if( !$form->{"qty_$i"} ) {
410 $form->{"qty_$i"} = 1;
415 select_item(mode => $mode, pre_entered_qty => $form->{"qty_$i"});
416 $::dispatcher->end_request;
420 my $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"});
422 map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] };
424 $form->{"marge_price_factor_$i"} = $form->{item_list}->[0]->{price_factor};
427 $form->{"sellprice_$i"} = $sellprice;
429 my $record = _make_record();
430 my $price_source = SL::PriceSource->new(record_item => $record->items->[$i-1], record => $record);
431 my $best_price = $price_source->best_price;
432 my $best_discount = $price_source->best_discount;
435 $::form->{"sellprice_$i"} = $best_price->price;
436 $::form->{"active_price_source_$i"} = $best_price->source;
438 if ($best_discount) {
439 $::form->{"discount_$i"} = $best_discount->discount;
440 $::form->{"active_discount_source_$i"} = $best_discount->source;
444 $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"});
445 $form->{"lastcost_$i"} = $form->format_amount(\%myconfig, $form->{"lastcost_$i"});
446 $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"});
447 $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100.0);
454 # ok, so this is a new part
455 # ask if it is a part or service item
457 if ( $form->{"partsgroup_$i"}
458 && ($form->{"partsnumber_$i"} eq "")
459 && ($form->{"description_$i"} eq "")) {
461 $form->{"discount_$i"} = "";
462 $form->{"not_discountable_$i"} = "";
466 $form->{"id_$i"} = 0;
472 $main::lxdebug->leave_sub();
476 $main::lxdebug->enter_sub();
480 my $form = $main::form;
481 my %myconfig = %main::myconfig;
482 my $locale = $main::locale;
484 $form->{vc} = $form->{type} eq 'purchase_delivery_order' ? 'vendor' : 'customer';
486 $form->get_lists("projects" => { "key" => "ALL_PROJECTS",
488 "business_types" => "ALL_BUSINESS_TYPES");
489 $form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ deleted => 0 ]);
490 $form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all;
491 $form->{title} = $locale->text('Delivery Orders');
495 print $form->parse_html_template('do/search');
497 $main::lxdebug->leave_sub();
501 $main::lxdebug->enter_sub();
505 my $form = $main::form;
506 my %myconfig = %main::myconfig;
507 my $locale = $main::locale;
508 my $cgi = $::request->{cgi};
510 $::request->{layout}->use_javascript(map { "${_}.js" } qw(kivi.MassDeliveryOrderPrint));
511 ($form->{ $form->{vc} }, $form->{"$form->{vc}_id"}) = split(/--/, $form->{ $form->{vc} });
513 report_generator_set_default_sort('transdate', 1);
517 $form->{rowcount} = scalar @{ $form->{DO} };
520 ids transdate reqdate
522 ordnumber customernumber cusordnumber
523 name employee salesman
524 shipvia globalprojectnumber
525 transaction_description department
530 $form->{l_open} = $form->{l_closed} = "Y" if ($form->{open} && $form->{closed});
531 $form->{l_delivered} = "Y" if ($form->{delivered} && $form->{notdelivered});
533 $form->{title} = $locale->text('Delivery Orders');
535 my $attachment_basename = $form->{vc} eq 'vendor' ? $locale->text('purchase_delivery_order_list') : $locale->text('sales_delivery_order_list');
537 my $report = SL::ReportGenerator->new(\%myconfig, $form);
539 my @hidden_variables = map { "l_${_}" } @columns;
540 push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber serialnumber cusordnumber
541 transaction_description transdatefrom transdateto reqdatefrom reqdateto
542 type vc employee_id salesman_id project_id parts_partnumber parts_description
543 insertdatefrom insertdateto business_id);
545 my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables);
548 'ids' => { 'text' => '<input type="checkbox" id="multi_all" value="1">', 'align' => 'center' },
549 'transdate' => { 'text' => $locale->text('Delivery Order Date'), },
550 'reqdate' => { 'text' => $locale->text('Reqdate'), },
551 'id' => { 'text' => $locale->text('ID'), },
552 'donumber' => { 'text' => $locale->text('Delivery Order'), },
553 'ordnumber' => { 'text' => $locale->text('Order'), },
554 'customernumber' => { 'text' => $locale->text('Customer Number'), },
555 'cusordnumber' => { 'text' => $locale->text('Customer Order Number'), },
556 'name' => { 'text' => $form->{vc} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), },
557 'employee' => { 'text' => $locale->text('Employee'), },
558 'salesman' => { 'text' => $locale->text('Salesman'), },
559 'shipvia' => { 'text' => $locale->text('Ship via'), },
560 'globalprojectnumber' => { 'text' => $locale->text('Project Number'), },
561 'transaction_description' => { 'text' => $locale->text('Transaction description'), },
562 'open' => { 'text' => $locale->text('Open'), },
563 'delivered' => { 'text' => $locale->text('Delivered'), },
564 'department' => { 'text' => $locale->text('Department'), },
565 'insertdate' => { 'text' => $locale->text('Insert Date'), },
568 foreach my $name (qw(id transdate reqdate donumber ordnumber name employee salesman shipvia transaction_description department insertdate)) {
569 my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
570 $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";
573 $form->{"l_type"} = "Y";
574 map { $column_defs{$_}->{visible} = $form->{"l_${_}"} ? 1 : 0 } @columns;
576 $column_defs{ids}->{visible} = 'HTML';
578 $report->set_columns(%column_defs);
579 $report->set_column_order(@columns);
581 $report->set_export_options('orders', @hidden_variables, qw(sort sortdir));
583 $report->set_sort_indicator($form->{sort}, $form->{sortdir});
586 if ($form->{customer}) {
587 push @options, $locale->text('Customer') . " : $form->{customer}";
589 if ($form->{vendor}) {
590 push @options, $locale->text('Vendor') . " : $form->{vendor}";
592 if ($form->{cp_name}) {
593 push @options, $locale->text('Contact Person') . " : $form->{cp_name}";
595 if ($form->{department_id}) {
596 push @options, $locale->text('Department') . " : " . SL::DB::Department->new(id => $form->{department_id})->load->description;
598 if ($form->{donumber}) {
599 push @options, $locale->text('Delivery Order Number') . " : $form->{donumber}";
601 if ($form->{ordnumber}) {
602 push @options, $locale->text('Order Number') . " : $form->{ordnumber}";
604 push @options, $locale->text('Serial Number') . " : $form->{serialnumber}" if $form->{serialnumber};
605 if ($form->{business_id}) {
606 my $vc_type_label = $form->{vc} eq 'customer' ? $locale->text('Customer type') : $locale->text('Vendor type');
607 push @options, $vc_type_label . " : " . SL::DB::Business->new(id => $form->{business_id})->load->description;
609 if ($form->{transaction_description}) {
610 push @options, $locale->text('Transaction description') . " : $form->{transaction_description}";
612 if ($form->{parts_description}) {
613 push @options, $locale->text('Part Description') . " : $form->{parts_description}";
615 if ($form->{parts_partnumber}) {
616 push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}";
618 if ( $form->{transdatefrom} or $form->{transdateto} ) {
619 push @options, $locale->text('Delivery Order Date');
620 push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if $form->{transdatefrom};
621 push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1) if $form->{transdateto};
623 if ( $form->{reqdatefrom} or $form->{reqdateto} ) {
624 push @options, $locale->text('Reqdate');
625 push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{reqdatefrom}, 1) if $form->{reqdatefrom};
626 push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{reqdateto}, 1) if $form->{reqdateto};
628 if ( $form->{insertdatefrom} or $form->{insertdateto} ) {
629 push @options, $locale->text('Insert Date');
630 push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{insertdatefrom}, 1) if $form->{insertdatefrom};
631 push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{insertdateto}, 1) if $form->{insertdateto};
634 push @options, $locale->text('Open');
636 if ($form->{closed}) {
637 push @options, $locale->text('Closed');
639 if ($form->{delivered}) {
640 push @options, $locale->text('Delivered');
642 if ($form->{notdelivered}) {
643 push @options, $locale->text('Not delivered');
646 # all_vc ruft get_employee auf, dort wird emloyee überschrieben, deshalb retten:
647 my $save_employee_id = $form->{'employee_id'};
648 my $save_employee = $form->{'employee'};
649 $form->all_vc(\%myconfig, $form->{vc}, ($form->{vc} eq 'customer') ? "AR" : "AP");
650 $form->{'employee_id'} = $save_employee_id;
651 $form->{'employee'} = $save_employee;
653 my $pr = SL::DB::Manager::Printer->find_by(
654 printer_description => $::locale->text("sales_delivery_order_printer"));
656 $form->{printer_id} = $pr->id;
659 $report->set_options('top_info_text' => join("\n", @options),
660 'raw_top_info_text' => $form->parse_html_template('do/orders_top'),
661 'raw_bottom_info_text' => $form->parse_html_template('do/orders_bottom', { print_options => print_options(inline => 1,hide_language_id => 1) }),
662 'output_format' => 'HTML',
663 'title' => $form->{title},
664 'attachment_basename' => $attachment_basename . strftime('_%Y%m%d', localtime time),
666 $report->set_options_from_form();
667 $locale->set_numberformat_wo_thousands_separator(\%myconfig) if lc($report->{options}->{output_format}) eq 'csv';
669 # add sort and escape callback, this one we use for the add sub
670 $form->{callback} = $href .= "&sort=$form->{sort}";
672 # escape callback for href
673 my $callback = $form->escape($href);
675 my $edit_url = build_std_url('action=edit', 'type', 'vc');
676 my $edit_order_url = build_std_url('script=oe.pl', 'type=' . ($form->{type} eq 'sales_delivery_order' ? 'sales_order' : 'purchase_order'), 'action=edit');
680 foreach my $dord (@{ $form->{DO} }) {
681 $dord->{open} = $dord->{closed} ? $locale->text('No') : $locale->text('Yes');
682 $dord->{delivered} = $dord->{delivered} ? $locale->text('Yes') : $locale->text('No');
684 my $row = { map { $_ => { 'data' => $dord->{$_} } } @columns };
686 my $ord_id = $dord->{id};
688 'raw_data' => $cgi->hidden('-name' => "trans_id_${idx}", '-value' => $ord_id)
689 . $cgi->checkbox('-name' => "multi_id_${idx}",' id' => "multi_id_id_".$ord_id, '-value' => 1, '-label' => ''),
690 'valign' => 'center',
694 $row->{donumber}->{link} = $edit_url . "&id=" . E($dord->{id}) . "&callback=${callback}";
695 $row->{ordnumber}->{link} = $edit_order_url . "&id=" . E($dord->{oe_id}) . "&callback=${callback}" if $dord->{oe_id};
696 $report->add_data($row);
701 $report->generate_with_headers();
703 $main::lxdebug->leave_sub();
707 $main::lxdebug->enter_sub();
713 my $form = $main::form;
714 my %myconfig = %main::myconfig;
715 my $locale = $main::locale;
717 $form->mtime_ischanged('delivery_orders');
719 $form->{defaultcurrency} = $form->get_default_currency(\%myconfig);
721 $form->isblank("transdate", $locale->text('Delivery Order Date missing!'));
723 $form->{donumber} =~ s/^\s*//g;
724 $form->{donumber} =~ s/\s*$//g;
726 my $msg = ucfirst $form->{vc};
727 $form->isblank($form->{vc} . "_id", $locale->text($msg . " missing!"));
729 # $locale->text('Customer missing!');
730 # $locale->text('Vendor missing!');
732 remove_emptied_rows();
735 # if the name changed get new values
736 my $vc = $form->{vc};
737 if (($form->{"previous_${vc}_id"} || $form->{"${vc}_id"}) != $form->{"${vc}_id"}) {
738 $::form->{salesman_id} = SL::DB::Manager::Employee->current->id if exists $::form->{salesman_id};
740 IS->get_customer(\%myconfig, $form) if $vc eq 'customer';
741 IR->get_vendor(\%myconfig, $form) if $vc eq 'vendor';
744 $::dispatcher->end_request;
747 $form->{id} = 0 if $form->{saveasnew};
751 if(!exists $form->{addition}) {
752 $form->{snumbers} = qq|donumber_| . $form->{donumber};
753 $form->{addition} = "SAVED";
756 # /saving the history
758 $form->{simple_save} = 1;
759 if (!$params{no_redirect} && !$form->{print_and_save}) {
760 delete @{$form}{ary_diff([keys %{ $form }], [qw(login id script type cursor_fokus)])};
762 $::dispatcher->end_request;
764 $main::lxdebug->leave_sub();
768 $main::lxdebug->enter_sub();
772 my $form = $main::form;
773 my %myconfig = %main::myconfig;
774 my $locale = $main::locale;
778 if(!exists $form->{addition}) {
779 $form->{snumbers} = qq|donumber_| . $form->{donumber};
780 $form->{addition} = "DELETED";
783 # /saving the history
785 $form->info($locale->text('Delivery Order deleted!'));
786 $::dispatcher->end_request;
789 $form->error($locale->text('Cannot delete delivery order!'));
791 $main::lxdebug->leave_sub();
795 $main::lxdebug->enter_sub();
797 my $form = $main::form;
798 my %myconfig = %main::myconfig;
799 my $locale = $main::locale;
802 $form->mtime_ischanged('delivery_orders');
804 $main::auth->assert($form->{type} eq 'purchase_delivery_order' ? 'vendor_invoice_edit' : 'invoice_edit');
806 $form->{convert_from_do_ids} = $form->{id};
807 $form->{deliverydate} = $form->{transdate};
808 $form->{transdate} = $form->{invdate} = $form->current_date(\%myconfig);
809 $form->{duedate} = $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1);
810 $form->{defaultcurrency} = $form->get_default_currency(\%myconfig);
814 delete @{$form}{qw(id closed delivered)};
816 my ($script, $buysell);
817 if ($form->{type} eq 'purchase_delivery_order') {
818 $form->{title} = $locale->text('Add Vendor Invoice');
819 $form->{script} = 'ir.pl';
824 $form->{title} = $locale->text('Add Sales Invoice');
825 $form->{script} = 'is.pl';
830 for my $i (1 .. $form->{rowcount}) {
831 map { $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if $form->{"${_}_${i}"} } qw(ship qty sellprice lastcost basefactor discount);
833 # adds a customer/vendor discount, unless we have a workflow case
834 # CAVEAT: has to be done, after the above parse_amount
835 unless ($form->{"ordnumber"}) {
836 if ($form->{discount}) { # Falls wir einen Lieferanten-/Kundenrabatt haben
837 # und rabattfähig sind, dann
838 unless ($form->{"not_discountable_$i"}) {
839 $form->{"discount_$i"} = $form->{discount}*100; # ... nehmen wir diesen Rabatt
843 $form->{"donumber_$i"} = $form->{donumber};
844 $form->{"converted_from_delivery_order_items_id_$i"} = delete $form->{"delivery_order_items_id_$i"};
847 $form->{type} = "invoice";
850 $main::locale = Locale->new("$myconfig{countrycode}", "$script");
851 $locale = $main::locale;
853 require "bin/mozilla/$form->{script}";
855 my $currency = $form->{currency};
858 if ($form->{ordnumber}) {
859 require SL::DB::Order;
860 if (my $order = SL::DB::Manager::Order->find_by(ordnumber => $form->{ordnumber})) {
862 $form->{orddate} = $order->transdate_as_date;
863 $form->{$_} = $order->$_ for qw(payment_id salesman_id taxzone_id quonumber);
867 $form->{currency} = $currency;
868 $form->{exchangerate} = "";
869 $form->{forex} = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{invdate}, $buysell);
870 $form->{exchangerate} = $form->{forex} if ($form->{forex});
875 for my $i (1 .. $form->{rowcount}) {
876 $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"});
878 my ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/);
880 my $decimalplaces = ($dec > 2) ? $dec : 2;
882 # copy delivery date from reqdate for order -> invoice conversion
883 $form->{"deliverydate_$i"} = $form->{"reqdate_$i"}
884 unless $form->{"deliverydate_$i"};
887 $form->{"sellprice_$i"} =
888 $form->format_amount(\%myconfig, $form->{"sellprice_$i"},
891 $form->{"lastcost_$i"} =
892 $form->format_amount(\%myconfig, $form->{"lastcost_$i"},
895 (my $dec_qty) = ($form->{"qty_$i"} =~ /\.(\d+)/);
896 $dec_qty = length $dec_qty;
898 $form->format_amount(\%myconfig, $form->{"qty_$i"}, $dec_qty);
904 $main::lxdebug->leave_sub();
908 $main::lxdebug->enter_sub();
910 my $form = $main::form;
911 my %myconfig = %main::myconfig;
912 my $locale = $main::locale;
915 $main::auth->assert($form->{type} eq 'sales_delivery_order' ? 'invoice_edit' : 'vendor_invoice_edit');
917 my @do_ids = map { $form->{"trans_id_$_"} } grep { $form->{"multi_id_$_"} } (1..$form->{rowcount});
919 if (!scalar @do_ids) {
920 $form->show_generic_error($locale->text('You have not selected any delivery order.'));
923 map { delete $form->{$_} } grep { m/^(?:trans|multi)_id_\d+/ } keys %{ $form };
925 if (!DO->retrieve('vc' => $form->{vc}, 'ids' => \@do_ids)) {
926 $form->show_generic_error($form->{vc} eq 'customer' ?
927 $locale->text('You cannot create an invoice for delivery orders for different customers.') :
928 $locale->text('You cannot create an invoice for delivery orders from different vendors.'),
932 my $source_type = $form->{type};
933 $form->{convert_from_do_ids} = join ' ', @do_ids;
934 # bei der auswahl von mehreren Lieferscheinen fuer eine Rechnung, die einfach in donumber_array
935 # zwischenspeichern (DO.pm) und als ' '-separierte Liste wieder zurueckschreiben
936 # Hinweis: delete gibt den wert zurueck und loescht danach das element (nett und einfach)
937 # $shell: perldoc perlunc; /delete EXPR
938 $form->{donumber} = delete $form->{donumber_array};
939 $form->{ordnumber} = delete $form->{ordnumber_array};
940 $form->{cusordnumber} = delete $form->{cusordnumber_array};
941 $form->{deliverydate} = $form->{transdate};
942 $form->{transdate} = $form->current_date(\%myconfig);
943 $form->{duedate} = $form->current_date(\%myconfig, $form->{invdate}, $form->{terms} * 1);
944 $form->{type} = "invoice";
946 $form->{defaultcurrency} = $form->get_default_currency(\%myconfig);
948 my ($script, $buysell);
949 if ($source_type eq 'purchase_delivery_order') {
950 $form->{title} = $locale->text('Add Vendor Invoice');
951 $form->{script} = 'ir.pl';
956 $form->{title} = $locale->text('Add Sales Invoice');
957 $form->{script} = 'is.pl';
962 map { delete $form->{$_} } qw(id subject message cc bcc printed emailed queued);
964 # get vendor or customer discount
966 my $saved_form = save_form();
967 if ($form->{vc} eq 'vendor') {
968 IR->get_vendor(\%myconfig, \%$form);
969 $vc_discount = $form->{vendor_discount};
971 IS->get_customer(\%myconfig, \%$form);
972 $vc_discount = $form->{customer_discount};
974 # use payment terms from customer or vendor
975 restore_form($saved_form,0,qw(payment_id));
977 $form->{rowcount} = 0;
978 foreach my $ref (@{ $form->{form_details} }) {
980 $ref->{reqdate} ||= $ref->{dord_transdate}; # copy transdates into each invoice row
981 map { $form->{"${_}_$form->{rowcount}"} = $ref->{$_} } keys %{ $ref };
982 map { $form->{"${_}_$form->{rowcount}"} = $form->format_amount(\%myconfig, $ref->{$_}) } qw(qty sellprice lastcost);
983 $form->{"converted_from_delivery_order_items_id_$form->{rowcount}"} = delete $form->{"delivery_order_items_id_$form->{rowcount}"};
985 if ($vc_discount){ # falls wir einen Lieferanten/Kundenrabatt haben
986 # und keinen anderen discount wert an $i ...
987 $form->{"discount_$form->{rowcount}"} ||= $vc_discount; # ... nehmen wir diesen Rabatt
990 $form->{"discount_$form->{rowcount}"} = $form->{"discount_$form->{rowcount}"} * 100; #s.a. Bug 1151
991 # Anm.: Eine Änderung des discounts in der SL/DO.pm->retrieve (select (doi.discount * 100) as discount) ergibt in psql einen
992 # Wert von 10.0000001490116. Ferner ist der Rabatt in der Rechnung dann bei 1.0 (?). Deswegen lasse ich das hier. jb 10.10.09
994 $form->{"discount_$form->{rowcount}"} = $form->format_amount(\%myconfig, $form->{"discount_$form->{rowcount}"});
996 delete $form->{form_details};
998 $locale = Locale->new("$myconfig{countrycode}", "$script");
1000 require "bin/mozilla/$form->{script}";
1007 $main::lxdebug->leave_sub();
1011 $main::lxdebug->enter_sub();
1015 my $form = $main::form;
1017 $form->{saveasnew} = 1;
1018 $form->{closed} = 0;
1019 $form->{delivered} = 0;
1020 map { delete $form->{$_} } qw(printed emailed queued);
1021 delete @{ $form }{ grep { m/^stock_(?:in|out)_\d+/ } keys %{ $form } };
1022 $form->{"converted_from_delivery_order_items_id_$_"} = delete $form->{"delivery_order_items_id_$_"} for 1 .. $form->{"rowcount"};
1023 # Let kivitendo assign a new order number if the user hasn't changed the
1024 # previous one. If it has been changed manually then use it as-is.
1025 $form->{donumber} =~ s/^\s*//g;
1026 $form->{donumber} =~ s/\s*$//g;
1027 if ($form->{saved_donumber} && ($form->{saved_donumber} eq $form->{donumber})) {
1028 delete($form->{donumber});
1033 $main::lxdebug->leave_sub();
1037 $main::lxdebug->enter_sub();
1041 $::form->mtime_ischanged('delivery_orders','mail');
1043 $::form->{print_and_save} = 1;
1045 my $saved_form = save_form();
1049 restore_form($saved_form, 0, qw(id ordnumber quonumber));
1053 $main::lxdebug->leave_sub();
1056 sub calculate_stock_in_out {
1057 $main::lxdebug->enter_sub();
1059 my $form = $main::form;
1063 if (!$form->{"id_${i}"}) {
1064 $main::lxdebug->leave_sub();
1068 my $all_units = AM->retrieve_all_units();
1070 my $in_out = $form->{type} =~ /^sales/ ? 'out' : 'in';
1071 my $sinfo = DO->unpack_stock_information('packed' => $form->{"stock_${in_out}_${i}"});
1073 my $do_qty = AM->sum_with_unit($::form->{"qty_$i"}, $::form->{"unit_$i"});
1074 my $sum = AM->sum_with_unit(map { $_->{qty}, $_->{unit} } @{ $sinfo });
1075 my $matches = $do_qty == $sum;
1077 my $content = $form->format_amount_units('amount' => $sum * 1,
1078 'part_unit' => $form->{"partunit_$i"},
1079 'amount_unit' => $all_units->{$form->{"partunit_$i"}}->{base_unit},
1080 'conv_units' => 'convertible_not_smaller',
1082 $content = qq|<span id="stock_in_out_qty_display_${i}">${content}</span><input type=hidden id='stock_in_out_qty_matches_$i' value='$matches'> <input type="button" onclick="open_stock_in_out_window('${in_out}', $i);" value="?">|;
1084 $main::lxdebug->leave_sub();
1089 sub get_basic_bin_wh_info {
1090 $main::lxdebug->enter_sub();
1092 my $stock_info = shift;
1094 my $form = $main::form;
1096 foreach my $sinfo (@{ $stock_info }) {
1097 next unless ($sinfo->{bin_id});
1099 my $bin_info = WH->get_basic_bin_info('id' => $sinfo->{bin_id});
1100 map { $sinfo->{"${_}_description"} = $sinfo->{"${_}description"} = $bin_info->{"${_}_description"} } qw(bin warehouse);
1103 $main::lxdebug->leave_sub();
1106 sub stock_in_out_form {
1107 $main::lxdebug->enter_sub();
1109 my $form = $main::form;
1111 if ($form->{in_out} eq 'out') {
1117 $main::lxdebug->leave_sub();
1120 sub redo_stock_info {
1121 $main::lxdebug->enter_sub();
1125 my $form = $main::form;
1127 my @non_empty = grep { $_->{qty} } @{ $params{stock_info} };
1129 if ($params{add_empty_row}) {
1131 'warehouse_id' => scalar(@non_empty) ? $non_empty[-1]->{warehouse_id} : undef,
1132 'bin_id' => scalar(@non_empty) ? $non_empty[-1]->{bin_id} : undef,
1136 @{ $params{stock_info} } = @non_empty;
1138 $main::lxdebug->leave_sub();
1141 sub update_stock_in {
1142 $main::lxdebug->enter_sub();
1144 my $form = $main::form;
1145 my %myconfig = %main::myconfig;
1147 my $stock_info = [];
1149 foreach my $i (1..$form->{rowcount}) {
1150 $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"});
1151 push @{ $stock_info }, { map { $_ => $form->{"${_}_${i}"} } qw(warehouse_id bin_id chargenumber
1152 bestbefore qty unit delivery_order_items_stock_id) };
1155 display_stock_in_form($stock_info);
1157 $main::lxdebug->leave_sub();
1161 $main::lxdebug->enter_sub();
1163 my $form = $main::form;
1165 my $stock_info = DO->unpack_stock_information('packed' => $form->{stock});
1167 display_stock_in_form($stock_info);
1169 $main::lxdebug->leave_sub();
1172 sub display_stock_in_form {
1173 $main::lxdebug->enter_sub();
1175 my $stock_info = shift;
1177 my $form = $main::form;
1178 my %myconfig = %main::myconfig;
1179 my $locale = $main::locale;
1181 $form->{title} = $locale->text('Stock');
1183 my $part_info = IC->get_basic_part_info('id' => $form->{parts_id});
1185 # Standardlagerplatz für Standard-Auslagern verwenden, falls keiner für die Ware explizit definiert wurde
1186 if ($::instance_conf->get_transfer_default_use_master_default_bin) {
1187 $part_info->{warehouse_id} ||= $::instance_conf->get_warehouse_id;
1188 $part_info->{bin_id} ||= $::instance_conf->get_bin_id;
1191 my $units = AM->retrieve_units(\%myconfig, $form);
1192 # der zweite Parameter von unit_select_data gibt den default-Namen (selected) vor
1193 my $units_data = AM->unit_select_data($units, $form->{do_unit}, undef, $part_info->{unit});
1195 $form->get_lists('warehouses' => { 'key' => 'WAREHOUSES',
1196 'bins' => 'BINS' });
1198 redo_stock_info('stock_info' => $stock_info, 'add_empty_row' => !$form->{delivered});
1200 get_basic_bin_wh_info($stock_info);
1202 $form->header(no_layout => 1);
1203 print $form->parse_html_template('do/stock_in_form', { 'UNITS' => $units_data,
1204 'STOCK_INFO' => $stock_info,
1205 'PART_INFO' => $part_info, });
1207 $main::lxdebug->leave_sub();
1210 sub _stock_in_out_set_qty_display {
1211 my $stock_info = shift;
1213 my $all_units = AM->retrieve_all_units();
1214 my $sum = AM->sum_with_unit(map { $_->{qty}, $_->{unit} } @{ $stock_info });
1215 $form->{qty_display} = $form->format_amount_units(amount => $sum * 1,
1216 part_unit => $form->{partunit},
1217 amount_unit => $all_units->{ $form->{partunit} }->{base_unit},
1218 conv_units => 'convertible_not_smaller',
1223 $main::lxdebug->enter_sub();
1225 my $form = $main::form;
1226 my %myconfig = %main::myconfig;
1228 my $stock_info = [];
1230 foreach my $i (1..$form->{rowcount}) {
1231 $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"});
1233 next if ($form->{"qty_$i"} <= 0);
1235 push @{ $stock_info }, { map { $_ => $form->{"${_}_${i}"} } qw(delivery_order_items_stock_id warehouse_id bin_id chargenumber bestbefore qty unit) };
1238 $form->{stock} = YAML::Dump($stock_info);
1240 _stock_in_out_set_qty_display($stock_info);
1242 my $do_qty = AM->sum_with_unit($::form->parse_amount(\%::myconfig, $::form->{do_qty}), $::form->{do_unit});
1243 my $transfer_qty = AM->sum_with_unit(map { $_->{qty}, $_->{unit} } @{ $stock_info });
1246 print $form->parse_html_template('do/set_stock_in_out', {
1247 qty_matches => $do_qty == $transfer_qty,
1250 $main::lxdebug->leave_sub();
1253 sub stock_out_form {
1254 $main::lxdebug->enter_sub();
1256 my $form = $main::form;
1257 my %myconfig = %main::myconfig;
1258 my $locale = $main::locale;
1260 $form->{title} = $locale->text('Release From Stock');
1262 my $part_info = IC->get_basic_part_info('id' => $form->{parts_id});
1264 my $units = AM->retrieve_units(\%myconfig, $form);
1265 my $units_data = AM->unit_select_data($units, undef, undef, $part_info->{unit});
1267 my @contents = DO->get_item_availability('parts_id' => $form->{parts_id});
1269 my $stock_info = DO->unpack_stock_information('packed' => $form->{stock});
1271 if (!$form->{delivered}) {
1272 foreach my $row (@contents) {
1273 $row->{available_qty} = $form->format_amount_units('amount' => $row->{qty} * 1,
1274 'part_unit' => $part_info->{unit},
1275 'conv_units' => 'convertible_not_smaller',
1278 foreach my $sinfo (@{ $stock_info }) {
1279 next if (($row->{bin_id} != $sinfo->{bin_id}) ||
1280 ($row->{warehouse_id} != $sinfo->{warehouse_id}) ||
1281 ($row->{chargenumber} ne $sinfo->{chargenumber}) ||
1282 ($row->{bestbefore} ne $sinfo->{bestbefore}));
1284 map { $row->{"stock_$_"} = $sinfo->{$_} } qw(qty unit error delivery_order_items_stock_id);
1289 get_basic_bin_wh_info($stock_info);
1291 foreach my $sinfo (@{ $stock_info }) {
1292 map { $sinfo->{"stock_$_"} = $sinfo->{$_} } qw(qty unit);
1296 $form->header(no_layout => 1);
1297 print $form->parse_html_template('do/stock_out_form', { 'UNITS' => $units_data,
1298 'WHCONTENTS' => $form->{delivered} ? $stock_info : \@contents,
1299 'PART_INFO' => $part_info, });
1301 $main::lxdebug->leave_sub();
1305 $main::lxdebug->enter_sub();
1307 my $form = $main::form;
1308 my %myconfig = %main::myconfig;
1309 my $locale = $main::locale;
1311 my $stock_info = [];
1313 foreach my $i (1 .. $form->{rowcount}) {
1314 $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"});
1316 next if ($form->{"qty_$i"} <= 0);
1318 push @{ $stock_info }, {
1319 'warehouse_id' => $form->{"warehouse_id_$i"},
1320 'bin_id' => $form->{"bin_id_$i"},
1321 'chargenumber' => $form->{"chargenumber_$i"},
1322 'bestbefore' => $form->{"bestbefore_$i"},
1323 'qty' => $form->{"qty_$i"},
1324 'unit' => $form->{"unit_$i"},
1326 'delivery_order_items_stock_id' => $form->{"delivery_order_items_stock_id_$i"},
1330 my @errors = DO->check_stock_availability('requests' => $stock_info,
1331 'parts_id' => $form->{parts_id});
1333 $form->{stock} = YAML::Dump($stock_info);
1336 $form->{ERRORS} = [];
1337 map { push @{ $form->{ERRORS} }, $locale->text('Error in row #1: The quantity you entered is bigger than the stocked quantity.', $_->{row}); } @errors;
1338 stock_in_out_form();
1341 _stock_in_out_set_qty_display($stock_info);
1343 my $do_qty = AM->sum_with_unit($::form->parse_amount(\%::myconfig, $::form->{do_qty}), $::form->{do_unit});
1344 my $transfer_qty = AM->sum_with_unit(map { $_->{qty}, $_->{unit} } @{ $stock_info });
1347 print $form->parse_html_template('do/set_stock_in_out', {
1348 qty_matches => $do_qty == $transfer_qty,
1352 $main::lxdebug->leave_sub();
1356 $main::lxdebug->enter_sub();
1358 my $form = $main::form;
1359 my %myconfig = %main::myconfig;
1360 my $locale = $main::locale;
1362 if ($form->{id} && DO->is_marked_as_delivered(id => $form->{id})) {
1363 $form->show_generic_error($locale->text('The parts for this delivery order have already been transferred in.'));
1366 save(no_redirect => 1);
1368 my @part_ids = map { $form->{"id_${_}"} } grep { $form->{"id_${_}"} && $form->{"stock_in_${_}"} } (1 .. $form->{rowcount});
1372 my $units = AM->retrieve_units(\%myconfig, $form);
1373 my %part_info_map = IC->get_basic_part_info('id' => \@part_ids);
1376 $form->{ERRORS} = [];
1378 foreach my $i (1 .. $form->{rowcount}) {
1379 next unless ($form->{"id_$i"} && $form->{"stock_in_$i"});
1381 my $row_sum_base_qty = 0;
1382 my $base_unit_factor = $units->{ $part_info_map{$form->{"id_$i"}}->{unit} }->{factor} || 1;
1384 foreach my $request (@{ DO->unpack_stock_information('packed' => $form->{"stock_in_$i"}) }) {
1385 $request->{parts_id} = $form->{"id_$i"};
1386 $row_sum_base_qty += $request->{qty} * $units->{$request->{unit}}->{factor} / $base_unit_factor;
1388 $request->{project_id} = $form->{"project_id_$i"} || $form->{globalproject_id};
1390 push @all_requests, $request;
1393 next if (0 == $row_sum_base_qty);
1395 my $do_base_qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}) * $units->{$form->{"unit_$i"}}->{factor} / $base_unit_factor;
1397 # if ($do_base_qty != $row_sum_base_qty) {
1398 # push @{ $form->{ERRORS} }, $locale->text('Error in position #1: You must either assign no stock at all or the full quantity of #2 #3.',
1399 # $i, $form->{"qty_$i"}, $form->{"unit_$i"});
1403 if (@{ $form->{ERRORS} }) {
1404 push @{ $form->{ERRORS} }, $locale->text('The delivery order has not been marked as delivered. The warehouse contents have not changed.');
1406 set_headings('edit');
1408 $main::lxdebug->leave_sub();
1410 $::dispatcher->end_request;
1414 DO->transfer_in_out('direction' => 'in',
1415 'requests' => \@all_requests);
1417 SL::DB::DeliveryOrder->new(id => $form->{id})->load->update_attributes(delivered => 1);
1419 $form->{callback} = 'do.pl?action=edit&type=purchase_delivery_order&id=' . $form->escape($form->{id});
1422 $main::lxdebug->leave_sub();
1426 $main::lxdebug->enter_sub();
1428 my $form = $main::form;
1429 my %myconfig = %main::myconfig;
1430 my $locale = $main::locale;
1432 if ($form->{id} && DO->is_marked_as_delivered(id => $form->{id})) {
1433 $form->show_generic_error($locale->text('The parts for this delivery order have already been transferred out.'));
1436 save(no_redirect => 1);
1438 my @part_ids = map { $form->{"id_${_}"} } grep { $form->{"id_${_}"} && $form->{"stock_out_${_}"} } (1 .. $form->{rowcount});
1442 my $units = AM->retrieve_units(\%myconfig, $form);
1443 my %part_info_map = IC->get_basic_part_info('id' => \@part_ids);
1446 $form->{ERRORS} = [];
1448 foreach my $i (1 .. $form->{rowcount}) {
1449 next unless ($form->{"id_$i"} && $form->{"stock_out_$i"});
1451 my $row_sum_base_qty = 0;
1452 my $base_unit_factor = $units->{ $part_info_map{$form->{"id_$i"}}->{unit} }->{factor} || 1;
1454 foreach my $request (@{ DO->unpack_stock_information('packed' => $form->{"stock_out_$i"}) }) {
1455 $request->{parts_id} = $form->{"id_$i"};
1456 $request->{base_qty} = $request->{qty} * $units->{$request->{unit}}->{factor} / $base_unit_factor;
1457 $request->{project_id} = $form->{"project_id_$i"} ? $form->{"project_id_$i"} : $form->{globalproject_id};
1459 my $map_key = join '--', ($form->{"id_$i"}, @{$request}{qw(warehouse_id bin_id chargenumber bestbefore)});
1461 $request_map{$map_key} ||= $request;
1462 $request_map{$map_key}->{sum_base_qty} ||= 0;
1463 $request_map{$map_key}->{sum_base_qty} += $request->{base_qty};
1464 $row_sum_base_qty += $request->{base_qty};
1466 push @all_requests, $request;
1469 next if (0 == $row_sum_base_qty);
1471 my $do_base_qty = $form->{"qty_$i"} * $units->{$form->{"unit_$i"}}->{factor} / $base_unit_factor;
1473 # if ($do_base_qty != $row_sum_base_qty) {
1474 # push @{ $form->{ERRORS} }, $locale->text('Error in position #1: You must either assign no transfer at all or the full quantity of #2 #3.',
1475 # $i, $form->{"qty_$i"}, $form->{"unit_$i"});
1480 my @bin_ids = map { $_->{bin_id} } values %request_map;
1481 my %bin_info_map = WH->get_basic_bin_info('id' => \@bin_ids);
1482 my @contents = DO->get_item_availability('parts_id' => \@part_ids);
1484 foreach my $inv (@contents) {
1485 my $map_key = join '--', @{$inv}{qw(parts_id warehouse_id bin_id chargenumber bestbefore)};
1487 next unless ($request_map{$map_key});
1489 my $request = $request_map{$map_key};
1490 $request->{ok} = $request->{sum_base_qty} <= $inv->{qty};
1493 foreach my $request (values %request_map) {
1494 next if ($request->{ok});
1496 my $pinfo = $part_info_map{$request->{parts_id}};
1497 my $binfo = $bin_info_map{$request->{bin_id}};
1499 if ($::instance_conf->get_show_bestbefore) {
1500 push @{ $form->{ERRORS} }, $locale->text("There is not enough available of '#1' at warehouse '#2', bin '#3', #4, #5, for the transfer of #6.",
1501 $pinfo->{description},
1502 $binfo->{warehouse_description},
1503 $binfo->{bin_description},
1504 $request->{chargenumber} ? $locale->text('chargenumber #1', $request->{chargenumber}) : $locale->text('no chargenumber'),
1505 $request->{bestbefore} ? $locale->text('bestbefore #1', $request->{bestbefore}) : $locale->text('no bestbefore'),
1506 $form->format_amount_units('amount' => $request->{sum_base_qty},
1507 'part_unit' => $pinfo->{unit},
1508 'conv_units' => 'convertible_not_smaller'));
1510 push @{ $form->{ERRORS} }, $locale->text("There is not enough available of '#1' at warehouse '#2', bin '#3', #4, for the transfer of #5.",
1511 $pinfo->{description},
1512 $binfo->{warehouse_description},
1513 $binfo->{bin_description},
1514 $request->{chargenumber} ? $locale->text('chargenumber #1', $request->{chargenumber}) : $locale->text('no chargenumber'),
1515 $form->format_amount_units('amount' => $request->{sum_base_qty},
1516 'part_unit' => $pinfo->{unit},
1517 'conv_units' => 'convertible_not_smaller'));
1522 if (@{ $form->{ERRORS} }) {
1523 push @{ $form->{ERRORS} }, $locale->text('The delivery order has not been marked as delivered. The warehouse contents have not changed.');
1525 set_headings('edit');
1527 $main::lxdebug->leave_sub();
1529 $::dispatcher->end_request;
1532 DO->transfer_in_out('direction' => 'out',
1533 'requests' => \@all_requests);
1535 SL::DB::DeliveryOrder->new(id => $form->{id})->load->update_attributes(delivered => 1);
1537 $form->{callback} = 'do.pl?action=edit&type=sales_delivery_order&id=' . $form->escape($form->{id});
1540 $main::lxdebug->leave_sub();
1544 $main::lxdebug->enter_sub();
1546 my $form = $main::form;
1548 DO->close_orders('ids' => [ $form->{id} ]);
1550 $form->{closed} = 1;
1554 $main::lxdebug->leave_sub();
1558 $::lxdebug->enter_sub;
1560 $::auth->assert('purchase_delivery_order_edit | sales_delivery_order_edit');
1563 retrieve_partunits();
1565 my $new_rowcount = $::form->{"rowcount"} * 1 + 1;
1566 $::form->{"project_id_${new_rowcount}"} = $::form->{"globalproject_id"};
1568 $::form->language_payment(\%::myconfig);
1570 Common::webdav_folder($::form);
1573 display_row(++$::form->{rowcount});
1576 $::lxdebug->leave_sub;
1580 call_sub($main::form->{yes_nextsub});
1584 call_sub($main::form->{no_nextsub});
1588 call_sub($main::form->{update_nextsub} || $main::form->{nextsub} || 'update_delivery_order');
1592 my $form = $main::form;
1593 my $locale = $main::locale;
1595 foreach my $action (qw(update ship_to print e_mail save transfer_out transfer_out_default sort
1596 transfer_in transfer_in_default mark_closed save_as_new invoice delete)) {
1597 if ($form->{"action_${action}"}) {
1603 $form->error($locale->text('No action defined.'));
1606 sub transfer_out_default {
1607 $main::lxdebug->enter_sub();
1609 my $form = $main::form;
1611 transfer_in_out_default('direction' => 'out');
1613 $main::lxdebug->leave_sub();
1616 sub transfer_in_default {
1617 $main::lxdebug->enter_sub();
1619 my $form = $main::form;
1621 transfer_in_out_default('direction' => 'in');
1623 $main::lxdebug->leave_sub();
1626 # Falls das Standardlagerverfahren aktiv ist, wird
1627 # geprüft, ob alle Standardlagerplätze für die Auslager-
1628 # artikel vorhanden sind UND ob die Warenmenge ausreicht zum
1629 # Auslagern. Falls nicht wird entsprechend eine Fehlermeldung
1630 # generiert. Offen Chargennummer / bestbefore wird nicht berücksichtigt
1631 sub transfer_in_out_default {
1632 $main::lxdebug->enter_sub();
1634 my $form = $main::form;
1635 my %myconfig = %main::myconfig;
1636 my $locale = $main::locale;
1639 my (%missing_default_bins, %qty_parts, @all_requests, %part_info_map, $default_warehouse_id, $default_bin_id);
1641 Common::check_params(\%params, qw(direction));
1643 # entsprechende defaults holen, falls standardlagerplatz verwendet werden soll
1644 if ($::instance_conf->get_transfer_default_use_master_default_bin) {
1645 $default_warehouse_id = $::instance_conf->get_warehouse_id;
1646 $default_bin_id = $::instance_conf->get_bin_id;
1650 my @part_ids = map { $form->{"id_${_}"} } (1 .. $form->{rowcount});
1652 my $units = AM->retrieve_units(\%myconfig, $form);
1653 %part_info_map = IC->get_basic_part_info('id' => \@part_ids);
1654 foreach my $i (1 .. $form->{rowcount}) {
1655 next unless ($form->{"id_$i"});
1656 my $base_unit_factor = $units->{ $part_info_map{$form->{"id_$i"}}->{unit} }->{factor} || 1;
1657 my $qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}) * $units->{$form->{"unit_$i"}}->{factor} / $base_unit_factor;
1659 $form->show_generic_error($locale->text("Cannot transfer negative entries." )) if ($qty < 0);
1660 # if we do not want to transfer services and this part is a service, set qty to zero
1661 # ... and do not create a hash entry in %qty_parts below (will skip check for bins for the transfer == out case)
1662 # ... and push only a empty (undef) element to @all_requests (will skip check for bin_id and warehouse_id and will not alter the row)
1664 $qty = 0 if (!$::instance_conf->get_transfer_default_services && !defined($part_info_map{$form->{"id_$i"}}->{inventory_accno_id}) && !$part_info_map{$form->{"id_$i"}}->{assembly});
1665 $qty_parts{$form->{"id_$i"}} += $qty;
1667 delete $qty_parts{$form->{"id_$i"}} unless $qty_parts{$form->{"id_$i"}};
1668 undef $form->{"stock_in_$i"};
1671 $part_info_map{$form->{"id_$i"}}{bin_id} ||= $default_bin_id;
1672 $part_info_map{$form->{"id_$i"}}{warehouse_id} ||= $default_warehouse_id;
1674 push @all_requests, ($qty == 0) ? { } : {
1675 'chargenumber' => '', #?? die müsste entsprechend geholt werden
1676 #'bestbefore' => undef, # TODO wird nicht berücksichtigt
1677 'bin_id' => $part_info_map{$form->{"id_$i"}}{bin_id},
1679 'parts_id' => $form->{"id_$i"},
1680 'comment' => $locale->text("Default transfer delivery order"),
1681 'unit' => $part_info_map{$form->{"id_$i"}}{unit},
1682 'warehouse_id' => $part_info_map{$form->{"id_$i"}}{warehouse_id},
1683 'oe_id' => $form->{id},
1684 'project_id' => $form->{"project_id_$i"} ? $form->{"project_id_$i"} : $form->{globalproject_id}
1688 # jetzt wird erst überprüft, ob die Stückzahl entsprechend stimmt.
1689 # check if bin (transfer in and transfer out and qty (transfer out) is correct
1690 foreach my $key (keys %qty_parts) {
1692 $missing_default_bins{$key}{missing_bin} = 1 unless ($part_info_map{$key}{bin_id});
1693 next unless ($part_info_map{$key}{bin_id}); # abbruch
1695 if ($params{direction} eq 'out') { # wird nur für ausgehende Mengen benötigt
1696 my ($max_qty, $error) = WH->get_max_qty_parts_bin(parts_id => $key, bin_id => $part_info_map{$key}{bin_id});
1698 # wir können nicht entscheiden, welche charge oder mhd (bestbefore) ausgewählt sein soll
1699 # deshalb rückmeldung nach oben geben, manuell auszulagern
1700 # TODO Bei nur einem Treffer mit Charge oder bestbefore wäre das noch möglich
1701 $missing_default_bins{$key}{chargenumber} = 1;
1703 if ($max_qty < $qty_parts{$key}){
1704 $missing_default_bins{$key}{missing_qty} = $max_qty - $qty_parts{$key};
1710 # Abfrage für Fehlerbehandlung (nur bei direction == out)
1711 if (scalar (keys %missing_default_bins)) {
1713 foreach my $fehler (keys %missing_default_bins) {
1715 my $ware = WH->get_part_description(parts_id => $fehler);
1716 if ($missing_default_bins{$fehler}{missing_bin}){
1717 $fehlertext .= "Kein Standardlagerplatz definiert bei $ware <br>";
1719 if ($missing_default_bins{$fehler}{missing_qty}) { # missing_qty
1720 $fehlertext .= "Es fehlen " . $missing_default_bins{$fehler}{missing_qty}*-1 .
1721 " von $ware auf dem Standard-Lagerplatz " . $part_info_map{$fehler}{bin} . " zum Auslagern<br>";
1723 if ($missing_default_bins{$fehler}{chargenumber}){
1724 $fehlertext .= "Die Ware hat eine Chargennummer oder eine Mindesthaltbarkeit definiert.
1725 Hier kann man nicht automatisch entscheiden.
1726 Bitte diesen Lieferschein manuell auslagern.
1729 # auslagern soll immer gehen, auch wenn nicht genügend auf lager ist.
1730 # der lagerplatz ist hier extra konfigurierbar, bspw. Lager-Korrektur mit
1731 # Lagerplatz Lagerplatz-Korrektur
1732 my $default_warehouse_id_ignore_onhand = $::instance_conf->get_warehouse_id_ignore_onhand;
1733 my $default_bin_id_ignore_onhand = $::instance_conf->get_bin_id_ignore_onhand;
1734 if ($::instance_conf->get_transfer_default_ignore_onhand && $default_bin_id_ignore_onhand) {
1735 # entsprechende defaults holen
1736 # falls chargenumber, bestbefore oder anzahl nicht stimmt, auf automatischen
1737 # lagerplatz wegbuchen!
1738 foreach (@all_requests) {
1739 if ($_->{parts_id} eq $fehler){
1740 $_->{bin_id} = $default_bin_id_ignore_onhand;
1741 $_->{warehouse_id} = $default_warehouse_id_ignore_onhand;
1745 #$main::lxdebug->message(0, 'Fehlertext: ' . $fehlertext);
1746 $form->show_generic_error($locale->text("Cannot transfer. <br> Reason:<br>#1", $fehlertext ));
1752 # hier der eigentliche fallunterschied für in oder out
1753 my $prefix = $params{direction} eq 'in' ? 'in' : 'out';
1755 # dieser array_ref ist für DO->save da:
1756 # einmal die all_requests in YAML verwandeln, damit delivery_order_items_stock
1757 # gefüllt werden kann.
1758 # could be dumped to the form in the first loop,
1759 # but maybe bin_id and warehouse_id has changed to the "korrekturlager" with
1760 # allowed negative qty ($::instance_conf->get_warehouse_id_ignore_onhand) ...
1762 foreach (@all_requests){
1764 next unless scalar(%{ $_ });
1765 $form->{"stock_${prefix}_$i"} = YAML::Dump([$_]);
1768 save(no_redirect => 1); # Wir können auslagern, deshalb beleg speichern
1769 # und in delivery_order_items_stock speichern
1771 # ... and fill back the persistent dois_id for inventory fk
1772 undef (@all_requests);
1773 foreach my $i (1 .. $form->{rowcount}) {
1774 next unless ($form->{"id_$i"} && $form->{"stock_${prefix}_$i"});
1775 push @all_requests, @{ DO->unpack_stock_information('packed' => $form->{"stock_${prefix}_$i"}) };
1777 DO->transfer_in_out('direction' => $prefix,
1778 'requests' => \@all_requests);
1780 SL::DB::DeliveryOrder->new(id => $form->{id})->load->update_attributes(delivered => 1);
1782 $form->{callback} = 'do.pl?action=edit&type=sales_delivery_order&id=' . $form->escape($form->{id}) if $params{direction} eq 'out';
1783 $form->{callback} = 'do.pl?action=edit&type=purchase_delivery_order&id=' . $form->escape($form->{id}) if $params{direction} eq 'in';
1789 $main::lxdebug->enter_sub();
1793 my $form = $main::form;
1796 save(no_redirect => 1); # has to be done, at least for newly added positions
1798 # hashify partnumbers, positions. key is delivery_order_items_id
1799 for my $i (1 .. ($form->{rowcount}) ) {
1800 $temp_hash{$form->{"delivery_order_items_id_$i"}} = { runningnumber => $form->{"runningnumber_$i"}, partnumber => $form->{"partnumber_$i"} };
1801 if ($form->{id} && $form->{"discount_$i"}) {
1802 # prepare_order assumes a db value if there is a form->id and multiplies *100
1803 # We hope for new controller code (no more format_amount/parse_amount distinction)
1804 $form->{"discount_$i"} /=100;
1807 # naturally sort partnumbers and get a sorted array of doi_ids
1808 my @sorted_doi_ids = sort { Sort::Naturally::ncmp($temp_hash{$a}->{"partnumber"}, $temp_hash{$b}->{"partnumber"}) } keys %temp_hash;
1813 for (@sorted_doi_ids) {
1814 $form->{"runningnumber_$temp_hash{$_}->{runningnumber}"} = $new_number;
1817 # all parse_amounts changes are in form (i.e. , to .) therefore we need
1818 # another format_amount to change it back, for the next save ;-(
1819 # works great except for row discounts (see above comment)
1823 $main::lxdebug->leave_sub();
1835 do.pl - Script for all calls to delivery order
1843 Sorts all position with Natural Sort. Can be activated in form_footer.html like this
1844 C<E<lt>input class="submit" type="submit" name="action_sort" id="sort_button" value="[% 'Sort and Save' | $T8 %]"E<gt>>
1850 Sort and Save can be implemented as an optional button if configuration ca be set by client config.
1851 Example coding for database scripts and templates in (git show af2f24b8), check also
1852 autogeneration for rose (scripts/rose_auto_create_model.pl --h)