Attachment #103987 for bug #25260

View | Details | Raw Unified | Return to bug 25260
Collapse All | Expand All

Lines 161-168 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/AuthorisedValue.pm (-2 / +2 lines)
161	);	161	);
162		162
163		163
164	# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-07 11:23:19	164	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:42
165	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6MjWlDqdpIOwsJlyjQawAg	165	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OQ+CBmiY+03gjFyILECgkg
166		166
167		167
168	# You can replace this text with custom code or comments, and it will be preserved on regeneration	168	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 97-104 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/AuthorisedValueCategory.pm (-2 / +2 lines)
97	);	97	);
98		98
99		99
100	# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:59:31	100	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:42
101	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6vToj9pUcIv8Jio38rNE4g	101	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+hJjiFy4+OTbGZe9FeOSJg
102		102
103	sub koha_objects_class {	103	sub koha_objects_class {
104	'Koha::AuthorisedValueCategories';	104	'Koha::AuthorisedValueCategories';




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 holds

Type: has_many

Related object: L<Koha::Schema::Result::Hold>

=cut

__PACKAGE__->has_many(
  "holds",
  "Koha::Schema::Result::Hold",
  { "foreign.biblio_id" => "self.biblionumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 items

Type: has_many

Related object: L<Koha::Schema::Result::Item>

=cut

__PACKAGE__->has_many(
  "items",
  "Koha::Schema::Result::Item",
  { "foreign.biblionumber" => "self.biblionumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

Related object: L<Koha::Schema::Result::Reserve>

=cut

__PACKAGE__->has_many(
  "reserves",
  "Koha::Schema::Result::Reserve",
  { "foreign.biblionumber" => "self.biblionumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reviews

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N40arh8lmwliRuTIf0ji7g


__PACKAGE__->has_one(





=head1 RELATIONS

=head2 accountlines_borrowernumbers

Type: has_many


=cut

__PACKAGE__->has_many(
  "accountlines_borrowernumbers",
  "Koha::Schema::Result::Accountline",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 holds

Type: has_many

Related object: L<Koha::Schema::Result::Hold>

=cut

__PACKAGE__->has_many(
  "holds",
  "Koha::Schema::Result::Hold",
  { "foreign.patron_id" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 housebound_profile

Type: might_have

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 messages_borrowernumbers

Type: has_many


=cut

__PACKAGE__->has_many(
  "messages_borrowernumbers",
  "Koha::Schema::Result::Message",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 messages_managers

Type: has_many


=cut

__PACKAGE__->has_many(
  "messages_managers",
  "Koha::Schema::Result::Message",
  { "foreign.manager_id" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);


  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 old_reserves

Type: has_many

Related object: L<Koha::Schema::Result::OldReserve>

=cut

__PACKAGE__->has_many(
  "old_reserves",
  "Koha::Schema::Result::OldReserve",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 opac_news

Type: has_many

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

Related object: L<Koha::Schema::Result::Reserve>

=cut

__PACKAGE__->has_many(
  "reserves",
  "Koha::Schema::Result::Reserve",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 return_claims_borrowernumbers

Type: has_many

__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eeA+LaMzH/BGaVIEXfv91A

__PACKAGE__->add_columns(
    '+anonymized'    => { is_boolean => 1 },

Lines 162-169 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/BorrowerAttributeType.pm (-2 / +2 lines)
162	);	162	);
163		163
164		164
165	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-25 20:32:12	165	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:42
166	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gsPR8PuUUZHFUkr3MIbTpw	166	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iBALyOv0WYIIIyiKh+Qtlw
167		167
168	sub koha_object_class {	168	sub koha_object_class {
169	'Koha::Patron::Attribute::Type';	169	'Koha::Patron::Attribute::Type';




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 holds

Type: has_many

Related object: L<Koha::Schema::Result::Hold>

=cut

__PACKAGE__->has_many(
  "holds",
  "Koha::Schema::Result::Hold",
  { "foreign.pickup_library_id" => "self.branchcode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 illrequests

Type: has_many

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

Related object: L<Koha::Schema::Result::Reserve>

=cut

__PACKAGE__->has_many(
  "reserves",
  "Koha::Schema::Result::Reserve",
  { "foreign.branchcode" => "self.branchcode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 special_holidays

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QCorqKahrCQBDE1G6A5o+Q

__PACKAGE__->add_columns(
    '+pickup_location' => { is_boolean => 1 }

Lines 266-273 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Category.pm (-2 / +2 lines)
266	);	266	);
267		267
268		268
269	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-04-12 02:43:58	269	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:42
270	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7rwTH9HuxcdRCBP/bj0d/A	270	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IJa+UUdr5UUiwK9vcnzVtQ
271		271
272	sub koha_object_class {	272	sub koha_object_class {
273	'Koha::Patron::Category';	273	'Koha::Patron::Category';





Type: belongs_to

Related object: L<Koha::Schema::Result::Hold>

=cut

__PACKAGE__->belongs_to(
  "hold",
  "Koha::Schema::Result::Hold",
  { id => "hold_id" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:43
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5z4rQioemKHFmPWtIw+HSw

sub koha_objects_class {
    'Koha::Club::Hold::PatronHolds';

Lines 158-165 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Currency.pm (-2 / +2 lines)
158	);	158	);
159		159
160		160
161	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-01 14:23:58	161	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:43
162	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PnJEcCgrM1Edf99phWFdyQ	162	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GZu4ECid8a0ON+Vqv2TY4g
163		163
164		164
165	sub koha_object_class {	165	sub koha_object_class {

Lines 181-188 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Deletedbiblio.pm (-2 / +2 lines)
181	);	181	);
182		182
183		183
184	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-08-05 13:53:34	184	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:43
185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FQaznWmkfR2Ge5NG8lDmSw	185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cmMAwEbKNSiFaYVexqQHbQ
186		186
187	sub koha_objects_class {	187	sub koha_objects_class {
188	'Koha::Old::Biblios';	188	'Koha::Old::Biblios';

Lines 264-271 __PACKAGE__->might_have( Link Here

(-)a/Koha/Schema/Result/Issue.pm (-2 / +2 lines)
264	);	264	);
265		265
266		266
267	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-31 12:18:38	267	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:43
268	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QVmFa5b0Pe5OhUI92n9kzQ	268	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oMVidyJ8jFrABeMsWQ0Gkw
269		269
270	__PACKAGE__->add_columns(	270	__PACKAGE__->add_columns(
271	'+auto_renew' => { is_boolean => 1 },	271	'+auto_renew' => { is_boolean => 1 },




  },
);

=head2 holds

Type: has_many

Related object: L<Koha::Schema::Result::Hold>

=cut

__PACKAGE__->has_many(
  "holds",
  "Koha::Schema::Result::Hold",
  { "foreign.item_id" => "self.itemnumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 homebranch

Type: belongs_to

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 old_reserves

Type: has_many

Related object: L<Koha::Schema::Result::OldReserve>

=cut

__PACKAGE__->has_many(
  "old_reserves",
  "Koha::Schema::Result::OldReserve",
  { "foreign.itemnumber" => "self.itemnumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

Related object: L<Koha::Schema::Result::Reserve>

=cut

__PACKAGE__->has_many(
  "reserves",
  "Koha::Schema::Result::Reserve",
  { "foreign.itemnumber" => "self.itemnumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 return_claims

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0gYj48OTmEd79BoFTb2EiQ

__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );





  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 holds

Type: has_many

Related object: L<Koha::Schema::Result::ItemtypesBranch>

=cut

__PACKAGE__->has_many(
  "itemtypes_branches",
  "Koha::Schema::Result::ItemtypesBranch",
  { "foreign.itemtype" => "self.itemtype" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 old_reserves

Type: has_many

Related object: L<Koha::Schema::Result::Hold>

=cut

__PACKAGE__->has_many(
  "holds",
  "Koha::Schema::Result::Hold",
  { "foreign.item_type" => "self.itemtype" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 itemtypes_branches

Type: has_many

Related object: L<Koha::Schema::Result::ItemtypesBranch>

=cut

__PACKAGE__->has_many(
  "itemtypes_branches",
  "Koha::Schema::Result::ItemtypesBranch",
  { "foreign.itemtype" => "self.itemtype" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SK+5YpGrmEVIio1N0y1Ixw

__PACKAGE__->add_columns(
    '+rentalcharge_hourly_calendar' => { is_boolean => 1 },





=head1 NAME

Koha::Schema::Result::OldReserve - VIEW

=cut


use warnings;

use base 'DBIx::Class::Core';
__PACKAGE__->table_class("DBIx::Class::ResultSource::View");

=head1 TABLE: C<old_reserves>

=cut

__PACKAGE__->table("old_reserves");
__PACKAGE__->result_source_instance->view_definition("select `dbic`.`holds`.`id` AS `reserve_id`,`dbic`.`holds`.`patron_id` AS `borrowernumber`,`dbic`.`holds`.`placing_date` AS `reservedate`,`dbic`.`holds`.`biblio_id` AS `biblionumber`,`dbic`.`holds`.`pickup_library_id` AS `branchcode`,(case when (`dbic`.`holds`.`status` = 'cancelled') then `dbic`.`holds`.`completion_date` else NULL end) AS `cancellationdate`,`dbic`.`holds`.`notes` AS `reservenotes`,`dbic`.`holds`.`priority` AS `priority`,(case when (`dbic`.`holds`.`status` = 'fulfilled') then 'F' else NULL end) AS `found`,`dbic`.`holds`.`timestamp` AS `timestamp`,`dbic`.`holds`.`item_id` AS `itemnumber`,`dbic`.`holds`.`waiting_date` AS `waitingdate`,`dbic`.`holds`.`expiration_date` AS `expirationdate`,`dbic`.`holds`.`lowest_priority` AS `lowestPriority`,`dbic`.`holds`.`suspended` AS `suspend`,`dbic`.`holds`.`suspended_until_date` AS `suspend_until`,`dbic`.`holds`.`item_type` AS `itemtype`,`dbic`.`holds`.`item_level` AS `item_level_hold` from `dbic`.`holds` where (`dbic`.`holds`.`completed` = 1)");

=head1 ACCESSORS

=head2 reserve_id

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

=head2 borrowernumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

=head2 reservedate


=head2 biblionumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

=head2 branchcode


  is_nullable: 1
  size: 10

=head2 notificationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 reminderdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 cancellationdate

  data_type: 'date'


  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

=head2 itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 waitingdate

=head2 itemtype

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10



__PACKAGE__->add_columns(
  "reserve_id",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "borrowernumber",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "reservedate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "biblionumber",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "branchcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "notificationdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "reminderdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "cancellationdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "reservenotes",

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "0000-00-00 00:00:00",
    is_nullable => 0,
  },
  "itemnumber",
  { data_type => "integer", is_nullable => 1 },
  "waitingdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "expirationdate",

    is_nullable => 1,
  },
  "itemtype",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "item_level_hold",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</reserve_id>

=back

=cut

__PACKAGE__->set_primary_key("reserve_id");

=head1 RELATIONS

=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,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);

=head2 borrowernumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Borrower>

=cut

__PACKAGE__->belongs_to(
  "borrowernumber",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "borrowernumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);

=head2 itemnumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Item>

=cut

__PACKAGE__->belongs_to(
  "itemnumber",
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);

=head2 itemtype

Type: belongs_to

Related object: L<Koha::Schema::Result::Itemtype>

=cut

__PACKAGE__->belongs_to(
  "itemtype",
  "Koha::Schema::Result::Itemtype",
  { itemtype => "itemtype" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j84bBLVB23oDE0csBcI8+A

__PACKAGE__->add_columns(
    '+item_level_hold' => { is_boolean => 1 },

Lines 171-178 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Overduerule.pm (-2 / +2 lines)
171	);	171	);
172		172
173		173
174	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-06 12:00:28	174	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:43
175	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Opfa1YZ3IeQRRbyrbKAkNQ	175	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KxNZfxE1nimQWpvHx8VQxA
176		176
177		177
178	# You can replace this text with custom content, and it will be preserved on regeneration	178	# You can replace this text with custom content, and it will be preserved on regeneration





=head1 NAME

Koha::Schema::Result::Reserve - VIEW

=cut


use warnings;

use base 'DBIx::Class::Core';
__PACKAGE__->table_class("DBIx::Class::ResultSource::View");

=head1 TABLE: C<reserves>

=cut

__PACKAGE__->table("reserves");
__PACKAGE__->result_source_instance->view_definition("select `dbic`.`holds`.`id` AS `reserve_id`,`dbic`.`holds`.`patron_id` AS `borrowernumber`,`dbic`.`holds`.`placing_date` AS `reservedate`,`dbic`.`holds`.`biblio_id` AS `biblionumber`,`dbic`.`holds`.`pickup_library_id` AS `branchcode`,NULL AS `cancellationdate`,`dbic`.`holds`.`notes` AS `reservenotes`,`dbic`.`holds`.`priority` AS `priority`,(case when (`dbic`.`holds`.`status` = 'waiting') then 'W' when (`dbic`.`holds`.`status` = 'in_transit') then 'T' else NULL end) AS `found`,`dbic`.`holds`.`timestamp` AS `timestamp`,`dbic`.`holds`.`item_id` AS `itemnumber`,`dbic`.`holds`.`waiting_date` AS `waitingdate`,`dbic`.`holds`.`expiration_date` AS `expirationdate`,`dbic`.`holds`.`lowest_priority` AS `lowestPriority`,`dbic`.`holds`.`suspended` AS `suspend`,`dbic`.`holds`.`suspended_until_date` AS `suspend_until`,`dbic`.`holds`.`item_type` AS `itemtype`,`dbic`.`holds`.`item_level` AS `item_level_hold` from `dbic`.`holds` where (`dbic`.`holds`.`completed` = 0)");

=head1 ACCESSORS

=head2 reserve_id

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

=head2 borrowernumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

=head2 reservedate


  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

=head2 branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

=head2 notificationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 reminderdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 cancellationdate

  data_type: 'binary'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 reservenotes


  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

=head2 itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 waitingdate

=head2 itemtype

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10



__PACKAGE__->add_columns(
  "reserve_id",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "borrowernumber",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "reservedate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "biblionumber",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "branchcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "notificationdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "reminderdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "cancellationdate",
  { data_type => "binary", is_nullable => 1 },
  "reservenotes",
  { data_type => "longtext", is_nullable => 1 },
  "priority",

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "0000-00-00 00:00:00",
    is_nullable => 0,
  },
  "itemnumber",
  { data_type => "integer", is_nullable => 1 },
  "waitingdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "expirationdate",

    is_nullable => 1,
  },
  "itemtype",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "item_level_hold",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</reserve_id>

=back

=cut

__PACKAGE__->set_primary_key("reserve_id");

=head1 RELATIONS

=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 borrowernumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Borrower>

=cut

__PACKAGE__->belongs_to(
  "borrowernumber",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "borrowernumber" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 branchcode

Type: belongs_to

Related object: L<Koha::Schema::Result::Branch>

=cut

__PACKAGE__->belongs_to(
  "branchcode",
  "Koha::Schema::Result::Branch",
  { branchcode => "branchcode" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 club_holds_to_patron_holds

Type: has_many

Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>

=cut

__PACKAGE__->has_many(
  "club_holds_to_patron_holds",
  "Koha::Schema::Result::ClubHoldsToPatronHold",
  { "foreign.hold_id" => "self.reserve_id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 itemnumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Item>

=cut

# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5rN+zc7MxGkvUsCfihsq2Q
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 itemtype

Type: belongs_to

Related object: L<Koha::Schema::Result::Itemtype>

=cut

__PACKAGE__->belongs_to(
  "itemtype",
  "Koha::Schema::Result::Itemtype",
  { itemtype => "itemtype" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VH7h5kYo9WhlGobXb3N3Jg

__PACKAGE__->belongs_to(
  "item",
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

__PACKAGE__->belongs_to(
  "biblio",
  "Koha::Schema::Result::Biblio",
  { biblionumber => "biblionumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

__PACKAGE__->add_columns(
    '+item_level_hold' => { is_boolean => 1 },
- 

Return to bug 25260

Lines 270-301 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-26 / +11 lines)
270	{ cascade_copy => 0, cascade_delete => 0 },	270	{ cascade_copy => 0, cascade_delete => 0 },
271	);	271	);
272		272
273	=head2 items	273	=head2 holds
274		274
275	Type: has_many	275	Type: has_many
276		276
277	Related object: L<Koha::Schema::Result::Item>	277	Related object: L<Koha::Schema::Result::Hold>
278		278
279	=cut	279	=cut
280		280
281	__PACKAGE__->has_many(	281	__PACKAGE__->has_many(
282	"items",	282	"holds",
283	"Koha::Schema::Result::Item",	283	"Koha::Schema::Result::Hold",
284	{ "foreign.biblionumber" => "self.biblionumber" },	284	{ "foreign.biblio_id" => "self.biblionumber" },
285	{ cascade_copy => 0, cascade_delete => 0 },	285	{ cascade_copy => 0, cascade_delete => 0 },
286	);	286	);
287		287
288	=head2 old_reserves	288	=head2 items
289		289
290	Type: has_many	290	Type: has_many
291		291
292	Related object: L<Koha::Schema::Result::OldReserve>	292	Related object: L<Koha::Schema::Result::Item>
293		293
294	=cut	294	=cut
295		295
296	__PACKAGE__->has_many(	296	__PACKAGE__->has_many(
297	"old_reserves",	297	"items",
298	"Koha::Schema::Result::OldReserve",	298	"Koha::Schema::Result::Item",
299	{ "foreign.biblionumber" => "self.biblionumber" },	299	{ "foreign.biblionumber" => "self.biblionumber" },
300	{ cascade_copy => 0, cascade_delete => 0 },	300	{ cascade_copy => 0, cascade_delete => 0 },
301	);	301	);
Lines 315-335 __PACKAGE__->has_many( Link Here
315	{ cascade_copy => 0, cascade_delete => 0 },	315	{ cascade_copy => 0, cascade_delete => 0 },
316	);	316	);
317		317
318	=head2 reserves
319
320	Type: has_many
321
322	Related object: L<Koha::Schema::Result::Reserve>
323
324	=cut
325
326	__PACKAGE__->has_many(
327	"reserves",
328	"Koha::Schema::Result::Reserve",
329	{ "foreign.biblionumber" => "self.biblionumber" },
330	{ cascade_copy => 0, cascade_delete => 0 },
331	);
332
333	=head2 reviews	318	=head2 reviews
334		319
335	Type: has_many	320	Type: has_many
Lines 451-458 __PACKAGE__->has_many( Link Here
451	);	436	);
452		437
453		438
454	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51	439	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
455	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p2SIq565zPyE3ZUkSuXyBA	440	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N40arh8lmwliRuTIf0ji7g
456		441
457		442
458	__PACKAGE__->has_one(	443	__PACKAGE__->has_one(

Lines 712-718 __PACKAGE__->add_unique_constraint("userid", ["userid"]); Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-40 / +25 lines)
712		712
713	=head1 RELATIONS	713	=head1 RELATIONS
714		714
715	=head2 accountlines	715	=head2 accountlines_borrowernumbers
716		716
717	Type: has_many	717	Type: has_many
718		718
Lines 721-727 Related object: L<Koha::Schema::Result::Accountline> Link Here
721	=cut	721	=cut
722		722
723	__PACKAGE__->has_many(	723	__PACKAGE__->has_many(
724	"accountlines",	724	"accountlines_borrowernumbers",
725	"Koha::Schema::Result::Accountline",	725	"Koha::Schema::Result::Accountline",
726	{ "foreign.borrowernumber" => "self.borrowernumber" },	726	{ "foreign.borrowernumber" => "self.borrowernumber" },
727	{ cascade_copy => 0, cascade_delete => 0 },	727	{ cascade_copy => 0, cascade_delete => 0 },
Lines 1057-1062 __PACKAGE__->has_many( Link Here
1057	{ cascade_copy => 0, cascade_delete => 0 },	1057	{ cascade_copy => 0, cascade_delete => 0 },
1058	);	1058	);
1059		1059
		1060	=head2 holds
		1061
		1062	Type: has_many
		1063
		1064	Related object: L<Koha::Schema::Result::Hold>
		1065
		1066	=cut
		1067
		1068	__PACKAGE__->has_many(
		1069	"holds",
		1070	"Koha::Schema::Result::Hold",
		1071	{ "foreign.patron_id" => "self.borrowernumber" },
		1072	{ cascade_copy => 0, cascade_delete => 0 },
		1073	);
		1074
1060	=head2 housebound_profile	1075	=head2 housebound_profile
1061		1076
1062	Type: might_have	1077	Type: might_have
Lines 1192-1198 __PACKAGE__->has_many( Link Here
1192	{ cascade_copy => 0, cascade_delete => 0 },	1207	{ cascade_copy => 0, cascade_delete => 0 },
1193	);	1208	);
1194		1209
1195	=head2 messages	1210	=head2 messages_borrowernumbers
1196		1211
1197	Type: has_many	1212	Type: has_many
1198		1213
Lines 1201-1213 Related object: L<Koha::Schema::Result::Message> Link Here
1201	=cut	1216	=cut
1202		1217
1203	__PACKAGE__->has_many(	1218	__PACKAGE__->has_many(
1204	"messages",	1219	"messages_borrowernumbers",
1205	"Koha::Schema::Result::Message",	1220	"Koha::Schema::Result::Message",
1206	{ "foreign.manager_id" => "self.borrowernumber" },	1221	{ "foreign.borrowernumber" => "self.borrowernumber" },
1207	{ cascade_copy => 0, cascade_delete => 0 },	1222	{ cascade_copy => 0, cascade_delete => 0 },
1208	);	1223	);
1209		1224
1210	=head2 messages_borrowernumbers	1225	=head2 messages_managers
1211		1226
1212	Type: has_many	1227	Type: has_many
1213		1228
Lines 1216-1224 Related object: L<Koha::Schema::Result::Message> Link Here
1216	=cut	1231	=cut
1217		1232
1218	__PACKAGE__->has_many(	1233	__PACKAGE__->has_many(
1219	"messages_borrowernumbers",	1234	"messages_managers",
1220	"Koha::Schema::Result::Message",	1235	"Koha::Schema::Result::Message",
1221	{ "foreign.borrowernumber" => "self.borrowernumber" },	1236	{ "foreign.manager_id" => "self.borrowernumber" },
1222	{ cascade_copy => 0, cascade_delete => 0 },	1237	{ cascade_copy => 0, cascade_delete => 0 },
1223	);	1238	);
1224		1239
Lines 1237-1257 __PACKAGE__->has_many( Link Here
1237	{ cascade_copy => 0, cascade_delete => 0 },	1252	{ cascade_copy => 0, cascade_delete => 0 },
1238	);	1253	);
1239		1254
1240	=head2 old_reserves
1241
1242	Type: has_many
1243
1244	Related object: L<Koha::Schema::Result::OldReserve>
1245
1246	=cut
1247
1248	__PACKAGE__->has_many(
1249	"old_reserves",
1250	"Koha::Schema::Result::OldReserve",
1251	{ "foreign.borrowernumber" => "self.borrowernumber" },
1252	{ cascade_copy => 0, cascade_delete => 0 },
1253	);
1254
1255	=head2 opac_news	1255	=head2 opac_news
1256		1256
1257	Type: has_many	1257	Type: has_many
Lines 1357-1377 __PACKAGE__->has_many( Link Here
1357	{ cascade_copy => 0, cascade_delete => 0 },	1357	{ cascade_copy => 0, cascade_delete => 0 },
1358	);	1358	);
1359		1359
1360	=head2 reserves
1361
1362	Type: has_many
1363
1364	Related object: L<Koha::Schema::Result::Reserve>
1365
1366	=cut
1367
1368	__PACKAGE__->has_many(
1369	"reserves",
1370	"Koha::Schema::Result::Reserve",
1371	{ "foreign.borrowernumber" => "self.borrowernumber" },
1372	{ cascade_copy => 0, cascade_delete => 0 },
1373	);
1374
1375	=head2 return_claims_borrowernumbers	1360	=head2 return_claims_borrowernumbers
1376		1361
1377	Type: has_many	1362	Type: has_many
Lines 1688-1695 Composing rels: L</aqorder_users> -> ordernumber Link Here
1688	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1673	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1689		1674
1690		1675
1691	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-01 09:42:50	1676	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
1692	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1G8678sy3UnvmJffzcU/Hg	1677	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eeA+LaMzH/BGaVIEXfv91A
1693		1678
1694	__PACKAGE__->add_columns(	1679	__PACKAGE__->add_columns(
1695	'+anonymized' => { is_boolean => 1 },	1680	'+anonymized' => { is_boolean => 1 },

Lines 578-583 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-17 / +17 lines)
578	{ cascade_copy => 0, cascade_delete => 0 },	578	{ cascade_copy => 0, cascade_delete => 0 },
579	);	579	);
580		580
		581	=head2 holds
		582
		583	Type: has_many
		584
		585	Related object: L<Koha::Schema::Result::Hold>
		586
		587	=cut
		588
		589	__PACKAGE__->has_many(
		590	"holds",
		591	"Koha::Schema::Result::Hold",
		592	{ "foreign.pickup_library_id" => "self.branchcode" },
		593	{ cascade_copy => 0, cascade_delete => 0 },
		594	);
		595
581	=head2 illrequests	596	=head2 illrequests
582		597
583	Type: has_many	598	Type: has_many
Lines 698-718 __PACKAGE__->has_many( Link Here
698	{ cascade_copy => 0, cascade_delete => 0 },	713	{ cascade_copy => 0, cascade_delete => 0 },
699	);	714	);
700		715
701	=head2 reserves
702
703	Type: has_many
704
705	Related object: L<Koha::Schema::Result::Reserve>
706
707	=cut
708
709	__PACKAGE__->has_many(
710	"reserves",
711	"Koha::Schema::Result::Reserve",
712	{ "foreign.branchcode" => "self.branchcode" },
713	{ cascade_copy => 0, cascade_delete => 0 },
714	);
715
716	=head2 special_holidays	716	=head2 special_holidays
717		717
718	Type: has_many	718	Type: has_many
Lines 789-796 __PACKAGE__->has_many( Link Here
789	);	789	);
790		790
791		791
792	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-29 16:09:25	792	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
793	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9f0Crr57ffdoe8syXgawng	793	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QCorqKahrCQBDE1G6A5o+Q
794		794
795	__PACKAGE__->add_columns(	795	__PACKAGE__->add_columns(
796	'+pickup_location' => { is_boolean => 1 }	796	'+pickup_location' => { is_boolean => 1 }

Lines 591-596 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Item.pm (-32 / +17 lines)
591	},	591	},
592	);	592	);
593		593
		594	=head2 holds
		595
		596	Type: has_many
		597
		598	Related object: L<Koha::Schema::Result::Hold>
		599
		600	=cut
		601
		602	__PACKAGE__->has_many(
		603	"holds",
		604	"Koha::Schema::Result::Hold",
		605	{ "foreign.item_id" => "self.itemnumber" },
		606	{ cascade_copy => 0, cascade_delete => 0 },
		607	);
		608
594	=head2 homebranch	609	=head2 homebranch
595		610
596	Type: belongs_to	611	Type: belongs_to
Lines 656-691 __PACKAGE__->has_many( Link Here
656	{ cascade_copy => 0, cascade_delete => 0 },	671	{ cascade_copy => 0, cascade_delete => 0 },
657	);	672	);
658		673
659	=head2 old_reserves
660
661	Type: has_many
662
663	Related object: L<Koha::Schema::Result::OldReserve>
664
665	=cut
666
667	__PACKAGE__->has_many(
668	"old_reserves",
669	"Koha::Schema::Result::OldReserve",
670	{ "foreign.itemnumber" => "self.itemnumber" },
671	{ cascade_copy => 0, cascade_delete => 0 },
672	);
673
674	=head2 reserves
675
676	Type: has_many
677
678	Related object: L<Koha::Schema::Result::Reserve>
679
680	=cut
681
682	__PACKAGE__->has_many(
683	"reserves",
684	"Koha::Schema::Result::Reserve",
685	{ "foreign.itemnumber" => "self.itemnumber" },
686	{ cascade_copy => 0, cascade_delete => 0 },
687	);
688
689	=head2 return_claims	674	=head2 return_claims
690		675
691	Type: has_many	676	Type: has_many
Lines 747-754 __PACKAGE__->has_many( Link Here
747	);	732	);
748		733
749		734
750	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-27 10:38:13	735	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
751	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IpI7wRweeZCbCeU1LhZbRQ	736	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0gYj48OTmEd79BoFTb2EiQ
752		737
753	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	738	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
754		739

Lines 197-250 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Itemtype.pm (-26 / +11 lines)
197	{ cascade_copy => 0, cascade_delete => 0 },	197	{ cascade_copy => 0, cascade_delete => 0 },
198	);	198	);
199		199
200	=head2 itemtypes_branches	200	=head2 holds
201
202	Type: has_many
203
204	Related object: L<Koha::Schema::Result::ItemtypesBranch>
205
206	=cut
207
208	__PACKAGE__->has_many(
209	"itemtypes_branches",
210	"Koha::Schema::Result::ItemtypesBranch",
211	{ "foreign.itemtype" => "self.itemtype" },
212	{ cascade_copy => 0, cascade_delete => 0 },
213	);
214
215	=head2 old_reserves
216		201
217	Type: has_many	202	Type: has_many
218		203
219	Related object: L<Koha::Schema::Result::OldReserve>	204	Related object: L<Koha::Schema::Result::Hold>
220		205
221	=cut	206	=cut
222		207
223	__PACKAGE__->has_many(	208	__PACKAGE__->has_many(
224	"old_reserves",	209	"holds",
225	"Koha::Schema::Result::OldReserve",	210	"Koha::Schema::Result::Hold",
226	{ "foreign.itemtype" => "self.itemtype" },	211	{ "foreign.item_type" => "self.itemtype" },
227	{ cascade_copy => 0, cascade_delete => 0 },	212	{ cascade_copy => 0, cascade_delete => 0 },
228	);	213	);
229		214
230	=head2 reserves	215	=head2 itemtypes_branches
231		216
232	Type: has_many	217	Type: has_many
233		218
234	Related object: L<Koha::Schema::Result::Reserve>	219	Related object: L<Koha::Schema::Result::ItemtypesBranch>
235		220
236	=cut	221	=cut
237		222
238	__PACKAGE__->has_many(	223	__PACKAGE__->has_many(
239	"reserves",	224	"itemtypes_branches",
240	"Koha::Schema::Result::Reserve",	225	"Koha::Schema::Result::ItemtypesBranch",
241	{ "foreign.itemtype" => "self.itemtype" },	226	{ "foreign.itemtype" => "self.itemtype" },
242	{ cascade_copy => 0, cascade_delete => 0 },	227	{ cascade_copy => 0, cascade_delete => 0 },
243	);	228	);
244		229
245		230
246	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-09 17:13:18	231	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:03
247	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7ojvTzsDvdHPAJMwJrAZ7A	232	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SK+5YpGrmEVIio1N0y1Ixw
248		233
249	__PACKAGE__->add_columns(	234	__PACKAGE__->add_columns(
250	'+rentalcharge_hourly_calendar' => { is_boolean => 1 },	235	'+rentalcharge_hourly_calendar' => { is_boolean => 1 },

Lines 127-140 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/ClubHoldsToPatronHold.pm (-5 / +5 lines)
127		127
128	Type: belongs_to	128	Type: belongs_to
129		129
130	Related object: L<Koha::Schema::Result::Reserve>	130	Related object: L<Koha::Schema::Result::Hold>
131		131
132	=cut	132	=cut
133		133
134	__PACKAGE__->belongs_to(	134	__PACKAGE__->belongs_to(
135	"hold",	135	"hold",
136	"Koha::Schema::Result::Reserve",	136	"Koha::Schema::Result::Hold",
137	{ reserve_id => "hold_id" },	137	{ id => "hold_id" },
138	{	138	{
139	is_deferrable => 1,	139	is_deferrable => 1,
140	join_type => "LEFT",	140	join_type => "LEFT",
Lines 159-166 __PACKAGE__->belongs_to( Link Here
159	);	159	);
160		160
161		161
162	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47	162	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-19 13:02:43
163	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/T626DfqUi7SnXOyieUzYw	163	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5z4rQioemKHFmPWtIw+HSw
164		164
165	sub koha_objects_class {	165	sub koha_objects_class {
166	'Koha::Club::Hold::PatronHolds';	166	'Koha::Club::Hold::PatronHolds';

Lines 6-12 package Koha::Schema::Result::OldReserve; Link Here

(-)a/Koha/Schema/Result/OldReserve.pm (-126 / +17 lines)
6		6
7	=head1 NAME	7	=head1 NAME
8		8
9	Koha::Schema::Result::OldReserve	9	Koha::Schema::Result::OldReserve - VIEW
10		10
11	=cut	11	=cut
12		12
Lines 14-38 use strict; Link Here
14	use warnings;	14	use warnings;
15		15
16	use base 'DBIx::Class::Core';	16	use base 'DBIx::Class::Core';
		17	__PACKAGE__->table_class("DBIx::Class::ResultSource::View");
17		18
18	=head1 TABLE: C<old_reserves>	19	=head1 TABLE: C<old_reserves>
19		20
20	=cut	21	=cut
21		22
22	__PACKAGE__->table("old_reserves");	23	__PACKAGE__->table("old_reserves");
		24	__PACKAGE__->result_source_instance->view_definition("select `dbic`.`holds`.`id` AS `reserve_id`,`dbic`.`holds`.`patron_id` AS `borrowernumber`,`dbic`.`holds`.`placing_date` AS `reservedate`,`dbic`.`holds`.`biblio_id` AS `biblionumber`,`dbic`.`holds`.`pickup_library_id` AS `branchcode`,(case when (`dbic`.`holds`.`status` = 'cancelled') then `dbic`.`holds`.`completion_date` else NULL end) AS `cancellationdate`,`dbic`.`holds`.`notes` AS `reservenotes`,`dbic`.`holds`.`priority` AS `priority`,(case when (`dbic`.`holds`.`status` = 'fulfilled') then 'F' else NULL end) AS `found`,`dbic`.`holds`.`timestamp` AS `timestamp`,`dbic`.`holds`.`item_id` AS `itemnumber`,`dbic`.`holds`.`waiting_date` AS `waitingdate`,`dbic`.`holds`.`expiration_date` AS `expirationdate`,`dbic`.`holds`.`lowest_priority` AS `lowestPriority`,`dbic`.`holds`.`suspended` AS `suspend`,`dbic`.`holds`.`suspended_until_date` AS `suspend_until`,`dbic`.`holds`.`item_type` AS `itemtype`,`dbic`.`holds`.`item_level` AS `item_level_hold` from `dbic`.`holds` where (`dbic`.`holds`.`completed` = 1)");
23		25
24	=head1 ACCESSORS	26	=head1 ACCESSORS
25		27
26	=head2 reserve_id	28	=head2 reserve_id
27		29
28	data_type: 'integer'	30	data_type: 'integer'
		31	default_value: 0
29	is_nullable: 0	32	is_nullable: 0
30		33
31	=head2 borrowernumber	34	=head2 borrowernumber
32		35
33	data_type: 'integer'	36	data_type: 'integer'
34	is_foreign_key: 1	37	default_value: 0
35	is_nullable: 1	38	is_nullable: 0
36		39
37	=head2 reservedate	40	=head2 reservedate
38		41
Lines 43-50 __PACKAGE__->table("old_reserves"); Link Here
43	=head2 biblionumber	46	=head2 biblionumber
44		47
45	data_type: 'integer'	48	data_type: 'integer'
46	is_foreign_key: 1	49	default_value: 0
47	is_nullable: 1	50	is_nullable: 0
48		51
49	=head2 branchcode	52	=head2 branchcode
50		53
Lines 52-69 __PACKAGE__->table("old_reserves"); Link Here
52	is_nullable: 1	55	is_nullable: 1
53	size: 10	56	size: 10
54		57
55	=head2 notificationdate
56
57	data_type: 'date'
58	datetime_undef_if_invalid: 1
59	is_nullable: 1
60
61	=head2 reminderdate
62
63	data_type: 'date'
64	datetime_undef_if_invalid: 1
65	is_nullable: 1
66
67	=head2 cancellationdate	58	=head2 cancellationdate
68		59
69	data_type: 'date'	60	data_type: 'date'
Lines 91-103 __PACKAGE__->table("old_reserves"); Link Here
91		82
92	data_type: 'timestamp'	83	data_type: 'timestamp'
93	datetime_undef_if_invalid: 1	84	datetime_undef_if_invalid: 1
94	default_value: current_timestamp	85	default_value: '0000-00-00 00:00:00'
95	is_nullable: 0	86	is_nullable: 0
96		87
97	=head2 itemnumber	88	=head2 itemnumber
98		89
99	data_type: 'integer'	90	data_type: 'integer'
100	is_foreign_key: 1
101	is_nullable: 1	91	is_nullable: 1
102		92
103	=head2 waitingdate	93	=head2 waitingdate
Lines 134-140 __PACKAGE__->table("old_reserves"); Link Here
134	=head2 itemtype	124	=head2 itemtype
135		125
136	data_type: 'varchar'	126	data_type: 'varchar'
137	is_foreign_key: 1
138	is_nullable: 1	127	is_nullable: 1
139	size: 10	128	size: 10
140		129
Lines 148-166 __PACKAGE__->table("old_reserves"); Link Here
148		137
149	__PACKAGE__->add_columns(	138	__PACKAGE__->add_columns(
150	"reserve_id",	139	"reserve_id",
151	{ data_type => "integer", is_nullable => 0 },	140	{ data_type => "integer", default_value => 0, is_nullable => 0 },
152	"borrowernumber",	141	"borrowernumber",
153	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	142	{ data_type => "integer", default_value => 0, is_nullable => 0 },
154	"reservedate",	143	"reservedate",
155	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	144	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
156	"biblionumber",	145	"biblionumber",
157	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	146	{ data_type => "integer", default_value => 0, is_nullable => 0 },
158	"branchcode",	147	"branchcode",
159	{ data_type => "varchar", is_nullable => 1, size => 10 },	148	{ data_type => "varchar", is_nullable => 1, size => 10 },
160	"notificationdate",
161	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
162	"reminderdate",
163	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
164	"cancellationdate",	149	"cancellationdate",
165	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	150	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
166	"reservenotes",	151	"reservenotes",
Lines 173-183 __PACKAGE__->add_columns( Link Here
173	{	158	{
174	data_type => "timestamp",	159	data_type => "timestamp",
175	datetime_undef_if_invalid => 1,	160	datetime_undef_if_invalid => 1,
176	default_value => \"current_timestamp",	161	default_value => "0000-00-00 00:00:00",
177	is_nullable => 0,	162	is_nullable => 0,
178	},	163	},
179	"itemnumber",	164	"itemnumber",
180	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	165	{ data_type => "integer", is_nullable => 1 },
181	"waitingdate",	166	"waitingdate",
182	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	167	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
183	"expirationdate",	168	"expirationdate",
Lines 198-305 __PACKAGE__->add_columns( Link Here
198	is_nullable => 1,	183	is_nullable => 1,
199	},	184	},
200	"itemtype",	185	"itemtype",
201	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },	186	{ data_type => "varchar", is_nullable => 1, size => 10 },
202	"item_level_hold",	187	"item_level_hold",
203	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	188	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
204	);	189	);
205		190
206	=head1 PRIMARY KEY
207
208	=over 4
209
210	=item * L</reserve_id>
211
212	=back
213
214	=cut
215
216	__PACKAGE__->set_primary_key("reserve_id");
217
218	=head1 RELATIONS
219
220	=head2 biblionumber
221
222	Type: belongs_to
223
224	Related object: L<Koha::Schema::Result::Biblio>
225
226	=cut
227
228	__PACKAGE__->belongs_to(
229	"biblionumber",
230	"Koha::Schema::Result::Biblio",
231	{ biblionumber => "biblionumber" },
232	{
233	is_deferrable => 1,
234	join_type => "LEFT",
235	on_delete => "SET NULL",
236	on_update => "SET NULL",
237	},
238	);
239
240	=head2 borrowernumber
241
242	Type: belongs_to
243
244	Related object: L<Koha::Schema::Result::Borrower>
245
246	=cut
247
248	__PACKAGE__->belongs_to(
249	"borrowernumber",
250	"Koha::Schema::Result::Borrower",
251	{ borrowernumber => "borrowernumber" },
252	{
253	is_deferrable => 1,
254	join_type => "LEFT",
255	on_delete => "SET NULL",
256	on_update => "SET NULL",
257	},
258	);
259
260	=head2 itemnumber
261
262	Type: belongs_to
263
264	Related object: L<Koha::Schema::Result::Item>
265
266	=cut
267
268	__PACKAGE__->belongs_to(
269	"itemnumber",
270	"Koha::Schema::Result::Item",
271	{ itemnumber => "itemnumber" },
272	{
273	is_deferrable => 1,
274	join_type => "LEFT",
275	on_delete => "SET NULL",
276	on_update => "SET NULL",
277	},
278	);
279
280	=head2 itemtype
281
282	Type: belongs_to
283
284	Related object: L<Koha::Schema::Result::Itemtype>
285
286	=cut
287
288	__PACKAGE__->belongs_to(
289	"itemtype",
290	"Koha::Schema::Result::Itemtype",
291	{ itemtype => "itemtype" },
292	{
293	is_deferrable => 1,
294	join_type => "LEFT",
295	on_delete => "SET NULL",
296	on_update => "SET NULL",
297	},
298	);
299
300		191
301	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15	192	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:04
302	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4vMUC/1kSr3vgQ7n0Pmuug	193	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j84bBLVB23oDE0csBcI8+A
303		194
304	__PACKAGE__->add_columns(	195	__PACKAGE__->add_columns(
305	'+item_level_hold' => { is_boolean => 1 },	196	'+item_level_hold' => { is_boolean => 1 },

Lines 6-12 package Koha::Schema::Result::Reserve; Link Here

(-)a/Koha/Schema/Result/Reserve.pm (-190 / +16 lines)
6		6
7	=head1 NAME	7	=head1 NAME
8		8
9	Koha::Schema::Result::Reserve	9	Koha::Schema::Result::Reserve - VIEW
10		10
11	=cut	11	=cut
12		12
Lines 14-39 use strict; Link Here
14	use warnings;	14	use warnings;
15		15
16	use base 'DBIx::Class::Core';	16	use base 'DBIx::Class::Core';
		17	__PACKAGE__->table_class("DBIx::Class::ResultSource::View");
17		18
18	=head1 TABLE: C<reserves>	19	=head1 TABLE: C<reserves>
19		20
20	=cut	21	=cut
21		22
22	__PACKAGE__->table("reserves");	23	__PACKAGE__->table("reserves");
		24	__PACKAGE__->result_source_instance->view_definition("select `dbic`.`holds`.`id` AS `reserve_id`,`dbic`.`holds`.`patron_id` AS `borrowernumber`,`dbic`.`holds`.`placing_date` AS `reservedate`,`dbic`.`holds`.`biblio_id` AS `biblionumber`,`dbic`.`holds`.`pickup_library_id` AS `branchcode`,NULL AS `cancellationdate`,`dbic`.`holds`.`notes` AS `reservenotes`,`dbic`.`holds`.`priority` AS `priority`,(case when (`dbic`.`holds`.`status` = 'waiting') then 'W' when (`dbic`.`holds`.`status` = 'in_transit') then 'T' else NULL end) AS `found`,`dbic`.`holds`.`timestamp` AS `timestamp`,`dbic`.`holds`.`item_id` AS `itemnumber`,`dbic`.`holds`.`waiting_date` AS `waitingdate`,`dbic`.`holds`.`expiration_date` AS `expirationdate`,`dbic`.`holds`.`lowest_priority` AS `lowestPriority`,`dbic`.`holds`.`suspended` AS `suspend`,`dbic`.`holds`.`suspended_until_date` AS `suspend_until`,`dbic`.`holds`.`item_type` AS `itemtype`,`dbic`.`holds`.`item_level` AS `item_level_hold` from `dbic`.`holds` where (`dbic`.`holds`.`completed` = 0)");
23		25
24	=head1 ACCESSORS	26	=head1 ACCESSORS
25		27
26	=head2 reserve_id	28	=head2 reserve_id
27		29
28	data_type: 'integer'	30	data_type: 'integer'
29	is_auto_increment: 1	31	default_value: 0
30	is_nullable: 0	32	is_nullable: 0
31		33
32	=head2 borrowernumber	34	=head2 borrowernumber
33		35
34	data_type: 'integer'	36	data_type: 'integer'
35	default_value: 0	37	default_value: 0
36	is_foreign_key: 1
37	is_nullable: 0	38	is_nullable: 0
38		39
39	=head2 reservedate	40	=head2 reservedate
Lines 46-77 __PACKAGE__->table("reserves"); Link Here
46		47
47	data_type: 'integer'	48	data_type: 'integer'
48	default_value: 0	49	default_value: 0
49	is_foreign_key: 1
50	is_nullable: 0	50	is_nullable: 0
51		51
52	=head2 branchcode	52	=head2 branchcode
53		53
54	data_type: 'varchar'	54	data_type: 'varchar'
55	is_foreign_key: 1
56	is_nullable: 1	55	is_nullable: 1
57	size: 10	56	size: 10
58		57
59	=head2 notificationdate
60
61	data_type: 'date'
62	datetime_undef_if_invalid: 1
63	is_nullable: 1
64
65	=head2 reminderdate
66
67	data_type: 'date'
68	datetime_undef_if_invalid: 1
69	is_nullable: 1
70
71	=head2 cancellationdate	58	=head2 cancellationdate
72		59
73	data_type: 'date'	60	data_type: 'binary'
74	datetime_undef_if_invalid: 1
75	is_nullable: 1	61	is_nullable: 1
76		62
77	=head2 reservenotes	63	=head2 reservenotes
Lines 95-107 __PACKAGE__->table("reserves"); Link Here
95		81
96	data_type: 'timestamp'	82	data_type: 'timestamp'
97	datetime_undef_if_invalid: 1	83	datetime_undef_if_invalid: 1
98	default_value: current_timestamp	84	default_value: '0000-00-00 00:00:00'
99	is_nullable: 0	85	is_nullable: 0
100		86
101	=head2 itemnumber	87	=head2 itemnumber
102		88
103	data_type: 'integer'	89	data_type: 'integer'
104	is_foreign_key: 1
105	is_nullable: 1	90	is_nullable: 1
106		91
107	=head2 waitingdate	92	=head2 waitingdate
Lines 138-144 __PACKAGE__->table("reserves"); Link Here
138	=head2 itemtype	123	=head2 itemtype
139		124
140	data_type: 'varchar'	125	data_type: 'varchar'
141	is_foreign_key: 1
142	is_nullable: 1	126	is_nullable: 1
143	size: 10	127	size: 10
144		128
Lines 152-182 __PACKAGE__->table("reserves"); Link Here
152		136
153	__PACKAGE__->add_columns(	137	__PACKAGE__->add_columns(
154	"reserve_id",	138	"reserve_id",
155	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },	139	{ data_type => "integer", default_value => 0, is_nullable => 0 },
156	"borrowernumber",	140	"borrowernumber",
157	{	141	{ data_type => "integer", default_value => 0, is_nullable => 0 },
158	data_type => "integer",
159	default_value => 0,
160	is_foreign_key => 1,
161	is_nullable => 0,
162	},
163	"reservedate",	142	"reservedate",
164	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	143	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
165	"biblionumber",	144	"biblionumber",
166	{	145	{ data_type => "integer", default_value => 0, is_nullable => 0 },
167	data_type => "integer",
168	default_value => 0,
169	is_foreign_key => 1,
170	is_nullable => 0,
171	},
172	"branchcode",	146	"branchcode",
173	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },	147	{ data_type => "varchar", is_nullable => 1, size => 10 },
174	"notificationdate",
175	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
176	"reminderdate",
177	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
178	"cancellationdate",	148	"cancellationdate",
179	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	149	{ data_type => "binary", is_nullable => 1 },
180	"reservenotes",	150	"reservenotes",
181	{ data_type => "longtext", is_nullable => 1 },	151	{ data_type => "longtext", is_nullable => 1 },
182	"priority",	152	"priority",
Lines 187-197 __PACKAGE__->add_columns( Link Here
187	{	157	{
188	data_type => "timestamp",	158	data_type => "timestamp",
189	datetime_undef_if_invalid => 1,	159	datetime_undef_if_invalid => 1,
190	default_value => \"current_timestamp",	160	default_value => "0000-00-00 00:00:00",
191	is_nullable => 0,	161	is_nullable => 0,
192	},	162	},
193	"itemnumber",	163	"itemnumber",
194	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	164	{ data_type => "integer", is_nullable => 1 },
195	"waitingdate",	165	"waitingdate",
196	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	166	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
197	"expirationdate",	167	"expirationdate",
Lines 212-368 __PACKAGE__->add_columns( Link Here
212	is_nullable => 1,	182	is_nullable => 1,
213	},	183	},
214	"itemtype",	184	"itemtype",
215	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },	185	{ data_type => "varchar", is_nullable => 1, size => 10 },
216	"item_level_hold",	186	"item_level_hold",
217	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	187	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
218	);	188	);
219		189
220	=head1 PRIMARY KEY
221
222	=over 4
223
224	=item * L</reserve_id>
225
226	=back
227
228	=cut
229
230	__PACKAGE__->set_primary_key("reserve_id");
231
232	=head1 RELATIONS
233
234	=head2 biblionumber
235
236	Type: belongs_to
237
238	Related object: L<Koha::Schema::Result::Biblio>
239
240	=cut
241
242	__PACKAGE__->belongs_to(
243	"biblionumber",
244	"Koha::Schema::Result::Biblio",
245	{ biblionumber => "biblionumber" },
246	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
247	);
248
249	=head2 borrowernumber
250
251	Type: belongs_to
252
253	Related object: L<Koha::Schema::Result::Borrower>
254
255	=cut
256
257	__PACKAGE__->belongs_to(
258	"borrowernumber",
259	"Koha::Schema::Result::Borrower",
260	{ borrowernumber => "borrowernumber" },
261	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
262	);
263
264	=head2 branchcode
265
266	Type: belongs_to
267
268	Related object: L<Koha::Schema::Result::Branch>
269
270	=cut
271
272	__PACKAGE__->belongs_to(
273	"branchcode",
274	"Koha::Schema::Result::Branch",
275	{ branchcode => "branchcode" },
276	{
277	is_deferrable => 1,
278	join_type => "LEFT",
279	on_delete => "CASCADE",
280	on_update => "CASCADE",
281	},
282	);
283
284	=head2 club_holds_to_patron_holds
285
286	Type: has_many
287
288	Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>
289
290	=cut
291
292	__PACKAGE__->has_many(
293	"club_holds_to_patron_holds",
294	"Koha::Schema::Result::ClubHoldsToPatronHold",
295	{ "foreign.hold_id" => "self.reserve_id" },
296	{ cascade_copy => 0, cascade_delete => 0 },
297	);
298
299	=head2 itemnumber
300
301	Type: belongs_to
302
303	Related object: L<Koha::Schema::Result::Item>
304
305	=cut
306		190
307	__PACKAGE__->belongs_to(	191	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 19:21:04
308	"itemnumber",	192	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5rN+zc7MxGkvUsCfihsq2Q
309	"Koha::Schema::Result::Item",
310	{ itemnumber => "itemnumber" },
311	{
312	is_deferrable => 1,
313	join_type => "LEFT",
314	on_delete => "CASCADE",
315	on_update => "CASCADE",
316	},
317	);
318
319	=head2 itemtype
320
321	Type: belongs_to
322
323	Related object: L<Koha::Schema::Result::Itemtype>
324
325	=cut
326
327	__PACKAGE__->belongs_to(
328	"itemtype",
329	"Koha::Schema::Result::Itemtype",
330	{ itemtype => "itemtype" },
331	{
332	is_deferrable => 1,
333	join_type => "LEFT",
334	on_delete => "CASCADE",
335	on_update => "CASCADE",
336	},
337	);
338
339
340	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15
341	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VH7h5kYo9WhlGobXb3N3Jg
342
343	__PACKAGE__->belongs_to(
344	"item",
345	"Koha::Schema::Result::Item",
346	{ itemnumber => "itemnumber" },
347	{
348	is_deferrable => 1,
349	join_type => "LEFT",
350	on_delete => "CASCADE",
351	on_update => "CASCADE",
352	},
353	);
354
355	__PACKAGE__->belongs_to(
356	"biblio",
357	"Koha::Schema::Result::Biblio",
358	{ biblionumber => "biblionumber" },
359	{
360	is_deferrable => 1,
361	join_type => "LEFT",
362	on_delete => "CASCADE",
363	on_update => "CASCADE",
364	},
365	);
366		193
367	__PACKAGE__->add_columns(	194	__PACKAGE__->add_columns(
368	'+item_level_hold' => { is_boolean => 1 },	195	'+item_level_hold' => { is_boolean => 1 },
369	-