Projekt

Allgemein

Profil

Herunterladen (79,7 KB) Statistiken
| Zweig: | Markierung: | Revision:
#=====================================================================
# LX-Office ERP
# Copyright (C) 2004
# Based on SQL-Ledger Version 2.1.9
# Web http://www.lx-office.org
#
#=====================================================================
# SQL-Ledger, Accounting
# Copyright (c) 1998-2003
#
# Author: Dieter Simader
# Email: dsimader@sql-ledger.org
# Web: http://www.sql-ledger.org
#
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
# MA 02110-1335, USA.
#======================================================================
#
# Delivery orders
#======================================================================

use Carp;
use List::MoreUtils qw(uniq);
use List::Util qw(max sum);
use POSIX qw(strftime);

use SL::Controller::DeliveryOrder;
use SL::DB::DeliveryOrder;
use SL::DB::DeliveryOrderItem;
use SL::DB::DeliveryOrder::TypeData qw(:types validate_type);
use SL::DB::ValidityToken;
use SL::Helper::UserPreferences::DisplayPreferences;
use SL::DO;
use SL::IR;
use SL::IS;
use SL::MoreCommon qw(ary_diff restore_form save_form);
use SL::Presenter::ItemsList;
use SL::ReportGenerator;
use SL::WH;
use SL::YAML;
use Sort::Naturally ();
require "bin/mozilla/common.pl";
require "bin/mozilla/io.pl";
require "bin/mozilla/reportgenerator.pl";

use strict;

1;

# end of main

sub check_do_access_for_edit {
validate_type($::form->{type});

my $right = SL::DB::DeliveryOrder::TypeData::get3($::form->{type}, "rights", "edit");
$main::auth->assert($right);
}

sub check_do_access {
validate_type($::form->{type});

my $right = SL::DB::DeliveryOrder::TypeData::get3($::form->{type}, "rights", "view");
$main::auth->assert($right);
}

sub set_headings {
$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');
} else {
$form->{vc} = 'customer';
$form->{title} = $action eq "edit" ? $locale->text('Edit Sales Delivery Order') : $locale->text('Add Sales Delivery Order');
}

$form->{heading} = $locale->text('Delivery Order');

$main::lxdebug->leave_sub();
}

sub add {
$main::lxdebug->enter_sub();

check_do_access_for_edit();

if (($::form->{type} =~ /purchase/) && !$::instance_conf->get_allow_new_purchase_invoice) {
$::form->show_generic_error($::locale->text("You do not have the permissions to access this function."));
}

my $form = $main::form;

set_headings("add");

$form->{show_details} = $::myconfig{show_form_details};
$form->{callback} = build_std_url('action=add', 'type', 'vc') unless ($form->{callback});

if (!$form->{form_validity_token}) {
$form->{form_validity_token} = SL::DB::ValidityToken->create(scope => SL::DB::ValidityToken::SCOPE_DELIVERY_ORDER_SAVE())->token;
}

order_links(is_new => 1);
prepare_order();
display_form();

$main::lxdebug->leave_sub();
}

sub add_from_reclamation {

require SL::DB::Reclamation;
my $reclamation = SL::DB::Reclamation->new(id => $::form->{from_id})->load;
my ($delivery_order, $error) = $reclamation->convert_to_delivery_order();
if($error) {
croak("Error while converting: " . $error);
}

# edit new saved delivery order
$::form->{id} = $delivery_order->id;
edit();
}

sub edit {
$main::lxdebug->enter_sub();

check_do_access();

my $form = $main::form;

$form->{show_details} = $::myconfig{show_form_details};

# show history button
$form->{javascript} = qq|<script type="text/javascript" src="js/show_history.js"></script>|;
#/show hhistory button

$form->{simple_save} = 0;

set_headings("edit");

# editing without stuff to edit? try adding it first
if ($form->{rowcount} && !$form->{print_and_save}) {
# map { $id++ if $form->{"multi_id_$_"} } (1 .. $form->{rowcount});
# if (!$id) {

# reset rowcount
undef $form->{rowcount};
add();
$main::lxdebug->leave_sub();
return;
# }
} elsif (!$form->{id}) {
add();
$main::lxdebug->leave_sub();
return;
}

my ($language_id, $printer_id);
if ($form->{print_and_save}) {
$form->{action} = "dispatcher";
$form->{action_print} = "1";
$form->{resubmit} = 1;
$language_id = $form->{language_id};
$printer_id = $form->{printer_id};
}

set_headings("edit");

order_links();
prepare_order();

if ($form->{print_and_save}) {
$form->{language_id} = $language_id;
$form->{printer_id} = $printer_id;
}

display_form();

$main::lxdebug->leave_sub();
}

sub order_links {
$main::lxdebug->enter_sub();

check_do_access();

my %params = @_;
my $form = $main::form;
my %myconfig = %main::myconfig;

# retrieve order/quotation
my $editing = $form->{id};

DO->retrieve('vc' => $form->{vc},
'ids' => $form->{id});

$form->backup_vars(qw(payment_id language_id taxzone_id salesman_id taxincluded cp_id intnotes delivery_term_id currency));

# 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->{billing_address_id} = $form->{default_billing_address_id} if $params{is_new};
}

$form->restore_vars(qw(payment_id language_id taxzone_id intnotes cp_id delivery_term_id));
$form->restore_vars(qw(currency)) if ($form->{id} || $form->{convert_from_oe_ids});
$form->restore_vars(qw(taxincluded)) if $form->{id};
$form->restore_vars(qw(salesman_id)) if $editing;

$main::lxdebug->leave_sub();
}

sub prepare_order {
$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 my $ref (@{ $form->{form_details} }) {
$form->{rowcount} = ++$i;

map { $form->{"${_}_$i"} = $ref->{$_} } keys %{$ref};
}
for my $i (1 .. $form->{rowcount}) {
if ($form->{id}) {
$form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100);
} else {
$form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"});
}
my ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/);
$dec = length $dec;
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);
}

$main::lxdebug->leave_sub();
}

sub setup_do_action_bar {
my @transfer_qty = qw(kivi.SalesPurchase.delivery_order_check_transfer_qty);
my @req_trans_desc = qw(kivi.SalesPurchase.check_transaction_description) x!!$::instance_conf->get_require_transaction_description_ps;
my $is_customer = $::form->{vc} eq 'customer';

my $undo_date = DateTime->today->subtract(days => $::instance_conf->get_undo_transfer_interval);
my $insertdate = DateTime->from_kivitendo($::form->{insertdate});
my $undo_transfer = 0;
if (ref $undo_date eq 'DateTime' && ref $insertdate eq 'DateTime') {
$undo_transfer = $insertdate > $undo_date;
}

my $may_edit_create = $::auth->assert(SL::DB::DeliveryOrder::TypeData::get3($::form->{type}, "rights", "edit"), 1);

for my $bar ($::request->layout->get('actionbar')) {
$bar->add(
action =>
[ t8('Update'),
submit => [ '#form', { action => "update" } ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.') : undef,
id => 'update_button',
accesskey => 'enter',
],

combobox => [
action => [
t8('Save'),
submit => [ '#form', { action => "save" } ],
checks => [ 'kivi.validate_form' ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: $::form->{delivered} ? t8('This record has already been delivered.')
: undef,
],
action => [
t8('Save as new'),
submit => [ '#form', { action => "save_as_new" } ],
checks => [ 'kivi.validate_form' ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: !$::form->{id},
],
action => [
t8('Mark as closed'),
submit => [ '#form', { action => "mark_closed" } ],
checks => [ 'kivi.validate_form' ],
confirm => t8('This will remove the delivery order from showing as open even if contents are not delivered. Proceed?'),
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: !$::form->{id} ? t8('This record has not been saved yet.')
: $::form->{closed} ? t8('This record has already been closed.')
: undef,
],
], # end of combobox "Save"

action => [
t8('Delete'),
submit => [ '#form', { action => "delete" } ],
confirm => t8('Do you really want to delete this object?'),
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: !$::form->{id} ? t8('This record has not been saved yet.')
: $::form->{delivered} ? t8('This record has already been delivered.')
: ($::form->{vc} eq 'customer' && !$::instance_conf->get_sales_delivery_order_show_delete) ? t8('Deleting this type of record has been disabled in the configuration.')
: ($::form->{vc} eq 'vendor' && !$::instance_conf->get_purchase_delivery_order_show_delete) ? t8('Deleting this type of record has been disabled in the configuration.')
: undef,
],

combobox => [
action => [
t8('Transfer out'),
submit => [ '#form', { action => "transfer_out" } ],
checks => [ 'kivi.validate_form', @transfer_qty ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: $::form->{delivered} ? t8('This record has already been delivered.')
: undef,
only_if => $is_customer,
],
action => [
t8('Transfer out via default'),
submit => [ '#form', { action => "transfer_out_default" } ],
checks => [ 'kivi.validate_form' ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: $::form->{delivered} ? t8('This record has already been delivered.')
: undef,
only_if => $is_customer && $::instance_conf->get_transfer_default,
],
action => [
t8('Transfer in'),
submit => [ '#form', { action => "transfer_in" } ],
checks => [ 'kivi.validate_form', @transfer_qty ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: $::form->{delivered} ? t8('This record has already been delivered.')
: undef,
only_if => !$is_customer,
],
action => [
t8('Transfer in via default'),
submit => [ '#form', { action => "transfer_in_default" } ],
checks => [ 'kivi.validate_form' ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: $::form->{delivered} ? t8('This record has already been delivered.')
: undef,
only_if => !$is_customer && $::instance_conf->get_transfer_default,
],
action => [
t8('Undo Transfer'),
submit => [ '#form', { action => "delete_transfers" } ],
checks => [ 'kivi.validate_form' ],
only_if => $::form->{delivered},
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: !$undo_transfer ? t8('Transfer date exceeds the maximum allowed interval.')
: undef,
],
], # end of combobox "Transfer out"


'separator',

combobox => [
action => [ t8('Workflow') ],
action => [
t8('Invoice'),
submit => [ '#form', { action => "invoice" } ],
disabled => !$::form->{id} ? t8('This record has not been saved yet.') : undef,
confirm => $::form->{delivered} ? undef
: ($::form->{vc} eq 'customer' && $::instance_conf->get_sales_delivery_order_check_stocked) ? t8('This record has not been stocked out. Proceed?')
: ($::form->{vc} eq 'vendor' && $::instance_conf->get_purchase_delivery_order_check_stocked) ? t8('This record has not been stocked in. Proceed?')
: undef,
],
action => [
t8('Save and Reclamation'),
submit => [ '#form', { action => "save_and_reclamation" } ],
],
],

combobox => [
action => [ t8('Export') ],
action => [
t8('Print'),
call => [ 'kivi.SalesPurchase.show_print_dialog' ],
checks => [ 'kivi.validate_form' ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.') : undef,
],
action => [
t8('E Mail'),
call => [ 'kivi.SalesPurchase.show_email_dialog' ],
checks => [ 'kivi.validate_form' ],
disabled => !$may_edit_create ? t8('You do not have the permissions to access this function.')
: !$::form->{id} ? t8('This record has not been saved yet.')
: undef,
],
], # end of combobox "Export"

combobox => [
action => [ t8('more') ],
action => [
t8('History'),
call => [ 'set_history_window', $::form->{id} * 1, 'id' ],
disabled => !$::form->{id} ? t8('This record has not been saved yet.') : undef,
],
action => [
t8('Follow-Up'),
call => [ 'follow_up_window' ],
disabled => !$::form->{id} ? t8('This record has not been saved yet.') : undef,
],
], # end if combobox "more"
);
}
$::request->layout->add_javascripts('kivi.Validator.js');
}

sub setup_do_search_action_bar {
my %params = @_;

for my $bar ($::request->layout->get('actionbar')) {
$bar->add(
action => [
t8('Search'),
submit => [ '#form' ],
accesskey => 'enter',
checks => [ 'kivi.validate_form' ],
],
);
}
$::request->layout->add_javascripts('kivi.Validator.js');
}

sub setup_do_orders_action_bar {
my %params = @_;

for my $bar ($::request->layout->get('actionbar')) {
$bar->add(
action => [
t8('New invoice'),
submit => [ '#form', { action => 'invoice_multi' } ],
checks => [ [ 'kivi.check_if_entries_selected', '#form tbody input[type=checkbox]' ] ],
accesskey => 'enter',
],
action => [
t8('Print'),
call => [ 'kivi.SalesPurchase.show_print_dialog', 'js:kivi.MassDeliveryOrderPrint.submitMultiOrders' ],
checks => [ [ 'kivi.check_if_entries_selected', '#form tbody input[type=checkbox]' ] ],
],
);
}
}

sub form_header {
$main::lxdebug->enter_sub();

check_do_access();

my $form = $main::form;
my %myconfig = %main::myconfig;

my $class = "SL::DB::" . ($form->{vc} eq 'customer' ? 'Customer' : 'Vendor');
$form->{VC_OBJ} = $class->load_cached($form->{ $form->{vc} . '_id' });

$form->{CONTACT_OBJ} = $form->{cp_id} ? SL::DB::Contact->load_cached($form->{cp_id}) : undef;
my $current_employee = SL::DB::Manager::Employee->current;
$form->{employee_id} = $form->{old_employee_id} if $form->{old_employee_id};
$form->{salesman_id} = $form->{old_salesman_id} if $form->{old_salesman_id};
$form->{employee_id} ||= $current_employee->id;
$form->{salesman_id} ||= $current_employee->id;

my $vc = $form->{vc} eq "customer" ? "customers" : "vendors";
$form->get_lists("price_factors" => "ALL_PRICE_FACTORS",
"business_types" => "ALL_BUSINESS_TYPES",
);
$form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all_sorted;
$form->{ALL_LANGUAGES} = SL::DB::Manager::Language->get_all_sorted;

# Projects
my @old_project_ids = uniq grep { $_ } map { $_ * 1 } ($form->{"globalproject_id"}, map { $form->{"project_id_$_"} } 1..$form->{"rowcount"});
my @old_ids_cond = @old_project_ids ? (id => \@old_project_ids) : ();
my @customer_cond;
if (($vc eq 'customers') && $::instance_conf->get_customer_projects_only_in_sales) {
@customer_cond = (
or => [
customer_id => $::form->{customer_id},
billable_customer_id => $::form->{customer_id},
]);
}
my @conditions = (
or => [
and => [ active => 1, @customer_cond ],
@old_ids_cond,
]);

$::form->{ALL_PROJECTS} = SL::DB::Manager::Project->get_all_sorted(query => \@conditions);
$::form->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
$::form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{employee_id}, deleted => 0 ] ]);
$::form->{ALL_SALESMEN} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{salesman_id}, deleted => 0 ] ]);
$::form->{ALL_SHIPTO} = SL::DB::Manager::Shipto->get_all_sorted(query => [
or => [ and => [ trans_id => $::form->{"$::form->{vc}_id"} * 1, module => 'CT' ], and => [ shipto_id => $::form->{shipto_id} * 1, trans_id => undef ] ]
]);
$::form->{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
or => [
cp_cv_id => $::form->{"$::form->{vc}_id"} * 1,
and => [
cp_cv_id => undef,
cp_id => $::form->{cp_id} * 1
]
]
]);

my $dispatch_to_popup = '';
if ($form->{resubmit} && ($form->{format} eq "html")) {
$dispatch_to_popup = "window.open('about:blank','Beleg'); document.do.target = 'Beleg';";
$dispatch_to_popup .= "document.do.submit();";
} elsif ($form->{resubmit} && $form->{action_print}) {
# emulate click for resubmitting actions
$dispatch_to_popup = "kivi.SalesPurchase.show_print_dialog(); kivi.SalesPurchase.print_record();";
}
$::request->{layout}->add_javascripts_inline("\$(function(){$dispatch_to_popup});");


$form->{follow_up_trans_info} = $form->{donumber} .'('. $form->{VC_OBJ}->name .')' if $form->{VC_OBJ};
$form->{longdescription_dialog_size_percentage} = SL::Helper::UserPreferences::DisplayPreferences->new()->get_longdescription_dialog_size_percentage();

$::request->{layout}->use_javascript(map { "${_}.js" } qw(kivi.File kivi.MassDeliveryOrderPrint kivi.SalesPurchase kivi.Part kivi.CustomerVendor kivi.Validator ckeditor/ckeditor ckeditor/adapters/jquery kivi.io));

setup_do_action_bar();

$form->header();
# Fix für Bug 1082 Erwartet wird: 'abteilungsNAME--abteilungsID'
# und Erweiterung für Bug 1760:
# Das war leider nur ein Teil-Fix, da das Verhalten den 'Erneuern'-Knopf
# nicht überlebt. Konsequent jetzt auf L umgestellt
# $ perldoc SL::Template::Plugin::L
# Daher entsprechend nur die Anpassung in form_header
# und in DO.pm gemacht. 4 Testfälle:
# department_id speichern | i.O.
# department_id lesen | i.O.
# department leer überlebt erneuern | i.O.
# department nicht leer überlebt erneuern | i.O.
# $main::lxdebug->message(0, 'ABTEILUNGS ID in form?' . $form->{department_id});
print $form->parse_html_template('do/form_header');

$main::lxdebug->leave_sub();
}

sub form_footer {
$main::lxdebug->enter_sub();

check_do_access();

my $form = $main::form;

$form->{PRINT_OPTIONS} = setup_sales_purchase_print_options();

my $shipto_cvars = SL::DB::Shipto->new->cvars_by_config;
foreach my $var (@{ $shipto_cvars }) {
my $name = "shiptocvar_" . $var->config->name;
$var->value($form->{$name}) if exists $form->{$name};
}

print $form->parse_html_template('do/form_footer',
{transfer_default => ($::instance_conf->get_transfer_default),
shipto_cvars => $shipto_cvars});

$main::lxdebug->leave_sub();
}

sub update_delivery_order {
$main::lxdebug->enter_sub();

check_do_access();

my $form = $main::form;
my %myconfig = %main::myconfig;

set_headings($form->{"id"} ? "edit" : "add");

$form->{insertdate} = SL::DB::DeliveryOrder->new(id => $form->{id})->load->itime_as_date if $form->{id};

$form->{update} = 1;

my $payment_id;
$payment_id = $form->{payment_id} if $form->{payment_id};

my $vc = $form->{vc};
if (($form->{"previous_${vc}_id"} || $form->{"${vc}_id"}) != $form->{"${vc}_id"}) {
$::form->{salesman_id} = SL::DB::Manager::Employee->current->id if exists $::form->{salesman_id};

if ($vc eq 'customer') {
IS->get_customer(\%myconfig, $form);
$::form->{billing_address_id} = $::form->{default_billing_address_id};
} else {
IR->get_vendor(\%myconfig, $form);
}
}

$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 "";

my $i = $form->{rowcount};

if ( ($form->{"partnumber_$i"} eq "")
&& ($form->{"description_$i"} eq "")
&& ($form->{"partsgroup_$i"} eq "")) {

check_form();

} else {

my $mode;
if ($form->{type} eq 'purchase_delivery_order') {
IR->retrieve_item(\%myconfig, $form);
$mode = 'IR';
} else {
IS->retrieve_item(\%myconfig, $form);
$mode = 'IS';
}

my $rows = scalar @{ $form->{item_list} };

if ($rows) {
$form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"});
if( !$form->{"qty_$i"} ) {
$form->{"qty_$i"} = 1;
}

if ($rows > 1) {

select_item(mode => $mode, pre_entered_qty => $form->{"qty_$i"});
$::dispatcher->end_request;

} else {

my $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"});

map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] };

$form->{"marge_price_factor_$i"} = $form->{item_list}->[0]->{price_factor};

if ($sellprice) {
$form->{"sellprice_$i"} = $sellprice;
} else {
my $record = _make_record();
my $price_source = SL::PriceSource->new(record_item => $record->items->[$i-1], record => $record);
my $best_price = $price_source->best_price;
my $best_discount = $price_source->best_discount;

if ($best_price) {
$::form->{"sellprice_$i"} = $best_price->price;
$::form->{"active_price_source_$i"} = $best_price->source;
}
if ($best_discount) {
$::form->{"discount_$i"} = $best_discount->discount;
$::form->{"active_discount_source_$i"} = $best_discount->source;
}
}

$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"});
$form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100.0);
}

display_form();

} else {

# ok, so this is a new part
# ask if it is a part or service item

if ( $form->{"partsgroup_$i"}
&& ($form->{"partsnumber_$i"} eq "")
&& ($form->{"description_$i"} eq "")) {
$form->{rowcount}--;
$form->{"discount_$i"} = "";
$form->{"not_discountable_$i"} = "";
display_form();

} else {
$form->{"id_$i"} = 0;
new_item();
}
}
}

$main::lxdebug->leave_sub();
}

sub search {
$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",
"all" => 1 },
"business_types" => "ALL_BUSINESS_TYPES");
$form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ deleted => 0 ]);
$form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all_sorted;
$form->{title} = $locale->text('Delivery Orders');

setup_do_search_action_bar();

$form->header();

print $form->parse_html_template('do/search');

$main::lxdebug->leave_sub();
}

sub orders {
$main::lxdebug->enter_sub();

check_do_access();

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
my $cgi = $::request->{cgi};

$::request->{layout}->use_javascript(map { "${_}.js" } qw(kivi.MassDeliveryOrderPrint kivi.SalesPurchase));
($form->{ $form->{vc} }, $form->{"$form->{vc}_id"}) = split(/--/, $form->{ $form->{vc} });

report_generator_set_default_sort('transdate', 1);

DO->transactions();

$form->{rowcount} = scalar @{ $form->{DO} };

my @columns = qw(
ids transdate reqdate
id donumber
ordnumber customernumber cusordnumber
name employee salesman
shipvia globalprojectnumber
transaction_description department
open delivered
insertdate items
);

$form->{l_open} = $form->{l_closed} = "Y" if ($form->{open} && $form->{closed});
$form->{l_delivered} = "Y" if ($form->{delivered} && $form->{notdelivered});

$form->{title} = $locale->text('Delivery Orders');

my $attachment_basename = $form->{vc} eq 'vendor' ? $locale->text('purchase_delivery_order_list') : $locale->text('sales_delivery_order_list');

my $report = SL::ReportGenerator->new(\%myconfig, $form);

my @hidden_variables = map { "l_${_}" } @columns;
push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber serialnumber cusordnumber
transaction_description transdatefrom transdateto reqdatefrom reqdateto
type vc employee_id salesman_id project_id parts_partnumber parts_description
insertdatefrom insertdateto business_id all department_id chargenumber);

my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables);

my %column_defs = (
'ids' => { raw_header_data => SL::Presenter::Tag::checkbox_tag("", id => "multi_all", checkall => "[data-checkall=1]"), align => 'center' },
'transdate' => { 'text' => $locale->text('Delivery Order Date'), },
'reqdate' => { 'text' => $locale->text('Reqdate'), },
'id' => { 'text' => $locale->text('ID'), },
'donumber' => { 'text' => $locale->text('Delivery Order'), },
'ordnumber' => { 'text' => $locale->text('Order'), },
'customernumber' => { 'text' => $locale->text('Customer Number'), },
'cusordnumber' => { 'text' => $locale->text('Customer Order Number'), },
'name' => { 'text' => $form->{vc} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), },
'employee' => { 'text' => $locale->text('Employee'), },
'salesman' => { 'text' => $locale->text('Salesman'), },
'shipvia' => { 'text' => $locale->text('Ship via'), },
'globalprojectnumber' => { 'text' => $locale->text('Project Number'), },
'transaction_description' => { 'text' => $locale->text('Transaction description'), },
'open' => { 'text' => $locale->text('Open'), },
'delivered' => { 'text' => $locale->text('Delivered'), },
'department' => { 'text' => $locale->text('Department'), },
'insertdate' => { 'text' => $locale->text('Insert Date'), },
'items' => { 'text' => $locale->text('Positions'), },
);

foreach my $name (qw(id transdate reqdate donumber ordnumber name employee salesman shipvia transaction_description department insertdate)) {
my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
$column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";
}

$form->{"l_type"} = "Y";
map { $column_defs{$_}->{visible} = $form->{"l_${_}"} ? 1 : 0 } @columns;

$column_defs{ids}->{visible} = 'HTML';

$report->set_columns(%column_defs);
$report->set_column_order(@columns);

$report->set_export_options('orders', @hidden_variables, qw(sort sortdir));

$report->set_sort_indicator($form->{sort}, $form->{sortdir});

my @options;
if ($form->{customer}) {
push @options, $locale->text('Customer') . " : $form->{customer}";
}
if ($form->{vendor}) {
push @options, $locale->text('Vendor') . " : $form->{vendor}";
}
if ($form->{cp_name}) {
push @options, $locale->text('Contact Person') . " : $form->{cp_name}";
}
if ($form->{department_id}) {
push @options, $locale->text('Department') . " : " . SL::DB::Department->new(id => $form->{department_id})->load->description;
}
if ($form->{donumber}) {
push @options, $locale->text('Delivery Order Number') . " : $form->{donumber}";
}
if ($form->{ordnumber}) {
push @options, $locale->text('Order Number') . " : $form->{ordnumber}";
}
push @options, $locale->text('Serial Number') . " : $form->{serialnumber}" if $form->{serialnumber};
if ($form->{business_id}) {
my $vc_type_label = $form->{vc} eq 'customer' ? $locale->text('Customer type') : $locale->text('Vendor type');
push @options, $vc_type_label . " : " . SL::DB::Business->new(id => $form->{business_id})->load->description;
}
if ($form->{transaction_description}) {
push @options, $locale->text('Transaction description') . " : $form->{transaction_description}";
}
if ($form->{parts_description}) {
push @options, $locale->text('Part Description') . " : $form->{parts_description}";
}
if ($form->{parts_partnumber}) {
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}";
}
if ($form->{chargenumber}) {
push @options, $locale->text('Charge Number') . " : $form->{chargenumber}";
}
if ( $form->{transdatefrom} or $form->{transdateto} ) {
push @options, $locale->text('Delivery Order Date');
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if $form->{transdatefrom};
push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1) if $form->{transdateto};
};
if ( $form->{reqdatefrom} or $form->{reqdateto} ) {
push @options, $locale->text('Reqdate');
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{reqdatefrom}, 1) if $form->{reqdatefrom};
push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{reqdateto}, 1) if $form->{reqdateto};
};
if ( $form->{insertdatefrom} or $form->{insertdateto} ) {
push @options, $locale->text('Insert Date');
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{insertdatefrom}, 1) if $form->{insertdatefrom};
push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{insertdateto}, 1) if $form->{insertdateto};
};
if ($form->{open}) {
push @options, $locale->text('Open');
}
if ($form->{closed}) {
push @options, $locale->text('Closed');
}
if ($form->{delivered}) {
push @options, $locale->text('Delivered');
}
if ($form->{notdelivered}) {
push @options, $locale->text('Not delivered');
}
push @options, $locale->text('Quick Search') . " : $form->{all}" if $form->{all};

my $pr = SL::DB::Manager::Printer->find_by(
printer_description => $::locale->text("sales_delivery_order_printer"));
if ($pr ) {
$form->{printer_id} = $pr->id;
}

my $print_options = SL::Helper::PrintOptions->get_print_options(
options => {
hide_language_id => 1,
show_bothsided => 1,
show_headers => 1,
},
);

$report->set_options('top_info_text' => join("\n", @options),
'raw_top_info_text' => $form->parse_html_template('do/orders_top'),
'raw_bottom_info_text' => $form->parse_html_template('do/orders_bottom', { print_options => $print_options }),
'output_format' => 'HTML',
'title' => $form->{title},
'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
my $callback = $form->escape($href);

my $edit_url = build_std_url('action=edit', 'type', 'vc');
my $edit_order_url = ($::instance_conf->get_feature_experimental_order)
? build_std_url('script=controller.pl', 'action=Order/edit', 'type=' . ($form->{type} eq 'sales_delivery_order' ? 'sales_order' : 'purchase_order'))
: build_std_url('script=oe.pl', 'action=edit', 'type=' . ($form->{type} eq 'sales_delivery_order' ? 'sales_order' : 'purchase_order'));

my $idx = 1;

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');

my $row = { map { $_ => { 'data' => $dord->{$_} } } grep {$_ ne 'items'} @columns };

my $ord_id = $dord->{id};
$row->{ids} = {
'raw_data' => $cgi->hidden('-name' => "trans_id_${idx}", '-value' => $ord_id)
. $cgi->checkbox('-name' => "multi_id_${idx}",' id' => "multi_id_id_".$ord_id, '-value' => 1, 'data-checkall' => 1, '-label' => ''),
'valign' => 'center',
'align' => 'center',
};

$row->{donumber}->{link} = SL::DB::DeliveryOrder::TypeData::get3($dord->{order_type}, "show_menu", "new_controller")
? SL::Controller::DeliveryOrder->url_for(action => "edit", id => $dord->{id}, type => $dord->{order_type})
: $edit_url . "&id=" . E($dord->{id}) . "&callback=${callback}";
$row->{ordnumber}->{link} = $edit_order_url . "&id=" . E($dord->{oe_id}) . "&callback=${callback}" if $dord->{oe_id};

if ($form->{l_items}) {
my $items = SL::DB::Manager::DeliveryOrderItem->get_all_sorted(where => [id => $dord->{item_ids}]);
$row->{items}->{raw_data} = SL::Presenter::ItemsList::items_list($items) if lc($report->{options}->{output_format}) eq 'html';
$row->{items}->{data} = SL::Presenter::ItemsList::items_list($items, as_text => 1) if lc($report->{options}->{output_format}) ne 'html';
}

$report->add_data($row);

$idx++;
}

setup_do_orders_action_bar();

$report->generate_with_headers();

$main::lxdebug->leave_sub();
}

sub save {
$main::lxdebug->enter_sub();

my (%params) = @_;

check_do_access_for_edit();

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;

$form->mtime_ischanged('delivery_orders');

my $validity_token;
if (!$form->{id}) {
$validity_token = SL::DB::Manager::ValidityToken->fetch_valid_token(
scope => SL::DB::ValidityToken::SCOPE_DELIVERY_ORDER_SAVE(),
token => $form->{form_validity_token},
);

$form->error($::locale->text('The form is not valid anymore.')) if !$validity_token;
}

$form->{defaultcurrency} = $form->get_default_currency(\%myconfig);

$form->isblank("transdate", $locale->text('Delivery Order Date missing!'));

$form->{donumber} =~ s/^\s*//g;
$form->{donumber} =~ s/\s*$//g;

my $msg = ucfirst $form->{vc};
$form->isblank($form->{vc} . "_id", $locale->text($msg . " missing!"));

# $locale->text('Customer missing!');
# $locale->text('Vendor missing!');

remove_emptied_rows();
validate_items();

# check for serial number if part needs one
for my $i (1 .. $form->{rowcount} - 1) {
next unless $form->{"has_sernumber_$i"};
$form->isblank("serialnumber_$i",
$locale->text('Serial Number missing in Row') . " $i");
}
# if the name changed get new values
my $vc = $form->{vc};
if (($form->{"previous_${vc}_id"} || $form->{"${vc}_id"}) != $form->{"${vc}_id"}) {
$::form->{salesman_id} = SL::DB::Manager::Employee->current->id if exists $::form->{salesman_id};

if ($vc eq 'customer') {
IS->get_customer(\%myconfig, $form);
$::form->{billing_address_id} = $::form->{default_billing_address_id};
} else {
IR->get_vendor(\%myconfig, $form);
}

update();
$::dispatcher->end_request;
}

$form->{id} = 0 if $form->{saveasnew};
# we rely on converted_from_orderitems, if the workflow is used
# be sure that at least one position is linked to the original orderitem
if ($form->{convert_from_oe_ids}) {
my $has_linked_pos;
for my $i (1 .. $form->{rowcount}) {
if ($form->{"converted_from_orderitems_id_$i"}) {
$has_linked_pos = 1;
last;
}
}
if (!$has_linked_pos) {
$form->error($locale->text('Need at least one original position for the workflow Order to Delivery Order!'));
}
}
DO->save();

$validity_token->delete if $validity_token;
delete $form->{form_validity_token};

# saving the history
if(!exists $form->{addition}) {
$form->{snumbers} = qq|donumber_| . $form->{donumber};
$form->{addition} = "SAVED";
$form->save_history;
}
# /saving the history

$form->{simple_save} = 1;
if (!$params{no_redirect} && !$form->{print_and_save}) {
delete @{$form}{ary_diff([keys %{ $form }], [qw(login id script type cursor_fokus)])};
edit();
$::dispatcher->end_request;
}
$main::lxdebug->leave_sub();
}

sub delete {
$main::lxdebug->enter_sub();

check_do_access_for_edit();

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
my $ret;
if ($ret = DO->delete()) {
# saving the history
if(!exists $form->{addition}) {
$form->{snumbers} = qq|donumber_| . $form->{donumber};
$form->{addition} = "DELETED";
$form->save_history;
}
# /saving the history

$form->info($locale->text('Delivery Order deleted!'));
$::dispatcher->end_request;
}

$form->error($locale->text('Cannot delete delivery order!') . $ret);

$main::lxdebug->leave_sub();
}
sub delete_transfers {
$main::lxdebug->enter_sub();

check_do_access_for_edit();

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
my $ret;

die "Invalid form type" unless $form->{type} =~ m/^(sales|purchase)_delivery_order$/;

if ($ret = DO->delete_transfers()) {
# saving the history
if(!exists $form->{addition}) {
$form->{snumbers} = qq|donumber_| . $form->{donumber};
$form->{addition} = "UNDO TRANSFER";
$form->save_history;
}
# /saving the history

flash_later('info', $locale->text("Transfer undone."));

$form->{callback} = 'do.pl?action=edit&type=' . $form->{type} . '&id=' . $form->escape($form->{id});
$form->redirect;
}

$form->error($locale->text('Cannot undo delivery order transfer!') . $ret);

$main::lxdebug->leave_sub();
}

sub invoice {
$main::lxdebug->enter_sub();

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;

check_do_access();
$form->mtime_ischanged('delivery_orders');

$main::auth->assert($form->{type} eq 'purchase_delivery_order' ? 'vendor_invoice_edit' : 'invoice_edit');

$form->get_employee();

$form->{form_validity_token} = SL::DB::ValidityToken->create(scope => SL::DB::ValidityToken::SCOPE_SALES_INVOICE_POST())->token;
$form->{convert_from_do_ids} = $form->{id};
# if we have a reqdate (Liefertermin), this is definetely the preferred
# deliverydate for invoices
$form->{deliverydate} = $form->{reqdate} || $form->{transdate};
</