Bug 17767: DBIC update

[koha.git] / Koha / Schema / Result / Item.pm

diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm
index c3c4b33..ce85bd7 100644 (file)
--- a/Koha/Schema/Result/Item.pm
+++ b/Koha/Schema/Result/Item.pm
@@ -33,6 +33,7 @@ __PACKAGE__->table("items");
 
   data_type: 'integer'
   default_value: 0
+  is_foreign_key: 1
   is_nullable: 0
 
 =head2 biblioitemnumber
@@ -273,9 +274,8 @@ __PACKAGE__->table("items");
   is_nullable: 1
   size: 32
 
-=head2 new
+=head2 new_status
 
-  accessor: undef
   data_type: 'varchar'
   is_nullable: 1
   size: 32
@@ -286,7 +286,12 @@ __PACKAGE__->add_columns(
   "itemnumber",
   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
   "biblionumber",
-  { data_type => "integer", default_value => 0, is_nullable => 0 },
+  {
+    data_type      => "integer",
+    default_value  => 0,
+    is_foreign_key => 1,
+    is_nullable    => 0,
+  },
   "biblioitemnumber",
   {
     data_type      => "integer",
@@ -387,8 +392,8 @@ __PACKAGE__->add_columns(
   { data_type => "varchar", is_nullable => 1, size => 32 },
   "stocknumber",
   { data_type => "varchar", is_nullable => 1, size => 32 },
-  "new",
-  { accessor => undef, data_type => "varchar", is_nullable => 1, size => 32 },
+  "new_status",
+  { data_type => "varchar", is_nullable => 1, size => 32 },
 );
 
 =head1 PRIMARY KEY
@@ -434,6 +439,21 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 article_requests
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::ArticleRequest>
+
+=cut
+
+__PACKAGE__->has_many(
+  "article_requests",
+  "Koha::Schema::Result::ArticleRequest",
+  { "foreign.itemnumber" => "self.itemnumber" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
 =head2 biblioitemnumber
 
 Type: belongs_to
@@ -449,6 +469,21 @@ __PACKAGE__->belongs_to(
   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 );
 
+=head2 biblionumber
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Biblio>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "biblionumber",
+  "Koha::Schema::Result::Biblio",
+  { biblionumber => "biblionumber" },
+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+);
+
 =head2 branchtransfers
 
 Type: has_many
@@ -640,8 +675,8 @@ __PACKAGE__->might_have(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rhW0Ddhh2hLoV//7nonLCA
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-24 13:56:21
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vf1sBZrpUo0Cvi896fjNuA
 
 __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
 
@@ -652,15 +687,16 @@ __PACKAGE__->belongs_to(
   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 );
 
+use C4::Context;
 sub effective_itemtype {
     my ( $self ) = @_;
 
-    my $pref = $self->result_source->schema->resultset('Systempreference')->find('item-level_itypes');
-    if ( $pref->value() && $self->itype() ) {
+    my $pref = C4::Context->preference('item-level_itypes');
+    if ( $pref && $self->itype() ) {
         return $self->itype();
     } else {
-        warn "item-level_itypes set but no itemtype set for item ($self->itemnumber)"
-          if $pref->value();
+        warn "item-level_itypes set but no itemtype set for item (".$self->itemnumber.")"
+          if $pref;
         return $self->biblioitemnumber()->itemtype();
     }
 }