Rechnungen nach Fälligkeitsdatum sortieren

[mfinanz.git] / SL / DB / DeliveryOrder.pm

diff --git a/SL/DB/DeliveryOrder.pm b/SL/DB/DeliveryOrder.pm
index 824689353d545d2b97c3565bdaa3f67067a8e8ad..b6f1f95967f5beb7d6e8063207155034a6b0d397 100644 (file)
--- a/SL/DB/DeliveryOrder.pm
+++ b/SL/DB/DeliveryOrder.pm
@@ -8,6 +8,8 @@ use Rose::DB::Object::Helpers ();
 
 use SL::DB::MetaSetup::DeliveryOrder;
 use SL::DB::Manager::DeliveryOrder;
 
 use SL::DB::MetaSetup::DeliveryOrder;
 use SL::DB::Manager::DeliveryOrder;

+use SL::DB::Helper::AttrHTML;
+use SL::DB::Helper::AttrSorted;

 use SL::DB::Helper::FlattenToForm;
 use SL::DB::Helper::LinkedRecords;
 use SL::DB::Helper::TransNumberGenerator;
 use SL::DB::Helper::FlattenToForm;
 use SL::DB::Helper::LinkedRecords;
 use SL::DB::Helper::TransNumberGenerator;


@@ -29,6 +31,9 @@ __PACKAGE__->meta->add_relationship(orderitems => { type         => 'one to many
 
 __PACKAGE__->meta->initialize;
 
 
 __PACKAGE__->meta->initialize;
 

+__PACKAGE__->attr_html('notes');
+__PACKAGE__->attr_sorted('items');
+

 __PACKAGE__->before_save('_before_save_set_donumber');
 
 # hooks
 __PACKAGE__->before_save('_before_save_set_donumber');
 
 # hooks


@@ -45,12 +50,8 @@ sub _before_save_set_donumber {
 
 sub items { goto &orderitems; }
 sub add_items { goto &add_orderitems; }
 
 sub items { goto &orderitems; }
 sub add_items { goto &add_orderitems; }

-
-sub items_sorted {
-  my ($self) = @_;
-
-  return [ sort {$a->id <=> $b->id } @{ $self->items } ];
-}
+sub payment_terms { goto &payment; }
+sub record_number { goto &donumber; }

 
 sub sales_order {
   my $self   = shift;
 
 sub sales_order {
   my $self   = shift;


@@ -72,6 +73,19 @@ sub type {
   return shift->customer_id ? 'sales_delivery_order' : 'purchase_delivery_order';
 }
 
   return shift->customer_id ? 'sales_delivery_order' : 'purchase_delivery_order';
 }
 

+sub displayable_type {
+  my $type = shift->type;
+
+  return $::locale->text('Sales Delivery Order')    if $type eq 'sales_delivery_order';
+  return $::locale->text('Purchase Delivery Order') if $type eq 'purchase_delivery_order';
+
+  die 'invalid type';
+}
+
+sub displayable_name {
+  join ' ', grep $_, map $_[0]->$_, qw(displayable_type record_number);
+};
+

 sub displayable_state {
   my ($self) = @_;
 
 sub displayable_state {
   my ($self) = @_;
 


@@ -105,15 +119,12 @@ sub new_from {
     $item_parent_column    = 'order';
   }
 
     $item_parent_column    = 'order';
   }
 

-  my $terms = $source->can('payment_id') && $source->payment_id ? $source->payment_terms->terms_netto : 0;
-

   my %args = ( map({ ( $_ => $source->$_ ) } qw(cp_id currency_id customer_id cusordnumber department_id employee_id globalproject_id intnotes language_id notes
   my %args = ( map({ ( $_ => $source->$_ ) } qw(cp_id currency_id customer_id cusordnumber department_id employee_id globalproject_id intnotes language_id notes

-                                                ordnumber reqdate salesman_id shippingpoint shipvia taxincluded taxzone_id transaction_description vendor_id
+                                                ordnumber payment_id reqdate salesman_id shippingpoint shipvia taxincluded taxzone_id transaction_description vendor_id

                                              )),
                closed    => 0,
                is_sales  => !!$source->customer_id,
                delivered => 0,
                                              )),
                closed    => 0,
                is_sales  => !!$source->customer_id,
                delivered => 0,

-               terms     => $terms,

                transdate => DateTime->today_local,
             );
 
                transdate => DateTime->today_local,
             );
 


@@ -155,7 +166,7 @@ sub new_from {
 
     SL::DB::DeliveryOrderItem->new(map({ ( $_ => $source_item->$_ ) }
                                          qw(base_qty cusordnumber description discount lastcost longdescription marge_price_factor parts_id price_factor price_factor_id
 
     SL::DB::DeliveryOrderItem->new(map({ ( $_ => $source_item->$_ ) }
                                          qw(base_qty cusordnumber description discount lastcost longdescription marge_price_factor parts_id price_factor price_factor_id

-                                            project_id qty reqdate sellprice serialnumber transdate unit
+                                            project_id qty reqdate sellprice serialnumber transdate unit active_discount_source active_price_source

                                          )),
                                    custom_variables => \@custom_variables,
                                    ordnumber        => ref($item_parent) eq 'SL::DB::Order' ? $item_parent->ordnumber : $source_item->ordnumber,
                                          )),
                                    custom_variables => \@custom_variables,
                                    ordnumber        => ref($item_parent) eq 'SL::DB::Order' ? $item_parent->ordnumber : $source_item->ordnumber,


@@ -163,13 +174,52 @@ sub new_from {
 
   } @{ $items };
 
 
   } @{ $items };
 

+  @items = grep { $params{item_filter}->($_) } @items if $params{item_filter};

   @items = grep { $_->qty * 1 } @items if $params{skip_items_zero_qty};
   @items = grep { $_->qty * 1 } @items if $params{skip_items_zero_qty};

+  @items = grep { $_->qty >=0 } @items if $params{skip_items_negative_qty};

 
   $delivery_order->items(\@items);
 
   return ($delivery_order, $custom_shipto);
 }
 
 
   $delivery_order->items(\@items);
 
   return ($delivery_order, $custom_shipto);
 }
 

+sub customervendor {
+  $_[0]->is_sales ? $_[0]->customer : $_[0]->vendor;
+}
+
+sub convert_to_invoice {
+  my ($self, %params) = @_;
+
+  croak("Conversion to invoices is only supported for sales records") unless $self->customer_id;
+
+  my $invoice;
+  if (!$self->db->with_transaction(sub {
+    require SL::DB::Invoice;
+    $invoice = SL::DB::Invoice->new_from($self)->post(%params) || die;
+    $self->link_to_record($invoice);
+    foreach my $item (@{ $invoice->items }) {
+      foreach (qw(delivery_order_items)) {    # expand if needed (delivery_order_items)
+        if ($item->{"converted_from_${_}_id"}) {
+          die unless $item->{id};
+          RecordLinks->create_links('mode'       => 'ids',
+                                    'from_table' => $_,
+                                    'from_ids'   => $item->{"converted_from_${_}_id"},
+                                    'to_table'   => 'invoice',
+                                    'to_id'      => $item->{id},
+          ) || die;
+          delete $item->{"converted_from_${_}_id"};
+        }
+      }
+    }
+    $self->update_attributes(closed => 1);
+    1;
+  })) {
+    return undef;
+  }
+
+  return $invoice;
+}
+

 1;
 __END__
 
 1;
 __END__
 


@@ -190,6 +240,11 @@ SL::DB::DeliveryOrder - Rose model for delivery orders (table
 
 An alias for C<transdate> for compatibility with other sales/purchase models.
 
 
 An alias for C<transdate> for compatibility with other sales/purchase models.
 

+=item C<displayable_name>
+
+Returns a human-readable and translated description of the delivery order, consisting of
+record type and number, e.g. "Verkaufslieferschein 123".
+

 =item C<displayable_state>
 
 Returns a human-readable description of the state regarding being
 =item C<displayable_state>
 
 Returns a human-readable description of the state regarding being


@@ -197,14 +252,9 @@ closed and delivered.
 
 =item C<items>
 
 
 =item C<items>
 

-An alias for C<deliver_orer_items> for compatibility with other
+An alias for C<delivery_order_items> for compatibility with other

 sales/purchase models.
 
 sales/purchase models.
 

-=item C<items_sorted>
-
-Returns the delivery order items sorted by their ID (same order they
-appear in the frontend delivery order masks).
-

 =item C<new_from $source, %params>
 
 Creates a new C<SL::DB::DeliveryOrder> instance and copies as much
 =item C<new_from $source, %params>
 
 Creates a new C<SL::DB::DeliveryOrder> instance and copies as much


@@ -239,10 +289,21 @@ missing then the method C<items_sorted> will be called on
 C<$source>. This option can be used to override the sorting, to
 exclude certain positions or to add additional ones.
 
 C<$source>. This option can be used to override the sorting, to
 exclude certain positions or to add additional ones.
 

+=item C<skip_items_negative_qty>
+
+If trueish then items with a negative quantity are skipped. Items with
+a quantity of 0 are not affected by this option.
+

 =item C<skip_items_zero_qty>
 
 If trueish then items with a quantity of 0 are skipped.
 
 =item C<skip_items_zero_qty>
 
 If trueish then items with a quantity of 0 are skipped.
 

+=item C<item_filter>
+
+An optional code reference that is called for each item with the item
+as its sole parameter. Items for which the code reference returns a
+falsish value will be skipped.
+

 =item C<attributes>
 
 An optional hash reference. If it exists then it is passed to C<new>
 =item C<attributes>
 
 An optional hash reference. If it exists then it is passed to C<new>


@@ -257,9 +318,24 @@ TODO: Describe sales_order
 
 =item C<type>
 
 
 =item C<type>
 

-Returns a stringdescribing this record's type: either
+Returns a string describing this record's type: either

 C<sales_delivery_order> or C<purchase_delivery_order>.
 
 C<sales_delivery_order> or C<purchase_delivery_order>.
 

+=item C<convert_to_invoice %params>
+
+Creates a new invoice with C<$self> as the basis by calling
+L<SL::DB::Invoice::new_from>. That invoice is posted, and C<$self> is
+linked to the new invoice via L<SL::DB::RecordLink>. C<$self>'s
+C<closed> attribute is set to C<true>, and C<$self> is saved.
+
+The arguments in C<%params> are passed to L<SL::DB::Invoice::post>.
+
+Returns the new invoice instance on success and C<undef> on
+failure. The whole process is run inside a transaction. On failure
+nothing is created or changed in the database.
+
+At the moment only sales delivery orders can be converted.
+

 =back
 
 =head1 BUGS
 =back
 
 =head1 BUGS