1 package SL::DB::Helper::FlattenToForm;
5 use parent qw(Exporter);
6 our @EXPORT = qw(flatten_to_form);
8 use List::MoreUtils qw(any);
11 my ($self, $form, %params) = @_;
13 my $vc = $self->can('customer_id') && $self->customer_id ? 'customer' : 'vendor';
15 _copy($self, $form, '', '', 0, qw(id type taxzone_id ordnumber quonumber invnumber donumber cusordnumber taxincluded shippingpoint shipvia notes intnotes cp_id
16 employee_id salesman_id closed department_id language_id payment_id delivery_customer_id delivery_vendor_id shipto_id proforma
17 globalproject_id delivered transaction_description container_type accepted_by_customer invoice storno storno_id dunning_config_id
18 orddate quodate reqdate gldate duedate deliverydate datepaid transdate delivery_term_id));
19 $form->{currency} = $form->{curr} = $self->currency_id ? $self->currency->name || '' : '';
21 if ( $vc eq 'customer' ) {
22 $form->{customer_id} = $self->customer_id;
24 $form->{vendor_id} = $self->vendor_id;
27 if (_has($self, 'transdate')) {
28 my $transdate_idx = ref($self) eq 'SL::DB::Order' ? ($self->quotation ? 'quodate' : 'orddate')
29 : ref($self) eq 'SL::DB::Invoice' ? 'invdate'
31 $form->{$transdate_idx} = $self->transdate->to_lxoffice;
34 $form->{vc} = $vc if ref($self) =~ m{^SL::DB::(?:.*Invoice|Order)};
36 my @vc_fields = (qw(account_number bank bank_code bic business city contact country creditlimit
37 department_1 department_2 discount email fax gln homepage iban language name
38 payment_terms phone street taxnumber ustid zipcode),
40 ($vc eq 'customer')? 'c_vendor_id': 'v_customer_id');
41 my @vc_prefixed_fields = qw(email fax notes number phone);
43 _copy($self, $form, '', '', 1, qw(amount netamount marge_total marge_percent container_remaining_weight container_remaining_volume paid));
44 _copy($self->$vc, $form, '', '', 0, @vc_fields);
45 _copy($self->$vc, $form, $vc, '', 0, @vc_prefixed_fields);
46 _copy($self->contact, $form, '', '', 0, grep { /^cp_/ } map { $_->name } SL::DB::Contact->meta->columns) if _has($self, 'cp_id');
47 _copy($self->shipto, $form, '', '', 0, grep { /^shipto/ } map { $_->name } SL::DB::Shipto->meta->columns) if _has($self, 'shipto_id');
48 _copy($self->globalproject, $form, 'globalproject', '', 0, qw(number description)) if _has($self, 'globalproject_id');
49 _copy($self->employee, $form, 'employee_', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'employee_id');
50 _copy($self->salesman, $form, 'salesman_', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'salesman_id');
51 _copy($self->acceptance_confirmed_by, $form, 'acceptance_confirmed_by_', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'acceptance_confirmed_by_id');
53 $form->{employee} = $self->employee->name if _has($self, 'employee_id');
54 $form->{language} = $self->language->template_code if _has($self, 'language_id');
55 $form->{department} = $self->department->description if _has($self, 'department_id');
56 $form->{business} = $self->$vc->business->description if _has($self->$vc, 'business_id');
57 $form->{rowcount} = scalar(@{ $self->items });
59 my $items_name = ref($self) eq 'SL::DB::Order' ? 'orderitems'
60 : ref($self) eq 'SL::DB::DeliveryOrder' ? 'delivery_order_items'
61 : ref($self) eq 'SL::DB::Invoice' ? 'invoice'
65 my $format_amounts = $params{format_amounts} ? 1 : 0;
66 my $format_notnull = $params{format_amounts} ? 2 : 0;
67 my $format_percent = $params{format_amounts} ? 3 : 0;
68 my $format_noround = $params{format_amounts} ? 4 : 0;
69 foreach my $item (@{ $self->items_sorted }) {
70 next if _has($item, 'assemblyitem');
74 $form->{"partsgroup_${idx}"} = $item->part->partsgroup->partsgroup if _has($item->part, 'partsgroup_id');
75 _copy($item, $form, "${items_name}_", "_${idx}", 0, qw(id)) if $items_name;
76 _copy($item->part, $form, '', "_${idx}", 0, qw(id partnumber weight));
77 _copy($item->part, $form, '', "_${idx}", 0, qw(listprice));
78 _copy($item, $form, '', "_${idx}", 0, qw(description project_id ship serialnumber pricegroup_id ordnumber donumber cusordnumber unit
79 subtotal longdescription price_factor_id marge_price_factor approved_sellprice reqdate transdate
80 active_price_source active_discount_source));
81 _copy($item, $form, '', "_${idx}", $format_noround, qw(qty sellprice));
82 _copy($item, $form, '', "_${idx}", $format_amounts, qw(marge_total marge_percent lastcost));
83 _copy($item, $form, '', "_${idx}", $format_percent, qw(discount));
84 _copy($item->project, $form, 'project', "_${idx}", 0, qw(number description)) if _has($item, 'project_id');
86 _copy_custom_variables($item, $form, 'ic_cvar_', "_${idx}");
88 if (ref($self) eq 'SL::DB::Invoice') {
89 my $date = $item->deliverydate ? $item->deliverydate->to_lxoffice : undef;
90 $form->{"deliverydate_oe_${idx}"} = $date;
91 $form->{"reqdate_${idx}"} = $date;
95 _copy_custom_variables($self, $form, 'vc_cvar_', '');
101 my ($obj, $column) = @_;
102 return $obj->can($column) && $obj->$column;
106 my ($src, $form, $prefix, $postfix, $format_amounts, @columns) = @_;
108 @columns = grep { $src->can($_) } @columns;
110 map { $form->{"${prefix}${_}${postfix}"} = ref($src->$_) eq 'DateTime' ? $src->$_->to_lxoffice : $src->$_ } @columns if !$format_amounts;
111 map { $form->{"${prefix}${_}${postfix}"} = $::form->format_amount(\%::myconfig, $src->$_ * 1, 2) } @columns if $format_amounts == 1;
112 map { $form->{"${prefix}${_}${postfix}"} = $src->$_ * 1 ? $::form->format_amount(\%::myconfig, $src->$_ * 1, 2) : 0 } @columns if $format_amounts == 2;
113 map { $form->{"${prefix}${_}${postfix}"} = $src->$_ * 1 ? $::form->format_amount(\%::myconfig, $src->$_ * 100, 2) : 0 } @columns if $format_amounts == 3;
114 map { $form->{"${prefix}${_}${postfix}"} = $src->$_ * 1 ? $::form->format_amount(\%::myconfig, $src->$_ * 1, -2) : 0 } @columns if $format_amounts == 4;
119 sub _copy_custom_variables {
120 my ($src, $form, $prefix, $postfix, $format_amounts) = @_;
122 my $obj = (any { ref($src) eq $_ } qw(SL::DB::OrderItem SL::DB::DeliveryOrderItem SL::DB::InvoiceItem))
124 : $src->customervendor;
126 foreach my $cvar (@{ $obj->cvars_by_config }) {
127 my $value = ($cvar->config->type =~ m{^(?:bool|customer|vendor|part)$})
129 : $cvar->value_as_text;
131 $form->{ $prefix . $cvar->config->name . $postfix } = $value;