SL/DB/DeliveryOrder.pm

   1 package SL::DB::DeliveryOrder;
   2
   3 use strict;
   4
   5 use SL::DB::MetaSetup::DeliveryOrder;
   6 use SL::DB::Manager::DeliveryOrder;
   7 use SL::DB::Order;
   8
   9 use List::Util qw(first);
  10
  11 for my $field (qw(transdate reqdate)) {
  12   __PACKAGE__->attr_date($field);
  13 }
  14
  15 __PACKAGE__->meta->add_relationship(orderitems => { type         => 'one to many',
  16                                                     class        => 'SL::DB::DeliveryOrderItem',
  17                                                     column_map   => { id => 'trans_id' },
  18                                                     manager_args => { with_objects => [ 'part' ] }
  19                                                   },
  20                                    );
  21
  22 __PACKAGE__->meta->initialize;
  23
  24 # methods
  25
  26 sub sales_order {
  27   my $self   = shift;
  28   my %params = @_;
  29
  30   my $orders = SL::DB::Manager::Order->get_all(
  31     query => [
  32       ordnumber => $self->ordnumber,
  33       @{ $params{query} || [] },
  34     ],
  35   );
  36
  37   return first { $_->is_type('sales_order') } @{ $orders };
  38 }
  39
  40 1;