Attachment #156778 for bug #6796

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




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

=head2 library_hours

Type: has_many

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

=cut

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

=head2 library_smtp_server

Type: might_have

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-09 04:50:00
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hLjXBe4fcWRqiubm5JXcfA

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




use utf8;
package Koha::Schema::Result::LibraryHour;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::LibraryHour

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<library_hours>

=cut

__PACKAGE__->table("library_hours");

=head1 ACCESSORS

=head2 library_id

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

=head2 day

  data_type: 'enum'
  default_value: 0
  extra: {list => [0,1,2,3,4,5,6]}
  is_nullable: 0

=head2 open_time

  data_type: 'time'
  is_nullable: 1

=head2 close_time

  data_type: 'time'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "library_id",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
  "day",
  {
    data_type => "enum",
    default_value => 0,
    extra => { list => [0 .. 6] },
    is_nullable => 0,
  },
  "open_time",
  { data_type => "time", is_nullable => 1 },
  "close_time",
  { data_type => "time", is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</library_id>

=item * L</day>

=back

=cut

__PACKAGE__->set_primary_key("library_id", "day");

=head1 RELATIONS

=head2 library

Type: belongs_to

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

=cut

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


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-09 04:50:00
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+HaRcwTHecetQRA+fNytTw


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;

Return to bug 6796

Lines 767-772 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
767	{ cascade_copy => 0, cascade_delete => 0 },	767	{ cascade_copy => 0, cascade_delete => 0 },
768	);	768	);
769		769
		770	=head2 library_hours
		771
		772	Type: has_many
		773
		774	Related object: L<Koha::Schema::Result::LibraryHour>
		775
		776	=cut
		777
		778	__PACKAGE__->has_many(
		779	"library_hours",
		780	"Koha::Schema::Result::LibraryHour",
		781	{ "foreign.library_id" => "self.branchcode" },
		782	{ cascade_copy => 0, cascade_delete => 0 },
		783	);
		784
770	=head2 library_smtp_server	785	=head2 library_smtp_server
771		786
772	Type: might_have	787	Type: might_have
Lines 918-925 __PACKAGE__->has_many( Link Here
918	);	933	);
919		934
920		935
921	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-11-08 17:35:26	936	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-09 04:50:00
922	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QPqXuEigMeIBb9NKMSkrNw	937	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hLjXBe4fcWRqiubm5JXcfA
923		938
924	__PACKAGE__->add_columns(	939	__PACKAGE__->add_columns(
925	'+pickup_location' => { is_boolean => 1 },	940	'+pickup_location' => { is_boolean => 1 },

Line 0 Link Here

(-)a/Koha/Schema/Result/LibraryHour.pm (-1 / +105 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::LibraryHour;
		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::LibraryHour
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<library_hours>
		19
		20	=cut
		21
		22	__PACKAGE__->table("library_hours");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 library_id
		27
		28	data_type: 'varchar'
		29	is_foreign_key: 1
		30	is_nullable: 0
		31	size: 10
		32
		33	=head2 day
		34
		35	data_type: 'enum'
		36	default_value: 0
		37	extra: {list => [0,1,2,3,4,5,6]}
		38	is_nullable: 0
		39
		40	=head2 open_time
		41
		42	data_type: 'time'
		43	is_nullable: 1
		44
		45	=head2 close_time
		46
		47	data_type: 'time'
		48	is_nullable: 1
		49
		50	=cut
		51
		52	__PACKAGE__->add_columns(
		53	"library_id",
		54	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
		55	"day",
		56	{
		57	data_type => "enum",
		58	default_value => 0,
		59	extra => { list => [0 .. 6] },
		60	is_nullable => 0,
		61	},
		62	"open_time",
		63	{ data_type => "time", is_nullable => 1 },
		64	"close_time",
		65	{ data_type => "time", is_nullable => 1 },
66	);
67
68	=head1 PRIMARY KEY
69
70	=over 4
71
72	=item * L</library_id>
73
74	=item * L</day>
75
76	=back
77
78	=cut
79
80	__PACKAGE__->set_primary_key("library_id", "day");
81
82	=head1 RELATIONS
83
84	=head2 library
85
86	Type: belongs_to
87
88	Related object: L<Koha::Schema::Result::Branch>
89
90	=cut
91
92	__PACKAGE__->belongs_to(
93	"library",
94	"Koha::Schema::Result::Branch",
95	{ branchcode => "library_id" },
96	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
97	);
98
99
100	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-09 04:50:00
101	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+HaRcwTHecetQRA+fNytTw
102
103
104	# You can replace this text with custom code or comments, and it will be preserved on regeneration
105	1;