Koha/Schema/Result/Item.pm

   1 use utf8;
   2 package Koha::Schema::Result::Item;
   3
   4 # Created by DBIx::Class::Schema::Loader
   5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
   6
   7 =head1 NAME
   8
   9 Koha::Schema::Result::Item
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<items>
  19
  20 =cut
  21
  22 __PACKAGE__->table("items");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 itemnumber
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 biblionumber
  33
  34   data_type: 'integer'
  35   default_value: 0
  36   is_foreign_key: 1
  37   is_nullable: 0
  38
  39 =head2 biblioitemnumber
  40
  41   data_type: 'integer'
  42   default_value: 0
  43   is_foreign_key: 1
  44   is_nullable: 0
  45
  46 =head2 barcode
  47
  48   data_type: 'varchar'
  49   is_nullable: 1
  50   size: 20
  51
  52 =head2 dateaccessioned
  53
  54   data_type: 'date'
  55   datetime_undef_if_invalid: 1
  56   is_nullable: 1
  57
  58 =head2 booksellerid
  59
  60   data_type: 'longtext'
  61   is_nullable: 1
  62
  63 =head2 homebranch
  64
  65   data_type: 'varchar'
  66   is_foreign_key: 1
  67   is_nullable: 1
  68   size: 10
  69
  70 =head2 price
  71
  72   data_type: 'decimal'
  73   is_nullable: 1
  74   size: [8,2]
  75
  76 =head2 replacementprice
  77
  78   data_type: 'decimal'
  79   is_nullable: 1
  80   size: [8,2]
  81
  82 =head2 replacementpricedate
  83
  84   data_type: 'date'
  85   datetime_undef_if_invalid: 1
  86   is_nullable: 1
  87
  88 =head2 datelastborrowed
  89
  90   data_type: 'date'
  91   datetime_undef_if_invalid: 1
  92   is_nullable: 1
  93
  94 =head2 datelastseen
  95
  96   data_type: 'date'
  97   datetime_undef_if_invalid: 1
  98   is_nullable: 1
  99
 100 =head2 stack
 101
 102   data_type: 'tinyint'
 103   is_nullable: 1
 104
 105 =head2 notforloan
 106
 107   data_type: 'tinyint'
 108   default_value: 0
 109   is_nullable: 0
 110
 111 =head2 damaged
 112
 113   data_type: 'tinyint'
 114   default_value: 0
 115   is_nullable: 0
 116
 117 =head2 damaged_on
 118
 119   data_type: 'datetime'
 120   datetime_undef_if_invalid: 1
 121   is_nullable: 1
 122
 123 =head2 itemlost
 124
 125   data_type: 'tinyint'
 126   default_value: 0
 127   is_nullable: 0
 128
 129 =head2 itemlost_on
 130
 131   data_type: 'datetime'
 132   datetime_undef_if_invalid: 1
 133   is_nullable: 1
 134
 135 =head2 withdrawn
 136
 137   data_type: 'tinyint'
 138   default_value: 0
 139   is_nullable: 0
 140
 141 =head2 withdrawn_on
 142
 143   data_type: 'datetime'
 144   datetime_undef_if_invalid: 1
 145   is_nullable: 1
 146
 147 =head2 itemcallnumber
 148
 149   data_type: 'varchar'
 150   is_nullable: 1
 151   size: 255
 152
 153 =head2 coded_location_qualifier
 154
 155   data_type: 'varchar'
 156   is_nullable: 1
 157   size: 10
 158
 159 =head2 issues
 160
 161   data_type: 'smallint'
 162   is_nullable: 1
 163
 164 =head2 renewals
 165
 166   data_type: 'smallint'
 167   is_nullable: 1
 168
 169 =head2 reserves
 170
 171   data_type: 'smallint'
 172   is_nullable: 1
 173
 174 =head2 restricted
 175
 176   data_type: 'tinyint'
 177   is_nullable: 1
 178
 179 =head2 itemnotes
 180
 181   data_type: 'longtext'
 182   is_nullable: 1
 183
 184 =head2 itemnotes_nonpublic
 185
 186   data_type: 'longtext'
 187   is_nullable: 1
 188
 189 =head2 holdingbranch
 190
 191   data_type: 'varchar'
 192   is_foreign_key: 1
 193   is_nullable: 1
 194   size: 10
 195
 196 =head2 paidfor
 197
 198   data_type: 'longtext'
 199   is_nullable: 1
 200
 201 =head2 timestamp
 202
 203   data_type: 'timestamp'
 204   datetime_undef_if_invalid: 1
 205   default_value: current_timestamp
 206   is_nullable: 0
 207
 208 =head2 location
 209
 210   data_type: 'varchar'
 211   is_nullable: 1
 212   size: 80
 213
 214 =head2 permanent_location
 215
 216   data_type: 'varchar'
 217   is_nullable: 1
 218   size: 80
 219
 220 =head2 onloan
 221
 222   data_type: 'date'
 223   datetime_undef_if_invalid: 1
 224   is_nullable: 1
 225
 226 =head2 cn_source
 227
 228   data_type: 'varchar'
 229   is_nullable: 1
 230   size: 10
 231
 232 =head2 cn_sort
 233
 234   data_type: 'varchar'
 235   is_nullable: 1
 236   size: 255
 237
 238 =head2 ccode
 239
 240   data_type: 'varchar'
 241   is_nullable: 1
 242   size: 80
 243
 244 =head2 materials
 245
 246   data_type: 'mediumtext'
 247   is_nullable: 1
 248
 249 =head2 uri
 250
 251   data_type: 'mediumtext'
 252   is_nullable: 1
 253
 254 =head2 itype
 255
 256   data_type: 'varchar'
 257   is_nullable: 1
 258   size: 10
 259
 260 =head2 more_subfields_xml
 261
 262   data_type: 'longtext'
 263   is_nullable: 1
 264
 265 =head2 enumchron
 266
 267   data_type: 'mediumtext'
 268   is_nullable: 1
 269
 270 =head2 copynumber
 271
 272   data_type: 'varchar'
 273   is_nullable: 1
 274   size: 32
 275
 276 =head2 stocknumber
 277
 278   data_type: 'varchar'
 279   is_nullable: 1
 280   size: 32
 281
 282 =head2 new_status
 283
 284   data_type: 'varchar'
 285   is_nullable: 1
 286   size: 32
 287
 288 =cut
 289
 290 __PACKAGE__->add_columns(
 291   "itemnumber",
 292   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 293   "biblionumber",
 294   {
 295     data_type      => "integer",
 296     default_value  => 0,
 297     is_foreign_key => 1,
 298     is_nullable    => 0,
 299   },
 300   "biblioitemnumber",
 301   {
 302     data_type      => "integer",
 303     default_value  => 0,
 304     is_foreign_key => 1,
 305     is_nullable    => 0,
 306   },
 307   "barcode",
 308   { data_type => "varchar", is_nullable => 1, size => 20 },
 309   "dateaccessioned",
 310   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 311   "booksellerid",
 312   { data_type => "longtext", is_nullable => 1 },
 313   "homebranch",
 314   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 315   "price",
 316   { data_type => "decimal", is_nullable => 1, size => [8, 2] },
 317   "replacementprice",
 318   { data_type => "decimal", is_nullable => 1, size => [8, 2] },
 319   "replacementpricedate",
 320   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 321   "datelastborrowed",
 322   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 323   "datelastseen",
 324   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 325   "stack",
 326   { data_type => "tinyint", is_nullable => 1 },
 327   "notforloan",
 328   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 329   "damaged",
 330   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 331   "damaged_on",
 332   {
 333     data_type => "datetime",
 334     datetime_undef_if_invalid => 1,
 335     is_nullable => 1,
 336   },
 337   "itemlost",
 338   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 339   "itemlost_on",
 340   {
 341     data_type => "datetime",
 342     datetime_undef_if_invalid => 1,
 343     is_nullable => 1,
 344   },
 345   "withdrawn",
 346   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 347   "withdrawn_on",
 348   {
 349     data_type => "datetime",
 350     datetime_undef_if_invalid => 1,
 351     is_nullable => 1,
 352   },
 353   "itemcallnumber",
 354   { data_type => "varchar", is_nullable => 1, size => 255 },
 355   "coded_location_qualifier",
 356   { data_type => "varchar", is_nullable => 1, size => 10 },
 357   "issues",
 358   { data_type => "smallint", is_nullable => 1 },
 359   "renewals",
 360   { data_type => "smallint", is_nullable => 1 },
 361   "reserves",
 362   { data_type => "smallint", is_nullable => 1 },
 363   "restricted",
 364   { data_type => "tinyint", is_nullable => 1 },
 365   "itemnotes",
 366   { data_type => "longtext", is_nullable => 1 },
 367   "itemnotes_nonpublic",
 368   { data_type => "longtext", is_nullable => 1 },
 369   "holdingbranch",
 370   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 371   "paidfor",
 372   { data_type => "longtext", is_nullable => 1 },
 373   "timestamp",
 374   {
 375     data_type => "timestamp",
 376     datetime_undef_if_invalid => 1,
 377     default_value => \"current_timestamp",
 378     is_nullable => 0,
 379   },
 380   "location",
 381   { data_type => "varchar", is_nullable => 1, size => 80 },
 382   "permanent_location",
 383   { data_type => "varchar", is_nullable => 1, size => 80 },
 384   "onloan",
 385   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 386   "cn_source",
 387   { data_type => "varchar", is_nullable => 1, size => 10 },
 388   "cn_sort",
 389   { data_type => "varchar", is_nullable => 1, size => 255 },
 390   "ccode",
 391   { data_type => "varchar", is_nullable => 1, size => 80 },
 392   "materials",
 393   { data_type => "mediumtext", is_nullable => 1 },
 394   "uri",
 395   { data_type => "mediumtext", is_nullable => 1 },
 396   "itype",
 397   { data_type => "varchar", is_nullable => 1, size => 10 },
 398   "more_subfields_xml",
 399   { data_type => "longtext", is_nullable => 1 },
 400   "enumchron",
 401   { data_type => "mediumtext", is_nullable => 1 },
 402   "copynumber",
 403   { data_type => "varchar", is_nullable => 1, size => 32 },
 404   "stocknumber",
 405   { data_type => "varchar", is_nullable => 1, size => 32 },
 406   "new_status",
 407   { data_type => "varchar", is_nullable => 1, size => 32 },
 408 );
 409
 410 =head1 PRIMARY KEY
 411
 412 =over 4
 413
 414 =item * L</itemnumber>
 415
 416 =back
 417
 418 =cut
 419
 420 __PACKAGE__->set_primary_key("itemnumber");
 421
 422 =head1 UNIQUE CONSTRAINTS
 423
 424 =head2 C<itembarcodeidx>
 425
 426 =over 4
 427
 428 =item * L</barcode>
 429
 430 =back
 431
 432 =cut
 433
 434 __PACKAGE__->add_unique_constraint("itembarcodeidx", ["barcode"]);
 435
 436 =head1 RELATIONS
 437
 438 =head2 accountlines
 439
 440 Type: has_many
 441
 442 Related object: L<Koha::Schema::Result::Accountline>
 443
 444 =cut
 445
 446 __PACKAGE__->has_many(
 447   "accountlines",
 448   "Koha::Schema::Result::Accountline",
 449   { "foreign.itemnumber" => "self.itemnumber" },
 450   { cascade_copy => 0, cascade_delete => 0 },
 451 );
 452
 453 =head2 article_requests
 454
 455 Type: has_many
 456
 457 Related object: L<Koha::Schema::Result::ArticleRequest>
 458
 459 =cut
 460
 461 __PACKAGE__->has_many(
 462   "article_requests",
 463   "Koha::Schema::Result::ArticleRequest",
 464   { "foreign.itemnumber" => "self.itemnumber" },
 465   { cascade_copy => 0, cascade_delete => 0 },
 466 );
 467
 468 =head2 biblioitemnumber
 469
 470 Type: belongs_to
 471
 472 Related object: L<Koha::Schema::Result::Biblioitem>
 473
 474 =cut
 475
 476 __PACKAGE__->belongs_to(
 477   "biblioitemnumber",
 478   "Koha::Schema::Result::Biblioitem",
 479   { biblioitemnumber => "biblioitemnumber" },
 480   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 481 );
 482
 483 =head2 biblionumber
 484
 485 Type: belongs_to
 486
 487 Related object: L<Koha::Schema::Result::Biblio>
 488
 489 =cut
 490
 491 __PACKAGE__->belongs_to(
 492   "biblionumber",
 493   "Koha::Schema::Result::Biblio",
 494   { biblionumber => "biblionumber" },
 495   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 496 );
 497
 498 =head2 branchtransfers
 499
 500 Type: has_many
 501
 502 Related object: L<Koha::Schema::Result::Branchtransfer>
 503
 504 =cut
 505
 506 __PACKAGE__->has_many(
 507   "branchtransfers",
 508   "Koha::Schema::Result::Branchtransfer",
 509   { "foreign.itemnumber" => "self.itemnumber" },
 510   { cascade_copy => 0, cascade_delete => 0 },
 511 );
 512
 513 =head2 club_holds
 514
 515 Type: has_many
 516
 517 Related object: L<Koha::Schema::Result::ClubHold>
 518
 519 =cut
 520
 521 __PACKAGE__->has_many(
 522   "club_holds",
 523   "Koha::Schema::Result::ClubHold",
 524   { "foreign.item_id" => "self.itemnumber" },
 525   { cascade_copy => 0, cascade_delete => 0 },
 526 );
 527
 528 =head2 course_item
 529
 530 Type: might_have
 531
 532 Related object: L<Koha::Schema::Result::CourseItem>
 533
 534 =cut
 535
 536 __PACKAGE__->might_have(
 537   "course_item",
 538   "Koha::Schema::Result::CourseItem",
 539   { "foreign.itemnumber" => "self.itemnumber" },
 540   { cascade_copy => 0, cascade_delete => 0 },
 541 );
 542
 543 =head2 creator_batches
 544
 545 Type: has_many
 546
 547 Related object: L<Koha::Schema::Result::CreatorBatch>
 548
 549 =cut
 550
 551 __PACKAGE__->has_many(
 552   "creator_batches",
 553   "Koha::Schema::Result::CreatorBatch",
 554   { "foreign.item_number" => "self.itemnumber" },
 555   { cascade_copy => 0, cascade_delete => 0 },
 556 );
 557
 558 =head2 hold_fill_target
 559
 560 Type: might_have
 561
 562 Related object: L<Koha::Schema::Result::HoldFillTarget>
 563
 564 =cut
 565
 566 __PACKAGE__->might_have(
 567   "hold_fill_target",
 568   "Koha::Schema::Result::HoldFillTarget",
 569   { "foreign.itemnumber" => "self.itemnumber" },
 570   { cascade_copy => 0, cascade_delete => 0 },
 571 );
 572
 573 =head2 holdingbranch
 574
 575 Type: belongs_to
 576
 577 Related object: L<Koha::Schema::Result::Branch>
 578
 579 =cut
 580
 581 __PACKAGE__->belongs_to(
 582   "holdingbranch",
 583   "Koha::Schema::Result::Branch",
 584   { branchcode => "holdingbranch" },
 585   {
 586     is_deferrable => 1,
 587     join_type     => "LEFT",
 588     on_delete     => "RESTRICT",
 589     on_update     => "CASCADE",
 590   },
 591 );
 592
 593 =head2 homebranch
 594
 595 Type: belongs_to
 596
 597 Related object: L<Koha::Schema::Result::Branch>
 598
 599 =cut
 600
 601 __PACKAGE__->belongs_to(
 602   "homebranch",
 603   "Koha::Schema::Result::Branch",
 604   { branchcode => "homebranch" },
 605   {
 606     is_deferrable => 1,
 607     join_type     => "LEFT",
 608     on_delete     => "RESTRICT",
 609     on_update     => "CASCADE",
 610   },
 611 );
 612
 613 =head2 issue
 614
 615 Type: might_have
 616
 617 Related object: L<Koha::Schema::Result::Issue>
 618
 619 =cut
 620
 621 __PACKAGE__->might_have(
 622   "issue",
 623   "Koha::Schema::Result::Issue",
 624   { "foreign.itemnumber" => "self.itemnumber" },
 625   { cascade_copy => 0, cascade_delete => 0 },
 626 );
 627
 628 =head2 items_last_borrower
 629
 630 Type: might_have
 631
 632 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
 633
 634 =cut
 635
 636 __PACKAGE__->might_have(
 637   "items_last_borrower",
 638   "Koha::Schema::Result::ItemsLastBorrower",
 639   { "foreign.itemnumber" => "self.itemnumber" },
 640   { cascade_copy => 0, cascade_delete => 0 },
 641 );
 642
 643 =head2 old_issues
 644
 645 Type: has_many
 646
 647 Related object: L<Koha::Schema::Result::OldIssue>
 648
 649 =cut
 650
 651 __PACKAGE__->has_many(
 652   "old_issues",
 653   "Koha::Schema::Result::OldIssue",
 654   { "foreign.itemnumber" => "self.itemnumber" },
 655   { cascade_copy => 0, cascade_delete => 0 },
 656 );
 657
 658 =head2 old_reserves
 659
 660 Type: has_many
 661
 662 Related object: L<Koha::Schema::Result::OldReserve>
 663
 664 =cut
 665
 666 __PACKAGE__->has_many(
 667   "old_reserves",
 668   "Koha::Schema::Result::OldReserve",
 669   { "foreign.itemnumber" => "self.itemnumber" },
 670   { cascade_copy => 0, cascade_delete => 0 },
 671 );
 672
 673 =head2 reserves
 674
 675 Type: has_many
 676
 677 Related object: L<Koha::Schema::Result::Reserve>
 678
 679 =cut
 680
 681 __PACKAGE__->has_many(
 682   "reserves",
 683   "Koha::Schema::Result::Reserve",
 684   { "foreign.itemnumber" => "self.itemnumber" },
 685   { cascade_copy => 0, cascade_delete => 0 },
 686 );
 687
 688 =head2 return_claims
 689
 690 Type: has_many
 691
 692 Related object: L<Koha::Schema::Result::ReturnClaim>
 693
 694 =cut
 695
 696 __PACKAGE__->has_many(
 697   "return_claims",
 698   "Koha::Schema::Result::ReturnClaim",
 699   { "foreign.itemnumber" => "self.itemnumber" },
 700   { cascade_copy => 0, cascade_delete => 0 },
 701 );
 702
 703 =head2 serialitem
 704
 705 Type: might_have
 706
 707 Related object: L<Koha::Schema::Result::Serialitem>
 708
 709 =cut
 710
 711 __PACKAGE__->might_have(
 712   "serialitem",
 713   "Koha::Schema::Result::Serialitem",
 714   { "foreign.itemnumber" => "self.itemnumber" },
 715   { cascade_copy => 0, cascade_delete => 0 },
 716 );
 717
 718 =head2 stockrotationitem
 719
 720 Type: might_have
 721
 722 Related object: L<Koha::Schema::Result::Stockrotationitem>
 723
 724 =cut
 725
 726 __PACKAGE__->might_have(
 727   "stockrotationitem",
 728   "Koha::Schema::Result::Stockrotationitem",
 729   { "foreign.itemnumber_id" => "self.itemnumber" },
 730   { cascade_copy => 0, cascade_delete => 0 },
 731 );
 732
 733 =head2 tmp_holdsqueues
 734
 735 Type: has_many
 736
 737 Related object: L<Koha::Schema::Result::TmpHoldsqueue>
 738
 739 =cut
 740
 741 __PACKAGE__->has_many(
 742   "tmp_holdsqueues",
 743   "Koha::Schema::Result::TmpHoldsqueue",
 744   { "foreign.itemnumber" => "self.itemnumber" },
 745   { cascade_copy => 0, cascade_delete => 0 },
 746 );
 747
 748
 749 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-17 10:42:24
 750 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CcrMhgq+PQ1MHV6jZEN8wA
 751
 752 __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
 753
 754 __PACKAGE__->belongs_to(
 755   "biblio",
 756   "Koha::Schema::Result::Biblio",
 757   { biblionumber => "biblionumber" },
 758   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 759 );
 760
 761 use C4::Context;
 762 sub effective_itemtype {
 763     my ( $self ) = @_;
 764
 765     my $pref = C4::Context->preference('item-level_itypes');
 766     if ( $pref && $self->itype() ) {
 767         return $self->itype();
 768     } else {
 769         warn "item-level_itypes set but no itemtype set for item (".$self->itemnumber.")"
 770           if $pref;
 771         return $self->biblioitemnumber()->itemtype();
 772     }
 773 }
 774
 775 1;