X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FHelper%2FFlattenToForm.pm;h=920bdf2e84123557602b62e93bf7db94596b1fdf;hb=3defabe6d3011c83298d4415672ed5d32ccab95c;hp=7712c9d799c856e20f355fa06bfabd877f116b49;hpb=522eb5a4a138c665b00a7f99a9e2b66d7d44857d;p=kivitendo-erp.git diff --git a/SL/DB/Helper/FlattenToForm.pm b/SL/DB/Helper/FlattenToForm.pm index 7712c9d79..920bdf2e8 100644 --- a/SL/DB/Helper/FlattenToForm.pm +++ b/SL/DB/Helper/FlattenToForm.pm @@ -20,8 +20,10 @@ sub flatten_to_form { if ( $vc eq 'customer' ) { $form->{customer_id} = $self->customer_id; + $form->{customer} = $self->customer->name if $self->customer; } else { - $form->{vendor_id} = $self->vendor_id; + $form->{vendor_id} = $self->vendor_id; + $form->{vendor} = $self->vendor->name if $self->vendor; }; if (_has($self, 'transdate')) { @@ -31,11 +33,11 @@ sub flatten_to_form { $form->{$transdate_idx} = $self->transdate->to_lxoffice; } - $form->{vc} = $vc if ref($self) =~ m{^SL::DB::(?:.*Invoice|Order)}; + $form->{vc} = $vc if ref($self) =~ m{^SL::DB::(?:.*Invoice|.*Order)}; my @vc_fields = (qw(account_number bank bank_code bic business city contact country creditlimit - department_1 department_2 discount email fax gln homepage iban language name - payment_terms phone street taxnumber ustid zipcode), + department_1 department_2 discount email fax gln greeting homepage iban language name + phone street taxnumber ustid zipcode), "${vc}number", ($vc eq 'customer')? 'c_vendor_id': 'v_customer_id'); my @vc_prefixed_fields = qw(email fax notes number phone); @@ -50,6 +52,13 @@ sub flatten_to_form { _copy($self->salesman, $form, 'salesman_', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'salesman_id'); _copy($self->acceptance_confirmed_by, $form, 'acceptance_confirmed_by_', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'acceptance_confirmed_by_id'); + if (_has($self, 'employee_id')) { + my $user = User->new(login => $self->employee->login); + $form->{"employee_$_"} = $user->{$_} for qw(tel email fax); + } + # company is employee and login independent + $form->{"${_}_company"} = $::instance_conf->get_company for qw (employee salesman); + $form->{employee} = $self->employee->name if _has($self, 'employee_id'); $form->{language} = $self->language->template_code if _has($self, 'language_id'); $form->{department} = $self->department->description if _has($self, 'department_id'); @@ -73,12 +82,15 @@ sub flatten_to_form { $idx++; - $form->{"partsgroup_${idx}"} = $item->part->partsgroup->partsgroup if _has($item->part, 'partsgroup_id'); + $form->{"std_warehouse_${idx}"} = $item->part->warehouse->description if _has($item->part, 'warehouse_id'); + $form->{"std_bin_${idx}"} = $item->part->bin->description if _has($item->part, 'bin_id'); + $form->{"partsgroup_${idx}"} = $item->part->partsgroup->partsgroup if _has($item->part, 'partsgroup_id'); _copy($item, $form, "${items_name}_", "_${idx}", 0, qw(id)) if $items_name; - _copy($item->part, $form, '', "_${idx}", 0, qw(id partnumber weight)); + # TODO: is part_type correct here? Do we need to set part_type as default? + _copy($item->part, $form, '', "_${idx}", 0, qw(id partnumber weight part_type)); _copy($item->part, $form, '', "_${idx}", 0, qw(listprice)); _copy($item, $form, '', "_${idx}", 0, qw(description project_id ship serialnumber pricegroup_id ordnumber donumber cusordnumber unit - subtotal longdescription price_factor_id marge_price_factor approved_sellprice reqdate transdate + subtotal longdescription price_factor_id marge_price_factor reqdate transdate active_price_source active_discount_source)); _copy($item, $form, '', "_${idx}", $format_noround, qw(qty sellprice)); _copy($item, $form, '', "_${idx}", $format_amounts, qw(marge_total marge_percent lastcost)); @@ -95,6 +107,7 @@ sub flatten_to_form { } _copy_custom_variables($self, $form, 'vc_cvar_', '', $cvar_validity{vc}); + _copy_custom_variables($self->contact, $form, 'cp_cvar_', '') if $self->contact; return $self; } @@ -121,7 +134,7 @@ sub _copy { sub _copy_custom_variables { my ($src, $form, $prefix, $postfix, $cvar_validity) = @_; - my $obj = (any { ref($src) eq $_ } qw(SL::DB::OrderItem SL::DB::DeliveryOrderItem SL::DB::InvoiceItem)) + my $obj = (any { ref($src) eq $_ } qw(SL::DB::OrderItem SL::DB::DeliveryOrderItem SL::DB::InvoiceItem SL::DB::Contact)) ? $src : $src->customervendor;