1 package SL::DB::Helper::FlattenToForm;
5 use parent qw(Exporter);
6 our @EXPORT = qw(flatten_to_form);
8 use List::MoreUtils qw(any);
13 my ($self, $form, %params) = @_;
15 my $vc = $self->can('customer_id') && $self->customer_id ? 'customer' : 'vendor';
17 _copy($self, $form, '', '', 0, qw(id type taxzone_id ordnumber quonumber invnumber donumber cusordnumber taxincluded shippingpoint shipvia notes intnotes curr cp_id
18 employee_id salesman_id closed department_id language_id payment_id delivery_customer_id delivery_vendor_id shipto_id proforma
19 globalproject_id delivered transaction_description container_type accepted_by_customer invoice terms storno storno_id dunning_config_id
20 orddate quodate reqdate gldate duedate deliverydate datepaid transdate));
22 if (_has($self, 'transdate')) {
23 my $transdate_idx = ref($self) eq 'SL::DB::Order' ? ($self->quotation ? 'quodate' : 'orddate')
24 : ref($self) eq 'SL::DB::Invoice' ? 'invdate'
26 $form->{$transdate_idx} = $self->transdate->to_lxoffice;
29 $form->{vc} = $vc if ref($self) =~ /^SL::DB::.*Invoice/;
31 my @vc_fields = (qw(account_number bank bank_code bic business city contact country creditlimit discount
32 email fax homepage iban language name payment_terms phone street taxnumber zipcode),
34 my @vc_prefixed_fields = qw(email fax notes number phone);
36 _copy($self, $form, '', '', 1, qw(amount netamount marge_total marge_percent container_remaining_weight container_remaining_volume paid));
37 _copy($self->$vc, $form, '', '', 0, @vc_fields);
38 _copy($self->$vc, $form, $vc, '', 0, @vc_prefixed_fields);
39 _copy($self->contact, $form, '', '', 0, grep { /^cp_/ } map { $_->name } SL::DB::Contact->meta->columns) if _has($self, 'cp_id');
40 _copy($self->shipto, $form, '', '', 0, grep { /^shipto/ } map { $_->name } SL::DB::Shipto->meta->columns) if _has($self, 'shipto_id');
41 _copy($self->globalproject, $form, 'globalproject', '', 0, qw(number description)) if _has($self, 'globalproject_id');
42 _copy($self->employee, $form, 'employee', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'employee_id');
43 _copy($self->salesman, $form, 'salesman', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'salesman_id');
44 _copy($self->acceptance_confirmed_by, $form, 'acceptance_confirmed_by_', '', 0, map { $_->name } SL::DB::Employee->meta->columns) if _has($self, 'acceptance_confirmed_by_id');
46 $form->{employee} = $self->employee->name if _has($self, 'employee_id');
47 $form->{language} = $self->language->template_code if _has($self, 'language_id');
48 $form->{department} = $self->department->description if _has($self, 'department_id');
49 $form->{rowcount} = scalar(@{ $self->items });
52 my $format_amounts = $params{format_amounts};
53 foreach my $item (@{ $self->items }) {
54 next if _has($item, 'assemblyitem');
58 $form->{"id_${idx}"} = $item->parts_id;
59 $form->{"number_${idx}"} = $item->part->partnumber;
60 _copy($item, $form, '', "_${idx}", 0, qw(description project_id ship serialnumber pricegroup_id ordnumber cusordnumber unit
61 subtotal longdescription price_factor_id marge_price_factor approved_sellprice reqdate transdate));
62 _copy($item, $form, '', "_${idx}", $format_amounts, qw(qty sellprice discount marge_total marge_percent lastcost));
63 _copy($item->project, $form, 'project', "_${idx}", 0, qw(number description)) if _has($item, 'project_id');
65 _copy_custom_variables($item, $form, 'ic_cvar_', "_${idx}");
68 _copy_custom_variables($self, $form, 'vc_cvar_', '');
74 my ($obj, $column) = @_;
75 return $obj->can($column) && $obj->$column;
79 my ($src, $form, $prefix, $postfix, $format_amounts, @columns) = @_;
81 map { $form->{"${prefix}${_}${postfix}"} = ref($src->$_) eq 'DateTime' ? $src->$_->to_lxoffice : $src->$_ if $src->can($_) } @columns if !$format_amounts;
82 map { $form->{"${prefix}${_}${postfix}"} = $::form->format_amount(\%::myconfig, $src->$_ * 1, 2) if $src->can($_) } @columns if $format_amounts;
87 sub _copy_custom_variables {
88 my ($src, $form, $prefix, $postfix) = @_;
90 my ($module, $sub_module, $trans_id) = ref($src) eq 'SL::DB::OrderItem' ? ('IC', 'orderitems', $src->id)
91 : ref($src) eq 'SL::DB::DeliveryOrderItem' ? ('IC', 'delivery_order_items', $src->id)
92 : ref($src) eq 'SL::DB::InvoiceItem' ? ('IC', 'invoice', $src->id)
93 : ('CT', undef, _has($src, 'customer_id') ? $src->customer_id : $src->vendor_id);
95 return unless $trans_id;
97 my $cvars = CVar->get_custom_variables(dbh => $src->db->dbh,
99 sub_module => $sub_module,
100 trans_id => $trans_id,
102 map { $form->{ $prefix . $_->{name} . $postfix } = $_->{value} } @{ $cvars };