X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/fff57e55bed689ab673bf72937bfd71eab26a293..2aecf487d4afd29f13007b927fec624c2f45d3ce:/SL/DB/Invoice.pm diff --git a/SL/DB/Invoice.pm b/SL/DB/Invoice.pm index 8a4f4ec8e..502654ba2 100644 --- a/SL/DB/Invoice.pm +++ b/SL/DB/Invoice.pm @@ -130,22 +130,32 @@ sub new_from { require SL::DB::Employee; - my $terms = $source->can('payment_id') && $source->payment_id ? $source->payment_terms->terms_netto : 0; - my (@columns, @item_columns); + my $terms = $source->can('payment_id') && $source->payment_id ? $source->payment_terms + : $source->customer_id ? $source ->customer->payment_terms + : undef; + + my (@columns, @item_columns, $item_parent_id_column, $item_parent_column); if (ref($source) eq 'SL::DB::Order') { @columns = qw(quonumber payment_id delivery_customer_id delivery_vendor_id); @item_columns = qw(subtotal); + $item_parent_id_column = 'trans_id'; + $item_parent_column = 'order'; + } else { @columns = qw(donumber); + + $item_parent_id_column = 'delivery_order_id'; + $item_parent_column = 'delivery_order'; } my %args = ( map({ ( $_ => $source->$_ ) } qw(customer_id taxincluded shippingpoint shipvia notes intnotes salesman_id cusordnumber ordnumber department_id cp_id language_id taxzone_id shipto_id globalproject_id transaction_description currency_id delivery_term_id), @columns), transdate => DateTime->today_local, gldate => DateTime->today_local, - duedate => DateTime->today_local->add(days => $terms * 1), + duedate => DateTime->today_local->add(days => ($terms ? $terms->terms_netto * 1 : 1)), + payment_id => $terms ? $terms->id : undef, invoice => 1, type => 'invoice', storno => 0, @@ -160,19 +170,27 @@ sub new_from { $args{quodate} = $source->transdate; } - my $invoice = $class->new(%args, %{ $params{attributes} || {} }); + my $invoice = $class->new(%args); + $invoice->assign_attributes(%{ $params{attributes} }) if $params{attributes}; my $items = delete($params{items}) || $source->items_sorted; + my %item_parents; my @items = map { my $source_item = $_; + my $source_item_id = $_->$item_parent_id_column; my @custom_variables = map { _clone_orderitem_delivery_order_item_cvar($_) } @{ $source_item->custom_variables }; + $item_parents{$source_item_id} ||= $source_item->$item_parent_column; + my $item_parent = $item_parents{$source_item_id}; + SL::DB::InvoiceItem->new(map({ ( $_ => $source_item->$_ ) } - qw(parts_id description qty sellprice discount project_id serialnumber pricegroup_id ordnumber transdate cusordnumber unit + qw(parts_id description qty sellprice discount project_id serialnumber pricegroup_id transdate cusordnumber unit base_qty longdescription lastcost price_factor_id), @item_columns), deliverydate => $source_item->reqdate, fxsellprice => $source_item->sellprice, custom_variables => \@custom_variables, + ordnumber => ref($item_parent) eq 'SL::DB::Order' ? $item_parent->ordnumber : $source_item->ordnumber, + donumber => ref($item_parent) eq 'SL::DB::DeliveryOrder' ? $item_parent->donumber : $source_item->can('donumber') ? $source_item->donumber : '', ); } @{ $items }; @@ -302,6 +320,15 @@ sub date { goto &transdate; } +sub transactions { + my ($self) = @_; + + return unless $self->id; + + require SL::DB::AccTransaction; + SL::DB::Manager::AccTransaction->get_all(query => [ trans_id => $self->id ]); +} + 1; __END__