Attachment #162470 for bug #35906

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




=head2 bookable

  data_type: 'tinyint'
  is_nullable: 1
  is_nullable: 0

nullable boolean value defining whether this this item is available for bookings or not

=head2 dateaccessioned


  "barcode",
  { data_type => "varchar", is_nullable => 1, size => 20 },
  "bookable",
  { data_type => "tinyint", is_nullable => 1 },
  "dateaccessioned",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "booksellerid",

__PACKAGE__->set_primary_key("itemnumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zX0VESQ43dK9B93+jjj8Lg

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




=head2 bookable

  data_type: 'tinyint'
  is_nullable: 1
  is_nullable: 0

nullable boolean value defining whether this this item is available for bookings or not

=head2 dateaccessioned


  "barcode",
  { data_type => "varchar", is_nullable => 1, size => 20 },
  "bookable",
  { data_type => "tinyint", is_nullable => 1 },
  "dateaccessioned",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "booksellerid",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j8/IH2fOro69Owo92OkATA

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


Lines 175-180 Group this item type with others with the same value on OPAC search options Link Here

(-)a/Koha/Schema/Result/Itemtype.pm (-3 / +12 lines)
175		175
176	If automatic checkin is enabled for items of this type	176	If automatic checkin is enabled for items of this type
177		177
		178	=head2 bookable
		179
		180	data_type: 'tinyint'
		181	default_value: 0
		182	is_nullable: 0
		183
		184	Activate bookable feature for items related to this item type
		185
178	=cut	186	=cut
179		187
180	__PACKAGE__->add_columns(	188	__PACKAGE__->add_columns(
Lines 221-226 __PACKAGE__->add_columns( Link Here
221	{ data_type => "varchar", is_nullable => 1, size => 80 },	229	{ data_type => "varchar", is_nullable => 1, size => 80 },
222	"automatic_checkin",	230	"automatic_checkin",
223	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	231	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
		232	"bookable",
		233	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
224	);	234	);
225		235
226	=head1 PRIMARY KEY	236	=head1 PRIMARY KEY
Lines 333-340 __PACKAGE__->has_many( Link Here
333	);	343	);
334		344
335		345
336	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-09-22 11:31:25	346	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06
337	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SoRKIMEqXE2+RkGq6zBejA	347	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sgu5QbKVwomifJp1T8OZzA
338		348
339	__PACKAGE__->add_columns(	349	__PACKAGE__->add_columns(
340	'+automatic_checkin' => { is_boolean => 1 },	350	'+automatic_checkin' => { is_boolean => 1 },
341	-

Return to bug 35906

Lines 58-67 item barcode (MARC21 952$p) Link Here

(-)a/Koha/Schema/Result/Deleteditem.pm (-6 / +5 lines)
58	=head2 bookable	58	=head2 bookable
59		59
60	data_type: 'tinyint'	60	data_type: 'tinyint'
61	default_value: 0	61	is_nullable: 1
62	is_nullable: 0
63		62
64	boolean value defining whether this this item is available for bookings or not	63	nullable boolean value defining whether this this item is available for bookings or not
65		64
66	=head2 dateaccessioned	65	=head2 dateaccessioned
67		66
Lines 398-404 __PACKAGE__->add_columns( Link Here
398	"barcode",	397	"barcode",
399	{ data_type => "varchar", is_nullable => 1, size => 20 },	398	{ data_type => "varchar", is_nullable => 1, size => 20 },
400	"bookable",	399	"bookable",
401	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	400	{ data_type => "tinyint", is_nullable => 1 },
402	"dateaccessioned",	401	"dateaccessioned",
403	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	402	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
404	"booksellerid",	403	"booksellerid",
Lines 523-530 __PACKAGE__->add_columns( Link Here
523	__PACKAGE__->set_primary_key("itemnumber");	522	__PACKAGE__->set_primary_key("itemnumber");
524		523
525		524
526	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-02 11:06:29	525	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06
527	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Afgr1jl6aeSy/rS9RJGq2g	526	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zX0VESQ43dK9B93+jjj8Lg
528		527
529	__PACKAGE__->add_columns(	528	__PACKAGE__->add_columns(
530	'+bookable' => { is_boolean => 1 },	529	'+bookable' => { is_boolean => 1 },

Lines 60-69 item barcode (MARC21 952$p) Link Here

(-)a/Koha/Schema/Result/Item.pm (-6 / +5 lines)
60	=head2 bookable	60	=head2 bookable
61		61
62	data_type: 'tinyint'	62	data_type: 'tinyint'
63	default_value: 0	63	is_nullable: 1
64	is_nullable: 0
65		64
66	boolean value defining whether this this item is available for bookings or not	65	nullable boolean value defining whether this this item is available for bookings or not
67		66
68	=head2 dateaccessioned	67	=head2 dateaccessioned
69		68
Lines 412-418 __PACKAGE__->add_columns( Link Here
412	"barcode",	411	"barcode",
413	{ data_type => "varchar", is_nullable => 1, size => 20 },	412	{ data_type => "varchar", is_nullable => 1, size => 20 },
414	"bookable",	413	"bookable",
415	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	414	{ data_type => "tinyint", is_nullable => 1 },
416	"dateaccessioned",	415	"dateaccessioned",
417	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	416	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
418	"booksellerid",	417	"booksellerid",
Lines 983-990 __PACKAGE__->might_have( Link Here
983	);	982	);
984		983
985		984
986	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06	985	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06
987	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0jargxEw3HZOK57+ijsMHA	986	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j8/IH2fOro69Owo92OkATA
988		987
989	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	988	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
990		989