Attachment #103890 for bug #19532

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




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

=head2 recalls

Type: has_many

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

=cut

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

=head2 reserves

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 00:54:30
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DbUlMrhdgEUvLgSj6wIH+A


__PACKAGE__->has_one(




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

=head2 recalls

Type: has_many

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

=cut

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

=head2 reserves

Type: has_many

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


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 00:54:30
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lecZ0Xfi1oulQ+2/jkKMVw

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




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

=head2 recalls

Type: has_many

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

=cut

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

=head2 repeatable_holidays

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 00:54:30
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kh4GrH/Wv2e6FosOF25fQw

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




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

=head2 recalls

Type: has_many

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

=cut

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

=head2 reserves

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 02:45:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YCgQDdMWwB7iAiGdk+MTAQ

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





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

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

=head1 NAME

Koha::Schema::Result::Recall

=cut

use strict;
use warnings;

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

=head1 TABLE: C<recalls>

=cut

__PACKAGE__->table("recalls");

=head1 ACCESSORS

=head2 recall_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 borrowernumber

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

=head2 recalldate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 biblionumber

  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 cancellationdate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 recallnotes

  data_type: 'mediumtext'
  is_nullable: 1

=head2 priority

  data_type: 'smallint'
  is_nullable: 1

=head2 status

  data_type: 'varchar'
  is_nullable: 1
  size: 1

=head2 timestamp

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

=head2 itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 waitingdate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 expirationdate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 old

  data_type: 'tinyint'
  is_nullable: 1

=head2 item_level_recall

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "recall_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "borrowernumber",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "recalldate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "biblionumber",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "branchcode",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
  "cancellationdate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "recallnotes",
  { data_type => "mediumtext", is_nullable => 1 },
  "priority",
  { data_type => "smallint", is_nullable => 1 },
  "status",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "timestamp",
  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 0,
  },
  "itemnumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "waitingdate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "expirationdate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "old",
  { data_type => "tinyint", is_nullable => 1 },
  "item_level_recall",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</recall_id>

=back

=cut

__PACKAGE__->set_primary_key("recall_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 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     => "CASCADE",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 02:45:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:37PqSXq0nhMZk9PN30nW4Q

__PACKAGE__->add_columns(
    '+old' => { is_boolean => 1 },
    '+item_level_recall' => { is_boolean => 1},
);

1;

Return to bug 19532

Lines 315-320 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
315	{ cascade_copy => 0, cascade_delete => 0 },	315	{ cascade_copy => 0, cascade_delete => 0 },
316	);	316	);
317		317
		318	=head2 recalls
		319
		320	Type: has_many
		321
		322	Related object: L<Koha::Schema::Result::Recall>
		323
		324	=cut
		325
		326	__PACKAGE__->has_many(
		327	"recalls",
		328	"Koha::Schema::Result::Recall",
		329	{ "foreign.biblionumber" => "self.biblionumber" },
		330	{ cascade_copy => 0, cascade_delete => 0 },
		331	);
		332
318	=head2 reserves	333	=head2 reserves
319		334
320	Type: has_many	335	Type: has_many
Lines 451-458 __PACKAGE__->has_many( Link Here
451	);	466	);
452		467
453		468
454	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51	469	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 00:54:30
455	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p2SIq565zPyE3ZUkSuXyBA	470	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DbUlMrhdgEUvLgSj6wIH+A
456		471
457		472
458	__PACKAGE__->has_one(	473	__PACKAGE__->has_one(

Lines 1357-1362 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +17 lines)
1357	{ cascade_copy => 0, cascade_delete => 0 },	1357	{ cascade_copy => 0, cascade_delete => 0 },
1358	);	1358	);
1359		1359
		1360	=head2 recalls
		1361
		1362	Type: has_many
		1363
		1364	Related object: L<Koha::Schema::Result::Recall>
		1365
		1366	=cut
		1367
		1368	__PACKAGE__->has_many(
		1369	"recalls",
		1370	"Koha::Schema::Result::Recall",
		1371	{ "foreign.borrowernumber" => "self.borrowernumber" },
		1372	{ cascade_copy => 0, cascade_delete => 0 },
		1373	);
		1374
1360	=head2 reserves	1375	=head2 reserves
1361		1376
1362	Type: has_many	1377	Type: has_many
Lines 1688-1695 Composing rels: L</aqorder_users> -> ordernumber Link Here
1688	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1703	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1689		1704
1690		1705
1691	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-01 09:42:50	1706	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 00:54:30
1692	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1G8678sy3UnvmJffzcU/Hg	1707	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lecZ0Xfi1oulQ+2/jkKMVw
1693		1708
1694	__PACKAGE__->add_columns(	1709	__PACKAGE__->add_columns(
1695	'+anonymized' => { is_boolean => 1 },	1710	'+anonymized' => { is_boolean => 1 },

Lines 653-658 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
653	{ cascade_copy => 0, cascade_delete => 0 },	653	{ cascade_copy => 0, cascade_delete => 0 },
654	);	654	);
655		655
		656	=head2 recalls
		657
		658	Type: has_many
		659
		660	Related object: L<Koha::Schema::Result::Recall>
		661
		662	=cut
		663
		664	__PACKAGE__->has_many(
		665	"recalls",
		666	"Koha::Schema::Result::Recall",
		667	{ "foreign.branchcode" => "self.branchcode" },
		668	{ cascade_copy => 0, cascade_delete => 0 },
		669	);
		670
656	=head2 repeatable_holidays	671	=head2 repeatable_holidays
657		672
658	Type: has_many	673	Type: has_many
Lines 759-766 __PACKAGE__->has_many( Link Here
759	);	774	);
760		775
761		776
762	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-01 09:42:50	777	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 00:54:30
763	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OK9rj4bv4KW5if0kLRDTSg	778	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kh4GrH/Wv2e6FosOF25fQw
764		779
765	__PACKAGE__->add_columns(	780	__PACKAGE__->add_columns(
766	'+pickup_location' => { is_boolean => 1 }	781	'+pickup_location' => { is_boolean => 1 }

Lines 671-676 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Item.pm (-2 / +17 lines)
671	{ cascade_copy => 0, cascade_delete => 0 },	671	{ cascade_copy => 0, cascade_delete => 0 },
672	);	672	);
673		673
		674	=head2 recalls
		675
		676	Type: has_many
		677
		678	Related object: L<Koha::Schema::Result::Recall>
		679
		680	=cut
		681
		682	__PACKAGE__->has_many(
		683	"recalls",
		684	"Koha::Schema::Result::Recall",
		685	{ "foreign.itemnumber" => "self.itemnumber" },
		686	{ cascade_copy => 0, cascade_delete => 0 },
		687	);
		688
674	=head2 reserves	689	=head2 reserves
675		690
676	Type: has_many	691	Type: has_many
Lines 747-754 __PACKAGE__->has_many( Link Here
747	);	762	);
748		763
749		764
750	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-27 10:38:13	765	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 02:45:15
751	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IpI7wRweeZCbCeU1LhZbRQ	766	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YCgQDdMWwB7iAiGdk+MTAQ
752		767
753	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	768	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
754		769

Line 0 Link Here

(-)a/Koha/Schema/Result/Recall.pm (-1 / +276 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::Recall;
		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::Recall
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<recalls>
		19
		20	=cut
		21
		22	__PACKAGE__->table("recalls");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 recall_id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 borrowernumber
		33
		34	data_type: 'integer'
		35	default_value: 0
		36	is_foreign_key: 1
		37	is_nullable: 0
		38
		39	=head2 recalldate
		40
		41	data_type: 'datetime'
		42	datetime_undef_if_invalid: 1
		43	is_nullable: 1
		44
		45	=head2 biblionumber
		46
		47	data_type: 'integer'
		48	default_value: 0
		49	is_foreign_key: 1
		50	is_nullable: 0
		51
		52	=head2 branchcode
		53
		54	data_type: 'varchar'
		55	is_foreign_key: 1
		56	is_nullable: 1
		57	size: 10
		58
		59	=head2 cancellationdate
		60
		61	data_type: 'datetime'
		62	datetime_undef_if_invalid: 1
		63	is_nullable: 1
		64
		65	=head2 recallnotes
66
67	data_type: 'mediumtext'
68	is_nullable: 1
69
70	=head2 priority
71
72	data_type: 'smallint'
73	is_nullable: 1
74
75	=head2 status
76
77	data_type: 'varchar'
78	is_nullable: 1
79	size: 1
80
81	=head2 timestamp
82
83	data_type: 'timestamp'
84	datetime_undef_if_invalid: 1
85	default_value: current_timestamp
86	is_nullable: 0
87
88	=head2 itemnumber
89
90	data_type: 'integer'
91	is_foreign_key: 1
92	is_nullable: 1
93
94	=head2 waitingdate
95
96	data_type: 'datetime'
97	datetime_undef_if_invalid: 1
98	is_nullable: 1
99
100	=head2 expirationdate
101
102	data_type: 'datetime'
103	datetime_undef_if_invalid: 1
104	is_nullable: 1
105
106	=head2 old
107
108	data_type: 'tinyint'
109	is_nullable: 1
110
111	=head2 item_level_recall
112
113	data_type: 'tinyint'
114	default_value: 0
115	is_nullable: 0
116
117	=cut
118
119	__PACKAGE__->add_columns(
120	"recall_id",
121	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
122	"borrowernumber",
123	{
124	data_type => "integer",
125	default_value => 0,
126	is_foreign_key => 1,
127	is_nullable => 0,
128	},
129	"recalldate",
130	{
131	data_type => "datetime",
132	datetime_undef_if_invalid => 1,
133	is_nullable => 1,
134	},
135	"biblionumber",
136	{
137	data_type => "integer",
138	default_value => 0,
139	is_foreign_key => 1,
140	is_nullable => 0,
141	},
142	"branchcode",
143	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
144	"cancellationdate",
145	{
146	data_type => "datetime",
147	datetime_undef_if_invalid => 1,
148	is_nullable => 1,
149	},
150	"recallnotes",
151	{ data_type => "mediumtext", is_nullable => 1 },
152	"priority",
153	{ data_type => "smallint", is_nullable => 1 },
154	"status",
155	{ data_type => "varchar", is_nullable => 1, size => 1 },
156	"timestamp",
157	{
158	data_type => "timestamp",
159	datetime_undef_if_invalid => 1,
160	default_value => \"current_timestamp",
161	is_nullable => 0,
162	},
163	"itemnumber",
164	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
165	"waitingdate",
166	{
167	data_type => "datetime",
168	datetime_undef_if_invalid => 1,
169	is_nullable => 1,
170	},
171	"expirationdate",
172	{
173	data_type => "datetime",
174	datetime_undef_if_invalid => 1,
175	is_nullable => 1,
176	},
177	"old",
178	{ data_type => "tinyint", is_nullable => 1 },
179	"item_level_recall",
180	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
181	);
182
183	=head1 PRIMARY KEY
184
185	=over 4
186
187	=item * L</recall_id>
188
189	=back
190
191	=cut
192
193	__PACKAGE__->set_primary_key("recall_id");
194
195	=head1 RELATIONS
196
197	=head2 biblionumber
198
199	Type: belongs_to
200
201	Related object: L<Koha::Schema::Result::Biblio>
202
203	=cut
204
205	__PACKAGE__->belongs_to(
206	"biblionumber",
207	"Koha::Schema::Result::Biblio",
208	{ biblionumber => "biblionumber" },
209	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
210	);
211
212	=head2 borrowernumber
213
214	Type: belongs_to
215
216	Related object: L<Koha::Schema::Result::Borrower>
217
218	=cut
219
220	__PACKAGE__->belongs_to(
221	"borrowernumber",
222	"Koha::Schema::Result::Borrower",
223	{ borrowernumber => "borrowernumber" },
224	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
225	);
226
227	=head2 branchcode
228
229	Type: belongs_to
230
231	Related object: L<Koha::Schema::Result::Branch>
232
233	=cut
234
235	__PACKAGE__->belongs_to(
236	"branchcode",
237	"Koha::Schema::Result::Branch",
238	{ branchcode => "branchcode" },
239	{
240	is_deferrable => 1,
241	join_type => "LEFT",
242	on_delete => "CASCADE",
243	on_update => "CASCADE",
244	},
245	);
246
247	=head2 itemnumber
248
249	Type: belongs_to
250
251	Related object: L<Koha::Schema::Result::Item>
252
253	=cut
254
255	__PACKAGE__->belongs_to(
256	"itemnumber",
257	"Koha::Schema::Result::Item",
258	{ itemnumber => "itemnumber" },
259	{
260	is_deferrable => 1,
261	join_type => "LEFT",
262	on_delete => "CASCADE",
263	on_update => "CASCADE",
264	},
265	);
266
267
268	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-22 02:45:15
269	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:37PqSXq0nhMZk9PN30nW4Q
270
271	__PACKAGE__->add_columns(
272	'+old' => { is_boolean => 1 },
273	'+item_level_recall' => { is_boolean => 1},
274	);
275
276	1;