X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/5a2af3414e6a5f0fa4811194b42a3d155f414acb..d1a7b626e6b6b87539643016a2227c632e64e62b:/SL/DB/Part.pm diff --git a/SL/DB/Part.pm b/SL/DB/Part.pm index 581b468d5..0f855231e 100644 --- a/SL/DB/Part.pm +++ b/SL/DB/Part.pm @@ -32,7 +32,7 @@ __PACKAGE__->meta->add_relationships( assemblies => { type => 'one to many', class => 'SL::DB::Assembly', - manager_args => { sort_by => 'position, oid' }, + manager_args => { sort_by => 'position' }, column_map => { id => 'id' }, }, prices => { @@ -61,6 +61,7 @@ __PACKAGE__->meta->add_relationships( type => 'one to many', class => 'SL::DB::AssortmentItem', column_map => { id => 'assortment_id' }, + manager_args => { sort_by => 'position' }, }, history_entries => { type => 'one to many', @@ -75,6 +76,12 @@ __PACKAGE__->meta->add_relationships( column_map => { id => 'part_id' }, manager_args => { with_objects => [ 'shop' ] }, }, + last_price_update => { + type => 'one to one', + class => 'SL::DB::PartsPriceHistory', + column_map => { id => 'part_id' }, + manager_args => { sort_by => 'valid_from DESC', limit => 1 }, + }, ); __PACKAGE__->meta->initialize;